From 764d04b497356ba6bcbb75fd42b51eca750f7223 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期三, 29 五月 2024 15:02:51 +0800 Subject: [PATCH] 调整上级观看消息的发送 --- src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 11 +++-------- 1 files changed, 3 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java old mode 100644 new mode 100755 index 67cdccd..168a577 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java @@ -2,6 +2,7 @@ import com.genersoft.iot.vmp.storager.dao.dto.User; import org.apache.ibatis.annotations.*; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.List; @@ -36,7 +37,7 @@ @Result(column = "role_create_time", property = "role.createTime"), @Result(column = "role_update_time", property = "role.updateTime") }) - User select(String username, String password); + User select(@Param("username") String username, @Param("password") String password); @Select("select u.*, r.id as role_id, r.name as role_name, r.authority as role_authority , r.create_time as role_create_time , r.update_time as role_update_time from wvp_user u, wvp_user_role r WHERE u.role_id=r.id and u.id=#{id}") @ResultMap(value="roleMap") @@ -50,16 +51,10 @@ @ResultMap(value="roleMap") List<User> selectAll(); -// @Select("select * from (select user.*, concat(concat(#{call_id}, '_'), push_key) as str1 from wvp_user) as u where md5(u.str1) = #{sign}") -// List<User> checkPushAuthorityByCallIdAndSign(String callId, String sign); -// -// @Select("select * from wvp_user where md5(push_key) = #{sign}") -// List<User> checkPushAuthorityByCallId(String sign); - @Select("select u.id, u.username,u.push_key,u.role_id, r.id as role_id, r.name as role_name, r.authority as role_authority , r.create_time as role_create_time , r.update_time as role_update_time from wvp_user u join wvp_user_role r on u.role_id=r.id") @ResultMap(value="roleMap") List<User> getUsers(); @Update("UPDATE wvp_user set push_key=#{pushKey} where id=#{id}") - int changePushKey(int id, String pushKey); + int changePushKey(@Param("id") int id, @Param("pushKey") String pushKey); } -- Gitblit v1.8.0