modules/profile/general.inc.php

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