package cn.lili.modules.member.mapper;
|
|
import cn.lili.modules.member.entity.dos.StoreMenu;
|
import cn.lili.modules.member.entity.vo.StoreUserMenuVO;
|
import cn.lili.modules.permission.entity.dos.Menu;
|
import cn.lili.modules.permission.entity.vo.UserMenuVO;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 菜单数据处理层
|
*
|
* @author Chopper
|
* @since 2020-11-22 09:17
|
*/
|
public interface StoreMenuMapper extends BaseMapper<StoreMenu> {
|
|
/**
|
* 根据用户获取菜单列表
|
*
|
* @param userId 用户ID
|
* @return 菜单列表
|
*/
|
@Select("SELECT menu.* FROM li_store_menu AS menu WHERE menu.id IN (" +
|
"SELECT rm.menu_id FROM li_store_menu_role AS rm WHERE rm.role_id IN (" +
|
"SELECT ur.role_id FROM li_clerk_role AS ur WHERE ur.clerk_id=#{userId}) OR rm.role_id IN (" +
|
"SELECT dr.role_id FROM li_store_department_role AS dr WHERE dr.department_id=(" +
|
"SELECT department_id FROM li_clerk AS au WHERE au.id = #{userId})))")
|
List<StoreMenu> findByUserId(String userId);
|
|
/**
|
* 根据用户获取菜单权限
|
*
|
* @param userId 用户ID
|
* @return 用户菜单VO列表
|
*/
|
@Select("SELECT rm.is_super as is_super,m.*FROM li_store_menu AS m INNER JOIN li_store_menu_role AS rm ON rm.menu_id=m.id WHERE rm.role_id IN (" +
|
"SELECT ur.role_id FROM li_clerk_role AS ur WHERE ur.clerk_id=#{userId}) OR rm.role_id IN (" +
|
"SELECT dr.role_id FROM li_store_department_role AS dr INNER JOIN li_clerk AS au ON au.department_id=dr.department_id " +
|
"WHERE au.id=#{userId}) GROUP BY m.id,rm.is_super ORDER BY rm.is_super desc")
|
List<StoreUserMenuVO> getUserRoleMenu(String userId);
|
}
|
