2 /***************************************************************************
3 * Copyright (C) 2003-2010 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 function build_javascript_names($data, $isFemale)
24 $data_array = explode(';;', $data);
25 $n = count($data_array);
27 for ($i = 0; $i < $n; $i++
) {
28 $searchname = explode(';', $data_array[$i]);
29 if (isset($search_names[$searchname[0]])) {
30 $search_names[$searchname[0]][] = $searchname[1];
32 $search_names[$searchname[0]] = array('fullname' => $searchname[1]);
36 $sn_types_public = build_types('public');
37 $sn_types_private = build_types('private');
38 $full_name = build_full_name($search_names, $sn_types_public, $isFemale);
39 return build_public_name($search_names, $sn_types_public, $full_name) . ';' .
40 build_private_name($search_names, $sn_types_private);
43 function build_display_names(&$display_names, $search_names, $isFemale, $private_name_end = null
, &$alias = null
)
45 $sn_types_public = build_types('public');
46 $full_name = build_full_name($search_names, $sn_types_public, $isFemale);
47 $display_names['public_name'] = build_public_name($search_names, $sn_types_public, $full_name);
48 $display_names['private_name'] = $display_names['public_name'] . $private_name_end;
49 $display_names['directory_name'] = build_directory_name($search_names, $sn_types_public, $full_name);
50 $display_names['short_name'] = build_short_name($search_names, $sn_types_public, $alias);
51 $display_names['sort_name'] = build_sort_name($search_names, $sn_types_public);
54 function build_types($pub = null
)
56 if ($pub == 'public') {
57 $sql_pub = "AND FIND_IN_SET('public', flags)";
58 } elseif ($pub == 'private') {
59 $sql_pub = "AND NOT FIND_IN_SET('public', flags)";
63 $sql = "SELECT id, type, name
64 FROM profile_name_enum
65 WHERE NOT FIND_IN_SET('not_displayed', flags)" . $sql_pub;
66 $sn_types = XDB
::iterator($sql);
68 while ($sn_type = $sn_types->next()) {
70 $types[$sn_type['type']] = $sn_type['id'];
72 $types[$sn_type['id']] = $sn_type['name'];
78 function build_full_name(&$search_names, &$sn_types, $isFemale)
81 if (isset($search_names[$sn_types['lastname_ordinary']])) {
82 $name .= $search_names[$sn_types['lastname_ordinary']]['fullname'] . " ("
83 . $search_names[$sn_types['lastname']]['fullname'] . ")";
85 $name .= $search_names[$sn_types['lastname']]['fullname'];
87 if (isset($search_names[$sn_types['lastname_marital']])
88 ||
isset($search_names[$sn_types['pseudonym']])) {
90 if (isset($search_names[$sn_types['lastname_marital']])) {
96 $name .= $search_names[$sn_types['lastname_marital']]['fullname'];
97 if (isset($search_names[$sn_types['pseudonym']])) {
101 if (isset($search_names[$sn_types['pseudonym']])) {
102 $name .= $search_names[$sn_types['pseudonym']]['fullname'];
109 function build_public_name(&$search_names, &$sn_types, $full_name)
111 return $search_names[$sn_types['firstname']]['fullname'] . " " . $full_name;
114 function build_private_name(&$search_names, &$sn_types)
117 if (isset($search_names[$sn_types['nickname']])
118 ||
(isset($search_names[$sn_types['name_other']])
119 ||
isset($search_names[$sn_types['name_other']]))) {
121 if (isset($search_names[$sn_types['nickname']])) {
122 $name .= "alias " . $search_names[$sn_types['nickname']]['fullname'];
124 while (isset($search_names[$sn_types['nickname']][$i])) {
125 $name .= ", " . $search_names[$sn_types['nickname']][$i];
128 if (isset($search_names[$sn_types['name_other']])
129 ||
isset($search_names[$sn_types['firstname_other']])) {
133 if (isset($search_names[$sn_types['firstname_other']])) {
134 $name .= "autres prénoms : " . $search_names[$sn_types['firstname_other']]['fullname'];
136 while (isset($search_names[$sn_types['firstname_other']][$i])) {
137 $name .= ", " . $search_names[$sn_types['firstname_other']][$i];
140 if (isset($search_names[$sn_types['name_other']])) {
144 if (isset($search_names[$sn_types['name_other']])) {
145 $name .= "autres noms : " . $search_names[$sn_types['name_other']]['fullname'];
147 while (isset($search_names[$sn_types['name_other']][$i])) {
148 $name .= ", " . $search_names[$sn_types['name_other']][$i];
157 function build_directory_name(&$search_names, &$sn_types, $full_name)
159 return $full_name . " " . $search_names[$sn_types['firstname']]['fullname'];
162 function build_short_name(&$search_names, &$sn_types, &$alias = null
)
164 if (isset($search_names[$sn_types['lastname_ordinary']])) {
165 $lastname = $search_names[$sn_types['lastname_ordinary']]['fullname'];
167 $lastname = $search_names[$sn_types['lastname']]['fullname'];
169 if (isset($search_names[$sn_types['firstname_ordinary']])) {
170 $firstname = $search_names[$sn_types['firstname_ordinary']]['fullname'];
172 $firstname = $search_names[$sn_types['firstname']]['fullname'];
175 $alias = PlUser
::makeUserName($firstname, $lastname);
177 return $firstname . " " . $lastname;
180 function build_sort_name(&$search_names, &$sn_types)
183 if (isset($search_names[$sn_types['lastname_ordinary']])) {
184 $name .= $search_names[$sn_types['lastname_ordinary']]['name'];
186 $name .= $search_names[$sn_types['lastname']]['name'];
188 $name .= " " . $search_names[$sn_types['firstname']]['fullname'];
192 function set_profile_display(&$display_names, Profile
$profile)
194 XDB
::execute("UPDATE profile_display
195 SET public_name = {?}, private_name = {?},
196 directory_name = {?}, short_name = {?}, sort_name = {?}
198 $display_names['public_name'], $display_names['private_name'],
199 $display_names['directory_name'], $display_names['short_name'],
200 $display_names['sort_name'], $profile->id());
202 $owner = $profile->owner();
204 XDB
::execute('UPDATE accounts
205 SET full_name = {?}, directory_name = {?}
207 $display_names['public_name'], $display_names['directory_name'], $owner->id());
211 function build_sn_pub($pid)
213 $res = XDB
::iterator("SELECT CONCAT(sn.particle, sn.name) AS fullname, sn.typeid,
214 sn.particle, sn.name, sn.id
215 FROM profile_name AS sn
216 INNER JOIN profile_name_enum AS e ON (e.id = sn.typeid)
217 WHERE sn.pid = {?} AND NOT FIND_IN_SET('not_displayed', e.flags)
218 AND FIND_IN_SET('public', e.flags)
219 ORDER BY NOT FIND_IN_SET('always_displayed', e.flags), e.id, sn.name",
222 while ($old = $res->next()) {
223 $sn_old[$old['typeid']] = array('fullname' => $old['fullname'],
224 'name' => $old['name'],
225 'particle' => $old['particle'],
231 /** Transform a name to its canonical value so it can be compared
232 * to another form (different case, with accents or with - instead
234 * @see compare_basename to compare
236 function name_to_basename($value) {
237 $value = mb_strtoupper(replace_accent($value));
238 return preg_replace('/[^A-Z]/', ' ', $value);
241 /** Compares two strings and check if they are two forms of the
242 * same name (different case, with accents or with - instead of
244 * @see name_to_basename to retreive the compared string
246 function compare_basename($a, $b) {
247 return name_to_basename($a) == name_to_basename($b);
250 function set_alias_names(&$sn_new, $sn_old, $pid, $uid, $update_new = false
, $new_alias = null
)
253 foreach ($sn_new as $typeid => $sn) {
254 if (isset($sn['pub'])) {
255 if (isset($sn_old[$typeid]) && ($sn_old[$typeid]['fullname'] == $sn['fullname'] && $update_new)) {
256 XDB
::execute("UPDATE profile_name
257 SET particle = {?}, name = {?}, typeid = {?}
258 WHERE id = {?} AND pid = {?}",
259 $sn['particle'], $sn['name'], $typeid, $sn_old[$typeid]['id'], $pid);
260 unset($sn_old[$typeid]);
261 } elseif ($update_new
262 ||
(isset($sn_old[$typeid]) && compare_basename($sn_old[$typeid]['fullname'], $sn['fullname']))) {
263 XDB
::execute("INSERT INTO profile_name (particle, name, typeid, pid)
264 VALUES ({?}, {?}, {?}, {?})",
265 $sn['particle'], $sn['name'], $typeid, $pid);
266 unset($sn_old[$typeid]);
271 if ($sn['fullname'] != '') {
272 XDB
::execute("INSERT INTO profile_name (particle, name, typeid, pid)
273 VALUES ('', {?}, {?}, {?})",
274 $sn['fullname'], $typeid, $pid);
277 while (isset($sn[$i])) {
278 XDB
::execute("INSERT INTO profile_name (particle, name, typeid, pid)
279 VALUES ('', {?}, {?}, {?})",
280 $sn[$i], $typeid, $pid);
285 if (count($sn_old) > 0) {
288 foreach ($sn_old as $typeid => $sn) {
289 XDB
::execute("INSERT INTO profile_name (particle, name, typeid, pid)
290 VALUES ({?}, {?}, {?}, {?})",
291 $sn['particle'], $sn['name'], $typeid, $pid);
294 foreach ($sn_old as $typeid => $sn) {
295 XDB
::execute("DELETE FROM profile_name
296 WHERE pid = {?} AND id = {?}",
302 XDB
::execute("DELETE FROM aliases
303 WHERE FIND_IN_SET('usage', flags) AND uid = {?}",
307 XDB
::execute("INSERT INTO aliases (alias, type, flags, uid)
308 VALUES ({?}, 'alias', 'usage', {?})",
311 Profile
::rebuildSearchTokens($pid, false
);
315 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: