$courrier->Ln(15); //****Liste d'attente aux ateliers if ($attente > 0) { $courrier->MultiCell(0, 5, html_entity_decode('Vous êtes &ecute;galement inscrit en attente pour les sessions suivantes'), 0, 'J', false); if ($nba > 0) { while ($rowa = mysqli_fetch_array($rowsessionattente)) { ///recuperer la liste des dates $idsa = $rowa["id_session"]; $db = mysqli_connect($host, $userdb, $passdb, $database); $sqldates = "SELECT `date_session` FROM `tab_session_dates` WHERE `id_session` ='" . $idsa . "'"; $rowsdates = mysqli_query($db, $sqldates); mysqli_close($db); $nbrdates = mysqli_num_rows($rowsdates); for ($f = 0; $f < $nbrdates; $f++) { $rowd = mysqli_fetch_array($rowsdates); $dates = $dates . getDatefr($rowd["date_session"]) . "\n"; } $courrier->SetFont('SourceSansPro-Semibold', '', 12); $titre = $rowa['session_titre'] . " : "; $courrier->Write(7, $titre); $courrier->Ln(); $courrier->SetFont('SourceSansPro-LightItalic', '', 12); $courrier->Write(5, $rowa['session_detail']); $courrier->Ln(7); $courrier->SetFont('SourceSansPro-Regular', '', 12); $courrier->Multicell(0, 7, $dates, 0, 'L', false); $courrier->Ln(); $dates = ""; } } else { $courrier->SetFont('SourceSansPro-Regular', '', 12);
$titresession = getTitreSession($row["nom_session"]); $anim = getUserName($row["id_anim"]); $salle = mysqli_fetch_array(getSalle($row["id_salle"])); $nomsalle = $salle["nom_salle"] . " (" . $espaces[$salle["id_espace"]] . ")"; $tarif = getNomTarif($row["id_tarif"]); $idtarif = $row["id_tarif"]; $epn = $salle['id_espace']; $nbplace = $row["nbplace_session"]; $sessionstatut = $row["status_session"]; //Afficher les dates de la session $nbrdates = $row["nbre_dates_sessions"]; $datesarray = getDatesSession($idsession); for ($f = 0; $f < $nbrdates; $f++) { $rowd = mysqli_fetch_array($datesarray); //debug($row); $datessession = $datessession . getDatefr($rowd["date_session"]) . " <br>"; $iddate = $rowd["id_datesession"]; //donner la derniere id } $placesoccupee = countPlaceSession($idsession, 0); $enattente = countPlaceSession($idsession, 2); $placesrestantes = $nbplace - $placesoccupee; //tester la présence de tarifs ateliers $testTarifAtelier = TestTarifs(); if ($b == 2) { //verification d'inscription if (FALSE != checkUserSession($idsession, $iduser)) { $datesarray2 = getDatesSession($idsession); //boucler pour insérer le nombre de dates par sessions for ($f = 0; $f < $nbrdates; $f++) { $row2 = mysqli_fetch_array($datesarray2);
$arraysessionLVSA = getSession($rowLVSA["id_session"]); $sujetLVSA = mysqli_fetch_array(getSujetSessionById($arraysessionLVSA["nom_session"])); $salle = mysqli_fetch_array(getSalle($rowLVSA["id_salle"])); $lieuSession = $salle["nom_salle"] . " (" . $espaces[$salle["id_espace"]] . ")"; if ($rowLVSA["statut_datesession"] == 1) { $class = "text-muted"; if ($rowLVSA["status_rel_session"] == 1) { $presence = "Présent"; } else { $presence = "Absent"; } } else { $class = ""; $presence = "inscrit(e)"; } echo "<tr class=" . $class . ">\n\t\t\t\t\t\t<td>" . getDatefr($rowLVSA["date_session"]) . "</td>\n\t\t\t\t<td>" . $sujetLVSA["session_titre"] . " (" . $k . ") </td>\n\t\t\t\t\t\t<td>" . $presence . "</td>\n\t\t\t\t\t\t<td>" . $lieuSession . "</td>\n\t\t\t\t\t\t<td><a href=\"index.php?m=6&b=7&idsession=" . $rowLVSA["id_session"] . "\"><button type=\"button\" class=\"btn bg-red sm\"><i class=\"fa fa-trash-o\" title=\" se désinscrire\"></i></button></a></td></tr>"; } ?> </tbody></table> <?php } } else { echo '<div class="alert alert-info alert-dismissable"> <i class="fa fa-info"></i> <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Vous ne participez à aucune session</div>'; } ?> </div><!-- /.tab-pane -->
$salle = mysqli_fetch_array(getSalle($row["id_salle"])); $nomsalle = $salle["nom_salle"]; $idsession = $row["idsession"]; $tarif = getNomTarif($row["id_tarif"]); $nbre_dates = $row["nbre_dates_sessions"]; // liste des dates de la session $datesarray = getDatesSession($row["idsession"]); $placesoccupee = countPlaceSession($row["idsession"], 0); echo "<tr>\n\t\t\t <td>" . getDayfr($row["datep"]) . "</td>\n\t\t\t <td>" . $row["session_titre"] . "</td>\n\t\t\t <td>" . $anim . "</td>\n\t\t\t <td>" . $nomsalle . "</td>\n\t\t\t <td>" . $placesoccupee . "</td>\n\t\t\t \t\t\n\t\t\t <td>"; for ($s = 0; $s < $nbre_dates; $s++) { $row2 = mysqli_fetch_array($datesarray); $statut = $row2["statut_datesession"]; if ($statut == 2) { echo getDatefr($row2["date_session"]) . " " . $statusarray[$statut] . " </br>"; } else { echo "<a href=\"index.php?a=32&act=1&idsession=" . $idsession . "&dateid=" . $row2["id_datesession"] . "&numerod=" . $s . "\">" . getDatefr($row2["date_session"]) . "</a> " . $statusarray[$statut] . " </br> "; } } echo "</td>\n\t\t\t </tr>"; } ?> </tbody></table> </div> <div class="box-footer"> <a href="index.php?a=37"><button class="btn btn-default" type="submit"> <i class="fa fa-arrow-circle-left"></i> Retour à la liste des sessions en cours</button></a></div> </div> <?php } else { echo "<div class=\"alert alert-info alert-dismissable\"><i class=\"fa fa-info\"></i>\n <button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>Aucune session archivée pour l'année en cours</div>";
<div class="box-tools pull-right"> <div class="btn-group"> <?php $rowanneesstat = getYearStatAtelierSessions(); while ($ans = mysqli_fetch_array($rowanneesstat)) { echo '<a href="index.php?a=18&year=' . $ans['Y'] . '&month=12&day=365&jour=31" > <button class="btn bg-yellow btn-sm">' . $ans['Y'] . ' </button></a>'; } //annee en cours echo '<a href="index.php?a=18&year=' . date('Y') . '"> <button class="btn bg-yellow btn-sm"> Année en cours</button></a>'; ?> </div></div> </div> <div class="box-body"> <?php if ($nb2 > 0) { ?> <table class="table"> <thead><tr><th>Date</th><th>Titre</th><th>Inscrits</th><th>Présents</th><th>Absents</th><th>En Attente</th></tr></thead><tbody> <?php for ($j = 0; $j < $nb2; $j++) { $row2 = mysqli_fetch_array($result2); $sujet = getAtelierSujet($row2['id_AS']); echo "<tr>\n\t\t\t\t\t\t <td>" . getDatefr($row2["date_AS"]) . "</td>\n\t\t\t\t\t\t <td><a href=\"index.php?a=16&b=4&act=1&idatelier=" . $row2['id_AS'] . " \">" . $sujet['label_atelier'] . "</a></td>\n\t\t\t\t\t\t <td>" . $row2["inscrits"] . "</td>\n\t\t\t\t\t\t <td>" . $row2["presents"] . "</td>\n\t\t\t\t\t\t <td>" . $row2["absents"] . "</td>\n\t\t\t\t\t\t <td>" . $row2["attente"] . "</td>\n\t\t\t\t\t\t </tr>"; } echo "</tbody></table></div>"; } else { echo '<div class="alert alert-info alert-dismissable"><i class="fa fa-info"></i><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Aucune formation archivée cette année</div>'; } ?> </div>
<table class="table"><thead><tr><th>Type</th><th>Date et heure</th><th>Nom de l'atelier</th><th></th></tr></thead><tbody> <?php for ($i = 1; $i <= $nbabsentatelier; $i++) { //atelier $rowatelier = mysqli_fetch_array($ListeAtelierAbsent); $arrayatelier = getAtelier($rowatelier["id_atelier"]); $titrearray = getSujetById($arrayatelier["id_sujet"]); $rowsujetA = mysqli_fetch_array($titrearray); echo "<tr><td>Atelier</td><td>" . getDayFR($arrayatelier["date_atelier"]) . " à " . $arrayatelier["heure_atelier"] . "</td>\n\t\t\t\t\t\t<td>" . $rowsujetA["label_atelier"] . "</td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t</tr>"; } //session for ($i = 1; $i <= $nbabsentsession; $i++) { $sessionabsent = mysqli_fetch_array($ListeSessionAbsent); $arrayses = getSession($sessionabsent["id_session"]); $titresession = mysqli_fetch_array(getSujetSessionById($arrayses["nom_session"])); echo "<tr><td>Session</td><td>" . getDatefr($sessionabsent["date_session"]) . "</td>\n\t\t\t\t\t\t<td>" . $titresession["session_titre"] . " </td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t</tr>"; } ?> </tbody></table> <?php } else { echo "<p>Pas d'absence passée enregistrée</p>"; } ?> <h4>Présent (<?php echo $nbtotalpresent; ?> )</h4> <?php if ($nbtotalpresent > 0) {