From f68d3c71819feb59e7a227a5d992b059b900916c Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期五, 28 三月 2025 08:28:26 +0800 Subject: [PATCH] 修改报表,界面添加查询流程卡个数,调整推送数据到前端的间隔 --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java | 579 ++++++++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 427 insertions(+), 152 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 a63c890..e964692 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 @@ -5,9 +5,14 @@ import cn.hutool.json.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; +import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.github.yulichang.query.MPJQueryWrapper; +import com.github.yulichang.wrapper.MPJLambdaWrapper; import com.mes.common.S7object; import com.mes.common.config.Const; +import com.mes.damage.entity.Damage; +import com.mes.damage.service.DamageService; import com.mes.device.PlcParameterObject; import com.mes.edgglasstask.entity.EdgGlassTaskInfo; import com.mes.edgglasstask.service.EdgGlassTaskInfoService; @@ -32,6 +37,7 @@ import java.util.Date; import java.util.List; import java.util.Map; +import java.util.stream.Collectors; /** * @Author : zhoush @@ -56,6 +62,8 @@ @Autowired WebSocketServer webServerService; + @Autowired + DamageService damageService; @Value("${mes.threshold}") private int threshold; @@ -66,23 +74,58 @@ @Value("${mes.sequence.order}") private boolean sequenceOrder; - @Value("${mes.firstLength}") + @Value("${mes.max.firstLength}") private String firstLength; - @Value("${mes.secondLength}") + @Value("${mes.max.secondLength}") private String secondLength; - @Scheduled(fixedDelay = 1000) + @Value("${mes.cache.cacheWidth}") + private double cacheWidth; + + @Value("${mes.cache.cacheHeight}") + private double cacheHeight; + + @Value("${mes.min.one.firstLength}") + private String minOneFirstLength; + + @Value("${mes.min.one.secondLength}") + private String minOneSecondLength; + + @Value("${mes.min.two.firstLength}") + private String minTwoFirstLength; + + @Value("${mes.min.two.secondLength}") + private String minTwoSecondLength; + + public static String engineerId = ""; + + @Scheduled(fixedDelay = 500) public void plcHomeEdgTask() { + Date startDate = new Date(); + log.info("鏈浠诲姟寮�濮嬫墽琛屾椂闂达細{}", startDate); 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 out09Glassstate = plcParameterObject.getPlcParameter("A09_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 ("1".equals(out09Glassstate)) { + log.info("A09绌洪棽"); + out08Glassstate = "1"; + } + +// taskRequestTypeValue = "2"; +// out08Glassstate = "1"; +// out10Glassstate = "1"; +// currentSlot = "1"; +// confirmationWrodValue = "0"; +// glassIdeValue = "P25021704|75|12"; log.info("1銆佽幏鍙栧埌鐨勮姹傚瓧涓猴細{}锛岃幏鍙栧埌鐨勬壂鎻廔D涓猴細{}锛岃幏鍙栧埌鐨勭‘璁ゅ瓧涓猴細{}锛岃幏鍙栧埌鐨勫嚭鐗囩姸鎬佸垎鍒负锛欰09:{}銆丄10:{},褰撳墠鏍煎瓙鍙蜂负锛歿}", taskRequestTypeValue, glassIdeValue, confirmationWrodValue, out08Glassstate, out10Glassstate, currentSlot); @@ -93,53 +136,70 @@ return; } log.info("2銆佽幏鍙栧埌鐨勮姹傚瓧涓�0锛屽皢纭瀛楁敼涓�0"); - S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 0); + S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, 0); return; } if (!"0".equals(confirmationWrodValue)) { log.info("2銆佽幏鍙栧埌鐨勮姹傚瓧涓嶄负0锛屽皢纭瀛椾笉涓�0锛岀洿鎺ョ粨鏉�"); return; } - if ("1".equals(taskRequestTypeValue)) { - log.info("2銆佽繘鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + boolean result = edgStorageCageDetailsService.inToVerify(glassIdeValue); + if (!result) { + log.info("姝ょ幓鐠僫d宸茬粡杩涜繃"); + return; + } + if ("1".equals(taskRequestTypeValue) && result) { + log.info("2銆佽繘鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�,鎵爜閲嶅ID楠岃瘉銆愭湁閲嶅=false,鏃犻噸澶�=true銆戯細{}", result); inTo(glassIdeValue, confirmationWrodAddress, currentSlot); - } else if ("2".equals(taskRequestTypeValue)) { + } else if ("2".equals(taskRequestTypeValue) && result) { //09绌洪棽 锛�1 10绌洪棽 锛�2 閮界┖闂诧細3 鍏朵粬0 - log.info("2銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛岃繘鐗囦换鍔�"); + log.info("2銆佸嚭鐗囪姹傦紝涓旂‘璁ゅ瓧涓�0锛屾墽琛屽嚭鐗囦换鍔�"); outTo(Integer.parseInt(out08Glassstate), - Integer.parseInt(out10Glassstate), confirmationWrodAddress, "", 0); - } else if ("3".equals(taskRequestTypeValue)) { + Integer.parseInt(out10Glassstate), confirmationWrodAddress, "", Integer.parseInt(currentSlot)); + } else if ("3".equals(taskRequestTypeValue) && result) { log.info("2銆佽繘鐗囧拰鍑虹墖閮界┖闂诧紝鎵ц鍑虹墖浠诲姟"); //鍔犵瀛愰噷闈㈡槸鍚︽湁鐜荤拑锛屾湁鍏堝嚭锛屾棤鐜荤拑鍏堣繘 boolean outFlase = outTo(Integer.parseInt(out08Glassstate), Integer.parseInt(out10Glassstate), confirmationWrodAddress, glassIdeValue, Integer.parseInt(currentSlot)); - log.info("鍑虹墖浠诲姟鏄惁瀹屾垚锛歿},澶辫触涓旂幓鐠僫d:{}涓嶄负绌哄垯鎵ц杩涚墖浠诲姟", outFlase, glassIdeValue); - if (!outFlase && StringUtils.isNotBlank(glassIdeValue)) { + log.info("鍑虹墖浠诲姟鏄惁瀹屾垚锛歿},涓旂幓鐠僫d:{}涓嶄负绌哄垯鎵ц杩涚墖浠诲姟,鎵爜閲嶅ID楠岃瘉銆愭湁閲嶅=false,鏃犻噸澶�=true銆戯細{}", outFlase, glassIdeValue, result); + if (!outFlase && StringUtils.isNotBlank(glassIdeValue) && result) { inTo(glassIdeValue, confirmationWrodAddress, currentSlot); } } + Date endDate = new Date(); + log.info("鏈浠诲姟缁撴潫鏃堕棿锛歿}锛屽叡鑰楁椂锛歿}ms", endDate, endDate.getTime() - startDate.getTime()); } - public void plcToHomeEdgTask() { - // 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(); -// } -// } -// -// } -// } + + @Scheduled(fixedDelay = 500) + public void dealDamageTask() { + Date startDate = new Date(); + log.info("鍗у紡鐞嗙墖鐮存崯鐜荤拑娓呴櫎浠诲姟寮�濮嬫墽琛屾椂闂达細{}", startDate); + List<TaskCache> taskCacheList = taskCacheService.list(new LambdaQueryWrapper<TaskCache>().in(TaskCache::getTaskStatus, Const.GLASS_STATE_DAMAGE_TAKE) + .in(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT_ALL)); + if (CollectionUtils.isNotEmpty(taskCacheList)) { + //鑾峰彇鐮存崯/鎷胯蛋鐜荤拑id + List<String> glassList = taskCacheList.stream().map(TaskCache::getGlassId).collect(Collectors.toList()); + //灏嗙(杈归槦鍒楃殑鏁版嵁鍒犻櫎 + edgGlassTaskInfoService.remove(new LambdaQueryWrapper<EdgGlassTaskInfo>().in(EdgGlassTaskInfo::getGlassId, glassList)); + //灏嗕换鍔¤〃涓殑鏁版嵁鍒犻櫎 + taskCacheService.remove(new LambdaQueryWrapper<TaskCache>().in(TaskCache::getGlassId, glassList).in(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT_ALL)); + List<Damage> damageList = taskCacheList.stream().map(e -> { + Damage damage = new Damage(); + damage.setGlassId(e.getGlassId()); + damage.setLine(e.getEndCell()); + damage.setWorkingProcedure("纾ㄨ竟"); + damage.setRemark("纾ㄨ竟鍓嶅崸寮忕悊鐗�"); + damage.setStatus(1); + damage.setType(e.getTaskStatus()); + return damage; + }).collect(Collectors.toList()); + damageService.batchInsertDamage(damageList); + } + Date endDate = new Date(); + log.info("鏈浠诲姟缁撴潫鏃堕棿锛歿}锛屽叡鑰楁椂锛歿}ms", endDate, endDate.getTime() - startDate.getTime()); } + /** * 杩涚墖浠诲姟 @@ -150,28 +210,48 @@ */ public void inTo(String glassId, String confirmationWrodAddress, String currentSlot) { log.info("1銆佹寜鐓х幓鐠僫d:{}鑾峰彇鐜荤拑灏忕墖淇℃伅,褰撳墠鏍煎瓙涓�:{}", glassId, currentSlot); + + GlassInfo feedGlassInfo = glassInfoService.getOne( + new LambdaQueryWrapper<GlassInfo>() + .eq(GlassInfo::getGlassId, glassId) + ); + if (Math.max(feedGlassInfo.getWidth(), feedGlassInfo.getHeight()) > cacheWidth || + Math.min(feedGlassInfo.getWidth(), feedGlassInfo.getHeight()) > cacheHeight + || Math.min(feedGlassInfo.getWidth(), feedGlassInfo.getHeight()) < Integer.parseInt(minTwoFirstLength) + ) { + log.info("1.1銆佺幓鐠冭秴杩囧崸寮忕悊鐗囧昂瀵歌寖鍥�:{}", feedGlassInfo); + return; + } + //娣诲姞杩涚墖浠诲姟 鏌ユ壘绌烘牸 EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(Integer.parseInt(currentSlot), Boolean.FALSE); Assert.isTrue(null != nearestEmpty, "鏍煎瓙宸叉弧"); log.info("2銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", nearestEmpty); - //鏌ヨ鐜荤拑骞惰繘琛屼氦鎹� - GlassInfo glassInfo = queryAndChangeGlass(glassId); - log.info("3銆佸皢鐜荤拑淇℃伅鎻掑叆鍗у紡鐞嗙墖绗�,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); + //鏌ヨ鐜荤拑淇℃伅 + GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId)); + if (glassInfo == null) { + return; + } + if ((glassInfo.getWidth() < Double.parseDouble(minTwoFirstLength) && glassInfo.getHeight() < Double.parseDouble(minTwoSecondLength)) || (glassInfo.getWidth() < Double.parseDouble(minTwoSecondLength) && glassInfo.getHeight() < Double.parseDouble(minTwoFirstLength))) { + log.info("3銆佺幓鐠冧俊鎭笉绗﹀悎杩涘叆鐞嗙墖绗兼渶灏忓昂瀵革紝鐜荤拑淇℃伅涓簕}", glassInfo); + return; + } + 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("4銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details); + damageService.deleteByGlassId(glassId); + log.info("5銆佺幓鐠冧俊鎭凡瀛樺叆鐞嗙墖绗艰鎯呰〃锛岀幓鐠冧俊鎭负{}", details); //娣诲姞杩涚墖浠诲姟 boolean taskCache = saveTaskCache(details.getGlassId(), 0, nearestEmpty.getSlot(), Const.GLASS_CACHE_TYPE_IN); - log.info("5銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃鏄惁瀹屾垚锛歿}", taskCache); + log.info("6銆佺敓鎴愯繘鐗囦换鍔′俊鎭瓨鍏ヤ换鍔¤〃鏄惁瀹屾垚锛歿}", taskCache); - S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 1); - log.info("6銆佸彂閫佺‘璁ゅ瓧瀹屾垚"); - + S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, 1); + log.info("7銆佸彂閫佺‘璁ゅ瓧瀹屾垚"); } @@ -181,21 +261,22 @@ * @param glassId * @return */ - public GlassInfo queryAndChangeGlass(String glassId) { - GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId) - .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1")); - Assert.isFalse(null == glassInfo, "鐜荤拑淇℃伅涓嶅瓨鍦�"); - //鎸夌収鐜荤拑灏哄 + public String queryAndChangeGlass(String glassId) { + GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId)); +// .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1")); + Assert.isFalse(null == glassInfo, "鐜荤拑淇℃伅涓嶅瓨鍦�"); //鎸夌収鐜荤拑灏哄 LambdaQueryWrapper<GlassInfo> queryWrapper = new LambdaQueryWrapper<GlassInfo>() .eq(GlassInfo::getWidth, glassInfo.getWidth()) .eq(GlassInfo::getHeight, glassInfo.getHeight()) .eq(GlassInfo::getThickness, glassInfo.getThickness()) .eq(GlassInfo::getFilmsid, glassInfo.getFilmsid()) + .eq(GlassInfo::getFlowCardId, glassInfo.getFlowCardId()) .eq(GlassInfo::getTotalLayer, glassInfo.getTotalLayer()) .eq(GlassInfo::getLayer, glassInfo.getLayer()) .eq(GlassInfo::getEngineerId, glassInfo.getEngineerId()) .notInSql(GlassInfo::getGlassId, "select distinct glass_id from edg_storage_cage_details " + - "where engineer_id = '" + glassInfo.getEngineerId() + "' and width = " + glassInfo.getWidth() + " and height = " + glassInfo.getHeight()) + "where engineer_id = '" + glassInfo.getEngineerId() + "' and width = " + glassInfo.getWidth() + " and height = " + glassInfo.getHeight() + + " and state != 100") .orderByAsc(GlassInfo::getTemperingLayoutId) .orderBy(Boolean.TRUE, sequenceOrder, GlassInfo::getTemperingFeedSequence) .last("Limit 1"); @@ -207,9 +288,52 @@ glassInfo.setGlassId(swapGlassId); glassInfoService.updateById(swapGlassInfo); glassInfoService.updateById(glassInfo); - return swapGlassInfo; + return swapGlassId; } - return glassInfo; + return ""; + } + + + /** + * 鏌ヨ鍗у紡鐞嗙墖鐜荤拑骞惰繘琛屼氦鎹� + * + * @param glassId + * @return + */ + public void queryEdgAndChangeGlass(String glassId, String swapGlassId) { + if (StringUtils.isBlank(swapGlassId)) { + log.info("褰撳墠鍑虹鐜荤拑涓嶅瓨鍦ㄩ渶瑕佹浛鎹㈢殑鐜荤拑"); + return; + } + //鑾峰彇寰呭嚭绗肩殑鐜荤拑 + EdgStorageCageDetails glassInfo = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getGlassId, glassId).eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)); +// 鑾峰彇寰呭嚭绗肩殑鐜荤拑闇�瑕佹浛鎹㈢殑鐜荤拑淇℃伅 + EdgStorageCageDetails swapGlassDetailInfo = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getGlassId, swapGlassId).eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)); + +// 鐜荤拑灏忕墖琛ㄤ腑鐜荤拑宸茬粡鏇挎崲锛屾洿鏂板崸鐞嗙鍐呯幇鏈夌殑鍑嗗鍑虹鐨勭幓鐠冧俊鎭紝 + if (null == swapGlassDetailInfo) { + GlassInfo glassInfoBase = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>() + .eq(GlassInfo::getGlassId, glassId)); + //闇�瑕佹浛鎹㈢殑鐜荤拑涓哄瓨杩涘崸鐞嗭紝浠呴渶鏇存柊褰撳墠闇�瑕佸嚭绗肩殑鐜荤拑淇℃伅鍗冲彲 + edgStorageCageDetailsService.update(new LambdaUpdateWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getGlassId, glassId) + .set(EdgStorageCageDetails::getTemperingLayoutId, glassInfoBase.getTemperingLayoutId()) + .set(EdgStorageCageDetails::getTemperingFeedSequence, glassInfoBase.getTemperingFeedSequence())); + } else { + //闇�瑕佹浛鎹㈢殑鐜荤拑閮藉湪鍗х悊鍐咃紝鎸夌収鐜荤拑id瀵硅皟鐜荤拑淇℃伅锛氬璋冪幓鐠僫d鍗冲彲 + edgStorageCageDetailsService.update(new LambdaUpdateWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getId, glassInfo.getId()) + .set(EdgStorageCageDetails::getTemperingLayoutId, swapGlassDetailInfo.getTemperingLayoutId()) + .set(EdgStorageCageDetails::getTemperingFeedSequence, swapGlassDetailInfo.getTemperingFeedSequence()) + ); + edgStorageCageDetailsService.update(new LambdaUpdateWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getId, swapGlassDetailInfo.getId()) + .set(EdgStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) + .set(EdgStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence()) + ); + } } /** @@ -235,14 +359,27 @@ // 1.2.3銆佹寜鐓у嚭鐗囦俊鎭幓璇︽儏琛ㄦ煡璇㈡牸瀛愬湪绗煎瓙閲岄潰鍓╀綑鐩稿悓灏哄鐨勭幓鐠冩暟鎹笖浠ョ増鍥緄d銆佺増搴忓崌搴忔帓搴� 鍙栫涓�鍧楃幓鐠冨嚭鐗� // 2銆佸鏋滄病鏈夊巻鍙插嚭鐗囦换鍔� // 2.1銆佸嚭褰撳墠鐗堝浘id鏈�灏忕増搴忔渶灏忕殑鐜荤拑锛堥棶棰橈細涓ゆ潯绾块兘娌℃湁鍘嗗彶浠诲姟锛屽嚭鐗囨椂涓ゆ潯绾跨殑鐜荤拑灏哄鐩稿悓锛屾槸鍚︽壘灏哄涓嶅悓鐨勶級 - if (out08Glassstate == 2 && out10Glassstate == 2) { - log.info("A09銆丄10涓簕},{}闈炶嚜鍔ㄧ姸鎬侊紝鏃犳硶鍑虹墖"); +// if ((out08Glassstate == 2 && out10Glassstate == 2) || (out08Glassstate == 0 && out10Glassstate == 0)) { +// log.info("A09銆丄10涓簕},{}闈炶嚜鍔ㄧ姸鎬侊紝鏃犳硶鍑虹墖", out08Glassstate, out10Glassstate); +// return Boolean.FALSE; +// } + if ((out08Glassstate == 2 && out10Glassstate == 2)) { + log.info("A09銆丄10涓簕},{}闈炶嚜鍔ㄧ姸鎬侊紝鏃犳硶鍑虹墖", out08Glassstate, out10Glassstate); return Boolean.FALSE; + } + if ((out08Glassstate == 0 && out10Glassstate == 0)) { + out10Glassstate = 1; } log.info("0銆佸嚭鐗囦换鍔″嚭鐨勭姸鎬�:A09:銆恵}銆�;A10:銆恵}銆�)", out08Glassstate, out10Glassstate); //瀹氫箟鍑虹墖鐜荤拑淇℃伅 int endcell = 0; EdgStorageCageDetails glassInfo = null; + //褰撶瀛愬凡婊℃椂锛屼笉鑰冭檻鍗у紡鐞嗙墖鍓嶇殑鐜荤拑 + EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(currentSlot, Boolean.FALSE); + if (nearestEmpty == null) { + glassId = ""; + } + boolean flag = queryMaxMinDiff(threshold); log.info("1銆佽幏鍙栭挗鍖栫増鍥炬槸鍚﹁秴杩囬槇鍊�:{}", flag); if (flag) { @@ -257,40 +394,63 @@ EdgStorageCageDetails a10EdgGlass = queryGlassByTaskCache(Const.A10_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT_ALL); endcell = queryLineByGlassInfo(a09EdgGlass, a10EdgGlass, glassInfo, out08Glassstate, out10Glassstate); } else { - //鍒ゆ柇涓ゆ潯绾挎槸鍚﹂兘绌洪棽 - endcell = out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; - - if ((out08Glassstate == 0 && out10Glassstate == 0) || (out08Glassstate == 1 && out10Glassstate == 1)) { + //鎸夌収鐘舵�佸垽鏂袱鏉$嚎璧伴偅鏉$嚎 + GlassInfo glassInfos = glassInfoService.getOne( + new LambdaQueryWrapper<GlassInfo>() + .eq(GlassInfo::getGlassId, glassId) + ); + if (glassInfos != null) { + if (Math.max(glassInfos.getWidth(), glassInfos.getHeight()) > Integer.parseInt(firstLength) && out08Glassstate == 1) { + endcell = Const.A09_OUT_TARGET_POSITION; + } else { + endcell = computerLineByState(out08Glassstate, out10Glassstate); + } + } else { + endcell = computerLineByState(out08Glassstate, out10Glassstate); + } + if (out08Glassstate == 1 && out10Glassstate == 1) { EdgStorageCageDetails a09EdgGlass = queryGlassByTaskCache(Const.A09_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT_ALL); EdgStorageCageDetails a10EdgGlass = queryGlassByTaskCache(Const.A10_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT_ALL); - if (a09EdgGlass == null && a10EdgGlass == null) { + if (a09EdgGlass != null || a10EdgGlass != null) { MPJQueryWrapper<EdgStorageCageDetails> wrapper = new MPJQueryWrapper<>(); wrapper.select("count(t.glass_id), t.width, t.height") .eq("t.state", Const.GLASS_STATE_IN) + .inSql("t.slot", "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON) .groupBy("t.width, t.height"); if (endcell == Const.A10_OUT_TARGET_POSITION) { wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + - "on t.glass_id = t1.glass_id and (t1.first_length <=" + firstLength + " and t1.second_length<=" + secondLength + ") "); + "on t.glass_id = t1.glass_id and (t1.first_length between " + minTwoFirstLength + " and " + firstLength + + " and t1.second_length between " + minTwoSecondLength + " and " + secondLength + ") "); + } else { + wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + + "on t.glass_id = t1.glass_id and (t1.first_length >=" + minOneFirstLength + " and t1.second_length>=" + minOneSecondLength + ") "); } wrapper.last("order by count(t.glass_id) desc limit 2"); List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper); if (CollectionUtil.isEmpty(list)) { + log.info("绗煎瓙鍐呮病鏈夋壘鍒板悎閫傜殑鐜荤拑"); MPJQueryWrapper<GlassInfo> queryWrapper = new MPJQueryWrapper<GlassInfo>() - .selectAll(GlassInfo.class).eq("t.glass_id", glassId) - .inSql("t.engineer_id", "select engineer_id from engineering where state = 1"); + .selectAll(GlassInfo.class).eq("t.glass_id", glassId); if (endcell == Const.A10_OUT_TARGET_POSITION) { - queryWrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + - "case when width < height then width else height end as second_length from glass_info) t1 " + - "on t.glass_id = t1.glass_id and (t1.first_length <=" + firstLength + " and t1.second_length<=" + secondLength + ") "); + queryWrapper.leftJoin("(select glass_id, case when height <= width then width else height end as first_length, " + + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + + "on t.glass_id = t1.glass_id and (t1.first_length between " + minTwoFirstLength + " and " + firstLength + + " and t1.second_length between " + minTwoSecondLength + " and " + secondLength + ") "); + } else { + queryWrapper.leftJoin("(select glass_id, case when height <= width then width else height end as first_length, " + + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + + "on t.glass_id = t1.glass_id and (t1.first_length >=" + minOneFirstLength + " and t1.second_length>=" + minOneSecondLength + ") "); } GlassInfo one = glassInfoService.getOne(queryWrapper); + log.info("鎵惧埌鍚堥�傜殑鐜荤拑" + one); if (one != null) { EdgStorageCageDetails resultDetails = new EdgStorageCageDetails(); BeanUtils.copyProperties(one, resultDetails); glassInfo = resultDetails; } else { - log.info("鑾峰彇绗煎唴鐜荤拑鍜屽甫杩涚墖鐜荤拑涓虹┖鎴栬�呬笉绗﹀悎纾ㄨ竟灏哄"); + log.info("鑾峰彇绗煎唴鐜荤拑鍜屽緟杩涚墖鐜荤拑涓虹┖鎴栬�呬笉绗﹀悎纾ㄨ竟灏哄"); } } else { glassInfo = queryMinGlass(list.get(0).getWidth(), list.get(0).getHeight(), glassId); @@ -333,7 +493,11 @@ } } } - return saveOutGlassMessage(glassInfo, endcell, confirmationWrodAddress, glassId, currentSlot); + if (endcell == Const.A09_OUT_TARGET_POSITION && Math.min(glassInfo.getWidth(), glassInfo.getHeight()) < Integer.parseInt(minOneFirstLength)) { + log.info("灏哄涓嶇鍚堟渶澶х嚎鏈�灏忓昂瀵竰}", glassInfo); + return Boolean.FALSE; + } + return saveOutGlassMessageBySlot(glassInfo, endcell, confirmationWrodAddress, glassId, currentSlot); } /** @@ -347,15 +511,16 @@ //todo: 鑾峰彇姝e湪鎵ц鐨勫伐绋嬩俊鎭� if (StringUtils.isNotBlank(glassId)) { GlassInfo one = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>() - .eq(GlassInfo::getGlassId, glassId) - .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1")); + .eq(GlassInfo::getGlassId, glassId)); +// .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1")); EdgStorageCageDetails resultDetails = new EdgStorageCageDetails(); BeanUtils.copyProperties(one, resultDetails); glassList.add(resultDetails); } //鑾峰彇绗煎唴鐜荤拑 - List<EdgStorageCageDetails> details = edgStorageCageDetailsService.list(new LambdaQueryWrapper<EdgStorageCageDetails>() - .eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)); + List<EdgStorageCageDetails> details = edgStorageCageDetailsService.selectJoinList(EdgStorageCageDetails.class, new MPJLambdaWrapper<EdgStorageCageDetails>().selectAll(EdgStorageCageDetails.class) + .leftJoin(EdgStorageCage.class, on -> on.eq(EdgStorageCage::getSlot, EdgStorageCageDetails::getSlot).eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN)) + .eq(EdgStorageCage::getEnableState, Const.SLOT_ON)); glassList.addAll(details); return glassList; @@ -366,19 +531,20 @@ * * @return */ - private boolean queryMaxMinDiff(int threshold) { + public 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); + .eq("state", Const.GLASS_STATE_IN) + .inSql("slot", "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON); List<Object> list = edgStorageCageDetailsService.listObjs(queryWrapper); + //鑾峰彇绗煎唴鐜荤拑鐗堝浘宸�兼槸鍚﹀ぇ浜庨槇鍊� if (CollectionUtil.isNotEmpty(list)) { Long diff = (Long) list.get(0); return diff > threshold; } else { return Boolean.FALSE; } - } /** @@ -387,12 +553,13 @@ * @param width * @param height */ - private EdgStorageCageDetails queryMinGlass(Double width, Double height, String glassId) { + private EdgStorageCageDetails queryMinGlass(double width, double height, String glassId) { //鑾峰彇琛ㄥ唴鐗堝浘id鏈�灏忕殑鐜荤拑淇℃伅 EdgStorageCageDetails glassDetails = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() .eq(EdgStorageCageDetails::getState, 100) .eq(width != 0, EdgStorageCageDetails::getWidth, width) .eq(height != 0, EdgStorageCageDetails::getHeight, height) + .inSql(EdgStorageCageDetails::getSlot, "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON) .orderByAsc(EdgStorageCageDetails::getTemperingLayoutId) .orderBy(Boolean.TRUE, sequenceOrder, EdgStorageCageDetails::getTemperingFeedSequence) .last("limit 1")); @@ -400,8 +567,8 @@ return glassDetails; } GlassInfo one = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>() - .eq(GlassInfo::getGlassId, glassId) - .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1") + .eq(GlassInfo::getGlassId, glassId) +// .inSql(GlassInfo::getEngineerId, "select engineer_id from engineering where state = 1") ); EdgStorageCageDetails resultDetails = new EdgStorageCageDetails(); BeanUtils.copyProperties(one, resultDetails); @@ -428,6 +595,7 @@ .eq("t.glass_id", taskCache.getGlassId()) .ne("t1.glass_id", taskCache.getGlassId()) .eq("t1.state", Const.GLASS_STATE_IN) + .inSql("t1.slot", "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON) .orderByAsc("t1.tempering_layout_id") .orderBy(Boolean.TRUE, sequenceOrder, "t1.tempering_feed_sequence"); List<EdgStorageCageDetails> details = edgStorageCageDetailsService.selectJoinList(EdgStorageCageDetails.class, mpjLambdaWrapper); @@ -451,7 +619,8 @@ return null; } return edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getGlassId, taskCache.getGlassId()) - .inSql(EdgStorageCageDetails::getEngineerId, "select engineer_id from engineering where state = 1").last(" limit 1 ")); + .inSql(EdgStorageCageDetails::getSlot, "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON) + .last(" limit 1 ")); } /** @@ -466,18 +635,20 @@ */ private Integer queryLineByGlassInfo(EdgStorageCageDetails a08EdgStorageCageDetails, EdgStorageCageDetails a10EdgStorageCageDetails, EdgStorageCageDetails glassInfo, int out08Glassstate, int out10Glassstate) { - boolean b08 = a08EdgStorageCageDetails != null && a08EdgStorageCageDetails.getHeight().equals(glassInfo.getHeight()) - && a08EdgStorageCageDetails.getWidth().equals(glassInfo.getWidth()); - boolean b10 = a10EdgStorageCageDetails != null && a10EdgStorageCageDetails.getHeight().equals(glassInfo.getHeight()) - && a10EdgStorageCageDetails.getWidth().equals(glassInfo.getWidth()); //瀛樺湪鍑虹墖浠诲姟 07涓虹┖ - if (b10) { - return out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; + if (out08Glassstate == 1 && out10Glassstate == 1) { + boolean b08 = a08EdgStorageCageDetails != null && a08EdgStorageCageDetails.getHeight() == glassInfo.getHeight() + && a08EdgStorageCageDetails.getWidth() == glassInfo.getWidth(); + boolean b10 = a10EdgStorageCageDetails != null && a10EdgStorageCageDetails.getHeight() == glassInfo.getHeight() + && a10EdgStorageCageDetails.getWidth() == glassInfo.getWidth(); + if (b08) { + return Const.A09_OUT_TARGET_POSITION; + } + if (b10) { + return Const.A10_OUT_TARGET_POSITION; + } } - if (b08) { - return out08Glassstate == 2 ? Const.A10_OUT_TARGET_POSITION : Const.A09_OUT_TARGET_POSITION; - } - return out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION; + return computerLineByState(out08Glassstate, out10Glassstate); } /** @@ -492,11 +663,17 @@ MPJQueryWrapper<EdgStorageCageDetails> wrapper = new MPJQueryWrapper<>(); wrapper.select("count(t.glass_id) as count, t.width, t.height") .eq("t.state", Const.GLASS_STATE_IN) + .inSql("t.slot", "select slot from edg_storage_cage where enable_state = " + Const.SLOT_ON) .groupBy("t.width, t.height"); - if (endcell == Const.A09_OUT_TARGET_POSITION) { + if (endcell == Const.A10_OUT_TARGET_POSITION) { wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + - "on t.glass_id = t1.glass_id and (t1.first_length <=" + firstLength + " and t1.second_length<=" + secondLength + ") "); + "on t.glass_id = t1.glass_id and (t1.first_length >= " + minOneFirstLength + " and t1.second_length >= " + minOneSecondLength + ")"); + } else { + wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + + "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + + "on t.glass_id = t1.glass_id and (t1.first_length between " + minTwoFirstLength + " and " + firstLength + + " and t1.second_length between " + minTwoSecondLength + " and " + secondLength + ") "); } wrapper.last("order by count(t.glass_id) desc limit 2"); List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper); @@ -507,16 +684,16 @@ //鑾峰彇瀹介珮鎷嶇涓�鐨勭幓鐠冧俊鎭� EdgStorageCageDetails firstSize = list.get(0); Integer firstCount = firstSize.getCount(); - Double firstWidth = firstSize.getWidth(); - Double firstHeight = firstSize.getHeight(); + double firstWidth = firstSize.getWidth(); + double firstHeight = firstSize.getHeight(); if (list.size() == 1) { return queryMinGlass(firstWidth, firstHeight, glassId); } //鑾峰彇瀹介珮鎷嶇浜岀殑鐜荤拑淇℃伅 EdgStorageCageDetails secondSize = list.get(1); Integer secondCount = secondSize.getCount(); - Double secondWidth = secondSize.getWidth(); - Double secondHeight = secondSize.getHeight(); + double secondWidth = secondSize.getWidth(); + double secondHeight = secondSize.getHeight(); //鑾峰彇鏁伴噺鍓�2鐨勭幓鐠冩暟閲忔瘮渚� Integer mix = firstCount / secondCount; log.info("鑾峰彇鐜荤拑鏁伴噺鍓�2鐨勭幓鐠冨崰姣斾负锛歿}", mix); @@ -534,9 +711,9 @@ return queryMinGlass(firstSize.getWidth(), firstSize.getHeight(), glassId); } EdgStorageCageDetails outGlassInfo = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() - .eq(EdgStorageCageDetails::getGlassId, taskCache.getGlassId())); + .eq(EdgStorageCageDetails::getGlassId, taskCache.getGlassId()).last("limit 1")); log.info("{}绾挎湁鍑虹墖浠诲姟淇℃伅,浠诲姟淇℃伅涓簕}锛岀幓鐠冧俊鎭负{}", endcell, taskCache, outGlassInfo); - if (outGlassInfo.getWidth().equals(firstWidth) && outGlassInfo.getHeight().equals(firstHeight)) { + if (outGlassInfo.getWidth() == firstWidth && outGlassInfo.getHeight() == firstHeight) { log.info("鏁伴噺鏈�澶氱殑瀹絳}楂榹}鍜寋}绾夸换鍔$殑瀹絳}楂榹}鐩稿悓锛屽嚭鏁伴噺鎺掔浜岀殑鐜荤拑锛屽{}楂榹}", firstWidth, firstHeight, endcell, outGlassInfo.getWidth(), outGlassInfo.getHeight(), secondWidth, secondHeight); return queryMinGlass(secondWidth, secondHeight, glassId); @@ -562,6 +739,7 @@ log.info("4銆佹坊鍔犲嚭鐗囦换鍔★紝鐜荤拑id锛歿}锛屼换鍔$被鍨嬶細{}锛岃捣濮嬩綅缃細{}锛岀粨鏉熶綅缃細{}", glassInfo.getGlassId(), 2, glassInfo.getSlot(), endcell); if (glassInfo.getGlassId().equals(glassId)) { + log.info("5銆佺洿閫氫换鍔�,灏嗙幓鐠冧俊鎭彃鍏ュ崸寮忕悊鐗囩,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); EdgStorageCageDetails details = new EdgStorageCageDetails(); BeanUtils.copyProperties(glassInfo, details); @@ -571,25 +749,103 @@ details.setSlot(nearestEmpty.getSlot()); details.setState(Const.GLASS_STATE_OUT); edgStorageCageDetailsService.save(details); - boolean taskCacheStatus = saveTaskCache(glassInfo.getGlassId(), nearestEmpty.getSlot(), endcell, Const.GLASS_CACHE_TYPE_THROUGH); log.info("6銆佹坊鍔犲嚭鐗囦换鍔℃槸鍚﹀畬鎴愶細{}", taskCacheStatus); } else { log.info("5銆侀潪鐩撮�氫换鍔�,灏嗙幓鐠冧俊鎭彃鍏ュ崸寮忕悊鐗囩,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); - 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); + LambdaUpdateWrapper<EdgStorageCageDetails> wrapper = new LambdaUpdateWrapper<>(); + wrapper.eq(EdgStorageCageDetails::getGlassId, glassInfo.getGlassId()).set(EdgStorageCageDetails::getState, Const.GLASS_STATE_OUT); + edgStorageCageDetailsService.update(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); + boolean glassSizeStatus = saveGlassSize(glassInfo, endcell); log.info("7銆佹坊鍔犲嚭鐗囩幓鐠冨昂瀵镐俊鎭埌纾ㄨ竟鍓嶇幓鐠冭〃鏄惁瀹屾垚锛歿}", glassSizeStatus); - S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 1); + S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, 1); log.info("8銆佸彂閫佺‘璁ゅ瓧宸插畬鎴�"); + Damage damage = new Damage(); + damage.setGlassId(glassInfo.getGlassId()); + damage.setWorkingProcedure("鍒囧壊"); + damage.setLine(1001); + damage.setType(1); + damage.setRemark("杩囧崸寮忕悊鐗�"); + damageService.insertDamage(damage); + damageService.deleteByGlassId(glassId); + return Boolean.TRUE; + } + return Boolean.FALSE; + } + + /** + * 淇濆瓨鍑虹墖浠诲姟鐩稿叧淇℃伅 + * + * @param glassInfo + * @param endcell + * @param confirmationWrodAddress + * @param glassId + * @return + */ + private boolean saveOutGlassMessageBySlot(EdgStorageCageDetails glassInfo, int endcell, String confirmationWrodAddress, String glassId, Integer currentSlot) { + if (glassInfo != null) { + log.info("4銆佹坊鍔犲嚭鐗囦换鍔★紝鐜荤拑id锛歿}锛屼换鍔$被鍨嬶細{}锛岃捣濮嬩綅缃細{}锛岀粨鏉熶綅缃細{}", glassInfo.getGlassId(), + 2, glassInfo.getSlot(), endcell); + if (glassInfo.getGlassId().equals(glassId)) { + log.info("5銆佺洿閫氫换鍔�,灏嗙幓鐠冧俊鎭彃鍏ュ崸寮忕悊鐗囩,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); + EdgStorageCageDetails details = new EdgStorageCageDetails(); + //鐜荤拑淇℃伅鏇挎崲 + String glassIdChange = queryAndChangeGlass(glassId); + if (StringUtils.isBlank(glassIdChange)) { + BeanUtils.copyProperties(glassInfo, details); + } else { + GlassInfo one = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId)); + BeanUtils.copyProperties(one, details); + } + EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(currentSlot, Boolean.TRUE); + Assert.isTrue(null != nearestEmpty, "鏍煎瓙宸叉弧,鏃犳硶鎵ц鐩撮�氫换鍔�"); + log.info("3銆佹煡璇㈠崸寮忕悊鐗囩閲岄潰鐨勭┖鏍�:{}", nearestEmpty); + details.setSlot(nearestEmpty.getSlot()); + details.setState(Const.GLASS_STATE_OUT); + edgStorageCageDetailsService.save(details); + boolean taskCacheStatus = saveTaskCache(glassInfo.getGlassId(), nearestEmpty.getSlot(), endcell, Const.GLASS_CACHE_TYPE_THROUGH); + log.info("6銆佹坊鍔犲嚭鐗囦换鍔℃槸鍚﹀畬鎴愶細{}", taskCacheStatus); + } else { + log.info("5銆侀潪鐩撮�氫换鍔�,灏嗙幓鐠冧俊鎭彃鍏ュ崸寮忕悊鐗囩,褰撳墠鐜荤拑淇℃伅:{}", glassInfo); + if (!glassInfo.getSlot().equals(currentSlot)) { + EdgStorageCageDetails currentGlass = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>() + .eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN) + .eq(EdgStorageCageDetails::getSlot, currentSlot).eq(EdgStorageCageDetails::getWidth, glassInfo.getWidth()) + .eq(EdgStorageCageDetails::getHeight, glassInfo.getHeight()).eq(EdgStorageCageDetails::getThickness, glassInfo.getThickness()) + ); + if (null != currentGlass) { + glassInfo = currentGlass; + } + } +// //鐜荤拑淇℃伅鏇挎崲 +// String glassIdChange = queryAndChangeGlass(glassInfo.getGlassId()); +// //澶勭悊鍦ㄥ崸鐞嗗唴鐨勭幓鐠冧俊鎭細绗煎唴鐨勬暟鎹鐞� +// queryEdgAndChangeGlass(glassInfo.getGlassId(), glassIdChange); + LambdaUpdateWrapper<EdgStorageCageDetails> wrapper = new LambdaUpdateWrapper<>(); + wrapper.eq(EdgStorageCageDetails::getGlassId, glassInfo.getGlassId()).set(EdgStorageCageDetails::getState, Const.GLASS_STATE_OUT); + edgStorageCageDetailsService.update(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, endcell); + log.info("7銆佹坊鍔犲嚭鐗囩幓鐠冨昂瀵镐俊鎭埌纾ㄨ竟鍓嶇幓鐠冭〃鏄惁瀹屾垚锛歿}", glassSizeStatus); + S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, 1); + log.info("8銆佸彂閫佺‘璁ゅ瓧宸插畬鎴�"); + Damage damage = new Damage(); + damage.setGlassId(glassInfo.getGlassId()); + damage.setWorkingProcedure("鍒囧壊"); + damage.setLine(1001); + damage.setType(1); + damage.setRemark("杩囧崸寮忕悊鐗�"); + damageService.insertDamage(damage); + damageService.deleteByGlassId(glassId); return Boolean.TRUE; } return Boolean.FALSE; @@ -616,34 +872,70 @@ } /** - * 娣诲姞鐞嗙墖绗间换鍔� + * 娣诲姞纾ㄨ竟闃熷垪淇℃伅 * * @param glassInfo + * @param endcell * @return */ - private boolean saveGlassSize(EdgStorageCageDetails glassInfo) { + private boolean saveGlassSize(EdgStorageCageDetails glassInfo, int endcell) { EdgGlassTaskInfo edgGlassTaskInfo = new EdgGlassTaskInfo(); BeanUtils.copyProperties(glassInfo, edgGlassTaskInfo); edgGlassTaskInfo.setHeight((int) (glassInfo.getHeight() * ratio)); edgGlassTaskInfo.setWidth((int) (glassInfo.getWidth() * ratio)); edgGlassTaskInfo.setThickness((int) (glassInfo.getThickness() * ratio)); edgGlassTaskInfo.setStatus(Const.EDG_GLASS_BEFORE); + edgGlassTaskInfo.setLine(endcell); + edgGlassTaskInfo.setTime(new Date()); + //鍏堝皢鍘嗗彶瀵瑰垪琛ㄤ腑鏈幓鐠冪殑鏁版嵁鍒犻櫎锛岄噸鏂版柊澧炰竴浠芥渶鏂扮殑鏁版嵁 + edgGlassTaskInfoService.remove(new LambdaQueryWrapper<EdgGlassTaskInfo>().eq(EdgGlassTaskInfo::getGlassId, glassInfo.getGlassId())); return edgGlassTaskInfoService.save(edgGlassTaskInfo); } /** - * 褰撳墠鍒囧壊鐗堝浘淇℃伅 + * 璁$畻鍑虹墖绾胯矾 + * 宸叉帓闄ら兘涓�2 閮戒负0 鐨勬儏鍐� * - * @param + * @param out08Glassstate + * @param out10Glassstate * @return */ - @Scheduled(fixedDelay = 1000) - public void currentCutTerritory(){ - JSONObject jsonObject = new JSONObject(); - List<Map<String, Object>> currentCutTerritorys = edgStorageCageDetailsService.selectCutTerritory(); - jsonObject.append("currentCutTerritory", currentCutTerritorys); + private int computerLineByState(int out08Glassstate, int out10Glassstate) { +// if (out08Glassstate == 0) { +// if (out10Glassstate == 2) { +// return Const.A09_OUT_TARGET_POSITION; +// } else { +// return Const.A10_OUT_TARGET_POSITION; +// } +// } else if (out08Glassstate == 1) { +// return Const.A09_OUT_TARGET_POSITION; +// } else { +// return Const.A10_OUT_TARGET_POSITION; +// } + if (out10Glassstate == 0) { + if (out08Glassstate == 2) { + return Const.A10_OUT_TARGET_POSITION; + } else { + return Const.A09_OUT_TARGET_POSITION; + } + } else if (out10Glassstate == 1) { + return Const.A10_OUT_TARGET_POSITION; + } else { + return Const.A09_OUT_TARGET_POSITION; + } + } + + @Scheduled(fixedDelay = 3000) + public void CacheGlassTasks() { ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("cacheGlass"); if (sendwServer != null) { + JSONObject jsonObject = new JSONObject(); + List<Map<String, Object>> currentCutTerritorys = edgStorageCageDetailsService.selectCutTerritory(); + jsonObject.append("currentCutTerritory", currentCutTerritorys); + //log.info("鏈璇嗗埆鐗堝浘{},++++{}",engineerId,currentCutTerritorys); + //鍗у缂撳瓨绗煎唴淇℃伅 + List<Map<String, Object>> EdgStorageCageinfos = edgStorageCageService.selectEdgStorageCages(); + jsonObject.append("EdgStorageCageinfos", EdgStorageCageinfos); for (WebSocketServer webserver : sendwServer) { if (webserver != null) { webserver.sendMessage(jsonObject.toString()); @@ -659,20 +951,33 @@ } } - /** - * 纾ㄨ竟浠诲姟 - * - * @param - * @return - */ - @Scheduled(fixedDelay = 1000) - public void selectEdgTask(){ + @Scheduled(fixedDelay = 3000) + public void cacheGlassIsRun() { JSONObject jsonObject = new JSONObject(); - List<Map<String,Object>> EdgTasks1 = taskCacheService.selectEdgInfo("2001"); - List<Map<String,Object>> EdgTasks2 = taskCacheService.selectEdgInfo("2002"); - jsonObject.append("EdgTasks1", EdgTasks1); - jsonObject.append("EdgTasks2", EdgTasks2); - ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("cacheGlass"); + //姝e湪杩涜鐨勪换鍔� + List<EdgGlassTaskInfo> taskCaches = edgGlassTaskInfoService.selectTaskCacheIsRun(); + jsonObject.append("taskCaches", taskCaches); + ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("cacheGlassIsRun"); + if (sendwServer != null) { + for (WebSocketServer webserver : sendwServer) { + if (webserver != null) { + webserver.sendMessage(jsonObject.toString()); + } else { + log.info("Home is closed"); + } + } + } + } + + @Scheduled(fixedDelay = 3000) + public void CacheGlassTaskss() { + JSONObject jsonObject = new JSONObject(); + //log.info("鏈璇嗗埆鐗堝浘{},++++{}",engineerId,currentCutTerritorys); + //纾ㄨ竟淇℃伅 + List<EdgGlassTaskInfo> edgTasks = edgGlassTaskInfoService.selectEdgInfo(); + jsonObject.append("edgTasks", edgTasks); + + ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("edgTasks"); if (sendwServer != null) { for (WebSocketServer webserver : sendwServer) { if (webserver != null) { @@ -683,39 +988,9 @@ webserver.clearMessages(); } } else { - log.info("Home is closed"); + log.info("edgTasks is closed"); } } } } - - /** - * 纾ㄨ竟鍓� 缂撳瓨鍐呬俊鎭� - * - * @param - * @return - */ - @Scheduled(fixedDelay = 1000) - public void selectEdgStorageCage(){ - JSONObject jsonObject = new JSONObject(); - List<Map<String, Object>> EdgStorageCageinfos=edgStorageCageService.selectEdgStorageCages(); - jsonObject.append("EdgStorageCageinfos", EdgStorageCageinfos); - ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("cacheGlass"); - if (sendwServer != null) { - for (WebSocketServer webserver : sendwServer) { - if (webserver != null) { - webserver.sendMessage(jsonObject.toString()); - List<String> messages = webserver.getMessages(); - if (!messages.isEmpty()) { - // // 灏嗘渶鍚庝竴涓秷鎭浆鎹负鏁存暟绫诲瀷鐨勫垪琛� - webserver.clearMessages(); - } - } else { - log.info("Home is closed"); - } - } - } - } - - } -- Gitblit v1.8.0