X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fuserset.inc.php;h=f7252105b1bb4806f92fd4a27d442f8d97691ba4;hb=86aa4b4cccd01fa073f3d46bc7890bc0debb270c;hp=ebd37dd648c227cb350691c113a528765f083254;hpb=5818ad2405cfb20b4cb906711040ab6681f3209b;p=platal.git

diff --git a/include/userset.inc.php b/include/userset.inc.php
index ebd37dd..f725210 100644
--- a/include/userset.inc.php
+++ b/include/userset.inc.php
@@ -173,6 +173,7 @@ class MinificheView extends MultipageView
     {
         global $globals;
         return "u.user_id AS id, u.*, d.promo_display,
+                CONCAT(a.alias, '@{$globals->mail->domain}') AS bestemail,
                 u.perms != 'pending' AS inscrit,
                 u.perms != 'pending' AS wasinscrit,
                 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
@@ -201,7 +202,8 @@ class MinificheView extends MultipageView
 
     public function joins()
     {
-        return  "LEFT JOIN  profile_job                   AS j    ON (j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").")
+        return  "LEFT JOIN  aliases                       AS a    ON (u.user_id = a.id AND FIND_IN_SET('bestalias', a.flags))
+                 LEFT JOIN  profile_job                   AS j    ON (j.uid = u.user_id".(S::logged() ? "" : " AND j.pub = 'public'").")
                  LEFT JOIN  profile_job_enum              AS je   ON (je.id = j.jobid)
                  LEFT JOIN  profile_job_sector_enum       AS es   ON (j.sectorid = es.id)
                  LEFT JOIN  fonctions_def                 AS ef   ON (j.functionid = ef.id)