bdfb90a2c90a6d1b8fc627f84ad0d868f08dd5f5
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 $score = null
;
61 private $order = null
;
62 private $quick = false
;
64 public function __construct($quick = false
, $no_search = false
)
66 require_once dirname(__FILE__
).'/../modules/search/search.inc.php';
72 $this->quick
= $quick;
80 private function getQuick()
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('Recherche trop générale.');
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' : ''));
98 $this->order
= implode(',',array_filter(array($fields->get_order_statement(),
99 'u.promo DESC, NomSortKey, prenom')));
102 private function getAdvanced()
105 $fields = new SFieldGroup(true
, advancedSearchFromInput());
106 if ($fields->too_large()) {
107 new ThrowError('Recherche trop générale.');
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')));
115 public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null
, $limitfrom = null
)
118 $fields .= ', ' . $this->score
;
120 return parent
::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
124 class MinificheView
extends MultipageView
126 public function __construct(PlSet
&$set, $data, array $params)
128 require_once 'applis.func.inc.php';
130 $this->entriesPerPage
= $globals->search
->per_page
;
131 if (@$params['with_score']) {
132 $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
134 $this->addSortKey('name', array('nom', 'prenom'), 'nom');
135 $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
136 $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
137 parent
::__construct($set, $data, $params);
140 public function fields()
142 return "u.user_id AS id,
143 u.*, a.alias AS forlife,
144 u.perms != 'pending' AS inscrit,
145 u.perms != 'pending' AS wasinscrit,
146 u.deces != 0 AS dcd, u.deces, u.matricule_ax,
147 FIND_IN_SET('femme', u.flags) AS sexe,
148 e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
149 IF(n.nat='',n.pays,n.nat) AS nat, n.a2 AS iso3166,
150 ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
151 ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
152 adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
153 IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,
154 COUNT(em.email) > 0 AS actif" . (S
::logged() ?
", c.contact AS contact" : '');
157 public function joins()
159 return ($this->set
instanceof SearchSet ?
"" :
160 "LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id)
161 LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
162 LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
163 LEFT JOIN geoloc_pays AS n ON (u.nationalite = n.a2)
164 LEFT JOIN applis_ins AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
165 LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
166 LEFT JOIN applis_ins AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
167 LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
168 LEFT JOIN adresses AS adr ON (u.user_id = adr.uid
169 AND FIND_IN_SET('active', adr.statut))
170 LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
171 LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
172 LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = 'active')
174 "LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S
::v('uid') . ")"
178 public function templateName()
180 return 'include/plview.minifiche.tpl';
184 class TrombiView
extends MultipageView
186 public function __construct(PlSet
&$set, $data, array $params)
188 $this->entriesPerPage
= 24;
189 $this->order
= explode(',', Env
::v('order', 'nom,prenom,promo'));
190 if (@$params['with_score']) {
191 $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
193 $this->addSortKey('name', array('nom', 'prenom'), 'nom');
194 $this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
195 $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
196 parent
::__construct($set, $data, $params);
199 public function fields()
201 return "u.user_id, IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom, u.prenom, u.promo, a.alias AS forlife ";
204 public function joins()
206 return "INNER JOIN photo AS p ON (p.uid = u.user_id) ";
209 public function templateName()
211 return 'include/plview.trombi.tpl';
214 public function apply(PlatalPage
&$page)
216 if (!empty($GLOBALS['IS_XNET_SITE'])) {
218 $page->assign('mainsiteurl', 'https://' . $globals->core
->secure_domain
. '/');
220 return parent
::apply($page);
224 class GeolocView
implements PlView
230 public function __construct(PlSet
&$set, $data, array $params)
232 $this->params
= $params;
237 private function use_map()
239 return is_file(dirname(__FILE__
) . '/../modules/geoloc/dynamap.swf') &&
240 is_file(dirname(__FILE__
) . '/../modules/geoloc/icon.swf');
243 public function args()
245 $args = $this->set
->args();
246 unset($args['initfile']);
247 unset($args['mapid']);
251 public function apply(PlatalPage
&$page)
253 require_once 'geoloc.inc.php';
254 require_once '../modules/search/search.inc.php';
256 switch ($this->type
) {
258 header("Content-type: application/x-shockwave-flash");
260 readfile(dirname(__FILE__
).'/../modules/geoloc/icon.swf');
264 header("Content-type: application/x-shockwave-flash");
266 readfile(dirname(__FILE__
).'/../modules/geoloc/dynamap.swf');
270 $page->changeTpl('geoloc/init.tpl', NO_SKIN
);
271 header('Content-Type: text/xml');
273 if (!empty($GLOBALS['IS_XNET_SITE'])) {
274 $page->assign('background', 0xF2E9D0);
279 $page->changeTpl('geoloc/city.tpl', NO_SKIN
);
280 header('Content-Type: text/xml');
282 $it =& $this->set
->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
283 "INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id)
284 LEFT JOIN aliases AS al ON (u.user_id = al.id
285 AND FIND_IN_SET(al.flags, 'bestalias'))
286 INNER JOIN adresses AS av ON (" . getadr_join('av') . ")",
287 'adrf.cityid = ' . Env
::i('cityid'), null
, null
, 11);
288 $page->assign('users', $it);
292 if (Env
::has('debug')) {
293 $page->changeTpl('geoloc/country.tpl', SIMPLE
);
295 $page->changeTpl('geoloc/country.tpl', NO_SKIN
);
296 header('Content-Type: text/xml');
299 $mapid = Env
::has('mapid') ? Env
::i('mapid', -2) : false
;
300 list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set
, 10);
301 $page->assign('countries', $countries);
302 $page->assign('cities', $cities);
307 if (!$this->use_map()) {
308 $page->assign('request_geodesix', true
);
310 if (!empty($GLOBALS['IS_XNET_SITE'])) {
311 $page->assign('no_annu', true
);
313 $page->assign('protocole', @$_SERVER['HTTPS'] ?
'https' : 'http');
314 $this->set
->get('u.user_id', null
, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null
);
315 return 'include/plview.geoloc.tpl';
320 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: