-- =====================================================================================================================================
-- CZ060/CZ061 工位对齐脚本（第二版，依据《新版工位.xlsx》2026-10-16）
-- 上一版脚本：db/cz060_cz061_routing_align.sql（按布线说明表对齐），本版按新版工位表收敛站点口径
--
-- 改动总览：
--   1. mes_line_process（生产工位管理）
--      CZ060(line_id=2102288813172203520) 删除 5 个新版取消的工位（含 A 变体，共 10 行）：
--        OP060 干冰清洁 / OP176 TIG手工焊 / OP200 电泳 / OP215 水道气密二序 / OP255 绝缘耐压测试
--        注：OP176 为上一版新增，新版已取消（TIG手工焊仅保留 OP085、OP120）
--      CZ061(line_id=2102288695354204160) 删除 2 个工位（含 A 变体，共 4 行）：
--        OP060 干冰清洁 / OP165 拉铆
--      CZ061 工位名称修正（与新表一致）：OP100/OP100A 预拼锁付→前膨胀梁打码，OP105/OP105A 后膨胀梁打码→预拼锁付
--      CZ060 OP166A 排序修正：sorts 155→166（主码 OP166 为 166）
--      其余工位编号/名称已与新表完全一致，无需改动
--   2. mes_template_items（建档模板）：删除上述已取消工位的"工位结果"模板项，
--      防止新建档生成已取消工位的 UDF 记录（否则 OP195 等下游动态检查会扫到幽灵记录）
--   3. js_sys_config（跳站配置）：mes.pass.oprno.cz060 / mes.pass.oprno.cz061 移除已删工位条目
--      （其余跳站成员不变；两产线防呆当前全部关闭，跳站配置不影响现有过站逻辑）
--   4. mes_icons（功能模块 cz060_icon_100~119）：核对无需改动 ——
--      20 个 PDA 工位 OP065A/OP090A/OP100/OP125/OP140/OP166/OP175/OP180/OP185/OP190/OP195/
--      OP220/OP225/OP230/OP235/OP240/OP245/OP260/OP265/OP270 的编号、名称与新表全部一致
--
-- 幂等性：所有语句可重复执行；执行后工位/模板表即时生效，跳站配置需重启服务或在后台"系统配置"页重新保存一次触发缓存刷新
-- =====================================================================================================================================

-- ---------------------------------------------------------------- 1. 生产工位管理 ----------------------------------------------------------------

-- 1.1 CZ060 删除新版取消的工位（含 A 变体）
DELETE FROM mes_line_process WHERE line_id = '2102288813172203520' AND oprno IN ('OP060','OP060A','OP176','OP176A','OP200','OP200A','OP215','OP215A','OP255','OP255A');

-- 1.2 CZ061 删除新版取消的工位（含 A 变体）
DELETE FROM mes_line_process WHERE line_id = '2102288695354204160' AND oprno IN ('OP060','OP060A','OP165','OP165A');

-- 1.3 CZ061 工位名称修正
UPDATE mes_line_process SET title = '前膨胀梁打码', update_by = 'system', update_date = NOW() WHERE line_id = '2102288695354204160' AND oprno IN ('OP100','OP100A') AND title <> '前膨胀梁打码';
UPDATE mes_line_process SET title = '预拼锁付',     update_by = 'system', update_date = NOW() WHERE line_id = '2102288695354204160' AND oprno IN ('OP105','OP105A') AND title <> '预拼锁付';

-- 1.4 CZ060 OP166A 排序修正
UPDATE mes_line_process SET sorts = 166, update_by = 'system', update_date = NOW() WHERE id = '1790149168072073' AND sorts <> 166;

-- ---------------------------------------------------------------- 2. 建档模板 ----------------------------------------------------------------

-- 2.1 CZ060 模板删除已取消工位项
DELETE FROM mes_template_items WHERE template_id = '2102266346164490240' AND oprno IN ('OP060','OP176','OP200','OP215','OP255') AND title = '工位结果';

