1.0.219.sql 1.8 KB

123456789101112131415161718192021
  1. -- ============================================================
  2. -- 1.0.219.sql
  3. -- A4-S7-FINISHED-WAREHOUSE-4PAGES-REAL-PAGE-1
  4. --
  5. -- 业务目标:将 S7 成品仓储下 4 条既有三级菜单的 Component
  6. -- 由占位组件 /aidop/planning/index 重指到真实只读页面:
  7. -- - 1329017010001 FQC检验任务列表 → /aidop/s7/fqc/fqcInspectionTaskList
  8. -- - 1329017010002 FQC检验结果列表 → /aidop/s7/fqc/fqcInspectionResultList
  9. -- - 1329017020001 生产入库单列表 → /aidop/s7/production-receipt/productionInboundList
  10. -- - 1329017030001 销售发货通知 → /aidop/s7/finished-outbound/salesDeliveryNoticeList
  11. --
  12. -- 安全保证:
  13. -- - 仅 UPDATE 四条既有菜单的 Component / Remark / UpdateTime;不新增、不 DELETE / DROP / TRUNCATE。
  14. -- - 菜单 Id / Pid / Path / Name / 租户分配(SysTenantMenu)均不变,无需补分配。
  15. -- - 不动 SysRoleMenu / SysOrg / SysUser / SysRole / SysTenant;不动 S5 / S6 / S8 及其他 S7 菜单。
  16. -- ============================================================
  17. UPDATE SysMenu SET Component = '/aidop/s7/fqc/fqcInspectionTaskList', Remark = 'S7 FQC检验任务列表(只读列表)', UpdateTime = NOW() WHERE Id = 1329017010001;
  18. UPDATE SysMenu SET Component = '/aidop/s7/fqc/fqcInspectionResultList', Remark = 'S7 FQC检验结果列表(只读列表)', UpdateTime = NOW() WHERE Id = 1329017010002;
  19. UPDATE SysMenu SET Component = '/aidop/s7/production-receipt/productionInboundList', Remark = 'S7 生产入库单列表(只读列表)', UpdateTime = NOW() WHERE Id = 1329017020001;
  20. UPDATE SysMenu SET Component = '/aidop/s7/finished-outbound/salesDeliveryNoticeList', Remark = 'S7 销售发货通知(只读列表)', UpdateTime = NOW() WHERE Id = 1329017030001;