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
}
}
?> |
between et formulaire
une idée ?
Répondre avec citation
Envoyé par sabotage
Partager