package doumeemes.dao.ext.dto;

import doumeemes.core.annotation.excel.ExcelColumn;
import doumeemes.dao.ext.vo.DepartmentExtListVO;
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;

/**
 * @author 江蹄蹄
 * @date 2022/04/20 11:01
 */
@Data
@ApiModel("生产计划查询参数")
public class QueryPlansExtDTO {

    @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 = "来源 0人工创建、1Excel导入、2计划程序生成", example = "1")
    private Integer origin;

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

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

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

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

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

    @ApiModelProperty(value = "计划数量", example = "1")
    private Integer num;
    @ApiModelProperty(value = "是否暂停 0未暂停 1已暂停", example = "1")
    private Integer paused;
    @ApiModelProperty(value = "批次号")
    private String batch;

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

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

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

    @ApiModelProperty(value = "状态 0已生成、1已发布、2已撤回、3已取消、4已分配、5已暂停、6已完工、7已入库、8已关闭，默认为null 表示全部", example = "1")
    private Integer status;

    @ApiModelProperty(value = "查询状态集合 默认为null表示全部", example = "1")
    private List<Integer> statusList;

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

    @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 = "成品计划主键", example = "1")
    private Integer workPlanId;


    @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 = "计划类型 0正常1异常2返工", example = "1")
    private Integer type;


    @ApiModelProperty(value = "成品计划编码")
    private String workPlanCode;

    @ApiModelProperty(value = "返修申请单号（关联backorder表）", example = "1")
    private Integer backorderId;
    @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 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 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 = "工序信息表代码")
    private String pmodelCode;

    @ApiModelProperty(value = "工序信息表名称")
    private String pmodelName;

    @ApiModelProperty(value = "工序信息表加工顺序", example = "1")
    private Integer pmodelSortnum;

    @ApiModelProperty(value = "工序信息表部门级组织编码（关联department表组织）", example = "1")
    private Integer pmodelOrgId;

    @ApiModelProperty(value = "工序信息表工序负责人编码（关联company_user表）", example = "1")
    private Integer pmodelUserId;

    @ApiModelProperty(value = "工序信息表领料仓库编码（关联warehouse表）", example = "1")
    private Integer pmodelPickingWarehouseId;

    @ApiModelProperty(value = "工序信息表产出仓库编码（关联warehouse表）", example = "1")
    private Integer pmodelProduceWarehouseId;

    @ApiModelProperty(value = "工序信息表设备收集层次 0设备 1组", example = "1")
    private Integer pmodelLevel;

    @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 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 usermodelId;

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

    @ApiModelProperty(value = "系统用户信息表创建人编码（自关联）", example = "1")
    private Integer usermodelCreateUser;

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

    @ApiModelProperty(value = "系统用户信息表更新人编码（自关联）", example = "1")
    private Integer usermodelUpdateUser;

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

    @ApiModelProperty(value = "系统用户信息表是否为固定用户", example = "1")
    private Integer usermodelFixed;

    @ApiModelProperty(value = "系统用户信息表密码")
    private String usermodelPassword;

    @ApiModelProperty(value = "系统用户信息表密码盐")
    private String usermodelSalt;

    @ApiModelProperty(value = "系统用户信息表头像")
    private String usermodelAvatar;

    @ApiModelProperty(value = "系统用户信息表手机号")
    private String usermodelMobile;

    @ApiModelProperty(value = "系统用户信息表邮箱")
    private String usermodelEmail;

    @ApiModelProperty(value = "系统用户信息表性别")
    private String usermodelSex;

    @ApiModelProperty(value = "系统用户信息表生日")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date usermodelBirthday;

    @ApiModelProperty(value = "系统用户信息表工号")
    private String usermodelEmpNo;

    @ApiModelProperty(value = "系统用户信息表真实姓名")
    private String usermodelRealname;

    @ApiModelProperty(value = "系统用户信息表用户名")
    private String usermodelUsername;

    @ApiModelProperty(value = "系统用户信息表创建系统ID（关联external_system表）")
    private String usermodelSystemid;

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

    @ApiModelProperty(value = "系统用户信息表用户类型 0平台用户 1企业用户", example = "1")
    private Integer usermodelType;

    @ApiModelProperty(value = "工序编码集合", example = "1",hidden = true)
    private List<Integer> procedureIds;
    @ApiModelProperty(value = "筛选工序编码集合", example = "1")
    private List<Integer> procedureIdList;

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

    @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;
}