$is_free_replacement = false; $previous_referral = '0'; $previous_invoice = '0'; // 1. Update the referral to employed $query = "SELECT referrals.employer_agreed_terms_on, \n referrals.member, referrals.referee, jobs.title \n FROM referrals \n LEFT JOIN jobs ON jobs.id = referrals.job \n WHERE referrals.id = " . $_POST['id']; $not_agreed_terms_yet = false; $mysqli = Database::connect(); $result = $mysqli->query($query); if (empty($result[0]['employer_agreed_terms_on']) || is_null($result[0]['employer_agreed_terms_on'])) { $not_agreed_terms_yet = true; } $member = new Member($result[0]['member']); $referee = new Member($result[0]['referee']); $job_title = $result[0]['title']; $irc_id = $member->is_IRC() ? $member->id() : NULL; $total_reward = Referral::calculate_total_reward_from($_POST['salary'], $_POST['employer'], $irc_id); $total_token_reward = $total_reward * 0.3; $total_reward_to_referrer = $total_reward - $total_token_reward; $data = array(); $data['id'] = $_POST['id']; $data['employed_on'] = now(); $data['work_commence_on'] = $_POST['commence']; $data['salary_per_annum'] = $_POST['salary']; $data['total_reward'] = $total_reward_to_referrer; $data['total_token_reward'] = $total_token_reward; $data['used_suggested'] = $_POST['used_suggested']; $data['guarantee_expire_on'] = Referral::get_guarantee_expiry_date_from($_POST['salary'], $_POST['employer'], $today); if ($not_agreed_terms_yet) { $data['employer_agreed_terms_on'] = $data['employed_on']; } // 1.1 Check whether the reward is 0.00 or NULL. If it is, then the employer account is not ready.