From 849648e82e5dec96f9f30fcc9c9bd799268b1f4c Mon Sep 17 00:00:00 2001
From: wujianwei <wjw@11.com>
Date: 星期四, 09 四月 2026 10:40:44 +0800
Subject: [PATCH] 新增资金流水导入

---
 service/src/main/java/com/ruoyi/cwgl/domain/ReceivableBillManagement.java |  183 ++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 179 insertions(+), 4 deletions(-)

diff --git a/service/src/main/java/com/ruoyi/cwgl/domain/ReceivableBillManagement.java b/service/src/main/java/com/ruoyi/cwgl/domain/ReceivableBillManagement.java
index 26b04e1..8c83d29 100644
--- a/service/src/main/java/com/ruoyi/cwgl/domain/ReceivableBillManagement.java
+++ b/service/src/main/java/com/ruoyi/cwgl/domain/ReceivableBillManagement.java
@@ -2,6 +2,7 @@
 
 import java.math.BigDecimal;
 import java.util.Date;
+import java.util.List;
 import com.fasterxml.jackson.annotation.JsonFormat;
 import com.ruoyi.common.annotation.Excel;
 import com.baomidou.mybatisplus.annotation.TableField;
@@ -41,6 +42,48 @@
 
         @TableField("customer_name")
     private String customerName;
+
+
+    /** 鏀舵浜� */
+    @Excel(name = "鏀舵浜�")
+
+        @TableField("payee")
+    private String payee;
+
+
+    /** 璐d换浜� */
+    @Excel(name = "璐d换浜�")
+
+        @TableField("responsible_person")
+    private String responsiblePerson;
+
+
+    /** 璐d换棰嗗 */
+    @Excel(name = "璐d换棰嗗")
+
+        @TableField("responsible_leader")
+    private String responsibleLeader;
+
+
+    /** 缁撶畻鏂瑰紡 */
+    @Excel(name = "缁撶畻鏂瑰紡")
+
+        @TableField("settlement_method")
+    private String settlementMethod;
+
+
+    /** 涓氬姟绫诲瀷 */
+    @Excel(name = "涓氬姟绫诲瀷")
+
+        @TableField("business_type")
+    private String businessType;
+
+
+    /** 鎺ㄨ繘瑕佹眰 */
+    @Excel(name = "鎺ㄨ繘瑕佹眰")
+
+        @TableField("promotion_requirement")
+    private String promotionRequirement;
 
 
     /** 鏄惁鍐呴儴缁撶畻 */
@@ -168,19 +211,151 @@
     private Date billSendDate;
 
 
