From ad9e95343ccec55d45d73d9e814b7c68ac38e9ca Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期二, 05 八月 2025 10:55:11 +0800
Subject: [PATCH] 1

---
 src/main/java/com/zy/asrs/entity/ReviewDetl.java |  193 +++++++++++++++++++++++++++++++----------------
 1 files changed, 127 insertions(+), 66 deletions(-)

diff --git a/src/main/java/com/zy/asrs/entity/ReviewDetl.java b/src/main/java/com/zy/asrs/entity/ReviewDetl.java
index 5f667aa..d036dda 100644
--- a/src/main/java/com/zy/asrs/entity/ReviewDetl.java
+++ b/src/main/java/com/zy/asrs/entity/ReviewDetl.java
@@ -1,5 +1,7 @@
 package com.zy.asrs.entity;
 
+import com.alibaba.excel.annotation.ExcelIgnore;
+import com.alibaba.excel.annotation.ExcelProperty;
 import com.baomidou.mybatisplus.annotations.TableField;
 import com.baomidou.mybatisplus.annotations.TableId;
 import com.baomidou.mybatisplus.annotations.TableName;
@@ -8,7 +10,6 @@
 import com.core.common.Cools;
 import com.core.common.SpringUtils;
 import com.zy.asrs.service.BasBoxTypeService;
-import com.zy.asrs.service.OrderService;
 import com.zy.common.utils.Synchro;
 import com.zy.system.entity.User;
 import com.zy.system.service.UserService;
@@ -29,289 +30,338 @@
     /**
      * ID
      */
-    @ApiModelProperty(value= "ID")
+    @ApiModelProperty(value = "ID")
     @TableId(value = "id", type = IdType.AUTO)
+    @ExcelIgnore
     private Long id;
 
     /**
      * 璁㈠崟鍐呯爜
      */
-    @ApiModelProperty(value= "璁㈠崟鍐呯爜")
+    @ApiModelProperty(value = "璁㈠崟鍐呯爜")
+    @ExcelIgnore
     @TableField("order_id")
     private Long orderId;
 
     /**
      * 鍗曟嵁缂栧彿
      */
-    @ApiModelProperty(value= "鍗曟嵁缂栧彿")
+    @ApiModelProperty(value = "鍗曟嵁缂栧彿")
     @TableField("order_no")
+    @ExcelProperty("鍗曟嵁缂栧彿")
     private String orderNo;
 
 
     /**
      * 鏁伴噺
      */
-    @ApiModelProperty(value= "鏁伴噺")
+    @ApiModelProperty(value = "鏁伴噺")
+    @ExcelProperty("鍑�閲�")
     private Double anfme;
 
     /**
      * 浣滀笟鏁伴噺
-     *
-     *  鍏ュ簱 : 缁勬墭瀹屾垚锛岀粍鎵樻。銆佸伐浣滄。銆佸叆搴撳畬鎴愭暟閲�
-     *  鍑哄簱 : 宸ヤ綔妗c�佸嚭搴撳畬鎴愭暟閲�
+     * <p>
+     * 鍏ュ簱 : 缁勬墭瀹屾垚锛岀粍鎵樻。銆佸伐浣滄。銆佸叆搴撳畬鎴愭暟閲�
+     * 鍑哄簱 : 宸ヤ綔妗c�佸嚭搴撳畬鎴愭暟閲�
      */
-    @ApiModelProperty(value= "浣滀笟鏁伴噺")
+    @ApiModelProperty(value = "浣滀笟鏁伴噺")
     @TableField("work_qty")
+    @ExcelIgnore
     private Double workQty;
 
     /**
      * 瀹屾垚鏁伴噺
-     *
-     *  鍏ュ簱 : qty 馃憜
-     *  鍑哄簱 : qty 馃憜
+     * <p>
+     * 鍏ュ簱 : qty 馃憜
+     * 鍑哄簱 : qty 馃憜
      */
-    @ApiModelProperty(value= "瀹屾垚鏁伴噺")
+    @ApiModelProperty(value = "瀹屾垚鏁伴噺")
+    @ExcelIgnore
     private Double qty;
 
     /**
      * 鍟嗗搧缂栫爜
      */
