public function getAllAdvisingAppointments() { $results = $this->db->get_where('AdvisingAppointments', array('AdvisingScheduleID' => $this->advisingScheduleID)); $data_arr = array(); foreach ($results->result_array() as $row) { $appt = new Advising_appointment_model(); $appt->setAdvisingAppointmentID($row['AdvisingAppointmentID']); $appt->setAdvisingScheduleID($row['AdvisingScheduleID']); $appt->setStartTime($row['StartTime']); $appt->setEndTime($row['EndTime']); $results = $this->db->get_where('ScheduledAdvisingAppointments', array('AdvisingAppointmentID' => $row['AdvisingAppointmentID']), 1); if ($results->num_rows() > 0) { $row = $results->row_array(); $appt->setAdvisingAppointmentState($row['AppointmentStateID']); $appt->setStudentUserID($row['StudentUserID']); } array_push($data_arr, $appt); } return $data_arr; }
public function Student_Cancel() { $User_model = new User_model(); $User_model->loadPropertiesFromPrimaryKey($_SESSION['UserID']); $quarter = Academic_quarter_model::getLatestAcademicQuarter(); $quarter = $quarter->getAcademicQuarterID(); $Advising_schedule = new Advising_schedule_model(); $Advising_appointment = new Advising_appointment_model(); $advisor = $User_model->getAdvisor(); $advisor = $advisor->getUserID(); $Advising_schedule->loadPropertiesFromAdvisorIDAndAcademicQuarterID($advisor, $quarter); $app_array = $Advising_schedule->getAllAdvisingAppointments(); foreach ($app_array as $key) { if ($key->getScheduledStudentUserID() == $_SESSION['UserID'] && $key->isScheduled()) { $Advising_appointment->loadPropertiesFromPrimaryKey($key->getAdvisingAppointmentID()); $Advising_appointment->setAdvisingAppointmentState(3); $Advising_appointment->update(); break; } } //SEND Optional Email redirect('appointment_controller'); }