From 6b2ade5c76b1b59d30060935d4c8c3c5e78b945b Mon Sep 17 00:00:00 2001 From: whycq <913841844@qq.com> Date: 星期二, 24 九月 2024 15:33:54 +0800 Subject: [PATCH] * --- src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java | 34 ++++++++++++++++++++++++++++++++-- 1 files changed, 32 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java index 9453e7a..104572f 100644 --- a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java @@ -60,13 +60,19 @@ } - public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq) { + public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq,String type) { //鏍规嵁鐗╂枡鍙峰拰鎵规鎵惧埌瀵瑰簲鐨勫簱瀛橈紝骞朵笖鎸夌収淇敼鏃堕棿鎺掑簭 Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).orderBy("modi_time"); - + if (type != null) { + wrapper.notLike("loc_no", "F1"); + } wapperSetCondition(wrapper,"batch",batch); wapperSetCondition(wrapper,"three_code",csocode); wapperSetCondition(wrapper,"dead_time",isoseq); + + if ("JG".equals(orderNo.substring(0,2))) { + wapperSetCondition(wrapper,"process_sts","1"); + } List<AgvLocDetl> agvLocDetls = this.selectList(wrapper); @@ -129,8 +135,18 @@ } @Override + public Double getSumAnfmeProcessed(String matnr, String threeCode) { + return this.baseMapper.selectSumAnfmeByMatnrProcessed(matnr, threeCode); + } + + @Override public Double getSumAnfmeDb(String matnr, String threeCode,Integer floor) { return this.baseMapper.selectSumAnfmeByMatnr2(matnr, threeCode, floor); + } + + @Override + public Double getSumAnfmeback(String matnr, String threeCode,Integer floor) { + return this.baseMapper.getSumAnfmeback(matnr, threeCode, floor); } /* @@ -181,6 +197,20 @@ } } + public boolean updateAnfmeProcess(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode, Integer process) { + EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); + 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 { + AgvLocDetl agvLocDetl = this.selectOne(wrapper); + agvLocDetl.setAnfme(anfme); + agvLocDetl.setModiTime(new Date()); + return this.baseMapper.updateAnfmeProcess(locNo,anfme,matnr,batch,csocode,isocode,process) > 0; + } + } + private void wapperSetCondition(Wrapper wrapper,String column, String condition){ if(Cools.isEmpty(condition)){ -- Gitblit v1.9.1