| | |
| | | |
| | | public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq) { |
| | | //根据物料号和批次找到对应的库存,并且按照修改时间排序 |
| | | Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).orderBy("modi_time"); |
| | | Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).orderBy("appe_time"); |
| | | |
| | | wapperSetCondition(wrapper,"batch",batch); |
| | | wapperSetCondition(wrapper,"three_code",csocode); |
| | |
| | | double anfme = agvLocDetl.getAnfme(); |
| | | //int ioType = anfme > issued ? 101 : 103; |
| | | anfme = anfme > issued ? issued : anfme; |
| | | LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNo, anfme); |
| | | //用于显示工作明细档的订单号 |
| | | String orderNoWrkDtel = Utils.getOrderNo(orderNo,anfme); |
| | | //更新订单数量 |
| | | orderNo = Utils.orderMergeUpdate(orderNo,anfme); |
| | | LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNoWrkDtel, anfme); |
| | | locDto.setCsocode(csocode); |
| | | locDto.setIsoseq(isoseq); |
| | | locDto.setContainerCode(agvLocDetl.getSuppCode()); |
| | |
| | | |
| | | public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode) { |
| | | EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); |
| | | Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode); |
| | | wrapper.eq("loc_no", locNo); |
| | | Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode); |
| | | if (anfme <= 0) { |
| | | return this.baseMapper.deleteLocDetl(locNo,anfme,matnr,batch,csocode,isocode) > 0; |
| | | } else { |
| | |
| | | if(Cools.isEmpty(condition)){ |
| | | wrapper.andNew().eq(column,"").or().isNull(column); |
| | | }else { |
| | | wrapper.eq(column,condition); |
| | | wrapper.andNew().eq(column,condition); |
| | | } |
| | | } |
| | | |
| | |
| | | @Override |
| | | public Double selectSumAnfmeByLocNo(String locNo) { |
| | | return this.baseMapper.sumByLocNo(locNo); |
| | | } |
| | | |
| | | @Override |
| | | public Double selectSumAnfmeByMatnr(String matnr) { |
| | | return this.baseMapper.sumByMatnr(matnr); |
| | | } |
| | | |
| | | @Override |
| | |
| | | log.info("库位号:" + locNo + ",容器码:" + containerCode + ",不存在明细"); |
| | | } |
| | | if(agvLocDetls.size()>1){ |
| | | log.info("库位号:" + locNo + ",容器码:" + containerCode + ",存在1条以上记录"); |
| | | //log.info("库位号:" + locNo + ",容器码:" + containerCode + ",存在1条以上记录"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public int updateNewMatnr(String matnrOld, String matnrNew) { |
| | | return this.baseMapper.updateNewMatnr(matnrOld, matnrNew); |
| | | } |
| | | } |