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 /** Class Phone is meant to perform most of the access to the table profile_phones.
24 * profile_phone describes a Phone, which can be related to an Address,
25 * a Job, a Profile or a Company:
27 * - `link_type` is set to 'user'
28 * - `link_id` is set to 0
29 * - `pid` is set to the id of the related Profile (in profiles)
32 * - `link_type` is set to 'hq'
33 * - `link_id` is set to the id of the related Company (in profile_job_enum)
36 * - for an Address (this only applies to a personal address)
37 * - `link_type` is set to 'address'
38 * - `link_id` is set to the related Address `id` (in profile_addresses)
39 * - `pid` is set to the related Address `pid` (in both profiles and profile_addresses)
42 * - `link_type` is set to 'pro'
43 * - `link_id` is set to the related Job `id` (not `jobid`) (in profile_job)
44 * - `pid` is set to the related Job `pid` (in both profiles and profile_job)
46 * Thus a Phone can be linked to a Company, a Profile, a Job, or a Profile-related Address.
50 const TYPE_FAX
= 'fax';
51 const TYPE_FIXED
= 'fixed';
52 const TYPE_MOBILE
= 'mobile';
54 const LINK_JOB
= 'pro';
55 const LINK_ADDRESS
= 'address';
56 const LINK_PROFILE
= 'user';
57 const LINK_COMPANY
= 'hq';
59 /** The following fields, but $error, all correspond to the fields of the
60 * database table profile_phones.
65 private $link_type = 'user';
67 // The following fields are the fields of the form in the profile edition.
68 private $type = 'fixed';
70 private $pub = 'private';
72 private $error = false
;
74 public function __construct(array $data = array())
76 if (count($data) > 0) {
77 foreach ($data as $key => $val) {
83 public function linkType()
85 return $this->link_type
;
88 public function linkId()
90 return $this->link_id
;
103 public function search()
105 return $this->search
;
108 public function setId($id)
113 /** Returns the unique ID of a phone.
114 * This ID will allow to link it to an address, a user or a job.
115 * The format is address_addressId_phoneId (where phoneId is the id
116 * of the phone in the list of those associated with the address).
118 public function uniqueId() {
119 return $this->link_type
. '_' . $this->link_id
. '_' . $this->id
;
122 public function hasFlags($flags) {
123 return $this->hasType($flags) && $this->hasLink($flags);
126 /** Returns true if this phone's type matches the flags.
128 public function hasType($flags) {
129 $flags = $flags & Profile
::PHONE_TYPE_ANY
;
131 ($flags == Profile
::PHONE_TYPE_ANY
)
133 (($flags & Profile
::PHONE_TYPE_FAX
) && $this->type
== self
::TYPE_FAX
)
135 (($flags & Profile
::PHONE_TYPE_FIXED
) && $this->type
== self
::TYPE_FIXED
)
137 (($flags & Profile
::PHONE_TYPE_MOBILE
) && $this->type
== self
::TYPE_MOBILE
)
141 /** User-friendly accessible version of the type.
143 public function displayType($short = false
)
145 switch ($this->type
) {
146 case Phone
::TYPE_FIXED
:
147 return $short ?
'Tél' : 'Fixe';
148 case Phone
::TYPE_FAX
:
150 case Phone
::TYPE_MOBILE
:
151 return $short ?
'Mob' : 'Mobile';
157 /** Returns true if this phone's link matches the flags.
159 public function hasLink($flags)
161 $flags = $flags & Profile
::PHONE_LINK_ANY
;
163 ($flags == Profile
::PHONE_LINK_ANY
)
165 (($flags & Profile
::PHONE_LINK_COMPANY
) && $this->link_type
== self
::LINK_COMPANY
)
167 (($flags & Profile
::PHONE_LINK_JOB
) && $this->link_type
== self
::LINK_JOB
)
169 (($flags & Profile
::PHONE_LINK_ADDRESS
) && $this->link_type
== self
::LINK_ADDRESS
)
171 (($flags & Profile
::PHONE_LINK_PROFILE
) && $this->link_type
== self
::LINK_PROFILE
)
175 /* Properly formats the search phone, based on actual display phone.
177 * Computes a base form of the phone number with the international prefix.
178 * This number only contains digits, thus does not begin with the '+' sign.
179 * Numbers starting with 0 (or '(0)') are considered as French.
180 * This assumes that non-French numbers have their international prefix.
182 private function formatSearch()
184 $tel = trim($this->display
);
185 // Number starting with "(0)" is a French number.
186 if (substr($tel, 0, 3) === '(0)') {
189 // Removes all "(0)" often used as local prefix.
190 $tel = str_replace('(0)', '', $tel);
191 // Removes all non-digit chars.
192 $tel = preg_replace('/[^0-9]/', '', $tel);
194 if (substr($tel, 0, 2) === '00') {
195 // Removes prefix for international calls.
196 $tel = substr($tel, 2);
197 } else if (substr($tel, 0, 1) === '0') {
198 // Number starting with 0 is a French number.
199 $tel = '33' . substr($tel, 1);
201 $this->search
= $tel;
204 // Properly formats the display phone, it requires the search phone to be already formatted.
205 private function formatDisplay($format = array())
207 $tel = $this->search
;
209 $telLength = strlen($tel);
210 // Try to find the country by trying to find a matching prefix of 1, 2 or 3 digits.
211 if ((!isset($format['phoneprf'])) ||
($format['phoneprf'] == '')) {
212 $res = XDB
::query('SELECT phonePrefix AS phoneprf, phoneFormat AS format
213 FROM geoloc_countries
214 WHERE phonePrefix = {?} OR phonePrefix = {?} OR phonePrefix = {?}
216 substr($tel, 0, 1), substr($tel, 0, 2), substr($tel, 0, 3));
217 if ($res->numRows() == 0) {
218 // No country found, does not format more than prepending a '+' sign.
220 $this->display
= '+' . $tel;
223 $format = $res->fetchOneAssoc();
225 if ($format['format'] == '') {
226 // If the country does not have a phone number format, the number will be displayed
227 // as "+prefix ## ## ## ##...".
228 $format['format'] = '(+p)';
231 /* Formats the phone number according t the template with these rules:
232 * - p is replaced by the international prefix,
233 * - # is replaced by one digit,
234 * - other chars are left intact.
235 * If the number is longer than the format, remaining digits are
236 * appended by blocks of two digits separated by spaces.
237 * The last block can have 3 digits to avoid a final single-digit block.
240 $i = strlen($format['phoneprf']);
241 $lengthFormat = strlen($format['format']);
242 while (($i < $telLength) && ($j < $lengthFormat)) {
243 if ($format['format'][$j] == '#') {
246 } else if ($format['format'][$j] == 'p') {
247 $ret .= $format['phoneprf'];
249 $ret .= $format['format'][$j];
253 for (; $i < $telLength - 1; $i +
= 2) {
254 $ret .= ' ' . substr($tel, $i, 2);
256 // Appends last left alone numbers to the last block.
257 if ($i < $telLength) {
258 $ret .= substr($tel, $i);
260 $this->display
= $ret;
264 public function format($format = array())
266 if (!($this->type
== Phone
::TYPE_FIXED
267 ||
$this->type
== Phone
::TYPE_MOBILE
268 ||
$this->type
== Phone
::TYPE_FAX
)) {
269 $this->type
= Phone
::TYPE_FIXED
;
271 $this->formatSearch();
272 $this->formatDisplay($format);
273 return !$this->error
;
276 public function toFormArray()
279 'type' => $this->type
,
280 'display' => $this->display
,
282 'comment' => $this->comment
,
283 'error' => $this->error
287 private function toString()
289 return 'type : ' . $this->type
.', numéro : ' . $this->display
290 . ', commentaire : « ' . $this->comment
. ' », affichage : ' . $this->pub
;
293 private function isEmpty()
295 return (!$this->search ||
$this->search
== '');
298 public function save()
301 if (!$this->isEmpty()) {
302 XDB
::execute('INSERT INTO profile_phones (pid, link_type, link_id, tel_id, tel_type,
303 search_tel, display_tel, pub, comment)
304 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
305 $this->pid
, $this->link_type
, $this->link_id
, $this->id
, $this->type
,
306 $this->search
, $this->display
, $this->pub
, $this->comment
);
310 public function delete()
312 XDB
::execute('DELETE FROM profile_phones
313 WHERE pid = {?} AND link_type = {?} AND link_id = {?} AND tel_id = {?}',
314 $this->pid
, $this->link_type
, $this->link_id
, $this->id
);
317 static public function deletePhones($pid, $link_type, $link_id = null
)
320 if (!is_null($link_id)) {
321 $where = XDB
::format(' AND link_id = {?}', $link_id);
323 XDB
::execute('DELETE FROM profile_phones
324 WHERE pid = {?} AND link_type = {?}' . $where,
328 /** Saves phones into the database.
329 * @param $data: an array of form formatted phones.
330 * @param $pid, $link_type, $link_id: pid, link_type and link_id concerned by the update.
332 static public function savePhones(array $data, $pid, $link_type, $link_id = null
)
334 foreach ($data as $id => $value) {
336 if (!is_null($pid)) {
337 $value['pid'] = $pid ;
339 if (!is_null($link_type)) {
340 $value['link_type'] = $link_type ;
342 if (!is_null($link_id)) {
343 $value['link_id'] = $link_id ;
345 $phone = new Phone($value);
350 static private function formArrayWalk(array $data, $function, &$success = true
, $requiresEmptyPhone = false
)
353 foreach ($data as $item) {
354 $phone = new Phone($item);
355 $success = (!$phone->error
&& ($phone->format() ||
$phone->isEmpty()) && $success);
356 if (!$phone->isEmpty()) {
357 $phones[] = call_user_func(array($phone, $function));
360 if (count($phones) == 0 && $requiresEmptyPhone) {
361 $phone = new Phone();
362 $phones[] = call_user_func(array($phone, $function));
367 // Formats an array of form phones into an array of form formatted phones.
368 static public function formatFormArray(array $data, &$success = true
)
370 return self
::formArrayWalk($data, 'toFormArray', $success, true
);
373 static public function formArrayToString(array $data)
375 return implode(' ; ', self
::formArrayWalk($data, 'toString'));
378 static public function iterate(array $pids = array(), array $link_types = array(),
379 array $link_ids = array(), array $pubs = array())
381 return new PhoneIterator($pids, $link_types, $link_ids, $pubs);
385 /** Iterator over a set of Phones
387 * @param $pid, $link_type, $link_id, $pub
389 * The iterator contains the phones that correspond to the value stored in the
390 * parameters' arrays.
392 class PhoneIterator
implements PlIterator
396 public function __construct(array $pids, array $link_types, array $link_ids, array $pubs)
399 if (count($pids) != 0) {
400 $where[] = XDB
::format('(pid IN {?})', $pids);
402 if (count($link_types) != 0) {
403 $where[] = XDB
::format('(link_type IN {?})', $link_types);
405 if (count($link_ids) != 0) {
406 $where[] = XDB
::format('(link_id IN {?})', $link_ids);
408 if (count($pubs) != 0) {
409 $where[] = XDB
::format('(pub IN {?})', $pubs);
411 $sql = 'SELECT search_tel AS search, display_tel AS display, comment, link_id,
412 tel_type AS type, link_type, tel_id AS id, pid, pub
414 ' . ((count($where) > 0) ?
'WHERE ' . implode(' AND ', $where) : '') . '
415 ORDER BY pid, link_id, tel_id';
416 $this->dbiter
= XDB
::iterator($sql);
419 public function next()
421 if (is_null($this->dbiter
)) {
424 $data = $this->dbiter
->next();
425 if (is_null($data)) {
428 return new Phone($data);
431 public function total()
433 return $this->dbiter
->total();
436 public function first()
438 return $this->dbiter
->first();
441 public function last()
443 return $this->dbiter
->last();
446 public function value()
448 return $this->dbiter
;
452 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: