From 2a959177f1adcd36f790e14718bbd116752e5c64 Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期六, 12 十月 2024 17:19:10 +0800 Subject: [PATCH] 2024-10-12 朱宝民 优化交易明细导出、取水口导出、阀控器导出 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoIntake.java | 48 ++++++++++++++++++++++++------------------------ 1 files changed, 24 insertions(+), 24 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoIntake.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoIntake.java index c8b7ece..530f5ad 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoIntake.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoIntake.java @@ -3,8 +3,11 @@ import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; +import com.alibaba.excel.annotation.write.style.ContentRowHeight; +import com.alibaba.excel.annotation.write.style.HeadRowHeight; import com.dy.common.po.BaseEntity; import com.fasterxml.jackson.annotation.JsonFormat; +import com.fasterxml.jackson.annotation.JsonPropertyOrder; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; @@ -19,62 +22,61 @@ */ @Data -@Schema(title = "鍙栨按鍙h鍥惧璞�") +@JsonPropertyOrder({ "intakeId", "intakeName", "divideId", "divideName", "blockId", "blockName", "isBind", "address", "lng", "lat", "operator", "operateDt", "remarks", "controllerId", "rtuAddr"}) +@HeadRowHeight(30) +@ContentRowHeight(20) public class VoIntake implements BaseEntity { private static final long serialVersionUID = 202312261049001L; @Schema(title = "鍙栨按鍙D") - @ExcelProperty("鍙栨按鍙D") - @ColumnWidth(10) + @ExcelIgnore private String intakeId; @Schema(title = "鍙栨按鍙e悕绉�") - @ExcelProperty("鍙栨按鍙e悕绉�") + @ExcelProperty(value = {"${title}", "鍙栨按鍙g紪鍙�"}) @ColumnWidth(15) private String intakeName; @Schema(title = "鍒嗘按鎴縄D") - @ExcelProperty("鍒嗘按鎴縄D") - @ColumnWidth(10) + @ExcelIgnore private String divideId; @Schema(title = "鎵�灞炲垎姘存埧") - @ExcelProperty("鎵�灞炲垎姘存埧") + @ExcelProperty(value = {"${title}", "鎵�灞炲垎姘存埧"}) @ColumnWidth(15) private String divideName; @Schema(title = "鐗囧尯ID") - @ExcelProperty("鐗囧尯ID") - @ColumnWidth(15) + @ExcelIgnore private String blockId; @Schema(title = "鎵�灞炵墖鍖�") - @ExcelProperty("鎵�灞炵墖鍖�") + @ExcelProperty(value = {"${title}", "鎵�灞炵墖鍖�"}) @ColumnWidth(15) private String blockName; @Schema(title = "缁戝畾璁惧") - @ExcelProperty("缁戝畾璁惧") - @ColumnWidth(6) + @ExcelProperty(value = {"${title}", "缁戝畾璁惧"}) + @ColumnWidth(10) private String isBind; @Schema(title = "鍦板潃") - @ExcelProperty("鍦板潃") - @ColumnWidth(25) + @ExcelProperty(value = {"${title}", "鍦板潃"}) + @ColumnWidth(30) private String address; @Schema(title = "缁忓害") - @ExcelProperty("缁忓害") - @ColumnWidth(25) + @ExcelProperty(value = {"${title}", "缁忓害"}) + @ColumnWidth(20) private String lng; @Schema(title = "绾害") - @ExcelProperty("绾害") - @ColumnWidth(25) + @ExcelProperty(value = {"${title}", "绾害"}) + @ColumnWidth(20) private String lat; @Schema(title = "鎿嶄綔浜�") - @ExcelProperty("鎿嶄綔浜�") + @ExcelIgnore @ColumnWidth(25) private String operator; @@ -85,17 +87,15 @@ private Date operateDt; @Schema(title = "澶囨敞") - @ExcelProperty("澶囨敞") - @ColumnWidth(250) + @ExcelIgnore private String remarks; @Schema(title = "鎺у埗鍣↖D") - @ExcelProperty("鎺у埗鍣↖D") - @ColumnWidth(15) + @ExcelIgnore private String controllerId; @Schema(title = "鎺у埗鍣ㄥ湴鍧�") - @ExcelProperty("鎺у埗鍣ㄥ湴鍧�") + @ExcelProperty(value = {"${title}", "鎺у埗鍣ㄥ湴鍧�"}) @ColumnWidth(15) private String rtuAddr; } -- Gitblit v1.8.0