From 27dfcfed6ae2edaa0a4052615866d07c140304cb Mon Sep 17 00:00:00 2001
From: jiaosong <jiaosong6760@dingtalk.com>
Date: 星期四, 26 十月 2023 11:52:51 +0800
Subject: [PATCH] # excel导出调整
---
server/services/src/main/java/com/doumee/dao/business/model/ActionLog.java | 76 +++++++++++++++++++++++++------------
1 files changed, 51 insertions(+), 25 deletions(-)
diff --git a/server/services/src/main/java/com/doumee/dao/business/model/ActionLog.java b/server/services/src/main/java/com/doumee/dao/business/model/ActionLog.java
index 5ad6827..d6a0892 100644
--- a/server/services/src/main/java/com/doumee/dao/business/model/ActionLog.java
+++ b/server/services/src/main/java/com/doumee/dao/business/model/ActionLog.java
@@ -1,5 +1,6 @@
package com.doumee.dao.business.model;
+import com.baomidou.mybatisplus.annotation.TableField;
import com.doumee.core.annotation.excel.ExcelColumn;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
@@ -8,7 +9,10 @@
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.poi.ss.usermodel.HorizontalAlignment;
+
import java.util.Date;
+import java.util.List;
/**
* 绯荤粺琛屼负鎿嶄綔璁板綍琛�
@@ -21,88 +25,110 @@
public class ActionLog {
@ApiModelProperty(value = "缂栫爜")
- @ExcelColumn(name="缂栫爜")
private String id;
@ApiModelProperty(value = "鍒涘缓鏃堕棿")
- @ExcelColumn(name="鍒涘缓鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
+ @ExcelColumn(name="鍒涘缓鏃堕棿",index = 6,width = 10,align = HorizontalAlignment.CENTER)
private Date createDate;
@ApiModelProperty(value = "鍒涘缓浜�")
- @ExcelColumn(name="鍒涘缓浜�")
+ @ExcelColumn(name="鍒涘缓浜�",index = 7,width = 10,align = HorizontalAlignment.CENTER)
private String creator;
+
+ @ApiModelProperty(value = "鍒涘缓浜哄悕绉�")
+ @ExcelColumn(name="鍒涘缓浜哄悕绉�",index = 7,width = 10,align = HorizontalAlignment.CENTER)
+ @TableField(exist = false)
+ private String creatorName;
+
@ApiModelProperty(value = "缂栬緫鏃堕棿")
- @ExcelColumn(name="缂栬緫鏃堕棿")
//@JsonFormat(pattern = "yyyy-MM-dd")
private Date editDate;
@ApiModelProperty(value = "缂栬緫浜�")
- @ExcelColumn(name="缂栬緫浜�")
private String editor;
@ApiModelProperty(value = "鏄惁宸插垹闄� 0鏈垹闄� 1宸插垹闄�", example = "1")
- @ExcelColumn(name="鏄惁宸插垹闄� 0鏈垹闄� 1宸插垹闄�")
private Integer isdeleted;
@ApiModelProperty(value = "澶囨敞")
- @ExcelColumn(name="澶囨敞")
private String info;
@ApiModelProperty(value = "鏍囬")
- @ExcelColumn(name="鏍囬")
private String title;
@ApiModelProperty(value = "鍐呭")
- @ExcelColumn(name="鍐呭")
private String content;
- @ApiModelProperty(value = "绫诲瀷 ", example = "1")
- @ExcelColumn(name="绫诲瀷 ")
+ @ApiModelProperty(value = "绫诲瀷 0寮哄埗杩樿溅 1楠戣鏃堕暱淇敼", example = "1")
+ @ExcelColumn(name="绫诲瀷 " ,valueMapping = "0=寮哄埗杩樿溅;1=楠戣鏃堕暱淇敼;",index = 5,width = 10,align = HorizontalAlignment.CENTER)
private Integer type;
+ @ApiModelProperty(value = "绫诲瀷闆嗗悎", example = "1")
+ @TableField(exist = false)
+ private List<Integer> typeList;
@ApiModelProperty(value = "鍏宠仈瀵硅薄缂栫爜")
- @ExcelColumn(name="鍏宠仈瀵硅薄缂栫爜")
private String objId;
@ApiModelProperty(value = "鍏宠仈瀵硅薄绫诲瀷 ", example = "1")
- @ExcelColumn(name="鍏宠仈瀵硅薄绫诲瀷 ")
private Integer objType;
@ApiModelProperty(value = "鐢ㄦ埛缂栫爜")
- @ExcelColumn(name="鐢ㄦ埛缂栫爜")
private String userId;
@ApiModelProperty(value = "鐢ㄦ埛绫诲瀷 0浼氬憳 1绯荤粺鐢ㄦ埛", example = "1")
- @ExcelColumn(name="鐢ㄦ埛绫诲瀷 0浼氬憳 1绯荤粺鐢ㄦ埛")
private Integer userType;
@ApiModelProperty(value = "鎿嶄綔鍓嶅唴瀹�")
- @ExcelColumn(name="鎿嶄綔鍓嶅唴瀹�")
private String beforeContent;
@ApiModelProperty(value = "鎿嶄綔鍚庡唴瀹�")
- @ExcelColumn(name="鎿嶄綔鍚庡唴瀹�")
private String afterContent;
@ApiModelProperty(value = "鍙傛暟1")
- @ExcelColumn(name="鍙傛暟1")
private String param;
@ApiModelProperty(value = "鍙傛暟2")
- @ExcelColumn(name="鍙傛暟2")
private String param2;
@ApiModelProperty(value = "鍙傛暟3")
- @ExcelColumn(name="鍙傛暟3")
private String param3;
@ApiModelProperty(value = "鎿嶄綔缁撴灉 0鎴愬姛 1澶辫触", example = "1")
- @ExcelColumn(name="鎿嶄綔缁撴灉 0鎴愬姛 1澶辫触")
private Integer result;
- @ApiModelProperty(value = "鎿嶄綔缁撴灉 0鎴愬姛 1澶辫触", example = "1")
- @ExcelColumn(name="鎿嶄綔缁撴灉 0鎴愬姛 1澶辫触")
- private Integer result;
+ @ApiModelProperty(value = "鎿嶄綔鍘熷洜")
+ @ExcelColumn(name="鎿嶄綔鍘熷洜",index = 8,width = 10,align = HorizontalAlignment.CENTER)
+ private String actReason;
+
+ @ApiModelProperty(value = "鎿嶄綔澶囨敞")
+ @ExcelColumn(name="鎿嶄綔澶囨敞",index = 9,width = 10,align = HorizontalAlignment.CENTER)
+ private String actInfo;
+
+ @ApiModelProperty(value = "楠戣璁板綍瀵硅薄" )
+ @TableField(exist = false)
+ private MemberRides ridesObj;
+ @ApiModelProperty(value = "杞︾紪鍙�" )
+ @TableField(exist = false)
+ private String bikeCode;
+ @ApiModelProperty(value = "鐢ㄦ埛" )
+ @ExcelColumn(name="鐢ㄦ埛",index = 1,width = 10,align = HorizontalAlignment.CENTER)
+ @TableField(exist = false)
+ private String openid;
+ @ApiModelProperty(value = "鍊熷嚭绔欑偣" )
+ @ExcelColumn(name="鍊熷嚭绔欑偣",index = 3,width = 10,align = HorizontalAlignment.CENTER)
+ @TableField(exist = false)
+ private String rentSiteId;
+ @ApiModelProperty(value = "鍊熷嚭鏃堕棿" )
+ @ExcelColumn(name="鍊熷嚭鏃堕棿",index = 4,width = 10,align = HorizontalAlignment.CENTER)
+ @TableField(exist = false)
+ private Date rentDate;
+ @ApiModelProperty(value = "鏌ヨ寮�濮嬫棩鏈燂紙鍖呭惈锛�", example = "2023-10-01 15:12:01")
+ @TableField(exist = false)
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date startDate;
+ @ApiModelProperty(value = "鏌ヨ鎴鏃ユ湡锛堝寘鍚級", example = "2023-10-09 15:12:05")
+ @TableField(exist = false)
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date endDate;
}
--
Gitblit v1.9.3