2ecfc8730318da2a9b79def4674aa0f086848115
[platal.git] / modules / profile.php
1 <?php
2 /***************************************************************************
3 * Copyright (C) 2003-2006 Polytechnique.org *
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
22 class ProfileModule extends PLModule
23 {
24 function handlers()
25 {
26 return array(
27 'photo' => $this->make_hook('photo', AUTH_PUBLIC),
28 'photo/change' => $this->make_hook('photo_change', AUTH_MDP),
29
30 'profile/orange' => $this->make_hook('p_orange', AUTH_MDP),
31 'profile/referent' => $this->make_hook('p_referent', AUTH_MDP),
32 'profile/usage' => $this->make_hook('p_usage', AUTH_MDP),
33
34 'trombi' => $this->make_hook('trombi', AUTH_COOKIE),
35
36 'vcard' => $this->make_hook('vcard', AUTH_COOKIE),
37 );
38 }
39
40 function _trombi_getlist($offset, $limit)
41 {
42 global $globals;
43
44 $where = ( $this->promo > 0 ? "WHERE promo='{$this->promo}'" : "" );
45
46 $res = $globals->xdb->query(
47 "SELECT COUNT(*)
48 FROM auth_user_md5 AS u
49 RIGHT JOIN photo AS p ON u.user_id=p.uid
50 $where");
51 $pnb = $res->fetchOneCell();
52
53 $res = $globals->xdb->query(
54 "SELECT promo,user_id,a.alias AS forlife,IF(nom_usage='', nom, nom_usage) AS nom,prenom
55 FROM photo AS p
56 INNER JOIN auth_user_md5 AS u ON u.user_id=p.uid
57 INNER JOIN aliases AS a ON ( u.user_id=a.id AND a.type='a_vie' )
58 $where
59 ORDER BY promo,nom,prenom LIMIT {?}, {?}", $offset*$limit, $limit);
60
61 return array($pnb, $res->fetchAllAssoc());
62 }
63
64 function handler_photo(&$page, $x = null, $req = null)
65 {
66 if (is_null($x)) {
67 return PL_NOT_FOUND;
68 }
69
70 global $globals;
71
72 $res = $globals->xdb->query("SELECT id, pub FROM aliases
73 LEFT JOIN photo ON(id = uid)
74 WHERE alias = {?}", $x);
75 list($uid, $photo_pub) = $res->fetchOneRow();
76
77 if ($req && logged()) {
78 include 'validations.inc.php';
79 $myphoto = PhotoReq::get_request($uid);
80 Header('Content-type: image/'.$myphoto->mimetype);
81 echo $myphoto->data;
82 } else {
83 $res = $globals->xdb->query(
84 "SELECT attachmime, attach
85 FROM photo
86 WHERE uid={?}", $uid);
87
88 if ((list($type,$data) = $res->fetchOneRow()) && ($photo_pub == 'public' || logged())) {
89 Header("Content-type: image/$type");
90 echo $data;
91 } else {
92 Header('Content-type: image/png');
93 echo file_get_contents(dirname(__FILE__).'/../htdocs/images/none.png');
94 }
95 }
96 exit;
97 }
98
99 function handler_photo_change(&$page)
100 {
101 global $globals;
102
103 $page->changeTpl('trombino.tpl');
104
105 require_once('validations.inc.php');
106
107 $trombi_x = '/home/web/trombino/photos'.Session::get('promo')
108 .'/'.Session::get('forlife').'.jpg';
109
110 if (Env::has('upload')) {
111 $file = isset($_FILES['userfile']['tmp_name'])
112 ? $_FILES['userfile']['tmp_name']
113 : Env::get('photo');
114 if ($data = file_get_contents($file)) {
115 if ($myphoto = new PhotoReq(Session::getInt('uid'), $data)) {
116 $myphoto->submit();
117 }
118 } else {
119 $page->trig('Fichier inexistant ou vide');
120 }
121 } elseif (Env::has('trombi')) {
122 $myphoto = new PhotoReq(Session::getInt('uid'),
123 file_get_contents($trombi_x));
124 if ($myphoto) {
125 $myphoto->commit();
126 $myphoto->clean();
127 }
128 } elseif (Env::get('suppr')) {
129 $globals->xdb->execute('DELETE FROM photo WHERE uid = {?}',
130 Session::getInt('uid'));
131 $globals->xdb->execute('DELETE FROM requests
132 WHERE user_id = {?} AND type="photo"',
133 Session::getInt('uid'));
134 } elseif (Env::get('cancel')) {
135 $sql = $globals->xdb->query('DELETE FROM requests
136 WHERE user_id={?} AND type="photo"',
137 Session::getInt('uid'));
138 }
139
140 $sql = $globals->xdb->query('SELECT COUNT(*) FROM requests
141 WHERE user_id={?} AND type="photo"',
142 Session::getInt('uid'));
143 $page->assign('submited', $sql->fetchOneCell());
144 $page->assign('has_trombi_x', file_exists($trombi_x));
145
146 return PL_OK;
147 }
148
149 function handler_p_orange(&$page)
150 {
151 global $globals;
152
153 $page->changeTpl('orange.tpl');
154
155 require_once 'validations.inc.php';
156 require_once 'xorg.misc.inc.php';
157
158 $res = $globals->xdb->query(
159 "SELECT u.promo,u.promo_sortie
160 FROM auth_user_md5 AS u
161 WHERE user_id={?}", Session::getInt('uid'));
162
163 list($promo,$promo_sortie_old) = $res->fetchOneRow();
164 $page->assign('promo_sortie_old', $promo_sortie_old);
165 $page->assign('promo', $promo);
166
167 if (!Env::has('promo_sortie')) {
168 return PL_OK;
169 }
170
171 $promo_sortie = Env::getInt('promo_sortie');
172
173 if ($promo_sortie < 1000 || $promo_sortie > 9999) {
174 $page->trig('L\'année de sortie doit être un nombre de quatre chiffres');
175 }
176 elseif ($promo_sortie < $promo + 3) {
177 $page->trig('Trop tôt');
178 }
179 elseif ($promo_sortie == $promo_sortie_old) {
180 $page->trig('Tu appartiens déjà à la promotion correspondante à cette année de sortie.');
181 }
182 elseif ($promo_sortie == $promo + 3) {
183 $globals->xdb->execute(
184 "UPDATE auth_user_md5 set promo_sortie={?}
185 WHERE user_id={?}",$promo_sortie,Session::getInt('uid'));
186 $page->trig('Ton statut "orange" a été supprimé.');
187 $page->assign('promo_sortie_old', $promo_sortie);
188 }
189 else {
190 $page->assign('promo_sortie', $promo_sortie);
191
192 if (Env::has('submit')) {
193 $myorange = new OrangeReq(Session::getInt('uid'),
194 $promo_sortie);
195 $myorange->submit();
196 $page->assign('myorange', $myorange);
197 }
198 }
199
200 return PL_OK;
201 }
202
203 function handler_p_referent(&$page, $x = null)
204 {
205 global $globals;
206
207 require_once 'user.func.inc.php';
208
209 if (is_null($x)) {
210 return PL_NOT_FOUND;
211 }
212
213 $page->changeTpl('fiche_referent.tpl');
214 $page->assign('simple', true);
215
216 $res = $globals->xdb->query(
217 "SELECT prenom, nom, user_id, promo, cv, a.alias AS bestalias
218 FROM auth_user_md5 AS u
219 INNER JOIN aliases AS a ON (u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags))
220 INNER JOIN aliases AS a1 ON (u.user_id=a1.id
221 AND a1.alias = {?}
222 AND a1.type!='homonyme')", $x);
223
224 if ($res->numRows() != 1) {
225 return PL_NOT_FOUND;
226 }
227
228 list($prenom, $nom, $user_id, $promo, $cv, $bestalias) = $res->fetchOneRow();
229
230 $page->assign('prenom', $prenom);
231 $page->assign('nom', $nom);
232 $page->assign('promo', $promo);
233 $page->assign('cv', $cv);
234 $page->assign('bestalias', $bestalias);
235 $page->assign('adr_pro', get_user_details_pro($user_id));
236
237 ///// recuperations infos referent
238
239 //expertise
240 $res = $globals->xdb->query("SELECT expertise FROM mentor WHERE uid = {?}", $user_id);
241 $page->assign('expertise', $res->fetchOneCell());
242
243 //secteurs
244 $secteurs = $ss_secteurs = Array();
245 $res = $globals->xdb->iterRow(
246 "SELECT s.label, ss.label
247 FROM mentor_secteurs AS m
248 LEFT JOIN emploi_secteur AS s ON(m.secteur = s.id)
249 LEFT JOIN emploi_ss_secteur AS ss ON(m.secteur = ss.secteur AND m.ss_secteur = ss.id)
250 WHERE uid = {?}", $user_id);
251 while (list($sec, $ssec) = $res->next()) {
252 $secteurs[] = $sec;
253 $ss_secteurs[] = $ssec;
254 }
255 $page->assign_by_ref('secteurs', $secteurs);
256 $page->assign_by_ref('ss_secteurs', $ss_secteurs);
257
258 //pays
259 $res = $globals->xdb->query(
260 "SELECT gp.pays
261 FROM mentor_pays AS m
262 LEFT JOIN geoloc_pays AS gp ON(m.pid = gp.a2)
263 WHERE uid = {?}", $user_id);
264 $page->assign('pays', $res->fetchColumn());
265
266 $page->addJsLink('javascript/close_on_esc.js');
267 return PL_OK;
268 }
269
270 function handler_p_usage(&$page)
271 {
272 global $globals;
273
274 $page->changeTpl('nomusage.tpl');
275
276 require_once 'validations.inc.php';
277 require_once 'xorg.misc.inc.php';
278
279 $res = $globals->xdb->query(
280 "SELECT u.nom,u.nom_usage,u.flags,e.alias
281 FROM auth_user_md5 AS u
282 LEFT JOIN aliases AS e ON(u.user_id = e.id AND FIND_IN_SET('usage',e.flags))
283 WHERE user_id={?}", Session::getInt('uid'));
284
285 list($nom,$usage_old,$flags,$alias_old) = $res->fetchOneRow();
286 $flags = new flagset($flags);
287 $page->assign('usage_old', $usage_old);
288 $page->assign('alias_old', $alias_old);
289
290 $nom_usage = replace_accent(trim(Env::get('nom_usage')));
291 $nom_usage = strtoupper($nom_usage);
292 $page->assign('usage_req', $nom_usage);
293
294 if (Env::has('submit') && ($nom_usage != $usage_old)) {
295 // on vient de recevoir une requete, differente de l'ancien nom d'usage
296 if ($nom_usage == $nom) {
297 $page->assign('same', true);
298 } else { // le nom de mariage est distinct du nom à l'X
299 // on calcule l'alias pour l'afficher
300 $reason = Env::get('reason');
301 if ($reason == 'other') {
302 $reason = Env::get('other_reason');
303 }
304 $myusage = new UsageReq(Session::getInt('uid'), $nom_usage, $reason);
305 $myusage->submit();
306 $page->assign('myusage', $myusage);
307 }
308 }
309
310 return PL_OK;
311 }
312
313 function handler_trombi(&$page, $promo = null)
314 {
315 require_once 'trombi.inc.php';
316
317 $page->changeTpl('trombipromo.tpl');
318 $page->assign('xorg_title','Polytechnique.org - Trombi Promo');
319
320 if (is_null($promo)) {
321 return PL_OK;
322 }
323
324 $this->promo = $promo = intval($promo);
325
326 if ($promo >= 1900 && $promo < intval(date('Y'))
327 || ($promo == -1 && has_perms()))
328 {
329 $trombi = new Trombi(array($this, '_trombi_getlist'));
330 $trombi->hidePromo();
331 $trombi->setAdmin();
332 $page->assign_by_ref('trombi', $trombi);
333 } else {
334 $page->trig('Promotion incorrecte (saisir au format YYYY). Recommence.');
335 }
336
337 return PL_OK;
338 }
339
340 function format_adr($params, &$smarty)
341 {
342 // $adr1, $adr2, $adr3, $postcode, $city, $region, $country
343 extract($params['adr']);
344 $adr = $adr1;
345 $adr = trim("$adr\n$adr2");
346 $adr = trim("$adr\n$adr3");
347 return quoted_printable_encode(";;$adr;$city;$region;$postcode;$country");
348 }
349
350 function handler_vcard(&$page, $x = null)
351 {
352 if (is_null($x)) {
353 return PL_NOT_FOUND;
354 }
355
356 global $globals;
357
358 if (substr($x, -4) == '.vcf') {
359 $x = substr($x, 0, strlen($x) - 4);
360 }
361
362 new_nonhtml_page('vcard.tpl', AUTH_COOKIE);
363 require_once 'xorg.misc.inc.php';
364 require_once 'user.func.inc.php';
365
366 $page->register_modifier('qp_enc', 'quoted_printable_encode');
367 $page->register_function('format_adr', array($this, 'format_adr'));
368
369 $login = get_user_forlife($x);
370 $user = get_user_details($login);
371
372 // alias virtual
373 $res = $globals->xdb->query(
374 "SELECT alias
375 FROM virtual
376 INNER JOIN virtual_redirect USING(vid)
377 INNER JOIN auth_user_quick ON ( user_id = {?} AND emails_alias_pub = 'public' )
378 WHERE ( redirect={?} OR redirect={?} )
379 AND alias LIKE '%@{$globals->mail->alias_dom}'",
380 Session::getInt('uid'),
381 $user['forlife'].'@'.$globals->mail->domain,
382 $user['forlife'].'@'.$globals->mail->domain2);
383
384 $user['virtualalias'] = $res->fetchOneCell();
385
386 $page->assign_by_ref('vcard', $user);
387
388 header("Pragma: ");
389 header("Cache-Control: ");
390 header("Content-type: text/x-vcard\n");
391 header("Content-Transfer-Encoding: Quoted-Printable\n");
392
393 return PL_OK;
394 }
395 }
396
397 ?>