| | |
| | | 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; |
| | |
| | | |
| | | //我个人的数据 |
| | | 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; |
| | | // @ExcelProperty({"个人信息","工作地址"}) |
| | | @Excel(name = "个人工作地址",headerBackgroundColor = IndexedColors.YELLOW) |
| | | private String workAddress; |
| | | // @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; |
| | | // @ExcelProperty(value = {"配偶信息","工作地址"}) |
| | | @Excel(name = "配偶工作地址",headerBackgroundColor = IndexedColors.GREEN) |
| | | private String spouseWorkAddress; |
| | | // @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; |
| | | |
| | | |
| | | |
| | | //生育情况(中间表) |
| | |
| | | /** |
| | | * 结婚时间 |
| | | */ |
| | | @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; |
| | | |
| | | /** |
| | | * 前任信息的List |
| | | */ |
| | | @Excel(name = "前任信息",headerBackgroundColor= IndexedColors.RED) |
| | | private List<MarryUser> oldSpouseList; |
| | | |
| | | } |