From db75b45e9a7ce347162b8d3a36e4a7f46cfe199e Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期一, 10 二月 2025 15:30:18 +0800 Subject: [PATCH] 核算导出单独对录像扣分的数量做处理 --- ycl-pojo/src/main/java/com/ycl/platform/domain/excel/PointExport.java | 77 +++++++++++++++++++++++++++++++++++--- 1 files changed, 71 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..c354891 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,80 @@ */ @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(30) + @ExcelProperty("鍖哄幙(涓嶅彲淇敼)") + private String area; @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 provinceTagVideo; + + @ExcelIgnore + private Boolean provinceTagCar; + + @ExcelIgnore + private Boolean provinceTagFace; + + @ColumnWidth(20) + @ExcelProperty("鏄惁鐪佸巺瑙嗛鏍囩(鍙慨鏀�)") + private String provinceTagVideoString; + + @ColumnWidth(20) + @ExcelProperty("鏄惁鐪佸巺杞﹁締鏍囩(鍙慨鏀�)") + private String provinceTagCarString; + + @ColumnWidth(20) + @ExcelProperty("鏄惁鐪佸巺浜鸿劯鏍囩(鍙慨鏀�)") + private String provinceTagFaceString; + @ColumnWidth(20) + @ExcelProperty("鏄惁閲嶇偣鎸囨尌鍥惧儚(鍙慨鏀�)") + private String importantCommandImageTagString; + + @ColumnWidth(20) + @ExcelProperty("鏄惁閮ㄧ骇鏍囩(鍙慨鏀�)") + private String deptTagString; + + @ExcelIgnore + private Boolean deptTag; + @ExcelIgnore + private Boolean importantTag; + + @ExcelProperty("鏄惁閲嶇偣鐐逛綅") + private String importantTagString; + + @ColumnWidth(20) + @ExcelProperty("鐢ㄦ埛鍚�(鍙慨鏀�)") + private String username; + @ColumnWidth(20) + @ExcelProperty("瀵嗙爜(鍙慨鏀�)") + private String password; + @ExcelIgnore + private Boolean importantCommandImageTag; + + private List<DynamicColumnVO> dynamicData; } -- Gitblit v1.8.0