package doumeemes.dao.business.model;

import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import doumeemes.core.annotation.excel.ExcelColumn;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 物料库存余额信息表
 * @author 江蹄蹄
 * @date 2022/04/20 09:37
 */
@Data
@ApiModel("物料库存余额信息表")
@TableName("`w_stock`")
public class WStock implements Serializable {
     @TableId(value = "ID",type = IdType.AUTO)
    @ApiModelProperty(value = "主键", example = "1")
    @ExcelColumn(name="主键")
    private Integer id;

    @ApiModelProperty(value = "是否已删除 0未删除 1已删除", example = "1")
    @ExcelColumn(name="是否已删除 0未删除 1已删除")
    private Integer deleted;

    @ApiModelProperty(value = "创建人编码", example = "1")
    @ExcelColumn(name="创建人编码")
    private Integer createUser;

    @ApiModelProperty(value = "创建时间")
    @ExcelColumn(name="创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date createTime;

    @ApiModelProperty(value = "更新人编码", example = "1")
    @ExcelColumn(name="更新人编码")
    private Integer updateUser;

    @ApiModelProperty(value = "更新时间")
    @ExcelColumn(name="更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date updateTime;

    @ApiModelProperty(value = "备注")
    @ExcelColumn(name="备注")
    private String remark;

    @ApiModelProperty(value = "主组织编码（关联department表根组织）", example = "1")
    @ExcelColumn(name="主组织编码（关联department表根组织）")
    private Integer rootDepartId;

    @ApiModelProperty(value = "物料编码（关联material_distribute表）", example = "1")
    @ExcelColumn(name="物料编码（关联material_distribute表）")
    private Integer materialId;

    @ApiModelProperty(value = "单位编码（关联unit_distribute表）", example = "1")
    @ExcelColumn(name="单位编码（关联unit_distribute表）")
    private Integer unitId;

    @ApiModelProperty(value = "库位编码（关联warehouse_location表）", example = "1")
    @ExcelColumn(name="库位编码（关联warehouse_location表）")
    private Integer locationId;

    @ApiModelProperty(value = "仓库编码（关联warehouse表）", example = "1")
    @ExcelColumn(name="仓库编码（关联warehouse表）")
    private Integer warehouseId;

    @ApiModelProperty(value = "批次号")
    @ExcelColumn(name="批次号")
    private String batch;

    @ApiModelProperty(value = "库存量", example = "1")
    @ExcelColumn(name="库存量")
    private BigDecimal num;

    @ApiModelProperty(value = "已投料数量", example = "1",hidden = true)
    @TableField(exist = false)
    private BigDecimal tNum;

    @ApiModelProperty(value = "工序编码")
    private Integer procedureId;

    @ApiModelProperty(value = "工序名称")
    @TableField(exist = false)
    private String procedureName;

    @ApiModelProperty(value = "产品质量属性 0合格 1不良 2报废")
    private Integer qualityType;

}