$data['resume'] = $_POST['resume'];
$data['referee_acknowledged_on'] = $_POST['requested_on'];
$query = "SELECT referrer_read_resume_on FROM referral_requests WHERE id = " . $_POST['request_id'] . " LIMIT 1";
$result = $mysqli->query($query);
$data['member_read_resume_on'] = $result[0]['referrer_read_resume_on'];
$referral_id = Referral::create($data);
if ($referral_id === false || $referral_id <= 0) {
echo 'ko';
exit;
}
if (!Referral::close_similar_referrals_with_id($referral_id)) {
echo 'ko';
exit;
}
} elseif (isset($_POST['referral_id'])) {
if (Referral::update($data) !== false) {
if (!Referral::close_similar_referrals_with_id($referral_id)) {
echo 'ko';
exit;
}
} else {
echo 'ko';
exit;
}
} else {
if (!Referral::create_multiple($data)) {
echo 'ko';
exit;
}
}
$positions = '';
exit;
}
foreach ($result as $i => $row) {
$result[$i]['padded_invoice'] = pad($row['invoice'], 11, '0');
}
$response = array('replacements' => array('replacement' => $result));
header('Content-type: text/xml');
echo $xml_dom->get_xml_from_array($response);
exit;
}
if ($_POST['action'] == 'authorize_replacement') {
$today = now();
$data = array();
$data['id'] = $_POST['id'];
$data['replacement_authorized_on'] = $today;
if (!Referral::update($data)) {
echo 'ko';
exit;
}
$query = "SELECT job FROM referrals WHERE id = " . $_POST['id'] . " LIMIT 1";
$mysqli = Database::connect();
$result = $mysqli->query($query);
$data = array();
$data['expire_on'] = sql_date_add($today, 30, 'day');
$data['closed'] = 'N';
$data['for_replacement'] = 'Y';
$job = new Job($result[0]['job']);
if (!$job->update($data)) {
echo 'ko';
exit;
}
if ($current_app['job_id'] == $result[$j]['job_id']) {
if ($current_app['tab'] == 'ref') {
$skips[] = $j;
} else {
$skips[] = $i;
}
}
}
}
}
if (!in_array($i, $skips)) {
$filter_apps[] = $current_app;
}
}
$result = $filter_apps;
$response = array('applications' => array('application' => $result));
header('Content-type: text/xml');
echo $xml_dom->get_xml_from_array($response);
exit;
}
if ($_POST['action'] == 'confirm_employment') {
$referral = new Referral($_POST['id']);
$data = array();
$data['referee_confirmed_hired_on'] = now();
if ($referral->update($data) === false) {
echo 'ko';
exit;
}
echo 'ok';
exit;
}
$data['referred_on'] = $timestamp;
$data['referee_acknowledged_on'] = $timestamp;
$data['member_confirmed_on'] = $timestamp;
$data['member_read_resume_on'] = $timestamp;
$data['job'] = 0;
foreach ($job_ids as $job) {
$data['job'] = $job;
if ($referral->create($data) === false) {
$criteria = array("columns" => "id", "match" => "member = '" . $member . "' AND \n referee = '" . $referee . "' AND \n job = " . $job, "limit" => "1");
$result = $referral->find($criteria);
if (is_null($result) || count($result) <= 0 || $result === false) {
$failed_jobs[] = $job;
continue;
}
$existing_referral = new Referral($result[0]['id']);
if ($existing_referral->update($data) === false) {
$failed_jobs[] = $job;
}
}
}
if (!empty($failed_jobs) && count($failed_jobs) > 0) {
$criteria = array("columns" => "jobs.id, jobs.title, employers.id, employers.name AS employer, \n jobs.expire_on", "joins" => "employers ON employers.id = jobs.employer", "match" => "jobs.id IN (" . implode(',', $failed_jobs) . ")");
$job = new Job();
$result = $job->find($criteria);
header('Content-type: text/xml');
echo $xml_dom->get_xml_from_array(array('failed_jobs' => array('job' => $result)));
exit;
}
// put new non-applied jobs into member_jobs too
// 1. get the job IDs not in member_jobs
// 1.1 Get the job IDs in member_jobs using the IN() clause
$data['referee_acknowledged_on'] = now();
$data['resume'] = 103;
if ($referral->update($data) !== false) {
print_array($referral->get());
} else {
echo "failed";
exit;
}
?>
</p><p style="font-weight: bold;">Employer decides to shortlist referral 3... </p><p><?php
$referral = new Referral($ref_3);
$data = array();
$data['employer_agreed_terms_on'] = now();
// This should be done before the shortlisting.
$data['shortlisted_on'] = now();
if ($referral->update($data) !== false) {
print_array($referral->get());
} else {
echo "failed";
exit;
}
?>
</p><p style="font-weight: bold;">Employer decides to employ referral 3... </p><p><?php
$data = array();
$data['employed_on'] = now();
$data['work_commence_on'] = today();
$data['salary_per_annum'] = 36000.0;
$data['total_reward'] = $referral->calculateRewardFrom($data['salary_per_annum']);
if ($referral->update($data)) {
print_array($referral->get());
} else {
