From 23f026fbfd81066b1f2e9662bbeff31965dda4d6 Mon Sep 17 00:00:00 2001
From: huang <1532065656@qq.com>
Date: 星期一, 20 十月 2025 17:00:16 +0800
Subject: [PATCH] 仓储页面推送数据过滤查询

---
 hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassTask.java |  823 +++++++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 547 insertions(+), 276 deletions(-)

diff --git a/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassTask.java b/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassTask.java
index 0bf747d..759df14 100644
--- a/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassTask.java
+++ b/hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/job/RawGlassTask.java
@@ -3,17 +3,22 @@
 import cn.hutool.core.collection.CollectionUtil;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import com.github.xingshuangs.iot.protocol.s7.serializer.S7Serializer;
 import com.kangaroohy.milo.model.ReadWriteEntity;
 import com.kangaroohy.milo.service.MiloService;
 import com.mes.common.config.Const;
 import com.mes.engineering.entity.Engineering;
 import com.mes.engineering.mapper.EngineeringMapper;
+import com.mes.opctask.entity.LoadGlassDeviceTask;
+import com.mes.opctask.service.LoadGlassDeviceTaskService;
 import com.mes.rawglassdetails.entity.RawGlassStorageDetails;
 import com.mes.rawglassdetails.service.RawGlassStorageDetailsService;
 import com.mes.rawglassstation.entity.RawGlassStorageStation;
 import com.mes.rawglassstation.service.RawGlassStorageStationService;
 import com.mes.rawglasstask.entity.RawGlassStorageTask;
 import com.mes.rawglasstask.service.RawGlassStorageTaskService;
+import com.mes.s7.entity.S7Data;
+import com.mes.uppattenusage.entity.UpPattenUsage;
 import com.mes.uppattenusage.entity.vo.UpPattenUsageVO;
 import com.mes.uppattenusage.mapper.UpPattenUsageMapper;
 import lombok.extern.slf4j.Slf4j;
@@ -23,10 +28,7 @@
 import org.springframework.util.CollectionUtils;
 
 import javax.annotation.Resource;
