dateRef = ".$dateRef; $dateMy = substr($dateRef, 6, 4) . '-' . substr($dateRef, 3, 2) . '-' . substr($dateRef, 0, 2); //echo "
  • dateMy = ".$dateMy; $s2 = ""; $s3 = ""; $q = 'SELECT id_agence, nom_agence FROM ca_agences WHERE supp=0 AND id_agence NOT IN(:id_agence) ORDER BY nom_agence ASC'; $agences = array(87,88,89,90,91,92,93,94); $values = array(':id_agence' => implode(',', $agences)); $result = excuteQuery($q, $values); $r = $result['stmt']; while ($o = $r->fetchObject()) { $q2 = 'SELECT count(id_client) as nb FROM ca_clients WHERE id_agence=:id_agence AND date_arrivee > :date_arrivee1 AND date_arrivee < :date_arrivee2 '; $dateMySql = $dateMy . " 00:00:00"; $v2 = array(':id_agence'=>$o->id_agence, ':date_arrivee1'=>$dateMySql, ':date_arrivee2'=>$dateMySql); $stmt = excuteQuery($q2, $v2); if ($stmt['status']) { $result = $stmt['stmt']; if ($result->rowCount() > 0) { if ($result->fetch( PDO::FETCH_ASSOC )['nb'] == 0) $s2 .= "" . $o->nom_agence . ""; } }else { wts_die($stmt->error); } $q3 = 'SELECT heure FROM ca_bornes WHERE id_agence=:id_agence AND jour=:jour'; $v3 = array(':id_agence' => $o->id_agence, ':jour' => $dateMy); //echo "
  • Q3 = ".$q3; $stmt2 = excuteQuery($q3, $v3); if ($stmt2['status']) { $result = $stmt2['stmt']; $n3 = $result->rowCount(); if ($n3 > 0) { $i = 0; while ($o3 = $r3->fetchObject()) { if (($n3 > 1) && ($i > 0)) { $s3 .= "" . $o->nom_agence . "" . $o3->heure . ""; } else { $s3 .= "" . $o->nom_agence . "" . $o3->heure . ""; } $i++; } } else { $s3 .= "" . $o->nom_agence . " - "; } } else { wts_die($stmt2->error); } } } ?> <?php echo $PROJECT_TITLE; ?>
    Bornes : Surveillance

    Date sélectionnée :

    " . $s3 . "
    BornesHeure de connexion
    		   " . $s2 . "
    Bornes n'ayant pas enregistré de client
    "; } else { echo ""; } ?>