-- ===================================================================== -- 北方科技:清理 2026-11-05 之前的 采购 / 入库 / 库存 数据 -- (不动人力资源 hrm_* 模块) -- -- 服务器当前时间 2026-11-06,因此「11月5号之前」= create_time < '2026-11-05' -- -- 清理前已全量备份 16 张表为 *_bak20261106 -- -- 数据现状(清理前): -- 采购订单 48 条(五号前 4 条,11-05 新建 44 条需保留) -- 采购申请 3 条(全部五号前) -- 采购入库 4 条、产品入库 1 条、到货通知 2 条(全部五号前) -- 库存现有量 7 条、事务流水 9 条、库存占用 4 条、批次 1 条(全部五号前) -- ===================================================================== -- 1. 库存占用(先释放,避免孤立) DELETE FROM mes_wm_stock_reserve; -- 2. 库存事务流水 DELETE FROM mes_wm_transaction; -- 3. 库存现有量 DELETE FROM mes_wm_material_stock; -- 4. 库存批次 DELETE FROM mes_wm_batch; -- 5. 采购入库单(明细 → 行 → 主表) DELETE FROM mes_wm_item_receipt_detail; DELETE FROM mes_wm_item_receipt_line; DELETE FROM mes_wm_item_receipt; -- 6. 产品入库单 DELETE FROM mes_wm_product_receipt_detail; DELETE FROM mes_wm_product_receipt_line; DELETE FROM mes_wm_product_receipt; -- 7. 到货通知单 DELETE FROM mes_wm_arrival_notice_line; DELETE FROM mes_wm_arrival_notice; -- 8. 采购订单:只删 2026-11-05 之前的(11-05 新建的 44 条保留) DELETE i FROM erp_purchase_order_items i INNER JOIN erp_purchase_order o ON o.id = i.order_id WHERE o.create_time < '2026-11-05'; DELETE FROM erp_purchase_order WHERE create_time < '2026-11-05'; -- 9. 采购申请:只删 2026-11-05 之前的 DELETE i FROM erp_purchase_request_items i INNER JOIN erp_purchase_request r ON r.id = i.request_id WHERE r.create_time < '2026-11-05'; DELETE FROM erp_purchase_request WHERE create_time < '2026-11-05'; -- 验证 SELECT '库存现有量' AS 表, COUNT(*) AS 剩余 FROM mes_wm_material_stock UNION ALL SELECT '库存事务流水', COUNT(*) FROM mes_wm_transaction UNION ALL SELECT '库存占用', COUNT(*) FROM mes_wm_stock_reserve UNION ALL SELECT '库存批次', COUNT(*) FROM mes_wm_batch UNION ALL SELECT '采购入库单', COUNT(*) FROM mes_wm_item_receipt UNION ALL SELECT '产品入库单', COUNT(*) FROM mes_wm_product_receipt UNION ALL SELECT '到货通知单', COUNT(*) FROM mes_wm_arrival_notice UNION ALL SELECT '采购订单(总)', COUNT(*) FROM erp_purchase_order UNION ALL SELECT '采购订单(五号前)', COUNT(*) FROM erp_purchase_order WHERE create_time < '2026-11-05' UNION ALL SELECT '采购申请', COUNT(*) FROM erp_purchase_request UNION ALL SELECT '员工档案(应不变)', COUNT(*) FROM hrm_employee WHERE deleted=0;