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