From d0e719bd6bb8d2a840211d60efbb46b83d77455d Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期四, 21 九月 2023 09:51:54 +0800
Subject: [PATCH] 添加玻璃尺寸不在范围内的提示并不允许上片
---
springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java | 16 ++++++++++------
1 files changed, 10 insertions(+), 6 deletions(-)
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
index 04cd455..2a2bae3 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
@@ -3,6 +3,7 @@
import org.apache.ibatis.annotations.*;
import com.example.springboot.entity.CarPosition;
+import com.example.springboot.entity.Glass;
import com.example.springboot.entity.StorageCage;
import com.example.springboot.entity.alarmmg;
@@ -14,19 +15,19 @@
@Select("select cage,round(100-(21-sum(state))/21*100) as cell,21-sum(state) as state from (select cage,cell,max(state) as state from storage_cage group by cage,cell) as cages group by cage")
List<StorageCage> selectAll();
- // 鏌ヨ1-5绗煎唴灞傛牸瀛愮姸鎬�
+ // 鏌ヨ10-6绗煎唴灞傛牸瀛愮姸鎬�
@Select("SELECT cage,state,ifnull(glasswidth/2750*2,0) as glasswidth from storage_cage where cage>5 and tier=2 order by cage desc,cell desc")
List<StorageCage> selectRack1();
- // 鏌ヨ6-10绗煎唴灞傛牸瀛愮姸鎬�
+ // 鏌ヨ5-1绗煎唴灞傛牸瀛愮姸鎬�
@Select("SELECT cage,state,ifnull(glasswidth/2750*2,0) as glasswidth from storage_cage where cage<=5 and tier=2 order by cage desc,cell desc")
List<StorageCage> selectRack2();
- // 鏌ヨ1-5绗煎灞傛牸瀛愮姸鎬�
+ // 鏌ヨ10-6绗煎灞傛牸瀛愮姸鎬�
@Select("SELECT case when tier=1 then cage else 0 end as cage,case when tier=1 then state else 0 end as state,sum(case when tier=1 then glasswidth/2750*2 else 0 end) as glasswidth,sum(case when tier=2 then glasswidth/2750*2 else 0 end) as width from storage_cage where cage>5 group by cage,cell order by cage desc,cell desc")
List<StorageCage> selectRack3();
- // 鏌ヨ6-10绗煎灞傛牸瀛愮姸鎬�
+ // 鏌ヨ5-1绗煎灞傛牸瀛愮姸鎬�
@Select("SELECT case when tier=1 then cage else 0 end as cage,case when tier=1 then state else 0 end as state,sum(case when tier=1 then glasswidth/2750*2 else 0 end) as glasswidth,sum(case when tier=2 then glasswidth/2750*2 else 0 end) as width from storage_cage where cage<=5 group by cage,cell order by cage desc,cell desc")
List<StorageCage> selectRack4();
@@ -47,8 +48,8 @@
void updateOrder();
// 鏌ヨ鏄惁瀛樺湪姝ｅ湪涓婄墖鐨勪换鍔�
- @Select("select count(*) from storage_task where task_state=0 and task_type=1")
- short SelectOutTask();
+ @Select("select count(*) from storage_task where task_state=0 and task_type=0")
+ short SelectInTask();
// 鎵嬪姩瀹屾垚浠诲姟
@Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0")
@@ -82,4 +83,7 @@
@Select("select * from storage_cage where glass_id=#{glassid}")
StorageCage SelectGlassInfo(Integer glassid);
+ @Select("select * from glass where glassid=#{glassid}")
+ Glass SelectGlassByGlassID(String glassid);
+
}
--
Gitblit v1.8.0