Room Model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Room extends Model
{
/**
* Get the comments for the room.
*/
public function comments()
{
return $this->hasMany('App\Comment');
}
}
Comment Model
namespace App;
use Illuminate\Database\Eloquent\Model;
class Comment extends Model
{
/**
* Get the room that owns the comment.
*/
public function room()
{
return $this->belongsTo('App\Room');
}
public function upvotes() {
return $this->hasMany('App\Upvote');
}
}
Upvote Model
namespace App;
use Illuminate\Database\Eloquent\Model;
class Upvote extends Model
{
/**
* Get the comment that the upvote belongs to.
*/
public function comment() {
return $this->belongsTo('App\Comment');
}
}
How would I be able to have a list of comments for the room that is sorted by the count of upvotes each comment has?
I have searched online and have only managed to find answers relating to having the model sorted by its directed relation e.g $room->comments()
rather than being sorted by $room->comments()->upvotes()
?
Thanks
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire