| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | | |
| | | /** |
| | |
| | | |
| | | @Autowired |
| | | private OriginRuleService originRuleService; |
| | | |
| | | @Autowired |
| | | private LocInPrintMatService locInPrintMatService; |
| | | |
| | | @Autowired |
| | | private LocOutPrintMatService locOutPrintMatService; |
| | | |
| | | @Autowired |
| | | private LocOwnerService locOwnerService; |
| | | |
| | | |
| | | |
| | |
| | | |
| | | @Override |
| | | public R manDetlOrigin(JSONObject json, User user) { |
| | | Date now = new Date(); |
| | | String jsonLocNo = (String) json.get("locNo"); //获取库位码 |
| | | String ownerName = (String) json.get("owner"); //获取拥有者 |
| | | LocOwner locOwner = locOwnerService.selectOne(new EntityWrapper<LocOwner>().eq("owner", ownerName)); |
| | | Long ownerId = locOwner.getId(); |
| | | String jsonCode = (String) json.get("code"); //获取条码 |
| | | String jsonOrigin = (String) json.get("origin"); //获取来源地 |
| | | if (Cools.isEmpty(jsonLocNo)){ |
| | | return R.error("库位号参数为空!"); |
| | | }else if (Cools.isEmpty(ownerId)){ |
| | | return R.error("拥有者参数为空!"); |
| | | }else if (Cools.isEmpty(jsonCode)){ |
| | | return R.error("条码参数为空!"); |
| | | }else if (Cools.isEmpty(jsonOrigin)){ |
| | | return R.error("来源地参数为空!"); |
| | | } |
| | | Integer jsonOwner = ownerId.intValue(); //获取拥有者 |
| | | OriginRule originRule = originRuleService.selectOne(new EntityWrapper<OriginRule>() |
| | | .eq("origin_address", jsonOrigin)); |
| | | |
| | |
| | | if (Cools.isEmpty(mat)){ |
| | | return R.error("未查询到商品信息"); |
| | | } |
| | | //增加打印档案 |
| | | LocInPrintMat locInPrintMat = new LocInPrintMat(now,user.getId(), mat.getMatnr(),jsonOriginDetl.getBatch(),jsonOriginDetl.getAnfme(),jsonLocNo,mat.getMaktx()); |
| | | locInPrintMat.setOwnerId(ownerId); |
| | | locInPrintMatService.insert(locInPrintMat); |
| | | |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonLocNo).eq("matnr", jsonOriginDetl.getMatnr()).eq("batch",date); |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonLocNo) |
| | | .eq("matnr", jsonOriginDetl.getMatnr()).eq("batch",date).eq("owner",jsonOwner); |
| | | ManLocDetl manLocDetl1 = manLocDetlService.selectOne(manLocDetlWrapper); |
| | | if(!Cools.isEmpty(manLocDetl1)){ |
| | | BigDecimal inAnfme = BigDecimal.valueOf(jsonOriginDetl.getAnfme()); |
| | |
| | | } |
| | | |
| | | }else { |
| | | Date now = new Date(); |
| | | ManLocDetl manLocDetl = new ManLocDetl(); //初始化库存实体类 |
| | | manLocDetl.sync(mat); |
| | | manLocDetl.setLocNo(node.getUuid()); |
| | |
| | | manLocDetl.setModiTime(now); |
| | | // manLocDetl.setOrderNo(waitPakin.getOrderNo()); |
| | | manLocDetl.setStockFreeze(1); |
| | | manLocDetl.setOwner(jsonOwner); |
| | | try { |
| | | Date produceTime = DateUtils.convert(manLocDetl.getBatch(),DateUtils.yyyyMMdd); |
| | | manLocDetl.setProduceTime(produceTime); |
| | | } catch (Exception e) { |
| | | manLocDetl.setProduceTime(now); |
| | | } |
| | | |
| | | if (!manLocDetlService.insert(manLocDetl)){ //数据库插入实体类信息 |
| | | return R.error("物料信息入库失败"); |
| | |
| | | |
| | | @Override |
| | | public R manDetlOrigInNo(JSONObject json, User user) { |
| | | Date now = new Date(); |
| | | String jsonLocNo = (String) json.get("locNo"); //获取库位码 |
| | | |
| | | String ownerName = (String) json.get("owner"); //获取拥有者 |
| | | LocOwner locOwner = locOwnerService.selectOne(new EntityWrapper<LocOwner>().eq("owner", ownerName)); |
| | | Long ownerId = locOwner.getId(); |
| | | if (Cools.isEmpty(jsonLocNo)){ |
| | | return R.error("库位号参数为空!"); |
| | | }else if (Cools.isEmpty(ownerId)){ |
| | | return R.error("拥有者参数为空!"); |
| | | } |
| | | Integer jsonOwner = ownerId.intValue(); //获取拥有者 |
| | | Node node = nodeService.selectOne(new EntityWrapper<Node>().eq("name", jsonLocNo)); //获取对应库位信息 |
| | | if (Cools.isEmpty(node)){ |
| | | return R.error("未查询到库位信息"); |
| | |
| | | if (Cools.isEmpty(mat)){ |
| | | return R.error("未查询到商品信息"); |
| | | } |
| | | //增加打印档案 |
| | | LocInPrintMat locInPrintMat = new LocInPrintMat(now,user.getId(), mat.getMatnr(),jsonOriginDetl.getBatch(),jsonOriginDetl.getAnfme(),jsonLocNo,mat.getMaktx()); |
| | | locInPrintMat.setOwnerId(ownerId); |
| | | locInPrintMatService.insert(locInPrintMat); |
| | | |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonLocNo).eq("matnr", jsonOriginDetl.getMatnr()).eq("batch",jsonOriginDetl.getBatch()); |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonLocNo) |
| | | .eq("matnr", jsonOriginDetl.getMatnr()).eq("batch",jsonOriginDetl.getBatch()).eq("owner",jsonOwner); |
| | | ManLocDetl manLocDetl1 = manLocDetlService.selectOne(manLocDetlWrapper); |
| | | if(!Cools.isEmpty(manLocDetl1)){ |
| | | BigDecimal inAnfme = BigDecimal.valueOf(jsonOriginDetl.getAnfme()); |
| | |
| | | } |
| | | |
| | | }else { |
| | | Date now = new Date(); |
| | | ManLocDetl manLocDetl = new ManLocDetl(); //初始化库存实体类 |
| | | manLocDetl.sync(mat); |
| | | manLocDetl.setLocNo(node.getUuid()); |
| | |
| | | manLocDetl.setCreateTime(now); |
| | | manLocDetl.setUpdateBy(user.getId()); |
| | | manLocDetl.setModiTime(now); |
| | | manLocDetl.setOwner(jsonOwner); |
| | | // manLocDetl.setOrderNo(waitPakin.getOrderNo()); |
| | | manLocDetl.setStockFreeze(1); |
| | | |
| | | try { |
| | | Date produceTime = DateUtils.convert(jsonOriginDetl.getBatch(),DateUtils.yyyyMMdd); |
| | | manLocDetl.setProduceTime(produceTime); |
| | | } catch (Exception e) { |
| | | manLocDetl.setProduceTime(now); |
| | | } |
| | | if (!manLocDetlService.insert(manLocDetl)){ //数据库插入实体类信息 |
| | | return R.error("物料信息入库失败"); |
| | | } |
| | |
| | | |
| | | @Override |
| | | public R manDetlOriginOut(JSONObject json, User user) { |
| | | String jsonLocNo = (String) json.get("locNo"); //获取库位码 |
| | | |
| | | Date now = new Date(); |
| | | JSONArray combMats = json.getJSONArray("combMats"); |
| | | List<MatPrint> matPrintList=new ArrayList<>(); |
| | | List<Long> ids=new ArrayList<>(); |
| | | for (int i = 0; i < combMats.size(); i++) { |
| | | OrderDetl jsonOriginDetl = combMats.getObject(i, OrderDetl.class); |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonLocNo).eq("matnr", jsonOriginDetl.getMatnr()).eq("batch", jsonOriginDetl.getBatch()); |
| | | MatPrint matPrintNow = combMats.getObject(i, MatPrint.class); |
| | | if (!ids.contains(matPrintNow.getIndex())){ |
| | | ids.add(matPrintNow.getIndex()); |
| | | matPrintList.add(matPrintNow); |
| | | } |
| | | } |
| | | for (MatPrint jsonOriginDetl:matPrintList) { |
| | | Double parseLong = jsonOriginDetl.getAnfme(); |
| | | Long ownerId = Long.parseLong(jsonOriginDetl.getOwner()); |
| | | jsonOriginDetl.setOwnerId(ownerId); |
| | | Wrapper<ManLocDetl> manLocDetlWrapper = new EntityWrapper<ManLocDetl>().eq("loc_no", jsonOriginDetl.getLocNo()) |
| | | .eq("matnr", jsonOriginDetl.getMatnr()).eq("batch", jsonOriginDetl.getBatch()).eq("owner",jsonOriginDetl.getOwnerId()); |
| | | ManLocDetl manLocDetl = manLocDetlService.selectOne(manLocDetlWrapper); |
| | | if (Cools.isEmpty(manLocDetl)){ |
| | | return R.error("未商品明细信息!库位号:"+jsonLocNo+";商品编号:"+jsonOriginDetl.getMatnr()+"批次:"+jsonOriginDetl.getBatch()); |
| | | return R.error("未查询到商品明细信息!库位号:"+jsonOriginDetl.getLocNo()+";商品编号:"+jsonOriginDetl.getMatnr()+"批次:"+jsonOriginDetl.getBatch()+"货主"+jsonOriginDetl.getOwnerId()); |
| | | } |
| | | BigDecimal outAnfme = BigDecimal.valueOf(jsonOriginDetl.getAnfme()); |
| | | BigDecimal outAnfme = BigDecimal.valueOf(parseLong); |
| | | BigDecimal anfme = BigDecimal.valueOf(manLocDetl.getAnfme()); |
| | | |
| | | if (manLocDetl.getAnfme() > jsonOriginDetl.getAnfme()){ |
| | | if (manLocDetl.getAnfme() > parseLong){ |
| | | BigDecimal num = anfme.subtract(outAnfme); |
| | | manLocDetl.setAnfme(num.doubleValue()); |
| | | |
| | | |
| | | manLocDetl.setUpdateBy(user.getId()); |
| | | manLocDetl.setModiTime(now); |
| | | if (!manLocDetlService.update(manLocDetl,manLocDetlWrapper)) { |
| | | return R.error("物料信息下架失败"); |
| | | } |
| | |
| | | return R.error("物料信息删除失败"); |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | for (MatPrint jsonOriginDetl:matPrintList) { |
| | | //增加打印档案 |
| | | LocOutPrintMat locOutPrintMat = new LocOutPrintMat(now, user.getId(), jsonOriginDetl.getMatnr(), jsonOriginDetl.getBatch(), jsonOriginDetl.getAnfme(), jsonOriginDetl.getLocNo(), jsonOriginDetl.getMaktx()); |
| | | locOutPrintMat.setOwnerId(jsonOriginDetl.getOwnerId()); |
| | | locOutPrintMatService.insert(locOutPrintMat); |
| | | } |
| | | return R.ok(); |
| | | } |