echo "<input value='2' name='etape' type='hidden' />\n";
echo "<input value='valider' name='Valider' id='valid2' type='submit' onClick=\"this.form.submit();this.disabled=true;this.value='En cours'\" />\n";
echo "</div>\n";
echo "</div>\n";
}
echo "</form>\n";
}
//==================================================================================
/* affichage vignettes */
if ($etape === '2' and $classe != 'toutes' and $groupe != 'toutes' and $discipline != 'toutes' and $equipepeda != 'toutes' and ($classe != '' or $groupe != '' or $aid != '' or $equipepeda != '' or $discipline != '' or $statusgepi != '')) {
echo "<div style='text-align: center;'>\n";
echo "<table width='100%' border='0' cellspacing='0' cellpadding='2' style='border : thin dashed #242424; background-color: #FFFFB8;' summary='Choix'>\n";
echo "<tr valign='top'>\n";
echo "<td align='left'><font>TROMBINOSCOPE ";
$datej = date('Y-m-d');
$annee_en_cours_t = annee_en_cours_t($datej);
echo $annee_en_cours_t;
echo "<br />\n";
echo "<b>\n";
// on regarde ce qui a été choisi
if ($classe != '' and $groupe === '' and $aid === '' and $equipepeda === '' and $discipline === '' and $statusgepi === '') {
// c'est une classe
$action_affiche = 'classe';
} elseif ($classe === '' and $groupe != '' and $aid === '' and $equipepeda === '' and $discipline === '' and $statusgepi === '') {
// c'est un groupe
$action_affiche = 'groupe';
} elseif ($classe === '' and $groupe === '' and $aid != '' and $equipepeda === '' and $discipline === '' and $statusgepi === '') {
// c'est un groupe
$action_affiche = 'aid';
} elseif ($classe === '' and $groupe === '' and $equipepeda != '' and $discipline === '' and $statusgepi === '') {
// c'est une équipe pédagogique
else { if (isset($_GET['du'])) {$du=$_GET['du'];} if (isset($_POST['du'])) {$du=$_POST['du'];} }
if (empty($_GET['au']) AND empty($_POST['au'])) {$au="";}
else { if (isset($_GET['au'])) {$au=$_GET['au'];} if (isset($_POST['au'])) {$au=$_POST['au'];} }
if (empty($_GET['recherche']) AND empty($_POST['recherche'])) {$recherche="";}
else { if (isset($_GET['recherche'])) {$recherche=$_GET['recherche'];} if (isset($_POST['recherche'])) {$recherche=$_POST['recherche'];} }
if ($type == "A" and $submit2 == "") {$type="A"; $justifie="1"; $nonjustifie="1"; $motif="tous"; $classe_choix="tous"; $eleve_choix="tous"; $du="$date_ce_jour"; $au="jj/mm/aaaa";}
if ($type == "D" and $submit2 == "") {$type="D"; $justifie="1"; $nonjustifie="1"; $motif="tous"; $classe_choix="tous"; $eleve_choix="tous"; $du="$date_ce_jour"; $au="jj/mm/aaaa";}
if ($type == "R" and $submit2 == "") {$type="R"; $justifie="1"; $nonjustifie="1"; $motif="tous"; $classe_choix="tous"; $eleve_choix="tous"; $du="$date_ce_jour"; $au="jj/mm/aaaa";}
if ($type == "I" and $submit2 == "") {$type="I"; $justifie="1"; $nonjustifie="1"; $motif="tous"; $classe_choix="tous"; $eleve_choix="tous"; $du="$date_ce_jour"; $au="jj/mm/aaaa";}
if ($du == "jj/mm/aaaa" OR $du == "") {$du = $date_ce_jour; }
if ($au == "jj/mm/aaaa" OR $au == "") {$au = $du; }
//Quelle que variabale
$datej = date('Y-m-d');
$annee_scolaire=annee_en_cours_t($datej);
//REQUETE
//requête pour liste les motif d'absence
$requete_liste_motif = "SELECT init_motif_absence, def_motif_absence FROM ".$prefix_base."absences_motifs ORDER BY init_motif_absence ASC";
//requete sur les champs des tableaus
if ($motif == "tous" AND $classe_choix == "tous" AND $eleve_choix == "tous" AND $justifie == "1" AND $nonjustifie == "1")
{
$requete_recherche = "SELECT * FROM ".$prefix_base."absences_eleves, ".$prefix_base."eleves WHERE type_absence_eleve = '".$type."' AND eleve_absence_eleve = login AND ((d_date_absence_eleve >= '".date_sql($du)."' AND d_date_absence_eleve <= '".date_sql($au)."') OR (a_date_absence_eleve >= '".date_sql($du)."' AND a_date_absence_eleve <= '".date_sql($au)."')) ORDER BY nom, prenom ASC";
}
if ($motif == "tous" AND $classe_choix == "tous" AND $eleve_choix == "tous" AND $justifie == "1" AND $nonjustifie != "1")
{
$requete_recherche = "SELECT * FROM ".$prefix_base."absences_eleves, ".$prefix_base."eleves WHERE type_absence_eleve = '".$type."' AND eleve_absence_eleve = login AND ((d_date_absence_eleve >= '".date_sql($du)."' AND d_date_absence_eleve <= '".date_sql($au)."') OR (a_date_absence_eleve >= '".date_sql($du)."' AND a_date_absence_eleve <= '".date_sql($au)."')) AND justify_absence_eleve = 'O' ORDER BY nom, prenom ASC";
}
$total = $total + 1;
}
// si tout est ok on redirige
if(!isset($id_absence_eleve_erreur[0]) and empty($id_absence_eleve_erreur[0]))
{
if ( $action_sql === "ajouter" ) { header("Location:select.php?type=R"); }
if ( $action_sql === "modifier" ) {
if($fiche==='oui') { header("Location:gestion_absences.php?type=R&select_fiche_eleve=$id_absence_eleve_form&aff_fiche=abseleve#abseleve"); } else { header("Location:gestion_absences.php?type=R"); }
}
}
}
$datej = date('Y-m-d'); $annee_en_cours_t=annee_en_cours_t($datej);
$datejour = date('d/m/Y');
if ($action === "supprimer")
{
include "../lib/function_abs.php";
if (empty($_GET['date_ce_jour']) and empty($_POST['date_ce_jour'])) { $date_ce_jour = ''; }
else { if (isset($_GET['date_ce_jour'])) { $date_ce_jour = $_GET['date_ce_jour']; } if (isset($_POST['date_ce_jour'])) { $date_ce_jour = $_POST['date_ce_jour']; } }
$id_absence_eleve = $_GET['id'];
$requete_sup = "SELECT eleve_absence_eleve FROM ".$prefix_base."absences_eleves
WHERE id_absence_eleve ='$id_absence_eleve'";
$resultat_sup = mysqli_query($GLOBALS["mysqli"], $requete_sup) or die('Erreur SQL !'.$requete_sup.'<br />'.mysqli_error($GLOBALS["mysqli"]));
$login_eleve = mysqli_fetch_array($resultat_sup);
// fonction affiche les moyennes avec les arrondies et le nombre de chiffre après la virgule
// precision '0.01' '0.1' '0.25' '0.5' '1'
function present_nombre($nombre, $precision, $nb_chiffre_virgule, $chiffre_avec_zero)
{
if ( $precision === '' or $precision === '0.0' or $precision === '0' ) { $precision = '0.01'; }
$nombre=number_format(round($nombre/$precision)*$precision, $nb_chiffre_virgule, ',', '');
$nombre_explose = explode(",",$nombre);
if($nombre_explose[1]==='0' and $chiffre_avec_zero==='1') { $nombre=$nombre_explose[0]; }
return($nombre);
}
// Variable prédéfinie
$date_ce_jour = date('d/m/Y');
$date_ce_jour_sql = date('Y-m-d');
$annee_scolaire = annee_en_cours_t($date_ce_jour_sql);
// donnée de l'axe X
$donnee_x = '';
// donnée de l'axe Y
$donnee_y = '';
// texte des labels
$donnee_label = '';
// titre du graphique
$donnee_titre = '';
$type_selectionne = '';
$classe_selectionne = '';
$eleve_selectionne = '';
$type_selectionne_titre = '';
$cpt_donnees = '0';
$donnee_select = '';
$cpt_photo = $cpt_photo + 1;
}
$total = $cpt_photo;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Trombinoscope</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<div style="text-align: center;">
<table width="100%" border="0" cellspacing="0" cellpadding="2" style="border : 1px solid #010101;" align="center" summary="Trombinoscope">
<tr>
<td width="70%" height="20" style="text-align: left; ">
<span style="font-size: 12px;">TROMBINOSCOPE <?php $datej = date('Y-m-d'); $annee_en_cours_t=annee_en_cours_t($datej); echo $annee_en_cours_t; ?></span><br />
<span style="font-size: 16px; font-weight: bold;"><?php echo $entete; ?></span>
</td>
</tr>
</table>
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="1" align="center" summary="Trombinoscope">
<?php
unset($tmp_id_classe);
if (($action_affiche=='equipepeda')||
($action_affiche=='discipline')||
($action_affiche=='statusgepi')) {
if($_SESSION['statut']=='eleve') {
