public static function searchDoctor($pais, $ciudad, $especialidad, $seguro, $nombre, $patient)
{
$doctors = DB::table('doctors')->Join('users', 'users.id', '=', 'doctors.user_id')->Join('specialties', 'specialties.id', '=', 'doctors.specialty_id')->Join('clinics', 'clinics.id', '=', 'doctors.clinic_id')->Join('business_clinics', 'business_clinics.doctor_id', '=', 'doctors.id')->Join('addresses', 'addresses.id', '=', 'business_clinics.addresses_id')->Join('cities', 'cities.id', '=', 'addresses.city_id')->Join('provinces', 'provinces.id', '=', 'cities.province_id')->Join('countries', 'countries.id', '=', 'provinces.country_id');
/*
$pais
$ciudad
$especialidad
$seguro
if($ciudad!=""){$patients = $patients->where('appointments.reason', 'LIKE', '%'.Input::get("motivo").'%'); }
*/
if ($pais != "0") {
$doctors = $doctors->where('countries.id', $pais);
}
if ($ciudad != "0") {
$doctors = $doctors->where('cities.id', $ciudad);
}
if ($especialidad != "0") {
$doctors = $doctors->where('specialties.id', $especialidad);
}
$doctors = $doctors->where('doctors.state', 1);
$doctors = $doctors->select('doctors.id as id', DB::raw('CONCAT(first_name," ",last_name) as name'), 'business_clinics.name as local', 'business_clinics.id as local_id', 'specialties.id as specialty_id', 'specialties.name_es as specialty_name', 'cities.id as city_id', 'cities.name as city_name', 'provinces.name as province', 'countries.id as country_id', 'countries.name as country_name', 'addresses.id as address_id', 'addresses.my_address as address_name')->take(10);
$doctors = $doctors->orderBy('users.first_name')->get();
$array = [];
if ($seguro != "0") {
foreach ($doctors as $a) {
$c = Helpers::Insurances($a->id, true, $seguro);
$is_favorite = Helpers::is_favorite($a->local_id, $patient);
if (!$c) {
} else {
$arrayobj = (array) $a;
$arrayobj2 = array('insurances' => $c, 'favorite' => $is_favorite);
$a = array_merge($arrayobj, $arrayobj2);
$array2 = array_merge($array, $a);
$array[] = $a;
}
}
} else {
foreach ($doctors as $doc) {
$c = Helpers::Insurances($doc->id);
$is_favorite = Helpers::is_favorite($doc->local_id, $patient);
$arrayobj = (array) $doc;
$arrayobj2 = array('insurances' => $c, 'favorite' => $is_favorite);
$doc = array_merge($arrayobj, $arrayobj2);
$array2 = array_merge($array, $doc);
$array[] = $doc;
}
}
#return Response::json($array);
return Response::json($array);
}
