package com.ruoyi.account.api.dto; import com.ruoyi.common.core.annotation.Excel; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; /** * VIN码管理 Excel 传输对象。 *
导入模板与导入解析只使用「导出导入」列(VIN码/车牌号/联系人手机号/所属公司/启停状态); * 导出额外使用 type=EXPORT 的派生列(所属车队、账户模式、可用余额、超额、账户状态), * 派生的车队/公司/余额字段仅供导出内部回填,不参与Excel读写。
*/ @Data public class VinManagementExcelDTO implements Serializable { private static final long serialVersionUID = 1L; @Excel(name = "VIN码", sort = 1, width = 24, prompt = "必填,最多64个字符") private String vin; @Excel(name = "车牌号", sort = 2, width = 16) private String plateNumber; @Excel(name = "联系人手机号", sort = 3, width = 16) private String phone; @Excel(name = "所属公司", sort = 4, width = 24) private String companyName; /** 所属车队(仅导出,按车队ID远程回填) */ @Excel(name = "所属车队", sort = 5, width = 16, type = Excel.Type.EXPORT) private String fleetName; /** 账户模式(仅导出,1=共享模式,2=分配模式) */ @Excel(name = "账户模式", sort = 6, width = 12, type = Excel.Type.EXPORT, readConverterExp = "1=共享模式,2=分配模式") private Integer accountMode; /** 可用余额(仅导出,共享模式=公司可用余额,分配模式=VIN码自身余额) */ @Excel(name = "可用余额", sort = 7, width = 14, type = Excel.Type.EXPORT, scale = 2) private BigDecimal availableBalance; /** 超额(仅导出,可用余额为负时取其绝对值) */ @Excel(name = "超额", sort = 8, width = 14, type = Excel.Type.EXPORT, scale = 2) private BigDecimal overrun; /** 账户状态(仅导出,1=正常,2=欠款) */ @Excel(name = "账户状态", sort = 9, width = 12, type = Excel.Type.EXPORT, readConverterExp = "1=正常,2=欠款") private Integer accountStatus; @Excel(name = "启停状态", sort = 10, width = 14, readConverterExp = "1=启用,2=禁用", combo = {"启用", "禁用"}) private String status; /** 所属公司ID(仅导出内部使用,不落Excel) */ private Integer companyId; /** 所属车队ID(仅导出内部使用,不落Excel) */ private Integer fleetId; /** VIN码自身余额(仅导出内部使用,不落Excel) */ private BigDecimal balance; }