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