From c7b4647fbcebf9a097a948110ca9a195827ac430 Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期一, 13 五月 2024 11:00:43 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java | 483 +++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 340 insertions(+), 143 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java index cb8a805..0f0b2a6 100644 --- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java +++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java @@ -1,13 +1,18 @@ package com.mes.job; -import cn.hutool.core.date.DateTime; -import cn.hutool.json.JSONObject; +import cn.hutool.core.collection.CollectionUtil; +import cn.hutool.core.lang.Assert; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.github.yulichang.query.MPJQueryWrapper; import com.github.yulichang.wrapper.MPJLambdaWrapper; import com.mes.common.S7object; -import com.mes.common.WebSocketServer; +import com.mes.common.config.Const; +import com.mes.device.PlcParameterObject; +import com.mes.edgglasstask.entity.EdgGlassTaskInfo; +import com.mes.edgglasstask.service.EdgGlassTaskInfoService; import com.mes.edgstoragecage.entity.EdgStorageCage; import com.mes.edgstoragecage.entity.EdgStorageCageDetails; -import com.mes.edgstoragecage.mapper.EdgStorageCageDetailsMapper; import com.mes.edgstoragecage.service.EdgStorageCageDetailsService; import com.mes.edgstoragecage.service.EdgStorageCageService; import com.mes.glassinfo.entity.GlassInfo; @@ -15,15 +20,16 @@ import com.mes.taskcache.entity.TaskCache; import com.mes.taskcache.service.TaskCacheService; import lombok.extern.slf4j.Slf4j; +import org.apache.commons.lang.StringUtils; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; -import javax.annotation.Resource; import java.util.ArrayList; -import java.util.HashMap; +import java.util.Date; import java.util.List; -import java.util.Map; /** * @Author : zhoush @@ -42,164 +48,355 @@ EdgStorageCageService edgStorageCageService; @Autowired EdgStorageCageDetailsService edgStorageCageDetailsService; - @Resource - private EdgStorageCageDetailsMapper edgStorageCageDetailsMapper; - private Map<String, String> mapParameter = new HashMap<>(); - private Map<String, String> mapValue = new HashMap<>(); - private Map<String, String> mapType = new HashMap<>(); - private Map<String, Object> mapSettings = new HashMap<>(); + @Autowired + EdgGlassTaskInfoService edgGlassTaskInfoService; + + @Value("${mes.threshold}") + private int threshold; + + @Value("${mes.ratio}") + private int ratio; @Scheduled(fixedDelay = 1000) public void plcHomeEdgTask() { - initialize(); - log.info("褰撳墠鍙傛暟鍊硷細{}", mapValue); - JSONObject jsonObject = new JSONObject(); -// for (String key : mapParameter.keySet()) { -// String value = ""; -// if ("String".equals(mapType.get(key))) { -// value = S7object.getinstance().plccontrol.readString(mapParameter.get(key)); -// } else { -// value = S7object.getinstance().plccontrol.readWord(mapParameter.get(key)) + ""; -// } -// mapValue.put(key, value); -// } + PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject; + String taskRequestTypeValue = plcParameterObject.getPlcParameter("A06_request_word").getValue(); + String glassIdeValue = plcParameterObject.getPlcParameter("A05_scanning_ID").getValue(); + String confirmationWrodValue = plcParameterObject.getPlcParameter("MES_confirmation_word").getValue(); + //A08 A09琛ㄧず绾胯矾鐩稿悓 鍙仛绛変环 鏃犳暟鎹浆int寮傚父 + String out08Glassstate = plcParameterObject.getPlcParameter("A08_glass_status").getValue(); + String out10Glassstate = plcParameterObject.getPlcParameter("A10_glass_status").getValue(); + String confirmationWrodAddress = plcParameterObject.getPlcParameter("MES_confirmation_word").getAddress(); + String currentSlot = plcParameterObject.getPlcParameter("Current_slot").getValue(); - if ("0".equals(mapValue.get("A06_request_word"))) { - log.info("鑾峰彇鍒扮殑璇锋眰瀛椾负0锛屽皢纭瀛楁敼涓�0"); - //娓呴櫎 - S7object.getinstance().plccontrol.WriteWord(mapParameter.get("MES_confirmation_word"), (short) 0); - } else if ("1".equals(mapValue.get("A06_request_word")) && - "0".equals(mapValue.get("MES_confirmation_word"))) { - log.info("杩涚墖璇锋眰锛屼笖纭瀛椾负0锛屾墽琛岃繘鐗囦换鍔�"); - inTo(); - } else if ("2".equals(mapValue.get("A06_request_word")) && - "0".equals(mapValue.get("MES_confirmation_word")) && !"0".equals(mapValue.get("A09_glass_status"))) { - //09绌洪棽 锛�1 10绌洪棽 锛�2 閮界┖闂诧細3 鍏朵粬0 - log.info("鍑虹墖璇锋眰锛屼笖纭瀛椾负0锛屾墽琛岃繘鐗囦换鍔�"); - outTo(Integer.parseInt(mapValue.get("A09_glass_status"))); - } else if ("3".equals(mapValue.get("A06_request_word")) && - "0".equals(mapValue.get("MES_confirmation_word"))) { +// String taskRequestTypeValue = "2"; +// String glassIdeValue = "2222222222"; +// String confirmationWrodValue = "0"; +// //A08 A09琛ㄧず绾胯矾鐩稿悓 鍙仛绛変环 +// Integer out08Glassstate = 1; +// Integer out10Glassstate = 0; +// String confirmationWrodAddress = "DB11.38"; +// String currentSlot = "1"; - if ("0".equals(mapValue.get("A09_glass_status")) || "0".equals(mapValue.get("A10_glass_status"))) { - outTo(Integer.parseInt(mapValue.get("A09_glass_status"))); - } else { - inTo(); + + log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佸垎鍒负锛欰09:{}銆丄10:{},褰撳墠鏍煎瓙鍙蜂负锛歿}", + taskRequestTypeValue, glassIdeValue, confirmationWrodValue, out08Glassstate, out10Glassstate, currentSlot); + + if ("0".equals(taskRequestTypeValue)) { + if ("0".equals(confirmationWrodValue)) { + log.info("2銆佽幏鍙栧埌鐨勮姹傚瓧涓�0锛屼笖纭瀛椾负0锛屼笉鎵ц浠诲姟"); + return; } + log.info("2銆佽幏鍙栧埌鐨勮姹傚瓧涓�0锛屽皢纭瀛楁敼涓�0"); + S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 0); + return; } -// log.info("鎺ㄦ暟鎹�"); - // jsonObject.append("params", new short[] { 30, 40, }); - ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("Home"); - if (sendwServer != null) { - for (WebSocketServer webserver : sendwServer) { - webserver.sendMessage(jsonObject.toString()); - if (webserver != null) { - - List<String> messages = webserver.getMessages(); - - if (!messages.isEmpty()) { - // // 灏嗘渶鍚庝竴涓秷鎭浆鎹负鏁存暟绫诲瀷鐨勫垪琛� - webserver.clearMessages(); - } + if (!"0".equals(confirmationWrodValue)) { + log.info("2銆佽幏鍙栧埌鐨勮姹傚瓧涓嶄负0锛屽皢纭瀛楁敼涓�0"); + S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 0); + return; + } + if ("1".equals(taskRequestTypeValue)) { + log.info("2銆佽繘鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + inTo(glassIdeValue, confirmationWrodAddress, currentSlot); + } else if ("2".equals(taskRequestTypeValue)) { + //09绌洪棽 锛�1 10绌洪棽 锛�2 閮界┖闂诧細3 鍏朵粬0 + log.info("2銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + outTo(Integer.parseInt(out08Glassstate), + Integer.parseInt(out10Glassstate), confirmationWrodAddress); + } else if ("3".equals(taskRequestTypeValue)) { + log.info("2銆佽繘鐗囧拰鍑虹墖閮界┖闂诧紝鎵ц鍑虹墖浠诲姟"); + //鍔犵瀛愰噷闈㈡槸鍚︽湁鐜荤拑锛屾湁鍏堝嚭锛屾棤鐜荤拑鍏堣繘 + int count = edgStorageCageDetailsService.count(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)); + if ("0".equals(out08Glassstate) && "0".equals(out10Glassstate) && count < 9) { + inTo(glassIdeValue, confirmationWrodAddress, currentSlot); + } else { + boolean outFlase = outTo(Integer.parseInt(out08Glassstate), + Integer.parseInt(out10Glassstate), confirmationWrodAddress); + log.info("鍑虹墖浠诲姟鏄惁瀹屾垚锛歿},澶辫触涓旂幓鐠僫d:{}涓嶄负绌哄垯鎵ц杩涚墖浠诲姟", outFlase, glassIdeValue); + if (!outFlase && StringUtils.isNotBlank(glassIdeValue)) { + inTo(glassIdeValue, confirmationWrodAddress, currentSlot); } } } } /** - * 鍒濆鍖杙lc鏁版嵁 + * 杩涚墖浠诲姟 + * + * @param glassId + * @param confirmationWrodAddress + * @param currentSlot */ - private void initialize() { -// mapParameter.put("A06_request_word", "DB11.0"); //work -// mapParameter.put("A05_scanning_ID", "DB11.2"); -// mapParameter.put("MES_confirmation_word", "DB11.40"); -// mapParameter.put("A09_glass_status", "DB11.70"); -// //mapParameter.put("A10_glass_status", "DB11.72"); -// mapParameter.put("A09_prohibit_film_production", "DB11.74"); -// mapParameter.put("A10_prohibit_film_production", "DB11.76"); -// mapSettings.put("territoryPoor", 3); -// mapType.put("A06_request_word", "Word"); -// mapType.put("A05_scanning_ID", "String"); -// mapType.put("MES_confirmation_word", "Word"); -// mapType.put("A09_glass_status", "Word"); -// //mapType.put("A10_glass_status", "Word"); -// mapType.put("A09_prohibit_film_production", "Word"); -// mapType.put("A10_prohibit_film_production", "Word"); - mapValue.put("A06_request_word", "2");//璇锋眰瀛� - mapValue.put("A05_scanning_ID", "11111111111");//璇锋眰ID - mapValue.put("MES_confirmation_word", "0");//MES鍙戦�佸瓧 - mapValue.put("A09_glass_status", "1");//A09鐜荤拑鐘舵�� - mapValue.put("A10_glass_status", "0");//A09鐜荤拑鐘舵�� - mapValue.put("A09_prohibit_film_production", "0");//A9绂佹鍑虹墖 - mapValue.put("A10_prohibit_film_production", "0");//A10绂佹鍑虹墖 - - } - - private void inTo() { - List<GlassInfo> glassInfos = glassInfoService.selectId(mapValue.get("A05_scanning_ID")); - if (glassInfos.size() < 1) { - log.info("姝ょ幓鐠冪紪鍙蜂笉瀛樺湪"); - } else if (glassInfos.size() == 1) { - //娣诲姞杩涚墖浠诲姟 鏌ユ壘绌烘牸 - log.info("姝e父"); - List<EdgStorageCage> list = edgStorageCageService.selectCacheEmpty(); - - if (list.size() > 1) { - EdgStorageCageDetails edgStorageCageDetails = edgStorageCageDetailsMapper.selectOne(new MPJLambdaWrapper<EdgStorageCageDetails>() - .eq(EdgStorageCageDetails::getGlassId, glassInfos.get(0).getGlassId())); - edgStorageCageDetails.setState(200); - - TaskCache taskCache = new TaskCache(); - EdgStorageCage edgStorageCage = list.get(0); - taskCache.setGlassId(glassInfos.get(0).getGlassId()); - taskCache.setTaskStatus(0); - taskCache.setStartCell(0); - taskCache.setEndCell(edgStorageCage.getSlot()); - taskCache.setTaskType(1); - taskCache.setCreateTime(new DateTime()); - edgStorageCageDetailsMapper.updateById(edgStorageCageDetails); - taskCacheService.insertTaskCache(taskCache); -// S7object.getinstance().plccontrol.WriteWord("DB11.40", (short) 1); - } else { - log.info("涓嶅瓨鍦ㄧ┖鏍�"); - } - } else { - log.info("姝ょ幓鐠冪紪鍙峰瓨鍦ㄥ涓�"); + private void inTo(String glassId, String confirmationWrodAddress, String currentSlot) { + log.info("1銆佹寜鐓х幓鐠僫d:{}鑾峰彇鐜荤拑灏忕墖淇℃伅,褰撳墠鏍煎瓙涓�:{}", glassId, currentSlot); + GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId)); + if (glassInfo == null) { + log.info("2銆佹鐜荤拑缂栧彿涓嶅瓨鍦�"); + return; } + log.info("2銆佽幏鍙栧埌鐨勭幓鐠冧俊鎭负{}", glassInfo); + //娣诲姞杩涚墖浠诲姟 鏌ユ壘绌烘牸 + EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(Integer.parseInt(currentSlot)); + Assert.isTrue(null != nearestEmpty, "鏍煎瓙宸叉弧"); + log.info("3銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", nearestEmpty); + + log.info("4銆佸皢鐜荤拑淇℃伅鎻掑叆鍗у紡鐞嗙墖绗�,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); + EdgStorageCageDetails details = new EdgStorageCageDetails(); + BeanUtils.copyProperties(glassInfo, details); + details.setState(Const.GLASS_STATE_IN); + details.setSlot(nearestEmpty.getSlot()); + details.setDeviceId(nearestEmpty.getDeviceId()); + edgStorageCageDetailsService.save(details); + log.info("5銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details); + //娣诲姞杩涚墖浠诲姟 + boolean taskCache = saveTaskCache(details.getGlassId(), 0, nearestEmpty.getSlot(), Const.GLASS_CACHE_TYPE_IN); + log.info("6銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃鏄惁瀹屾垚锛歿}", taskCache); + + S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 1); + log.info("7銆佸彂閫佺‘璁ゅ瓧瀹屾垚"); + + } - private void outTo(int line) { + /** + * 鍑虹墖浠诲姟 + * + * @param out08Glassstate + * @param out10Glassstate + * @param confirmationWrodAddress + */ + private boolean outTo(int out08Glassstate, int out10Glassstate, String confirmationWrodAddress) { + //閫昏緫姝ラ锛� +// 0銆丄09銆丄10鏄惁绌洪棽锛屾槸鍚﹀彲浠ユ墽琛屽嚭鐗囦换鍔� +// 1銆佽幏鍙栭挗鍖栫増鍥炬槸鍚﹁秴杩囬槇鍊� +// 1.1銆佽秴杩囬槇鍊硷細鑾峰彇褰撳墠鏈�灏忕増鍥鹃渶瑕佸嚭鐗囩殑鐜荤拑淇℃伅 +// 1.1.1銆佽幏鍙栦袱鏉$嚎鏈�鍚庝竴娆″嚭鐗囩殑浠诲姟淇℃伅 +// 1.1.2銆佹寜鐓у嚭鐗囦俊鎭幓璇︽儏琛ㄦ煡璇㈡牸瀛愬湪绗煎瓙閲岄潰鍓╀綑鐩稿悓灏哄鐨勭幓鐠冩暟鎹� +// 1.1.3銆佸垽鏂摢鏉$嚎鐜荤拑鏁伴噺鍦ㄧ悊鐗囩鍐呯殑鏁版嵁鏈�灏戯紝鍐冲畾鏈�灏忕増鍥捐蛋璇ユ潯绾匡紙闂锛氬鏋滆繖鏉$嚎闈炵┖闂诧紝鐩存帴缁撴潫锛� +// 1.2銆佹湭瓒呰繃闃堝�硷細 +// 1.2.1銆佽幏鍙栫▼搴忛偅鏉$嚎绌洪棽 +// 1.2.2銆佽幏鍙栬鏉$嚎鏈�鍚庝竴娆″嚭鐗囩殑浠诲姟淇℃伅 +// 1.2.3銆佹寜鐓у嚭鐗囦俊鎭幓璇︽儏琛ㄦ煡璇㈡牸瀛愬湪绗煎瓙閲岄潰鍓╀綑鐩稿悓灏哄鐨勭幓鐠冩暟鎹笖浠ョ増鍥緄d銆佺増搴忓崌搴忔帓搴� 鍙栫涓�鍧楃幓鐠冨嚭鐗� +// 2銆佸鏋滄病鏈夊巻鍙插嚭鐗囦换鍔� +// 2.1銆佸嚭褰撳墠鐗堝浘id鏈�灏忕増搴忔渶灏忕殑鐜荤拑锛堥棶棰橈細涓ゆ潯绾块兘娌℃湁鍘嗗彶浠诲姟锛屽嚭鐗囨椂涓ゆ潯绾跨殑鐜荤拑灏哄鐩稿悓锛屾槸鍚︽壘灏哄涓嶅悓鐨勶級 + Assert.isFalse(out08Glassstate == 0 && out10Glassstate == 0, "A09銆丄10閮芥湁鐜荤拑锛屾棤娉曞嚭鐗�"); + log.info("0銆佸嚭鐗囦换鍔″嚭鐨勭姸鎬�:A09:銆恵}銆�;A10:銆恵}銆�)", out08Glassstate, out10Glassstate); + //瀹氫箟鍑虹墖鐜荤拑淇℃伅 int endcell = 0; - EdgStorageCageDetails outEdgStorageCageDetails = new EdgStorageCageDetails(); - TaskCache taskCacheA09 = taskCacheService.selectLastOutCacheInfo(""); - TaskCache taskCacheA10 = taskCacheService.selectLastOutCacheInfo(""); - //涓ょ嚎鍚勮嚜瑕佸嚭鐨勭幓鐠� - EdgStorageCageDetails glassInfo09 = edgStorageCageDetailsService.selectConformGlass(taskCacheA09.getGlassId(), (int) mapSettings.get("territoryPoor")); - EdgStorageCageDetails glassInfo10 = edgStorageCageDetailsService.selectConformGlass(taskCacheA10.getGlassId(), (int) mapSettings.get("territoryPoor")); - //鍐冲畾绾胯矾 - if (line == 1) { - endcell = 9000; - outEdgStorageCageDetails = glassInfo09; - } else if (line == 2) { - endcell = 1000; - outEdgStorageCageDetails = glassInfo10; - } else if (line == 3) { - endcell = 9000;//榛樿璧颁竴鍙风嚎 浼樺寲鏂瑰悜鍙牴鎹� 瀵规瘮涓ょ嚎閫熷害/涓ょ嚎褰撳墠浠诲姟鎯呭喌鍋� - outEdgStorageCageDetails = glassInfo09; - } - if (outEdgStorageCageDetails != null && endcell > 0) { - TaskCache taskCache = new TaskCache(); - taskCache.setGlassId(outEdgStorageCageDetails.getGlassId()); - taskCache.setTaskStatus(0); - taskCache.setStartCell(outEdgStorageCageDetails.getSlot()); - taskCache.setEndCell(endcell); - taskCache.setTaskType(2); - taskCache.setCreateTime(new DateTime()); - taskCacheService.insertTaskCache(taskCache); -// S7object.getinstance().plccontrol.WriteWord(mapParameter.get("MES_confirmation_word"), (short) 1); + EdgStorageCageDetails glassInfo = null; + boolean flag = queryMaxMinDiff(threshold); + log.info("1銆佽幏鍙栭挗鍖栫増鍥炬槸鍚﹁秴杩囬槇鍊�:{}", flag); + if (flag) { + glassInfo = queryMinGlass(0.0, 0.0); + log.info("1.1銆佽秴杩囬槇鍊硷細鑾峰彇褰撳墠鏈�灏忕増鍥鹃渶瑕佸嚭鐗囩殑鐜荤拑淇℃伅:{}", glassInfo); + Integer a09Count = queryCountByTaskLine(Const.A09_OUT_TARGET_POSITION).size(); + Integer a10Count = queryCountByTaskLine(Const.A10_OUT_TARGET_POSITION).size(); + log.info("1.2銆佽幏鍙栫瀛愬墿浣欐暟閲廇09涓簕},A10涓簕}", a09Count, a10Count); + + // 鍋囪宸茬煡 outXXGlassstate 鐨勫�煎彧鏈� 0 鍜� 1 涓ょ鎯呭喌锛屼笖 0 琛ㄧず鏌愮鐘舵�侊紝1 琛ㄧず鍙︿竴绉嶇姸鎬� + int targetPositionWhenStateZero = (out08Glassstate == 0) ? Const.A10_OUT_TARGET_POSITION : Const.A09_OUT_TARGET_POSITION; + int targetPositionWhenStateOne = (out10Glassstate == 0) ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; + endcell = (a10Count <= a09Count) ? targetPositionWhenStateZero : targetPositionWhenStateOne; + } else { + //褰撳墠浠诲姟鍑哄畬鏃犵幓鐠� 鏇存崲鐜荤拑 鑾峰彇鍙︿竴鏉$嚎璺� + endcell = out08Glassstate == 1 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; + int othercell = endcell == Const.A10_OUT_TARGET_POSITION ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; + List<EdgStorageCageDetails> details = queryCountByTaskLine(endcell); + if (details.size() > 0) { + glassInfo = details.get(0); + } else { + //鍘荤悊鐗囩閲岄潰鏌� + glassInfo = queryChangeGlassInfo(othercell); + } } + if (glassInfo != null) { + log.info("4銆佹坊鍔犲嚭鐗囦换鍔★紝鐜荤拑id锛歿}锛屼换鍔$被鍨嬶細{}锛岃捣濮嬩綅缃細{}锛岀粨鏉熶綅缃細{}", glassInfo.getGlassId(), + 2, glassInfo.getSlot(), endcell); + LambdaQueryWrapper<EdgStorageCageDetails> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(EdgStorageCageDetails::getGlassId, glassInfo.getGlassId()); + EdgStorageCageDetails updateDetail = new EdgStorageCageDetails(); + updateDetail.setState(Const.GLASS_STATE_OUT); + edgStorageCageDetailsService.update(updateDetail, wrapper); + log.info("5銆佹洿鏂板嚭鐗囩幓鐠冪殑鐘舵�佷负{}", Const.GLASS_STATE_OUT); + + boolean taskCacheStatus = saveTaskCache(glassInfo.getGlassId(), glassInfo.getSlot(), endcell, Const.GLASS_CACHE_TYPE_OUT); + log.info("6銆佹坊鍔犲嚭鐗囦换鍔℃槸鍚﹀畬鎴愶細{}", taskCacheStatus); + + boolean glassSizeStatus = saveGlassSize(glassInfo); + log.info("7銆佹坊鍔犲嚭鐗囩幓鐠冨昂瀵镐俊鎭埌纾ㄨ竟鍓嶇幓鐠冭〃鏄惁瀹屾垚锛歿}", glassSizeStatus); + + S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 1); + log.info("8銆佸彂閫佺‘璁ゅ瓧宸插畬鎴�"); + return Boolean.TRUE; + } + return Boolean.FALSE; + } + + /** + * 鑾峰彇璇︽儏琛ㄥ唴鏈�澶ф渶灏忕増鍥緄d鐨勫樊鍊硷紝鍒ゆ柇鏄惁鍑烘渶灏忕増鍥剧幓鐠� + * + * @return + */ + private boolean queryMaxMinDiff(int threshold) { + //鑾峰彇绗煎瓙鍐呮渶澶х増鍥緄d鍜屾渶灏忕増鍥緄d鎻掑�硷紝鍒ゆ柇鏄惁澶т簬闃堝�硷紝澶т簬闃堝�肩洿鎺ュ嚭鏈�灏忕増鍥剧幓鐠� + QueryWrapper<EdgStorageCageDetails> queryWrapper = new QueryWrapper<>(); + queryWrapper.select("max(tempering_layout_id)-min(tempering_layout_id) as diff") + .eq("state", Const.GLASS_STATE_IN); + List<Object> list = edgStorageCageDetailsService.listObjs(queryWrapper); + if (CollectionUtil.isNotEmpty(list)) { + Long diff = (Long) list.get(0); + return diff > threshold; + } else { + return Boolean.FALSE; + } + + } + + /** + * 鑾峰彇褰撳墠鏈�灏忕増鍥鹃渶瑕佸嚭鐗囩殑鐜荤拑淇℃伅 + * + * @param width + * @param height + */ + private EdgStorageCageDetails queryMinGlass(Double width, Double height) { + return edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getState, 100) + .eq(width != 0, EdgStorageCageDetails::getWidth, width) + .eq(height != 0, EdgStorageCageDetails::getHeight, height) + .orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence) + .last("limit 1")); + } + + /** + * 鑾峰彇浠诲姟琛ㄤ腑鎸囧畾绾胯矾绗煎瓙鍐呰繕鍓╀綑鐨勭幓鐠冩暟閲� + */ + private List<EdgStorageCageDetails> queryCountByTaskLine(int line) { + //鑾峰彇浠诲姟琛ㄤ腑鏈�鍚庝竴娆″嚭鐗囩殑鐜荤拑id + LambdaQueryWrapper<TaskCache> queryWrapper = new LambdaQueryWrapper<TaskCache>().eq(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT) + .eq(TaskCache::getEndCell, line).orderByDesc(TaskCache::getCreateTime); + List<TaskCache> taskCacheList = taskCacheService.list(queryWrapper); + if (CollectionUtil.isEmpty(taskCacheList)) { + return new ArrayList<>(); + } + TaskCache taskCache = taskCacheList.get(0); + MPJQueryWrapper<EdgStorageCageDetails> mpjLambdaWrapper = new MPJQueryWrapper<>(); + mpjLambdaWrapper.select("t1.*") + .innerJoin("edg_storage_cage_details t1 on t.width = t1.width and t.height = t1.height") + .eq("t.glass_id", taskCache.getGlassId()) + .ne("t1.glass_id", taskCache.getGlassId()) + .orderByAsc("t1.tempering_layout_id", "t1.tempering_feed_sequence"); + List<EdgStorageCageDetails> details = edgStorageCageDetailsService.selectJoinList(EdgStorageCageDetails.class, mpjLambdaWrapper); + if (CollectionUtil.isEmpty(details)) { + return new ArrayList<>(); + } + return details; + } + + /** + * 鏇存崲鍑虹墖鐜荤拑 + * + * @param othercell + * @return + */ + private EdgStorageCageDetails queryChangeGlassInfo(int othercell) { + //鑾峰彇绗煎瓙鍐呮暟閲忓墠浜岀殑鐜荤拑鏁伴噺 + MPJLambdaWrapper<EdgStorageCageDetails> wrapper = new MPJLambdaWrapper<>(); + wrapper.select(EdgStorageCageDetails::getWidth, EdgStorageCageDetails::getHeight) + .selectCount(EdgStorageCageDetails::getGlassId, EdgStorageCageDetails::getCount) + .groupBy(EdgStorageCageDetails::getWidth, EdgStorageCageDetails::getHeight) + .last("order by count(t.glass_id) desc limit 2"); + List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper); + log.info("鑾峰彇绗煎瓙鍐呮暟閲忓墠浜岀殑鐜荤拑鏁伴噺锛歿}", list); + if (CollectionUtil.isEmpty(list)) { + log.info("绗煎瓙閲屾病鏈夌幓鐠�"); + return null; + } + //涓�鐗囩幓鐠冪洿鎺ュ嚭 + //鑾峰彇瀹介珮鎷嶇涓�鐨勭幓鐠冧俊鎭� + EdgStorageCageDetails firstSize = list.get(0); + Integer firstCount = firstSize.getCount(); + Double firstWidth = firstSize.getWidth(); + Double firstHeight = firstSize.getHeight(); + if (list.size() == 1) { + return queryMinGlass(firstWidth, firstHeight); + } + //鑾峰彇瀹介珮鎷嶇浜岀殑鐜荤拑淇℃伅 + EdgStorageCageDetails secondSize = list.get(1); + //鑾峰彇浠诲姟琛ㄤ腑鏈�鍚庝竴娆″嚭鐗囩殑鐜荤拑id + LambdaQueryWrapper<TaskCache> queryWrapper = new LambdaQueryWrapper<TaskCache>().eq(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT) + .eq(TaskCache::getEndCell, othercell).orderByDesc(TaskCache::getCreateTime); + List<TaskCache> taskCacheList = taskCacheService.list(queryWrapper); + log.info("鑾峰彇浠诲姟琛ㄤ腑{}绾挎渶鍚庝竴娆″嚭鐗囩殑鐜荤拑浠诲姟淇℃伅锛歿}", othercell, taskCacheList); + if (CollectionUtil.isEmpty(taskCacheList)) { + log.info("{}绾挎病鏈夊嚭鐗囦换鍔′俊鎭紝鐩存帴鍑虹墖", othercell); + return queryMinGlass(firstSize.getWidth(), firstSize.getHeight()); + } + + Integer secondCount = secondSize.getCount(); + Double secondWidth = secondSize.getWidth(); + Double secondHeight = secondSize.getHeight(); + //鑾峰彇鏁伴噺鍓�2鐨勭幓鐠冩暟閲忔瘮渚� + Integer mix = firstCount / secondCount; + log.info("鑾峰彇鐜荤拑鏁伴噺鍓�2鐨勭幓鐠冨崰姣斾负锛歿}", mix); + + if (mix >= 2) { + log.info("鑾峰彇鐜荤拑鏁伴噺鍓�2鐨勭幓鐠冨崰姣斾负{}锛屽ぇ浜�2锛岀洿鎺ュ嚭鐜荤拑鏁版嵁鐨勬渶澶氱殑锛屽锛歿}锛岄珮锛歿}", mix, firstWidth, firstHeight); + return queryMinGlass(firstWidth, firstHeight); + } else { + log.info("鑾峰彇鐜荤拑鏁伴噺鍓�2鐨勭幓鐠冨崰姣斾负{}锛屽皬浜�2", mix); + TaskCache taskCache = taskCacheList.get(0); + EdgStorageCageDetails outGlassInfo = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getGlassId, taskCache.getGlassId())); + log.info("{}绾挎湁鍑虹墖浠诲姟淇℃伅,浠诲姟淇℃伅涓簕}锛岀幓鐠冧俊鎭负{}", othercell, taskCache, outGlassInfo); + if (outGlassInfo.getWidth().equals(firstWidth) && outGlassInfo.getHeight().equals(firstHeight)) { + log.info("鏁伴噺鏈�澶氱殑瀹絳}楂榹}鍜寋}绾夸换鍔$殑瀹絳}楂榹}鐩稿悓锛屽嚭鏁伴噺鎺掔浜岀殑鐜荤拑锛屽{}楂榹}", + firstWidth, firstHeight, othercell, outGlassInfo.getWidth(), outGlassInfo.getHeight(), secondWidth, secondHeight); + return queryMinGlass(secondWidth, secondHeight); + } else { + log.info("鏁伴噺绗簩澶氱殑瀹絳}楂榹}鍜寋}绾夸换鍔$殑瀹絳}楂榹}鐩稿悓锛屽嚭鏁伴噺鎺掔浜岀殑鐜荤拑锛屽{}楂榹}", + secondWidth, secondHeight, othercell, outGlassInfo.getWidth(), outGlassInfo.getHeight(), firstWidth, firstHeight); + return queryMinGlass(firstWidth, firstHeight); + } + } + } + + /** + * 娣诲姞鐞嗙墖绗间换鍔� + * + * @param glassId + * @param startcell + * @param endcell + * @param taskType + * @return + */ + private boolean saveTaskCache(String glassId, int startcell, int endcell, int taskType) { + TaskCache taskCache = new TaskCache(); + taskCache.setGlassId(glassId); + taskCache.setTaskStatus(0); + taskCache.setStartCell(startcell); + taskCache.setEndCell(endcell); + taskCache.setTaskType(taskType); + taskCache.setCreateTime(new Date()); + return taskCacheService.save(taskCache); + } + + /** + * 娣诲姞鐞嗙墖绗间换鍔� + * + * @param glassInfo + * @return + */ + private boolean saveGlassSize(EdgStorageCageDetails glassInfo) { + EdgGlassTaskInfo edgGlassTaskInfo = new EdgGlassTaskInfo(); + BeanUtils.copyProperties(glassInfo, edgGlassTaskInfo); + edgGlassTaskInfo.setHeight((int) (glassInfo.getEdgHeight() * ratio)); + edgGlassTaskInfo.setWidth((int) (glassInfo.getWidth() * ratio)); + edgGlassTaskInfo.setThickness((int) (glassInfo.getThickness() * ratio)); + edgGlassTaskInfo.setStatus(Const.EDG_GLASS_BEFORE); + return edgGlassTaskInfoService.save(edgGlassTaskInfo); } -- Gitblit v1.8.0