echo '<hr>'; echo "This E-mail: <font color='#FF0000'>'" . $email . "'</font> does not exist in our database"; echo '<br>'; echo 'Use the Close Button to Continue'; } else { $user->email = $email; $user_exists = array_shift($user_exists); if ($user_exists->progress == 'Completed') { $referees = new Referees(); $referees_details = $referees->find_by_sql("SELECT * FROM referees WHERE applicant_id='" . $user_exists->applicant_id . "'"); $mail_error = ''; foreach ($referees_details as $referee_info) { $referees->referee_email = $referee_info->referee_email; $referees->referee_name = $referee_info->referee_name; $referees->referees_id = $referee_info->referees_id; if (!$referees->sendRefereeMail()) { $mail_error .= "Mail not sent to " . $referees->referee_email . "<br>"; } } if ($mail_error == '') { echo '<h4 class="alert alert-success">Success</h4>'; echo '<hr>'; echo "Referee mails for applicant with email: <font color='#FF0000'>'" . $email . "'</font> has been successfully sent"; echo '<br>'; echo 'Use the Close Button to Continue'; } else { echo '<h4 class="alert alert-error">Error</h4>'; echo '<hr>'; echo $mail_error; echo 'Use the Close Button to Continue'; }
echo '<a href="application_form.php" class="btn">Close</a>'; } else { $user->progress = 'Completed'; $user->db_fields = array('progress'); $user->applicant_id = $session->applicant_id; $referees = new Referees(); $referees_details = $referees->find_by_sql("SELECT * FROM referees WHERE applicant_id='" . $session->applicant_id . "'"); $mail_error = ''; $applicant_name = User::find_by_sql("SELECT * FROM personal_details WHERE applicant_id=" . $session->applicant_id); $applicant_name = array_shift($applicant_name); $applicant_name = $applicant_name->surname . ' ' . $applicant_name->first_name . ' ' . $applicant_name->middle_name; foreach ($referees_details as $referee_info) { $referees->referee_email = $referee_info->referee_email; $referees->referee_name = $referee_info->referee_name; $referees->referees_id = $referee_info->referees_id; if (!$referees->sendRefereeMail($applicant_name)) { $mail_error .= "Mail not sent to " . $referees->referee_email . "<br>"; } } if ($user->save()) { $admissions = new Admission(); $sql_adm = "select admission_id from admission_status where applicant_id='" . $session->applicant_id . "'"; $res_adm = Admission::find_by_sql($sql_adm); if (empty($res_adm)) { $academic_session = $session_sql['session']; $admissions->applicant_id = $session->applicant_id; $admissions->time_completed_application = time(); $admissions->academic_session = $academic_session; $admissions->status = 1; $admissions->save(); }