projects / platal.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
If there is no photo, default publicity is 'private'.
[platal.git] / modules / profile / general.inc.php
CommitLineData
fd38b30e
FB		 1<?php
2/***************************************************************************
9f5bd98e 3 * Copyright (C) 2003-2010 Polytechnique.org *
fd38b30e
FB		 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
12bcf04b 22class ProfileSettingSearchNames implements ProfileSetting
fd38b30e 23{
dced83b4
SJ		 24 private $private_name_end;
25 private $search_names;
b270577e
SJ		 26 private $name_types;
27
28 public function __construct() {
29 $this->name_types = DirEnum::getOptions(DirEnum::NAMES);
30 }
c4b45374 31
e5bcd851
FB		 32 private function matchWord($old, $new, $newLen)
33 {
93553cea 34 return ($i = strpos($old, $new)) !== false
fd38b30e
FB		 35 && ($i == 0 || $old{$i-1} == ' ')
36 && ($i + $newLen == strlen($old) || $old{$i + $newLen} == ' ');
37 }
38
39 private function prepareField($value)
40 {
ac40839f 41 return name_to_basename($value);
fd38b30e
FB		 42 }
43
c4b45374 44 private function prepare(ProfilePage &$page, $field, $value, $init, &$success)
fd38b30e
FB		 45 {
46 $success = true;
dced83b4
SJ		 47 $ini = $this->prepareField($init);
48 $new = $this->prepareField($value);
c4b45374
SJ		 49 $newLen = strlen($new);
50 $success = $this->matchWord($ini, $new, $newLen)
6cb58d39 51 || ($field == 'lastname' && $new == 'DE ' . $ini);
fd38b30e 52 if (!$success) {
c4b45374 53 $field = strtolower($field);
b270577e
SJ		 54 Platal::page()->trigError("Le " . $this->name_types[$field] . " que tu as choisi (" . $value .
55 ") est trop loin de ton " . $this->name_types[$field] . " initial (" . $init . ").");
fd38b30e 56 }
c4b45374 57 return $success ? $value : $init;
fd38b30e
FB		 58 }
59
b270577e
SJ		 60 /* Removes duplicated entries for the fields that do not allow them. */
61 private function clean($value)
62 {
63 $single_types = XDB::fetchAllAssoc('id',
64 'SELECT id, 0
65 FROM profile_name_enum
66 WHERE NOT FIND_IN_SET(\'allow_duplicates\', flags)');
67
68 foreach ($value as $key => $item) {
69 if (isset($single_types[$item['typeid']])) {
70 if ($single_types[$item['typeid']] === true) {
71 unset($value[$key]);
72 } else {
73 $single_types[$item['typeid']] = true;
74 }
75 }
76 }
77
78 return $value;
79 }
80
c4b45374 81 public function value(ProfilePage &$page, $field, $value, &$success)
fd38b30e 82 {
dced83b4 83 $success = true;
c4b45374 84 $success_tmp = true;
09f9ebea 85
c4b45374
SJ		 86 if (is_null($value)) {
87 $sn_all = XDB::iterator("SELECT CONCAT(sn.particle, sn.name) AS name,
6cb58d39 88 sn.particle, sn.typeid, e.type, e.name AS type_name,
c4b45374
SJ		 89 FIND_IN_SET('has_particle', e.flags) AS has_particle,
90 FIND_IN_SET('always_displayed', e.flags) AS always_displayed,
91 FIND_IN_SET('public', e.flags) AS pub
97a98687
SJ		 92 FROM profile_name AS sn
93 INNER JOIN profile_name_enum AS e ON (e.id = sn.typeid)
c4b45374
SJ		 94 WHERE sn.pid = {?} AND NOT FIND_IN_SET('not_displayed', e.flags)
95 ORDER BY NOT FIND_IN_SET('always_displayed', e.flags), e.id, sn.name",
111b2736 96 $page->pid());
c4b45374 97
6cb58d39
SJ		 98 $sn_types = XDB::iterator("SELECT id, type, name,
99 FIND_IN_SET('has_particle', flags) AS has_particle
97a98687 100 FROM profile_name_enum
c4b45374
SJ		 101 WHERE NOT FIND_IN_SET('not_displayed', flags)
102 AND FIND_IN_SET('always_displayed', flags)
103 ORDER BY id");
104
105 $value = array();
106 $sn = $sn_all->next();
107 while ($sn_type = $sn_types->next()) {
108 if ($sn_type['id'] == $sn['typeid']) {
109 $value[] = $sn;
111b2736
FB		 110 if ($sn) {
111 $sn = $sn_all->next();
112 }
c4b45374 113 } else {
09f9ebea
SJ		 114 $value[] = array('name' => '',
115 'particle' => '',
116 'typeid' => $sn_type['id'],
117 'type' => $sn_type['type'],
118 'type_name' => $sn_type['name'],
c4b45374 119 'has_particle' => $sn_type['has_particle'],
09f9ebea
SJ		 120 'always_displayed' => 1,
121 'pub' => 1);
c4b45374
SJ		 122 }
123 }
6cb58d39
SJ		 124 if ($sn) {
125 do {
126 $value[] = $sn;
127 } while ($sn = $sn_all->next());
111b2736 128 }
bd3e755e
SJ		 129 $namesRequest = ProfileValidate::get_typed_requests($page->pid(), 'usage');
130 if (count($namesRequest) > 0) {
131 Platal::page()->assign('validation', true);
132 }
b270577e 133 $value = $this->clean($value);
c4b45374 134 } else {
6cb58d39
SJ		 135 require_once 'name.func.inc.php';
136
b270577e 137 $value = $this->clean($value);
c4b45374 138 $res = XDB::query("SELECT s.particle, s.name
97a98687
SJ		 139 FROM profile_name AS s
140 INNER JOIN profile_name_enum AS e ON (e.id = s.typeid)
2fa91df0
SJ		 141 WHERE s.pid = {?} AND (e.type = 'lastname' OR e.type = 'firstname')
142 ORDER BY e.type = 'firstname'",
111b2736 143 $page->pid());
c4b45374
SJ		 144 $res = $res->fetchAllAssoc();
145 $initial = array();
6cb58d39
SJ		 146 $initial['lastname'] = $res[0]['particle'] . $res[0]['name'];
147 $initial['firstname'] = $res[1]['name'];
148 $sn_types = build_types();
dced83b4
SJ		 149 $this->search_names = array();
150 foreach ($value as &$sn) {
c4b45374 151 $sn['name'] = trim($sn['name']);
6cb58d39 152 if ($sn['type'] == 'firstname' || $sn['type'] == 'lastname') {
c4b45374
SJ		 153 $sn['name'] = $this->prepare($page, $sn['type'], $sn['name'],
154 $initial[$sn['type']], $success_tmp);
155 $success = $success && $success_tmp;
156 }
dced83b4
SJ		 157 if ($sn['pub']) {
158 if (isset($sn['particle']) && ($sn['particle'] != '')) {
faf5f834 159 // particle is before first blank
dced83b4
SJ		 160 list($particle, $name) = explode(' ', $sn['name'], 2);
161 $particle = trim($particle) . ' ';
162 if (!$name) {
faf5f834 163 // particle is before first quote
dced83b4
SJ		 164 list($particle, $name) = explode('\'', $sn['name'], 2);
165 $particle = trim($particle);
faf5f834
PC		 166 if (!$name) {
167 // actually there is no particle
168 $particle = '';
169 $name = $sn['name'];
170 }
dced83b4
SJ		 171 }
172 } else {
173 $particle = '';
174 $name = $sn['name'];
175 }
176 }
c4b45374 177 if ($sn['name'] != '') {
dced83b4
SJ		 178 if ($sn['pub']) {
179 $this->search_names[$sn['typeid']] = array('fullname' => $sn['name'],
180 'name' => $name,
181 'particle' => $particle,
182 'pub' => $sn['pub']);
c4b45374 183 } else {
dced83b4
SJ		 184 if (isset($this->search_names[$sn['typeid']])) {
185 $this->search_names[$sn['typeid']][] = $sn['name'];
186 } else {
187 $this->search_names[$sn['typeid']] = array('fullname' => $sn['name']);
188 }
6cb58d39 189 $sn['type_name'] = $sn_types[$sn['typeid']];
c4b45374
SJ		 190 }
191 }
192 }
dced83b4
SJ		 193 $res = XDB::query("SELECT public_name, private_name
194 FROM profile_display
195 WHERE pid = {?}",
f41cf525 196 $page->pid());
dced83b4
SJ		 197 list($public_name, $private_name) = $res->fetchOneRow();
198 if ($success) {
dced83b4
SJ		 199 $sn_types_private = build_types('private');
200 $this->private_name_end = build_private_name($this->search_names, $sn_types_private);
201 $private_name = $public_name . $this->private_name_end;
202 }
203 Platal::page()->assign('public_name', $public_name);
204 Platal::page()->assign('private_name', $private_name);
fd38b30e 205 }
09f9ebea 206
c4b45374 207 return $value;
fd38b30e
FB		 208 }
209
c4b45374 210 public function save(ProfilePage &$page, $field, $value)
fd38b30e 211 {
dced83b4 212 require_once 'name.func.inc.php';
024ec1e5 213
e8a7cf31 214 $sn_old = build_sn_pub($page->pid());
c4b45374 215 XDB::execute("DELETE FROM s
97a98687
SJ		 216 USING profile_name AS s
217 INNER JOIN profile_name_enum AS e ON (s.typeid = e.id)
c4b45374 218 WHERE s.pid = {?} AND NOT FIND_IN_SET('not_displayed', e.flags)",
111b2736 219 $page->pid());
e8a7cf31 220 $has_new = set_alias_names($this->search_names, $sn_old, $page->pid(), $page->owner->id());
dced83b4
SJ		 221
222 // Only requires validation if modification in public names
223 if ($has_new) {
0b981fbe 224 $new_names = new NamesReq(S::user(), $page->profile, $this->search_names, $this->private_name_end);
dced83b4 225 $new_names->submit();
b270577e
SJ		 226 Platal::page()->trigWarning('La demande de modification de tes noms a bien été prise en compte.' .
227 ' Tu recevras un email dès que ces changements auront été effectués.');
dced83b4
SJ		 228 } else {
229 $display_names = array();
e8a7cf31
SJ		 230 build_display_names($display_names, $this->search_names,
231 $page->profile->isFemale(), $this->private_name_end);
f4b04704 232 set_profile_display($display_names, $page->profile);
c4b45374 233 }
fd38b30e 234 }
a0fce0c6
SJ		 235
236 public function getText($value) {
237 $names = array();
238 foreach ($value as $name) {
239 if ($name['name'] != '') {
240 $names[] = $name['type_name'] . ' : ' . $name['name'];
241 }
242 }
243 return implode(', ' , $names);
244 }
fd38b30e
FB		 245}
246
12bcf04b 247class ProfileSettingEdu implements ProfileSetting
576777d7 248{
e5bcd851
FB		 249 public function __construct() {
250 }
043bbacf 251
5ba8842e 252 static function sortByGradYear($line1, $line2) {
be6806fa
SJ		 253 $a = (isset($line1['grad_year'])) ? (int) $line1['grad_year'] : 0;
254 $b = (isset($line2['grad_year'])) ? (int) $line2['grad_year'] : 0;
22f0a0a8 255 if ($a == $b) {
5ba8842e
SJ		 256 return 0;
257 }
22f0a0a8 258 return ($a < $b) ? -1 : 1;
5ba8842e
SJ		 259 }
260
576777d7
FB		 261 public function value(ProfilePage &$page, $field, $value, &$success)
262 {
263 $success = true;
885fa398 264 if (is_null($value)) {
043bbacf 265 $value = array();
111b2736
FB		 266 $value = XDB::fetchAllAssoc("SELECT eduid, degreeid, fieldid, grad_year, program
267 FROM profile_education
ce0b2c6f 268 WHERE pid = {?} AND !FIND_IN_SET('primary', flags)
111b2736
FB		 269 ORDER BY id",
270 $page->pid());
885fa398
SJ		 271 } else if (!is_array($value)) {
272 $value = null;
043bbacf
SJ		 273 } else {
274 $i = 0;
275 foreach ($value as $key=>&$edu) {
3ede4850
SJ		 276 if ($edu['eduid'] < 1 || !isset($edu['degreeid']) || $edu['degreeid'] < 1) {
277 Platal::page()->trigError('L\'université ou le diplôme d\'une formation manque.');
278 $success = false;
279 }
043bbacf 280 if (($edu['grad_year'] < 1921) || ($edu['grad_year'] > (date('Y') + 4))) {
be6806fa 281 Platal::page()->trigWarning('L\'année d\'obtention du diplôme est mal ou non renseignée, elle doit être du type : 2004.');
83065276 282 $edu['grad_year'] = null;
be6806fa 283 $edu['warning'] = true;
043bbacf
SJ		 284 }
285 if ($key != $i) {
286 $value[$i] = $edu;
287 unset($value[$key]);
288 }
289 $i++;
290 }
12bcf04b 291 usort($value, array("ProfileSettingEdu", "sortByGradYear"));
576777d7
FB		 292 }
293 return $value;
294 }
295
043bbacf 296 public function save(ProfilePage &$page, $field, $value)
576777d7 297 {
043bbacf 298 XDB::execute("DELETE FROM profile_education
ce0b2c6f 299 WHERE pid = {?} AND !FIND_IN_SET('primary', flags)",
e5bcd851 300 $page->pid());
043bbacf
SJ		 301 foreach ($value as $eduid=>&$edu) {
302 if ($edu['eduid'] != '') {
8768e5af 303 $fieldId = ($edu['fieldid'] == 0) ? null : $edu['fieldid'];
043bbacf 304 XDB::execute("INSERT INTO profile_education
ce0b2c6f 305 SET id = {?}, pid = {?}, eduid = {?}, degreeid = {?},
1504ac45 306 fieldid = {?}, grad_year = {?}, program = {?}",
e5bcd851 307 $eduid, $page->pid(), $edu['eduid'], $edu['degreeid'],
8768e5af 308 $fieldId, $edu['grad_year'], $edu['program']);
043bbacf 309 }
576777d7
FB		 310 }
311 }
a0fce0c6
SJ		 312
313 public function getText($value) {
314 $schoolsList = DirEnum::getOptions(DirEnum::EDUSCHOOLS);
315 $degreesList = DirEnum::getOptions(DirEnum::EDUDEGREES);
316 $fieldsList = DirEnum::getOptions(DirEnum::EDUFIELDS);
317 $educations = array();
318 foreach ($value as $education) {
319 $educations[] = 'Université : ' . $schoolsList[$education['eduid']]
320 . ', diplôme : ' . $degreesList[$education['degreeid']]
321 . ', domaine : ' . $fieldsList[$education['fieldid']]
322 . ', année d\'obtention : ' . $education['grad_year']
323 . ', intitulé : ' . $education['program'];
324 }
325 return implode(', ', $educations);
326 }
576777d7
FB		 327}
328
12bcf04b 329class ProfileSettingEmailDirectory implements ProfileSetting
b715c1e1 330{
b814a8b8
SJ		 331 public function __construct(){}
332 public function save(ProfilePage &$page, $field, $value){}
b715c1e1
SJ		 333
334 public function value(ProfilePage &$page, $field, $value, &$success)
335 {
ad3fee9d 336 $p = Platal::page();
b715c1e1
SJ		 337
338 $success = true;
339 if (!is_null($value)) {
340 $email_stripped = strtolower(trim($value));
ad3fee9d
SJ		 341 if ((!isvalid_email($email_stripped)) && ($email_stripped) && ($page->values['email_directory'] == "new@example.org")) {
342 $p->assign('email_error', '1');
343 $p->assign('email_directory_error', $email_stripped);
344 $p->trigError('Adresse Email invalide');
b715c1e1
SJ		 345 $success = false;
346 } else {
ad3fee9d 347 $p->assign('email_error', '0');
b715c1e1
SJ		 348 }
349 }
350 return $value;
351 }
a0fce0c6
SJ		 352
353 public function getText($value) {
354 return $value;
355 }
b715c1e1
SJ		 356}
357
12bcf04b 358class ProfileSettingNetworking implements ProfileSetting
d1a2252a
GB		 359{
360 private $email;
361 private $pub;
362 private $web;
92446a53 363 private $number;
d1a2252a
GB		 364
365 public function __construct()
366 {
12bcf04b
RB		 367 $this->email = new ProfileSettingEmail();
368 $this->pub = new ProfileSettingPub();
369 $this->web = new ProfileSettingWeb();
370 $this->number = new ProfileSettingNumber();
d1a2252a
GB		 371 }
372
373 public function value(ProfilePage &$page, $field, $value, &$success)
374 {
375 if (is_null($value)) {
1f5cd004 376 $value = XDB::fetchAllAssoc("SELECT n.address, n.pub, n.nwid AS type
111b2736 377 FROM profile_networking AS n
ce0b2c6f 378 WHERE n.pid = {?}",
111b2736 379 $page->pid());
d1a2252a
GB		 380 }
381 if (!is_array($value)) {
382 $value = array();
383 }
1f5cd004 384 $filters = XDB::fetchAllAssoc('type', 'SELECT filter, nwid AS type, name
111b2736 385 FROM profile_networking_enum;');
d1a2252a
GB		 386 $success = true;
387 foreach($value as $i=>&$network) {
92c3f9e5
GB		 388 if (!trim($network['address'])) {
389 unset($value[$i]);
390 } else {
391 if (!isset($network['pub'])) {
392 $network['pub'] = 'private';
393 }
394 $network['error'] = false;
395 $network['pub'] = $this->pub->value($page, 'pub', $network['pub'], $s);
396 $s = true;
1f5cd004
PC		 397 $network['name'] = $filters[$network['type']]['name'];
398 if ($filters[$network['type']]['filter'] == 'web') {
92c3f9e5 399 $network['address'] = $this->web->value($page, 'address', $network['address'], $s);
1f5cd004 400 } elseif ($filters[$network['type']]['filter'] == 'email') {
92c3f9e5 401 $network['address'] = $this->email->value($page, 'address', $network['address'], $s);
1f5cd004 402 } elseif ($filters[$network['type']]['filter'] == 'number') {
92c3f9e5
GB		 403 $network['address'] = $this->number->value($page, 'address', $network['address'], $s);
404 }
405 if (!$s) {
406 $success = false;
407 $network['error'] = true;
408 }
d1a2252a
GB		 409 }
410 }
411 return $value;
412 }
413
414 public function save(ProfilePage &$page, $field, $value)
415 {
416 XDB::execute("DELETE FROM profile_networking
ce0b2c6f 417 WHERE pid = {?}",
e5bcd851 418 $page->pid());
d1a2252a
GB		 419 if (!count($value)) {
420 return;
421 }
422 $insert = array();
423 foreach ($value as $id=>$network) {
1f5cd004 424 XDB::execute("INSERT INTO profile_networking (pid, id, nwid, address, pub)
d1a2252a 425 VALUES ({?}, {?}, {?}, {?}, {?})",
e5bcd851 426 $page->pid(), $id, $network['type'], $network['address'], $network['pub']);
d1a2252a
GB		 427 }
428 }
a0fce0c6
SJ		 429
430 public function getText($value) {
431 $networkings = array();
432 foreach ($value as $network) {
433 $networkings[] = 'nom : ' . $network['name'] . ', adresse : ' . $network['address']
434 . ', affichage : ' . $network['pub'];
435 }
436 return implode(' ; ' , $networkings);
437 }
d1a2252a
GB		 438}
439
7e233317
SJ		 440class ProfileSettingPromo implements ProfileSetting
441{
442 public function __construct(){}
443
444 public function save(ProfilePage &$page, $field, $value)
445 {
446 $gradYearNew = $value;
447 if ($page->profile->mainEducation() == 'X') {
448 $gradYearNew += $page->profile->mainEducationDuration();
449 }
86ced4d4
SJ		 450 if (($page->profile->mainEducation() != 'X'
451 && $value == $page->profile->entry_year + $page->profile->mainEducationDuration())
452 || ($page->profile->mainEducation() == 'X' && $value == $page->profile->entry_year)) {
7e233317
SJ		 453 XDB::execute('UPDATE profile_display
454 SET promo = {?}
455 WHERE pid = {?}',
456 $page->profile->mainEducation() . strval($value), $page->profile->id());
457 XDB::execute('UPDATE profile_education
458 SET grad_year = {?}
459 WHERE pid = {?} AND FIND_IN_SET(\'primary\', flags)',
460 $gradYearNew, $page->profile->id());
86ced4d4 461 Platal::page()->trigSuccess('Ton statut « orange » a été supprimé.');
7e233317 462 } else {
0b981fbe 463 $myorange = new OrangeReq(S::user(), $page->profile, $gradYearNew);
7e233317
SJ		 464 $myorange->submit();
465 Platal::page()->trigSuccess('Tu pourras changer l\'affichage de ta promotion dès que ta nouvelle promotion aura été validée.');
466 }
467 }
468
469 public function value(ProfilePage &$page, $field, $value, &$success)
470 {
471 $entryYear = $page->profile->entry_year;
472 $gradYear = $page->profile->grad_year;
86ced4d4
SJ		 473 $yearpromo = $page->profile->grad_year;
474 if ($page->profile->mainEducation() == 'X') {
475 $yearpromo -= $page->profile->mainEducationDuration();
476 }
7e233317 477 $success = true;
86ced4d4 478 if (is_null($value) || $value == $yearpromo) {
7e233317
SJ		 479 if ($gradYear != $entryYear + $page->profile->mainEducationDuration()) {
480 $promoChoice = array();
86ced4d4
SJ		 481 for ($i = $entryYear; $i <= $gradYear - $page->profile->mainEducationDuration(); ++$i) {
482 if ($page->profile->mainEducation() == 'X') {
483 $promoChoice[] = $page->profile->mainEducation() . strval($i);
484 } else {
485 $promoChoice[] = $page->profile->mainEducation() . strval($i + $page->profile->mainEducationDuration());
486 }
7e233317
SJ		 487 }
488 Platal::page()->assign('promo_choice', $promoChoice);
489 }
86ced4d4 490 return $yearpromo;
7e233317
SJ		 491 }
492
493 // If this profile belongs to an X, $promoNew needs to be changed to
494 // the graduation year.
495 $gradYearNew = $value;
496 if ($page->profile->mainEducation() == 'X') {
497 $gradYearNew += $page->profile->mainEducationDuration();
498 }
499
500 if ($value < 1000 || $value > 9999) {
501 Platal::page()->trigError('L\'année de sortie doit être un nombre de quatre chiffres.');
502 $success = false;
503 } elseif ($gradYearNew < $entryYear + $page->profile->mainEducationDuration()) {
504 Platal::page()->trigError('Trop tôt&nbsp;!');
505 $success = false;
506 }
507 return intval($value);
508 }
a0fce0c6
SJ		 509
510 public function getText($value) {
511 return $value;
512 }
7e233317
SJ		 513}
514
515
66c4bdaf 516class ProfilePageGeneral extends ProfilePage
fd38b30e
FB		 517{
518 protected $pg_template = 'profile/general.tpl';
519
520 public function __construct(PlWizard &$wiz)
521 {
522 parent::__construct($wiz);
c4b45374 523 $this->settings['search_names']
12bcf04b
RB		 524 = new ProfileSettingSearchNames();
525 $this->settings['birthdate'] = new ProfileSettingDate();
42ec0fe2 526 $this->settings['nationality1']
e5bcd851
FB		 527 = $this->settings['nationality2']
528 = $this->settings['nationality3']
7e233317 529 = $this->settings['promo_display']
93553cea 530 = null;
b715c1e1 531 $this->settings['email_directory']
12bcf04b 532 = new ProfileSettingEmail();
b715c1e1 533 $this->settings['email_directory_new']
12bcf04b
RB		 534 = new ProfileSettingEmailDirectory();
535 $this->settings['networking'] = new ProfileSettingNetworking();
0b6c8b36 536 $this->settings['tels'] = new ProfileSettingPhones();
12bcf04b 537 $this->settings['edus'] = new ProfileSettingEdu();
7e233317 538 $this->settings['promo'] = new ProfileSettingPromo();
42ec0fe2 539 $this->watched= array('tels' => true,
043bbacf 540 'networking' => true, 'edus' => true,
e5bcd851 541 'nationality1' => true, 'nationality2' => true,
4ca15c31 542 'nationality3' => true, 'search_names' => true);
42ec0fe2
FB		 543
544 /* Some fields editable under condition */
545 if (!S::user()->isMe($this->owner)) {
546 $this->settings['deathdate'] = new ProfileSettingDate(true);
547 }
548 if (S::user()->checkPerms('directory_private')
549 || S::user()->isMyProfile($this->owner)) {
550 $this->settings['yourself']
551 = $this->settings['freetext']
552 = null;
553 $this->settings['freetext_pub']
554 = $this->settings['photo_pub']
555 = new ProfileSettingPub();
556 $this->watched['freetext'] = true;
557 }
558
93553cea
FB		 559 }
560
7c2e0f0d 561 protected function _fetchData()
93553cea 562 {
576777d7 563 // Checkout all data...
7e233317 564 $res = XDB::query("SELECT p.nationality1, p.nationality2, p.nationality3, p.birthdate,
7e233317 565 p.email_directory as email_directory, pd.promo AS promo_display,
87db81e7
FB		 566 p.freetext, p.freetext_pub, p.ax_id AS matricule_ax, pd.yourself,
567 p.deathdate
7e233317
SJ		 568 FROM profiles AS p
569 INNER JOIN profile_display AS pd ON (pd.pid = p.pid)
7e233317 570 WHERE p.pid = {?}", $this->pid());
93553cea 571 $this->values = $res->fetchOneAssoc();
576777d7 572
576777d7
FB		 573 // Retreive photo informations
574 $res = XDB::query("SELECT pub
5c4ea53f
FB		 575 FROM profile_photos
576 WHERE pid = {?}", $this->pid());
bf9202ed
SJ		 577 if ($res->numRows() == 0) {
578 $this->values['photo_pub'] = 'private';
579 } else {
580 $this->values['photo_pub'] = $res->fetchOneCell();
581 }
576777d7 582
e5bcd851
FB		 583 if ($this->owner) {
584 $res = XDB::query("SELECT COUNT(*)
585 FROM requests
58bb2d9c 586 WHERE type = 'photo' AND pid = {?}",
e5bcd851
FB		 587 $this->owner->id());
588 $this->values['nouvellephoto'] = $res->fetchOneCell();
589 } else {
590 $this->values['nouvellephoto'] = 0;
591 }
93553cea
FB		 592 }
593
7c2e0f0d 594 protected function _saveData()
93553cea 595 {
e5bcd851 596 if ($this->changed['nationality1'] || $this->changed['nationality2'] || $this->changed['nationality3']
ce0b2c6f
FB		 597 || $this->changed['birthdate'] || $this->changed['freetext'] || $this->changed['freetext_pub']
598 || $this->changed['email_directory']) {
e5bcd851
FB		 599 if ($this->values['nationality3'] == "") {
600 $this->values['nationality3'] = NULL;
8450c2aa 601 }
e5bcd851
FB		 602 if ($this->values['nationality2'] == "") {
603 $this->values['nationality2'] = $this->values['nationality3'];
604 $this->values['nationality3'] = NULL;
8450c2aa 605 }
e5bcd851 606 if ($this->values['nationality1'] == "") {
48a4525c 607 $this->values['nationality1'] = $this->values['nationality2'];
e5bcd851
FB		 608 $this->values['nationality2'] = $this->values['nationality3'];
609 $this->values['nationality3'] = NULL;
8450c2aa 610 }
48a4525c
SJ		 611 if ($this->values['nationality1'] == $this->values['nationality2']
612 && $this->values['nationality2'] == $this->values['nationality3']) {
613 $this->values['nationality2'] = NULL;
614 $this->values['nationality3'] = NULL;
615 } else if ($this->values['nationality1'] == $this->values['nationality2']) {
616 $this->values['nationality2'] = $this->values['nationality3'];
617 $this->values['nationality3'] = NULL;
618 } else if ($this->values['nationality2'] == $this->values['nationality3']
619 || $this->values['nationality1'] == $this->values['nationality3']) {
620 $this->values['nationality3'] = NULL;
621 }
622
ce0b2c6f
FB		 623 $new_email = ($this->values['email_directory'] == "new@example.org") ?
624 $this->values['email_directory_new'] : $this->values['email_directory'];
625 if ($new_email == "") {
626 $new_email = NULL;
627 }
8450c2aa 628
e5bcd851
FB		 629 XDB::execute("UPDATE profiles
630 SET nationality1 = {?}, nationality2 = {?}, nationality3 = {?}, birthdate = {?},
ce0b2c6f 631 freetext = {?}, freetext_pub = {?}, email_directory = {?}
d1e61677 632 WHERE pid = {?}",
e5bcd851 633 $this->values['nationality1'], $this->values['nationality2'], $this->values['nationality3'],
87db81e7 634 ProfileSettingDate::toSQLDate($this->values['birthdate']),
ce0b2c6f 635 $this->values['freetext'], $this->values['freetext_pub'], $new_email, $this->pid());
b715c1e1 636 }
a7c28fff 637 if ($this->changed['photo_pub']) {
5c4ea53f 638 XDB::execute("UPDATE profile_photos
a7c28fff 639 SET pub = {?}
5c4ea53f 640 WHERE pid = {?}",
e5bcd851 641 $this->values['photo_pub'], $this->pid());
a7c28fff 642 }
9241c897 643 if (S::user()->isMe($this->owner) && $this->changed['yourself']) {
cb0af6e5
FB		 644 if ($this->owner) {
645 XDB::execute('UPDATE accounts
646 SET display_name = {?}
647 WHERE uid = {?}',
648 $this->values['yourself'], $this->owner->id());
649 }
650 XDB::execute('UPDATE profile_display
651 SET yourself = {?}
652 WHERE pid = {?}', $this->values['yourself'],
653 $this->pid());
fb2c09c9 654 }
7e233317 655 if ($this->changed['promo_display']) {
86ced4d4
SJ		 656 if ($this->values['promo_display']{0} == $this->profile->mainEducation()) {
657 if (($this->profile->mainEducation() == 'X'
658 && intval(substr($this->values['promo_display'], 1, 4)) >= $this->profile->entry_year)
659 || ($this->profile->mainEducation() != 'X'
660 && intval(substr($this->values['promo_display'], 1, 4)) >= $this->profile->entry_year + $this->profile->mainEducationDuration())) {
661 XDB::execute('UPDATE profile_display
662 SET promo = {?}
663 WHERE pid = {?}',
664 $this->values['promo_display'], $this->pid());
665 }
7e233317 666 }
b04882ff 667 }
f7190088 668 if (!S::user()->isMe($this->owner) && $this->changed['deathdate']) {
87db81e7
FB		 669 XDB::execute('UPDATE profiles
670 SET deathdate = {?}, deathdate_rec = NOW()
671 WHERE pid = {?} AND deathdate_rec IS NULL',
672 ProfileSettingDate::toSQLDate($this->values['deathdate']), $this->pid());
673 if (XDB::affectedRows() > 0) {
674 $this->profile->clear();
675 if ($this->owner) {
676 $this->owner->clear(true);
677 }
678 } else {
679 /* deathdate_rec was not NULL, this is just an update of the death date
680 */
681 XDB::execute('UPDATE profiles
682 SET deathdate = {?}
683 WHERE pid = {?}',
684 ProfileSettingDate::toSQLDate($this->values['deathdate']), $this->pid());
685 }
686 }
fd38b30e
FB		 687 }
688
04334c61 689 public function _prepare(PlPage &$page, $id)
fd38b30e 690 {
f711b03f 691 require_once "education.func.inc.php";
d1a2252a 692
111b2736
FB		 693 $res = XDB::query("SELECT id, field
694 FROM profile_education_field_enum
695 ORDER BY field");
043bbacf
SJ		 696 $page->assign('edu_fields', $res->fetchAllAssoc());
697
b715c1e1 698 require_once "emails.combobox.inc.php";
4e698dc9 699 fill_email_combobox($page, $this->owner);
b715c1e1 700
1f5cd004 701 $res = XDB::query("SELECT nw.nwid AS type, nw.name
111b2736
FB		 702 FROM profile_networking_enum AS nw
703 ORDER BY name");
d1a2252a 704 $page->assign('network_list', $res->fetchAllAssoc());
c4b45374
SJ		 705
706 $res = XDB::query("SELECT public_name, private_name
707 FROM profile_display
708 WHERE pid = {?}",
111b2736 709 $this->pid());
c4b45374
SJ		 710 $res = $res->fetchOneRow();
711 $page->assign('public_name', $res[0]);
712 $page->assign('private_name', $res[1]);
e8a7cf31 713 $page->assign('isFemale', $this->profile->isFemale() ? 1 : 0);
fd38b30e
FB		 714 }
715}
716
717// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
718?>
plat/al