package com.vincent.rsf.server.manager.entity.excel; import cn.afterturn.easypoi.excel.annotation.Excel; import com.vincent.rsf.server.manager.entity.excel.annotation.ExcelAutoColumnSize; import com.vincent.rsf.server.manager.entity.excel.annotation.ExcelComment; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.ToString; import lombok.experimental.Accessors; import javax.validation.constraints.NotNull; import java.io.Serializable; /** * @author Ryan * @version 1.0 * @title MatnrsTemplate * @description * @create 2025/3/3 08:40 */ @Data public class MatnrsTemplate { @NotNull @Excel(name = "物料名称*") @ExcelComment(example = "华为手机") private String name; @NotNull @Excel(name = "分类助记码*") @ExcelComment(example = "256874556") private String groupCode; @NotNull @Excel(name = "分类名称*") @ExcelComment(example = "移动设备") private String groupName; @NotNull @Excel(name = "物料助记码*") @ExcelComment(example = "P3528461569") private String erpCode; @NotNull @Excel(name = "规格") @ExcelComment(example = "HW-148*68*10") private String spec; @NotNull @Excel(name = "型号") @ExcelComment(example = "华为三折叠") private String model; @Excel(name = "重量") @ExcelComment(notNull = false, example = "258g") private String weight; @Excel(name = "颜色") @ExcelComment(notNull = false, example = "紫红色") private String color; @Excel(name = "大小") @ExcelComment(notNull = false, example = "148*68*10") private String size; @Excel(name = "描述") @ExcelComment(notNull = false, example = "新上市三折叠") private String describle; @Excel(name = "描述") @ExcelComment(notNull = false, example = "新上市三折叠") private String nromNum; @NotNull @Excel(name = "主单位") @ExcelComment(example = "部") private String unit; @Excel(name = "采购单位") @ExcelComment(example = "部") private String purUnit; @Excel(name = "ABC类") @ExcelComment(notNull = false, example = "0") private String stockLevel; @Excel(name = "安全库存量") @ExcelComment(example = "50") private String safeQty; @Excel(name = "最小库存量") @ExcelComment(notNull = false, example = "10") private String minQty; @NotNull @Excel(name = "最大库存量") @ExcelComment(notNull = false, example = "150") private String maxQty; @Excel(name = "停滞天数") @ExcelComment(notNull = false, example = "25") private String stagn; @Excel(name = "有效期") @ExcelComment(notNull = false, example = "25") private String valid; @Excel(name = "条形码") @ExcelComment(notNull = false, example = "8001354") private String barcode; @Excel(name = "效期预警阈值") @ExcelComment(notNull = false, example = "90") private String validWarn; @Excel(name = "是否免检") @ExcelComment(notNull = false, example = "0") private String flagCheck; }