rackbeat/laravel-morph-where-has

Fix whereHas for morphTo relations.

Use whereHas for morphed relationships in Laravel

Usually, you cant say whereHas('contact') if contact is a morphTo relationship. This package aims to fix that., _(*1)

, _(*2)

Installation

You just require using composer and you're good to go!, _(*3)

composer require rackbeat/laravel-morph-where-has

The Service Provider is automatically registered., _(*4)

Usage

1. Add possible variations in your model

The problem, is that the morph relationship can have a hard time determining how to handle the whereHas call., _(*5)

Our solution, is that you define every possible morphed class. Like so:, _(*6)

<?php

class Invoice extends Model {
    // Old morph relation
    public function owner() {
        return $this->morphTo('owner'); 
    }

    // New solution
    public function customer() {
        return $this->morphTo('owner')->forClass(App\Customer::class);
    }

    public function supplier() {
        return $this->morphTo('owner')->forClass(App\Supplier::class);
    }
}

2. Use whereHas

php Invoice::whereHas('supplier', function($query) { $query->whereName('John Doe'); })->get();, _(*7)

This will correctly query a relation with the type and any queries you've added., _(*8)

Requirements

• PHP >= 7.1

Inspiration

Solution based upon work by github@thisdotvoid - modified to fix some common issues., _(*9)