• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
some trouble with jqgrid

#1
[eluser]teddy[/eluser]
everything is ok when I used Jqgrid with php, but when I apply to script below with views in codeigniter I have meet some troubles

1. Formate datetime is just show date and time is show 00:00:00
2. Jqgird not show filter toolbar

I don't know what happen with my code, or I miss something. Thank you for reading my topic

Code:
[removed]
        $(document).ready(function (){
            jQuery("#list").jqGrid({              
                url:'<?=$base_url.'index.php/admin/users/list_users'?>',            
                mtype : "post",    
                datatype: "json",  
                colNames:['id','Họ tên','username','Email','Ngày đăng ký'],
                colModel:[
                    {name:'id', index:'id', width:55,hidden:true},
                    {name:'hoten',index:'hoten', width:100, align:"left",sortable:true},
                    {name:'username',index:'username', width:150, align:"left",search:true,sortable:true},                
                    {name:'Email',index:'phone', width:100, align:"right",search:true,sortable:true},
                   {name:'date_added', index:'date_added'
                        ,formatter:'date', formatoptions: {newformat:'d-m-Y: H:i:s'}
                        , align:'center',search:true,sortable:true}  
                
                ],
                rowNum:10,
                width: 750,
                height: 300,
                rowList:[10,20,30],
                pager: '#pager',
                sortname: 'id',
                viewrecords: true,
                rownumbers: true,
                 //loadonce:true,
                gridview: true,
    
                caption:"Danh sách Users"
            }).navGrid('#pager',{edit:true,add:true,del:true,refesh:true});
        });


      jQuery('#list').jqGrid('filterToolbar', { searchOnEnter: true, enableClear: false });

[removed]

#2
[eluser]teddy[/eluser]
I found some errors in my code and everything is ok, but I am seeking some tutorials about master detail with jqgrid I did it but subgrid is not show is nothing just show text loading...

My js script
Code:
$(function()
    {

            jQuery("#list").jqGrid({              
                url:'<?=$base_url.'index.php/admin/users/list_users'?>',            
                editurl:'<?=$base_url.'index.php/admin/users/crud'?>',
                datatype: "json",  
                mtype : "post",                    
                colNames:['id','Họ tên','username','Email','Ngày đăng ký','Active'],
                colModel:[
                    {name:'id', index:'id', width:55,hidden:true},
                    {name:'hoten',index:'hoten', width:100, align:"left",sortable:true,editable:true},
                    {name:'username',index:'username', width:150, align:"left",search:true,sortable:true,editable:true},                
                    {name:'Email',index:'email', width:100, align:"right",search:true,sortable:true},
                    {name:'date_added', index:'date_added'
                        ,formatter:'date', formatoptions: {newformat:'d-m-Y H:i:s'}
                        , align:'center',search:true,sortable:true},

                    {name:'Active',index:'active', width:100, align:"right",search:true,sortable:true
                        ,edittype:'checkbox',editoptions: { value:"True:False" }
                        ,formatter: "checkbox", formatoptions: {disabled : false},align:'center'},    
                
                ],
                rowNum:10,
                width: 750,
                height: 300,
                rowList:[10,20,30],
                pager: '#pager',
                sortname: 'id',
                viewrecords: true,
                rownumbers: true,
                loadonce:true,
                gridview: true,
                multiselect:true,
                caption:"Danh sách Users",
                subGrid:true,        
                subGridUrl:'<?=$base_url.'index.php/admin/users/getDetails'?>',
                subGridModel: [{ name : ['tieude','date_added'], width : [200,55], params:['user_id']} ]
            });
    
      
   $("#list").jqGrid('navGrid', '#pager', { edit: false,add: false,  del: true, });
    jQuery("#list").jqGrid('filterToolbar',{stringResult: true,searchOnEnter : false});    
    jQuery("#list").jqGrid('inlineNav',"#pager");
    
});

and here is my subgrid controller

Code:
function getDetails()
{
  $id=$_POST['id'];    
  $sql="select * from tbl_posts where user_id='$id'";
  $rs=$this->db->query($sql)->result_array();
    

  $i=0;
  foreach($rs as $row) {
   $responce->rows[$i]['id']=$row->id;
   $responce->rows[$i]['cell']=array($row->id,$row->tieude,$row->date_added);
   $i++;
      }

   echo json_encode($responce);

}

#3
[eluser]robertorubioes[/eluser]
Hi,

always double quotes for JSON

Try it! Wink

#4
[eluser]teddy[/eluser]
@robertorubioes: please explain more, tk


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.