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

-- 1.0.565.verify.sql — 每条 SELECT 必须返回真值。量级验收见执行报告，此处只锁结构不变量。

SELECT COUNT(*) = 1 FROM information_schema.tables
 WHERE table_schema = DATABASE() AND table_name = 'mdp_location_role';

SELECT COUNT(*) = 0 FROM mdp_location_role
 WHERE location_role NOT IN ('MAT_INSPECT','MATERIAL','MAT_LINE_LOC','SEMI','FG_INSPECT','FG','FG_LINE_LOC','REJECT_SCRAP','VMI','OTHER','UNKNOWN');

SELECT COUNT(*) = 0 FROM mdp_location_role
 WHERE location_role IN ('INSPECT','LINE','SCRAP');

SELECT COUNT(*) = 0
  FROM mdp_location_role r
  JOIN LocationMaster lm
    ON lm.tenant_id = r.tenant_id AND IFNULL(lm.Domain,'') = r.domain AND lm.location = r.location
 WHERE IFNULL(lm.typed,'') = 'Supp';

SELECT COUNT(*) = 0 FROM mdp_std_inv_trans
 WHERE trans_type IS NOT NULL
   AND trans_type NOT IN ('MAT_RECEIPT','MAT_IQC_RELEASE','MAT_PUTAWAY','MAT_PICK','MAT_ISSUE','MAT_LINE','FG_RECEIPT','FG_PUTAWAY','FG_PICK','FG_SHIP','FG_PROD_RECEIPT','FG_FQC_RELEASE');

SELECT COUNT(*) = 0 FROM mdp_std_inv_trans_unmapped
 WHERE src_trans_type_raw IN ('inv-frz','inv-unfrz','iss-rv','iss-po','tag-cnf','tag-cnt');

SELECT COUNT(*) = 0 FROM mdp_std_inv_trans_unmapped
 WHERE unmapped_reason NOT IN ('PENDING_VERIFY','LOCATION_ROLE_UNCONFIGURED','OUT_OF_SCOPE_ROLE','UNKNOWN_CODE');

SELECT COUNT(*) = 0
  FROM mdp_std_inv_trans_unmapped u
  JOIN mdp_std_inv_trans t
    ON t.tenant_id = u.tenant_id AND t.source_system = u.source_system AND t.src_rec_id = u.src_rec_id
 WHERE t.trans_type IS NOT NULL;

SELECT COUNT(*) = 0 FROM mdp_std_inv_trans
 WHERE source_system = 'UAT_GENERATOR' AND tenant_id = 838257186181189;

SELECT (SELECT COUNT(*) FROM ado_s9_kpi_value_l1_day WHERE tenant_id = 1300000000001) > 0
    OR (SELECT COUNT(*) FROM mdp_std_inv_trans WHERE tenant_id = 1300000000001 AND source_system = 'DOPDEMORQ_SQLSERVER') = 0;

SELECT COUNT(*) = 1 FROM information_schema.tables
 WHERE table_schema = DATABASE() AND table_name = 'mdp_source_table_registry';

SELECT COUNT(*) = 1 FROM information_schema.columns
 WHERE table_schema = DATABASE() AND table_name = 'mdp_std_inv_trans' AND column_name = 'written_by';

SELECT COUNT(*) = 1 FROM `SysMenu` WHERE `Permission` = 's8:dashboard:refresh';