RoleService.php

<?php


namespace App\Http\Services;

//后台用户相关信息服务
use Illuminate\Support\Facades\DB;

class RoleService
{

    //根据user_id获取角色
    public function getRolesByUserId($userId)
    {
        $bid = config('website.PermId');
        $roleIds = DB::connection()->table('t_user_perm')->where('userId', $userId)->where('bid',$bid)->value('roles');
        $roleIds = json_decode($roleIds, true);
        return DB::connection()->table('t_role_perm')->where('bid',$bid)->whereIn('roleId', $roleIds)->pluck('name');
    }
}