-import java.util.Arrays;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -39,325 +41,594 @@
 public class RawGlassTask {
 
     @Autowired
-    private RawGlassStorageStationService rawGlassStorageStationService;
-    @Autowired
     private RawGlassStorageDetailsService rawGlassStorageDetailsService;
 
     @Autowired
     private RawGlassStorageTaskService rawGlassStorageTaskService;
+    @Autowired
+    private RawGlassStorageStationService rawGlassStorageStationService;
 
     @Resource
     private EngineeringMapper engineeringMapper;
     @Resource
     private UpPattenUsageMapper upPattenUsageMapper;
 
-    @Autowired
+    @Resource
+    private LoadGlassDeviceTaskService loadGlassDeviceTaskService;
+
+    @Autowired(required = false)
     private MiloService miloService;
 
-    private static final List<String> LIFTING_STATION = Arrays.asList("4");
-    private static final List<String> LOAD_STATION_01 = Arrays.asList("101", "102");
-    private static final List<String> LOAD_STATION_02 = Arrays.asList("103", "104");
-    private static final List<Integer> LOAD_STATION_MAX = Arrays.asList(102, 104);
+    @Autowired(required = false)
+    S7Serializer s7Serializer;
+
+
+    private static final String LOAD_GLASS_DEVICE_ONE_TASK = "load_glass_device_one_task";
+
+    private static final String LOAD_GLASS_DEVICE_TWO_TASK = "load_glass_device_two_task";
+
+    private static final List<Integer> LOAD_STATION_01 = Collections.singletonList(101);
+//    private static final List<Integer> LOAD_STATION_02 = Arrays.asList(103, 104);
+//    private static final List<Integer> LOAD_STATION_ALL = Arrays.asList(101, 102, 103, 104);
+    private static final Integer LEFTING_01 = 99;
+//    private static final Integer LEFTING_02 = 99;
+    private static final Integer LOAD_GLASS_ONE_DEVICE = 5;
+    private static final Integer LOAD_GLASS_TWO_DEVICE = 6;
+
+    @Scheduled(fixedDelay = 1000)
+    public void rawStorageTask() throws Exception {
+        S7Data S7DataWL1 = s7Serializer.read(S7Data.class);
+//        S7Data S7DataWL1 = new S7Data();
+//        S7DataWL1.setRequest((short) 1);
+//        S7DataWL1.setConfirmation((short) 0);
+//        S7DataWL1.setReportWord((short) 0);
+//        S7DataWL1.setTaskWord((short) 0);
+//        String requestWord = S7DataWL1.getRequest().toString();
+//        String confireWord = S7DataWL1.getConfirmation().toString();
+//        String reportWord = S7DataWL1.getReportWord().toString();
+//        String taskWord = S7DataWL1.getTaskWord().toString();
+
+        String requestWord = S7DataWL1.getRequest().toString();
+        String confireWord = S7DataWL1.getConfirmation().toString();
+        String reportWord = S7DataWL1.getReportWord().toString();
+        String taskWord = S7DataWL1.getTaskWord().toString();
+        String requestValue = requestWord;
+//        ReadWriteEntity requestWord = miloService.readFromOpcUa("CC.CC.request");
+//        ReadWriteEntity confireWord = miloService.readFromOpcUa("CC.CC.confirmation");
+//        ReadWriteEntity reportWord = miloService.readFromOpcUa("CC.CC.reportWord");
+//        ReadWriteEntity taskWord = miloService.readFromOpcUa("CC.CC.taskWord");
+//        String requestValue = requestWord.getValue() + "";
+        if ("0".equals(requestValue)) {
+            if ("1".equals(confireWord) && "0".equals(reportWord)) {
+//            if ("1".equals(confireWord.getValue() + "") && "0".equals(reportWord.getValue() + "")) {
+                S7Data s7Data = new S7Data();
+                s7Data.setConfirmation((short) 0);
+                s7Serializer.write(s7Data);
+//                List<ReadWriteEntity> list = new ArrayList<>();
+//                list.add(generateReadWriteEntity("CC.CC.confirmation", 0));
+//                miloService.writeToOpcWord(list);
+            }
+            if ("1".equals(taskWord)) {
+//          if ("1".equals(taskWord.getValue() + "")) {
+                S7Data s7Data = new S7Data();
+                s7Data.setTaskWord((short) 0);
+                s7Data.setStartSlot((short) 0);
+                s7Data.setEndSlot((short) 0);
+                s7Serializer.write(s7Data);
+//                List<ReadWriteEntity> list = new ArrayList<>();
+//                list.add(generateReadWriteEntity("CC.CC.taskWord", 0));
+//                list.add(generateReadWriteEntity("CC.CC.startSlot", 0));
+//                list.add(generateReadWriteEntity("CC.CC.endSlot", 0));
+//                miloService.writeToOpcWord(list);
+            }
+            return;
+        }
+        if (!"1".equals(requestValue)) {
+            log.info("鏃犺姹�");
+            return;
+        }
+        //鏄惁鏈夋鍦ㄦ墽琛岀殑浠诲姟
+        boolean flag = isHasRunningTask();
+        if (flag) {
+            log.info("鏈夋湭瀹屾垚鐨勪换鍔★紝缁撴潫");
+            return;
+        }
+        //todo:浼樺厛杩涗笂鐗囨満浣�
+        flag = rawGlassDispatchTask();
+        if (flag) {
+            log.info("鎵ц璋冨害浠诲姟锛岀粨鏉�");
+            return;
+        }
+        flag = inboundRequestTask();
+        if (flag) {
+            log.info("鎵ц鍚婅浣嶈姹備换鍔�");
+            return;
+        }
+        flag = warehouseTask();
+        if (flag) {
+            log.info("鎵ц鍥炲簱浠诲姟");
+            return;
+        }
+        flag = outboundTask();
+        if (flag) {
+            log.info("鎵ц鍑哄簱浠诲姟锛岀粨鏉�");
+            return;
+        }
+        log.info("鏃犱换鍔℃墽琛岋紝缁撴潫");
+    }
+
+    @Scheduled(fixedDelay = 1000)
+    public void rawStorageInCar() throws Exception {
+        S7Data S7DataWL1 = s7Serializer.read(S7Data.class);
+//        S7Data S7DataWL1 = new S7Data();
+//        S7DataWL1.setInCar((short) 1);
+        String value = S7DataWL1.getInCar().toString();
+//        ReadWriteEntity entity = miloService.readFromOpcUa("CC.CC.inCar");
+//        String value = entity.getValue() + "";
+        if (!"1".equals(value)) {
+            log.info("澶ц溅涓婃病鏈夋灦瀛�");
+            return;
+        }
+        //鏌ヨ浠诲姟
+        RawGlassStorageDetails one = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+        if (one == null) {
+            log.info("娌℃湁姝e湪鎵ц鐨勪换鍔�");
+            return;
+        }
+        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>().eq(RawGlassStorageDetails::getId, one.getId())
+                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_CAR));
+    }
+
+    @Scheduled(fixedDelay = 1000)
+    public void rawStorageFinish() throws Exception {
+        S7Data S7DataWL1 = s7Serializer.read(S7Data.class);
+//        S7Data S7DataWL1 = new S7Data();
+//        S7DataWL1.setReportWord((short) 1);
+        String value = S7DataWL1.getReportWord().toString();
+//        ReadWriteEntity entity = miloService.readFromOpcUa("CC.CC.reportWord");
+//        String value = entity.getValue() + "";
+        if ("0".equals(value)) {
+            log.info("褰撳墠浠诲姟鏈眹鎶ワ紝缁撴潫鏈浠诲姟");
+            return;
+        }
+        RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_CAR));
+        if (null == details) {
+            log.info("鏃犳墽琛屼腑鐨勪换鍔�");
+            return;
+        }
+        RawGlassStorageTask task = rawGlassStorageTaskService.getOne(new LambdaQueryWrapper<RawGlassStorageTask>()
+                .in(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING, Const.RAW_GLASS_TASK_NEW));
+        RawGlassStorageDetails targetDetails = rawGlassStorageDetailsService.generateDetails(details, task.getEndSlot());
+        int deviceId = details.getDeviceId();
+        Integer taskType = task.getTaskType();
+        if ("1".equals(value)) {
+            log.info("灏嗚鎯呰〃鐨勭姸鎬佹敼涓哄凡鍑哄簱");
+            rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                    .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_OUT)
+                    .eq(RawGlassStorageDetails::getSlot, task.getStartSlot()).eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_CAR));
+            log.info("浠诲姟鐘舵�佸凡鏇存敼涓猴細宸插畬鎴�");
+            rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                    .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING)
+                    .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_SUCCESS));
+            switch (taskType) {
+                case 1:
+                case 3:
+                    log.info("1銆佸叆搴擄紝3銆佽皟搴︿换鍔°�倇}", taskType);
+                    if (targetDetails.getRemainQuantity() > 0) {
+                        rawGlassStorageDetailsService.save(targetDetails);
+                    }
+                    break;
+                case 2:
+                case 4:
+                    log.info("2銆佸嚭鐗�,4銆佸悐瑁呬綅璇锋眰銆倇}", taskType);
+                    targetDetails = new RawGlassStorageDetails();
+                    targetDetails.setSlot(task.getEndSlot());
+                    targetDetails.setDeviceId(deviceId);
+                    targetDetails.setShelf(task.getStartSlot());
+                    targetDetails.setState(Const.RAW_GLASS_STATE_IN);
+                    rawGlassStorageDetailsService.save(targetDetails);
+                    break;
+                default:
+                    break;
+            }
+        } else {
+            if (taskType.equals(Const.RAW_GLASS_TASK_TYPE_IN_REQUEST)) {
+                rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                        .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_OUT)
+                        .eq(RawGlassStorageDetails::getSlot, task.getStartSlot())
+                        .in(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING, Const.RAW_GLASS_STATE_CAR));
+            } else {
+                rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                        .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN)
+                        .eq(RawGlassStorageDetails::getSlot, task.getStartSlot())
+                        .in(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING, Const.RAW_GLASS_STATE_CAR));
+            }
+            rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                    .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING)
+                    .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_FAILURE));
+
+        }
+        S7Data s7Data = new S7Data();
+        s7Data.setConfirmation((short) 1);
+        s7Serializer.write(s7Data);
+    }
+
+    private boolean isHasRunningTask() {
+        RawGlassStorageTask task = rawGlassStorageTaskService.getOne(new LambdaQueryWrapper<RawGlassStorageTask>()
+                .in(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
+        return task == null ? Boolean.FALSE : Boolean.TRUE;
+    }
+
+    /**
+     * 鍘熺墖璋冨害锛�1銆佹煡璇㈠伐绋嬪師鐗囪〃锛屾寜鐓ч『搴忓皢鍘熺墖鏀惧叆涓婄墖1鍙蜂綅锛屽悗缁師鐗囨斁涓婄墖2鍙蜂綅锛屽嚭鐜板昂瀵告浛鎹紝鍒ゆ柇鍘熶笂鐗囦綅鏄惁鏈夌幓鐠冿紝鏈� 鍏堝嚭鍚庤繘锛屾棤 鐩存帴杩涚墖
+     */
+    public boolean rawGlassDispatchTask() throws Exception {
+        //鏌ヨ褰撳墠绯荤粺姝e湪鎵ц鐨勮鍗�
+        List<Engineering> engineeringList = engineeringMapper.selectList(new LambdaQueryWrapper<Engineering>()
+                .eq(Engineering::getState, Const.ENGINEERING_RUNNING).last("order by id"));
+        if (CollectionUtils.isEmpty(engineeringList)) {
+            log.info("娌℃湁姝e湪鎵ц鐨勫伐绋�");
+            return false;
+        }
+        for (Engineering engineering : engineeringList) {
+            boolean flag = rawGlassDispatchByEngineering(engineering.getStationCell(), engineering.getEngineerId());
+            if (flag) {
+                return flag;
+            }
+        }
+        return Boolean.FALSE;
+
+    }
+
+    /**
+     * 澶勭悊绌烘灦瀛愬悐瑁呬綅璇锋眰浠诲姟锛氬皢浠撳簱鐨勭┖鏋跺瓙閫佸埌鍚婅浣�99锛岀瓑寰呭叆搴�
+     *
+     * @return
+     */
+    public boolean inboundRequestTask() throws Exception {
+        // 姝ラ1锛氭煡璇⑩�滄湭鎵ц鐨勭┖鏋跺瓙鍒板悐瑁呬綅璇锋眰浠诲姟鈥濓紙绫诲瀷IN_REQUEST锛岀姸鎬丯EW锛�
+        RawGlassStorageTask inRequestTask = rawGlassStorageTaskService.getOne(new LambdaQueryWrapper<RawGlassStorageTask>()
+                .eq(RawGlassStorageTask::getTaskType, Const.RAW_GLASS_TASK_TYPE_IN_REQUEST) // 绌烘灦瀛愬叆搴撹姹傜被鍨�
+                .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_NEW)
+                .last("limit 1")); // 姣忔澶勭悊涓�涓换鍔★紝閬垮厤鍐茬獊
+
+        if (inRequestTask == null) {
+            log.info("鏃犲緟鎵ц鐨勭┖鏋跺瓙鍚婅浣嶈姹備换鍔�");
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ2锛氭鏌ヤ换鍔″叧鑱旂殑绌烘灦瀛愮姸鎬侊紙闇�涓衡�滃緟鍏ュ簱鈥濓紝涓旂‘瀹炴槸绌烘灦瀛愶級
+        RawGlassStorageDetails emptyShelf = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, inRequestTask.getStartSlot()) // 璧峰浣嶏細浠撳簱绌烘灦瀛愪綅
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING)); // 寰呭叆搴撶姸鎬�);
+
+        if (emptyShelf == null) {
+            log.info("绌烘灦瀛愬埌鍚婅浣嶈姹備换鍔″叧鑱旂殑鏋跺瓙寮傚父锛堥潪绌烘灦瀛愭垨鐘舵�侀敊璇級锛岃烦杩囨墽琛�");
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ3锛氭鏌ョ洰鏍囧悐瑁呬綅99鏄惁绌洪棽
+        List<RawGlassStorageDetails> liftingShelfList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, inRequestTask.getEndSlot()) // 鐩爣浣嶏細鍚婅浣�99
+                .in(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN_ALL));
+
+        if (CollectionUtil.isNotEmpty(liftingShelfList)) {
+            log.info("鍚婅浣峽}宸叉湁鍏宠仈鏋跺瓙锛屾棤娉曟墽琛岀┖鏋跺瓙鍒板悐瑁呬綅璇锋眰", inRequestTask.getEndSlot());
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ4锛氭洿鏂扮┖鏋跺瓙鐘舵�佷负鈥滄墽琛屼腑鈥�
+        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, emptyShelf.getSlot())
+                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN)
+                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+
+        // 姝ラ5锛氭洿鏂颁换鍔$姸鎬佷负鈥滄墽琛屼腑鈥濓紝閬垮厤閲嶅鎵ц
+        rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                .eq(RawGlassStorageTask::getId, inRequestTask.getId())
+                .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
+
+        // 姝ラ6锛氬彂閫丳LC鎸囦护锛岄┍鍔ㄧ┖鏋跺瓙浠庝粨搴撯啋鍚婅浣�
+        S7Data s7Data = new S7Data();
+        s7Data.setTaskWord((short) 1); // 浠诲姟瑙﹀彂淇″彿
+        s7Data.setStartSlot((short) inRequestTask.getStartSlot().intValue()); // 璧峰浣嶏細浠撳簱绌烘灦瀛愪綅
+        s7Data.setEndSlot((short) inRequestTask.getEndSlot().intValue());     // 鐩爣浣嶏細鍚婅浣�99
+        s7Serializer.write(s7Data);
+
+        log.info("鎵ц绌烘灦瀛愬埌鍚婅浣嶈姹備换鍔★細浠庝粨搴搟}鍒板悐瑁呬綅{}", inRequestTask.getStartSlot(), inRequestTask.getEndSlot());
+        return Boolean.TRUE;
+    }
+
+    /**
+     * 鍑哄簱浠诲姟锛�1銆佺偣鍑哄簱锛岀珛椹敓鎴愬嚭鐗囦换鍔� 2銆佺偣鍑哄簱淇敼宸ヤ綅璇︽儏鍐呯殑鐘舵�佷负寰呭嚭搴擄紝瀹氭椂浠诲姟鎵弿鐢熸垚鍑哄簱浠诲姟
+     */
+    public boolean outboundTask() throws Exception {
+        // 姝ラ1锛氭煡璇㈠凡鐢熸垚鐨勨�滄湭鎵ц鍑哄簱浠诲姟鈥濓紙鐘舵�佷负NEW锛岀被鍨嬩负OUT锛�
+        RawGlassStorageTask outboundTask = rawGlassStorageTaskService.getOne(new LambdaQueryWrapper<RawGlassStorageTask>()
+                .eq(RawGlassStorageTask::getTaskType, Const.RAW_GLASS_TASK_TYPE_OUT)
+                .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_NEW)
+                .last("limit 1")); // 姣忔澶勭悊涓�涓换鍔�
+
+        if (outboundTask == null) {
+            log.info("鏃犲緟鎵ц鐨勫嚭搴撲换鍔�");
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ2锛氳幏鍙栦换鍔″叧鑱旂殑鏋跺瓙璇︽儏锛屾鏌ョ姸鎬佹槸鍚﹀悎娉曪紙寰呭嚭搴擄級
+        RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, outboundTask.getStartSlot()) // 浠诲姟璧峰浣嶏紙浠撳簱浣嶏級
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_WAIT_OUT)); // 寰呭嚭搴撶姸鎬�
+        if (details == null) {
+            log.info("鍑哄簱浠诲姟鍏宠仈鐨勬灦瀛愮姸鎬佸紓甯革紝璺宠繃鎵ц");
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ3锛氭鏌ュ悐瑁呬綅99鏄惁绌洪棽锛堟棤鏋跺瓙锛�
+        List<RawGlassStorageDetails> emptyLeftingList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .in(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN_ALL)
+                .in(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1 and device_id = 4"));
+
+        if (CollectionUtil.isNotEmpty(emptyLeftingList)) {
+            log.info("鍚婅浣�99褰撳墠鏈夋灦瀛愶紝鏃犳硶鎵ц鍑哄簱浠诲姟");
+            return Boolean.FALSE;
+        }
+
+        // 姝ラ4锛氭洿鏂版灦瀛愮姸鎬佷负鈥滄墽琛屼腑鈥�
+        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, details.getSlot())
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_WAIT_OUT)
+                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+
+        // 姝ラ5锛氭洿鏂颁换鍔$姸鎬佷负鈥滄墽琛屼腑鈥濓紙閬垮厤閲嶅鎵ц锛�
+        rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                .eq(RawGlassStorageTask::getId, outboundTask.getId())
+                .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
+
+
+        S7Data s7Data = new S7Data();
+        s7Data.setTaskWord((short) 1);
+        s7Data.setStartSlot((short) outboundTask.getStartSlot().intValue()); // 浠撳簱瀛樺偍浣嶏紙璧峰浣嶏級
+        s7Data.setEndSlot((short) outboundTask.getEndSlot().intValue());     // 鍚婅浣�99锛堢洰鏍囦綅锛�
+        s7Serializer.write(s7Data);
+
+        return Boolean.TRUE;
+    }
+
+    /**
+     * 澶嶄綅浠诲姟锛�1銆佺偣澶嶄綅锛岀珛椹敓鎴愬浣嶄换鍔� 2銆佺偣鍑哄簱淇敼宸ヤ綅璇︽儏鍐呯殑鐘舵�佷负鏋跺瓙澶嶄綅锛屽畾鏃朵换鍔℃壂鎻忕敓鎴愬浣嶄换鍔�
+     */
+    public boolean shelfResetTask() throws Exception {
+        // 1. 鏌ヨ鈥滃緟澶嶄綅鈥濈殑鏋跺瓙锛堢姸鎬佷负RESET锛屼笖宸ヤ綅鍚敤锛�
+        List<RawGlassStorageDetails> rawGlassList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RESET)
+                .inSql(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1"));
+        if (CollectionUtil.isEmpty(rawGlassList)) {
+            log.info("绯荤粺娌℃湁闇�瑕佸浣嶇殑鍘熺墖淇℃伅");
+            return Boolean.FALSE;
+        }
+
+        // 2. 鍙栫涓�鏉″緟澶嶄綅鐨勬灦瀛愶紙姣忔澶勭悊涓�涓級
+        RawGlassStorageDetails details = rawGlassList.get(0);
+        Integer startSlot = details.getSlot();       // 澶嶄綅璧峰浣嶏紙褰撳墠鏋跺瓙鎵�鍦ㄤ綅锛�
+        Integer targetSlot = details.getShelf();     // 澶嶄綅鐩爣浣嶏紙鍒濆浠撳簱瀛樺偍浣嶏級
+
+        // 3. 鐢熸垚澶嶄綅浠诲姟锛堢被鍨嬪缓璁崟鐙畾涔夛細濡侰onst.RAW_GLASS_TASK_TYPE_RESET锛岄伩鍏嶄笌璋冨害浠诲姟娣锋穯锛�
+        rawGlassStorageDetailsService.generateTask(
+                startSlot,
+                targetSlot,
+                targetSlot,
+                details.getRemainQuantity(),
+                Const.RAW_GLASS_TASK_TYPE_DISPATCH
+        );
+
+        // 4. 鏇存柊鏋跺瓙鐘舵�佷负鈥滄墽琛屼腑鈥�
+        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, startSlot)
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RESET)
+                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+
+        // 5. 琛ュ厖PLC浜や簰锛氬彂閫佸浣嶆寚浠�
+        S7Data s7Data = new S7Data();
+        s7Data.setTaskWord((short) 1); // 浠诲姟瑙﹀彂淇″彿
+        s7Data.setStartSlot((short) startSlot.intValue()); // 璧峰浣嶏細褰撳墠鏋跺瓙浣�
+        s7Data.setEndSlot((short) targetSlot.intValue());   // 鐩爣浣嶏細鍒濆浠撳簱浣�
+        s7Serializer.write(s7Data);
+
+        log.info("鎵ц鏋跺瓙澶嶄綅浠诲姟锛氫粠{}鍒皗}", startSlot, targetSlot);
+        return Boolean.TRUE;
+    }
 
     /**
      * 鍏ュ簱浠诲姟锛氬悐瑁呬綅鏈夌幓鐠冿紝鍏堝幓宸ヤ綅琛ㄦ煡璇㈢┖鏍煎瓙锛岀敓鎴愬叆搴撲换鍔′粠鍚婅浣嶅埌鐩爣鏍煎瓙
      *
      * @throws Exception
      */
