2 /***************************************************************************
3 * Copyright (C) 2003-2008 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 class ProfileNom
implements ProfileSetting
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} == ' ');
30 private function prepareField($value)
32 $value = strtoupper(replace_accent($value));
33 return preg_replace('/[^A-Z]/', ' ', $value);
36 public function value(ProfilePage
&$page, $field, $value, &$success)
39 $current = S
::v($field);
40 $init = S
::v($field . '_ini');
41 if (is_null($value)) {
44 if ($value == $current ||
$value == $init) {
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);
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)"));
59 return $success ?
$value : $current;
62 public function save(ProfilePage
&$page, $field, $new_value)
64 $_SESSION[$field] = $new_value;
68 class ProfileSearchName
implements ProfileSetting
71 public function __construct()
75 public function value(ProfilePage
&$page, $field, $value, &$success)
79 public function save(ProfilePage
&$page, $field, $new_value)
84 class ProfileAppli
implements ProfileSetting
86 public function value(ProfilePage
&$page, $field, $value, &$success)
89 if (is_null($value)) {
90 return $page->values
[$field];
95 public function save(ProfilePage
&$page, $field, $new_value)
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);
103 XDB
::execute("DELETE FROM applis_ins
104 WHERE uid = {?} AND ordre = {?}",
105 S
::i('uid'), $index);
110 class ProfileGeneral
extends ProfilePage
112 protected $pg_template = 'profile/general.tpl';
114 public function __construct(PlWizard
&$wiz)
116 parent
::__construct($wiz);
117 $this->settings
['nom'] = $this->settings
['prenom']
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']
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']
133 $this->settings
['synchro_ax']
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
);
144 protected function _fetchData()
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();
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']);
174 // Retreive photo informations
175 $res = XDB
::query("SELECT pub
177 WHERE uid = {?}", S
::v('uid'));
178 $this->values
['photo_pub'] = $res->fetchOneCell();
180 $res = XDB
::query("SELECT COUNT(*)
182 WHERE type='photo' AND user_id = {?}",
184 $this->values
['nouvellephoto'] = $res->fetchOneCell();
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",
195 protected function _saveData()
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']),
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'));
219 if ($this->changed
['nick']) {
220 require_once('user.func.inc.php');
221 user_reindex(S
::v('uid'));
223 if ($this->changed
['photo_pub']) {
224 XDB
::execute("UPDATE photo
227 $this->values
['photo_pub'], S
::v('uid'));
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'],
245 public function _prepare(PlatalPage
&$page, $id)
247 require_once "applis.func.inc.php";
251 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: