From e8a5942bd0ac1188281cda29c882bb0e107896dc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 13 十月 2022 16:56:32 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/sys/UserController.java | 2
data/db_fn.sql | 18 ++---
data/db_tab.sql | 2
data/menu-执行.xls | 0
src/main/resources/mapper/sys/UserMapper.xml | 6 +-
说明.txt | 9 +-
src/main/java/com/lf/server/controller/sys/AuthController.java | 27 +++++++++
src/main/java/com/lf/server/mapper/sys/AuthMapper.java | 21 ++++++
src/main/resources/mapper/sys/AuthMapper.xml | 26 +++++++-
src/main/java/com/lf/server/service/sys/AuthService.java | 11 +++
10 files changed, 96 insertions(+), 26 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 23f7a00..d5a24db 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -150,25 +150,21 @@
-----------------------------------------------------------------------------------------------------
select a.*,fn_uname(a.create_user) createUserName,fn_uname(a.update_user) updateUserName from lf.sys_blacklist a order by a.id;
select * from lf.sys_user a where uname like '%' and a.depid=ANY(fn_rec_array(1,'dep'));
-
select * from lf.sys_user a left join lf.sys_role_user b on a.id=b.userid
-where exist
-select * from lf.sys_user a where not exists (select id from lf.sys_role_user b where b.userid = a.id and b.roleid = 1)
+select a.* from lf.sys_user a where not exists (select b.id from lf.sys_role_user b where b.userid = a.id and b.roleid = 1)
and uname like '%瀹�%' and a.depid = ANY(fn_rec_array(1, 'dep'))
order by a.id limit 10 offset 0;
-select a.*,fn_uname(a.userid) uname from lf.sys_role_user a order by a.id
-select a.*,fn_uname(a.userid) uname from lf.sys_role_user a where a.id = 1
-
select a.*,fn_rec_query(a.depid, 'dep') depName,fn_rec_query(a.dirid, 'dir') dirName from lf.sys_style a;
-
-select * from lf.sys_auth order by id;
+------------------------------------------------------------
+select * from lf.sys_auth;
+select * from lf.sys_menu;
select * from lf.sys_menu_auth;
-select * from lf.sys_args;
-
-
+select * from lf.sys_auth a left join lf.sys_menu;
+select a.* from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b where b.authid=a.id and b.menuid=1);
+-----------------------------------------------------------------------------------------------------
diff --git a/data/db_tab.sql b/data/db_tab.sql
index df50f48..8a25773 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -434,7 +434,7 @@
comment on column lf.sys_role.update_user is '鏇存柊浜篒D';
comment on column lf.sys_role.update_time is '鏇存柊鏃堕棿';
comment on column lf.sys_role.bak is '澶囨敞';
---insert into lf.sys_role (depid,name,descr) values (1,'Admin','绯荤粺绠＄悊鍛�');
+--insert into lf.sys_role (id,depid,name,descr) values (1,1,'Admin','绯荤粺绠＄悊鍛�');
select * from lf.sys_role;
select a.*,b.name depname from lf.sys_role a inner join lf.sys_dep b on a.depid = b.id order by a.id limit 10 offset 0;
diff --git "a/data/menu-\346\211\247\350\241\214.xls" "b/data/menu-\346\211\247\350\241\214.xls"
index 4ae1e70..27b8f73 100644
--- "a/data/menu-\346\211\247\350\241\214.xls"
+++ "b/data/menu-\346\211\247\350\241\214.xls"
Binary files differ
diff --git a/src/main/java/com/lf/server/controller/sys/AuthController.java b/src/main/java/com/lf/server/controller/sys/AuthController.java
index f55bb2a..425ebeb 100644
--- a/src/main/java/com/lf/server/controller/sys/AuthController.java
+++ b/src/main/java/com/lf/server/controller/sys/AuthController.java
@@ -96,6 +96,33 @@
}
@SysLog()
+ @ApiOperation(value = "鏍规嵁鑿滃崟鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "menuid", value = "鑿滃崟ID", dataType = "Integer", paramType = "query", example = "1"),
+ @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
+ @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
+ })
+ @GetMapping(value = "/selectByPageForMenu")
+ public ResponseMsg<List<AuthEntity>> selectByPageForMenu(Integer menuid, Integer pageSize, Integer pageIndex) {
+ try {
+ if (pageSize < 1 || pageIndex < 1) {
+ return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
+ }
+
+ int count = authService.selectCountForMenu(menuid);
+ if (count == 0) {
+ return success(0, null);
+ }
+
+ List<AuthEntity> rs = authService.selectByPageForMenu(menuid, pageSize, pageSize * (pageIndex - 1));
+
+ return success(count, rs);
+ } catch (Exception ex) {
+ return fail(ex.getMessage(), null);
+ }
+ }
+
+ @SysLog()
@ApiOperation(value = "鎻掑叆涓�鏉�")
@ApiImplicitParams({
@ApiImplicitParam(name = "entity", value = "瀹炰綋绫�", dataType = "com.lf.server.entity.sys.AuthEntity", paramType = "body", example = "")
diff --git a/src/main/java/com/lf/server/controller/sys/UserController.java b/src/main/java/com/lf/server/controller/sys/UserController.java
index 0580389..d7ea9e7 100644
--- a/src/main/java/com/lf/server/controller/sys/UserController.java
+++ b/src/main/java/com/lf/server/controller/sys/UserController.java
@@ -98,7 +98,7 @@
}
@SysLog()
- @ApiOperation(value = "鏍规嵁瑙掕壊+鍗曚綅鍒嗛〉鏌ヨ")
+ @ApiOperation(value = "鏍规嵁瑙掕壊+鍗曚綅鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
@ApiImplicitParams({
@ApiImplicitParam(name = "uname", value = "鐢ㄦ埛鍚�", dataType = "String", paramType = "query", example = "瀹�"),
@ApiImplicitParam(name = "roleid", value = "瑙掕壊ID", dataType = "Integer", paramType = "query", example = "1"),
diff --git a/src/main/java/com/lf/server/mapper/sys/AuthMapper.java b/src/main/java/com/lf/server/mapper/sys/AuthMapper.java
index 31ea4f5..8720f46 100644
--- a/src/main/java/com/lf/server/mapper/sys/AuthMapper.java
+++ b/src/main/java/com/lf/server/mapper/sys/AuthMapper.java
@@ -25,12 +25,30 @@
/**
* 鍒嗛〉鏌ヨ
*
- * @param name 鍚嶇О
+ * @param name 鍚嶇О
* @param limit 璁板綍琛�
* @param offset 鍋忕Щ閲�
* @return 鍒楄〃
*/
public List<AuthEntity> selectByPage(String name, Integer limit, Integer offset);
+
+ /**
+ * 鏍规嵁鑿滃崟鏌ヨ璁板綍鏁�
+ *
+ * @param menuid
+ * @return
+ */
+ public Integer selectCountForMenu(Integer menuid);
+
+ /**
+ * 鏍规嵁鑿滃崟鍒嗛〉鏌ヨ
+ *
+ * @param menuid
+ * @param limit
+ * @param offset
+ * @return
+ */
+ public List<AuthEntity> selectByPageForMenu(Integer menuid, Integer limit, Integer offset);
/**
* 鎻掑叆涓�鏉�
@@ -86,5 +104,4 @@
* @return
*/
public List<AuthEntity> selectAuthAll();
-
}
diff --git a/src/main/java/com/lf/server/service/sys/AuthService.java b/src/main/java/com/lf/server/service/sys/AuthService.java
index 67c83d2..d78c227 100644
--- a/src/main/java/com/lf/server/service/sys/AuthService.java
+++ b/src/main/java/com/lf/server/service/sys/AuthService.java
@@ -17,7 +17,6 @@
@Autowired
AuthMapper authMapper;
-
@Override
public Integer selectCount(String name) {
return authMapper.selectCount(name);
@@ -29,6 +28,16 @@
}
@Override
+ public Integer selectCountForMenu(Integer menuid) {
+ return authMapper.selectCountForMenu(menuid);
+ }
+
+ @Override
+ public List<AuthEntity> selectByPageForMenu(Integer menuid, Integer limit, Integer offset) {
+ return authMapper.selectByPageForMenu(menuid, limit, offset);
+ }
+
+ @Override
public Integer insertAuth(AuthEntity authEntity) {
return authMapper.insertAuth(authEntity);
}
diff --git a/src/main/resources/mapper/sys/AuthMapper.xml b/src/main/resources/mapper/sys/AuthMapper.xml
index 3ec62ba..be313ae 100644
--- a/src/main/resources/mapper/sys/AuthMapper.xml
+++ b/src/main/resources/mapper/sys/AuthMapper.xml
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.AuthMapper">
-
- <!-- 缁熻琛屾暟 -->
<select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
select count(*) from lf.sys_auth
<where>
@@ -12,7 +10,6 @@
</where>
</select>
- <!-- 鍒嗛〉鏌ヨ -->
<select id="selectByPage" resultType="com.lf.server.entity.sys.AuthEntity">
select * from lf.sys_auth
<where>
@@ -24,6 +21,29 @@
limit #{limit} offset #{offset}
</select>
+ <select id="selectCountForMenu" resultType="java.lang.Integer" parameterType="java.lang.String">
+ select count(a.*) from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b
+ <where>
+ b.authid = a.id
+ <if test="menuid != null">
+ and b.menuid = #{menuid}
+ </if>
+ </where>
+ )
+ </select>
+
+ <select id="selectByPageForMenu" resultType="com.lf.server.entity.sys.AuthEntity">
+ select a.* from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b
+ <where>
+ b.authid = a.id
+ <if test="menuid != null">
+ and b.menuid = #{menuid}
+ </if>
+ </where>
+ )
+ order by a.id
+ limit #{limit} offset #{offset}
+ </select>
<select id="selectAuthAll" resultType="com.lf.server.entity.sys.AuthEntity">
select * from lf.sys_auth order by id
diff --git a/src/main/resources/mapper/sys/UserMapper.xml b/src/main/resources/mapper/sys/UserMapper.xml
index 1f8db0d..d9b09a6 100644
--- a/src/main/resources/mapper/sys/UserMapper.xml
+++ b/src/main/resources/mapper/sys/UserMapper.xml
@@ -31,9 +31,9 @@
</select>
<select id="selectCountForRole" resultType="java.lang.Integer" parameterType="java.lang.String">
- select count(*) from lf.sys_user a
+ select count(a.*) from lf.sys_user a
<where>
- not exists (select id from lf.sys_role_user b where b.userid = a.id
+ not exists (select b.id from lf.sys_role_user b where b.userid = a.id
<if test="roleid != null">
and b.roleid = #{roleid}
</if>
@@ -50,7 +50,7 @@
<select id="selectByPageForRole" resultMap="resultMap" resultType="com.lf.server.entity.sys.UserEntity">
select a.*,fn_rec_query(a.depid, 'dep') depName from lf.sys_user a
<where>
- not exists (select id from lf.sys_role_user b where b.userid = a.id
+ not exists (select b.id from lf.sys_role_user b where b.userid = a.id
<if test="roleid != null">
and b.roleid = #{roleid}
</if>
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index 28a1366..9140dc1 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -12,11 +12,12 @@
11.璧勬簮瀹炴椂鐩戞帶锛圕PU淇℃伅+鍐呭瓨淇℃伅+鍦ㄧ嚎鐢ㄦ埛+璧勬簮鐘舵�侊級
12.涓嬭浇鏂囦欢骞惰缃甅IME绫诲瀷
13.涓婁紶鏂囦欢锛坈ommons-fileupload锛� *
-
-1.鍓嶇闆嗘垚鐧诲綍鎺ュ彛
-2.鑿滃崟鎺ュ彛娣诲姞鐢ㄦ埛鏉冮檺
-3.寮�鍙戣彍鍗曟潈闄愩�佺敤鎴锋潈闄愩�佽祫婧愭潈闄愭帴鍙�
----------------------------------------------------------------------------------------------------
+java 璋冪敤gdal璇诲彇gdb鏁版嵁锛宭inux涓媕ava璋冪敤gdal锛�
+https://blog.csdn.net/weixin_53853459/article/details/120954597
+https://blog.csdn.net/qq_43444401/article/details/125649414
+https://blog.csdn.net/qq_43961619/article/details/124627871
+
http://127.0.0.1:12316/dict/selectCount?tab=sys_user
http://127.0.0.1:12316/Dict/selectByPage?tab=sys_user&pageSize=10&pageIndex=0
--
Gitblit v1.9.3