package com.xly.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;

@Mapper
public interface UserSceneSessionMapper {

    /**
     * 查询用户权限Key列表
     * @param sUserId 用户ID
     * @return 权限Key列表
     */
    @Select("SELECT J.sKey AS sKey FROM sysjurisdiction AS J JOIN sisjurisdictionclassify AS B ON J.sJurisdictionClassifyId = B.sId WHERE B.sId IN(SELECT U.sJurisdictionClassifyId  FROM sftlogininfojurisdictiongroup AS U WHERE U.sParentId = #{sUserId}) ")
    List<Map<String, Object>> findUserPermissions(@Param("sUserId") String sUserId);

}