From e7110f57152cc0428dfa18ea34a924b06b2d89b3 Mon Sep 17 00:00:00 2001 From: 严智鑫 <test> Date: 星期二, 09 四月 2024 14:12:53 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/Albania_Mes --- springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java index 4ebf773..2772b5c 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java +++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java @@ -17,7 +17,7 @@ @Select("SELECT * FROM queue where glassid=#{glassid}") List<Queue> selectQueues(@Param("glassid") int glassid); - @Select("SELECT * FROM queue order by time asc limit 1") + @Select("SELECT * FROM queue order by time desc limit 1") Queue selectLastQueue(); @Select("SELECT * FROM queue where state<=0") @@ -30,8 +30,8 @@ // @Update("UPDATE role_permission SET state = #{state} WHERE role_id = #{roleId} AND permission_id = #{permissionId}") // void updateState(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state); - @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time) "+ - "select glassid,flowcard,null,null,width,height,#{glasswidthmm},#{glassheightmm},glasstype,#{state},NOW() from glassinfo where glassid=#{glassid}") + @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time,thickness) "+ + "select glassid,flowcard,null,null,width,height,#{glasswidthmm},#{glassheightmm},glasstype,#{state},NOW(),thickness from glassinfo where glassid=#{glassid}") void insert(@Param("glassid") String glassid, @Param("glasswidthmm") double glasswidthmm, @Param("glassheightmm") double glassheightmm,@Param("state") int state); @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time) "+ -- Gitblit v1.8.0