1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
| <?php
$date = date("d/m/Y");
$heure = date("H:i");
Print("Nous sommes le $date et il est $heure");
$iddate=$date;
?>
<form method="post" action="toutesabsbis2dates.php">
<br><a href="abs_index.php">Accueil</a>
<a href="toutesabsbis2dates.php">Afficher TOUTES les ABSENCES !</a> <br><br>
DEBUT souhaité (format 01/09/2009): <input type="text" name="date1" size="12">
FIN souhaitée (format 01/09/2009) :<input type="text" name="date2" size="12">
<input type="submit" value="Valider les dates">
</form>
<?php
$debut = $_POST['date1'];
$fin = $_POST['date2'];
print("<center>Dates choisies ENTRE le: $debut ET le: $fin</center>");
//echo $debut;
//echo $fin;
if(isset($_POST['date1']) && $_POST['date2'])
{
$dateA = $debut;
$annee = substr($dateA, 6, 4);
$mois = substr($dateA, 3, 2);
$jour = substr($dateA, 0, 2);
//echo $jour . '-' . $mois . '-' . $annee;
//echo $annee . '/' . $mois . '/' . $jour;
$date3=$annee . '-' . $mois . '-' . $jour;
$dateB = $fin;
$annee1 = substr($dateB, 6, 4);
$mois1 = substr($dateB, 3, 2);
$jour1 = substr($dateB, 0, 2);
//echo $jour1 . '-' . $mois1 . '-' . $annee1;
//echo $annee1 . '/' . $mois1 . '/' . $jour1;
$date4=$annee1 . '-' . $mois1 . '-' . $jour1;
$clause = " AND (QUAND1 BETWEEN '$date3' and '$date4')";
}
$orderby = " ORDER BY QUAND1";
//$sql = "SELECT * FROM ges_abs where JUST1='N' " . $clause . $orderby;
$sql = "SELECT * FROM ges_abs WHERE JUSTIFICATION ='N' " . $clause . $orderby;
$resultat = mysql_query ($sql);
$date=$motclef;
echo "Il y a ".mysql_num_rows($resultat)." absences NON JUSTIFIEES entre ces deux dates.";
//cho "<br>";
//echo $date;
//echo "<br>";
//echo $sql;
while ($eleve = mysql_fetch_array ($resultat))
{
?>
<?php
// début du code affichage des sanctions
{
// on affiche les informations de l'enregistrement en cours
$sql2 = "SELECT * FROM `elevescomplete` WHERE `Eléve No Etab` LIKE '".$eleve['id']."' group by 'Eléve No Etab'";
$resultat2 = mysql_query ($sql2);
$eleve2 = mysql_fetch_array ($resultat2);
$dateMySQL = $eleve['QUAND1'];
$date1=date("d/m/Y", strtotime($dateMySQL));
echo '</table>';
echo "<hr size=\"1\" color=\"black\">";
echo '<b>
'.$eleve['id'].'';
$id1= $eleve['Numero'];
echo '<table border=0 align=center border=0 cellpadding=3 cellspacing=4 width="50%">';
echo'<td>Nom: <B> '.$eleve['elenom'].'</td>';
echo'<td>Prénom: <B> '.$eleve['elepre'].'</td>';
echo'<td>Classe: <B> '.$eleve['divcod'].'</td>';
//echo'<tr>';
echo'<td>Auteur ABSENCE: <B> '.$eleve['Qui'].'</td>';
echo'<td>Date ABSENCE:<B><br>'.$date1.'</td>';
echo'<td>DE:<B>'.$eleve['Heures1'].'</td>';
echo'<td>A:<B>'.$eleve['Heures1bis'].'</td>';
echo'<td>JUSTIFICATION:<B>'.$eleve['JUSTIFICATION'].'</td><br>';
echo'<td>REMARQUES:<B>'.$eleve['REMARQUES1'].'</td>';
echo'<td>ACTION FAITE:<B><br>'.$eleve['ACTION1'].'</td>';
echo'<td>Numéro:<B>'.$eleve['Numero'].'</td>';
echo'<td>RETARD ?:<B>'.$eleve['RETARD'].'</td><br>';
echo'<td>Remarque RETARD:<B>'.$eleve['RQRETARD'].'</td>';
//echo'<tr>';
//echo "<td>$id</td>";
//echo $eleve['id'];
//echo $date;
//echo "<table border=0 align=center border=0 cellpadding=3 cellspacing=4 bgcolor=#00FFFF >";
//echo "<td><a href=abs_faitebis.php?id1=$id1> TRAITER cette ABSENCE </a></td>";
//echo " <td><a href=abs_modifierbis.php?id1=$id1> MODIFIER cette ABSENCE </a></td>";
//echo "<td><a href=imprimerabs.php?id=$id1> IMPRIMER cette ABSENCE </a></td> ";
//echo "<td><a href=supp1abs.php?id1=$id1> Supprimer cette ABSENCE </a></td> ";
//echo "</tr>";
//echo "</table>" ;
//echo "<br><a href=abs_faitebis.php?id1=$id1> TRAITER cette ABSENCE </a>";
//echo "<a href=abs_modifierbis.php?id1=$id1> MODIFIER cette ABSENCE </a>";
//echo "<a href=supp1abs.php?id1=$id1> Supprimer cette ABSENCE </a>";
//echo "<br><a href=imprimerabs.php?id=$id1> Imprimer </a>";
//echo "<br>";
//echo "<br>";
// Fin du code affichage des sanctions
}
}
?> |
Partager