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 getProvider($idProvider) { $dataProviders = PrProviders::join('pr_types', 'pr_providers.pr_type_id', '=', 'pr_types.id')->leftJoin('pr_pictures', 'pr_pictures.pr_provider_id', '=', 'pr_providers.id')->select('pr_types.name_type', 'pr_providers.*', DB::raw('CONCAT("' . asset('') . '", picture_face) AS picture_face'))->where('pr_providers.id', '=', $idProvider)->where('pr_types.name_type', '!=', PrProviders::Type_Inactivo)->orderBy('pr_providers.lastupdate', 'desc')->first(); $data = $dataProviders == null ? [] : $dataProviders->toArray(); if ($data != []) { $data['comments'] = PrComments::join('users as u ', 'u.id', '=', 'pr_comments.user_id')->select('pr_comments.*', DB::raw('CONCAT("' . asset('') . '", pr_comments.picture) AS picture_comment'), DB::raw('CONCAT("' . asset('') . '", u.picture) AS picture_user'), DB::raw('CONCAT(u.name, " ", u.lastname) AS name_user'))->where('pr_comments.pr_provider_id', '=', $idProvider)->orderBy('pr_comments.datecreate', 'desc')->get()->toArray(); $value = $data['name_type'] == PrProviders::Type_Premium ? 'get' : 'first'; $dataPictureProvider = PrPictures::wherePrProviderId($idProvider)->select('flagactive', 'datecreate', DB::raw('CONCAT("' . asset('') . '", url) AS picture'))->{$value}(); $data['picture_provider'] = $dataPictureProvider == null ? [] : $dataPictureProvider->toArray(); } return $data; }