Example #1
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show(Request $request, $id)
 {
     try {
         $dataProvider = new PrComments();
         $objProvider = $dataProvider->getAllCommentForProvider($id, $request->input('page'));
         $this->_responseWS->setDataResponse(Response::HTTP_OK, $objProvider, array(), 'ok');
     } catch (Exception $exc) {
         $this->_responseWS->setDataResponse(Response::HTTP_INTERNAL_SERVER_ERROR, array(), array(), '');
     }
     $this->_responseWS->response();
 }
 /**
  *
  * @return Response
  */
 public function store(RegisterCommentProviderRequest $request)
 {
     try {
         $dataProvider = $request->all();
         $objProvider = PrComments::whereUserId($this->_identity->id)->wherePrProviderId($dataProvider['pr_provider_id'])->first();
         if ($objProvider == null) {
             $dataProvider['user_id'] = $this->_identity->id;
             if (isset($dataProvider['picture'])) {
                 $file = base64_decode($dataProvider['picture']);
                 $pathrelative = "/dinamic/pr_comment/" . date('YmdHis') . rand(1, 1000) . ".jpg";
                 $path = App::publicPath() . $pathrelative;
                 file_put_contents($path, $file);
                 $dataProvider['picture'] = $pathrelative;
             }
             $objProvider = PrComments::create($dataProvider);
             DB::select("call score_provider(" . $dataProvider['pr_provider_id'] . "," . $dataProvider['punctuation'] . ")");
             $msg = 'ok';
         } else {
             $msg = 'Usted ya ha valorado al proveedor';
         }
         $this->_responseWS->setDataResponse(Response::HTTP_OK, ['id' => $objProvider->id], [], $msg);
     } catch (\Exception $exc) {
         dd($exc->getMessage());
         $this->_responseWS->setDataResponse(Response::HTTP_INTERNAL_SERVER_ERROR, [], [], '');
     }
     $this->_responseWS->response();
 }
Example #3
0
 public function getallProviders($category = null, $name_provider = null, $page)
 {
     $dataProviders = PrProviders::join('pr_types', 'pr_providers.pr_type_id', '=', 'pr_types.id')->leftJoin('pr_pictures', 'pr_pictures.pr_provider_id', '=', 'pr_providers.id')->join('pu_categories as puc', 'pr_providers.pr_type_id', '=', 'puc.id')->select('pr_providers.*', DB::raw('CONCAT("' . asset('') . '", picture_face) AS picture_face'), DB::raw('CONCAT("' . asset('') . '", puc.picture) AS picture_category'), 'pr_types.name_type', 'puc.name_category');
     if ($category != null) {
         $dataProviders = $dataProviders->where('pr_providers.pu_category_id', '=', $category);
     }
     if ($name_provider != null) {
         $dataProviders = $dataProviders->where('pr_providers.name_provider', 'like', '%' . $name_provider . '%');
     }
     $dataProviders = $dataProviders->where('pr_providers.flagactive', '=', 1)->groupby('pr_providers.id')->where('name_type', '!=', PrProviders::Type_Inactivo)->skip($this->perpage * ($page - 1))->orderBy('pr_providers.pr_type_id', 'desc')->orderBy('pr_providers.ranking', 'desc')->orderBy('pr_providers.lastupdate', 'desc')->take($this->perpage)->get();
     $data = $dataProviders == null ? [] : $dataProviders->toArray();
     $newdata = [];
     if ($data) {
         foreach ($data as $row) {
             //                $score =PrScore::wherePrProviderId($row['id'])->select(DB::raw('count(id) as score'))->get();
             $value = $row['name_type'] == PrProviders::Type_Premium ? 'get' : 'first';
             $dataPictureProvider = PrPictures::wherePrProviderId($row['id'])->select('flagactive', 'datecreate', DB::raw('CONCAT("' . asset('') . '", url) AS picture'))->{$value}();
             $total_users = PrComments::wherePrProviderId($row['id'])->whereFlagactive(1)->select(DB::raw('count(id) as total_users'))->get()->first();
             $row["total_users"] = $total_users->total_users;
             $row["friends"] = [['idfacebook' => '10156644988105647'], ['idfacebook' => '620320758106445'], ['idfacebook' => '10153512513095805'], ['idfacebook' => '10156576400725089']];
             if ($dataPictureProvider == null) {
                 $row['picture_provider'] = [];
             } else {
                 $row['picture_provider'] = $value == 'get' ? $dataPictureProvider->toArray() : [$dataPictureProvider->toArray()];
             }
             $newdata[] = $row;
         }
     } else {
         $newdata = [];
     }
     return $newdata;
 }
Example #4
0
 public function AllCommentForProviderForDataTable($pr_provider_id)
 {
     try {
         $data = PrComments::join('pr_providers as p', 'pr_comments.pr_provider_id', '=', 'p.id')->join('users as u', 'pr_comments.user_id', '=', 'u.id')->select('pr_comments.*', DB::raw('CONCAT("' . asset('') . '", u.picture) AS picture_user'), DB::raw('CONCAT("' . asset('') . '", pr_comments.picture) AS picture_comment'), 'u.name', 'u.lastname', DB::raw("(if(pr_comments.flagactive='1','Activo',(if(pr_comments.flagactive='0','Inactivo','-')))) as flagactive"), DB::raw("(if(pr_comments.flagactive='1','lock',(if(pr_comments.flagactive='0','unlock','-')))) as estado"))->where('p.id', '=', $pr_provider_id)->where('u.flagactive', '=', User::STATE_USER_ACTIVE)->orderBy('pr_comments.datecreate', 'desc');
         return $data;
     } catch (Exception $exc) {
         echo $exc->getTraceAsString();
         exit;
     }
 }
Example #5
0
 public function getDeleteAssessment($id)
 {
     $result = array('state' => 0, 'msg' => '');
     try {
         if (!$id) {
             throw new \Exception("Id de valoración vacio");
         }
         $user = PrComments::whereId($id)->first();
         $flagactive = $user->flagactive == 0 ? 1 : 0;
         $user->update(['id' => $id, 'flagactive' => $flagactive]);
         $result['state'] = 1;
     } catch (\Exception $e) {
         $result['msg'] = $e->getMessage();
     }
     return response()->json($result);
 }