1.修复历史档没有源站点和目标站点
2.修复库存明细搜索栏
3.修复手动入库给出库完成任务标记
| | |
| | | private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ |
| | | for (Map.Entry<String, Object> entry : map.entrySet()){ |
| | | String val = String.valueOf(entry.getValue()); |
| | | String key = humpToLine(entry.getKey()); |
| | | if (val.contains(RANGE_TIME_LINK)){ |
| | | String[] dates = val.split(RANGE_TIME_LINK); |
| | | wrapper.ge(entry.getKey(), DateUtils.convert(dates[0])); |
| | | wrapper.le(entry.getKey(), DateUtils.convert(dates[1])); |
| | | wrapper.ge(key, DateUtils.convert(dates[0])); |
| | | wrapper.le(key, DateUtils.convert(dates[1])); |
| | | } else { |
| | | if (entry.getKey().equals("locNo")) { |
| | | if ("loc_no".equals(key)) { |
| | | wrapper.eq("loc_no", String.valueOf(entry.getValue())); |
| | | } else { |
| | | wrapper.like(entry.getKey(), String.valueOf(entry.getValue())); |
| | | wrapper.like(key, String.valueOf(entry.getValue())); |
| | | } |
| | | } |
| | | } |
| | |
| | | private String locNo; |
| | | |
| | | @ApiModelProperty("area_id") |
| | | @TableField("area_id") |
| | | private Long areaId; |
| | | |
| | | @ApiModelProperty("area_name") |
| | | @TableField("area_name") |
| | | private String areaName; |
| | | |
| | | @ApiModelProperty(value= "托盘条码") |
| | |
| | | */ |
| | | @ApiModelProperty(value= "目标站") |
| | | @TableField("sta_no") |
| | | private Integer staNo; |
| | | private String staNo; |
| | | |
| | | /** |
| | | * 源站 |
| | | */ |
| | | @ApiModelProperty(value= "源站") |
| | | @TableField("source_sta_no") |
| | | private Integer sourceStaNo; |
| | | private String sourceStaNo; |
| | | |
| | | /** |
| | | * 源库位 |
| | |
| | | |
| | | public TaskLog() {} |
| | | |
| | | public TaskLog(Long id,Integer wrkNo,Long logId,String invWh,Date ymd,String mk,Integer whsType,Integer wrkSts,Integer ioType,Integer crnNo,String sheetNo,Double ioPri,Date wrkDate,String locNo,Integer staNo,Integer sourceStaNo,String sourceLocNo,String locSts,String picking,String linkMis,String onlineYn,String updMk,String exitMk,Integer pltType,String emptyMk,Date ioTime,Integer ctnType,String packed,String oveMk,Double mtnType,String userNo,Date crnStrTime,Date crnEndTime,Date plcStrTime,Date crnPosTime,Double loadTime,Double expTime,Double refWrkno,Date refIotime,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String pauseMk,Date errorTime,String errorMemo,Integer ctnKind,String manuType,String memoM,Double scWeight,String logMk,Date logErrTime,String logErrMemo,String barcode,String PdcType,String ctnNo,String fullPlt,String preHave,String takeNone,Long lineNumber) { |
| | | public TaskLog(Long id,Integer wrkNo,Long logId,String invWh,Date ymd,String mk,Integer whsType,Integer wrkSts,Integer ioType,Integer crnNo,String sheetNo,Double ioPri,Date wrkDate,String locNo,String staNo,String sourceStaNo,String sourceLocNo,String locSts,String picking,String linkMis,String onlineYn,String updMk,String exitMk,Integer pltType,String emptyMk,Date ioTime,Integer ctnType,String packed,String oveMk,Double mtnType,String userNo,Date crnStrTime,Date crnEndTime,Date plcStrTime,Date crnPosTime,Double loadTime,Double expTime,Double refWrkno,Date refIotime,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String pauseMk,Date errorTime,String errorMemo,Integer ctnKind,String manuType,String memoM,Double scWeight,String logMk,Date logErrTime,String logErrMemo,String barcode,String PdcType,String ctnNo,String fullPlt,String preHave,String takeNone,Long lineNumber) { |
| | | this.id = id; |
| | | this.wrkNo = wrkNo; |
| | | this.logId = logId; |
| | |
| | | } |
| | | |
| | | public String getStaNo$(){ |
| | | BasDevpService service = SpringUtils.getBean(BasDevpService.class); |
| | | BasDevp basDevp = service.selectById(this.staNo); |
| | | if (!Cools.isEmpty(basDevp)){ |
| | | return String.valueOf(basDevp.getDevNo()); |
| | | } |
| | | if (Cools.isEmpty(this.staNo)) { |
| | | return null; |
| | | } |
| | | return this.staNo; |
| | | } |
| | | |
| | | public String getSourceStaNo$(){ |
| | | BasDevpService service = SpringUtils.getBean(BasDevpService.class); |
| | | BasDevp basDevp = service.selectById(this.sourceStaNo); |
| | | if (!Cools.isEmpty(basDevp)){ |
| | | return String.valueOf(basDevp.getDevNo()); |
| | | } |
| | | if (Cools.isEmpty(this.sourceStaNo)) { |
| | | return null; |
| | | } |
| | | return this.sourceStaNo; |
| | | } |
| | | |
| | | public String getSourceLocNo$(){ |
| | | LocMastService service = SpringUtils.getBean(LocMastService.class); |
| | |
| | | */ |
| | | @ApiModelProperty(value = "目标站") |
| | | @TableField("sta_no") |
| | | private Integer staNo; |
| | | private String staNo; |
| | | |
| | | /** |
| | | * 源站 |
| | | */ |
| | | @ApiModelProperty(value = "源站") |
| | | @TableField("source_sta_no") |
| | | private Integer sourceStaNo; |
| | | private String sourceStaNo; |
| | | |
| | | /** |
| | | * 源库位 |
| | |
| | | } |
| | | |
| | | public String getStaNo$() { |
| | | BasDevpService service = SpringUtils.getBean(BasDevpService.class); |
| | | BasDevp basDevp = service.selectById(this.staNo); |
| | | if (!Cools.isEmpty(basDevp)) { |
| | | return String.valueOf(basDevp.getDevNo()); |
| | | } |
| | | if (Cools.isEmpty(this.staNo)) { |
| | | return null; |
| | | } |
| | | return this.staNo; |
| | | } |
| | | |
| | | public String getSourceStaNo$() { |
| | | BasDevpService service = SpringUtils.getBean(BasDevpService.class); |
| | | BasDevp basDevp = service.selectById(this.sourceStaNo); |
| | | if (!Cools.isEmpty(basDevp)) { |
| | | return String.valueOf(basDevp.getDevNo()); |
| | | } |
| | | if (Cools.isEmpty(this.sourceStaNo)) { |
| | | return null; |
| | | } |
| | | return this.sourceStaNo; |
| | | } |
| | | |
| | | public String getSourceLocNo$() { |
| | | LocMastService service = SpringUtils.getBean(LocMastService.class); |
| | |
| | | } |
| | | TaskLog taskLog = new TaskLog(); |
| | | BeanUtils.copyProperties(task, taskLog); |
| | | if (task.getWrkSts() != null) { |
| | | taskLog.setWrkSts(task.getWrkSts().intValue()); |
| | | } |
| | | taskLog.setLogId(task.getId()); |
| | | |
| | | if (!this.insert(taskLog)) { |
| | | throw new CoolException("任务日志保存失败!!"); |
| | | } |
| | | |
| | | return false; |
| | | return true; |
| | | } |
| | | } |
| | |
| | | // 入库 + 库位转移 |
| | | if (wrkMast.getWrkSts() < 4 || (wrkMast.getWrkSts() > 10 && wrkMast.getIoType() == 11)) { |
| | | wrkMast.setWrkSts(4L); |
| | | WrkMast mast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("barcode", wrkMast.getBarcode()).eq("wrk_sts",15L)); |
| | | if (!Cools.isEmpty(wrkMast)) { |
| | | mast.setOveMk("Y"); |
| | | wrkMast.setModiTime(new Date()); |
| | | wrkMastService.updateById(mast); |
| | | } |
| | | // 出库 |
| | | } else if (wrkMast.getWrkSts() > 10) { |
| | | wrkMast.setWrkSts(14L); |
| | |
| | | left join asr_loc_mast b on a.loc_no = b.loc_no |
| | | where 1=1 |
| | | and b.loc_sts = 'F' |
| | | and (b.whs_type is null or b.whs_type <> 2) |
| | | <include refid="stockOutCondition"></include> |
| | | ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) |
| | | </select> |
| | |
| | | left join asr_loc_mast b on a.loc_no = b.loc_no |
| | | where 1=1 |
| | | and b.loc_sts = 'F' |
| | | and (b.whs_type is null or b.whs_type <> 2) |
| | | <include refid="stockOutCondition"></include> |
| | | </select> |
| | | |