-    @Scheduled(fixedDelay = 1000)
-    public void warehouseTask() throws Exception {
-        ReadWriteEntity entity = miloService.readFromOpcUa("rawglass.device.request");
-        String value = entity.getValue() + "";
-        if (!"1".equals(value)) {
-            log.info("澶ц溅蹇欑");
-            return;
-        }
-        List<RawGlassStorageDetails> rawGlassList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN)
-                .inSql(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1 and device_id = 4"));
-        if (CollectionUtil.isEmpty(rawGlassList)) {
-            log.info("鍚婅浣嶈绂佺敤鎴栨病鏈夌幓鐠�");
-            return;
-        }
-        //鏌ヨ宸ヤ綅淇℃伅鏄惁鏈�
-        List<RawGlassStorageStation> stationList = rawGlassStorageStationService.list(new LambdaQueryWrapper<RawGlassStorageStation>().notInSql(RawGlassStorageStation::getSlot, "select slot from raw_glass_storage_details where " +
-                "state in('100','102','103')")
-                .eq(RawGlassStorageStation::getEnableState, Const.SLOT_ON));
-        if (CollectionUtil.isEmpty(stationList)) {
-            log.info("娌℃湁绌虹殑宸ヤ綅");
-            return;
-        }
-        //鐢熸垚杩涚浠诲姟
-        generateTask(rawGlassList.get(0).getSlot(), stationList.get(0).getSlot(),
-                rawGlassList.get(0).getRemainQuantity(), Const.RAW_GLASS_STATE_RUNNING);
-        //鐢熸垚宸ヤ綅浠诲姟锛屽皢鍚婅浣嶇殑鐜荤拑鐘舵�佹敼浣嶈繘绗间腑
-//        淇敼鍚婅浣嶇殑鍘熺墖鐘舵�佷负103 鍑虹墖涓�
-        //淇敼鍑虹墖浠诲姟鐘舵��
-        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
-                .eq(RawGlassStorageDetails::getSlot, rawGlassList.get(0).getSlot())
-                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN)
-                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
-//        RawGlassStorageDetails details = new RawGlassStorageDetails();
-//        BeanUtils.copyProperties(rawGlassList.get(0), details);
-    }
+    public boolean warehouseTask() throws Exception {
+//        List<RawGlassStorageDetails> rawGlassList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
+//                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN)
+//                .gt(RawGlassStorageDetails::getRemainQuantity, 0)
+//                .inSql(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1 and device_id = 4")
+//                .inSql(RawGlassStorageDetails::getShelf, "select slot from raw_glass_storage_station where enable_state = 1 "));
+//        if (CollectionUtil.isEmpty(rawGlassList)) {
+//            log.info("鍚婅浣嶈绂佺敤/鏋跺瓙鎵�鍦ㄥ伐浣嶈绂佺敤/鏃犲師鐗囦俊鎭�");
+//            return Boolean.FALSE;
+//        }
+        // 鏌ヨ鍥炲簱浠诲姟
+        RawGlassStorageTask task = rawGlassStorageTaskService.getOne(new LambdaQueryWrapper<RawGlassStorageTask>()
+                .in(RawGlassStorageTask::getTaskType,  Const.RAW_GLASS_TASK_TYPE_IN)
+                .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_NEW)
+                .last("limit 1"));
 