-    @ApiModelProperty(value= "鍟嗗搧缂栫爜")
+    @ApiModelProperty(value = "鍟嗗搧缂栫爜")
+    @ExcelProperty("鐗╂枡缂栫爜")
     private String matnr;
 
     /**
      * 鍟嗗搧鍚嶇О
      */
-    @ApiModelProperty(value= "鍟嗗搧鍚嶇О")
+    @ApiModelProperty(value = "鍟嗗搧鍚嶇О")
+    @ExcelProperty("鐗╂枡鍚嶇О")
     private String maktx;
 
     /**
      * 鎵瑰彿
      */
-    @ApiModelProperty(value= "鎵瑰彿")
+    @ApiModelProperty(value = "鎵瑰彿")
+    @ExcelProperty("鎵规鍙�")
     private String batch;
 
     /**
      * 瑙勬牸
      */
-    @ApiModelProperty(value= "瑙勬牸")
+    @ApiModelProperty(value = "瑙勬牸")
+    @ExcelProperty("瑙勬牸鍨嬪彿")
     private String specs;
 
     /**
      * 鍨嬪彿
      */
-    @ApiModelProperty(value= "鍨嬪彿")
+    @ApiModelProperty(value = "鍨嬪彿")
+    @ExcelProperty("鍗峰彿")
     private String model;
 
     /**
      * 棰滆壊
      */
-    @ApiModelProperty(value= "棰滆壊")
+    @ApiModelProperty(value = "棰滆壊")
+    @ExcelIgnore
     private String color;
 
     /**
      * 鍝佺墝
      */
-    @ApiModelProperty(value= "鍝佺墝")
+    @ApiModelProperty(value = "鍝佺墝")
+    @ExcelIgnore
     private String brand;
 
     /**
      * 鍗曚綅
      */
-    @ApiModelProperty(value= "鍗曚綅")
+    @ApiModelProperty(value = "鍗曚綅")
+    @ExcelIgnore
     private String unit;
 
     /**
      * 鍗曚环
      */
-    @ApiModelProperty(value= "鍗曚环")
+    @ApiModelProperty(value = "鍗曚环")
+    @ExcelIgnore
     private Double price;
 
     /**
      * sku
      */
-    @ApiModelProperty(value= "sku")
+    @ApiModelProperty(value = "sku")
+    @ExcelIgnore
     private String sku;
 
     /**
      * 鍗曚綅閲�
      */
-    @ApiModelProperty(value= "鍗曚綅閲�")
+    @ApiModelProperty(value = "鍗曚綅閲�")
+    @ExcelIgnore
     private Double units;
 
     /**
      * 鏉$爜
      */
-    @ApiModelProperty(value= "鏉$爜")
+    @ApiModelProperty(value = "鏉$爜")
+    @ExcelIgnore
     private String barcode;
 
     /**
      * 浜у湴
      */
-    @ApiModelProperty(value= "浜у湴")
+    @ApiModelProperty(value = "浜у湴")
+    @ExcelIgnore
     private String origin;
 
     /**
      * 鍘傚 銆併�佹睙閾滐細鏆傚瓨搴撲綅鍙�
      */
-    @ApiModelProperty(value= "鍘傚")
+    @ApiModelProperty(value = "鍘傚")
+    @ExcelIgnore
     private String manu;
 
     /**
      * 鐢熶骇鏃ユ湡
      */
-    @ApiModelProperty(value= "鐢熶骇鏃ユ湡")
+    @ApiModelProperty(value = "鐢熶骇鏃ユ湡")
+    @ExcelIgnore
     @TableField("manu_date")
     private String manuDate;
 
     /**
      * 鍝侀」鏁�
      */
-    @ApiModelProperty(value= "鍝侀」鏁�")
+    @ApiModelProperty(value = "鍝侀」鏁�")
+    @ExcelIgnore
     @TableField("item_num")
     private String itemNum;
 
     /**
      * 瀹夊叏搴撳瓨閲�
      */
-    @ApiModelProperty(value= "瀹夊叏搴撳瓨閲�")
+    @ApiModelProperty(value = "瀹夊叏搴撳瓨閲�")
+    @ExcelIgnore
     @TableField("safe_qty")
     private Double safeQty;
 
     /**
      * 閲嶉噺
      */
-    @ApiModelProperty(value= "閲嶉噺")
+    @ApiModelProperty(value = "閲嶉噺")
+    @ExcelIgnore
     private Double weight;
 
     /**
      * 闀垮害
      */
