Line 8... |
Line 8... |
8 |
// | Les fonctions de annuaire_moteur.php |
|
8 |
// | Les fonctions de annuaire_moteur.php |
|
9 |
// +--------------------------------------------------------------------------------+
|
9 |
// +--------------------------------------------------------------------------------+
|
10 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> |
|
10 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> |
|
11 |
// +--------------------------------------------------------------------------------+
|
11 |
// +--------------------------------------------------------------------------------+
|
12 |
//
|
12 |
//
|
13 |
// $Id: annuaire_moteur_fonction.php,v 1.1.1.1 2005-01-03 17:27:49 alex Exp $
|
13 |
// $Id: annuaire_moteur_fonction.php,v 1.2 2005-03-24 08:24:39 alex Exp $
|
Line 14... |
Line 14... |
14 |
|
14 |
|
15 |
|
15 |
|
16 |
/** function mkengine ()
|
16 |
/** function mkengine ()
|
Line 20... |
Line 20... |
20 |
* @return
|
20 |
* @return
|
21 |
*/
|
21 |
*/
|
Line 22... |
Line 22... |
22 |
|
22 |
|
23 |
function mkengine()
|
23 |
function mkengine()
|
24 |
{
|
- |
|
25 |
global $GS_GLOBAL;
|
24 |
{
|
26 |
global $label_bbota;
|
25 |
global $label_bbota;
|
27 |
global $nbr_total;
|
26 |
global $nbr_total;
|
28 |
global $bouton, $HTTP_POST_VARS ;
|
27 |
global $bouton, $HTTP_POST_VARS ;
|
Line 44... |
Line 43... |
44 |
$$value = $HTTP_POST_VARS[$value] ;
|
43 |
$$value = $HTTP_POST_VARS[$value] ;
|
45 |
}
|
44 |
}
|
46 |
}
|
45 |
}
|
47 |
}
|
46 |
}
|
48 |
// Comptage du nombre total de données dans la table (hors CACHER = 1)
|
47 |
// Comptage du nombre total de données dans la table (hors CACHER = 1)
|
49 |
$query = "select count(*) as CPT from ".AM_ANNUAIRE;
|
48 |
$query = "select count(*) as CPT from ".ANN_ANNUAIRE;
|
50 |
$result = mysql_query($query) or die("<B>Erreur !</B> $query a échoué...");
|
49 |
$result = mysql_query($query) or die("<B>Erreur !</B> $query a échoué...");
|
Line 51... |
Line 50... |
51 |
|
50 |
|
52 |
if (mysql_num_rows($result) == 1)
|
51 |
if (mysql_num_rows($result) == 1)
|
53 |
{
|
52 |
{
|
Line 63... |
Line 62... |
63 |
|
62 |
|
Line 64... |
Line 63... |
64 |
$ret = "";
|
63 |
$ret = "";
|
Line 65... |
Line 64... |
65 |
|
64 |
|
66 |
// construction du moteur de str
|
65 |
// construction du moteur de str
|
67 |
|
66 |
|
68 |
$ret .= "<form action=\"".AM_URL_DOCUMENT."\" method=\"post\">\n";
|
- |
|
69 |
$ret .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" summary=\"\">\n";
|
67 |
$ret .= "<form action=\"".$GLOBALS['ann_url']->getURL()."\" method=\"post\">\n";
|
70 |
$ret .= "<tr class=\"titlePage\"><td colspan=\"2\">".AM_L_TITRE."</td></tr>\n" ;
|
- |
|
Line 71... |
Line 68... |
71 |
$ret .= presa_mk_blkline(1);
|
68 |
$ret .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" summary=\"\">\n";
|
72 |
$ret .= "<tr class=\"insTitle1\"><td colspan=\"2\">".AM_L_TITRE." $chaine :</td></tr>\n" ;
|
69 |
$ret .= "<tr class=\"titlePage\"><td colspan=\"2\">".AM_L_TITRE."</td></tr>\n" ;
|
73 |
$ret .= presa_mk_blkline(1);
|
70 |
$ret .= "<tr class=\"insTitle1\"><td colspan=\"2\">".AM_L_TITRE." $chaine :</td></tr>\n" ;
|
74 |
|
71 |
|
Line 146... |
Line 143... |
146 |
}
|
143 |
}
|
147 |
$ret .= "</select></td>" ;
|
144 |
$ret .= "</select></td>" ;
|
148 |
$ret .= "<td class=\"texte_tb\" align=\"right\" width=\"40%\">\n";
|
145 |
$ret .= "<td class=\"texte_tb\" align=\"right\" width=\"40%\">\n";
|
149 |
$ret .= "<input type=\"submit\" class=\"texte_tb\" value=\"".AM_L_RECHERCHER."\" name =\"bouton\">\n";
|
146 |
$ret .= "<input type=\"submit\" class=\"texte_tb\" value=\"".AM_L_RECHERCHER."\" name =\"bouton\">\n";
|
150 |
$ret .= "</td></tr></table>\n</td></tr>\n";
|
147 |
$ret .= "</td></tr></table>\n</td></tr>\n";
|
151 |
$ret .= presa_mk_blkline(1);
|
- |
|
152 |
$ret .= "</table></form>\n";
|
148 |
$ret .= "</table></form>\n";
|
153 |
return $ret;
|
149 |
return $ret;
|
154 |
}
|
150 |
}
|
Line 155... |
Line 151... |
155 |
|
151 |
|
Line 214... |
Line 210... |
214 |
}
|
210 |
}
|
215 |
}
|
211 |
}
|
216 |
if ($bouton) $sort = $mon_frag->getVariable("sort") ;
|
212 |
if ($bouton) $sort = $mon_frag->getVariable("sort") ;
|
Line 217... |
Line 213... |
217 |
|
213 |
|
218 |
|
214 |
|
219 |
$queries = "select ".AM_ANNUAIRE.".*" ;
|
215 |
$queries = "select ".ANN_ANNUAIRE.".*" ;
|
220 |
$queries .= ", ".AM_PAYS.".GC_NAME ";
|
216 |
$queries .= ", ".ANN_TABLE_PAYS.".GC_NAME ";
|
Line 221... |
Line 217... |
221 |
$queries .= "from ".AM_ANNUAIRE ;
|
217 |
$queries .= "from ".ANN_ANNUAIRE ;
|
Line 222... |
Line 218... |
222 |
$queries .= ",".AM_PAYS ;
|
218 |
$queries .= ",".ANN_TABLE_PAYS ;
|
223 |
|
219 |
|
Line 270... |
Line 266... |
270 |
} else {
|
266 |
} else {
|
271 |
if ($lettre == "tous") $lettre = "" ;
|
267 |
if ($lettre == "tous") $lettre = "" ;
|
272 |
$queries .="U_NAME like '$lettre%'" ;
|
268 |
$queries .="U_NAME like '$lettre%'" ;
|
273 |
}
|
269 |
}
|
274 |
$queries .= ")" ;
|
270 |
$queries .= ")" ;
|
275 |
$queries .= " and ".AM_ANNUAIRE.".U_COUNTRY=".AM_PAYS.".GC_ID" ;
|
271 |
$queries .= " and ".ANN_ANNUAIRE.".U_COUNTRY=".ANN_TABLE_PAYS.".GC_ID" ;
|
276 |
if (isset($cotisant) && $cotisant != 3) if ($cotisant == 1) {
|
272 |
if (isset($cotisant) && $cotisant != 3) if ($cotisant == 1) {
|
277 |
$queries .= " and ".AM_ANNUAIRE.".U_COT=$cotisant" ;
|
273 |
$queries .= " and ".ANN_ANNUAIRE.".U_COT=$cotisant" ;
|
278 |
} else {
|
274 |
} else {
|
279 |
$queries .= " and ".AM_ANNUAIRE.".U_COT=0" ;
|
275 |
$queries .= " and ".ANN_ANNUAIRE.".U_COT=0" ;
|
280 |
}
|
276 |
}
|
281 |
if (isset($nom) && $nom != "") $queries .= " and U_NAME like \"%$nom%\"" ;
|
277 |
if (isset($nom) && $nom != "") $queries .= " and U_NAME like \"%$nom%\"" ;
|
282 |
if (isset($prenom) && $prenom != "") $queries .= " and U_SURNAME like \"%$prenom%\"" ;
|
278 |
if (isset($prenom) && $prenom != "") $queries .= " and U_SURNAME like \"%$prenom%\"" ;
|
283 |
if (isset($ville) && $ville != "") $queries .= " and U_CITY like \"%$ville%\"" ;
|
279 |
if (isset($ville) && $ville != "") $queries .= " and U_CITY like \"%$ville%\"" ;
|
284 |
if (isset($mail) && $mail != "") $queries .= " and U_MAIL like \"%$mail%\"" ;
|
280 |
if (isset($mail) && $mail != "") $queries .= " and U_MAIL like \"%$mail%\"" ;
|
Line 287... |
Line 283... |
287 |
return $queries;
|
283 |
return $queries;
|
288 |
}
|
284 |
}
|
Line 289... |
Line 285... |
289 |
|
285 |
|
290 |
function mkresu()
|
286 |
function mkresu()
|
291 |
{
|
- |
|
292 |
global $GS_GLOBAL;
|
287 |
{
|
Line 293... |
Line 288... |
293 |
global $HTTP_HOST, $SCRIPT_URL, $SCRIPT_NAME, $bouton ;
|
288 |
global $HTTP_HOST, $SCRIPT_URL, $SCRIPT_NAME, $bouton ;
|
294 |
|
289 |
|
295 |
$mon_frag = new fragmenteur_session() ;
|
290 |
$mon_frag = new fragmenteur_session() ;
|
296 |
$mon_frag->setURL(AM_BASE_URL.AM_URL_DOCUMENT) ;
|
291 |
$mon_frag->setURL($GLOBALS['ann_url']->getURL()) ;
|
Line 297... |
Line 292... |
297 |
if ($bouton) $mon_frag->fixerLeDebut(0) ;
|
292 |
if ($bouton) $mon_frag->fixerLeDebut(0) ;
|
298 |
$requete = mkquery() ;
|
293 |
$requete = mkquery() ;
|
Line 306... |
Line 301... |
306 |
|
301 |
|
307 |
|
302 |
|
308 |
$result_final = mysql_query($requete." limit ".$mon_frag->lireLeDebut().",".$mon_frag->lireLePas()) or print (mysql_error());
|
303 |
$result_final = mysql_query($requete." limit ".$mon_frag->lireLeDebut().",".$mon_frag->lireLePas()) or print (mysql_error());
|
309 |
$nbr_final = mysql_num_rows($result_total) ;
|
304 |
$nbr_final = mysql_num_rows($result_total) ;
|
- |
|
305 |
mysql_free_result($result_total) ;
|
310 |
mysql_free_result($result_total) ;
|
306 |
// cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ;
|
Line 311... |
Line 307... |
311 |
cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ;
|
307 |
$_SESSION['requete_mail_tous'] = $requete ;
|
312 |
$ret = "<tr class=\"text1\"><td align=\"center\"><table><tr>" ;
|
308 |
$ret = "<div><table><tr>" ;
|
313 |
|
309 |
|
314 |
for ($i = 65 ; $i <91 ; $i++) {
|
310 |
for ($i = 65 ; $i <91 ; $i++) {
|
315 |
$ret .= "\t<td><a href=\"".AM_URL_DOCUMENT."&lettre=";
|
311 |
$ret .= "\t<td><a href=\"".$GLOBALS['ann_url']->getURL()."&lettre=";
|
316 |
$ret .= chr($i)."\">";
|
312 |
$ret .= chr($i)."\">";
|
Line 317... |
Line 313... |
317 |
$ret .= chr($i) ;
|
313 |
$ret .= chr($i) ;
|
318 |
$ret .= "</a></td>\n";
|
314 |
$ret .= "</a></td>\n";
|
319 |
}
|
315 |
}
|
320 |
|
316 |
|
321 |
$ret .= "<td> <a href=\"".AM_URL_DOCUMENT."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ;
|
317 |
$ret .= "<td> <a href=\"".$GLOBALS['ann_url']->getURL()."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ;
|
322 |
$ret .= "<tr></table></td></tr>\n" ;
|
318 |
$ret .= "<tr></table></div>\n" ;
|
323 |
$ret .= "<tr class=\"insInputForm\"><td>".$mon_frag->affNbRes($nbr_final) ;
|
319 |
$ret .= "<div>".$mon_frag->affNbRes($nbr_final).'</div>' ;
|
324 |
$ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ;
|
320 |
$ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ;
|
325 |
if ($nbr_final != 0) {
|
321 |
if ($nbr_final != 0) {
|
326 |
$ret .= "<tr><td><table width=\"100%\">\n";
|
322 |
$ret .= "<div><table>\n";
|
327 |
$ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_NAME\">Identité</a></td>\n";
|
323 |
$ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_NAME\">Identité</a></td>\n";
|
Line 328... |
Line 324... |
328 |
$ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_MAIL\">Adresse mail</a></td>\n" ;
|
324 |
$ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_MAIL\">Adresse mail</a></td>\n" ;
|
Line 329... |
Line 325... |
329 |
$ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ;
|
325 |
$ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ;
|
Line 343... |
Line 339... |
343 |
} else {
|
339 |
} else {
|
344 |
$pair = true ;
|
340 |
$pair = true ;
|
345 |
}
|
341 |
}
|
346 |
$ret .= ">" ;
|
342 |
$ret .= ">" ;
|
347 |
$ret .= "\n<td nowrap>";
|
343 |
$ret .= "\n<td nowrap>";
|
348 |
$urlPop = "http://$HTTP_HOST$SCRIPT_NAME" ;
|
- |
|
349 |
$urlPop .= "?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=popup&doc=admin_annu&page=".
|
- |
|
350 |
$GS_GLOBAL['current_page_ndx']."&u_id=$row->U_ID" ;
|
344 |
$urlPop = $GLOBALS['ann_url']->getURL()."&u_id=$row->U_ID";
|
351 |
$ret .= "<a href=\"javascript:MagicPopup('$urlPop', 'admin_annu');\">" ;
|
345 |
$ret .= "<a href=\"$urlPop\">" ;
|
352 |
$ret .= $row->U_NAME." ".$row->U_SURNAME ;
|
346 |
$ret .= $row->U_NAME." ".$row->U_SURNAME ;
|
353 |
$ret .= "</a></td>\n ";
|
347 |
$ret .= "</a></td>\n ";
|
354 |
$ret .= "<td><a href=\"mailto:$row->U_MAIL\">$row->U_MAIL</a></td>\n" ;
|
348 |
$ret .= "<td><a href=\"mailto:$row->U_MAIL\">$row->U_MAIL</a></td>\n" ;
|
355 |
$ret .= "<td>$row->U_CITY</td>" ;
|
349 |
$ret .= "<td>$row->U_CITY</td>" ;
|
356 |
if ($row->U_COUNTRY != 'fr') {
|
350 |
if ($row->U_COUNTRY != 'fr') {
|
357 |
$ret .= "<td>$row->GC_NAME</td>" ;
|
351 |
$ret .= "<td>$row->GC_NAME</td>" ;
|
358 |
} else {
|
352 |
} else {
|
359 |
$req_dpt = "select GFD_NAME from ".AM_DPT.",".AM_ANNUAIRE." where ".AM_ANNUAIRE.".U_ID=$row->U_ID" ;
|
353 |
$req_dpt = "select GFD_NAME from ".ANN_TABLE_DEPARTEMENT.",".ANN_ANNUAIRE." where ".ANN_ANNUAIRE.".U_ID=$row->U_ID" ;
|
360 |
$req_dpt .= " and ".AM_ANNUAIRE.".U_FRENCH_DPT=".AM_DPT.".GFD_ID" ;
|
354 |
$req_dpt .= " and ".ANN_ANNUAIRE.".U_FRENCH_DPT=".ANN_TABLE_DEPARTEMENT.".GFD_ID" ;
|
361 |
$resultat_dpt = mysql_query($req_dpt) or die ("Echec de la requete sur ".AM_DPT."<br>".mysql_error()) ;
|
355 |
$resultat_dpt = mysql_query($req_dpt) or die ("Echec de la requete sur ".ANN_TABLE_DEPARTEMENT."<br>".mysql_error()) ;
|
362 |
$ligne_dpt = mysql_fetch_object($resultat_dpt) ;
|
356 |
$ligne_dpt = mysql_fetch_object($resultat_dpt) ;
|
363 |
$ret .= "<td>$ligne_dpt->GFD_NAME</td>" ;
|
357 |
$ret .= "<td>$ligne_dpt->GFD_NAME</td>" ;
|
364 |
}
|
358 |
}
|
365 |
$ret .= "<td>".$cotisant[$row->U_COT]."</td></tr>\n" ;
|
359 |
$ret .= "<td>".$cotisant[$row->U_COT]."</td></tr>\n" ;
|
366 |
}
|
360 |
}
|
Line 367... |
Line 361... |
367 |
|
361 |
|
368 |
$ret .= "</table></td></tr>\n" ;
|
362 |
$ret .= "</table></div>\n" ;
|
369 |
$ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ;
|
- |
|
370 |
$ret .= presa_mk_blkline(1) ;
|
363 |
$ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ;
|
371 |
$ret .= "<tr class=\"texte_tb\"><td><a href=\"document.php?project=gus&doc=mail_tous\" target=\"_blank\">".AM_L_MAIL_SELECTION."</a></td></tr>\n" ;
|
364 |
$ret .= "<div><a href=\"".$GLOBALS['ann_url']->getURL()."&action=".ANN_MAIL_TOUS."\">".AM_L_MAIL_SELECTION."</a></div>\n" ;
|
372 |
}
|
365 |
}
|
373 |
// $ret .= $ret_req ;
|
366 |
// $ret .= $ret_req ;
|
374 |
return $ret;
|
367 |
return $ret;
|