1

13693261870

2022-10-08 ea8bcfaf7748301fb508f9939d943939813196da

1

 src/main/java/com/lf/server/controller/sys/MenusController.java

@@ -5,6 +5,7 @@
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.data.DirEntity;
import com.lf.server.entity.sys.MenusEntity;
import com.lf.server.helper.StringHelper;
import com.lf.server.service.sys.MenusService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
@@ -161,10 +162,17 @@

    @SysLog()
    @ApiOperation(value = "递归查询数据")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "菜单名称", dataType = "String", paramType = "query", required = false, example = "管道基础大数据平台")
    })
    @GetMapping(value = "/selectMenuRecursive")
    public ResponseMsg<List<DirEntity>>  selectMenuRecursive() {
    public ResponseMsg<List<DirEntity>> selectMenuRecursive(String name) {
        try {
            List<DirEntity> list = menuService.selectMenuRecursive();
            if (StringHelper.isEmpty(name)) {
                name = "管道基础大数据平台";
            }
            List<DirEntity> list = menuService.selectMenuRecursive(name);

            return success(list);
        } catch (Exception ex) {
            return fail(ex.getMessage(), null);

 src/main/java/com/lf/server/interceptor/AuthInterceptor.java

@@ -46,9 +46,10 @@
     */
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) {
        //noinspection AlibabaRemoveCommentedCode
        try {
//            System.out.println(request.getRequestURI().toLowerCase() + "," + (handler instanceof HandlerMethod));
//
            System.out.println(request.getRequestURI().toLowerCase() + "," + (handler instanceof HandlerMethod));

//            // 非方法，无需拦截
//            if (!(handler instanceof HandlerMethod)) {
//                return true;

 src/main/java/com/lf/server/mapper/sys/MenusMapper.java

@@ -73,5 +73,5 @@
     * 递归查询
     * @return
     */
    public List<DirEntity> selectMenuRecursive();
    public List<DirEntity> selectMenuRecursive(String name);
}

 src/main/java/com/lf/server/service/sys/MenusService.java

@@ -59,7 +59,7 @@
    }

    @Override
    public List<DirEntity> selectMenuRecursive() {
        return menusMapper.selectMenuRecursive();
    public List<DirEntity> selectMenuRecursive(String name) {
        return menusMapper.selectMenuRecursive(name);
    }
}

 src/main/resources/mapper/sys/MenusMapper.xml

@@ -18,7 +18,7 @@

    <select id="selectMenuRecursive" resultMap="resultMap" resultType="com.lf.server.entity.sys.MenusEntity">
        with recursive rs as(
            select * from lf.sys_menu where cn_name='管道基础大数据平台'
            select * from lf.sys_menu where cn_name=#{name}
        union
            select a.* from lf.sys_menu a, rs b where a.pid=b.id
        )
@@ -65,7 +65,7 @@
    </update>

    <update id="updateMenus">
        <foreach collection="list" item="item" index="index" separator=","  >
        <foreach collection="list" item="item" index="index" open="" close="" separator=";">
            update lf.sys_menu
            <set>
                pid=#{item.pid},cn_name=#{item.cnName},en_name=#{item.enName},url=#{item.url},perms=#{item.perms},type=#{item.type},
@@ -75,7 +75,4 @@
            where id = #{item.id}
        </foreach>
    </update>



</mapper>