From dba117185ebab076ce8ae59c1df13f0d14f6cfe0 Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期日, 17 九月 2023 16:43:30 +0800 Subject: [PATCH] 主界面添加小车位置配置 --- springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java | 14 +++++++++----- 1 files changed, 9 insertions(+), 5 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 3e22d2c..7a964ac 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 @@ -2,6 +2,7 @@ import org.apache.ibatis.annotations.*; +import com.example.springboot.entity.CarPosition; import com.example.springboot.entity.StorageCage; import com.example.springboot.entity.alarmmg; @@ -14,19 +15,19 @@ List<StorageCage> selectAll(); // 鏌ヨ1-5绗煎唴灞傛牸瀛愮姸鎬� - @Select("SELECT cage,state from storage_cage where cage<=5 and tier=1") + @Select("SELECT cage,state,glasswidth/2750*2 as glasswidth from storage_cage where cage<=5 and tier=2") List<StorageCage> selectRack1(); // 鏌ヨ6-10绗煎唴灞傛牸瀛愮姸鎬� - @Select("SELECT cage,state from storage_cage where cage>5 and tier=1") + @Select("SELECT cage,state,glasswidth/2750*2 as glasswidth from storage_cage where cage>5 and tier=2") List<StorageCage> selectRack2(); // 鏌ヨ1-5绗煎灞傛牸瀛愮姸鎬� - @Select("SELECT cage,state from storage_cage where cage<=5 and tier=2") + @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") List<StorageCage> selectRack3(); // 鏌ヨ6-10绗煎灞傛牸瀛愮姸鎬� - @Select("SELECT cage,state from storage_cage where cage>5 and tier=2") + @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") List<StorageCage> selectRack4(); // 鏍规嵁浠诲姟绫诲瀷鏌ヨ褰撳墠姝e湪鍑虹墖锛岃繘鐗囩殑鐜荤拑淇℃伅 @@ -66,10 +67,13 @@ List<alarmmg> SelectAlarmmgInfo(); //鑾峰彇鐞嗙墖绗煎唴鐜荤拑淇℃伅 - @Select("select *,concat(glasswidth,' x ',glassheight) as lengthwidth from storage_cage where cage=#{cage} ") + @Select("select *,concat(glasswidth,' x ',glassheight) as lengthwidth from storage_cage where cage=#{cage} and state!=0 ") List<StorageCage> SelectCageInfo(short cage); @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where glass_id=#{glassid}") void DeleteByGlassID(short glassid); + @Select("select * from car_position") + List<CarPosition> Loadcarlist(); + } -- Gitblit v1.8.0