package com.zy.asrs.entity;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.baomidou.mybatisplus.annotations.TableField;
|
import com.baomidou.mybatisplus.annotations.TableId;
|
import com.baomidou.mybatisplus.annotations.TableName;
|
import com.baomidou.mybatisplus.enums.IdType;
|
import com.core.common.Cools;
|
import com.core.common.SpringUtils;
|
import com.zy.asrs.service.TagService;
|
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;
|
import java.util.Date;
|
|
@Data
|
@TableName("man_mat")
|
public class Mat implements Serializable {
|
|
@TableField(exist = false)
|
private Double stock;
|
|
public Double getStock() {
|
return stock;
|
}
|
|
public void setStock(Double stock) {
|
this.stock = stock;
|
}
|
|
private static final long serialVersionUID = 1L;
|
|
/**
|
* ID
|
*/
|
@ApiModelProperty(value= "ID")
|
@TableId(value = "id", type = IdType.AUTO)
|
private Long id;
|
|
/**
|
* 编号
|
*/
|
@ApiModelProperty(value= "编号")
|
private String uuid;
|
|
/**
|
* 所属归类
|
*/
|
@ApiModelProperty(value= "所属归类")
|
@TableField("tag_id")
|
private Long tagId;
|
|
/**
|
* 物料号
|
*/
|
@ApiModelProperty(value= "存货编码")
|
@ExcelProperty(value = "存货编码")
|
private String matnr;
|
|
|
/**
|
* 物料号
|
*/
|
@ApiModelProperty(value= "物料名称")
|
@ExcelProperty(value = "存货名称")
|
private String maktx;
|
|
/**
|
* 移动类型
|
*/
|
@ApiModelProperty(value= "生产部门名称")
|
@ExcelProperty(value = "生产部门名称")
|
private String name;
|
|
/**
|
* 规格
|
*/
|
@ApiModelProperty(value= "规格")
|
@ExcelProperty(value = "规格型号")
|
private String specs;
|
|
/**
|
* 批次
|
*/
|
@ApiModelProperty(value= "批次")
|
@ExcelProperty(value = "通用型号")
|
private String model;
|
|
/**
|
* 颜色
|
*/
|
@ApiModelProperty(value= "颜色")
|
@ExcelProperty(value = "是否内销")
|
private String color;
|
|
/**
|
* 品牌
|
*/
|
@ApiModelProperty(value= "品牌")
|
@ExcelProperty(value = "存货大类名称")
|
private String brand;
|
|
/**
|
* 单位
|
*/
|
@ApiModelProperty(value= "单位")
|
@ExcelProperty(value = "主计量单位名称")
|
private String unit;
|
|
/**
|
* 单价
|
*/
|
@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= "物料状态")
|
@ExcelProperty(value = "是否批次管理")
|
private String origin;
|
|
/**
|
* 厂家
|
*/
|
@ApiModelProperty(value= "厂家")
|
//@ExcelProperty(value = "厂家")
|
private String manu;
|
|
/**
|
* 单据时间
|
*/
|
@ApiModelProperty(value= "单据时间")
|
//@ExcelProperty(value = "单据时间")
|
@TableField("manu_date")
|
private String manuDate;
|
|
/**
|
* 品项数
|
*/
|
@ApiModelProperty(value= "品项数")
|
//@ExcelProperty(value = "品项数")
|
@TableField("item_num")
|
private String itemNum;
|
|
/**
|
* 安全库存量
|
*/
|
@ApiModelProperty(value= "安全库存量")
|
@ExcelProperty(value = "安全库存量")
|
@TableField("safe_qty")
|
private Double safeQty;
|
|
/**
|
* 重量
|
*/
|
@ApiModelProperty(value= "重量")
|
//@ExcelProperty(value = "重量")
|
private Double weight;
|
|
/**
|
* 长度
|
*/
|
@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")
|
//@ExcelProperty(value = "'是否批次管理")
|
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_by")
|
private Long createBy;
|
|
/**
|
* 添加时间
|
*/
|
@ApiModelProperty(value= "添加时间")
|
@TableField("create_time")
|
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
|
private Date createTime;
|
|
/**
|
* 修改人员
|
*/
|
@ApiModelProperty(value= "修改人员")
|
@TableField("update_by")
|
private Long updateBy;
|
|
/**
|
* 修改时间
|
*/
|
@ApiModelProperty(value= "修改时间")
|
@TableField("update_time")
|
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
|
private Date updateTime;
|
|
/**
|
* 备注
|
*/
|
@ApiModelProperty(value= "备注")
|
@ExcelProperty(value = "备注")
|
private String memo;
|
|
/**
|
* 库存预警数量上限
|
*/
|
@TableField("store_max")
|
private Double storeMax;
|
|
/**
|
* 库存预警数量下限
|
*/
|
@TableField("store_min")
|
private Double storeMin;
|
|
/**
|
* 库龄预警上限
|
*/
|
@TableField("store_max_date")
|
private Integer storeMaxDate;
|
|
//启动日期
|
@TableField("ds_date")
|
@ExcelProperty(value = "启用日期")
|
private Date dsDate;
|
|
//建档日期
|
@TableField("d_inv_create_datetime")
|
@ExcelProperty(value = "建档日期")
|
private Date dInvCreateDatetime;
|
|
public Mat() {}
|
|
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, Double storeMax, Double storeMin, Integer storeMaxDate) {
|
this.uuid = uuid;
|
this.tagId = tagId;
|
this.matnr = matnr;
|
this.maktx = maktx;
|
this.name = name;
|
this.specs = specs;
|
this.model = model;
|
this.color = color;
|
this.brand = brand;
|
this.unit = unit;
|
this.price = price;
|
this.sku = sku;
|
this.units = units;
|
this.barcode = barcode;
|
this.origin = origin;
|
this.manu = manu;
|
this.manuDate = manuDate;
|
this.itemNum = itemNum;
|
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;
|
this.updateBy = updateBy;
|
this.updateTime = updateTime;
|
this.memo = memo;
|
this.storeMax = storeMax;
|
this.storeMin = storeMin;
|
this.storeMaxDate = storeMaxDate;
|
}
|
|
// Mat mat = new Mat(
|
// null, // 编号
|
// null, // 所属归类
|
// null, // 物料号
|
// null, // 物料号
|
// null, // 移动类型
|
// null, // 规格
|
// null, // 批次
|
// 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 // 备注
|
// );
|
|
public String getTagId$(){
|
TagService service = SpringUtils.getBean(TagService.class);
|
Tag tag = service.selectById(this.tagId);
|
if (!Cools.isEmpty(tag)){
|
return String.valueOf(tag.getName());
|
}
|
return null;
|
}
|
|
public String getBeBatch$(){
|
if (null == this.beBatch){ return null; }
|
switch (this.beBatch){
|
case 1:
|
return "高";
|
case 0:
|
return "低";
|
default:
|
return "低";
|
}
|
}
|
|
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.getUsername());
|
}
|
return null;
|
}
|
|
public String getCreateTime$(){
|
if (Cools.isEmpty(this.createTime)){
|
return "";
|
}
|
return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime);
|
}
|
|
public String getUpdateBy$(){
|
UserService service = SpringUtils.getBean(UserService.class);
|
User user = service.selectById(this.updateBy);
|
if (!Cools.isEmpty(user)){
|
return String.valueOf(user.getUsername());
|
}
|
return null;
|
}
|
|
public String getUpdateTime$(){
|
if (Cools.isEmpty(this.updateTime)){
|
return "";
|
}
|
return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime);
|
}
|
|
|
}
|
