From d913cc2ef67620a9ad9f6fcfd38bea897a023c00 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期三, 24 六月 2026 13:26:17 +0800 Subject: [PATCH] 1 --- docs/20260623_factory_inspect_optimization.md | 82 +++++++++++++++++++++++++++++++++++++++++ docs/20260623_factory_inspect_add_shipping_info_id.sql | 8 ++++ 2 files changed, 90 insertions(+), 0 deletions(-) diff --git a/docs/20260623_factory_inspect_add_shipping_info_id.sql b/docs/20260623_factory_inspect_add_shipping_info_id.sql new file mode 100644 index 0000000..f16838f --- /dev/null +++ b/docs/20260623_factory_inspect_add_shipping_info_id.sql @@ -0,0 +1,8 @@ +-- 鍑哄巶妫�楠屾坊鍔犲彂璐т俊鎭叧鑱斿瓧娈� +-- 鎵ц鏃堕棿锛�2026-06-23 + +ALTER TABLE quality_inspect + ADD COLUMN shipping_info_id BIGINT DEFAULT NULL COMMENT '鍙戣揣淇℃伅id锛堝嚭鍘傛楠屽叧鑱斿彂璐э級' AFTER sales_ledger_id; + +-- 娣诲姞绱㈠紩浼樺寲鏌ヨ +CREATE INDEX idx_quality_inspect_shipping_info ON quality_inspect(shipping_info_id, product_model_id); diff --git a/docs/20260623_factory_inspect_optimization.md b/docs/20260623_factory_inspect_optimization.md new file mode 100644 index 0000000..bd63ae8 --- /dev/null +++ b/docs/20260623_factory_inspect_optimization.md @@ -0,0 +1,82 @@ +# 鍑哄巶璐ㄦ浼樺寲 - 鍓嶇鑱旇皟鏂囨。 + +## 鍙樻洿姒傝堪 + +浼樺寲鍙戣揣娴佺▼涓殑鍑哄巶璐ㄦ鐜妭锛� +1. 鍙戣揣瀹℃牳閫氳繃鍚庯紝鑷姩鐢熸垚鍑哄巶妫�楠屽崟 +2. 鍑哄簱瀹℃壒鍓嶏紝蹇呴』瀹屾垚鍑哄巶璐ㄦ + +## 涓�銆佹暟鎹簱鍙樻洿 + +鎵ц `docs/20260623_factory_inspect_add_shipping_info_id.sql`锛� + +```sql +ALTER TABLE quality_inspect + ADD COLUMN shipping_info_id BIGINT DEFAULT NULL COMMENT '鍙戣揣淇℃伅id锛堝嚭鍘傛楠屽叧鑱斿彂璐э級' AFTER sales_ledger_id; + +CREATE INDEX idx_quality_inspect_shipping_info ON quality_inspect(shipping_info_id, product_model_id); +``` + +## 浜屻�佷笟鍔℃祦绋嬪彉鏇� + +### 鍘熸祦绋� +鍙戣揣 鈫� 鍙戣揣瀹℃牳 鈫� 鍑哄巶璐ㄦ 鈫� 鍑哄簱瀹℃牳 鈫� 鍑哄簱閫氳繃 + +### 浼樺寲鍚庢祦绋� +1. **鍙戣揣鐢宠** 鈫� 鍒涘缓鍙戣揣鍗曪紝鐘舵��"寰呭鏍�" +2. **鍙戣揣瀹℃牳閫氳繃** 鈫� 鑷姩鐢熸垚鍑哄巶妫�楠屽崟锛岀姸鎬佸彉涓�"瀹℃牳閫氳繃" +3. **鍑哄巶璐ㄦ** 鈫� 瀹屾垚鍑哄巶妫�楠屽崟锛堟彁浜ゆ楠岀粨鏋滐級 +4. **鍑哄簱瀹℃牳** 鈫� 妫�鏌ュ嚭鍘傝川妫�鏄惁瀹屾垚锛岄�氳繃鍚庢墸鍑忓簱瀛� +5. **鍑哄簱閫氳繃** 鈫� 瀹屾垚 + +## 涓夈�佹帴鍙ｅ彉鏇� + +### 3.1 鍑哄巶妫�楠屽崟鏂板瀛楁 + +**GET** `/quality/qualityInspect/listPage?inspectType=2` + +杩斿洖瀛楁鏂板锛� + +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| `shippingInfoId` | Long | 鍏宠仈鐨勫彂璐т俊鎭疘D | + +### 3.2 鍑哄簱瀹℃壒鏍￠獙 + +**POST** `/stockOutRecord/approve` + +鍑哄簱瀹℃壒閫氳繃鏃讹紝鍚庣浼氭鏌ワ細 +- 閿�鍞嚭搴擄紙recordType=SALE_SHIP_STOCK_OUT锛夋槸鍚︽湁鍏宠仈鐨勫嚭鍘傛楠屽崟 +- 鍑哄巶妫�楠屽崟鏄惁宸插畬鎴愶紙inspectState=1锛� + +**閿欒鎻愮ず锛�** +- `"璇ュ嚭搴撹褰曟湭鐢熸垚鍑哄巶妫�楠屽崟锛岃鍏堝畬鎴愬彂璐у鎵�"` - 鍙戣揣瀹℃牳鏈�氳繃 +- `"鍑哄巶妫�楠屽崟灏氭湭鎻愪氦瀹屾垚锛岃鍏堝畬鎴愬嚭鍘傝川妫�鍚庡啀杩涜鍑哄簱瀹℃壒"` - 鍑哄巶璐ㄦ鏈畬鎴� + +## 鍥涖�佸墠绔鎺ヨ鐐� + +### 4.1 鍑哄巶妫�楠屽垪琛ㄩ〉 + +鍑哄巶妫�楠屽崟鏂板 `shippingInfoId` 瀛楁锛屽彲鐢ㄤ簬锛� +- 璺宠浆鍒板彂璐ц鎯呴〉 +- 鏄剧ず鍏宠仈鐨勫彂璐х紪鍙� + +### 4.2 鍑哄簱瀹℃壒椤� + +鍑哄簱瀹℃壒鏃讹紝濡傛灉杩斿洖閿欒鎻愮ず锛屽墠绔簲寮曞鐢ㄦ埛锛� +1. 鍏堝畬鎴愬彂璐у鏍革紙鍙戣揣瀹℃牳閫氳繃鍚庤嚜鍔ㄧ敓鎴愬嚭鍘傛楠屽崟锛� +2. 瀹屾垚鍑哄巶璐ㄦ鍚庡啀杩涜鍑哄簱瀹℃壒 + +### 4.3 寤鸿浼樺寲 + +鍙湪鍑哄簱瀹℃壒椤甸潰澧炲姞"鍑哄巶璐ㄦ鐘舵��"鍒楋紝鏄剧ず锛� +- 鏈敓鎴� - 鍙戣揣瀹℃牳鏈�氳繃 +- 寰呮楠� - 宸茬敓鎴愬嚭鍘傛楠屽崟锛屾湭鎻愪氦 +- 宸插畬鎴� - 鍑哄巶妫�楠屽崟宸叉彁浜� + +## 浜斻�佹敞鎰忎簨椤� + +1. 鍑哄巶妫�楠屽崟鍦ㄥ彂璐у鏍搁�氳繃鍚庤嚜鍔ㄧ敓鎴愶紝鏃犻渶鎵嬪姩鍒涘缓 +2. 姣忎釜鍙戣揣浜у搧鏄庣粏浼氱敓鎴愪竴鏉″搴旂殑鍑哄巶妫�楠屽崟 +3. 鍑哄巶妫�楠屽崟鐨勬楠屽弬鏁颁細鏍规嵁浜у搧鐨勫嚭鍘傛楠屾爣鍑嗚嚜鍔ㄥ垵濮嬪寲 +4. 鍑哄簱瀹℃壒閫氳繃鍓嶅繀椤诲畬鎴愬嚭鍘傝川妫�锛屽惁鍒欎細鎶ラ敊 -- Gitblit v1.9.3