bool = new ProfileBool(); $this->pub = new ProfilePub(); } private function cleanAddress(ProfilePage &$page, $addrid, array &$address) { if (!isset($address['tel'])) { $address['tel'] = array(); } $profiletel = new ProfilePhones('address', $addrid); $address['tel'] = $profiletel->value($page, 'tel', $address['tel'], $s); $address['current'] = $this->bool->value($page, 'current', $address['current'], $s); $address['temporary'] = $this->bool->value($page, 'temporary', $address['temporary'], $s); $address['secondary'] = $this->bool->value($page, 'secondary', $address['secondary'], $s); $address['mail'] = $this->bool->value($page, 'mail', $address['mail'], $s); $address['pub'] = $this->pub->value($page, 'pub', $address['pub'], $s); } public function value(ProfilePage &$page, $field, $value, &$success) { $init = false; if (is_null($value)) { $value = $page->values['addresses']; $init = true; } foreach ($value as $key => &$address) { if (isset($address['removed']) && $address['removed']) { unset($value[$key]); } } $current = 0; $success = true; foreach ($value as $key => &$address) { if (isset($address['current']) && $address['current']) { $current++; } } if ($current == 0 && count($value) > 0) { foreach ($value as $address) { $address['current'] = true; break; } } elseif ($current > 1) { $success = false; } foreach ($value as $key => &$address) { if (!trim($address['text'])) { unset($value[$key]); } elseif (!$init) { $this->geocodeAddress($address, $s); $success = $success && $s; } $this->cleanAddress($page, $key, $address); } return $value; } private function saveAddress($pid, $addrid, array &$address, $type) { require_once "geocoding.inc.php"; $flags = new PlFlagSet(); $flags->addFlag('current', $address['current']); $flags->addFlag('temporary', $address['temporary']); $flags->addFlag('secondary', $address['secondary']); $flags->addFlag('mail', $address['mail']); $flags->addFlag('cedex', $address['cedex'] = (strpos(strtoupper(preg_replace(array("/[0-9,\"'#~:;_\- ]/", "/\r\n/"), array("", "\n"), $address['text'])), 'CEDEX')) !== false); Geocoder::getAreaId($address, "administrativeArea"); Geocoder::getAreaId($address, "subAdministrativeArea"); Geocoder::getAreaId($address, "locality"); XDB::execute("INSERT INTO profile_addresses (pid, type, id, flags, accuracy, text, postalText, postalCode, localityId, subAdministrativeAreaId, administrativeAreaId, countryId, latitude, longitude, updateTime, pub, comment, north, south, east, west) VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, FROM_UNIXTIME({?}), {?}, {?}, {?}, {?}, {?}, {?})", $pid, $type, $addrid, $flags, $address['accuracy'], $address['text'], $address['postalText'], $address['postalCode'], $address['localityId'], $address['subAdministrativeAreaId'], $address['administrativeAreaId'], $address['countryId'], $address['latitude'], $address['longitude'], $address['updateTime'], $address['pub'], $address['comment'], $address['north'], $address['south'], $address['east'], $address['west']); } public function save(ProfilePage &$page, $field, $value) { XDB::execute("DELETE FROM profile_addresses WHERE pid = {?} AND type = 'home'", $page->pid()); XDB::execute("DELETE FROM profile_phones WHERE uid = {?} AND link_type = 'address'", $page->pid()); foreach ($value as $addrid => &$address) { $this->saveAddress($page->pid(), $addrid, $address, 'home'); $profiletel = new ProfilePhones('address', $addrid); $profiletel->saveTels($page->pid(), 'tel', $address['tel']); } } } class ProfileAddresses extends ProfilePage { protected $pg_template = 'profile/adresses.tpl'; public function __construct(PlWizard &$wiz) { parent::__construct($wiz); $this->settings['addresses'] = new ProfileAddress(); $this->watched['addresses'] = true; } protected function _fetchData() { $res = XDB::query("SELECT id, accuracy, text, postalText, postalCode, localityId, subAdministrativeAreaId, administrativeAreaId, countryId, latitude, longitude, pub, comment, updateTime, north, south, east, west, FIND_IN_SET('current', flags) AS current, FIND_IN_SET('temporary', flags) AS temporary, FIND_IN_SET('secondary', flags) AS secondary, FIND_IN_SET('mail', flags) AS mail, FIND_IN_SET('cedex', flags) AS cedex FROM profile_addresses WHERE pid = {?} AND type = 'home' ORDER BY id", $this->pid()); if ($res->numRows() == 0) { $this->values['addresses'] = array(); } else { $this->values['addresses'] = $res->fetchAllAssoc(); } $res = XDB::iterator("SELECT link_id AS addrid, tel_type AS type, pub, display_tel AS tel, comment FROM profile_phones WHERE uid = {?} AND link_type = 'address' ORDER BY link_id", $this->pid()); $i = 0; $adrNb = count($this->values['addresses']); while ($tel = $res->next()) { $addrid = $tel['addrid']; unset($tel['addrid']); while ($i < $adrNb && $this->values['addresses'][$i]['id'] < $addrid) { $i++; } if ($i >= $adrNb) { break; } $address =& $this->values['addresses'][$i]; if (!isset($address['tel'])) { $address['tel'] = array(); } if ($address['id'] == $addrid) { $address['tel'][] = $tel; } } foreach ($this->values['addresses'] as $id => &$address) { if (!isset($address['tel'])) { $address['tel'] = array(); } unset($address['id']); } } } // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>