$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 {