1.0.217.sql 2.0 KB

1234567891011121314151617181920212223
  1. -- ============================================================
  2. -- 1.0.217.sql
  3. -- A2-1-S5-INVENTORY-5PAGES-REAL-PAGE-1
  4. --
  5. -- 业务目标:将 S5 库存数据目录 (1322000000017) 下除标签查询外的 5 条既有三级菜单
  6. -- 的 Component 由占位组件 /aidop/planning/index 重指到真实只读页面:
  7. -- - 1329015030002 暂收在检列表 → /aidop/s5/inventory/pendingInspectionList
  8. -- - 1329015030003 库存查询 → /aidop/s5/inventory/stockQueryList
  9. -- - 1329015030004 进出存查询 → /aidop/s5/inventory/inoutQueryList
  10. -- - 1329015030005 盘点标签确认 → /aidop/s5/inventory/stocktakeLabelConfirmList
  11. -- - 1329015030006 盘点结果查询 → /aidop/s5/inventory/stocktakeResultList
  12. --
  13. -- 安全保证:
  14. -- - 仅 UPDATE 五条既有菜单的 Component / Remark / UpdateTime;不新增、不 DELETE / DROP / TRUNCATE。
  15. -- - 菜单 Id / Pid / Path / Name / 租户分配(SysTenantMenu)均不变,无需补分配。
  16. -- - 不动标签查询菜单 (1329015030001);不动 SysRoleMenu / SysOrg / SysUser / SysRole / SysTenant;不动其他 Sx 菜单。
  17. -- ============================================================
  18. UPDATE SysMenu SET Component = '/aidop/s5/inventory/pendingInspectionList', Remark = 'S5 暂收在检列表(只读列表)', UpdateTime = NOW() WHERE Id = 1329015030002;
  19. UPDATE SysMenu SET Component = '/aidop/s5/inventory/stockQueryList', Remark = 'S5 库存查询(只读列表)', UpdateTime = NOW() WHERE Id = 1329015030003;
  20. UPDATE SysMenu SET Component = '/aidop/s5/inventory/inoutQueryList', Remark = 'S5 进出存查询(只读列表)', UpdateTime = NOW() WHERE Id = 1329015030004;
  21. UPDATE SysMenu SET Component = '/aidop/s5/inventory/stocktakeLabelConfirmList', Remark = 'S5 盘点标签确认(只读列表)', UpdateTime = NOW() WHERE Id = 1329015030005;
  22. UPDATE SysMenu SET Component = '/aidop/s5/inventory/stocktakeResultList', Remark = 'S5 盘点结果查询(只读列表)', UpdateTime = NOW() WHERE Id = 1329015030006;