I have been this SQL working fine, but trying to convert it to Eloquent format, it keeps returning a wrong, SQL entirely which flags error. Coding with Laravel 5.5
Select arm_articles.article_topic, arm_articles.id, arm_articles.article_id, COUNT(arm_article_views.view_article_id) AS TotalViews, COUNT( arm_article_likes.liked_article_id) AS TotalLikes, COUNT( arm_article_comments.comment_article_id) AS TotalComments FROM arm_articles LEFT JOIN arm_article_views ON arm_articles.article_id = arm_article_views.view_article_id LEFT JOIN arm_article_likes ON arm_articles.article_id = arm_article_likes.liked_article_id LEFT JOIN arm_article_comments ON arm_articles.article_id = arm_article_comments.comment_article_id GROUP BY arm_articles.article_id ORDER BY TotalLikes, TotalLikes, TotalComments ASC
**HOW I WROTE MY ELOQUENT ** Not working though
return Datatables::of(PostModel:: leftJoin('arm_article_views','arm_article_views.view_article_id','=','arm_articles.article_id')
->leftJoin('arm_article_likes','arm_article_likes.liked_article_id','=','arm_articles.article_id')->leftJoin('arm_article_comments','arm_article_comments.comment_article_id','=','arm_articles.article_id')->selectRaw('arm_articles.*, count(arm_article_views.view_article_id) AS ViewCount, ->groupBy('arm_articles.article_id')->orderBy('ViewCount','DESC') ->where('arm_articles.article_contributor_id','=',$contributor_id)->getQuery())->make(true);
Any hint would be appreciated
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire