From b021f4175c672b6a64b5e65d477c877f0855b2a4 Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期一, 13 五月 2024 08:49:16 +0800 Subject: [PATCH] 卧式理片笼对接改造已基本完成:部分逻辑暂未校验:超过阈值 --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java | 190 ++++++++++++++++++++++++++++++++-------------- 1 files changed, 131 insertions(+), 59 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 fc0aa21..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 @@ -9,6 +9,8 @@ import com.mes.common.S7object; 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.service.EdgStorageCageDetailsService; @@ -18,6 +20,7 @@ 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; @@ -46,8 +49,14 @@ @Autowired EdgStorageCageDetailsService edgStorageCageDetailsService; + @Autowired + EdgGlassTaskInfoService edgGlassTaskInfoService; + @Value("${mes.threshold}") private int threshold; + + @Value("${mes.ratio}") + private int ratio; @Scheduled(fixedDelay = 1000) public void plcHomeEdgTask() { @@ -55,12 +64,23 @@ 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琛ㄧず绾胯矾鐩稿悓 鍙仛绛変环 + //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(); - log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佸垎鍒负锛欰09{}銆丄10{},褰撳墠鏍煎瓙鍙蜂负锛歿}", + +// String taskRequestTypeValue = "2"; +// String glassIdeValue = "2222222222"; +// String confirmationWrodValue = "0"; +// //A08 A09琛ㄧず绾胯矾鐩稿悓 鍙仛绛変环 +// Integer out08Glassstate = 1; +// Integer out10Glassstate = 0; +// String confirmationWrodAddress = "DB11.38"; +// String currentSlot = "1"; + + + log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佸垎鍒负锛欰09:{}銆丄10:{},褰撳墠鏍煎瓙鍙蜂负锛歿}", taskRequestTypeValue, glassIdeValue, confirmationWrodValue, out08Glassstate, out10Glassstate, currentSlot); if ("0".equals(taskRequestTypeValue)) { @@ -77,22 +97,27 @@ S7object.getinstance().plccontrol.WriteWord(confirmationWrodAddress, (short) 0); return; } - if ("1".equals(taskRequestTypeValue)) { - log.info("3銆佽繘鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + log.info("2銆佽繘鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); inTo(glassIdeValue, confirmationWrodAddress, currentSlot); } else if ("2".equals(taskRequestTypeValue)) { //09绌洪棽 锛�1 10绌洪棽 锛�2 閮界┖闂诧細3 鍏朵粬0 - log.info("3銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); - outTo(Integer.parseInt(out08Glassstate), confirmationWrodAddress); + log.info("2銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + outTo(Integer.parseInt(out08Glassstate), + Integer.parseInt(out10Glassstate), confirmationWrodAddress); } else if ("3".equals(taskRequestTypeValue)) { - log.info("3銆佽繘鐗囧拰鍑虹墖閮界┖闂诧紝鎵ц鍑虹墖浠诲姟"); + log.info("2銆佽繘鐗囧拰鍑虹墖閮界┖闂诧紝鎵ц鍑虹墖浠诲姟"); //鍔犵瀛愰噷闈㈡槸鍚︽湁鐜荤拑锛屾湁鍏堝嚭锛屾棤鐜荤拑鍏堣繘 int count = edgStorageCageDetailsService.count(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)); - if ("0".equals(out08Glassstate) || count > 0) { + if ("0".equals(out08Glassstate) && "0".equals(out10Glassstate) && count < 9) { inTo(glassIdeValue, confirmationWrodAddress, currentSlot); } else { - outTo(Integer.parseInt(out08Glassstate), confirmationWrodAddress); + boolean outFlase = outTo(Integer.parseInt(out08Glassstate), + Integer.parseInt(out10Glassstate), confirmationWrodAddress); + log.info("鍑虹墖浠诲姟鏄惁瀹屾垚锛歿},澶辫触涓旂幓鐠僫d:{}涓嶄负绌哄垯鎵ц杩涚墖浠诲姟", outFlase, glassIdeValue); + if (!outFlase && StringUtils.isNotBlank(glassIdeValue)) { + inTo(glassIdeValue, confirmationWrodAddress, currentSlot); + } } } } @@ -114,7 +139,7 @@ log.info("2銆佽幏鍙栧埌鐨勭幓鐠冧俊鎭负{}", glassInfo); //娣诲姞杩涚墖浠诲姟 鏌ユ壘绌烘牸 EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(Integer.parseInt(currentSlot)); - Assert.isTrue(nearestEmpty == null, "鏍煎瓙宸叉弧"); + Assert.isTrue(null != nearestEmpty, "鏍煎瓙宸叉弧"); log.info("3銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", nearestEmpty); log.info("4銆佸皢鐜荤拑淇℃伅鎻掑叆鍗у紡鐞嗙墖绗�,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); @@ -125,17 +150,9 @@ details.setDeviceId(nearestEmpty.getDeviceId()); edgStorageCageDetailsService.save(details); log.info("5銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details); - //娣诲姞杩涚墖浠诲姟 - TaskCache taskCache = new TaskCache(); - taskCache.setGlassId(glassId); - taskCache.setTaskStatus(0); - taskCache.setStartCell(0); - taskCache.setEndCell(nearestEmpty.getSlot()); - taskCache.setTaskType(1); - taskCache.setCreateTime(new Date()); - taskCacheService.insertTaskCache(taskCache); - log.info("6銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃{}", taskCache); + 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銆佸彂閫佺‘璁ゅ瓧瀹屾垚"); @@ -146,10 +163,11 @@ /** * 鍑虹墖浠诲姟 * - * @param line + * @param out08Glassstate + * @param out10Glassstate * @param confirmationWrodAddress */ - private void outTo(int line, String confirmationWrodAddress) { + private boolean outTo(int out08Glassstate, int out10Glassstate, String confirmationWrodAddress) { //閫昏緫姝ラ锛� // 0銆丄09銆丄10鏄惁绌洪棽锛屾槸鍚﹀彲浠ユ墽琛屽嚭鐗囦换鍔� // 1銆佽幏鍙栭挗鍖栫増鍥炬槸鍚﹁秴杩囬槇鍊� @@ -163,11 +181,11 @@ // 1.2.3銆佹寜鐓у嚭鐗囦俊鎭幓璇︽儏琛ㄦ煡璇㈡牸瀛愬湪绗煎瓙閲岄潰鍓╀綑鐩稿悓灏哄鐨勭幓鐠冩暟鎹笖浠ョ増鍥緄d銆佺増搴忓崌搴忔帓搴� 鍙栫涓�鍧楃幓鐠冨嚭鐗� // 2銆佸鏋滄病鏈夊巻鍙插嚭鐗囦换鍔� // 2.1銆佸嚭褰撳墠鐗堝浘id鏈�灏忕増搴忔渶灏忕殑鐜荤拑锛堥棶棰橈細涓ゆ潯绾块兘娌℃湁鍘嗗彶浠诲姟锛屽嚭鐗囨椂涓ゆ潯绾跨殑鐜荤拑灏哄鐩稿悓锛屾槸鍚︽壘灏哄涓嶅悓鐨勶級 - Assert.isTrue(line != 0, "A09銆丄10閮芥湁鐜荤拑锛屾棤娉曞嚭鐗�"); - log.info("0銆佸嚭鐗囦换鍔″嚭銆恵}銆戝彿绾�,澶囨敞(09绌洪棽锛�1;10绌洪棽锛�2;閮界┖闂诧細3)", line); + Assert.isFalse(out08Glassstate == 0 && out10Glassstate == 0, "A09銆丄10閮芥湁鐜荤拑锛屾棤娉曞嚭鐗�"); + log.info("0銆佸嚭鐗囦换鍔″嚭鐨勭姸鎬�:A09:銆恵}銆�;A10:銆恵}銆�)", out08Glassstate, out10Glassstate); //瀹氫箟鍑虹墖鐜荤拑淇℃伅 - EdgStorageCageDetails glassInfo = null; int endcell = 0; + EdgStorageCageDetails glassInfo = null; boolean flag = queryMaxMinDiff(threshold); log.info("1銆佽幏鍙栭挗鍖栫増鍥炬槸鍚﹁秴杩囬槇鍊�:{}", flag); if (flag) { @@ -176,41 +194,46 @@ 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); - if (a10Count <= a09Count && line != 2) { - log.info("1.2.1銆丄09绾垮嚭鐗�"); - endcell = Const.A09_OUT_TARGET_POSITION; - } else { - log.info("1.2.2銆丄10绾垮嚭鐗�"); - endcell = Const.A09_OUT_TARGET_POSITION; - } + + // 鍋囪宸茬煡 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 = line == 2 ? Const.A10_OUT_TARGET_POSITION : Const.A09_OUT_TARGET_POSITION; - //褰撳墠浠诲姟鍑哄畬鏃犵幓鐠� 鏇存崲鐜荤拑 + //褰撳墠浠诲姟鍑哄畬鏃犵幓鐠� 鏇存崲鐜荤拑 鑾峰彇鍙︿竴鏉$嚎璺� + 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 { - //todo:鍘荤悊鐗囩閲岄潰鏌� + //鍘荤悊鐗囩閲岄潰鏌� glassInfo = queryChangeGlassInfo(othercell); } - } if (glassInfo != null) { log.info("4銆佹坊鍔犲嚭鐗囦换鍔★紝鐜荤拑id锛歿}锛屼换鍔$被鍨嬶細{}锛岃捣濮嬩綅缃細{}锛岀粨鏉熶綅缃細{}", glassInfo.getGlassId(), 2, glassInfo.getSlot(), endcell); - TaskCache taskCache = new TaskCache(); - taskCache.setGlassId(glassInfo.getGlassId()); - taskCache.setTaskStatus(0); - taskCache.setStartCell(glassInfo.getSlot()); - taskCache.setEndCell(endcell); - taskCache.setTaskType(2); - taskCache.setCreateTime(new Date()); - taskCacheService.insertTaskCache(taskCache); + + 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; } /** @@ -219,12 +242,18 @@ * @return */ private boolean queryMaxMinDiff(int threshold) { - //todo:鑾峰彇绗煎瓙鍐呮渶澶х増鍥緄d鍜屾渶灏忕増鍥緄d鎻掑�硷紝鍒ゆ柇鏄惁澶т簬闃堝�硷紝澶т簬闃堝�肩洿鎺ュ嚭鏈�灏忕増鍥剧幓鐠� + //鑾峰彇绗煎瓙鍐呮渶澶х増鍥緄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); - Integer diff = (Integer) edgStorageCageDetailsService.listObjs(queryWrapper).get(0); - return diff > threshold; + List<Object> list = edgStorageCageDetailsService.listObjs(queryWrapper); + if (CollectionUtil.isNotEmpty(list)) { + Long diff = (Long) list.get(0); + return diff > threshold; + } else { + return Boolean.FALSE; + } + } /** @@ -255,7 +284,7 @@ } TaskCache taskCache = taskCacheList.get(0); MPJQueryWrapper<EdgStorageCageDetails> mpjLambdaWrapper = new MPJQueryWrapper<>(); - mpjLambdaWrapper.select("a.*") + 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()) @@ -277,18 +306,25 @@ //鑾峰彇绗煎瓙鍐呮暟閲忓墠浜岀殑鐜荤拑鏁伴噺 MPJLambdaWrapper<EdgStorageCageDetails> wrapper = new MPJLambdaWrapper<>(); wrapper.select(EdgStorageCageDetails::getWidth, EdgStorageCageDetails::getHeight) - .selectCount("*", EdgStorageCageDetails::getCount) + .selectCount(EdgStorageCageDetails::getGlassId, EdgStorageCageDetails::getCount) .groupBy(EdgStorageCageDetails::getWidth, EdgStorageCageDetails::getHeight) - .last("order by count(*) desc limit 2"); + .last("order by count(t.glass_id) desc limit 2"); List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper); log.info("鑾峰彇绗煎瓙鍐呮暟閲忓墠浜岀殑鐜荤拑鏁伴噺锛歿}", list); - Assert.notEmpty(list, "绗煎瓙閲屾病鏈夌幓鐠�"); - //涓�鐗囩幓鐠冪洿鎺ュ嚭 - if (list.size() == 1) { - return list.get(0); + 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) @@ -299,9 +335,7 @@ log.info("{}绾挎病鏈夊嚭鐗囦换鍔′俊鎭紝鐩存帴鍑虹墖", othercell); return queryMinGlass(firstSize.getWidth(), firstSize.getHeight()); } - Integer firstCount = firstSize.getCount(); - Double firstWidth = firstSize.getWidth(); - Double firstHeight = firstSize.getHeight(); + Integer secondCount = secondSize.getCount(); Double secondWidth = secondSize.getWidth(); Double secondHeight = secondSize.getHeight(); @@ -328,4 +362,42 @@ } } } + + /** + * 娣诲姞鐞嗙墖绗间换鍔� + * + * @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