The following here : https://groups.google.com/d/msg/web2py/4zuGOSsYrQ4/DYHIoUsuj_wJ
Richard On Tue, Mar 19, 2013 at 4:39 PM, Richard Vézina <[email protected] > wrote: > One more issue... The representation in the visible referenced field get > cleared out when form has error... > > Stay tune!! > > Richard > > > On Tue, Mar 19, 2013 at 4:23 PM, Richard Vézina < > [email protected]> wrote: > >> Finally it there were still a issue with the above code in case length >> was greater then 0 but the typeahead field was alter before submit... Here >> a fix : >> >> def autocomplete_typeahead_widget(f, v, referenced_table, >> represent_field, id_field, **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("""jQuery(document).ready(function(){ >> var labels = [] >> var mapped = {} >> $(function() { >> $('#%(table_name)s_%(field_name)s_ac').typeahead( >> { minLength: 0, >> items: 10, >> source: function (query, process) { >> $.get('%(url)s', >> { q: query }, >> function (data) { >> $.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;} >> }) >> }); >> $('input#%(table_name)s_%(field_name)s_ac').blur( >> function(){ >> if($(this).val().length==0) >> {$('#%(table_name)s_%(field_name)s').val('')} >> else >> if($('#%(table_name)s_%(field_name)s').val()!=mapped[$(this).val()]) >> {$('#%(table_name)s_%(field_name)s').val('')} >> }); >> });""" % {'url': URL(c='test', >> f='autocomplete_typeahead_widget_json_feed.json', >> vars=dict(referenced_table=referenced_table, >> represent_field=represent_field, >> id_field=id_field)), >> 'table_name': table_name, >> 'field_name': field_name}) >> ) >> >> >> On Tue, Mar 19, 2013 at 2:39 PM, Richard Vézina < >> [email protected]> wrote: >> >>> Ok, here a more generic and a fix for the bootstrap hole (in red) : >>> >>> def autocomplete_typeahead_widget(f, v, referenced_table, >>> represent_field, id_field, **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("""jQuery(document).ready(function(){ >>> $(function() { >>> $('#%(table_name)s_%(field_name)s_ac').typeahead( >>> { minLength: 0, >>> items: 10, >>> source: function (query, process) { >>> $.get('%(url)s', >>> { 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;} >>> }) >>> }); >>> $("input#%(table_name)s_%(field_name)s_ac").blur(function(){ >>> if($(this).val().length==0) {$('#%(table_name)s_%(field_name)s').val('')} >>> }); >>> });""" % {'url': URL(c='test', >>> f='autocomplete_typeahead_widget_json_feed.json', >>> vars=dict(referenced_table=referenced_table, >>> represent_field=represent_field, >>> id_field=id_field)), >>> 'table_name': table_name, >>> 'field_name': field_name}) >>> ) >>> >>> def autocomplete_typeahead_widget_json_feed(): >>> referenced_table = request.vars.referenced_table >>> id_field = request.vars.id_field >>> represent_field = request.vars.represent_field >>> >>> rows=db(db[referenced_table][id_field]>0).select(db[referenced_table][id_field], >>> db[referenced_table][represent_field]) >>> options = [] >>> for i,row in enumerate(rows): >>> options.append({'option': row[represent_field], 'id': row.id}) >>> from gluon.contrib import simplejson >>> return simplejson.dumps({'options': options }) >>> >>> >>> db.table.field.widget = lambda field, value: >>> autocomplete_typeahead_widget(field, value, >>> referenced_table='referenced_table_name', >>> represent_field='represent_field_name', >>> id_field='id_field_name_of_the_referenced_table', _placeholder=T('Start >>> typing...')) >>> >>> >>> >>> On Tue, Mar 19, 2013 at 1:29 PM, Richard Vézina < >>> [email protected]> wrote: >>> >>>> I found an hole in typeahead updater... >>>> >>>> typeahead updater seems to be bit it by a trigger event only when there >>>> is something that have been selected... But if for instance someone select >>>> something the hidden field that get submitted is updated with the id if the >>>> record, but the hidden field is not updated if the field is empty (for some >>>> reason : USERS) after been filled once... So the id of the previous >>>> selected record stay there and the form submit correctly if there is no >>>> other validators that trigger up!! >>>> >>>> I googled a lot about this hole and typeahead, maybe I don't have the >>>> right keywords or the issue have not been identified since bootstrap >>>> typeahead as only recently get the updated to support key/value field. >>>> >>>> Richard >>>> >>>> >>>> On Mon, Mar 18, 2013 at 9:02 PM, Richard >>>> <[email protected]>wrote: >>>> >>>>> Hello, >>>>> >>>>> Wrote this and it may be handy for others in the meantime there is a >>>>> better integration of autocomplete bootstrap typeahead : >>>>> >>>>> # Widget function >>>>> 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}) >>>>> ) >>>>> >>>>> # Generating JSON function >>>>> def autocomplete_typeahead_widget_json_feed(): >>>>> rows=db(db.table.field>0).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 }) >>>>> >>>>> # Init of the widget >>>>> 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) >>>>> >>>>> Enjoy! >>>>> >>>>> Richard >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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 [email protected]. >>>>> 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
