From 69e3dd71185b1cdaf524a4d2a25bf9648bd02ff4 Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期五, 10 五月 2024 17:01:07 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/workstation/service/impl/UpWorkstationServiceImpl.java | 57 +++++++++++++++++++++++++++++++++++---------------------- 1 files changed, 35 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..1e24d13 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(UpWorkstation upwork) { + UpdateWrapper<UpWorkstation> wrapper = new UpdateWrapper<>(); + wrapper.eq("id", upwork.getWorkstationId()) + .setSql("number = number - 1"); + boolean updateResult = upWorkstationMapper.update(null, wrapper) > 0; + log.info("鍑忓皯宸ヤ綅鏁伴噺{}",updateResult); + } /** * 澧炲姞浜哄伐杈撳叆鐨勫伐浣嶇幓鐠冧俊鎭�/鍒犻櫎浜哄伐鎼蛋鐨勭幓鐠冧俊鎭� - * @param upwork */ @Override public void updateGlassMessage(UpWorkstation upwork) { -- Gitblit v1.8.0