AiDOPWarehouse/doc/plan/sql/S1S4_UAT_P0补发货_PO04_PO05.sql

-- 补 S4 发货单：PO-UAT-20260604-04 / PO-UAT-20260604-05
SET @tenant_id := 797403760988229;
SET @id_base := 9106000400000001;
SET @operator_name := 'UAT数据导入';
SET @now := NOW();

INSERT INTO scm_shd (id, po_billno, shddh, sh_purchase_num, estimated_delivery_date, tjrxm, tjrq, state)
VALUES
(@id_base+604, 'PO-UAT-20260604-04', 'SH-UAT-20260604-04', 'VEN00060', DATE_ADD(@now, INTERVAL 7 DAY), @operator_name, DATE_FORMAT(@now,'%Y-%m-%d'), 0),
(@id_base+605, 'PO-UAT-20260604-05', 'SH-UAT-20260604-05', 'VEN00060', DATE_ADD(@now, INTERVAL 7 DAY), @operator_name, DATE_FORMAT(@now,'%Y-%m-%d'), 0);

INSERT INTO scm_shdzb (id, glid, sh_material_code, sh_delivery_quantity, po_bill, po_billline)
SELECT @id_base+707, CAST(@id_base+604 AS CHAR), '91C0D2C', 600, 'PO-UAT-20260604-04', '1'
UNION ALL SELECT @id_base+708, CAST(@id_base+604 AS CHAR), '91CC0231', 100, 'PO-UAT-20260604-04', '2'
UNION ALL SELECT @id_base+709, CAST(@id_base+605 AS CHAR), '322AD001', 5500, 'PO-UAT-20260604-05', '1'
UNION ALL SELECT @id_base+710, CAST(@id_base+605 AS CHAR), '3221C0031', 5500, 'PO-UAT-20260604-05', '2';

SELECT pom.PurOrd, COUNT(sh.id) ship_cnt
FROM PurOrdMaster pom
LEFT JOIN scm_shd sh ON sh.po_billno = pom.PurOrd
WHERE pom.tenant_id = @tenant_id AND pom.PurOrd LIKE 'PO-UAT-20260604-%'
GROUP BY pom.PurOrd ORDER BY pom.PurOrd;