/** * 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(); }
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; }
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; } }
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); }