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
| -- 计划
| DROP TABLE IF EXISTS `blade_plan`;
| CREATE TABLE `blade_plan`
| (
| `id` bigint(20) NOT NULL,
| `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计划类型名称',
| `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
| `type_id` bigint(20) DEFAULT NULL COMMENT '所属计划类型',
| `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计划编号',
| `indent_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单编号',
| `category` int(11) DEFAULT NULL COMMENT '计划类别：1 产品计划 2 来料计划',
| `product_id` bigint(20) DEFAULT NULL COMMENT '所属产品id',
| `product_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属产品编码',
| `product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属产品名称',
| `plan_num` int(11) DEFAULT '0' COMMENT '计划数量',
| `unassigned_num` int(11) DEFAULT '0' COMMENT '待派发数量',
| `report_num` int(11) DEFAULT '0' COMMENT '报工数量',
| `qualify_num` int(11) DEFAULT '0' COMMENT '合格数量',
| `scrapped_num` int(11) DEFAULT '0' COMMENT '报废数量',
| `craft_id` bigint(20) DEFAULT NULL COMMENT '所属产品工艺id',
| `craft_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属产品工艺名称',
| `craft_version` bigint(20) DEFAULT NULL COMMENT '所属工艺版本id',
| `craft_version_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属工艺版本名称',
| `plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
| `plan_end_time` datetime DEFAULT NULL COMMENT '计划结束时间',
| `start_time` datetime DEFAULT NULL COMMENT '实际开始时间',
| `end_time` datetime DEFAULT NULL COMMENT '实际结束时间',
| `standard_model` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格型号',
| `plan_status_before` int(11) DEFAULT NULL COMMENT '暂停前的状态',
| `plan_status` int(11) DEFAULT NULL COMMENT '计划状态(1:待派发 2.待加工 3.加工中 4.暂停 5.关闭 6.完工)',
| `bom_id` bigint(20) DEFAULT NULL COMMENT '产品bom主键',
| `bom_version` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属bom版本名称',
| `customer_id` bigint(20) DEFAULT NULL COMMENT '客户id',
| `customer_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户名称',
| `extend_field` json DEFAULT NULL COMMENT '扩展字段',
| `create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
| `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门',
| `create_time` datetime DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
| `update_time` datetime DEFAULT NULL COMMENT '修改时间',
| `status` int(11) DEFAULT NULL COMMENT '状态',
| `is_deleted` int(11) unsigned zerofill DEFAULT NULL,
| `source_plan_id` bigint(20) DEFAULT NULL COMMENT '源计划',
| PRIMARY KEY (`id`) USING BTREE,
| UNIQUE KEY `idx_typeid_planstatus_code` (`type_id`,`plan_status`,`code`) USING BTREE
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| -- 计划工序
| DROP TABLE IF EXISTS `blade_plan_process`;
| CREATE TABLE `blade_plan_process`
| (
| `id` bigint(20) NOT NULL,
| `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '租户id',
| `type_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划类型名称',
| `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
| `plan_id` bigint(20) NULL DEFAULT NULL COMMENT '所属计划id',
| `main_sequence_id` bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
| `sort` int(11) NULL DEFAULT NULL COMMENT '工序顺序',
| `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序编号',
| `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序名称',
| `program_id` bigint(20) NULL DEFAULT NULL COMMENT '程序id',
| `program_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称',
| `standard_time` int(11) NULL DEFAULT NULL COMMENT '标准工时',
| `workstation_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
| `workstation_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
| `art_bag_id` bigint(20) NULL DEFAULT NULL COMMENT '工艺包id',
| `art_bag_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包名称',
| `prepare_time` int(11) NULL DEFAULT NULL COMMENT '准备工时',
| `disassembly_time` int(11) NULL DEFAULT NULL COMMENT '拆卸工时',
| `transport_time` int(11) NULL DEFAULT NULL COMMENT '运输工时',
| `whether_test` int(11) NULL DEFAULT 0 COMMENT '是否质检 默认 0否 1是',
| `whether_parallel` int(11) NULL DEFAULT NULL COMMENT '是否并行 默认 0否 1是',
| `assign_status` int(11) NULL DEFAULT 0 COMMENT '工序派发状态 默认 0未派发 1已派发',
| `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
| `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
| `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
| `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
| `status` int(11) NULL DEFAULT NULL COMMENT '状态',
| `is_deleted` int(11) NULL DEFAULT NULL,
| PRIMARY KEY (`id`) USING BTREE,
| INDEX `plan_process_index` (`plan_id`) USING BTREE
| ) ENGINE = InnoDB
| CHARACTER SET = utf8mb4
| COLLATE = utf8mb4_general_ci COMMENT = '计划工序'
| ROW_FORMAT = DYNAMIC;
|
| -- 工单
| DROP TABLE IF EXISTS `blade_order`;
| CREATE TABLE `blade_order`
| (
| `id` bigint(20) NOT NULL COMMENT '主键',
| `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态',
| `is_deleted` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除',
| `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
| `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
| `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
| `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
| `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户',
| `order_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工单号',
| `assign_num` int(11) NULL DEFAULT 0 COMMENT '投产数量',
| `scrapped_num` int(11) NULL DEFAULT 0 COMMENT '报废数量',
| `qualify_num` int(11) NULL DEFAULT 0 COMMENT '合格数量',
| `order_status` int(1) NULL DEFAULT 1 COMMENT '工单状态(1：待加工，2：加工中，3：暂停，4：关闭,5:完工)',
| `plan_id` bigint(20) NULL DEFAULT NULL COMMENT '计划ID，cpc生成的ID',
| `order_status_before` int(1) NULL DEFAULT NULL COMMENT '变更前工单状态',
| `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
| `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
| `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
| PRIMARY KEY (`id`) USING BTREE,
| INDEX `order_index` (`plan_id`, `order_status`) USING BTREE
| ) ENGINE = InnoDB
| CHARACTER SET = utf8mb4
| COLLATE = utf8mb4_general_ci COMMENT = '计划工单'
| ROW_FORMAT = Dynamic;
|
| -- 工单工序
| DROP TABLE IF EXISTS `blade_order_process`;
| CREATE TABLE `blade_order_process`
| (
| `id` bigint(20) NOT NULL COMMENT '主键',
| `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
| `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
| `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
| `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
| `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态',
| `is_deleted` bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
| `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
| `plan_id` bigint(20) NULL DEFAULT NULL COMMENT '计划id',
| `order_id` bigint(20) NULL DEFAULT NULL COMMENT '工单id',
| `sort` int(11) NULL DEFAULT NULL COMMENT '工序顺序',
| `process_sequence` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序序号',
| `process_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序编号',
| `process_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序名称',
| `program_id` bigint(20) NULL DEFAULT NULL COMMENT '程序id',
| `program_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称',
| `process_status_before` int(11) NULL DEFAULT NULL COMMENT '暂停前状态',
| `process_status` int(11) NULL DEFAULT NULL COMMENT '工序状态(1.待加工 2.加工中 3.暂停 4.关闭 5.完工)',
| `input_num` int(11) NULL DEFAULT 0 COMMENT '投产数量',
| `qualify_num` int(11) NULL DEFAULT 0 COMMENT '工序合格数量',
| `scrapped_num` int(11) NULL DEFAULT 0 COMMENT '工序报废数量',
| `standard_time` int(11) NULL DEFAULT NULL COMMENT '标准工时（单位：s）',
| `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
| `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
| `workstation_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
| `workstation_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位名称，用逗号隔开',
| `art_bag_id` bigint(20) NULL DEFAULT NULL COMMENT '工艺包id',
| `art_bag_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包名称',
| `prepare_time` int(11) NULL DEFAULT NULL COMMENT '准备工时（单位：s）',
| `disassembly_time` int(11) NULL DEFAULT NULL COMMENT '拆卸工时（单位：s）',
| `transport_time` int(11) NULL DEFAULT NULL COMMENT '运输工时（单位：s）',
| `whether_test` int(11) NULL DEFAULT 0 COMMENT '是否质检： 0 否 1 是',
| `whether_parallel` int(11) NULL DEFAULT 0 COMMENT '是否并行： 0 否 1 是',
| `main_sequence_id` bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
| PRIMARY KEY (`id`) USING BTREE,
| INDEX `plan_order` (`plan_id`, `order_id`) USING BTREE
| ) ENGINE = InnoDB
| CHARACTER SET = utf8mb4
| COLLATE = utf8mb4_general_ci
| ROW_FORMAT = Dynamic;
|
| -- 工单工位
| DROP TABLE IF EXISTS `blade_order_workstation`;
| CREATE TABLE `blade_order_workstation`
| (
| `id` bigint(20) NOT NULL COMMENT '主键',
| `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
| `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
| `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
| `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
| `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态',
| `is_deleted` bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
| `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
| `plan_id` bigint(20) NULL DEFAULT NULL COMMENT '计划id',
| `order_id` bigint(20) NULL DEFAULT NULL COMMENT '工单id',
| `process_id` bigint(20) NULL DEFAULT NULL COMMENT '工单工序id',
| `workstation_id` bigint(20) NULL DEFAULT NULL COMMENT '加工工位id',
| `workstation_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加工工位名称',
| `producer_id` bigint(20) NULL DEFAULT NULL COMMENT '当前生产人员id',
| `producer_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前生产人员编号',
| `producer_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前生产人员名称',
| `qualify_num` int(11) NULL DEFAULT 0 COMMENT '报工合格数量',
| `scrapped_num` int(11) NULL DEFAULT 0 COMMENT '报工报废数量',
| `workstation_status` int(11) NULL DEFAULT 1 COMMENT '状态：1.未开工 2.已开工 ',
| `current_record_id` bigint(20) NULL DEFAULT NULL COMMENT '当前报工记录的id',
| PRIMARY KEY (`id`) USING BTREE,
| INDEX `plan_order_process_workstation` (`order_id`, `process_id`, `workstation_id`) USING BTREE
| ) ENGINE = InnoDB
| CHARACTER SET = utf8mb4
| COLLATE = utf8mb4_general_ci
| ROW_FORMAT = Dynamic;
|
| -- 开报工记录
| DROP TABLE IF EXISTS `blade_order_report_record`;
| CREATE TABLE `blade_order_report_record`
| (
| `id` bigint(20) NOT NULL COMMENT '主键',
| `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
| `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
| `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
| `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
| `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
| `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
| `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态',
| `is_deleted` bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
| `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
| `plan_id` bigint(20) NULL DEFAULT NULL COMMENT '计划id',
| `order_id` bigint(20) NULL DEFAULT NULL COMMENT '工单id',
| `process_id` bigint(20) NULL DEFAULT NULL COMMENT '工单工序id',
| `workstation_id` bigint(20) NULL DEFAULT NULL COMMENT '加工工位id',
| `workstation_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加工工位名称',
| `producer_user_id` bigint(20) NULL DEFAULT NULL COMMENT '开工人员id',
| `producer_user_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开工人员编码',
| `producer_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开工人员名称',
| `start_time` datetime NULL DEFAULT NULL COMMENT '开工时间',
| `workshop_time` datetime NULL DEFAULT NULL COMMENT '报工时间',
| `quality_time` datetime NULL DEFAULT NULL COMMENT '质检报工时间',
| `workshop_user_id` bigint(20) NULL DEFAULT NULL COMMENT '报工人员id',
| `workshop_user_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报工人员编码',
| `workshop_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报工人员名称',
| `quality_user_id` bigint(20) NULL DEFAULT NULL COMMENT '质检报工人员id',
| `quality_user_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '质检报工人员编码',
| `quality_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '质检报工人员名称',
| `qualify_num` int(11) NULL DEFAULT 0 COMMENT '报工合格数量',
| `scrapped_num` int(11) NULL DEFAULT 0 COMMENT '报工报废数量',
| `record_status` int(11) NULL DEFAULT 0 COMMENT '记录状态：0 开工 1 完工',
| `main_sequence_id` bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
| `open_sequence_id` bigint(20) NULL DEFAULT NULL COMMENT '并序报工记录id（并序开工时子序的开工记录中）',
| `version` int(11) DEFAULT '0' COMMENT '乐观锁',
| `system_or_ordinary` int(11) DEFAULT '0' COMMENT '0:普通报工 1:系统报工',
| PRIMARY KEY (`id`) USING BTREE,
| INDEX `record_index` (`process_id`, `workstation_id`, `record_status`) USING BTREE
| ) ENGINE = InnoDB
| CHARACTER SET = utf8mb4
| COLLATE = utf8mb4_0900_ai_ci
| ROW_FORMAT = Dynamic;
|
| -- 计划工单菜单
| 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 (1594520271959724033, 0, 'job', '计划工单', 'job', '/job', 'iconfont saber-jihuagongdan', 12, 0, 0, 1, '', 0, 'CPS',
| 1),
| (1594521413162733569, 1594520271959724033, 'job_plan', '计划', 'menu', '/job/plan/index', '', 1, 1, 0, 1, '', 0,
| 'CPS', 1),
| (1594524229658841089, 1594520271959724033, 'job_order', '工单1', 'job_order', '/job/order/index', '', 2, 1, 0, 1,
| '', 0, 'CPS', 1),
| (1599717577688829954, 1594524229658841089, 'job_work_start', '开工', 'job_work_start', '', '', 1, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599717707783557122, 1594524229658841089, 'job_work_report', '报工', 'job_work_report', '', '', 2, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599717873215295489, 1594524229658841089, 'job_work_complete', '完工', 'job_work_complete', '', '', 3, 2, 0, 1,
| '', 0, 'CPS', 1),
| (1599718446291443713, 1594524229658841089, 'job_work_assigned', '工位指派', 'job_work_assigned', '', '', 4, 2, 0, 1,
| '', 0, 'CPS', 1),
| (1599725934163382273, 1594524229658841089, 'report_history_edit', '报工记录编辑', 'report_history_edit', '', '', 5, 2,
| 0, 1, '', 0, 'CPS', 1),
| (1599726500805464065, 1594524229658841089, 'report_history_delete', '报工记录删除', 'report_history_delete', '', '', 6,
| 2, 0, 1, '', 0, 'CPS', 1),
| (1599727121952526337, 1594524229658841089, 'report_history', '报工记录列表', 'report_history', '', '', 7, 2, 0, 1, '',
| 0, 'CPS', 1),
| (1599948830497501186, 1594521413162733569, 'job_plan_create', '计划新增', 'button', '', '', 1, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599948991642660865, 1594521413162733569, 'job_plan_edit', '计划编辑', 'button', '', '', 2, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599949079353946114, 1594521413162733569, 'job_plan_import', '计划导入', 'button', '', '', 3, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599949217078112257, 1594521413162733569, 'job_plan_export', '计划导出', 'button', '', '', 4, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599949426399047681, 1594521413162733569, 'job_plan_distributed', '计划派工', 'button', '', '', 5, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599949565360533506, 1594521413162733569, 'job_plan_additional', '计划追加', 'button', '', '', 6, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599949740036517889, 1594521413162733569, 'job_plan_suspended', '计划暂停', 'button', '', '', 7, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599949969905348609, 1594521413162733569, 'job_plan_close', '计划关闭', 'button', '', '', 8, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599950097730957313, 1594521413162733569, 'job_plan_delete', '计划删除', 'button', '', '', 9, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599967268410040322, 1594524229658841089, 'report_history_export', '报工记录导出', 'report_history_export', '', '', 8,
| 2, 0, 1, '', 0, 'CPS', 1),
| (1600664450734919681, 1594524229658841089, 'job_work_delete', '删除', 'job_work_delete', '', '', 9, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599950099730957311, 1594521413162733569, 'job_plan_list', '计划列表', 'button', '', '', 10, 2, 0, 1, '', 0, 'CPS',
| 1),
| (1599950099730957312, 1594521413162733569, 'job_plan_reboot', '计划重启', 'button', '', '', 11, 2, 0, 1, '', 0,
| 'CPS', 1),
| (1599950099730957313, 1594521413162733569, 'job_plan_finish', '计划完工', 'button', '', '', 12, 2, 0, 1, '', 0, 'CPS',
| 1);
|
|
|
| -- 工单编码规则
| INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted)
| VALUES (1595651058122289153, 1531087267316621313, 'code_rule_for_biz_objects', 'Order', '工单', 1, '', 0, 0);
| INSERT INTO blade_meta_object_type (f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key,
| rule_field, rule_dict_code, code)
| VALUES ('Order', '工单', NULL, 'CoProduction', 'blade_order', 'id', 'plan_id', 'id', NULL, NULL, 'order_code');
| INSERT INTO blade_meta_object_type_field (id, object_id, f_code, f_name, field, element_type, enum_type, seq)
| VALUES (1595653060172640257, 'Order', 'plan_id', '计划', 'planId', '5', NULL, 0);
| INSERT INTO blade_bas_coderule (id, name, remark, bill_form_id, system_default, auto_billno, repair_billno,
| const_length, create_user, create_dept, create_time, update_user, update_time, status,
| is_deleted, rule_field_dict_key, preview)
| VALUES (1595657697210212353, '工单', '工单', 'Order', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201,
| '2022-11-24 13:56:56', 1123598821738675201, '2022-11-28 16:22:16', 1, 0, NULL, '-001');
| INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1595657697231183873, 1595657697210212353, 1, 5, 'plan_id', 1, 0, '', '', 1, 1, '', '', '', 1, 0, 0, 1);
| INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1595657697235378178, 1595657697210212353, 3, 0, '', NULL, 3, '', '', 1, 1, '', '', '0', 1, 0, 0, 1);
| INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1595658353455210498, 1595657697210212353, 2, 1, '', NULL, 1, '', '-', 1, 1, '', '', '', 1, 0, 0, 1);
| INSERT INTO blade_meta_ref_object_type (object_type_id, ref_object_type_id, field_name, id)
| VALUES ('Order', 'CoPlan', 'plan_id', 1595657548199174145);
|
| -- 计划编号编码规则
| INSERT INTO blade_bas_coderule(id, name, remark, bill_form_id, system_default, auto_billno, repair_billno, const_length,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted,
| rule_field_dict_key, preview)
| VALUES (1598203747095384066, '计划', '计划编码', 'CoPlan', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201,
| '2022-12-01 14:34:01', 1123598821738675201, '2022-12-01 14:34:03', 1, 0, NULL, '20221201-RS5-R-001');
| INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1598203747158298626, 1598203747095384066, 1, 2, 'create_time', NULL, 8, 'yyyyMMdd', '', 1, 1, '-', '', '', 1, 0,
| 0, 1);
| INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1598203747162492929, 1598203747095384066, 2, 1, '', NULL, 3, '', 'RS5', 1, 1, '-', '', '', 1, 0, 0, 1);
| INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1598203747166687234, 1598203747095384066, 3, 1, '', NULL, 1, '', 'R', 1, 1, '-', '', '', 1, 0, 0, 1);
| INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
| element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
| add_style, code_only_by, code_element)
| VALUES (1598203747166687235, 1598203747095384066, 4, 0, '', NULL, 3, '', '', 1, 1, '', '', '0', 1, 0, 0, 1);
| INSERT INTO blade_meta_object_type_field(id, object_id, f_code, f_name, field, element_type, enum_type, seq)
| VALUES (1598203200812453890, 'CoPlan', 'create_time', '创建时间', 'createTime', '2', NULL, 0);
| INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted)
| VALUES (1531090589473823540, 1531087267316621313, 'code_rule_for_biz_objects', 'CoPlan', '计划', 0, '', 0, 0);
| INSERT INTO blade_meta_object_type(f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key,
| rule_field, rule_dict_code, code)
| VALUES ('CoPlan', '计划', NULL, 'CoProduction', 'blade_plan', 'id', 'code', 'id', NULL, NULL, 'code');
| -- 数据权限
| INSERT INTO blade_scope_api VALUES (1599960953099784192, 1599950099730957311, 'coproduction_plan.detail', '计划查看详情', '/blade-coproduction/plan/get/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784193, 1599950099730957311, 'coproduction_plan.page', '计划列表分页', '/blade-coproduction/plan/page', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784194, 1599948830497501186, 'coproduction_plan.save', '计划新增', '/blade-coproduction/plan/save', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784195, 1599948991642660865, 'coproduction_plan.modify', '计划修改', '/blade-coproduction/plan/modify', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784196, 1599950097730957313, 'coproduction_plan.remove', '计划删除', '/blade-coproduction/plan/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784197, 1599949565360533506, 'coproduction_plan.append', '计划追加', '/blade-coproduction/plan/append', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784198, 1599949740036517889, 'coproduction_plan.pause', '计划暂停', '/blade-coproduction/plan/pause', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784199, 1599950099730957312, 'coproduction_plan.reboot', '计划重启', '/blade-coproduction/plan/reboot', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784200, 1599949079353946114, 'coproduction_plan.template', '计划导入模板下载', '/blade-coproduction/plan/template', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784201, 1599949079353946114, 'coproduction_plan.import', '计划导入', '/blade-coproduction/plan/import', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784202, 1599949217078112257, 'coproduction_plan.export', '计划导出', '/blade-coproduction/plan/export', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784203, 1599950099730957313, 'coproduction_plan.finish', '计划完工', '/blade-coproduction/plan/finish', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784204, 1599949969905348609, 'coproduction_plan.close', '计划关闭', '/blade-coproduction/plan/close', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784205, 1599717873215295489, 'coproduction_plan.editWorkstation', '编辑工位', '/blade-coproduction/plan/editWorkstation', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
| INSERT INTO blade_scope_api VALUES (1599960953099784222, 1594521413162733569, 'coproduction_plan.statusCount', '计划页上方状态数量总览','/blade-coproduction/plan/statusCount', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,'2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
|
|
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599961117681328130, 1599949426399047681, 'order.assign', '工单派发', '/blade-coproduction/order/assign', NULL,
| NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 10:57:11', 1123598821738675201,
| '2022-12-06 10:57:11', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599961227261714434, 1594521413162733569, 'plan_process.list_by_plan_id', '计划工序列表',
| '/blade-coproduction/plan-process/list-by-plan-id', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
| '2022-12-06 10:57:37', 1123598821738675201, '2022-12-06 10:57:37', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599961446795780098, 1594521413162733569, 'order_process.tree_workstation', '获取指派的工位组以及工位',
| '/blade-coproduction/order-process/tree-workstation', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 10:58:29', 1123598821738675201, '2022-12-06 10:58:29', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599961674936557570, 1594521413162733569, 'order.plan_order_list', '计划工单列表',
| '/blade-coproduction/order/plan-order-list', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
| '2022-12-06 10:59:24', 1123598821738675201, '2022-12-06 10:59:24', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599962064025362434, 1594521413162733569, 'plan.detail', 'blade_plan详情', '/blade-coproduction/plan/get/*', NULL,
| NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:00:57', 1123598821738675201,
| '2022-12-06 11:00:57', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599962305147510786, 1594524229658841089, 'order.list', '工单主页列表', '/blade-coproduction/order/list', NULL, NULL,
| 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:01:54', 1123598821738675201,
| '2022-12-06 11:01:54', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599962398688878593, 1594524229658841089, 'order_process.detail', '工单工序详情',
| '/blade-coproduction/order-process/detail', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
| '2022-12-06 11:02:16', 1123598821738675201, '2022-12-06 11:02:16', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599962692835418114, 1594524229658841089, 'order_process.tree_workstation', '获取指派的工位组以及工位',
| '/blade-coproduction/order-process/tree-workstation', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:03:26', 1123598821738675201, '2022-12-06 11:03:26', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599962774611763201, 1594524229658841089, 'order_process.get_relation', '获取刀具、夹具信息',
| '/blade-coproduction/order-process/get-relation', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
| '2022-12-06 11:03:46', 1123598821738675201, '2022-12-06 11:03:46', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599966795124776961, 1599727121952526337, 'order_report_record.page_query', '分页查询工单报工记录',
| '/blade-coproduction/order-report-record/page-query', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:19:45', 1123598821738675201, '2022-12-06 11:19:45', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599967401986039809, 1599967268410040322, 'order_report_record.record_export', '导出报工记录',
| '/blade-coproduction/order-report-record/record-export', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:22:09', 1123598821738675201, '2022-12-06 11:22:09', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599969158061432833, 1599727121952526337, 'order_report_record.query_child_record', '查询主序下子序相关信息',
| '/blade-coproduction/order-report-record/query-child-record', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:29:08', 1123598821738675201, '2022-12-06 11:29:08', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970340100567042, 1599717707783557122, 'order_process.report_parallel', '报工(并行序)',
| '/blade-coproduction/order-process/report-parallel', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:33:50', 1123598821738675201, '2022-12-06 11:33:50', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970340104761345, 1599717707783557122, 'order_process.report_work', '报工(非并行序)',
| '/blade-coproduction/order-process/report-work', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
| '2022-12-06 11:33:50', 1123598821738675201, '2022-12-06 11:33:50', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970386216939521, 1599717577688829954, 'order_process.start_detail_general', '开工页面详情(非并行序)',
| '/blade-coproduction/order-process/start-detail-general', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970386216939522, 1599717577688829954, 'order_process.start_detail_parallel', '开工页面详情(并行序)',
| '/blade-coproduction/order-process/start-detail-parallel', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970386221133825, 1599717577688829954, 'order_process.start_general', '开工(非并行序)',
| '/blade-coproduction/order-process/start-general', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
| '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970386221133826, 1599717577688829954, 'order_process.start_parallel', '开工(并行序)',
| '/blade-coproduction/order-process/start-parallel', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970399634518017, 1599725934163382273, 'order_report_record.edit_order_parallel_record', '编辑并行序报工记录',
| '/blade-coproduction/order-report-record/edit-parallel-record', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:04', 1123598821738675201, '2022-12-06 11:34:04', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970399638712321, 1599725934163382273, 'order_report_record.edit_order_record', '编辑非行序报工记录',
| '/blade-coproduction/order-report-record/edit-common-record', NULL, NULL, 'POST', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:04', 1123598821738675201, '2022-12-06 11:34:04', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970433344139265, 1599726500805464065, 'order_report_record.remove_report_record', '删除报工记录id',
| '/blade-coproduction/order-report-record/remove-report-record', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:12', 1123598821738675201, '2022-12-06 11:34:12', 1, 0);
| INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
| create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
| VALUES (1599970533021773826, 1599717577688829954, 'order_workstation.get_workstation_can_start', '获得可开工的工位)',
| '/blade-coproduction/order-workstation/get-workstation-can-start', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-06 11:34:36', 1123598821738675201, '2022-12-06 11:34:36', 1, 0);
| INSERT INTO blade_boot.blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type,
| remark, http_method, create_user, create_dept, create_time,
| update_user, update_time, status, is_deleted)
| VALUES (1601031782210977794, 1600664450734919681, 'order.remove', '计划工单删除', '/blade-coproduction/order/remove', NULL,
| NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-12-09 09:51:37', 1123598821738675201,
| '2022-12-09 09:51:37', 1, 0);
| INSERT INTO `blade_scope_api` (`id`, `menu_id`, `resource_code`, `scope_name`, `scope_path`, `scope_type`, `remark`,
| `http_method`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`,
| `status`, `is_deleted`)
| VALUES (1602122216145076226, 1599725934163382273, 'order_report_record.report_records_detail', '编辑报工记录展开详情',
| '/blade-coproduction/order-report-record/report-record-detail', NULL, NULL, 'GET', 1123598821738675201,
| 1123598813738675201, '2022-12-12 10:04:37', 1123598821738675201, '2022-12-12 10:04:37', 1, 0);
|
|