-    /** 璐﹀崟鍒版湡鏃ユ湡 */
+    /**
+     * 璐﹀崟鍒版湡鏃ユ湡
+     */
     @Excel(name = "璐﹀崟鍒版湡鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
 
         @JsonFormat(pattern = "yyyy-MM-dd")
         @TableField("bill_due_date")
     private Date billDueDate;
 
+    /**
+     * 30澶╁唴鍒版湡閲戦
+     */
+    @Excel(name = "30澶╁唴鍒版湡閲戦")
 
-    /** 鐘舵��(draft:鑽夌;generated:宸茬敓鎴�;sent:宸插彂閫�;partial_paid:閮ㄥ垎鏀舵;paid:宸叉敹娆�;cancelled:宸插彇娑�) */
+        @TableField("due_in_30_days")
+    private BigDecimal dueIn30Days;
+
+    /**
+     * 閫炬湡閲戦
+     */
+    @Excel(name = "閫炬湡閲戦")
+
+        @TableField("overdue_amount")
+    private BigDecimal overdueAmount;
+
+    /**
+     * 閫炬湡1~30澶╅噾棰�
+     */
+    @Excel(name = "閫炬湡1~30澶╅噾棰�")
+
+        @TableField("overdue_1_to_30_days")
+    private BigDecimal overdue1To30Days;
+
+    /**
+     * 閫炬湡31~60澶╅噾棰�
+     */
+    @Excel(name = "閫炬湡31~60澶╅噾棰�")
+
+        @TableField("overdue_31_to_60_days")
+    private BigDecimal overdue31To60Days;
+
+    /**
+     * 閫炬湡61~90澶╅噾棰�
+     */
+    @Excel(name = "閫炬湡61~90澶╅噾棰�")
+
+        @TableField("overdue_61_to_90_days")
+    private BigDecimal overdue61To90Days;
+
+    /**
+     * 閫炬湡91~180澶╅噾棰�
+     */
+    @Excel(name = "閫炬湡91~180澶╅噾棰�")
+
+        @TableField("overdue_91_to_180_days")
+    private BigDecimal overdue91To180Days;
+
+    /**
+     * 閫炬湡181~365澶╅噾棰�
+     */
+    @Excel(name = "閫炬湡181~365澶╅噾棰�")
+
+        @TableField("overdue_181_to_365_days")
+    private BigDecimal overdue181To365Days;
+
+    /**
+     * 閫炬湡1骞翠互涓婇噾棰�
+     */
+    @Excel(name = "閫炬湡1骞翠互涓婇噾棰�")
+
+        @TableField("overdue_over_1_year")
+    private BigDecimal overdueOver1Year;
+
+    /**
+     * 閫炬湡澶╂暟
+     */
+    @Excel(name = "閫炬湡澶╂暟")
+
+        @TableField("overdue_days")
+    private Integer overdueDays;
+
+
+    /** 缁撶畻绉嶇被 */
+    @Excel(name = "缁撶畻绉嶇被")
+
+        @TableField("settlement_category")
+    private String settlementCategory;
+
+
+    /** 缁撶畻鏈� */
+    @Excel(name = "缁撶畻鏈�")
+
+        @TableField("settlement_period")
+    private String settlementPeriod;
+
+
+    /** NC璐﹂潰缁撶畻鏃ユ湡 */
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @Excel(name = "NC璐﹂潰缁撶畻鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
+
+        @TableField("nc_settlement_date")
+    private Date ncSettlementDate;
+
+
+    /** NC璐﹂潰缁撶畻閲戦 */
+    @Excel(name = "NC璐﹂潰缁撶畻閲戦")
+
+        @TableField("nc_settlement_amount")
+    private BigDecimal ncSettlementAmount;
+
+
+    /** 璐︽澶囨敞 */
+    @Excel(name = "璐︽澶囨敞")
+
+        @TableField("account_remark")
+    private String accountRemark;
+
+
+    /** 閫炬湡鍒╂伅 */
+    @Excel(name = "閫炬湡鍒╂伅")
+
+        @TableField("overdue_interest")
+    private BigDecimal overdueInterest;
+
+
+    /**
+     * 鐘舵��(draft:鑽夌;generated:宸茬敓鎴�;sent:宸插彂閫�;pending_review:寰呭鏍�;partial_paid:閮ㄥ垎鏀舵;paid:宸叉敹娆�;cancelled:宸插彇娑�)
+     */
     @Excel(name = "鐘舵��")
 
         @TableField("status")
     private String status;
+
+
+    /** 瀹℃牳鐘舵��(0:鏈鏍�;1:瀹℃牳閫氳繃;2:瀹℃牳涓嶉�氳繃) */
+    @Excel(name = "瀹℃牳鐘舵��")
+
+        @TableField("audit_status")
+    private Integer auditStatus;
+
+    /** 鏉ユ簮绯荤粺ID锛堢敤浜庡鏍告帹閫佹椂璇嗗埆鐩爣TMS绯荤粺锛� */
+    @Excel(name = "鏉ユ簮绯荤粺ID")
+
+        @TableField("source_system_id")
+    private Integer sourceSystemId;
 
 
     /** 澶囨敞 */
@@ -196,7 +371,7 @@
 
 
     /** 鍒涘缓鏃堕棿 */
-        @JsonFormat(pattern = "yyyy-MM-dd")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
         @TableField("create_time")
     private Date createTime;
 
@@ -207,7 +382,7 @@
 
 
     /** 鏇存柊鏃堕棿 */
-        @JsonFormat(pattern = "yyyy-MM-dd")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
         @TableField("update_time")
     private Date updateTime;
 

--
Gitblit v1.8.0