include/userset.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 require_once('user.func.inc.php');
  23
  24 global $globals;
  25
  26 @$globals->search->result_where_statement = '
  27     LEFT JOIN  applis_ins     AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
  28     LEFT JOIN  applis_def     AS ad0 ON (ad0.id = ai0.aid)
  29     LEFT JOIN  applis_ins     AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
  30     LEFT JOIN  applis_def     AS ad1 ON (ad1.id = ai1.aid)
  31     LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.user_id)
  32     LEFT JOIN  emploi_secteur AS es  ON (e.secteur = es.id)
  33     LEFT JOIN  fonctions_def  AS ef  ON (e.fonction = ef.id)
  34     LEFT JOIN  geoloc_pays    AS n   ON (u.nationalite = n.a2)
  35     LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid AND FIND_IN_SET(\'active\',adr.statut))
  36     LEFT JOIN  geoloc_pays    AS gp  ON (adr.country = gp.a2)
  37     LEFT JOIN  geoloc_region  AS gr  ON (adr.country = gr.a2 AND adr.region = gr.region)
  38     LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = \'active\')';
  39
  40 class UserSet extends PlSet
  41 {
  42     public function __construct($joins = '', $where = '')
  43     {
  44         global $globals;
  45         parent::__construct('auth_user_md5 AS u',
  46                             (!empty($GLOBALS['IS_XNET_SITE']) ?
  47                                 'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
  48                                                                        AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
  49                            . 'LEFT JOIN auth_user_quick AS q USING (user_id)
  50                               LEFT JOIN aliases         AS a ON (a.id = u.user_id AND a.type = \'a_vie\')
  51                               ' . $joins,
  52                             $where,
  53                             'u.user_id');
  54     }
  55 }
  56
  57 class SearchSet extends UserSet
  58 {
  59     public  $advanced = false;
  60     private $score = null;
  61     private $order = null;
  62     private $quick = false;
  63
  64     public function __construct($quick = false, $no_search = false, $join = '', $where = '')
  65     {
  66         require_once dirname(__FILE__).'/../modules/search/search.inc.php';
  67
  68         if ($no_search) {
  69             return;
  70         }
  71
  72         $this->quick = $quick;
  73         if ($quick) {
  74             $this->getQuick($join, $where);
  75         } else {
  76             $this->getAdvanced($join, $where);
  77         }
  78     }
  79
  80     private function getQuick($join, $where)
  81     {
  82         require_once dirname(__FILE__).'/../modules/search/search.inc.php';
  83         global $globals;
  84         if (!S::logged()) {
  85             Env::kill('with_soundex');
  86         }
  87         $qSearch = new QuickSearch('quick');
  88         $fields  = new SFieldGroup(true, array($qSearch));
  89         if ($qSearch->isEmpty()) {
  90             new ThrowError('Aucun critère de recherche n\'est spécifié.');
  91         }
  92         $this->score = $qSearch->get_score_statement();
  93         $pwhere = $fields->get_where_statement();
  94         if (trim($pwhere)) {
  95             if (trim($where)) {
  96                 $where .= ' AND ';
  97             }
  98             $where .= $pwhere;
  99         }
 100         if (S::logged() && Env::has('nonins')) {
 101             if (trim($where)) {
 102                 $where .= ' AND ';
 103             }
 104             $where .= 'u.perms="pending" AND u.deces=0';
 105         }
 106         parent::__construct($join . ' ' . $fields->get_select_statement(), $where);
 107
 108         $this->order = implode(',',array_filter(array($fields->get_order_statement(),
 109                                                       'u.promo DESC, NomSortKey, prenom')));
 110     }
 111
 112     private function getAdvanced($join, $where)
 113     {
 114         global $globals;
 115         $this->advanced = true;
 116         $fields = new SFieldGroup(true, advancedSearchFromInput());
 117         if ($fields->too_large()) {
 118             new ThrowError('Recherche trop générale.');
 119         }
 120         parent::__construct(@$join . ' ' . $fields->get_select_statement(),
 121                             @$where . ' ' . $fields->get_where_statement());
 122         $this->order = implode(',',array_filter(array($fields->get_order_statement(),
 123                                                       'promo DESC, NomSortKey, prenom')));
 124     }
 125
 126     public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
 127     {
 128         if ($this->score) {
 129             $fields .= ', ' . $this->score;
 130         }
 131         return parent::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
 132     }
 133 }
 134
 135 class ArraySet extends UserSet
 136 {
 137     public function __construct(array $users)
 138     {
 139         $where = $this->getUids($users);
 140         if ($where) {
 141             $where = "a.alias IN ($where)";
 142         } else {
 143             $where = " 0 ";
 144         }
 145         parent::__construct('', $where);
 146     }
 147
 148     private function getUids(array $users)
 149     {
 150         $users = get_users_forlife_list($users, true, '_silent_user_callback');
 151         if (is_null($users)) {
 152             return '';
 153         }
 154         return '\'' . implode('\', \'', $users) . '\'';
 155     }
 156 }
 157
 158 class MinificheView extends MultipageView
 159 {
 160     public function __construct(PlSet &$set, $data, array $params)
 161     {
 162         require_once 'applis.func.inc.php';
 163         global $globals;
 164         $this->entriesPerPage = $globals->search->per_page;
 165         if (@$params['with_score']) {
 166             $this->addSortKey('score', array('-score', '-date', '-promo', 'nom', 'prenom'), 'pertinence');
 167         }
 168         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 169         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 170         $this->addSortKey('date_mod', array('-date', '-promo', 'nom', 'prenom'), 'dernière modification');
 171         parent::__construct($set, $data, $params);
 172     }
 173
 174     public function fields()
 175     {
 176         return "u.user_id AS id,
 177                 u.*, a.alias AS forlife,
 178                 u.perms != 'pending' AS inscrit,
 179                 u.perms != 'pending' AS wasinscrit,
 180                 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
 181                 FIND_IN_SET('femme', u.flags) AS sexe,
 182                 e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
 183                 IF(n.nat='',n.pays,n.nat) AS nat, n.a2 AS iso3166,
 184                 ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
 185                 ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
 186                 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
 187                 IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,
 188                 (COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif" .
 189                 (S::logged() ? ", c.contact AS contact" : '');
 190     }
 191
 192     public function joins()
 193     {
 194         return  "LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.user_id".(S::logged() ? "" : " AND e.pub = 'public'").")
 195                  LEFT JOIN  emploi_secteur AS es  ON (e.secteur = es.id)
 196                  LEFT JOIN  fonctions_def  AS ef  ON (e.fonction = ef.id)
 197                  LEFT JOIN  geoloc_pays    AS n   ON (u.nationalite = n.a2)
 198                  LEFT JOIN  applis_ins     AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
 199                  LEFT JOIN  applis_def     AS ad0 ON (ad0.id = ai0.aid)
 200                  LEFT JOIN  applis_ins     AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
 201                  LEFT JOIN  applis_def     AS ad1 ON (ad1.id = ai1.aid)
 202                  LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid
 203                                                       AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
 204                  LEFT JOIN  geoloc_pays    AS gp  ON (adr.country = gp.a2)
 205                  LEFT JOIN  geoloc_region  AS gr  ON (adr.country = gr.a2 AND adr.region = gr.region)
 206                  LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = 'active')" .
 207                 (S::logged() ?
 208                  "LEFT JOIN  contacts       AS c   On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
 209                  : "");
 210     }
 211
 212     public function templateName()
 213     {
 214         return 'include/plview.minifiche.tpl';
 215     }
 216 }
 217
 218 class MentorView extends MultipageView
 219 {
 220     public function __construct(PlSet &$set, $data, array $params)
 221     {
 222         $this->entriesPerPage = 10;
 223         $this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
 224         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 225         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 226         $this->addSortKey('date_mod', array('-date', '-promo', 'nom', 'prenom'), 'dernière modification');
 227         parent::__construct($set, $data, $params);
 228     }
 229
 230     public function fields()
 231     {
 232         return "m.uid, u.prenom, u.nom, u.promo,
 233                 a.alias AS forlife, m.expertise, mp.pid,
 234                 ms.secteur, ms.ss_secteur";
 235     }
 236
 237     public function templateName()
 238     {
 239         return 'include/plview.referent.tpl';
 240     }
 241 }
 242
 243 class TrombiView extends MultipageView
 244 {
 245     public function __construct(PlSet &$set, $data, array $params)
 246     {
 247         $this->entriesPerPage = 24;
 248         $this->order = explode(',', Env::v('order', 'nom,prenom,promo'));
 249         if (@$params['with_score']) {
 250             $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
 251         }
 252         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 253         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 254         parent::__construct($set, $data, $params);
 255     }
 256
 257     public function fields()
 258     {
 259         return "u.user_id, IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom, u.prenom, u.promo, a.alias AS forlife ";
 260     }
 261
 262     public function joins()
 263     {
 264         return "INNER JOIN  photo AS p ON (p.uid = u.user_id) ";
 265     }
 266
 267     public function templateName()
 268     {
 269         return 'include/plview.trombi.tpl';
 270     }
 271
 272     public function apply(PlPage &$page)
 273     {
 274         if (!empty($GLOBALS['IS_XNET_SITE'])) {
 275             global $globals;
 276             $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
 277         }
 278         return parent::apply($page);
 279     }
 280 }
 281
 282 class GeolocView implements PlView
 283 {
 284     private $set;
 285     private $type;
 286     private $params;
 287
 288     public function __construct(PlSet &$set, $data, array $params)
 289     {
 290         $this->params = $params;
 291         $this->set   =& $set;
 292         $this->type   = $data;
 293     }
 294
 295     private function use_map()
 296     {
 297         return is_file(dirname(__FILE__) . '/../modules/geoloc/dynamap.swf') &&
 298                is_file(dirname(__FILE__) . '/../modules/geoloc/icon.swf');
 299     }
 300
 301     public function args()
 302     {
 303         $args = $this->set->args();
 304         unset($args['initfile']);
 305         unset($args['mapid']);
 306         return $args;
 307     }
 308
 309     public function apply(PlPage &$page)
 310     {
 311         require_once 'geoloc.inc.php';
 312         require_once '../modules/search/search.inc.php';
 313
 314         switch ($this->type) {
 315           case 'icon.swf':
 316             header("Content-type: application/x-shockwave-flash");
 317             header("Pragma:");
 318             readfile(dirname(__FILE__).'/../modules/geoloc/icon.swf');
 319             exit;
 320
 321           case 'dynamap.swf':
 322             header("Content-type: application/x-shockwave-flash");
 323             header("Pragma:");
 324             readfile(dirname(__FILE__).'/../modules/geoloc/dynamap.swf');
 325             exit;
 326
 327           case 'init':
 328             $page->changeTpl('geoloc/init.tpl', NO_SKIN);
 329             header('Content-Type: text/xml');
 330             header('Pragma:');
 331             if (!empty($GLOBALS['IS_XNET_SITE'])) {
 332                 $page->assign('background', 0xF2E9D0);
 333             }
 334             break;
 335
 336           case 'city':
 337             $page->changeTpl('geoloc/city.tpl', NO_SKIN);
 338             header('Content-Type: text/xml');
 339             header('Pragma:');
 340             $only_current = Env::v('only_current', false)? ' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
 341             $it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
 342                                    "INNER JOIN  adresses AS adrf  ON (adrf.uid = u.user_id $only_current)
 343                                      LEFT JOIN  aliases  AS al   ON (u.user_id = al.id
 344                                                                    AND FIND_IN_SET('bestalias', al.flags))
 345                                     INNER JOIN  adresses AS avg ON (" . getadr_join('avg') . ")",
 346                                    'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
 347             $page->assign('users', $it);
 348             break;
 349
 350           case 'country':
 351             if (Env::has('debug')) {
 352                 $page->changeTpl('geoloc/country.tpl', SIMPLE);
 353             } else {
 354                 $page->changeTpl('geoloc/country.tpl', NO_SKIN);
 355                 header('Content-Type: text/xml');
 356                 header('Pragma:');
 357             }
 358             $mapid = Env::has('mapid') ? Env::i('mapid', -2) : false;
 359             list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set, 10);
 360             $page->assign('countries', $countries);
 361             $page->assign('cities', $cities);
 362             break;
 363
 364           default:
 365             global $globals;
 366             if (!$this->use_map()) {
 367                 $page->assign('request_geodesix', true);
 368             }
 369             $page->assign('annu', @$this->params['with_annu']);
 370             $page->assign('protocole', @$_SERVER['HTTPS'] ? 'https' : 'http');
 371             $this->set->get('u.user_id', null, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null);
 372             return 'include/plview.geoloc.tpl';
 373         }
 374     }
 375 }
 376
 377 class GadgetView implements PlView
 378 {
 379     public function __construct(PlSet &$set, $data, array $params)
 380     {
 381         $this->set =& $set;
 382     }
 383
 384     public function fields()
 385     {
 386         return "u.user_id AS id,
 387                 u.*, a.alias AS forlife," .
 388                 (S::logged() ? "q.profile_mobile AS mobile, " : "IF(q.profile_mobile_pub = 'public', q.profile_mobile, NULL) as mobile, ") .
 389                "u.perms != 'pending' AS inscrit,
 390                 u.perms != 'pending' AS wasinscrit,
 391                 u.deces != 0 AS dcd, u.deces,
 392                 FIND_IN_SET('femme', u.flags) AS sexe,
 393                 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region" .
 394                 (S::logged() ? ", c.contact AS contact" : '');
 395     }
 396
 397     public function joins()
 398     {
 399         return  "LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
 400                  LEFT JOIN  geoloc_pays    AS gp  ON (adr.country = gp.a2)
 401                  LEFT JOIN  geoloc_region  AS gr  ON (adr.country = gr.a2 AND adr.region = gr.region)" .
 402                 (S::logged() ?
 403                  "LEFT JOIN  contacts       AS c   On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
 404                  : "");
 405     }
 406
 407     public function apply(PlPage &$page)
 408     {
 409         $page->assign_by_ref('set',
 410           $this->set->get($this->fields(), $this->joins(), null, null, null, 5, 0));
 411     }
 412
 413     public function args()
 414     {
 415         return null;
 416     }
 417 }
 418
 419 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 420 ?>