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
| -- 初始化菜单脚本
| 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);
|
| CREATE TABLE `blade_wcs_feedback`
| (
| `id` bigint(20) NOT NULL,
| `workstation_id` bigint(20) DEFAULT NULL COMMENT '工位Id',
| `wcs` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人工反馈状态code',
| `start_time` datetime DEFAULT NULL COMMENT '反馈开始时间',
| `end_time` datetime DEFAULT NULL COMMENT '反馈结束时间',
| `feedback_time` datetime DEFAULT NULL COMMENT '反馈时间',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反馈描述',
| `feedback_type` tinyint(3) DEFAULT NULL COMMENT '0: 时间段反馈 1.持续反馈 ',
| `feed_user` bigint(20) DEFAULT NULL COMMENT '开始反馈人',
| `end_feed_user` bigint(20) DEFAULT NULL COMMENT '结束反馈人',
| `status` tinyint(3) DEFAULT NULL COMMENT '状态: 1 待执行 2. 执行中 3. 执行完成',
| PRIMARY KEY (`id`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4
| COLLATE = utf8mb4_general_ci;
|
| CREATE TABLE `blade_wcs_feedback_detail`
| (
| `id` bigint(20) NOT NULL COMMENT '主键id',
| `feedback_id` bigint(20) DEFAULT NULL COMMENT '反馈主表id',
| `workstation_id` bigint(20) DEFAULT NULL COMMENT '反馈工位id',
| `wcs` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反馈状态',
| `start_time` datetime DEFAULT NULL COMMENT '开始时间',
| `end_time` datetime DEFAULT NULL COMMENT '结束时间',
| `status` int(11) DEFAULT NULL COMMENT '0：待生效 1: 已生效',
| `cancel` tinyint(1) DEFAULT '0' COMMENT '是否撤销 0 没有撤销 1 已经撤销',
| `cancel_time` datetime DEFAULT NULL COMMENT '撤销数据的时间',
| PRIMARY KEY (`id`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4
| COLLATE = utf8mb4_general_ci;
|
| 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_report`
| VALUES ('707023101616324608', '20220713105912', '时间周期--产量', NULL, NULL, 'datainfo',
| '{\"loopBlockList\":[],\"area\":false,\"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\":26,\"rendered\":\"\",\"config\":\"\"},\"2\":{\"text\":\"工位名称\",\"style\":26,\"rendered\":\"\",\"config\":\"\"},\"3\":{\"text\":\"工位组\",\"style\":26,\"rendered\":\"\",\"config\":\"\"},\"4\":{\"direction\":\"right\",\"text\":\"#{output.groupRight(dateCycle)}\",\"style\":28,\"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', 'admin', '2022-07-27 18:01:06', 0, NULL, NULL, 0, 368, NULL,
| ' function init() {\n this.queryPanel = \'1\';\n this.onSearchFormChange(\"output\", \"dateCycle\", (value) => {\n console.log(value);\n var date = new Date();\n var yy = date.getFullYear();\n var mm =\n date.getMonth() < 10\n ? \"0\" + (new Date().getMonth() + 1)\n : new Date().getMonth() + 1;\n var startDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate()-2;\n var endDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate();\n \n var start = yy + \"-\" + mm + \"-\" + startDay;\n var end = yy + \"-\" + mm + \"-\" + endDay;\n this.updateSearchFormValue(\"output\", \"timeCondition\", start + \"|\" + end);\n });\n }\n');
| INSERT INTO `jimu_report`
| 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', 'admin', '2022-07-27 14:38:49', 0, NULL, NULL, 0, 359, NULL,
| ' function init() {\n this.queryPanel = \'1\';\n this.onSearchFormChange(\"alarmTime\", \"dateCycle\", (value) => {\n console.log(value);\n var date = new Date();\n var yy = date.getFullYear();\n var mm =\n date.getMonth() < 10\n ? \"0\" + (new Date().getMonth() + 1)\n : new Date().getMonth() + 1;\n var startDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate()-2;\n var endDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate();\n \n var start = yy + \"-\" + mm + \"-\" + startDay;\n var end = yy + \"-\" + mm + \"-\" + endDay;\n this.updateSearchFormValue(\"alarmTime\", \"showDate\", start + \"|\" + end);\n });\n }');
| INSERT INTO `jimu_report`
| VALUES ('707168303790407680', '20220713201009', '班次-产量', NULL, NULL, 'datainfo',
| '{\"loopBlockList\":[],\"area\":false,\"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\":14,\"sort\":\"desc\"},\"2\":{\"text\":\"#{output.group(workstationName)}\",\"aggregate\":\"group\",\"style\":14,\"sort\":\"desc\"},\"3\":{\"text\":\"#{output.group(workstationGroup)}\",\"aggregate\":\"group\",\"style\":14,\"sort\":\"desc\"},\"4\":{\"aggregate\":\"group\",\"text\":\"#{output.group(shiftName)}\",\"style\":14,\"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}],\"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', 'admin', '2022-07-27 14:38:15', 0, NULL, NULL, 0, 231, NULL,
| '\nfunction init(){\n this.queryPanel = \'1\';\n}');
| INSERT INTO `jimu_report`
| 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', 'admin', '2022-07-27 14:38:03', 0, NULL, NULL, 0, 68, NULL, NULL);
| INSERT INTO `jimu_report`
| VALUES ('707452299503865856', '20220714144957', '效率报表-按时间', NULL, NULL, 'datainfo',
| '{\"loopBlockList\":[],\"area\":{\"sri\":3,\"sci\":4,\"eri\":3,\"eci\":4,\"width\":80,\"height\":38},\"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\":11}},\"height\":40},\"2\":{\"cells\":{\"0\":{\"style\":21,\"text\":\" \"},\"4\":{\"text\":\"#{efficiency.groupRight(type)}\",\"aggregate\":\"group\",\"direction\":\"right\",\"style\":11}},\"height\":40},\"3\":{\"cells\":{\"0\":{\"style\":21,\"text\":\"\"},\"1\":{\"text\":\"#{efficiency.group(workstationCode)}\",\"aggregate\":\"group\",\"style\":22,\"sort\":\"desc\"},\"2\":{\"text\":\"#{efficiency.group(workstationName)}\",\"aggregate\":\"group\",\"style\":22,\"sort\":\"desc\"},\"3\":{\"text\":\"#{efficiency.group(workstationNameGroupName)}\",\"aggregate\":\"group\",\"style\":22,\"sort\":\"desc\"},\"4\":{\"text\":\"#{efficiency.dynamic(value)}\",\"aggregate\":\"dynamic\",\"style\":38}},\"height\":38},\"len\":4},\"dbexps\":[],\"dicts\":[],\"rpbar\":{\"show\":true,\"pageSize\":\"\",\"btnList\":[1,2,3,4,5,6,8]},\"groupField\":\"efficiency.workstationCode\",\"freeze\":\"A1\",\"dataRectWidth\":1097,\"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}],\"validations\":[],\"isGroup\":true,\"cols\":{\"0\":{\"width\":18},\"1\":{\"width\":333},\"2\":{\"width\":333},\"3\":{\"width\":333},\"4\":{\"width\":80},\"5\":{\"width\":100},\"6\":{\"width\":141},\"len\":50},\"merges\":[\"B2:B3\",\"C2:C3\",\"D2:D3\"]}',
| NULL, NULL, 'admin', '2022-07-14 14:49:58', 'admin', '2022-07-27 18:39:32', 0, NULL, NULL, 0, 242, NULL,
| 'function init() {\n this.queryPanel = \'1\';\n this.onSearchFormChange(\"efficiency\", \"dateCycle\", (value) => {\n console.log(value);\n var date = new Date();\n var yy = date.getFullYear();\n var mm =\n date.getMonth() < 10\n ? \"0\" + (new Date().getMonth() + 1)\n : new Date().getMonth() + 1;\n var startDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate()-2;\n var endDay = new Date().getDate() < 10 ? \"0\" + new Date().getDate() : new Date().getDate();\n\n var start = yy + \"-\" + mm + \"-\" + startDay;\n var end = yy + \"-\" + mm + \"-\" + endDay;\n this.updateSearchFormValue(\"efficiency\", \"time\", start + \"|\" + end);\n });\n }');
| INSERT INTO `jimu_report`
| 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', 'admin', '2022-07-27 14:37:37', 0, NULL, NULL, 0, 55, NULL, NULL);
| INSERT INTO `jimu_report`
| 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', 'admin', '2022-07-27 14:37:16', 0, NULL, NULL, 0, 257, NULL,
| 'function init(){\n this.queryPanel = \'1\';\n}');
| INSERT INTO `jimu_report`
| VALUES ('707520139154034688', '202207141449579192', '效率报表-按班次', NULL, NULL, 'datainfo',
| '{\"loopBlockList\":[],\"area\":{\"sri\":3,\"sci\":6,\"eri\":3,\"eci\":6,\"width\":70.8,\"height\":38},\"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\":11}},\"height\":40},\"2\":{\"cells\":{\"5\":{\"text\":\"#{efficiency.groupRight(type)}\",\"direction\":\"right\",\"aggregate\":\"group\",\"style\":11}},\"height\":40},\"3\":{\"cells\":{\"1\":{\"text\":\"#{efficiency.group(workstationCode)}\",\"style\":27,\"aggregate\":\"group\",\"sort\":\"desc\"},\"2\":{\"text\":\"#{efficiency.group(workstationName)}\",\"style\":27,\"aggregate\":\"group\",\"sort\":\"desc\"},\"3\":{\"text\":\"#{efficiency.group(workstationNameGroupName)}\",\"style\":27,\"aggregate\":\"group\",\"sort\":\"desc\"},\"4\":{\"text\":\"#{efficiency.group(shiftName)}\",\"style\":27,\"aggregate\":\"group\",\"sort\":\"default\"},\"5\":{\"text\":\"#{efficiency.dynamic(value}\",\"aggregate\":\"select\",\"style\":0}},\"height\":38},\"len\":4},\"dbexps\":[],\"dicts\":[],\"rpbar\":{\"show\":true,\"pageSize\":\"\",\"btnList\":[1,2,3,4,5,6,8]},\"groupField\":\"efficiency.workstationCode\",\"freeze\":\"A1\",\"dataRectWidth\":1096,\"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}}],\"validations\":[],\"isGroup\":true,\"cols\":{\"0\":{\"width\":16},\"1\":{\"width\":250},\"2\":{\"width\":250},\"3\":{\"width\":250},\"4\":{\"width\":250},\"5\":{\"width\":80},\"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', 'admin', '2022-07-27 17:39:16', 0, NULL, NULL, 0, 309, NULL,
| 'function init(){\n this.queryPanel = \'1\';\n}');
|
|
| INSERT INTO `jimu_report_db`
| VALUES ('707023721635119104', '707023101616324608', 'admin', 'admin', '2022-07-27 11:14:15', '2022-07-27 11:14:15',
| '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', '2022-07-25 15:18:16',
| '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', '2022-07-27 10:34:10',
| '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', '2022-07-14 11:25:00',
| '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', '2022-07-27 18:06:23',
| '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', '2022-07-25 08:58:12',
| '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', '2022-07-26 15:12:18',
| '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', '2022-07-27 17:38:36',
| '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`
| VALUES ('707395912053153792', 'admin', '2022-07-14 11:25:00', NULL, NULL, '707387768497364992', 'alarmMsg', 'alarmMsg',
| 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707395912732631040', 'admin', '2022-07-14 11:25:00', NULL, NULL, '707387768497364992', 'workstationId',
| 'workstationId', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707395913550520320', 'admin', '2022-07-14 11:25:00', NULL, NULL, '707387768497364992', 'alarmCode',
| 'alarmCode', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707395913969950720', 'admin', '2022-07-14 11:25:00', NULL, NULL, '707387768497364992', 'ts', 'ts', 'String',
| NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707395914334855168', 'admin', '2022-07-14 11:25:01', NULL, NULL, '707387768497364992', 'factoryDate',
| 'factoryDate', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707397699799736320', 'admin', '2022-07-14 11:25:01', NULL, NULL, '707387768497364992', 'showDate', 'showDate',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028690982002688', 'admin', '2022-07-13 14:42:04', NULL, NULL, '707025543152656384', 'alarmCount',
| 'alarmCount', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028691627925504', 'admin', '2022-07-13 14:42:04', NULL, NULL, '707025543152656384', 'workstationCode',
| 'workstationCode', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028692118659072', 'admin', '2022-07-13 14:42:05', NULL, NULL, '707025543152656384', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028692512923648', 'admin', '2022-07-13 14:42:05', NULL, NULL, '707025543152656384', 'workstationName',
| 'workstationName', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028693192400896', 'admin', '2022-07-13 14:42:05', NULL, NULL, '707025543152656384', 'alarmCode',
| 'alarmCode', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707028693850906624', 'admin', '2022-07-13 14:42:05', NULL, NULL, '707025543152656384', 'showDate', 'showDate',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036167661543424', 'admin', '2022-07-14 09:22:53', NULL, NULL, '707036167195975680', 'id', 'id', 'String',
| NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036168169054208', 'admin', '2022-07-14 09:22:53', NULL, NULL, '707036167195975680', 'tenant_id',
| 'tenant_id', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036168399740928', 'admin', '2022-07-14 09:22:53', NULL, NULL, '707036167195975680', 'code', 'code',
| 'String', NULL, 2, 1, 7, 'dateCycle', NULL, NULL, NULL),
| ('707036168617844736', 'admin', '2022-07-14 09:22:53', NULL, NULL, '707036167195975680', 'name', 'name',
| 'number', NULL, 3, 1, 1, NULL, NULL, NULL, NULL),
| ('707036168840142848', 'admin', '2022-07-14 09:22:54', NULL, NULL, '707036167195975680', 'parent_id',
| 'parent_id', 'String', NULL, 4, 0, 7, NULL, NULL, NULL, NULL),
| ('707036169070829568', 'admin', '2022-07-14 09:22:54', NULL, NULL, '707036167195975680', 'type_id', 'type_id',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036169293127680', 'admin', '2022-07-14 09:22:54', NULL, NULL, '707036167195975680', 'unit', 'unit',
| 'String', NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036169507037184', 'admin', '2022-07-14 09:22:54', NULL, NULL, '707036167195975680', 'standard_model',
| 'standard_model', 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036169716752384', 'admin', '2022-07-14 09:22:55', NULL, NULL, '707036167195975680', 'description',
| 'description', 'String', NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036169943244800', 'admin', '2022-07-14 09:22:55', NULL, NULL, '707036167195975680', 'documents',
| 'documents', 'String', NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036170207485952', 'admin', '2022-07-14 09:22:55', NULL, NULL, '707036167195975680', 'create_user',
| 'create_user', 'String', NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036170429784064', 'admin', '2022-07-14 09:22:55', NULL, NULL, '707036167195975680', 'create_dept',
| 'create_dept', 'String', NULL, 11, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036170664665088', 'admin', '2022-07-14 09:22:55', NULL, NULL, '707036167195975680', 'create_time',
| 'create_time', 'String', NULL, 12, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036170891157504', 'admin', '2022-07-14 09:22:56', NULL, NULL, '707036167195975680', 'update_user',
| 'update_user', 'String', NULL, 13, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036171117649920', 'admin', '2022-07-14 09:22:56', NULL, NULL, '707036167195975680', 'update_time',
| 'update_time', 'date', NULL, 14, 1, 2, NULL, NULL, NULL, NULL),
| ('707036171327365120', 'admin', '2022-07-14 09:22:56', NULL, NULL, '707036167195975680', 'status', 'status',
| 'String', NULL, 15, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707036171537080320', 'admin', '2022-07-14 09:22:56', NULL, NULL, '707036167195975680', 'is_deleted',
| 'is_deleted', 'String', NULL, 16, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707115740183781376', 'admin', '2022-07-13 16:32:20', NULL, NULL, '707091464042962944', 'alarmCount',
| 'alarmCount', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707115740766789632', 'admin', '2022-07-13 16:32:20', NULL, NULL, '707091464042962944', 'workstationCode',
| 'workstationCode', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707115741337214976', 'admin', '2022-07-13 16:32:21', NULL, NULL, '707091464042962944', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707115742016692224', 'admin', '2022-07-13 16:32:21', NULL, NULL, '707091464042962944', 'workstationName',
| 'workstationName', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707115742620672000', 'admin', '2022-07-13 16:32:21', NULL, NULL, '707091464042962944', 'showDate', 'showDate',
| 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485156897579008', 'admin', '2022-07-25 08:58:13', NULL, NULL, '707481063152017408', 'shiftName',
| 'shiftName', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485157392506880', 'admin', '2022-07-25 08:58:13', NULL, NULL, '707481063152017408', 'alarmMsg', 'alarmMsg',
| 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485157769994240', 'admin', '2022-07-25 08:58:14', NULL, NULL, '707481063152017408', 'shiftIndexName',
| 'shiftIndexName', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485158134898688', 'admin', '2022-07-25 08:58:14', NULL, NULL, '707481063152017408', 'workstationId',
| 'workstationId', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485158634020864', 'admin', '2022-07-25 08:58:15', NULL, NULL, '707481063152017408', 'alarmCode',
| 'alarmCode', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485159040868352', 'admin', '2022-07-25 08:58:15', NULL, NULL, '707481063152017408', 'shiftIndex',
| 'shiftIndex', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485159472881664', 'admin', '2022-07-25 08:58:16', NULL, NULL, '707481063152017408', 'ts', 'ts', 'String',
| NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707485159858757632', 'admin', '2022-07-25 08:58:17', NULL, NULL, '707481063152017408', 'factoryDate',
| 'factoryDate', 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707081703117414400', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'alarmCount',
| 'alarmCount', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707081703629119488', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'workstationCode',
| 'workstationCode', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707081704463785984', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707081704941936640', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'workstationName',
| 'workstationName', 'String', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL),
| ('707081706049232896', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'showDate', '日期',
| 'date', NULL, 4, 1, 2, NULL, '=dateStr(=nowstr(),\'yyyy-MM-dd\',-2)|=dateStr(\'yyyy-MM-dd\')', NULL, NULL),
| ('707150777386131456', 'admin', '2022-07-25 15:18:16', NULL, NULL, '707081702282747904', 'workstationId',
| 'workstationId', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170308280147968', 'admin', '2022-07-25 15:18:17', NULL, NULL, '707081702282747904', 'alarmCountSum',
| 'alarmCountSum', 'String', NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722975775264768', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'ctotal', 'ctotal',
| 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722976152752128', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'cname', 'cname',
| 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722976588959744', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'cprice', 'cprice',
| 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722976941281280', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'riqi', 'riqi', 'String',
| NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722977343934464', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'id', 'id', 'String',
| NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722977738199040', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'dtotal', 'dtotal',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722978149240832', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'tp', 'tp', 'String',
| NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722978501562368', 'dev', '2022-07-26 09:39:51', NULL, NULL, '711722975007707136', 'ztotal', 'ztotal',
| 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('711722978816135168', 'dev', '2022-07-26 09:39:52', NULL, NULL, '711722975007707136', 'cnum', 'cnum', 'String',
| NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509544896290816', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'alarmCount',
| 'alarmCount', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509545579962368', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'shiftName',
| 'shiftName', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509546011975680', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'workstationCode',
| 'workstationCode', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509546737590272', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509547102494720', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'workstationId',
| 'workstationId', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509547769389056', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'workstationName',
| 'workstationName', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509548096544768', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'alarmCountSum',
| 'alarmCountSum', 'String', NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509548448866304', 'admin', '2022-07-26 15:12:18', NULL, NULL, '707506557054476288', 'shiftIndex',
| 'shiftIndex', 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707509548830547968', 'admin', '2022-07-26 15:12:19', NULL, NULL, '707506557054476288', 'showDate', '日期',
| 'date', NULL, 8, 1, 2, NULL, '=dateStr(=nowstr(),\'yyyy-MM-dd\',-2)|=dateStr(\'yyyy-MM-dd\')', NULL, NULL),
| ('712093798755307520', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720', 'workstationCode', '工位编码',
| 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093799048908800', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720', 'workstationName', '工位名称',
| 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093799321538560', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720',
| 'workstationNameGroupName', '工位组', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093799619334144', 'dev', '2022-07-27 10:13:22', 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', NULL, NULL, '712093798440734720', 'running', '运行率',
| 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093800177176576', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720', 'alarm', '报警率', 'String',
| NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093800474972160', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720', 'oee', '稼动率', 'String',
| NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093800739213312', 'dev', '2022-07-27 10:13:22', NULL, NULL, '712093798440734720', 'workstationId', '工位id',
| 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093802425323520', 'dev', '2022-07-27 10:13:23', NULL, NULL, '712093798440734720', 'shiftIndex', '班次',
| 'String', NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL),
| ('712093802882502656', 'dev', '2022-07-27 10:13:23', NULL, NULL, '712093798440734720', 'shiftName', '班次名称',
| 'String', NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170018434465792', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'shiftName',
| 'shiftName', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170018753232896', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'outputCount',
| 'outputCount', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170019021668352', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'workstationCode',
| 'workstationCode', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170019298492416', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170019835363328', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'workstationId',
| 'workstationId', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170020099604480', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'workstationName',
| 'workstationName', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170020368039936', 'admin', '2022-07-27 10:34:10', NULL, NULL, '707168986820231168', 'dateCycle',
| 'dateCycle', 'String', NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707170020640669696', 'admin', '2022-07-27 10:34:11', NULL, NULL, '707168986820231168', 'shiftIndex',
| 'shiftIndex', 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL),
| ('707883555179970560', 'admin', '2022-07-27 10:34:11', 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', NULL, NULL, '707023721635119104', 'outputCount',
| 'outputCount', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342789914161152', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'workstationCode',
| 'workstationCode', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342790203568128', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'workstationGroup',
| 'workstationGroup', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342790501363712', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'workstationId',
| 'workstationId', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342790786576384', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'workstationName',
| 'workstationName', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342791067594752', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'dateCycle',
| 'dateCycle', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL),
| ('710342791352807424', 'admin', '2022-07-27 11:14:16', NULL, NULL, '707023721635119104', 'timeCondition', '日期',
| 'date', NULL, 6, 1, 2, NULL, '=dateStr(=nowstr(),\'yyyy-MM-dd\',-2)|=dateStr(\'yyyy-MM-dd\')', 'yyyy-MM-dd',
| NULL),
| ('712176894052012032', 'admin', '2022-07-27 15:57:54', NULL, NULL, '712167373367808000', 'workstationCode',
| 'workstationCode', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, ''),
| ('712176894798598144', 'admin', '2022-07-27 15:57:54', NULL, NULL, '712167373367808000', 'workstationName',
| 'workstationName', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, ''),
| ('712176895549378560', 'admin', '2022-07-27 15:57:54', NULL, NULL, '712167373367808000', 'type', 'type',
| 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, ''),
| ('712176895167696896', 'admin', '2022-07-27 15:57:55', NULL, NULL, '712167373367808000', 'time', '日期', 'date',
| NULL, 4, 1, 2, NULL, '=dateStr(=nowstr(),\'yyyy-MM-dd\',-2)|=dateStr(\'yyyy-MM-dd\')', NULL, ''),
| ('712176896316936192', 'admin', '2022-07-27 15:57:55', NULL, NULL, '712167373367808000',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, ''),
| ('712176896807669760', 'admin', '2022-07-27 15:57:55', NULL, NULL, '712167373367808000', 'value', 'value',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, ''),
| ('712184021634125824', 'admin', '2022-07-27 17:08:31', NULL, NULL, '712184021055311872', 'workstationCode',
| 'workstationCode', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, ''),
| ('712184021940310016', 'admin', '2022-07-27 17:08:31', NULL, NULL, '712184021055311872', 'workstationName',
| 'workstationName', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, ''),
| ('712184022288437248', 'admin', '2022-07-27 17:08:31', NULL, NULL, '712184021055311872', 'type', 'type',
| 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, ''),
| ('712184022607204352', 'admin', '2022-07-27 17:08:32', 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', NULL, NULL, '712184021055311872',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, ''),
| ('712184023823552512', 'admin', '2022-07-27 17:08:32', NULL, NULL, '712184021055311872', 'value', 'value',
| 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202044604551168', 'admin', '2022-07-27 17:38:37', NULL, NULL, '707520142291374080', 'shiftName',
| 'shiftName', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202045032370176', 'admin', '2022-07-27 17:38:37', NULL, NULL, '707520142291374080', 'workstationCode',
| 'workstationCode', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202045418246144', 'admin', '2022-07-27 17:38:37', NULL, NULL, '707520142291374080', 'workstationId',
| 'workstationId', 'String', NULL, 2, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202045732818944', 'admin', '2022-07-27 17:38:37', NULL, NULL, '707520142291374080', 'workstationName',
| 'workstationName', 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202046101917696', 'admin', '2022-07-27 17:38:37', 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', NULL, NULL, '707520142291374080', 'shiftIndex',
| 'shiftIndex', 'String', NULL, 5, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202047146299392', 'admin', '2022-07-27 17:38:38', NULL, NULL, '707520142291374080', 'type', 'type',
| 'String', NULL, 6, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202047507009536', 'admin', '2022-07-27 17:38:39', NULL, NULL, '707520142291374080',
| 'workstationNameGroupName', 'workstationNameGroupName', 'String', NULL, 7, NULL, NULL, NULL, NULL, NULL, ''),
| ('712202047918051328', 'admin', '2022-07-27 17:38:39', NULL, NULL, '707520142291374080', 'value', 'value',
| 'String', NULL, 8, NULL, NULL, NULL, NULL, NULL, ''),
| ('712209917829058560', 'admin', '2022-07-27 18:06:23', NULL, NULL, '707460433337257984', 'workstationCode',
| '工位编码', 'String', NULL, 0, NULL, NULL, NULL, NULL, NULL, ''),
| ('712209918395289600', 'admin', '2022-07-27 18:06:23', NULL, NULL, '707460433337257984', 'workstationName',
| '工位名称', 'String', NULL, 1, NULL, NULL, NULL, NULL, NULL, ''),
| ('712209920425332736', 'admin', '2022-07-27 18:06:24', NULL, NULL, '707460433337257984', 'type', '数据类型',
| 'String', NULL, 3, NULL, NULL, NULL, NULL, NULL, ''),
| ('712209919754244096', 'admin', '2022-07-27 18:06:24', NULL, NULL, '707460433337257984', 'time', '日期', 'date',
| NULL, 4, 1, 2, NULL, '=dateStr(=nowstr(),\'yyyy-MM-dd\',-2)|=dateStr(\'yyyy-MM-dd\')', NULL, ''),
| ('712209920769265664', 'admin', '2022-07-27 18:06:24', NULL, NULL, '707460433337257984',
| 'workstationNameGroupName', '工位组', 'String', NULL, 4, NULL, NULL, NULL, NULL, NULL, ''),
| ('712209921318719488', 'admin', '2022-07-27 18:06:24', NULL, NULL, '707460433337257984', 'value', '数据', 'String',
| NULL, 5, NULL, NULL, NULL, NULL, NULL, '');
|
|
| INSERT INTO `jimu_report_db_param`
| VALUES ('707025549368614912', '707025543152656384', 'startTime', NULL, '2022-04-10', 2, 'admin', '2022-07-13 14:42:05',
| NULL, NULL, 1, 'date', NULL, NULL, NULL, NULL),
| ('707025549695770624', '707025543152656384', 'dateCycle', NULL, '2', 4, 'admin', '2022-07-13 14:42:06', NULL,
| NULL, 1, NULL, 4, 'dateCycle', NULL, NULL),
| ('707025550094229504', '707025543152656384', 'endTime', NULL, '2022-04-20', 3, 'admin', '2022-07-13 14:42:06',
| NULL, NULL, 1, 'date', NULL, NULL, NULL, NULL),
| ('707028696707227648', '707025543152656384', 'workstationKeyword', NULL, '全新工位', 5, 'admin',
| '2022-07-13 14:42:06', NULL, NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707481064498388992', '707481063152017408', 'currentDate', NULL, '2022-04-15', 1, 'admin',
| '2022-07-25 08:58:17', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707481065026871296', '707481063152017408', 'workstationId', NULL, '1514869396182376449', 2, 'admin',
| '2022-07-25 08:58:18', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707387775153725440', '707387768497364992', 'currentDate', NULL, '2022-04-15', 1, 'admin',
| '2022-07-14 11:25:01', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707387775480881152', '707387768497364992', 'workstationId', NULL, '1514869396182376449', 2, 'admin',
| '2022-07-14 11:25:01', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707479270108028928', '707479266836471808', 'currentDate', NULL, '2022-04-15', 1, 'admin',
| '2022-07-14 16:37:39', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707479270472933376', '707479266836471808', 'workstationId', NULL, '1514869396182376449', 2, 'admin',
| '2022-07-14 16:37:39', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
| ('707081708037332992', '707081702282747904', 'workstationKeyword', '工位编号/名称', NULL, 1, 'admin',
| '2022-07-25 15:18:17', NULL, NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707081707622096896', '707081702282747904', 'dateCycle', '时间周期', '2', 2, 'admin', '2022-07-25 15:18:17', NULL,
| NULL, 1, NULL, 7, 'dateCycle', NULL, NULL),
| ('707506564881047552', '707506557054476288', 'workstationKeyword', '工位编号/名称', NULL, 1, 'admin',
| '2022-07-26 15:12:19', NULL, NULL, 1, NULL, 1, NULL, NULL, NULL),
| ('707506565279506432', '707506557054476288', 'shiftIndex', '班次', NULL, 2, 'admin', '2022-07-26 15:12:19', NULL,
| NULL, 1, NULL, 3, 'shiftName', NULL, NULL),
| ('707506565598273536', '707506557054476288', 'shiftIndexName', '班次名称', NULL, 3, 'admin', '2022-07-26 15:12:19',
| NULL, NULL, 1, NULL, 1, NULL, NULL, NULL),
| ('712093803167715328', '712093798440734720', 'name', '工位编号/名称', NULL, 1, 'dev', '2022-07-27 10:13:23', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('712093803444539392', '712093798440734720', 'shiftIndex', '班次名称', NULL, 2, 'dev', '2022-07-27 10:13:23', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('712093803708780544', '712093798440734720', 'productivityTypes', '数据名称', NULL, 3, 'dev', '2022-07-27 10:13:23',
| NULL, NULL, 1, 'number', 3, 'productivityType', NULL, NULL),
| ('707168988472786944', '707168986820231168', 'keyword', '工位编号/名称', NULL, 4, 'admin', '2022-07-27 10:34:11', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707403727959998464', '707168986820231168', 'shiftIndex', '班次', NULL, 5, 'admin', '2022-07-27 10:34:11', NULL,
| NULL, 1, 'number', 3, 'shiftName', NULL, NULL),
| ('707399583601770496', '707168986820231168', 'shiftName', '班次名称', NULL, 6, 'admin', '2022-07-27 10:34:11', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707098916668440576', '707023721635119104', 'keyword', '工位编号/名称', NULL, 1, 'admin', '2022-07-27 11:14:16', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707028978213715968', '707023721635119104', 'dateCycle', '时间周期', '2', 2, 'admin', '2022-07-27 11:14:17', NULL,
| NULL, 1, 'string', 7, 'dateCycle', NULL, NULL),
| ('712167377838936064', '712167373367808000', 'name', '工位编号/名称', NULL, 1, 'admin', '2022-07-27 15:57:55', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('712167378304503808', '712167373367808000', 'productivityTypes', '数据名称', NULL, 2, 'admin',
| '2022-07-27 15:57:56', NULL, NULL, 1, NULL, 3, 'productivityType', NULL, NULL),
| ('712167378744905728', '712167373367808000', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 15:57:56', NULL,
| NULL, 1, NULL, 7, 'dateCycle', NULL, NULL),
| ('712184024217817088', '712184021055311872', 'name', '工位编号/名称', NULL, 1, 'admin', '2022-07-27 17:08:32', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('712184024612081664', '712184021055311872', 'productivityTypes', '数据名称', NULL, 2, 'admin',
| '2022-07-27 17:08:32', NULL, NULL, 1, NULL, 3, 'productivityType', NULL, NULL),
| ('712184025002151936', '712184021055311872', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 17:08:32', NULL,
| NULL, 1, NULL, 7, 'dateCycle', NULL, NULL),
| ('707520145965584384', '707520142291374080', 'name', '工位编号/名称', NULL, 1, 'admin', '2022-07-27 17:38:39', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707520146309517312', '707520142291374080', 'shiftIndex', '班次名称', NULL, 2, 'admin', '2022-07-27 17:38:39', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707520146741530624', '707520142291374080', 'productivityTypes', '数据名称', NULL, 3, 'admin',
| '2022-07-27 17:38:40', NULL, NULL, 1, 'number', 3, 'productivityType', NULL, NULL),
| ('707470056312147968', '707460433337257984', 'name', '工位编号/名称', NULL, 1, 'admin', '2022-07-27 18:06:24', NULL,
| NULL, 1, 'string', 1, NULL, NULL, NULL),
| ('707470057666908160', '707460433337257984', 'productivityTypes', '数据名称', NULL, 2, 'admin',
| '2022-07-27 18:06:25', NULL, NULL, 1, NULL, 3, 'productivityType', NULL, NULL),
| ('707470058061172736', '707460433337257984', 'dateCycle', '时间周期', '2', 3, 'admin', '2022-07-27 18:06:25', NULL,
| NULL, 1, NULL, 7, 'dateCycle', NULL, NULL),
| ('762569105621245952', '707023721635119104', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', NULL,
| NULL, 1, NULL, 6, NULL, NULL,
| '{\'loadTree\':\'{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu\',\'loadTreeByValue\':\'{{ domainURL }}/demo/wsControlTree/loadTreeByValue\'}'),
| ('762569105621245953', '707081702282747904', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', NULL,
| NULL, 1, NULL, 6, NULL, NULL,
| '{\'loadTree\':\'{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu\',\'loadTreeByValue\':\'{{ domainURL }}/demo/wsControlTree/loadTreeByValue\'}'),
| ('762569105621245954', '707168986820231168', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', NULL,
| NULL, 1, NULL, 6, NULL, NULL,
| '{\'loadTree\':\'{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu\',\'loadTreeByValue\':\'{{ domainURL }}/demo/wsControlTree/loadTreeByValue\'}'),
| ('762569105621245955', '707460433337257984', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', NULL,
| NULL, 1, NULL, 6, NULL, NULL,
| '{\'loadTree\':\'{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu\',\'loadTreeByValue\':\'{{ domainURL }}/demo/wsControlTree/loadTreeByValue\'}'),
| ('762569105621245956', '707506557054476288', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', NULL,
| NULL, 1, NULL, 6, NULL, NULL,
| '{\'loadTree\':\'{{ domainURL }}/api/blade-cps/group/groupWorkstation/jimu\',\'loadTreeByValue\':\'{{ domainURL }}/demo/wsControlTree/loadTreeByValue\'}'),
| ('762569105621245957', '707520142291374080', 'workstationIds', '工位', '', 0, 'admin', '2022-12-13 17:08:04', 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`
| 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),
| ('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);
|
|
| INSERT INTO `jimu_dict`
| VALUES ('707025839572508672', '时间周期', 'dateCycle', NULL, 0, 'admin', '2022-07-13 10:35:06', NULL, NULL, NULL),
| ('707403397956354048', '班次', 'shiftName', NULL, 0, 'admin', '2022-07-14 11:35:23', NULL, NULL, NULL),
| ('707470863329792000', '数据名称', 'productivityType', NULL, 0, 'admin', '2022-07-14 16:03:28', 'admin',
| '2022-07-15 18:28:11', NULL);
|
| INSERT INTO `jimu_dict_item`
| VALUES ('707025981486784512', '707025839572508672', '按日', '2', NULL, 1, 1, 'admin', '2022-07-13 10:35:40', NULL, NULL),
| ('707026020959379456', '707025839572508672', '按周', '3', NULL, 2, 1, 'admin', '2022-07-13 10:35:50', NULL, NULL),
| ('707026056464162816', '707025839572508672', '按月', '4', NULL, 3, 1, 'admin', '2022-07-13 10:35:58', NULL, NULL),
| ('707403478516350976', '707403397956354048', '班次1', '1', NULL, 1, 1, 'admin', '2022-07-14 11:35:42', NULL, NULL),
| ('707403515199733760', '707403397956354048', '班次2', '2', NULL, 1, 1, 'admin', '2022-07-14 11:35:51', NULL, NULL),
| ('707403538511675392', '707403397956354048', '班次3', '3', NULL, 1, 1, 'admin', '2022-07-14 11:35:57', NULL, NULL),
| ('707403564394725376', '707403397956354048', '班次4', '4', NULL, 1, 1, 'admin', '2022-07-14 11:36:03', NULL, NULL),
| ('707726195796873216', '707470863329792000', '运行率', '1', NULL, 1, 1, 'admin', '2022-07-15 08:58:04', NULL, NULL),
| ('707726244526297088', '707470863329792000', '报警率', '2', NULL, 1, 1, 'admin', '2022-07-15 08:58:16', NULL, NULL),
| ('707726276738551808', '707470863329792000', '稼动率', '3', NULL, 1, 1, 'admin', '2022-07-15 08:58:24', NULL, NULL);
|
|
