WebSVN – Applications.papyrus – Diff – /trunk/client/annuaire/annuaire_moteur_fonction.php

 // | Les fonctions de annuaire_moteur.php                                           |
 // +--------------------------------------------------------------------------------+
 // | 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 ()
 *	@return
 */
 function mkengine()
-  {
     global $GS_GLOBAL;
     global $label_bbota;
     global $nbr_total;
     global $bouton, $HTTP_POST_VARS ;
                 $$value = $HTTP_POST_VARS[$value] ;
+            }
+        }
+    }
     // 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)
+    {
   $ret = "";
   // construction du moteur de str
-    $ret .= "<form action=\"".AM_URL_DOCUMENT."\" method=\"post\">\n";
-    $ret .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" summary=\"\">\n";
+    $ret .= "<form action=\"".$GLOBALS['ann_url']->getURL()."\" method=\"post\">\n";
-    $ret .= "<tr class=\"titlePage\"><td colspan=\"2\">".AM_L_TITRE."</td></tr>\n" ;
-    $ret .= presa_mk_blkline(1);
+    $ret .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" summary=\"\">\n";
-    $ret .= "<tr class=\"insTitle1\"><td colspan=\"2\">".AM_L_TITRE." $chaine :</td></tr>\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 .= "</select></td>" ;
     $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;
+}
+        }
+    }
     if ($bouton) $sort = $mon_frag->getVariable("sort") ;
-	$queries = "select ".AM_ANNUAIRE.".*" ;
+	$queries = "select ".ANN_ANNUAIRE.".*" ;
-    $queries .= ", ".AM_PAYS.".GC_NAME ";
+    $queries .= ", ".ANN_TABLE_PAYS.".GC_NAME ";
-	$queries .= "from ".AM_ANNUAIRE ;
+	$queries .= "from ".ANN_ANNUAIRE ;
-    $queries .= ",".AM_PAYS ;
+    $queries .= ",".ANN_TABLE_PAYS ;
 } else {
 	if ($lettre == "tous") $lettre = "" ;
 	$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%\"" ;
     if (isset($ville) && $ville != "") $queries .= " and U_CITY like \"%$ville%\"" ;
     if (isset($mail) && $mail != "") $queries .= " and U_MAIL like \"%$mail%\"" ;
   return $queries;
+}
 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() ;
     $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) ;
-    mysql_free_result($result_total) ;
+//    cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ;
-    cxt_addVariable(AM_BD_BOTA, AM_BD_LINK, "requete_mail_tous", $requete) ;
+    $_SESSION['requete_mail_tous'] = $requete ;
-    $ret = "<tr class=\"text1\"><td align=\"center\"><table><tr>" ;
+    $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>&nbsp;&nbsp;<a href=\"".AM_URL_DOCUMENT."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ;
+    $ret .= "<td>&nbsp;&nbsp;<a href=\"".$GLOBALS['ann_url']->getURL()."&lettre=tous\">".AM_L_TOUS."</a></td>\n" ;
-    $ret .= "<tr></table></td></tr>\n" ;
+    $ret .= "<tr></table></div>\n" ;
-    $ret .= "<tr class=\"insInputForm\"><td>".$mon_frag->affNbRes($nbr_final) ;
+    $ret .= "<div>".$mon_frag->affNbRes($nbr_final).'</div>' ;
-    $ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ;
+    $ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ;
     if ($nbr_final != 0) {
-        $ret .= "<tr><td><table width=\"100%\">\n";
+        $ret .= "<div><table>\n";
-        $ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&amp;sort=U_NAME\">Identit&eacute;</a></td>\n";
+        $ret .= "<tr class=\"insTitle1\"><td nowrap><a href=\"".$GLOBALS['ann_url']->getURL()."&amp;sort=U_NAME\">Identit&eacute;</a></td>\n";
-        $ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&amp;sort=U_MAIL\">Adresse mail</a></td>\n" ;
+        $ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&amp;sort=U_MAIL\">Adresse mail</a></td>\n" ;
-        $ret .= "<td><a href=\"".AM_BASE_URL.AM_URL_DOCUMENT."&amp;sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ;
+        $ret .= "<td><a href=\"".$GLOBALS['ann_url']->getURL()."&amp;sort=U_CITY\">".AM_L_VILLE."</a></td>\n" ;
 	    } else {
 	    $pair = true ;
+	    }
     $ret .= ">" ;
     $ret .= "\n<td nowrap>";
-    $urlPop = "http://$HTTP_HOST$SCRIPT_NAME" ;
-    $urlPop .= "?project=".$GS_GLOBAL['project']."&amp;locale=".$GS_GLOBAL['locale']."&amp;set=popup&amp;doc=admin_annu&amp;page=".
-                $GS_GLOBAL['current_page_ndx']."&amp;u_id=$row->U_ID" ;
+    $urlPop = $GLOBALS['ann_url']->getURL()."&amp;u_id=$row->U_ID";
-    $ret .= "<a href=\"javascript:MagicPopup('$urlPop', 'admin_annu');\">" ;
+    $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" ;
     $ret .= "<td>$row->U_CITY</td>" ;
     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 = "select GFD_NAME from ".ANN_TABLE_DEPARTEMENT.",".ANN_ANNUAIRE." where ".ANN_ANNUAIRE.".U_ID=$row->U_ID" ;
-        $req_dpt .= " and ".AM_ANNUAIRE.".U_FRENCH_DPT=".AM_DPT.".GFD_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 ".AM_DPT."<br>".mysql_error()) ;
+        $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 .= "</table></div>\n" ;
-    $ret .= "<tr class=\"insInputForm\" align=\"center\"><td align=\"center\">".$mon_frag->fragmente($nbr_final)."</td></tr>\n" ;
-    $ret .= presa_mk_blkline(1) ;
+    $ret .= "<div>".$mon_frag->fragmente($nbr_final)."</div>\n" ;
-    $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 .= "<div><a href=\"".$GLOBALS['ann_url']->getURL()."&amp;action=".ANN_MAIL_TOUS."\">".AM_L_MAIL_SELECTION."</a></div>\n" ;
+    }
     // $ret .= $ret_req ;
   return $ret;

Subversion Repositories Applications.papyrus

(root)/trunk/client/annuaire/annuaire_moteur_fonction.php @ 369 – Rev 235 → 311