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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
// Premier formulaire
$tabSuite1 = (isset($_POST['suite1']))?$_POST['suite1']:null;
// bouclons sur le tableau qui a été transmis et affichons les valeurs sélectionnées
if (!empty($tabSuite1))
{
foreach($tabSuite1 as $cle => $id1)
{
OpenTable();
$query="select * from gpoint_personne where dept='$id1'";
$result=mysql_query($query);
$nb=mysql_numrows($result);
echo "<div align='center'>";
echo "<br />";
echo "<table cellspacing='1' width='100%'>";
echo "<tr>";
$query_departement="select descriptif_departement from gpoint_departement where id_departement='$id1'";
$result_departement=mysql_query($query_departement);
$nom_departement=mysql_result($result_departement,"descriptif_departement");
echo "<h6 style='color:red'>$nom_departement</h6>";
echo "</tr>";
echo "<tr bgcolor='#B0C4DE' ALIGN='center' valign='middle' >";
//l'id
echo "<td>";
echo "<h6>Technicien / Personnel</h6></a>";
echo "</td>";
//le type
echo "<td>";
echo "<h6>Product</h6>";
echo "</td>";
//le statut
echo "<td>";
echo "<h6>RTT Perso </h6></a>";
echo "</td>";
//modele
echo "<td>";
echo "<h6>RTT Direct</h6></a>";
echo "</td>";
//num_serie
echo "<td>";
echo "<h6>Congès légaux</h6>";
echo "</td>";
//le login
echo "<td>";
echo "<h6>Congès Evt Fam</h6></a>";
echo "</td>";
//le departement
echo "<td>";
echo "<h6>Congès Ss solde</h6></a>";
echo "</td>";
//la localisation
echo "<td>";
echo "<h6>Format.</h6></a>";
echo "</td>";
//PROCHAIN ENTRETIEN
echo "<td>";
echo "<h6>Qualité</h6></a>";
echo "</td>";
//prochaine verification
echo "<td>";
echo "<h6>Maladie</h6></a>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Accident de travail</h6>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Absence non justifiée</h6>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Délégué CE-DP</h6>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Divers N.Prod</h6>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Admin Général</h6>";
echo "</td>";
//fiche actif
echo "<td>";
echo "<h6>Total</h6>";
echo "</td>";
echo "</tr>";
for($i=0;$i<$nb;$i++){
$nom=mysql_result($result,$i,"nom");
$product=mysql_result($result,$i,"product");
$rtt_perso=mysql_result($result,$i,"rtt_perso");
$rtt_direct=mysql_result($result,$i,"rtt_direct");
$conges_legaux=mysql_result($result,$i,"conges_legaux");
$conges_fam=mysql_result($result,$i,"conges_fam");
$conges_ss_solde=mysql_result($result,$i,"conges_ss_solde");
$format=mysql_result($result,$i,"format");
$qualite=mysql_result($result,$i,"qualite");
$maladie=mysql_result($result,$i,"maladie");
$accident=mysql_result($result,$i,"accident");
$absence=mysql_result($result,$i,"absence");
$deleg=mysql_result($result,$i,"deleg");
$divers=mysql_result($result,$i,"divers");
$admin_genral=mysql_result($result,$i,"admin_genral");
// ici le test de couleur pour modifier la couleur de la ligne
if($couleur==1){
echo "<tr bgcolor='#DDDDDD' ALIGN='center'>";
$couleur=0;
}
else{
echo "<tr bgcolor='#FFEBCD' ALIGN='center'>";
$couleur=1;
}
echo "<td>";
echo "$nom ";
echo "</td>";
echo "<td>";
echo "$login ";
echo "</td>";
echo "<td>";
echo "$pass ";
echo "</td>";
echo "<td>";
echo "$serial ";
echo "</td>";
echo "<td>";
echo "$login";
echo "</td>";
echo "<td>";
echo "$departement ";
echo "</td>";
echo "<td>";
echo "$localisation";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "<td>";
echo "$modele ";
echo "</td>";
echo "</tr>";
}
echo "</table>";
echo "</div>";
CloseTable();
}
}
//________________________________________________________________________________________________________________________________________________ // Deuxième formulaire
$tabSuite2 = (isset($_POST['suite2']))?$_POST['suite2']:null;
// bouclons sur le tableau qui a été transmis et affichons les valeurs sélectionnées
if (!empty($tabSuite2))
{
foreach($tabSuite2 as $cle => $id2)
{
echo $id2;
}
}
// recuperation date
if (isset($_POST['date_debut']) && isset($_POST['date_fin'])) {
echo ' - La date de debut est '.$_POST['date_debut'].' et la date de fin est '.$_POST['date_fin'];
} |
