From 807d0524a6e965599f9cdbfc7bbf7504c4d9b917 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期二, 23 五月 2023 10:34:00 +0800 Subject: [PATCH] 修复推流鉴权 --- src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 10 +++++----- 1 files changed, 5 insertions(+), 5 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 index 89b9d86..67cdccd 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java @@ -50,11 +50,11 @@ @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 * 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") -- Gitblit v1.8.0