+        if (task == null) {
+            log.info("鏃犲緟鎵ц鐨勫洖搴撲换鍔�");
+            return false;
+        }
+        RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getSlot, task.getStartSlot()) // 浠诲姟璧峰浣嶏紙鍚婅浣嶏級
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING)); // 宸叉爣璁颁负鎵ц涓�
+        if (details == null) {
+            log.info("浠诲姟鍏宠仈鐨勬灦瀛愮姸鎬佸紓甯革紝璺宠繃鎵ц");
+            return false;
+        }
 
-    /**
-     * 鍑哄簱浠诲姟锛�1銆佺偣鍑哄簱锛岀珛椹敓鎴愬嚭鐗囦换鍔� 2銆佺偣鍑哄簱淇敼宸ヤ綅璇︽儏鍐呯殑鐘舵�佷负寰呭嚭搴擄紝瀹氭椂浠诲姟鎵弿鐢熸垚鍑哄簱浠诲姟
-     */
-    @Scheduled(fixedDelay = 1000)
-    public void outboundTask() throws Exception {
-        ReadWriteEntity entity = miloService.readFromOpcUa("rawglass.device.request");
-        String value = entity.getValue() + "";
-        if (!"2".equals(value)) {
-            log.info("澶ц溅蹇欑");
-            return;
-        }
-        List<RawGlassStorageDetails> rawGlassList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_WAIT_OUT));
-//                .inSql(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1 and device_id = 4"));
-        if (CollectionUtil.isEmpty(rawGlassList)) {
-            log.info("绯荤粺娌℃湁闇�瑕佸嚭搴撶殑鍘熺墖淇℃伅");
-            return;
-        }
-        List<Integer> emptyLeftingList = rawGlassStorageDetailsService.listBySlotState(LIFTING_STATION, Arrays.asList(Const.RAW_GLASS_STATE_IN, Const.RAW_GLASS_STATE_RUNNING));
-        if (CollectionUtil.isEmpty(emptyLeftingList)) {
-            log.info("鍚婅浣嶅綋鍓嶉兘鏈夊師鐗囷紝缁撴潫鍑虹墖浠诲姟");
-            return;
-        }
-        //鐢熸垚鍑哄簱浠诲姟
-        generateTask(rawGlassList.get(0).getSlot(), emptyLeftingList.get(0),
-                rawGlassList.get(0).getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_OUT);
-        //淇敼鍑虹墖浠诲姟鐘舵��
-        rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
-                .eq(RawGlassStorageDetails::getSlot, rawGlassList.get(0).getSlot())
-                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_WAIT_OUT)
-                .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+        rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                .eq(RawGlassStorageTask::getId, task.getId())
+                .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
+        log.info("鎵ц鍥炲簱浠诲姟锛氫粠{}鍒皗}", task.getStartSlot(), task.getEndSlot());
+//        List<ReadWriteEntity> list = new ArrayList<>();
+//        list.add(generateReadWriteEntity("CC.CC.taskWord", 1));
+//        list.add(generateReadWriteEntity("CC.CC.taskSending", 1));
+//        list.add(generateReadWriteEntity("CC.CC.startSlot", details.getSlot()));
+//        list.add(generateReadWriteEntity("CC.CC.endSlot", details.getShelf()));
+//        miloService.writeToOpcWord(list);
+
+        S7Data s7Data = new S7Data();
+        s7Data.setTaskWord((short) 1);
+        s7Data.setStartSlot((short) details.getSlot().intValue());
+        s7Data.setEndSlot((short) details.getShelf().intValue());
+        s7Serializer.write(s7Data);
+        return Boolean.TRUE;
     }
 
     /**
-     * 鍘熺墖璋冨害锛�1銆佹煡璇㈠伐绋嬪師鐗囪〃锛屾寜鐓ч『搴忓皢鍘熺墖鏀惧叆涓婄墖1鍙蜂綅锛屽悗缁師鐗囨斁涓婄墖2鍙蜂綅锛屽嚭鐜板昂瀵告浛鎹紝鍒ゆ柇鍘熶笂鐗囦綅鏄惁鏈夌幓鐠冿紝鏈� 鍏堝嚭鍚庤繘锛屾棤 鐩存帴杩涚墖
+     * @param stationCell 璁惧淇℃伅  5  銆� 6
+     * @param enginneerId 鍏变酣鍙�
+     * @return
+     * @throws Exception
      */
