} $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()) {