package doumeemes.dao.business.model;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
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.util.Date;

/**
 * 工单类-生产计划信息表
 * @author 江蹄蹄
 * @date 2022/04/20 09:34
 */
@Data
@ApiModel("工单类-生产计划信息表")
@TableName("`plans`")
public class Plans 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 = "数量统计信息，json格式")
    @ExcelColumn(name="数量统计信息，json格式")
    private String statisticInfo;

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

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

    @ApiModelProperty(value = "来源 0人工创建、1Excel导入、2计划程序生成", example = "1")
    @ExcelColumn(name="来源 0人工创建、1Excel导入、2计划程序生成")
    private Integer origin;

    @ApiModelProperty(value = "计划日期")
    @ExcelColumn(name="计划日期")
    @Excel(name="计划日期",orderNum ="1",format = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date planDate;

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

    @ApiModelProperty(value = "产品名称" )
    @TableField(exist = false)
    @Excel(name="产品名称",orderNum ="2")
    private String materialName;

    @ApiModelProperty(value = "产品编码" )
    @TableField(exist = false)
    @Excel(name="产品编码",orderNum ="3")
    private String materialCode;

    @ApiModelProperty(value = "生产工序编码（关联procedures表）", example = "1")
    @ExcelColumn(name="生产工序编码（关联procedures表）")
    private Integer procedureId;
    @ApiModelProperty(value = "是否暂停 0未暂停 1已暂停", example = "1")
    @ExcelColumn(name="是否暂停 0未暂停 1已暂停")
    private Integer paused;

    @ApiModelProperty(value = "生产工序" )
    @Excel(name="生产工序",orderNum ="6")
    @TableField(exist = false)
    private String procedureCode;

    @ApiModelProperty(value = "生产工厂机级组织编码（关联department表）", example = "1")
    @ExcelColumn(name="生产工厂机级组织编码（关联department表）")
    private Integer factoryId;

    @ApiModelProperty(value = "生产工厂机级组织名称" )
    @Excel(name="生产工厂",orderNum ="5")
    @TableField(exist = false)
    @ExcelColumn(name="生产工厂机级组织名称")
    private String factoryName;

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

    @ApiModelProperty(value = "计划数量", example = "1")
    @Excel(name="计划生产数量",orderNum ="4")
    @ExcelColumn(name="计划数量")
    private Integer num;

    @ApiModelProperty(value = "批次号")
    @Excel(name="产品批次号",orderNum = "7")
    @ExcelColumn(name="批次号")
    private String batch;

    @ApiModelProperty(value = "优先级（排序码）字段", example = "1")
    @ExcelColumn(name="优先级（排序码）字段")
    @Excel(name="优先级" ,orderNum = "8")
    private Integer urgent;

    @ApiModelProperty(value = "导入批号（关联plan_import表)", example = "1")
    @ExcelColumn(name="导入批号（关联plan_import表)")
    private Integer importId;

    @ApiModelProperty(value = "计划员编码（与system_user表关联）", example = "1")
    @ExcelColumn(name="计划员编码（与system_user表关联）")
    private Integer userId;

    @ApiModelProperty(value = "状态 0已生成、1已发布、2已撤回、3已取消、4已分配、5已暂停、6已完工、7已入库、8已关闭", example = "1")
    @ExcelColumn(name="状态 0已生成、1已发布、2已撤回、3已取消、4已分配、5已暂停、6已完工、7已入库、8已关闭")
    private Integer status;
    @ApiModelProperty(value = "计划类型 0正常1异常2返工", example = "1")
    @ExcelColumn(name="计划类型 0正常1异常2返工")
    private Integer type;

    @ApiModelProperty(value = "已报工数量", example = "1",hidden = true)
    @TableField(exist = false)
    private Integer baogongNum;

    @ApiModelProperty(value = "计划发布时间")
    @ExcelColumn(name="计划发布时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date publishDate;

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

    @ApiModelProperty(value = "成品计划主键（关联work_plans表）", example = "1")
    private Integer workPlansId;

}