package cn.iocoder.yudao.module.crm.controller.admin.contract.vo.contract; import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat; import cn.iocoder.yudao.framework.excel.core.annotations.ExcelColumnSelect; import cn.iocoder.yudao.framework.excel.core.convert.DictConvert; import cn.idev.excel.annotation.ExcelProperty; import cn.idev.excel.annotation.write.style.HeadFontStyle; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; import java.math.BigDecimal; import java.time.LocalDateTime; import static cn.iocoder.yudao.module.crm.enums.DictTypeConstants.*; /** * 合同 Excel 导入 VO */ @Data @Builder @AllArgsConstructor @NoArgsConstructor public class CrmContractImportExcelVO { @HeadFontStyle(color = 10) @ExcelProperty("合同名称") private String name; @HeadFontStyle(color = 10) @ExcelProperty("客户名称") private String customerName; @ExcelProperty("下单日期") private LocalDateTime orderDate; @ExcelProperty("开始时间") private LocalDateTime startTime; @ExcelProperty("结束时间") private LocalDateTime endTime; @ExcelProperty("整单折扣") private BigDecimal discountPercent; @ExcelProperty("合同总金额") private BigDecimal totalPrice; @ExcelProperty("定金金额") private BigDecimal depositPrice; @ExcelProperty(value = "合同类型", converter = DictConvert.class) @DictFormat(CRM_CONTRACT_TYPE) @ExcelColumnSelect(dictType = CRM_CONTRACT_TYPE) private String contractType; @ExcelProperty(value = "电压等级", converter = DictConvert.class) @DictFormat(CRM_VOLTAGE_LEVEL) @ExcelColumnSelect(dictType = CRM_VOLTAGE_LEVEL) private String voltageLevel; @ExcelProperty(value = "用电类型", converter = DictConvert.class) @DictFormat(CRM_ELECTRICITY_TYPE) @ExcelColumnSelect(dictType = CRM_ELECTRICITY_TYPE) private String electricityType; @ExcelProperty("合同容量") private BigDecimal contractCapacity; @ExcelProperty(value = "电价模式", converter = DictConvert.class) @DictFormat(CRM_TARIFF_MODE) @ExcelColumnSelect(dictType = CRM_TARIFF_MODE) private String tariffMode; @ExcelProperty(value = "计量方式", converter = DictConvert.class) @DictFormat(CRM_METER_MODE) @ExcelColumnSelect(dictType = CRM_METER_MODE) private String meterMode; @ExcelProperty("缴费周期") private Integer payCycle; @ExcelProperty("物料编码") private String productCode; @ExcelProperty("合同单价") private BigDecimal productPrice; @ExcelProperty("数量") private Integer productCount; @ExcelProperty("备注") private String remark; }