示例#1
0
文件: PuAds.php 项目: josmel/buen
 public function getAdsType($idPost, $value = null)
 {
     $dataAds = PuAds::join('pu_types as t', 'pu_ads.pu_type_id', '=', 't.id')->leftJoin('pu_comments as comment', 'pu_ads.id', '=', 'comment.pu_ad_id')->leftJoin('pu_likes as likes', 'pu_ads.id', '=', 'likes.pu_ad_id')->select('pu_ads.*', 't.*', DB::raw('count(comment.id) as comentario'), DB::raw('count(likes.id) as likes'))->where('pu_ads.id', '=', $idPost)->where('pu_ads.flagactive', '=', 1);
     if ($value) {
         switch ($value) {
             case 1:
                 $dataAds = $dataAds->where('likes.flagactive', '=', 1);
                 break;
             case 2:
                 $dataAds = $dataAds->where('comment.flagactive', '=', 1);
                 break;
         }
     }
     $dataAds = $dataAds->first();
     return $dataAds;
 }