1 $("#jqxGridByAttendanceDetail").on("bindingcomplete", function (event) {
2 // your code here.
3 changeStyle();
4 });
5
6 function changeStyle() {
7 var cellsrenderer = function (index, column, value, html, cellInfo, row) {
8 if (row.RestType == "0") {//假
9 return $(html).addClass("red").append("<sup> 假</sup>").prop("outerHTML");
10 }
11 if (row.RestType == "1") {//休
12 return $(html).addClass("red").append("<sup> 休</sup>").prop("outerHTML");
13 }
14 if (row.RestType == "2") {//正常
15 return $(html).append("<sup> </sup>").prop("outerHTML");
16 }
17 };
18 //重置列配置
19 $('#jqxGridByAttendanceDetail').jqxGrid({
20 columns: [
21 {
22 datafield: 'Date',
23 filterdelay: 50000,
24 text: '日期',
25 sort: '0',
26 minwidth: '90',
27 align: 'center',
28 cellsalign: 'center',
29 hidden: false,
30 sortable: true,
31 filterable: true,
32 pinned: true,
33 editable: false,
34 cellsformat: 'yyyy-MM-dd',
35 filtertype: 'range',
36 cellsrenderer: cellsrenderer
37 },
38 {
39 datafield: 'ShiftCode',
40 filterdelay: 50000,
41 text: '班次',
42 sort: '1',
43 minwidth: '70',
44 align: 'center',
45 cellsalign: 'center',
46 hidden: false,
47 sortable: true,
48 filterable: true,
49 pinned: true,
50 editable: false,
51 },
52 {
53 datafield: 'FirstStandardIn',
54 filterdelay: 50000,
55 text: '标准进1',
56 sort: '2',
57 minwidth: '70',
58 align: 'center',
59 cellsalign: 'center',
60 hidden: false,
61 sortable: true,
62 filterable: true,
63 pinned: false,
64 editable: false,
65 cellsformat: 'HH:mm',
66 },
67 {
68 datafield: 'FirstStandardOut',
69 filterdelay: 50000,
70 text: '标准出1',
71 sort: '3',
72 minwidth: '70',
73 align: 'center',
74 cellsalign: 'center',
75 hidden: false,
76 sortable: true,
77 filterable: true,
78 pinned: false,
79 editable: false,
80 cellsformat: 'HH:mm',
81 },
82 {
83 datafield: 'SecondStandardIn',
84 filterdelay: 50000,
85 text: '标准进2',
86 sort: '4',
87 minwidth: '70',
88 align: 'center',
89 cellsalign: 'center',
90 hidden: false,
91 sortable: true,
92 filterable: true,
93 pinned: false,
94 editable: false,
95 cellsformat: 'HH:mm',
96 },
97 {
98 datafield: 'SecondStandardOut',
99 filterdelay: 50000,
100 text: '标准出2',
101 sort: '5',
102 minwidth: '70',
103 align: 'center',
104 cellsalign: 'center',
105 hidden: false,
106 sortable: true,
107 filterable: true,
108 pinned: false,
109 editable: false,
110 cellsformat: 'HH:mm',
111 },
112 {
113 datafield: 'FirstActualIn',
114 filterdelay: 50000,
115 text: '实际进1',
116 sort: '6',
117 minwidth: '70',
118 align: 'center',
119 cellsalign: 'center',
120 hidden: false,
121 sortable: true,
122 filterable: true,
123 pinned: false,
124 editable: false,
125 cellsformat: 'HH:mm',
126 },
127 {
128 datafield: 'FirstActualOut',
129 filterdelay: 50000,
130 text: '实际出1',
131 sort: '7',
132 minwidth: '70',
133 align: 'center',
134 cellsalign: 'center',
135 hidden: false,
136 sortable: true,
137 filterable: true,
138 pinned: false,
139 editable: false,
140 cellsformat: 'HH:mm',
141 },
142 {
143 datafield: 'SecondActualIn',
144 filterdelay: 50000,
145 text: '实际进2',
146 sort: '8',
147 minwidth: '70',
148 align: 'center',
149 cellsalign: 'center',
150 hidden: false,
151 sortable: true,
152 filterable: true,
153 pinned: false,
154 editable: false,
155 cellsformat: 'HH:mm',
156 },
157 {
158 datafield: 'SecondActualOut',
159 filterdelay: 50000,
160 text: '实际出2',
161 sort: '9',
162 minwidth: '70',
163 align: 'center',
164 cellsalign: 'center',
165 hidden: false,
166 sortable: true,
167 filterable: true,
168 pinned: false,
169 editable: false,
170 cellsformat: 'HH:mm',
171 },
172 {
173 datafield: 'WorkHours',
174 filterdelay: 50000,
175 text: '排班小时',
176 sort: '10',
177 minwidth: '75',
178 align: 'center',
179 cellsalign: 'center',
180 hidden: false,
181 sortable: true,
182 filterable: true,
183 pinned: false,
184 editable: false,
185 cellsrenderer: function (index, column, value, html, cellInfo, row) {
186 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
187 },
188 },
189 {
190 datafield: 'ActualWorkHours',
191 minwidth: '100',
192 filterdelay: 50000,
193 text: '实际工作小时',
194 sort: '11',
195 align: 'center',
196 cellsalign: 'center',
197 hidden: false,
198 sortable: true,
199 filterable: true,
200 pinned: false,
201 editable: false,
202 cellsrenderer: function (index, column, value, html, cellInfo, row) {
203 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
204 },
205 },
206 {
207 datafield: 'FirstLate',
208 filterdelay: 50000,
209 text: '迟到分钟1',
210 sort: '11',
211 minwidth: '78',
212 align: 'center',
213 cellsalign: 'center',
214 hidden: false,
215 sortable: true,
216 filterable: true,
217 pinned: false,
218 editable: false,
219 cellsrenderer: function (index, column, value, html, cellInfo, row) {
220 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
221 },
222 },
223 {
224 datafield: 'FirstLeaveEarly',
225 filterdelay: 50000,
226 text: '早退分钟1',
227 sort: '12',
228 minwidth: '78',
229 align: 'center',
230 cellsalign: 'center',
231 hidden: false,
232 sortable: true,
233 filterable: true,
234 pinned: false,
235 editable: false,
236 cellsrenderer: function (index, column, value, html, cellInfo, row) {
237 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
238 },
239 },
240 {
241 datafield: 'SecondLate',
242 filterdelay: 50000,
243 text: '迟到分钟2',
244 sort: '13',
245 minwidth: '78',
246 align: 'center',
247 cellsalign: 'center',
248 hidden: false,
249 sortable: true,
250 filterable: true,
251 pinned: false,
252 editable: false,
253 cellsrenderer: function (index, column, value, html, cellInfo, row) {
254 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
255 },
256 },
257 {
258 datafield: 'SecondLeaveEarly',
259 filterdelay: 50000,
260 text: '早退分钟2',
261 sort: '14',
262 minwidth: '78',
263 align: 'center',
264 cellsalign: 'center',
265 hidden: false,
266 sortable: true,
267 filterable: true,
268 pinned: false,
269 editable: false,
270 cellsrenderer: function (index, column, value, html, cellInfo, row) {
271 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
272 },
273 },
274 {
275 datafield: 'MissCardNum',
276 filterdelay: 50000,
277 text: '缺卡次数',
278 sort: '15',
279 minwidth: '70',
280 align: 'center',
281 cellsalign: 'center',
282 hidden: false,
283 sortable: true,
284 filterable: true,
285 pinned: false,
286 editable: false,
287 cellsrenderer: function (index, column, value, html, cellInfo, row) {
288 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
289 },
290 },
291 {
292 datafield: 'AbsentHours',
293 filterdelay: 50000,
294 text: '旷工小时',
295 sort: '16',
296 minwidth: '70',
297 align: 'center',
298 cellsalign: 'center',
299 hidden: false,
300 sortable: true,
301 filterable: true,
302 pinned: false,
303 editable: false,
304 cellsrenderer: function (index, column, value, html, cellInfo, row) {
305 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
306 },
307 },
308 {
309 datafield: 'FristLeaveType',
310 filterdelay: 50000,
311 text: '请假类型1',
312 sort: '17',
313 minwidth: '78',
314 align: 'center',
315 cellsalign: 'center',
316 hidden: false,
317 sortable: true,
318 filterable: true,
319 pinned: false,
320 editable: false,
321 cellsrenderer: function (index, column, value, html, cellInfo, row) {
322 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
323 },
324 },
325 {
326 datafield: 'FristLeaveHours',
327 filterdelay: 50000,
328 text: '请假小时1',
329 sort: '18',
330 minwidth: '78',
331 align: 'center',
332 cellsalign: 'center',
333 hidden: false,
334 sortable: true,
335 filterable: true,
336 pinned: false,
337 editable: false,
338 cellsrenderer: function (index, column, value, html, cellInfo, row) {
339 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
340 },
341 },
342 {
343 datafield: 'SecondLeaveType',
344 filterdelay: 50000,
345 text: '请假类型2',
346 sort: '19',
347 minwidth: '78',
348 align: 'center',
349 cellsalign: 'center',
350 hidden: false,
351 sortable: true,
352 filterable: true,
353 pinned: false,
354 editable: false,
355 cellsrenderer: function (index, column, value, html, cellInfo, row) {
356 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
357 },
358 },
359 {
360 datafield: 'SecondLeaveHours',
361 filterdelay: 50000,
362 text: '请假小时2',
363 sort: '20',
364 minwidth: '78',
365 align: 'center',
366 cellsalign: 'center',
367 hidden: false,
368 sortable: true,
369 filterable: true,
370 pinned: false,
371 editable: false,
372 cellsrenderer: function (index, column, value, html, cellInfo, row) {
373 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
374 },
375 },
376 {
377 datafield: 'OTNormal',
378 filterdelay: 50000,
379 text: '平时调休加班',
380 sort: '21',
381 minwidth: '100',
382 align: 'center',
383 cellsalign: 'center',
384 hidden: false,
385 sortable: true,
386 filterable: true,
387 pinned: false,
388 editable: false,
389 cellsrenderer: function (index, column, value, html, cellInfo, row) {
390 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
391 },
392 },
393 {
394 datafield: 'OTOFF',
395 filterdelay: 50000,
396 text: '休息调休加班',
397 sort: '22',
398 minwidth: '100',
399 align: 'center',
400 cellsalign: 'center',
401 hidden: false,
402 sortable: true,
403 filterable: true,
404 pinned: false,
405 editable: false,
406 cellsrenderer: function (index, column, value, html, cellInfo, row) {
407 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
408 },
409 },
410 {
411 datafield: 'OTPH',
412 filterdelay: 50000,
413 text: '节日调休加班',
414 sort: '23',
415 minwidth: '100',
416 align: 'center',
417 cellsalign: 'center',
418 hidden: false,
419 sortable: true,
420 filterable: true,
421 pinned: false,
422 editable: false,
423 cellsrenderer: function (index, column, value, html, cellInfo, row) {
424 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
425 },
426 },
427 {
428 datafield: 'OTNormalPay',
429 filterdelay: 50000,
430 text: '平时支付加班',
431 sort: '24',
432 minwidth: '100',
433 align: 'center',
434 cellsalign: 'center',
435 hidden: false,
436 sortable: true,
437 filterable: true,
438 pinned: false,
439 editable: false,
440 cellsrenderer: function (index, column, value, html, cellInfo, row) {
441 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
442 },
443 },
444 {
445 datafield: 'OTOFFPay',
446 filterdelay: 50000,
447 text: '休息支付加班',
448 sort: '25',
449 minwidth: '100',
450 align: 'center',
451 cellsalign: 'center',
452 hidden: false,
453 sortable: true,
454 filterable: true,
455 pinned: false,
456 editable: false,
457 cellsrenderer: function (index, column, value, html, cellInfo, row) {
458 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
459 },
460 },
461 {
462 datafield: 'OTPHPay',
463 filterdelay: 50000,
464 text: '节日支付加班',
465 sort: '26',
466 minwidth: '100',
467 align: 'center',
468 cellsalign: 'center',
469 hidden: false,
470 sortable: true,
471 filterable: true,
472 pinned: false,
473 editable: false,
474 cellsrenderer: function (index, column, value, html, cellInfo, row) {
475 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
476 },
477 },
478 {
479 datafield: 'ExtOTHours',
480 filterdelay: 50000,
481 text: '内部加班',
482 sort: '27',
483 minwidth: '70',
484 align: 'center',
485 cellsalign: 'center',
486 hidden: false,
487 sortable: true,
488 filterable: true,
489 pinned: false,
490 editable: false,
491 cellsrenderer: function (index, column, value, html, cellInfo, row) {
492 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
493 },
494 },
495 {
496 datafield: 'ExtLeaveHours',
497 filterdelay: 50000,
498 text: '内部调休',
499 sort: '28',
500 minwidth: '70',
501 align: 'center',
502 cellsalign: 'center',
503 hidden: false,
504 sortable: true,
505 filterable: true,
506 pinned: false,
507 editable: false,
508 cellsrenderer: function (index, column, value, html, cellInfo, row) {
509 return '<div class=\'row30 text-center\' >' + (value == '0' ? '' : value) + '</div>';
510 },
511 },
512 {
513 datafield: 'IsForced',
514 filterdelay: 50000,
515 text: '强制分析',
516 sort: '29',
517 minwidth: '70',
518 align: 'center',
519 cellsalign: 'center',
520 hidden: false,
521 sortable: true,
522 filterable: true,
523 pinned: false,
524 editable: false,
525 cellsrenderer: function (index, column, value, html, cellInfo, row) {
526 var str = '';
527 if (value == true) {
528 str = '是';
529 } else {
530 str = '否';
531 }
532 return '<div class=\'row30 text-center\'>' + str + '</div>';
533 },
534 },
535 {
536 datafield: 'VGUID',
537 filterdelay: 50000,
538 text: '修正记录',
539 sort: '29',
540 minwidth: '70',
541 align: 'center',
542 cellsalign: 'center',
543 hidden: false,
544 sortable: true,
545 filterable: true,
546 pinned: false,
547 editable: false,
548 cellsrenderer: function (index, column, value, html, cellInfo, row) {
549 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>';
550 },
551 },
552 {
553 datafield: 'UserId',
554 filterdelay: 50000,
555 sort: '30',
556 align: 'center',
557 cellsalign: 'center',
558 hidden: true,
559 sortable: true,
560 filterable: true,
561 pinned: false,
562 editable: false,
563 },
564 {
565 datafield: 'Sort',
566 filterdelay: 50000,
567 sort: '31',
568 align: 'center',
569 cellsalign: 'center',
570 hidden: true,
571 sortable: true,
572 filterable: true,
573 pinned: false,
574 editable: false,
575 },
576 {
577 datafield: 'Founder',
578 filterdelay: 50000,
579 sort: '32',
580 align: 'center',
581 cellsalign: 'center',
582 hidden: true,
583 sortable: true,
584 filterable: true,
585 pinned: false,
586 editable: false,
587 },
588 {
589 datafield: 'CreateTime',
590 filterdelay: 50000,
591 sort: '33',
592 align: 'center',
593 cellsalign: 'center',
594 hidden: true,
595 sortable: true,
596 filterable: true,
597 pinned: false,
598 editable: false,
599 cellsformat: 'yyyy-MM-dd',
600 filtertype: 'range',
601 },
602 {
603 datafield: 'ModifiedBy',
604 filterdelay: 50000,
605 sort: '34',
606 align: 'center',
607 cellsalign: 'center',
608 hidden: true,
609 sortable: true,
610 filterable: true,
611 pinned: false,
612 editable: false,
613 },
614 {
615 datafield: 'ModifiedTime',
616 filterdelay: 50000,
617 sort: '35',
618 align: 'center',
619 cellsalign: 'center',
620 hidden: true,
621 sortable: true,
622 filterable: true,
623 pinned: false,
624 editable: false,
625 cellsformat: 'yyyy-MM-dd',
626 filtertype: 'range',
627 },
628 {
629 datafield: 'REMARK',
630 filterdelay: 50000,
631 sort: '37',
632 align: 'center',
633 cellsalign: 'left',
634 hidden: true,
635 sortable: true,
636 filterable: true,
637 pinned: false,
638 editable: false,
639 }
640 ]
641 });
642 }
浙公网安备 33010602011771号