package com.vincent.rsf.server.manager.entity.excel;
|
|
import cn.afterturn.easypoi.excel.annotation.Excel;
|
import cn.afterturn.easypoi.handler.inter.IExcelDataModel;
|
import cn.afterturn.easypoi.handler.inter.IExcelModel;
|
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 java.io.Serializable;
|
|
/**
|
* @author Ryan
|
* @version 1.0
|
* @title MatnrsTemplate
|
* @description
|
* @create 2025/3/3 08:40
|
*/
|
@Data
|
@ExcelAutoColumnSize
|
@Accessors(chain = true)
|
@ToString(callSuper = true)
|
@EqualsAndHashCode(callSuper = false)
|
public class MatnrsTemplate implements IExcelModel, IExcelDataModel, Serializable {
|
|
@Excel(name = "物料名称")
|
@ExcelComment(example = "华为手机")
|
private String name;
|
|
@Excel(name = "分类助记码")
|
@ExcelComment(example = "256874556")
|
private String groupCode;
|
|
@Excel(name = "分类名称")
|
@ExcelComment(example = "移动设备")
|
private String groupName;
|
|
@Excel(name = "物料助记码")
|
@ExcelComment(example = "P3528461569")
|
private String erpCode;
|
|
@Excel(name = "规格")
|
@ExcelComment(example = "HW-148*68*10")
|
private String spec;
|
|
@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;
|
|
@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;
|
|
@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;
|
|
private Integer rowNum;
|
|
private String errorMsg;
|
|
|
@Override
|
public Integer getRowNum() {
|
return this.rowNum;
|
}
|
|
@Override
|
public void setRowNum(Integer rowNum) {
|
this.rowNum = rowNum;
|
}
|
|
@Override
|
public String getErrorMsg() {
|
return this.errorMsg;
|
}
|
|
@Override
|
public void setErrorMsg(String errorMsg) {
|
this.errorMsg = errorMsg;
|
}
|
}
|