-    @Scheduled(fixedDelay = 1000)
-    public void rawGlassDispatchTask() throws Exception {
-        ReadWriteEntity entity = miloService.readFromOpcUa("rawglass.device.request");
-        String value = entity.getValue() + "";
-        if (!"2".equals(value)) {
-            log.info("澶ц溅蹇欑");
-            return;
-        }
-        //鏌ヨ褰撳墠绯荤粺姝e湪鎵ц鐨勮鍗�
-        List<Engineering> engineeringList = engineeringMapper.selectList(new LambdaQueryWrapper<Engineering>()
-                .eq(Engineering::getState, Const.ENGINEERING_RUNNING).last("order by id"));
-        if (CollectionUtils.isEmpty(engineeringList)) {
-            log.info("娌℃湁姝e湪鎵ц鐨勫伐绋�");
-            return;
-        }
-        //绾胯矾 + 宸ョ▼鍚�
-        //todo:鎸夌収璺嚎鍙婂伐绋嬪彿锛岃繘琛屽嚭鐗囦换鍔�
-        String stationCell = engineeringList.get(0).getStationCell();
-        String enginneerId = engineeringList.get(0).getEngineerId();
-
+    private boolean rawGlassDispatchByEngineering(int stationCell, String enginneerId) throws Exception {
         //褰撳墠灏哄闇�瑕佷笂鐗囩殑鏁伴噺
         List<UpPattenUsageVO> pattenUsageList = upPattenUsageMapper.queryRawGlassByEngineeringId(enginneerId);
         if (CollectionUtils.isEmpty(pattenUsageList)) {
             log.info("姝e湪鎵ц鐨勫伐绋嬪師鐗囨棤鍙笂鐗囩殑鍘熺墖淇℃伅");
-            return;
+            return Boolean.FALSE;
         }
+        //鑾峰彇褰撳墠闇�瑕佷笂鐗囩殑鍘熺墖鏁版嵁
         Map<String, List<UpPattenUsageVO>> upListMap = pattenUsageList.stream()
                 .collect(Collectors.groupingBy(UpPattenUsageVO::getGroupNumber));
-        //todo:鎸夌収宸ョ▼鍙锋寜鐓у伐绋嬩笅鏈畬鎴愮殑灏哄鐨勯『搴忥紝褰�1鍙蜂笂鐗囦綅鏋跺瓙涓婄殑褰撳墠灏哄鐜荤拑灏戜簬3鐗囦笖2鍙蜂笂鐗囦綅鏃犲師鐗囩幓鐠冿紝鍒欏皢鍘昏皟搴︾幓鐠冨幓2鍙蜂笂鐗囦綅锛�
-        //todo:褰撲竴鍙蜂笂鐗囦綅鏋跺瓙涓婄殑鐜荤拑浣嶇┖鎴栬�呭綋鍓嶅昂瀵哥敤瀹屾椂鏃讹紝灏�2鍙凤紙鏈夌幓鐠冿級涓婄墖浣嶈皟搴﹀埌1鍙蜂笂鐗囦綅
-        //1銆佹煡璇�4涓笂鐗囩殑鍘熺墖璇︽儏
-        List<RawGlassStorageDetails> rawGlassDetailsList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN).in(RawGlassStorageDetails::getSlot, LOAD_STATION_01));
-        if (CollectionUtils.isEmpty(rawGlassDetailsList)) {
-            //琛ㄧず1涓婄墖浣嶆病鏈夊師鐗囷紝鐩存帴鎵惧師鐗囨斁鍏ュ搴旂殑涓婄墖浣�
-            List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("1");
-            UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-            RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                    .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                    .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                    .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                    .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                    .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                    .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                    .last("limit 1")
-            );
-            generateTask(details.getSlot(), 1, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-            //缁撴潫璋冨害浠诲姟
+        List<UpPattenUsageVO> usageVOS = upListMap.get("1");
+        //鑾峰彇褰撳墠涓婄墖浣�1鍙锋灦瀛愪俊鎭�
+        List<Integer> loadStation = LOAD_STATION_01;
+        List<RawGlassStorageStation> stations = rawGlassStorageStationService.list(new LambdaQueryWrapper<RawGlassStorageStation>()
+                .in(RawGlassStorageStation::getSlot, loadStation)
+                .eq(RawGlassStorageStation::getEnableState, Const.SLOT_ON)
+                .orderByAsc(RawGlassStorageStation::getSlot));
+        if (CollectionUtils.isEmpty(stations)) {
+            log.info("101鐨勪笂鐗囦綅涓嶅彲鐢�");
+            return Boolean.FALSE;
         }
-        Map<Integer, List<RawGlassStorageDetails>> listMap = rawGlassDetailsList.stream().collect(Collectors.groupingBy(RawGlassStorageDetails::getSlot));
-        RawGlassStorageDetails rawGlass03Details = listMap.get(3).get(0);
-        RawGlassStorageDetails rawGlass04Details = listMap.get(4).get(0);
-//        RawGlassStorageDetails rawGlass05Details = listMap.get(5).get(0);
-//        RawGlassStorageDetails rawGlass06Details = listMap.get(6).get(0);
-        //todo:涓婄墖1鍙蜂綅2绉嶆竻绌烘柟寮忥細鏂瑰紡涓�锛氬師鐗囩敤瀹�  鏂瑰紡浜岋細褰撳墠灏哄鐢ㄥ畬
-        if (null == rawGlass03Details) {
-            if (null == rawGlass04Details) {
-                //琛ㄧず1涓婄墖浣嶆病鏈夊師鐗囷紝鐩存帴鎵惧師鐗囨斁鍏ュ搴旂殑涓婄墖浣�
-                List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("1");
-                UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-                RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                        .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                        .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                        .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                        .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                        .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                        .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                        .last("limit 1")
-                );
-                generateTask(details.getSlot(), 1, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-                //缁撴潫璋冨害浠诲姟
-            } else {
-                //灏�2鍙蜂笂鐗囦綅鐨勫師鐗囨斁鍏�1鍙蜂笂鐗囦綅
-                generateTask(2, 1, rawGlass04Details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-                //缁撴潫璋冨害浠诲姟
+
+        List<RawGlassStorageDetails> loadStationList = rawGlassStorageDetailsService.list(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .inSql(RawGlassStorageDetails::getSlot, "select slot from raw_glass_storage_station where enable_state = 1")
+                .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN)
+                .eq(RawGlassStorageDetails::getDeviceId, stationCell));
+        if (CollectionUtils.isEmpty(loadStationList)) {
+            RawGlassStorageDetails rawDetails = getRawGlassStorageDetailsBySize(usageVOS.get(0), usageVOS.size());
+            if (rawDetails == null) {
+                log.info("浠撳簱鏃犲尮閰嶈鏍肩殑鍘熺墖锛屾棤娉曡皟搴﹀埌101宸ヤ綅");
+                return Boolean.FALSE;
             }
-        } else {
-            if (null == rawGlass04Details) {
-                List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("2");
-                if (CollectionUtils.isEmpty(upPattenUsage01VOS)) {
-                    return;
-                }
-                UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-                RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                        .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                        .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                        .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                        .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                        .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                        .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                        .last("limit 1")
-                );
-                generateTask(details.getSlot(), 2, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-            }
-        }
+            // 鐢熸垚璋冨害浠诲姟锛氫粨搴撳師鐗囦綅 鈫� 101涓婄墖浣�
+            rawGlassStorageDetailsService.generateTask(
+                    rawDetails.getSlot(),
+                    stations.get(0).getSlot(),
+                    rawDetails.getShelf(),
+                    rawDetails.getRemainQuantity(),
+                    Const.RAW_GLASS_TASK_TYPE_DISPATCH);
 
+            rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                    .eq(RawGlassStorageTask::getTaskType, Const.RAW_GLASS_TASK_TYPE_DISPATCH)
+                    .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_NEW)
+                    .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
 
-    }
+            rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                    .eq(RawGlassStorageDetails::getSlot, rawDetails.getSlot())
+                    .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN)
+                    .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+            S7Data s7Data = new S7Data();
+            s7Data.setTaskWord((short) 1);
+            s7Data.setStartSlot((short) rawDetails.getSlot().intValue()); // 璧峰浣嶏細浠撳簱
+            s7Data.setEndSlot((short) LOAD_STATION_01.get(0).intValue()); // 鐩爣浣嶏細涓婄墖浣�101
+            s7Serializer.write(s7Data); // 鍙戦�佸埌PLC
 
