public function ProviderForDataTable($condicion, $valoracion = null) { $dataProviders = PrProviders::join('pr_types', 'pr_providers.pr_type_id', '=', 'pr_types.id'); if ($valoracion != null) { $dataProviders = $dataProviders->join('pr_comments as prc', 'pr_providers.id', '=', 'prc.pr_provider_id'); } else { $dataProviders = $dataProviders->leftJoin('pr_comments as prc', 'pr_providers.id', '=', 'prc.pr_provider_id'); } $dataProviders = $dataProviders->select('pr_types.name_type', 'pr_providers.*', DB::raw('COUNT(prc.id) as valoracion'), DB::raw('CONCAT("' . asset('') . '", picture_face) AS picture_face'), DB::raw("(if(pr_providers.flagactive='1','Activo',(if(pr_providers.flagactive='0','Inactivo','-')))) as flagactive"), DB::raw("(if(pr_providers.flagactive='1','lock',(if(pr_providers.flagactive='0','unlock','-')))) as estado"))->where('pr_types.name_type', $condicion, PrProviders::Type_Inactivo)->groupby('pr_providers.id')->orderBy('pr_providers.pr_type_id', 'desc')->orderBy('pr_providers.ranking', 'desc')->orderBy('pr_providers.lastupdate', 'desc')->groupBy('pr_providers.id'); return $dataProviders; }
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', '!=', 'inactivo')->orderBy('pr_providers.lastupdate', 'desc')->first(); $data = $dataProviders == null ? [] : $dataProviders->toArray(); return $data; }