elmerald on Problem master/detail with Add e Edit

Tue, 26 Apr 2011 11:21:42 +0300

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.

....

<div id="riepilogo2">
      <p><h2>Macchine da registrare</h2></p>
     <br/><table id="navgrid"></table>
     <div id="pagernav"></div>

</div>

....

</HTML 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>

jQuery Grid Plugin - jqGrid - Topic: Problem master/detail with Add e Edit

elmerald on Problem master/detail with Add e Edit