<?php
session_start();
/*
DROP TABLE `ca_bornes`;
CREATE TABLE IF NOT EXISTS `ca_bornes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_agence` int(10) unsigned NOT NULL,
`nom_agence` varchar(255) NOT NULL,
`ip` varchar(15) NOT NULL,
`jour` date NOT NULL,
`heure` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `id_agence` (`id_agence`),
KEY `jour` (`jour`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='bornes' AUTO_INCREMENT=1 ;
*/
// print_r($_SESSION);
require_once("../../inc/confNetisse.php");
$dateRef = "";
$s = $s2 = $s3 = "";
if (isset($_POST["dateRef"])) {
$dateRef = $_POST["dateRef"];
}
if ( ($dateRef != "") && (isset($_REQUEST["a"])) ) {
//echo "<li>dateRef = ".$dateRef;
$dateMy = substr($dateRef,6,4).'-'.substr($dateRef,3,2).'-'.substr($dateRef,0,2);
//echo "<li>dateMy = ".$dateMy;
$s2 = "";
$s3 = "";
$q = 'SELECT id_agence, nom_agence FROM ca_agences WHERE supp=0 ORDER BY nom_agence ASC';
$r = excuteQuery($q);
while ($o = $r['stmt']->fetchObject()) {
$q2 = 'SELECT count(id_client) as nb FROM ca_clients WHERE id_agence='.intval($o->id_agence).' AND date_arrivee > "'.$dateMy.' 00:00:00" AND date_arrivee < "'.$dateMy.' 23:59:59" ';
$r2 = excuteQuery($q2);
if ($r2['stmt']->fetch( PDO::FETCH_ASSOC )['nb'] == 0) $s2 .= "<tr><td>".$o->nom_agence."</td></tr>";
$q3 = 'SELECT heure FROM ca_bornes WHERE id_agence='.intval($o->id_agence).' AND jour="'.$dateMy.'" ';
//echo "<li>Q3 = ".$q3;
$r3 = excuteQuery($q3);
if ($r3) {
$n3 = $r3['stmt']->rowCount();
$i = 0;
while ($o3 = $r3['stmt']->fetchObject()) {
if (($n3 >1) && ($i > 0)) {
$s3 .= "<tr style='color:#0000FF'><td>".$o->nom_agence."</td><td>".$o3->heure."</td></tr>";
} else {
$s3 .= "<tr><td>".$o->nom_agence."</td><td>".$o3->heure."</td></tr>";
}
$i++;
}
} else {
$s3 .= "<tr><td style='color:#FF0000'>".$o->nom_agence."</td><td style='color:#FF0000' align='center'> - </td></tr>";
}
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo $PROJECT_TITLE;?> : Surveillance</title>
<link rel="stylesheet" href="../css/font-awesome.min.css" />
<link rel="stylesheet" type="text/css" href="../css/cadif.css" />
<link rel="stylesheet" type="text/css" href="../css/dashboard.css" />
<link rel="stylesheet" type="text/css" href="../css/cans/jquery-ui-1.8.17.custom.css" />
<!--<link rel="stylesheet" type="text/css" href="css/tableTools_jui.css" />-->
<link rel="stylesheet" type="text/css" href="../css/datatable_jui.css" />
<script type="text/javascript" src="../stats//js/uidatepicker-fr.js"></script>
<script type="text/javascript" src="../js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="../js/jquery-ui-1.8.22.custom.min.js"></script>
<script type="text/javascript" src="../js/jquery.dataTables.js"></script>
</head>
<body>
<div id="global">
<div id="home">
<div id="logo"><a href="<?php echo $SERVER;?>admin/dashboard.php"><img src="/assets/img/logo.png" height="110" border="0"/></a></div>
<div id="username">
<b><?php echo isset($_SESSION["nom"]) ? $_SESSION["nom"] : $_SESSION["matricule"];?></b> | <a href="<?php echo $SERVER;?>admin/close.php" class="link" title="Fermer et clore votre session">Déconnexion</a>
<br/>
</div>
</div>
<div id="panels">
<?php include "../menu.php";?>
<div class="main-content">
<div id="title">
Bornes : Surveillance
</div>
<br/>
<form name="frm" action="bornes.php?a=1" method="post" style="margin-bottom:0px !important">
<table class="content" align="center">
<tr>
<td class=""><b>Date sélectionnée</b></td>
<td class="padStats"> : </td>
<td>
<input id="dateRef" class="date_input" name="dateRef" type="text" value="<?php echo $dateRef; ?>" />
</td>
<td><input type="submit" id="bornesSub" name="bornesSub" value="Valider"/></td>
</tr>
</table>
</form>
<br/>
<?php
if ($s3 != "") {
echo "<br/><table align='center' valign='top'><tr>
<td valign='top'>
<table align='center' class='display' style='background-color:#EEEEEE;'><tr><td><u><b>Bornes</b></u></td><td><u><b>Heure de connexion</b></u></td></tr>".$s3."</table>
</td>
<td style='width:100px'> </td>
<td valign='top'>
<table align='center' class='display' style='background-color:#EEEEEE;'><tr><td><u><b>Bornes n'ayant pas enregistré de client</b></u></td></tr>".$s2."</table>
</td>
</tr>
</table>";
} else {
echo "";
}
?>
</div>
</div>
</div>
<?php include '../footer.php';?>
<script type="text/javascript">
$(document).ready(function() {
jQuery.datepicker.setDefaults($.datepicker.regional['fr']);
jQuery('#dateRef').mousedown(function(){
jQuery("#dateRef").datepicker({minDate:'-36500', maxDate:new Date(), dateFormat: 'dd/mm/yy', firstDay:1, cgangeFirstDay : false }).attr("readonly","readonly");
});
});
</script>
</body>
</html>