2 require 'xnet.inc.php';
4 define('NB_PER_PAGE', 25);
6 if ($globals->asso('pub') == 'public')
7 new_group_page('xnet/groupe/annuaire.tpl');
9 new_groupadmin_page('xnet/groupe/annuaire.tpl');
11 $page->assign('admin', may_update());
13 switch (Env
::get('order')) {
14 case 'promo' : $group = 'promo'; $tri = 'promo_o DESC, nom, prenom'; break;
15 case 'promo_inv' : $group = 'promo'; $tri = 'promo_o, nom, prenom'; break;
16 case 'alpha_inv' : $group = 'initiale'; $tri = 'nom DESC, prenom DESC, promo'; break;
17 default : $group = 'initiale'; $tri = 'nom, prenom, promo';
19 if ($group == 'initiale')
20 $res = $globals->xdb
->iterRow(
21 'SELECT UPPER(SUBSTRING(IF(m.origine="X",IF(u.nom_usage<>"", u.nom_usage, u.nom),m.nom), 1, 1)) as letter, COUNT(*)
22 FROM groupex.membres AS m
23 LEFT JOIN auth_user_md5 AS u ON ( u.user_id = m.uid )
26 ORDER BY letter', $globals->asso('id'));
28 $res = $globals->xdb
->iterRow(
29 'SELECT IF(m.origine="X",u.promo,"extérieur") as promo, COUNT(*), IF(m.origine="X",u.promo,"") as promo_o
30 FROM groupex.membres AS m
31 LEFT JOIN auth_user_md5 AS u ON ( u.user_id = m.uid )
34 ORDER BY promo_o DESC', $globals->asso('id'));
38 while (list($char, $nb) = $res->next()) {
41 if (Env
::has($group) && $char == strtoupper(Env
::get($group))) {
45 $page->assign('group', $group);
46 $page->assign('request_group', Env
::get($group));
47 $page->assign('alphabet', $alphabet);
48 $page->assign('nb_tot', $nb_tot);
50 $ofs = Env
::getInt('offset');
51 $tot = Env
::get($group) ?
$tot : $nb_tot;
52 $nbp = intval(($tot-1)/NB_PER_PAGE
);
55 $links['précédent'] = $ofs-1;
57 for ($i = 0; $i <= $nbp; $i++
) {
58 $links[(string)($i+
1)] = $i;
61 $links['suivant'] = $ofs+
1;
63 if (count($links)>1) {
64 $page->assign('links', $links);
68 if (Env
::has('initiale'))
69 $ini = 'AND IF(m.origine="X",IF(u.nom_usage<>"", u.nom_usage, u.nom),m.nom) LIKE "'.addslashes(Env
::get('initiale')).'%"';
70 elseif (Env
::has('promo'))
71 $ini = 'AND IF(m.origine="X",u.promo,"extérieur") = "'.addslashes(Env
::get('promo')).'"';
72 $ann = $globals->xdb
->iterator(
73 "SELECT IF(m.origine='X',IF(u.nom_usage<>'', u.nom_usage, u.nom) ,m.nom) AS nom,
74 IF(m.origine='X',u.prenom,m.prenom) AS prenom,
75 IF(m.origine='X',u.promo,'extérieur') AS promo,
76 IF(m.origine='X',u.promo,'') AS promo_o,
77 IF(m.origine='X',a.alias,m.email) AS email,
78 IF(m.origine='X',FIND_IN_SET('femme', u.flags),0) AS femme,
79 m.perms='admin' AS admin,
82 FROM groupex.membres AS m
83 LEFT JOIN auth_user_md5 AS u ON ( u.user_id = m.uid )
84 LEFT JOIN aliases AS a ON ( a.id = m.uid AND a.type='a_vie' )
85 WHERE m.asso_id = {?} $ini
87 LIMIT {?},{?}", $globals->asso('id'), $ofs*NB_PER_PAGE
, NB_PER_PAGE
);
90 $page->assign('ann', $ann);