Forum
Log In
Home
Topic RSS
Related Topics
11:21
25/11/2010
Offline
Hi, I have a problem with a master detail table. I need to add or modify rows in the detail, but when I try to make a change the variation is made on the master table. Can someone tell me where I'm wrong? The editurl is not call.
Thank you for Help.
<HTML CODE>
....
<div id="riepilogo2">
<p><h2>Macchine da registrare</h2></p>
<br/><table id="navgrid"></table>
<div id="pagernav"></div>
<br > <table id='list10_d'><table> <div id="pager10_d"></div>
<script src="macchina_modifica.js" type=\text/javascript"> </script>
</div>
....
</HTML CODE>
<JS CODE>
jQuery("#navgrid").jqGrid({
url:'serie_modificare.php?q=1',
datatype: "json",
colNames:['Idn','Serie','Descrizione Italiana', 'Descrizione Inglese','Descrizione francese','Descrizione spagnola','Descrizione russa','Cancellato'],
colModel:[
{name:'idn',index:'idn', width:5,hidden:true},
{name:'codiceserie',index:'codiceserie', width:110},
{name:'it',index:'it', width:210,hidden:true},
{name:'en',index:'en', width:210,hidden:true},
{name:'fr',index:'fr', width:210,hidden:true},
{name:'es',index:'es', width:210,hidden:true},
{name:'ru',index:'ru', width:210,hidden:true},
{name:'cancellato',index:'cancellato',width:60,hidden:true}
],
rowNum:10,
rowList:[10,20,30],
pager: '#pagernav',
sortname: 'codiceserie',
viewrecords: true,
sortorder: "asc",
multiselect: false,
width: 690,
height: "100%",
caption:"Serie",
onSelectRow: function(ids) {
if(ids == null) {
ids=0;
if(jQuery("#list10_d").jqGrid('getGridParam','records') >0 )
{
jQuery("#list10_d").jqGrid('setGridParam',{url:"macchina_subgrid.php?q=1&id="+ids,page:1,editurl:"serie_modificare2.php?idn="+ids});
jQuery("#list10_d").jqGrid('setCaption',"Macchine 1: "+ids)
.trigger('reloadGrid');
}
} else {
jQuery("#list10_d").jqGrid('setGridParam',{url:"macchina_subgrid.php?q=1&id="+ids,page:1,editurl:"serie_modificare2.php?idn="+ids});
jQuery("#list10_d").jqGrid('setCaption',"Macchine 2: "+ids)
.trigger('reloadGrid');
}
}
});
jQuery("#navgrid").jqGrid('navGrid','#pagernav',{edit: false, add: false, del: false, refresh: true, search: false});
jQuery("#list10_d").jqGrid({
height: 100,
url:'macchina_subgrid.php?q=1&id=0',
datatype: "json",
colNames:['Idm','Idn', 'Codice Macchina', 'Desc. Italiana','Desc. Inglese','Desc. Francese','Desc. Spagnola','Desc. Russa','Immagine','Cancellato'],
colModel:[
{name:'idm',index:'idm', width:55,hidden:true},
{name:'idn',index:'idn', width:55,hidden:true},
{name:'codicemacchina',index:'codicemacchina', width:60,editable:true,edittype:"textarea",editoptions:{size:10,maxlength: 16},editrules:{required:true},formoptions:{elmprefix:'(*)'}},
{name:'it',index:'it', width:110,editable:true,edittype:"textarea",editoptions:{size:100,maxlength: 2000}},
{name:'en',index:'en', width:110,editable:true,edittype:"textarea",editoptions:{size:100,maxlength: 2000}},
{name:'fr',index:'fr', width:110,editable:true,edittype:"textarea",editoptions:{size:100,maxlength: 2000}},
{name:'es',index:'es', width:110,editable:true,edittype:"textarea",editoptions:{size:100,maxlength: 2000}},
{name:'ru',index:'ru', width:110,editable:true,edittype:"textarea",editoptions:{size:100,maxlength: 2000}},
{name:'image',index:'image', width:55},
{name:'cancellato',index:'cancellato',width:60,align:'center',editable:true,edittype:"checkbox",editoptions:{value:"1:0"}}
],
rowNum:5,
rowList:[5,10,20],
pager: '#pager10_d',
sortname: 'idm',
viewrecords: true,
sortorder: "asc",
multiselect: false,
caption:"Macchine",
editurl:"serie_modificare2.php?idn=0"
});
jQuery("#list10_d").jqGrid('navGrid','#pager10_d',{del:false,closeAfterEdit:true,search:false},
{height:'auto',reloadAfterSubmit:true,closeAfterEdit :true}, // edit options
{height:'auto',closeOnEscape:true,jqModal:true,bottominfo:"Fields marked with (*) are required",
reloadAfterSubmit:true,
closeAfterAdd:true,
afterSubmit:function(response,postdata){
var success = false;
var message = "";
var new_id = 0;
try{
var json = eval(response.responseText );
success = json.success;
new_id = json.sql_id;
//alert("[" + success + "," + message + "," + new_id + "]");
if(json.errors) {
for(i=0; i < json.errors.length; i++) {
message += json.errors[i]['error'] + '<br/>';
}
}
}catch (e) {
message = e.name + " : " + e.message + " : mah ";
}
//if(success == undefined){success = false; message="Utente già esistente";}
// var new_id = "1″;
// alert("[" + success + "," + message + "," + new_id + "]");
return [success,message,new_id];
} }, // add options
{reloadAfterSubmit:false}, // del options
{multipleSearch:true,overlay:true} // search options
);
var fn_editSubmit=function(response,postdata){
var json=response.responseText; //in my case response text form server is "{sc:true,msg:''}"
var result=eval("("+json+")"); //create js object from server reponse
return [result.sc,result.msg,null];
}
//define edit options for navgrid
var editOptions={
top: 50, left: "100", width: 500
,closeOnEscape: true, afterSubmit: fn_editSubmit
}
</ JS CODE>
Most Users Ever Online: 715
Currently Online:
78 Guest(s)
Currently Browsing this Page:
1 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
