jQuery Grid Plugin - jqGrid - Topic: Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array Simple:Press Version 5.7.5.3 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18785 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18785 OMG that was it!!

More then 2 weeks and three people working on this only to find out that the file wasn't even in the download.

Thank you RedSpawn!!!

]]> Fri, 23 Jul 2010 20:07:42 +0300 RedSpawn on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18783 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18783 yes, it's the ui part of jquery..

put this in the head:

<script type="text/javascript" language="javascript" src="business/jquery-ui-1.8.2.custom.min.js"></script>

and you can get it here:

http://jqueryui.com/download

]]> Fri, 23 Jul 2010 20:02:03 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18782 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18782 Better yet, where do you get that file? I don't have it?!

]]> Fri, 23 Jul 2010 20:01:38 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18780 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18780 What do you mean load it? It needs to go into the header of the page?

]]> Fri, 23 Jul 2010 19:57:21 +0300 RedSpawn on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18779 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18779 ok, i got it to work Embarassed

i had to load "jquery-ui-1.8.2.custom.min.js" Embarassed

sooooooooooo stupid!

i don't know if i should hope for you that you made the same mistake Wink

greetz

red

]]> Fri, 23 Jul 2010 19:56:02 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18777 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18777 Well I have no database to connect to, so if you can figure something out that will work for the local data I'd be eternily grateful!

]]> Fri, 23 Jul 2010 18:54:26 +0300 RedSpawn on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18776 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18776 no, the class is not missing in the css, it is missing in the html created by jqGrid.

there is something going wrong on creating the jqGrid object with local data and sortable columns.

i'm trying to recreate the demo with json data now.

]]> Fri, 23 Jul 2010 18:46:18 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18775 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18775 So we're missing the class ui-sortable from the css file?

Is that what you're saying  RedSpawn?

]]> Fri, 23 Jul 2010 18:36:38 +0300 RedSpawn on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18774 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18774 hi there

i'm trying the same thing and i can't get it to work either....

what i've found is that in the working demo the header "tr" has an additional "ui-sortable" class which is missing in my local-data version

can someone help?

]]> Fri, 23 Jul 2010 18:33:09 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18750 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18750 So I realised that 3.5 does not have the reordering of columns.

Can someone please help me. I've gotta have this done for tomorrow (Friday).

Loq

]]> Thu, 22 Jul 2010 22:36:21 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18744 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18744 I currently have the most current version downloaded, but I'll try and download the 3.5 to see if that works.

Anyone else have any insight?

]]> Thu, 22 Jul 2010 16:18:59 +0300 yandaomin on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18729 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18729 Hi loquae：

I use your html and test, I found it's normal. I use jqgrid 3.5 lib.

    I think your problem is about jqgrid lib. you download jqgrid 3.5lib and try it.

   the code see below,

   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<link rel="stylesheet" type="text/css" media="screen" href="css/jquery-ui-1.8.2.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />

<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/i18n/grid.locale-en.js"></script>
<script type="text/javascript" src="js/jquery.jqGrid.min.js"></script>
</head>

<body>

<table id="list47"></table>
<div id="plist47"></div>

<script type="text/javascript">
var rc = $("list47").jqGrid("getGridParam", "remapColumns")
if (rc && rc.length) {
   // rc[i] is the original position of the current i'th column
} else {
   // columns havent been reordered yet
}

