ChronoScripts JobberBase Scripts and (PHP) Support

// per category
case 'jobs':
	require_once 'page_category.php';
	$flag = 1;
	break;

// cities
case 'cities':
	require_once 'page_cities.php';
	$flag = 1;
	break;

<?php
	$city_array = get_cities_cloud();
	$smarty->assign('cities_overview', $city_array);
	$smarty->assign('cities_count', count($city_array));
	$html_title = $translations['jobscity']['page_title'];
	$template = 'cities.tpl';
?>

{include file="header.tpl"}
<div id="content">
 
<!-- #job-listings -->
<h3 class="page-heading">{$translations.jobscity.title}</h3>
{section name=tmp loop=$cities_overview}
			<span class="company-tag-{$cities_overview[tmp].tag_height}">
				<a href="{$BASE_URL}jobs-in/{$cities_overview[tmp].varname}">{$cities_overview[tmp].name} ({$cities_overview[tmp].count})</a>
			</span>
			{/section}
 
				{$translations.jobscity.total}: <strong>{$cities_count}</strong> {$translations.jobscity.cities}</div>
<!-- /content -->
 
{include file="footer.tpl"}

<a href="{$BASE_URL}companies/" title="{$translations.footer.companies_title}">{$translations.footer.companies}</a><br />

<a href="{$BASE_URL}cities/" title="{$translations.footer.cities_title}">{$translations.footer.cities}</a><br />

[footer]

cities_title = "Cities"
cities = "Cities"

[jobscity]

page_title = "Overview of cities"
title = "Cities with jobs available"
total = "Total"
cities = "cities"
jobs_at = "Jobs in"

function add_single_quotes($arg)
{
	/* single quote and escape single quotes and backslashes */
	return "'" . addcslashes($arg, "'\\") . "'";
}

function get_cities_cloud()
{
	global $db;
	$city_array = array();
 
	$sql = 	'SELECT c.id, c.name, c.ascii_name, COUNT(*) AS nr
			 FROM cities c 
			 INNER JOIN jobs j ON (j.city_id = c.id ) 
			 WHERE j.is_active = 1 
			 GROUP BY c.name';
 
	$cities = $db->QueryArray($sql);
 
	foreach ($cities as $city)
	{
		$nr = $city['nr'];
 
		if ($nr < 2)
		{
			$tag_height = 1;
		}
		else if ($nr >= 2 && $nr < 3)
		{
			$tag_height = 2;
		}
		else if ($nr >= 3 && $nr < 4)
		{
			$tag_height = 3;
		}
		else if ($nr >= 4 && $nr < 5)
		{
			$tag_height = 4;
		}
		else if ($nr >= 5 && $nr < 6)
		{
			$tag_height = 5;
		}
		else if ($nr >= 6)
		{
			$tag_height = 6;
		}
 
		$city_array[] = array('name' => $city['name'],
		                     'varname' => $city['ascii_name'],
		                     'count' => $nr,
		                     'tag_height' => $tag_height);
	}
 
	return $city_array;
}