Thanks Brian
El lunes, 23 de junio de 2014 03:56:32 UTC+2, Brian M escribió:
>
> Tomeu,
>
> At the moment I'm just letting datatables.net enhance a plain html table
> for me. One of these days I'll probably get around to giving it a json
> datasource but so far it hasn't been a priority for my usage.
>
> As a bonus, here's some of how to update the datatables.net display after
> using the edit dialog. (So just the edited record's row in the datatable
> gets updated rather than a full page refresh)
>
> In controller
> #after you'd done the necessary DB updates...
>
> #tell browser to close the jqueryui dialog
> response.js =XML( '$("#edit_dialog").dialog("close");')
>
> #prepare for display update
> edit_icon = IMG(_src=URL(c="static",f="images/page_white_edit.png"),
> _alt="Click
> to edit")
>
> #prep javascript code for datatables.net to update the existing row's
> display
> #basically just a json list of td values
> row_update = simplejson.dumps([updated_record.table.first_name,
> updated_record.table.last_name, updated_record.table2.name,
> str(A(edit_icon, _href=URL(r=request,f='edit_loader', args=[
> updated_record.table.record_id, mode]), _class="updateDialog")),
> updated_record.table.email, updated_record.table.someother_id])
>
> #using the tr#id method to update table is unreliable (the TR won't have
> an id if it was added dynamically
> #instead use the row index provided by datatables.net itself (we passed
> it in via ajax vars)
> #essentially fnUpdate(new td values, which row)
> response.js += '$("#your_table_selector").dataTable().fnUpdate( '+
> row_update+', '+request.vars['datatable_row_index']+',0, false );'
>
> #also using jGrowl to give an acknowledgement
> message = T("%s updated") % (updated_record.table.first_name)
> response.js += '$.jGrowl("'+message+'");'
>
>
> And as the second bonus, how to insert a brand new row in the datatable.
> (Below my datatable.net is another always visible LOAD()ed form for
> creating a new record. Upon submission the new record is inserted into the
> existing datatable via javascript returned in web2py's response)
>
> In controller:
> #do the database insert then
> #prepare for display update
> edit_icon = IMG(_src=URL(c="static",f="images/page_white_edit.png"),
> _alt="Click
> to edit")
>
> table_update = simplejson.dumps([new_record.table.first_name, new_record.
> table.last_name,
> new_record.table2.name, str(A(edit_icon, _href=URL(r=request,f=
> 'edit_loader',
> args=[new_record.table.record_id, form.vars.mode]), _class=
> "updateDialog")),
> new_record.table.email, new_record.table.foreign_id])
>
> #issue command for adding new row to datatable
> response.js = 'vol_table.fnAddData('+table_update+');'
>
> Good luck
>
> ~Brian
>
>
> On Sunday, June 22, 2014 4:44:33 PM UTC-5, Tomeu Roig wrote:
>>
>> Thanks Brian, nice think to get a full href for pass to the
>> $web2py.component.
>>
>> I see that you use datatables.net. Do you use some plugin o directly you
>> pass json from controller?
>>
>> I want use in a new project but i have doubts have to implement. Can you
>> give me some idea?
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
