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             Platal::page()->trigError("Le $field que tu as choisi ($value) est trop loin de ton $field initial ($init)"
  56                                     . (($init == $current)? "" : " et de ton prénom précédent ($current)"));
  57         }
  58         return $success ? $value : $current;
  59     }
  60
  61     public function save(ProfilePage &$page, $field, $new_value)
  62     {
  63         $_SESSION[$field] = $new_value;
  64     }
  65 }
  66
  67 class ProfileAppli implements ProfileSetting
  68 {
  69     public function value(ProfilePage &$page, $field, $value, &$success)
  70     {
  71         $success = true;
  72         if (is_null($value)) {
  73             return $page->values[$field];
  74         }
  75         return $value;
  76     }
  77
  78     public function save(ProfilePage &$page, $field, $new_value)
  79     {
  80         $index = ($field == 'appli1' ? 0 : 1);
  81         if ($new_value['id'] > 0) {
  82             XDB::execute("REPLACE INTO  applis_ins
  83                                    SET  uid = {?}, aid = {?}, type = {?}, ordre = {?}",
  84                          S::i('uid'), $new_value['id'], $new_value['type'], $index);
  85         } else {
  86             XDB::execute("DELETE FROM  applis_ins
  87                                 WHERE  uid = {?} AND ordre = {?}",
  88                          S::i('uid'), $index);
  89         }
  90     }
  91 }
  92
  93 class ProfileGeneral extends ProfilePage
  94 {
  95     protected $pg_template = 'profile/general.tpl';
  96
  97     public function __construct(PlWizard &$wiz)
  98     {
  99         parent::__construct($wiz);
 100         $this->settings['nom'] = $this->settings['prenom']
 101                                = new ProfileNom();
 102         $this->settings['naissance'] = new ProfileDate();
 103         $this->settings['mobile_pub']
 104                                   = $this->settings['web_pub']
 105                                   = $this->settings['freetext_pub']
 106                                   = $this->settings['photo_pub']
 107                                   = new ProfilePub();
 108         $this->settings['freetext']
 109                                   = $this->settings['nationalite']
 110                                   = $this->settings['nick']
 111                                   = null;
 112         $this->settings['synchro_ax']
 113                                   = new ProfileBool();
 114         $this->settings['mobile'] = new ProfileTel();
 115         $this->settings['web'] = new ProfileWeb();
 116         $this->settings['appli1']
 117                                   = $this->settings['appli2']
 118                                   = new ProfileAppli();
 119         $this->watched= array('nom' => true, 'freetext' => true, 'mobile' => true, 'web' => true,
 120                        'appli1' => true, 'appli2' => true, 'nationalite' => true, 'nick' => true);
 121     }
 122
 123     protected function _fetchData()
 124     {
 125         // Checkout all data...
 126         $res = XDB::query("SELECT  u.promo, u.promo_sortie, u.nom_usage, u.nationalite, u.naissance,
 127                                    q.profile_mobile as mobile, q.profile_mobile_pub as mobile_pub,
 128                                    q.profile_web as web, q.profile_web_pub as web_pub,
 129                                    q.profile_freetext as freetext, q.profile_freetext_pub as freetext_pub,
 130                                    q.profile_nick as nick, q.profile_from_ax as synchro_ax, u.matricule_ax,
 131                                    IF(a1.aid IS NULL, -1, a1.aid) as appli_id1, a1.type as appli_type1,
 132                                    IF(a2.aid IS NULL, -1, a2.aid) as appli_id2, a2.type as appli_type2
 133                              FROM  auth_user_md5   AS u
 134                        INNER JOIN  auth_user_quick AS q  USING(user_id)
 135                         LEFT JOIN  applis_ins      AS a1 ON(a1.uid = u.user_id and a1.ordre = 0)
 136                         LEFT JOIN  applis_ins      AS a2 ON(a2.uid = u.user_id and a2.ordre = 1)
 137                             WHERE  u.user_id = {?}", S::v('uid', -1));
 138         $this->values = $res->fetchOneAssoc();
 139
 140         // Reformat formation data
 141         $this->values['appli1'] = array('id'    => $this->values['appli_id1'],
 142                                         'type'  => $this->values['appli_type1']);
 143         unset($this->values['appli_id1']);
 144         unset($this->values['appli_type1']);
 145         $this->values['appli2'] = array('id'    => $this->values['appli_id2'],
 146                                         'type'  => $this->values['appli_type2']);
 147         unset($this->values['appli_id2']);
 148         unset($this->values['appli_type2']);
 149
 150         // Retreive photo informations
 151         $res = XDB::query("SELECT  pub
 152                              FROM  photo
 153                             WHERE  uid = {?}", S::v('uid'));
 154         $this->values['photo_pub'] = $res->fetchOneCell();
 155
 156         $res = XDB::query("SELECT  COUNT(*)
 157                              FROM  requests
 158                             WHERE  type='photo' AND user_id = {?}",
 159                           S::v('uid'));
 160         $this->values['nouvellephoto'] = $res->fetchOneCell();
 161     }
 162
 163     protected function _saveData()
 164     {
 165         if ($this->changed['nationalite'] || $this->changed['nom'] || $this->changed['prenom']
 166             || $this->changed['naissance']) {
 167            XDB::execute("UPDATE  auth_user_md5
 168                             SET  nationalite = {?}, nom={?}, prenom={?}, naissance={?}
 169                           WHERE  user_id = {?}",
 170                          $this->values['nationalite'], $this->values['nom'], $this->values['prenom'],
 171                          preg_replace('@(\d{2})/(\d{2})/(\d{4})@', '\3-\2-\1', $this->values['naissance']),
 172                          S::v('uid'));
 173         }
 174         if ($this->changed['nick'] || $this->changed['mobile'] || $this->changed['mobile_pub']
 175             || $this->changed['web'] || $this->changed['web_pub'] || $this->changed['freetext']
 176             || $this->changed['freetext_pub'] || $this->changed['synchro_ax']) {
 177             XDB::execute("UPDATE  auth_user_quick
 178                              SET  profile_nick= {?}, profile_mobile={?}, profile_mobile_pub={?},
 179                                   profile_web={?}, profile_web_pub={?}, profile_freetext={?},
 180                                   profile_freetext_pub={?}, profile_from_ax = {?}
 181                            WHERE  user_id = {?}",
 182                          $this->values['nick'], $this->values['mobile'], $this->values['mobile_pub'],
 183                          $this->values['web'], $this->values['web_pub'],
 184                          $this->values['freetext'], $this->values['freetext_pub'],
 185                          $this->values['synchro_ax'], S::v('uid'));
 186         }
 187         if ($this->changed['nick']) {
 188             require_once('user.func.inc.php');
 189             user_reindex(S::v('uid'));
 190         }
 191         if ($this->changed['photo_pub']) {
 192             XDB::execute("UPDATE  photo
 193                              SET  pub = {?}
 194                            WHERE  uid = {?}",
 195                          $this->values['photo_pub'], S::v('uid'));
 196         }
 197     }
 198
 199     public function _prepare(PlPage &$page, $id)
 200     {
 201         require_once "applis.func.inc.php";
 202     }
 203 }
 204
 205 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 206 ?>