4e6d51b0b287c7f6723ce89be0332d22d5a2ed2f
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 ProfileSettingAddress
extends ProfileSettingGeocoding
27 public function __construct()
29 $this->bool
= new ProfileSettingBool();
30 $this->pub
= new ProfileSettingPub();
33 private function cleanAddress(ProfilePage
&$page, $addrid, array &$address)
35 if (!isset($address['tel'])) {
36 $address['tel'] = array();
38 $profiletel = new ProfileSettingPhones('address', $addrid);
39 $address['tel'] = $profiletel->value($page, 'tel', $address['tel'], $s);
40 $address['current'] = $this->bool
->value($page, 'current', $address['current'], $s);
41 $address['temporary'] = $this->bool
->value($page, 'temporary', $address['temporary'], $s);
42 $address['secondary'] = $this->bool
->value($page, 'secondary', $address['secondary'], $s);
43 $address['mail'] = $this->bool
->value($page, 'mail', $address['mail'], $s);
44 $address['pub'] = $this->pub
->value($page, 'pub', $address['pub'], $s);
47 public function value(ProfilePage
&$page, $field, $value, &$success)
50 if (is_null($value)) {
51 $value = $page->values
['addresses'];
54 foreach ($value as $key => &$address) {
55 if (isset($address['removed']) && $address['removed']) {
56 array_splice($value, $key, 1);
61 foreach ($value as $key => &$address) {
62 if (isset($address['current']) && $address['current']) {
66 if ($current == 0 && count($value) > 0) {
67 foreach ($value as &$address) {
68 $address['current'] = true
;
71 } elseif ($current > 1) {
74 foreach ($value as $key => &$address) {
75 if (!trim($address['text'])) {
78 $this->geocodeAddress($address, $s);
79 $success = $success && $s;
81 $this->cleanAddress($page, $key, $address);
86 public function saveAddress($pid, $addrid, array &$address, $type)
88 require_once 'geocoding.inc.php';
90 $flags = new PlFlagSet();
91 $flags->addFlag('current', $address['current']);
92 $flags->addFlag('temporary', $address['temporary']);
93 $flags->addFlag('secondary', $address['secondary']);
94 $flags->addFlag('mail', $address['mail']);
95 $flags->addFlag('cedex', $address['cedex'] =
96 (strpos(strtoupper(preg_replace(array("/[0-9,\"'#~:;_\- ]/", "/\r\n/"),
97 array("", "\n"), $address['text'])), 'CEDEX')) !== false
);
98 Geocoder
::getAreaId($address, "administrativeArea");
99 Geocoder
::getAreaId($address, "subAdministrativeArea");
100 Geocoder
::getAreaId($address, "locality");
101 XDB
::execute("INSERT INTO profile_addresses (pid, type, id, flags, accuracy,
102 text, postalText, postalCode, localityId,
103 subAdministrativeAreaId, administrativeAreaId,
104 countryId, latitude, longitude, updateTime, pub, comment,
105 north, south, east, west)
106 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?},
107 {?}, {?}, FROM_UNIXTIME({?}), {?}, {?}, {?}, {?}, {?}, {?})",
108 $pid, $type, $addrid, $flags, $address['accuracy'],
109 $address['text'], $address['postalText'], $address['postalCode'], $address['localityId'],
110 $address['subAdministrativeAreaId'], $address['administrativeAreaId'],
111 $address['countryId'], $address['latitude'], $address['longitude'],
112 $address['updateTime'], $address['pub'], $address['comment'],
113 $address['north'], $address['south'], $address['east'], $address['west']);
116 public function save(ProfilePage
&$page, $field, $value)
118 XDB
::execute("DELETE FROM profile_addresses
119 WHERE pid = {?} AND type = 'home'",
121 XDB
::execute("DELETE FROM profile_phones
122 WHERE pid = {?} AND link_type = 'address'",
124 foreach ($value as $addrid => &$address) {
125 $this->saveAddress($page->pid(), $addrid, $address, 'home');
126 $profiletel = new ProfileSettingPhones('address', $addrid);
127 $profiletel->saveTels($page->pid(), 'tel', $address['tel']);
132 class ProfileSettingAddresses
extends ProfilePage
134 protected $pg_template = 'profile/adresses.tpl';
136 public function __construct(PlWizard
&$wiz)
138 parent
::__construct($wiz);
139 $this->settings
['addresses'] = new ProfileSettingAddress();
140 $this->watched
['addresses'] = true
;
143 protected function _fetchData()
145 $res = XDB
::query("SELECT id, accuracy, text, postalText,
146 postalCode, localityId, subAdministrativeAreaId, administrativeAreaId,
147 countryId, latitude, longitude, pub, comment, UNIX_TIMESTAMP(updateTime) AS updateTime,
148 north, south, east, west,
149 FIND_IN_SET('current', flags) AS current,
150 FIND_IN_SET('temporary', flags) AS temporary,
151 FIND_IN_SET('secondary', flags) AS secondary,
152 FIND_IN_SET('mail', flags) AS mail,
153 FIND_IN_SET('cedex', flags) AS cedex
154 FROM profile_addresses
155 WHERE pid = {?} AND type = 'home'
158 if ($res->numRows() == 0) {
159 $this->values
['addresses'] = array();
161 $this->values
['addresses'] = $res->fetchAllAssoc();
164 $res = XDB
::iterator("SELECT link_id AS addrid, tel_type AS type, pub, display_tel AS tel, comment
166 WHERE pid = {?} AND link_type = 'address'
170 $adrNb = count($this->values
['addresses']);
171 while ($tel = $res->next()) {
172 $addrid = $tel['addrid'];
173 unset($tel['addrid']);
174 while ($i < $adrNb && $this->values
['addresses'][$i]['id'] < $addrid) {
180 $address =& $this->values
['addresses'][$i];
181 if (!isset($address['tel'])) {
182 $address['tel'] = array();
184 if ($address['id'] == $addrid) {
185 $address['tel'][] = $tel;
188 foreach ($this->values
['addresses'] as $id => &$address) {
189 if (!isset($address['tel'])) {
190 $address['tel'] = array(
199 unset($address['id']);
200 $address['changed'] = 0;
201 $address['removed'] = 0;
206 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: