nullthoughts/laravel-latest-relation

Eloquent macros for querying latest HasMany relationship in Laravel

v1.0.0 2020-02-05 16:13 UTC

Requires (Dev)

• orchestra/testbench: ^4.0

MIT

• Jani Gyllenberg

README

Laravel Latest Relation

Eloquent macros for querying the latest HasMany relationship in Laravel.

More information on the problem and solutions: Dynamic scope on latest record in Laravel's HasMany relationships, Part 1: solving with Subqueries - nullthoughts.com

Installation

Install via composer: composer require nullthoughts/laravel-latest-relation

Usage / Examples

Use the Builder methods inside a whereHas closure:

Latest:

whereLatestRelation($relation, $column, $operator = null, $value = null)

Query

$users = User::whereLatestRelation('logins', 'device_type', '=', 'desktop');

Dynamic Scope

public function scopeUsingDevice($query, $device)
{
    return $query->whereLatestRelation('logins', 'device_type', $device);
}

public function scopeHavingCountry($query)
{
    return $query->whereLatestRelation('logins', 'country', '!=', 'null');
}

whereLatest($column, $value)

Query

$users = User::whereHas('logins', function ($query) {
    $query->whereLatest('device_type', 'desktop');
});

Dynamic Scope

public function scopeUsingDevice($query, $device)
{
    return $query->whereHas('logins', function ($query) use ($device) {
        $query->whereLatest('device_type', $device);
    });
}

latestRelation()

Query

$users = User::whereHas('logins', function ($query) {
    $query->latestRelation()->whereBetween(
        'created_at', [
            Carbon::now()->startOfDay(),
            Carbon::now()->endOfDay()
        ]);
});

Dynamic Scope

public function scopeHavingDeviceType($query)
{
    return $query->whereHas('logins', function ($query) {
        $query->latestRelation()->whereNotNull('device_type');
    });
}

Earliest:

$users = User::whereLatestRelation('logins', 'device_type', 'desktop');

$users = User::whereHas('logins', function ($query) {
    $query->whereEarliest('device_type', 'desktop');
});

$users = User::whereHas('logins', function ($query) {
    $query->earliestRelation()->whereNotNull('device_type');
});