Laravel - 使用 whereHas 获取最后一行

时间:2023-03-03
本文介绍了Laravel - 使用 whereHas 获取最后一行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我正在尝试获取最后一次用户活动的时间created_at",我有模型 UserUserActivity.
我想获取最后一个用户活动并检查该用户的最后一个活动是否是 3 天才能发送通知,

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 IlluminateDatabaseEloquentModel;
class User extends Model
{
    public function activites()
    {
        return $this->hasMany(Activty::class);
    }

}

Activity.php

<?php

namespace App;

use IlluminateDatabaseEloquentModel;
use CarbonCarbon;

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

控制器

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

推荐答案

首先,在 User 模型中创建另一个关系,即 必须是 hasOne 以获取最新活动:

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();
}

然后只加载最近活动超过 3 天的用户

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();

这篇关于Laravel - 使用 whereHas 获取最后一行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:Laravel - 根据动态参数扩展 Eloquent where 子句 下一篇:Laravel 在数据透视表中雄辩的 UUID

相关文章