modules/profile/general.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 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 ProfileNom implements ProfileSetting
  23 {
  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} == ' ');
  28     }
  29
  30     private function prepareField($value)
  31     {
  32         $value = strtoupper(replace_accent($value));
  33         return preg_replace('/[^A-Z]/', ' ', $value);
  34     }
  35
  36     public function value(ProfilePage &$page, $field, $value, &$success)
  37     {
  38         $success = true;
  39         $current = S::v($field);
  40         $init    = S::v($field . '_ini');
  41         if (is_null($value)) {
  42             return $current;
  43         }
  44         if ($value == $current || $value == $init) {
  45             return $value;
  46         }
  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);
  54         if (!$success) {
  55             global $page;
  56             $page->trigError("Le $field que tu as choisi ($value) est trop loin de ton $field initial ($init)"
  57                        . (($init == $current)? "" : " et de ton prénom précédent ($current)"));
  58         }
  59         return $success ? $value : $current;
  60     }
  61
  62     public function save(ProfilePage &$page, $field, $new_value)
  63     {
  64         $_SESSION[$field] = $new_value;
  65     }
  66 }
  67
  68 class ProfileSearchName implements ProfileSetting
  69 {
  70
  71     public function __construct()
  72     {
  73     }
  74
  75     public function value(ProfilePage &$page, $field, $value, &$success)
  76     {
  77     }
  78
  79     public function save(ProfilePage &$page, $field, $new_value)
  80     {
  81     }
  82 }
  83
  84 class ProfileAppli implements ProfileSetting
  85 {
  86     public function value(ProfilePage &$page, $field, $value, &$success)
  87     {
  88         $success = true;
  89         if (is_null($value)) {
  90             return $page->values[$field];
  91         }
  92         return $value;
  93     }
  94
  95     public function save(ProfilePage &$page, $field, $new_value)
  96     {
  97         $index = ($field == 'appli1' ? 0 : 1);
  98         if ($new_value['id'] > 0) {
  99             XDB::execute("REPLACE INTO  applis_ins
 100                                    SET  uid = {?}, aid = {?}, type = {?}, ordre = {?}",
 101                          S::i('uid'), $new_value['id'], $new_value['type'], $index);
 102         } else {
 103             XDB::execute("DELETE FROM  applis_ins
 104                                 WHERE  uid = {?} AND ordre = {?}",
 105                          S::i('uid'), $index);
 106         }
 107     }
 108 }
 109
 110 class ProfileNetworking implements ProfileSetting
 111 {
 112     private $email;
 113     private $pub;
 114     private $web;
 115     private $number;
 116
 117     public function __construct()
 118     {
 119         $this->email  = new ProfileEmail();
 120         $this->pub    = new ProfilePub();
 121         $this->web    = new ProfileWeb();
 122         $this->number = new ProfileNumber();
 123     }
 124
 125     public function value(ProfilePage &$page, $field, $value, &$success)
 126     {
 127         if (is_null($value)) {
 128             $value = array();
 129             $res = XDB::iterator("SELECT  n.address, n.network_type AS type, n.pub, m.name
 130                                     FROM  profile_networking AS n
 131                               INNER JOIN  profile_networking_enum AS m ON (n.network_type = m.network_type)
 132                                    WHERE  n.uid = {?}",
 133                                  S::i('uid'));
 134             while($network = $res->next()) {
 135                 $value[] = $network;
 136             }
 137         }
 138         if (!is_array($value)) {
 139             $value = array();
 140         }
 141         $res = XDB::iterator("SELECT filter, network_type AS type
 142                                 FROM profile_networking_enum;");
 143         $filters = array();
 144         while($filter = $res->next()) {
 145             $filters[$filter['type']] = $filter['filter'];
 146         }
 147         $success = true;
 148         foreach($value as $i=>&$network) {
 149             if(!isset($network['pub'])) {
 150                 $network['pub'] = 'private';
 151             }
 152             $network['error'] = false;
 153             $network['pub'] = $this->pub->value($page, 'pub', $network['pub'], $s);
 154             $s = true;
 155             if ($filters[$network['type']] == 'web') {
 156                 $network['address'] = $this->web->value($page, 'address', $network['address'], $s);
 157             } elseif ($filters[$network['type']] == 'email') {
 158                 $network['address'] = $this->email->value($page, 'address', $network['address'], $s);
 159             } elseif ($filters[$network['type']] == 'number') {
 160                 $network['address'] = $this->number->value($page, 'address', $network['address'], $s);
 161             }
 162             if (!$s) {
 163                 $success = false;
 164                 $network['error'] = true;
 165             }
 166         }
 167         return $value;
 168     }
 169
 170     public function save(ProfilePage &$page, $field, $value)
 171     {
 172         XDB::execute("DELETE FROM profile_networking
 173                             WHERE uid = {?}",
 174                      S::i('uid'));
 175         if (!count($value)) {
 176             return;
 177         }
 178         $insert = array();
 179         foreach ($value as $id=>$network) {
 180             XDB::execute("INSERT INTO  profile_networking (uid, nwid, network_type, address, pub)
 181                                VALUES  ({?}, {?}, {?}, {?}, {?})",
 182                          S::i('uid'), $id, $network['type'], $network['address'], $network['pub']);
 183         }
 184     }
 185 }
 186
 187 class ProfileGeneral extends ProfilePage
 188 {
 189     protected $pg_template = 'profile/general.tpl';
 190
 191     public function __construct(PlWizard &$wiz)
 192     {
 193         parent::__construct($wiz);
 194         $this->settings['nom'] = $this->settings['prenom']
 195                                = new ProfileNom();
 196         $this->settings['naissance'] = new ProfileDate();
 197         $this->settings['mobile_pub']
 198                                   = $this->settings['freetext_pub']
 199                                   = $this->settings['photo_pub']
 200                                   = new ProfilePub();
 201         $this->settings['freetext']
 202                                   = $this->settings['nationalite']
 203                                   = $this->settings['nick']
 204                                   = $this->settings['yourself']
 205                                   = $this->settings['display_name']
 206                                   = $this->settings['sort_name']
 207                                   = $this->settings['tooltip_name']
 208                                   = null;
 209         $this->settings['synchro_ax']
 210                                   = new ProfileBool();
 211         $this->settings['mobile'] = new ProfileTel();
 212         $this->settings['networking'] = new ProfileNetworking();
 213         $this->settings['appli1']
 214                                   = $this->settings['appli2']
 215                                   = new ProfileAppli();
 216         $this->watched= array('nom' => true, 'freetext' => true, 'mobile' => true, 'networking' => true,
 217                        'appli1' => true, 'appli2' => true, 'nationalite' => true, 'nick' => true);
 218     }
 219
 220     protected function _fetchData()
 221     {
 222         // Checkout all data...
 223         $res = XDB::query("SELECT  u.promo, u.promo_sortie, u.nom_usage, u.nationalite, u.naissance,
 224                                    q.profile_mobile as mobile, q.profile_mobile_pub as mobile_pub,
 225                                    q.profile_freetext as freetext, q.profile_freetext_pub as freetext_pub,
 226                                    q.profile_nick as nick, q.profile_from_ax as synchro_ax, u.matricule_ax,
 227                                    IF(a1.aid IS NULL, -1, a1.aid) as appli_id1, a1.type as appli_type1,
 228                                    IF(a2.aid IS NULL, -1, a2.aid) as appli_id2, a2.type as appli_type2,
 229                                    n.yourself, n.display AS display_name, n.sort AS sort_name,
 230                                    n.tooltip AS tooltip_name
 231                              FROM  auth_user_md5   AS u
 232                        INNER JOIN  auth_user_quick AS q  ON(u.user_id = q.user_id)
 233                        INNER JOIN  profile_names_display AS n ON(n.user_id = u.user_id)
 234                         LEFT JOIN  applis_ins      AS a1 ON(a1.uid = u.user_id and a1.ordre = 0)
 235                         LEFT JOIN  applis_ins      AS a2 ON(a2.uid = u.user_id and a2.ordre = 1)
 236                             WHERE  u.user_id = {?}", S::v('uid', -1));
 237         $this->values = $res->fetchOneAssoc();
 238
 239         // Reformat formation data
 240         $this->values['appli1'] = array('id'    => $this->values['appli_id1'],
 241                                         'type'  => $this->values['appli_type1']);
 242         unset($this->values['appli_id1']);
 243         unset($this->values['appli_type1']);
 244         $this->values['appli2'] = array('id'    => $this->values['appli_id2'],
 245                                         'type'  => $this->values['appli_type2']);
 246         unset($this->values['appli_id2']);
 247         unset($this->values['appli_type2']);
 248
 249         // Retreive photo informations
 250         $res = XDB::query("SELECT  pub
 251                              FROM  photo
 252                             WHERE  uid = {?}", S::v('uid'));
 253         $this->values['photo_pub'] = $res->fetchOneCell();
 254
 255         $res = XDB::query("SELECT  COUNT(*)
 256                              FROM  requests
 257                             WHERE  type='photo' AND user_id = {?}",
 258                           S::v('uid'));
 259         $this->values['nouvellephoto'] = $res->fetchOneCell();
 260
 261         // Retreive search names info
 262         $this->values['search_names'] = XDB::iterator("
 263                               SELECT sn.search_name, sn.name_type, sn.pub, sn.sn_id
 264                                 FROM profile_names_search AS sn
 265                                WHERE sn.user_id = {?}
 266                             ORDER BY sn.name_type, search_score, search_name",
 267                           S::v('uid'));
 268     }
 269
 270     protected function _saveData()
 271     {
 272         if ($this->changed['nationalite'] || $this->changed['nom'] || $this->changed['prenom']
 273             || $this->changed['naissance']) {
 274            XDB::execute("UPDATE  auth_user_md5
 275                             SET  nationalite = {?}, nom={?}, prenom={?}, naissance={?}
 276                           WHERE  user_id = {?}",
 277                          $this->values['nationalite'], $this->values['nom'], $this->values['prenom'],
 278                          preg_replace('@(\d{2})/(\d{2})/(\d{4})@', '\3-\2-\1', $this->values['naissance']),
 279                          S::v('uid'));
 280         }
 281         if ($this->changed['nick'] || $this->changed['mobile'] || $this->changed['mobile_pub']
 282             || $this->changed['freetext']
 283             || $this->changed['freetext_pub'] || $this->changed['synchro_ax']) {
 284             XDB::execute("UPDATE  auth_user_quick
 285                              SET  profile_nick= {?}, profile_mobile={?}, profile_mobile_pub={?},
 286                                   profile_freetext={?},
 287                                   profile_freetext_pub={?}, profile_from_ax = {?}
 288                            WHERE  user_id = {?}",
 289                          $this->values['nick'], $this->values['mobile'], $this->values['mobile_pub'],
 290                          $this->values['freetext'], $this->values['freetext_pub'],
 291                          $this->values['synchro_ax'], S::v('uid'));
 292         }
 293         if ($this->changed['nick']) {
 294             require_once('user.func.inc.php');
 295             user_reindex(S::v('uid'));
 296         }
 297         if ($this->changed['photo_pub']) {
 298             XDB::execute("UPDATE  photo
 299                              SET  pub = {?}
 300                            WHERE  uid = {?}",
 301                          $this->values['photo_pub'], S::v('uid'));
 302         }
 303         if ($this->changed['yourself'] || $this->changed['sort_name'] ||
 304             $this-> changed['display_name'] || $this->changed['tooltip_name']) {
 305           XDB::execute("UPDATE profile_names_display AS n
 306                            SET n.yourself = {?},
 307                                n.sort = {?}, ". // SET
 308                               "n.display = {?}, ". // SET
 309                               "n.tooltip = {?} ". // SET
 310                         "WHERE n.user_id = {?}",
 311                        $this->values['yourself'],
 312                        $this->values['sort_name'],
 313                        $this->values['display_name'],
 314                        $this->values['tooltip_name'],
 315                         S::v('uid'));
 316         }
 317     }
 318
 319     public function _prepare(PlatalPage &$page, $id)
 320     {
 321         require_once "applis.func.inc.php";
 322
 323         $res = XDB::iterator("SELECT nw.network_type AS type, nw.name
 324                                 FROM profile_networking_enum AS nw
 325                             ORDER BY name");
 326         $page->assign('network_list', $res->fetchAllAssoc());
 327     }
 328 }
 329
 330 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 331 ?>