-- 2.2 CZ061 模板删除已取消工位项
DELETE FROM mes_template_items WHERE template_id = '2102266410110849024' AND oprno IN ('OP060','OP165') AND title = '工位结果';

-- ---------------------------------------------------------------- 3. 跳站配置 ----------------------------------------------------------------

-- 3.1 CZ060：移除 OP060/OP176/OP200/OP215（含 A 变体），其余不变
UPDATE js_sys_config SET config_value = 'OP035,OP035A,OP040,OP040A,OP045,OP045A,OP050,OP050A,OP055,OP055A,OP070,OP070A,OP075,OP075A,OP080,OP080A,OP085,OP085A,OP095,OP095A,OP105,OP105A,OP110,OP110A,OP115,OP115A,OP120,OP120A,OP130,OP130A,OP135,OP135A,OP145,OP145A,OP150,OP150A,OP160,OP160A,OP165,OP165A,OP170,OP170A,OP205,OP205A,OP210,OP210A,OP250,OP250A', update_date = NOW() WHERE config_key = 'mes.pass.oprno.cz060';

-- 3.2 CZ061：移除 OP060/OP165（含 A 变体），其余不变
UPDATE js_sys_config SET config_value = 'OP035,OP035A,OP040,OP040A,OP045,OP045A,OP050,OP050A,OP055,OP055A,OP065,OP065A,OP070,OP070A,OP075,OP075A,OP080,OP080A,OP085,OP085A,OP090,OP090A,OP095,OP095A,OP100,OP100A,OP105,OP105A,OP110,OP110A,OP115,OP115A,OP120,OP120A,OP130,OP130A,OP135,OP135A,OP145,OP145A,OP150,OP150A,OP170,OP170A,OP175,OP175A,OP180,OP180A,OP185,OP185A,OP200,OP200A,OP205,OP205A,OP210,OP210A,OP215,OP215A,OP220,OP220A,OP250,OP250A,OP255,OP255A', update_date = NOW() WHERE config_key = 'mes.pass.oprno.cz061';

