package doumeemes.dao.ext.dto;

import doumeemes.core.annotation.excel.ExcelColumn;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.util.Date;
import java.util.List;

/**
 * @autOhor 江蹄蹄
 * @date 2022/04/20 10:56
 */
@Data
@ApiModel("工单信息查询参数")
public class QueryWorkorderExtDTO {

    @ApiModelProperty(value = "主键", example = "1")
    private Integer id;

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

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

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

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

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

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

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

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

    @ApiModelProperty(value = "所属计划编码", example = "1")
    private Integer planId;

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

    @ApiModelProperty(value = "生产工序编码（关联procedures表）", example = "1")
    private Integer procedureId;

    @ApiModelProperty(value = "工单编号")
    private String code;

    @ApiModelProperty(value = "是否暂停 0未暂停 1已暂停", example = "1")
    private Integer paused;
    @ApiModelProperty(value = "原工单编码（返工工单专用）", example = "1")
    private Integer originWorkorderId;

    @ApiModelProperty(value = "工单类型ID（关联system_dict_data）", example = "1")
    private Integer typeId;

    @ApiModelProperty(value = "数据来源ID（关联system_dict_data）", example = "1")
    private Integer originId;

    @ApiModelProperty(value = "计划日期")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date planDate;

    @ApiModelProperty(value = "计划数量", example = "1")
    private Integer planNum;

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

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

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

    @ApiModelProperty(value = "生产人员编码（关联system_user表）", example = "1")
    private Integer proUserId;

    @ApiModelProperty(value = "生产班组编码（关联device表）", example = "1")
    private Integer proGroupId;

    @ApiModelProperty(value = "合格数量", example = "1")
    private Integer qualifiedNum;

    @ApiModelProperty(value = "不合格数量", example = "1")
    private Integer unqualifiedNum;

    @ApiModelProperty(value = "检验人员编码", example = "1")
    private Integer checkUserId;

    @ApiModelProperty(value = "工单状态 0已创建、1已备料、2已完工、3已检验、4已报工、5已入库、6已取消", example = "1")
    private Integer status;
    @ApiModelProperty(value = "工单状态集合（待生产：[0,1]，生产中[2,3]，已完成[4,5,6]" )
    private List<Integer> statusList;

