Merge branch 'master' into fusionax

[platal.git] / modules / profile / addresses.inc.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2009 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

class ProfileAddress extends ProfileGeocoding
{
    private $bool;
    private $pub;

    public function __construct()
    {
        $this->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 saveTel($addrid, $telid, array &$tel)
    {
        XDB::execute("INSERT INTO  profile_phones (uid, link_type, link_id, tel_id, tel_type,
                                                   search_tel, display_tel, pub)
                           VALUES  ({?}, 'address', {?}, {?}, {?},
                                    {?}, {?}, {?})",
                     S::i('uid'), $addrid, $telid, $tel['type'],
                     format_phone_number($tel['tel']), $tel['tel'], $tel['pub']);
    }

    public function saveAddress($addrid, array &$address, $type)
    {
        require_once "geocoding.inc.php";

        $flags = new PlFlagSet();
        if ($address['current']) {
            $flags->addFlag('current');
        }
        if ($address['temporary']) {
            $flags->addFlag('temporary');
        }
        if ($address['secondary']) {
            $flags->addFlag('secondary');
        }
        if ($address['mail']) {
            $flags->addFlag('mail');
        }
        if ($address['cedex'] =
            (strpos(strtoupper(preg_replace(array("/[0-9,\"'#~:;_\- ]/", "/\r\n/"),
                                            array("", "\n"), $address['text'])), 'CEDEX')) !== false) {
            $flags->addFlag('cedex');
        }
        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({?}), {?}, {?}, {?}, {?}, {?}, {?})",
                     S::i('uid'), $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'",
                     S::i('uid'));
        XDB::execute("DELETE FROM  profile_phones
                            WHERE  uid = {?} AND link_type = 'address'",
                     S::i('uid'));
        foreach ($value as $addrid => &$address) {
            $this->saveAddress($addrid, $address, 'home');
            $profiletel = new ProfilePhones('address', $addrid);
            $profiletel->saveTels('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, UNIX_TIMESTAMP(updateTime) AS 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",
                           S::i('uid'));
        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",
                             S::i('uid'));
        $i = 0;
        $adrNb = count($this->values['addresses']);
        while ($tel = $res->next()) {
            $adrid = $tel['addrid'];
            unset($tel['addrid']);
            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();
            }
            if ($address['id'] == $adrid) {
                $address['tel'][] = $tel;
            }
        }
        foreach ($this->values['addresses'] as $id => &$address) {
            if (!isset($address['tel'])) {
                $address['tel'] = array(
                                 0 => array(
                                     'type'    => 'fixed',
                                     'tel'     => '',
                                     'pub'     => 'private',
                                     'comment' => '',
                                     )
                                 );
            }
            unset($address['id']);
            $address['changed'] = 0;
            $address['removed'] = 0;
        }
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>