From dfed9c07aa8da5791d568736716bc4b44d59ebaf Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 16 Apr 2021 13:33:53 +0800
Subject: [PATCH] jfreechart+easyExcel 方式导出报表
---
blade-common/src/main/java/org/springblade/common/entity/AnimalHeatExcel.java | 18 ++++++++++++------
1 files changed, 12 insertions(+), 6 deletions(-)
diff --git a/blade-common/src/main/java/org/springblade/common/entity/AnimalHeatExcel.java b/blade-common/src/main/java/org/springblade/common/entity/AnimalHeatExcel.java
index 8139022..7893c9d 100644
--- a/blade-common/src/main/java/org/springblade/common/entity/AnimalHeatExcel.java
+++ b/blade-common/src/main/java/org/springblade/common/entity/AnimalHeatExcel.java
@@ -1,10 +1,13 @@
package org.springblade.common.entity;
+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 lombok.Data;
+import org.springblade.common.converter.AnimalHeatTypeConverter;
+
import java.util.Date;
@Data
@@ -13,7 +16,7 @@
@ContentRowHeight(18)
public class AnimalHeatExcel {
- @ColumnWidth(15)
+ @ColumnWidth(12)
@ExcelProperty("体温检测编号")
private Integer id;// bigint(20) NOT NULL COMMENT '主键',
@@ -25,12 +28,15 @@
@ExcelProperty("设备IP")
private String ip;// varchar(63) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备IP地址',
- @ColumnWidth(50)
+ @ColumnWidth(60)
@ExcelProperty("图片URL")
private String picture;// varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片url路径',
-// @TableField("picture_red")
-// private String pictureRed;// varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '红外图片url路径',
+ /**
+ * 忽略，不显示到excel
+ */
+ @ExcelIgnore
+ private String pictureRed;// varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '红外图片url路径',
@ColumnWidth(15)
@ExcelProperty("体温")
@@ -47,7 +53,7 @@
@ExcelProperty("创建时间")
private Date createTime;// datetime DEFAULT NULL COMMENT '创建时间',
- @ColumnWidth(25)
- @ExcelProperty("状态 1:异常 0:正常")
+ @ColumnWidth(10)
+ @ExcelProperty(value = "状态",converter = AnimalHeatTypeConverter.class)
private Integer status;//状态 1为异常 0为正常 ，以37.3度为标准，大于37.3度为高温
}
--
Gitblit v1.9.3