| | |
| | | import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | import com.baomidou.mybatisplus.annotations.TableField; |
| | | import com.baomidou.mybatisplus.annotations.TableId; |
| | | import com.baomidou.mybatisplus.annotations.TableName; |
| | | import com.core.common.Cools; |
| | | import com.core.common.SpringUtils; |
| | |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | @ApiModelProperty(value= "库位号") |
| | | @TableId |
| | | private Long id; |
| | | |
| | | @ApiModelProperty(value = "库位号") |
| | | @TableField("loc_no") |
| | | private String locNo; |
| | | |
| | | @ApiModelProperty(value= "托盘条码") |
| | | @ApiModelProperty(value = "托盘条码") |
| | | private String zpallet; |
| | | |
| | | @ApiModelProperty(value= "数量") |
| | | @ApiModelProperty(value = "数量") |
| | | @ExcelProperty("数量") |
| | | private Double anfme; |
| | | |
| | | @ApiModelProperty(value= "物料号") |
| | | @ApiModelProperty(value = "物料号") |
| | | @ExcelProperty("物料号") |
| | | private String matnr; |
| | | |
| | | @ApiModelProperty(value= "物料号") |
| | | @ApiModelProperty(value = "物料号") |
| | | @ExcelProperty("物料号") |
| | | private String maktx; |
| | | |
| | | @ApiModelProperty(value= "序列码") |
| | | @ApiModelProperty(value = "序列码") |
| | | @ExcelProperty("序列码") |
| | | private String batch; |
| | | |
| | | @ApiModelProperty(value= "单据编号") |
| | | @ApiModelProperty(value = "单据编号") |
| | | @ExcelProperty("单据编号") |
| | | @TableField("order_no") |
| | | private String orderNo; |
| | | |
| | | @ApiModelProperty(value= "规格") |
| | | @ApiModelProperty(value = "规格") |
| | | private String specs; |
| | | |
| | | @ApiModelProperty(value= "批次") |
| | | @ApiModelProperty(value = "批次") |
| | | private String model; |
| | | |
| | | @ApiModelProperty(value= "颜色") |
| | | @ApiModelProperty(value = "颜色") |
| | | private String color; |
| | | |
| | | @ApiModelProperty(value= "品牌") |
| | | @ApiModelProperty(value = "品牌") |
| | | private String brand; |
| | | |
| | | @ApiModelProperty(value= "单位") |
| | | @ApiModelProperty(value = "单位") |
| | | private String unit; |
| | | |
| | | @ApiModelProperty(value= "单价") |
| | | @ApiModelProperty(value = "单价") |
| | | private Double price; |
| | | |
| | | @ApiModelProperty(value= "sku") |
| | | @ApiModelProperty(value = "sku") |
| | | private String sku; |
| | | |
| | | @ApiModelProperty(value= "包数") |
| | | @ApiModelProperty(value = "包数") |
| | | private Double units; |
| | | |
| | | @ApiModelProperty(value= "条码") |
| | | @ApiModelProperty(value = "条码") |
| | | private String barcode; |
| | | |
| | | @ApiModelProperty(value= "物料状态") |
| | | @ApiModelProperty(value = "物料状态") |
| | | private String origin; |
| | | |
| | | @ApiModelProperty(value= "厂家") |
| | | @ApiModelProperty(value = "厂家") |
| | | private String manu; |
| | | |
| | | @ApiModelProperty(value= "单据时间") |
| | | @ApiModelProperty(value = "单据时间") |
| | | @TableField("manu_date") |
| | | private String manuDate; |
| | | |
| | | @ApiModelProperty(value= "品项数") |
| | | @ApiModelProperty(value = "品项数") |
| | | @TableField("item_num") |
| | | private String itemNum; |
| | | |
| | | @ApiModelProperty(value= "安全库存量") |
| | | @ApiModelProperty(value = "安全库存量") |
| | | @TableField("safe_qty") |
| | | private Double safeQty; |
| | | |
| | | @ApiModelProperty(value= "重量") |
| | | @ApiModelProperty(value = "重量") |
| | | private Double weight; |
| | | |
| | | @ApiModelProperty(value= "长度") |
| | | @ApiModelProperty(value = "长度") |
| | | private Double length; |
| | | |
| | | @ApiModelProperty(value= "体积") |
| | | @ApiModelProperty(value = "体积") |
| | | private Double volume; |
| | | |
| | | @ApiModelProperty(value= "三方编码") |
| | | @ApiModelProperty(value = "三方编码") |
| | | @TableField("three_code") |
| | | private String threeCode; |
| | | |
| | | @ApiModelProperty(value= "供应商") |
| | | @ApiModelProperty(value = "供应商") |
| | | private String supp; |
| | | |
| | | @ApiModelProperty(value= "供应商编码") |
| | | @ApiModelProperty(value = "供应商编码") |
| | | @TableField("supp_code") |
| | | private String suppCode; |
| | | |
| | | @ApiModelProperty(value= "是否批次 1: 是 0: 否 ") |
| | | @ApiModelProperty(value = "是否批次 1: 是 0: 否 ") |
| | | @TableField("be_batch") |
| | | private Integer beBatch; |
| | | |
| | | @ApiModelProperty(value= "保质期") |
| | | @ApiModelProperty(value = "保质期") |
| | | @TableField("dead_time") |
| | | private String deadTime; |
| | | |
| | | @ApiModelProperty(value= "预警天数") |
| | | @ApiModelProperty(value = "预警天数") |
| | | @TableField("dead_warn") |
| | | private Integer deadWarn; |
| | | |
| | | @ApiModelProperty(value= "制购 1: 制造 2: 采购 3: 外协 ") |
| | | @ApiModelProperty(value = "制购 1: 制造 2: 采购 3: 外协 ") |
| | | private Integer source; |
| | | |
| | | @ApiModelProperty(value= "要求检验 1: 是 0: 否 ") |
| | | @ApiModelProperty(value = "要求检验 1: 是 0: 否 ") |
| | | private Integer inspect; |
| | | |
| | | @ApiModelProperty(value= "危险品 1: 是 0: 否 ") |
| | | @ApiModelProperty(value = "危险品 1: 是 0: 否 ") |
| | | private Integer danger; |
| | | |
| | | @ApiModelProperty(value= "修改人员") |
| | | @ApiModelProperty(value = "修改人员") |
| | | @TableField("modi_user") |
| | | private Long modiUser; |
| | | |
| | | @ApiModelProperty(value= "修改时间") |
| | | @ApiModelProperty(value = "修改时间") |
| | | @TableField("modi_time") |
| | | private Date modiTime; |
| | | |
| | | @ApiModelProperty(value= "创建者") |
| | | @ApiModelProperty(value = "创建者") |
| | | @TableField("appe_user") |
| | | private Long appeUser; |
| | | |
| | | @ApiModelProperty(value= "添加时间") |
| | | @ApiModelProperty(value = "添加时间") |
| | | @TableField("appe_time") |
| | | private Date appeTime; |
| | | |
| | | @ApiModelProperty(value= "备注") |
| | | @ApiModelProperty(value = "备注") |
| | | private String memo; |
| | | |
| | | @TableField("stock_freeze") |
| | | @ApiModelProperty(value= "库存冻结{1:正常,0:冻结}") |
| | | @ApiModelProperty(value = "库存冻结{1:正常,0:冻结}") |
| | | private Integer stockFreeze; |
| | | |
| | | /** |
| | | * 库存数量 |
| | | */ |
| | | @ApiModelProperty(value= "可出数量") |
| | | @ApiModelProperty(value = "可出数量") |
| | | @TableField(exist = false) |
| | | private Double stock; |
| | | |
| | | /** |
| | | * 库存数量 |
| | | */ |
| | | @ApiModelProperty(value= "可出数量") |
| | | @ApiModelProperty(value = "可出数量") |
| | | @TableField(exist = false) |
| | | private String locSts; |
| | | |
| | | /** |
| | | * 库存数量 |
| | | */ |
| | | @ApiModelProperty(value= "可出数量") |
| | | @ApiModelProperty(value = "可出数量") |
| | | @TableField(exist = false) |
| | | private String locSts$; |
| | | |
| | | /** |
| | | * 工序状态 |
| | | */ |
| | | @ApiModelProperty(value= "工序状态 1:待加工,2:已加工,3:无需加工") |
| | | @ApiModelProperty(value = "工序状态 1:待加工,2:已加工,3:无需加工") |
| | | @TableField("process_sts") |
| | | private Integer processSts; |
| | | |
| | | |
| | | public String getProcessSts$(){ |
| | | if (null == this.processSts){ return null; } |
| | | switch (this.processSts){ |
| | | public String getProcessSts$() { |
| | | if (null == this.processSts) { |
| | | return null; |
| | | } |
| | | switch (this.processSts) { |
| | | case 0: |
| | | return "其他"; |
| | | case 1: |
| | |
| | | } |
| | | } |
| | | |
| | | public String getLocNo$(){ |
| | | public String getLocNo$() { |
| | | LocMastService service = SpringUtils.getBean(LocMastService.class); |
| | | LocMast locMast = service.selectById(this.locNo); |
| | | if (!Cools.isEmpty(locMast)){ |
| | | if (!Cools.isEmpty(locMast)) { |
| | | return String.valueOf(locMast.getLocNo()); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | public String getBeBatch$(){ |
| | | if (null == this.beBatch){ return null; } |
| | | switch (this.beBatch){ |
| | | public String getBeBatch$() { |
| | | if (null == this.beBatch) { |
| | | return null; |
| | | } |
| | | switch (this.beBatch) { |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | |
| | | } |
| | | } |
| | | |
| | | public String getSource$(){ |
| | | if (null == this.source){ return null; } |
| | | switch (this.source){ |
| | | public String getSource$() { |
| | | if (null == this.source) { |
| | | return null; |
| | | } |
| | | switch (this.source) { |
| | | case 1: |
| | | return "制造"; |
| | | case 2: |
| | |
| | | } |
| | | } |
| | | |
| | | public String getInspect$(){ |
| | | if (null == this.inspect){ return null; } |
| | | switch (this.inspect){ |
| | | public String getInspect$() { |
| | | if (null == this.inspect) { |
| | | return null; |
| | | } |
| | | switch (this.inspect) { |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | |
| | | } |
| | | } |
| | | |
| | | public String getDanger$(){ |
| | | if (null == this.danger){ return null; } |
| | | switch (this.danger){ |
| | | public String getDanger$() { |
| | | if (null == this.danger) { |
| | | return null; |
| | | } |
| | | switch (this.danger) { |
| | | case 1: |
| | | return "是"; |
| | | case 0: |
| | |
| | | } |
| | | } |
| | | |
| | | public String getModiUser$(){ |
| | | public String getModiUser$() { |
| | | UserService service = SpringUtils.getBean(UserService.class); |
| | | User user = service.selectById(this.modiUser); |
| | | if (!Cools.isEmpty(user)){ |
| | | if (!Cools.isEmpty(user)) { |
| | | return String.valueOf(user.getUsername()); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | public String getModiTime$(){ |
| | | if (Cools.isEmpty(this.modiTime)){ |
| | | public String getModiTime$() { |
| | | if (Cools.isEmpty(this.modiTime)) { |
| | | return ""; |
| | | } |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.modiTime); |
| | | } |
| | | |
| | | public String getAppeUser$(){ |
| | | public String getAppeUser$() { |
| | | UserService service = SpringUtils.getBean(UserService.class); |
| | | User user = service.selectById(this.appeUser); |
| | | if (!Cools.isEmpty(user)){ |
| | | if (!Cools.isEmpty(user)) { |
| | | return String.valueOf(user.getUsername()); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | public String getAppeTime$(){ |
| | | if (Cools.isEmpty(this.appeTime)){ |
| | | public String getAppeTime$() { |
| | | if (Cools.isEmpty(this.appeTime)) { |
| | | return ""; |
| | | } |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime); |
| | |
| | | } |
| | | |
| | | public String getStockFreeze$() { |
| | | if (Cools.isEmpty(this.stockFreeze)){ |
| | | if (Cools.isEmpty(this.stockFreeze)) { |
| | | return ""; |
| | | } |
| | | return this.stockFreeze == 1 ? "正常" : "冻结"; |