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}`; } } }