From 24de3c28662a351a056adbecc0027ca1b90a8b0e Mon Sep 17 00:00:00 2001
From: whywhyo <1511349576@qq.com>
Date: 星期二, 25 七月 2023 08:43:35 +0800
Subject: [PATCH] 21564
---
zhang-content/src/main/java/com/ruoyi/domain/dto/MarryInfoDto.java | 62 +++++++++++++++++++++++++++----
1 files changed, 54 insertions(+), 8 deletions(-)
diff --git a/zhang-content/src/main/java/com/ruoyi/domain/dto/MarryInfoDto.java b/zhang-content/src/main/java/com/ruoyi/domain/dto/MarryInfoDto.java
index b0c4bab..fb45095 100644
--- a/zhang-content/src/main/java/com/ruoyi/domain/dto/MarryInfoDto.java
+++ b/zhang-content/src/main/java/com/ruoyi/domain/dto/MarryInfoDto.java
@@ -1,8 +1,13 @@
package com.ruoyi.domain.dto;
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.converter.BearStatusConverter;
import com.ruoyi.domain.MarryUser;
import lombok.Data;
+import org.apache.poi.ss.usermodel.IndexedColors;
import java.io.Serializable;
import java.util.Date;
@@ -20,28 +25,60 @@
//鎴戜釜浜虹殑鏁版嵁
private String id;
+ // @ExcelProperty({"涓汉鏁版嵁","濮撳悕"})
+ @Excel(name = "涓汉濮撳悕",headerBackgroundColor = IndexedColors.YELLOW)
private String name;
- @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+// @ExcelProperty({"涓汉淇℃伅","鐢熸棩"})
+// @DateTimeFormat("yyyy-MM-dd")
+ @Excel(name = "涓汉鐢熸棩", dateFormat = "yyyy-MM-dd",headerBackgroundColor = IndexedColors.YELLOW)
private Date birthday;
+ // @ExcelProperty({"涓汉淇℃伅","鎴风睄鍦板潃"})
+ @Excel(name = "涓汉鎴风睄鍦板潃",headerBackgroundColor = IndexedColors.YELLOW)
private String address;
- private String workAddress;
+ // @ExcelProperty({"涓汉淇℃伅","宸ヤ綔鍦板潃"})
+ @Excel(name = "涓汉韬唤璇�",headerBackgroundColor = IndexedColors.YELLOW)
+ private String idNo;
+ // @ExcelProperty(value = {"涓汉淇℃伅","濠氬Щ鐘跺喌"},converter = BearStatusConverter.class)
+ @Excel(name = "涓汉濠氬Щ鐘跺喌", readConverterExp = "0=鏈,1=鍒濆,2=绂诲,3=鍐嶅",headerBackgroundColor = IndexedColors.YELLOW)
private Integer marryStatus;
+ // @ExcelProperty(value = {"涓汉淇℃伅","鎬у埆"})
+ @Excel(name = "涓汉鎬у埆", readConverterExp = "0=濂�,1=鐢�",headerBackgroundColor = IndexedColors.YELLOW)
private Integer sex;
+ // @ExcelProperty(value = {"涓汉淇℃伅","姘戞棌"})
+ @Excel(name = "涓汉姘戞棌",headerBackgroundColor = IndexedColors.YELLOW)
private String nation;
+ // @ExcelProperty(value = {"涓汉淇℃伅","鎵嬫満鍙风爜"})
+ @Excel(name = "涓汉鐢佃瘽鍙风爜",headerBackgroundColor = IndexedColors.YELLOW)
private String phone;
//閰嶅伓鐨勬暟鎹�
private String spouseId;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","濮撳悕"})
+ @Excel(name = "閰嶅伓濮撳悕",headerBackgroundColor = IndexedColors.GREEN)
private String spouseName;
- @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+// @ExcelProperty(value = {"閰嶅伓淇℃伅","鐢熸棩"})
+// @DateTimeFormat("yyyy-MM-dd")
+ @Excel(name = "閰嶅伓鐢熸棩", dateFormat = "yyyy-MM-dd",headerBackgroundColor = IndexedColors.GREEN)
private Date spouseBirthday;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","鎴风睄鍦板潃"})
+ @Excel(name = "閰嶅伓鎴风睄鍦板潃",headerBackgroundColor = IndexedColors.GREEN)
private String spouseAddress;
- private String spouseWorkAddress;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","宸ヤ綔鍦板潃"})
+ @Excel(name = "閰嶅伓韬唤璇�",headerBackgroundColor = IndexedColors.GREEN)
+ private String spouseIdNo;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","濠氬Щ鐘跺喌"},converter = BearStatusConverter.class)
+ @Excel(name = "閰嶅伓濠氬Щ鐘跺喌", readConverterExp = "0=鏈,1=鍒濆,2=绂诲,3=鍐嶅",headerBackgroundColor = IndexedColors.GREEN)
private Integer spouseMarryStatus;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","鎬у埆"})
+ @Excel(name = "閰嶅伓鎬у埆", readConverterExp = "0=濂�,1=鐢�",headerBackgroundColor = IndexedColors.GREEN)
private Integer spouseSex;
+ // @ExcelProperty(value = {"閰嶅伓淇℃伅","姘戞棌"})
+ @Excel(name = "閰嶅伓姘戞棌",headerBackgroundColor = IndexedColors.GREEN)
private String spouseNation;
+ @Excel(name = "閰嶅伓鎵嬫満鍙风爜",headerBackgroundColor = IndexedColors.GREEN)
private String spousePhone;
-
//鐢熻偛鎯呭喌(涓棿琛�)
@@ -49,25 +86,34 @@
/**
* 缁撳鏃堕棿
*/
- @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+ @Excel(name = "缁撳鏃堕棿", dateFormat = "yyyy-MM-dd")
private Date marryTime;
/**
* 鐢熻偛鎯呭喌,0锛氭湭鐢熻偛銆�1锛氬湪瀛曘��2锛氬凡鐢熻偛
*/
+ @Excel(name = "鐢熻偛鎯呭喌", readConverterExp = "0=鏈敓鑲�,1=鍦ㄥ瓡,2=宸茬敓鑲�")
private Integer bearStatus;
+ @Excel(name = "鏄惁棰嗗彇璁″垝鐢熻偛鏈嶅姟鎵嬪唽", readConverterExp = "0=鍚�,1=鏄�")
private Integer handbookStatus;
- @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+ @Excel(name = "棰嗗彇璁″垝鐢熻偛鏈嶅姟鎵嬪唽鏃堕棿", dateFormat = "yyyy-MM-dd")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
private Date handbookTime;
+ @Excel(name = "鏄惁棰嗗彇鐙敓瀛愬コ璇�", readConverterExp = "0=鍚�,1=鏄�")
private Integer oneBorn;
- @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
+ @Excel(name = "棰嗗彇鐙敓瀛愬コ璇佹椂闂�", dateFormat = "yyyy-MM-dd")
+ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
private Date oneBornTime;
+ @Excel(name = "闇�澹版槑鐨勬儏鍐�")
private String content;
+ @Excel(name = "澶囨敞")
private String remark;
/**
* 鍓嶄换淇℃伅鐨凩ist
*/
+ @Excel(name = "鍓嶄换淇℃伅",headerBackgroundColor= IndexedColors.RED)
private List<MarryUser> oldSpouseList;
}
--
Gitblit v1.9.1