projects / platal.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Displays the possible multiple nationalities.
[platal.git] / include / userset.inc.php
CommitLineData
8c4a0c30 1<?php
2/***************************************************************************
179afa7f 3 * Copyright (C) 2003-2008 Polytechnique.org *
8c4a0c30 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
8c4a0c30 22require_once('xorg.misc.inc.php');
23require_once('user.func.inc.php');
24
25global $globals;
26
35fa92e8 27@$globals->search->result_where_statement = '
8c4a0c30 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)
eeb2ec0f
SJ		 35 LEFT JOIN geoloc_pays AS n1 ON (u.nationalite = n1.a2)
36 LEFT JOIN geoloc_pays AS n2 ON (u.nationalite2 = n2.a2)
37 LEFT JOIN geoloc_pays AS n3 ON (u.nationalite2 = n3.a2)
8c4a0c30 38 LEFT JOIN adresses AS adr ON (u.user_id = adr.uid AND FIND_IN_SET(\'active\',adr.statut))
39 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
40 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
41 LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = \'active\')';
42
43class UserSet extends PlSet
44{
45 public function __construct($joins = '', $where = '')
46 {
47 global $globals;
48 parent::__construct('auth_user_md5 AS u',
eaf30d86
PH		 49 (!empty($GLOBALS['IS_XNET_SITE']) ?
50 'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
8c4a0c30 51 AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
eaf30d86 52 . 'LEFT JOIN auth_user_quick AS q USING (user_id)
9d66aa4a 53 LEFT JOIN aliases AS a ON (a.id = u.user_id AND a.type = \'a_vie\')
8c4a0c30 54 ' . $joins,
55 $where,
56 'u.user_id');
57 }
58}
59
60class SearchSet extends UserSet
61{
86b5c8f0 62 public $advanced = false;
35fa92e8 63 private $score = null;
8c4a0c30 64 private $order = null;
65 private $quick = false;
66
a2aa8436 67 public function __construct($quick = false, $no_search = false, $join = '', $where = '')
8c4a0c30 68 {
69 require_once dirname(__FILE__).'/../modules/search/search.inc.php';
70
71 if ($no_search) {
72 return;
73 }
74
75 $this->quick = $quick;
76 if ($quick) {
a2aa8436 77 $this->getQuick($join, $where);
8c4a0c30 78 } else {
a2aa8436 79 $this->getAdvanced($join, $where);
8c4a0c30 80 }
81 }
82
a2aa8436 83 private function getQuick($join, $where)
8c4a0c30 84 {
85 require_once dirname(__FILE__).'/../modules/search/search.inc.php';
86 global $globals;
87 if (!S::logged()) {
88 Env::kill('with_soundex');
89 }
90 $qSearch = new QuickSearch('quick');
91 $fields = new SFieldGroup(true, array($qSearch));
92 if ($qSearch->isEmpty()) {
8d118e58 93 new ThrowError('Aucun critère de recherche n\'est spécifié.');
8c4a0c30 94 }
35fa92e8 95 $this->score = $qSearch->get_score_statement();
3b2f9d11 96 $pwhere = $fields->get_where_statement();
97 if (trim($pwhere)) {
98 if (trim($where)) {
99 $where .= ' AND ';
100 }
101 $where .= $pwhere;
102 }
103 if (S::logged() && Env::has('nonins')) {
104 if (trim($where)) {
105 $where .= ' AND ';
106 }
107 $where .= 'u.perms="pending" AND u.deces=0';
108 }
109 parent::__construct($join . ' ' . $fields->get_select_statement(), $where);
8c4a0c30 110
111 $this->order = implode(',',array_filter(array($fields->get_order_statement(),
112 'u.promo DESC, NomSortKey, prenom')));
113 }
114
63fac48e 115 private function getAdvanced($join, $where)
8c4a0c30 116 {
117 global $globals;
86b5c8f0 118 $this->advanced = true;
8c4a0c30 119 $fields = new SFieldGroup(true, advancedSearchFromInput());
120 if ($fields->too_large()) {
121 new ThrowError('Recherche trop générale.');
122 }
137e819f
FB		 123 parent::__construct(@$join . ' ' . $fields->get_select_statement(),
124 @$where . ' ' . $fields->get_where_statement());
8c4a0c30 125 $this->order = implode(',',array_filter(array($fields->get_order_statement(),
126 'promo DESC, NomSortKey, prenom')));
127 }
35fa92e8 128
129 public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
130 {
131 if ($this->score) {
132 $fields .= ', ' . $this->score;
133 }
134 return parent::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
135 }
8c4a0c30 136}
137
1cc0afe7 138class ArraySet extends UserSet
139{
140 public function __construct(array $users)
141 {
142 $where = $this->getUids($users);
143 if ($where) {
144 $where = "a.alias IN ($where)";
145 } else {
146 $where = " 0 ";
147 }
148 parent::__construct('', $where);
149 }
150
151 private function getUids(array $users)
152 {
153 $users = get_users_forlife_list($users, true, '_silent_user_callback');
154 if (is_null($users)) {
155 return '';
156 }
157 return '\'' . implode('\', \'', $users) . '\'';
158 }
159}
160
8c4a0c30 161class MinificheView extends MultipageView
162{
163 public function __construct(PlSet &$set, $data, array $params)
164 {
165 require_once 'applis.func.inc.php';
166 global $globals;
167 $this->entriesPerPage = $globals->search->per_page;
35fa92e8 168 if (@$params['with_score']) {
cd5bd7dc 169 $this->addSortKey('score', array('-score', '-date', '-promo', 'name_sort'), 'pertinence');
35fa92e8 170 }
cd5bd7dc
PC		 171 $this->addSortKey('name', array('name_sort'), 'nom');
172 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
173 $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
8c4a0c30 174 parent::__construct($set, $data, $params);
175 }
176
177 public function fields()
178 {
179 return "u.user_id AS id,
180 u.*, a.alias AS forlife,
181 u.perms != 'pending' AS inscrit,
182 u.perms != 'pending' AS wasinscrit,
183 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
184 FIND_IN_SET('femme', u.flags) AS sexe,
185 e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
eeb2ec0f
SJ		 186 IF(n1.nat='',n1.pays,n1.nat) AS nat1, n1.a2 AS iso3166_1,
187 IF(n2.nat='',n2.pays,n2.nat) AS nat2, n2.a2 AS iso3166_2,
188 IF(n3.nat='',n3.pays,n3.nat) AS nat3, n3.a2 AS iso3166_3,
8c4a0c30 189 ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
190 ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
191 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
cd5bd7dc
PC		 192 (COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif,
193 nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort" .
0e5ec860 194 (S::logged() ? ", c.contact AS contact" : '');
8c4a0c30 195 }
196
197 public function joins()
198 {
f3af95c0 199 return "LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id".(S::logged() ? "" : " AND e.pub = 'public'").")
8c4a0c30 200 LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
201 LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
eeb2ec0f
SJ		 202 LEFT JOIN geoloc_pays AS n1 ON (u.nationalite = n1.a2)
203 LEFT JOIN geoloc_pays AS n2 ON (u.nationalite2 = n2.a2)
204 LEFT JOIN geoloc_pays AS n3 ON (u.nationalite3 = n3.a2)
8c4a0c30 205 LEFT JOIN applis_ins AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
206 LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
207 LEFT JOIN applis_ins AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
208 LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
209 LEFT JOIN adresses AS adr ON (u.user_id = adr.uid
f3af95c0 210 AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
8c4a0c30 211 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
212 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
cd5bd7dc
PC		 213 LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = 'active')
214 INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)" .
eaf30d86 215 (S::logged() ?
86b5c8f0 216 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
217 : "");
8c4a0c30 218 }
219
220 public function templateName()
221 {
222 return 'include/plview.minifiche.tpl';
223 }
224}
225
ff3eb9b7 226class MentorView extends MultipageView
227{
228 public function __construct(PlSet &$set, $data, array $params)
229 {
eaf30d86 230 $this->entriesPerPage = 10;
ff3eb9b7 231 $this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
cd5bd7dc
PC		 232 $this->addSortKey('name', array('name_sort'), 'nom');
233 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
234 $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
eaf30d86 235 parent::__construct($set, $data, $params);
ff3eb9b7 236 }
237
238 public function fields()
239 {
cd5bd7dc 240 return "m.uid, u.promo,
ff3eb9b7 241 a.alias AS bestalias, m.expertise, mp.pid,
cd5bd7dc
PC		 242 ms.secteur, ms.ss_secteur,
243 nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort";
244 }
245
246 public function joins()
247 {
248 return "INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
ff3eb9b7 249 }
250
251 public function templateName()
252 {
253 return 'include/plview.referent.tpl';
254 }
255}
256
8c4a0c30 257class TrombiView extends MultipageView
258{
259 public function __construct(PlSet &$set, $data, array $params)
260 {
261 $this->entriesPerPage = 24;
cd5bd7dc 262 $this->order = explode(',', Env::v('order', 'name_sort'));
35fa92e8 263 if (@$params['with_score']) {
cd5bd7dc 264 $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'name_sort'), 'pertinence');
35fa92e8 265 }
cd5bd7dc
PC		 266 $this->addSortKey('name', array('name_sort'), 'nom');
267 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
8c4a0c30 268 parent::__construct($set, $data, $params);
269 }
270
271 public function fields()
272 {
cd5bd7dc 273 return "u.user_id, nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort, u.promo, a.alias AS forlife ";
8c4a0c30 274 }
275
276 public function joins()
277 {
cd5bd7dc
PC		 278 return "INNER JOIN photo AS p ON (p.uid = u.user_id)
279 INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
8c4a0c30 280 }
281
282 public function templateName()
283 {
284 return 'include/plview.trombi.tpl';
285 }
286
287 public function apply(PlatalPage &$page)
288 {
289 if (!empty($GLOBALS['IS_XNET_SITE'])) {
290 global $globals;
291 $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
292 }
293 return parent::apply($page);
294 }
295}
296
297class GeolocView implements PlView
298{
299 private $set;
300 private $type;
301 private $params;
302
303 public function __construct(PlSet &$set, $data, array $params)
304 {
305 $this->params = $params;
306 $this->set =& $set;
307 $this->type = $data;
308 }
309
310 private function use_map()
311 {
312 return is_file(dirname(__FILE__) . '/../modules/geoloc/dynamap.swf') &&
313 is_file(dirname(__FILE__) . '/../modules/geoloc/icon.swf');
314 }
315
35fa92e8 316 public function args()
8c4a0c30 317 {
35fa92e8 318 $args = $this->set->args();
319 unset($args['initfile']);
320 unset($args['mapid']);
321 return $args;
8c4a0c30 322 }
323
324 public function apply(PlatalPage &$page)
325 {
326 require_once 'geoloc.inc.php';
327 require_once '../modules/search/search.inc.php';
328
329 switch ($this->type) {
330 case 'icon.swf':
331 header("Content-type: application/x-shockwave-flash");
332 header("Pragma:");
333 readfile(dirname(__FILE__).'/../modules/geoloc/icon.swf');
334 exit;
335
336 case 'dynamap.swf':
337 header("Content-type: application/x-shockwave-flash");
338 header("Pragma:");
339 readfile(dirname(__FILE__).'/../modules/geoloc/dynamap.swf');
340 exit;
341
342 case 'init':
343 $page->changeTpl('geoloc/init.tpl', NO_SKIN);
344 header('Content-Type: text/xml');
345 header('Pragma:');
346 if (!empty($GLOBALS['IS_XNET_SITE'])) {
347 $page->assign('background', 0xF2E9D0);
348 }
8c4a0c30 349 break;
350
351 case 'city':
352 $page->changeTpl('geoloc/city.tpl', NO_SKIN);
353 header('Content-Type: text/xml');
354 header('Pragma:');
a2aa8436 355 $only_current = Env::v('only_current', false)? ' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
8c4a0c30 356 $it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
a2aa8436 357 "INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id $only_current)
8c4a0c30 358 LEFT JOIN aliases AS al ON (u.user_id = al.id
010268b2 359 AND FIND_IN_SET('bestalias', al.flags))
97eff0ff 360 INNER JOIN adresses AS avg ON (" . getadr_join('avg') . ")",
8c4a0c30 361 'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
362 $page->assign('users', $it);
363 break;
364
365 case 'country':
366 if (Env::has('debug')) {
367 $page->changeTpl('geoloc/country.tpl', SIMPLE);
368 } else {
369 $page->changeTpl('geoloc/country.tpl', NO_SKIN);
370 header('Content-Type: text/xml');
371 header('Pragma:');
372 }
8c4a0c30 373 $mapid = Env::has('mapid') ? Env::i('mapid', -2) : false;
374 list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set, 10);
375 $page->assign('countries', $countries);
376 $page->assign('cities', $cities);
377 break;
378
379 default:
380 global $globals;
381 if (!$this->use_map()) {
382 $page->assign('request_geodesix', true);
383 }
a2aa8436 384 $page->assign('annu', @$this->params['with_annu']);
8c4a0c30 385 $page->assign('protocole', @$_SERVER['HTTPS'] ? 'https' : 'http');
386 $this->set->get('u.user_id', null, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null);
8c4a0c30 387 return 'include/plview.geoloc.tpl';
388 }
389 }
390}
391
92e80560
VZ		 392class GadgetView implements PlView
393{
394 public function __construct(PlSet &$set, $data, array $params)
395 {
396 $this->set =& $set;
397 }
398
399 public function fields()
400 {
401 return "u.user_id AS id,
402 u.*, a.alias AS forlife," .
92e80560
VZ		 403 "u.perms != 'pending' AS inscrit,
404 u.perms != 'pending' AS wasinscrit,
405 u.deces != 0 AS dcd, u.deces,
406 FIND_IN_SET('femme', u.flags) AS sexe,
407 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region" .
408 (S::logged() ? ", c.contact AS contact" : '');
409 }
410
411 public function joins()
412 {
413 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'").")
414 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
415 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)" .
416 (S::logged() ?
417 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
418 : "");
419 }
420
421 public function apply(PlatalPage &$page)
422 {
423 $page->assign_by_ref('set',
424 $this->set->get($this->fields(), $this->joins(), null, null, null, 5, 0));
425 }
426
427 public function args()
428 {
429 return null;
430 }
431}
432
8c4a0c30 433// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
434?>
plat/al