231 |
alex |
1 |
<?
|
|
|
2 |
// +--------------------------------------------------------------------------------+
|
|
|
3 |
// | liste_inscrit.php |
|
|
|
4 |
// +--------------------------------------------------------------------------------+
|
|
|
5 |
// | Copyright (c) 2002 |
|
|
|
6 |
// +--------------------------------------------------------------------------------+
|
|
|
7 |
// | |
|
|
|
8 |
// +--------------------------------------------------------------------------------+
|
|
|
9 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> |
|
|
|
10 |
// +--------------------------------------------------------------------------------+
|
|
|
11 |
//
|
|
|
12 |
// $Id: liste_inscrit.php,v 1.1 2004-12-15 13:33:03 alex Exp $
|
|
|
13 |
|
|
|
14 |
global $HTTP_USER_AGENT;
|
|
|
15 |
|
|
|
16 |
$classe_titre = 'titlePage' ;
|
|
|
17 |
|
|
|
18 |
$javascript = "function confirmer ()
|
|
|
19 |
{
|
|
|
20 |
if (window.confirm ('Cliquez sur OK pour confirmer.')) {
|
|
|
21 |
window.formmail.submit();
|
|
|
22 |
}
|
|
|
23 |
}
|
|
|
24 |
function setCheckboxes(the_form)
|
|
|
25 |
{
|
|
|
26 |
var do_check=document.forms[the_form].elements['selecttotal'].checked;
|
|
|
27 |
var elts = document.forms[the_form].elements['select[]'];
|
|
|
28 |
var elts_cnt = (typeof(elts.length) != 'undefined')
|
|
|
29 |
? elts.length
|
|
|
30 |
: 0;
|
|
|
31 |
if (elts_cnt) {
|
|
|
32 |
for (var i = 0; i < elts_cnt; i++) {
|
|
|
33 |
elts[i].checked = do_check;
|
|
|
34 |
} // Fin for
|
|
|
35 |
}
|
|
|
36 |
else {
|
|
|
37 |
elts.checked = do_check;
|
|
|
38 |
} // Fin if... else
|
|
|
39 |
return true;
|
|
|
40 |
} // Fin de la fonction 'setCheckboxes()'";
|
|
|
41 |
|
|
|
42 |
GEN_stockerCodeScript($javascript);
|
|
|
43 |
|
|
|
44 |
$url = CAR_URL ;
|
|
|
45 |
|
|
|
46 |
$res = "";
|
|
|
47 |
|
|
|
48 |
$tabmonde = explode ('*',$monde->historique);
|
|
|
49 |
|
|
|
50 |
// Premier cas, on vient de cliquer sur un pays qui n'est pas
|
|
|
51 |
// la France, on affiche les adhérents de ce pays
|
|
|
52 |
|
|
|
53 |
if (count($tabmonde) == 3) {
|
|
|
54 |
$argument = $tabmonde[2];
|
|
|
55 |
|
|
|
56 |
$query = "select * from carto_PAYS where CP_ID_pays='$argument'";
|
|
|
57 |
$result = $GLOBALS['car_db']->query($query);
|
|
|
58 |
if (DB::isError($resultat)) {
|
|
|
59 |
die ($result->getMessage().'<br />'.$result->getDebugInfo()) ;
|
|
|
60 |
}
|
|
|
61 |
$row = $result->fetchRow(DB_FETCHMODE_OBJECT) ;
|
|
|
62 |
|
|
|
63 |
$pays = $row->CP_Intitule_pays;
|
|
|
64 |
$monde->nom = $monde->nom.'*'.$pays;
|
|
|
65 |
|
|
|
66 |
$tabonglet = explode ('*', $monde->historique);
|
|
|
67 |
$tabnom = explode ('*', $monde->nom);
|
|
|
68 |
$res .= "<b>\n";
|
|
|
69 |
foreach ($tabonglet as $key => $value) {
|
|
|
70 |
if ($key == 0) {
|
|
|
71 |
$chemin = $value;
|
|
|
72 |
$value = 'monde';
|
|
|
73 |
$res .= "<a class=\"chemin_carto\" href=\"".$monde->url."&historique_cartes=$chemin\"> > ".$tabnom[$key]."</a>";
|
|
|
74 |
}
|
|
|
75 |
else if ($key == (count($tabonglet)-1)) {
|
|
|
76 |
$res .= "<a class=\"chemin_carto\"> > $pays</a>";
|
|
|
77 |
}
|
|
|
78 |
else {
|
|
|
79 |
$chemin .= '*'.$value;
|
|
|
80 |
$res .= "<a class=\"chemin_carto\" href=\"".$monde->url."&historique_cartes=$chemin\"> > ".$tabnom[$key]."</a>";
|
|
|
81 |
}
|
|
|
82 |
}
|
|
|
83 |
|
|
|
84 |
$res .= "</b>\n";
|
|
|
85 |
|
|
|
86 |
$capitale = $row->CP_Intitule_capitale;
|
|
|
87 |
|
|
|
88 |
$query2 = " SELECT count(".CAR_CHAMPS_ID.") as nbr".
|
|
|
89 |
" from ".CAR_ANNUAIRE.
|
|
|
90 |
" where ".CAR_CHAMPS_CE_PAYS."='$argument'";
|
|
|
91 |
|
|
|
92 |
$result2 = $GLOBALS['car_db']->query($query2);
|
|
|
93 |
if (DB::isError($resultat2)) {
|
|
|
94 |
die ($resultat2->getMessage().'<br />'.$resultat2->getDebugInfo()) ;
|
|
|
95 |
}
|
|
|
96 |
$row2 = $result2->fetchRow(DB_FETCHMODE_OBJECT) ;
|
|
|
97 |
|
|
|
98 |
$res .= "<div class=\"$classe_titre\">$pays ($capitale) : " ;
|
|
|
99 |
|
|
|
100 |
if ($row2->nbr == 0) {
|
|
|
101 |
$res .= "aucun inscrit ".CAR_LABEL_PROJET ;
|
|
|
102 |
} else if ($row2->nbr == 1) {
|
|
|
103 |
$res .= $row2->nbr." inscrit ".CAR_LABEL_PROJET ;
|
|
|
104 |
} else {
|
|
|
105 |
$res .= $row2->nbr." inscrits ".CAR_LABEL_PROJET ;
|
|
|
106 |
}
|
|
|
107 |
$res .= "</div>\n";
|
|
|
108 |
|
|
|
109 |
if (!$GLOBALS['car_auth']->getAuth()) {
|
|
|
110 |
$res .= AUTH_formulaire_login();
|
|
|
111 |
} else {
|
|
|
112 |
$requete = "select * from ".CAR_ANNUAIRE.
|
|
|
113 |
" where ".CAR_CHAMPS_CE_PAYS."='$argument'".
|
|
|
114 |
" order by ".CAR_CHAMPS_NOM.", ".CAR_CHAMPS_PRENOM;
|
|
|
115 |
|
|
|
116 |
$res .= listes_inscrit ($requete, $url, $select, $argument, $GLOBALS['car_db']) ;
|
|
|
117 |
|
|
|
118 |
if ($mailer==1) {
|
|
|
119 |
if (!is_array($select)) {
|
|
|
120 |
$res .= "<div>".CAR_NO_DESTINATAIRE."</div>";
|
|
|
121 |
} else {
|
|
|
122 |
$res .= "<div class=\"$classe_titre\">".CAR_MESSAGE_ENVOYE."</div>\n" ;
|
|
|
123 |
envoie_mail() ;
|
|
|
124 |
}
|
|
|
125 |
} else {
|
|
|
126 |
$res .= carto_texte_cocher() ;
|
|
|
127 |
}
|
|
|
128 |
$res .= carto_formulaire($titre_mail, $corps) ;
|
|
|
129 |
}
|
|
|
130 |
|
|
|
131 |
// 2 ème cas, on vient de cliquer sur un département français
|
|
|
132 |
|
|
|
133 |
} else if (count($tabmonde) == 4) {
|
|
|
134 |
$argument = $tabmonde[3];
|
|
|
135 |
|
|
|
136 |
$query = "select * from gen_FRENCH_DPT where GFD_ID='$argument'";
|
|
|
137 |
$result = $GLOBALS['car_db']->query($query);
|
|
|
138 |
if (DB::isError($resultat)) {
|
|
|
139 |
die ($result->getMessage() .'<br />'.$result->getDebugInfo());
|
|
|
140 |
}
|
|
|
141 |
$row = $result->fetchRow(DB_FETCHMODE_OBJECT);
|
|
|
142 |
$nom = $row->GFD_NAME;
|
|
|
143 |
|
|
|
144 |
$tabonglet=explode ('*', $monde->historique);
|
|
|
145 |
$tabnom=explode ('*', $monde->nom);
|
|
|
146 |
$res.="<div><b>\n";
|
|
|
147 |
foreach ($tabonglet as $key=>$value) {
|
|
|
148 |
if ($key==0) {
|
|
|
149 |
$chemin=$value;
|
|
|
150 |
$value='monde';
|
|
|
151 |
$res.= "<a class=\"chemin_carto\" href=\"".$monde->url."&historique_cartes=$chemin\"> > ".$tabnom[$key]."</a>";
|
|
|
152 |
}
|
|
|
153 |
else if ($key==(count($tabonglet)-1)) {
|
|
|
154 |
$res.="<a class=\"chemin_carto\"> > $nom</a>";
|
|
|
155 |
}
|
|
|
156 |
else {
|
|
|
157 |
$chemin.='*'.$value;
|
|
|
158 |
$res.= "<a class=\"chemin_carto\" href=\"".$monde->url."&historique_cartes=$chemin\"> > ".$tabnom[$key]."</a>";
|
|
|
159 |
}
|
|
|
160 |
}
|
|
|
161 |
$res .= "</b></div>\n";
|
|
|
162 |
|
|
|
163 |
$query2 = " SELECT count(".CAR_CHAMPS_ID.") as nbr".
|
|
|
164 |
" FROM ".CAR_ANNUAIRE.
|
|
|
165 |
" WHERE ".CAR_CHAMPS_DPT." = '$argument'".
|
|
|
166 |
" AND ".CAR_CHAMPS_CE_PAYS."='fr'";
|
|
|
167 |
|
|
|
168 |
$result2 = $GLOBALS['car_db']->query($query2);
|
|
|
169 |
if (DB::isError($resultat2)) {
|
|
|
170 |
die ($resultat2->getMessage().'<br />'.$resultat2->getDebugInfo()) ;
|
|
|
171 |
}
|
|
|
172 |
|
|
|
173 |
$row2 = $result2->fetchRow(DB_FETCHMODE_OBJECT);
|
|
|
174 |
$res .= "<div class=\"$classe_titre\">$nom : " ;
|
|
|
175 |
if ($row2->nbr == 0) {
|
|
|
176 |
$res .= CAR_AUCUN_INSCRIT." ".CAR_LABEL_PROJET ;
|
|
|
177 |
}
|
|
|
178 |
else if ($row2->nbr == 1) {
|
|
|
179 |
$res .= $row2->nbr." ".CAR_INSCRIT." ".CAR_LABEL_PROJET ;
|
|
|
180 |
}
|
|
|
181 |
else {
|
|
|
182 |
$res .= $row2->nbr." ".CAR_INSCRIT."s ".CAR_LABEL_PROJET ;
|
|
|
183 |
}
|
|
|
184 |
$res .= "</div>\n";
|
|
|
185 |
|
|
|
186 |
if (!$GLOBALS['car_auth']->getAuth()) {
|
|
|
187 |
$res .= AUTH_formulaire_login();
|
|
|
188 |
} else {
|
|
|
189 |
$requete = "SELECT * FROM ".CAR_ANNUAIRE.
|
|
|
190 |
" WHERE ".CAR_CHAMPS_DPT." = '$argument'".
|
|
|
191 |
" AND ".CAR_CHAMPS_CE_PAYS."='fr'".
|
|
|
192 |
" ORDER BY ".CAR_CHAMPS_NOM.", ".CAR_CHAMPS_PRENOM;
|
|
|
193 |
$res .= listes_inscrit ($requete, $url, $select, $argument, $GLOBALS['car_db'], 'france') ;
|
|
|
194 |
|
|
|
195 |
if ($mailer==1) {
|
|
|
196 |
if (!is_array($select)) {
|
|
|
197 |
$res.= CAR_NO_DESTINATAIRE;
|
|
|
198 |
} else {
|
|
|
199 |
$res .= "<div class=\"$classe_titre\">".CAR_MESSAGE_ENVOYE."</div>\n" ;
|
|
|
200 |
envoie_mail() ;
|
|
|
201 |
}
|
|
|
202 |
} else {
|
|
|
203 |
$res .=carto_texte_cocher() ;
|
|
|
204 |
}
|
|
|
205 |
$res .= carto_formulaire($titre_mail, $corps) ;
|
|
|
206 |
}
|
|
|
207 |
}
|
|
|
208 |
|
|
|
209 |
$res.="</div>";
|
|
|
210 |
?>
|