-- 下线销售质检业务线：逻辑删除“销售质检”菜单及按钮权限，清理销售质检审核人配置。
|
-- 出货检验（OQC）基础功能保留。
|
|
-- 1. 删除销售质检按钮权限
|
UPDATE system_menu SET deleted = b'1', update_time = NOW()
|
WHERE deleted = b'0'
|
AND permission IN ('mes:qc-oqc:retest', 'mes:qc-oqc:sales-approve', 'mes:qc-oqc:company-approve');
|
|
-- 2. 逻辑删除“销售质检”菜单
|
UPDATE system_menu SET deleted = b'1', update_time = NOW()
|
WHERE deleted = b'0' AND parent_id = 5500 AND path = 'sales-quality';
|
|
-- 3. 清理角色与销售质检菜单的关联（system_role_menu 无 deleted 列，物理删除）
|
DELETE rm FROM system_role_menu rm
|
JOIN system_menu m ON rm.menu_id = m.id
|
WHERE m.permission IN ('mes:qc-oqc:retest', 'mes:qc-oqc:sales-approve', 'mes:qc-oqc:company-approve')
|
OR (m.parent_id = 5500 AND m.path = 'sales-quality');
|
|
-- 4. 逻辑删除销售质检审核人配置
|
UPDATE mes_qc_approver_config SET deleted = b'1', update_time = NOW()
|
WHERE deleted = b'0' AND qc_type = 2;
|
|
-- 可选：确认无历史数据后，再清理销售质检遗留的表结构与字段
|
-- DROP TABLE IF EXISTS mes_qc_oqc_action;
|
-- ALTER TABLE mes_qc_oqc
|
-- DROP COLUMN workflow_status,
|
-- DROP COLUMN inspection_round,
|
-- DROP COLUMN retest_of_id;
|
