package com.ruoyi.device.execl; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.framework.aspectj.lang.annotation.Excel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.math.BigDecimal; import java.util.Date; @Data public class DeviceLedgerExeclDto { @Excel(name = "设备类型", sort = 0, combo = {"生产设备", "办公设备", "检测设备", "运输设备", "其他设备"}) private String type; @Excel(name = "设备名称", sort = 1) private String deviceName; @Excel(name = "规格型号", sort = 2) private String deviceModel; @Excel(name = "供应商名称", sort = 3) private String supplierName; @Excel(name = "单位", sort = 4) private String unit; @Excel(name = "数量", sort = 5, type = Excel.Type.EXPORT) private BigDecimal number = BigDecimal.ONE; @Excel(name = "含税单价", sort = 6) private BigDecimal taxIncludingPriceUnit; @Excel(name = "含税总价", sort = 7, type = Excel.Type.EXPORT) private BigDecimal taxIncludingPriceTotal; @Excel(name = "税率", sort = 8) private BigDecimal taxRate; @Excel(name = "不含税总价", sort = 9, type = Excel.Type.EXPORT) private BigDecimal unTaxIncludingPriceTotal; @ApiModelProperty("计划运行时间") @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "计划运行时间", sort = 10, dateFormat = "yyyy-MM-dd") private Date planRuntimeTime; @Excel(name = "设备区域", sort = 11) private String areaName; @Excel(name = "录入人", sort = 12) private String createUser; }