From 080edcadaec99063016531f1aa3e623b062d3c9b Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期二, 10 十月 2023 15:22:32 +0800
Subject: [PATCH] 骑行记录表优化和导出
---
server/services/src/main/java/com/doumee/dao/business/model/MemberRides.java | 60 ++++++++++++++----------------------------------------------
1 files changed, 14 insertions(+), 46 deletions(-)
diff --git a/server/services/src/main/java/com/doumee/dao/business/model/MemberRides.java b/server/services/src/main/java/com/doumee/dao/business/model/MemberRides.java
index dd62879..60fc871 100644
--- a/server/services/src/main/java/com/doumee/dao/business/model/MemberRides.java
+++ b/server/services/src/main/java/com/doumee/dao/business/model/MemberRides.java
@@ -6,6 +6,8 @@
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.poi.ss.usermodel.HorizontalAlignment;
+
import java.util.Date;
import java.math.BigDecimal;
@@ -20,168 +22,134 @@
public class MemberRides {
@ApiModelProperty(value = "缂栫爜")
- @ExcelColumn(name="缂栫爜")
private String id;
@ApiModelProperty(value = "鍒涘缓鏃堕棿")
- @ExcelColumn(name="鍒涘缓鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
private Date createDate;
@ApiModelProperty(value = "鍒涘缓浜�")
- @ExcelColumn(name="鍒涘缓浜�")
private String creator;
@ApiModelProperty(value = "缂栬緫鏃堕棿")
- @ExcelColumn(name="缂栬緫鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
private Date editDate;
@ApiModelProperty(value = "缂栬緫浜�")
- @ExcelColumn(name="缂栬緫浜�")
private String editor;
@ApiModelProperty(value = "鏄惁宸插垹闄� 0鏈垹闄� 1宸插垹闄�")
- @ExcelColumn(name="鏄惁宸插垹闄� 0鏈垹闄� 1宸插垹闄�")
@TableLogic
private Integer isdeleted;
@ApiModelProperty(value = "澶囨敞")
- @ExcelColumn(name="澶囨敞")
private String info;
@ApiModelProperty(value = "鐢ㄦ埛缂栫爜")
- @ExcelColumn(name="鐢ㄦ埛缂栫爜")
private String memberId;
@ApiModelProperty(value = "鐢ㄦ埛OpenId")
- @ExcelColumn(name="鐢ㄦ埛OpenId")
+ @ExcelColumn(name="鐢ㄦ埛",index = 1,width = 10,align = HorizontalAlignment.CENTER)
@TableField(exist = false)
private String memberOpenid;
@ApiModelProperty(value = "杞﹁締缂栫爜")
- @ExcelColumn(name="杞﹁締缂栫爜")
+ @ExcelColumn(name="杞﹁締缂栫爜",index = 2,width = 10,align = HorizontalAlignment.CENTER)
private String bikeCode;
@ApiModelProperty(value = "褰撳墠璐︽埛浣欓")
- @ExcelColumn(name="褰撳墠璐︽埛浣欓")
private BigDecimal balance;
@ApiModelProperty(value = "杞﹁締绫诲瀷缂栫爜")
- @ExcelColumn(name="杞﹁締绫诲瀷缂栫爜")
private String paramId;
@ApiModelProperty(value = "杞﹁締绫诲瀷鍚嶇О")
- @ExcelColumn(name="杞﹁締绫诲瀷鍚嶇О")
+ @ExcelColumn(name="杞﹁締绫诲瀷",index = 3,width = 10,align = HorizontalAlignment.CENTER)
@TableField(exist = false)
private String paramName;
@ApiModelProperty(value = "绉熻溅绔欑偣缂栫爜")
- @ExcelColumn(name="绉熻溅绔欑偣缂栫爜")
+ @ExcelColumn(name="绉熻溅绔欑偣",index = 4,width = 10,align = HorizontalAlignment.CENTER)
private String rentSiteId;
@ApiModelProperty(value = "绉熻溅閿佸ご缂栫爜")
- @ExcelColumn(name="绉熻溅閿佸ご缂栫爜")
+ @ExcelColumn(name="绉熻溅閿佸叿",index = 5,width = 10,align = HorizontalAlignment.CENTER)
private String rentLockId;
@ApiModelProperty(value = "绉熻溅鏃堕棿")
- @ExcelColumn(name="绉熻溅鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
+ @ExcelColumn(name="绉熻溅鏃堕棿",index = 6,width = 10,align = HorizontalAlignment.CENTER)
private Date rentDate;
@ApiModelProperty(value = "绉熻溅鎸囦护缂栫爜")
- @ExcelColumn(name="绉熻溅鎸囦护缂栫爜")
private String rentCommondD;
@ApiModelProperty(value = "杩樿溅绔欑偣缂栫爜")
- @ExcelColumn(name="杩樿溅绔欑偣缂栫爜")
+ @ExcelColumn(name="褰掕繕绔欑偣",index = 7,width = 10,align = HorizontalAlignment.CENTER)
private String backSiteId;
@ApiModelProperty(value = "杩樿溅閿佸ご缂栫爜")
- @ExcelColumn(name="杩樿溅閿佸ご缂栫爜")
+ @ExcelColumn(name="褰掕繕閿佸叿",index = 8,width = 10,align = HorizontalAlignment.CENTER)
private String backLockId;
@ApiModelProperty(value = "杩樿溅鏃堕棿")
- @ExcelColumn(name="杩樿溅鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
+ @ExcelColumn(name="褰掕繕鏃堕棿",index = 9,width = 10,align = HorizontalAlignment.CENTER))
private Date backDate;
@ApiModelProperty(value = "杩樿溅鎸囦护缂栫爜")
- @ExcelColumn(name="杩樿溅鎸囦护缂栫爜")
private String backCommondId;
@ApiModelProperty(value = "璧锋浠�")
- @ExcelColumn(name="璧锋浠�")
private BigDecimal basePrice;
@ApiModelProperty(value = "璧锋浠锋椂闂�")
- @ExcelColumn(name="璧锋浠锋椂闂�")
private Integer baseTime;
@ApiModelProperty(value = "瓒呭嚭鍗曚环")
- @ExcelColumn(name="瓒呭嚭鍗曚环")
private BigDecimal unitPrice;
@ApiModelProperty(value = "瓒呭嚭鏃堕棿鍗曚綅")
- @ExcelColumn(name="瓒呭嚭鏃堕棿鍗曚綅")
private Integer unitTime;
@ApiModelProperty(value = "楠戣浠锋牸")
- @ExcelColumn(name="楠戣浠锋牸")
private BigDecimal price;
@ApiModelProperty(value = "楠戣瀹為檯浠锋牸")
- @ExcelColumn(name="楠戣瀹為檯浠锋牸")
private BigDecimal actualPrice;
@ApiModelProperty(value = "楠戣璁¤垂鏃堕暱")
- @ExcelColumn(name="楠戣璁¤垂鏃堕暱")
+// @ExcelColumn(name="楠戣璁¤垂鏃堕暱",index = 1,width = 10,align = HorizontalAlignment.CENTER)
private Integer duration;
@ApiModelProperty(value = "缁撶畻鏃堕棿")
- @ExcelColumn(name="缁撶畻鏃堕棿")
- //@JsonFormat(pattern = "yyyy-MM-dd")
private Date closeDate;
@ApiModelProperty(value = "缁撶畻鐘舵�� 0鏈粨绠� 1宸茬粨鏉�")
- @ExcelColumn(name="缁撶畻鐘舵�� 0鏈粨绠� 1宸茬粨鏉�")
private Integer closeStatus;
+ @ApiModelProperty(value = "鐘舵�� 0璇锋眰寮�閿佷腑 1楠戣涓� 2宸茶繕杞� 3寮�閿佸け璐�")
+ private Integer status;
@ApiModelProperty(value = "鍏宠仈璁㈠崟缂栫爜(鍏宠仈goodsorder锛�")
- @ExcelColumn(name="鍏宠仈璁㈠崟缂栫爜(鍏宠仈goodsorder锛�")
private String ordreId;
@ApiModelProperty(value = "鏄惁缁撶畻璁¤垂杞﹀瀷 0鍚� 1鏄�")
- @ExcelColumn(name="鏄惁缁撶畻璁¤垂杞﹀瀷 0鍚� 1鏄�")
private Integer isStandard;
@ApiModelProperty(value = "璁′环鏂规缂栫爜(鍏宠仈pricing_detail)")
- @ExcelColumn(name="璁′环鏂规缂栫爜(鍏宠仈pricing_detail)")
private String pricingDetailId;
@ApiModelProperty(value = "鏄惁鑺傚亣鏃� 0涓嶆槸 1鏄�")
- @ExcelColumn(name="鏄惁鑺傚亣鏃� 0涓嶆槸 1鏄�")
private String isHoliday;
- @ApiModelProperty(value = "鐘舵�� 0璇锋眰寮�閿佷腑 1楠戣涓� 2宸茶繕杞� 3寮�閿佸け璐�")
- @ExcelColumn(name="鐘舵�� 0璇锋眰寮�閿佷腑 1楠戣涓� 2宸茶繕杞� 3寮�閿佸け璐�")
- private Integer status;
@ApiModelProperty(value = "杩樿溅绫诲瀷 0姝ｅ父杩樿溅 1寮哄埗杩樿溅")
- @ExcelColumn(name="杩樿溅绫诲瀷 0姝ｅ父杩樿溅 1寮哄埗杩樿溅")
private Integer backType;
@ApiModelProperty(value = "杩樿溅鍘熷洜")
- @ExcelColumn(name="杩樿溅鍘熷洜")
private String backReason;
@ApiModelProperty(value = "杩樿溅澶囨敞")
- @ExcelColumn(name="杩樿溅澶囨敞")
private String backInfo;
@ApiModelProperty(value = "寮哄埗杩樿溅鎿嶄綔浜�(鍏宠仈system_user)")
- @ExcelColumn(name="寮哄埗杩樿溅鎿嶄綔浜�(鍏宠仈system_user)")
private String backUserid;
}
--
Gitblit v1.9.3