$("#jqxGridByAttendanceDetail").on("bindingcomplete", function (event) {
// your code here.
changeStyle();
}); function changeStyle() {
var cellsrenderer = function (index, column, value, html, cellInfo, row) {
if (row.RestType == "0") {//假
return $(html).addClass("red").append("<sup> 假</sup>").prop("outerHTML");
}
if (row.RestType == "1") {//休
return $(html).addClass("red").append("<sup> 休</sup>").prop("outerHTML");
}
if (row.RestType == "2") {//正常
return $(html).append("<sup> </sup>").prop("outerHTML");
}
};
//重置列配置
$('#jqxGridByAttendanceDetail').jqxGrid({
columns: [
{
datafield: 'Date',
filterdelay: 50000,
text: '日期',
sort: '0',
minwidth: '90',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: true,
editable: false,
cellsformat: 'yyyy-MM-dd',
filtertype: 'range',
cellsrenderer: cellsrenderer
},
{
datafield: 'ShiftCode',
filterdelay: 50000,
text: '班次',
sort: '1',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: true,
editable: false,
},
{
datafield: 'FirstStandardIn',
filterdelay: 50000,
text: '标准进1',
sort: '2',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'FirstStandardOut',
filterdelay: 50000,
text: '标准出1',
sort: '3',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'SecondStandardIn',
filterdelay: 50000,
text: '标准进2',
sort: '4',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'SecondStandardOut',
filterdelay: 50000,
text: '标准出2',
sort: '5',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'FirstActualIn',
filterdelay: 50000,
text: '实际进1',
sort: '6',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'FirstActualOut',
filterdelay: 50000,
text: '实际出1',
sort: '7',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'SecondActualIn',
filterdelay: 50000,
text: '实际进2',
sort: '8',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'SecondActualOut',
filterdelay: 50000,
text: '实际出2',
sort: '9',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'HH:mm',
},
{
datafield: 'WorkHours',
filterdelay: 50000,
text: '排班小时',
sort: '10',
minwidth: '75',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'ActualWorkHours',
minwidth: '100',
filterdelay: 50000,
text: '实际工作小时',
sort: '11',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'FirstLate',
filterdelay: 50000,
text: '迟到分钟1',
sort: '11',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'FirstLeaveEarly',
filterdelay: 50000,
text: '早退分钟1',
sort: '12',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'SecondLate',
filterdelay: 50000,
text: '迟到分钟2',
sort: '13',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'SecondLeaveEarly',
filterdelay: 50000,
text: '早退分钟2',
sort: '14',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'MissCardNum',
filterdelay: 50000,
text: '缺卡次数',
sort: '15',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'AbsentHours',
filterdelay: 50000,
text: '旷工小时',
sort: '16',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'FristLeaveType',
filterdelay: 50000,
text: '请假类型1',
sort: '17',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'FristLeaveHours',
filterdelay: 50000,
text: '请假小时1',
sort: '18',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'SecondLeaveType',
filterdelay: 50000,
text: '请假类型2',
sort: '19',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'SecondLeaveHours',
filterdelay: 50000,
text: '请假小时2',
sort: '20',
minwidth: '78',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTNormal',
filterdelay: 50000,
text: '平时调休加班',
sort: '21',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTOFF',
filterdelay: 50000,
text: '休息调休加班',
sort: '22',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTPH',
filterdelay: 50000,
text: '节日调休加班',
sort: '23',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTNormalPay',
filterdelay: 50000,
text: '平时支付加班',
sort: '24',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTOFFPay',
filterdelay: 50000,
text: '休息支付加班',
sort: '25',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'OTPHPay',
filterdelay: 50000,
text: '节日支付加班',
sort: '26',
minwidth: '100',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'ExtOTHours',
filterdelay: 50000,
text: '内部加班',
sort: '27',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'ExtLeaveHours',
filterdelay: 50000,
text: '内部调休',
sort: '28',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
},
},
{
datafield: 'IsForced',
filterdelay: 50000,
text: '强制分析',
sort: '29',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
var str = '';
if (value == true) {
str = '是';
} else {
str = '否';
}
return '<div class=\'row30 text-center\'>' + str + '</div>';
},
},
{
datafield: 'VGUID',
filterdelay: 50000,
text: '修正记录',
sort: '29',
minwidth: '70',
align: 'center',
cellsalign: 'center',
hidden: false,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsrenderer: function (index, column, value, html, cellInfo, row) {
return '<div class=\'text-center row30\' ><a class=\'showdiv click \' data-id=\'' + row.VGUID + '\' data-date=\'' + row.Date + '\' ><span class=\'iconfont icon-historyrecode\' title=\'修正记录\'></span></a></div>';
},
},
{
datafield: 'UserId',
filterdelay: 50000,
sort: '30',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
},
{
datafield: 'Sort',
filterdelay: 50000,
sort: '31',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
},
{
datafield: 'Founder',
filterdelay: 50000,
sort: '32',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
},
{
datafield: 'CreateTime',
filterdelay: 50000,
sort: '33',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'yyyy-MM-dd',
filtertype: 'range',
},
{
datafield: 'ModifiedBy',
filterdelay: 50000,
sort: '34',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
},
{
datafield: 'ModifiedTime',
filterdelay: 50000,
sort: '35',
align: 'center',
cellsalign: 'center',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
cellsformat: 'yyyy-MM-dd',
filtertype: 'range',
},
{
datafield: 'REMARK',
filterdelay: 50000,
sort: '37',
align: 'center',
cellsalign: 'left',
hidden: true,
sortable: true,
filterable: true,
pinned: false,
editable: false,
}
]
});
}