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
| -- 设备备件管理：备件台账与初始库存流水种子数据
| -- 前提：已执行 mes_dv_spare_init.sql（建表 + 菜单）
| -- 幂等，可重复执行
| -- 说明：领用/退回流水（type=3/4）需挂真实维修单，不由本脚本生成；后续通过界面领用产生
|
| -- ========== 备件台账 ==========
| INSERT INTO mes_dv_spare_part
| (code, name, specification, unit, location, stock_quantity, safety_quantity, status, remark, creator, updater)
| VALUES
| ('SP-0001','深沟球轴承','6205-2RS','件','A区-01',20,4,0,'通用备件','1','1'),
| ('SP-0002','骨架油封','TC 35x52x7','件','A区-01',30,6,0,'通用备件','1','1'),
| ('SP-0003','三角皮带','A-900','条','A区-02',15,4,0,'传动件','1','1'),
| ('SP-0004','同步带','HTD 8M-1200','条','A区-02',8,2,0,'传动件','1','1'),
| ('SP-0005','空气滤芯','AF-200x300','个','B区-01',24,6,0,'空压机保养件','1','1'),
| ('SP-0006','机油滤芯','JX-0810','个','B区-01',24,6,0,'空压机保养件','1','1'),
| ('SP-0007','交流接触器','CJX2-2510 220V','个','B区-02',18,5,0,'电气件','1','1'),
| ('SP-0008','热继电器','JR36-20','个','B区-02',12,4,0,'电气件','1','1'),
| ('SP-0009','变频器散热风扇','D1751','个','B区-03',10,3,0,'电气件','1','1'),
| ('SP-0010','O型密封圈','NBR 50x3.5','件','C区-01',50,10,0,'密封件','1','1'),
| ('SP-0011','泵用机械密封','108-25','套','C区-02',6,2,0,'泵类备件','1','1'),
| ('SP-0012','联轴器弹性块','GR28','个','C区-02',16,4,0,'传动件','1','1')
| ON DUPLICATE KEY UPDATE id = id;
|
| -- ========== 初始库存流水（type=1，与台账库存一致） ==========
| INSERT INTO mes_dv_spare_movement
| (request_key, spare_part_id, spare_part_code, spare_part_name, specification, unit,
| type, quantity, before_quantity, after_quantity, operator_user_id, remark, creator, updater)
| SELECT CONCAT('SPARE-INIT-', p.code), p.id, p.code, p.name, p.specification, p.unit,
| 1, p.stock_quantity, 0, p.stock_quantity, 1,
| CONCAT('初始库存登记：', p.name, ' ', p.stock_quantity, p.unit), '1', '1'
| FROM mes_dv_spare_part p
| WHERE p.deleted = b'0' AND p.stock_quantity > 0
| AND NOT EXISTS (SELECT 1 FROM mes_dv_spare_movement m WHERE m.request_key = CONCAT('SPARE-INIT-', p.code));
|
|
