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');
}
