db56b4ce0250e3efeecb345359c3c7c643eb9437
2 /***************************************************************************
3 * Copyright (C) 2003-2007 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('xorg.misc.inc.php');
23 require_once('user.func.inc.php');
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\')';
41 class UserSet
extends PlSet
43 public function __construct($joins = '', $where = '')
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\')
58 class SearchSet
extends UserSet
60 private $order = null
;
61 private $quick = false
;
63 public function __construct($quick = false
, $no_search = false
)
65 require_once dirname(__FILE__
).'/../modules/search/search.inc.php';
71 $this->quick
= $quick;
79 private function getQuick()
81 require_once dirname(__FILE__
).'/../modules/search/search.inc.php';
84 Env
::kill('with_soundex');
86 $qSearch = new QuickSearch('quick');
87 $fields = new SFieldGroup(true
, array($qSearch));
88 if ($qSearch->isEmpty()) {
89 new ThrowError('Recherche trop générale.');
91 parent
::__construct($fields->get_select_statement() . ' ' . $globals->search
->result_where_statement
,
92 $fields->get_where_statement() .
93 (S
::logged() && Env
::has('nonins') ?
' AND u.perms="pending" AND u.deces=0' : ''));
95 $this->order
= implode(',',array_filter(array($fields->get_order_statement(),
96 'u.promo DESC, NomSortKey, prenom')));
99 private function getAdvanced()
102 $fields = new SFieldGroup(true
, advancedSearchFromInput());
103 if ($fields->too_large()) {
104 new ThrowError('Recherche trop générale.');
106 parent
::__construct($fields->get_select_statement() . ' ' . $globals->search
->result_where_statement
,
107 $fields->get_where_statement());
108 $this->order
= implode(',',array_filter(array($fields->get_order_statement(),
109 'promo DESC, NomSortKey, prenom')));
113 class MinificheView
extends MultipageView
115 public function __construct(PlSet
&$set, $data, array $params)
117 require_once 'applis.func.inc.php';
119 $this->entriesPerPage
= $globals->search
->per_page
;
120 $this->order
= explode(',', Env
::v('order', 'nom,prenom,promo'));
121 parent
::__construct($set, $data, $params);
124 public function fields()
126 return "u.user_id AS id,
127 u.*, a.alias AS forlife,
128 u.perms != 'pending' AS inscrit,
129 u.perms != 'pending' AS wasinscrit,
130 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
131 FIND_IN_SET('femme', u.flags) AS sexe,
132 e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
133 IF(n.nat='',n.pays,n.nat) AS nat, n.a2 AS iso3166,
134 ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
135 ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
136 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
137 IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,
138 COUNT(em.email) > 0 AS actif" . (S
::logged() ?
", c.contact AS contact" : '');
141 public function joins()
143 return ($this->set
instanceof SearchSet ?
"" :
144 "LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id)
145 LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
146 LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
147 LEFT JOIN geoloc_pays AS n ON (u.nationalite = n.a2)
148 LEFT JOIN applis_ins AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
149 LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
150 LEFT JOIN applis_ins AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
151 LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
152 LEFT JOIN adresses AS adr ON (u.user_id = adr.uid
153 AND FIND_IN_SET('active', adr.statut))
154 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
155 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
156 LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = 'active')
158 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S
::v('uid') . ")"
162 public function templateName()
164 return 'include/plview.minifiche.tpl';
168 class TrombiView
extends MultipageView
170 public function __construct(PlSet
&$set, $data, array $params)
172 $this->entriesPerPage
= 24;
173 $this->order
= explode(',', Env
::v('order', 'nom,prenom,promo'));
174 parent
::__construct($set, $data, $params);
177 public function fields()
179 return "u.user_id, IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom, u.prenom, u.promo, a.alias AS forlife ";
182 public function joins()
184 return "INNER JOIN photo AS p ON (p.uid = u.user_id) ";
187 public function templateName()
189 return 'include/plview.trombi.tpl';
192 public function apply(PlatalPage
&$page)
194 if (!empty($GLOBALS['IS_XNET_SITE'])) {
196 $page->assign('mainsiteurl', 'https://' . $globals->core
->secure_domain
. '/');
198 return parent
::apply($page);
202 class GeolocView
implements PlView
208 public function __construct(PlSet
&$set, $data, array $params)
210 $this->params
= $params;
215 private function use_map()
217 return is_file(dirname(__FILE__
) . '/../modules/geoloc/dynamap.swf') &&
218 is_file(dirname(__FILE__
) . '/../modules/geoloc/icon.swf');
221 private function make_qs($urlencode = true
)
224 foreach ($_GET as $v=>$a) {
225 if ($v != 'initfile' && $v != 'n' && $v != 'mapid') {
227 $qs .= $v . '=' . $a . '&';
229 $qs .= urlencode($v) . '=' . urlencode($a) . '&';
236 public function apply(PlatalPage
&$page)
238 require_once 'geoloc.inc.php';
239 require_once '../modules/search/search.inc.php';
241 switch ($this->type
) {
243 header("Content-type: application/x-shockwave-flash");
245 readfile(dirname(__FILE__
).'/../modules/geoloc/icon.swf');
249 header("Content-type: application/x-shockwave-flash");
251 readfile(dirname(__FILE__
).'/../modules/geoloc/dynamap.swf');
255 $page->changeTpl('geoloc/init.tpl', NO_SKIN
);
256 header('Content-Type: text/xml');
258 if (!empty($GLOBALS['IS_XNET_SITE'])) {
259 $page->assign('background', 0xF2E9D0);
261 $page->assign('querystring', $this->make_qs());
265 $page->changeTpl('geoloc/city.tpl', NO_SKIN
);
266 header('Content-Type: text/xml');
268 $it =& $this->set
->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
269 "INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id)
270 LEFT JOIN aliases AS al ON (u.user_id = al.id
271 AND FIND_IN_SET(al.flags, 'bestalias'))
272 INNER JOIN adresses AS av ON (" . getadr_join('av') . ")",
273 'adrf.cityid = ' . Env
::i('cityid'), null
, null
, 11);
274 $page->assign('users', $it);
278 if (Env
::has('debug')) {
279 $page->changeTpl('geoloc/country.tpl', SIMPLE
);
281 $page->changeTpl('geoloc/country.tpl', NO_SKIN
);
282 header('Content-Type: text/xml');
285 $querystring = $this->make_qs();
286 $page->assign('searchvars', $querystring);
287 $mapid = Env
::has('mapid') ? Env
::i('mapid', -2) : false
;
288 list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set
, 10);
289 $page->assign('countries', $countries);
290 $page->assign('cities', $cities);
295 if (!$this->use_map()) {
296 $page->assign('request_geodesix', true
);
298 if (!empty($GLOBALS['IS_XNET_SITE'])) {
299 $page->assign('no_annu', true
);
301 $page->assign('protocole', @$_SERVER['HTTPS'] ?
'https' : 'http');
302 $this->set
->get('u.user_id', null
, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null
);
303 $url = '?' . $this->make_qs(false
);
304 $page->assign('search_nourlencode', $url);
305 $page->assign('search', urlencode($url));
306 return 'include/plview.geoloc.tpl';
311 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: