package doumeemes.dao.ext.vo; import doumeemes.core.annotation.excel.ExcelColumn; import doumeemes.dao.business.model.*; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; /** * @author 江蹄蹄 * @date 2022/04/20 11:01 */ @Data @ApiModel("工装器具信息列表对象") public class AppliancesExtListVO implements Serializable { @ApiModelProperty(value = "主键", example = "1") // @ExcelColumn(name="主键") private Integer id; @ApiModelProperty(value = "是否已删除 0未删除 1已删除", example = "1",hidden = true) // @ExcelColumn(name="是否已删除 0未删除 1已删除") private Integer deleted; @ApiModelProperty(value = "创建人编码", example = "1") // @ExcelColumn(name="创建人编码") private Integer createUser; @ApiModelProperty(value = "创建时间") @ExcelColumn(name="创建时间",dateFormat = "yyyy-MM-dd HH:mm:ss",index = 15,width =15) private Date createTime; @ApiModelProperty(value = "更新人编码", example = "1",hidden = true) // @ExcelColumn(name="更新人编码") private Integer updateUser; @ApiModelProperty(value = "分类组合编码(关联category_union表)", example = "1" ) // @ExcelColumn(name="分类组合编码") private Integer categoryId; @ApiModelProperty(value = "更新时间",hidden = true) // @ExcelColumn(name="更新时间") // @JsonFormat(pattern = "yyyy-MM-dd") private Date updateTime; @ApiModelProperty(value = "备注") @ExcelColumn(name="报废原因",index = 16,width =15) private String remark; @ApiModelProperty(value = "主组织编码(关联department表根组织)", example = "1",hidden = true) // @ExcelColumn(name="主组织编码(关联department表根组织)") private Integer rootDepartId; @ApiModelProperty(value = "公司级组织编码(关联department表)", example = "1",hidden = true) // @ExcelColumn(name="公司级组织编码(关联department表)") private Integer departId; @ApiModelProperty(value = "序列号") @ExcelColumn(name="序列号",index = 4,width =15) private String serialNum; @ApiModelProperty(value = "二维码ID", example = "1",hidden = true) // @ExcelColumn(name="二维码ID") private Integer brcode; @ApiModelProperty(value = "生产时间",hidden = true) // @ExcelColumn(name="生产时间") //@JsonFormat(pattern = "yyyy-MM-dd") private Date validTime; @ApiModelProperty(value = "类型数据字典配置(关联system_dict_data表)", example = "1",hidden = true) // @ExcelColumn(name="类型数据字典配置(关联system_dict_data表)") private Integer type; @ApiModelProperty(value = "状态0.报废、1.空、2.部分、3.满", example = "1") // @ExcelColumn(name="状态0.报废、1.空、2.部分、3.满") private Integer status; @ExcelColumn(name="状态",index = 5,width =15) private String statusname; @ApiModelProperty(value = "当前装载工单编码(关联workorder表)", example = "1") @ExcelColumn(name="单据编号",index = 6,width =15) private Integer workorderId; @ApiModelProperty(value = "当前装载物料编码(关联material表)") // @ExcelColumn(name="当前装载物料编码(关联material表)") private Integer materialId; @ApiModelProperty(value = "托盘码编码") @ExcelColumn(name="工装编码",index = 3,width =15) private String code; @ApiModelProperty(value = "位置类型 0仓库1.车间", example = "1") // @ExcelColumn(name="位置类型 0仓库1.车间") private Integer positionType; @ApiModelProperty(value = "当前所在仓库代码(关联warehouse表)", example = "1") // @ExcelColumn(name="当前所在仓库代码(关联warehouse表)") private Integer warehouseId; @ApiModelProperty(value = "当前所在货位代码(关联warehouse_location表)", example = "1") // @ExcelColumn(name="当前所在货位代码(关联warehouse_location表)") private Integer locationId; @ApiModelProperty(value = "当前所在工序编码(关联procedure表)", example = "1") // @ExcelColumn(name="当前所在工序编码(关联procedure表)") private Integer procedureId; @ApiModelProperty(value = "当前被使用对象类型 0出入库单 1生产过程记录表", example = "1") // @ExcelColumn(name="当前被使用对象类型 0出入库单 1生产过程记录表") private Integer curObjType; @ApiModelProperty(value = "当前被使用对象编码(根据CUR_OBJ_TYPE确定关联关系)", example = "1") // @ExcelColumn(name="当前被使用对象编码(根据CUR_OBJ_TYPE确定关联关系)") private Integer curObjId; @ApiModelProperty(value = "产品质量属性 0合格 1不良 2报废", example = "1") private Integer qualityType ; @ApiModelProperty(value = "批次") @ExcelColumn(name="批次号",index = 9,width =15) private String batch; @ApiModelProperty(value = "返修申请单号(关联backorder表)", example = "1") private Integer backorderId ; @ApiModelProperty(value = "返修客返单号(关联saleorder表)", example = "1") private Integer saleorderId ; @ApiModelProperty(value = "返修不良产生工序编码(关联procedure表)", example = "1") private Integer backProcedureId ; @ApiModelProperty(value = "下一加工工序编码(关联procedure表)", example = "1") private Integer nextProcedureId ; @ApiModelProperty(value = "关联票据类型 0工单 1篮筐更换单记录", example = "1") private Integer relobjType ; @ApiModelProperty(value = "工装属性") @ExcelColumn(name="工装属性",index = 2,width =15) private String smodelCode; @ApiModelProperty(value = "系统-组织信息表信息",hidden = true) private Department dmodel; @ApiModelProperty(value = "工单类-工单信息表信息",hidden = true) private Workorder wmodel; @ApiModelProperty(value = "工位") private String vmodelStationCode; @ApiModelProperty(value = "物料分配基本信息表信息",hidden = true) private MaterialDistribute mdmodel; @ApiModelProperty(value = "物料基本信息表信息",hidden = true) private Material mmodel; @ApiModelProperty(value = "物料名称") @ExcelColumn(name="物料编码",index = 7,width =15) private String mmodelCode; @ApiModelProperty(value = "物料编码") @ExcelColumn(name="物料名称",index = 8,width =15) private String mmodelName; @ApiModelProperty(value = "仓库信息表信息",hidden = true) private Warehouse whmodel; @ApiModelProperty(value = "仓库名称") @ExcelColumn(name="仓库",index = 13,width =15) private String whmodelName; @ApiModelProperty(value = "仓库管理-库位信息表信息",hidden = true) private WarehouseLocation lmodel; @ApiModelProperty(value = "货位名称") @ExcelColumn(name="货位名称",index = 14,width =15) private String lmodelUnionName; @ApiModelProperty(value = "工序信息表信息",hidden = true) private Procedures pmodel; @ApiModelProperty(value = "工序名称") @ExcelColumn(name="生产工序",index = 12,width =15) private String pmodelName; @ApiModelProperty(value = "篮筐当前批次号" ) // @ExcelColumn(name="篮筐当前批次号") private String proBatch; @ApiModelProperty(value = "器具分类编码((关联category_union表))") private CategoryUnion cumodel; @ApiModelProperty(value = "工装类型大类名称") @ExcelColumn(name="工装类型",index = 1,width =15) private String cmodel1BigName; @ApiModelProperty(value = "工装类型中类名称") private String cmodel1MiddleName; @ApiModelProperty(value = "工装类型小类名称") private String cmodel1SmallName; @ApiModelProperty(value = "工单编码") private String wmodelCode; @ApiModelProperty(value = "字典表对应lables") private String smodelLabel; @ApiModelProperty(value = "数量", example = "1") @ExcelColumn(name="数量",index = 10,width =15) private BigDecimal num; @ApiModelProperty(value = "单位名称") @ExcelColumn(name="单位",index = 11,width =15) private String umodelName; @ApiModelProperty(value = "单位属性 0整数 1小时4位",example = "1") private Integer umodelData; @ApiModelProperty(value = "物料编码") private String materialCode; @ApiModelProperty(value = "物料名称") private String materialName; @ApiModelProperty(value = "大类") private String cumodelCateBigId; @ApiModelProperty(value = "中类") private String cumodelCateMiddleId; @ApiModelProperty(value = "小类") private String cumodelCateSmallId; @ApiModelProperty(value = "返修工序") private String fxpmodelName; @ApiModelProperty(value = "下一加工工序编码") private String xypmodelName; @ApiModelProperty(value = "客反单号") private String salemodelCode; @ApiModelProperty(value = "客返客户") private String cmodelName; @ApiModelProperty(value = "工装关联工序下的工厂名称") private String dpmodelName; @ApiModelProperty(value = "工装关联工序下的工厂id") private String pmodelOrgId; @ApiModelProperty(value = "单位编码",example = "1") private Integer unitId; @ApiModelProperty(value = "工装分类Big") private String categoryBigName; @ApiModelProperty(value = "工装分类Middle") private String categoryMiddleName; @ApiModelProperty(value = "工装分类Small") private String categorySmallName; @ApiModelProperty(value = "工装前缀") private String prefix; @ApiModelProperty(value = "单据编号,relobjType=0取workorder 表中的code,relobjType=1 取更换单记录表中的code") private String zjcode; }