JavaScript
$('#listRAbsence')
.jqGrid({
datatype: 'json',
mtype: 'post',
colNames: ["NIK","Nama","Divisi"],
colModel: [
{name:"rovertime_nik",index:"rovertime_nik",width:100,
frozen:true,
key:true,
searchoptions:{
sopt:["eq","ne","bw","bn","ew","en","cn","nc"]
}
},
{name:"rovertime_name",index:"rovertime_name",width:260,
frozen:true,
searchoptions:{
sopt:["eq","ne","bw","bn","ew","en","cn","nc"]
}
},
{name:"rovertime_div",index:"rovertime_div",width:120,
frozen:true,
search:false
}
],
autowidth: true,
shrinkToFit: false,
rowNum: 10000,
rowList: [],
pager: jQuery('#pListRAbsence'),
pgbuttons: false,
pgtext: false,
recordtext: 'View {1} record(s)',
sortname: 'rabsence_name',
height: 330,
viewrecords: true,
sortorder: 'asc',
caption: 'Laporan Kehadiran'
}).jqGrid ('navGrid','#pListRAbsence',{edit:false,add:false,del:false,search:true},
{}, // edit options
{}, // add options
{}, // del options
{ // search options
resize: false,
width: 500,
multipleSearch: true,
afterRedraw: function($form) {
// hide the AND/OR operation selection
$('select.opsel', $form[0]).hide();
}
}
).jqGrid ('navButtonAdd', '#pListRAbsence', {caption:'Export to Excel',title:'Export to Excel',
onClickButton: function() {
exportExcel(this);
}
}).jqGrid('setFrozenColumns')
.jqGrid('bindKeys', {onEnter: null});