PHP Appointment::where方法代码示例

 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) {