Downloads
Stars
Version
Provide an ability to add related fields/columns to all model Eloquent queries without additional database queries. It uses sub SELECT and joins so take into account extra database load when database has a lot of records.
To get the latest version of Laravel Model Related Fields
, simply require the project using Composer:
$ composer require dedmytro/laravel-model-related-fields
Or manually update require
block of composer.json
and run composer update
.
{
"require": {
"dedmytro/laravel-model-related-fields": "^0.1"
}
}
Add HasRelatedFields
trait to your model and define method addRelatedFields()
which returns array related fields you want to load on each Model query.
On example below you can see how to load related field through many relations and load SUM() of HasMany relation.
use Illuminate\Database\Eloquent\Model;
use DeDmytro\LaravelModelRelatedFields\RelatedField;
use DeDmytro\LaravelModelRelatedFields\Traits\HasRelatedFields;
// ...
class Order extends Model
{
use HasRelatedFields;
// ...
protected function addRelatedFields(): array
{
return [
'country_currency' => 'event.company.country.currency',
'total' => new RelatedField('items.total', function ($query) {
$query->selectRaw('SUM(price)');
}),
];
}
where
'event.company.country.currency'
is the same as $order->event->company->country->currency
'items.total'
is the same as $order->items()->sum('price')
As an alternative you can use $relatedFields
property for simple fields, without RelatedField
class usage. Property
and method result array will be be merged.
use Illuminate\Database\Eloquent\Model;
use DeDmytro\LaravelModelRelatedFields\RelatedField;
use DeDmytro\LaravelModelRelatedFields\Traits\HasRelatedFields;
// ...
class Order extends Model
{
use HasRelatedFields;
// ...
protected $relatedFields = [
'country_currency' => 'event.company.country.currency',
];
protected function addRelatedFields(): array
{
return [
'total' => new RelatedField('items.total', function ($query) {
$query->selectRaw('SUM(price)');
}),
];
}
The result of query:
$order = Order::first();
you will get Order model with all fields plus additional related fields:
[
"id" => 1,
// ...
"country_currency" => "USD",
"total" => 25.00,
]
To disable related fields for all models by default,
'enabled' => false
ENABLE_MODEL_RELATED_FIELDS=false
Add protected $enableRelatedFields = false
protected $enableRelatedFields = false;
$order = Order::withoutRelatedFields()->first();
$order = Order::withRelatedFields()->first();