-    private boolean queryDispatchTask(String stationCell, String enginneerId) {
-        //todo:鎸夌収宸ョ▼鍙锋寜鐓у伐绋嬩笅鏈畬鎴愮殑灏哄鐨勯『搴忥紝褰�1鍙蜂笂鐗囦綅鏋跺瓙涓婄殑褰撳墠灏哄鐜荤拑灏戜簬3鐗囦笖2鍙蜂笂鐗囦綅鏃犲師鐗囩幓鐠冿紝鍒欏皢鍘昏皟搴︾幓鐠冨幓2鍙蜂笂鐗囦綅锛�
-        //todo:褰撲竴鍙蜂笂鐗囦綅鏋跺瓙涓婄殑鐜荤拑浣嶇┖鎴栬�呭綋鍓嶅昂瀵哥敤瀹屾椂鏃讹紝灏�2鍙凤紙鏈夌幓鐠冿級涓婄墖浣嶈皟搴﹀埌1鍙蜂笂鐗囦綅
-        //1銆佹煡璇笂鐗囩嚎璺搴斿伐浣嶇殑鍘熺墖淇℃伅
-        LambdaQueryWrapper<RawGlassStorageDetails> wrapper = new LambdaQueryWrapper<>();
-        wrapper.eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN);
-        if ("1".equals(stationCell)) {
-            wrapper.in(RawGlassStorageDetails::getSlot, LOAD_STATION_01);
-        } else {
-            wrapper.in(RawGlassStorageDetails::getSlot, LOAD_STATION_02);
-        }
-        List<RawGlassStorageDetails> rawGlassDetailsList = rawGlassStorageDetailsService.list(wrapper);
-        if (CollectionUtils.isEmpty(rawGlassDetailsList)) {
-            //鐩存帴鐢熸垚璋冨害浠诲姟
-            generateTask(1, 2, 34, 4);
+            log.info("璋冨害浠诲姟宸插彂閫丳LC锛氫粠浠撳簱{}鍒颁笂鐗囦綅{}", rawDetails.getSlot(), LOAD_STATION_01);
             return Boolean.TRUE;
         }
