#

18516761980

2021-08-31 f3d0b8d2219182087dbe9020ef40fe53fa415df1

#

 src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java

@@ -1,13 +1,23 @@
package com.zy.asrs.task.handler;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.zy.asrs.entity.*;
import com.zy.asrs.service.*;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocMast;
import com.zy.asrs.entity.WrkDetl;
import com.zy.asrs.entity.WrkMast;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.LocMastService;
import com.zy.asrs.service.WrkDetlService;
import com.zy.asrs.service.WrkMastService;
import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
import com.zy.asrs.utils.VersionUtils;
import com.zy.ints.entity.IoComplete;
import com.zy.ints.entity.WaitMatin;
import com.zy.ints.entity.WaitMatout;
import com.zy.ints.service.IoCompleteService;
import com.zy.ints.service.WaitMatinService;
import com.zy.ints.service.WaitMatoutService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
@@ -30,9 +40,11 @@
    @Autowired
    private LocDetlService locDetlService;
    @Autowired
    private WaitPakinService waitPakinService;
    @Autowired
    private WaitMatinService waitMatinService;
    @Autowired
    private WaitMatoutService waitMatoutService;
    @Autowired
    private IoCompleteService ioCompleteService;

    public ReturnT<String> start(WrkMast wrkMast) {
        // 4.入库完成
@@ -95,34 +107,37 @@
                                exceptionHandle("全板入库 ===>> 添加库存明细失败；[workNo={0}],[locNo={1}]", wrkMast.getWrkNo(), wrkMast.getLocNo());
                            }
                        }
                        // 更新入库通知档 ioStatus ===>> 2
                        if(!"0".equals(wrkDetl.getBillNo()) || !wrkDetl.getSeqNo().equals(0)){
                            WaitMatin waitMatin = waitMatinService.selectOne(new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                            if(null != waitMatin && waitMatin.getInQty() >= waitMatin.getQty()){
                                waitMatin.setIoStatus(2);
                                waitMatin.setModiTime(new Date());
                                boolean res = waitMatinService.update(waitMatin, new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                                if(!res){
                                    exceptionHandle("全板入库 ===>> 更新入库通知档失败；[workNo={0}],[billNo={1}]", wrkMast.getWrkNo(),wrkDetl.getBillNo());
                                }

                        // 更新入库通知档 ioStatus ====>> 2
                        WaitMatin waitMatin = waitMatinService.selectOne(new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                        if(null != waitMatin && waitMatin.getInQty() >= waitMatin.getQty()){
                            waitMatin.setIoStatus(2);
                            waitMatin.setModiTime(now);
                            boolean res = waitMatinService.update(waitMatin, new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                            if(!res){
                                exceptionHandle("全板入库 ===>> 更新入库通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }

                        //todo:插入回报档
                        //插入回报档 insert ====>> io_complete
                        if("Y".equals(wrkMast.getLinkMis())){

                            IoComplete ioComplete = new IoComplete();
                            ioComplete.setBillNo(wrkDetl.getBillNo());
                            ioComplete.setSeqNo(wrkDetl.getSeqNo());
                            ioComplete.setTaskType(1);//入库
                            ioComplete.setLocNo(wrkMast.getLocNo());
                            ioComplete.setZpallet(wrkMast.getBarcode());
                            ioComplete.setMatNo(wrkDetl.getMatNo());
                            ioComplete.setMatName(wrkDetl.getMatName());
                            ioComplete.setQty(wrkDetl.getQty());
                            ioComplete.setUpdStatus(0);//上报状态，待处理
                            ioComplete.setModiTime(now);
                            ioComplete.setAppeTime(now);
                            boolean res = ioCompleteService.insert(ioComplete);
                            if(!res){
                                exceptionHandle("全板入库 ===>> 插入回报通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }
//                        try {
//                            WaitPakin setParam = new WaitPakin();
//                            setParam.setIoStatus("Y");
//                            boolean updateRes = waitPakinService.update(setParam
//                                    , new EntityWrapper<WaitPakin>().eq("zpallet", wrkDetl.getZpallet())
//                                            .eq("mat_no", wrkDetl.getMatNo())
//                                            .eq("qty", wrkDetl.getQty()));
//                            if (!updateRes && updateRes) {
//                                exceptionHandle("全板入库 ===>> 更新入库通知档失败；[workNo={0}]", wrkMast.getWrkNo());
//                            }
//                        } catch (Exception ignore){}

                    }
                    // 修改库位状态 S ====>> F
@@ -150,7 +165,37 @@
                            if (!locDetlService.updateAnfme(locDetl.getQty() - wrkDetl.getQty(), locMast.getLocNo(), wrkDetl.getMatNo())) {
                                exceptionHandle("拣料入库 ===>> 修改库存明细数量失败；[workNo={0}],[locNo={1}]", wrkMast.getWrkNo(), wrkMast.getLocNo());
                            }
                            // todo:luxiaotao 3)修改出库通知档 iostatus ==> Y

                            // 更新出库通知档 ioStatus ====>> 2
                            WaitMatout waitMatout = waitMatoutService.selectOne(new EntityWrapper<WaitMatout>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                            if(null != waitMatout && waitMatout.getOutQty() >= waitMatout.getQty()){
                                waitMatout.setIoStatus(2);
                                waitMatout.setModiTime(now);
                                boolean res = waitMatoutService.update(waitMatout, new EntityWrapper<WaitMatout>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                                if(!res){
                                    exceptionHandle("拣料出库 ===>> 更新出库通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                                }
                            }

                            //插入回报档 insert ====>> io_complete
                            if("Y".equals(wrkMast.getLinkMis())){
                                IoComplete ioComplete = new IoComplete();
                                ioComplete.setBillNo(wrkDetl.getBillNo());
                                ioComplete.setSeqNo(wrkDetl.getSeqNo());
                                ioComplete.setTaskType(2);//出库
                                ioComplete.setLocNo(wrkMast.getLocNo());
                                ioComplete.setZpallet(wrkMast.getBarcode());
                                ioComplete.setMatNo(wrkDetl.getMatNo());
                                ioComplete.setMatName(wrkDetl.getMatName());
                                ioComplete.setQty(wrkDetl.getQty());
                                ioComplete.setUpdStatus(0);//上报状态，待处理
                                ioComplete.setModiTime(now);
                                ioComplete.setAppeTime(now);
                                boolean res = ioCompleteService.insert(ioComplete);
                                if(!res){
                                    exceptionHandle("拣料出库 ===>> 插入回报通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                                }
                            }
                        }
                    }
                    // 修改库位状态 Q ====>> F
@@ -188,7 +233,38 @@
                                exceptionHandle("并板入库 ===>> 新增库存明细失败；[workNo={0}],[matNo={1}]", wrkMast.getWrkNo(), wrkDetl.getMatNo());
                            }
                        }
                        // todo:luxiaotao 3)修改出库通知档 status ==> Y

                        // 更新入库通知档 ioStatus ====>> 2
                        WaitMatin waitMatin = waitMatinService.selectOne(new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                        if(null != waitMatin && waitMatin.getInQty() >= waitMatin.getQty()){
                            waitMatin.setIoStatus(2);
                            waitMatin.setModiTime(now);
                            boolean res = waitMatinService.update(waitMatin, new EntityWrapper<WaitMatin>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                            if(!res){
                                exceptionHandle("并板入库 ===>> 更新入库通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }

                        //插入回报档 insert ====>> io_complete
                        if("Y".equals(wrkMast.getLinkMis())){
                            IoComplete ioComplete = new IoComplete();
                            ioComplete.setBillNo(wrkDetl.getBillNo());
                            ioComplete.setSeqNo(wrkDetl.getSeqNo());
                            ioComplete.setTaskType(1);//入库
                            ioComplete.setLocNo(wrkMast.getLocNo());
                            ioComplete.setZpallet(wrkMast.getBarcode());
                            ioComplete.setMatNo(wrkDetl.getMatNo());
                            ioComplete.setMatName(wrkDetl.getMatName());
                            ioComplete.setQty(wrkDetl.getQty());
                            ioComplete.setUpdStatus(0);//上报状态，待处理
                            ioComplete.setModiTime(now);
                            ioComplete.setAppeTime(now);
                            boolean res = ioCompleteService.insert(ioComplete);
                            if(!res){
                                exceptionHandle("并板入库 ===>> 插入回报通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }

                    }
                    // 修改库位状态 Q ====>> F
                    if (locMast.getLocSts().equals("Q")) {
@@ -208,7 +284,6 @@
                    if (wrkDetls57.isEmpty()) {
                        exceptionHandle("盘点入库 ===>> 工作明细档为空；[workNo={0}]", wrkMast.getWrkNo());
                    }
                    // todo:luxiaotao 3)修改盘点通知档 status ==> Y
                    // 修改库位状态 Q ====>> F
                    if (locMast.getLocSts().equals("Q")) {
                        locMast.setLocSts("F");
@@ -232,7 +307,6 @@
                            exceptionHandle("库位移转 ===>> 转移库存明细数据失败；[源库位={0}],[目标库位={1}]", wrkMast.getSourceLocNo(), wrkMast.getLocNo());
                        }
                    }
                    // todo:luxiaotao 3)修改盘点通知档 status ==> Y
                    // 修改源库位状态 ==> O
                    LocMast sourceLoc = locMastService.selectById(wrkMast.getSourceLocNo());
                    if (null != sourceLoc) {
@@ -286,7 +360,35 @@
                        exceptionHandle("全板出库 ===>> 工作明细档为空；[workNo={0}]", wrkMast.getWrkNo());
                    }
                    for (WrkDetl wrkDetl : wrkDetls101) {
                        // todo:luxiaotao 3)修改出库通知档 status ==> Y
                        WaitMatout waitMatout = waitMatoutService.selectOne(new EntityWrapper<WaitMatout>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                        if(null != waitMatout && waitMatout.getOutQty() >= waitMatout.getQty()){
                            waitMatout.setIoStatus(2);
                            waitMatout.setModiTime(now);
                            boolean res = waitMatoutService.update(waitMatout, new EntityWrapper<WaitMatout>().eq("bill_no",wrkDetl.getBillNo()).eq("seq_no",wrkDetl.getSeqNo()));
                            if(!res){
                                exceptionHandle("全板出库 ===>> 更新出库通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }

                        //插入回报档 insert ====>> io_complete
                        if("Y".equals(wrkMast.getLinkMis())){
                            IoComplete ioComplete = new IoComplete();
                            ioComplete.setBillNo(wrkDetl.getBillNo());
                            ioComplete.setSeqNo(wrkDetl.getSeqNo());
                            ioComplete.setTaskType(2);//出库
                            ioComplete.setLocNo(wrkMast.getLocNo());
                            ioComplete.setZpallet(wrkMast.getBarcode());
                            ioComplete.setMatNo(wrkDetl.getMatNo());
                            ioComplete.setMatName(wrkDetl.getMatName());
                            ioComplete.setQty(wrkDetl.getQty());
                            ioComplete.setUpdStatus(0);//上报状态，待处理
                            ioComplete.setModiTime(now);
                            ioComplete.setAppeTime(now);
                            boolean res = ioCompleteService.insert(ioComplete);
                            if(!res){
                                exceptionHandle("全板出库 ===>> 插入回报通知档失败；[workNo={0}],[billNo={1}],[seqNo={2}]", wrkMast.getWrkNo(),wrkDetl.getBillNo(),wrkDetl.getSeqNo());
                            }
                        }
                    }
                    // 删除工作档源库位的库存明细
                    if (!locDetlService.delete(new EntityWrapper<LocDetl>().eq("loc_no", wrkMast.getSourceLocNo()))) {

 src/main/java/com/zy/ints/task/WaitMatinLogScheduler.java

New file
@@ -0,0 +1,35 @@
package com.zy.ints.task;

import com.zy.asrs.task.core.ReturnT;
import com.zy.ints.entity.WaitMatin;
import com.zy.ints.task.handler.WaitMatinLogHandler;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * 入库通知档转历史档
 * Created by TQS on 2021/8/31
 */
@Component
public class WaitMatinLogScheduler {
    private static final Logger log = LoggerFactory.getLogger(WaitMatinLogScheduler.class);

    @Autowired
    private WaitMatinLogHandler waitMatinLogHandler;

    @Scheduled(cron = "0/3 * * * * ? ")
    private void execute(){
        List<WaitMatin> WaitMatins = null;
        for (WaitMatin waitMatin : WaitMatins) {
            ReturnT<String> result = waitMatinLogHandler.start(waitMatin);
            if (!result.isSuccess()) {
                log.error("入库通知档[billNo={}],[seqNo={}]历史档处理失败", waitMatin.getBillNo(),waitMatin.getSeqNo());
            }
        }
    }
}

 src/main/java/com/zy/ints/task/handler/WaitMatinLogHandler.java

New file
@@ -0,0 +1,43 @@
package com.zy.ints.task.handler;

import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
import com.zy.ints.entity.WaitMatin;
import com.zy.ints.service.WaitMatinLogService;
import com.zy.ints.service.WaitMatinService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;

/**
 * 入库通知档转历史档
 * Created by TQS on 2021/8/31
 */
@Service
public class WaitMatinLogHandler extends AbstractHandler<String>  {

    @Autowired
    WaitMatinService waitMatinService;
    @Autowired
    WaitMatinLogService waitMatinLogService;

    @Transactional
    public ReturnT<String> start(WaitMatin waitMatin){
        try {
            // 保存工作主档历史档
//            if (!WaitMatinLogService.save(waitMatin.getBillNo(),waitMatin.getSeqNo())) {
//                exceptionHandle("保存工作历史档[workNo={0}]失败", wrkMast.getWrkNo());
//            }
//            // 删除工作主档
//            if (!wrkMastService.deleteById(wrkMast)) {
//                exceptionHandle("删除工作主档[workNo={0}]失败", wrkMast.getWrkNo());
//            }
        } catch (Exception e) {
            e.printStackTrace();
            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
            return FAIL.setMsg(e.getMessage());
        }
        return SUCCESS;
    }
}