From 5ad764c0373e982bd208241a25aa26b4ef3780dc Mon Sep 17 00:00:00 2001
From: xyh <18782104331@139.com>
Date: 星期一, 28 六月 2021 17:13:53 +0800
Subject: [PATCH] excel导出
---
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/visit/EventVisitingTasksVO.java | 26 ++++++++++++++------------
1 files changed, 14 insertions(+), 12 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/visit/EventVisitingTasksVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/visit/EventVisitingTasksVO.java
index 19a9002..491d06d 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/visit/EventVisitingTasksVO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/visit/EventVisitingTasksVO.java
@@ -1,5 +1,6 @@
package com.panzhihua.common.model.vos.visit;
+import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
@@ -23,6 +24,7 @@
* */
@Data
@ApiModel("重点人群走访记录返回参数")
+@ExcelIgnoreUnannotated
@EncryptDecryptClass
public class EventVisitingTasksVO {
@@ -30,50 +32,50 @@
@JsonSerialize(using = ToStringSerializer.class)
private Long id;
- @ExcelProperty(value = "序号",index = 0)
- private Integer rowNum;
+// @ExcelProperty(value = "序号",index = 0)
+// private Integer rowNum;
- @ExcelProperty(value = "创建时间",index = 1)
+ @ExcelProperty(value = "创建时间",index = 0)
@ApiModelProperty(value = "创建时间")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date createAt;
- @ExcelProperty(value = "创建人",index = 2)
+ @ExcelProperty(value = "创建人",index = 1)
@ApiModelProperty(value = "创建人")
private String creator;
- @ExcelProperty(value = "走访对象",index = 3)
+ @ExcelProperty(value = "走访对象",index = 2)
@ApiModelProperty(value = "需走访人名字")
private String visiterName;
- @ExcelProperty(value = "身份证号码",index = 4)
+ @ExcelProperty(value = "身份证号码",index = 3)
@ApiModelProperty(value = "身份证号码")
private String cardNoStr;
- @ExcelProperty(value = "走访地址",index = 5)
+ @ExcelProperty(value = "走访地址",index = 4)
@ApiModelProperty(value = "走访地址")
private String visiterAddress;
- @ExcelProperty(value = "人员标签",index = 6)
+ @ExcelProperty(value = "人员标签",index = 5)
@ApiModelProperty(value = "人员标签")
private String visiterTypeName;
- @ExcelProperty(value = "走访人",index = 7)
+ @ExcelProperty(value = "走访人",index = 6)
@ApiModelProperty(value = "走访人")
private String dellUserName;
- @ExcelProperty(value = "完成走访时间",index = 8)
+ @ExcelProperty(value = "完成走访时间",index = 7)
@ApiModelProperty(value = "完成走访时间")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date submitDate;
- @ExcelProperty(value = "撤销时间",index = 9)
+ @ExcelProperty(value = "撤销时间",index = 8)
@ApiModelProperty(value = "撤销时间")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date cancelTime;
- @ExcelProperty(value = "状态",index = 10)
+ @ExcelProperty(value = "状态",index = 9)
@ApiModelProperty(value = "状态")
private String eventStatusName;
--
Gitblit v1.7.1