| | |
| | | |
| | | |
| | | if (!Cools.isEmpty(mat.getStoreMaxDate())) { |
| | | if (Cools.isEmpty(locDetl.getBatch())) { |
| | | continue; |
| | | } else if (locDetl.getBatch().length() != 8) { |
| | | continue; |
| | | } |
| | | // if (Cools.isEmpty(locDetl.getBatch())) { |
| | | // continue; |
| | | // } else if (locDetl.getBatch().length() != 8) { |
| | | // continue; |
| | | // } |
| | | try { |
| | | SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); |
| | | Date maxDate = simple.parse(locDetl.getBatch()); |
| | | // SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); |
| | | // Date maxDate = simple.parse(locDetl.getBatch()); |
| | | Date maxDate = locDetl.getModiTime(); |
| | | Calendar calendar = new GregorianCalendar(); |
| | | calendar.setTime(maxDate); |
| | | // 把日期往后增加一天,整数 往后推,负数往前移动 |
| | |
| | | abnormalLocDetlParam.setSpecs(mat.getSpecs()); |
| | | abnormalLocDetlParam.setBatch(locDetl.getBatch()); |
| | | if (now.compareTo(maxDate) > 0) { |
| | | long difference = (now.getTime() - maxDate.getTime()) / (24 * 60 * 60 * 1000); |
| | | long difference = (now.getTime() - locDetl.getModiTime().getTime()) / (24 * 60 * 60 * 1000); |
| | | abnormalLocDetlParam.setNowTime(Integer.parseInt(String.valueOf(difference))); |
| | | result.add(abnormalLocDetlParam); |
| | | } |
| | |
| | | @RequestParam(required = false)String orderByType, |
| | | @RequestParam Map<String, Object> param){ |
| | | EntityWrapper<OrderLog> wrapper = new EntityWrapper<>(); |
| | | wrapper.orderBy("create_time"); |
| | | excludeTrash(param); |
| | | convert(param, wrapper); |
| | | if (!Cools.isEmpty(orderByField)){ |
| | |
| | | if (wrkDetls.get(0).getOrderNo() != null) { |
| | | for (WrkDetl wrkDetl : wrkDetls) { |
| | | String orderNo$ = ""; |
| | | JSON.parseArray(wrkDetl.getOrderNo(), DetlDto.class).forEach(detlDto -> { |
| | | resultRecords.add(detlDto.getOrderNo()); |
| | | }); |
| | | if(!wrkDetl.getOrderNo().startsWith("[") || !wrkDetl.getOrderNo().endsWith("]")) { |
| | | return wrkDetl.getOrderNo(); |
| | | } else { |
| | | JSON.parseArray(wrkDetl.getOrderNo(), DetlDto.class).forEach(detlDto -> { |
| | | resultRecords.add(detlDto.getOrderNo()); |
| | | }); |
| | | } |
| | | } |
| | | |
| | | } |
| | |
| | | add(zerofill(String.valueOf(3), 2) + locNo.substring(2)); |
| | | }}; |
| | | case 3: |
| | | return new ArrayList<>(); |
| | | case 4: |
| | | return new ArrayList<>(); |
| | | case 5: |
| | | return new ArrayList<String>() {{ |
| | | add(zerofill(String.valueOf(4), 2) + locNo.substring(2)); |
| | |
| | | add(zerofill(String.valueOf(11), 2) + locNo.substring(2)); |
| | | }}; |
| | | case 11: |
| | | return new ArrayList<>(); |
| | | case 12: |
| | | return new ArrayList<>(); |
| | | case 13: |
| | | return new ArrayList<String>() {{ |
| | | add(zerofill(String.valueOf(12), 2) + locNo.substring(2)); |
| | |
| | | add(zerofill(String.valueOf(18), 2) + locNo.substring(2)); |
| | | }}; |
| | | case 18: |
| | | return new ArrayList<>(); |
| | | case 19: |
| | | return new ArrayList<>(); |
| | | case 20: |
| | | return new ArrayList<String>() {{ |
| | | add(zerofill(String.valueOf(19), 2) + locNo.substring(2)); |
| | |
| | | , a.loc_no as locNo |
| | | , a.batch |
| | | , a.anfme |
| | | , a.modi_time as modiTime |
| | | from asr_loc_detl a |
| | | where 1=1 |
| | | and batch!='' and batch is not null |
| | | <include refid="stockOutCondition"></include> |
| | | group by a.matnr,a.batch,a.anfme, a.loc_no |
| | | group by a.matnr,a.batch,a.anfme, a.loc_no, a.modi_time |
| | | ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) |
| | | </select> |
| | | |
| | |
| | | <!-- </div>--> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off"> |
| | | <input class="layui-input" type="text" name="owner" placeholder="请输入" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline">  |
| | |
| | | <div class="layui-row"> |
| | | <div class="layui-col-md12"> |
| | | <div class="layui-form-item"> |
| | | <label class="layui-form-label layui-form-required">: </label> |
| | | <label class="layui-form-label layui-form-required">客户信息: </label> |
| | | <div class="layui-input-block"> |
| | | <input class="layui-input" name="owner" placeholder="请输入" lay-vertype="tips" lay-verify="required"> |
| | | </div> |