Re: [web2py] Re: Override _autocomplete function
Hi Richard
It looks like you have got here faster than I did! Glad it worked out for
you. Just some comments:
Using the version I posted allows one to handle the AJAX callback directly
within the function embedding the widget. Each function can handle the
callback differently. One requirement though is that the widget needs to be
embedded at the function level rather than when the db tables are defined.
Ultimately, which is preferred depends on the use case requirement.
Embedding the widget within a function is done as you have suggested:
def somefunction():
if request.vars.ac_table_field:
rows = db(db.addr.zip.like(%s%% %
request.vars._ac_table_field)).select(limitby=(0,10))
return dict(options=[%d_%s, %s, %s %s % (r.id, r.streetnum,
r.streetname, r.city, r.zip) for r in rows])
kwargs = dict(...)
db.table.field.widget = lambda field, value: bs_typeahead(field, value,**
kwargs)
form = SQLFORM(table)
return dict(form=form)
**if there are no optional arguments, the widget could also be embedded
like so-which would give a marginal performance improvement:
db.table.field.widget = bs_typeahead
For Calvin that inadvertently send this answer only to me and not to the
mailing list.
Richard
On Mon, Mar 18, 2013 at 8:56 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Here what I come up with :
def autocomplete_typeahead_widget(f, v, **kwargs):
table_name = f._tablename
field_name = f.name
field_requires = f.requires
field_value = v
options = {'_data-provide':'typeahead', '_autocomplete': 'off'}
options.update(kwargs)
return CAT(
INPUT(_type=text, _class=string, _id=%s_%s_ac % (table_name,
field_name), **options),
INPUT(_type=hidden, _id=%s_%s % (table_name, field_name),
_name=field_name, _value=field_value, requires=field_requires),
SCRIPT($(function() {
$('#%(table_name)s_%(field_name)s_ac').typeahead(
{ source: function (query, process) {
$.get('%(url)s.json',
{ q: query },
function (data) {
labels = []
mapped = {}
$.each(data.options, function (i, item) {
mapped[item.option] = item.id
labels.push(item.option)
})
process(labels)
}
)
},
updater:function(item){
$('#%(table_name)s_%(field_name)s').val(mapped[item]); return item}
})
}); % {'url':URL(c='test',
f='autocomplete_typeahead_widget_json_feed'), 'table_name':table_name,
'field_name':field_name})
)
def autocomplete_typeahead_widget_json_feed():
rows=db(db.table.field0).select()
options = []
for i,row in enumerate(rows):
options.append({'option': row.field, 'id': row.id})
from gluon.contrib import simplejson
return simplejson.dumps({'options': options })
db.other_table.select_field.widget = autocomplete_typeahead_widget
or
db.other_table.select_field.widget = lambda field, value:
autocomplete_typeahead_widget(field, value, MORE_ARGS)
On Mon, Mar 18, 2013 at 10:10 AM, Richard Vézina
ml.richard.vez...@gmail.com wrote:
Hello Calvin,
This seems interesting. I was planning to work un this when I get time
but it looks that what you did is a good start!
I have a question, I am not sure how you was thinking to initialize the
widget on a select type field??
Should I do something like this in order to use your typeahead
autocomplete widget? :
db.table.field.widget = lambda field, value: bs_typeahead(field, value,
???kwargs)
??
Thanks
Richard
On Mon, Mar 11, 2013 at 4:45 AM, Calvin calvin@gmail.com wrote:
If of interest to anyone, eventually, I made my own autocomplete based
on Bootstrap Typeahead:
def bs_typeahead(f, v, **kwargs):
options = {'_data-provide':'textahead'}
options.update(kwargs)
return CAT(
INPUT(_type=text, _class=string, _id=%s_%s_ac % (f.
_tablename, f.name), **options),
INPUT(_type=hidden, _id=%s_%s % (f._tablename, f.name),_name
=f.name, _value=v, requires=f.requires),
SCRIPT($($('#%(table)s_%(field)s_ac').typeahead({minLength: 3,
source:function(query,process){console.log(query); return
$.get('%(url)s.json', {'_ac_%(table)s_%(field)s': query},
function(data){return process(data.options)})},
highlighter:function(item){return
item.split('_')[1]},updater:function(item){ var p=item.split('_');
$('#%(table)s_%(field)s').val(p[0]); return p[1]}})) % {'url':URL(),
'table':f._tablename, 'field':f.name})
)
and with the appropriate handler for request.vars['ac_%s_%s'
%(f._tablename, f.name)]
--
---
You received this message because you are subscribed to the Google
Groups web2py-users group.
To unsubscribe from this group and stop receiving emails
Re: [web2py] Re: Override _autocomplete function
Hello Calvin,
This seems interesting. I was planning to work un this when I get time but
it looks that what you did is a good start!
I have a question, I am not sure how you was thinking to initialize the
widget on a select type field??
Should I do something like this in order to use your typeahead autocomplete
widget? :
db.table.field.widget = lambda field, value: bs_typeahead(field, value,
???kwargs)
??
Thanks
Richard
On Mon, Mar 11, 2013 at 4:45 AM, Calvin calvin@gmail.com wrote:
If of interest to anyone, eventually, I made my own autocomplete based on
Bootstrap Typeahead:
def bs_typeahead(f, v, **kwargs):
options = {'_data-provide':'textahead'}
options.update(kwargs)
return CAT(
INPUT(_type=text, _class=string, _id=%s_%s_ac % (f.
_tablename, f.name), **options),
INPUT(_type=hidden, _id=%s_%s % (f._tablename, f.name), _name=
f.name, _value=v, requires=f.requires),
SCRIPT($($('#%(table)s_%(field)s_ac').typeahead({minLength: 3,
source:function(query,process){console.log(query); return
$.get('%(url)s.json', {'_ac_%(table)s_%(field)s': query},
function(data){return process(data.options)})},
highlighter:function(item){return
item.split('_')[1]},updater:function(item){ var p=item.split('_');
$('#%(table)s_%(field)s').val(p[0]); return p[1]}})) % {'url':URL(),
'table':f._tablename, 'field':f.name})
)
and with the appropriate handler for request.vars['ac_%s_%s'
%(f._tablename, f.name)]
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an
email to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Re: [web2py] Re: Override _autocomplete function
Here what I come up with :
def autocomplete_typeahead_widget(f, v, **kwargs):
table_name = f._tablename
field_name = f.name
field_requires = f.requires
field_value = v
options = {'_data-provide':'typeahead', '_autocomplete': 'off'}
options.update(kwargs)
return CAT(
INPUT(_type=text, _class=string, _id=%s_%s_ac % (table_name,
field_name), **options),
INPUT(_type=hidden, _id=%s_%s % (table_name, field_name),
_name=field_name, _value=field_value, requires=field_requires),
SCRIPT($(function() {
$('#%(table_name)s_%(field_name)s_ac').typeahead(
{ source: function (query, process) {
$.get('%(url)s.json',
{ q: query },
function (data) {
labels = []
mapped = {}
$.each(data.options, function (i, item) {
mapped[item.option] = item.id
labels.push(item.option)
})
process(labels)
}
)
},
updater:function(item){
$('#%(table_name)s_%(field_name)s').val(mapped[item]); return item}
})
}); % {'url':URL(c='test',
f='autocomplete_typeahead_widget_json_feed'), 'table_name':table_name,
'field_name':field_name})
)
def autocomplete_typeahead_widget_json_feed():
rows=db(db.table.field0).select()
options = []
for i,row in enumerate(rows):
options.append({'option': row.field, 'id': row.id})
from gluon.contrib import simplejson
return simplejson.dumps({'options': options })
db.other_table.select_field.widget = autocomplete_typeahead_widget
or
db.other_table.select_field.widget = lambda field, value:
autocomplete_typeahead_widget(field, value, MORE_ARGS)
On Mon, Mar 18, 2013 at 10:10 AM, Richard Vézina
ml.richard.vez...@gmail.com wrote:
Hello Calvin,
This seems interesting. I was planning to work un this when I get time but
it looks that what you did is a good start!
I have a question, I am not sure how you was thinking to initialize the
widget on a select type field??
Should I do something like this in order to use your typeahead
autocomplete widget? :
db.table.field.widget = lambda field, value: bs_typeahead(field, value,
???kwargs)
??
Thanks
Richard
On Mon, Mar 11, 2013 at 4:45 AM, Calvin calvin@gmail.com wrote:
If of interest to anyone, eventually, I made my own autocomplete based on
Bootstrap Typeahead:
def bs_typeahead(f, v, **kwargs):
options = {'_data-provide':'textahead'}
options.update(kwargs)
return CAT(
INPUT(_type=text, _class=string, _id=%s_%s_ac % (f.
_tablename, f.name), **options),
INPUT(_type=hidden, _id=%s_%s % (f._tablename, f.name), _name
=f.name, _value=v, requires=f.requires),
SCRIPT($($('#%(table)s_%(field)s_ac').typeahead({minLength: 3,
source:function(query,process){console.log(query); return
$.get('%(url)s.json', {'_ac_%(table)s_%(field)s': query},
function(data){return process(data.options)})},
highlighter:function(item){return
item.split('_')[1]},updater:function(item){ var p=item.split('_');
$('#%(table)s_%(field)s').val(p[0]); return p[1]}})) % {'url':URL(),
'table':f._tablename, 'field':f.name})
)
and with the appropriate handler for request.vars['ac_%s_%s'
%(f._tablename, f.name)]
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an
email to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
