From 2a4889b621bea7f49ee8977d56f5a0e15ddecd14 Mon Sep 17 00:00:00 2001
From: renkang <8417338+k94314517@user.noreply.gitee.com>
Date: 星期五, 06 十二月 2024 15:49:59 +0800
Subject: [PATCH] 客户资料 巡检任务业务

---
 server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java |   39 +++++++++------------------------------
 1 files changed, 9 insertions(+), 30 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
index e0c3601..52b009b 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/YwWorkorder.java
@@ -26,129 +26,103 @@
 
     @TableId(type = IdType.AUTO)
     @ApiModelProperty(value = "涓婚敭", example = "1")
-    @ExcelColumn(name="涓婚敭")
     private Integer id;
 
     @ApiModelProperty(value = "鍒涘缓浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鍒涘缓浜虹紪鐮�")
     private Integer creator;
 
     @ApiModelProperty(value = "鍒涘缓鏃堕棿")
-    @ExcelColumn(name="鍒涘缓鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date createDate;
 
     @ApiModelProperty(value = "鏇存柊浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鏇存柊浜虹紪鐮�")
     private Integer editor;
 
     @ApiModelProperty(value = "鏇存柊鏃堕棿")
-    @ExcelColumn(name="鏇存柊鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd")
     private Date editDate;
 
     @ApiModelProperty(value = "鏄惁鍒犻櫎0鍚� 1鏄�", example = "1")
-    @ExcelColumn(name="鏄惁鍒犻櫎0鍚� 1鏄�")
     private Integer isdeleted;
 
     @ApiModelProperty(value = "鏍囬")
-    @ExcelColumn(name="鏍囬")
     private String title;
 
     @ApiModelProperty(value = "澶囨敞")
-    @ExcelColumn(name="澶囨敞")
     private String remark;
 
     @ApiModelProperty(value = "鐘舵�� 0鍚敤 1绂佺敤", example = "1")
-    @ExcelColumn(name="鐘舵�� 0鍚敤 1绂佺敤")
     private Integer status;
 
     @ApiModelProperty(value = "鎺掑簭鐮�", example = "1")
-    @ExcelColumn(name="鎺掑簭鐮�")
     private Integer sortnum;
 
     @ApiModelProperty(value = "鎯呭喌璇存槑")
-    @ExcelColumn(name="鎯呭喌璇存槑")
     private String content;
 
     @ApiModelProperty(value = "涓婇棬鏃堕棿")
-    @ExcelColumn(name="涓婇棬鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date getDate;
 
     @ApiModelProperty(value = "鎵�灞為」鐩紪鐮侊紙鍏宠仈yw_project)", example = "1")
-    @ExcelColumn(name="鎵�灞為」鐩紪鐮侊紙鍏宠仈yw_project)")
     private Integer projectId;
 
     @ApiModelProperty(value = "鎵�灞炴ゼ瀹囩紪鐮侊紙鍏宠仈yw_building)", example = "1")
-    @ExcelColumn(name="鎵�灞炴ゼ瀹囩紪鐮侊紙鍏宠仈yw_building)")
     private Integer buildingId;
 
     @ApiModelProperty(value = "鎵�灞炴埧闂寸紪鐮侊紙鍏宠仈yw_room)", example = "1")
-    @ExcelColumn(name="鎵�灞炴埧闂寸紪鐮侊紙鍏宠仈yw_room)")
     private Integer roomId;
     @ApiModelProperty(value = "鎵�灞炴ゼ灞傜紪鐮侊紙鍏宠仈yw_floor)", example = "1")
-    @ExcelColumn(name="鎵�灞炴ゼ灞傜紪鐮侊紙鍏宠仈yw_floor)")
     private Integer floorId;
 
     @ApiModelProperty(value = "鎻愭姤浜虹紪鐮�", example = "1")
-    @ExcelColumn(name="鎻愭姤浜虹紪鐮�")
     private Integer userId;
 
     @ApiModelProperty(value = "鑱旂郴鐢佃瘽")
-    @ExcelColumn(name="鑱旂郴鐢佃瘽")
     private String phone;
 
     @ApiModelProperty(value = "鎻愭姤鏃堕棿")
-    @ExcelColumn(name="鎻愭姤鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @ExcelColumn(name="涓婃姤鏃堕棿",index = 5,width = 16,dateFormat = "yyyy-MM-dd HH:mm:ss")
     private Date submitDate;
 
     @ApiModelProperty(value = "宸ュ崟鍒嗙被缂栫爜(鍏宠仈category锛�", example = "1")
-    @ExcelColumn(name="宸ュ崟鍒嗙被缂栫爜(鍏宠仈category锛�")
     private Integer cateId;
 
     @ApiModelProperty(value = "淇濅慨鍖哄煙绫诲瀷 0瀹ゅ唴缁翠慨 1鍏叡鍖哄煙", example = "1")
-    @ExcelColumn(name="淇濅慨鍖哄煙绫诲瀷 0瀹ゅ唴缁翠慨 1鍏叡鍖哄煙")
+    @ExcelColumn(name="浣嶇疆鍖哄煙",valueMapping = "0=瀹ゅ唴缁翠慨;1=鍏叡鍖哄煙;",index = 0,width = 10)
     private Integer areaType;
 
     @ApiModelProperty(value = "宸ュ崟缂栧彿")
-    @ExcelColumn(name="宸ュ崟缂栧彿")
     private String code;
 
     @ApiModelProperty(value = "澶勭悊鐘舵�� 0寰呭鐞� 1宸插垎娲� 2宸插鐞�", example = "1")
-    @ExcelColumn(name="澶勭悊鐘舵�� 0寰呭鐞� 1宸插垎娲� 2宸插鐞�")
+    @ExcelColumn(name="宸ュ崟鐘舵��",index = 7,width = 10,valueMapping = "0=寰呭鐞�;1=宸插垎娲�;1=宸插鐞�;")
     private Integer dealStatus;
 
     @ApiModelProperty(value = "鍒嗘淳浜虹紪鐮�(鍏宠仈system_user)", example = "1")
-    @ExcelColumn(name="鍒嗘淳浜虹紪鐮�(鍏宠仈system_user)")
     private Integer dispatchUserId;
 
     @ApiModelProperty(value = "鍒嗘淳鏃堕棿")
-    @ExcelColumn(name="鍒嗘淳鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date dispatchDate;
 
     @ApiModelProperty(value = "鍒嗘淳澶勭悊璇存槑")
-    @ExcelColumn(name="鍒嗘淳澶勭悊璇存槑")
     private String dispatchInfo;
 
     @ApiModelProperty(value = "澶勭悊浜虹紪鐮�(鍏宠仈system_user)", example = "1")
-    @ExcelColumn(name="澶勭悊浜虹紪鐮�(鍏宠仈system_user)")
     private Integer dealUserId;
 
     @ApiModelProperty(value = "澶勭悊鏃堕棿")
-    @ExcelColumn(name="澶勭悊鏃堕棿")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private Date dealDate;
 
     @ApiModelProperty(value = "澶勭悊澶囨敞")
-    @ExcelColumn(name="澶勭悊澶囨敞")
     private String dealInfo;
 
     @ApiModelProperty(value = "澶勭悊鏂瑰紡 0鎸囨淳鍚庡鐞� 1鐩存帴鍥炲", example = "1")
-    @ExcelColumn(name="澶勭悊鏂瑰紡 0鎸囨淳鍚庡鐞� 1鐩存帴鍥炲")
     private Integer dealType;
+
     @ApiModelProperty(value = "椤圭洰鍚嶇О")
     @TableField(exist = false)
     private String projectName;
@@ -158,9 +132,11 @@
     private String queryStatus;
 
     @ApiModelProperty(value = "妤煎畤鍚嶇О")
+    @ExcelColumn(name="妤煎畤",index = 1,width = 10)
     @TableField(exist = false)
     private String buildingName;
     @ApiModelProperty(value = "鎴挎簮鍚嶇О")
+    @ExcelColumn(name="鎴挎簮",index = 2,width = 10)
     @TableField(exist = false)
     private String roomName;
     @ApiModelProperty(value = "妤煎眰鍚嶇О")
@@ -170,6 +146,7 @@
     @TableField(exist = false)
     private String roomNum;
     @ApiModelProperty(value = "鎻愭姤浜哄鍚�")
+    @ExcelColumn(name="涓婃姤浜�",index = 4,width = 10)
     @TableField(exist = false)
     private String creatorName;
     @ApiModelProperty(value = "鎻愭姤浜虹數璇�")
@@ -177,11 +154,13 @@
     private String creatorMobile;
     @ApiModelProperty(value = "澶勭悊浜哄鍚�")
     @TableField(exist = false)
+    @ExcelColumn(name="澶勭悊浜�",index = 6,width = 10)
     private String dealUserName;
     @ApiModelProperty(value = "澶勭悊浜虹粍缁�")
     @TableField(exist = false)
     private String dealUserCompany;
     @ApiModelProperty(value = "绫诲埆鍚嶇О")
+    @ExcelColumn(name="宸ュ崟鍒嗙被",index = 3,width = 10)
     @TableField(exist = false)
     private String categoryName;
     @ApiModelProperty(value = "鍒嗛厤浜哄鍚�")

--
Gitblit v1.9.3