Forum


11:43

20/02/2009

Hello,
My button search doesn't work very well. when I enter parameter for selection, It returns me all my grid and it doesn't care about my query?
Do you any idea about this problem. Below it's my program:
jQuery(document).ready(function(){
var lastsel;
jQuery("#client").jqGrid({
url:'/paiement/traitement/server.php?nd='+new Date().getTime(),
datatype: "json",
colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
colModel:[
{name:'invid',index:'invid', width:55,sorttype:"int"},
{name:'invdate',index:'invdate', width:90,editable:true,sorttype:"date",formatter:'date',formatoptions:{newformat: 'd/m/Y'},editrules:{required:true}},
{name:'name',index:'name', width:100,editable:true,sorttype:"text",editrules:{required:true}},
{name:'amount',index:'amount', width:80, align:"right",sorttype:"float",editable:true,editrules:{number:true}},
{name:'tax',index:'tax', width:80, align:"right",sorttype:"float",editable:true,editrules:{number:true}},
{name:'total',index:'total', width:80,align:"right",sorttype:"float",editable:true,editrules:{number:true}},
{name:'note',index:'note', width:150, sortable:false,editable:true}
],
rowNum:10,
rowList:[10,20,30],
pager: jQuery('#pclient'),
sortname: 'invid',
imgpath: '/paiement/jqgrid/themes/coffee/images/',
viewrecords: true,
sortorder: "asc",
caption: "tableau test",
onSelectRow: function(invid){
if(invid && invid!==lastsel){
var ret = jQuery("#client").getRowData(invid);
jQuery('#client').restoreRow(lastsel);
//jQuery('#client').editRow(invid,true,pickdates,success,'/paiement/traitement/mise_a_jour_bd.php',{'invid':+ret.invid},aftersavefunc,onerrorfunc);
jQuery('#client').editRow(invid,true,pickdates,'','/paiement/traitement/mise_a_jour_bd.php',{'invid':+ret.invid},'',onerrorfunc);
lastsel=invid;
}
},
editurl: "/paiement/traitement/server.php",
}).navGrid('#pclient', {refresh:true,add:true,del:true,search:true,edit:true},
{ height:180,width:300}, //edit options
{ height:180, width:300, modal:true, reloadAfterSubmit:true,url:'/paiement/traitement/ajout_bd.php',
onInitializeForm : function() {
jQuery("#invdate").datepicker({
dateFormat:"dd/mm/yy",
clickInput:true,
createButton:true,
buttonImage: '/paiement/jqgrid/themes/calendar.gif'
//startDate:'2000-01-02'
}); // Mark grid's date fields
}
}, // add options
{ height:80,width:300, reloadAfterSubmit:true, modal:true, url:'/paiement/traitement/suppression_bd.php',
beforeSubmit: function() { //réccuperation du code d'identification!
var sr = jQuery('#client').getGridParam('selrow');
var rowData = jQuery('#client').getRowData(sr);
this.delData = {'invid': rowData['invid']};
//retarr = {'invid': rowData['invid']};
retarr = this.delData;
return retarr;
}
}, // delete options
{} // search options
);
});
Thank you for your help!
Aurore
03:15

Moderators
30/10/2007

Hello,
Check your server side code - what is get and what is returned.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
47 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66