#

LSH

2023-11-17 3e4ca9accd2be4240308565bb21469f3abb86023

#

 src/main/java/com/zy/asrs/mapper/TaskWrkMapper.java

@@ -14,6 +14,7 @@
public interface TaskWrkMapper extends BaseMapper<TaskWrk> {

    TaskWrk selectByTaskNo(String taskNo);
    TaskWrk selectByStartPoint(@Param("startPoint") String startPoint);

    TaskWrk selectByWrkNo(Integer wrkNo);


 src/main/java/com/zy/asrs/service/TaskWrkService.java

@@ -8,6 +8,7 @@
public interface TaskWrkService extends IService<TaskWrk> {

    TaskWrk selectByTaskNo(String taskNo);
    TaskWrk selectByStartPoint(String taskNo);

    TaskWrk selectByWrkNo(Integer wrkNo);


 src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java

@@ -1,6 +1,7 @@
package com.zy.asrs.service.impl;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.core.common.Cools;
import com.core.exception.CoolException;
import com.zy.asrs.entity.*;
@@ -14,6 +15,7 @@
import com.zy.asrs.utils.PostMesDataUtils;
import com.zy.asrs.utils.Utils;
import com.zy.common.service.CommonService;
import com.zy.common.utils.HttpHandler;
import com.zy.core.CrnThread;
import com.zy.core.DevpThread;
import com.zy.core.cache.SlaveConnection;
@@ -320,27 +322,32 @@
                    // 双深库位且浅库位有货，则需先对浅库位进行库位移转
                    if (Utils.isDeepLoc(slaveProperties, taskWrk.getStartPoint())) {

                        taskWrkMapper.selectPakOutIoType(taskWrk.getCrnNo());

                        List<TaskWrk> taskWrks1 = taskWrkMapper.selectPakOutIoType(taskWrk.getCrnNo());
                        if (Cools.isEmpty(taskWrks1) && taskWrks1.size()!=0){
                            break;
                            continue;
                        }
                        String shallowLocNo = Utils.getShallowLoc(slaveProperties, taskWrk.getStartPoint());
                        LocMast shallowLoc = locMastService.selectById(shallowLocNo);
                        if (!shallowLoc.getLocSts().equals("O")){
                            // O.空库位、Q.拣料/盘点/并板再入库、S.入库预约、X.禁用 直接搬！
                            if (shallowLoc.getLocSts().equals("P") || shallowLoc.getLocSts().equals("R")) {
                                log.error("工作号={}，库位号={}，浅库位异常：浅库位号：={}，库位状态={}",taskWrk.getTaskNo(),taskWrk.getStartPoint(),shallowLocNo,shallowLoc.getLocSts());
                            } else if (shallowLoc.getLocSts().equals("F") || shallowLoc.getLocSts().equals("D")) {
                                taskWrk.setTransferMark(1);
                                taskWrkMapper.updateById(taskWrk);
                                WMSAndAGVInterfaceParam param = new WMSAndAGVInterfaceParam();
                                param.setTaskNo(taskWrk.getTaskNo());
                                new PostMesDataUtils().postMesData("MES系统",wmsUrl,movePath,param);
                                log.error("工作号={}，库位号={}，浅库位需要移库：浅库位号：={}，库位状态={}",taskWrk.getTaskNo(),taskWrk.getStartPoint(),shallowLocNo,shallowLoc.getLocSts());
                            } else if (shallowLoc.getLocSts().equals("Q") || shallowLoc.getLocSts().equals("S")) {
                                log.error("工作号={}，库位号={}，浅库位异常：浅库位号：={}，库位状态={}",taskWrk.getTaskNo(),taskWrk.getStartPoint(),shallowLocNo,shallowLoc.getLocSts());
                        TaskWrk hallowLocNoTask = taskWrkMapper.selectByStartPoint(shallowLocNo);
                        if (!Cools.isEmpty(hallowLocNoTask)){
//                            new PostMesDataUtils().postMesData("移库任务分配库位",wmsUrl,movePath,hallowLocNoTask);
                            try {
                                String response = new HttpHandler.Builder()
                                        .setUri(wmsUrl)
                                        .setPath(movePath)
                                        .setJson(JSON.toJSONString(hallowLocNoTask))
                                        .build()
                                        .doPost();
                                System.out.println("response:"+response);
                                JSONObject jsonObject = JSON.parseObject(response);
                                if (jsonObject.getInteger("code").equals(200)) {
                                    //解析
                                }
                            }catch (Exception e){
                                log.error("请求接口失败！！！url：{}；request：{}；response：{}", wmsUrl+"/"+movePath, JSON.toJSONString(hallowLocNoTask), "请求移库任务分配库位");
                            }
                            continue;
                            break;
                        }
                    }


 src/main/java/com/zy/asrs/service/impl/TaskWrkServiceImpl.java

@@ -31,6 +31,11 @@
    }

    @Override
    public TaskWrk selectByStartPoint(String taskNo) {
        return this.baseMapper.selectByStartPoint(taskNo);
    }

    @Override
    public TaskWrk selectByWrkNo(Integer wrkNo) {
        return this.baseMapper.selectByWrkNo(wrkNo);
    }

 src/main/resources/mapper/TaskWrkMapper.xml

@@ -33,6 +33,13 @@
        and task_no = #{taskNo}
    </select>

    <select id="selectByStartPoint" resultMap="BaseResultMap">
        select top 1 * from wcs_task_wrk
        where 1=1
        and io_type=3
        and start_point = #{startPoint}
    </select>

    <select id="selectByWrkNo" resultMap="BaseResultMap">
        select top 1 * from wcs_task_wrk
        where 1=1