Laravel Eloquent only get parent if latest child created_at < than 5 years from now

Question

I have a customer model with many transactions, and I need to get customers only where the customer's latest transaction is < 5 years from now. So the result was a customer who had any transaction that matched the condition. Even the transaction that matched the condition is not the latest one.

public function lastTransaction()
{
    return $this->hasOne(Transaction::class, 'user_id', 'id')->latest();
}

$customers = Customer::whereHas('lastTransaction', function ($q) {
    $q->whereDate('created_at', '<', Carbon::now()->subYears(5));
})->get();

"_< 5 years from now_" Just to be clear, that's in the future, right? — brombeer, Dec 08 '21 at 11:48
i mean, customer last transaction should be 2015, 2014, 2013... — wahyudwikrisnanto, Dec 08 '21 at 12:15

score 0 · Answer 1 · answered Dec 08 '21 at 13:18

i resolved the problem by combining whereHas and whereDoesntHave like below:

Customer::whereHas('transactions', function ($q) {
        $q->whereDate('created_at', '<=', Carbon::now()->subYears(5));
    })->whereDoesntHave('transactions', function ($q) {
        $q->whereDate('created_at', '>', Carbon::now()->subYears(5));
    })->with('lastTransaction')->get();

Laravel Eloquent only get parent if latest child created_at < than 5 years from now

1 Answers1