package doumeemes.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import doumeemes.core.annotation.excel.ExcelColumn; import doumeemes.dao.ext.vo.BomExtListVO; 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; import java.util.List; /** * 工单类-工单信息表 * @author 江蹄蹄 * @date 2022/04/20 09:37 */ @Data @ApiModel("工单类-工单信息表") @TableName("`workorder`") public class Workorder 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 = "公司级组织编码(关联department表)", example = "1") @ExcelColumn(name="公司级组织编码(关联department表)") private Integer departId; @ApiModelProperty(value = "所属计划编码", example = "1") @ExcelColumn(name="所属计划编码") private Integer planId; @ApiModelProperty(value = "生产工厂机级组织编码(关联department表)", example = "1") @ExcelColumn(name="生产工厂机级组织编码(关联department表)") private Integer factoryId; @ApiModelProperty(value = "生产工序编码(关联procedures表)", example = "1") @ExcelColumn(name="生产工序编码(关联procedures表)") private Integer procedureId; @ApiModelProperty(value = "工单编号") @ExcelColumn(name="工单编号") private String code; @ApiModelProperty(value = "原工单编码(返工工单专用)", example = "1") @ExcelColumn(name="原工单编码(返工工单专用)") private Integer originWorkorderId; @ApiModelProperty(value = "工单类型ID(关联system_dict_data)", example = "1") @ExcelColumn(name="工单类型ID(关联system_dict_data)") private Integer typeId; @ApiModelProperty(value = "数据来源ID(关联system_dict_data)", example = "1") @ExcelColumn(name="数据来源ID(关联system_dict_data)") private Integer originId; @ApiModelProperty(value = "计划日期") @ExcelColumn(name="计划日期") @JsonFormat(pattern = "yyyy-MM-dd") private Date planDate; @ApiModelProperty(value = "二维码ID", example = "1") @ExcelColumn(name="二维码ID") private Integer qrcodeId; @ApiModelProperty(value = "计划数量", example = "1") @ExcelColumn(name="计划数量") private Integer planNum; @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 = "批次号") @ExcelColumn(name="批次号") private String batch; @ApiModelProperty(value = "生产人员编码(关联system_user表),已废弃参数", example = "1") @ExcelColumn(name="生产人员编码(关联system_user表)") private Integer proUserId; @ApiModelProperty(value = "生产人员编码集合" ) @ExcelColumn(name="生产人员编码集合") @TableField(exist = false) private List proUserList; @ApiModelProperty(value = "生产班组编码(关联device表)", example = "1") @ExcelColumn(name="生产班组编码(关联device表)") private Integer proGroupId; @ApiModelProperty(value = "合格数量", example = "1") @ExcelColumn(name="合格数量") private Integer qualifiedNum; @ApiModelProperty(value = "不合格数量", example = "1") @ExcelColumn(name="不合格数量") private Integer unqualifiedNum; @ApiModelProperty(value = "检验人员编码", example = "1") @ExcelColumn(name="检验人员编码") private Integer checkUserId; @ApiModelProperty(value = "工单状态 0已创建、1已备料、2已完工、3已检验、4已报工、5已入库、6已取消", example = "1") @ExcelColumn(name="工单状态 0已创建、1已备料、2已完工、3已检验、4已报工、5已入库、6已取消") private Integer status; @ApiModelProperty(value = "是否暂停 0未暂停 1已暂停", example = "1") @ExcelColumn(name="是否暂停 0未暂停 1已暂停") private Integer paused; @ApiModelProperty(value = "最近状态更新时间") @ExcelColumn(name="最近状态更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date lastDealDate; @ApiModelProperty(value = "最近状态更新备注") @ExcelColumn(name="最近状态更新备注") private String lastDealInfo; @ApiModelProperty(value = "优先级(排序码)字段", example = "1") @ExcelColumn(name="优先级(排序码)字段") private Integer urgent; @ApiModelProperty(value = "工单类型(0正常、1异常、2返工返修)", example = "1") @ExcelColumn(name="工单类型(0正常、1异常、2返工返修)") private Integer type; @ApiModelProperty(value = "检点内容(json)", example = "1") @ExcelColumn(name="检点内容(json)") private String checkParam; @ApiModelProperty(value = "主键集合") @TableField(exist = false) private List ids; @ApiModelProperty(value = "人员班组关联编码,分配工单时传参") @TableField(exist = false) private Integer userDeivceId; @ApiModelProperty(value = "待生产货位(关联warehouse_location))", example = "1",hidden = true) @TableField(exist = false) private Integer produceWarehouseLocationId; @ApiModelProperty(value = "待产出货位(关联warehouse_location))", example = "1",hidden = true) @TableField(exist = false) private Integer finishWarehouseLocationId; @ApiModelProperty(value = "待生产仓库(关联warehouse ))", example = "1",hidden = true) @TableField(exist = false) private Integer produceWarehouseId; @ApiModelProperty(value = "待产出仓库(关联warehouse))", example = "1",hidden = true) @TableField(exist = false) private Integer finishWarehouseId; @ApiModelProperty(value = "是否查询统计信息,0否 1是 ", example = "1",hidden = true) @TableField(exist = false) private Integer queryFlag; @ApiModelProperty(value = "投料总计", example = "1",hidden = true) @TableField(exist = false) private BigDecimal hasMaterialNum; @ApiModelProperty(value = "产出总计", example = "1",hidden = true) @TableField(exist = false) private Integer hasProduceNum; @ApiModelProperty(value = "报废或者不良总计", example = "1",hidden = true) @TableField(exist = false) private Integer hasUnqulifiedNum; @ApiModelProperty(value = "工序报工是否计算不良品 0是 1否",hidden = true) @TableField(exist = false) private Integer iscalculate; @ApiModelProperty(value = "关联BOM对象",hidden = true) @TableField(exist = false) private BomExtListVO bomModel; @ApiModelProperty(value = "返修申请单号(关联backorder表)", example = "1") private Integer backorderId; @ApiModelProperty(value = "计划总量", example = "1",hidden = true) @TableField(exist = false) private Integer totalPlanNum; @ApiModelProperty(value = "工序是否需要检验才能报工 0是 1否", example = "1" ) @TableField(exist = false) private Integer needcheck; @ApiModelProperty(value = "工单设备人员集合" ) @TableField(exist = false) private List workorderUserList; }