| 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_backoffice.fonct.php,v 1.13 2007-11-08 09:26:20 alexandre_tb Exp $
|
13 |
// $Id: annuaire_backoffice.fonct.php,v 1.13.2.1 2008-02-08 08:21:20 alexandre_tb Exp $
|
| Line 14... |
Line 14... |
| 14 |
|
14 |
|
| 15 |
|
15 |
|
| 16 |
/** function mkengine ()
|
16 |
/** function mkengine ()
|
| Line 118... |
Line 118... |
| 118 |
$tableau_dpt[$ligne_dpt[INS_CHAMPS_ID_DEPARTEMENT]] = $ligne_dpt[INS_CHAMPS_NOM_DEPARTEMENT];
|
118 |
$tableau_dpt[$ligne_dpt[INS_CHAMPS_ID_DEPARTEMENT]] = $ligne_dpt[INS_CHAMPS_NOM_DEPARTEMENT];
|
| 119 |
if (isset ($_REQUEST['dept']) && $_REQUEST['dept'] == $ligne_dpt[INS_CHAMPS_ID_DEPARTEMENT]) {
|
119 |
if (isset ($_REQUEST['dept']) && $_REQUEST['dept'] == $ligne_dpt[INS_CHAMPS_ID_DEPARTEMENT]) {
|
| 120 |
$dpt = $_REQUEST['dept'];
|
120 |
$dpt = $_REQUEST['dept'];
|
| 121 |
}
|
121 |
}
|
| 122 |
}
|
122 |
}
|
| - |
|
123 |
// Construction d un select avec les type d inscription
|
| 123 |
|
124 |
|
| - |
|
125 |
$requete_type_inscription = 'select ic_id_inscription, ic_nom_inscription from inscription_configuration';
|
| - |
|
126 |
$resultat_type_inscription = $GLOBALS['ins_db']->query ($requete_type_inscription);
|
| - |
|
127 |
if (DB::isError($resultat_type_inscription)) {
|
| - |
|
128 |
return 'Echec de la requete<br />'.$requete_type_inscription.'<br />'.$resultat_type_inscription->getMessage();
|
| - |
|
129 |
}
|
| - |
|
130 |
if ($resultat_type_inscription->numRows() > 1) {
|
| - |
|
131 |
if (isset($_REQUEST['type_inscription'])) $type_inscription = $_REQUEST['type_inscription'];
|
| - |
|
132 |
while ($ligne_type_inscription = $resultat_type_inscription->fetchrow(DB_FETCHMODE_ASSOC)) {
|
| - |
|
133 |
$tableau_type_inscription[$ligne_type_inscription['ic_id_inscription']] = $ligne_type_inscription['ic_nom_inscription'];
|
| - |
|
134 |
}
|
| - |
|
135 |
}
|
| 124 |
$pager_select_box = $pager->getperpageselectbox (50 , 200, 50 , false ,'%d');
|
136 |
$pager_select_box = $pager->getperpageselectbox (50 , 200, 50 , false ,'%d');
|
| Line 125... |
Line 137... |
| 125 |
|
137 |
|
| 126 |
ob_start();
|
138 |
ob_start();
|
| 127 |
include_once INS_CHEMIN_SQUELETTE.INS_FICHIER_SQUELETTE_BACKOFFICE_MOTEUR ;
|
139 |
include_once INS_CHEMIN_SQUELETTE.INS_FICHIER_SQUELETTE_BACKOFFICE_MOTEUR ;
|
| Line 161... |
Line 173... |
| 161 |
for ($i = ($debut - 1) * $_REQUEST['setPerPage'];
|
173 |
for ($i = ($debut - 1) * $_REQUEST['setPerPage'];
|
| 162 |
$i < $_REQUEST['setPerPage'] * $debut;
|
174 |
$i < $_REQUEST['setPerPage'] * $debut;
|
| 163 |
$i++) {
|
175 |
$i++) {
|
| 164 |
// On teste s'il y une valeur, si oui on ajoute la ligne
|
176 |
// On teste s'il y une valeur, si oui on ajoute la ligne
|
| 165 |
if (isset ($data[$i])) {
|
177 |
if (isset ($data[$i])) {
|
| - |
|
178 |
$GLOBALS['ins_url']->addQueryString('id_inscription', $data[$i]['a_ce_id_inscription']);
|
| 166 |
$urlPop = $GLOBALS['ins_url']->getURL().'&'.INS_CHAMPS_ID.'='.$data[$i][INS_CHAMPS_ID];
|
179 |
$urlPop = $GLOBALS['ins_url']->getURL().'&'.INS_CHAMPS_ID.'='.$data[$i][INS_CHAMPS_ID];
|
| 167 |
$ligne_inscrit = array ("<a href=\"$urlPop\">".$data[$i][INS_CHAMPS_NOM].' '.$data[$i][INS_CHAMPS_PRENOM].
|
180 |
$ligne_inscrit = array ("<a href=\"$urlPop\">".$data[$i][INS_CHAMPS_NOM].' '.$data[$i][INS_CHAMPS_PRENOM].
|
| 168 |
'</a>', $data[$i][INS_CHAMPS_MAIL], $data[$i][INS_CHAMPS_VILLE]) ;
|
181 |
'</a>', $data[$i][INS_CHAMPS_MAIL], $data[$i][INS_CHAMPS_VILLE]) ;
|
| Line 169... |
Line 182... |
| 169 |
|
182 |
|
| Line 287... |
Line 300... |
| 287 |
if (isset($mail) && $mail != "") $where .= " and ".INS_CHAMPS_MAIL." like \"%$mail%\"" ;
|
300 |
if (isset($mail) && $mail != "") $where .= " and ".INS_CHAMPS_MAIL." like \"%$mail%\"" ;
|
| 288 |
$where .= ' and gip_id_i18n like "%'.$GLOBALS['lang'].'%"' ;
|
301 |
$where .= ' and gip_id_i18n like "%'.$GLOBALS['lang'].'%"' ;
|
| Line 289... |
Line 302... |
| 289 |
|
302 |
|
| 290 |
if (isset ($_REQUEST['lettre']) && $_REQUEST['lettre'] == "tous") $_REQUEST['lettre'] = "" ;
|
303 |
if (isset ($_REQUEST['lettre']) && $_REQUEST['lettre'] == "tous") $_REQUEST['lettre'] = "" ;
|
| - |
|
304 |
if (!isset ($_REQUEST['lettre'])) $_REQUEST['lettre'] = '' ;
|
| Line 291... |
Line 305... |
| 291 |
if (!isset ($_REQUEST['lettre'])) $_REQUEST['lettre'] = '' ;
|
305 |
if (isset ($_REQUEST['type_inscription']) && $_REQUEST['type_inscription'] != 'tous') $where .= ' and a_ce_id_inscription="'.$_REQUEST['type_inscription'].'"';
|
| Line 292... |
Line 306... |
| 292 |
|
306 |
|
| Line 325... |
Line 339... |
| 325 |
return $msg.mkengine();
|
339 |
return $msg.mkengine();
|
| 326 |
}
|
340 |
}
|
| 327 |
}
|
341 |
}
|
| 328 |
return $formulaire->toHTML();
|
342 |
return $formulaire->toHTML();
|
| 329 |
}
|
343 |
}
|
| - |
|
344 |
//-- Fin du code source ------------------------------------------------------------
|
| - |
|
345 |
/*
|
| - |
|
346 |
* $Log: not supported by cvs2svn $
|
| - |
|
347 |
* --------------------------------------------------------*/
|
| 330 |
?>
|
348 |
?>
|