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
| -- 排班计划编码规则（可重复执行）
| -- 格式：PB + yyyyMMdd + 4 位流水号，例如 PB202610250001；流水号按天重置。
|
| INSERT INTO `mes_md_auto_code_rule`
| (`code`, `name`, `description`, `max_length`, `padded`, `padded_char`, `padded_method`,
| `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
| SELECT 'CAL_PLAN_CODE', '排班计划编码', '排班计划自动编码', 14, b'0', NULL, NULL,
| 0, '系统内置规则', 'system', NOW(), 'system', NOW(), b'0'
| WHERE NOT EXISTS (
| SELECT 1 FROM `mes_md_auto_code_rule` WHERE `code` = 'CAL_PLAN_CODE' AND `deleted` = b'0'
| );
|
| SET @cal_plan_rule_id := (
| SELECT `id` FROM `mes_md_auto_code_rule`
| WHERE `code` = 'CAL_PLAN_CODE' AND `deleted` = b'0'
| ORDER BY `id` LIMIT 1
| );
|
| INSERT INTO `mes_md_auto_code_part`
| (`rule_id`, `sort`, `type`, `length`, `fix_character`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
| SELECT @cal_plan_rule_id, 1, 3, 2, 'PB', 'system', NOW(), 'system', NOW(), b'0'
| WHERE NOT EXISTS (
| SELECT 1 FROM `mes_md_auto_code_part`
| WHERE `rule_id` = @cal_plan_rule_id AND `sort` = 1 AND `deleted` = b'0'
| );
|
| INSERT INTO `mes_md_auto_code_part`
| (`rule_id`, `sort`, `type`, `length`, `date_format`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
| SELECT @cal_plan_rule_id, 2, 2, 8, 'yyyyMMdd', 'system', NOW(), 'system', NOW(), b'0'
| WHERE NOT EXISTS (
| SELECT 1 FROM `mes_md_auto_code_part`
| WHERE `rule_id` = @cal_plan_rule_id AND `sort` = 2 AND `deleted` = b'0'
| );
|
| INSERT INTO `mes_md_auto_code_part`
| (`rule_id`, `sort`, `type`, `length`, `serial_start_no`, `serial_step`, `cycle_flag`, `cycle_method`,
| `creator`, `create_time`, `updater`, `update_time`, `deleted`)
| SELECT @cal_plan_rule_id, 3, 4, 4, 1, 1, b'1', 3,
| 'system', NOW(), 'system', NOW(), b'0'
| WHERE NOT EXISTS (
| SELECT 1 FROM `mes_md_auto_code_part`
| WHERE `rule_id` = @cal_plan_rule_id AND `sort` = 3 AND `deleted` = b'0'
| );
|
|
