lundi 6 août 2018

How to get latest eloquent relationship by column name in Laravel

I am building a small application on Laravel 5.6 where I am having two models Project and Status. In this I am having a relation as such:

In Project Model I am having:

public function statusUpdate()
{
    return $this->hasMany('App\Status','project_id','id');

}

and to retrieve latest status I have:

public function latestStatus()
{
    return $this->hasOne('App\Status','project_id','id')->latest();
}

In status I have columns: date, status, sub_status, comments.

I want to retrieve Status where I am having latest status by date mentioned in the column

I tried doing this in my model:

public function latestStatus()
{
    return $this->hasOne('App\Status','project_id','id')->latest('date');
}

But this thing is not working out, help me out in this. Thanks



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire