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;
}
