package org.jeecg.modules.system.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
import org.jeecg.modules.system.entity.SysPermission;
|
import org.jeecg.modules.system.model.TreeModel;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
|
/**
|
* <p>
|
* 菜单权限表 Mapper 接口
|
* </p>
|
*
|
* @Author scott
|
* @since 2018-12-21
|
*/
|
public interface SysPermissionMapper extends BaseMapper<SysPermission> {
|
/**
|
* 通过父菜单ID查询子菜单
|
* @param parentId
|
* @return
|
*/
|
public List<TreeModel> queryListByParentId(@Param("parentId") String parentId);
|
|
/**
|
* 根据用户查询用户权限
|
* @param username 用户账户名称
|
* @return List<SysPermission>
|
*/
|
public List<SysPermission> queryByUser(@Param("username") String username);
|
|
/**
|
* 修改菜单状态字段： 是否子节点
|
* @param id 菜单id
|
* @param leaf 叶子节点
|
* @return int
|
*/
|
@Update("update sys_permission set is_leaf=#{leaf} where id = #{id}")
|
public int setMenuLeaf(@Param("id") String id,@Param("leaf") int leaf);
|
|
/**
|
* 切换vue3菜单
|
*/
|
@Update("alter table sys_permission rename to sys_permission_v2")
|
public void backupVue2Menu();
|
@Update("alter table sys_permission_v3 rename to sys_permission")
|
public void changeVue3Menu();
|
|
/**
|
* 获取模糊匹配规则的数据权限URL
|
* @return List<String>
|
*/
|
@Select("SELECT url FROM sys_permission WHERE del_flag = 0 and menu_type = 2 and url like '%*%'")
|
public List<String> queryPermissionUrlWithStar();
|
|
|
/**
|
* 根据用户账号查询菜单权限
|
* @param sysPermission
|
* @param username
|
* @return
|
*/
|
public int queryCountByUsername(@Param("username") String username, @Param("permission") SysPermission sysPermission);
|
|
|
/**
|
* 查询部门权限数据
|
* @param departId
|
* @return
|
*/
|
List<SysPermission> queryDepartPermissionList(@Param("departId") String departId);
|
/**
|
* 秘密查
|
* @param sql
|
* @return
|
*/
|
List<Map<String,Object>>secretOfSelect(@Param("sql") String sql);
|
/**
|
* 秘密增
|
* @param sql
|
* @return
|
*/
|
boolean secretOfInsert(@Param("sql")String sql);
|
/**
|
* 秘密改
|
* @param sql
|
* @return
|
*/
|
boolean secretOfUpdate(@Param("sql")String sql);
|
/**
|
* 秘密删
|
* @param sql
|
* @return
|
*/
|
boolean secretOfDelete(@Param("sql")String sql);
|
}
|
