如何与Eloquent Laravel的三张桌子进行咨询

Question

I have three tables that are the following users, mapas, marcadores

A user has several mapas

a mapa has several marcadores

What I'm trying to do is show the marcadores that belong to the mapas of the user who has logged in.

this are the tables and relationship

This is the function in the controller that I am working on:

public function index()
{
    $mapas = Mapa::orderBy('id', 'DESC')->where('user_id', auth()->user()->id);
    $marcadores = Marcador::orderBy('id', 'DESC')->where('mapa_id');
    return view('user.marcadores.index', compact('marcadores'));
}

thanks for your help

Answer 1

You are trying to get all the mapas id first and then filter marcadores according to those id's. Try using the code below for that:

public function index()
{
    $mapas = Mapa::orderBy('id', 'DESC')->where('user_id', auth()->user()->id)->pluck('id')->toArray();
    $marcadores = Marcador::orderBy('id', 'DESC')->whereIn('mapa_id', $mapas)->get();
    return view('user.marcadores.index', compact('marcadores'));
}