From 7b89e2cf25b6d5a43ecc86bb64a6a245ae862c6e Mon Sep 17 00:00:00 2001 From: 严智鑫 <test> Date: 星期五, 17 五月 2024 11:12:25 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java | 58 ++++++++++++++++++++++++++++++++++++---------------------- 1 files changed, 36 insertions(+), 22 deletions(-) diff --git a/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java index ffd6491..3b8a57a 100644 --- a/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java +++ b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java @@ -1,7 +1,9 @@ package com.mes.workstation.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.mes.engineering.entity.Engineering; import com.mes.uppattenusage.entity.UpPattenUsage; import com.mes.uppattenusage.mapper.UpPattenUsageMapper; import com.mes.workstation.entity.UpWorkSequence; @@ -27,36 +29,47 @@ public class UpWorkstationServiceImpl extends ServiceImpl<UpWorkstationMapper, UpWorkstation> implements UpWorkstationService { @Resource UpPattenUsageMapper upPattenUsageMapper; - public static final String DB_100_10 = "DB_100_10"; - - //鍒ゆ柇鏄惁鍙互鍚哥墖杩涜浠诲姟 - public boolean isCanLoadGlass() { - String loadstart = "鍚哥墖淇″彿";//plcmes.getPlcParameter("鍚哥墖淇″彿").getValue(); - return "1".equals(loadstart); - - } - //鏄剧ず姝e湪杩涜浠诲姟鐨勫伐绋嬩俊鎭� + @Resource + UpWorkstationMapper upWorkstationMapper; //鍒ゆ柇浼樺厛鍚哥墖浣嶇疆鍚庡彂閫佸嚭鐗囦换鍔� - public UpWorkSequence selectPriority() { - UpWorkSequence upwork= this.baseMapper.selectPriority(1); - String start = "1";//plcmes.getPlcParameter("鍚哥墖淇″彿").getValue(); - UpPattenUsage uplist=new UpPattenUsage(); - if(start.equals("1")){ - //鍙戦�佸嚭鐗囦换鍔� - UpdateWrapper<UpPattenUsage> updateWrapper = new UpdateWrapper<>(); - updateWrapper.eq("state",1).last("LIMIT 1"); - uplist= upPattenUsageMapper.selectOne(updateWrapper); - log.info("鏌ヨ鍑烘湰娆″嚭鐗囩殑鐜荤拑淇℃伅[]",uplist); - } - return upwork; + public UpPattenUsage selectPriority(Engineering engineering) { + QueryWrapper<UpPattenUsage> wrapper=new QueryWrapper<>(); + wrapper.eq("state", 0) + .eq("engineering_id",engineering.getEngineerId()) + .orderByAsc("layout_sequence") + .last("limit 1"); + return upPattenUsageMapper.selectOne(wrapper); + } + + //鍒ゆ柇宸ヤ綅鏄惁鏈夌鍚堟潯浠剁殑鐜荤拑 + @Override + public UpWorkstation selectWorkstation(UpPattenUsage upPattenUsage) { + QueryWrapper<UpWorkstation> wrapper = new QueryWrapper<>(); + wrapper.eq("pattern_width", upPattenUsage.getWidth()) + .eq("pattern_height", upPattenUsage.getHeight()) + .eq("pattern_thickness", upPattenUsage.getThickness()) + .eq("films_id", upPattenUsage.getFilmsId()) + .gt("number", 0) + .orderByAsc("number") + .last("limit 1"); + return this.baseMapper.selectOne(wrapper); + } + + @Override + public void reduceWorkstationNumber(Integer upworkId) { + UpdateWrapper<UpWorkstation> wrapper = new UpdateWrapper<>(); + wrapper.eq("id", upworkId) + .setSql("number = number - 1"); + boolean updateResult = upWorkstationMapper.update(null, wrapper) > 0; + log.info("鍑忓皯宸ヤ綅鏁伴噺{}",updateResult); + } /** * 澧炲姞浜哄伐杈撳叆鐨勫伐浣嶇幓鐠冧俊鎭�/鍒犻櫎浜哄伐鎼蛋鐨勭幓鐠冧俊鎭� - * @param upwork */ @Override public void updateGlassMessage(UpWorkstation upwork) { @@ -66,4 +79,5 @@ } + } -- Gitblit v1.8.0