<th>Places Restantes</th>
<th>Sièges</th>
<th>Attente</th>
<th>Statut</th>
<th>Animateur</th>
<th>Infos</th>
<th></th></thead><tbody>
<?php
for ($x = 1; $x <= $nbas; ++$x) {
$row = mysqli_fetch_array($result2);
$idsujet = $row["id_sujet"];
$result = getSujetById($idsujet);
$rowsujet = mysqli_fetch_array($result);
$enattente = getAttenteAtelier($row["id_atelier"]);
$nbplace = $row["nbplace_atelier"] - countPlace($row["id_atelier"]);
if ($nbplace < 0) {
$nbplace = 0;
}
echo "<tr> \n\t\t\t\t\t <td>" . getDayfr($row["date_atelier"]) . "</td>\n\t\t\t\t\t <td>" . $row["heure_atelier"] . "</td>\n\t\t\t\t\t <td><a href=\"index.php?a=13&b=1&idatelier=" . $row["id_atelier"] . "\" data-toggle=\"tooltip\" title=\"Inscrire un adherent\" >" . $rowsujet["label_atelier"] . "</a>";
//Ajout mention "complet"
if ($nbplace == 0) {
echo "<b>\t <span class=\"text-red\">COMPLET</span></b>";
}
echo "</td>\n\t\t\t\t\t <td>" . $nbplace . "</td>\n\t\t\t\t\t <td>" . $row["nbplace_atelier"] . "</td>\n\t\t\t\t\t <td>" . $enattente . "</td>\n\t\t\t\t\t <td>" . $stateAtelier[$row["statut_atelier"]] . "</td>\n\t\t\t\t\t <td>" . getUserName($row["anim_atelier"]) . "</td>\n\t\t\t\t\t <td><a href=\"index.php?a=14&idatelier=" . $row["id_atelier"] . "\"><button type=\"button\" class=\"btn bg-green btn-sm\" data-toggle=\"tooltip\" title=\"Modifier la programmation\" ><i class=\"fa fa-edit\"></i></button></a>\n\t\t\t\t\t\t<a href=\"index.php?a=14&m=4&idatelier=" . $row["id_atelier"] . "\"><button type=\"button\" class=\"btn bg-red btn-sm\" data-toggle=\"tooltip\" title=\"Déprogrammer\"><i class=\"fa fa-trash-o\"></i></button></a></td>\t\t\t\t\t\n\t\t\t\t\t</tr>";
}
echo "</tbody></table>";
echo "</div></div>";
} else {
if (date('m') >= 8) {
echo "<div class=\"alert alert-info alert-dismissable\" id=\"nextyear\" class=\"fade\"><i class=\"fa fa-warning\"></i>\n <button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>aucune formation programmée pour l'année prochaine</div>";
function checkUserSession($idsession, $iduser)
{
// verifie si le user n'est pas deja inscrit et si il reste des places disponibles.
$sql = "SELECT * FROM `rel_session_user` WHERE `id_session` =" . $idsession . " AND `id_user` =" . $iduser;
$db = opendb();
$result = mysqli_query($db, $sql);
closedb($db);
if (mysqli_num_rows($result) == 0) {
$sql3 = "SELECT `nbplace_session` FROM `tab_session` WHERE `id_session`=" . $idsession;
$db = opendb();
$result3 = mysqli_query($db, $sql3);
$row = mysqli_fetch_array($result3);
closedb($db);
if (countPlace($idsession) < $row["nbplace_session"]) {
return TRUE;
} else {
return TRUE;
//inserer la liste d'attente Attention normalement doit etre FALSE
}
} else {
return FALSE;
}
}
//rajouter la relation des computers à libérer pour epnconnect
if (FALSE == connectAtelierComputer($salle, $idatelier)) {
header("Location: ./index.php?a=11&mesno=0");
} else {
header("Location: ./index.php?a=11&p=ok");
}
}
break;
case 2:
// modifie un poste
if (FALSE == modifAtelier($id, $date, $heure, $duree, $anim, $sujet, $nbplace, $public, $stateAtelier, $salle, $tarif)) {
header("Location: ./index.php?a=11mesno=0");
} else {
if ($stateAtelier == 3) {
//en cas d'annulation d'atelier, l'inscrire dans les stats
$inscrits = countPlace($id);
//adherent en attente
$rattente = getAtelierUser($idatelier, 2);
$attente = mysqli_num_rows($rattente);
InsertStatAS('a', $id, $date, $inscrits, 0, 0, $attente, $nbplace, $stateAtelier);
}
header("Location: ./index.php?a=11&p=ok");
}
break;
}
}
}
}
// Si le bouton supprimé est posté
if ($m == 4) {
if (FALSE == delAtelier($id)) {
//libération pour epnconnect
if ($b == 11) {
if (FALSE != ModifStatusAtelier($idatelier, 1)) {
echo "<div class=\"alert alert-success alert-dismissable\"><i class=\"fa fa-info\"></i>\n <button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button> EpnConnect libère les postes pour l'atelier.</div>";
}
}
//Cloture de l'atelier pour epnconnect
if ($b == 12) {
if (FALSE != ModifStatusAtelier($idatelier, 2)) {
echo "<div class=\"alert alert-success alert-dismissable\"><i class=\"fa fa-info\"></i>\n <button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button> Atelier cloturé, EpnConnect reprends le contrôle !</div>";
}
}
if (countPlace($idatelier) > $row["nbplace_atelier"]) {
$nbplace = 0;
} else {
$nbplace = $row["nbplace_atelier"] - countPlace($idatelier);
}
//adherent en attente
$rattente = getAtelierUser($idatelier, 2);
$enattente = mysqli_num_rows($rattente);
$testTarifAtelier = TestTarifs();
//
////Envoi du mail de rappel
//retrouver les mails de l'epn, les donnees texte subject/body
//coordonnees de l'espace
$arraymail = getMailRappel();
if (FALSE == $arraymail) {
$mailok = 0;
} else {
$espacearray = mysqli_fetch_array(getEspace($idepn));
$mail_epn = $espacearray["mail_espace"];
<div class="box"><div class="box-header"><h3 class="box-title">Au programme cette semaine à l'EPN</h3></div>
<div class="box-body">
<?php
if ($nbe > 0) {
for ($g = 1; $g <= $nbe; $g++) {
$rowTA = mysqli_fetch_array($listeWeekAtelier);
if ($rowTA["tab_origine"] == "tab_atelier") {
$idatelier = $rowTA["id"];
$rowAtelier = getAtelier($idatelier);
$result = getSujetById($rowAtelier["id_sujet"]);
$rowsujet = mysqli_fetch_array($result);
$titre = $rowsujet["label_atelier"];
$heureAS = $rowAtelier["heure_atelier"];
$dateAS = $rowAtelier["date_atelier"];
$anim = getUserName($rowAtelier["anim_atelier"]);
$inscrits = countPlace($rowAtelier["id_atelier"]);
$salle = mysqli_fetch_array(getSalle($rowAtelier["salle_atelier"]));
$nomsalle = $salle["nom_salle"] . " (" . $espaces[$salle["id_espace"]] . ")";
$nomespace = mysqli_fetch_array(getEspace($rowTA["id_espace"]));
$duree = $rowAtelier["duree_atelier"];
$testinscription = getTestInscript($_SESSION["iduser"], $idatelier, "a");
if ($testinscription == "FALSE") {
$urlAS = "index.php?m=6&b=1&idatelier=" . $idatelier;
$boutoninscr = "s'inscrire";
$couleurb = "btn btn-success btn-xs";
} else {
$urlAS = "";
$boutoninscr = $arrayinscrip[$testinscription["statut"]];
$couleurb = "btn btn-warning btn-xs";
}
} elseif ($rowTA["tab_origine"] == "tab_session_dates") {
