10,7 → 10,7 |
// | Auteur : Alexandre Granier <alexandre@tela-botanica.org> | |
// +--------------------------------------------------------------------------------+ |
// |
// $Id: annuaire_moteur_fonction.php,v 1.1.1.1 2005-01-03 17:27:49 alex Exp $ |
// $Id: annuaire_moteur_fonction.php,v 1.2 2005-03-24 08:24:39 alex Exp $ |
|
|
/** function mkengine () |
22,7 → 22,6 |
|
function mkengine() |
{ |
global $GS_GLOBAL; |
global $label_bbota; |
global $nbr_total; |
global $bouton, $HTTP_POST_VARS ; |
46,7 → 45,7 |
} |
} |
// Comptage du nombre total de données dans la table (hors CACHER = 1) |
$query = "select count(*) as CPT from ".AM_ANNUAIRE; |
$query = "select count(*) as CPT from ".ANN_ANNUAIRE; |
$result = mysql_query($query) or die("<B>Erreur !</B> $query a échoué..."); |
|
if (mysql_num_rows($result) == 1) |
65,12 → 64,10 |
|
// construction du moteur de str |
|
$ret .= "<form action=\"".AM_URL_DOCUMENT."\" method=\"post\">\n"; |
$ret .= "<form action=\"".$GLOBALS['ann_url']->getURL()."\" method=\"post\">\n"; |
$ret .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" summary=\"\">\n"; |
$ret .= "<tr class=\"titlePage\"><td colspan=\"2\">".AM_L_TITRE."</td></tr>\n" ; |
$ret .= presa_mk_blkline(1); |
$ret .= "<tr class=\"insTitle1\"><td colspan=\"2\">".AM_L_TITRE." $chaine :</td></tr>\n" ; |
$ret .= presa_mk_blkline(1); |
|
// ligne de recherche |
$ret .= "<tr><td colspan=\"2\">\n"; |
148,7 → 145,6 |
$ret .= "<td class=\"texte_tb\" align=\"right\" width=\"40%\">\n"; |
$ret .= "<input type=\"submit\" class=\"texte_tb\" value=\"".AM_L_RECHERCHER."\" name =\"bouton\">\n"; |
$ret .= "</td></tr></table>\n</td></tr>\n"; |
$ret .= presa_mk_blkline(1); |
$ret .= "</table></form>\n"; |
return $ret; |
} |
216,10 → 212,10 |
if ($bouton) $sort = $mon_frag->getVariable("sort") ; |
|
|
$queries = "select ".AM_ANNUAIRE.".*" ; |
$queries .= ", ".AM_PAYS.".GC_NAME "; |
$queries .= "from ".AM_ANNUAIRE ; |
$queries .= ",".AM_PAYS ; |
$queries = "select ".ANN_ANNUAIRE.".*" ; |
$queries .= ", ".ANN_TABLE_PAYS.".GC_NAME "; |
$queries .= "from ".ANN_ANNUAIRE ; |
$queries .= ",".ANN_TABLE_PAYS ; |
|
// Construction en fonction des champs saisies |
|
272,11 → 268,11 |
$queries .="U_NAME like '$lettre%'" ; |
} |
$queries .= ")" ; |
$queries .= " and ".AM_ANNUAIRE.".U_COUNTRY=".AM_PAYS.".GC_ID" ; |
$queries .= " and ".ANN_ANNUAIRE.".U_COUNTRY=".ANN_TABLE_PAYS.".GC_ID" ; |
if (isset($cotisant) && $cotisant != 3) if ($cotisant == 1) { |
$queries .= " and ".AM_ANNUAIRE.".U_COT=$cotisant" ; |
$queries .= " and ".ANN_ANNUAIRE.".U_COT=$cotisant" ; |
} else { |
$queries .= " and ".AM_ANNUAIRE.".U_COT=0" ; |
$queries .= " and ".ANN_ANNUAIRE.".U_COT=0" ; |
} |
if (isset($nom) && $nom != "") $queries .= " and U_NAME like \"%$nom%\"" ; |
if (isset($prenom) && $prenom != "") $queries .= " and U_SURNAME like \"%$prenom%\"" ; |
289,11 → 285,10 |
|
function mkresu() |
{ |
global $GS_GLOBAL; |
global $HTTP_HOST, $SCRIPT_URL, $SCRIPT_NAME, $bouton ; |
|
$mon_frag = new fragmenteur_session() ; |
$mon_frag->setURL(AM_BASE_URL.AM_URL_DOCUMENT) ; |
$mon_frag->setURL($GLOBALS['ann_url']->getURL()) ; |
if ($bouton) $mon_frag->fixerLeDebut(0) ; |
$requete = mkquery() ; |
|
308,27 → 303,28 |
$result_final = mysql_query($requete." limit ".$mon_frag->lireLeDebut().",".$mon_frag->lireLePas()) or print (mysql_error()); |
$nbr_final = mysql_num_rows($result_total) ; |
mysql_free_result($result_total) ; |
cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ; |
$ret = "<tr class=\"text1\"><td align=\"center\"><table><tr>" ; |
// cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ; |
$_SESSION['requete_mail_tous'] = $requete ; |
$ret = "<div><table><tr>" ; |
|
for ($i = 65 ; $i <91 ; $i++) { |
$ret .= "\t<td><a href=\"".AM_URL_DOCUMENT."&lettre="; |
$ret .= "\t<td><a href=\"".$GLOBALS['ann_url']->getURL()."&lettre="; |
$ret .= chr($i)."\">"; |
$ret .= chr($i) ; |
$ret .= "</a></td>\n"; |
} |
|
$ret .= "<td> <a href=\"".AM_URL_DOCUMENT."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ; |
$ret .= "<tr></table></td></tr>\n" ; |
$ret .= "<tr class=\"insInputForm\"><td>".$mon_frag->affNbRes($nbr_final) ; |
$ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ; |
$ret .= "<td> <a href=\"".$GLOBALS['ann_url']->getURL()."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ; |
$ret .= "<tr></table></div>\n" ; |
$ret .= "<div>".$mon_frag->affNbRes($nbr_final).'</div>' ; |
$ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ; |
if ($nbr_final != 0) { |
$ret .= "<tr><td><table width=\"100%\">\n"; |
$ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_NAME\">Identité</a></td>\n"; |
$ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_MAIL\">Adresse mail</a></td>\n" ; |
$ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ; |
$ret .= "<div><table>\n"; |
$ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_NAME\">Identité</a></td>\n"; |
$ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_MAIL\">Adresse mail</a></td>\n" ; |
$ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ; |
$ret .= "<td>Pays ou Dpt (fr)</td>\n" ; |
$ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&sort=U_COT\">".AM_L_COTISANTS."</a></td></tr>\n" ; |
$ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&sort=U_COT\">".AM_L_COTISANTS."</a></td></tr>\n" ; |
|
$cotisant = array( "non", "oui") ; |
|
345,10 → 341,8 |
} |
$ret .= ">" ; |
$ret .= "\n<td nowrap>"; |
$urlPop = "http://$HTTP_HOST$SCRIPT_NAME" ; |
$urlPop .= "?project=".$GS_GLOBAL['project']."&locale=".$GS_GLOBAL['locale']."&set=popup&doc=admin_annu&page=". |
$GS_GLOBAL['current_page_ndx']."&u_id=$row->U_ID" ; |
$ret .= "<a href=\"javascript:MagicPopup('$urlPop', 'admin_annu');\">" ; |
$urlPop = $GLOBALS['ann_url']->getURL()."&u_id=$row->U_ID"; |
$ret .= "<a href=\"$urlPop\">" ; |
$ret .= $row->U_NAME." ".$row->U_SURNAME ; |
$ret .= "</a></td>\n "; |
$ret .= "<td><a href=\"mailto:$row->U_MAIL\">$row->U_MAIL</a></td>\n" ; |
356,19 → 350,18 |
if ($row->U_COUNTRY != 'fr') { |
$ret .= "<td>$row->GC_NAME</td>" ; |
} else { |
$req_dpt = "select GFD_NAME from ".AM_DPT.",".AM_ANNUAIRE." where ".AM_ANNUAIRE.".U_ID=$row->U_ID" ; |
$req_dpt .= " and ".AM_ANNUAIRE.".U_FRENCH_DPT=".AM_DPT.".GFD_ID" ; |
$resultat_dpt = mysql_query($req_dpt) or die ("Echec de la requete sur ".AM_DPT."<br>".mysql_error()) ; |
$req_dpt = "select GFD_NAME from ".ANN_TABLE_DEPARTEMENT.",".ANN_ANNUAIRE." where ".ANN_ANNUAIRE.".U_ID=$row->U_ID" ; |
$req_dpt .= " and ".ANN_ANNUAIRE.".U_FRENCH_DPT=".ANN_TABLE_DEPARTEMENT.".GFD_ID" ; |
$resultat_dpt = mysql_query($req_dpt) or die ("Echec de la requete sur ".ANN_TABLE_DEPARTEMENT."<br>".mysql_error()) ; |
$ligne_dpt = mysql_fetch_object($resultat_dpt) ; |
$ret .= "<td>$ligne_dpt->GFD_NAME</td>" ; |
} |
$ret .= "<td>".$cotisant[$row->U_COT]."</td></tr>\n" ; |
} |
} |
|
$ret .= "</table></td></tr>\n" ; |
$ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ; |
$ret .= presa_mk_blkline(1) ; |
$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" ; |
$ret .= "</table></div>\n" ; |
$ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ; |
$ret .= "<div><a href=\"".$GLOBALS['ann_url']->getURL()."&action=".ANN_MAIL_TOUS."\">".AM_L_MAIL_SELECTION."</a></div>\n" ; |
} |
// $ret .= $ret_req ; |
return $ret; |