Question 16510 in Laravel Question posted in
The official Laravel Documentation can be found here.

How to compare 2 pivot table in Laravel?

I’m training with many to many relationships and today i’m trying to compare 2 pivot tables.

I’m trying a site for a nutritionist.
On one hand the nutritionist/admin can create patient’s card (my table "User". In this cards he informs the regime’s type of this patient. It’s a many to many relationship so i made a "regime_user" table pivot.

Schema::create('regime_user', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
        $table->foreignId('regime_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
        $table->timestamps();
    });

On the other hand he can create receipts (my table is "Recette") and informs regime’s type. Again i use a pivot table "recette_regime".

Schema::create('recette_regime', function (Blueprint $table) {
        $table->id();
        $table->timestamps();
        $table->foreignId('recette_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
        $table->foreignId('regime_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
    });

Of course in my Models i’ve added the relation:
For the User Model :

public function regimes()
{
    return $this->belongsToMany(Regime::class);
}

For the Regime Model :

 public function users()
{
    return $this->belongsToMany(User::class);
}

What i want to do now in the receipts’s index is to display for the auth()->user() only the receipts who has the same regime’s types. So i need to compare the 2 pivots table :

  • which regime’s types has the auth()->user()
  • find the receipts which have the same regime’s types

I’ve read the doc and find nothing i could use. Can you help me please?

Tags:

2

Answers


  1. 0

    I’m not sure what kind of data you have inside of "Regime & Recette" but I will assume in this example that the column name exists, to show the concept of how you can present the data.

    User Model:

    public function regimes()
{
    return $this->belongsToMany(Regime::class);
}

    Regime Model:

    public function users()
{
    return $this->belongsToMany(User::class);
}

public function recettes()
{
    return $this->belongsToMany(Recette::class);
}

    Recette Model:

    public function regimes()
{
    return $this->belongsToMany(Regime::class);
}

    In UserController show function:

    /**
 * Show the specified model.
 *
 * @param  IlluminateHttpRequest  $request
 * @param  User $user
 * @return IlluminateHttpResponse
 */
public function show(User $user){
    // This will lazy load all of the inner relationships:
    $user->load('regimes.recettes');
   
    // Return the view with the user
    return view('sampleView', compact('user')); 
}

    In sampleView Blade:

    <!-- You call the regime relationship and display it !-->
@foreach($user->regimes as $regime)
    <ul>
        <li>ID: {{$regime->id}} - Name: {{$regime->name}}
            <ul>
                <!-- You call the recette relationship and display it !-->
                @forelse($regime->recettes as $recette)
                    <li>ID: {{$recette->id}} - Name: {{$recette->name}}</li>
                @empty
                    <li>No Data</li>
                @endforelse
            </ul>
        </li>       
    </ul>
@endforeach
    Login or Signup to reply.
  2. 0

    You can get it by using whereHas()

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

$receipts = Recette::whereHas('regimes', function($query) use($user) {
    $query->whereIn('regime_id', $user->regimes->pluck('id'));
})->get();
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search