- global $globals;
- new_annu_page('xnetgrp/trombi.tpl');
-
- $page->assign('urlmainsite', "https://www.polytechnique.org/");
- $trombi = new Trombi(array($this, '_trombi_getlist'));
- $trombi->hidePromo();
- $trombi->setAdmin();
- $page->assign_by_ref('trombi', $trombi);
- }
-
- function _trombi_getlist($offset, $limit)
- {
- global $globals;
- $where = "WHERE m.asso_id= '".addslashes($globals->asso('id'))."'";
-
- $res = XDB::query(
- "SELECT COUNT(*)
- FROM auth_user_md5 AS u
- RIGHT JOIN photo AS p ON u.user_id=p.uid
- INNER JOIN groupex.membres AS m ON (m.uid = u.user_id)
- $where");
- $pnb = $res->fetchOneCell();
-
- $res = XDB::query("SELECT promo, user_id, a.alias AS forlife,
- IF (nom_usage='', u.nom, nom_usage) AS nom, u.prenom
- FROM photo AS p
- INNER JOIN auth_user_md5 AS u ON u.user_id=p.uid
- INNER JOIN aliases AS a ON ( u.user_id=a.id AND a.type='a_vie' )
- INNER JOIN groupex.membres AS m ON (m.uid = u.user_id)
- $where
- ORDER BY promo, u.nom, u.prenom LIMIT {?}, {?}", $offset*$limit, $limit);
-
- return array($pnb, $res->fetchAllAssoc());
+ $view = new UserSet();
+ $view->addMod('trombi', 'Trombinoscope', true, array('with_admin' => false, 'with_promo' => true));
+ $view->apply('trombi', $page, 'trombi', $action, $subaction);