| | |
| | | import com.core.common.Cools; |
| | | import com.core.common.SpringUtils; |
| | | import com.zy.asrs.service.TagService; |
| | | import com.zy.common.utils.Synchro; |
| | | import com.zy.system.entity.User; |
| | | import com.zy.system.service.UserService; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.io.Serializable; |
| | | import java.text.SimpleDateFormat; |
| | |
| | | @Data |
| | | @TableName("man_mat") |
| | | public class Mat implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | @TableField(exist = false) |
| | | private Double stock; |
| | |
| | | public void setStock(Double stock) { |
| | | this.stock = stock; |
| | | } |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * ID |
| | |
| | | private String uuid; |
| | | |
| | | /** |
| | | * 所属区域 |
| | | */ |
| | | @ApiModelProperty(value= "所属区域") |
| | | @TableField("node_id") |
| | | private Long nodeId; |
| | | |
| | | /** |
| | | * 所属归类 |
| | | */ |
| | | @ApiModelProperty(value= "所属归类") |
| | |
| | | /** |
| | | * 商品编号 |
| | | */ |
| | | @ExcelProperty(index = 2, value = "商品编号") |
| | | @ApiModelProperty(value= "商品编号") |
| | | @ExcelProperty(value = "商品编码") |
| | | private String matnr; |
| | | |
| | | |
| | | /** |
| | | * 商品名称 |
| | | */ |
| | | @ExcelProperty(index = 3, value = "商品名称") |
| | | @ApiModelProperty(value= "商品名称") |
| | | @ExcelProperty(value = "商品名称") |
| | | private String maktx; |
| | | |
| | | /** |
| | | * 名称 |
| | | * 别名 |
| | | */ |
| | | @ApiModelProperty(value= "名称") |
| | | @ApiModelProperty(value= "别名") |
| | | @ExcelProperty(value = "别名") |
| | | private String name; |
| | | |
| | | /** |
| | | * 规格 |
| | | */ |
| | | @ExcelProperty(index = 4, value = "规格") |
| | | @ApiModelProperty(value= "规格") |
| | | @ExcelProperty(value = "规格") |
| | | private String specs; |
| | | |
| | | /** |
| | | * 型号 |
| | | */ |
| | | @ExcelProperty(index = 5, value = "型号") |
| | | @ApiModelProperty(value= "型号") |
| | | @ExcelProperty(value = "型号") |
| | | private String model; |
| | | |
| | | /** |
| | | * 批号 |
| | | * 颜色 |
| | | */ |
| | | @ExcelProperty(index = 6, value = "批号") |
| | | @ApiModelProperty(value= "批号") |
| | | private String batch; |
| | | @ApiModelProperty(value= "颜色") |
| | | @ExcelProperty(value = "颜色") |
| | | private String color; |
| | | |
| | | /** |
| | | * 品牌 |
| | | */ |
| | | @ApiModelProperty(value= "品牌") |
| | | @ExcelProperty(value = "品牌") |
| | | private String brand; |
| | | |
| | | /** |
| | | * 单位 |
| | | */ |
| | | @ExcelProperty(index = 7, value = "单位") |
| | | @ApiModelProperty(value= "单位") |
| | | @ExcelProperty(value = "单位") |
| | | private String unit; |
| | | |
| | | /** |
| | | * SKC |
| | | * 单价 |
| | | */ |
| | | @ExcelProperty(index = 8, value = "SKC") |
| | | @ApiModelProperty(value= "SKC") |
| | | @ApiModelProperty(value= "单价") |
| | | @ExcelProperty(value = "单价") |
| | | private Double price; |
| | | |
| | | /** |
| | | * sku |
| | | */ |
| | | @ApiModelProperty(value= "sku") |
| | | @ExcelProperty(value = "sku") |
| | | private String sku; |
| | | |
| | | /** |
| | | * 单位量 |
| | | */ |
| | | @ApiModelProperty(value= "单位量") |
| | | @ExcelProperty(value = "单位量") |
| | | private Double units; |
| | | |
| | | /** |
| | | * 条码 |
| | | */ |
| | | @ApiModelProperty(value= "条码") |
| | | @ExcelProperty(value = "条码") |
| | | private String barcode; |
| | | |
| | | /** |
| | | * 单据类型 |
| | | * 产地 |
| | | */ |
| | | @ApiModelProperty(value= "单据类型") |
| | | @TableField("doc_id") |
| | | private Long docId; |
| | | @ApiModelProperty(value= "产地") |
| | | @ExcelProperty(value = "产地") |
| | | private String origin; |
| | | |
| | | /** |
| | | * 单据编号 |
| | | * 厂家 |
| | | */ |
| | | @ApiModelProperty(value= "单据编号") |
| | | @TableField("doc_num") |
| | | private String docNum; |
| | | @ApiModelProperty(value= "厂家") |
| | | @ExcelProperty(value = "厂家") |
| | | private String manu; |
| | | |
| | | /** |
| | | * 客户名称 |
| | | * 生产日期 |
| | | */ |
| | | @ApiModelProperty(value= "客户名称") |
| | | @TableField("cust_name") |
| | | private String custName; |
| | | @ApiModelProperty(value= "生产日期") |
| | | @ExcelProperty(value = "生产日期") |
| | | @TableField("manu_date") |
| | | private String manuDate; |
| | | |
| | | /** |
| | | * 品项数 |
| | | */ |
| | | @ApiModelProperty(value= "品项数") |
| | | @ExcelProperty(value = "品项数") |
| | | @TableField("item_num") |
| | | private Integer itemNum; |
| | | private String itemNum; |
| | | |
| | | /** |
| | | * 库存余量 |
| | | * 安全库存量 |
| | | */ |
| | | @ApiModelProperty(value= "库存余量") |
| | | private Integer count; |
| | | |
| | | /** |
| | | * 单价 |
| | | */ |
| | | @ExcelProperty(index = 9, value = "单价") |
| | | @ApiModelProperty(value= "单价") |
| | | private Double price; |
| | | @ApiModelProperty(value= "安全库存量") |
| | | @ExcelProperty(value = "安全库存量") |
| | | @TableField("safe_qty") |
| | | private Double safeQty; |
| | | |
| | | /** |
| | | * 重量 |
| | | */ |
| | | @ExcelProperty(index = 10, value = "重量") |
| | | @ApiModelProperty(value= "重量") |
| | | @ExcelProperty(value = "重量") |
| | | private Double weight; |
| | | |
| | | @ApiModelProperty(value= "") |
| | | /** |
| | | * 长度 |
| | | */ |
| | | @ApiModelProperty(value= "长度") |
| | | @ExcelProperty(value = "长度") |
| | | private Double length; |
| | | |
| | | /** |
| | | * 体积 |
| | | */ |
| | | @ApiModelProperty(value= "体积") |
| | | @ExcelProperty(value = "体积") |
| | | private Double volume; |
| | | |
| | | /** |
| | | * 三方编码 |
| | | */ |
| | | @ApiModelProperty(value= "三方编码") |
| | | @ExcelProperty(value = "三方编码") |
| | | @TableField("three_code") |
| | | private String threeCode; |
| | | |
| | | /** |
| | | * 供应商 |
| | | */ |
| | | @ApiModelProperty(value= "供应商") |
| | | @ExcelProperty(value = "供应商") |
| | | private String supp; |
| | | |
| | | /** |
| | | * 供应商编码 |
| | | */ |
| | | @ApiModelProperty(value= "供应商编码") |
| | | @ExcelProperty(value = "供应商编码") |
| | | @TableField("supp_code") |
| | | private String suppCode; |
| | | |
| | | /** |
| | | * 是否批次 1: 是 0: 否 |
| | | */ |
| | | @ApiModelProperty(value= "是否批次 1: 是 0: 否 ") |
| | | @TableField("be_batch") |
| | | private Integer beBatch; |
| | | |
| | | /** |
| | | * 保质期 |
| | | */ |
| | | @ApiModelProperty(value= "保质期") |
| | | @TableField("dead_time") |
| | | @ExcelProperty(value = "保质期") |
| | | private String deadTime; |
| | | |
| | | /** |
| | | * 预警天数 |
| | | */ |
| | | @ApiModelProperty(value= "预警天数") |
| | | @TableField("dead_warn") |
| | | @ExcelProperty(value = "预警天数") |
| | | private Integer deadWarn; |
| | | |
| | | /** |
| | | * 制购 1: 制造 2: 采购 3: 外协 |
| | | */ |
| | | @ApiModelProperty(value= "制购 1: 制造 2: 采购 3: 外协 ") |
| | | private Integer source; |
| | | |
| | | /** |
| | | * 要求检验 1: 是 0: 否 |
| | | */ |
| | | @ApiModelProperty(value= "要求检验 1: 是 0: 否 ") |
| | | private Integer inspect; |
| | | |
| | | /** |
| | | * 危险品 1: 是 0: 否 |
| | | */ |
| | | @ApiModelProperty(value= "危险品 1: 是 0: 否 ") |
| | | private Integer danger; |
| | | |
| | | /** |
| | | * 状态 1: 正常 0: 禁用 |
| | | */ |
| | | @ApiModelProperty(value= "状态 1: 正常 0: 禁用 ") |
| | | private Integer status; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ApiModelProperty(value= "添加时间") |
| | | @TableField("create_time") |
| | | @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") |
| | | private Date createTime; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ApiModelProperty(value= "修改时间") |
| | | @TableField("update_time") |
| | | @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") |
| | | private Date updateTime; |
| | | |
| | | /** |
| | | * 备注 |
| | | */ |
| | | @ExcelProperty(index = 11, value = "备注") |
| | | @ApiModelProperty(value= "备注") |
| | | @ExcelProperty(value = "备注") |
| | | private String memo; |
| | | |
| | | public Mat() {} |
| | | |
| | | public Mat(String uuid,Long nodeId,Long tagId,String matnr,String maktx,String name,String specs,String model,String batch,String unit,String barcode,Long docId,String docNum,String custName,Integer itemNum,Integer count,Double weight,Integer status,Long createBy,Date createTime,Long updateBy,Date updateTime,String memo) { |
| | | public Mat(String uuid,Long tagId,String matnr,String maktx,String name,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Integer status,Long createBy,Date createTime,Long updateBy,Date updateTime,String memo) { |
| | | this.uuid = uuid; |
| | | this.nodeId = nodeId; |
| | | this.tagId = tagId; |
| | | this.matnr = matnr; |
| | | this.maktx = maktx; |
| | | this.name = name; |
| | | this.specs = specs; |
| | | this.model = model; |
| | | this.batch = batch; |
| | | this.color = color; |
| | | this.brand = brand; |
| | | this.unit = unit; |
| | | this.price = price; |
| | | this.sku = sku; |
| | | this.units = units; |
| | | this.barcode = barcode; |
| | | this.docId = docId; |
| | | this.docNum = docNum; |
| | | this.custName = custName; |
| | | this.origin = origin; |
| | | this.manu = manu; |
| | | this.manuDate = manuDate; |
| | | this.itemNum = itemNum; |
| | | this.count = count; |
| | | this.safeQty = safeQty; |
| | | this.weight = weight; |
| | | this.length = length; |
| | | this.volume = volume; |
| | | this.threeCode = threeCode; |
| | | this.supp = supp; |
| | | this.suppCode = suppCode; |
| | | this.beBatch = beBatch; |
| | | this.deadTime = deadTime; |
| | | this.deadWarn = deadWarn; |
| | | this.source = source; |
| | | this.inspect = inspect; |
| | | this.danger = danger; |
| | | this.status = status; |
| | | this.createBy = createBy; |
| | | this.createTime = createTime; |
| | |
| | | |
| | | // Mat mat = new Mat( |
| | | // null, // 编号 |
| | | // null, // 所属区域 |
| | | // null, // 所属归类 |
| | | // null, // 商品编号 |
| | | // null, // 商品名称 |
| | | // null, // 名称 |
| | | // null, // 别名 |
| | | // null, // 规格 |
| | | // null, // 型号 |
| | | // null, // 批号 |
| | | // null, // 颜色 |
| | | // null, // 品牌 |
| | | // null, // 单位 |
| | | // null, // SKC |
| | | // null, // 单据类型 |
| | | // null, // 单据编号 |
| | | // null, // 客户名称 |
| | | // null, // 单价 |
| | | // null, // sku |
| | | // null, // 单位量 |
| | | // null, // 条码 |
| | | // null, // 产地 |
| | | // null, // 厂家 |
| | | // null, // 生产日期 |
| | | // null, // 品项数 |
| | | // null, // 库存余量 |
| | | // null, // 安全库存量 |
| | | // null, // 重量 |
| | | // null, // |
| | | // null, // 长度 |
| | | // null, // 体积 |
| | | // null, // 三方编码 |
| | | // null, // 供应商 |
| | | // null, // 供应商编码 |
| | | // null, // 是否批次 |
| | | // null, // 保质期 |
| | | // null, // 预警天数 |
| | | // null, // 制购 |
| | | // null, // 要求检验 |
| | | // null, // 危险品 |
| | | // null, // 状态[非空] |
| | | // null, // 添加人员 |
| | | // null, // 添加时间 |
| | | // null, // 修改人员 |
| | |
| | | return null; |
| | | } |
| | | |
| | | public String getBeBatch$(){ |
| | | if (null == this.beBatch){ return null; } |
| | | switch (this.beBatch){ |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | | return "否"; |
| | | default: |
| | | return String.valueOf(this.beBatch); |
| | | } |
| | | } |
| | | |
| | | public String getSource$(){ |
| | | if (null == this.source){ return null; } |
| | | switch (this.source){ |
| | | case 1: |
| | | return "制造"; |
| | | case 2: |
| | | return "采购"; |
| | | case 3: |
| | | return "外协"; |
| | | default: |
| | | return String.valueOf(this.source); |
| | | } |
| | | } |
| | | |
| | | public String getInspect$(){ |
| | | if (null == this.inspect){ return null; } |
| | | switch (this.inspect){ |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | | return "否"; |
| | | default: |
| | | return String.valueOf(this.inspect); |
| | | } |
| | | } |
| | | |
| | | public String getDanger$(){ |
| | | if (null == this.danger){ return null; } |
| | | switch (this.danger){ |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | | return "否"; |
| | | default: |
| | | return String.valueOf(this.danger); |
| | | } |
| | | } |
| | | |
| | | public String getStatus$(){ |
| | | if (null == this.status){ return null; } |
| | | switch (this.status){ |
| | | case 1: |
| | | return "正常"; |
| | | case 0: |
| | | return "禁用"; |
| | | default: |
| | | return String.valueOf(this.status); |
| | | } |
| | | } |
| | | |
| | | public String getCreateBy$(){ |
| | | UserService service = SpringUtils.getBean(UserService.class); |
| | | User user = service.selectById(this.createBy); |
| | | if (!Cools.isEmpty(user)){ |
| | | return String.valueOf(user.getNickname()); |
| | | return String.valueOf(user.getUsername()); |
| | | } |
| | | return null; |
| | | } |
| | |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime); |
| | | } |
| | | |
| | | public Long getUpdateBy() { |
| | | return updateBy; |
| | | } |
| | | |
| | | public String getUpdateBy$(){ |
| | | UserService service = SpringUtils.getBean(UserService.class); |
| | | User user = service.selectById(this.updateBy); |
| | | if (!Cools.isEmpty(user)){ |
| | | return String.valueOf(user.getNickname()); |
| | | return String.valueOf(user.getUsername()); |
| | | } |
| | | return null; |
| | | } |
| | |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime); |
| | | } |
| | | |
| | | public void sync(Object source) { |
| | | Synchro.Copy(source, this); |
| | | } |
| | | |
| | | } |