🔨 Improved Polymorphic Eloquent Builder
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.gitignore
LICENSE
README.md
composer.json

README.md

Improved Polymorphic Eloquent Builder

Packagist

Attempting to use whereHas queries with standard Eloquent polymorphic relationships will fail, due to Eloquent being unable to determine the correct model to retrieve. You may receive an error similar to the one below as Eloquent tries to build the query using columns from the model without including its table name.

QueryException in Connection.php line 662:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'column_name' in 'where clause'

The 'Improved Polymorphic Eloquent Builder' is a class which extends the Eloquent Builder class that is built in to Laravel 5.1. It enables limited use of the whereHas method to query Eloquent polymorphic relationships.

Requirements

You must be using Laravel 5.1 as your framework and Eloquent as your ORM.

Installation

Simply require this package, using Composer, in the root directory of your project.

composer require rapidwebltd/improved-polymorphic-eloquent-builder

Then change any Eloquent models using polymorphic relationships to extend the \RapidWeb\ImprovedPolymorphicEloquentBuilder\Model class. This will usually be any model(s) containing methods which return morphTo() relationship(s). An example class is shown below.

class Variation extends \RapidWeb\ImprovedPolymorphicEloquentBuilder\Model
{
  public function model()
  {
    return $this->morphTo();
  }
}

Usage

When performing a whereHas query, you must specify the morph types as the 5th argument. Morph types refers to an array of the polymorphic types you wish to filter by. These should be presented as strings equal to one or more of the possible values the [...]_type field of the polymorphic relationship in question.

The example below selects all variation records that have related model record of type bags, with a brand_id of 2.

Variation::whereHas('model', function($query) use ($brandId) {
  $query->where('brand_id', 2);
}, '>=', 1, ['bags'])->get();

A database structure for this example would be similar to the following. The polymorphic fields are highlighted in bold.

variations bags sunglasses
id id id
model_type ('bags', 'sunglasses', etc.) brand_id brand_id
model_id material_id lens_colour_id