public function HorariosOcupados($dia_cita) { $dayOfWeek = Carbon::now()->dayOfWeek; if ($dayOfWeek >= $dia_cita) { $citaInicial = Carbon::now()->next($dia_cita); } else { $citaInicial = Carbon::now()->next($dia_cita)->addWeek(); } $citas = Cita::distinct()->select('hora_id')->whereDia_id($dia_cita)->where('fecha', '>=', $citaInicial->toDateString())->groupBy('hora_id')->get(); $horasIds = array(); foreach ($citas as $cita) { $horasIds[] = $cita->hora_id; } return $horasIds; }