X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile%2Faddresses.inc.php;h=a308fe609683ed70fc81414f153b92ea92cb5083;hb=0001ba7a34dc3b535407cb1b961781c3c69c0ccd;hp=34e36afba9f88c08e5908cbe47add7235510ebba;hpb=7568a515d7e3c4c992dd98b784165aa36b575ff9;p=platal.git diff --git a/modules/profile/addresses.inc.php b/modules/profile/addresses.inc.php index 34e36af..a308fe6 100644 --- a/modules/profile/addresses.inc.php +++ b/modules/profile/addresses.inc.php @@ -1,6 +1,6 @@ bool = new ProfileBool(); + $this->pub = new ProfilePub(); + } + + private function cleanAddress(ProfilePage &$page, $adrid, array &$address, &$success) + { + if (@$address['changed']) { + $address['datemaj'] = time(); + } + $success = true; + if (!isset($address['tel'])) { + $address['tel'] = array(); } - $address['text'] = get_address_text($address); + $profiletel = new ProfilePhones('address', $adrid); + $address['tel'] = $profiletel->value($page, 'tel', $address['tel'], $s); + $address['checked'] = $this->bool->value($page, 'checked', $address['checked'], $s); + $address['secondaire'] = $this->bool->value($page, 'secondaire', $address['secondaire'], $s); + $address['mail'] = $this->bool->value($page, 'mail', $address['mail'], $s); + $address['temporary'] = $this->bool->value($page, 'temporary', $address['temporary'], $s); + $address['current'] = $this->bool->value($page, 'current', @$address['current'], $s); + $address['pub'] = $this->pub->value($page, 'pub', $address['pub'], $s); unset($address['parsevalid']); unset($address['changed']); + unset($address['removed']); + unset($address['display']); } public function value(ProfilePage &$page, $field, $value, &$success) @@ -54,15 +65,75 @@ class ProfileAddress extends ProfileNoSave unset($value[$key]); } } + $current = 0; $success = true; foreach ($value as $key=>&$adr) { + if (@$adr['current']) { + $current++; + } + } + if ($current == 0 && count($value) > 0) { + foreach ($value as $key=>&$adr) { + $adr['current'] = true; + break; + } + } else if ($current > 1) { + $success = false; + } + foreach ($value as $key=>&$adr) { + $ls = true; $this->geolocAddress($adr, $s); - if (!$init) { - $success = $success && $s; + $ls = ($ls && $s); + $this->cleanAddress($page, $key, $adr, $s); + $ls = ($ls && $s); + if (!trim($adr['text'])) { + unset($value[$key]); + } else if (!$init) { + $success = ($success && $ls); } } return $value; } + + private function saveAddress($pid, $adrid, array &$address) + { + $flags = new PlFlagSet(); + $flags->addFlag('res-secondaire', $address['secondaire']); + $flags->addFlag('courrier', $address['mail']); + $flags->addFlag('temporaire', $address['temporary']); + $flags->addFlag('active', $address['current']); + $flags->addFlag('coord-checked', $address['checked']); + XDB::execute("INSERT INTO adresses (adr1, adr2, adr3, + postcode, city, cityid, + country, region, regiontxt, + pub, datemaj, statut, + uid, adrid, glat, glng, comment) + VALUES ({?}, {?}, {?}, + {?}, {?}, {?}, + {?}, {?}, {?}, + {?}, FROM_UNIXTIME({?}), {?}, + {?}, {?}, {?}, {?}, {?})", + $address['adr1'], $address['adr2'], $address['adr3'], + $address['postcode'], $address['city'], $address['cityid'], + $address['country'], $address['region'], $address['regiontxt'], + $address['pub'], $address['datemaj'], $flags, + $pid, $adrid, $address['precise_lat'], $address['precise_lon'], $address['comment']); + } + + public function save(ProfilePage &$page, $field, $value) + { + XDB::execute("DELETE FROM adresses + WHERE uid = {?}", + $page->pid()); + XDB::execute("DELETE FROM profile_phones + WHERE uid = {?} AND link_type = 'address'", + $page->pid()); + foreach ($value as $adrid=>&$address) { + $this->saveAddress($page->pid(), $adrid, $address); + $profiletel = new ProfilePhones('address', $adrid); + $profiletel->saveTels($page->pid(), 'tel', $address['tel']); + } + } } class ProfileAddresses extends ProfilePage @@ -73,42 +144,50 @@ class ProfileAddresses extends ProfilePage { parent::__construct($wiz); $this->settings['addresses'] = new ProfileAddress(); + $this->watched['addresses'] = true; } - protected function fetchData() + protected function _fetchData() { - if (count($this->orig) > 0) { - $this->values = $this->orig; - return; - } // Build the addresses tree $res = XDB::query("SELECT a.adrid AS id, a.adr1, a.adr2, a.adr3, + UNIX_TIMESTAMP(a.datemaj) AS datemaj, a.postcode, a.city, a.cityid, a.region, a.regiontxt, - a.fax, a.glat, a.glng, a.datemaj, a.pub, - a.country, gp.pays AS countrytxt, gp.display, + a.pub, a.country, gp.pays AS countrytxt, gp.display, + FIND_IN_SET('coord-checked', a.statut) AS checked, FIND_IN_SET('res-secondaire', a.statut) AS secondaire, FIND_IN_SET('courrier', a.statut) AS mail, - FIND_IN_SET('temporary', a.statut) AS temporary, - FIND_IN_SET('active', a.statut) AS current + FIND_IN_SET('temporaire', a.statut) AS temporary, + FIND_IN_SET('active', a.statut) AS current, + a.glat AS precise_lat, a.glng AS precise_lon, + a.comment FROM adresses AS a - INNER JOIN geoloc_pays AS gp ON(gp.a2 = a.country) + INNER JOIN geoloc_pays AS gp ON(gp.a2 = a.country) WHERE uid = {?} AND NOT FIND_IN_SET('pro', statut) ORDER BY adrid", - S::i('uid')); - $this->values['addresses'] = $res->fetchAllAssoc(); + $this->pid()); + if ($res->numRows() == 0) { + $this->values['addresses'] = array(); + } else { + $this->values['addresses'] = $res->fetchAllAssoc(); + } - $res = XDB::iterator("SELECT adrid, tel_type AS type, tel_pub AS pub, tel - FROM tels - WHERE uid = {?} - ORDER BY adrid", - S::i('uid')); + $res = XDB::iterator("SELECT link_id AS adrid, 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()) { $adrid = $tel['adrid']; unset($tel['adrid']); - while ($this->values['addresses'][$i]['id'] < $adrid) { + while ($i < $adrNb && $this->values['addresses'][$i]['id'] < $adrid) { $i++; } + if ($i >= $adrNb) { + break; + } $address =& $this->values['addresses'][$i]; if (!isset($address['tel'])) { $address['tel'] = array(); @@ -118,19 +197,11 @@ class ProfileAddresses extends ProfilePage } } foreach ($this->values['addresses'] as $id=>&$address) { + if (!isset($address['tel'])) { + $address['tel'] = array(); + } unset($address['id']); } - parent::fetchData(); - } - - protected function saveData() - { - parent::saveData(); - } - - public function prepare(PlatalPage &$page) - { - parent::prepare($page); } }