function __construct($job_id = false)
{
global $db;
if (is_numeric($job_id)) {
$sanitizer = new Sanitizer();
$sql = 'SELECT a.type_id AS type_id, a.category_id AS category_id, a.title AS title, a.summary AS summary,
a.description AS description, a.company AS company, a.url AS url, a.apply AS apply,
DATE_FORMAT(a.created_on, "' . DATE_FORMAT . '") AS created_on, a.created_on AS mysql_date,
a.is_temp AS is_temp, a.is_active AS is_active, a.spotlight AS spotlight,
a.views_count AS views_count, a.auth AS auth, a.city_id AS city_id, a.outside_location AS outside_location,
a.poster_email AS poster_email, a.apply_online AS apply_online, b.name AS category_name,
c.var_name as type_var_name, c.name as type_name,
DATE_ADD(created_on, INTERVAL 30 DAY) AS closed_on, DATEDIFF(NOW(), created_on) AS days_old, cit.name AS city_name
FROM ' . DB_PREFIX . 'jobs a LEFT JOIN ' . DB_PREFIX . 'cities cit on a.city_id = cit.id, ' . DB_PREFIX . 'categories b, ' . DB_PREFIX . 'types c
WHERE a.category_id = b.id AND c.id = a.type_id AND a.id = ' . $job_id;
$result = $db->query($sql);
$row = $result->fetch_assoc();
if (!empty($row)) {
$this->mId = $job_id;
$this->mTypeId = $row['type_id'];
$this->mCategoryId = $row['category_id'];
$this->mCategoryName = $row['category_name'];
$this->mTitle = str_replace('&', '&', $row['title']);
$this->mSummary = str_replace('&', '&', $row['summary']);
$this->mDescription = $row['description'];
$this->mCompany = $row['company'];
$this->mUrl = $row['url'];
$this->mApply = $row['apply'];
$this->mCreatedOn = $row['created_on'];
$this->mClosedOn = $row['closed_on'];
$this->mIsTemp = $row['is_temp'];
$this->mIsActive = $row['is_active'];
$this->mViewsCount = $row['views_count'];
$this->mAuth = $row['auth'];
$this->mCityId = $row['city_id'];
$this->mMySqlDate = $row['mysql_date'];
$this->mLocation = $this->GetLocation($row);
$this->mLocationOutsideRo = $row['outside_location'];
$this->mPosterEmail = $row['poster_email'];
$this->mUrlTitle = $sanitizer->sanitize_title_with_dashes($this->mTitle . ' at ' . $this->mCompany);
$this->mApplyOnline = $row['apply_online'];
$this->mDaysOld = $row['days_old'];
$this->mIsSpotlight = $row['spotlight'];
$this->mTypeName = $row['type_name'];
$this->mTypeVarName = $row['type_var_name'];
}
}
}
<?php
$sanitizer = new Sanitizer();
$sql = 'SELECT DISTINCT company FROM ' . DB_PREFIX . 'jobs';
$comps = $db->QueryArray($sql);
if ($id === 'undisclosed') {
$company = '';
} else {
$company = false;
foreach ($comps as $comp) {
if ($sanitizer->sanitize_title_with_dashes($comp['company']) === $id) {
$company = $comp['company'];
break;
}
}
}
if ($company !== false) {
$smarty->assign('jobs', $job->ApiGetJobsByCompany($company, false, false));
$smarty->assign('current_company', $company);
$html_title = $translations['companies']['are_you_looking'] . ' ' . $company . '?';
$meta_description = $translations['companies']['meta_part1'] . ' ' . $company . '! ' . $translations['companies']['meta_part2'];
$template = 'company.tpl';
} else {
// Copied from index.php
header("HTTP/1.1 404 Not Found");
// TO-DO: add suggestion if no trailing slash supplied
$html_title = 'Page unavailable / ' . SITE_NAME;
$template = 'error.tpl';
}
function generate_sitemap($type)
{
global $db;
$sanitizer = new Sanitizer();
// Get all links
$result = $db->query('SELECT url FROM ' . DB_PREFIX . 'links');
while ($row = $result->fetch_assoc()) {
if (!strstr($row['url'], 'http://')) {
$sitemap[BASE_URL . $row['url'] . '/'] = 1;
}
}
// Get all custom pages
$result = $db->query('SELECT url FROM ' . DB_PREFIX . 'pages');
while ($row = $result->fetch_assoc()) {
$sitemap[BASE_URL . $row['url'] . '/'] = 1;
}
// Get all categories
$categories = get_categories();
$i = 0;
while ($i < count($categories)) {
$sitemap[BASE_URL . URL_JOBS . '/' . $categories[$i]['var_name'] . '/'] = 1;
$i++;
}
// Get all cities
$cities = get_cities();
$i = 0;
while ($i < count($cities)) {
$sitemap[BASE_URL . URL_JOBS_IN_CITY . '/' . $cities[$i]['ascii_name'] . '/'] = 1;
$i++;
}
// Get all companies
$result = $db->query('SELECT company FROM ' . DB_PREFIX . 'jobs WHERE is_temp = 0 AND is_active = 1 GROUP BY company');
while ($row = $result->fetch_assoc()) {
$sitemap[BASE_URL . URL_JOBS_AT_COMPANY . '/' . $sanitizer->sanitize_title_with_dashes($row['company']) . '/'] = 1;
}
// Get all active Jobs
$result = $db->query('SELECT id, title, company FROM ' . DB_PREFIX . 'jobs WHERE is_active = 1 AND is_temp = 0');
while ($row = $result->fetch_assoc()) {
$sitemap[BASE_URL . URL_JOB . '/' . $row['id'] . '/' . $sanitizer->sanitize_title_with_dashes($row['title'])] = 1;
}
// Generate output
if ($type == 'xml') {
header('Content-Type: text/xml; charset="utf-8"');
echo '<?xml version="1.0" encoding="UTF-8"?>';
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
foreach ($sitemap as $url => $value) {
echo '<url><loc>' . $url . '</loc></url>';
}
echo '</urlset>';
} else {
foreach ($sitemap as $url => $value) {
echo $url . '<br />';
}
}
}
<?php
$companies = array();
$sanitizer = new Sanitizer();
$sql = 'SELECT company, count(id) AS nr
FROM ' . DB_PREFIX . 'jobs
WHERE is_temp = 0 AND is_active = 1
GROUP BY company
ORDER BY company ASC';
$comps = $db->QueryArray($sql);
foreach ($comps as $company) {
$nr = $company['nr'];
$tag_height = get_cloud_tag_height($nr);
$companies[] = array('name' => $company['company'], 'varname' => $sanitizer->sanitize_title_with_dashes($company['company']), 'count' => $nr, 'tag_height' => $tag_height);
}
$smarty->assign('companies', $companies);
$smarty->assign('companies_count', count($comps));
$html_title = $translations['companies']['page_title'];
$template = 'companies.tpl';
private function prepare_job_for_export($job)
{
$sanitizer = new Sanitizer();
$url_title = $sanitizer->sanitize_title_with_dashes($job['title'] . ' at ' . $job['company']);
$job['city'] = !empty($job['city']) ? $job['city'] : 'Any city';
$job['detail_url'] = JOBBER_URL . URL_JOB . '/' . $job['id'] . '/' . $url_title . '/';
return $job;
}
if ($item['url'] == $url) {
$job_flag = false;
}
}
} else {
$_SESSION['last_viewed_jobs'] = array();
}
if ($job_flag) {
array_unshift($_SESSION['last_viewed_jobs'], array('url' => $url, 'title' => stripslashes($job->mTitle)));
}
if (count($_SESSION['last_viewed_jobs']) > 10) {
array_pop($_SESSION['last_viewed_jobs']);
}
$app = new JobApplication($id);
$info['applied_count'] = $app->Count();
// ######### list other jobs by the same company #########
$compjobs = $job->ApiGetJobsByCompany($info['company'], 5, false);
$sanitizedcomp = $sanitizer->sanitize_title_with_dashes($info['company']);
$smarty->assign('compjobs', $compjobs);
$smarty->assign('jobsat', $sanitizedcomp);
// ######### list other jobs by the same company #########
$smarty->assign('job', $info);
$category = get_category_by_id($info['category_id']);
$smarty->assign('seo_title', $translator->translate("jobs.html_title", stripslashes($info['title']), stripslashes($info['company']), SITE_NAME));
$smarty->assign('current_category', $category['var_name']);
$smarty->assign('back_link', BASE_URL . URL_JOBS . '/' . $category['var_name'] . '/');
$template = 'job.tpl';
} else {
redirect_to(BASE_URL . 'job-unavailable/');
exit;
}
<?php
$companies = array();
$sanitizer = new Sanitizer();
$sql = 'SELECT company, count(id) AS nr
FROM ' . DB_PREFIX . 'jobs
WHERE is_temp = 0 AND is_active = 1
GROUP BY company
ORDER BY company ASC';
$comps = $db->QueryArray($sql);
foreach ($comps as $company) {
$nr = $company['nr'];
$tag_height = get_cloud_tag_height($nr);
$varname = $sanitizer->sanitize_title_with_dashes($company['company']);
if ($varname == '') {
$varname = 'undisclosed';
}
$companies[] = array('name' => $company['company'], 'varname' => $varname, 'count' => $nr, 'tag_height' => $tag_height);
}
$smarty->assign('companies', $companies);
$smarty->assign('companies_count', count($comps));
$html_title = $translations['companies']['page_title'];
$template = 'companies.tpl';