Relationship three tables?

Hello. I have problem with relationship three table.

We have the tables

users
- id
- username

companies
- id
- name

user_company
- user_id
- company_id

permissions
- id
- name

user_company_permission
- user_id
- company_id
- permission_id

The company has been set when user logged in.

Example:
Step 1: demo account logged in
Step 2: demo account chosen Company A
Step 3: Check permission of demo account in Company  A. [Problem]
...........

I need check permission of user in one company.

Please help me. Thank you so much

bobbybouwmann

9 years ago

Level 88

What have you tried? What relations do you have so far?

tuyenlaptrinh

9 years ago

Level 1

Hi Bobby

I just tried logged in.

function permission(){
    $route_name = \Illuminate\Support\Facades\Request::route()->getName();
    $user = \Illuminate\Support\Facades\Auth::user();
    if($user->user_type == 1){
        return true;
    }
    else {
        $route = \ProjectManagement\Permission::where('route',$route_name)->first();
        if($route){
            $permission = \ProjectManagement\UserPermission::where('user_id',$user->id)->where('permission_id',$route->id)->where('company_id',$user->company_id)->first();
            if($permission){
                return true;
            }
            else return false;
        }
        else return false;
    }
}

This is my function

Remember. company_id has not been in users table

bobbybouwmann

9 years ago

Level 88

Thats not what I asked? What are your relations?

It looks like you have no clue what you are doing. Why don't you watch this series first to get you started?

Laravel series: https://laracasts.com/series/laravel-5-from-scratch

Please or to participate in this conversation.