CODEWITHSUNDEEP
phplaraveleloquent
Peril
Peril

Reputation: 1599

Laravel - get last row using whereHas

I am trying to get the time "created_at" for the last user activity, I have the model User, and UserActivity.
I want to get the last user activity and check if the last activity of this user is 3 days to send notification,

User.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
class User extends Model
{
    public function activites()
    {
        return $this->hasMany(Activty::class);
    }

}

Activity.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Carbon\Carbon;

class Activity extends Model
{
    function function user(){
        return $this->belongsTo(User::class);
    }
}

Controller

$latest_activites = User::whereHas("activites",function($query){
            $query->where("created_at",">=",Carbon::now()->subDays(3));
        });
$latest_activites = $latest_activites->get();

Upvotes: 2

Views: 6940

Answers (3)

Alexey Mezenin
Alexey Mezenin

Reputation: 163758

First, create another relationship in User model, which has to be hasOne to get the latest activity:

public function latestActivity()
{
    return $this->hasOne(Activity::class)->latest();
}

Then load just users who have latest activities older than 3 days 

$users = User::whereHas('activites', function($q) {
        $q->where('created_at', '<=', now()->subDays(3));
    })
    ->whereDoesntHave('activites', function($q) {
        $q->where('created_at', '>', now()->subDays(3));
    })
    ->with('latestActivity')
    ->get();

Upvotes: 3

parastoo
parastoo

Reputation: 2469

main structure: model::latest()->get() 

  $latest_activites = User::with('activites')
                    ->where("activites",function($query){
                     .
                     .
                     .
                     .
            })->latest()->get();

Upvotes: 1

Leo
Leo

Reputation: 7420

You should eagerload user activities at the same time then with subquery filter based on created_at. Call the latest to get last record and you should be good to go.

$latest_activites = User::with('activites')
                         ->where("activites",function($query){

             $query->where("created_at",">=",Carbon::now()->subDays(3));

        })->latest()->get();

Upvotes: 4

Related Questions