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);
}