function ch2dat($ch)
{
$annee = substr($ch, 0, 4);
$mois = substr($ch, 5, 2);
$jour = substr($ch, 8, 2);
$dat = $jour . " " . moix($mois) . " " . $annee;
return $dat;
}
$cou = explode(".", $couche[4]);
$imag = '../../tmp/' . $cou[0];
error_reporting($erreur);
$pdf->AddPage();
$pdf->SetFont('times', '', 11);
//fixe la marge gauche des textes qui suivent après un retour à la ligne(<br>)
$pdf->SetLeftMargin(15);
//supprime le saut de page
$pdf->Setautopagebreak(0, 0);
//fixe la marge droite des textes qui suivent
$pdf->SetrightMargin(5);
$pdf->SetTextColor(0);
$pdf->Image("../../logo/" . $codeinsee . ".png", 10, 8, $lar, '20', '', '');
//on se positionne à 130mm du bord gauche et à 15 mm du bord haut
$pdf->Setxy(130, 10);
$pdf->Write(5, $r1[0]['nom'] . ', le ' . date("d") . ' ' . moix(date("m")) . ' ' . date("Y"));
$pdf->SetFont('', 'B', 13);
$pdf->Setxy(85, 17);
$pdf->Write(5, 'Renseignement d' . chr(180) . 'Urbanisme N° I' . $comp . '/' . $annee);
$pdf->SetFont('', '', 11);
$pdf->Setxy(15, 45);
$pdf->Write(5, 'Pour contacter le service Urbanisme:');
$pdf->Setxy(15, 50);
$pdf->Write(5, $r1[0]['tel_urba'] . ' (' . $r1[0]['horaire_urba'] . ')');
$pdf->Image($imag . ".jpg", 10, 80, '190', '154,7', '', '');
$pdf->Image("legende.PNG", 10, 250, '40', '32', '', '');
$pdf->Setxy(85, 30);
$pdf->SetFillColor(225, 225, 225);
$pdf->Multicell(115, 5, 'Le présent document graphique est délivré à titre indicatif. Il ne peut en aucun cas se substituer au plan d' . chr(180) . 'alignement approuvé, consultable en Mairie. ', 1, 1, 'L', 1);
}
// Sortie alternative
$insee = $_SESSION['profil']->insee;
$appli = $_SESSION['profil']->appli;
if (!$_SESSION['profil']->acces_ssl || !in_array("administration", $_SESSION['profil']->liste_appli)) {
//
die("Point d'entrée réglementé.<br> Accès interdit. <br>Veuillez vous connecter via <a href=\"https://" . $_SERVER['HTTP_HOST'] . "\">serveur carto</a><SCRIPT language=javascript>setTimeout(\"window.location.replace('https://" . $_SERVER['HTTP_HOST'] . "')\",5000)</SCRIPT>");
}
$sql = "select count(distinct sessionid) as nb_con,\n\tcount(distinct page||query) as nb_page \n\tfrom admin_svg.connexion as a\n\twhere date_trunc('month',date_a)>date_trunc('month',now())-interval '12 month'\n\tgroup by date_trunc('month',date_a) \n\torder by date_trunc('month',date_a)";
$rsql = $DB->tab_result($sql);
$sql1 = "select count(distinct sessionid) as max_nb_con,\n\tcount(distinct page||query) as max_nb_page \n\tfrom admin_svg.connexion as a\n\tgroup by date_trunc('month',date_a)";
$rsql1 = $DB->tab_result($sql1);
//$sql2="select distinct(lpad(EXTRACT(MONTH FROM date_a)::text,2,'0')) as mois from admin_svg.connexion";
$sql2 = "select distinct(date_trunc('month',date_a)) as mois from admin_svg.connexion \n\twhere date_trunc('month',date_a)>date_trunc('month',now())-interval '12 month'";
$rsql2 = $DB->tab_result($sql2);
for ($p = 0; $p < count($rsql1); $p++) {
$max = max($max, $rsql1[$p]["max_nb_con"], $rsql1[$p]["max_nb_page"]);
}
//echo "<html><br><IMG src='".graphe($max,$rsql,$rsql2,"Nbre connexion","Nbre de page")."' align='left' border='1'>";
echo "<html><TABLE width=\"600px\" align=\"center\" bgcolor=\"lightGray\"><tr><th align=\"center\">Utilisation du serveur SIG<br> </th></tr>\n <tr><td align=\"center\"><IMG src='./graphe.php?max=" . $max . "&rsql=" . serialize($rsql) . "&rsql2=" . serialize($rsql2) . "&lg1=Nbre connexion&lg2=Nbre de page&col=12' align='center' border='0'></td></tr>";
echo "<tr><td align=\"center\"> <br>Connexion mensuelle</td></tr>";
echo "<tr><td>";
echo "<table width='100%' border=1>";
echo "<tr><th></th><th>Nbre de connexion</th><th>Nbre de page</th></tr>";
for ($o = 0; $o < count($rsql1); $o++) {
echo "<tr><td><a href='./utilisation_mensuel.php?mois=" . $rsql2[$o]["mois"] . "'>" . moix(substr($rsql2[$o]["mois"], 5, 2)) . "</a></td><td align=\"center\">" . $rsql[$o]["nb_con"] . "</td><td align=\"center\">" . $rsql[$o]["nb_page"] . "</td></tr>";
$conn_tot = $conn_tot + $rsql[$o]["nb_con"];
$page_tot = $page_tot + $rsql[$o]["nb_page"];
}
echo "<tr><td>Totaux</td><td>{$conn_tot}</td><td>{$page_tot}</td></tr>";
echo "</table>";
echo "</td></tr>";
echo "</TABLE></html>";