-    @ApiModelProperty(value= "闀垮害")
+    @ApiModelProperty(value = "闀垮害")
+    @ExcelIgnore
     private Double length;
 
     /**
      * 浣撶Н
      */
-    @ApiModelProperty(value= "浣撶Н")
+    @ApiModelProperty(value = "浣撶Н")
+    @ExcelIgnore
     private Double volume;
 
     /**
      * 涓夋柟缂栫爜
      */
-    @ApiModelProperty(value= "涓夋柟缂栫爜")
+    @ApiModelProperty(value = "涓夋柟缂栫爜")
     @TableField("three_code")
+    @ExcelProperty("澶嶆牳浜�")
     private String threeCode;
 
     /**
      * 渚涘簲鍟�
      */
-    @ApiModelProperty(value= "渚涘簲鍟�")
+    @ApiModelProperty(value = "渚涘簲鍟�")
+    @ExcelIgnore
     private String supp;
 
     /**
      * 渚涘簲鍟嗙紪鐮�
      */
-    @ApiModelProperty(value= "渚涘簲鍟嗙紪鐮�")
+    @ApiModelProperty(value = "渚涘簲鍟嗙紪鐮�")
+    @ExcelIgnore
     @TableField("supp_code")
     private String suppCode;
 
     /**
      * 鏄惁鎵规 1: 鏄�  0: 鍚�
      */
-    @ApiModelProperty(value= "鏄惁鎵规 1: 鏄�  0: 鍚�  ")
+    @ApiModelProperty(value = "鏄惁鎵规 1: 鏄�  0: 鍚�  ")
     @TableField("be_batch")
+    @ExcelIgnore
     private Integer beBatch;
 
     /**
      * 淇濊川鏈�
      */
-    @ApiModelProperty(value= "淇濊川鏈�")
+    @ApiModelProperty(value = "淇濊川鏈�")
     @TableField("dead_time")
+    @ExcelProperty("鍑哄簱鏃ユ湡")
     private String deadTime;
 
     /**
      * 棰勮澶╂暟
      */
-    @ApiModelProperty(value= "棰勮澶╂暟")
+    @ApiModelProperty(value = "棰勮澶╂暟")
+    @ExcelIgnore
     @TableField("dead_warn")
     private Integer deadWarn;
 
     /**
      * 鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗  銆併�佹睙閾滐細鏄惁纭   1: 纭  2: 鏈‘璁�
      */
-    @ApiModelProperty(value= "鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗  ")
+    @ApiModelProperty(value = "鍒惰喘 1: 鍒堕��  2: 閲囪喘  3: 澶栧崗  ")
+    @ExcelIgnore
     private Integer source;
 
     /**
      * 瑕佹眰妫�楠� 1: 鏄�  0: 鍚�
      */
-    @ApiModelProperty(value= "瑕佹眰妫�楠� 1: 鏄�  0: 鍚�  ")
+    @ApiModelProperty(value = "瑕佹眰妫�楠� 1: 鏄�  0: 鍚�  ")
+    @ExcelIgnore
     private Integer inspect;
+
+    @ExcelProperty("鏄惁澶嶆牳")
+    @TableField(exist = false)
+    private String inspect$;
 
     /**
      * 鍗遍櫓鍝� 1: 鏄�  0: 鍚�
      */
-    @ApiModelProperty(value= "鍗遍櫓鍝� 1: 鏄�  0: 鍚�  ")
+    @ApiModelProperty(value = "鍗遍櫓鍝� 1: 鏄�  0: 鍚�  ")
+    @ExcelIgnore
     private Integer danger;
 
     /**
      * 鐘舵�� 1: 姝e父  0: 绂佺敤
      */
-    @ApiModelProperty(value= "鐘舵�� 1: 姝e父  0: 绂佺敤  ")
+    @ApiModelProperty(value = "鐘舵�� 1: 姝e父  0: 绂佺敤  ")
+    @ExcelIgnore
     private Integer status;
 
     /**
      * 娣诲姞浜哄憳
      */
-    @ApiModelProperty(value= "娣诲姞浜哄憳")
+    @ApiModelProperty(value = "娣诲姞浜哄憳")
+    @ExcelIgnore
     @TableField("create_by")
     private Long createBy;
 
     /**
      * 娣诲姞鏃堕棿
      */