-- =====================================================================================================================================
-- 回滚参考（默认注释，仅灾难恢复时使用）
-- =====================================================================================================================================
-- 4.1 恢复 CZ060 工位
-- INSERT INTO mes_line_process (id,line_id,title,oprno,remark,status,sorts,create_by,create_date,update_by,update_date,`repeat`,quality,devices,gzs,stop,pid,auto,online) VALUES
-- ('1790149154028006','2102288813172203520','干冰清洁','OP060','','0','60','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168069054','2102288813172203520','干冰清洁','OP060A',NULL,'0','60','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154028006',NULL,NULL),
-- ('2026101517000001','2102288813172203520','TIG手工焊','OP176','','0','176','system','2026-10-15 04:32:44','system',NOW(),'1','0','','','0',NULL,NULL,''),
-- ('2026101517000002','2102288813172203520','TIG手工焊','OP176A','','0','176','system','2026-10-15 04:32:44','system',NOW(),'1','0','','','0','2026101517000001',NULL,''),
-- ('1790149154033034','2102288813172203520','电泳','OP200',NULL,'0','200','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168073082','2102288813172203520','电泳','OP200A',NULL,'0','200','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154033034',NULL,NULL),
-- ('1790149154033037','2102288813172203520','水道气密二序','OP215',NULL,'0','215','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168074085','2102288813172203520','水道气密二序','OP215A',NULL,'0','215','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154033037',NULL,NULL),
-- ('1790149154035045','2102288813172203520','绝缘耐压测试','OP255',NULL,'0','255','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168074093','2102288813172203520','绝缘耐压测试','OP255A',NULL,'0','255','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154035045',NULL,NULL);
-- 4.2 恢复 CZ061 工位
-- INSERT INTO mes_line_process (id,line_id,title,oprno,remark,status,sorts,create_by,create_date,update_by,update_date,`repeat`,quality,devices,gzs,stop,pid,auto,online) VALUES
-- ('1790149154065053','2102288695354204160','干冰清洁','OP060','','0','60','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168062006','2102288695354204160','干冰清洁','OP060A',NULL,'0','60','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154065053',NULL,NULL),
-- ('1790149154068073','2102288695354204160','拉铆','OP165',NULL,'0','165','system','2026-09-23 15:39:14','system',NOW(),'1','0',NULL,NULL,'0',NULL,NULL,NULL),
-- ('1790149168065026','2102288695354204160','拉铆','OP165A',NULL,'0','165','system','2026-09-23 15:39:28','system',NOW(),'1','0',NULL,NULL,'0','1790149154068073',NULL,NULL);
-- 4.3 恢复 CZ061 工位名称 / CZ060 OP166A 排序
-- UPDATE mes_line_process SET title='预拼锁付'     WHERE line_id='2102288695354204160' AND oprno IN ('OP100','OP100A');
-- UPDATE mes_line_process SET title='后膨胀梁打码' WHERE line_id='2102288695354204160' AND oprno IN ('OP105','OP105A');
-- UPDATE mes_line_process SET sorts=155 WHERE id='1790149168072073';
-- 4.4 恢复模板项（id 沿用原值）
-- INSERT INTO mes_template_items (id,template_id,oprno,craft,cate,title,status,create_by,create_date,update_by,update_date,`rank`) VALUES
-- ('1790055941711006','2102266346164490240','OP060','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'60'),
-- ('2026101517000011','2102266346164490240','OP176','100000','','工位结果','0','system','2026-10-15 04:32:44','system',NOW(),'176'),
-- ('1790055941711034','2102266346164490240','OP200','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'200'),
-- ('1790055941711037','2102266346164490240','OP215','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'215'),
-- ('1790055941711045','2102266346164490240','OP255','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'255'),
-- ('1790055941748053','2102266410110849024','OP060','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'60'),
-- ('1790055941748073','2102266410110849024','OP165','100000',NULL,'工位结果','0','system','2026-09-22 13:45:41','system',NOW(),'165');
-- 4.5 恢复跳站配置原值
-- UPDATE js_sys_config SET config_value='OP035,OP035A,OP040,OP040A,OP045,OP045A,OP050,OP050A,OP055,OP055A,OP060,OP060A,OP070,OP070A,OP075,OP075A,OP080,OP080A,OP085,OP085A,OP095,OP095A,OP105,OP105A,OP110,OP110A,OP115,OP115A,OP120,OP120A,OP130,OP130A,OP135,OP135A,OP145,OP145A,OP150,OP150A,OP160,OP160A,OP165,OP165A,OP170,OP170A,OP176,OP176A,OP200,OP200A,OP205,OP205A,OP210,OP210A,OP215,OP215A,OP250,OP250A' WHERE config_key='mes.pass.oprno.cz060';
-- UPDATE js_sys_config SET config_value='OP035,OP035A,OP040,OP040A,OP045,OP045A,OP050,OP050A,OP055,OP055A,OP060,OP060A,OP065,OP065A,OP070,OP070A,OP075,OP075A,OP080,OP080A,OP085,OP085A,OP090,OP090A,OP095,OP095A,OP100,OP100A,OP105,OP105A,OP110,OP110A,OP115,OP115A,OP120,OP120A,OP130,OP130A,OP135,OP135A,OP145,OP145A,OP150,OP150A,OP165,OP165A,OP170,OP170A,OP175,OP175A,OP180,OP180A,OP185,OP185A,OP200,OP200A,OP205,OP205A,OP210,OP210A,OP215,OP215A,OP220,OP220A,OP250,OP250A,OP255,OP255A' WHERE config_key='mes.pass.oprno.cz061';