From 423ac2a5e7e451248d8cdfc2cda3f32dba0ec8f8 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 11 三月 2026 17:59:52 +0800
Subject: [PATCH] feat: 生产计划关联物料信息表

---
 src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java |   56 ++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 52 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java b/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
index 1bd9b0c..8ecf1e8 100644
--- a/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
+++ b/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
@@ -4,11 +4,14 @@
 import com.baomidou.mybatisplus.annotation.TableId;
 import com.baomidou.mybatisplus.annotation.TableName;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
 
 import java.math.BigDecimal;
 import java.time.LocalDateTime;
+import java.util.Date;
 
 /**
  * <br>
@@ -45,116 +48,144 @@
      * 鐢宠鍗曠紪鍙�
      */
     @ApiModelProperty("鐢宠鍗曠紪鍙�")
+    @Excel(name = "鐢宠鍗曠紪鍙�")
     private String applyNo;
 
     /**
      * 瀹㈡埛鍚嶇О
      */
     @ApiModelProperty("瀹㈡埛鍚嶇О")
+    @Excel(name = "瀹㈡埛鍚嶇О")
     private String customerName;
 
     /**
      * 鐗╂枡缂栫爜
      */
     @ApiModelProperty("鐗╂枡缂栫爜")
+    @Excel(name = "鐗╂枡缂栫爜")
     private String materialCode;
+
+
+    /**
+     * 鍏宠仈鐗╂枡淇℃伅琛↖D
+     */
+    @ApiModelProperty("鍏宠仈鐗╂枡淇℃伅琛↖D")
+    private Integer productMaterialId;
 
     /**
      * 浜у搧鍚嶇О
      */
     @ApiModelProperty("浜у搧鍚嶇О")
+    @Excel(name = "浜у搧鍚嶇О")
     private String productName;
 
     /**
      * 浜у搧瑙勬牸
      */
     @ApiModelProperty("浜у搧瑙勬牸")
+    @Excel(name = "浜у搧瑙勬牸")
     private String productSpec;
 
     /**
      * 闀�
      */
     @ApiModelProperty("闀�")
+    @Excel(name = "闀�")
     private Integer length;
 
     /**
      * 瀹�
      */
     @ApiModelProperty("瀹�")
+    @Excel(name = "瀹�")
     private Integer width;
 
     /**
      * 楂�
      */
     @ApiModelProperty("楂�")
+    @Excel(name = "楂�")
     private Integer height;
 
     /**
      * 鍧楁暟
      */
     @ApiModelProperty("鍧楁暟")
+    @Excel(name = "鍧楁暟")
     private Integer quantity;
 
     /**
      * 鏂规暟
      */
     @ApiModelProperty("鏂规暟")
+    @Excel(name = "鏂规暟")
     private BigDecimal volume;
 
     /**
      * 寮哄害
      */
     @ApiModelProperty("寮哄害")
+    @Excel(name = "寮哄害")
     private String strength;
 
     /**
      * 寮�濮嬫棩鏈�
      */
-    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
     @ApiModelProperty("寮�濮嬫棩鏈�")
-    private LocalDateTime startDate;
+    @Excel(name = "寮�濮嬫棩鏈�", width = 20, dateFormat = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private Date startDate;
 
     /**
      * 缁撴潫鏃ユ湡
      */
     @ApiModelProperty("缁撴潫鏃ユ湡")
-    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
-    private LocalDateTime endDate;
+    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+    @Excel(name = "缁撴潫鏃ユ湡", width = 20, dateFormat = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private Date endDate;
 
     /**
      * 鎻愪氦浜�
      */
     @ApiModelProperty("鎻愪氦浜�")
+    @Excel(name = "鎻愪氦浜�")
     private String submitter;
 
     /**
      * 鎻愪氦浜虹粍缁�
      */
     @ApiModelProperty("鎻愪氦浜虹粍缁�")
+    @Excel(name = "鎻愪氦浜虹粍缁�")
     private String submitOrg;
 
     /**
      * 澶囨敞1
      */
     @ApiModelProperty("澶囨敞1")
+    @Excel(name = "澶囨敞1")
     private String remarkOne;
 
     /**
      * 澶囨敞2
      */
     @ApiModelProperty("澶囨敞2")
+    @Excel(name = "澶囨敞2")
     private String remarkTwo;
 
     /**
      * 鍒涘缓浜�
      */
     @ApiModelProperty("鍒涘缓浜�")
+    @Excel(name = "鍒涘缓浜�")
     private String creatorName;
 
     /**
      * 淇敼浜�
      */
     @ApiModelProperty("淇敼浜�")
+    @Excel(name = "淇敼浜�")
     private String modifierName;
 
     /**
@@ -204,5 +235,22 @@
     private Integer totalCount;
 
     @ApiModelProperty(value = "涓嬪彂鏁伴噺")
+    @Excel(name = "涓嬪彂鏁伴噺")
     private BigDecimal assignedQuantity;
+
+    /**
+     * 璁＄畻鍓╀綑鏂规暟
+     *
+     * @return 鍓╀綑鏂规暟
+     */
+    @ApiModelProperty(value = "鍓╀綑鏂规暟")
+    public BigDecimal getRemainingVolume() {
+        if (volume == null) {
+            return BigDecimal.ZERO;
+        }
+        if (assignedQuantity == null) {
+            return volume;
+        }
+        return volume.subtract(assignedQuantity);
+    }
 }
\ No newline at end of file

--
Gitblit v1.9.3