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