PHP Appointment::save方法代码示例

 public function postSave($id = null)
 {
     $validator = Validator::make(Input::all(), Appointment::$rules);
     if ($validator->passes()) {
         $event = Appointment::find(Input::get('id'));
         if (!$event) {
             $event = new Appointment();
         }
         $calendar = Calendar::find(explode('/', Input::get('date'))[0]);
         if ($calendar) {
             $day = explode('/', Input::get('date'))[1];
             if ($day > 0 && $day <= $calendar->number_of_days) {
                 $event->name = Input::get('name');
                 $event->date = explode('/', Input::get('date'))[1];
                 $event->start_time = Input::get('start_time');
                 $event->end_time = Input::get('end_time');
                 $event->notes = Input::get('notes');
                 $event->calendar_id = $calendar->id;
                 $event->group_id = Input::get('group_id');
                 $event->user_id = Auth::user()->id;
                 $event->save();
                 return Response::json(array('status' => 'success', $event));
             } else {
                 $validator->messages()->add('date', 'The day is invalid.');
             }
         } else {
             $validator->messages()->add('date', 'The month is invalid.');
         }
     }
     return Response::json(array('status' => 'error', 'errors' => $validator->messages()));
 }

 /**
  * Display the specified resource.
  * GET /patientappointment/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function makeAppointment()
 {
     $patient = null;
     $rules = ['patient_id' => 'required', 'doctor_id' => 'required', 'date' => 'required', 'time' => 'required'];
     $data = Input::all();
     $validator = Validator::make(Input::all(), $rules);
     $patient = DB::table('patients')->where('id', $data['patient_id'])->first();
     if ($validator->fails()) {
         return View::make('PatientViews/appointment')->with('title', 'Appointment')->with('id', $data['patient_id'])->with('name', $patient->name)->withErrors($validator);
     } else {
         $doctor = DB::table('doctors')->where('id', $data['doctor_id'])->pluck('working_hourse');
         $doctor_name = DB::table('doctors')->where('id', $data['doctor_id'])->pluck('name');
         $appointmentCount = 0;
         $appointment = DB::table('appointments')->where('schedule', $data['date'])->get();
         $appointmentCount = count($appointment);
         $hourse = $doctor;
         $appointment = new Appointment();
         $appointment->patients_id = $data['patient_id'];
         $appointment->doctors_id = $data['doctor_id'];
         $appointment->schedule = $data['time'];
         if ($appointment->save()) {
             return View::make('PatientViews/appointmentComplete')->with('title', 'appointment_complete')->with('patient_name', $patient->name)->with('patient_id', $data['patient_id'])->with('doctor_name', $doctor_name)->with('appointment_date', $data['date'])->with('appointment_time', $data['time']);
         } else {
             return View::make('PatientViews/appointment')->with('title', 'Appointment')->with('id', $data['patient_id'])->with('name', $patient_name)->withErrors("Something Went Wrong, please try again");
         }
     }
 }

 /**
  * Store a newly created appointment in storage.
  *
  * Should have: category, advisor, studentId, startTime, endTime
  *
  * @return Response
  *
  */
 public function store()
 {
     $appointment = new Appointment();
     $input = Input::all();
     //Check Required
     if (!array_key_exists('category', $input)) {
         return Response::json(array('message' => 'Missing category'), 400);
     } elseif (!array_key_exists('advisor', $input)) {
         return Response::json(array('message' => 'Missing advisor'), 400);
     } elseif (!array_key_exists('start', $input)) {
         return Response::json(array('message' => 'Missing startTime'), 400);
     } elseif (!array_key_exists('end', $input)) {
         return Response::json(array('message' => 'Missing endTime'), 400);
     } elseif (!array_key_exists('studentId', $input)) {
         return Response::json(array('message' => 'Missing studentId'), 400);
     }
     $appointment->category_id = $input['category'];
     $appointment->start = $input['start'];
     $appointment->end = $input['end'];
     $appointment->save();
     $user = User::find($input['studentId']);
     $std_appt = $user->appointments()->save($appointment);
     // DOES NOT CURRENTLY SET 'is_advising' correctly ... need to fix
     $advisor = User::find($input['advisor']);
     $adv_appt = $advisor->appointments()->save($appointment);
     // Format the dates better
     $appointment->start = Carbon::parse($appointment->start)->toDayDateTimeString();
     $appointment->end = Carbon::parse($appointment->end)->toDayDateTimeString();
     // Return the advisorid and userid in the created appointment object
     $appointment->user = $user->fname . ' ' . $user->lname;
     $appointment->advisor = $advisor->fname . ' ' . $advisor->lname;
     $appointment->category = Category::find($appointment->category_id)->name;
     return Response::json($appointment);
 }

 public function executeQuery(sfWebRequest $request)
 {
     if ($request->isXmlHttpRequest()) {
         if ($request->isMethod(sfRequest::GET)) {
             $startDate = $request->getGetParameter('startDate');
             $endDate = $request->getGetParameter('endDate');
             $page = $request->getGetParameter('page');
             $start = $request->getGetParameter('start');
             $limit = $request->getGetParameter('limit');
             $this->convertParamToDateTime($startDate);
             $this->convertParamToDateTime($endDate);
             $result = Doctrine_Core::getTable('Appointment')->getBetween($startDate, $endDate);
             $response = $this->buildResponse($result, "Loading Record");
         } else {
             if ($request->isMethod(sfRequest::POST)) {
                 $form_data = json_decode(file_get_contents('php://input'));
                 $location = $form_data->loc;
                 $title = $form_data->title;
                 $notes = $form_data->notes;
                 $url = $form_data->url;
                 $reminder = $form_data->rem;
                 $cid = $form_data->cid;
                 $startDate = str_replace('T', ' ', $form_data->start);
                 $endDate = str_replace('T', ' ', $form_data->end);
                 $this->convertParamToDateTime($startDate, 'Y-m-d H:i:s');
                 $this->convertParamToDateTime($endDate, 'Y-m-d H:i:s');
                 $a = new Appointment();
                 $a->fromArray(array('coach_id' => 1, 'client_id' => 1, 'calendar_type_id' => $cid, 'scheduled' => $startDate, 'started_at' => $startDate, 'finished_at' => $endDate, 'title' => $title, 'location' => $location, 'notes' => $notes, 'web_link' => $url, 'reminder' => $reminder));
                 $a->save();
                 $response = $this->buildResponse($a, "Creating Record");
             } else {
                 if ($request->isMethod(sfRequest::PUT)) {
                     $form_data = json_decode(file_get_contents('php://input'));
                     $location = $form_data->loc;
                     $title = $form_data->title;
                     $notes = $form_data->notes;
                     $url = $form_data->url;
                     $reminder = $form_data->rem;
                     $cid = $form_data->cid;
                     $startDate = str_replace('T', ' ', $form_data->start);
                     $endDate = str_replace('T', ' ', $form_data->end);
                     $this->convertParamToDateTime($startDate, 'Y-m-d H:i:s');
                     $this->convertParamToDateTime($endDate, 'Y-m-d H:i:s');
                     $a = Doctrine_Core::getTable('Appointment')->find(array($request->getParameter('id')));
                     $a->fromArray(array('coach_id' => 1, 'client_id' => 1, 'calendar_type_id' => $cid, 'scheduled' => $startDate, 'started_at' => $startDate, 'finished_at' => $endDate, 'title' => $title, 'location' => $location, 'notes' => $notes, 'web_link' => $url, 'reminder' => $reminder));
                     $a->save();
                     $response = $this->buildResponse($a, "Updating Record");
                 } else {
                     if ($request->isMethod(sfRequest::DELETE)) {
                         $app = Doctrine_Core::getTable('Appointment')->find(array($request->getParameter('id')));
                         $app->delete();
                         $response = array('success' => true, 'message' => 'Destroyed Record', 'data' => array());
                     }
                 }
             }
         }
         sfConfig::set('sf_web_debug', false);
         return $this->renderPartial('global/ajax', array('ajax' => json_encode($response)));
     }
 }

 public function store()
 {
     if (Request::ajax()) {
         $data = array("agenda_id" => Input::get("agenda_id"), "patient" => Input::get("patient"), "reason" => Input::get("reason"), "fecha" => Input::get("fecha"), "start" => Input::get("start"), "end" => Input::get("end"));
         $rules = array("agenda_id" => 'required', "patient" => 'required|min:2|max:100', "reason" => 'required|min:2|max:200', "fecha" => 'required|min:1|max:100', "start" => 'required|min:1|max:100', "end" => 'required|min:1|max:100');
         $messages = array('required' => 'El campo :attribute es obligatorio.', 'min' => 'El campo :attribute no puede tener menos de :min carácteres.', 'email' => 'El campo :attribute debe ser un email válido.', 'max' => 'El campo :attribute no puede tener más de :max carácteres.', 'numeric' => 'El campo :attribute debe contener solo numeros', 'mimes' => 'El formato de la imagen logo debe ser jpg, git, png');
         $validation = Validator::make(Input::all(), $rules, $messages);
         //si la validación falla redirigimos al formulario de registro con los errores
         if ($validation->fails()) {
             return Response::json(array('success' => false, 'errors' => $validation->getMessageBag()->toArray()));
         } else {
             $agenda = Agenda::find(Input::get('agenda_id'));
             $user = User::where('email', Input::get('patient'))->orWhere('username', Input::get('patient'))->first();
             if ($user) {
                 $patient = Patient::where('user_id', $user->id)->first();
                 if (!$patient) {
                     $patient = new Patient();
                     $patient->user_id = $user->id;
                     $patient->save();
                 }
                 $docPatient = DoctorPatient::where('patient_id', $patient->id)->where('doctor_id', $agenda->doctor_id)->first();
                 if (!$docPatient) {
                     $docPatient = new DoctorPatient();
                     $docPatient->patient_id = $patient->id;
                     $docPatient->doctor_id = $agenda->doctor_id;
                     $docPatient->save();
                 }
                 $apo = new Appointment();
                 $apo->patient_id = $patient->id;
                 $apo->agenda_id = $agenda->id;
                 $apo->day = Input::get("fecha");
                 $apo->start_date = Input::get('start');
                 $apo->end_date = Input::get('end');
                 $apo->reason = Input::get('reason');
                 if ($agenda->appointment_state == 0) {
                     $apo->state = 'confirmed';
                 } else {
                     $apo->state = 'pending';
                 }
                 $apo->save();
                 if ($apo) {
                     if ($agenda->appointment_state == 0) {
                         $mgs = new MgsAppointment();
                         $mgs->appointment_id = $apo->id;
                         $mgs->text = "Su cita fue Confirmada";
                         $mgs->save();
                     }
                     return Response::json(array('success' => true));
                 }
             } else {
                 return Response::json(array('success' => false, 'errors' => 'El usuario no existe'));
             }
         }
     }
 }

 public function create()
 {
     $user = Confide::user();
     if (Request::isMethod('GET')) {
         $staffMembers = DB::table('doctor_patient')->where('doctor_patient.user_id', '=', $user->id)->join('user', 'doctor_patient.staff_id', '=', 'user.id')->join('staff', 'staff.user_id', '=', 'user.id')->select('user.id', 'first_name', 'last_name', 'position')->get();
         $staff = array();
         $staff[''] = "-- Select a Doctor --";
         foreach ($staffMembers as $staffMember) {
             $staff[$staffMember->id] = "Dr. " . $staffMember->first_name . " " . $staffMember->last_name . " " . "(" . $staffMember->position . ")";
         }
         return View::make('home/appointment/create', compact('staff', 'user'));
     } elseif (Request::isMethod('POST')) {
         $messages = array();
         $validator = Validator::make(Input::all(), array('date' => 'required|after:' . date('Y-m-d') . '', 'time' => 'required', 'staff_id' => 'required', 'reason' => 'required'), array('date.required' => 'You must specify a date for the appointment.', 'date.after' => 'You must specify a more future date.', 'time.required' => 'You must specify a time for the appointment.', 'staff_id.required' => 'You must select a doctor.', 'reason.required' => 'You must describe a reason for your appointment.'));
         // Get other errors
         if ($validator->fails()) {
             $messageBag = $validator->messages();
             foreach ($messageBag->all(':message<br>') as $message) {
                 $messages[] = $message;
             }
         }
         if (empty($messages)) {
             // Create a new Appointment with the given data
             $appointment = new Appointment();
             $appointment->fill(Input::all());
             $appointment->patient_id = $user->id;
             $appointment->timestamp = date('Y-m-d H:i:s', strtotime(Input::get('date') . " " . Input::get('time')));
             $appointment->status = 'unconfirmed';
             $appointment->save();
             return Redirect::route('appointment.show.all');
         } else {
             // Flash data to session vars to repopulate form later
             Input::flash();
             // Compile error messages
             $messages = implode($messages);
             return Redirect::route('appointment.create')->with(array('message' => 'Error:<br>' . $messages, 'message_type' => 'error'));
         }
     }
 }

 public function getdataAction()
 {
     $this->view->disable();
     if ($this->request->isPost()) {
         $infos = $this->request->getPost();
         $appointment = new Appointment();
         $appointment->custName = $infos['res_custName'];
         $appointment->mobile = $infos['res_mobile'];
         $appointment->telephone = $infos['res_telephone'];
         $appointment->email = $infos['res_email'];
         $appointment->postcode = $infos['res_postcode'];
         $appointment->custsex = $infos['res_custSex'];
         $appointment->address = $infos['res_address'];
         $appointment->type = 0;
         $appointment->time = time();
         if ($appointment->save()) {
             echo true;
         } else {
             echo false;
         }
     } else {
         $this->response->redirect("index/index");
     }
 }

 function makeAppointment($user, $scheduleitem_id)
 {
     //get schedule item and verify it and update the darn status
     if (!($item =& $this->getScheduleItem($scheduleitem_id))) {
         return false;
     }
     if (!$item->isOpen()) {
         $this->addError('Requested appointment not open');
         return false;
     }
     $appointment = new Appointment($this->dbcon);
     $data = array('userdata_id' => $user, 'action_id' => $scheduleitem_id);
     $appointment->setData($data);
     return $appointment->save();
 }

 /**
  * @before _secure
  */
 public function book()
 {
     $this->noview();
     $session = Registry::get("session");
     $configuration = Registry::get("configuration");
     $imojo = $configuration->parse("configuration/payment");
     $intoSeconds = function ($value) {
         $pieces = explode(":", $value);
         return 3600 * $pieces[0] + 60 * $pieces[1];
     };
     if (RequestMethods::get("action") == "pickupLocation") {
         $session->set('Appt\\Book:$location', RequestMethods::get("location_id"));
         echo "Success";
         return;
     }
     if (RequestMethods::post("action") != "checkout" || !$session->get('Appt\\Book:$location')) {
         $this->redirect("/404");
     }
     $charge = base64_decode(RequestMethods::post("tp"));
     $services = RequestMethods::post("service");
     $centre = RequestMethods::post("centre");
     $carts = RequestMethods::post("cart");
     $order = new Order(array("user_id" => $this->user->id, "type" => "appointment", "amount" => $charge, "mode" => "instamojo", "ref_id" => ""));
     $order->save();
     foreach ($services as $service) {
         $i = 0;
         $c = Centre::first(array("id = ?" => $centre[$i]), array("organization_id"));
         $appointment = new Appointment(array("patient_id" => RequestMethods::post("user_id", $this->user->id), "user_id" => $this->user->id, "order_id" => $order->id, "centre_id" => $centre[$i], "service_id" => $service, "location_id" => $session->get('Appt\\Book:$location'), "organization_id" => $c->organization_id, "start" => strftime("%Y-%m-%d %H:%M:%S", strtotime(RequestMethods::post("start")) + $intoSeconds(RequestMethods::post("startTime"))), "end" => strftime("%Y-%m-%d %H:%M:%S", strtotime(RequestMethods::post("start")) + $intoSeconds(RequestMethods::post("endTime"))), "allDay" => 0));
         $appointment->save();
         $i++;
     }
     $session->erase('Appt\\Book:$location');
     $curl = new Curl();
     $curl->setHeader('X-Api-Key', $imojo->payment->instamojo->key);
     $curl->setHeader('X-Auth-Token', $imojo->payment->instamojo->auth);
     $curl->post('https://www.instamojo.com/api/1.1/payment-requests/', array("purpose" => "Appointment", "amount" => $charge, "buyer_name" => $this->user->name, "email" => $this->user->email, "phone" => $this->user->phone, "redirect_url" => "http://healthlitmus.com/appointments/success", "allow_repeated_payments" => false));
     if (!isset($_COOKIE["fixedappointments"])) {
         setcookie("fixedappointments", 1, time() + 3600 * 24);
     } else {
         setcookie("fixedappointments", $_COOKIE["fixedappointments"] + 1, time() + 3600 * 24);
     }
     $payment = $curl->response;
     if ($payment->success == "true") {
         foreach ($carts as $cart) {
             $cart = Cart::first(array("id = ?" => $cart));
             $cart->delete();
         }
         $session->erase('User\\Cart:$cart')->erase('User\\Cart:$total');
         $instamojo = new Instamojo(array("user_id" => $this->user->id, "payment_request_id" => $payment->payment_request->id, "amount" => $payment->payment_request->amount, "purpose" => "order", "purpose_id" => $order->id, "status" => $payment->payment_request->status, "longurl" => $payment->payment_request->longurl, "live" => 1));
         $instamojo->save();
         $this->redirect($instamojo->longurl);
     }
 }

 protected function afterSave()
 {
     /** @var $user User */
     $userId = $this->followUpUser ?: Yii::app()->user->id;
     $user = User::model()->findByPk($userId);
     if ($this->followUpDue) {
         if ($note = $this->followUpAppointment) {
             $note->app_start = date("Y-m-d", strtotime($this->followUpDue));
             $note->app_user = $user ? $user->use_id : $note->app_user;
             $note->calendarID = $user ? $user->use_branch : $note->calendarID;
         } else {
             if (!$user) {
                 throw new Exception('User for follow up is not selected');
             }
             $note = new Appointment();
             $note->app_type = Appointment::TYPE_VALUATION_FOLLOW_UP;
             $note->app_start = date("Y-m-d", strtotime($this->followUpDue));
             $note->app_user = $user->use_id;
             $note->calendarID = $user->use_branch;
             $note->app_subject = $this->property->address->toString(', ');
             $note->setInstructions([$this->dea_id]);
         }
         $existingFollowUps = Appointment::model()->findByAttributes(array("app_user" => $note->app_user, 'app_type' => Appointment::TYPE_VALUATION_FOLLOW_UP), array('order' => 'app_start DESC', 'condition' => 'DATE(app_start) = "' . date("Y-m-d", strtotime($note->app_start)) . '"'));
         if (!$existingFollowUps) {
             $note->app_start = date("Y-m-d", strtotime($note->app_start)) . " 09:00:00";
             // hardcoded time, not best solution ever
             $note->app_end = date("Y-m-d", strtotime($note->app_start)) . " 09:30:00";
         } else {
             $note->app_start = $existingFollowUps->app_end;
             $note->app_end = date("Y-m-d H:i:s", strtotime($note->app_start . " + 30 minutes"));
         }
         if ($note->save()) {
             $this->followUpAppointmentId = $note->app_id;
             $this->saveAttributes(['followUpAppointmentId']);
         } else {
             $this->addError("followUpUppointment", "Could not save follow up appointment");
         }
         $this->followUpAppointment = $note;
     }
     parent::afterSave();
 }

 /**
  * Update the specified resource in storage.
  * PUT /patients/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function doctorSelection()
 {
     $rules = ['patient_id' => 'required', 'patient_name' => 'required', 'specialty' => 'required', 'doctor_id' => 'required', 'appointment_date' => 'required', 'appointment_time' => 'required'];
     $data = Input::all();
     $validator = Validator::make(Input::all(), $rules);
     $patient = DB::table('patients')->where('id', $data['patient_id'])->first();
     if ($validator->fails()) {
         return View::make('appointment')->with('title', 'Appointment')->with('id', $data['patient_id'])->with('name', $patient->name)->withErrors($validator);
     } else {
         $doctor = DB::table('doctors')->where('id', $data['doctor_id'])->pluck('working_hourse');
         $doctor_name = DB::table('doctors')->where('id', $data['doctor_id'])->pluck('name');
         $appointmentCount = 0;
         $appointment = DB::table('appointments')->where('schedule', $data['appointment_date'])->get();
         $appointmentCount = count($appointment);
         $hourse = $doctor;
         if ($appointmentCount >= $hourse * 60 / 15) {
             return View::make('appointment')->with('title', 'Appointment')->with('id', $data['patient_id'])->with('name', $patient_name)->withErrors($validator);
         } else {
             $appointment = new Appointment();
             $appointment->patients_id = $data['patient_id'];
             $appointment->doctors_id = $data['doctor_id'];
             $appointment->schedule = $data['appointment_date'] . ' ' . $data['appointment_time'];
             if ($appointment->save()) {
                 return View::make('appointmentComplete')->with('title', 'appointment_complete')->with('patient_name', $patient->name)->with('patient_serial', $data['patient_id'])->with('doctor_name', $doctor_name)->with('appointment_date', $data['appointment_date'])->with('appointment_time', $data['appointment_time']);
             }
         }
     }
     //return 'abc';
 }

 /**
  * edit method
  *
  * @param string $id
  * @return void
  */
 public function edit($id = null, $section = null)
 {
     $this->WorkOrder->id = $id;
     if (!$this->WorkOrder->exists()) {
         throw new NotFoundException(__('Invalid quote'));
     }
     if ($this->request->is('post') || $this->request->is('put')) {
         $this->request->data['WorkOrder']['id'] = $id;
         if (trim($this->request->data['WorkOrderStatus']['status']) == "Approve") {
             $this->request->data['WorkOrder']['status'] = "Approve";
             $wo_data = $this->WorkOrder->find('first', array('conditions' => array('WorkOrder.id' => $id)));
             $s_date = date("Y-m-d H:i:s", strtotime($wo_data['Quote']['est_shipping']));
             $add_e_date = strtotime($wo_data['Quote']['est_shipping']);
             //				$add_e_date = strtotime($wo_data['Quote']['est_shipping']) + ( 60 * 60 );
             $e_date = date("Y-m-d H:i:s", $add_e_date);
             $schedule['Appointment']['work_order_id'] = $wo_data['WorkOrder']['id'];
             $schedule['Appointment']['address'] = $wo_data['Quote']['address'];
             $schedule['Appointment']['city'] = $wo_data['Quote']['city'];
             $schedule['Appointment']['province'] = $wo_data['Quote']['province'];
             $schedule['Appointment']['postal_code'] = $wo_data['Quote']['postal_code'];
             $schedule['Appointment']['country'] = $wo_data['Quote']['country'];
             $schedule['Appointment']['type'] = "Appointment";
             $schedule['Appointment']['created_by'] = $this->loginUser['id'];
             $schedule['Appointment']['start_date'] = $s_date;
             $schedule['Appointment']['end_date'] = $e_date;
         }
         if (trim($this->request->data['WorkOrderStatus']['status']) == "Review") {
             $this->request->data['WorkOrder']['status'] = "Review";
         }
         if (trim($this->request->data['WorkOrderStatus']['status']) == "New") {
             $this->request->data['WorkOrder']['status'] = "New";
         }
         if (trim($this->request->data['WorkOrderStatus']['status']) == "Cancel") {
             $this->request->data['WorkOrder']['status'] = "Cancel";
         }
         if (trim($this->request->data['WorkOrderStatus']['status']) == "Change") {
             $this->request->data['WorkOrder']['status'] = "Change";
         }
         //			pr($this->request->data);exit;
         if ($this->WorkOrder->save($this->request->data)) {
             App::import('Model', 'ScheduleManager.Appointment');
             $Appointment_Model = new Appointment();
             $Appointment_Model->save($schedule);
             $this->Session->setFlash(__('The Work Order status has been saved'), 'default', array('class' => 'text-success'));
             $this->redirect(array('action' => 'detail_section', $this->WorkOrder->id, $section));
         } else {
             $this->Session->setFlash(__('The Work Order status could not be saved. Please, try again.'), 'default', array('class' => 'text-error'));
             $this->redirect(array('action' => 'detail_section', $this->WorkOrder->id, $section));
         }
     }
 }