31358d261dc2eaf0f5f7456e065d6c02a98c49a0
2 /***************************************************************************
3 * Copyright (C) 2003-2008 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 require_once('user.func.inc.php');
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\')';
40 class UserSet
extends PlSet
42 public function __construct($joins = '', $where = '')
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\')
57 class SearchSet
extends UserSet
59 public $advanced = false
;
60 private $score = null
;
61 private $order = null
;
62 private $quick = false
;
64 public function __construct($quick = false
, $no_search = false
, $join = '', $where = '')
66 require_once dirname(__FILE__
).'/../modules/search/search.inc.php';
72 $this->quick
= $quick;
74 $this->getQuick($join, $where);
76 $this->getAdvanced($join, $where);
80 private function getQuick($join, $where)
82 require_once dirname(__FILE__
).'/../modules/search/search.inc.php';
85 Env
::kill('with_soundex');
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é.');
92 $this->score
= $qSearch->get_score_statement();
93 $pwhere = $fields->get_where_statement();
100 if (S
::logged() && Env
::has('nonins')) {
104 $where .= 'u.perms="pending" AND u.deces=0';
106 parent
::__construct($join . ' ' . $fields->get_select_statement(), $where);
108 $this->order
= implode(',',array_filter(array($fields->get_order_statement(),
109 'u.promo DESC, NomSortKey, prenom')));
112 private function getAdvanced($join, $where)
115 $this->advanced
= true
;
116 $fields = new SFieldGroup(true
, advancedSearchFromInput());
117 if ($fields->too_large()) {
118 new ThrowError('Recherche trop générale.');
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')));
126 public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null
, $limitfrom = null
)
129 $fields .= ', ' . $this->score
;
131 return parent
::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
135 class ArraySet
extends UserSet
137 public function __construct(array $users)
139 $where = $this->getUids($users);
141 $where = "a.alias IN ($where)";
145 parent
::__construct('', $where);
148 private function getUids(array $users)
150 $users = get_users_forlife_list($users, true
, '_silent_user_callback');
151 if (is_null($users)) {
154 return '\'' . implode('\', \'', $users) . '\'';
158 class MinificheView
extends MultipageView
160 public function __construct(PlSet
&$set, $data, array $params)
162 require_once 'applis.func.inc.php';
164 $this->entriesPerPage
= $globals->search
->per_page
;
165 if (@$params['with_score']) {
166 $this->addSortKey('score', array('-score', '-date', '-promo', 'name_sort'), 'pertinence');
168 $this->addSortKey('name', array('name_sort'), 'nom');
169 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
170 $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
171 parent
::__construct($set, $data, $params);
174 public function fields()
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 (COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif,
188 nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort" .
189 (S
::logged() ?
", c.contact AS contact" : '');
192 public function joins()
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 INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)" .
209 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S
::v('uid') . ")"
213 public function bounds()
215 $order = Env
::v('order', $this->defaultkey
);
217 if (($order == "name") ||
($order == "-name")) {
218 $this->bound_field
= "nom";
220 } elseif (($order == "promo") ||
($order == "-promo")) {
221 $this->bound_field
= "promo";
224 if ($order{0} == '-') {
225 $show_bounds = -$show_bounds;
230 public function templateName()
232 return 'include/plview.minifiche.tpl';
236 class MentorView
extends MultipageView
238 public function __construct(PlSet
&$set, $data, array $params)
240 $this->entriesPerPage
= 10;
241 $this->addSortKey('rand', array('RAND(' . S
::i('uid') . ')'), 'aléatoirement');
242 $this->addSortKey('name', array('name_sort'), 'nom');
243 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
244 $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
245 parent
::__construct($set, $data, $params);
248 public function fields()
250 return "m.uid, u.promo,
251 a.alias AS bestalias, m.expertise, mp.pid,
252 ms.secteur, ms.ss_secteur,
253 nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort";
256 public function joins()
258 return "INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
261 public function bounds()
263 $order = Env
::v('order', $this->defaultkey
);
265 if (($order == "name") ||
($order == "-name")) {
266 $this->bound_field
= "nom";
268 } elseif (($order == "promo") ||
($order == "-promo")) {
269 $this->bound_field
= "promo";
272 if ($order{0} == '-') {
273 $show_bounds = -$show_bounds;
278 public function templateName()
280 return 'include/plview.referent.tpl';
284 class TrombiView
extends MultipageView
286 public function __construct(PlSet
&$set, $data, array $params)
288 $this->entriesPerPage
= 24;
289 $this->order
= explode(',', Env
::v('order', 'name_sort'));
290 if (@$params['with_score']) {
291 $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'name_sort'), 'pertinence');
293 $this->addSortKey('name', array('name_sort'), 'nom');
294 $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
295 parent
::__construct($set, $data, $params);
298 public function fields()
300 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 ";
303 public function joins()
305 return "INNER JOIN photo AS p ON (p.uid = u.user_id)
306 INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
309 public function bounds()
311 $order = Env
::v('order', $this->defaultkey
);
313 if (($order == "name") ||
($order == "-name")) {
314 $this->bound_field
= "nom";
316 } elseif (($order == "promo") ||
($order == "-promo")) {
317 $this->bound_field
= "promo";
320 if ($order{0} == '-') {
321 $show_bounds = -$show_bounds;
326 public function templateName()
328 return 'include/plview.trombi.tpl';
331 public function apply(PlPage
&$page)
333 if (!empty($GLOBALS['IS_XNET_SITE'])) {
335 $page->assign('mainsiteurl', 'https://' . $globals->core
->secure_domain
. '/');
337 return parent
::apply($page);
341 class GeolocView
implements PlView
347 public function __construct(PlSet
&$set, $data, array $params)
349 $this->params
= $params;
354 private function use_map()
356 return is_file(dirname(__FILE__
) . '/../modules/geoloc/dynamap.swf') &&
357 is_file(dirname(__FILE__
) . '/../modules/geoloc/icon.swf');
360 public function args()
362 $args = $this->set
->args();
363 unset($args['initfile']);
364 unset($args['mapid']);
368 public function apply(PlPage
&$page)
370 require_once 'geoloc.inc.php';
371 require_once '../modules/search/search.inc.php';
373 switch ($this->type
) {
375 header("Content-type: application/x-shockwave-flash");
377 readfile(dirname(__FILE__
).'/../modules/geoloc/icon.swf');
381 header("Content-type: application/x-shockwave-flash");
383 readfile(dirname(__FILE__
).'/../modules/geoloc/dynamap.swf');
387 $page->changeTpl('geoloc/init.tpl', NO_SKIN
);
388 header('Content-Type: text/xml');
390 if (!empty($GLOBALS['IS_XNET_SITE'])) {
391 $page->assign('background', 0xF2E9D0);
396 $page->changeTpl('geoloc/city.tpl', NO_SKIN
);
397 header('Content-Type: text/xml');
399 $only_current = Env
::v('only_current', false
)?
' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
400 $it =& $this->set
->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
401 "INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id $only_current)
402 LEFT JOIN aliases AS al ON (u.user_id = al.id
403 AND FIND_IN_SET('bestalias', al.flags))
404 INNER JOIN adresses AS avg ON (" . getadr_join('avg') . ")",
405 'adrf.cityid = ' . Env
::i('cityid'), null
, null
, 11);
406 $page->assign('users', $it);
410 if (Env
::has('debug')) {
411 $page->changeTpl('geoloc/country.tpl', SIMPLE
);
413 $page->changeTpl('geoloc/country.tpl', NO_SKIN
);
414 header('Content-Type: text/xml');
417 $mapid = Env
::has('mapid') ? Env
::i('mapid', -2) : false
;
418 list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set
, 10);
419 $page->assign('countries', $countries);
420 $page->assign('cities', $cities);
425 if (!$this->use_map()) {
426 $page->assign('request_geodesix', true
);
428 $page->assign('annu', @$this->params
['with_annu']);
429 $page->assign('protocole', @$_SERVER['HTTPS'] ?
'https' : 'http');
430 $this->set
->get('u.user_id', null
, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null
);
431 return 'include/plview.geoloc.tpl';
436 class GadgetView
implements PlView
438 public function __construct(PlSet
&$set, $data, array $params)
443 public function fields()
445 return "u.user_id AS id,
446 u.*, a.alias AS forlife," .
447 "u.perms != 'pending' AS inscrit,
448 u.perms != 'pending' AS wasinscrit,
449 u.deces != 0 AS dcd, u.deces,
450 FIND_IN_SET('femme', u.flags) AS sexe,
451 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region" .
452 (S
::logged() ?
", c.contact AS contact" : '');
455 public function joins()
457 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'").")
458 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
459 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)" .
461 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S
::v('uid') . ")"
465 public function apply(PlPage
&$page)
467 $page->assign_by_ref('set',
468 $this->set
->get($this->fields(), $this->joins(), null
, null
, null
, 5, 0));
471 public function args()
477 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: