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'];
