modules/profile/addresses.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2009 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   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.                                    *
  10  *                                                                         *
  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.                           *
  15  *                                                                         *
  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            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 class ProfileAddress extends ProfileGeocoding
  23 {
  24     private $bool;
  25     private $pub;
  26
  27     public function __construct()
  28     {
  29         $this->bool = new ProfileBool();
  30         $this->pub  = new ProfilePub();
  31     }
  32
  33     private function cleanAddress(ProfilePage &$page, $addrid, array &$address)
  34     {
  35         if (!isset($address['tel'])) {
  36             $address['tel'] = array();
  37         }
  38         $profiletel           = new ProfilePhones('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);
  45     }
  46
  47     public function value(ProfilePage &$page, $field, $value, &$success)
  48     {
  49         $init = false;
  50         if (is_null($value)) {
  51             $value = $page->values['addresses'];
  52             $init  = true;
  53         }
  54         foreach ($value as $key => &$address) {
  55             if (isset($address['removed']) && $address['removed']) {
  56                 unset($value[$key]);
  57             }
  58         }
  59         $current = 0;
  60         $success = true;
  61         foreach ($value as $key => &$address) {
  62             if (isset($address['current']) && $address['current']) {
  63                 $current++;
  64             }
  65         }
  66         if ($current == 0 && count($value) > 0) {
  67             foreach ($value as $address) {
  68                 $address['current'] = true;
  69                 break;
  70             }
  71         } elseif ($current > 1) {
  72             $success = false;
  73         }
  74         foreach ($value as $key => &$address) {
  75             if (!trim($address['text'])) {
  76                 unset($value[$key]);
  77             } elseif (!$init) {
  78                 $this->geocodeAddress($address, $s);
  79                 $success = $success && $s;
  80             }
  81             $this->cleanAddress($page, $key, $address);
  82         }
  83         return $value;
  84     }
  85
  86     private function saveTel($addrid, $telid, array &$tel)
  87     {
  88         XDB::execute("INSERT INTO  profile_phones (uid, link_type, link_id, tel_id, tel_type,
  89                                                    search_tel, display_tel, pub)
  90                            VALUES  ({?}, 'address', {?}, {?}, {?},
  91                                     {?}, {?}, {?})",
  92                      S::i('uid'), $addrid, $telid, $tel['type'],
  93                      format_phone_number($tel['tel']), $tel['tel'], $tel['pub']);
  94     }
  95
  96     public function saveAddress($addrid, array &$address, $type)
  97     {
  98         require_once "geocoding.inc.php";
  99
 100         $flags = new PlFlagSet();
 101         if ($address['current']) {
 102             $flags->addFlag('current');
 103         }
 104         if ($address['temporary']) {
 105             $flags->addFlag('temporary');
 106         }
 107         if ($address['secondary']) {
 108             $flags->addFlag('secondary');
 109         }
 110         if ($address['mail']) {
 111             $flags->addFlag('mail');
 112         }
 113         if ($address['cedex'] =
 114             (strpos(strtoupper(preg_replace(array("/[0-9,\"'#~:;_\- ]/", "/\r\n/"),
 115                                             array("", "\n"), $address['text'])), 'CEDEX')) !== false) {
 116             $flags->addFlag('cedex');
 117         }
 118         Geocoder::getAreaId($address, "administrativeArea");
 119         Geocoder::getAreaId($address, "subAdministrativeArea");
 120         Geocoder::getAreaId($address, "locality");
 121         XDB::execute("INSERT INTO  profile_addresses (pid, type, id, flags, accuracy,
 122                                                       text, postalText, postalCode, localityId,
 123                                                       subAdministrativeAreaId, administrativeAreaId,
 124                                                       countryId, latitude, longitude, updateTime, pub, comment,
 125                                                       north, south, east, west)
 126                            VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?},
 127                                     {?}, {?}, FROM_UNIXTIME({?}), {?}, {?}, {?}, {?}, {?}, {?})",
 128                      S::i('uid'), $type, $addrid, $flags, $address['accuracy'],
 129                      $address['text'], $address['postalText'], $address['postalCode'], $address['localityId'],
 130                      $address['subAdministrativeAreaId'], $address['administrativeAreaId'],
 131                      $address['countryId'], $address['latitude'], $address['longitude'],
 132                      $address['updateTime'], $address['pub'], $address['comment'],
 133                      $address['north'], $address['south'], $address['east'], $address['west']);
 134     }
 135
 136     public function save(ProfilePage &$page, $field, $value)
 137     {
 138         XDB::execute("DELETE FROM  profile_addresses
 139                             WHERE  pid = {?} AND type = 'home'",
 140                      S::i('uid'));
 141         XDB::execute("DELETE FROM  profile_phones
 142                             WHERE  uid = {?} AND link_type = 'address'",
 143                      S::i('uid'));
 144         foreach ($value as $addrid => &$address) {
 145             $this->saveAddress($addrid, $address, 'home');
 146             $profiletel = new ProfilePhones('address', $addrid);
 147             $profiletel->saveTels('tel', $address['tel']);
 148         }
 149     }
 150 }
 151
 152 class ProfileAddresses extends ProfilePage
 153 {
 154     protected $pg_template = 'profile/adresses.tpl';
 155
 156     public function __construct(PlWizard &$wiz)
 157     {
 158         parent::__construct($wiz);
 159         $this->settings['addresses'] = new ProfileAddress();
 160         $this->watched['addresses']  = true;
 161     }
 162
 163     protected function _fetchData()
 164     {
 165         $res = XDB::query("SELECT  id, accuracy, text, postalText,
 166                                    postalCode, localityId, subAdministrativeAreaId, administrativeAreaId,
 167                                    countryId, latitude, longitude, pub, comment, UNIX_TIMESTAMP(updateTime) AS updateTime,
 168                                    north, south, east, west,
 169                                    FIND_IN_SET('current', flags) AS current,
 170                                    FIND_IN_SET('temporary', flags) AS temporary,
 171                                    FIND_IN_SET('secondary', flags) AS secondary,
 172                                    FIND_IN_SET('mail', flags) AS mail,
 173                                    FIND_IN_SET('cedex', flags) AS cedex
 174                              FROM  profile_addresses
 175                             WHERE  pid = {?} AND type = 'home'
 176                          ORDER BY  id",
 177                            S::i('uid'));
 178         if ($res->numRows() == 0) {
 179             $this->values['addresses'] = array();
 180         } else {
 181             $this->values['addresses'] = $res->fetchAllAssoc();
 182         }
 183
 184         $res = XDB::iterator("SELECT  link_id AS addrid, tel_type AS type, pub, display_tel AS tel, comment
 185                                 FROM  profile_phones
 186                                WHERE  uid = {?} AND link_type = 'address'
 187                             ORDER BY  link_id",
 188                              S::i('uid'));
 189         $i = 0;
 190         $adrNb = count($this->values['addresses']);
 191         while ($tel = $res->next()) {
 192             $adrid = $tel['addrid'];
 193             unset($tel['addrid']);
 194             while ($i < $adrNb && $this->values['addresses'][$i]['id'] < $adrid) {
 195                 $i++;
 196             }
 197             if ($i >= $adrNb) {
 198                 break;
 199             }
 200             $address =& $this->values['addresses'][$i];
 201             if (!isset($address['tel'])) {
 202                 $address['tel'] = array();
 203             }
 204             if ($address['id'] == $adrid) {
 205                 $address['tel'][] = $tel;
 206             }
 207         }
 208         foreach ($this->values['addresses'] as $id => &$address) {
 209             if (!isset($address['tel'])) {
 210                 $address['tel'] = array(
 211                                  0 => array(
 212                                      'type'    => 'fixed',
 213                                      'tel'     => '',
 214                                      'pub'     => 'private',
 215                                      'comment' => '',
 216                                      )
 217                                  );
 218             }
 219             unset($address['id']);
 220             $address['changed'] = 0;
 221             $address['removed'] = 0;
 222         }
 223     }
 224 }
 225
 226 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 227 ?>