function parse_candidates($_xml_str) { if (empty($_xml_str)) { return null; } $candidates = array(); $dom = new XMLDOM(); $xml_dom = $dom->load_from_xml($_xml_str); if (!empty($xml_dom)) { $tags = array('email_addr', 'phone_num', 'name', 'social', 'current_position', 'current_employer'); $candidates = $dom->get_assoc($tags); foreach ($candidates as $i => $candidate) { $candidates[$i]['name'] = sanitize(stripslashes($candidate['name'])); $candidates[$i]['current_position'] = sanitize(stripslashes($candidate['current_position'])); $candidates[$i]['current_employer'] = sanitize(stripslashes($candidate['current_employer'])); if (is_null($candidate['social']) || empty($candidate['social'])) { $candidates[$i]['social'] = 'NULL'; } else { $candidates[$i]['social'] = strtolower($candidate['social']); } } } return $candidates; }
<?php require_once dirname(__FILE__) . "/../../private/lib/utilities.php"; header('Content-type: text/xml'); $xml_dom = new XMLDOM(); $response = array(); $result = array(); $result = Job::find(array('columns' => 'employers.id, employers.name', 'joins' => 'employers ON employers.id = jobs.employer', 'match' => 'employers.active = \'Y\' AND jobs.closed = \'N\' AND jobs.expire_on >= NOW()', 'group' => 'employers.id', 'order' => 'employers.name')); $i = 0; foreach ($result as $row) { $response[$i]['id'] = $row['id']; $response[$i]['name'] = $row['name']; $i++; } $xml_array = array('employers' => array('employer' => $response)); echo $xml_dom->get_xml_from_array($xml_array);
} if (!isset($_SESSION['yel']['member']) || empty($_SESSION['yel']['member']['id']) || empty($_SESSION['yel']['member']['sid']) || empty($_SESSION['yel']['member']['hash'])) { echo "An illegal attempt to view resume has been detected."; exit; } $resume = new Resume(0, $_GET['id']); $cover = $resume->get(); if (!is_null($cover[0]['file_name'])) { $file = $resume->get_file(); header('Content-length: ' . $file['size']); header('Content-type: ' . $file['type']); header('Content-Disposition: attachment; filename="' . $file['name'] . '"'); readfile($GLOBALS['resume_dir'] . "/" . $_GET['id'] . "." . $file['hash']); exit; } $xml_dom = new XMLDOM(); $member = new Member($cover[0]['member']); $contacts = $member->get(); $experiences = $resume->get_work_experiences(); $educations = $resume->get_educations(); $skills = $resume->get_skills(); $technical_skills = $resume->get_technical_skills(); $resume_data = array(); $resume_data['resume']['_ATTRS'] = array('candidate' => $member->get_name()); $resume_data['resume']['DISCLAIMER_NOTE'] = 'Generated from YellowElevator.com. Resume Terms of Use subjected.'; $resume_data['resume']['contacts']['telephone_number'] = $contacts[0]['phone_num']; $resume_data['resume']['contacts']['email_address'] = $contacts[0]['email_addr']; $resume_data['resume']['contacts']['address'] = $contacts[0]['address']; $resume_data['resume']['contacts']['state'] = $contacts[0]['state']; $resume_data['resume']['contacts']['country'] = Country::getCountryFrom($contacts[0]['country']); $resume_data['resume']['work_experiences'] = array();
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; // if ($GLOBALS['protocol'] == 'https') { // if (empty($_SERVER['HTTPS']) || $_SERVER['HTTPS'] == 'off') { // redirect_to('https://'. $GLOBALS['root']. '/resumes/get.php'); // exit(); // } // } $xml_dom = new XMLDOM(); $mysqli = Database::connect(); // 1. get all the resume IDs which are needs re-indexing $query = "SELECT id, file_hash FROM resumes \n WHERE needs_indexing = TRUE AND \n file_type = 'application/msword' AND \n deleted = 'N'"; $result = $mysqli->query($query); if ($result === false) { echo 'ko'; exit; } if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } // 2. put them into array for XML parsing $response = array(); foreach ($result as $i => $row) { $resume = array('id' => $row['id'], 'hash' => $row['file_hash']); $response['resume'][] = $resume; } // 3. return header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('resumes' => $response));
/** * Returns the MySQL error stored in the $mysql_error array in XML string. * @return String Returns mysql_error in XML format. * FORMAT: * <errors><errno>mysql_error['errno']</errno><error>mysql_error['error']</error></errors> */ public function error_in_xml() { $data = array('errors' => array('errno' => $this->mysql_error['errno'], 'error' => $this->mysql_error['error'])); $xml_dom = new XMLDOM(); return $xml_dom->get_xml_from_array($data); }
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); $order_by = 'member_saved_jobs.saved_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } if (!isset($_POST['action'])) { $member = new Member($_POST['id'], $_SESSION['yel']['member']['sid']); $result = $member->get_saved_jobs($order_by); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit; } foreach ($result as $key => $row) { $result[$key]['description'] = htmlspecialchars_decode($row['description']); $result[$key]['potential_reward'] = number_format($row['potential_reward'], 2, '.', ', '); } header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('saved_jobs' => array('saved_job' => $result)));
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); $filter_by = '0'; if (isset($_POST['filter_by'])) { $filter_by = $_POST['filter_by']; } if ($_POST['action'] == 'get_networks') { $member = new Member($_POST['member'], $_SESSION['yel']['member']['sid']); $networks = $member->get_networks(); $response = array('networks' => array('network' => $networks)); header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array($response); exit; } if ($_POST['action'] == 'get_candidates') { $member = new Member($_POST['id'], $_SESSION['yel']['member']['sid']); $result = $member->get_referees("member_referees.referred_on DESC", $filter_by); foreach ($result as $key => $row) { $result[$key]['networks'] = ''; } $networks = $member->get_networks(); $mysqli = Database::connect(); foreach ($networks as $network) {
// $file_name .= '.'. generate_random_string_of(6). '.txt'; // } // $handle = fopen($file_name, 'w'); // fwrite($handle, 'Header: '. $headers. "\n\n"); // fwrite($handle, 'Subject: '. $subject. "\n\n"); // fwrite($handle, $message); // fclose($handle); return true; } if (!isset($_POST['id'])) { redirect_to('members.php'); } if (!isset($_POST['action'])) { redirect_to('members.php'); } $xml_dom = new XMLDOM(); if ($_POST['action'] == 'get_jobs') { $employer_ids = explode(',', $_POST['employer_ids']); if (count($employer_ids) > 0) { foreach ($employer_ids as $i => $id) { $employer_ids[$i] = trim($id); } } else { echo '0'; exit; } $employers = ''; $j = 0; foreach ($employer_ids as $i => $id) { $employers .= "'" . $id . "'"; if ($j < count($employer_ids) - 1) {
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'recommenders.added_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $query = "SELECT recommenders.email_addr, recommenders.phone_num, recommenders.remarks, recommenders.region, \n CONCAT(recommenders.firstname, ', ', recommenders.lastname) AS recommender_name, \n DATE_FORMAT(recommenders.added_on, '%e %b, %Y') AS formatted_added_on \n FROM recommenders \n LEFT JOIN employees ON employees.id = recommenders.added_by "; if ($_POST['filter_by'] == '0') { $query .= "WHERE employees.branch = " . $_SESSION['yel']['employee']['branch']['id']; } else { $query .= "LEFT JOIN recommender_industries ON recommender_industries.recommender = recommenders.email_addr \n WHERE employees.branch = " . $_SESSION['yel']['employee']['branch']['id'] . " AND \n recommender_industries.industry = " . $_POST['filter_by']; } $query .= " AND recommenders.email_addr NOT LIKE '*****@*****.**' \n ORDER BY " . $_POST['order_by']; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit;
<?php require_once "../private/lib/utilities.php"; $xml_seed = new XMLDOM(); $xml_seed->load_from_uri("http://localhost/yel2/members/seed.php"); $data = $xml_seed->get_assoc(array('id', 'seed')); $sid = $data[0]['id']; $seed = $data[0]['seed']; $uid = '*****@*****.**'; $password = '******'; $hash = sha1($uid . md5($password) . $seed); echo $sid . ": " . $seed . "<br>"; echo $hash . "<br>"; ?> <p style="font-weight: bold;">Logging in... </p><p><?php $member = new Member($uid, $sid); if ($member->is_registered($hash)) { if ($member->session_set($hash)) { echo "Success"; } } if (!$member->is_logged_in($hash)) { echo "failed"; exit; } ?> </p>
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo 'ko'; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'bank asc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $query = "SELECT * FROM member_banks \n WHERE member = '" . $_POST['id'] . "' AND \n in_used = 'Y' \n ORDER BY " . $order_by; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit; } header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('bank_accounts' => array('bank_account' => $result))); exit; } if ($_POST['action'] == 'save_bank') {
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'members.joined_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $filter = ''; if (isset($_POST['filter_by'])) { if (!empty($_POST['filter_by']) && $_POST['filter_by'] > 0) { $filter = $_POST['filter_by']; } } $filter_country = ''; if (isset($_POST['filter_country_by'])) { if (!empty($_POST['filter_country_by'])) { $filter_country = $_POST['filter_country_by']; } } $filter_zip = ''; if (isset($_POST['filter_zip_by'])) { if (!empty($_POST['filter_zip_by'])) { $filter_zip = $_POST['filter_zip_by'];
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $member = new Member($_POST['referee']); $response = array('resume' => $member->get()); header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array($response); exit; } if ($_POST['action'] == 'delete') { if (!isset($_POST['payload'])) { echo "ko"; exit; } $member = new Member($_POST['member'], $_SESSION['yel']['member']['sid']); $xml_dom->load_from_xml($_POST['payload']); $referees = $xml_dom->get('id'); foreach ($referees as $id) { if (!$member->delete_referee($id->nodeValue)) { echo "ko"; exit; } }
<?php require_once "../private/lib/utilities.php"; $xml_seed = new XMLDOM(); $xml_seed->load_from_uri("http://" . $GLOBALS['root'] . "/members/seed.php"); $data = $xml_seed->get_assoc(array('id', 'seed')); $sid = $data[0]['id']; $seed = $data[0]['seed']; $uid = '*****@*****.**'; $password = '******'; $hash = sha1($uid . md5($password) . $seed); ?> <b>Logging in...</b><br><br><?php echo $sid . ": " . $seed . "<br>"; echo $hash . "<br>"; $member = new Member($uid, $sid); if ($member->is_registered($hash)) { if ($member->session_set($hash)) { echo "Success<br>"; } } if (!$member->is_logged_in($hash)) { echo "failed<br>"; exit; } echo "<br>"; ?> <b>Creating a new resume...</b><br><br><?php $resume = new Resume($uid); $first_resume = 0; $second_resume = 0;
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { redirect_to('status.php'); } if (!isset($_POST['action'])) { redirect_to('status.php'); } $xml_dom = new XMLDOM(); if ($_POST['action'] == 'get_applications') { $page_limit = $GLOBALS['default_results_per_page'] + 10; $period = explode(';', $_POST['period']); $match = "referrals.referred_on BETWEEN '" . $period[0] . "' AND '" . $period[1] . "' "; if (!empty($_POST['filter'])) { switch ($_POST['filter']) { case 'employed': $match = "referrals.employed_on BETWEEN '" . $period[0] . "' AND '" . $period[1] . "' AND \n (referrals.employed_on IS NOT NULL AND referrals.employed_on <> '0000-00-00') AND \n (referrals.employer_rejected_on IS NULL OR referrals.employer_rejected_on = '0000-00-00') AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00')"; break; case 'rejected': $match = "referrals.employer_rejected_on BETWEEN '" . $period[0] . "' AND '" . $period[1] . "' AND \n (referrals.employer_rejected_on IS NOT NULL AND referrals.employer_rejected_on <> '0000-00-00')"; break; case 'removed': $match = "referrals.employer_deleted_on BETWEEN '" . $period[0] . "' AND '" . $period[1] . "' AND \n (referrals.employer_removed_on IS NOT NULL AND referrals.employer_removed_on <> '0000-00-00')"; break; case 'viewed': $match = "referrals.employer_agreed_terms_on BETWEEN '" . $period[0] . "' AND '" . $period[1] . "' AND \n (referrals.employer_agreed_terms_on IS NOT NULL AND referrals.employer_agreed_terms_on <> '0000-00-00') AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00') AND \n (referrals.employer_rejected_on IS NULL OR referrals.employer_rejected_on = '0000-00-00') AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00')"; break; case 'not_viewed': $match .= "AND (referrals.employer_agreed_terms_on IS NULL OR referrals.employer_agreed_terms_on = '0000-00-00') AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00') AND \n (referrals.employer_rejected_on IS NULL OR referrals.employer_rejected_on = '0000-00-00') AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00')";
$order_by = 'referred_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $query = "SELECT referrals.id, resumes.file_hash, resumes.name AS resume_name, referrals.resume AS resume_id, \n members.email_addr AS candidate_email_addr, \n members.phone_num AS candidate_phone_num, \n CONCAT(members.lastname, ', ', members.firstname) AS candidate_name, \n referrers.email_addr AS referrer_email_addr, \n referrers.phone_num AS referrer_phone_num, \n CONCAT(referrers.lastname, ', ', referrers.firstname) AS referrer_name, \n DATE_FORMAT(referrals.referred_on, '%e %b, %Y') AS formatted_referred_on, \n DATE_FORMAT(referrals.member_confirmed_on, '%e %b, %Y') AS formatted_confirmed_on, \n DATE_FORMAT(referrals.employer_agreed_terms_on, '%e %b, %Y') AS formatted_employer_viewed_on \n FROM referrals \n LEFT JOIN resumes ON resumes.id = referrals.resume \n LEFT JOIN members ON members.email_addr = referrals.referee \n LEFT JOIN members AS referrers ON referrers.email_addr = referrals.member \n WHERE referrals.job = " . $_POST['id'] . " AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00 00:00:00') AND \n (referrals.referee_acknowledged_on IS NOT NULL AND referrals.referee_acknowledged_on <> '0000-00-00 00:00:00') \n ORDER BY " . $order_by; $mysqli = Database::connect(); $result = $mysqli->query($query); $response = array('referrals' => array('referral' => $result)); $xml_dom = new XMLDOM(); header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array($response); exit; } if ($_POST['action'] == 'get_employer_name') { $query = "SELECT name FROM employers WHERE id = '" . $_POST['id'] . "' LIMIT 1"; $mysqli = Database::connect(); $result = $mysqli->query($query); $xml_dom = new XMLDOM(); header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('employer' => array('name' => $result[0]['name']))); exit; } if ($_POST['action'] == 'get_job_title') { $query = "SELECT title FROM jobs WHERE id = " . $_POST['id'] . " LIMIT 1"; $mysqli = Database::connect(); $result = $mysqli->query($query); $xml_dom = new XMLDOM(); header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('job' => array('title' => $result[0]['title']))); exit; }
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); session_start(); if (!isset($_POST['id'])) { redirect_to('rewards.php'); } if (!isset($_POST['action'])) { redirect_to('rewards.php'); } $xml_dom = new XMLDOM(); function get_rewards($_is_paid = false, $_order_by) { $criteria = array('columns' => "invoices.id AS invoice, referrals.id AS referral, referrals.total_reward,\n referrals.job AS job_id, currencies.symbol AS currency, jobs.title, \n referrals.member AS member_id, referrals.employed_on, \n employers.name AS employer, members.phone_num, \n CONCAT(members.lastname, ', ', members.firstname) AS member, \n DATE_FORMAT(referrals.employed_on, '%e %b, %Y') AS formatted_employed_on, \n (SUM(referral_rewards.reward) / 3) AS paid_reward", 'joins' => "invoice_items ON invoice_items.item = referrals.id, \n invoices ON invoices.id = invoice_items.invoice, \n referral_rewards ON referral_rewards.referral = referrals.id, \n jobs ON jobs.id = referrals.job, \n members ON members.email_addr = referrals.member, \n employers ON employers.id = jobs.employer, \n currencies ON currencies.country_code = employers.country", 'match' => "invoices.type = 'R' AND \n (invoices.paid_on IS NOT NULL AND invoices.paid_on <> '0000-00-00 00:00:00') AND \n (referrals.employed_on IS NOT NULL AND referrals.employed_on <> '0000-00-00 00:00:00') AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00 00:00:00') AND \n (referrals.referee_rejected_on IS NULL OR referrals.referee_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') AND \n (referrals.guarantee_expire_on <= CURDATE() OR referrals.guarantee_expire_on IS NULL) ", 'group' => "referrals.id", 'order' => $_order_by, 'having' => "(paid_reward < referrals.total_reward OR paid_reward IS NULL)"); if ($_is_paid) { $criteria['columns'] .= ", referral_rewards.gift, DATE_FORMAT(MAX(referral_rewards.paid_on), '%e %b, %Y') AS formatted_paid_on"; $criteria['having'] = "(paid_reward >= referrals.total_reward OR referral_rewards.gift IS NOT NULL)"; } else { $criteria['match'] .= "AND (referral_rewards.gift IS NULL OR referral_rewards.gift = '')"; } $referral = new Referral(); return $referral->find($criteria); } if ($_POST['action'] == 'get_new_rewards') { $order_by = 'referrals.employed_on ASC'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $rewards = get_rewards(false, $order_by); if (count($rewards) <= 0 || is_null($rewards)) {
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'prvileged_referral_buffers.referred_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $employee = new Employee($_POST['id']); $branch = $employee->get_branch(); $member = 'team.' . strtolower($branch[0]['country_code']) . '@yellowelevator.com'; $query = "SELECT jobs.id, jobs.title, employers.name AS employer, industries.industry, \n members.email_addr AS candidate_email, members.phone_num, \n resumes.name AS resume, privileged_referral_buffers.resume AS resume_id, \n CONCAT(members.firstname, ', ', members.lastname) AS candidate, \n DATE_FORMAT(privileged_referral_buffers.referred_on, '%e %b, %Y') AS formatted_referred_on \n FROM privileged_referral_buffers \n LEFT JOIN jobs ON jobs.id = privileged_referral_buffers.job \n LEFT JOIN members ON members.email_addr = privileged_referral_buffers.referee \n LEFT JOIN employers ON employers.id = jobs.employer \n LEFT JOIN industries ON industries.id = jobs.industry \n LEFT JOIN resumes ON resumes.id = privileged_referral_buffers.resume \n WHERE privileged_referral_buffers.member = '" . $member . "' \n ORDER BY " . $_POST['order_by']; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit; } foreach ($result as $i => $row) { $result[$i]['candidate'] = htmlspecialchars_decode($row['candidate']);
} return $_text; } function remove_stop_words($_keywords) { $out = array(); $stop_words = $GLOBALS['stopWords']; $words = explode(' ', $_keywords); foreach ($words as $word) { if (!in_array($word, $stop_words)) { $out[] = $word; } } return implode(' ', $out); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $resume_search = new ResumeSearch(); $criteria = array(); $criteria['order_by'] = 'relevance desc'; $criteria['industry'] = 0; $criteria['country_code'] = ''; $criteria['limit'] = $GLOBALS['default_results_per_page']; $criteria['offset'] = 0; $criteria['keywords'] = $_POST['keywords']; // $criteria['use_exact'] = (isset($_POST['use_exact'])) ? true : false; $criteria['use_mode'] = $_POST['use_mode']; $_SESSION['yel']['prs']['resume_search']['criteria'] = array(); $_SESSION['yel']['prs']['resume_search']['criteria']['order_by'] = 'relevance desc'; $_SESSION['yel']['prs']['resume_search']['criteria']['industry'] = 0; $_SESSION['yel']['prs']['resume_search']['criteria']['country_code'] = '';
<?php require_once "../../private/lib/utilities.php"; $xml_dom = new XMLDOM(); echo "Attributes test: <br><br>"; if ($xml_dom->load_from_uri(dirname(__FILE__) . "/text.xml")) { $properties = $xml_dom->get("property"); $propertys = array(); foreach ($properties as $property) { $key = ""; foreach ($property->attributes as $attribute) { switch ($attribute->name) { case "key": $key = $attribute->value; break; default: if (!empty($key)) { $propertys[$key][$attribute->name] = $attribute->value; } break; } } } echo "<pre>"; print_r($propertys); echo "</pre>"; } else { echo "failed"; } echo "<br><br>"; echo "Elements test: <br><br>";
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { redirect_to('member.php'); } if (!isset($_POST['action'])) { redirect_to('member.php'); } $xml_dom = new XMLDOM(); if ($_POST['action'] == 'save_profile') { $today = now(); $mode = 'update'; if ($_POST['id'] == '0') { $mode = 'create'; } $employee = new Employee($_POST['employee']); $branch = $employee->getBranch(); $data = array(); $data['firstname'] = $_POST['firstname']; $data['lastname'] = $_POST['lastname']; $data['phone_num'] = $_POST['phone_num']; $data['address'] = $_POST['address']; $data['state'] = $_POST['state']; $data['zip'] = $_POST['zip']; $data['country'] = $_POST['country']; $data['citizenship'] = $_POST['citizenship']; $data['hrm_gender'] = $_POST['hrm_gender']; $data['hrm_ethnicity'] = $_POST['hrm_ethnicity']; $data['hrm_birthdate'] = $_POST['hrm_birthdate'];
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'employed_on ASC'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $query = "SELECT referrals.id AS referral, currencies.symbol AS currency, referrals.total_token_reward, \n jobs.title, employers.name AS employer, \n referrals.referee AS candidate_id, referrals.employed_on, \n CONCAT(members.lastname, ', ', members.firstname) AS candidate, \n DATE_FORMAT(referrals.employed_on, '%e %b, %Y') AS formatted_employed_on, \n DATE_FORMAT(referrals.referee_confirmed_hired_on, '%e %b, %Y') AS formatted_referee_confirmed_on \n FROM referrals \n LEFT JOIN referral_token_rewards ON referral_token_rewards.referral = referrals.id \n LEFT JOIN jobs ON jobs.id = referrals.job \n LEFT JOIN members ON members.email_addr = referrals.member \n LEFT JOIN employers ON employers.id = jobs.employer \n LEFT JOIN currencies ON currencies.country_code = employers.country \n LEFT JOIN employees ON employers.registered_by = employees.id \n WHERE (referral_token_rewards.paid_on IS NULL OR referral_token_rewards.paid_on = '0000-00-00 00:00:00') AND \n (referrals.employed_on IS NOT NULL AND referrals.employed_on <> '0000-00-00 00:00:00') AND \n (referrals.member_confirmed_on IS NOT NULL AND referrals.member_confirmed_on <> '0000-00-00 00:00:00') AND \n (referrals.total_token_reward IS NOT NULL AND referrals.total_token_reward > 0) AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00 00:00:00') AND \n (referrals.referee_rejected_on IS NULL OR referrals.referee_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') AND \n (referrals.guarantee_expire_on <= CURDATE() OR referrals.guarantee_expire_on IS NULL) AND \n employees.branch = " . $_SESSION['yel']['employee']['branch']['id'] . " AND \n referrals.id NOT IN (SELECT referral FROM referral_token_rewards) \n GROUP BY referrals.id \n ORDER BY " . $order_by; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit; } $i = 0; $rewards = array(); foreach ($result as $row) { $paid = ReferralReward::get_sum_paid_of_referral($row['referral']); if ($paid[0]['amount'] <= 0 || is_null($paid)) {
// Strip newline characters. $_description = str_replace(chr(10), " ", $_description); $_description = str_replace(chr(13), " ", $_description); // Replace single quotes. $_description = str_replace(chr(145), chr(39), $_description); $_description = str_replace(chr(146), chr(39), $_description); // Return the result. return $_description; } session_start(); if (!isset($_POST['job'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $criteria = array('columns' => 'jobs.*, countries.country AS country_name, industries.industry AS full_industry, employers.contact_person, employers.email_addr, DATE_FORMAT(jobs.created_on, \'%e %b, %Y %k:%i:%s\') AS formatted_created_on, DATE_FORMAT(jobs.expire_on, \'%e %b, %Y %k:%i:%s\') AS formatted_expire_on, DATEDIFF(NOW(), jobs.expire_on) AS expired', 'joins' => 'industries ON industries.id = jobs.industry, countries ON countries.country_code = jobs.country, employers ON employers.id = jobs.employer', 'match' => 'jobs.id = \'' . $_POST['job'] . '\''); $jobs = Job::find($criteria); $job = array(); foreach ($jobs[0] as $key => $value) { $job[$key] = $value; if ($key == 'description') { $job[$key] = htmlspecialchars_decode(html_entity_decode(desanitize($value))); $job[$key] = replace_characters($job[$key]);
if ($_referral_id_only) { $columns = "referrals.id"; } $query = "SELECT " . $columns . " \n FROM resume_index \n LEFT JOIN referrals ON referrals.resume = resume_index.resume \n LEFT JOIN members ON members.email_addr = referrals.member \n LEFT JOIN members AS referees ON referees.email_addr = referrals.referee \n , " . $max_score_temp_table . "\n WHERE " . $match_against . " AND \n referrals.job = " . $_POST['id'] . " AND \n need_approval = 'N' AND \n -- referrals.resume IN (" . $non_file_resumes_list . ") AND\n (referrals.referee_acknowledged_on IS NOT NULL AND referrals.referee_acknowledged_on <> '0000-00-00 00:00:00') AND \n (referrals.member_confirmed_on IS NOT NULL AND referrals.member_confirmed_on <> '0000-00-00 00:00:00') AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00 00:00:00') AND \n referrals.employer_removed_on IS NULL AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00')"; if (!$_referral_id_only) { $query .= " ORDER BY " . $order_by; } $result = $mysqli->query($query); return $result; } if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'num_referrals desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $today = now(); //$today = '0000-00-00 00:00:00'; // use this to temporarily bypass the date $query = "SELECT industries.industry, jobs.id, jobs.title, jobs.created_on, \n jobs.expire_on, COUNT(referrals.id) AS num_referrals, jobs.description \n FROM referrals \n LEFT JOIN jobs ON jobs.id = referrals.job \n LEFT JOIN industries ON industries.id = jobs.industry \n WHERE jobs.employer = '" . $_POST['id'] . "' AND \n need_approval = 'N' AND \n (referrals.referee_acknowledged_on IS NOT NULL AND referrals.referee_acknowledged_on <> '0000-00-00 00:00:00') AND \n (referrals.member_confirmed_on IS NOT NULL AND referrals.member_confirmed_on <> '0000-00-00 00:00:00') AND \n -- (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00 00:00:00') AND \n referrals.employer_removed_on IS NULL AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00')\n GROUP BY referrals.job \n ORDER BY " . $order_by; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) {
<?php require_once dirname(__FILE__) . "/../../private/lib/utilities.php"; session_start(); $xml_dom = new XMLDOM(); $counts = array(); $query = "SELECT COUNT(referrals.id) AS num_responses \n FROM referrals \n LEFT JOIN jobs ON jobs.id = referrals.job \n LEFT JOIN member_referees ON member_referees.member = referrals.member AND \n member_referees.referee = referrals.referee \n WHERE referrals.member = '" . $_SESSION['yel']['member']['id'] . "' AND \n member_referees.member = '" . $_SESSION['yel']['member']['id'] . "' AND \n referrals.response_counted = false AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00 00:00:00') AND \n (referrals.work_commence_on IS NULL OR referrals.work_commence_on = '0000-00-00 00:00:00') AND \n (referrals.referee_acknowledged_on IS NOT NULL AND referrals.referee_acknowledged_on <> '0000-00-00 00:00:00') AND \n (referrals.referee_rejected_on IS NULL OR referrals.referee_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.member_rejected_on IS NULL OR referrals.member_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') AND \n (referrals.employer_agreed_terms_on IS NULL OR referrals.employer_agreed_terms_on = '0000-00-00 00:00:00') \n AND jobs.closed = 'N' AND jobs.expire_on >= NOW()"; $mysqli = Database::connect(); $result = $mysqli->query($query); if (!count($result) <= 0 && !is_null($result)) { $counts['num_responses'] = $result[0]['num_responses']; } else { $counts['num_responses'] = '0'; } $query = "SELECT COUNT(referrals.id) AS num_views \n FROM referrals \n LEFT JOIN jobs ON jobs.id = referrals.job \n LEFT JOIN member_referees ON member_referees.member = referrals.member AND \n member_referees.referee = referrals.referee \n WHERE referrals.member = '" . $_SESSION['yel']['member']['id'] . "' AND \n member_referees.member = '" . $_SESSION['yel']['member']['id'] . "' AND \n referrals.view_counted = false AND \n (referrals.employed_on IS NULL OR referrals.employed_on = '0000-00-00 00:00:00') AND \n (referrals.work_commence_on IS NULL OR referrals.work_commence_on = '0000-00-00 00:00:00') AND \n (referrals.referee_acknowledged_on IS NOT NULL AND referrals.referee_acknowledged_on <> '0000-00-00 00:00:00') AND \n (referrals.referee_rejected_on IS NULL OR referrals.referee_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.member_rejected_on IS NULL OR referrals.member_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.employer_rejected_on IS NULL OR referrals.employer_rejected_on = '0000-00-00 00:00:00') AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00 00:00:00') AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') AND \n (referrals.employer_agreed_terms_on IS NOT NULL AND referrals.employer_agreed_terms_on <> '0000-00-00 00:00:00') \n AND jobs.closed = 'N' AND jobs.expire_on >= NOW()"; $result = $mysqli->query($query); if (!count($result) <= 0 && !is_null($result)) { $counts['num_views'] = $result[0]['num_views']; } else { $counts['num_views'] = '0'; } $query = "SELECT COUNT(referrals.id) AS num_rewards \n FROM referrals \n LEFT JOIN jobs ON jobs.id = referrals.job \n LEFT JOIN member_referees ON member_referees.member = referrals.member AND \n member_referees.referee = referrals.referee \n WHERE referrals.member = '" . $_SESSION['yel']['member']['id'] . "' AND \n member_referees.member = '" . $_SESSION['yel']['member']['id'] . "' AND\n referrals.reward_counted = false AND \n (referrals.employer_removed_on IS NULL OR referrals.employer_removed_on = '0000-00-00 00:00:00') AND \n (referrals.employed_on IS NOT NULL AND referrals.employed_on <> '0000-00-00 00:00:00') AND \n (referrals.work_commence_on IS NOT NULL AND referrals.work_commence_on <> '0000-00-00 00:00:00') AND \n (referrals.replacement_authorized_on IS NULL OR referrals.replacement_authorized_on = '0000-00-00 00:00:00') \n AND jobs.closed = 'N' AND jobs.expire_on >= NOW()"; $result = $mysqli->query($query); if (!count($result) <= 0 && !is_null($result)) { $counts['num_rewards'] = $result[0]['num_rewards']; } else { $counts['num_rewards'] = '0'; } header('Content-type: text/xml'); echo $xml_dom->get_xml_from_array(array('counts' => $counts)); exit;
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; require_once dirname(__FILE__) . "/../private/config/job_profile.inc"; session_start(); date_default_timezone_set('Asia/Kuala_Lumpur'); if (!isset($_POST['id'])) { redirect_to('member.php'); } if (!isset($_POST['action'])) { redirect_to('member.php'); } $xml_dom = new XMLDOM(); if ($_POST['action'] == 'save_profile') { $today = now(); $mode = 'update'; if ($_POST['id'] == '0') { $mode = 'create'; } $employee = new Employee($_POST['employee']); $branch = $employee->getBranch(); if ($_POST['hrm_birthdate'] == '--') { $_POST['hrm_birthdate'] = ''; } $data = array(); $data['firstname'] = $_POST['firstname']; $data['lastname'] = $_POST['lastname']; $data['phone_num'] = $_POST['phone_num']; $data['address'] = $_POST['address']; $data['state'] = $_POST['state']; $data['zip'] = $_POST['zip'];
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; session_start(); if (!isset($_POST['id'])) { echo "ko"; exit; //redirect_to('login.php'); } $xml_dom = new XMLDOM(); if (!isset($_POST['action'])) { $order_by = 'purchased_on desc'; if (isset($_POST['order_by'])) { $order_by = $_POST['order_by']; } $query = "SELECT employer AS employer_id, employers.name AS employer, \n employer_slots_purchases.transaction_id, \n employer_slots_purchases.number_of_slot, \n employer_slots_purchases.price_per_slot, \n employer_slots_purchases.total_amount, \n employer_slots_purchases.on_hold, \n currencies.symbol AS currency, \n DATE_FORMAT(employer_slots_purchases.purchased_on, '%e %b, %Y') AS formatted_purchased_on \n FROM employer_slots_purchases \n INNER JOIN employers ON employers.id = employer_slots_purchases.employer \n INNER JOIN currencies ON currencies.country_code = employers.country \n INNER JOIN employees ON employers.registered_by = employees.id \n WHERE employees.branch = " . $_SESSION['yel']['employee']['branch']['id'] . " \n ORDER BY " . $_POST['order_by']; $mysqli = Database::connect(); $result = $mysqli->query($query); if (count($result) <= 0 || is_null($result)) { echo '0'; exit; } if (!$result) { echo 'ko'; exit; } foreach ($result as $i => $row) { $result[$i]['employer'] = htmlspecialchars_decode($row['employer']); } $response = array('purchases' => array('purchase' => $result)); header('Content-type: text/xml');
<?php require_once dirname(__FILE__) . "/../private/lib/utilities.php"; require_once dirname(__FILE__) . "/../private/config/job_profile.inc"; session_start(); $xml_dom = new XMLDOM(); if (!isset($_POST['id'])) { redirect_to('home.php'); } if (!isset($_POST['action'])) { redirect_to('home.php'); } if ($_POST['action'] == 'save_census_answers') { $data = array(); $data['hrm_gender'] = desanitize($_POST['gender']); $data['hrm_ethnicity'] = desanitize($_POST['ethnicity']); $data['hrm_birthdate'] = desanitize($_POST['birthdate']); $data['updated_on'] = date('Y-m-d'); $member = new Member($_POST['id']); if ($member->update($data) === false) { echo 'ko'; exit; } echo 'ok'; exit; } if ($_POST['action'] == 'save_career_summary') { $data = array(); $data['is_active_seeking_job'] = $_POST['is_active']; $data['contact_me_for_opportunities'] = $_POST['contact_me']; $data['seeking'] = $_POST['seeking'];