}
$buffer = $result[0];
// create recommender
$recommender = new Recommender($_POST['recommender_email']);
$query = "SELECT COUNT(*) AS id_used FROM recommenders WHERE email_addr = '" . $_POST['recommender_email'] . "'";
$result = $mysqli->query($query);
if ($result[0]['id_used'] == '0') {
$recommender_data = array();
$recommender_data['firstname'] = $buffer['referrer_firstname'];
$recommender_data['lastname'] = $buffer['referrer_lastname'];
$recommender_data['phone_num'] = $buffer['referrer_phone_num'];
$recommender_data['remarks'] = sanitize($_POST['recommender_remarks']);
$recommender_data['region'] = sanitize($_POST['recommender_region']);
$recommender_data['added_by'] = $_POST['id'];
$recommender_data['added_on'] = $joined_on;
if ($recommender->create($recommender_data)) {
$industries = explode(',', $_POST['recommender_industries']);
if (!empty($industries)) {
if (!$recommender->add_to_industries($industries)) {
$recommender_industries_adding_error = true;
}
}
} else {
echo '-2';
// failed to create new recommender
exit;
}
} else {
// update the industries
$industries = explode(',', $_POST['recommender_industries']);
if (!empty($industries)) {
$branch_data = $employee->get_branch();
$branch = 'team.' . strtolower($branch_data[0]['country_code']) . '@yellowelevator.com';
// 2. check whether is this branch already in the recommenders' table
$query = "SELECT COUNT(*) AS id_used FROM recommenders WHERE email_addr = '" . $branch . "'";
$result = $mysqli->query($query);
if ($result[0]['id_used'] == '0') {
// create it since not added
$recommender_data = array();
$recommender_data['firstname'] = 'Yellow';
$recommender_data['lastname'] = 'Elevator';
$recommender_data['phone_num'] = '0';
$recommender_data['region'] = $branch_data[0]['country'];
$recommender_data['added_by'] = $employee->id();
$recommender_data['added_on'] = $joined_on;
$recommender = new Recommender($branch);
if ($recommender->create($recommender_data) === false) {
echo '-1';
// failed to create new recommender
exit;
}
}
// 3. make the member privileged
// 3.1 check whether is the member active?
// if not, reset the password to the email and set flag to send email, and make member active.
// 3.2 make the recommender field to use the $branch
$send_password_reset_email = false;
$member_data = array();
$member_data['recommender'] = $branch;
$member_data['added_by'] = $employee->id();
$member = new Member($_POST['member']);
if (!$member->is_active()) {
