-- 设备备件管理：备件台账与初始库存流水种子数据
-- 前提：已执行 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));