WMS/sql/06_agv_tasklog_menu.sql
sunwang c76e7bb681 fix:永丰售后修复BUG,
1,物料库存获取不到ERP:重新调整触发查询逻辑
2,工序变更导致物料无法出库:配置旧工序
3,测试出库订单ERP推送,任务下发
2026-10-29 13:12:11 +08:00

81 lines
3.6 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- =============================================================
-- AGV 平库对接 · 06 AgvTaskLog 日志页 菜单/权限 DML
-- 说明:
-- 1) 日志页为只读(列表+搜索+详情),对应 AgvTaskLogController;
-- 2) 菜单/权限参照 05_agv_dml_menu.sql 的 SceneConfig 插入方式;
-- 3) 脚本可重复执行。
-- =============================================================
-- -------------------------------------------------------------
-- 1) 菜单:AGV 任务日志页(Area: agv,见 AgvTaskLogController)
-- -------------------------------------------------------------
SET @agv_tasklog_page_id = (
SELECT `ID` FROM `frameworkmenus`
WHERE `ClassName` = 'HHWMS.Web.Controllers,AgvTaskLogController'
AND (`MethodName` IS NULL OR `MethodName` = '')
ORDER BY `ShowOnMenu` DESC, `DisplayOrder`
LIMIT 1
);
INSERT INTO `frameworkmenus`
(`ID`, `PageName`, `ActionName`, `ModuleName`, `FolderOnly`, `IsInherit`,
`ClassName`, `MethodName`, `Domain`, `ShowOnMenu`, `IsPublic`, `DisplayOrder`,
`IsInside`, `TenantAllowed`, `Url`, `Icon`, `ParentId`)
SELECT
UUID(), 'AGV日志', 'AGV日志', NULL, 0, 0,
'HHWMS.Web.Controllers,AgvTaskLogController', '',
NULL, 1, 0, 102, 1, 1, '/agv/AgvTaskLog/Index', NULL, NULL
WHERE @agv_tasklog_page_id IS NULL;
SET @agv_tasklog_page_id = (
SELECT `ID` FROM `frameworkmenus`
WHERE `ClassName` = 'HHWMS.Web.Controllers,AgvTaskLogController'
AND (`MethodName` IS NULL OR `MethodName` = '')
ORDER BY `ShowOnMenu` DESC, `DisplayOrder`
LIMIT 1
);
-- 日志页详情动作权限(查看报文)
INSERT INTO `frameworkmenus`
(`ID`, `PageName`, `ActionName`, `ModuleName`, `FolderOnly`, `IsInherit`,
`ClassName`, `MethodName`, `Domain`, `ShowOnMenu`, `IsPublic`, `DisplayOrder`,
`IsInside`, `TenantAllowed`, `Url`, `Icon`, `ParentId`)
SELECT
UUID(), 'AGV日志详情', 'AGV日志详情', `ModuleName`, 0, 0,
`ClassName`, 'Details', `Domain`, 0, 0,
(SELECT COALESCE(MAX(child.`DisplayOrder`), 0) + 1 FROM `frameworkmenus` child
WHERE child.`ParentId` = @agv_tasklog_page_id),
1, `TenantAllowed`, '/agv/AgvTaskLog/Details', NULL, `ID`
FROM `frameworkmenus` WHERE `ID` = @agv_tasklog_page_id
AND NOT EXISTS (SELECT 1 FROM `frameworkmenus`
WHERE `ClassName` = 'HHWMS.Web.Controllers,AgvTaskLogController'
AND `MethodName` = 'Details');
-- 给已有日志页权限的角色授予详情权限
INSERT INTO `functionprivileges`
(`ID`, `RoleCode`, `MenuItemId`, `Allowed`, `TenantCode`,
`CreateTime`, `CreateBy`, `UpdateTime`, `UpdateBy`)
SELECT
UUID(), page_privilege.`RoleCode`, action_menu.`ID`, 1, page_privilege.`TenantCode`,
NOW(), 'system', NULL, NULL
FROM `frameworkmenus` action_menu
JOIN `functionprivileges` page_privilege
ON page_privilege.`MenuItemId` = @agv_tasklog_page_id AND page_privilege.`Allowed` = 1
WHERE action_menu.`ClassName` = 'HHWMS.Web.Controllers,AgvTaskLogController'
AND action_menu.`MethodName` = 'Details'
AND @agv_tasklog_page_id IS NOT NULL
AND NOT EXISTS (
SELECT 1 FROM `functionprivileges` existing_privilege
WHERE existing_privilege.`RoleCode` = page_privilege.`RoleCode`
AND existing_privilege.`MenuItemId` = action_menu.`ID`
AND (existing_privilege.`TenantCode` <=> page_privilege.`TenantCode`)
);
SELECT
menu.`PageName`, menu.`MethodName`, menu.`Url`,
privilege.`RoleCode`, privilege.`Allowed`
FROM `frameworkmenus` menu
LEFT JOIN `functionprivileges` privilege ON privilege.`MenuItemId` = menu.`ID`
WHERE menu.`ClassName` = 'HHWMS.Web.Controllers,AgvTaskLogController'
ORDER BY menu.`PageName`, menu.`MethodName`, privilege.`RoleCode`;