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