package doumeemes.dao.business.model;
import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import doumeemes.core.annotation.excel.ExcelColumn;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

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

/**
 * 工装器具信息表
 * @author 江蹄蹄
 * @date 2022/04/20 09:33
 */
@Data
@ApiModel("工装器具信息表")
@TableName("`appliances`")
public class Appliances implements Serializable{
    @ApiModelProperty(value = "主键", example = "1")
    @TableId(value = "id",type = IdType.AUTO)
    private Integer id;

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

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

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

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

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

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

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

    @ApiModelProperty(value = "公司级组织编码（关联department表）", example = "1",hidden = true)
    private Integer departId;

    @ApiModelProperty(value = "序列号")
    private String serialNum;

    @ApiModelProperty(value = "开始序列号")
    @TableField(exist = false)
    private Integer serialStartNum;
    @ApiModelProperty(value = "结束序列号")
    @TableField(exist = false)
    private Integer serialEndNum;

    @ApiModelProperty(value = "二维码ID", example = "1")
    private Integer brcode;

    @ApiModelProperty(value = "生产时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date validTime;

    @ApiModelProperty(value = "类型数据字典配置（关联system_dict_data表）", example = "1")
    private Integer type;

    @ApiModelProperty(value = "状态0.报废、1.空、2.部分、3.满", example = "1")
    private Integer status;

    @ApiModelProperty(value = "当前装载工单编码（关联workorder表）", example = "1")
    private Integer workorderId;

    @ApiModelProperty(value = "当前装载物料编码（关联material_distribute表）")
    private Integer materialId;

    @ApiModelProperty(value = "数量", example = "1")
    private BigDecimal num;

    @ApiModelProperty(value = "托盘码,前缀")
    @ExcelColumn(name="编码")
    @Excel(name="编码",orderNum ="1")
    private String code;

    @ApiModelProperty(value = "工装属性")
    @TableField(exist = false)
    @ExcelColumn(name="工装属性")
    @Excel(name="工装属性",orderNum ="2")
    private String typeName;

    @ApiModelProperty(value = "物料单位信息")
    @TableField(exist = false)
    private Integer unitId;

    @ApiModelProperty(value = "位置类型 0仓库1.车间", example = "1")
    private Integer positionType;

    @ApiModelProperty(value = "当前所在仓库代码（关联warehouse表）", example = "1")
    @TableField(updateStrategy  = FieldStrategy.IGNORED)
    private Integer warehouseId;

    @ApiModelProperty(value = "当前所在货位代码（关联warehouse_location表）", example = "1")
    @TableField(updateStrategy  = FieldStrategy.IGNORED)
    private Integer locationId;

    @ApiModelProperty(value = "当前所在工序编码（关联procedure表）", example = "1")
    private Integer procedureId;

    @ApiModelProperty(value = "当前被使用对象类型 0出入库单 1生产过程记录表", example = "1")
    private Integer curObjType;

    @ApiModelProperty(value = "当前被使用对象编码（根据CUR_OBJ_TYPE确定关联关系）", example = "1")
    private Integer curObjId;
    @ApiModelProperty(value = "器具分类编码（（关联category_union表））", example = "1")
    private Integer  categoryId;

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

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

    @ApiModelProperty(value = "返修申请单号（关联backorder表）", example = "1")
    private Integer backorderId ;
    @ApiModelProperty(value = "返修客返单号（关联saleorder表）", example = "1")
    private Integer saleorderId ;

    @ApiModelProperty(value = "返修不良产生工序编码（关联procedure表）", example = "1")
    private Integer backProcedureId ;
    @ApiModelProperty(value = "下一加工工序编码（关联procedure表）", example = "1")
    private Integer nextProcedureId ;

    @ApiModelProperty(value = "关联票据类型 0工单 1篮筐更换单记录", example = "1")
    private Integer relobjType ;
        //QUALITY_TYPE ,BATCH,BACKORDER_ID,SALEORDER_ID,BACK_PROCEDURE_ID,NEXT_PROCEDURE_ID,RELOBJ_TYPE

}