From 11214e3074266a23fe61e8eebbce647fdb7305ef Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 12 六月 2026 18:02:03 +0800
Subject: [PATCH] 报价单修改-优化，增加导入记录，降价历史
---
docs/sales_quotation_import_api.md | 223 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 223 insertions(+), 0 deletions(-)
diff --git a/docs/sales_quotation_import_api.md b/docs/sales_quotation_import_api.md
new file mode 100644
index 0000000..8613ff2
--- /dev/null
+++ b/docs/sales_quotation_import_api.md
@@ -0,0 +1,223 @@
+# 閿�鍞姤浠峰鍏ュ姛鑳� - 鍓嶇鑱旇皟鏂囨。
+
+## 涓�銆佸姛鑳芥杩�
+
+閿�鍞姤浠锋ā鍧楁敮鎸佸Sheet妯℃澘瀵煎叆锛屾ā鏉跨粨鏋勫弬鑰冮攢鍞彴璐︼細
+1. **鎶ヤ环鍗曟暟鎹甋heet**锛氬寘鍚姤浠峰崟鍩烘湰淇℃伅
+2. **鎶ヤ环浜у搧鏁版嵁Sheet**锛氬寘鍚骇鍝佹槑缁嗕俊鎭�
+
+---
+
+## 浜屻�佹ā鏉跨粨鏋�
+
+### 2.1 鎶ヤ环鍗曟暟鎹甋heet
+
+| 瀛楁 | 璇存槑 | 鏄惁蹇呭～ |
+|------|------|----------|
+| 鎶ヤ环鍗曞彿 | 鎶ヤ环鍗曠紪鍙凤紙涓嶅～鑷姩鐢熸垚锛� | 鍚� |
+| 瀹㈡埛鍚嶇О | 瀹㈡埛鍚嶇О | 鏄� |
+| 涓氬姟鍛� | 閿�鍞汉鍛樺鍚� | 鍚� |
+| 鎶ヤ环鏃ユ湡 | 鏍煎紡yyyy-MM-dd | 鍚� |
+| 鏈夋晥鏈熻嚦 | 鏍煎紡yyyy-MM-dd | 鍚� |
+| 浠樻鏂瑰紡 | 濡�"鏈堢粨30澶�" | 鍚� |
+| 浜よ揣鍛ㄦ湡 | 濡�"7澶�" | 鍚� |
+| 澶囨敞 | 鍏朵粬璇存槑 | 鍚� |
+
+### 2.2 鎶ヤ环浜у搧鏁版嵁Sheet
+
+| 瀛楁 | 璇存槑 | 鏄惁蹇呭～ |
+|------|------|----------|
+| 鎶ヤ环鍗曞彿 | 鍏宠仈鎶ヤ环鍗曟暟鎹甋heet鐨勬姤浠峰崟鍙� | 鏄� |
+| 浜у搧澶х被 | 浜у搧鍒嗙被鍚嶇О | 鏄� |
+| 瑙勬牸鍨嬪彿 | 浜у搧瑙勬牸鍨嬪彿 | 鏄� |
+| 鍗曚綅 | 璁￠噺鍗曚綅 | 鍚� |
+| 鏁伴噺 | 鎶ヤ环鏁伴噺 | 鏄� |
+| 鍚◣鍗曚环 | 鍗曚环锛堝厓锛� | 鏄� |
+| 鍚◣鎬讳环 | 鎬讳环锛堝厓锛� | 鍚︼紙涓嶅～鑷姩璁＄畻锛� |
+| 澶囨敞 | 浜у搧澶囨敞 | 鍚� |
+
+---
+
+## 涓夈�佹帴鍙ｈ鎯�
+
+### 3.1 涓嬭浇鎶ヤ环瀵煎叆妯℃澘
+
+**璇锋眰**
+```
+GET /sales/quotation/downloadTemplate
+```
+
+**鍝嶅簲**
+- Excel鏂囦欢涓嬭浇锛屽寘鍚袱涓猄heet锛�
+ - 鎶ヤ环鍗曟暟鎹紙鍚ず渚嬫暟鎹級
+ - 鎶ヤ环浜у搧鏁版嵁锛堝惈绀轰緥鏁版嵁锛�
+
+### 3.2 瀵煎叆鎶ヤ环鍗�
+
+**璇锋眰**
+```
+POST /sales/quotation/import
+Content-Type: multipart/form-data
+
+file: [Excel鏂囦欢]
+```
+
+**鍝嶅簲**
+```json
+{
+ "code": 200,
+ "msg": "鎿嶄綔鎴愬姛",
+ "data": {
+ "id": 1,
+ "batchNo": "QT_IMP_20260612143000",
+ "fileName": "鎶ヤ环鍗�.xlsx",
+ "totalCount": 5,
+ "successCount": 5,
+ "newCount": 5,
+ "failCount": 0,
+ "status": "completed",
+ "createTime": "2026-06-12 14:30:00",
+ "createUserName": "寮犱笁"
+ }
+}
+```
+
+**涓氬姟閫昏緫**
+
+1. **妯℃澘妫�鏌�**锛氬鍏ュ墠妫�鏌ユ姤浠峰鎵规ā鏉挎槸鍚﹀瓨鍦�
+ - 涓嶅瓨鍦細杩斿洖閿欒"璇峰厛閰嶇疆鎶ヤ环瀹℃壒妯℃澘锛屾棤娉曞鍏�"
+ - 瀛樺湪锛氱户缁鍏�
+
+2. **鎶ヤ环鍗曞彿澶勭悊**锛�
+ - 濡傛灉濉啓浜嗘姤浠峰崟鍙凤紝浣跨敤濉啓鐨勫崟鍙�
+ - 濡傛灉鏈～鍐欙紝鑷姩鐢熸垚鍗曞彿锛堟牸寮忥細QT + 鏃ユ湡 + 搴忓彿锛�
+ - 鎶ヤ环鍗曞彿宸插瓨鍦ㄥ垯璺宠繃
+
+3. **浜у搧鍏宠仈**锛氶�氳繃鎶ヤ环鍗曞彿灏嗕骇鍝佹暟鎹叧鑱斿埌瀵瑰簲鐨勬姤浠峰崟
+
+4. **瀹℃壒娴佺▼**锛氬鍏ユ垚鍔熷悗鑷姩鍒涘缓瀹℃壒娴佺▼
+
+5. **闄嶄环璁板綍**锛氱浉鍚岃鏍煎瀷鍙风殑浜у搧瀵规瘮鍘嗗彶浠锋牸锛岃嚜鍔ㄨ褰曢檷浠�
+
+**閿欒鐮�**
+
+| 閿欒淇℃伅 | 璇存槑 |
+|----------|------|
+| 璇峰厛閰嶇疆鎶ヤ环瀹℃壒妯℃澘锛屾棤娉曞鍏� | 绯荤粺鏈厤缃姤浠峰鎵规ā鏉� |
+| 璇诲彇鏂囦欢澶辫触 | Excel鏂囦欢鏍煎紡閿欒 |
+| 鎶ヤ环鍗曟暟鎹负绌猴紝璇锋鏌ユā鏉垮唴瀹� | 鎶ヤ环鍗昐heet鏃犳暟鎹� |
+
+### 3.3 鏌ヨ瀵煎叆璁板綍
+
+**璇锋眰**
+```
+GET /sales/quotation/importLog/list?pageNum=1&pageSize=10
+```
+
+**鍝嶅簲**
+```json
+{
+ "code": 200,
+ "data": {
+ "total": 20,
+ "records": [
+ {
+ "id": 1,
+ "batchNo": "QT_IMP_20260612143000",
+ "fileName": "鎶ヤ环鍗�.xlsx",
+ "totalCount": 5,
+ "successCount": 5,
+ "newCount": 5,
+ "failCount": 0,
+ "status": "completed",
+ "createUserName": "寮犱笁",
+ "createTime": "2026-06-12 14:30:00"
+ }
+ ]
+ }
+}
+```
+
+### 3.4 鏌ヨ闄嶄环鍘嗗彶
+
+**璇锋眰**
+```
+GET /sales/quotation/priceHistory/list?quotationProductId=123
+```
+
+**鍝嶅簲**
+```json
+{
+ "code": 200,
+ "data": [
+ {
+ "id": 1,
+ "productName": "鐢垫睜缁勪欢A",
+ "specification": "MODEL-A-100W",
+ "oldPrice": 150.00,
+ "newPrice": 120.00,
+ "priceChange": -30.00,
+ "changeReason": "闄嶄环",
+ "importBatch": "QT_IMP_20260612143000",
+ "importTime": "2026-06-12 14:30:00",
+ "createUserName": "寮犱笁"
+ }
+ ]
+}
+```
+
+---
+
+## 鍥涖�佷笟鍔℃祦绋�
+
+```
+涓嬭浇妯℃澘
+ 鈹�
+ 鈻�
+濉啓鎶ヤ环鍗曟暟鎹甋heet锛堟瘡琛屼竴涓姤浠峰崟锛�
+濉啓鎶ヤ环浜у搧鏁版嵁Sheet锛堥�氳繃鎶ヤ环鍗曞彿鍏宠仈锛�
+ 鈹�
+ 鈻�
+涓婁紶鏂囦欢
+ 鈹�
+ 鈻�
+妫�鏌ュ鎵规ā鏉挎槸鍚﹀瓨鍦�
+ 鈹�
+ 鈹溾攢鈹� 涓嶅瓨鍦� 鈹�鈹�鈻� 閿欒锛�"璇峰厛閰嶇疆鎶ヤ环瀹℃壒妯℃澘锛屾棤娉曞鍏�"
+ 鈹�
+ 鈹斺攢鈹� 瀛樺湪 鈹�鈹�鈻� 瑙ｆ瀽涓や釜Sheet鏁版嵁
+ 鈹�
+ 鈻�
+閬嶅巻鎶ヤ环鍗曟暟鎹�
+ 鈹�
+ 鈹溾攢鈹� 妫�鏌ユ姤浠峰崟鍙锋槸鍚﹀凡瀛樺湪 鈹�鈹�鈻� 宸插瓨鍦ㄥ垯璺宠繃
+ 鈹�
+ 鈹溾攢鈹� 鍒涘缓鎶ヤ环鍗曡褰�
+ 鈹溾攢鈹� 鍏宠仈浜у搧鏁版嵁锛堥�氳繃鎶ヤ环鍗曞彿鍖归厤锛�
+ 鈹溾攢鈹� 璁板綍闄嶄环鍘嗗彶锛堝姣斿巻鍙蹭环鏍硷級
+ 鈹斺攢鈹� 鍒涘缓瀹℃壒娴佺▼
+ 鈹�
+ 鈻�
+杩斿洖瀵煎叆缁撴灉
+```
+
+---
+
+## 浜斻�佺ず渚嬫暟鎹�
+
+**鎶ヤ环鍗曟暟鎹甋heet**
+| 鎶ヤ环鍗曞彿 | 瀹㈡埛鍚嶇О | 涓氬姟鍛� | 浠樻鏂瑰紡 | 浜よ揣鍛ㄦ湡 |
+|----------|----------|--------|----------|----------|
+| QT202606120001 | 绀轰緥瀹㈡埛 | 寮犱笁 | 鏈堢粨30澶� | 7澶� |
+
+**鎶ヤ环浜у搧鏁版嵁Sheet**
+| 鎶ヤ环鍗曞彿 | 浜у搧澶х被 | 瑙勬牸鍨嬪彿 | 鍗曚綅 | 鏁伴噺 | 鍚◣鍗曚环 | 鍚◣鎬讳环 |
+|----------|----------|----------|------|------|----------|----------|
+| QT202606120001 | 鐢垫睜缁勪欢 | MODEL-A-100W | 鐗� | 100 | 150.00 | 15000.00 |
+| QT202606120001 | 鐢垫睜缁勪欢 | MODEL-B-200W | 鐗� | 50 | 200.00 | 10000.00 |
+
+---
+
+## 鍏�佹暟鎹簱鍙樻洿
+
+闇�鎵ц锛歚docs/sales_quotation_price_history.sql`
\ No newline at end of file
--
Gitblit v1.9.3