jQuery Grid Plugin - jqGrid - Topic: A little help Please - Problem with code segment.

nelsonm on A little help Please - Problem with code segment.

Wed, 09 Nov 2011 01:21:36 +0200

I looked at the php demo before you mentioned it. Unfortunetly, there is nothing their that can help since it's completely handled by the php "setAutocomplete" function and i'm using jqgrid on the client side in javascript. I have already invested too much time programming jqgrid under javascript to purchase and reprogram the app in jqgrid php.

However the function of the "setAutocomplete" function does pretty much what i need to do. I need to...

1. (done) select, via autocomplete, server side table column data from the jqgrid edit form.

2. (not sure) update other jqgrid edit form fields with server side data related to the selected data item.

3. (working on it) post data related to the selected edit form data item back to the server to update the jqgrid row i'm editing.

I'm guessing that there is no easy way to do this under javascript jqgrid and that there probably is no "setAutocomplete" function for javascript?

tony on A little help Please - Problem with code segment.

Mon, 07 Nov 2011 12:59:36 +0200

Hello,

You can store this id in variable and use beforeSubmit event when the record is added. See the parameters passed to this event - i.e you can extend the posted data with this id.

Another approach is to have this field and fill it when the record is selected.

Some code you may get from our commertial componet here:

http://www.trirand.com/blog/ph.....efault.php

Regards

Tony

nelsonm on A little help Please - Problem with code segment.

Sat, 05 Nov 2011 06:43:36 +0200

Hi all,

I'm using autocomplete in the "editoptions" property of colModel. I'ts receiving customer id/value pair suggestions to select for an add new record operation. I display the item.value's in the suggestion window. However, i want the item.id of the selected item.value to be added to the "Add Record" window postdata passed to the server on submit.

    $('#tab3-grid').jqGrid({
       colNames:['Workorder', 'Customer', 'Technician', 'State', 'Service', 'Service Date', 'Time BLock', 'Payment Type', 'Total', 'Status', 'Notes'],
       colModel:[
           //use 'id' if you want aftersubmit: function new-id to work.
           {name:'id',               index:'wo.WOID',           width: 70, fixed:true, align:'center', sortable:true, editable:false, edittype:'text',     editoptions:{readonly:true,size:10}},
           {name:'wo.CUID',          index:'cu.LastName',       width:120, fixed:true, align:'center', sortable:true, editable:true, edittype:'text',
               editoptions:{dataInit:function(el){$(el).autocomplete({ source: 'php/customer-ac-script.php'
                                                                       , minLength: 1
                                                                       , change: function(event, ui) { code to add ui.item.id to submit postdata }
                                                                   })
                                                                   }},

               formoptions:{rowpos: 1, label:'Customer', elmprefix:'* '},
               editrules:{required:true}
           },

any help would be appeceated.