Master/detial: detail not reloaded -------------plzzzzz

[sodoko]

I want to setup a master/detail grid: when clicking on a cell of the master table, the detail grid shows more information about this record. I am retrieving data via PHP. here is the part of my code of index.php:


<script type="text/javascript" > var grid_demo_id = "myGrid1" ; var grid_details_id = "myGrid2"; var dsOption= {     fields :[         {name : 'idu'  },         {name : 'nom'  },         {name : 'prenom'  },     ],     recordType : 'object' } var dsOptionDetails= {     fields :[         {name : 'id'  },         {name : 'password'  },         {name : 'webpage'  },         {name : 'sqldatabase' },         {name : 'description'  },         {name : 'sqlpwd'  },         {name : 'phpurl'  },     ],     recordType : 'object' } var colsOption = [      {id: 'chk' ,isCheckColumn : true, filterable: false, exportable:false},      {id: 'idu' , header: "id user" , width :60  },      {id: 'nom' , header: "Nom" , width :120,editor: {  type :"text"  }},      {id: 'prenom' , header: "Pr&eacute;nom" , width :120,editor: {  type :"text"  }} ]; var colsOptionDetails = [      {id: 'password' , header: "Password" , width :120 , editor: {type :"text"}},      {id: 'webpage' , header: "Webpage" , width :120 , editor: {type :"text"}},      {id: 'sqldatabase' , header: "SQLDatabase" , width :120 , editor: {type :"text"}},      {id: 'description' , header: "Description" , width :120 , editor: {type :"text"}},      {id: 'sqlpwd' , header: "SQLPWD" , width :120 , editor: {type :"text"}},      {id: 'phpurl' , header: "PHPURL" , width :120 , editor: {type :"text"}} ]; var gridOption={     id : grid_demo_id,     onCellClick  : function(value, record , cell, row,  colNO, rowNO,columnObj,grid){         var grid=Sigma.$grid(grid_details_id);       //  grid.loadURL = "DetailsController.php";         grid.loadURL = "DetailsController.php?idu=" + record['idu'];         grid.addParameters({'idu':record['idu']});         grid.reload();     },     loadURL : 'Controller.php',     saveURL : 'Controller.php',     parameters:{'sql':"<?=$sql;?>"},     width: "800",  //"100%", // 700,     height: "450",  //"100%", // 330,     container : 'gridbox',      replaceContainer : true,     encoding : 'UTF-8', //Sigma.$encoding(), // '',     dataset : dsOption ,     columns : colsOption ,     clickStartEdit : false ,     pageSize:100,     toolbarContent : 'reload | add del save | nav | goto | pagesize | print xls',         pageSize : 20 ,     pageSizeList : [5,10,15,20,50],     onmouseover : function(event,grid){         var ts= grid.getEventTargets(event);         if (ts.column && ts.column.toolTip) {             grid.showCellToolTip(ts.cell,ts.column.toolTipWidth);         }else{             grid.hideCellToolTip();         }     },     onmouseout : function(event,grid){         grid.hideCellToolTip();     } }; var gridOptionDetails={     id : grid_details_id,     loadURL : 'DetailsController.php',     saveURL : 'DetailsController.php',     parameters:{'idu':"0"},     width: "700",     height: "260",          container : 'gridboxDetails',     replaceContainer : true,     editable : true,     pageSizeList : [5,10,15,20],     dataset : dsOptionDetails ,     columns : colsOptionDetails ,     clickStartEdit : true ,     pageSize:30,    // toolbarContent : 'reload | add del | print | state',    toolbarContent : 'reload | add del save | nav | goto | pagesize | print xls',     showGridMenu : true,     allowHide    : true , }; ?>

and here my My DetailsController.php has following code:

<?php include_once("ConnectionManager.php"); header('Content-type:text/javascript;charset=UTF-8'); $json=json_decode(stripslashes($_POST["_gt_json"])); //$pageNo = $json->{'pageInfo'}->{'pageNum'}; $conManager = new ConManager(); $conManager->getConnection(); if($json->{'action'} == 'load'){   $parametro = $json->{'parameters'};   $sql = "select * from matiere where id = '" . $parametro->idu. "'";   $handle = mysql_query($sql); // if($json->{'action'} == 'load'){   // $sql = "select * from matiere  where id =";   // $sql .= $json->{'parameters'}->id;   // $handle = mysql_query($sql);  


The 2 grids show up without any error, but when i click a cell on master grid, the detail grid shows "Please wait" but nothing changes, it isn't updated corresponding to the clicked cell in master grid.

What is wrong with this code?

100000000000 thanks thanks for your help [/font][/b]

[steven]

Your script is too long to review.
I suggest you check it with firebug first to see everything back from server side is ok first.

[prabhuraj]

hai try this.....


var gridOption={
   id : grid_demo_id,
   width: "700", 
   height: "350",     
   container : 'gridbox',
   replaceContainer : true,
   dataset : dsOption ,
   columns : colsOption ,
   pageSizeList : [5,10,15,20],
   customHead : 'myHead',
   
   onClickCell  : function(value, record , cell, row,  colNO, rowNO,columnObj,grid)
   {
       var master_id = record.order_no;
      var grid=Sigma.$grid(grid_details_id);
      grid.loadURL = "Controller.php?rid=" + master_id + "";
      grid.addParameters({'master_id':master_id});
      grid.reload();
   },
   
   SigmaGridPath : 'grid/',
   loadURL : 'Controller.php',
   parameters:{'rid':"2"},
   defaultRecord : ["","","","",0,0,0,0,"2008-01-01"],
   pageSize:5,
   toolbarContent : 'nav | reload | state',
   
   
};

[cd_gary]

Did you ever get this issue resolved?

I want to setup a master/detail grid: when clicking on a cell of the master table, the detail grid shows more information about this record. I am retrieving data via PHP. here is the part of my code of index.php:


<script type="text/javascript" > var grid_demo_id = "myGrid1" ; var grid_details_id = "myGrid2"; var dsOption= {     fields :[         {name : 'idu'  },         {name : 'nom'  },         {name : 'prenom'  },     ],     recordType : 'object' } var dsOptionDetails= {     fields :[         {name : 'id'  },         {name : 'password'  },         {name : 'webpage'  },         {name : 'sqldatabase' },         {name : 'description'  },         {name : 'sqlpwd'  },         {name : 'phpurl'  },     ],     recordType : 'object' } var colsOption = [      {id: 'chk' ,isCheckColumn : true, filterable: false, exportable:false},      {id: 'idu' , header: "id user" , width :60  },      {id: 'nom' , header: "Nom" , width :120,editor: {  type :"text"  }},      {id: 'prenom' , header: "Pr&eacute;nom" , width :120,editor: {  type :"text"  }} ]; var colsOptionDetails = [      {id: 'password' , header: "Password" , width :120 , editor: {type :"text"}},      {id: 'webpage' , header: "Webpage" , width :120 , editor: {type :"text"}},      {id: 'sqldatabase' , header: "SQLDatabase" , width :120 , editor: {type :"text"}},      {id: 'description' , header: "Description" , width :120 , editor: {type :"text"}},      {id: 'sqlpwd' , header: "SQLPWD" , width :120 , editor: {type :"text"}},      {id: 'phpurl' , header: "PHPURL" , width :120 , editor: {type :"text"}} ]; var gridOption={     id : grid_demo_id,     onCellClick  : function(value, record , cell, row,  colNO, rowNO,columnObj,grid){         var grid=Sigma.$grid(grid_details_id);       //  grid.loadURL = "DetailsController.php";         grid.loadURL = "DetailsController.php?idu=" + record['idu'];         grid.addParameters({'idu':record['idu']});         grid.reload();     },     loadURL : 'Controller.php',     saveURL : 'Controller.php',     parameters:{'sql':"<?=$sql;?>"},     width: "800",  //"100%", // 700,     height: "450",  //"100%", // 330,     container : 'gridbox',      replaceContainer : true,     encoding : 'UTF-8', //Sigma.$encoding(), // '',     dataset : dsOption ,     columns : colsOption ,     clickStartEdit : false ,     pageSize:100,     toolbarContent : 'reload | add del save | nav | goto | pagesize | print xls',         pageSize : 20 ,     pageSizeList : [5,10,15,20,50],     onmouseover : function(event,grid){         var ts= grid.getEventTargets(event);         if (ts.column && ts.column.toolTip) {             grid.showCellToolTip(ts.cell,ts.column.toolTipWidth);         }else{             grid.hideCellToolTip();         }     },     onmouseout : function(event,grid){         grid.hideCellToolTip();     } }; var gridOptionDetails={     id : grid_details_id,     loadURL : 'DetailsController.php',     saveURL : 'DetailsController.php',     parameters:{'idu':"0"},     width: "700",     height: "260",          container : 'gridboxDetails',     replaceContainer : true,     editable : true,     pageSizeList : [5,10,15,20],     dataset : dsOptionDetails ,     columns : colsOptionDetails ,     clickStartEdit : true ,     pageSize:30,    // toolbarContent : 'reload | add del | print | state',    toolbarContent : 'reload | add del save | nav | goto | pagesize | print xls',     showGridMenu : true,     allowHide    : true , }; ?>

and here my My DetailsController.php has following code:

<?php include_once("ConnectionManager.php"); header('Content-type:text/javascript;charset=UTF-8'); $json=json_decode(stripslashes($_POST["_gt_json"])); //$pageNo = $json->{'pageInfo'}->{'pageNum'}; $conManager = new ConManager(); $conManager->getConnection(); if($json->{'action'} == 'load'){   $parametro = $json->{'parameters'};   $sql = "select * from matiere where id = '" . $parametro->idu. "'";   $handle = mysql_query($sql); // if($json->{'action'} == 'load'){   // $sql = "select * from matiere  where id =";   // $sql .= $json->{'parameters'}->id;   // $handle = mysql_query($sql);  


The 2 grids show up without any error, but when i click a cell on master grid, the detail grid shows "Please wait" but nothing changes, it isn't updated corresponding to the clicked cell in master grid.

What is wrong with this code?

100000000000 thanks thanks for your help [/font][/b]