From a15a8cfd7b01ce4bba6fe9fd876f6704ca23a12d Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 07 一月 2025 16:40:32 +0800
Subject: [PATCH] 1、取水口用水日统计表中增加金额、次数字段； 2、优化或重写“累计流量超过指定值的取水口”、“累计流量低于指定值的取水口”、“指定时间段内用水量超过指定值的取水口”、“指定时间段内消费金额超过指定值的取水口”几个统计查询； 3、改“指定时间段内用水时长超过指定值的取水口”为“指定时间段内用水次数超过指定值的取水口”
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoDivide.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 58 insertions(+), 2 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoDivide.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoDivide.java
index 5973c5c..28edc55 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoDivide.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voPr/VoDivide.java
@@ -1,5 +1,8 @@
package com.dy.pipIrrGlobal.voPr;
+import com.alibaba.excel.annotation.ExcelIgnore;
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.dy.common.po.BaseEntity;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.v3.oas.annotations.media.Schema;
@@ -18,28 +21,81 @@
@Data
@Schema(title = "鍒嗘按鎴胯鍥惧璞�")
public class VoDivide implements BaseEntity {
- private static final long serialVersionUID = 1L;
+ private static final long serialVersionUID = 202401241704004L;
@Schema(title = "ID")
+ @ExcelProperty("ID")
+ @ColumnWidth(10)
private Long id;
+ @Schema(title = "鍒嗘按鎴跨紪鍙�")
+ @ExcelProperty("鍒嗘按鎴跨紪鍙�")
+ @ColumnWidth(15)
+ private String divideId;
+
@Schema(title = "鍒嗘按鎴垮悕绉�")
+ @ExcelProperty("鍒嗘按鎴垮悕绉�")
+ @ColumnWidth(15)
private String divideName;
- @Schema(title = "鎵�灞炵墖鍖�")
+ @Schema(title = "鎵�灞炵墖鍖篒D")
+ @ExcelProperty("鎵�灞炵墖鍖篒D")
+ @ColumnWidth(19)
+ private String blockId;
+
+ @Schema(title = "鎵�灞炵墖鍖哄悕绉�")
+ @ExcelProperty("鎵�灞炵墖鍖哄悕绉�")
+ @ColumnWidth(15)
private String blockName;
@Schema(title = "璐熻矗浜�")
+ @ExcelProperty("璐熻矗浜�")
+ @ColumnWidth(10)
private String header;
@Schema(title = "鑱旂郴鐢佃瘽")
+ @ExcelProperty("鑱旂郴鐢佃瘽")
+ @ColumnWidth(15)
private String phone;
@Schema(title = "褰掑睘鍦�")
+ @ExcelProperty("褰掑睘鍦�")
+ @ColumnWidth(25)
private String address;
+
+ @Schema(title = "瑕嗙洊鏉�")
+ @ExcelProperty("瑕嗙洊鏉�")
+ @ColumnWidth(25)
+ private String villages;
+
+ @Schema(title = "瑕嗙洊闈㈢Н")
+ @ExcelProperty("瑕嗙洊闈㈢Н")
+ @ColumnWidth(25)
+ private String area;
+
+ @Schema(title = "缁忓害")
+ @ExcelProperty("缁忓害")
+ @ColumnWidth(25)
+ private String lng;
+
+ @Schema(title = "绾害")
+ @ExcelProperty("绾害")
+ @ColumnWidth(25)
+ private String lat;
+
+ @Schema(title = "鎿嶄綔浜�")
+ @ExcelProperty("鎿嶄綔浜�")
+ @ColumnWidth(25)
+ private String operator;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
@Schema(title = "鎿嶄綔鏃堕棿")
+ @ExcelIgnore
private Date operateDt;
+
+ @Schema(title = "澶囨敞")
+ @ExcelProperty("澶囨敞")
+ @ColumnWidth(250)
+ private String remarks;
}
--
Gitblit v1.8.0