function affiche_abs($potache)
{
global $dtajadebut, $dtajafin;
//$potache=$_POST["eleve"];
$horaire = array("M1", "M2", "M3", "M4", "M5", "S1", "S2", "S3", "S4", "S5");
$nbabs = 0;
$nbrtd = 0;
foreach ($horaire as $cle => $val) {
$rq4 = "SELECT count(*) FROM absences WHERE uidprof='{$_SESSION['login']}' AND {$val}='A' AND uideleve='{$potache}' AND date >='{$dtajadebut}' AND date<='{$dtajafin}' ";
$result4 = mysqli_query($dbc, $rq4) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
while ($nb = mysqli_fetch_array($result4, MYSQLI_NUM)) {
$nbabs += $nb[0];
}
$rq5 = "SELECT count(*) FROM absences WHERE uidprof='{$_SESSION['login']}' AND {$val}='R' AND uideleve='{$potache}' AND date >='{$dtajadebut}' AND date<='{$dtajafin}' ";
$result5 = @mysqli_query($GLOBALS["___mysqli_ston"], $rq5) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
while ($nb = mysqli_fetch_array($result5, MYSQLI_NUM)) {
$nbrtd += $nb[0];
}
}
//fin foreach $horaire
if ($nbabs > 0) {
echo "<h3 class='perso'><i>" . $nbabs . "h d'absence - ";
} else {
echo "<h3 class='perso'><i>Aucune absence - ";
}
if ($nbrtd > 0) {
if ($nbrtd > 1) {
echo $nbrtd . " retards <br /></i>";
} else {
echo $nbrtd . " retard <br /></i>";
}
} else {
echo "Aucun retard <br /></i>";
}
$rq = "SELECT DATE_FORMAT(date,'%d/%m/%Y'),M1,motifM1,M2,motifM2,M3,motifM3,M4,motifM4,M5,motifM5,\n S1,motifS1,S2,motifS2,S3,motifS3,S4,motifS4,S5,motifS5,date FROM absences WHERE uidprof='{$_SESSION['login']}' \n AND uideleve='{$potache}' AND date >='{$dtajadebut}' AND date<='{$dtajafin}' ORDER BY date ASC";
// lancer la requete
$result = mysqli_query($GLOBALS["___mysqli_ston"], $rq) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
// Combien y a-t-il d'enregistrements ?
$nb2 = mysqli_num_rows($result);
while ($ligne = mysqli_fetch_array($result, MYSQLI_NUM)) {
$typmat = "";
foreach ($horaire as $cle => $val) {
if ($ligne[2 * $cle + 1] == A) {
$typmat .= " : absence en {$val} ( " . utf8_encode($ligne[2 * $cle + 2]) . " )";
} elseif ($ligne[2 * $cle + 1] == R) {
$typmat .= " : retard en {$val} ( " . utf8_encode($ligne[2 * $cle + 2]) . " )";
} else {
$typmat .= "";
}
}
echo " - Le " . LeJour(strToTime($ligne[21])) . " " . $ligne[0] . " " . $typmat . "<br />";
}
echo '</h3>';
}
" />
<table id="btn-plan-cdt">
<tr>
<td ><input type="submit" name="prec" value="<<" class="bt50" /></td>
<td><input type="submit" name="quit" id="quit" value="" class="bt-exit" /></td>
<td ><input type="submit" name="suiv" value=">>" class="bt50" /> </td>
</tr>
</table>
<table id="plan-cdt" cellpadding="1" cellspacing="1">
<thead>
<tr><th> <img src="../images/livre.gif" alt="." /> </th>
<?php
// Affichage des jours et dates de la semaine en haut du tableau"j-M-Y",
for ($i = 0; $i <= 5; $i++) {
$TS = $Lundi + $i * 86400;
echo '<td colspan="2"> ' . LeJour($TS) . "<br />" . datefr($TS) . "</td>\n";
}
?>
</tr>
</thead>
<tbody>
<?php
$horaire = array("M1<br />", "M2<br />", "M3<br />", "M4<br />", "M5<br />", "S1<br />", "S2<br />", "S3<br />", "S4<br />", "S5<br />");
for ($h = 0; $h <= 9; $h++) {
if (in_array(substr($horaire[$h], 0, 2), $cren_off)) {
echo '<tr><td class="mi-jour" colspan="13"></td></tr>';
continue;
}
//Affichage de la designation des creneaux horaires
echo "<tr><th>" . $horaire[$h] . date('G:i', $deb[$h]) . "-" . date('G:i', $fin[$h]) . "</th>\n";
//Affichage du contenu des creneaux horaires
setlocale(LC_TIME, "french");
} else {
setlocale("LC_TIME", "french");
}
$rq = "SELECT DATE_FORMAT(date,'%d/%m/%Y'),contenu,afaire,DATE_FORMAT(datafaire,'%d/%m/%Y'),id_rubrique,date,date FROM cahiertxt" . $ann_arch . "\n WHERE id_auteur={$cible} ORDER BY date asc";
// lancer la requete
$result = @mysqli_query($GLOBALS["___mysqli_ston"], $rq) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
// Combien y a-t-il d'enregistrements ?
$nb2 = mysqli_num_rows($result);
echo '<table id="tb-cdt" cellpadding="1" cellspacing="2">';
while ($ligne = mysqli_fetch_array($result, MYSQLI_NUM)) {
$textcours = utf8_encode(stripslashes($ligne[1]));
//$textcours=$ligne[1];
$textafaire = utf8_encode(stripslashes($ligne[2]));
//$day="1,0,0,12,1,2007";echo $day;
$jour = LeJour(strToTime($ligne[5]));
//debut
if ($ligne[1] != "") {
echo '<tbody><tr><th colspan="2"></th></tr></tbody>';
echo '<tbody>';
echo '<tr>';
//affichage de la seance
echo '<td class="seance">Séance du <br/>' . $jour . ' ' . $ligne[0] . '<br />Visible le ' . $ligne[7] . ' </td>';
if ($ligne[1] != "" && $ligne[6] == 1) {
echo '<td class="contenu2">';
} elseif ($ligne[1] != "" && $ligne[6] == 2) {
echo '<td class="contenu3">';
} else {
echo '<td class="contenu">';
}
echo $textcours . '</td></tr>';
function Imprime_seance_seq($param)
{
//affiche une sequence associee a une sequence
global $cible;
$rq = "SELECT DATE_FORMAT(date,'%d/%m/%Y'),contenu,afaire,DATE_FORMAT(datafaire,'%d/%m/%Y'),id_rubrique,date,on_off,DATE_FORMAT(datevisibi,'%d/%m/%Y') FROM cahiertxt\n WHERE (id_rubrique={$param}) ";
$result = @mysqli_query($GLOBALS["___mysqli_ston"], $rq) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if (mysqli_num_rows($result) > 0) {
while ($ligne = mysqli_fetch_array($result, MYSQLI_NUM)) {
$textcours = utf8_encode(stripslashes($ligne[1]));
$textafaire = utf8_encode(stripslashes($ligne[2]));
$jour = LeJour(strToTime($ligne[5]));
//debut
if ($ligne[1] != "") {
echo '<tbody><tr>';
//affichage de la seance
echo '<td><span class="cours">Séance du ' . $jour . ' ' . $ligne[0] . ' </span></td></tr>';
echo '<tr ><td>';
echo $textcours . '</td></tr>';
//affichage, s'il existe, du travail a effectuer
if ($ligne[2] != "") {
echo '<tr><td class="afR">A faire pour le : ' . $ligne[3] . '</td><tr>';
echo '<tr><td>' . $textafaire . '</td></tr></tbody>';
}
} else {
echo '<tbody><tr>';
//affichage de la seance
echo '<td><span class="cours">Donné le : ' . $ligne[0] . ' </span></td></tr>';
//affichage, s'il existe, du travail a effectuer
if ($ligne[2] != "") {
echo '<tr><td >Pour le : ' . $ligne[3] . '</td></tr>';
echo '<tr><td >';
echo $textafaire . '</td></tr>';
}
}
echo ' <tr><td ><hr /></td></tr></tbody>';
}
}
}
function Affiche_seance_seq($param, $boutons = FALSE, $tick = "")
{
//affiche une sequence associee a une sequence
global $cible;
if ($cible == "") {
$my_rq = "SELECT `id_auteur` FROM `cahiertxt` WHERE `id_rubrique` =" . $param;
$r = @mysqli_query($GLOBALS["___mysqli_ston"], $my_rq) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
$ret = mysqli_fetch_array($r, MYSQLI_NUM);
$cible = $ret[0];
}
if ($tick == "") {
$tick = md5($_SESSION['RT'] . htmlentities($_SERVER['PHP_SELF']));
}
$rq = "SELECT DATE_FORMAT(date,'%d/%m/%Y'),contenu,afaire,DATE_FORMAT(datafaire,'%d/%m/%Y'),id_rubrique,date,on_off,DATE_FORMAT(datevisibi,'%d/%m/%Y') FROM cahiertxt\n WHERE (id_rubrique={$param}) ";
$result = @mysqli_query($GLOBALS["___mysqli_ston"], $rq) or die(is_object($dbc) ? mysqli_error($dbc) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if (mysqli_num_rows($result) > 0) {
while ($ligne = mysqli_fetch_array($result, MYSQLI_NUM)) {
//$textcours=stripslashes(markdown($ligne[1]));
$textcours = utf8_encode($ligne[1]);
//$textafaire=stripslashes(markdown($ligne[2]));
$textafaire = utf8_encode($ligne[2]);
//$day="1,0,0,12,1,2007";echo $day;
$jour = LeJour(strToTime($ligne[5]));
//debut
if ($ligne[1] != "") {
echo '<tr>';
//affichage de la seance
echo '<td class="seance">Séance du <br/>' . $jour . ' ' . $ligne[0] . '<br />Visible le ' . $ligne[7] . ' </td>';
if ($ligne[1] != "" && $ligne[6] == 1) {
echo '<td class="contenu2">';
} elseif ($ligne[1] != "" && $ligne[6] == 2) {
echo '<td class="contenu3">';
} else {
echo '<td class="contenu">';
}
echo $textcours . '</td></tr>';
//affichage, s'il existe, du travail a effectuer
if ($ligne[2] != "") {
echo '<tr><td class="afaire">A faire pour le :<br/>' . $ligne[3] . '</td><td class="contenu">';
echo $textafaire . '</td></tr>';
}
//fin
echo '<tr><th class="bas" colspan="2">';
if ($_SESSION['cequi'] == "prof" && mb_ereg('prof\\.', $_SERVER['REQUEST_URI']) || $boutons == true) {
echo '<form action="';
echo 'cahier_texte_prof.php';
echo '" method="post"><div><input type="hidden" name="number" value="';
echo $ligne[4];
echo '" /><input type="hidden" name="rubriq" value="';
echo $cible;
echo ' " /><input name="date" type="hidden" value="' . $date . '" />';
if ($ligne[6] == "0") {
echo '<input type="submit" name="modif" value="" class="bt-modifier" />
<input type="submit" name="suppr" value="" class="bt-supprimer" />';
}
echo '<input name="TA" type="hidden" value="' . $tick . '" />';
echo '</div></form>';
}
echo '</th></tr>';
} else {
echo '<tr>';
//affichage de la seance
echo '<td class="afaire">Donné le : ' . $ligne[0] . '<br />Visible le ' . $ligne[7];
//affichage, s'il existe, du travail a effectuer
if ($ligne[2] != "") {
echo '<br />Pour le : ' . $ligne[3] . '</td>';
if ($ligne[6] == 1) {
echo '<td class="contenu2">';
} elseif ($ligne[6] == 2) {
echo '<td class="contenu3">';
} else {
echo '<td class="contenu">';
}
echo $textafaire . '</td></tr>';
}
//fin
echo '<tr><th class="bas" colspan="2">';
if ($_SESSION['cequi'] == "prof" && mb_ereg('prof\\.', $_SERVER['REQUEST_URI']) || $boutons == true) {
echo '<form action="';
echo 'cahier_texte_prof.php';
echo '" method="post"><div><input type="hidden" name="number" value="';
echo $ligne[4];
echo '" /><input type="hidden" name="rubriq" value="';
echo $cible;
echo ' " /><input name="date" type="hidden" value="' . $date . '" />';
if ($ligne[6] == "0") {
echo '<input type="submit" name="modif" value="" class="bt-modifier" />
<input type="submit" name="suppr" value="" class="bt-supprimer" />';
}
echo '<input name="TA" type="hidden" value="' . $tick . '" />';
echo '</div></form>';
}
echo '</th></tr>';
}
}
}
}
" />
<table id="btn-plan-cdt">
<tr>
<td ><input type="submit" name="prec" value="<<" class="bt50" /></td>
<td class="hebdo"> <?echo datefr2($Lundi)?> - <?echo datefr2($Samedi);?></td>
<td ><input type="submit" name="suiv" value=">>" class="bt50" /></td>
</tr>
</table>
<table id="plan-cdt" cellpadding="1" cellspacing="1">
<thead>
<tr><th> </th>
<?php
// Affichage des jours et dates de la semaine en haut du tableau"j-M-Y",
for ($i = 0; $i <= 5; $i++) {
$TS = $Lundi + $i * 86400;
echo '<td class="abs" >' . LeJour($TS) . "</td>";
}
?>
</tr></thead>
<tbody>
<?php
$horaire = array("M1", "M2", "M3", "M4", "M5", "S1", "S2", "S3", "S4", "S5");
for ($h = 0; $h <= 9; $h++) {
if (in_array($horaire[$h], $cren_off)) {
echo '<tr><td class="mi-jour" colspan="7"></td></tr>';
continue;
}
//Affichage de la designation des creneaux horaires
echo "<tr><th>" . $horaire[$h] . "</th>\n";
//Affichage du contenu des creneaux horaires
for ($j = 0; $j <= 5; $j++) {
if ($result) {
$id = array();
$cours = array();
$afR = array();
$n = 0;
while ($enrg = mysqli_fetch_array($result, MYSQLI_NUM)) {
$id[$n] = $enrg[0];
$cours[$n] = utf8_encode(mb_ereg_replace("../../../", "http://" . $hostname . "." . $domain . "/", $enrg[1]));
$afR[$n] = utf8_encode(mb_ereg_replace("../../../", "http://" . $hostname . "." . $domain . "/", $enrg[2]));
$n++;
}
}
mysqli_free_result($result) || is_object($result) && get_class($result) == "mysqli_result" ? true : false;
echo '<tr>
<td rowspan="' . count($id) . '" class="date">
<p>' . LeJour(strToTime($list_dates[$loop1])) . '<br />' . $list_dattes[$loop1] . '</p>
</td>';
// pour chaque jour
for ($loop2 = 0; $loop2 < count($id); $loop2++) {
//recherche donnes auteur
$rq = "SELECT prefix,prof,matiere from onglets WHERE id_prof='{$id[$loop2]}'";
//echo $rq;exit;
$result = @mysqli_query($GLOBALS["___mysqli_ston"], $rq);
if ($result) {
while ($enrg = mysqli_fetch_array($result, MYSQLI_NUM)) {
$Prof = utf8_encode($enrg[0]) . " " . utf8_encode($enrg[1]);
$matiere = utf8_encode($enrg[2]);
}
}
mysqli_free_result($result) || is_object($result) && get_class($result) == "mysqli_result" ? true : false;
if ($loop2 > 0) {
