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;
|
|
}
|
