| | |
| | | AgvWrkMast agvWrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("source_loc_no", param.get("loc_no"))); |
| | | String orderNo = null; |
| | | if (agvWrkMast != null) { |
| | | List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectByWrkNo(agvWrkMast.getWrkNo()); |
| | | //List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectByWrkNo(agvWrkMast.getWrkNo()); |
| | | List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectList(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", agvWrkMast.getWrkNo())); |
| | | if (!agvWrkDetls.isEmpty()) { |
| | | orderNo = agvWrkDetls.get(0).getOrderNo(); |
| | | } |
| | |
| | | } |
| | | } |
| | | for (AgvLocDetl record : agvLocDetlPage.getRecords()) { |
| | | OrderDetl orderDetl; |
| | | if (!Cools.isEmpty(orderNo)) { |
| | | orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>() |
| | | .eq("order_no", orderNo) |
| | | .eq("three_code", record.getThreeCode()) |
| | | .eq("matnr", record.getMatnr()) |
| | | .in("source", docIds)); |
| | | } else { |
| | | orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>() |
| | | .eq("three_code", record.getThreeCode()) |
| | | .eq("matnr", record.getMatnr()) |
| | | .in("source", docIds)); |
| | | } |
| | | //OrderDetl orderDetl; |
| | | // if (!Cools.isEmpty(orderNo)) { |
| | | // orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>() |
| | | // .eq("order_no", orderNo) |
| | | // .eq("three_code", record.getThreeCode()) |
| | | // .eq("matnr", record.getMatnr()) |
| | | // .in("source", docIds)); |
| | | // } else { |
| | | OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>() |
| | | .eq("three_code", record.getThreeCode()) |
| | | .eq("matnr", record.getMatnr()) |
| | | .in("source", docIds) |
| | | .orderBy("qty", false) |
| | | .orderBy("anfme", false) |
| | | .orderBy("create_time", true)); |
| | | // } |
| | | // if (orderDetl.getAnfme() - orderDetl.getQty() > 0) { |
| | | // record.setStock(orderDetl.getAnfme() - orderDetl.getQty()); |
| | | // } else { |
| | |
| | | // } |
| | | if (Cools.isEmpty(orderDetl)) { |
| | | record.setStock(0D); |
| | | // if (!Cools.isEmpty(orderNo)) { |
| | | // record.setOrderNo(orderNo); |
| | | // } |
| | | } else { |
| | | record.setStock(orderDetl.getAnfme() - orderDetl.getQty()); |
| | | record.setOrderNo(orderDetl.getOrderNo()); |