-    @ApiModelProperty(value= "娣诲姞鏃堕棿")
+    @ApiModelProperty(value = "娣诲姞鏃堕棿")
+    @ExcelIgnore
     @TableField("create_time")
-    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date createTime;
 
     /**
      * 淇敼浜哄憳
      */
-    @ApiModelProperty(value= "淇敼浜哄憳")
+    @ApiModelProperty(value = "淇敼浜哄憳")
+    @ExcelIgnore
     @TableField("update_by")
     private Long updateBy;
 
     /**
      * 淇敼鏃堕棿
      */
-    @ApiModelProperty(value= "淇敼鏃堕棿")
+    @ApiModelProperty(value = "淇敼鏃堕棿")
     @TableField("update_time")
-    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @ExcelProperty("澶嶆牳鏃堕棿")
     private Date updateTime;
 
     /**
      * 澶囨敞
      */
-    @ApiModelProperty(value= "澶囨敞")
+    @ApiModelProperty(value = "澶囨敞")
+    @ExcelProperty("澶嶆牳澶囨敞")
     private String memo;
 
     @ApiModelProperty(value = "閫�搴撴爣璁�")
+    @ExcelIgnore
     @TableField("tk_type")
     private Integer tkType;
 
     /**
      * 鍗蜂俊鎭疘D
      */
-    @ApiModelProperty(value= "鍗蜂俊鎭疘D")
+    @ApiModelProperty(value = "鍗蜂俊鎭疘D")
+    @ExcelIgnore
     @TableField("roll_up")
     private Long rollUp;
 
 
-    public String getStatus$(){
-        if (null == this.status){ return null; }
-        switch (this.status){
+    public String getStatus$() {
+        if (null == this.status) {
+            return null;
+        }
+        switch (this.status) {
             case 1:
                 return "姝e父";
             case 0:
@@ -321,43 +371,54 @@
         }
     }
 
-    public String getCreateBy$(){
+    public String getCreateBy$() {
         UserService service = SpringUtils.getBean(UserService.class);
         User user = service.selectById(this.createBy);
-        if (!Cools.isEmpty(user)){
+        if (!Cools.isEmpty(user)) {
             return String.valueOf(user.getUsername());
         }
         return null;
     }
 
-    public String getCreateTime$(){
-        if (Cools.isEmpty(this.createTime)){
+    public String getCreateTime$() {
+        if (Cools.isEmpty(this.createTime)) {
             return "";
         }
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime);
     }
 
-    public String getUpdateBy$(){
+    public String getUpdateBy$() {
         UserService service = SpringUtils.getBean(UserService.class);
         User user = service.selectById(this.updateBy);
-        if (!Cools.isEmpty(user)){
+        if (!Cools.isEmpty(user)) {
             return String.valueOf(user.getUsername());
         }
         return null;
     }
 
-    public String getUpdateTime$(){
-        if (Cools.isEmpty(this.updateTime)){
+    public String getUpdateTime$() {
+        if (Cools.isEmpty(this.updateTime)) {
             return "";
         }
         return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime);
     }
 
-    public String getQty$(){
-        if (getAnfme().equals(getQty())){
+    public String getQty$() {
+        if (getAnfme().equals(getQty())) {
             return "宸插畬鎴�";
         }
         return "鏈畬鎴�";
+    }
+
+    public String getInspect$() {
+        if (Cools.isEmpty(this.inspect)) {
+            return "鏈鏍�";
+        }
+        if (this.inspect == 1) {
+            return "宸插鏍�";
+        } else {
+            return "鏈鏍�";
+        }
     }
 
     public Double getEnableQty() {
@@ -374,10 +435,10 @@
         Synchro.Copy(source, this);
     }
 
-    public String getBrand$(){
+    public String getBrand$() {
         BasBoxTypeService basBoxTypeService = SpringUtils.getBean(BasBoxTypeService.class);
         BasBoxType basBoxType = basBoxTypeService.selectOne(new EntityWrapper<BasBoxType>().eq("box_type", this.brand));
-        if (!Cools.isEmpty(basBoxType)){
+        if (!Cools.isEmpty(basBoxType)) {
             return String.valueOf(basBoxType.getBoxSpecs());
         }
         return this.brand;

--
Gitblit v1.9.1