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 class ProfileNom
implements ProfileSetting
24 private function matchWord($old, $new, $newLen) {
25 return ($i = strpos($old, $new)) !== false
26 && ($i == 0 ||
$old{$i-1} == ' ')
27 && ($i +
$newLen == strlen($old) ||
$old{$i +
$newLen} == ' ');
30 private function prepareField($value)
32 $value = strtoupper(replace_accent($value));
33 return preg_replace('/[^A-Z]/', ' ', $value);
36 public function value(ProfilePage
&$page, $field, $value, &$success)
39 $current = S
::v($field);
40 $init = S
::v($field . '_ini');
41 if (is_null($value)) {
44 if ($value == $current ||
$value == $init) {
47 $ini = $this->prepareField($init);
48 $old = $this->prepareField($current);
49 $new = $this->prepareField($value);
50 $newLen = strlen($new);
51 $success = $this->matchWord($old, $new, $newLen)
52 ||
$this->matchWord($ini, $new, $newLen)
53 ||
($field == 'nom' && $new == 'DE ' . $old);
55 Platal
::page()->trigError("Le $field que tu as choisi ($value) est trop loin de ton $field initial ($init)"
56 . (($init == $current)?
"" : " et de ton prénom précédent ($current)"));
58 return $success ?
$value : $current;
61 public function save(ProfilePage
&$page, $field, $new_value)
63 $_SESSION[$field] = $new_value;
67 class ProfileSearchName
implements ProfileSetting
70 public function __construct()
74 public function value(ProfilePage
&$page, $field, $value, &$success)
78 public function save(ProfilePage
&$page, $field, $new_value)
83 class ProfileEdu
implements ProfileSetting
85 public function __construct()
89 public function value(ProfilePage
&$page, $field, $value, &$success)
92 if (is_null($value) ||
!is_array($value)) {
94 $res = XDB
::iterator("SELECT eduid, degreeid, fieldid, grad_year
95 FROM profile_education
99 while($edu = $res->next()) {
104 foreach ($value as $key=>&$edu) {
105 if (($edu['grad_year'] < 1921) ||
($edu['grad_year'] > (date('Y') +
4))) {
106 Platal
::page()->trigError('L\'année d\'obtention du diplôme est mal renseignée, elle doit être du type : 2004.');
107 $edu['error'] = true
;
120 public function save(ProfilePage
&$page, $field, $value)
122 XDB
::execute("DELETE FROM profile_education
125 foreach ($value as $eduid=>&$edu) {
126 if ($edu['eduid'] != '') {
127 XDB
::execute("INSERT INTO profile_education
128 SET id = {?}, uid = {?}, eduid = {?}, degreeid = {?}, fieldid = {?}, grad_year = {?}",
129 $eduid, S
::i('uid'), $edu['eduid'], $edu['degreeid'], $edu['fieldid'], $edu['grad_year']);
136 class ProfileEmailDirectory
implements ProfileSetting
138 public function __construct()
142 public function value(ProfilePage
&$page, $field, $value, &$success)
147 if (!is_null($value)) {
148 $email_stripped = strtolower(trim($value));
149 if ((!isvalid_email($email_stripped)) && ($email_stripped) && ($page->values
['email_directory'] == "new@example.org")) {
150 $p->assign('email_error', '1');
151 $p->assign('email_directory_error', $email_stripped);
152 $p->trigError('Adresse Email invalide');
155 $p->assign('email_error', '0');
161 public function save(ProfilePage
&$page, $field, $value)
166 class ProfileNetworking
implements ProfileSetting
173 public function __construct()
175 $this->email
= new ProfileEmail();
176 $this->pub
= new ProfilePub();
177 $this->web
= new ProfileWeb();
178 $this->number
= new ProfileNumber();
181 public function value(ProfilePage
&$page, $field, $value, &$success)
183 if (is_null($value)) {
185 $res = XDB
::iterator("SELECT n.address, n.network_type AS type, n.pub, m.name
186 FROM profile_networking AS n
187 INNER JOIN profile_networking_enum AS m ON (n.network_type = m.network_type)
190 while($network = $res->next()) {
194 if (!is_array($value)) {
197 $res = XDB
::iterator("SELECT filter, network_type AS type
198 FROM profile_networking_enum;");
200 while($filter = $res->next()) {
201 $filters[$filter['type']] = $filter['filter'];
204 foreach($value as $i=>&$network) {
205 if (!trim($network['address'])) {
208 if (!isset($network['pub'])) {
209 $network['pub'] = 'private';
211 $network['error'] = false
;
212 $network['pub'] = $this->pub
->value($page, 'pub', $network['pub'], $s);
214 if ($filters[$network['type']] == 'web') {
215 $network['address'] = $this->web
->value($page, 'address', $network['address'], $s);
216 } elseif ($filters[$network['type']] == 'email') {
217 $network['address'] = $this->email
->value($page, 'address', $network['address'], $s);
218 } elseif ($filters[$network['type']] == 'number') {
219 $network['address'] = $this->number
->value($page, 'address', $network['address'], $s);
223 $network['error'] = true
;
230 public function save(ProfilePage
&$page, $field, $value)
232 XDB
::execute("DELETE FROM profile_networking
235 if (!count($value)) {
239 foreach ($value as $id=>$network) {
240 XDB
::execute("INSERT INTO profile_networking (uid, nwid, network_type, address, pub)
241 VALUES ({?}, {?}, {?}, {?}, {?})",
242 S
::i('uid'), $id, $network['type'], $network['address'], $network['pub']);
247 class ProfileGeneral
extends ProfilePage
249 protected $pg_template = 'profile/general.tpl';
251 public function __construct(PlWizard
&$wiz)
253 parent
::__construct($wiz);
254 $this->settings
['nom'] = $this->settings
['prenom']
256 $this->settings
['naissance'] = new ProfileDate();
257 $this->settings
['freetext_pub']
258 = $this->settings
['photo_pub']
260 $this->settings
['freetext']
261 = $this->settings
['nationalite']
262 = $this->settings
['nationalite2']
263 = $this->settings
['nationalite3']
264 = $this->settings
['nick']
265 = $this->settings
['yourself']
266 = $this->settings
['display_name']
267 = $this->settings
['sort_name']
268 = $this->settings
['tooltip_name']
270 $this->settings
['synchro_ax']
272 $this->settings
['email_directory']
273 = new ProfileEmail();
274 $this->settings
['email_directory_new']
275 = new ProfileEmailDirectory();
276 $this->settings
['networking'] = new ProfileNetworking();
277 $this->settings
['tels'] = new ProfilePhones('user', 0);
278 $this->settings
['edus'] = new ProfileEdu();
279 $this->watched
= array('nom' => true
, 'freetext' => true
, 'tels' => true
,
280 'networking' => true
, 'edus' => true
,
281 'nationalite' => true
, 'nationalite2' => true
,
282 'nationalite3' => true
, 'nick' => true
);
285 protected function _fetchData()
287 // Checkout all data...
288 $res = XDB
::query("SELECT u.promo, u.promo_sortie, u.nom_usage, u.nationalite,
289 u.nationalite2, u.nationalite3, u.naissance,
290 t.display_tel as mobile, t.pub as mobile_pub,
291 d.email_directory as email_directory,
292 q.profile_freetext as freetext, q.profile_freetext_pub as freetext_pub,
293 q.profile_nick as nick, q.profile_from_ax as synchro_ax, u.matricule_ax,
294 n.yourself, n.display AS display_name, n.sort AS sort_name,
295 n.tooltip AS tooltip_name
296 FROM auth_user_md5 AS u
297 INNER JOIN auth_user_quick AS q ON(u.user_id = q.user_id)
298 INNER JOIN profile_names_display AS n ON(n.user_id = u.user_id)
299 LEFT JOIN profile_phones AS t ON(u.user_id = t.uid AND link_type = 'user')
300 LEFT JOIN profile_directory AS d ON(d.uid = u.user_id)
301 WHERE u.user_id = {?}", S
::v('uid', -1));
302 $this->values
= $res->fetchOneAssoc();
304 // Retreive photo informations
305 $res = XDB
::query("SELECT pub
307 WHERE uid = {?}", S
::v('uid'));
308 $this->values
['photo_pub'] = $res->fetchOneCell();
310 $res = XDB
::query("SELECT COUNT(*)
312 WHERE type='photo' AND user_id = {?}",
314 $this->values
['nouvellephoto'] = $res->fetchOneCell();
316 // Retreive search names info
317 $this->values
['search_names'] = XDB
::iterator("
318 SELECT sn.search_name, sn.name_type, sn.pub, sn.sn_id
319 FROM profile_names_search AS sn
320 WHERE sn.user_id = {?}
321 ORDER BY sn.name_type, search_score, search_name",
325 $res = XDB
::iterator("SELECT t.display_tel AS tel, t.tel_type AS type, t.pub, t.comment
326 FROM profile_phones AS t
327 WHERE t.uid = {?} AND t.link_type = 'user'
330 $this->values
['tels'] = $res->fetchAllAssoc();
333 protected function _saveData()
335 if ($this->changed
['nationalite'] ||
$this->changed
['nationalite2'] ||
$this->changed
['nationalite3']
336 ||
$this->changed
['nom'] ||
$this->changed
['prenom'] ||
$this->changed
['naissance']) {
337 if ($this->values
['nationalite3'] == "") {
338 $this->values
['nationalite3'] = NULL
;
340 if ($this->values
['nationalite2'] == "") {
341 $this->values
['nationalite2'] = $this->values
['nationalite3'];
342 $this->values
['nationalite3'] = NULL
;
344 if ($this->values
['nationalite'] == "") {
345 $this->values
['nationalite'] = $this->values
['nationalite2'];
346 $this->values
['nationalite2'] = $this->values
['nationalite3'];
347 $this->values
['nationalite3'] = NULL
;
350 XDB
::execute("UPDATE auth_user_md5
351 SET nationalite = {?}, nationalite2 = {?}, nationalite3 = {?}, nom={?}, prenom={?}, naissance={?}
352 WHERE user_id = {?}",
353 $this->values
['nationalite'], $this->values
['nationalite2'], $this->values
['nationalite3'],
354 $this->values
['nom'], $this->values
['prenom'],
355 preg_replace('@(\d{2})/(\d{2})/(\d{4})@', '\3-\2-\1', $this->values
['naissance']),
358 if ($this->changed
['nick'] ||
$this->changed
['freetext'] ||
$this->changed
['freetext_pub'] ||
$this->changed
['synchro_ax']) {
359 XDB
::execute("UPDATE auth_user_quick
360 SET profile_nick= {?},
361 profile_freetext={?},
362 profile_freetext_pub={?}, profile_from_ax = {?}
363 WHERE user_id = {?}",
364 $this->values
['nick'],
365 $this->values
['freetext'], $this->values
['freetext_pub'],
366 $this->values
['synchro_ax'], S
::v('uid'));
368 if ($this->changed
['email_directory']) {
369 $new_email = ($this->values
['email_directory'] == "new@example.org") ?
370 $this->values
['email_directory_new'] : $this->values
['email_directory'];
371 if ($new_email == "") {
374 XDB
::execute("REPLACE INTO profile_directory (uid, email_directory)
376 S
::v('uid'), $new_email);
378 if ($this->changed
['nick']) {
379 require_once('user.func.inc.php');
380 user_reindex(S
::v('uid'));
382 if ($this->changed
['photo_pub']) {
383 XDB
::execute("UPDATE photo
386 $this->values
['photo_pub'], S
::v('uid'));
388 if ($this->changed
['yourself'] ||
$this->changed
['sort_name'] ||
389 $this-> changed
['display_name'] ||
$this->changed
['tooltip_name']) {
390 XDB
::execute("UPDATE profile_names_display AS n
391 SET n.yourself = {?},
392 n.sort = {?}, ". // SET
393 "n.display = {?}, ". // SET
394 "n.tooltip = {?} ". // SET
395 "WHERE n.user_id = {?}",
396 $this->values
['yourself'],
397 $this->values
['sort_name'],
398 $this->values
['display_name'],
399 $this->values
['tooltip_name'],
404 public function _prepare(PlPage
&$page, $id)
406 require_once "education.func.inc.php";
408 $res = XDB
::iterator("SELECT id, field
409 FROM profile_education_field_enum
411 $page->assign('edu_fields', $res->fetchAllAssoc());
413 require_once "emails.combobox.inc.php";
414 fill_email_combobox($page);
416 $res = XDB
::iterator("SELECT nw.network_type AS type, nw.name
417 FROM profile_networking_enum AS nw
419 $page->assign('network_list', $res->fetchAllAssoc());
423 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: