$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);
Пример #3
0
                $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&eacute;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">&times;</button>Vous ne participez &agrave; 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"]) . "&nbsp;&nbsp;" . $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>&nbsp;&nbsp;" . $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\">&times;</button>Aucune session archiv&eacute;e pour l'ann&eacute;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&eacute;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&eacute;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">&times;</button>Aucune formation archiv&eacute;e cette ann&eacute;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"]) . " &agrave; " . $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) {