return Flight::notFound();
}
$mainData = $mainData[0];
$arrBbox = explode(',', $mainData['bbox']);
$arrBbox = array_map('floatval', $arrBbox);
$mainData['bbox'] = json_encode([[min($arrBbox[1], $arrBbox[3]), min($arrBbox[0], $arrBbox[2])], [max($arrBbox[1], $arrBbox[3]), max($arrBbox[0], $arrBbox[2])]]);
$proName = $mainData['prov_name'];
$regName = $mainData['reg_name'];
$munName = $mainData['name'];
$query = "SELECT stat.* FROM it_comuni com JOIN it_stats stat ON com.osm_id = stat.osm_id WHERE com.cod_istat=" . $db->quote($mainData['cod_istat']) . " AND data > (CURRENT_DATE - 30) ORDER BY data ASC";
$res = $db->query($query);
$stats = $res->fetchAll();
Flight::render('extract.php', array('baseUrl' => Flight::request()->base, 'pTitle' => $municipality . ', ' . $province . ', ' . $region, 'region' => $regName, 'region_safe' => $region, 'province' => $proName, 'province_safe' => $province, 'municipality' => $munName, 'municipality_safe' => $municipality, 'mainData' => $mainData, 'stats' => $stats));
});
Flight::route('/@region/@province/@municipality/stats', function ($region, $province, $municipality) {
checkLang();
$db = Flight::db();
$query = "SELECT com.osm_id,com.cod_istat,com.name, com.safe_name, pro.name AS prov_name, reg.name AS reg_name FROM it_regioni reg JOIN it_province pro ON reg.cod_istat = pro.cod_istat_reg JOIN it_comuni com ON pro.cod_istat=com.cod_istat_pro WHERE com.safe_name=" . $db->quote($municipality) . " AND pro.safe_name=" . $db->quote($province);
$res = $db->query($query);
$mainData = $res->fetchAll();
if (count($mainData) == 0) {
return Flight::notFound();
}
$mainData = $mainData[0];
$proName = $mainData['prov_name'];
$regName = $mainData['reg_name'];
$munName = $mainData['name'];
$query = "SELECT stat.* FROM it_comuni com JOIN it_stats stat ON com.osm_id = stat.osm_id WHERE com.cod_istat=" . $db->quote($mainData['cod_istat']) . " ORDER BY data ASC";
$res = $db->query($query);
$stats = $res->fetchAll();
Flight::render('extractStats.php', array('baseUrl' => Flight::request()->base, 'pTitle' => $municipality . ', ' . $province . ', ' . $region, 'region' => $regName, 'region_safe' => $region, 'province' => $proName, 'province_safe' => $province, 'municipality' => $munName, 'municipality_safe' => $municipality, 'mainData' => $mainData, 'stats' => $stats));
function getOptionCountry($langSelected, $countrySelected, $title)
{
$langSelected = checkLang($langSelected);
$countryArray = getCountries($langSelected);
$options = "<option id=\"default_" . rand() . "\" value=\"" . Select_default . "\"";
if ($countrySelected == "") {
$options .= " selected=\"selected\"";
}
$options .= ">" . $title . "</option>\n";
for ($i = 0; $i < $countryArray['Count']; $i++) {
$ISO = $countryArray[$i]["Iso"];
// $enName = $countryArray[$i]["En_name"];
$enName = strtr($countryArray[$i]["En_name"], ' ,().\'', '_______');
$Name = $countryArray[$i]["Name"];
$options .= "<option id=\"" . $enName . "\" value=\"" . $ISO . "\"";
if ($countrySelected == $ISO) {
$options .= " selected=\"selected\"";
}
$options .= ">" . $Name . "</option>\n";
}
return $options;
}
}
//Set the language into a session variable
$lang_user_now = isset($_GET['lang']) ? $_GET['lang'] : '';
if (isset($_GET['lang'])) {
$_SESSION['language'] = checkLang($lang_user_now);
$_SESSION['Update_application_noframe'] = "True";
unset($_SESSION['filter_page']);
}
//First time the user connects
$check_lang_auto = isset($_GET['check_lang_auto']) ? $_GET['check_lang_auto'] == "true" : true;
if (!isset($_SESSION['language']) && $check_lang_auto) {
//Get the client language
$clientLang = explode(",", $HTTP_ACCEPT_LANGUAGE);
$clientLang = ucFirst(StrToLower(subStr(rTrim($clientLang[0]), 0, 2)));
//Check if this language is available (return En if not)
$language = checkLang($clientLang);
//If the requested URI is a file
if (strpos($_SERVER["PHP_SELF"], '.php') !== false) {
//$_SERVER['REQUEST_URI'], '.php') !== false) {
//Get the file's name
$parentName = basename($_SERVER["PHP_SELF"]);
} else {
//Get the default value
$parentName = "index.php";
}
//Get the URL Parameters
$url_parameters = "";
foreach ($_GET as $key => $value) {
if ($key != "lang" && $key != "logout") {
$url_parameters .= "&" . $key . "=" . $value;
}
/**
* potmerge
*/
function potmerge($_verbose)
{
$langs = getExistingLanguages($_verbose);
$msgDebug = $_verbose ? '' : '2> /dev/null';
foreach (Tinebase_Translation::getTranslationDirs() as $appName => $translationPath) {
if (!checkAppName($appName, $_verbose)) {
continue;
}
if ($_verbose) {
echo "Processing {$appName} po files \n";
}
if ($_verbose) {
echo "creating en.po from template.po\n";
}
generateNewTranslationFile('en', 'GB', $appName, getPluralForm('English'), "{$translationPath}/en.po", $_verbose);
$enHeader = file_get_contents("{$translationPath}/en.po");
`cd "{$translationPath}"\n msgen template.pot > en.po {$msgDebug}`;
foreach ($langs as $langCode) {
if (!checkLang($langCode, $_verbose)) {
continue;
}
$poFile = "{$translationPath}/{$langCode}.po";
if (!is_file($poFile)) {
if ($_verbose) {
echo "Adding non exising translation {$langCode} for {$appName}\n";
}
if (strpos($langCode, '_') !== FALSE) {
list($language, $region) = explode('_', $langCode);
} else {
$language = $langCode;
$region = '';
}
$locale = new Zend_Locale('en');
$languageName = $locale->getTranslation($language, 'language');
$regionName = $region ? $locale->getTranslation($region, 'country') : '';
$pluralForm = getPluralForm($languageName);
generateNewTranslationFile($languageName, $regionName, $appName, $pluralForm, $poFile, $_verbose);
}
if ($_verbose) {
echo $poFile . ": ";
}
`cd "{$translationPath}"\n msgmerge --no-fuzzy-matching --no-wrap {$poFile} template.pot {$msgDebug} -o {$poFile}`;
}
}
}
