1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
| -- 初始化菜单脚本
| INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort,
| category, action, is_open, remark, is_deleted, belong_application, keep_alive)
| VALUES (2, 0, 'mdc', '采集分析', 'mdc', '/mdc', 'iconfont saber-caijifenxi', 4, 0, 0, 1, NULL, 0, 'CPS', 1),
| (1475640981749178369, 2, 'time_cost', '用时分析', 'time_cost', '/mdc/time-analysis', 'iconfont iconicon_compile', 4,
| 1, 0, 1, '', 0, 'CPS', 1),
| (1475761204784312321, 2, 'settings', '应用设置', 'settings', '/mdc/configuration', 'iconfont iconicon_setting', 9, 1,
| 0, 1, '', 0, 'CPS', 1),
| (1476448719033671682, 2, 'realtime_status', '实时看板', 'realtime_status', '/mdc/realtime-status/index',
| 'iconfont iconicon_work', 1, 1, 0, 1, '', 0, 'CPS', 1),
| (1476789818350559234, 2, 'workstation_data', '工位数据', 'workstation_data', '/mdc/station-live',
| 'iconfont iconicon_setting', 2, 1, 0, 1, '', 0, 'CPS', 1),
| (1498471500208750594, 2, 'collected_data', '过程参数', 'collected_data', '/mdc/processParam/index',
| 'iconfont iconicon_work', 8, 1, 0, 1, '', 0, 'CPS', 1),
| (1498900340410212354, 2, 'efficiency', '效率分析', 'efficiency', '/mdc/efficiency-analysis',
| 'iconfont iconicon_im_keyboard', 5, 1, 0, 1, '', 0, 'CPS', 1),
| (1502512819019243521, 2, 'state_record', '状态记录', 'state_record', '/mdc/status-record',
| 'iconfont iconicon_compile', 3, 1, 0, 1, '', 0, 'CPS', 1),
| (1503199291613646849, 2, 'output_statistics', '产量统计', 'output_statistics', '/mdc/output-statistics',
| 'iconfont iconicon_doc', 6, 1, 0, 1, '', 0, 'CPS', 1),
| (1503250876000481282, 2, 'alarm_statistics', '报警统计', 'alarm_statistics', '/mdc/alarm-statistics',
| 'iconfont iconicon_addressbook', 7, 1, 0, 1, '', 0, 'CPS', 1),
| (1567052674289815553, 2, 'state_feedback', '状态反馈', 'state-feedback', '/mdc/state-feedback', '', 0, 1, 0, 1, '',
| 0, 'CPS', 1),
| (1519581462658793473, 2, 'mdcShape', '状态分布占比', 'card', '', 'iconfont iconicon_send', 11, 3, 0, 1, '', 0, 'CPS',
| 1),
| (1519582181226954753, 2, 'mdcRunning', '设备运行时长排名', 'card', '', 'iconfont iconicon_send', 12, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1519582337473167362, 2, 'mdcStandby', '设备待机时长排名', 'card', '', 'iconfont iconicon_send', 13, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1519582580134625281, 2, 'mdcEquipmentRun', '设备稼动率排名', 'card', '', 'iconfont iconicon_send', 14, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1519582680160387073, 2, 'mdcEquipment', '设备稼动率', 'card', '', 'iconfont iconicon_send', 15, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1519583068544548865, 2, 'mdcWorktime', '班次-设备平均运行时长', 'card', '', 'iconfont iconicon_send', 16, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1519583197167075330, 2, 'mdcDeviceStatus', '设备状态统计', 'card', '', 'iconfont iconicon_send', 17, 3, 0, 1, '', 0,
| 'CPS', 1),
| (1585555062296231937, 0, 'hmi_feedback', '状态反馈', 'hmi_feedback', '/feedback', '', 3, 1, 0, 1, '', 0, 'HMI', 1);
|
| INSERT INTO blade_interface_config(id, status, is_deleted, create_user, create_dept,
| create_time,
| update_user, update_time, url, url_name, url_type,
| owning_chart)
| VALUES (1503622248980602882, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-15 14:40:55', 1123598821738675201,
| '2022-03-28 16:33:59', '/api/blade-visual/status/workstation-status', '工位状态实时数据', 0, '5'),
| (1504617457159569409, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-18 08:35:31', 1123598821738675201,
| '2022-03-21 10:22:24', '/api/blade-visual/status/record', '状态记录', 0, '4'),
| (1505743564599066626, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:10:16', 1123598821738675201,
| '2022-03-21 13:46:23', '/api/blade-visual/status/running-top', '设备运行时长排名', 0, '2'),
| (1505750036709695489, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:35:59', 1123598821738675201,
| '2022-03-21 13:52:32', '/api/blade-visual/status/distribution', '状态分布饼图', 0, '1'),
| (1505778256626110465, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 13:28:07', 1123598821738675201,
| '2022-03-22 16:43:26', '/api/blade-visual/status/waiting-top', '设备待机时长排名', 0, '2'),
| (1505815193831014402, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 15:54:54', 1123598821738675201,
| '2022-03-22 08:30:53', '/api/blade-visual/status/oee', '设备稼动率', 0, '1'),
| (1506187218116005890, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:33:11', 1123598821738675201,
| '2022-03-23 19:50:58', '/api/blade-visual/output/hours', '获取设备近n小时产量', 0, '2'),
| (1506187701408878594, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:35:06', 1123598821738675201,
| '2022-03-23 19:50:41', '/api/blade-visual/output/days', '获取设备近n天产量', 0, '2'),
| (1506459787743137794, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:36:17', 1123598821738675201,
| '2022-03-23 10:48:55', '/api/blade-visual/status/oee-top', '设备前n小时稼动率排名', 0, '2'),
| (1506465149816868866, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:57:35', 1123598821738675201,
| '2022-03-25 14:28:34', '/api/blade-visual/status/oee-shift-top', '班次稼动率排名', 0, '2'),
| (1506890468800016385, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-24 15:07:39', 1123598821738675201,
| '2022-03-24 15:07:39', '/api/blade-visual/output/shift-index-output', '班次产量统计', 0, '2'),
| (1507240354667880450, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 14:17:58', 1123598821738675201,
| '2022-03-25 14:49:58', '/api/blade-visual/status/oee-average', '班次设备平均稼动率', 0, '1'),
| (1507249835722412033, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 14:55:39', 1123598821738675201,
| '2022-03-25 15:01:47', '/api/blade-visual/status/group-running', '班次-设备平均运行时长', 0, '1'),
| (1511538380294787074, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-06 10:56:48', 1123598821738675201,
| '2022-04-06 11:00:47', '/api/blade-visual/status/workstation-alarm', '工位实时报警数据', 0, '5'),
| (1511910709614669825, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 11:36:18', 1123598821738675201,
| '2022-04-07 13:36:50', '/api/blade-visual/status/nature-record', '当日设备状态记录', 0, '4'),
| (1511967276235608066, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 15:21:04', 1123598821738675201,
| '2022-04-07 15:21:04', '/api/blade-visual/status/today-distribution', '当日状态分布饼图', 0, '1'),
| (1511974011134398466, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 15:47:50', 1123598821738675201,
| '2022-04-07 16:47:02', '/api/blade-visual/status/shift-distribution', '当前班次状态分布饼图', 0, '1'),
| (1512228264734470145, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-08 08:38:09', 1123598821738675201,
| '2022-04-08 08:38:09', '/api/blade-visual/status/shift-status-record', '当前班次设备状态记录', 0, '4'),
| (1511992448770494466, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 17:01:06', 1123598821738675201,
| '2022-04-08 09:43:22', '/api/blade-visual/status/today-oee', '自然日设备稼动率接口', 0, '2'),
| (1512244391821021186, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-08 09:42:14', 1123598821738675201,
| '2022-04-08 09:42:14', '/api/blade-visual/status/today-average-oee', '当日设备平均稼动率', 0, '1'),
| (1582983218196512770, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:33:04', 1123598821738675201,
| '2022-10-20 14:34:54', '/api/blade-visual/status/oee-month', '当月设备平均稼动率', 0, '1'),
| (1582983442512084994, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:33:58', 1123598821738675201,
| '2022-10-20 14:34:21', '/api/blade-visual/status/running-month', '当月设备平均运行率', 0, '1'),
| (1582983913133965313, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:35:50', 1123598821738675201,
| '2022-10-20 14:36:44', '/api/blade-visual/status/alarm-month', '月设备报警时长排名', 0, '2'),
| (1582984237475299330, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:37:07', 1123598821738675201,
| '2022-10-20 14:37:26', '/api/blade-visual/status/alarm-week', '周设备报警时长排名', 0, '2'),
| (1594926910627840001, 1, 0, 1123598821738675201, 1123598813738675201, '2022-11-22 13:33:02', 1511620362033377282,
| '2022-12-01 15:12:23', '/api/blade-visual/status/workstation-status-chart', '工位状态统计饼图', 0, '1');
|
|
| INSERT INTO blade_interface_config_field(id, status, is_deleted, create_user, create_dept,
| create_time, update_user, update_time, config_id,
| label, name, is_required, data_type, data_source,
| is_single_choice, checked_parent, relation_field,
| method)
| VALUES (1503623217785135105, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-15 14:44:46', 1123598821738675201,
| '2022-03-25 15:48:48', 1503622248980602882, '工位组', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, 0, NULL, 'get'),
| (1504368575234985986, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-17 16:06:33', 1123598821738675201,
| '2022-03-25 12:49:07', 1503622131942744066, '长度', 'length', 1, 1, '', 0, NULL, '1507216718736613378', NULL),
| (1504617566207279106, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-18 08:35:57', 1123598821738675201,
| '2022-03-21 10:22:22', 1504617457159569409, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1504618898540527617, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-18 08:41:15', 1123598821738675201,
| '2022-03-21 10:19:00', 1504617457159569409, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1505744038861602818, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:12:09', 1123598821738675201,
| '2022-03-21 11:12:09', 1505743564599066626, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1505744188359180289, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:12:45', 1123598821738675201,
| '2022-03-21 13:46:17', 1505743564599066626, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1505744407851302914, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:13:37', 1123598821738675201,
| '2022-03-21 13:46:22', 1505743564599066626, '设备TOP', 'top', 1, 2, '/api/blade-visual/data-source/time-level', 1,
| NULL, NULL, NULL),
| (1505751188071309313, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:40:33', 1123598821738675201,
| '2022-03-21 11:40:33', 1505750036709695489, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1505751345227685890, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 11:41:11', 1123598821738675201,
| '2022-03-21 11:41:11', 1505750036709695489, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1505778267208339458, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 13:28:10', 1123598821738675201,
| '2022-03-22 16:43:32', 1505778256626110465, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1505778395054919681, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 13:28:40', 1123598821738675201,
| '2022-03-21 13:46:36', 1505778256626110465, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1505778549048791042, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 13:29:17', 1123598821738675201,
| '2022-03-21 13:46:40', 1505778256626110465, '设备TOP', 'top', 1, 2, '/api/blade-visual/data-source/time-level', 1,
| NULL, NULL, NULL),
| (1505815205591842817, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 15:54:56', 1123598821738675201,
| '2022-03-21 15:54:56', 1505815193831014402, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1505815314400477185, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-21 15:55:22', 1123598821738675201,
| '2022-03-21 15:55:22', 1505815193831014402, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1506131274436476930, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 12:50:53', 1123598821738675201,
| '2022-03-22 12:56:11', 1506131249018994690, '工位组', 'groupId', 0, 2, '/api/blade-cps/group/list', 0, NULL, NULL,
| NULL),
| (1506187225422483458, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:33:13', 1123598821738675201,
| '2022-03-23 19:41:59', 1506187218116005890, '工位id', 'workStationId', 1, 4,
| '/api/blade-visual/data-source/workstation', 1, NULL, NULL, NULL),
| (1506187385422598146, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:33:51', 1123598821738675201,
| '2022-03-22 16:33:51', 1506187218116005890, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1506187705791926274, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:35:07', 1123598821738675201,
| '2022-03-23 19:50:26', 1506187701408878594, '工位id', 'workStationId', 1, 4,
| '/api/blade-visual/data-source/workstation', 1, NULL, NULL, NULL),
| (1506187871815061506, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-22 16:35:47', 1123598821738675201,
| '2022-03-22 16:35:47', 1506187701408878594, '近n天', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1506460470621966338, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:39:00', 1123598821738675201,
| '2022-03-23 10:39:56', 1506459787743137794, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1506460658841358337, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:39:44', 1123598821738675201,
| '2022-03-23 10:39:44', 1506459787743137794, '近n小时', 'timeLevel', 1, 2,
| '/api/blade-visual/data-source/time-level', 1, NULL, NULL, NULL),
| (1506461886275063810, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:44:37', 1123598821738675201,
| '2022-03-23 10:44:37', 1506459787743137794, '设备TOP', 'top', 1, 2, '/api/blade-visual/data-source/time-level', 1,
| NULL, NULL, NULL),
| (1506465357900484609, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 10:58:25', 1123598821738675201,
| '2022-03-25 14:19:38', 1506465149816868866, '设备TOP', 'top', 1, 2, '/api/blade-visual/data-source/time-level', 1,
| NULL, NULL, NULL),
| (1506465911997403137, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 11:00:37', 1123598821738675201,
| '2022-03-25 14:38:39', 1506465149816868866, '班制', 'shift', 1, 2, '/api/blade-visual/data-source/shift-system',
| 1, NULL, NULL, NULL),
| (1506466187336683521, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-23 11:01:43', 1123598821738675201,
| '2022-03-25 14:28:25', 1506465149816868866, '班制设备', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/shift-workstation', 0, NULL, '1506465911997403137', NULL),
| (1506890474181308418, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-24 15:07:40', 1123598821738675201,
| '2022-03-24 15:07:40', 1506890468800016385, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1507218852458774530, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 12:52:32', 1123598821738675201,
| '2022-03-25 12:52:32', 1503622131942744066, '文本', 'text', 0, 0, NULL, 0, NULL, '1504368575234985986', '0'),
| (1507240571525980161, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 14:18:50', 1123598821738675201,
| '2022-03-25 14:18:50', 1507240354667880450, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1507251077286727682, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 15:00:35', 1123598821738675201,
| '2022-03-25 15:00:35', 1507249835722412033, '班制', 'shift', 1, 2, '/api/blade-visual/data-source/shift-system',
| 1, NULL, NULL, NULL),
| (1507251361622790145, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-25 15:01:43', 1123598821738675201,
| '2022-03-25 15:01:43', 1507249835722412033, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/shift-workstation', 0, NULL, '1507251077286727682', NULL),
| (1511539377767387138, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-06 11:00:45', 1123598821738675201,
| '2022-04-06 11:00:45', 1511538380294787074, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, 'post'),
| (1511941033446420482, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 13:36:48', 1123598821738675201,
| '2022-04-07 13:36:48', 1511910709614669825, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1511967282682253313, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 15:21:06', 1123598821738675201,
| '2022-04-07 15:21:06', 1511967276235608066, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1511995684532428802, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 17:13:57', 1123598821738675201,
| '2022-04-07 17:13:57', 1511974011134398466, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1512228270551969794, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-08 08:38:10', 1123598821738675201,
| '2022-04-08 08:38:10', 1512228264734470145, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1511992673102843905, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-07 17:01:59', 1123598821738675201,
| '2022-04-07 17:01:59', 1511992448770494466, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1512244589997690882, 1, 0, 1123598821738675201, 1123598813738675201, '2022-04-08 09:43:01', 1123598821738675201,
| '2022-04-08 09:43:01', 1512244391821021186, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL),
| (1582983223846240257, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:33:06', 1123598821738675201,
| '2022-10-20 14:33:06', 1582983218196512770, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, null, null, null),
| (1582983523818668033, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:34:17', 1123598821738675201,
| '2022-10-20 14:34:17', 1582983442512084994, '工位', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, null, null, null),
| (1582983991907188737, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:36:09', 1123598821738675201,
| '2022-10-20 14:36:09', 1582983913133965313, '工位', 'workStationIdList', 0, 4,
| '/api/blade-visual/data-source/workstation', 0, null, null, null),
| (1582984313253789697, 1, 0, 1123598821738675201, 1123598813738675201, '2022-10-20 14:37:25', 1123598821738675201,
| '2022-10-20 14:37:25', 1582984237475299330, '工位', 'workStationIdList', 0, 4,
| '/api/blade-visual/data-source/workstation', 0, null, null, null),
| (1594927254296526849, 1, 0, 1123598821738675201, 1123598813738675201, '2022-11-22 13:34:24', 1511620362033377282,
| '2022-12-01 15:12:22', 1594926910627840001, '工位ID', 'workStationIdList', 1, 4,
| '/api/blade-visual/data-source/workstation', 0, NULL, NULL, NULL);
|
| INSERT INTO jimu_dict(id, dict_name, dict_code, description, del_flag, create_by, create_time, update_by, update_time,
| type)
| VALUES ('707025839572508672', '时间周期', 'dateCycle', null, 0, 'admin', '2022-07-13 10:35:06.000000', null, null, null),
| ('707403397956354048', '班次', 'shiftName', null, 0, 'admin', '2022-07-14 11:35:23.000000', null, null, null),
| ('707470863329792000', '数据名称', 'productivityType', null, 0, 'admin', '2022-07-14 16:03:28.000000', 'admin',
| '2022-07-15 18:28:11.000000', null);
|
|
| INSERT INTO jimu_dict_item(id, dict_id, item_text, item_value, description, sort_order, status, create_by, create_time,
| update_by, update_time)
| VALUES ('707025981486784512', '707025839572508672', '按日', '2', null, 1, 1, 'admin', '2022-07-13 10:35:40.000000', null,
| null),
| ('707026020959379456', '707025839572508672', '按周', '3', null, 2, 1, 'admin', '2022-07-13 10:35:50.000000', null,
| null),
| ('707026056464162816', '707025839572508672', '按月', '4', null, 3, 1, 'admin', '2022-07-13 10:35:58.000000', null,
| null),
| ('707403478516350976', '707403397956354048', '班次1', '1', null, 1, 1, 'admin', '2022-07-14 11:35:42.000000', null,
| null),
| ('707403515199733760', '707403397956354048', '班次2', '2', null, 1, 1, 'admin', '2022-07-14 11:35:51.000000', null,
| null),
| ('707403538511675392', '707403397956354048', '班次3', '3', null, 1, 1, 'admin', '2022-07-14 11:35:57.000000', null,
| null),
| ('707403564394725376', '707403397956354048', '班次4', '4', null, 1, 1, 'admin', '2022-07-14 11:36:03.000000', null,
| null),
| ('707726195796873216', '707470863329792000', '运行率', '1', null, 1, 1, 'admin', '2022-07-15 08:58:04.000000', null,
| null),
| ('707726244526297088', '707470863329792000', '报警率', '2', null, 1, 1, 'admin', '2022-07-15 08:58:16.000000', null,
| null),
| ('707726276738551808', '707470863329792000', '稼动率', '3', null, 1, 1, 'admin', '2022-07-15 08:58:24.000000', null,
| null);
|
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707023101616324608', '20220713105912', '时间周期--产量', null, null, 'datainfo',
| '{"loopBlockList":[],"area":{"sri":1,"sci":4,"eri":1,"eci":4,"width":160,"height":40},"excel_config_id":"707023101616324608","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","style":22,"rendered":"","config":""},"2":{"text":"工位名称","style":22,"rendered":"","config":""},"3":{"text":"工位组","style":22,"rendered":"","config":""},"4":{"direction":"right","text":"#{output.groupRight(dateCycle)}","style":22,"aggregate":"group","rendered":"","config":"","display":"normal"}},"height":40},"2":{"cells":{"1":{"text":"#{output.group(workstationCode)}","style":27,"aggregate":"group","sort":"desc","completeBlankStatus":false},"2":{"text":"#{output.group(workstationName)}","style":27,"aggregate":"group","sort":"desc","rendered":"","config":""},"3":{"text":"#{output.group(workstationGroup)}","style":27,"aggregate":"group","rendered":"","config":"","sort":"desc"},"4":{"text":"#{output.dynamic(outputCount)}","style":25,"aggregate":"dynamic","rendered":"","config":""}},"height":38},"len":3},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"output.workstationCode","freeze":"A1","dataRectWidth":1334,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"number"},{"format":"number"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#538136"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#71ae47"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#93d051"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#00b04e"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#ffffff"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#a7d08c"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#e3efd9"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":""},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 62%"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 62"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 6"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF "},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"left","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"right","font":{"size":9,"bold":true}}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":386},"2":{"width":386},"3":{"width":386},"4":{"width":160},"6":{"width":100},"len":50},"merges":[]}',
| null, null, 'admin', '2022-07-13 10:59:13.000000', 'admin', '2022-07-27 18:01:06.000000', 0, null, null, 0, 416,
| null,
| 'function init(){this.queryPanel=''1'';this.onSearchFormChange("output","dateCycle",(value)=>{console.log(value);var date=new Date();var yy=date.getFullYear();var mm=date.getMonth()<10?"0"+(new Date().getMonth()+1):new Date().getMonth()+1;var startDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate()-2;var endDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate();var start=yy+"-"+mm+"-"+startDay;var end=yy+"-"+mm+"-"+endDay;this.updateSearchFormValue("output","timeCondition",start+"|"+end)})}');
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707081699497730048', '202207131051026555', '工位报警报表（按时间）', null, null, 'datainfo',
| '{"loopBlockList":[],"area":false,"excel_config_id":"707081699497730048","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","merge":[1,0],"height":50,"style":28},"2":{"text":"工位名称","merge":[1,0],"height":50,"style":28},"3":{"merge":[1,0],"height":50,"text":"工位组","style":28},"4":{"merge":[1,0],"height":50,"style":29,"text":"报警次数"},"5":{"text":"#{alarmTime.groupRight(showDate)}","aggregate":"group","direction":"right","style":28,"subtotal":"-1","funcname":"-1"}},"height":40},"2":{"cells":{"5":{"text":"次数合计","style":28}},"height":40},"3":{"cells":{"1":{"text":"#{alarmTime.group(workstationCode)}","style":34,"aggregate":"group","sort":"desc"},"2":{"text":"#{alarmTime.group(workstationName)}","style":34,"aggregate":"group","sort":"desc"},"3":{"text":"#{alarmTime.group(workstationGroup)}","aggregate":"group","style":34,"sort":"desc"},"4":{"style":35,"text":"#{alarmTime.group(alarmCountSum)}","aggregate":"group","sort":"desc"},"5":{"text":"#{alarmTime.dynamic(alarmCount)}","aggregate":"dynamic","style":36,"funcname":"-1","subtotal":"-1","linkIds":"707399928057290752,707399928057290752","rendered":"","config":"","display":"link"}},"height":38},"4":{"cells":{"1":{"merge":[0,2],"height":25,"text":"总计","style":31},"4":{"style":32,"text":"=SUM(E3)"},"5":{"style":32,"text":"=SUM(F3)"}},"height":38},"len":77},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"10","btnList":[1,2,3,4,5,6,8]},"groupField":"alarmTime.workstationCode","freeze":"A1","dataRectWidth":1334,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"align":"center"},{"align":"center","border":{"bottom":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":false},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":14}},{"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":14,"bold":true}},{"font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":9,"bold":true}},{"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","textwrap":true,"valign":"middle","font":{"size":9,"bold":true}},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB","textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":333},"2":{"width":333},"3":{"width":332},"4":{"width":160},"5":{"width":160},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3","B5:D5"]}',
| null, null, 'admin', '2022-07-13 14:17:04.000000', 'admin', '2022-07-27 14:38:49.000000', 0, null, null, 0, 394,
| null,
| 'function init(){this.queryPanel=''1'';this.onSearchFormChange("alarmTime","dateCycle",(value)=>{console.log(value);var date=new Date();var yy=date.getFullYear();var mm=date.getMonth()<10?"0"+(new Date().getMonth()+1):new Date().getMonth()+1;var startDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate()-2;var endDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate();var start=yy+"-"+mm+"-"+startDay;var end=yy+"-"+mm+"-"+endDay;this.updateSearchFormValue("alarmTime","showDate",start+"|"+end)})}');
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707168303790407680', '20220713201009', '班次-产量', null, null, 'datainfo',
| '{"loopBlockList":[],"area":{"sri":2,"sci":1,"eri":2,"eci":1,"width":289,"height":38},"excel_config_id":"707168303790407680","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","style":12},"2":{"text":"工位名称","style":12},"3":{"text":"工位组","style":12},"4":{"text":"班次名称","style":12},"5":{"aggregate":"group","direction":"right","text":"#{output.groupRight(dateCycle)}","style":12}},"height":40},"2":{"cells":{"1":{"text":"#{output.group(workstationCode)}","aggregate":"group","style":16,"sort":"desc"},"2":{"text":"#{output.group(workstationName)}","aggregate":"group","style":16,"sort":"desc"},"3":{"text":"#{output.group(workstationGroup)}","aggregate":"group","style":16,"sort":"desc"},"4":{"aggregate":"group","text":"#{output.group(shiftName)}","style":16,"sort":"default"},"5":{"aggregate":"dynamic","style":15,"text":"#{output.dynamic(outputCount)}","sort":"asc"}},"height":38},"13":{"cells":{}},"14":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"output.workstationCode","freeze":"A1","dataRectWidth":1332,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#e3efd9"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":""},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 62%"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 62"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 6"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF "},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":289},"2":{"width":289},"3":{"width":289},"4":{"width":289},"5":{"width":160},"6":{"width":100},"len":50},"merges":[]}',
| null, null, 'admin', '2022-07-13 20:10:10.000000', 'dev', '2022-07-28 15:56:56.000000', 0, null, null, 0, 271,
| null, 'function init(){this.queryPanel=''1''}');
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707378988669853696', '20220714110613', '钻取报警按时间', null, null, 'datainfo',
| '{"loopBlockList":[],"area":false,"excel_config_id":"707378988669853696","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"报警日期","style":7},"2":{"text":"报警时间","style":7},"3":{"text":"报警代码","style":7},"4":{"text":"报警信息","style":7}},"height":40},"2":{"cells":{"1":{"text":"#{drillAlarmTime.group(showDate)}","aggregate":"group","style":8},"2":{"text":"#{drillAlarmTime.ts}","style":8},"3":{"text":"#{drillAlarmTime.alarmCode}","style":8},"4":{"text":"#{drillAlarmTime.alarmMsg}","style":8}},"height":38},"3":{"cells":{}},"4":{"cells":{}},"9":{"cells":{},"height":25},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"drillAlarmTime.showDate","freeze":"A1","dataRectWidth":1041,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":200},"2":{"width":200},"3":{"width":200},"4":{"width":425},"len":50},"merges":[]}',
| null, null, 'admin', '2022-07-14 11:06:14.000000', 'admin', '2022-07-27 14:38:03.000000', 0, null, null, 0, 69,
| null, null);
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707452299503865856', '20220714144957', '效率报表-按时间', null, null, 'datainfo',
| '{"loopBlockList":[],"area":{"sri":1,"sci":1,"eri":2,"eci":1,"width":300,"height":80},"excel_config_id":"707452299503865856","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"0":{"style":21,"text":" "},"1":{"style":21,"text":" "},"2":{"style":21,"text":" "},"3":{"style":21,"text":" "}},"height":18},"1":{"cells":{"0":{"style":21,"text":" "},"1":{"merge":[1,0],"height":50,"text":"工位编码","style":18},"2":{"merge":[1,0],"height":50,"text":"工位名称","style":18},"3":{"merge":[1,0],"height":50,"text":"工位组","style":18},"4":{"text":"#{efficiency.groupRight(time)}","aggregate":"group","direction":"right","style":18}},"height":40},"2":{"cells":{"0":{"style":21,"text":" "},"4":{"text":"#{efficiency.groupRight(type)}","aggregate":"group","direction":"right","style":18}},"height":40},"3":{"cells":{"0":{"style":21,"text":" "},"1":{"text":"#{efficiency.group(workstationCode)}","aggregate":"group","style":41,"sort":"desc"},"2":{"text":"#{efficiency.group(workstationName)}","aggregate":"group","style":41,"sort":"desc"},"3":{"text":"#{efficiency.group(workstationNameGroupName)}","aggregate":"group","style":41,"sort":"desc"},"4":{"text":"#{efficiency.dynamic(value)}","aggregate":"dynamic","style":43}},"height":38},"len":4},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"efficiency.workstationCode","freeze":"A1","dataRectWidth":1000,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#E"},{"bgcolor":"#E"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EF"},{"bgcolor":"#EF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFE"},{"bgcolor":"#EFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEF"},{"bgcolor":"#EFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFE"},{"bgcolor":"#EFEFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true}},{"font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":9}},{"font":{"bold":true,"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":12}},{"font":{"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10}},{"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":14}},{"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":false,"size":9}},{"font":{"bold":false}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true,"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"align":"right","font":{"size":9}}],"validations":[],"isGroup":true,"cols":{"0":{"width":18},"1":{"width":300},"2":{"width":300},"3":{"width":300},"4":{"width":82},"5":{"width":100},"6":{"width":141},"len":50},"merges":["B2:B3","C2:C3","D2:D3"]}',
| null, null, 'admin', '2022-07-14 14:49:58.000000', 'dev', '2022-07-28 10:44:32.000000', 0, null, null, 0, 285,
| null,
| 'function init(){this.queryPanel=''1'';this.onSearchFormChange("efficiency","dateCycle",(value)=>{console.log(value);var date=new Date();var yy=date.getFullYear();var mm=date.getMonth()<10?"0"+(new Date().getMonth()+1):new Date().getMonth()+1;var startDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate()-2;var endDay=new Date().getDate()<10?"0"+new Date().getDate():new Date().getDate();var start=yy+"-"+mm+"-"+startDay;var end=yy+"-"+mm+"-"+endDay;this.updateSearchFormValue("efficiency","time",start+"|"+end)})}');
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707479561238863872', '20220714170210', '钻取报警按班次', null, null, 'datainfo',
| '{"loopBlockList":[],"area":false,"excel_config_id":"707479561238863872","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"班次","style":7},"2":{"text":"班次名称","style":7},"3":{"text":"报警时间","style":7},"4":{"text":"报警代码","style":7},"5":{"text":"报警信息","style":7}},"height":40},"2":{"cells":{"1":{"text":"#{drillAlarmShift.group(shiftIndexName)}","aggregate":"group","style":8},"2":{"text":"#{drillAlarmShift.group(shiftName)}","aggregate":"group","style":8},"3":{"text":"#{drillAlarmShift.ts}","style":8},"4":{"text":"#{drillAlarmShift.alarmCode}","style":8},"5":{"text":"#{drillAlarmShift.alarmMsg}","style":8}},"height":38},"5":{"cells":{}},"6":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"drillAlarmShift.shiftIndexName","freeze":"A1","dataRectWidth":1041,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":120},"2":{"width":140},"3":{"width":160},"4":{"width":180},"5":{"width":425},"8":{"width":100},"9":{"width":100},"len":50},"merges":[]}',
| null, null, 'admin', '2022-07-14 17:02:11.000000', 'admin', '2022-07-27 14:37:37.000000', 0, null, null, 0, 61,
| null, null);
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707504177185415168', '20220714182839', '工位报警报表（按班次）', null, null, 'datainfo',
| '{"loopBlockList":[],"area":false,"excel_config_id":"707504177185415168","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"merge":[1,0],"height":50,"text":"工位编号","style":13},"2":{"merge":[1,0],"height":50,"text":"工位名称","style":13},"3":{"merge":[1,0],"height":50,"text":"工位组","style":13},"4":{"merge":[1,0],"height":50,"text":"班次","style":13},"5":{"merge":[1,0],"height":50,"text":"报警次数（合计）","style":13},"6":{"text":"#{alarmShift.groupRight(showDate)}","style":13,"aggregate":"group","direction":"right"}},"height":40},"2":{"cells":{"6":{"text":"当天合计","style":13}},"height":40},"3":{"cells":{"1":{"text":"#{alarmShift.group(workstationCode)}","style":18,"aggregate":"group","sort":"desc"},"2":{"text":"#{alarmShift.group(workstationName)}","style":18,"aggregate":"group","sort":"desc"},"3":{"text":"#{alarmShift.group(workstationGroup)}","style":21,"aggregate":"group","sort":"desc"},"4":{"text":"#{alarmShift.group(shiftName)}","style":18,"aggregate":"group","sort":"default"},"5":{"text":"#{alarmShift.group(alarmCountSum)}","style":19,"aggregate":"group","sort":"default"},"6":{"text":"#{alarmShift.dynamic(alarmCount)}","style":20,"aggregate":"dynamic","linkIds":"707513662478082048","rendered":"","config":"","display":"link","sort":"default"}},"height":38},"4":{"cells":{"1":{"merge":[0,3],"height":25,"text":"总计（次）","style":15},"5":{"text":"=SUM(F3)","style":16},"6":{"text":"=SUM(G3)","style":16}},"height":38},"5":{"cells":{}},"6":{"cells":{}},"7":{"cells":{}},"8":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"10","btnList":[1,2,3,4,5,6,8]},"groupField":"alarmShift.workstationCode","freeze":"A1","dataRectWidth":1335,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true,"valign":"middle"}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":250},"2":{"width":250},"3":{"width":249},"4":{"width":250},"5":{"width":160},"6":{"width":160},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3","F2:F3","B5:E5"]}',
| null, null, 'admin', '2022-07-14 18:28:40.000000', 'admin', '2022-07-27 14:37:16.000000', 0, null, null, 0, 289,
| null, 'function init(){this.queryPanel=''1''}');
| INSERT INTO "JIMU_REPORT"("ID", "CODE", "NAME", "NOTE", "STATUS", "TYPE", "JSON_STR", "API_URL", "THUMB", "CREATE_BY",
| "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "DEL_FLAG", "API_METHOD", "API_CODE", "TEMPLATE",
| "VIEW_COUNT", "CSS_STR", "JS_STR")
| VALUES ('707520139154034688', '202207141449579192', '效率报表-按班次', null, null, 'datainfo',
| '{"loopBlockList":[],"area":{"sri":1,"sci":1,"eri":3,"eci":5,"width":982,"height":118},"excel_config_id":"707520139154034688","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":16},"1":{"cells":{"0":{"text":""},"1":{"text":"工位编码","style":28,"merge":[1,0]},"2":{"text":"工位名称","style":28,"merge":[1,0]},"3":{"text":"工位组","style":28,"merge":[1,0]},"4":{"text":"班次","style":28,"merge":[1,0]},"5":{"text":"#{efficiency.groupRight(time)}","direction":"right","aggregate":"group","style":28}},"height":40},"2":{"cells":{"1":{"style":25,"text":" "},"2":{"style":25,"text":" "},"3":{"style":25,"text":" "},"4":{"style":25,"text":" "},"5":{"text":"#{efficiency.groupRight(type)}","direction":"right","aggregate":"group","style":28}},"height":40},"3":{"cells":{"1":{"text":"#{efficiency.group(workstationCode)}","style":49,"aggregate":"group","sort":"desc"},"2":{"text":"#{efficiency.group(workstationName)}","style":49,"aggregate":"group","sort":"desc"},"3":{"text":"#{efficiency.group(workstationNameGroupName)}","style":49,"aggregate":"group","sort":"desc"},"4":{"text":"#{efficiency.group(shiftName)}","style":49,"aggregate":"group","sort":"default"},"5":{"text":"#{efficiency.dynamic(value}","aggregate":"select","style":52}},"height":38},"len":4},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"efficiency.workstationCode","freeze":"A1","dataRectWidth":998,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#E"},{"bgcolor":"#E"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EF"},{"bgcolor":"#EF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFE"},{"bgcolor":"#EFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEF"},{"bgcolor":"#EFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFE"},{"bgcolor":"#EFEFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"align":"center"},{"align":"center","color":"#0a0a0a"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF"},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":9}},{"font":{"size":9}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9,"bold":true}},{"font":{"bold":true}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10.5,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":10.5}},{"font":{"size":10.5}},{"font":{"bold":true,"size":10.5}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":10.5,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":10}},{"font":{"size":10}},{"font":{"bold":true,"size":10}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":10,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":14}},{"font":{"size":14}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":12,"bold":true}},{"font":{"size":12}}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":225},"2":{"width":225},"3":{"width":225},"4":{"width":225},"5":{"width":82},"6":{"width":70.8},"7":{"width":70.8},"8":{"width":100},"9":{"width":100},"10":{"width":100},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3"]}',
| null, null, 'admin', '2022-07-14 19:19:17.000000', 'dev', '2022-07-28 15:55:32.000000', 0, null, null, 0, 371,
| null, 'function init(){this.queryPanel=''1''}');
|
| INSERT INTO jimu_report_db(id, jimu_report_id, create_by, update_by, create_time, update_time, db_code, db_ch_name,
| db_type, db_table_name, db_dyn_sql, db_key, tb_db_key, tb_db_table_name, java_type,
| java_value, api_url, api_method, is_list, is_page, db_source, db_source_type, json_data,
| api_convert)
| VALUES ('707023721635119104', '707023101616324608', 'admin', 'admin', '2022-07-27 11:14:15.000000',
| '2022-07-27 11:14:15.000000', 'output', '工位产量报表', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/output/list?statisticsType=2&dateCycle=${dateCycle}&keyword=${keyword}', '0', '1',
| '1', '', null, null, null),
| ('707081702282747904', '707081699497730048', 'admin', 'admin', '2022-07-25 15:18:16.000000',
| '2022-07-25 15:18:16.000000', 'alarmTime', '报警按时间', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-alarm/by-time?dateCycle=${dateCycle}&workstationKeyword=${workstationKeyword}',
| '0', '1', '1', '', null, null, null),
| ('707168986820231168', '707168303790407680', 'admin', 'admin', '2022-07-27 10:34:10.000000',
| '2022-07-27 10:34:10.000000', 'output', '工位产量-班次', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/output/list?statisticsType=1&keyword=${keyword}&shiftName=${shiftName}&shiftIndex=${shiftIndex}',
| '0', '1', '1', '', null, null, null),
| ('707387768497364992', '707378988669853696', 'admin', 'admin', '2022-07-14 11:24:59.000000',
| '2022-07-14 11:25:00.000000', 'drillAlarmTime', '钻取报警时间', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-alarm/drill-by-time?currentDate=${currentDate}&workstationId=${workstationId}',
| '0', '1', '1', null, null, null, null),
| ('707460433337257984', '707452299503865856', 'admin', 'admin', '2022-07-27 18:06:23.000000',
| '2022-07-27 18:06:23.000000', 'efficiency', '效率-按时间', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-efficiency/by-time?name=${name}&productivityTypes=${productivityTypes}&dateCycle=${dateCycle}',
| '0', '1', '1', '', null, null, null),
| ('707481063152017408', '707479561238863872', 'admin', 'admin', '2022-07-25 08:58:12.000000',
| '2022-07-25 08:58:12.000000', 'drillAlarmShift', '钻取报警班次', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-alarm/drill-by-shift?currentDate=${currentDate}&workstationId=${workstationId}',
| '0', '1', '1', null, null, null, null),
| ('707506557054476288', '707504177185415168', 'admin', 'admin', '2022-07-26 15:12:17.000000',
| '2022-07-26 15:12:18.000000', 'alarmShift', '报警按班次', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-alarm/by-shift?workstationKeyword=${workstationKeyword}&shiftIndex=${shiftIndex}&shiftIndexName=${shiftIndexName}',
| '0', '1', '1', '', null, null, null),
| ('707520142291374080', '707520139154034688', 'admin', 'admin', '2022-07-27 17:38:36.000000',
| '2022-07-27 17:38:36.000000', 'efficiency', '效率-按班次', '1', null, null, null, null, null, null, null,
| '{{domainURL}}/blade-report/workstation-efficiency/by-shift?name=${name}&shiftIndex=${shiftIndex}&productivityTypes=${productivityTypes}',
| '0', '1', '1', '', null, null, null);
|
| INSERT INTO jimu_report_db_field(id, create_by, create_time, update_by, update_time, jimu_report_db_id, field_name,
| field_text, widget_type, widget_width, order_num, search_flag, search_mode, dict_code,
| search_value, search_format, ext_json)
| VALUES ('707028690982002688', 'admin', '2022-07-13 14:42:04.000000', null, null, '707025543152656384', 'alarmCount',
| 'alarmCount', 'String', null, 0, null, null, null, null, null, null),
| ('707028691627925504', 'admin', '2022-07-13 14:42:04.000000', null, null, '707025543152656384',
| 'workstationCode', 'workstationCode', 'String', null, 1, null, null, null, null, null, null),
| ('707028692118659072', 'admin', '2022-07-13 14:42:05.000000', null, null, '707025543152656384',
| 'workstationGroup', 'workstationGroup', 'String', null, 2, null, null, null, null, null, null),
| ('707028692512923648', 'admin', '2022-07-13 14:42:05.000000', null, null, '707025543152656384',
| 'workstationName', 'workstationName', 'String', null, 3, null, null, null, null, null, null),
| ('707028693192400896', 'admin', '2022-07-13 14:42:05.000000', null, null, '707025543152656384', 'alarmCode',
| 'alarmCode', 'String', null, 4, null, null, null, null, null, null),
| ('707028693850906624', 'admin', '2022-07-13 14:42:05.000000', null, null, '707025543152656384', 'showDate',
| 'showDate', 'String', null, 5, null, null, null, null, null, null),
| ('707036167661543424', 'admin', '2022-07-14 09:22:53.000000', null, null, '707036167195975680', 'id', 'id',
| 'String', null, 0, null, null, null, null, null, null),
| ('707036168169054208', 'admin', '2022-07-14 09:22:53.000000', null, null, '707036167195975680', 'tenant_id',
| 'tenant_id', 'String', null, 1, null, null, null, null, null, null),
| ('707036168399740928', 'admin', '2022-07-14 09:22:53.000000', null, null, '707036167195975680', 'code', 'code',
| 'String', null, 2, 1, 7, 'dateCycle', null, null, null),
| ('707036168617844736', 'admin', '2022-07-14 09:22:53.000000', null, null, '707036167195975680', 'name', 'name',
| 'number', null, 3, 1, 1, null, null, null, null),
| ('707036168840142848', 'admin', '2022-07-14 09:22:54.000000', null, null, '707036167195975680', 'parent_id',
| 'parent_id', 'String', null, 4, 0, 7, null, null, null, null),
| ('707036169070829568', 'admin', '2022-07-14 09:22:54.000000', null, null, '707036167195975680', 'type_id',
| 'type_id', 'String', null, 5, null, null, null, null, null, null),
| ('707036169293127680', 'admin', '2022-07-14 09:22:54.000000', null, null, '707036167195975680', 'unit', 'unit',
| 'String', null, 6, null, null, null, null, null, null),
| ('707036169507037184', 'admin', '2022-07-14 09:22:54.000000', null, null, '707036167195975680', 'standard_model',
| 'standard_model', 'String', null, 7, null, null, null, null, null, null),
| ('707036169716752384', 'admin', '2022-07-14 09:22:55.000000', null, null, '707036167195975680', 'description',
| 'description', 'String', null, 8, null, null, null, null, null, null),
| ('707036169943244800', 'admin', '2022-07-14 09:22:55.000000', null, null, '707036167195975680', 'documents',
| 'documents', 'String', null, 9, null, null, null, null, null, null),
| ('707036170207485952', 'admin', '2022-07-14 09:22:55.000000', null, null, '707036167195975680', 'create_user',
| 'create_user', 'String', null, 10, null, null, null, null, null, null),
| ('707036170429784064', 'admin', '2022-07-14 09:22:55.000000', null, null, '707036167195975680', 'create_dept',
| 'create_dept', 'String', null, 11, null, null, null, null, null, null),
| ('707036170664665088', 'admin', '2022-07-14 09:22:55.000000', null, null, '707036167195975680', 'create_time',
| 'create_time', 'String', null, 12, null, null, null, null, null, null),
| ('707036170891157504', 'admin', '2022-07-14 09:22:56.000000', null, null, '707036167195975680', 'update_user',
| 'update_user', 'String', null, 13, null, null, null, null, null, null),
| ('707036171117649920', 'admin', '2022-07-14 09:22:56.000000', null, null, '707036167195975680', 'update_time',
| 'update_time', 'date', null, 14, 1, 2, null, null, null, null),
| ('707036171327365120', 'admin', '2022-07-14 09:22:56.000000', null, null, '707036167195975680', 'status',
| 'status', 'String', null, 15, null, null, null, null, null, null),
| ('707036171537080320', 'admin', '2022-07-14 09:22:56.000000', null, null, '707036167195975680', 'is_deleted',
| 'is_deleted', 'String', null, 16, null, null, null, null, null, null),
| ('707081703117414400', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904', 'alarmCount',
| 'alarmCount', 'String', null, 0, null, null, null, null, null, null),
| ('707081703629119488', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904',
| 'workstationCode', 'workstationCode', 'String', null, 1, null, null, null, null, null, null),
| ('707081704463785984', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904',
| 'workstationGroup', 'workstationGroup', 'String', null, 2, null, null, null, null, null, null),
| ('707081704941936640', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904',
| 'workstationName', 'workstationName', 'String', null, 3, 0, null, null, null, null, null),
| ('707081706049232896', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904', 'showDate', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, null),
| ('707115740183781376', 'admin', '2022-07-13 16:32:20.000000', null, null, '707091464042962944', 'alarmCount',
| 'alarmCount', 'String', null, 0, null, null, null, null, null, null),
| ('707115740766789632', 'admin', '2022-07-13 16:32:20.000000', null, null, '707091464042962944',
| 'workstationCode', 'workstationCode', 'String', null, 1, null, null, null, null, null, null),
| ('707115741337214976', 'admin', '2022-07-13 16:32:21.000000', null, null, '707091464042962944',
| 'workstationGroup', 'workstationGroup', 'String', null, 2, null, null, null, null, null, null),
| ('707115742016692224', 'admin', '2022-07-13 16:32:21.000000', null, null, '707091464042962944',
| 'workstationName', 'workstationName', 'String', null, 3, null, null, null, null, null, null),
| ('707115742620672000', 'admin', '2022-07-13 16:32:21.000000', null, null, '707091464042962944', 'showDate',
| 'showDate', 'String', null, 4, null, null, null, null, null, null),
| ('707150777386131456', 'admin', '2022-07-25 15:18:16.000000', null, null, '707081702282747904', 'workstationId',
| 'workstationId', 'String', null, 5, null, null, null, null, null, null),
| ('707170018434465792', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168', 'shiftName',
| 'shiftName', 'String', null, 0, null, null, null, null, null, null),
| ('707170018753232896', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168', 'outputCount',
| 'outputCount', 'String', null, 1, null, null, null, null, null, null),
| ('707170019021668352', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168',
| 'workstationCode', 'workstationCode', 'String', null, 2, null, null, null, null, null, null),
| ('707170019298492416', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168',
| 'workstationGroup', 'workstationGroup', 'String', null, 3, null, null, null, null, null, null),
| ('707170019835363328', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168', 'workstationId',
| 'workstationId', 'String', null, 4, null, null, null, null, null, null),
| ('707170020099604480', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168',
| 'workstationName', 'workstationName', 'String', null, 5, null, null, null, null, null, null),
| ('707170020368039936', 'admin', '2022-07-27 10:34:10.000000', null, null, '707168986820231168', 'dateCycle',
| 'dateCycle', 'String', null, 6, null, null, null, null, null, null),
| ('707170020640669696', 'admin', '2022-07-27 10:34:11.000000', null, null, '707168986820231168', 'shiftIndex',
| 'shiftIndex', 'String', null, 7, null, null, null, null, null, null),
| ('707170308280147968', 'admin', '2022-07-25 15:18:17.000000', null, null, '707081702282747904', 'alarmCountSum',
| 'alarmCountSum', 'String', null, 6, null, null, null, null, null, null),
| ('707395912053153792', 'admin', '2022-07-14 11:25:00.000000', null, null, '707387768497364992', 'alarmMsg',
| 'alarmMsg', 'String', null, 0, null, null, null, null, null, null),
| ('707395912732631040', 'admin', '2022-07-14 11:25:00.000000', null, null, '707387768497364992', 'workstationId',
| 'workstationId', 'String', null, 1, null, null, null, null, null, null),
| ('707395913550520320', 'admin', '2022-07-14 11:25:00.000000', null, null, '707387768497364992', 'alarmCode',
| 'alarmCode', 'String', null, 2, null, null, null, null, null, null),
| ('707395913969950720', 'admin', '2022-07-14 11:25:00.000000', null, null, '707387768497364992', 'ts', 'ts',
| 'String', null, 3, null, null, null, null, null, null),
| ('707395914334855168', 'admin', '2022-07-14 11:25:01.000000', null, null, '707387768497364992', 'factoryDate',
| 'factoryDate', 'String', null, 4, null, null, null, null, null, null),
| ('707397699799736320', 'admin', '2022-07-14 11:25:01.000000', null, null, '707387768497364992', 'showDate',
| 'showDate', 'String', null, 5, null, null, null, null, null, null),
| ('707485156897579008', 'admin', '2022-07-25 08:58:13.000000', null, null, '707481063152017408', 'shiftName',
| 'shiftName', 'String', null, 0, null, null, null, null, null, null),
| ('707485157392506880', 'admin', '2022-07-25 08:58:13.000000', null, null, '707481063152017408', 'alarmMsg',
| 'alarmMsg', 'String', null, 1, null, null, null, null, null, null),
| ('707485157769994240', 'admin', '2022-07-25 08:58:14.000000', null, null, '707481063152017408', 'shiftIndexName',
| 'shiftIndexName', 'String', null, 2, null, null, null, null, null, null),
| ('707485158134898688', 'admin', '2022-07-25 08:58:14.000000', null, null, '707481063152017408', 'workstationId',
| 'workstationId', 'String', null, 3, null, null, null, null, null, null),
| ('707485158634020864', 'admin', '2022-07-25 08:58:15.000000', null, null, '707481063152017408', 'alarmCode',
| 'alarmCode', 'String', null, 4, null, null, null, null, null, null),
| ('707485159040868352', 'admin', '2022-07-25 08:58:15.000000', null, null, '707481063152017408', 'shiftIndex',
| 'shiftIndex', 'String', null, 5, null, null, null, null, null, null),
| ('707485159472881664', 'admin', '2022-07-25 08:58:16.000000', null, null, '707481063152017408', 'ts', 'ts',
| 'String', null, 6, null, null, null, null, null, null),
| ('707485159858757632', 'admin', '2022-07-25 08:58:17.000000', null, null, '707481063152017408', 'factoryDate',
| 'factoryDate', 'String', null, 7, null, null, null, null, null, null),
| ('707509544896290816', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288', 'alarmCount',
| 'alarmCount', 'String', null, 0, null, null, null, null, null, null),
| ('707509545579962368', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288', 'shiftName',
| 'shiftName', 'String', null, 1, null, null, null, null, null, null),
| ('707509546011975680', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288',
| 'workstationCode', 'workstationCode', 'String', null, 2, null, null, null, null, null, null),
| ('707509546737590272', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288',
| 'workstationGroup', 'workstationGroup', 'String', null, 3, null, null, null, null, null, null),
| ('707509547102494720', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288', 'workstationId',
| 'workstationId', 'String', null, 4, null, null, null, null, null, null),
| ('707509547769389056', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288',
| 'workstationName', 'workstationName', 'String', null, 5, null, null, null, null, null, null),
| ('707509548096544768', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288', 'alarmCountSum',
| 'alarmCountSum', 'String', null, 6, null, null, null, null, null, null),
| ('707509548448866304', 'admin', '2022-07-26 15:12:18.000000', null, null, '707506557054476288', 'shiftIndex',
| 'shiftIndex', 'String', null, 7, null, null, null, null, null, null),
| ('707509548830547968', 'admin', '2022-07-26 15:12:19.000000', null, null, '707506557054476288', 'showDate', '日期',
| 'date', null, 8, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, null),
| ('707883555179970560', 'admin', '2022-07-27 10:34:11.000000', null, null, '707168986820231168', 'timeCondition',
| '日期', 'date', null, 8, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')',
| 'yyyy-MM-dd', null),
| ('710342789570228224', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104', 'outputCount',
| 'outputCount', 'String', null, 0, null, null, null, null, null, null),
| ('710342789914161152', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104',
| 'workstationCode', 'workstationCode', 'String', null, 1, null, null, null, null, null, null),
| ('710342790203568128', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104',
| 'workstationGroup', 'workstationGroup', 'String', null, 2, null, null, null, null, null, null),
| ('710342790501363712', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104', 'workstationId',
| 'workstationId', 'String', null, 3, null, null, null, null, null, null),
| ('710342790786576384', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104',
| 'workstationName', 'workstationName', 'String', null, 4, null, null, null, null, null, null),
| ('710342791067594752', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104', 'dateCycle',
| 'dateCycle', 'String', null, 5, null, null, null, null, null, null),
| ('710342791352807424', 'admin', '2022-07-27 11:14:16.000000', null, null, '707023721635119104', 'timeCondition',
| '日期', 'date', null, 6, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')',
| 'yyyy-MM-dd', null),
| ('711722975775264768', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'ctotal', 'ctotal',
| 'String', null, 0, null, null, null, null, null, null),
| ('711722976152752128', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'cname', 'cname',
| 'String', null, 1, null, null, null, null, null, null),
| ('711722976588959744', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'cprice', 'cprice',
| 'String', null, 2, null, null, null, null, null, null),
| ('711722976941281280', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'riqi', 'riqi',
| 'String', null, 3, null, null, null, null, null, null),
| ('711722977343934464', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'id', 'id',
| 'String', null, 4, null, null, null, null, null, null),
| ('711722977738199040', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'dtotal', 'dtotal',
| 'String', null, 5, null, null, null, null, null, null),
| ('711722978149240832', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'tp', 'tp',
| 'String', null, 6, null, null, null, null, null, null),
| ('711722978501562368', 'dev', '2022-07-26 09:39:51.000000', null, null, '711722975007707136', 'ztotal', 'ztotal',
| 'String', null, 7, null, null, null, null, null, null),
| ('711722978816135168', 'dev', '2022-07-26 09:39:52.000000', null, null, '711722975007707136', 'cnum', 'cnum',
| 'String', null, 8, null, null, null, null, null, null),
| ('712093798755307520', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'workstationCode',
| '工位编码', 'String', null, 0, null, null, null, null, null, null),
| ('712093799048908800', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'workstationName',
| '工位名称', 'String', null, 1, null, null, null, null, null, null),
| ('712093799321538560', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720',
| 'workstationNameGroupName', '工位组', 'String', null, 3, null, null, null, null, null, null),
| ('712093799619334144', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'time', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, null),
| ('712093799900352512', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'running', '运行率',
| 'String', null, 4, null, null, null, null, null, null),
| ('712093800177176576', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'alarm', '报警率',
| 'String', null, 5, null, null, null, null, null, null),
| ('712093800474972160', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'oee', '稼动率',
| 'String', null, 6, null, null, null, null, null, null),
| ('712093800739213312', 'dev', '2022-07-27 10:13:22.000000', null, null, '712093798440734720', 'workstationId',
| '工位id', 'String', null, 7, null, null, null, null, null, null),
| ('712093802425323520', 'dev', '2022-07-27 10:13:23.000000', null, null, '712093798440734720', 'shiftIndex', '班次',
| 'String', null, 8, null, null, null, null, null, null),
| ('712093802882502656', 'dev', '2022-07-27 10:13:23.000000', null, null, '712093798440734720', 'shiftName',
| '班次名称', 'String', null, 9, null, null, null, null, null, null),
| ('712176894052012032', 'admin', '2022-07-27 15:57:54.000000', null, null, '712167373367808000',
| 'workstationCode', 'workstationCode', 'String', null, 0, null, null, null, null, null, ''),
| ('712176894798598144', 'admin', '2022-07-27 15:57:54.000000', null, null, '712167373367808000',
| 'workstationName', 'workstationName', 'String', null, 1, null, null, null, null, null, ''),
| ('712176895167696896', 'admin', '2022-07-27 15:57:55.000000', null, null, '712167373367808000', 'time', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, ''),
| ('712176895549378560', 'admin', '2022-07-27 15:57:54.000000', null, null, '712167373367808000', 'type', 'type',
| 'String', null, 3, null, null, null, null, null, ''),
| ('712176896316936192', 'admin', '2022-07-27 15:57:55.000000', null, null, '712167373367808000',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', null, 4, null, null, null, null, null, ''),
| ('712176896807669760', 'admin', '2022-07-27 15:57:55.000000', null, null, '712167373367808000', 'value', 'value',
| 'String', null, 5, null, null, null, null, null, ''),
| ('712184021634125824', 'admin', '2022-07-27 17:08:31.000000', null, null, '712184021055311872',
| 'workstationCode', 'workstationCode', 'String', null, 0, null, null, null, null, null, ''),
| ('712184021940310016', 'admin', '2022-07-27 17:08:31.000000', null, null, '712184021055311872',
| 'workstationName', 'workstationName', 'String', null, 1, null, null, null, null, null, ''),
| ('712184022288437248', 'admin', '2022-07-27 17:08:31.000000', null, null, '712184021055311872', 'type', 'type',
| 'String', null, 3, null, null, null, null, null, ''),
| ('712184022607204352', 'admin', '2022-07-27 17:08:32.000000', null, null, '712184021055311872', 'time', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, ''),
| ('712184023232155648', 'admin', '2022-07-27 17:08:32.000000', null, null, '712184021055311872',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', null, 4, null, null, null, null, null, ''),
| ('712184023823552512', 'admin', '2022-07-27 17:08:32.000000', null, null, '712184021055311872', 'value', 'value',
| 'String', null, 5, null, null, null, null, null, ''),
| ('712202044604551168', 'admin', '2022-07-27 17:38:37.000000', null, null, '707520142291374080', 'shiftName',
| 'shiftName', 'String', null, 0, null, null, null, null, null, ''),
| ('712202045032370176', 'admin', '2022-07-27 17:38:37.000000', null, null, '707520142291374080',
| 'workstationCode', 'workstationCode', 'String', null, 1, null, null, null, null, null, ''),
| ('712202045418246144', 'admin', '2022-07-27 17:38:37.000000', null, null, '707520142291374080', 'workstationId',
| 'workstationId', 'String', null, 2, null, null, null, null, null, ''),
| ('712202045732818944', 'admin', '2022-07-27 17:38:37.000000', null, null, '707520142291374080',
| 'workstationName', 'workstationName', 'String', null, 3, null, null, null, null, null, ''),
| ('712202046101917696', 'admin', '2022-07-27 17:38:37.000000', null, null, '707520142291374080', 'time', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, ''),
| ('712202046668148736', 'admin', '2022-07-27 17:38:38.000000', null, null, '707520142291374080', 'shiftIndex',
| 'shiftIndex', 'String', null, 5, null, null, null, null, null, ''),
| ('712202047146299392', 'admin', '2022-07-27 17:38:38.000000', null, null, '707520142291374080', 'type', 'type',
| 'String', null, 6, null, null, null, null, null, ''),
| ('712202047507009536', 'admin', '2022-07-27 17:38:39.000000', null, null, '707520142291374080',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', null, 7, null, null, null, null, null, ''),
| ('712202047918051328', 'admin', '2022-07-27 17:38:39.000000', null, null, '707520142291374080', 'value', 'value',
| 'String', null, 8, null, null, null, null, null, ''),
| ('712209917829058560', 'admin', '2022-07-27 18:06:23.000000', null, null, '707460433337257984',
| 'workstationCode', '工位编码', 'String', null, 0, null, null, null, null, null, ''),
| ('712209918395289600', 'admin', '2022-07-27 18:06:23.000000', null, null, '707460433337257984',
| 'workstationName', '工位名称', 'String', null, 1, null, null, null, null, null, ''),
| ('712209919754244096', 'admin', '2022-07-27 18:06:24.000000', null, null, '707460433337257984', 'time', '日期',
| 'date', null, 4, 1, 2, null, '=dateStr(=nowstr(),''yyyy-MM-dd'',-2)|=dateStr(''yyyy-MM-dd'')', null, ''),
| ('712209920425332736', 'admin', '2022-07-27 18:06:24.000000', null, null, '707460433337257984', 'type', '数据类型',
| 'String', null, 3, null, null, null, null, null, ''),
| ('712209920769265664', 'admin', '2022-07-27 18:06:24.000000', null, null, '707460433337257984',
| 'workstationNameGroupName', '工位组', 'String', null, 4, null, null, null, null, null, ''),
| ('712209921318719488', 'admin', '2022-07-27 18:06:24.000000', null, null, '707460433337257984', 'value', '数据',
| 'String', null, 5, null, null, null, null, null, '');
|
| INSERT INTO jimu_report_db_param(ID, JIMU_REPORT_HEAD_ID, PARAM_NAME, PARAM_TXT, PARAM_VALUE, ORDER_NUM, CREATE_BY,
| CREATE_TIME, UPDATE_BY, UPDATE_TIME, SEARCH_FLAG, WIDGET_TYPE, SEARCH_MODE, DICT_CODE,
| SEARCH_FORMAT, EXT_JSON)
| VALUES ('707025549368614912', '707025543152656384', 'startTime', null, '2022-04-10', 2, 'admin',
| '2022-07-13 14:42:05.000000', null, null, 1, 'date', null, null, null, null),
| ('707025549695770624', '707025543152656384', 'dateCycle', null, '2', 4, 'admin', '2022-07-13 14:42:06.000000',
| null, null, 1, null, 4, 'dateCycle', null, null),
| ('707025550094229504', '707025543152656384', 'endTime', null, '2022-04-20', 3, 'admin',
| '2022-07-13 14:42:06.000000', null, null, 1, 'date', null, null, null, null),
| ('707028696707227648', '707025543152656384', 'workstationKeyword', null, '全新工位', 5, 'admin',
| '2022-07-13 14:42:06.000000', null, null, 1, 'string', 1, null, null, null),
| ('707481064498388992', '707481063152017408', 'currentDate', null, '2022-04-15', 1, 'admin',
| '2022-07-25 08:58:17.000000', null, null, 0, null, null, null, null, null),
| ('707481065026871296', '707481063152017408', 'workstationId', null, '1514869396182376449', 2, 'admin',
| '2022-07-25 08:58:18.000000', null, null, 0, null, null, null, null, null),
| ('707387775153725440', '707387768497364992', 'currentDate', null, '2022-04-15', 1, 'admin',
| '2022-07-14 11:25:01.000000', null, null, 0, null, null, null, null, null),
| ('707387775480881152', '707387768497364992', 'workstationId', null, '1514869396182376449', 2, 'admin',
| '2022-07-14 11:25:01.000000', null, null, 0, null, null, null, null, null),
| ('707479270108028928', '707479266836471808', 'currentDate', null, '2022-04-15', 1, 'admin',
| '2022-07-14 16:37:39.000000', null, null, 0, null, null, null, null, null),
| ('707479270472933376', '707479266836471808', 'workstationId', null, '1514869396182376449', 2, 'admin',
| '2022-07-14 16:37:39.000000', null, null, 0, null, null, null, null, null),
| ('707081708037332992', '707081702282747904', 'workstationKeyword', '工位编号/名称', null, 1, 'admin',
| '2022-07-25 15:18:17.000000', null, null, 1, 'string', 1, null, null, null),
| ('707081707622096896', '707081702282747904', 'dateCycle', '时间周期', '2', 2, 'admin', '2022-07-25 15:18:17.000000',
| null, null, 1, null, 7, 'dateCycle', null, null),
| ('707506564881047552', '707506557054476288', 'workstationKeyword', '工位编号/名称', null, 1, 'admin',
| '2022-07-26 15:12:19.000000', null, null, 1, null, 1, null, null, null),
| ('707506565279506432', '707506557054476288', 'shiftIndex', '班次', null, 2, 'admin', '2022-07-26 15:12:19.000000',
| null, null, 1, null, 3, 'shiftName', null, null),
| ('707506565598273536', '707506557054476288', 'shiftIndexName', '班次名称', null, 3, 'admin',
| '2022-07-26 15:12:19.000000', null, null, 1, null, 1, null, null, null),
| ('712093803167715328', '712093798440734720', 'name', '工位编号/名称', null, 1, 'dev', '2022-07-27 10:13:23.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('712093803444539392', '712093798440734720', 'shiftIndex', '班次名称', null, 2, 'dev', '2022-07-27 10:13:23.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('712093803708780544', '712093798440734720', 'productivityTypes', '数据名称', null, 3, 'dev',
| '2022-07-27 10:13:23.000000', null, null, 1, 'number', 3, 'productivityType', null, null),
| ('707168988472786944', '707168986820231168', 'keyword', '工位编号/名称', null, 4, 'admin',
| '2022-07-27 10:34:11.000000', null, null, 1, 'string', 1, null, null, null),
| ('707403727959998464', '707168986820231168', 'shiftIndex', '班次', null, 5, 'admin', '2022-07-27 10:34:11.000000',
| null, null, 1, 'number', 3, 'shiftName', null, null),
| ('707399583601770496', '707168986820231168', 'shiftName', '班次名称', null, 6, 'admin', '2022-07-27 10:34:11.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('707098916668440576', '707023721635119104', 'keyword', '工位编号/名称', null, 1, 'admin',
| '2022-07-27 11:14:16.000000', null, null, 1, 'string', 1, null, null, null),
| ('707028978213715968', '707023721635119104', 'dateCycle', '时间周期', '2', 2, 'admin', '2022-07-27 11:14:17.000000',
| null, null, 1, 'string', 7, 'dateCycle', null, null),
| ('712167377838936064', '712167373367808000', 'name', '工位编号/名称', null, 1, 'admin', '2022-07-27 15:57:55.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('712167378304503808', '712167373367808000', 'productivityTypes', '数据名称', null, 2, 'admin',
| '2022-07-27 15:57:56.000000', null, null, 1, null, 3, 'productivityType', null, null),
| ('712167378744905728', '712167373367808000', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 15:57:56.000000',
| null, null, 1, null, 7, 'dateCycle', null, null),
| ('712184024217817088', '712184021055311872', 'name', '工位编号/名称', null, 1, 'admin', '2022-07-27 17:08:32.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('712184024612081664', '712184021055311872', 'productivityTypes', '数据名称', null, 2, 'admin',
| '2022-07-27 17:08:32.000000', null, null, 1, null, 3, 'productivityType', null, null),
| ('712184025002151936', '712184021055311872', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 17:08:32.000000',
| null, null, 1, null, 7, 'dateCycle', null, null),
| ('707520145965584384', '707520142291374080', 'name', '工位编号/名称', null, 1, 'admin', '2022-07-27 17:38:39.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('707520146309517312', '707520142291374080', 'shiftIndex', '班次名称', null, 2, 'admin',
| '2022-07-27 17:38:39.000000', null, null, 1, 'string', 1, null, null, null),
| ('707520146741530624', '707520142291374080', 'productivityTypes', '数据名称', null, 3, 'admin',
| '2022-07-27 17:38:40.000000', null, null, 1, 'number', 3, 'productivityType', null, null),
| ('707470056312147968', '707460433337257984', 'name', '工位编号/名称', null, 1, 'admin', '2022-07-27 18:06:24.000000',
| null, null, 1, 'string', 1, null, null, null),
| ('707470057666908160', '707460433337257984', 'productivityTypes', '数据名称', null, 2, 'admin',
| '2022-07-27 18:06:25.000000', null, null, 1, null, 3, 'productivityType', null, null),
| ('707470058061172736', '707460433337257984', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 18:06:25.000000',
| null, null, 1, null, 7, 'dateCycle', null, null),
| ('762569105621245952', '707023721635119104', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}'),
| ('762569105621245953', '707081702282747904', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}'),
| ('762569105621245954', '707168986820231168', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}'),
| ('762569105621245955', '707460433337257984', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}'),
| ('762569105621245956', '707506557054476288', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}'),
| ('762569105621245957', '707520142291374080', 'workstationIds', '工位', NULL, '0', 'admin',
| TO_DATE('2022-12-13 17:08:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', NULL, '6', NULL, NULL,
| '{''loadTree'':''{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu'',''loadTreeByValue'':''{{ domainURL }}/demo/wsControlTree/loadTreeByValue''}');
|
|
| INSERT INTO "jimu_report_link"("id", "report_id", "parameter", "eject_type", "link_name", "api_method", "link_type",
| "api_url", "link_chart_id", "expression", "requirement")
| VALUES ('707399928057290752', '707378988669853696',
| '[{"paramName":"currentDate","paramValue":"showDate","tableIndex":0,"dbCode":"alarmTime","fieldName":"alarmCount"},{"paramName":"workstationId","paramValue":"workstationId","tableIndex":1,"dbCode":"alarmTime","fieldName":"alarmCount"}]',
| '1', '钻取按时间', null, '0', null, null, null, null);
| INSERT INTO "jimu_report_link"("id", "report_id", "parameter", "eject_type", "link_name", "api_method", "link_type",
| "api_url", "link_chart_id", "expression", "requirement")
| VALUES ('707513662478082048', '707479561238863872',
| '[{"paramName":"currentDate","paramValue":"showDate","tableIndex":0,"dbCode":"alarmShift","fieldName":"alarmCount"},{"paramName":"workstationId","paramValue":"workstationId","tableIndex":1,"dbCode":"alarmShift","fieldName":"alarmCount"}]',
| '1', '报警班次钻取', null, '0', null, null, null, null);
|
| create table "blade_wcs_feedback"
| (
| id bigint not null,
| workstation_id bigint,
| wcs varchar(50),
| start_time timestamp(0),
| end_time timestamp(0),
| feedback_time timestamp(0),
| remark varchar(255),
| feedback_type int,
| feed_user bigint,
| end_feed_user bigint,
| status int,
| not cluster primary key ("id"),
| check ("status" >= 0)
| );
|
| comment
| on column "blade_wcs_feedback".id is '主键';
| comment
| on column "blade_wcs_feedback".workstation_id is '工位id';
| comment
| on column "blade_wcs_feedback".wcs is '人工反馈状态code';
| comment
| on column "blade_wcs_feedback".start_time is '反馈开始时间';
| comment
| on column "blade_wcs_feedback".end_time is '反馈结束时间';
| comment
| on column "blade_wcs_feedback".feedback_time is '反馈时间';
| comment
| on column "blade_wcs_feedback".feed_user is '开始反馈人';
| comment
| on column "blade_wcs_feedback".feedback_type is '0: 时间段反馈 1.持续反馈 ';
| comment
| on column "blade_wcs_feedback".feed_user is '开始反馈人';
| comment
| on column "blade_wcs_feedback".end_feed_user is '结束反馈人';
| comment
| on column "blade_wcs_feedback".status is '状态: 1 待执行 2. 执行中 3. 执行完成';
|
| create table "blade_wcs_feedback_detail"
| (
| id bigint not null,
| feedback_id bigint,
| workstation_id bigint,
| wcs varchar(50),
| start_time timestamp(0),
| end_time timestamp(0),
| status int,
| cancel tinyint,
| cancel_time TIMESTAMP(0),
| not cluster primary key ("id"),
| check ("status" >= 0)
| );
|
| comment
| on column "blade_wcs_feedback_detail".id is '主键';
| comment
| on column "blade_wcs_feedback_detail".workstation_id is '工位ID';
| comment
| on column "blade_wcs_feedback_detail".feedback_id is '反馈主表id';
| comment
| on column "blade_wcs_feedback_detail".wcs is '人工反馈状态code';
| comment
| on column "blade_wcs_feedback_detail".start_time is '反馈开始时间';
| comment
| on column "blade_wcs_feedback_detail".end_time is '反馈结束时间';
| comment
| on column "blade_wcs_feedback_detail".status is '0：待生效 1: 已生效';
| comment
| on column "blade_wcs_feedback_detail".cancel is '是否撤销 0 没有撤销 1 已经撤销';
|
|
