From 7f1806c6a01318f3b1eff38da7c7c41ae82ff8c0 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期一, 11 十二月 2023 13:19:52 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 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 84d1fe4..e494aba 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 @@ -55,8 +55,8 @@ short SelectInTask(); // 鎵嬪姩瀹屾垚浠诲姟 - @Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0") - void UpdateTask(@Param("task_type") Integer task_type); + @Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0 and glass_id=#{glassid}") + void UpdateTask(@Param("task_type") Integer task_type,String glassid); // 鎵嬪姩瀹屾垚杩涚墖浠诲姟淇敼绗煎瓙鏁版嵁 @Update("update storage_cage set state=1 where glass_id=#{glassid} and state=2") @@ -168,8 +168,8 @@ @Select("select ifnull(max(sequence),0)+1 from out_slice ") Short SelectMaxSquence(); //鏌ヨ鐢ㄦ埛鏉冮檺 - @Select("select rp.* from role_permission rp inner join role r on rp.role_id=r.id and r.name=#{token} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35)") - List<RolePermission> SelectPermissionByUserName(String token); + @Select("select rp.* from role_permission rp inner join user r on rp.role_id=r.role_id and r.username=#{username} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35)") + List<RolePermission> SelectPermissionByUserName(String username); //瀹屾垚鍑虹墖浠诲姟 @Update("update out_slice set state=2 where id=#{id}") void CompleteQueue(String id); -- Gitblit v1.8.0