public function manage()
{
$expertId = Session::get('expert_id');
if (!isset($expertId)) {
return Redirect::to('/');
}
$appointment_count = Appointment::where('expert_id', '=', $expertId)->where('status', '=', 'booked')->where('appointment_date', '>=', date('Y-m-d H:i:s'))->count();
$availability_count = Appointment::where('expert_id', '=', $expertId)->where('status', '=', 'pending')->where('appointment_date', '>=', date('Y-m-d H:i:s'))->count();
return View::make('expert.dashboard')->with('appointment_count', $appointment_count)->with('availability_count', $availability_count);
}
public function getPatientAppointmentsHistory($patient)
{
if (Payment::VeryPayment() == false) {
return View::make('clinic.payment.renews-payment');
}
$doctor = Doctor::doctorLogin();
$Agenda = Agenda::where('doctor_id', $doctor)->first();
$Appointment = Appointment::where('patient_id', $patient)->where('agenda_id', $Agenda->id)->get();
return View::make('clinic.doctor.patients.history')->with('Appointment', $Appointment);
}
public function verifyAppointment()
{
$otp = Input::get('otp');
$email = Input::get('email');
$phone = Input::get('phone');
try {
$appointment = Appointment::where('otp', '=', $otp)->where('email', '=', $email)->where('phone', '=', $phone)->firstOrFail();
$appointment->verified = 1;
$appointment->save();
return Response::data($appointment);
} catch (ModelNotFoundException $e) {
return Response::invalid();
}
}
public function showAll($requestID = null)
{
$user = Confide::user();
$patient = Patient::find($requestID);
$patient = Patient::join('user', 'user.id', '=', 'patient.user_id')->where('patient.user_id', '=', $user->id)->first();
if ($user->isStaff() && $requestID !== null) {
// If weare requesting a patient's appointments and we are Staff
$appointments = Appointment::where('patient_id', '=', $requestID)->get();
$patient = Patient::join('user', 'user.id', '=', 'patient.user_id')->where('patient.user_id', '=', $requestID)->first();
} else {
$appointments = Appointment::where('patient_id', '=', $user->id)->get();
}
foreach ($appointments as $appointment) {
$doctor = User::find($appointment->staff_id);
$appointment->doctor = $doctor->first_name . ' ' . $doctor->last_name;
}
return View::make('home/appointment/show-all', compact('user', 'appointments', 'patient'));
}
public function dataCancelledAppointments()
{
$id = Session::get('institute_id');
$appointments = Appointment::where('institute_id', '=', $id)->where('status', '=', 'cancelled')->get();
return $appointments;
}
public function getAgendaDay()
{
if (Payment::VeryPayment() == false) {
return View::make('clinic.payment.renews-payment');
}
$id = Doctor::doctorLogin();
$agenda = Agenda::where('doctor_id', $id)->first();
$dt = Carbon::now();
$bussi = Business::where('agenda_id', $agenda->id)->first()->id;
if ($dt->dayOfWeek == 0) {
$dia = 'Sunday';
} elseif ($dt->dayOfWeek == 1) {
$dia = 'Monday';
} elseif ($dt->dayOfWeek == 2) {
$dia = 'Tuesday';
} elseif ($dt->dayOfWeek == 3) {
$dia = 'Wednesday';
} elseif ($dt->dayOfWeek == 4) {
$dia = 'Thursday';
} elseif ($dt->dayOfWeek == 5) {
$dia = 'Friday';
} else {
$dia = 'Saturday';
}
$CustomDay = CustomDay::where('agenda_id', $agenda->id)->get();
$Configday = Configday::where('day', $dia)->where('agenda_id', $agenda->id)->first();
$AgendaAppo = Appointment::where('agenda_id', $agenda->id)->get();
return View::make('clinic.doctor.Appointments.AppointmentsDay')->with('agendaAppo', $AgendaAppo)->with('configday', $Configday)->with('customddays', $CustomDay)->with('bussi', $bussi)->with('agenda', $agenda);
}
public function getAppointmentsOfDoctor($userid)
{
$apps = $this->appointment->where('doctor_id', $userid)->get();
return $this->getAppointments($apps);
}
public function getFreeSlots()
{
$id = Input::get('id');
// Get Employee id
$date = Input::get('date');
// Get selected date
$day = date('l', strtotime($date));
// Get day name from date
$duty_day = Dutyday::where('employee_id', $id)->where('day', $day)->get()->first();
if ($duty_day) {
$slot = null;
$appointments = Appointment::where('date', $date)->where('employee_id', $id)->get();
if (count($appointments) > 0) {
$timeslots = Timeslot::where('dutyday_id', $duty_day->id)->where('employee_id', $id);
foreach ($appointments as $appointment) {
$slot = $timeslots->where('slot', '!=', $appointment->time)->get()->toJson();
}
} else {
$slot = Timeslot::where('dutyday_id', $duty_day->id)->get()->toJson();
}
return JsonResponse::create($slot);
}
return 'false';
}
}
$flag = "check_fee";
return View::make('appointment_based_data.appointments', compact('appointments', 'flag'));
});
/* Route::get('app_view_vendor', function(){
if(Auth::user()->role == "Accountant"){
$vendor = Vendor::all();
}else{
$vendor = Vendor::has('vendor')->get();
}
$flag = "view_vendor";
return View::make('vendors.index', compact('vendors', 'flag'));
});*/
Route::get('app_test_fee', function () {
if (Input::get('id') !== null) {
$appointments = Appointment::where('patient_id', Input::get('id'))->get();
} else {
$appointments = Appointment::has('labtests')->get();
}
$flag = "test_fee";
return View::make('appointment_based_data.appointments', compact('appointments', 'flag'));
});
Route::resource('checkupfees', 'CheckupfeesController');
Route::resource('testfees', 'TestfeesController');
// PDF Reports
Route::any('print_pres', ['uses' => 'HomeController@print_pres']);
// Prescription PDF
Route::any('print_test', ['uses' => 'HomeController@print_test']);
// Test Report PDF
// Prints
Route::get('app_pres_print', function () {
Route::get('forgot_password', 'RemindersController@getRemind');
Route::post('forgot_password', 'RemindersController@postRemind');
Route::get('reset_password/{token}', 'RemindersController@getReset');
Route::post('reset_password/{token}', 'RemindersController@postReset');
Route::any('cities/{id}', 'PagesController@Cities');
Route::any('countries/', 'PagesController@Countries');
Route::any('insurances/', 'PagesController@Incuranses');
Route::controller('action', 'PagesController');
# Autentificacion
Route::get('logout', ['as' => 'logout', 'uses' => 'SessionsController@destroy']);
Route::resource('sessions', 'SessionsController', ['only' => ['create', 'store', 'destroy']]);
Route::get('test', function () {
$in_start = date('Y-m-d', Input::get('start'));
$date = $in_start;
$states = array('confirmed', 'delayed', 'pending', 'in-progress', 'served', 'old');
$appointment = Appointment::where('day', $date)->whereIn('state', $states)->get();
dd(count($appointment));
});
# Solo Pacientes Pacientes
Route::group(['before' => 'auth|standardUser'], function () {
Route::get('userProtected', 'StandardUserController@getUserProtected');
Route::resource('profiles', 'UsersController', ['only' => ['show', 'edit', 'update']]);
});
# Solo Admin
Route::group(['prefix' => '/admin', 'before' => 'auth|admin'], function () {
Route::get('/', ['as' => 'admin_dashboard', 'uses' => 'AdminController@getHome']);
Route::get('/clinic', ['as' => 'admin_patient', 'uses' => 'AdminController@getClinic']);
Route::resource('profiles', 'AdminUsersController', ['only' => ['index', 'show', 'edit', 'update', 'destroy']]);
Route::get('/send', ['as' => 'admin_send', 'uses' => 'GcmController@send']);
});
App::missing(function ($exception) {