projects / platal.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Bye xorg.misc.inc.php
[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('user.func.inc.php');
23
24global $globals;
25
35fa92e8 26@$globals->search->result_where_statement = '
8c4a0c30 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
40class UserSet extends PlSet
41{
42 public function __construct($joins = '', $where = '')
43 {
44 global $globals;
45 parent::__construct('auth_user_md5 AS u',
eaf30d86
PH		 46 (!empty($GLOBALS['IS_XNET_SITE']) ?
47 'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
8c4a0c30 48 AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
eaf30d86 49 . 'LEFT JOIN auth_user_quick AS q USING (user_id)
9d66aa4a 50 LEFT JOIN aliases AS a ON (a.id = u.user_id AND a.type = \'a_vie\')
8c4a0c30 51 ' . $joins,
52 $where,
53 'u.user_id');
54 }
55}
56
57class SearchSet extends UserSet
58{
86b5c8f0 59 public $advanced = false;
35fa92e8 60 private $score = null;
8c4a0c30 61 private $order = null;
62 private $quick = false;
63
a2aa8436 64 public function __construct($quick = false, $no_search = false, $join = '', $where = '')
8c4a0c30 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) {
a2aa8436 74 $this->getQuick($join, $where);
8c4a0c30 75 } else {
a2aa8436 76 $this->getAdvanced($join, $where);
8c4a0c30 77 }
78 }
79
a2aa8436 80 private function getQuick($join, $where)
8c4a0c30 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()) {
8d118e58 90 new ThrowError('Aucun critère de recherche n\'est spécifié.');
8c4a0c30 91 }
35fa92e8 92 $this->score = $qSearch->get_score_statement();
3b2f9d11 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);
8c4a0c30 107
108 $this->order = implode(',',array_filter(array($fields->get_order_statement(),
109 'u.promo DESC, NomSortKey, prenom')));
110 }
111
63fac48e 112 private function getAdvanced($join, $where)
8c4a0c30 113 {
114 global $globals;
86b5c8f0 115 $this->advanced = true;
8c4a0c30 116 $fields = new SFieldGroup(true, advancedSearchFromInput());
117 if ($fields->too_large()) {
118 new ThrowError('Recherche trop générale.');
119 }
137e819f
FB		 120 parent::__construct(@$join . ' ' . $fields->get_select_statement(),
121 @$where . ' ' . $fields->get_where_statement());
8c4a0c30 122 $this->order = implode(',',array_filter(array($fields->get_order_statement(),
123 'promo DESC, NomSortKey, prenom')));
124 }
35fa92e8 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 }
8c4a0c30 133}
134
1cc0afe7 135class 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
8c4a0c30 158class 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;
35fa92e8 165 if (@$params['with_score']) {
acbd9804 166 $this->addSortKey('score', array('-score', '-date', '-promo', 'nom', 'prenom'), 'pertinence');
35fa92e8 167 }
168 $this->addSortKey('name', array('nom', 'prenom'), 'nom');
169 $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
acbd9804 170 $this->addSortKey('date_mod', array('-date', '-promo', 'nom', 'prenom'), 'dernière modification');
8c4a0c30 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,
0e5ec860
VZ		 188 (COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif" .
189 (S::logged() ? ", c.contact AS contact" : '');
8c4a0c30 190 }
191
192 public function joins()
193 {
f3af95c0 194 return "LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id".(S::logged() ? "" : " AND e.pub = 'public'").")
8c4a0c30 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
f3af95c0 203 AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
8c4a0c30 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)
86b5c8f0 206 LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = 'active')" .
eaf30d86 207 (S::logged() ?
86b5c8f0 208 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
209 : "");
8c4a0c30 210 }
211
212 public function templateName()
213 {
214 return 'include/plview.minifiche.tpl';
215 }
216}
217
ff3eb9b7 218class MentorView extends MultipageView
219{
220 public function __construct(PlSet &$set, $data, array $params)
221 {
eaf30d86 222 $this->entriesPerPage = 10;
ff3eb9b7 223 $this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
eaf30d86
PH		 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);
ff3eb9b7 228 }
229
230 public function fields()
231 {
232 return "m.uid, u.prenom, u.nom, u.promo,
e1ce18d2 233 a.alias AS forlife, m.expertise, mp.pid,
ff3eb9b7 234 ms.secteur, ms.ss_secteur";
235 }
236
237 public function templateName()
238 {
239 return 'include/plview.referent.tpl';
240 }
241}
242
8c4a0c30 243class 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'));
35fa92e8 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');
8c4a0c30 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
04334c61 272 public function apply(PlPage &$page)
8c4a0c30 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
282class 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
35fa92e8 301 public function args()
8c4a0c30 302 {
35fa92e8 303 $args = $this->set->args();
304 unset($args['initfile']);
305 unset($args['mapid']);
306 return $args;
8c4a0c30 307 }
308
04334c61 309 public function apply(PlPage &$page)
8c4a0c30 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 }
8c4a0c30 334 break;
335
336 case 'city':
337 $page->changeTpl('geoloc/city.tpl', NO_SKIN);
338 header('Content-Type: text/xml');
339 header('Pragma:');
a2aa8436 340 $only_current = Env::v('only_current', false)? ' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
8c4a0c30 341 $it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
a2aa8436 342 "INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id $only_current)
8c4a0c30 343 LEFT JOIN aliases AS al ON (u.user_id = al.id
010268b2 344 AND FIND_IN_SET('bestalias', al.flags))
97eff0ff 345 INNER JOIN adresses AS avg ON (" . getadr_join('avg') . ")",
8c4a0c30 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 }
8c4a0c30 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 }
a2aa8436 369 $page->assign('annu', @$this->params['with_annu']);
8c4a0c30 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);
8c4a0c30 372 return 'include/plview.geoloc.tpl';
373 }
374 }
375}
376
92e80560
VZ		 377class 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
04334c61 407 public function apply(PlPage &$page)
92e80560
VZ		 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
8c4a0c30 419// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
420?>
plat/al