-        if (rawGlassDetailsList.size() == 2) {
-            return Boolean.FALSE;
-        }
-        int maxStationSlot = rawGlassDetailsList.stream().mapToInt(RawGlassStorageDetails::getSlot).max().orElse(0);
-        if (LOAD_STATION_MAX.contains(maxStationSlot)) {
-            return Boolean.FALSE;
-        }
-        //浜屽彿涓婄墖锛氱洿鎺ョ敓鎴愯皟搴︿换鍔�
-        generateTask(1, 2, 34, 4);
-        return Boolean.TRUE;
+        // 涓婄墖浣�101鏈夌幓鐠� 鈫� 鍒ゆ柇灏哄鏄惁鍖归厤
+        RawGlassStorageDetails oneLoadStation = loadStationList.get(0);
+        if (oneLoadStation.getRemainQuantity() <= 0 || !compareRawSize(usageVOS.get(0), oneLoadStation)) {
 
-
-        //褰撳墠灏哄闇�瑕佷笂鐗囩殑鏁伴噺
-        List<UpPattenUsageVO> pattenUsageList = upPattenUsageMapper.queryRawGlassByEngineeringId(enginneerId);
-        if (CollectionUtils.isEmpty(pattenUsageList)) {
-            log.info("姝e湪鎵ц鐨勫伐绋嬪師鐗囨棤鍙笂鐗囩殑鍘熺墖淇℃伅");
-            return Boolean.FALSE;
-        }
-        Map<String, List<UpPattenUsageVO>> upListMap = pattenUsageList.stream()
-                .collect(Collectors.groupingBy(UpPattenUsageVO::getGroupNumber));
-
-
-        if (CollectionUtils.isEmpty(rawGlassDetailsList)) {
-            //琛ㄧず1涓婄墖浣嶆病鏈夊師鐗囷紝鐩存帴鎵惧師鐗囨斁鍏ュ搴旂殑涓婄墖浣�
-            List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("1");
-            UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-            RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                    .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                    .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                    .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                    .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                    .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                    .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                    .last("limit 1")
-            );
-            generateTask(details.getSlot(), 1, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-            //缁撴潫璋冨害浠诲姟
-        }
-        Map<Integer, List<RawGlassStorageDetails>> listMap = rawGlassDetailsList.stream().collect(Collectors.groupingBy(RawGlassStorageDetails::getSlot));
-        RawGlassStorageDetails rawGlass03Details = listMap.get(3).get(0);
-        RawGlassStorageDetails rawGlass04Details = listMap.get(4).get(0);
-//        RawGlassStorageDetails rawGlass05Details = listMap.get(5).get(0);
-//        RawGlassStorageDetails rawGlass06Details = listMap.get(6).get(0);
-        //todo:涓婄墖1鍙蜂綅2绉嶆竻绌烘柟寮忥細鏂瑰紡涓�锛氬師鐗囩敤瀹�  鏂瑰紡浜岋細褰撳墠灏哄鐢ㄥ畬
-        if (null == rawGlass03Details) {
-            if (null == rawGlass04Details) {
-                //琛ㄧず1涓婄墖浣嶆病鏈夊師鐗囷紝鐩存帴鎵惧師鐗囨斁鍏ュ搴旂殑涓婄墖浣�
-                List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("1");
-                UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-                RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                        .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                        .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                        .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                        .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                        .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                        .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                        .last("limit 1")
-                );
-                generateTask(details.getSlot(), 1, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-                //缁撴潫璋冨害浠诲姟
-            } else {
-                //灏�2鍙蜂笂鐗囦綅鐨勫師鐗囨斁鍏�1鍙蜂笂鐗囦綅
-                generateTask(2, 1, rawGlass04Details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-                //缁撴潫璋冨害浠诲姟
+            // 妫�鏌ヤ笂鐗囨満鏄惁姝e湪宸ヤ綔锛岃嫢姝e湪宸ヤ綔鍒欎笉鐢熸垚閫�鍥炰换鍔�
+            if (pattenUsageList.stream().allMatch(vo -> vo.getState() == 101)) {
+                log.warn("涓婄墖鏈簕}姝e湪宸ヤ綔锛屾棤娉曟墽琛岄��鍥炰换鍔�", stationCell);
+                return Boolean.FALSE;
             }
-        } else {
-            if (null == rawGlass04Details) {
-                List<UpPattenUsageVO> upPattenUsage01VOS = upListMap.get("2");
-                if (CollectionUtils.isEmpty(upPattenUsage01VOS)) {
-                    return;
-                }
-                UpPattenUsageVO usageVO = upPattenUsage01VOS.get(0);
-                RawGlassStorageDetails details = rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
-                        .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
-                        .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
-                        .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
-                        .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
-                        .gt(RawGlassStorageDetails::getRemainQuantity, upPattenUsage01VOS.size())
-                        .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
-                        .last("limit 1")
-                );
-                generateTask(details.getSlot(), 2, details.getRemainQuantity(), Const.RAW_GLASS_TASK_TYPE_DISPATCH);
-            }
-        }
 
+            // 鐢熸垚閫�鍥炰换鍔★細101涓婄墖浣� 鈫� 鍘熶粨搴撳瓨鍌ㄤ綅
+            rawGlassStorageDetailsService.generateTask(
+                    stations.get(0).getSlot(),
+                    oneLoadStation.getShelf(),
+                    oneLoadStation.getShelf(),
+                    oneLoadStation.getRemainQuantity(),
+                    Const.RAW_GLASS_TASK_TYPE_DISPATCH);
+
+            rawGlassStorageTaskService.update(new LambdaUpdateWrapper<RawGlassStorageTask>()
+                    .eq(RawGlassStorageTask::getTaskType, Const.RAW_GLASS_TASK_TYPE_DISPATCH)
+                    .eq(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_NEW)
+                    .set(RawGlassStorageTask::getTaskState, Const.RAW_GLASS_TASK_RUNNING));
+
+            rawGlassStorageDetailsService.update(new LambdaUpdateWrapper<RawGlassStorageDetails>()
+                    .eq(RawGlassStorageDetails::getSlot, oneLoadStation.getSlot())
+                    .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN)
+                    .set(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_RUNNING));
+            S7Data s7Data = new S7Data();
+            s7Data.setTaskWord((short) 1); // 浠诲姟瑙﹀彂淇″彿
+            s7Data.setStartSlot((short) LOAD_STATION_01.get(0).intValue()); // 璧峰浣嶏細涓婄墖浣�101
+            s7Data.setEndSlot((short) oneLoadStation.getShelf().intValue()); // 鐩爣浣嶏細浠撳簱
+            s7Serializer.write(s7Data); // 鍙戦�佸埌PLC
+
+            log.info("閫�鍥炰换鍔″凡鍙戦�丳LC锛氫粠涓婄墖浣峽}鍒颁粨搴搟}", LOAD_STATION_01, oneLoadStation.getShelf());
+            return Boolean.FALSE;
+        }
+        // 涓婄墖浣�101鐜荤拑灏哄鍖归厤涓旀暟閲忓厖瓒� 鈫� 鏃犻渶璋冨害
+        log.info("101宸ヤ綅鐜荤拑灏哄鍖归厤涓旀暟閲忓厖瓒筹紝鏃犻渶璋冨害");
+        return Boolean.FALSE;
     }
 
