jQuery Grid Plugin - jqGrid

var id=0;
var parent_id=”196″;
var dim_nr=”";
var oURL=”";

jQuery().ready(function() {
jQuery(”#list”).jqGrid({
url:’get_product.cfc?CFID=2706&CFTOKEN=27757645&method=getMasterproductInfo&id_masterproduct=17182′,
datatype: ‘json’,
mtype: ‘GET’,
colNames:['ID_O_PRODUCT','Artikel Nr','L
mm','k
mm','b
mm','s
mm','d
','dk
mm','CHF / 100STK',''],

colModel:[{name:'ID_O_PRODUCT',index:'ID_O_PRODUCT',key:true,hidden:true, search:false},
{name:'PRODUCT_NUMBER',index:'PRODUCT_NUMBER',sortable:false, width:65, align:'left'},
{name:'PA1.VALUE_1',index:'PA1.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;100:100;110:110;120:120;130:130;140:140;150:150;160:160;170:170;180:180;200:200;220:220;240:240;25:25;260:260;280:280;30:30;300:300;35:35;40:40;45:45;50:50;55:55;60:60;65:65;70:70;75:75;80:80;85:85;90:90"}},
{name:'PA2.VALUE_1',index:'PA2.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;10:10;12:12;14:14;16:16;18:18;20:20;24:24;27:27;3:3;30:30;36:36;4:4;48:48;5:5;6:6;8:8"}},
{name:'PA3.VALUE_1',index:'PA3.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;108:108;18:18;20:20;22:22;24:24;28:28;32:32;36:36;40:40;44:44;48:48;52:52;60:60;66:66;72:72;84:84"}},
{name:'PA4.VALUE_1',index:'PA4.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;10:10;12:12;14:14;17:17;19:19;2.5:2.5;22:22;27:27;3:3;36:36;4:4;5:5;6:6;8:8"}},
{name:'PA5.VALUE_1',index:'PA5.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;M 10:M 10;M 12:M 12;M 14:M 14;M 16:M 16;M 18:M 18;M 20:M 20;M 22:M 22;M 24:M 24;M 27:M 27;M 3:M 3;M 30:M 30;M 36:M 36;M 4:M 4;M 48:M 48;M 5:M 5;M 6:M 6;M 8:M 8"}},
{name:'PA6.VALUE_1',index:'PA6.VALUE_1',width:90,align:'center',sortable:false,edittype:'select',editoptions:{value:":All;:;10:10;13:13;16:16;18:18;21:21;24:24;27:27;30:30;36:36;40:40;45:45;5.5:5.5;54:54;7:7;72:72;8.5:8.5"}},
{name:'PRICE',index:'PRICE',width:70, align:'center',formatter:'currency',sortable:false,search:false},
{name:'art_nr',index:'art_nr',width:25, align:'left',sortable:false,search:false}
],
pager: ‘#pager’,
height: ‘auto’,
width: 825,
shrinkToFit: false,
forceToFit: false,
imgpath: ‘/shop/javascript/jquery/themes/basic/images’,
loadError: function(xhr,st,err) {alert(’Type: ‘+st+’; Response: ‘+ xhr.status + ‘ ‘+xhr.statusText);},
loadonce: false,
loadui: “block”,
rowNum: 20,
rowList: [20,30,40,50,100],
sortname: ‘PRODUCT_NUMBER’,
sortorder: “asc”,
viewrecords: true,
toolbar: [true,"top"],
//The JSON reader. This defines what the JSON data returned from the CFC should look like
jsonReader: {
root: “ROWS”, //our data
page: “PAGE”, //current page
total: “TOTAL”, //total pages
records:”RECORDS”, //total records
userdata:”USERDATA”, //Userdata we will pass back for feedback
cell: “”, //Not Used
id: “0″ //Will default to frist column
},
caption: ‘Liste der Dimensionen’,
afterInsertRow: function(rowid, aData){
jQuery(”#list”).setCell( rowid, ‘PRODUCT_NUMBER’,”, { “font-weight”: “bold”});
jQuery(”#list”).setCell( rowid, ‘PRICE’,”, { “font-weight”: “bold”});
},
onCellSelect: function( rowid, iCol, aData) {
var mynumberofcolumns = $(”#list”).getGridParam(”colModel”).length-1;
id = $(”#list”).getCell(rowid, 0);
dim_nr = $(”#list”).getCell(rowid, 1);
// alert(”iCol=”+iCol + ” mynumberofcolumns=”+mynumberofcolumns);
if (iCol == mynumberofcolumns) {
// oURL = “addbasket.cfm?CFID=2706&CFTOKEN=27757645&ID_O_PRODUCT=” + id + “&parent_id=” + parent_id;
// awin = widthndow.open(oURL,”main”);
alert(”Produkt in den Warenkorb: ” + dim_nr );
} else {
alert(”Click: Row: ” + rowid + ” Cell: ” + iCol + ” was clicked”);
}
},
ondblClickRow: function( rowid ){
id = $(”#list”).getCell(rowid, 0);
dim_nr = $(”#list”).getCell(rowid,1);
alert(”doubleClick: rowid=” + rowid + ” id=”+id+” dim_nr=”+dim_nr);
},
onRightClickRow: function( rowid ) {
id = $(”#list”).getCell(rowid, 0);
dim_nr = $(”#list”).getCell(rowid,1);
//$(”#myModal”).jqmShow();
alert( “leftClick: here we are: id=” + id + ” , dim_nr=” + dim_nr);
}

});

jQuery(”#t_list”).height(25).hide().filterGrid(”list”,{gridModel:true,gridToolbar:true});

if (jQuery(”#list”).getGridParam(’records’) > 20) {
jQuery(”#t_list”).height(25).show().filterGrid(”list”,{gridModel:true,gridToolbar:true});
}

jQuery(”#list”).navGrid(’#pager’,{edit:false,add:false,del:false,search:false,refresh:false})
.navButtonAdd(”#pager”,{caption:”Search”,title:”Toggle Search”,buttonimg: ‘javascript/jquery/themes/basic/images/find.gif’,
onClickButton:function(){
if(jQuery(”#t_list”).css(”display”)==”none”) {
jQuery(”#t_list”).css(”display”,”");
} else {
jQuery(”#t_list”).css(”display”,”none”);
}
}

});
});