Home / Questions / 350519
Accepted
Luis
Asked: 2020-04-29 17:35:26 +0800 CST 2020-04-29 17:35:26 +0800 CST

Query between 3 tables

  • 772

I have 3 boards

  • Users table fields: id,

  • processes table fields: id, user_id ("user_id" is related to the users table)

  • Histories table fields: id, processes_id ("processes_id" is related to the processes table)

users has many processes(processes)

processes has many histories

histories has a single processes(process)

what I want to do is:

Fetch the data historythat is related to processes-user_idthe logged in user

I bring the processes in the following way in the controller:

$processes = Auth::user()->processes;
return view('processes.index', compact('processes'));

But with stories I couldn't

Here the dd of the answer

enter image description here

This is what appears to me when I put $data

enter image description here

laravel

1 Answers

  1. Best Answer

    First you need to have the models of your 3 entities respectively:

    • user
    • Process
    • History

    Models

    class User extends Model 
{
    public function processes()
    {
        return $this->hasMany(Process::class);
    }
}

class Process extends Model 
{
    public function user()
    {
        return $this->belongsTo(User::class);
    }

    public function histories()
    {
        return $this->hasMany(History::class);
    }
}

class History extends Model 
{
    public function process()
    {
        return $this->belongsTo(Process::class);
    }
}

    Now:

    • We get the id of the logged in user
    • We load from the History model its relation process and since process is the method that gives us access to this table then we can establish a whereto search for equality user_idwith the variable that stores the id of the current session

    Proposal

    $user = auth()->user()->id;

$data = History::with(['process' => function($query) use($user){
    $query->where('user_id', $user);
}])->get();

    We use useto pass the variable $userto the context of the function that will use it

    • 1