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.math.BigDecimal;
|
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 BigDecimal qualifiedNum;
|
|
@ApiModelProperty(value = "不合格数量", example = "1")
|
private BigDecimal unqualifiedNum;
|
|
@ApiModelProperty(value = "检验人员编码", example = "1")
|
private Integer checkUserId;
|
|
@ApiModelProperty(value = "工单状态 0已创建、1已备料、2已完工、3已检验、4已报工、5已入库、6已取消、7生产中", example = "1")
|
private Integer status;
|
@ApiModelProperty(value = "工单状态集合（待生产：[0,1]，生产中[2,3，7]，已完成[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 HH:mm:ss")
|
private String startDate;
|
|
@ApiModelProperty(value = "截止时间")
|
// @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
private String endDate;
|
}
|
