From 948541ab3fb1e7f0e7291e1f7ce5c47867fd3232 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@local>
Date: 星期五, 06 十一月 2026 10:15:23 +0800
Subject: [PATCH] chore(bfkj): 清理 2026-11-05 之前的采购/入库/库存数据

---
 sql/mysql/bfkj_clear_purchase_receipt_stock_before_1105.sql |   65 ++++++++++++++++++++++++++++++++
 1 files changed, 65 insertions(+), 0 deletions(-)

diff --git a/sql/mysql/bfkj_clear_purchase_receipt_stock_before_1105.sql b/sql/mysql/bfkj_clear_purchase_receipt_stock_before_1105.sql
new file mode 100644
index 0000000..2d19a4e
--- /dev/null
+++ b/sql/mysql/bfkj_clear_purchase_receipt_stock_before_1105.sql
@@ -0,0 +1,65 @@
+-- =====================================================================
+-- 鍖楁柟绉戞妧锛氭竻鐞� 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 '鍛樺伐妗f(搴斾笉鍙�)', COUNT(*) FROM hrm_employee WHERE deleted=0;

--
Gitblit v1.9.3