From c4df5d2cfaa12a1c8a72ef25934fdc31d5be65a1 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期日, 29 九月 2024 11:21:21 +0800 Subject: [PATCH] 工单导出 --- ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 47 insertions(+), 6 deletions(-) diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java index b384837..1e982be 100644 --- a/ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java +++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java @@ -1,8 +1,14 @@ package com.ycl.platform.domain.excel; +import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; +import com.alibaba.excel.annotation.format.DateTimeFormat; import com.alibaba.excel.annotation.write.style.ColumnWidth; +import com.ycl.platform.domain.vo.DynamicColumnVO; import lombok.Data; + +import java.util.Date; +import java.util.List; /** * 鐐逛綅瀵煎叆瀵煎嚭 @@ -12,21 +18,56 @@ */ @Data public class PointExport { - + private Integer id; @ColumnWidth(50) - @ExcelProperty("鐐逛綅鍚嶇О") + @ExcelProperty("鐐逛綅鍚嶇О(鍙慨鏀�)") private String pointName; @ColumnWidth(30) - @ExcelProperty("鍥芥爣鐮�") + @ExcelProperty("鍥芥爣鐮�(涓嶅彲淇敼)") private String serialNumber; - @ColumnWidth(16) - @ExcelProperty("鐐逛綅IP") + @ColumnWidth(30) + @ExcelProperty("鐐逛綅IP(鍙慨鏀�)") private String pointIP; @ColumnWidth(40) - @ExcelProperty("褰撳墠杩愮淮鍗曚綅") + @ExcelProperty("褰撳墠杩愮淮鍗曚綅(瀵煎叆鐣岄潰鍙敼)") private String unitName; + @ColumnWidth(40) + @DateTimeFormat("yyyy-MM-dd") + @ExcelProperty("杩愮淮寮�濮嬫椂闂�(瀵煎叆鐣岄潰鍙敼)") + private Date startTime; + + @ColumnWidth(40) + @DateTimeFormat("yyyy-MM-dd") + @ExcelProperty("杩愮淮缁撴潫鏃堕棿(瀵煎叆鐣岄潰鍙敼)") + private Date endTime; + + @ExcelIgnore + private Boolean provinceTag; + + @ColumnWidth(20) + @ExcelProperty("鏄惁鐪佸巺鏍囩(鍙慨鏀�)") + private String provinceTagString; + + @ColumnWidth(20) + @ExcelProperty("鏄惁閲嶇偣鎸囨尌鍥惧儚(鍙慨鏀�)") + private String importantCommandImageTagString; + + @ColumnWidth(20) + @ExcelProperty("鏄惁閮ㄧ骇鏍囩(鍙慨鏀�)") + private String deptTag; + + @ExcelIgnore + private Boolean importantTag; + + @ExcelProperty("鏄惁閲嶇偣鐐逛綅") + private String importantTagString; + + @ExcelIgnore + private Boolean importantCommandImageTag; + + private List<DynamicColumnVO> dynamicData; } -- Gitblit v1.8.0