$filtre = !empty($_POST['filtre']) ? trim($_POST['filtre']) : '';
$sienne = !empty($_POST['chambre']) ? $_POST['chambre'] : '';
$chambres_ = $pdo->query('SELECT ' . 'c.id, ' . 'c.batiment, ' . 'c.etage, ' . 'c.numero, ' . 'c.etat, ' . 'COUNT(cp.id_participant) AS filles ' . 'FROM chambres AS c ' . 'LEFT JOIN chambres_participants AS cp ON ' . 'cp.id_chambre = c.id ' . 'WHERE ' . (empty($_POST['amies']) ? 'c.etat = "autorise" OR ' : '') . 'c.etat = "amies" ' . 'GROUP BY ' . 'c.id ' . 'ORDER BY ' . 'c.etat DESC, ' . 'c.batiment, ' . 'c.etage, ' . 'c.numero') or DEBUG_ACTIVE && die(print_r($pdo->errorInfo()));
$chambres_ = $chambres_->fetchAll(PDO::FETCH_ASSOC);
$chambres = [];
if (empty($filtre) && empty($_POST['amies'])) {
$chambres[] = array('id' => '', 'value' => '(Sans chambre)', 'numero' => '', 'color' => 'transparent');
}
foreach ($chambres_ as $chambre) {
$numero = sprintf('%s%d%02d', $chambre['batiment'], $chambre['etage'], $chambre['numero']);
$places = in_array($chambre['batiment'], str_split('ABC')) ? 5 : 3;
$places -= $chambre['filles'];
if (!empty($filtre) && strpos($numero, $filtre) === false || $places <= 0 && $sienne != $numero) {
continue;
}
$chambres[] = array('id' => $chambre['id'], 'value' => $numero . (empty($_POST['amies']) && $chambre['etat'] == 'amies' ? ' #Amies ' : '') . ' (' . (empty($_POST['amies']) && $numero == $sienne ? 'La sienne' : $places . ' place' . ($places > 1 ? 's' : '')) . ')', 'numero' => $numero, 'color' => colorChambre($numero));
}
header('Content-Type: application/json', true);
echo json_encode($chambres);
exit;
}
$ecoles = $pdo->query('SELECT ' . 'e.id, ' . 'e.nom ' . 'FROM ecoles AS e ' . 'ORDER BY ' . 'e.nom ASC') or DEBUG_ACTIVE && die(print_r($pdo->errorInfo()));
$ecoles = $ecoles->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_UNIQUE);
if (!empty($_GET['ecole']) && in_array($_GET['ecole'], array_keys($ecoles))) {
if (!empty($_GET['del']) && intval($_GET['del'])) {
$pdo->exec('DELETE FROM chambres_participants WHERE id_participant = ' . $_GET['del']);
}
$filles = $pdo->query('SELECT ' . 'p.id, ' . 'p.nom, ' . 'e.nom AS enom, ' . 'p.prenom, ' . 's.id AS sid, ' . 's.sport, ' . 's.sexe, ' . 'p.telephone, ' . 'c.id AS cid, ' . 'c.batiment, ' . 'c.etage, ' . 'c.numero ' . 'FROM participants AS p ' . 'JOIN tarifs AS t ON ' . 't.id = p.id_tarif AND ' . 't.logement = 1 ' . 'JOIN ecoles AS e ON ' . 'e.id = p.id_ecole ' . 'LEFT JOIN sportifs AS sp ON ' . 'sp.id_participant = p.id ' . 'LEFT JOIN sports AS s ON ' . 's.id = sp.id_sport ' . 'LEFT JOIN chambres_participants AS cp ON ' . 'cp.id_participant = p.id ' . 'LEFT JOIN chambres AS c ON ' . 'c.id = cp.id_chambre ' . 'WHERE ' . 'p.sexe = "f" AND ' . 'p.id_ecole = ' . (int) $_GET['ecole'] . ' ' . 'ORDER BY ' . 'e.nom ASC, ' . 's.sport ASC, ' . 'p.nom ASC, ' . 'p.prenom ASC') or DEBUG_ACTIVE && die(print_r($pdo->errorInfo()));
$filles = $filles->fetchAll(PDO::FETCH_ASSOC);
$filles_non_logees = $pdo->query('SELECT ' . 'p.id, ' . 'p.nom, ' . 'p.prenom ' . 'FROM participants AS p ' . 'JOIN tarifs AS t ON ' . 't.id = p.id_tarif AND ' . 't.logement = 0 ' . 'JOIN ecoles AS e ON ' . 'e.id = p.id_ecole ' . 'WHERE ' . 'p.sexe = "f" AND ' . 'p.id_ecole = ' . (int) $_GET['ecole'] . ' AND ' . 'p.id NOT IN (SELECT ' . 'cp.id_participant ' . 'FROM chambres_participants AS cp) ' . 'ORDER BY ' . 'p.nom ASC, ' . 'p.prenom ASC') or DEBUG_ACTIVE && die(print_r($pdo->errorInfo()));
$filles_non_logees = $filles_non_logees->fetchAll(PDO::FETCH_ASSOC);
echo $i;
?>
</th>
<?php
}
?>
<th style="width:150px">Clefs</th>
<th style="width:100px">Lit de Camp</th>
</tr>
<?php
$header = ob_get_clean();
$nb = 0;
foreach (range(1, $chambres) as $numero) {
$chambre = sprintf('%s%d%02d', $batiment, $etage, $numero);
$color = colorChambre($chambre);
$proprio = isset($proprios[$chambre]) ? $proprios[$chambre] : null;
if ($proprio == null) {
continue;
}
if (!$nb) {
echo $header;
}
$nb++;
?>
<tr class="form">
<td style="background-color:<?php
echo $color;
?>
;color:<?php
<tr class="vide">
<td colspan="6">Aucune amie logée</td>
</tr>
<?php
} else {
foreach ($amies_logees as $fille) {
$numero = !empty($fille['cid']) ? sprintf('%s%d%02d', $fille['batiment'], $fille['etage'], $fille['numero']) : '';
?>
<tr class="form">
<td style="width:150px !important">
<input style="background-color:<?php
echo empty($fille['cid']) ? 'transparent' : colorChambre($numero);
?>
" type="text" readonly value="<?php
echo $numero;
?>
" />
</td>
<td><div><?php
echo empty($fille['sid']) ? '<i>Sans sport</i>' : stripslashes($fille['sport']) . ' ' . printSexe($fille['sexe']);
?>
</div></td>
<td><div><?php
echo stripslashes(strtoupper($fille['nom']));
?>
</div></td>
<td><div><?php
