package com.zy.asrs.service.impl; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.core.common.BaseRes; import com.core.common.Cools; import com.core.common.DateUtils; import com.core.common.R; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.*; import com.zy.asrs.mapper.ManLocDetlMapper; import com.zy.asrs.service.*; import com.zy.asrs.utils.SaasUtils; import com.zy.asrs.utils.Utils; import com.zy.common.model.DetlDto; import com.zy.common.service.CommonService; import com.zy.common.utils.Synchro; import com.zy.system.entity.User; import com.zy.system.service.SaasLogService; import lombok.Synchronized; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.Iterator; import java.util.List; /** * 移动端服务核心类 * Created by vincent on 2020/6/28 */ @Slf4j @Service public class MobileServiceImpl implements MobileService { @Autowired private MatService matService; @Autowired private WaitPakinService waitPakinService; @Autowired private OrderService orderService; @Autowired private OrderDetlService orderDetlService; @Autowired private BasDevpService basDevpService; @Autowired private WrkMastService wrkMastService; @Autowired private WrkDetlService wrkDetlService; @Autowired private PackService packService; @Autowired private OpenService openService; @Autowired private DocTypeService docTypeService; @Autowired private ManPakOutService manPakOutService; @Autowired private BasCrnpService basCrnpService; @Autowired private LocMastService locMastService; @Autowired private LocDetlService locDetlService; @Autowired private StaDescService staDescService; @Autowired private CommonService commonService; @Autowired private NodeService nodeService; @Autowired private ManLocDetlService manLocDetlService; @Autowired private ManLocDetlMapper manLocDetlMapper; @Autowired private WaitPakinLogService waitPakinLogService; @Autowired private LocCheckService locCheckService; @Autowired private OrderCheckService orderCheckService; @Autowired private OriginRuleService originRuleService; @Autowired private LocInPrintMatService locInPrintMatService; @Autowired private LocOutPrintMatService locOutPrintMatService; @Autowired private LocOwnerService locOwnerService; @Autowired private PlaService plaService; @Autowired private PlaQtyService plaQtyService; @Autowired private SaasLogService saasLogService; @Override @Transactional public void comb(CombParam param, Long userId) { if (Cools.isEmpty(param.getBarcode(), param.getCombMats())) { throw new CoolException(BaseRes.PARAM); } // if (Cools.isEmpty(param.getBarcode())){ // throw new CoolException("请填写货主信息"); // } // 判断是否有相同条码的数据 if (waitPakinService.selectCount(new EntityWrapper(). eq("zpallet", param.getBarcode()).eq("io_status", "N")) > 0) { throw new CoolException(param.getBarcode() + "数据正在进行入库"); } try{ param.setOrderNo(param.getCombMats().get(0).getOrderNo()); }catch (Exception e){ } int countLoc = locDetlService.selectCount(new EntityWrapper().eq("zpallet",param.getBarcode())); WrkMast wrkMast = wrkMastService.selectByBarcode(param.getBarcode()); if (wrkMast != null && wrkMast.getIoType() < 100){ throw new CoolException("工作档/库存条码数据已存在===>>" + param.getBarcode()); } if (countLoc > 0 ) { throw new CoolException("工作档/库存条码数据已存在===>>" + param.getBarcode()); } //设置非null批号, for (CombParam.CombMat combMat : param.getCombMats()) { if (combMat.getBatch() == null){ combMat.setBatch(""); } } Date now = new Date(); // 无单组托 if (Cools.isEmpty(param.getOrderNo())) { // 生成入库通知档 List detlDtos = new ArrayList<>(); param.getCombMats().forEach(elem -> { DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme(),elem.getWeight()); if (DetlDto.has(detlDtos, detlDto)) { DetlDto one = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch()); assert one != null; one.setAnfme(one.getAnfme() + detlDto.getAnfme()); one.setOwner(detlDto.getOwner()); } else { detlDtos.add(detlDto); } }); for (DetlDto detlDto : detlDtos) { String uuid = String.valueOf(System.currentTimeMillis()); Mat mat = matService.selectByMatnr(detlDto.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(detlDto.getMatnr() + "商品档案不存在"); } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setBatch(detlDto.getBatch()); waitPakin.setZpallet(param.getBarcode()); // 托盘码 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme(detlDto.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); waitPakin.setOwner(detlDto.getOwner()); waitPakin.setUuid(uuid); waitPakin.setWeight(detlDto.getWeight()); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } } // 关联组托 } else { for (CombParam.CombMat combMat : param.getCombMats()) { OrderDetl orderDetl = orderDetlService.selectItem(combMat.getOrderNo(), combMat.getMatnr(), combMat.getBatch()); if (orderDetl == null) { throw new CoolException("找不到组托的单据明细"); } Double anfme = orderDetl.getAnfme(); Double workQty = orderDetl.getWorkQty(); BigDecimal a1 = new BigDecimal(orderDetl.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal b1 = new BigDecimal(orderDetl.getWorkQty()).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal c1 = new BigDecimal(combMat.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP); double e1 = b1.add(c1).doubleValue(); BigDecimal f1 = new BigDecimal(e1).setScale(2,BigDecimal.ROUND_HALF_UP); Double d1 = a1.subtract(f1).doubleValue(); if ( d1 < 0.0) { throw new CoolException("组托数量已超出订单需求量,请检查是否有其他的组托已完成"); } } // 生成入库通知档 List detlDtos = new ArrayList<>(); for (CombParam.CombMat elem : param.getCombMats()) { Order order = orderService.selectByNo(elem.getOrderNo()); if (order.getSettle() > 2) { throw new CoolException("单据编号已过期"); } // 订单明细数量校验 OrderDetl orderDetl = orderDetlService.selectItem(order.getId(), elem.getMatnr(), elem.getBatch()); if(orderDetl == null){ throw new CoolException("该单据中不存在该物料明细:" + elem); } if (elem.getAnfme() > orderDetl.getEnableQty()) { throw new CoolException(orderDetl.getMatnr() + "入库数量不合法"); } // 修改订单作业数量 if (!orderDetlService.increaseWorkQty(order.getId(), elem.getMatnr(), elem.getBatch(), elem.getAnfme())) { throw new CoolException("修改单据作业数量失败"); } DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme(),elem.getWeight()); if (DetlDto.has(detlDtos, detlDto)) { DetlDto one = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch()); assert one != null; one.setAnfme(one.getAnfme() + detlDto.getAnfme()); } else { detlDtos.add(detlDto); } } int i=0; for (DetlDto detlDto : detlDtos) { Order order = orderService.selectByNo(param.getCombMats().get(i).getOrderNo()); i++; String uuid = String.valueOf(System.currentTimeMillis()); Mat mat = matService.selectByMatnr(detlDto.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(detlDto.getMatnr() + "商品档案不存在"); } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setOrderNo(order.getOrderNo()); // 单据编号 waitPakin.setBatch(detlDto.getBatch()); // 序列码 waitPakin.setZpallet(param.getBarcode()); // 托盘码 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme(detlDto.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); waitPakin.setOwner(detlDto.getOwner()); waitPakin.setPayment(detlDto.getPayment()); waitPakin.setUuid(uuid); waitPakin.setWeight(detlDto.getWeight()); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } orderService.updateSettle(order.getId(), 2L, userId); } } } // 商品上架 @Override public void onSale(CombParam param) { Date now = new Date(); // 获取库位号 String locno = param.getLocno(); Node node = nodeService.selectByUuid(locno); if (Cools.isEmpty(node)) { throw new CoolException(param.getLocno() + ":库位不存在"); } // 获取商品列表 for(CombParam.CombMat combMat : param.getCombMats()){ Mat mat = matService.selectByMatnr(combMat.getMatnr()); if (Cools.isEmpty(mat)){ throw new CoolException(combMat.getMatnr() + ":商品档案不存在!"); } if (Cools.isEmpty(combMat.getAnfme()) || combMat.getAnfme()==0){ throw new CoolException(combMat.getMatnr() + ":商品数量有误!"); } if (Cools.isEmpty(combMat.getBatch())){ // throw new CoolException(combMat.getMatnr() + ":商品批号有误!"); } ManLocDetl manLocDetl = new ManLocDetl(); manLocDetl.setLocNo(locno); manLocDetl.setNodeId(node.getId()); manLocDetl.setMaktx(mat.getMaktx()); manLocDetl.setMatnr(mat.getMatnr()); manLocDetl.setBatch(Cools.isEmpty(combMat.getBatch()) ? "" : combMat.getBatch()); manLocDetl.setAnfme(combMat.getAnfme()); manLocDetl.setModiTime(now); manLocDetl.setOwner(1); if (!manLocDetlService.insert(manLocDetl)) { throw new CoolException("商品上架失败!"); } } } // 商品下架 @Override public void offSale(OffSaleParam offSaleParam) { ManLocDetl manLocDetl = manLocDetlMapper.selectLocNo0(offSaleParam.getLocNo(), offSaleParam.getMatnr()); if (Cools.isEmpty(manLocDetl)){ throw new CoolException("无此商品!"); } double anfme = manLocDetl.getAnfme() - offSaleParam.getAnfme(); if (anfme < 0) { throw new CoolException("商品库存不足!"); } else if (anfme == 0){ manLocDetlMapper.deleteLocNo0(offSaleParam.getLocNo(), offSaleParam.getMatnr()); } manLocDetlMapper.updateAnfme0(anfme,manLocDetl.getNodeId()); } // 查找商品 @Override @Transactional public void adjust(MobileAdjustParam param, Long userId) { BasDevp basDevp = basDevpService.selectById(param.getStaNo()); if (null == basDevp || basDevp.getWrkNo() == null) { throw new CoolException(param.getStaNo() + "盘点站无效"); } if (!param.getWrkNo().equals(basDevp.getWrkNo())) { throw new CoolException(param.getStaNo() + "盘点站更新,请重新检索"); } WrkMast wrkMast = wrkMastService.selectById(param.getWrkNo()); if (wrkMast.getWrkSts() < 10) { throw new CoolException("盘点无效,任务已盘点再入库"); } Date now = new Date(); List wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()); List list = param.getWrkDetls(); // 修改数量 Iterator iterator = wrkDetls.iterator(); while (iterator.hasNext()) { WrkDetl wrkDetl = iterator.next(); Iterator iterator1 = list.iterator(); while (iterator1.hasNext()) { WrkDetl wrkDetl1 = iterator1.next(); if (wrkDetl1.getAnfme() == 0) { iterator1.remove(); } if (wrkDetl.getMatnr().equals(wrkDetl1.getMatnr()) && Cools.eq(wrkDetl.getBatch(), wrkDetl1.getBatch())) { if (!wrkDetl.getAnfme().equals(wrkDetl1.getAnfme())) { // todo 盘点记录、保存调整记录 // 修改明细 if (!wrkDetlService.updateAnfme(wrkDetl1.getAnfme(), wrkMast.getWrkNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { throw new CoolException(wrkMast.getWrkNo() + "盘点任务," + wrkDetl.getMatnr() + "商品," + wrkDetl.getBatch() + "批号修改数量失败"); } } iterator.remove(); iterator1.remove(); } } } // 删除明细 for (WrkDetl wrkDetl : wrkDetls) { // todo 盘点记录、保存调整记录 if (!wrkDetlService.updateAnfme(-1.0D, wrkMast.getWrkNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { throw new CoolException("删除" + wrkMast.getWrkNo() + "盘点任务," + wrkDetl.getMatnr() + "商品," + wrkDetl.getBatch() + "批号任务明细失败"); } } // 添加明细 for (WrkDetl wrkDetl : list) { if (wrkDetl.getAnfme() == 0.0D) { continue; } // todo 盘点记录、保存调整记录 String orderNo = wrkDetl.getOrderNo(); Mat mat = matService.selectByMatnr(wrkDetl.getMatnr()); wrkDetl.sync(mat); wrkDetl.setOrderNo(orderNo); wrkDetl.setModiTime(now); wrkDetl.setModiUser(userId); wrkDetl.setAppeTime(now); wrkDetl.setAppeUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("添加" + wrkMast.getWrkNo() + "盘点任务," + wrkDetl.getMatnr() + "商品," + wrkDetl.getBatch() + "批号任务明细失败"); } } // 修改盘点任务主档状态 wrkMast.setFullPlt(wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()).size() != 0?"Y":"N"); wrkMast.setModiTime(now); wrkMast.setModiUser(userId); if (!wrkMastService.updateById(wrkMast)) { throw new CoolException("修改盘点任务主档失败"); } } @Override @Transactional public void pakoutByOrder(JSONObject param, Long userId) { Integer staNo = param.containsKey("staNo") ? Integer.parseInt(param.get("staNo").toString()) : 0; String orderNo = param.containsKey("orderNo") ? param.get("orderNo").toString() : ""; BasDevp sta = basDevpService.checkSiteStatus(staNo); //根据订单号生成出库任务工作档 Order order = orderService.selectOne(new EntityWrapper().eq("order_no", orderNo)); if (order.getSettle() != 1 && order.getSettle() != 2){ throw new CoolException("该订单已处理"); } List orderDetls = orderDetlService.selectList(new EntityWrapper().eq("order_no", orderNo)); Date now = new Date(); for(OrderDetl orderDetl : orderDetls){ //查询所有库位状态为F的库位信息 List locDetls = locDetlService.queryStock(orderDetl.getMatnr(),orderDetl.getBatch(),orderDetl.getOwner()); if (locDetls.size() == 0) { throw new CoolException("库存中没有该物料"); } for(LocDetl locDetl : locDetls){ //如果该库位出库路线所用的堆垛机out_enable不为Y,跳过该循环 LocMast locMast = locMastService.selectOne(new EntityWrapper() .eq("loc_no", locDetl.getLocNo())); if (Cools.isEmpty(locMast)) { continue; } BasCrnp crn_no = basCrnpService.selectOne(new EntityWrapper() .eq("crn_no", locMast.getCrnNo())); if (Cools.isEmpty(crn_no) || !crn_no.getOutEnable().equals("Y")){ continue; } //可出库数量 = 订单数量 - 作业中数量 Double outQty = orderDetl.getAnfme() - orderDetl.getWorkQty(); if(outQty <= 0){ break; } // 判断入出库类型:101.全板出库 or 103.拣料出库 Double sumCount = locDetlService.getLocDetlSumQty(locDetl.getLocNo()); Double curOutQty = outQty >= locDetl.getAnfme() ? locDetl.getAnfme() : outQty; //本次出库量 int ioType = sumCount <= curOutQty ? 101 : 103; stockOut(orderDetl, sta, locDetl, curOutQty, ioType, userId, now); order.setSettle(2L); order.setUpdateBy(userId); order.setUpdateTime(now); if(!orderService.update(order, new EntityWrapper().eq("order_no", orderNo))){ throw new CoolException("更新订单状态失败"); } orderDetl.setWorkQty(orderDetl.getWorkQty() + curOutQty); orderDetl.setUpdateBy(userId); orderDetl.setUpdateTime(now); Wrapper wrapper = new EntityWrapper().eq("order_no", orderNo) .eq("matnr",orderDetl.getMatnr()); if(!Cools.isEmpty(orderDetl.getBatch())){ wrapper.eq("batch", orderDetl.getBatch()); } if(!orderDetlService.update(orderDetl, wrapper)){ throw new CoolException("更新订单明细失败"); } } } } @Override @Transactional public void stockOut(OrderDetl orderDetl, BasDevp staNo, LocDetl locDetl, Double curOutQty, Integer ioType, Long userId, Date now) { // 获取库位 LocMast locMast = locMastService.selectById(locDetl.getLocNo()); // 获取路径 Wrapper wrapper = new EntityWrapper() .eq("type_no", ioType) .eq("stn_no", staNo.getDevNo()) .eq("crn_no", locMast.getCrnNo()); StaDesc staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { throw new CoolException("出库路径不存在"); } // 生成工作号 int workNo = commonService.getWorkNo(2); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(now); wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID wrkMast.setIoType(ioType); // 入出库状态 wrkMast.setIoPri(13D); // 优先级:13 wrkMast.setCrnNo(locMast.getCrnNo()); wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站 wrkMast.setStaNo(staDesc.getStnNo()); // 目标站 wrkMast.setSourceLocNo(locDetl.getLocNo()); // 源库位 wrkMast.setFullPlt("Y"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setAppeUser(userId); // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiUser(userId); wrkMast.setModiTime(now); wrkMast.setBarcode(locMast.getBarcode()); if (!wrkMastService.insert(wrkMast)) { throw new CoolException("保存工作档失败,出库库位号:" + locDetl.getLocNo()); } WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(locDetl); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(now); wrkDetl.setAnfme(curOutQty); // 数量 wrkDetl.setOrderNo(orderDetl.getOrderNo()); wrkDetl.setAppeTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiTime(now); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作档明细失败"); } // 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中 locMast = locMastService.selectById(locDetl.getLocNo()); if (locMast.getLocSts().equals("F")) { locMast.setLocSts(ioType == 101 ? "R" : "P"); locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)) { throw new CoolException("预约库位状态失败,库位号:" + locDetl.getLocNo()); } } else { throw new CoolException(locDetl.getLocNo() + "库位不是在库状态"); } } @Transactional @Override public R manDetlIn(JSONObject json, User user) { Date date = new Date(); String jsonLocNo = (String) json.get("locNo"); LocMast locMast = locMastService.selectLocStatus(jsonLocNo); if (locMast.getLocSts().equals("X")){ return R.error("库位已被冻结"); } List locDetls = manLocDetlService.selectList(new EntityWrapper().eq("loc_no", jsonLocNo)); Node node = nodeService.selectOne(new EntityWrapper() .eq("name", jsonLocNo)); // if (node.getParentName().equals("A") || node.getParentName().equals("B")){ // if (node.getRow1() == 1 && locDetls.size() >=11){ // return R.error("该库位排已满"); // } // if (node.getRow1() == 6 && locDetls.size() >=4){ // return R.error("该库位排已满"); // } // if (node.getRow1() == 12 && locDetls.size() >=4){ // return R.error("该库位排已满"); // } // // } // if (locDetls.size() >=12){ // return R.error("该库位排已满"); // } JSONArray combMats = json.getJSONArray("combMats"); for (int i = 0; i < combMats.size(); i++) { OrderDetl jsonOrderDetl = combMats.getObject(i, OrderDetl.class); //查订单 Order order = orderService.selectOne(new EntityWrapper() .eq("order_no", jsonOrderDetl.getOrderNo())); if (Cools.isEmpty(node, order)) { return R.error("参数为空"); } //判断订单类型是否是入库 DocType docType=docTypeService.selectById(order.getDocType()); if(docType.getPakin()!=1 || docType.getStatus()!=1){ return R.error("该订单是出库订单,无法入库"); } OrderDetl orderDetl = orderDetlService.selectItem(jsonOrderDetl.getOrderNo(),jsonOrderDetl.getMatnr(),jsonOrderDetl.getBatch()); if (Cools.isEmpty(orderDetl)) { return R.error("单据明细有误,请检查"); } if (orderDetl.getAnfme() - (jsonOrderDetl.getAnfme() + orderDetl.getWorkQty()) < 0) { return R.error("入库数量大于可入数量"); } //查询平库中是否有一样的物料号,有的话直接增加数量 ManLocDetl checkManLocDetl = manLocDetlService.selectInventory(jsonLocNo,orderDetl.getMatnr(),jsonOrderDetl.getBatch()); if (checkManLocDetl == null) { ManLocDetl manLocDetl = new ManLocDetl(); Synchro.Copy(orderDetl, manLocDetl); manLocDetl.setLocNo(node.getName()); manLocDetl.setNodeId(node.getId()); manLocDetl.setMatnr(orderDetl.getMatnr()); manLocDetl.setMaktx(jsonOrderDetl.getMaktx()); manLocDetl.setAnfme(jsonOrderDetl.getAnfme()); manLocDetl.setModiTime(date); manLocDetl.setCreateTime(date); manLocDetl.setBatch(jsonOrderDetl.getBatch()); manLocDetl.setOwner(orderDetl.getOwner()); manLocDetl.setWeight(jsonOrderDetl.getWeight()); manLocDetl.setOrderNo(jsonOrderDetl.getOrderNo()); manLocDetl.setStockFreeze(1); if(!manLocDetlService.insert(manLocDetl)){ return R.error("插入平库物料失败!"); } } else { if (checkManLocDetl.getWeight() == null){ checkManLocDetl.setWeight(0.0); } if (jsonOrderDetl.getWeight() == null){ jsonOrderDetl.setWeight(0.0); } if(manLocDetlService.increase(checkManLocDetl.getAnfme() + jsonOrderDetl.getAnfme(), node.getName(), jsonOrderDetl.getMatnr(), jsonOrderDetl.getBatch(),checkManLocDetl.getWeight()+jsonOrderDetl.getWeight() )<=0 ){ return R.error("修改平库物料失败!"); } } orderDetl.setQty(orderDetl.getQty() + jsonOrderDetl.getAnfme()); orderDetl.setWorkQty(orderDetl.getWorkQty() + jsonOrderDetl.getAnfme()); orderDetl.setUpdateTime(date); orderDetlService.updateById(orderDetl); //更新订单状态 List orderDetls=orderDetlService.selectList(new EntityWrapper().eq("order_no",order.getOrderNo())); order.setSettle(2L); boolean log=true; for (OrderDetl orderDetl1: orderDetls) { //工作中的数量小于总订单数时,订单状态改为2,作业中 if(orderDetl1.getQty() < orderDetl.getAnfme()){ log=false; } } if(log){ order.setSettle(4L); } if(!orderService.updateById(order)){ return R.error("更新订单状态失败"); } orderService.checkComplete(order.getOrderNo()); SaasUtils.insertLog(0,jsonLocNo,jsonOrderDetl.getMatnr(), jsonOrderDetl.getAnfme(),user.getUsername(), null,null,null,null,null); } return R.ok("上架完成"); } @Transactional @Override public R manDetlOut(JSONObject json,User user) { Date date = new Date(); String jsonLocNo = (String) json.get("locNo"); LocMast locMast = locMastService.selectLocStatus(jsonLocNo); if (locMast.getLocSts().equals("X")){ return R.error("库位已被冻结"); } Node node = nodeService.selectOne(new EntityWrapper() .eq("name", jsonLocNo)); JSONArray combMats = json.getJSONArray("combMats"); for (int i = 0; i < combMats.size(); i++) { OrderDetl jsonOrderDetl = combMats.getObject(i, OrderDetl.class); Order order = orderService.selectOne(new EntityWrapper() .eq("order_no", jsonOrderDetl.getOrderNo())); //判断订单类型是否是出库 DocType docType=docTypeService.selectById(order.getDocType()); if(docType.getPakout()!=1 || docType.getStatus()!=1){ return R.error("该订单是入库订单,无法出库"); } if (Cools.isEmpty(node, order)) { return R.error("参数为空"); } OrderDetl orderDetl = orderDetlService.selectItem(jsonOrderDetl.getOrderNo(),jsonOrderDetl.getMatnr(),""); if (Cools.isEmpty(orderDetl)) { return R.error("单据明细有误,请检查"); } EntityWrapper manPakOutEntityWrapper = new EntityWrapper<>(); manPakOutEntityWrapper.eq("loc_no",jsonLocNo); manPakOutEntityWrapper.eq("matnr",jsonOrderDetl.getMatnr()); manPakOutEntityWrapper.eq("doc_num",order.getOrderNo()); ManPakOut manPakOut = manPakOutService.selectOne(manPakOutEntityWrapper); //获取拣货单中的对应的订单 if(Cools.isEmpty(manPakOut)){ return R.error("没有找到对应的出库单"+jsonLocNo+"-------"+jsonOrderDetl.getMatnr()); } if(manPakOut.getCount() == null){ manPakOut.setCount(0.0); } // if (jsonOrderDetl.getAnfme() > manPakOut.getAnfme()) { //判断工作数量是否大于拣货单的数量 // return R.error("出库数量大于拣货单总数量"); // } BigDecimal a1 = new BigDecimal(manPakOut.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal b1 = new BigDecimal(manPakOut.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP); Double c1 = a1.subtract(b1).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue(); if (jsonOrderDetl.getAnfme() > c1) { //判断工作数量是否大于拣货单剩余可出的数量 return R.error("出库数量大于拣货单剩余可出数量"); } BigDecimal e1 = new BigDecimal(orderDetl.getWorkQty()).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal f1 = new BigDecimal(orderDetl.getQty()).setScale(2,BigDecimal.ROUND_HALF_UP); Double g1 = e1.subtract(f1).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue(); if ( g1 checkManLocDetl.getAnfme()) { return R.error("出库数量大于可出数量"); } if(checkManLocDetl.getWeight() == null){ checkManLocDetl.setWeight(0.0); } if(jsonOrderDetl.getWeight() == null){ jsonOrderDetl.setWeight(0.0); } Double finalQty = new BigDecimal(checkManLocDetl.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP).subtract(new BigDecimal(jsonOrderDetl.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP)).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue() ; Double weight = new BigDecimal(checkManLocDetl.getWeight()).setScale(2,BigDecimal.ROUND_HALF_UP).subtract(new BigDecimal(jsonOrderDetl.getWeight()).setScale(2,BigDecimal.ROUND_HALF_UP)).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue() ; checkManLocDetl.setAnfme(finalQty); checkManLocDetl.setWeight(weight); if (weight < 0){ return R.error("出库重量有误!"); } if (finalQty < 0){ // if(manLocDetlService.deleteDatailed(jsonLocNo, jsonOrderDetl.getMatnr(), jsonOrderDetl.getBatch())<=0) { return R.error("数量有误!"); // } }else { if(manLocDetlService.increase(finalQty, jsonLocNo, jsonOrderDetl.getMatnr(), jsonOrderDetl.getBatch(),weight)<=0){ return R.error("修改平库物料失败!"); } } orderDetl.setQty( new BigDecimal(orderDetl.getQty()).setScale(2,BigDecimal.ROUND_HALF_UP).add(new BigDecimal(jsonOrderDetl.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP)).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue() ); orderDetl.setUpdateTime(date); orderDetlService.updateById(orderDetl); //更新订单状态 List orderDetls=orderDetlService.selectList(new EntityWrapper().eq("order_no",order.getOrderNo())); order.setSettle(2L); boolean log=true; for (OrderDetl orderDetl1: orderDetls) { //工作中的数量小于总订单数时,订单状态改为2,作业中 if(orderDetl1.getQty() < orderDetl1.getAnfme()){ log=false; } } if(log){ order.setSettle(4L); } if(!orderService.updateById(order)){ return R.error("更新订单状态失败"); } if(manPakOut.getCount() == null){ manPakOut.setCount(0.0); } manPakOut.setCount(new BigDecimal(manPakOut.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP).add(new BigDecimal(jsonOrderDetl.getAnfme()).setScale(2,BigDecimal.ROUND_HALF_UP)).setScale(2,BigDecimal.ROUND_HALF_UP).doubleValue()); if (!manPakOutService.update(manPakOut,manPakOutEntityWrapper)){ return R.error("更新拣货单完成数目失败"); } if (manPakOut.getAnfme().equals(manPakOut.getCount())){ manPakOut.setStatus(1); if (!manPakOutService.update(manPakOut,manPakOutEntityWrapper)){ return R.error("更新拣货单状态失败"); } } EntityWrapper manLocDetlEntityWrapper = new EntityWrapper<>(); manLocDetlEntityWrapper.eq("loc_no",manPakOut.getLocNo()); manLocDetlEntityWrapper.eq("matnr",manPakOut.getMatnr()); if (checkManLocDetl.getAnfme() == 0 ){ if(!manLocDetlService.delete(manLocDetlEntityWrapper)){ return R.error("删除平库库存失败"); } }else{ checkManLocDetl.setStatus(1); if(!manLocDetlService.update(checkManLocDetl,manLocDetlEntityWrapper)){ return R.error("更新平库库存状态失败"); } } SaasUtils.insertLog(1,jsonLocNo,jsonOrderDetl.getMatnr(), jsonOrderDetl.getAnfme(),user.getUsername(), null,null,null,null,null); } return R.ok("下架完成"); } @Override public R manDetlInBarcode(JSONObject json, User user) { String jsonLocNo = (String) json.get("locNo"); //获取库位码 String jsonBarNo = (String) json.get("barcode"); //获取托盘码 LocMast locMast = locMastService.selectLocStatus(jsonLocNo); if (locMast.getLocSts().equals("X")){ return R.error("库位已被冻结"); } List waitPakins = waitPakinService.selectList(new EntityWrapper().eq("zpallet", jsonBarNo)); //获取对应组托信息 if (Cools.isEmpty(waitPakins)){ return R.error("未查询到组托"); } else if (waitPakins.get(0).getIoStatus().equals("Y")) { return R.error("组托已经生成工作档"); } for (WaitPakin waitPakin: waitPakins) { List manLocDetls = manLocDetlService.selectList(new EntityWrapper().eq("zpallet", waitPakin.getZpallet())); if (!Cools.isEmpty(manLocDetls) || manLocDetls.size()>0){ return R.error("所在库位已存在明细"); } } //判断订单是否完成 boolean log =true; for (WaitPakin waitPakin: waitPakins) { Order order = orderService.selectOne(new EntityWrapper().eq("order_no", waitPakin.getOrderNo())); //获取对应订单信息 if (order.equals(null)){ return R.error("未查询到订单信息"); } OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper().eq("order_no", waitPakin. getOrderNo()).eq("matnr", waitPakin.getMatnr())); //获取对应订单明细信息 if (orderDetl.equals(null)){ return R.error("未查询到订单明细信息"); } Node node = nodeService.selectOne(new EntityWrapper().eq("name", jsonLocNo)); //获取对应库位信息 if (node.equals(null)){ return R.error("未查询到库位信息"); } Date date = new Date(); ManLocDetl manLocDetl = new ManLocDetl(); //初始化库存实体类 manLocDetl.setLocNo(node.getName()); manLocDetl.setNodeId(node.getId()); manLocDetl.setZpallet(waitPakin.getZpallet()); manLocDetl.setAnfme(waitPakin.getAnfme()); manLocDetl.setMatnr(waitPakin.getMatnr()); manLocDetl.setMaktx(waitPakin.getMaktx()); manLocDetl.setStatus(1); manLocDetl.setCreateBy(user.getId()); manLocDetl.setCreateTime(date); manLocDetl.setUpdateBy(user.getId()); manLocDetl.setModiTime(date); manLocDetl.setOrderNo(waitPakin.getOrderNo()); manLocDetl.setStockFreeze(1); if (!manLocDetlService.insert(manLocDetl)){ //数据库插入实体类信息 return R.error("物料信息入库失败"); } orderDetl.setQty(orderDetl.getQty()+ waitPakin.getAnfme()); //更新订单明细数量 if (!orderDetlService.updateById(orderDetl)){ return R.error("更新订单明细失败"); } WaitPakinLog waitPakinLog = new WaitPakinLog(); //初始化入库通知单日志实体类 waitPakinLog.setZpallet(waitPakin.getZpallet()); waitPakinLog.setAnfme(waitPakin.getAnfme()); waitPakinLog.setMatnr(waitPakin.getMatnr()); waitPakinLog.setLocNo(jsonLocNo); waitPakinLog.setMaktx(waitPakin.getMaktx()); waitPakinLog.setOrderNo(waitPakin.getOrderNo()); waitPakinLog.setWeight(waitPakin.getWeight()); waitPakinLog.setStatus("Y"); waitPakinLog.setIoStatus("Y"); waitPakinLog.setModiUser(user.getId()); waitPakinLog.setModiTime(date); waitPakinLog.setAppeUser(user.getId()); waitPakinLog.setAppeTime(date); waitPakinLog.setUuid(waitPakin.getUuid()); if (!waitPakinLogService.insert(waitPakinLog)){ //插入入库通知历史档数据库 return R.error("插入历史入库通知档失败"); } //订单是否完成 List or = orderDetlService.selectList(new EntityWrapper().eq("order_no", waitPakin.getOrderNo())); for (OrderDetl o: or) { if(o.getAnfme()-o.getQty()>0){ log=false; break; } } if(log){ order.setSettle(4L); if(!orderService.update(order,new EntityWrapper().eq("order_no", waitPakin.getOrderNo()))){ return R.error("订单转完成状态失败!!!"); } } } if (!waitPakinService.delete(new EntityWrapper().eq("zpallet",jsonBarNo))){ //删除原入库通知档 return R.error("删除入库通知档失败"); } return R.ok("上架成功"); } @Override public R adjustNew(MobileAdjustNewParam combParam, Long userId) { for (WrkDetl detl: combParam.getWrkDetls()){ EntityWrapper wrapper = new EntityWrapper<>(); wrapper.eq("order_no", combParam.getOrderNo()) .eq("matnr", detl.getMatnr()) .eq("loc_no", detl.getLocNo()) .eq("batch",detl.getBatch()); LocCheck CheckDetl = locCheckService.selectOne(wrapper); if (CheckDetl == null){ Date now = new Date(); LocCheck locCheck = new LocCheck(); locCheck.setLocNo(detl.getLocNo()); locCheck.setMaktx(detl.getMaktx()); locCheck.setType(1); locCheck.setMatnr(detl.getMatnr()); locCheck.setAnfme(detl.getAnfme()); locCheck.setRealAnfme(detl.getAnfme()); locCheck.setDiffAnfme(detl.getAnfme()); locCheck.setExamine(0); locCheck.setOwner(detl.getOwner()); locCheck.setPayment(detl.getPayment()); locCheck.setCreateTime(now); locCheck.setUpdateTime(now); locCheck.setOrderNo(combParam.getOrderNo()); locCheck.setBatch(detl.getBatch()); if (!locCheckService.insert(locCheck)){ return R.error("盘点明细插入失败"); } }else { CheckDetl.setRealAnfme(detl.getAnfme()); CheckDetl.setDiffAnfme(detl.getAnfme()- CheckDetl.getAnfme()); if (!locCheckService.update(CheckDetl,wrapper)){ return R.error("明细更新失败"); } } } OrderCheck orderCheck = orderCheckService.selectOne(new EntityWrapper().eq("order_no", combParam.getOrderNo())); orderCheck.setSettle(2L); if (!orderCheckService.update(orderCheck,new EntityWrapper().eq("order_no", combParam.getOrderNo()))){ return R.error("更新盘点单状态失败!"); } return R.ok("盘点成功"); } @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().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() .eq("origin_address", jsonOrigin)); String code = "0"; String weight = "0"; String date = "0"; try{ if (originRule.getStartCode() != 0 && originRule.getEndCode() !=0){ code = jsonCode.substring(originRule.getStartCode() - 1, originRule.getEndCode()); } if (originRule.getStartWeight() != 0 && originRule.getEndWeight() !=0){ weight = jsonCode.substring(originRule.getStartWeight() - 1, originRule.getEndWeight()); } if (originRule.getStartDate() != 0 && originRule.getEndDate() !=0){ date = jsonCode.substring(originRule.getStartDate() - 1, originRule.getEndDate()); } }catch (Exception e){ return R.error("条码位置有误"); } Node node = nodeService.selectOne(new EntityWrapper().eq("name", jsonLocNo)); //获取对应库位信息 if (Cools.isEmpty(node)){ return R.error("未查询到库位信息"); } JSONArray combMats = json.getJSONArray("combMats"); for (int i = 0; i < combMats.size(); i++) { OrderDetl jsonOriginDetl = combMats.getObject(i, OrderDetl.class); Mat mat = matService.selectByMatnr(jsonOriginDetl.getMatnr()); 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 manLocDetlWrapper = new EntityWrapper().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()); BigDecimal anfme = BigDecimal.valueOf(manLocDetl1.getAnfme()); BigDecimal sum = anfme.add(inAnfme); manLocDetl1.setAnfme(sum.doubleValue()); if (!manLocDetlService.update(manLocDetl1,manLocDetlWrapper)) { return R.error("物料信息上架失败"); } }else { ManLocDetl manLocDetl = new ManLocDetl(); //初始化库存实体类 manLocDetl.sync(mat); manLocDetl.setLocNo(node.getUuid()); manLocDetl.setNodeId(node.getId()); // manLocDetl.setZpallet(waitPakin.getZpallet()); manLocDetl.setAnfme(jsonOriginDetl.getAnfme()); manLocDetl.setName(jsonCode); manLocDetl.setModel(code); manLocDetl.setWeight(Double.valueOf(weight)); manLocDetl.setBatch(date); manLocDetl.setCustName(jsonOriginDetl.getOrigin()); manLocDetl.setStatus(1); manLocDetl.setCreateBy(user.getId()); manLocDetl.setCreateTime(now); manLocDetl.setUpdateBy(user.getId()); 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("物料信息入库失败"); } } } return R.ok(); } @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().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().eq("name", jsonLocNo)); //获取对应库位信息 if (Cools.isEmpty(node)){ return R.error("未查询到库位信息"); } JSONArray combMats = json.getJSONArray("combMats"); for (int i = 0; i < combMats.size(); i++) { OrderDetl jsonOriginDetl = combMats.getObject(i, OrderDetl.class); Mat mat = matService.selectByMatnr(jsonOriginDetl.getMatnr()); 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 manLocDetlWrapper = new EntityWrapper().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()); BigDecimal anfme = BigDecimal.valueOf(manLocDetl1.getAnfme()); BigDecimal sum = anfme.add(inAnfme); manLocDetl1.setAnfme(sum.doubleValue()); if (!manLocDetlService.update(manLocDetl1,manLocDetlWrapper)) { return R.error("物料信息上架失败"); } }else { ManLocDetl manLocDetl = new ManLocDetl(); //初始化库存实体类 manLocDetl.sync(mat); manLocDetl.setLocNo(node.getUuid()); manLocDetl.setNodeId(node.getId()); // manLocDetl.setZpallet(waitPakin.getZpallet()); manLocDetl.setAnfme(jsonOriginDetl.getAnfme()); manLocDetl.setName(""); manLocDetl.setModel(""); manLocDetl.setWeight(jsonOriginDetl.getAnfme()); manLocDetl.setBatch(jsonOriginDetl.getBatch()); manLocDetl.setCustName(jsonOriginDetl.getOrigin()); manLocDetl.setStatus(1); manLocDetl.setCreateBy(user.getId()); 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("物料信息入库失败"); } } } return R.ok(); } @Override public R manDetlOriginOut(JSONObject json, User user) { Date now = new Date(); JSONArray combMats = json.getJSONArray("combMats"); List matPrintList=new ArrayList<>(); List ids=new ArrayList<>(); for (int i = 0; i < combMats.size(); i++) { 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 manLocDetlWrapper = new EntityWrapper().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("未查询到商品明细信息!库位号:"+jsonOriginDetl.getLocNo()+";商品编号:"+jsonOriginDetl.getMatnr()+"批次:"+jsonOriginDetl.getBatch()+"货主"+jsonOriginDetl.getOwnerId()); } BigDecimal outAnfme = BigDecimal.valueOf(parseLong); BigDecimal anfme = BigDecimal.valueOf(manLocDetl.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("物料信息下架失败"); } }else if (manLocDetl.getAnfme().equals(jsonOriginDetl.getAnfme())) { if (!manLocDetlService.delete(manLocDetlWrapper)) { 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(); } @Override public void plaPakin(String brand, String locNo, String batch, Integer packageNo, User user) { Pla pla = plaService.selectByBatchAndPackageNo(batch, packageNo,brand); if(Cools.isEmpty(pla)){ throw new CoolException("系统未检测到该包物料信息,请重新录入"); } if(!pla.getStatus().equals(GlobleParameter.PLA_STATUS_0) && !pla.getStatus().equals(GlobleParameter.PLA_STATUS_00)){ throw new CoolException("该物料状态不为待入库,无法入库"); } pla.setStatus(GlobleParameter.PLA_STATUS_1); pla.setModifyTime(new Date()); pla.setPakinTime(new Date()); Node node = nodeService.selectByUuid(locNo); if(Cools.isEmpty(node)){ throw new CoolException("库位信息不正确"); } pla.setStash(node.getParentName()); pla.setLocNo(node.getUuid()); plaService.updateById(pla); SaasUtils.insertLog(0,locNo,pla.getBrand(),pla.getWeightAnfme(),user.getUsername(), null,pla.getBatch(),pla.getPackageNo(),pla.getOwner(),pla.getWorkshop()); } @Override @Transactional @Synchronized public void plaPakout(String brand, String locNo, String batch, Integer packageNo, String orderNo, String plaQtyId, String wrkNo, Double anfme, boolean isReplace) { Pla pla = plaService.selectByBatchAndPackageNo(batch, packageNo,brand); ManPakOut manPakOut = manPakOutService.selectById(wrkNo); PlaQty plaQty = plaQtyService.selectById(plaQtyId); //物料替换 if(isReplace){ replacePla(pla,manPakOut,plaQty); }else { if((!Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_2) && !Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_3) && !Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_1)) || !Cools.eq(pla.getBatch(),manPakOut.getBatch()) || !Cools.eq(pla.getPackageNo()+"",manPakOut.getBarcode()) || !Cools.eq(pla.getBrand(),manPakOut.getMaktx()) ){ throw new CoolException("物料不一致,无法出库" + "批号:" + pla.getBatch() + ",包号:" + pla.getPackageNo() + ",牌号:" + pla.getBrand()); } } //更新拣货单信息 if(manPakOut.getCount() + anfme > manPakOut.getAnfme()){ throw new CoolException("拣货重量大于拣货单所需拣货重量,请重新分配拣货重量"); } if(manPakOut.getStatus() == 1){ throw new CoolException("该拣料单已出库"); } manPakOut.setCount(manPakOut.getCount() + anfme); if (manPakOut.getAnfme().equals(manPakOut.getCount())){ manPakOut.setStatus(1); manPakOut.setUpdateTime(new Date()); manPakOutService.updateById(manPakOut); } //更新plaQty信息 plaQty.setPakoutTime(Utils.getDateStr(new Date())); plaQtyService.updateById(plaQty); //更新pla明细 pla.setWeightAnfme(pla.getWeightAnfme() - anfme); pla.setQtyAnfme(pla.getQtyAnfme() - anfme); pla.setModifyTime(new Date()); if(pla.getWeightAnfme() <= 0){ pla.setStatus(GlobleParameter.PLA_STATUS_4); }else { pla.setStatus(GlobleParameter.PLA_STATUS_3); } plaService.updateById(pla); SaasUtils.insertLog(1,locNo,pla.getBrand(),anfme,null,null, pla.getBatch(),pla.getPackageNo(),pla.getOwner(),pla.getWorkshop()); //更新订单明细 Order order = orderService.selectByNo(orderNo); OrderDetl orderDetl = orderDetlService.selectById(plaQty.getOrderDetlId()); orderDetl.setQty(orderDetl.getQty() + anfme); orderDetlService.updateById(orderDetl); orderService.checkComplete(orderNo); } @Override public void plaPackOutWithoutOrder(String brand, String batch, Integer packageNo, Double anfme) { Pla pla = plaService.selectByBatchAndPackageNo(batch, packageNo,brand); if(Cools.isEmpty(pla)){ throw new CoolException("当前物料明细不存在"); } if (!pla.getStatus().equals(GlobleParameter.PLA_STATUS_1) && !pla.getStatus().equals(GlobleParameter.PLA_STATUS_3)){ throw new CoolException("当前物料状态无法出库"); } if(anfme > pla.getWeightAnfme()){ throw new CoolException("当前物料剩余库存不足"); } pla.setWeightAnfme(pla.getWeightAnfme() - anfme); if(pla.getWeightAnfme() > 0){ pla.setStatus(GlobleParameter.PLA_STATUS_3); }else { pla.setStatus(GlobleParameter.PLA_STATUS_4); } plaService.updateById(pla); SaasUtils.insertLog(1,pla.getLocNo(),pla.getBrand(),anfme,null,null,pla.getBatch(),pla.getPackageNo(),pla.getOwner(),pla.getWorkshop()); } @Override public List getManPakoutByOrderNo(String orderNo) { return manPakOutService.selectList(new EntityWrapper().eq("doc_num",orderNo).eq("status",0)); } public void replacePla(Pla plaNew, ManPakOut manPakOut, PlaQty plaQty){ //还原旧物料状态 Pla plaOld = plaService.selectByBatchAndPackageNo(manPakOut.getBatch(), Integer.parseInt(manPakOut.getBarcode()), manPakOut.getMaktx()); //更新新物料信息 plaNew.setQtyAnfme(plaOld.getQtyAnfme()); plaNew.setStatus(plaOld.getStatus()); plaService.updateById(plaNew); plaOld.setStatus(GlobleParameter.PLA_STATUS_1); plaOld.setQtyAnfme(plaOld.getQtyAnfme() - manPakOut.getCount()); plaService.updateById(plaOld); //更新plaQty信息 plaQty.setBatch(plaNew.getBatch()); plaQty.setBrand(plaNew.getBrand()); plaQty.setPackageNo(plaNew.getPackageNo()); plaQtyService.updateById(plaQty); //更新拣货单信息 manPakOut.setMaktx(plaNew.getBrand()); manPakOut.setBatch(plaNew.getBatch()); manPakOut.setBarcode(plaNew.getPackageNo() + ""); manPakOut.setUpdateTime(new Date()); manPakOutService.updateById(manPakOut); } @Override public List pdaSelectInfmt(String barcode) { EntityWrapper plaEntityWrapper = new EntityWrapper<>(); String[] split = barcode.split(";"); if (split.length == 4){ plaEntityWrapper.eq("brand",split[0]); plaEntityWrapper.eq("batch",split[1]); plaEntityWrapper.eq("package_no",split[2]); plaEntityWrapper.eq("line",split[3]); }else if (split.length == 1){ Node node = nodeService.selectOne(new EntityWrapper().eq("name", barcode)); if (Cools.isEmpty(node)){ throw new CoolException("请检查输入的库位码"); } plaEntityWrapper.eq("loc_no",barcode); }else { throw new CoolException("条码信息有误!"); } plaEntityWrapper.eq(false,"status","全部出库"); List plaList = plaService.selectList(plaEntityWrapper); if (Cools.isEmpty(plaList)){ throw new CoolException("未查询到库存物料信息"); } return plaList; } }