$id = $_POST['coll_demande'];
list($_POST['mois'], $_POST['annee']) = explode('-', $_POST['date_demande']);
unset($_POST['demande']);
$action = 'valider';
$texte = 'Validation ';
} elseif (isset($_POST['mode']) && $_POST['mode'] == 'voir') {
$id = $_POST['col_id'];
$action = 'valider';
$texte = 'Validation ';
} else {
$id = $_SESSION['col_id'];
}
if (isset($_SERVER['REDIRECT_HTTP_REFERER'])) {
print_r($_SERVER['REDIRECT_HTTP_REFERER']);
}
$table = generer_calendrier($id);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr">
<head>
<title>Demande de congés</title>
<?php
include "head.php";
?>
<style>
tr {
height: 25px;
}
td {
min-width: 25px;
}
if ($abs == true) {
$query_comm = "SELECT AC.COM_NO, C.COM_TEXTE, A.ABS_ETAT, A.ABS_JOUR FROM ABSENCE A, COMMENTAIRE C, ABSENCE_COMMENTAIRE AC WHERE A.ABS_NO = AC.ABS_NO AND AC.COM_NO = C.COM_NO AND A.ABS_NO IN (" . implode(', ', $tab_abs_no) . ") ORDER BY A.ABS_ETAT, A.ABS_JOUR;";
$result_comm = $GLOBALS['connexion']->query($query_comm);
while ($row_comm = $result_comm->fetch_assoc()) {
$tab_com[$row_comm['COM_NO']][$row_comm['COM_TEXTE']][$row_comm['ABS_ETAT']][] = $row_comm['ABS_JOUR'];
}
$query = "SELECT * FROM ABSENCE WHERE ABS_NO IN (" . implode(', ', $tab_abs_no) . ") AND ABS_ETAT = 1 ORDER BY ABS_JOUR";
$result = $GLOBALS['connexion']->query($query);
if (mysqli_num_rows($result) > 0) {
$affiche = true;
}
while ($row = $result->fetch_assoc()) {
$tab_jour[] = $row['ABS_JOUR'];
}
}
$conges = generer_calendrier($row_coll['COL_NO']);
if ($abs == false) {
$tableau = '<tr id ="' . $row_coll['COL_NO'] . '">' . '<td class="nomColl" id="' . $row_coll['COL_NO'] . '">' . $row_coll['COL_NOM'] . '<br />' . $row_coll['COL_PRENOM'] . ' </td>' . '<td class="calendrier">' . $conges['calendrier'] . '</td>' . '<td class="not_printed"></td>' . '<td class="not_printed"></td>';
} else {
$tableau = '<tr id ="' . $row_coll['COL_NO'] . '">' . '<td class="nomColl" id="' . $row_coll['COL_NO'] . '">' . $row_coll['COL_NOM'] . '<br />' . $row_coll['COL_PRENOM'] . '</td>' . '<td class="calendrier">' . $conges['calendrier'] . '</td>' . '<td class="not_printed"><strong>Droit aux congés</strong><br />' . radio('droit' . $row_coll['COL_NO'], $droit) . '<br /><strong>Client notifié</strong><br />' . radio('notification' . $row_coll['COL_NO'], $notification) . '<br /></td>';
$tableau .= '<td class="not_printed"><strong>Etats et commentaires</strong><br />';
if ($affiche == true) {
$tableau .= '<strong>Congés acceptés</strong><br />';
$tableau .= implode(',', $tab_jour) . '<br />';
}
foreach ($tab_com as $idcom => $values) {
foreach ($values as $com => $values1) {
foreach ($values1 as $etat => $jour) {
if ($etat == 2 && $debutSR == true) {
$tableau .= '<strong>Congés acceptés sous réserves</strong><br />';
$debutSR = false;
if ($abs == true) {
$query_comm = "SELECT AC.COM_NO, C.COM_TEXTE, A.ABS_ETAT, A.ABS_JOUR FROM ABSENCE A, COMMENTAIRE C, ABSENCE_COMMENTAIRE AC WHERE A.ABS_NO = AC.ABS_NO AND AC.COM_NO = C.COM_NO AND A.ABS_NO IN (" . implode(', ', $tab_abs_no) . ") ORDER BY A.ABS_ETAT, ABS_JOUR;";
$result_comm = $GLOBALS['connexion']->query($query_comm);
while ($row_comm = $result_comm->fetch_assoc()) {
$tab_com[$row_comm['COM_NO']][$row_comm['COM_TEXTE']][$row_comm['ABS_ETAT']][] = $row_comm['ABS_JOUR'];
}
$query = "SELECT * FROM ABSENCE WHERE ABS_NO IN (" . implode(', ', $tab_abs_no) . ") AND ABS_ETAT = 1 ORDER BY ABS_JOUR";
$result = $GLOBALS['connexion']->query($query);
if (mysqli_num_rows($result) > 0) {
$affiche = true;
}
while ($row = $result->fetch_assoc()) {
$tab_jour[] = $row['ABS_JOUR'];
}
}
$conges = generer_calendrier($id_col, $id_mois, $_POST['annee']);
if ($abs == false) {
$tableau = '<tr>' . '<td>' . $mois . ' ' . $_POST['annee'] . '</td>' . '<td class="calendrier">' . $conges['calendrier'] . '</td>' . '<td class="not_printed"></td>' . '<td class="not_printed"></td>';
} else {
$tableau = '<tr>' . '<td>' . $mois . ' ' . $_POST['annee'] . '</td>' . '<td class="calendrier">' . $conges['calendrier'] . '</td>' . '<td class="not_printed"><strong>Droit aux congés</strong><br />' . ($droit == 1 ? 'Oui' : 'Non') . '<br /><strong>Client notifié</strong><br />' . ($notification == 1 ? 'Oui' : 'Non') . '<br /></td>';
$tableau .= '<td class="not_printed">';
if ($affiche == true) {
$tableau .= '<strong>Congés acceptés</strong><br />';
$tableau .= implode(',', $tab_jour) . '<br />';
}
foreach ($tab_com as $idcom => $values) {
foreach ($values as $com => $values1) {
foreach ($values1 as $etat => $jour) {
if ($etat == 2 && $debutSR == true) {
$tableau .= '<strong>Congés acceptés sous réserves</strong><br />';
$debutSR = false;
