From 1b4822da66a05ee7647f5f86a9f18f15dadb0a25 Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 17 May 2024 18:13:20 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
src/main/java/org/springblade/modules/house/excel/ExportHouseTenantExcel.java | 93 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 93 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/house/excel/ExportHouseTenantExcel.java b/src/main/java/org/springblade/modules/house/excel/ExportHouseTenantExcel.java
new file mode 100644
index 0000000..0fed67a
--- /dev/null
+++ b/src/main/java/org/springblade/modules/house/excel/ExportHouseTenantExcel.java
@@ -0,0 +1,93 @@
+package org.springblade.modules.house.excel;
+
+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 com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springblade.common.excel.ExcelDictConverter;
+import org.springblade.common.excel.ExcelDictItem;
+
+import java.io.Serializable;
+import java.util.Date;
+
+@Data
+@ColumnWidth(25)
+@HeadRowHeight(20)
+@ContentRowHeight(18)
+public class ExportHouseTenantExcel implements Serializable {
+
+ private static final long serialVersionUID = 2L;
+
+ /**
+ * 出租屋ID
+ */
+ @ExcelProperty(value = "房屋地址")
+ @ColumnWidth(25)
+ private String addressName;
+ /**
+ * 出租屋ID
+ */
+ @ExcelProperty(value = "地址编码")
+ @ColumnWidth(25)
+ private String houseCode;
+ /**
+ * 姓名
+ */
+ @ExcelProperty(value = "姓名")
+ @ColumnWidth(25)
+ private String name;
+ /**
+ * 联系电话
+ */
+ @ExcelProperty(value = "联系电话")
+ @ColumnWidth(25)
+ private String phone;
+ /**
+ * 身份证
+ */
+ @ExcelProperty(value = "身份证")
+ @ColumnWidth(25)
+ private String idCard;
+ /**
+ * 户籍
+ */
+ @ExcelProperty(value = "户籍")
+ @ColumnWidth(25)
+ private String domicile;
+ /**
+ * 工作单位
+ */
+ @ExcelProperty(value = "工作单位")
+ @ColumnWidth(25)
+ private String workUnit;
+
+ /**
+ * 备注
+ */
+ @ExcelProperty(value = "备注")
+ @ColumnWidth(25)
+ private String remark;
+
+
+ /** 性别 */
+ @ExcelProperty(value = "性别",converter = ExcelDictConverter.class)
+ @ExcelDictItem(type = "sex")
+ @ColumnWidth(25)
+ private Integer gender;
+
+ /** 民族 */
+ @ExcelProperty(value = "民族",converter = ExcelDictConverter.class)
+ @ExcelDictItem(type = "nationType")
+ private Integer ethnicity;
+
+ /** 创建时间 */
+ @ExcelProperty(value = "创建时间")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+ private Date createTime;
+
+}
--
Gitblit v1.9.3