From bbbc39611d232e013b900ba5e6a5a483a062e2f3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 23 七月 2025 16:46:49 +0800
Subject: [PATCH] 实现CommonMapper中空白方法
---
se-common/src/main/java/com/terra/common/mapper/CommonMapper.java | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git a/se-common/src/main/java/com/terra/common/mapper/CommonMapper.java b/se-common/src/main/java/com/terra/common/mapper/CommonMapper.java
index 537e33d..035471d 100644
--- a/se-common/src/main/java/com/terra/common/mapper/CommonMapper.java
+++ b/se-common/src/main/java/com/terra/common/mapper/CommonMapper.java
@@ -24,9 +24,18 @@
@Select("select a.* from lf.sys_token a where token = #{token} and expire > now() limit 1")
TokenPo selectOneByToken(String token);
- @Select("")
+ @Select("select ip from lf.sys_blacklist where type = #{type}")
List<String> selectIpList(Integer type);
- @Select("")
+ @Select("SELECT DISTINCT e.perms || f.tag AS perms " +
+ "FROM lf.sys_user a " +
+ "INNER JOIN lf.sys_role_user b ON a.id = b.userid " +
+ "INNER JOIN lf.sys_role_menu_auth c ON b.roleid = c.roleid " +
+ "INNER JOIN lf.sys_menu_auth d ON c.menu_auth_id = d.id " +
+ "INNER JOIN lf.sys_menu e ON d.menuid = e.id " +
+ "INNER JOIN lf.sys_auth f ON d.authid = f.id " +
+ "WHERE e.perms IS NOT NULL " +
+ "AND (#{uid} IS NULL OR a.uid = #{uid}) " +
+ "ORDER BY perms")
List<String> selectPerms(String type);
}
--
Gitblit v1.9.3