modules/profile/general.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2007 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->trig("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 ProfileGeneral extends ProfilePage
 111 {
 112     protected $pg_template = 'profile/general.tpl';
 113
 114     public function __construct(PlWizard &$wiz)
 115     {
 116         parent::__construct($wiz);
 117         $this->settings['nom'] = $this->settings['prenom']
 118                                = new ProfileNom();
 119         $this->settings['naissance'] = new ProfileDate();
 120         $this->settings['mobile_pub']
 121                                   = $this->settings['web_pub']
 122                                   = $this->settings['freetext_pub']
 123                                   = $this->settings['photo_pub']
 124                                   = new ProfilePub();
 125         $this->settings['freetext']
 126                                   = $this->settings['nationalite']
 127                                   = $this->settings['nick']
 128                                   = $this->settings['yourself']
 129                                   = $this->settings['display_name']
 130                                   = $this->settings['sort_name']
 131                                   = $this->settings['tooltip_name']
 132                                   = null;
 133         $this->settings['synchro_ax']
 134                                   = new ProfileBool();
 135         $this->settings['mobile'] = new ProfileTel();
 136         $this->settings['web'] = new ProfileWeb();
 137         $this->settings['appli1']
 138                                   = $this->settings['appli2']
 139                                   = new ProfileAppli();
 140         $this->watched= array('nom' => true, 'freetext' => true, 'mobile' => true, 'web' => true,
 141                        'appli1' => true, 'appli2' => true, 'nationalite' => true, 'nick' => true);
 142     }
 143
 144     protected function _fetchData()
 145     {
 146         // Checkout all data...
 147         $res = XDB::query("SELECT  u.promo, u.promo_sortie, u.nom_usage, u.nationalite, u.naissance,
 148                                    q.profile_mobile as mobile, q.profile_mobile_pub as mobile_pub,
 149                                    q.profile_web as web, q.profile_web_pub as web_pub,
 150                                    q.profile_freetext as freetext, q.profile_freetext_pub as freetext_pub,
 151                                    q.profile_nick as nick, q.profile_from_ax as synchro_ax, u.matricule_ax,
 152                                    IF(a1.aid IS NULL, -1, a1.aid) as appli_id1, a1.type as appli_type1,
 153                                    IF(a2.aid IS NULL, -1, a2.aid) as appli_id2, a2.type as appli_type2,
 154                                    n.yourself, n.display AS display_name, n.sort AS sort_name,
 155                                    n.tooltip AS tooltip_name
 156                              FROM  auth_user_md5   AS u
 157                        INNER JOIN  auth_user_quick AS q  ON(u.user_id = q.user_id)
 158                        INNER JOIN  profile_names_display AS n ON(n.user_id = u.user_id)
 159                         LEFT JOIN  applis_ins      AS a1 ON(a1.uid = u.user_id and a1.ordre = 0)
 160                         LEFT JOIN  applis_ins      AS a2 ON(a2.uid = u.user_id and a2.ordre = 1)
 161                             WHERE  u.user_id = {?}", S::v('uid', -1));
 162         $this->values = $res->fetchOneAssoc();
 163
 164         // Reformat formation data
 165         $this->values['appli1'] = array('id'    => $this->values['appli_id1'],
 166                                         'type'  => $this->values['appli_type1']);
 167         unset($this->values['appli_id1']);
 168         unset($this->values['appli_type1']);
 169         $this->values['appli2'] = array('id'    => $this->values['appli_id2'],
 170                                         'type'  => $this->values['appli_type2']);
 171         unset($this->values['appli_id2']);
 172         unset($this->values['appli_type2']);
 173
 174         // Retreive photo informations
 175         $res = XDB::query("SELECT  pub
 176                              FROM  photo
 177                             WHERE  uid = {?}", S::v('uid'));
 178         $this->values['photo_pub'] = $res->fetchOneCell();
 179
 180         $res = XDB::query("SELECT  COUNT(*)
 181                              FROM  requests
 182                             WHERE  type='photo' AND user_id = {?}",
 183                           S::v('uid'));
 184         $this->values['nouvellephoto'] = $res->fetchOneCell();
 185
 186         // Retreive search names info
 187         $this->values['search_names'] = XDB::iterator("
 188                               SELECT sn.search_name, sn.name_type, sn.pub, sn.sn_id
 189                                 FROM profile_names_search AS sn
 190                                WHERE sn.user_id = {?}
 191                             ORDER BY sn.name_type, search_score, search_name",
 192                           S::v('uid'));
 193     }
 194
 195     protected function _saveData()
 196     {
 197         if ($this->changed['nationalite'] || $this->changed['nom'] || $this->changed['prenom']
 198             || $this->changed['naissance']) {
 199            XDB::execute("UPDATE  auth_user_md5
 200                             SET  nationalite = {?}, nom={?}, prenom={?}, naissance={?}
 201                           WHERE  user_id = {?}",
 202                          $this->values['nationalite'], $this->values['nom'], $this->values['prenom'],
 203                          preg_replace('@(\d{2})/(\d{2})/(\d{4})@', '\3-\2-\1', $this->values['naissance']),
 204                          S::v('uid'));
 205         }
 206         if ($this->changed['nick'] || $this->changed['mobile'] || $this->changed['mobile_pub']
 207             || $this->changed['web'] || $this->changed['web_pub'] || $this->changed['freetext']
 208             || $this->changed['freetext_pub'] || $this->changed['synchro_ax']) {
 209             XDB::execute("UPDATE  auth_user_quick
 210                              SET  profile_nick= {?}, profile_mobile={?}, profile_mobile_pub={?},
 211                                   profile_web={?}, profile_web_pub={?}, profile_freetext={?},
 212                                   profile_freetext_pub={?}, profile_from_ax = {?}
 213                            WHERE  user_id = {?}",
 214                          $this->values['nick'], $this->values['mobile'], $this->values['mobile_pub'],
 215                          $this->values['web'], $this->values['web_pub'],
 216                          $this->values['freetext'], $this->values['freetext_pub'],
 217                          $this->values['synchro_ax'], S::v('uid'));
 218         }
 219         if ($this->changed['nick']) {
 220             require_once('user.func.inc.php');
 221             user_reindex(S::v('uid'));
 222         }
 223         if ($this->changed['photo_pub']) {
 224             XDB::execute("UPDATE  photo
 225                              SET  pub = {?}
 226                            WHERE  uid = {?}",
 227                          $this->values['photo_pub'], S::v('uid'));
 228         }
 229         if ($this->changed['yourself'] || $this->changed['sort_name'] ||
 230             $this-> changed['display_name'] || $this->changed['tooltip_name']) {
 231           XDB::execute("UPDATE profile_names_display AS n
 232                            SET n.yourself = {?},
 233                                n.sort = {?}, ". // SET
 234                               "n.display = {?}, ". // SET
 235                               "n.tooltip = {?} ". // SET
 236                         "WHERE n.user_id = {?}",
 237                        $this->values['yourself'],
 238                        $this->values['sort_name'],
 239                        $this->values['display_name'],
 240                        $this->values['tooltip_name'],
 241                         S::v('uid'));
 242         }
 243     }
 244
 245     public function _prepare(PlatalPage &$page, $id)
 246     {
 247         require_once "applis.func.inc.php";
 248     }
 249 }
 250
 251 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 252 ?>