error_reporting(E_ALL); ini_set( "display_errors", 1); /* à mettre à 0 en production */ include_once('./admin/init.php'); require_once("include/menu/menu.php"); require_once("include/addBalise.php"); require_once("include/getReleve.php"); require_once("./include/bd.php"); include("./admin/_utils.php"); $departement = 0; $debug = 1; $t0 = microtime(true); $req = "SELECT * FROM `departements` ORDER BY `id`"; $answer_dept = mysqli_query($DB_LINK, $req) or die("SQL Error"); $nb = mysqli_num_rows($answer_dept); for ($i=1; $i<=$nb; $i++) { $dept = mysqli_fetch_array($answer_dept); $id = $dept['id']; $departements[$id] = $dept; } $departement = get_post('dept'); if (intval($departement)) { // Protection injection SQL (Jerome 20100727) $get_dept = mysqli_real_escape_string($DB_LINK, $departement); // Récupération des informations sur le departement $req = "SELECT * FROM `departements` WHERE `id`='" . $get_dept . "'"; $answer_dept = mysqli_query($DB_LINK, $req) or die("SQL Error"); $infoDept = mysqli_fetch_array($answer_dept); // Récupération de la liste des departements voisins pour navigation $req ="SELECT * FROM `departements` WHERE `region`='{$infoDept['region']}'"; $listeDept = mysqli_query($DB_LINK, $req) or die("SQL Error"); $dept = mysqli_fetch_array($listeDept); if ($dept == null) { trace('erreur2 depart.php', 0); trace(print_r($_SERVER,1), 1); exit(); } // Récupération de la liste des balises du département $req = "SELECT * FROM `balises` WHERE `departement` = '" . $get_dept . "' ORDER BY `idBalise` "; $listeBalise = mysqli_query($DB_LINK, $req) or die("SQL Error"); // Récupération de la date du dernier relevé météo toutes balises confondues /*$req ="SELECT DATE_FORMAT(max(date),'%d/%m/%Y ‡ %H:%i') as maxDate" ." FROM relevemeteo rm, balises ba WHERE ba.departement='".$get_dept."'" ." AND rm.idBalise = ba.idBalise";*/ // optimisation requete (Jerome 20101018) /*$req = 'SELECT DATE_FORMAT(date,\'%d/%m/%Y ‡ %H:%i\') as maxDate' ." FROM relevemeteo rm, balises ba WHERE ba.departement='".$get_dept."'" . ' AND rm.idBalise = ba.idBalise' . ' ORDER by date desc' . ' LIMIT 1'; $answer_maxDate = mysqli_query($DB_LINK, $req) or die("SQL Error"); $maxDate = mysqli_fetch_array($answer_maxDate);*/ // requete pas vraiment utile mais lente ! JSO } else { trace('erreur1 depart.php', 0); trace(print_r($_SERVER,1), 1); exit(); } /* ----------------------------------------------------------------------------------------------------------------------------------------------- */ /* Google Maps */ /* ----------------------------------------------------------------------------------------------------------------------------------------------- */ $map = 1; $map_width = intval(get_post('w')); $map_height = intval(get_post('h')); $locations = ''; $locations_index = 0; $map_draggable = 'true'; $map_mapTypeControl = 'true'; $map_streetViewControl = 'false'; // par défaut $map_latitude = 46.5; $map_longitude = 3.75; $map_zoom = 6; if ($departement) { if (isset($departements[$departement])) { $map_latitude = $departements[$departement]['latitude']; $map_longitude = $departements[$departement]['longitude']; $map_zoom = $departements[$departement]['map_zoom']; } } if ($map_width==0) $map_width = '100%'; if ($map_height==0) $map_height = '100%'; ?>