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 = "查询标识 0大屏查询", example = "1")
|
private Integer queryType;
|
|
@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 String planDateStartDate;
|
@ApiModelProperty(value = "截止时间")
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private String planDateEndDate;
|
}
|
