AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.550.verify.sql

-- S8-ORDER-REVIEW-HOURS-PAGE-RETIREMENT-1 verify — 每条 SELECT 都必须返回 1

-- ① 目标菜单已停用（Status=2），且仍然存在（不是被 DELETE 掉）
SELECT (SELECT COUNT(*) FROM `SysMenu`
         WHERE `Name` = 'aidopS8OrderReviewActualHours'
           AND `Path` = '/aidop/s8/monitoring/order-review-hours'
           AND `Status` = 2) = 1;

-- ② 全库不再存在任何「启用中」的该路径菜单（防止别处另有一份副本继续下发路由）
SELECT (SELECT COUNT(*) FROM `SysMenu`
         WHERE `Path` = '/aidop/s8/monitoring/order-review-hours'
           AND `Status` <> 2) = 0;

-- ③ 授权行原样保留 —— 本批是 Runtime Retirement，不做物理清理，不得留下悬挂引用
SELECT (SELECT COUNT(*) FROM `SysRoleMenu` WHERE `MenuId` = 1329008000027) > 0;

-- ④ 同目录下本批明确要保留的两个页面仍然启用且可见（防止误伤范围扩大）
SELECT (SELECT COUNT(*) FROM `SysMenu`
         WHERE `Name` IN ('aidopS8OrderExecution', 'aidopS8OrderExecutionChain')
           AND `Status` = 1) = 2;

-- ⑤ S8 异常监控父目录本身未被波及
SELECT (SELECT COUNT(*) FROM `SysMenu` WHERE `Id` = 1329008000020 AND `Status` = 1) = 1;