package doumeemes.dao.ext.dto; import doumeemes.core.annotation.excel.ExcelColumn; import doumeemes.dao.business.dto.MaterialListDTO; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.List; import java.util.Date; /** * @author 江蹄蹄 * @date 2022/04/20 10:56 */ @Data @ApiModel("工单生产过程记录查询参数") public class QueryWorkorderRecordExtDTO { @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 workorderId; @ApiModelProperty(value = "批次号") private String batch; @ApiModelProperty(value = "生产工厂机级组织编码(关联department表)", example = "1") private Integer factoryId; @ApiModelProperty(value = "生产工序编码(关联procedures表)", example = "1") private Integer procedureId; @ApiModelProperty(value = "生产设备编码(关联device表)", example = "1") private Integer proDeviceId; @ApiModelProperty(value = "工装编码(关联appliances表)", example = "1") private Integer appliancesId; @ApiModelProperty(value = "生产日期") @JsonFormat(pattern = "yyyy-MM-dd") private Date proDate; @ApiModelProperty(value = "生产类型0.投料,1.产出", example = "1") private Integer type; @ApiModelProperty(value = "数量", example = "1") private Integer num; @ApiModelProperty(value = "报工类型0合格 1不良(只有type=1才有值)", example = "1") private Integer doneType; @ApiModelProperty(value = "物料编码(关联material_distribute表)", example = "1") private Integer materialId; @ApiModelProperty(value = "单位编码(关联unit_distribute表)", example = "1") private Integer unitId; @ApiModelProperty(value = "物料批次号") private String materialBatch; @ApiModelProperty(value = "检验方法 0全检 1抽检", example = "1") private Integer checkWay; @ApiModelProperty(value = "检验人员编码", example = "1") private Integer checkUserId; @ApiModelProperty(value = "检验合格数量", example = "1") private Integer qualifiedNum; @ApiModelProperty(value = "检验不合格数量", example = "1") private Integer unqualifiedNum; @ApiModelProperty(value = "检验日期") @JsonFormat(pattern = "yyyy-MM-dd") private Date checkDate; @ApiModelProperty(value = "检验说明") private String checkInfo; @ApiModelProperty(value = "检验不良品工装编码(关联appliances表)") private String qualifiedApplianceId; @ApiModelProperty(value = "生产人员编码集合([1],[2],...形式存储,优化查询)" ) private String proUserids; @ApiModelProperty(value = "物料质量属性0合格 1不良 2报废(只有type=1才有值)" ) private Integer materialDonetype; @ApiModelProperty(value = "物料工序编码(关联procedure表)" ) private Integer materialProcedurId; @ApiModelProperty(value = "关联票据编码(投料时)" ) private Integer relobjId; @ApiModelProperty(value = "关联票据类型 0工单 1篮筐更换单记录" ) private Integer relobjType; @ApiModelProperty(value = "检验类型 0巡线、1巡检、2终检", example = "1") private Integer checkType; @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 omodelId; @ApiModelProperty(value = "工单类-工单信息表是否已删除 0未删除 1已删除", example = "1") private Integer omodelDeleted; @ApiModelProperty(value = "工单类-工单信息表创建人编码", example = "1") private Integer omodelCreateUser; @ApiModelProperty(value = "工单类-工单信息表创建时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date omodelCreateTime; @ApiModelProperty(value = "工单类-工单信息表更新人编码", example = "1") private Integer omodelUpdateUser; @ApiModelProperty(value = "工单类-工单信息表更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date omodelUpdateTime; @ApiModelProperty(value = "工单类-工单信息表备注") private String omodelRemark; @ApiModelProperty(value = "工单类-工单信息表主组织编码(关联department表根组织)", example = "1") private Integer omodelRootDepartId; @ApiModelProperty(value = "工单类-工单信息表公司级组织编码(关联department表)", example = "1") private Integer omodelDepartId; @ApiModelProperty(value = "工单类-工单信息表所属计划编码", example = "1") private Integer omodelPlanId; @ApiModelProperty(value = "工单类-工单信息表生产工厂机级组织编码(关联department表)", example = "1") private Integer omodelFactoryId; @ApiModelProperty(value = "工单类-工单信息表生产工序编码(关联procedures表)", example = "1") private Integer omodelProcedureId; @ApiModelProperty(value = "工单类-工单信息表工单编号") private String omodelCode; @ApiModelProperty(value = "工单类-工单信息表原工单编码(返工工单专用)", example = "1") private Integer omodelOriginWorkorderId; @ApiModelProperty(value = "工单类-工单信息表工单类型ID(关联system_dict_data)", example = "1") private Integer omodelTypeId; @ApiModelProperty(value = "工单类-工单信息表数据来源ID(关联system_dict_data)", example = "1") private Integer omodelOriginId; @ApiModelProperty(value = "工单类-工单信息表计划日期") @JsonFormat(pattern = "yyyy-MM-dd") private Date omodelPlanDate; @ApiModelProperty(value = "工单类-工单信息表计划数量", example = "1") private Integer omodelPlanNum; @ApiModelProperty(value = "工单类-工单信息表物料编码(关联material_distribute表)", example = "1") private Integer omodelMaterialId; @ApiModelProperty(value = "工单类-工单信息表单位编码(关联unit_distribute表)", example = "1") private Integer omodelUnitId; @ApiModelProperty(value = "工单类-工单信息表批次号") private String omodelBatch; @ApiModelProperty(value = "工单类-工单信息表生产人员编码(关联system_user表)", example = "1") private Integer omodelProUserId; @ApiModelProperty(value = "工单类-工单信息表生产班组编码(关联device表)", example = "1") private Integer omodelProGroupId; @ApiModelProperty(value = "工单类-工单信息表合格数量", example = "1") private Integer omodelQualifiedNum; @ApiModelProperty(value = "工单类-工单信息表不合格数量", example = "1") private Integer omodelUnqualifiedNum; @ApiModelProperty(value = "工单类-工单信息表检验人员编码", example = "1") private Integer omodelCheckUserId; @ApiModelProperty(value = "工单类-工单信息表状态 0已创建、1已领料、2已完工、3已检验、4已返工、5已入库、6已暂停、7已取消、8已关闭", example = "1") private Integer omodelStatus; @ApiModelProperty(value = "工单类-工单信息表最近状态更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date omodelLastDealDate; @ApiModelProperty(value = "工单类-工单信息表最近状态更新备注") private String omodelLastDealInfo; @ApiModelProperty(value = "工单类-工单信息表是否加急 0否 1是", example = "1") private Integer omodelUrgent; @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 promodelId; @ApiModelProperty(value = "工序信息表是否已删除 0未删除 1已删除", example = "1") private Integer promodelDeleted; @ApiModelProperty(value = "工序信息表创建人编码", example = "1") private Integer promodelCreateUser; @ApiModelProperty(value = "工序信息表创建时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date promodelCreateTime; @ApiModelProperty(value = "工序信息表更新人编码", example = "1") private Integer promodelUpdateUser; @ApiModelProperty(value = "工序信息表更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date promodelUpdateTime; @ApiModelProperty(value = "工序信息表备注") private String promodelRemark; @ApiModelProperty(value = "工序信息表主组织编码(关联department表根组织)", example = "1") private Integer promodelRootDepartId; @ApiModelProperty(value = "工序信息表公司级组织编码(关联department表组织)", example = "1") private Integer promodelDepartId; @ApiModelProperty(value = "工序信息表代码") private String promodelCode; @ApiModelProperty(value = "工序信息表名称") private String promodelName; @ApiModelProperty(value = "工序信息表加工顺序", example = "1") private Integer promodelSortnum; @ApiModelProperty(value = "工序信息表部门级组织编码(关联department表组织)", example = "1") private Integer promodelOrgId; @ApiModelProperty(value = "工序信息表工序负责人编码(关联company_user表)", example = "1") private Integer promodelUserId; @ApiModelProperty(value = "工序信息表领料仓库编码(关联warehouse表)", example = "1") private Integer promodelPickingWarehouseId; @ApiModelProperty(value = "工序信息表产出仓库编码(关联warehouse表)", example = "1") private Integer promodelProduceWarehouseId; @ApiModelProperty(value = "工序信息表设备收集层次 0设备 1组", example = "1") private Integer promodelLevel; @ApiModelProperty(value = "工装器具信息表主键", example = "1") private Integer amodelId; @ApiModelProperty(value = "工装器具信息表是否已删除 0未删除 1已删除", example = "1") private Integer amodelDeleted; @ApiModelProperty(value = "工装器具信息表创建人编码", example = "1") private Integer amodelCreateUser; @ApiModelProperty(value = "工装器具信息表创建时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date amodelCreateTime; @ApiModelProperty(value = "工装器具信息表更新人编码", example = "1") private Integer amodelUpdateUser; @ApiModelProperty(value = "工装器具信息表更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date amodelUpdateTime; @ApiModelProperty(value = "工装器具信息表备注") private String amodelRemark; @ApiModelProperty(value = "工装器具信息表主组织编码(关联department表根组织)", example = "1") private Integer amodelRootDepartId; @ApiModelProperty(value = "工装器具信息表公司级组织编码(关联department表)", example = "1") private Integer amodelDepartId; @ApiModelProperty(value = "工装器具信息表序列号") private String amodelSerialNum; @ApiModelProperty(value = "工装器具信息表二维码ID", example = "1") private Integer amodelBrcode; @ApiModelProperty(value = "工装器具信息表生产时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date amodelValidTime; @ApiModelProperty(value = "工装器具信息表类型0篮筐,1托盘", example = "1") private Integer amodelType; @ApiModelProperty(value = "工装器具信息表状态0.报废、1.空、2.部分、3.满", example = "1") private Integer amodelStatus; @ApiModelProperty(value = "工装器具信息表当前装载工单编码(关联workorder表)", example = "1") private Integer amodelWorkorderId; @ApiModelProperty(value = "工装器具信息表当前装载物料编码(关联material表)") private String amodelMaterialId; @ApiModelProperty(value = "工装器具信息表数量", example = "1") private Integer amodelNum; @ApiModelProperty(value = "工装器具信息表托盘码") private String amodelCode; @ApiModelProperty(value = "工装器具信息表位置类型 0仓库1.车间", example = "1") private Integer amodelPositionType; @ApiModelProperty(value = "工装器具信息表当前所在仓库代码(关联warehouse表)", example = "1") private Integer amodelWarehouseId; @ApiModelProperty(value = "工装器具信息表当前所在货位代码(关联warehouse_location表)", example = "1") private Integer amodelLocationId; @ApiModelProperty(value = "工装器具信息表当前所在工序编码(关联procedure表)", example = "1") private Integer amodelProcedureId; @ApiModelProperty(value = "工装器具信息表当前被使用对象类型 0出入库单 1生产过程记录表", example = "1") private Integer amodelCurObjType; @ApiModelProperty(value = "工装器具信息表当前被使用对象编码(根据CUR_OBJ_TYPE确定关联关系)", example = "1") private Integer amodelCurObjId; @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 = "工装器具编码集合",hidden = true) private List applianceIds; @ApiModelProperty(value = "开始时间",example = "2022-07-27") @JsonFormat(pattern = "yyyy-MM-dd") private Date startDate; @ApiModelProperty(value = "截止时间",example = "2022-07-27") @JsonFormat(pattern = "yyyy-MM-dd") private Date endDate; @ApiModelProperty(value = "数据权限部门编码集合" ,hidden = true) private List departIds; }