Suivi des réservations
399
AND `numEta` <> 400
AND `numEta` <> 402
AND `numEta` <> 403) ";
$db = connect_base();
$queryRequest = $db->query($query);
$queryRequest->execute();
if($queryRequest->rowCount()>0){
$data=$queryRequest->fetchAll();
/* echo '
';
var_dump($data);
echo '
';*/
$coLy_tmp = array();
$coLy_fullDetail = array();
foreach($data as $key => $value){
$coLy_tmp[] = array(
"id_college_lycee" => $value['numCoLy'],
"jour_reserve" => mysqlToDateFr($value['jour']),
"creneau" => getCreneauPlus($value['creneau']),
"nom_cfa_lp" => decrypter($maCleDeCryptage, $value['nom_eta']),
"localite_cfa_lp" => decrypter($maCleDeCryptage, $value['cp']). "
" . decrypter($maCleDeCryptage, $value['ville'])
);
}
foreach($coLy_tmp as $key => $value){
$db = connect_base();
$query = $db->prepare("SELECT * FROM `collegelycee` WHERE `idCoLy` =:idCoLy");
$query->bindParam( ':idCoLy', $value['id_college_lycee'], PDO::PARAM_INT );
$query->execute();
$result[] = $query->fetchAll();
$result[$key][0]['chxJour'] = $value['jour_reserve'];
$result[$key][0]['chxCreneau'] = $value['creneau'];
$result[$key][0]['nom_cfa_lp'] = $value['nom_cfa_lp'];
$result[$key][0]['localite_cfa_lp'] = $value['localite_cfa_lp'];
}
echo '
';
echo "| Etablissement | Coordonnées | Classes/Elèves | Date Réservation | Créneaux | Nom CFA/LP | Localité CFA/LP |
|---|
";
foreach($result as $k => $v){
// Définition des coordonnées de l'établissement
$add1 = decrypter($maCleDeCryptage,$v[0]['adresse1CoLy']);
$add2 = decrypter($maCleDeCryptage,$v[0]['adresse2CoLy']);
$cp = decrypter($maCleDeCryptage,$v[0]['cpCoLy']);
$ville = decrypter($maCleDeCryptage,$v[0]['villeCoLy']);
$coordonnees = $add1;
if(!empty($add2)){
$coordonnees = $coordonnees . "
" . $add2;
}
$coordonnees = $coordonnees . "
" . $cp . " " . $ville;
echo "";
echo "| ".decrypter($maCleDeCryptage,$v[0]['etaCoLy'])." | ";
echo "".$coordonnees." | ";
echo "".$v[0]['nbClasses']."/".$v[0]['nbEleves']." | ";
echo "".$v[0]['chxJour']." | ";
echo "".$v[0]['chxCreneau']." | ";
echo "".$v[0]['nom_cfa_lp']." | ";
echo "".$v[0]['localite_cfa_lp']." | ";
}
echo '
';
}
?>