package com.zzg.system.domain.vo;
|
|
import com.alibaba.excel.annotation.ExcelIgnore;
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.format.NumberFormat;
|
import com.alibaba.excel.converters.doubleconverter.DoubleNumberConverter;
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import com.zzg.common.enums.CompensateTypeEnum;
|
import com.zzg.common.enums.CompensationCategoryEnum;
|
import com.zzg.system.convert.easyExcel.DateConverter;
|
import com.zzg.system.convert.easyExcel.MultiDropdownWriteHandler;
|
import com.zzg.system.convert.easyExcel.StringConverter;
|
import lombok.Data;
|
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.Map;
|
|
|
/**
|
* 导入结算模板属性 vo
|
*
|
* @date 2024/10/07
|
*/
|
@Data
|
public class ImportSettlementTemplatePropertyVO {
|
|
@ExcelProperty(value = "*不动产权证号", index = 0, converter = StringConverter.class)
|
private String realEstateCertificateNumber;
|
|
//置换赔偿参数
|
//置换后街道
|
@ExcelProperty(value = "*置换后镇街", index = 1, converter = StringConverter.class)
|
private String exchangeStreet;
|
|
//置换后位置
|
@ExcelProperty(value = "*置换后坐落", index = 2, converter = StringConverter.class)
|
private String exchangeLocation;
|
|
//置换后面积
|
@ExcelProperty(value = "*置换后房屋面积", index = 3, converter = DoubleNumberConverter.class)
|
@NumberFormat
|
private Double exchangeArea;
|
|
//置换后金额
|
@ExcelProperty(value = "*置换后房屋价值", index = 4, converter = DoubleNumberConverter.class)
|
@NumberFormat
|
private Double exchangeMoney;
|
|
|
//付款时间
|
@org.springframework.format.annotation.DateTimeFormat(pattern = "yyyy-MM-dd")
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
@ExcelProperty(value = "*付款时间", index = 5, converter = DateConverter.class)
|
private Date paidTime;
|
|
//备注
|
@ExcelProperty(value = "备注", index = 6, converter = StringConverter.class)
|
private String append;
|
@ExcelIgnore
|
private String stateHouseholdId;
|
|
public static ImportSettlementTemplatePropertyVO generateExampleData() {
|
ImportSettlementTemplatePropertyVO exampleData = new ImportSettlementTemplatePropertyVO();
|
exampleData.setRealEstateCertificateNumber("不动产权45678");
|
exampleData.setExchangeStreet("示例镇街");
|
exampleData.setExchangeLocation("示例坐落位置");
|
exampleData.setExchangeArea(150.0); // 示例面积
|
exampleData.setExchangeMoney(3000000.0); // 示例金额
|
exampleData.setPaidTime(new Date()); // 当前日期作为付款时间
|
exampleData.setAppend("这是一个示例备注");
|
|
return exampleData;
|
}
|
|
public static MultiDropdownWriteHandler generateHeaderData() {
|
Map<Integer, String[]> dropdownOptionsMap = new HashMap<>();
|
dropdownOptionsMap.put(2, Arrays.stream(CompensationCategoryEnum.values())
|
.map(CompensationCategoryEnum::getDescription)
|
.toArray(String[]::new));
|
dropdownOptionsMap.put(1, Arrays.stream(CompensateTypeEnum.values())
|
.map(CompensateTypeEnum::getDescription)
|
.toArray(String[]::new));
|
// return new MultiDropdownWriteHandler(dropdownOptionsMap);
|
return null;
|
}
|
}
|
