include/userset.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2007 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('xorg.misc.inc.php');
  23 require_once('user.func.inc.php');
  24
  25 global $globals;
  26
  27 @$globals->search->result_where_statement = '
  28     LEFT JOIN  applis_ins     AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
  29     LEFT JOIN  applis_def     AS ad0 ON (ad0.id = ai0.aid)
  30     LEFT JOIN  applis_ins     AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
  31     LEFT JOIN  applis_def     AS ad1 ON (ad1.id = ai1.aid)
  32     LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.user_id)
  33     LEFT JOIN  emploi_secteur AS es  ON (e.secteur = es.id)
  34     LEFT JOIN  fonctions_def  AS ef  ON (e.fonction = ef.id)
  35     LEFT JOIN  geoloc_pays    AS n   ON (u.nationalite = n.a2)
  36     LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid AND FIND_IN_SET(\'active\',adr.statut))
  37     LEFT JOIN  geoloc_pays    AS gp  ON (adr.country = gp.a2)
  38     LEFT JOIN  geoloc_region  AS gr  ON (adr.country = gr.a2 AND adr.region = gr.region)
  39     LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = \'active\')';
  40
  41 class UserSet extends PlSet
  42 {
  43     public function __construct($joins = '', $where = '')
  44     {
  45         global $globals;
  46         parent::__construct('auth_user_md5 AS u',
  47                             (!empty($GLOBALS['IS_XNET_SITE']) ?
  48                                 'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
  49                                                                        AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
  50                            . 'LEFT JOIN auth_user_quick AS q USING (user_id)
  51                               LEFT JOIN aliases         AS a ON (a.id = u.user_id AND type = \'a_vie\')
  52                               ' . $joins,
  53                             $where,
  54                             'u.user_id');
  55     }
  56 }
  57
  58 class SearchSet extends UserSet
  59 {
  60     private $score = null;
  61     private $order = null;
  62     private $quick = false;
  63
  64     public function __construct($quick = false, $no_search = false)
  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();
  75         } else {
  76             $this->getAdvanced();
  77         }
  78     }
  79
  80     private function getQuick()
  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('Recherche trop générale.');
  91         }
  92         $this->score = $qSearch->get_score_statement();
  93         parent::__construct("{$fields->get_select_statement()}
  94                              {$globals->search->result_where_statement}",
  95                             $fields->get_where_statement() .
  96                             (S::logged() && Env::has('nonins') ? ' AND u.perms="pending" AND u.deces=0' : ''));
  97
  98         $this->order = implode(',',array_filter(array($fields->get_order_statement(),
  99                                                       'u.promo DESC, NomSortKey, prenom')));
 100     }
 101
 102     private function getAdvanced()
 103     {
 104         global $globals;
 105         $fields = new SFieldGroup(true, advancedSearchFromInput());
 106         if ($fields->too_large()) {
 107             new ThrowError('Recherche trop générale.');
 108         }
 109         parent::__construct($fields->get_select_statement() . ' ' . $globals->search->result_where_statement,
 110                             $fields->get_where_statement());
 111         $this->order = implode(',',array_filter(array($fields->get_order_statement(),
 112                                                       'promo DESC, NomSortKey, prenom')));
 113     }
 114
 115     public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
 116     {
 117         if ($this->score) {
 118             $fields .= ', ' . $this->score;
 119         }
 120         return parent::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
 121     }
 122 }
 123
 124 class ArraySet extends UserSet
 125 {
 126     public function __construct(array $users)
 127     {
 128         $where = $this->getUids($users);
 129         if ($where) {
 130             $where = "a.alias IN ($where)";
 131         } else {
 132             $where = " 0 ";
 133         }
 134         parent::__construct('', $where);
 135     }
 136
 137     private function getUids(array $users)
 138     {
 139         $users = get_users_forlife_list($users, true, '_silent_user_callback');
 140         if (is_null($users)) {
 141             return '';
 142         }
 143         return '\'' . implode('\', \'', $users) . '\'';
 144     }
 145 }
 146
 147 class MinificheView extends MultipageView
 148 {
 149     public function __construct(PlSet &$set, $data, array $params)
 150     {
 151         require_once 'applis.func.inc.php';
 152         global $globals;
 153         $this->entriesPerPage = $globals->search->per_page;
 154         if (@$params['with_score']) {
 155             $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
 156         }
 157         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 158         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 159         $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
 160         parent::__construct($set, $data, $params);
 161     }
 162
 163     public function fields()
 164     {
 165         return "u.user_id AS id,
 166                 u.*, a.alias AS forlife,
 167                 u.perms != 'pending' AS inscrit,
 168                 u.perms != 'pending' AS wasinscrit,
 169                 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
 170                 FIND_IN_SET('femme', u.flags) AS sexe,
 171                 e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
 172                 IF(n.nat='',n.pays,n.nat) AS nat, n.a2 AS iso3166,
 173                 ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
 174                 ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
 175                 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
 176                 IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,
 177                 COUNT(em.email) > 0 AS actif" . (S::logged() ? ", c.contact AS contact" : '');
 178     }
 179
 180     public function joins()
 181     {
 182         return  ($this->set instanceof SearchSet ? "" :
 183                 "LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.user_id)
 184                  LEFT JOIN  emploi_secteur AS es  ON (e.secteur = es.id)
 185                  LEFT JOIN  fonctions_def  AS ef  ON (e.fonction = ef.id)
 186                  LEFT JOIN  geoloc_pays    AS n   ON (u.nationalite = n.a2)
 187                  LEFT JOIN  applis_ins     AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
 188                  LEFT JOIN  applis_def     AS ad0 ON (ad0.id = ai0.aid)
 189                  LEFT JOIN  applis_ins     AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
 190                  LEFT JOIN  applis_def     AS ad1 ON (ad1.id = ai1.aid)
 191                  LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid
 192                                                       AND FIND_IN_SET('active', adr.statut))
 193                  LEFT JOIN  geoloc_pays    AS gp  ON (adr.country = gp.a2)
 194                  LEFT JOIN  geoloc_region  AS gr  ON (adr.country = gr.a2 AND adr.region = gr.region)
 195                  LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = 'active')
 196                 ") . (S::logged() ?
 197                         "LEFT JOIN  contacts       AS c   On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
 198                         : "");
 199     }
 200
 201     public function templateName()
 202     {
 203         return 'include/plview.minifiche.tpl';
 204     }
 205 }
 206
 207 class MentorView extends MultipageView
 208 {
 209     public function __construct(PlSet &$set, $data, array $params)
 210     {
 211         $this->entriesPerPage = 10;
 212         $this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
 213         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 214         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 215         $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
 216         parent::__construct($set, $data, $params);
 217     }
 218
 219     public function fields()
 220     {
 221         return "m.uid, u.prenom, u.nom, u.promo,
 222                 a.alias AS bestalias, m.expertise, mp.pid,
 223                 ms.secteur, ms.ss_secteur";
 224     }
 225
 226     public function templateName()
 227     {
 228         return 'include/plview.referent.tpl';
 229     }
 230 }
 231
 232 class TrombiView extends MultipageView
 233 {
 234     public function __construct(PlSet &$set, $data, array $params)
 235     {
 236         $this->entriesPerPage = 24;
 237         $this->order = explode(',', Env::v('order', 'nom,prenom,promo'));
 238         if (@$params['with_score']) {
 239             $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
 240         }
 241         $this->addSortKey('name', array('nom', 'prenom'), 'nom');
 242         $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
 243         parent::__construct($set, $data, $params);
 244     }
 245
 246     public function fields()
 247     {
 248         return "u.user_id, IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom, u.prenom, u.promo, a.alias AS forlife ";
 249     }
 250
 251     public function joins()
 252     {
 253         return "INNER JOIN  photo AS p ON (p.uid = u.user_id) ";
 254     }
 255
 256     public function templateName()
 257     {
 258         return 'include/plview.trombi.tpl';
 259     }
 260
 261     public function apply(PlatalPage &$page)
 262     {
 263         if (!empty($GLOBALS['IS_XNET_SITE'])) {
 264             global $globals;
 265             $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
 266         }
 267         return parent::apply($page);
 268     }
 269 }
 270
 271 class GeolocView implements PlView
 272 {
 273     private $set;
 274     private $type;
 275     private $params;
 276
 277     public function __construct(PlSet &$set, $data, array $params)
 278     {
 279         $this->params = $params;
 280         $this->set   =& $set;
 281         $this->type   = $data;
 282     }
 283
 284     private function use_map()
 285     {
 286         return is_file(dirname(__FILE__) . '/../modules/geoloc/dynamap.swf') &&
 287                is_file(dirname(__FILE__) . '/../modules/geoloc/icon.swf');
 288     }
 289
 290     public function args()
 291     {
 292         $args = $this->set->args();
 293         unset($args['initfile']);
 294         unset($args['mapid']);
 295         return $args;
 296     }
 297
 298     public function apply(PlatalPage &$page)
 299     {
 300         require_once 'geoloc.inc.php';
 301         require_once '../modules/search/search.inc.php';
 302
 303         switch ($this->type) {
 304           case 'icon.swf':
 305             header("Content-type: application/x-shockwave-flash");
 306             header("Pragma:");
 307             readfile(dirname(__FILE__).'/../modules/geoloc/icon.swf');
 308             exit;
 309
 310           case 'dynamap.swf':
 311             header("Content-type: application/x-shockwave-flash");
 312             header("Pragma:");
 313             readfile(dirname(__FILE__).'/../modules/geoloc/dynamap.swf');
 314             exit;
 315
 316           case 'init':
 317             $page->changeTpl('geoloc/init.tpl', NO_SKIN);
 318             header('Content-Type: text/xml');
 319             header('Pragma:');
 320             if (!empty($GLOBALS['IS_XNET_SITE'])) {
 321                 $page->assign('background', 0xF2E9D0);
 322             }
 323             break;
 324
 325           case 'city':
 326             $page->changeTpl('geoloc/city.tpl', NO_SKIN);
 327             header('Content-Type: text/xml');
 328             header('Pragma:');
 329             $it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
 330                                    "INNER JOIN  adresses AS adrf  ON (adrf.uid = u.user_id)
 331                                      LEFT JOIN  aliases  AS al   ON (u.user_id = al.id
 332                                                                    AND FIND_IN_SET(al.flags, 'bestalias'))
 333                                     INNER JOIN  adresses AS av ON (" . getadr_join('av') . ")",
 334                                    'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
 335             $page->assign('users', $it);
 336             break;
 337
 338           case 'country':
 339             if (Env::has('debug')) {
 340                 $page->changeTpl('geoloc/country.tpl', SIMPLE);
 341             } else {
 342                 $page->changeTpl('geoloc/country.tpl', NO_SKIN);
 343                 header('Content-Type: text/xml');
 344                 header('Pragma:');
 345             }
 346             $mapid = Env::has('mapid') ? Env::i('mapid', -2) : false;
 347             list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set, 10);
 348             $page->assign('countries', $countries);
 349             $page->assign('cities', $cities);
 350             break;
 351
 352           default:
 353             global $globals;
 354             if (!$this->use_map()) {
 355                 $page->assign('request_geodesix', true);
 356             }
 357             if (!empty($GLOBALS['IS_XNET_SITE'])) {
 358                 $page->assign('no_annu', true);
 359             }
 360             $page->assign('protocole', @$_SERVER['HTTPS'] ? 'https' : 'http');
 361             $this->set->get('u.user_id', null, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null);
 362             return 'include/plview.geoloc.tpl';
 363         }
 364     }
 365 }
 366
 367 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 368 ?>