var mydata = [
                {id:"01",invdate:"2010-05-24",name:"test",note:"note",tax:"10.00",total:"2111.00"} ,
                {id:"02",invdate:"2010-05-25",name:"test2",note:"note2",tax:"20.00",total:"320.00"},
                {id:"03",invdate:"2007-09-01",name:"test3",note:"note3",tax:"30.00",total:"430.00"},
                {id:"04",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"},
                {id:"05",invdate:"2007-10-05",name:"test2",note:"note2",tax:"20.00",total:"320.00"},
                {id:"06",invdate:"2007-09-06",name:"test3",note:"note3",tax:"30.00",total:"430.00"},
                {id:"07",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"},
                {id:"08",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"21.00",total:"320.00"},
                {id:"09",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"11",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"12",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"13",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"14",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"15",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"16",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"17",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"18",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"19",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"21",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"22",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"23",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"24",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"25",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"26",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"27",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"28",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"29",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}
        
        ];
        
    jQuery("#list47").jqGrid( {
            sortable: true,
            data: mydata,
            datatype: "local",
            colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
            colModel:[
                    {name:'id',index:'id', width:55},
                    {name:'invdate',index:'invdate', width:90},
                    {name:'name',index:'name', width:100},
                    {name:'amount',index:'amount', width:80, align:"right"},
                    {name:'tax',index:'tax', width:80, align:"right"},
                    {name:'total',index:'total', width:80,align:"right"},
                    {name:'note',index:'note', width:150, sortable:false}
            ],
            rowNum: 5,
            rowList: [5,10,15],
            pager: "#plist47",
            sortname: 'invdate',
            viewrecords: true,
            sortorder: "desc",
            gridview: true,
                     pginput:true,
            caption: "Column Reordering"
    });
    jQuery("#list47").jqGrid('navGrid','#plist47',{add:false,edit:false,del:false});
</script>
</body>
</html>

]]> Thu, 22 Jul 2010 06:27:43 +0300 loquae on Column Reordering - Using Local Array http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18723 Help http://www.trirand.com/blog/?page_id=393/help/column-reordering-using-local-array#p18723 Afternoon!

I have been trying to get the columns to be sortable (reorder by dragging them) using a local array of data for the past week. I have gone through all of the demos, the message boards, and wiki to no avail. Can anyone look at the code for the page and tell me what I might be doing wrong please?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DT.....t;&gt;
<html xmlns="http://www.w3.org/1999/xhtml&q.....t;&gt;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<link rel="stylesheet" type="text/css" media="screen" href="css/redmond/jquery-ui-1.8.2.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />

<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/grid.locale-en.js"></script>
<script type="text/javascript" src="js/jquery.jqGrid.min.js"></script>
</head>

<body>

<table id="list47"></table>
<div id="plist47"></div>

<script type="text/javascript">
var rc = $("list47").jqGrid("getGridParam", "remapColumns")
if (rc && rc.length) {
   // rc[i] is the original position of the current i'th column
} else {
   // columns havent been reordered yet
}

var mydata = [
                {id:"01",invdate:"2010-05-24",name:"test",note:"note",tax:"10.00",total:"2111.00"} ,
                {id:"02",invdate:"2010-05-25",name:"test2",note:"note2",tax:"20.00",total:"320.00"},
                {id:"03",invdate:"2007-09-01",name:"test3",note:"note3",tax:"30.00",total:"430.00"},
                {id:"04",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"},
                {id:"05",invdate:"2007-10-05",name:"test2",note:"note2",tax:"20.00",total:"320.00"},
                {id:"06",invdate:"2007-09-06",name:"test3",note:"note3",tax:"30.00",total:"430.00"},
                {id:"07",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"},
                {id:"08",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"21.00",total:"320.00"},
                {id:"09",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"11",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"12",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"13",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"14",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"15",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"16",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"17",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"18",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"19",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"21",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"22",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"23",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"24",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"25",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"26",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
                {id:"27",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
                {id:"28",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
                {id:"29",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}
        
        ];
        
    jQuery("#list47").jqGrid( {
            sortable: true,
            data: mydata,
            datatype: "local",
            colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
            colModel:[
                    {name:'id',index:'id', width:55},
                    {name:'invdate',index:'invdate', width:90},
                    {name:'name',index:'name', width:100},
                    {name:'amount',index:'amount', width:80, align:"right"},
                    {name:'tax',index:'tax', width:80, align:"right"},
                    {name:'total',index:'total', width:80,align:"right"},
                    {name:'note',index:'note', width:150, sortable:false}
            ],
            rowNum: 5,
            rowList: [5,10,15],
            pager: "#plist47",
            sortname: 'invdate',
            viewrecords: true,
            sortorder: "desc",
            caption: "Column Reordering"
    });
    jQuery("#list47").jqGrid('navGrid','#plist47',{add:false,edit:false,del:false});
</script>
</body>
</html>

]]> Wed, 21 Jul 2010 20:45:45 +0300