From 361f5449f46da1fe7f4cef954dbf25bbe8b8101d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 26 八月 2026 16:45:31 +0800
Subject: [PATCH] feat(sales): 添加发货地址字段支持
---
doc/20260826_生产计划与销售发货数量规则前端联调文档.md | 3 +++
src/main/resources/mapper/sales/ShippingInfoMapper.xml | 2 ++
src/main/java/com/ruoyi/sales/pojo/ShippingInfo.java | 4 ++++
sql/product-inventory-management-new-pro.sql | 1 +
4 files changed, 10 insertions(+), 0 deletions(-)
diff --git "a/doc/20260826_\347\224\237\344\272\247\350\256\241\345\210\222\344\270\216\351\224\200\345\224\256\345\217\221\350\264\247\346\225\260\351\207\217\350\247\204\345\210\231\345\211\215\347\253\257\350\201\224\350\260\203\346\226\207\346\241\243.md" "b/doc/20260826_\347\224\237\344\272\247\350\256\241\345\210\222\344\270\216\351\224\200\345\224\256\345\217\221\350\264\247\346\225\260\351\207\217\350\247\204\345\210\231\345\211\215\347\253\257\350\201\224\350\260\203\346\226\207\346\241\243.md"
index ad73a4e..ef70959 100644
--- "a/doc/20260826_\347\224\237\344\272\247\350\256\241\345\210\222\344\270\216\351\224\200\345\224\256\345\217\221\350\264\247\346\225\260\351\207\217\350\247\204\345\210\231\345\211\215\347\253\257\350\201\224\350\260\203\346\226\207\346\241\243.md"
+++ "b/doc/20260826_\347\224\237\344\272\247\350\256\241\345\210\222\344\270\216\351\224\200\345\224\256\345\217\221\350\264\247\346\225\260\351\207\217\350\247\204\345\210\231\345\211\215\347\253\257\350\201\224\350\260\203\346\226\207\346\241\243.md"
@@ -191,6 +191,7 @@
"salesLedgerId": 2001,
"salesLedgerProductId": 3001,
"type": "閿�鍞彂璐�",
+ "shippingAddress": "姹熻嫃鐪佸崡閫氬競宕囧窛鍖虹ず渚嬭矾 100 鍙�",
"batchNoDetailList": [
{
"productModelId": 501,
@@ -209,6 +210,7 @@
| `salesLedgerId` | `number` | 鎸変笟鍔� | 閿�鍞彴璐� ID |
| `salesLedgerProductId` | `number` | 寤鸿浼犲叆 | 閿�鍞彴璐︿骇鍝� ID锛岀敤浜庡叧鑱旈攢鍞骇鍝佸強閲嶅鎻愪氦鏍￠獙 |
| `type` | `string` | 鍚� | 鍙戣揣绫诲瀷 |
+| `shippingAddress` | `string` | 鍚� | 鍙戣揣鍦板潃锛屾渶闀� 500 涓瓧绗� |
| `batchNoDetailList` | `array` | 鏄� | 鍙戣揣鎵规鏄庣粏 |
| `batchNoDetailList[].productModelId` | `number` | 鏄� | 浜у搧鍨嬪彿 ID |
| `batchNoDetailList[].batchNo` | `string` | 鏄� | 搴撳瓨鎵规鍙� |
@@ -223,6 +225,7 @@
4. 鍙敤搴撳瓨浼氭墸闄ゅ喕缁撳簱瀛樺拰宸叉湁寰呭嚭搴撴暟閲忋��
5. 鍚屼竴閿�鍞骇鍝佸凡鏈夆�滃緟瀹℃牳鈥濇垨鈥滃鏍镐腑鈥濆彂璐ц褰曟椂锛屼粛涓嶅厑璁搁噸澶嶆彁浜ゃ��
6. 鏂板鎴愬姛鍚庯紝鍙戣揣鍗曡繘鍏ュ鎵规祦绋嬶紝閫氬父鐘舵�佷负鈥滃鏍镐腑鈥濄��
+7. `shippingAddress` 浼氫繚瀛樺埌鍙戣揣鍗曪紝骞跺湪鍙戣揣鍒楄〃鍙婂鍑烘暟鎹腑杩斿洖锛岀敤浜庡洖鏄俱��
搴撳瓨涓嶈冻鏃跺彲鑳借繑鍥烇細
diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql
index ea5813b..4afdf6d 100644
--- a/sql/product-inventory-management-new-pro.sql
+++ b/sql/product-inventory-management-new-pro.sql
@@ -4416,6 +4416,7 @@
`sales_ledger_id` bigint NULL DEFAULT NULL COMMENT '閿�鍞彴璐d',
`shipping_date` datetime NULL DEFAULT NULL COMMENT '鍙戣揣鏃ユ湡',
`shipping_car_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '鍙戣揣杞︾墝鍙�',
+ `shipping_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍙戣揣鍦板潃',
`create_time` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
`create_user` bigint NULL DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
`update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
diff --git a/src/main/java/com/ruoyi/sales/pojo/ShippingInfo.java b/src/main/java/com/ruoyi/sales/pojo/ShippingInfo.java
index ed9a268..3e55877 100644
--- a/src/main/java/com/ruoyi/sales/pojo/ShippingInfo.java
+++ b/src/main/java/com/ruoyi/sales/pojo/ShippingInfo.java
@@ -67,6 +67,10 @@
@Excel(name = "鍙戣揣杞︾墝鍙�")
private String shippingCarNumber;
+ @Schema(description = "鍙戣揣鍦板潃")
+ @Excel(name = "鍙戣揣鍦板潃")
+ private String shippingAddress;
+
@Schema(description = "鍒涘缓鏃堕棿")
@TableField(fill = FieldFill.INSERT)
private LocalDateTime createTime;
diff --git a/src/main/resources/mapper/sales/ShippingInfoMapper.xml b/src/main/resources/mapper/sales/ShippingInfoMapper.xml
index 8775933..a86fc97 100644
--- a/src/main/resources/mapper/sales/ShippingInfoMapper.xml
+++ b/src/main/resources/mapper/sales/ShippingInfoMapper.xml
@@ -8,6 +8,7 @@
s.sales_ledger_id,
s.shipping_date,
s.shipping_car_number,
+ s.shipping_address,
s.express_number,
s.express_company,
s.shipping_no,
@@ -56,6 +57,7 @@
s.sales_ledger_id,
s.shipping_date,
s.shipping_car_number,
+ s.shipping_address,
s.create_time,
s.update_time,
s.create_user,
--
Gitblit v1.9.3