From f814b25800feaac018114a9f7906eae00c4d5f44 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期一, 08 六月 2026 15:31:19 +0800
Subject: [PATCH] 采购台账增加车牌号和运输单位/个人
---
src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java | 7 +++++++
src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml | 2 ++
doc/20260608_add_transport_fields_to_purchase_ledger.sql | 3 +++
src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java | 7 +++++++
4 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/doc/20260608_add_transport_fields_to_purchase_ledger.sql b/doc/20260608_add_transport_fields_to_purchase_ledger.sql
new file mode 100644
index 0000000..846b7cb
--- /dev/null
+++ b/doc/20260608_add_transport_fields_to_purchase_ledger.sql
@@ -0,0 +1,3 @@
+alter table purchase_ledger
+ add car_plate_number varchar(64) null comment '杞︾墝鍙�' after payment_method,
+ add transport_unit_or_person varchar(255) null comment '杩愯緭鍗曚綅/涓汉' after car_plate_number;
diff --git a/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java b/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
index cbca6f7..dc4ca2a 100644
--- a/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
+++ b/src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
@@ -183,6 +183,13 @@
@Schema(description = "浠樻鏂瑰紡")
private String paymentMethod;
+
+ @Schema(description = "杞︾墝鍙�")
+ private String carPlateNumber;
+
+ @Schema(description = "杩愯緭鍗曚綅/涓汉")
+ private String transportUnitOrPerson;
+
@Schema(description = "瀹℃壒鐘舵��")
private Integer approvalStatus;
@Schema(description = "妯℃澘鍚嶇О")
diff --git a/src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java b/src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java
index e7ec1eb..0b6e9c1 100644
--- a/src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java
+++ b/src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java
@@ -142,6 +142,13 @@
@Schema(description = "浠樻鏂瑰紡")
private String paymentMethod;
+
+ @Schema(description = "杞︾墝鍙�")
+ private String carPlateNumber;
+
+ @Schema(description = "杩愯緭鍗曚綅/涓汉")
+ private String transportUnitOrPerson;
+
@Schema(description = "瀹℃壒鐘舵�� 1-寰呭鏍革紝2-瀹℃壒涓紝3-瀹℃壒閫氳繃锛�4-瀹℃壒澶辫触,5琛ㄧず鏄ā鏉�")
@Excel(name = "瀹℃壒鐘舵��", readConverterExp = "1=寰呭鏍�,2=瀹℃壒涓�,3=瀹℃壒閫氳繃,4=瀹℃壒澶辫触")
private Integer approvalStatus;
diff --git a/src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml b/src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml
index a0a0a2d..07d3f5a 100644
--- a/src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml
+++ b/src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml
@@ -36,6 +36,8 @@
sm.is_white,
pl.approval_status,
pl.payment_method,
+ pl.car_plate_number,
+ pl.transport_unit_or_person,
pl.remarks,
CASE
WHEN IFNULL(ls.total_product_count, 0) = 0 THEN '寰呭叆搴�'
--
Gitblit v1.9.3