+    private ReadWriteEntity generateReadWriteEntity(String identifier, int value) {
+        ReadWriteEntity readWriteEntity = new ReadWriteEntity();
+        readWriteEntity.setIdentifier(identifier);
+        readWriteEntity.setValue(value);
+        return readWriteEntity;
+    }
+
+    private RawGlassStorageDetails getRawGlassStorageDetailsBySize(UpPattenUsageVO usageVO, int remainQuantity) {
+        return rawGlassStorageDetailsService.getOne(new LambdaQueryWrapper<RawGlassStorageDetails>()
+                .eq(RawGlassStorageDetails::getFilmsId, usageVO.getFilmsId())
+                .eq(RawGlassStorageDetails::getPatternWidth, usageVO.getWidth())
+                .eq(RawGlassStorageDetails::getPatternHeight, usageVO.getHeight())
+                .eq(RawGlassStorageDetails::getPatternThickness, usageVO.getThickness())
+                .notIn(RawGlassStorageDetails::getSlot, LOAD_STATION_01)
+                .eq(RawGlassStorageDetails::getState, Const.GLASS_STATE_IN)
+                .orderByAsc(RawGlassStorageDetails::getRemainQuantity)
+                .last("order by abs(t.remain_quantity - " + remainQuantity + ")  asc")
+                .last("limit 1"));
+    }
 
     /**
-     * 鐢熸垚鍘熺墖浠撳偍浠诲姟
+     * 灏哄涓�鏍峰苟涓斿師鐗囨暟閲忓ぇ浜�0
      *
-     * @param startSlot
-     * @param endSlot
-     * @param patternQuantity
-     * @param taskType
+     * @param upPattenUsage
+     * @param details
      * @return
      */
-    private boolean generateTask(int startSlot, int endSlot, Integer patternQuantity, int taskType) {
-        RawGlassStorageTask task = RawGlassStorageTask.builder()
-                .startSlot(startSlot)
-                .endSlot(endSlot)
-                .patternQuantity(patternQuantity)
-                .taskType(taskType)
-                .createTime(new Date()).build();
-        return rawGlassStorageTaskService.save(task);
+    private boolean compareRawSize(UpPattenUsage upPattenUsage, RawGlassStorageDetails details) {
+        boolean flag = upPattenUsage.getWidth() == details.getPatternWidth() && upPattenUsage.getHeight() == details.getPatternHeight() &&
+                upPattenUsage.getThickness() == details.getPatternThickness() && upPattenUsage.getFilmsId().equals(details.getFilmsId());
+        return flag;
     }
+
 }
+

--
Gitblit v1.8.0