Laravel 5 Eloquent 连接基于字段最大值

Question

我正在尝试从用户表中获取行并将其与文章表连接，其中articles.user_id = users.id且articles.view最大。

public function scopeMostViewedArticle($query)
{
    $query->leftjoin('articles as a', function ($join) {

            $join->on('a.user_id','=','users.id')
                  ->where('a.publish_date', '<',date('Y-m-d H:m'))
                  ->where('a.view','=',?);


            })
        ->groupby('users.id')
        ->orderby('users.id')
        ->select('users.*','a.title as article_title','a.image as article_image');  


}

我对 '->where('a.view','=',?);' 有问题部分。我感谢您的帮助! :)

Answer 1

public function scopeMostViewedArticle($query)
{
    $query->leftjoin('articles as a', function ($join) {

            $join->on('a.user_id','=','users.id')
                  ->where('a.publish_date', '<',date('Y-m-d H:m'))
                  ->max('a.view');   
            })
        ->groupby('users.id')
        ->orderby('users.id')
        ->select('users.*','a.title as article_title','a.image as article_image');  

}

您可以在以下位置找到更多信息 http://laravel.com/docs/5.1/queries