    @ApiModelProperty(value = "最近状态更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date lastDealDate;

    @ApiModelProperty(value = "最近状态更新备注")
    private String lastDealInfo;

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

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

    @ApiModelProperty(value = "系统-组织信息表主键", example = "1")
    private Integer dmodelId;

    @ApiModelProperty(value = "系统-组织信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer dmodelDeleted;

    @ApiModelProperty(value = "系统-组织信息表创建人编码", example = "1")
    private Integer dmodelCreateUser;

    @ApiModelProperty(value = "系统-组织信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date dmodelCreateTime;

    @ApiModelProperty(value = "系统-组织信息表更新人编码", example = "1")
    private Integer dmodelUpdateUser;

    @ApiModelProperty(value = "系统-组织信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date dmodelUpdateTime;

    @ApiModelProperty(value = "系统-组织信息表名称，不可重复")
    private String dmodelName;

    @ApiModelProperty(value = "系统-组织信息表备注")
    private String dmodelRemark;

    @ApiModelProperty(value = "系统-组织信息表主组织ID（自关联，type=4该字段为空）", example = "1")
    private Integer dmodelRootId;

    @ApiModelProperty(value = "系统-组织信息表上级组织ID（自关联）", example = "1")
    private Integer dmodelParentId;

    @ApiModelProperty(value = "系统-组织信息表公司ID（关联company表，type=4该字段为空）", example = "1")
    private Integer dmodelCompanyId;

    @ApiModelProperty(value = "系统-组织信息表组织类型 0公司 1工厂 2部门 3班组 4平台组织", example = "1")
    private Integer dmodelType;

    @ApiModelProperty(value = "系统-组织信息表关联ERP编码（type=4该字段为空）")
    private String dmodelErpId;

    @ApiModelProperty(value = "系统-组织信息表状态 0启用 1失效", example = "1")
    private Integer dmodelStatus;

    @ApiModelProperty(value = "系统-组织信息表最后启用时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date dmodelValidTime;

    @ApiModelProperty(value = "系统-组织信息表最后失效时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date dmodelInvalidTime;

    @ApiModelProperty(value = "工单类-生产计划信息表主键", example = "1")
    private Integer pmodelId;

    @ApiModelProperty(value = "工单类-生产计划信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer pmodelDeleted;

    @ApiModelProperty(value = "工单类-生产计划信息表创建人编码", example = "1")
    private Integer pmodelCreateUser;

    @ApiModelProperty(value = "工单类-生产计划信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pmodelCreateTime;

    @ApiModelProperty(value = "工单类-生产计划信息表更新人编码", example = "1")
    private Integer pmodelUpdateUser;

    @ApiModelProperty(value = "工单类-生产计划信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pmodelUpdateTime;

    @ApiModelProperty(value = "工单类-生产计划信息表备注")
    private String pmodelRemark;

    @ApiModelProperty(value = "工单类-生产计划信息表主组织编码（关联department表根组织）", example = "1")
    private Integer pmodelRootDepartId;

    @ApiModelProperty(value = "工单类-生产计划信息表公司级组织编码（关联department表）", example = "1")
    private Integer pmodelDepartId;

    @ApiModelProperty(value = "工单类-生产计划信息表来源 0人工创建、1Excel导入、2计划程序生成", example = "1")
    private Integer pmodelOrigin;

    @ApiModelProperty(value = "工单类-生产计划信息表计划日期")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pmodelPlanDate;

    @ApiModelProperty(value = "工单类-生产计划信息表物料编码（关联material_distribute表）", example = "1")
    private Integer pmodelMaterialId;

    @ApiModelProperty(value = "工单类-生产计划信息表生产工序编码（关联procedures表）", example = "1")
    private Integer pmodelProcedureId;

    @ApiModelProperty(value = "工单类-生产计划信息表生产工厂机级组织编码（关联department表）", example = "1")
    private Integer pmodelFactoryId;

    @ApiModelProperty(value = "工单类-生产计划信息表单位编码（关联unit_distribute表）", example = "1")
    private Integer pmodelUnitId;

    @ApiModelProperty(value = "工单类-生产计划信息表计划数量", example = "1")
    private Integer pmodelNum;

    @ApiModelProperty(value = "工单类-生产计划信息表批次号")
    private String pmodelBatch;

    @ApiModelProperty(value = "工单类-生产计划信息表是否加急 0否 1是", example = "1")
    private Integer pmodelUrgent;

    @ApiModelProperty(value = "工单类-生产计划信息表导入批号（关联plan_import表)", example = "1")
    private Integer pmodelImportId;

    @ApiModelProperty(value = "工单类-生产计划信息表计划员编码（与system_user表关联）", example = "1")
    private Integer pmodelUserId;

    @ApiModelProperty(value = "工单类-生产计划信息表状态 0已生成、1已发布、2已撤回、3已取消、4已分配、5已暂停、6已完工、7已入库、8已关闭", example = "1")
    private Integer pmodelStatus;

    @ApiModelProperty(value = "工单类-生产计划信息表计划发布时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pmodelPublishDate;

    @ApiModelProperty(value = "系统-组织信息表主键", example = "1")
    private Integer fmodelId;

    @ApiModelProperty(value = "系统-组织信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer fmodelDeleted;

    @ApiModelProperty(value = "系统-组织信息表创建人编码", example = "1")
    private Integer fmodelCreateUser;

    @ApiModelProperty(value = "系统-组织信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date fmodelCreateTime;

    @ApiModelProperty(value = "系统-组织信息表更新人编码", example = "1")
    private Integer fmodelUpdateUser;

    @ApiModelProperty(value = "系统-组织信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date fmodelUpdateTime;

    @ApiModelProperty(value = "系统-组织信息表名称，不可重复")
    private String fmodelName;

    @ApiModelProperty(value = "系统-组织信息表备注")
    private String fmodelRemark;

    @ApiModelProperty(value = "系统-组织信息表主组织ID（自关联，type=4该字段为空）", example = "1")
    private Integer fmodelRootId;

    @ApiModelProperty(value = "系统-组织信息表上级组织ID（自关联）", example = "1")
    private Integer fmodelParentId;

    @ApiModelProperty(value = "系统-组织信息表公司ID（关联company表，type=4该字段为空）", example = "1")
    private Integer fmodelCompanyId;

    @ApiModelProperty(value = "系统-组织信息表组织类型 0公司 1工厂 2部门 3班组 4平台组织", example = "1")
    private Integer fmodelType;

    @ApiModelProperty(value = "系统-组织信息表关联ERP编码（type=4该字段为空）")
    private String fmodelErpId;

    @ApiModelProperty(value = "系统-组织信息表状态 0启用 1失效", example = "1")
    private Integer fmodelStatus;

    @ApiModelProperty(value = "系统-组织信息表最后启用时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date fmodelValidTime;

    @ApiModelProperty(value = "系统-组织信息表最后失效时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date fmodelInvalidTime;

    @ApiModelProperty(value = "系统-数据字典数据表主键", example = "1")
    private Integer tmodelId;

    @ApiModelProperty(value = "系统-数据字典数据表是否已删除 0未删除 1已删除", example = "1")
    private Integer tmodelDeleted;

    @ApiModelProperty(value = "系统-数据字典数据表创建人编码", example = "1")
    private Integer tmodelCreateUser;

    @ApiModelProperty(value = "系统-数据字典数据表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date tmodelCreateTime;

    @ApiModelProperty(value = "系统-数据字典数据表更新人编码", example = "1")
    private Integer tmodelUpdateUser;

    @ApiModelProperty(value = "系统-数据字典数据表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date tmodelUpdateTime;

    @ApiModelProperty(value = "系统-数据字典数据表字典编码 （关联system_dict表）", example = "1")
    private Integer tmodelDictId;

    @ApiModelProperty(value = "系统-数据字典数据表数据值")
    private String tmodelCode;

    @ApiModelProperty(value = "系统-数据字典数据表标签备注")
    private String tmodelLabel;

    @ApiModelProperty(value = "系统-数据字典数据表排序码", example = "1")
    private Integer tmodelSort;

    @ApiModelProperty(value = "系统-数据字典数据表是否禁用0否 1是", example = "1")
    private Integer tmodelDisabled;

    @ApiModelProperty(value = "物料基本信息表主键", example = "1")
    private Integer mmodelId;

    @ApiModelProperty(value = "物料基本信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer mmodelDeleted;

    @ApiModelProperty(value = "物料基本信息表创建人编码", example = "1")
    private Integer mmodelCreateUser;

    @ApiModelProperty(value = "物料基本信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date mmodelCreateTime;

    @ApiModelProperty(value = "物料基本信息表更新人编码", example = "1")
    private Integer mmodelUpdateUser;

    @ApiModelProperty(value = "物料基本信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date mmodelUpdateTime;

    @ApiModelProperty(value = "物料基本信息表备注")
    private String mmodelRemark;

    @ApiModelProperty(value = "物料基本信息表主组织编码（关联department表根组织）", example = "1")
    private Integer mmodelRootDepartId;

    @ApiModelProperty(value = "物料基本信息表名称，不可重复")
    private String mmodelName;

    @ApiModelProperty(value = "物料基本信息表编码，不可重复")
    private String mmodelCode;

    @ApiModelProperty(value = "物料基本信息表规格型号")
    private String mmodelAttr;

    @ApiModelProperty(value = "物料基本信息表组合名称，（物料名称+物料规格型号，自动显示不可人工修改）")
    private String mmodelUnionName;

    @ApiModelProperty(value = "物料基本信息表主单位编码，（关联unit表）", example = "1")
    private Integer mmodelUnitId;

    @ApiModelProperty(value = "物料基本信息表物料分类组合编码（关联category_union表）", example = "1")
    private Integer mmodelCateUnionId;

    @ApiModelProperty(value = "物料基本信息表形成方式 0生产、1.采购", example = "1")
    private Integer mmodelFormation;

    @ApiModelProperty(value = "物料基本信息表二维码ID")
    private String mmodelQrcodeId;

    @ApiModelProperty(value = "物料基本信息表状态0.无效 1.有效", example = "1")
    private Integer mmodelStatus;

    @ApiModelProperty(value = "物料基本信息表最后启用时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date mmodelValidTime;

    @ApiModelProperty(value = "物料基本信息表最后失效时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date mmodelInvalidTime;

    @ApiModelProperty(value = "物料基本信息表检验方法 0全检 1抽检", example = "1")
    private Integer mmodelCheckWay;

    @ApiModelProperty(value = "物料基本信息表质量要求")
    private String mmodelQualityRequire;

    @ApiModelProperty(value = "物料基本信息表检验标准说明")
    private String mmodelCheckNote;

    @ApiModelProperty(value = "物料单位信息表主键", example = "1")
    private Integer umodelId;

    @ApiModelProperty(value = "物料单位信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer umodelDeleted;

    @ApiModelProperty(value = "物料单位信息表创建人编码", example = "1")
    private Integer umodelCreateUser;

    @ApiModelProperty(value = "物料单位信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date umodelCreateTime;

    @ApiModelProperty(value = "物料单位信息表更新人编码", example = "1")
    private Integer umodelUpdateUser;

    @ApiModelProperty(value = "物料单位信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date umodelUpdateTime;

    @ApiModelProperty(value = "物料单位信息表备注")
    private String umodelRemark;

    @ApiModelProperty(value = "物料单位信息表主组织编码（关联department表根组织）", example = "1")
    private Integer umodelRootDepartId;

    @ApiModelProperty(value = "物料单位信息表单位名称")
    private String umodelName;

    @ApiModelProperty(value = "物料单位信息表类型0.主单位，1.采购单位，2.库存单位", example = "1")
    private Integer umodelType;

    @ApiModelProperty(value = "物料单位信息表状态 0禁用 1启用", example = "1")
    private Integer umodelStatus;

    @ApiModelProperty(value = "系统用户信息表主键", example = "1")
    private Integer pumodelId;

    @ApiModelProperty(value = "系统用户信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer pumodelDeleted;

    @ApiModelProperty(value = "系统用户信息表创建人编码", example = "1")
    private Integer pumodelCreateUser;

    @ApiModelProperty(value = "系统用户信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pumodelCreateTime;

    @ApiModelProperty(value = "系统用户信息表更新人编码", example = "1")
    private Integer pumodelUpdateUser;

    @ApiModelProperty(value = "系统用户信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pumodelUpdateTime;

    @ApiModelProperty(value = "系统用户信息表备注")
    private String pumodelRemark;

    @ApiModelProperty(value = "系统用户信息表主组织编码（关联department表根组织）", example = "1")
    private Integer pumodelRootDepartId;

    @ApiModelProperty(value = "系统用户信息表公司级组织编码（关联department表）", example = "1")
    private Integer pumodelDepartId;

    @ApiModelProperty(value = "系统用户信息表所属计划编码", example = "1")
    private Integer pumodelPlanId;

    @ApiModelProperty(value = "系统用户信息表工单编码（关联department表）", example = "1")
    private Integer pumodelWorkorderId;

    @ApiModelProperty(value = "系统用户信息表生产人员编码（关联system_user表）", example = "1")
    private Integer pumodelProUserId;

    @ApiModelProperty(value = "生产设备信息表主键", example = "1")
    private Integer pgmodelId;

    @ApiModelProperty(value = "生产设备信息表是否已删除 0未删除 1已删除", example = "1")
    private Integer pgmodelDeleted;

    @ApiModelProperty(value = "生产设备信息表创建人编码", example = "1")
    private Integer pgmodelCreateUser;

    @ApiModelProperty(value = "生产设备信息表创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pgmodelCreateTime;

    @ApiModelProperty(value = "生产设备信息表更新人编码", example = "1")
    private Integer pgmodelUpdateUser;

    @ApiModelProperty(value = "生产设备信息表更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date pgmodelUpdateTime;

    @ApiModelProperty(value = "生产设备信息表备注")
    private String pgmodelRemark;

    @ApiModelProperty(value = "生产设备信息表主组织编码（关联department表根组织）", example = "1")
    private Integer pgmodelRootDepartId;

    @ApiModelProperty(value = "生产设备信息表公司级组织编码（关联department表）", example = "1")
    private Integer pgmodelDepartId;

    @ApiModelProperty(value = "生产设备信息表工序编码（关联procedure表）", example = "1")
    private Integer pgmodelProcedureId;

    @ApiModelProperty(value = "生产设备信息表设备编码", example = "1")
    private Integer pgmodelCode;

    @ApiModelProperty(value = "生产设备信息表类型 0组 1设备", example = "1")
    private Integer pgmodelType;

    @ApiModelProperty(value = "生产设备信息表名称")
    private String pgmodelName;

    @ApiModelProperty(value = "生产设备信息表型号")
    private String pgmodelModel;

    @ApiModelProperty(value = "生产设备信息表运行状态'-1.已报废，0.待启用，1.已启用，2.已停用", example = "1")
    private Integer pgmodelStatus;

    @ApiModelProperty(value = "生产设备信息表供应商")
    private String pgmodelSupplier;

    @ApiModelProperty(value = "生产设备信息表工位编号")
    private String pgmodelStationCode;

    @ApiModelProperty(value = "生产设备信息表设备组编码（自关联，type=0）", example = "1")
    private Integer pgmodelGroupId;

    @ApiModelProperty(value = "是否坚持是否有投料）", example = "1")
    private Integer checkTouliao;

    @ApiModelProperty(value = "生产设备信息表序列号")
    private String pgmodelSerialNum;

    @ApiModelProperty(value = "数据权限部门编码集合" ,hidden = true)
    private List<Integer> departIds;

    @ExcelColumn(name="工单类型（0正常、1返工、2客户返修）")
    private Integer type;

    @ApiModelProperty(value = "混合查询，工单编码/序名称")
    private String mixParam;

    @ApiModelProperty(value = "开始时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date startDate;

    @ApiModelProperty(value = "截止时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date endDate;
}