/**
  *
  * @return Response
  */
 public function index(Request $request)
 {
     try {
         $dataAdsForUser = new PuAds();
         $dataAds = $dataAdsForUser->getAllAdsForUser($this->_identity->id, $request->input('page'));
         $this->_responseWS->setDataResponse(Response::HTTP_OK, $dataAds->toArray(), array(), 'ok');
     } catch (Exception $exc) {
         $this->_responseWS->setDataResponse(Response::HTTP_INTERNAL_SERVER_ERROR, array(), array(), '');
     }
     $this->_responseWS->response();
 }
    public function getList(Request $request)
    {
        try {
            $PuPosts = new PuAds();
            $table = $PuPosts->PostForDataTable(null, 'ok');
            $datatable = Datatables::of($table)->editColumn('picture_publication', '<img src="{{$picture_publication}}" heigth=64" width="64" />')->addColumn('action', function ($table) {
                return '<a href="/admpanel/' . self::NAMEC_PUBLICATION . '/form/' . $table->id . '/' . self::NAMEC . '" class="btn-actions icon icon-pen"></a>
				<a href="javascript:;" data-url="/admpanel/' . self::NAMEC_PUBLICATION . '/delete/' . $table->id . '" class="btn-actions icon icon-' . $table->estado . ' js-change-confirm" title="' . $table->estado . '" data-status="' . $table->estado . '" data-id="' . $table->id . '" ></a>';
            });
            return $datatable->make(true);
        } catch (Exception $exc) {
            echo $exc->getTraceAsString();
            exit;
        }
    }
Exemple #3
0
 public function index()
 {
     //		$datos = DB::select("call post_popular(7,2)");
     $modelSubsidiary = new PuAds();
     $listPremiumAds_ = $modelSubsidiary->getAllAds(null, null, null, 1, PuTypes::TYPE_PREMIUM);
     $listPremiumAds_[0]['detalle'] = asset('') . 'admpanel/publication/form/' . $listPremiumAds_[0]['id'];
     $listPublishAds_ = $modelSubsidiary->getPublishAds_count();
     $listSessions_ = $modelSubsidiary->getSessions_count();
     $visits = new \stdClass();
     $visits->viewers['Día'] = (int) $listSessions_->day_;
     $visits->viewers['Semana'] = (int) $listSessions_->week_;
     $visits->viewers['Mes'] = (int) $listSessions_->month_;
     $visits->posts['Día'] = (int) $listPublishAds_->day_;
     $visits->posts['Semana'] = (int) $listPublishAds_->week_;
     $visits->posts['Mes'] = (int) $listPublishAds_->month_;
     $listPremiumAds_ = json_encode($listPremiumAds_);
     $visits = json_encode($visits);
     return $this->renderView('admin.home.index', compact('listPremiumAds_', 'visits'));
 }
Exemple #4
0
 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;
 }
 public function dataPremium($idPost)
 {
     $modelAds = new PuAds();
     $modelTypeAds = new PuTypes();
     $modelConfig = \App\Models\Configuration::whereFlagactive(1)->first();
     $dataComentario = $modelAds->getAdsType($idPost, 2);
     $dataLike = $modelAds->getAdsType($idPost, 1);
     if ($dataComentario->comentario >= $modelConfig->limit_datear || $dataLike->likes >= $modelConfig->limit_buen_dato) {
         $type = $modelTypeAds->getIdPuType(PuTypes::TYPE_POPULAR);
     } else {
         $type = $modelTypeAds->getIdPuType(PuTypes::TYPE_COMUN);
     }
     return $type;
 }
 /**
  * método que permite validar post de Usuario
  *
  * @param  int  $id
  * @return Response
  */
 public function haveAdsForUser($id)
 {
     $dataAds = PuAds::whereId($id)->whereUserId($this->_identity->id)->whereFlagactive(1)->first();
     if (isset($dataAds->id)) {
         return true;
     } else {
         $this->_responseWS->setDataResponse(Response::HTTP_NON_AUTHORITATIVE_INFORMATION, array(), array(), 'id de publicacion no permitida');
         $this->_responseWS->response();
     }
 }