| | |
| | | .where("loc_no like '" + row + "%'"); |
| | | } |
| | | List<LocDetl> list = locDetlService.selectList(wrapper); |
| | | List<AbnormalLocDetlParam> result = new ArrayList<>(); |
| | | List<LocDetl> result = new ArrayList<>(); |
| | | |
| | | Page<LocDetl> groupLocDetl = locDetlService.getStockStatis2(toPage(1, 10000, param, LocDetl.class)); |
| | | for (LocDetl locDetl : groupLocDetl.getRecords()) { |
| | | AbnormalLocDetlParam abnormalLocDetlParam = new AbnormalLocDetlParam(); |
| | | Mat mat = matService.selectOne(new EntityWrapper<Mat>() |
| | | .eq("matnr", locDetl.getMatnr())); |
| | | if (Cools.isEmpty(mat)) { |
| | | continue; |
| | | } |
| | | if (!Cools.isEmpty(mat .getStoreMax()) || !Cools.isEmpty(mat.getStoreMin())) { |
| | | abnormalLocDetlParam.setStoreMax(mat.getStoreMax()); |
| | | abnormalLocDetlParam.setStoreMaxDate(mat.getStoreMaxDate()); |
| | | abnormalLocDetlParam.setStoreMin(mat.getStoreMin()); |
| | | abnormalLocDetlParam.setAnfme(locDetl.getAnfme()); |
| | | abnormalLocDetlParam.setMaktx(mat.getMaktx()); |
| | | abnormalLocDetlParam.setMatnr(mat.getMatnr()); |
| | | abnormalLocDetlParam.setSpecs(mat.getSpecs()); |
| | | abnormalLocDetlParam.setBatch(locDetl.getBatch()); |
| | | |
| | | // for (LocDetl locDetl : groupLocDetl.getRecords()) { |
| | | for (LocDetl locDetl : list) { |
| | | // AbnormalLocDetlParam abnormalLocDetlParam = new AbnormalLocDetlParam(); |
| | | // Mat mat = matService.selectOne(new EntityWrapper<Mat>() |
| | | // .eq("matnr", locDetl.getMatnr())); |
| | | // if (Cools.isEmpty(mat)) { |
| | | // continue; |
| | | // } |
| | | // if (!Cools.isEmpty(mat.getStoreMax()) || !Cools.isEmpty(mat.getStoreMin())) { |
| | | // abnormalLocDetlParam.setStoreMax(mat.getStoreMax()); |
| | | // abnormalLocDetlParam.setStoreMaxDate(mat.getStoreMaxDate()); |
| | | // abnormalLocDetlParam.setStoreMin(mat.getStoreMin()); |
| | | // abnormalLocDetlParam.setAnfme(locDetl.getAnfme());//数量 |
| | | // abnormalLocDetlParam.setMaktx(mat.getMaktx());//商品名称 |
| | | // abnormalLocDetlParam.setMatnr(mat.getMatnr());//商品编号 |
| | | // abnormalLocDetlParam.setSpecs(mat.getSpecs()); |
| | | // abnormalLocDetlParam.setBatch(locDetl.getBatch()); |
| | | // abnormalLocDetlParam.setLocNo(locDetl.getLocNo());//库位号 |
| | | // abnormalLocDetlParam.setZpallet(locDetl.getZpallet());//托盘条码 |
| | | // abnormalLocDetlParam.setBarcode(locDetl.getStandby2());//条码upc |
| | | // abnormalLocDetlParam.setUnit(locDetl.getStandby1());//客户po |
| | | // abnormalLocDetlParam.setSku(locDetl.getSku());//客户sku |
| | | // abnormalLocDetlParam.setSupp(locDetl.getSupp());//供应商 |
| | | // abnormalLocDetlParam.setManu(locDetl.getBoxType1());//货主 |
| | | // abnormalLocDetlParam.setOrderNo(locDetl.getOrderNo());//采购单号 |
| | | // abnormalLocDetlParam.setMemo(locDetl.getMemo());//备注 |
| | | // abnormalLocDetlParam.setModiTime(locDetl.getModiTime());//修改时间 |
| | | // SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); |
| | | // Date maxDate = simple.parse(locDetl.getBatch()); |
| | | // long time = maxDate.getTime(); |
| | |
| | | // long time1 = now.getTime(); |
| | | // abnormalLocDetlParam.setNowTime((int) ((time1 - time) / (1000 * 60 * 60 * 24))); |
| | | |
| | | if (!Cools.isEmpty(mat.getStoreMax()) && locDetl.getAnfme() > mat.getStoreMax()) { |
| | | result.add(abnormalLocDetlParam); |
| | | } else if (!Cools.isEmpty(mat.getStoreMin()) && locDetl.getAnfme() < mat.getStoreMin()) { |
| | | result.add(abnormalLocDetlParam); |
| | | } |
| | | } |
| | | // if (!Cools.isEmpty(mat.getStoreMax()) && locDetl.getAnfme() > mat.getStoreMax()) { |
| | | result.add(locDetl); |
| | | // } else if (!Cools.isEmpty(mat.getStoreMin()) && locDetl.getAnfme() < mat.getStoreMin()) { |
| | | // result.add(abnormalLocDetlParam); |
| | | // } |
| | | // } |
| | | } |
| | | return R.ok(exportSupport(result, fields)); |
| | | } |