package com.ruoyi.device.execl; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.framework.aspectj.lang.annotation.Excel; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.math.BigDecimal; import java.time.LocalDate; import java.util.Date; @Data public class DeviceLedgerExeclDto { /** * 设备名称 */ @Excel(name = "设备名称" ,sort = 1) private String deviceName; /** * 设备类型 */ @Excel(name = "设备类型",sort = 0,combo = {"生产设备","办公设备","检查设备","运输设备","其他设备"}) private String type; @Schema(description = "计划运行时间") @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "计划运行时间",sort = 9,dateFormat = "yyyy-MM-dd") private Date planRuntimeTime; /** * 规格型号 */ @Excel(name = "规格型号" ,sort = 2) private String deviceModel; /** * 供应商名称 */ @Excel(name = "供应商名称",sort = 3) private String supplierName; /** * 单位 */ @Excel(name = "单位",sort = 4) private String unit; /** * 数量(不在导入模板/导出中展示,导入时按 1 台处理) */ private BigDecimal number = BigDecimal.ONE; /** * 含税单价 */ @Excel(name = "含税单价",sort = 5) private BigDecimal taxIncludingPriceUnit; /** * 含税总价(不在导入模板/导出中展示,导入时按 含税单价 × 数量 计算) */ private BigDecimal taxIncludingPriceTotal; /** * 税率 */ @Excel(name = "税率",sort = 6) private BigDecimal taxRate; /** * 不含税总价(不在导入模板/导出中展示,按税率折算) */ private BigDecimal unTaxIncludingPriceTotal; /** * 是否启用 1-启用 0-停用 */ @Excel(name = "启用状态", sort = 7, readConverterExp = "1=启用,0=停用") private Integer isEnabled; /** * 录入人 */ @Excel(name = "录入人",sort = 8) private String createUser; }