jquery widgets grid 重置列配置

  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>&nbsp;&nbsp;&nbsp;&nbsp;</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 }