<?php
/***************************************************************************
 *  Copyright (C) 2003-2010 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 EntrReq

class EntrReq extends ProfileValidate
{
    // {{{ properties

    public $id;
    public $name;
    public $acronym;
    public $url;
    public $email;
    public $holdingid;
    public $NAF_code;
    public $AX_code;

    public $tel;
    public $fax;
    public $address;

    public $suggestions;

    // }}}
    // {{{ constructor

    public function __construct(User &$_user, Profile &$_profile, $_id, $_name, $_acronym, $_url, $_email, $_tel, $_fax, $_address, $_stamp = 0)
    {
        parent::__construct($_user, $_profile, false, 'entreprise', $_stamp);
        $this->id       = $_id;
        $this->name     = $_name;
        $this->acronym  = $_acronym;
        $this->url      = $_url;
        $this->email    = $_email;
        $this->tel      = $_tel;
        $this->fax      = $_fax;
        $this->address  = $_address;

        $_name       = preg_replace('/[^0-9a-z]/i', ' ', strtolower(replace_accent($_name)));
        $name        = explode(" ", $_name);
        $name_array  = array_map("trim", $name);
        $length      = count($name_array);
        $where       = "";
        for ($i = 0; $i < $length; $i++) {
            if (strlen($name_array[$i]) > 2) {
                if ($where !== "") {
                    $where .= " OR ";
                }
                $where .= "name LIKE '%" . $name_array[$i] . "%'";
            }
        }
        if ($where != '') {
            $res = XDB::iterator('SELECT  name
                                    FROM  profile_job_enum
                                   WHERE  ' . $where);
            $this->suggestions = "| ";
            while ($sug = $res->next()) {
                $this->suggestions .= $sug['name'] . " | ";
            }
        }
    }

    // }}}
    // {{{ function formu()

    public function formu()
    {
        return 'include/form.valid.entreprises.tpl';
    }

    // }}}
    // {{{ function editor()

    public function editor()
    {
        return 'include/form.valid.edit-entreprises.tpl';
    }

    // }}}
    // {{{ function handle_editor()

    protected function handle_editor()
    {
        if (Env::has('name')) {
            $this->name = Env::t('name');
        }
        if (Env::has('acronym')) {
            $this->acronym = Env::t('acronym');
        }
        if (Env::has('url')) {
            $this->url = Env::t('url');
        }
        if (Env::has('email')) {
            $this->email = Env::t('email');
        }
        if (Env::has('holdingid')) {
            $this->holdingid = Env::i('holdingid');
        }
        if (Env::has('NAF_code')) {
            $this->NAF_code = Env::t('NAF_code');
        }
        if (Env::has('AX_code')) {
            $this->AX_code = Env::i('AX_code');
        }
        if (Env::has('address')) {
            $this->address['text'] = Env::t('address');
        }
        if (Env::has('tel')) {
            $this->tel = Env::t('tel');
        }
        if (Env::has('fax')) {
            $this->fax = Env::t('fax');
        }
        return true;
    }

    // }}}
    // {{{ function _mail_subj

    protected function _mail_subj()
    {
        return "[Polytechnique.org/Entreprises] Demande d'ajout d'une entreprise : " . $this->name;
    }

    // }}}
    // {{{ function _mail_body

    protected function _mail_body($isok)
    {
        if ($isok) {
            return "  L'entreprise " . $this->name . " vient d'être ajoutée à ta fiche.";
        } else {
            return "  La demande que tu avais faite pour l'entreprise " . $this->name .
                   " a été refusée, car elle figure déjà dans notre base.";
        }
    }

    // }}}
    // {{{ function commit()

    public function commit()
    {
        // TODO: use address and phone classes to update profile_job_enum and profile_phones once they are done.

        $res = XDB::query('SELECT  id
                             FROM  profile_job_enum
                            WHERE  name = {?}',
                          $this->name);
        if ($res->numRows() != 1) {
            require_once 'profil.func.inc.php';
            require_once 'geocoding.inc.php';

            XDB::execute('INSERT INTO  profile_job_enum (name, acronym, url, email, holdingid, NAF_code, AX_code)
                               VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
                         $this->name, $this->acronym, $this->url, $this->email,
                         $this->holdingid, $this->NAF_code, $this->AX_code);

            $jobid = XDB::insertId();
            $display_tel = format_display_number($this->tel, $error_tel);
            $display_fax = format_display_number($this->fax, $error_fax);
            XDB::execute("INSERT INTO  profile_phones (pid, link_type, link_id, tel_id, tel_type,
                                       search_tel, display_tel, pub)
                               VALUES  ({?}, 'hq', 0, 0, 'fixed', {?}, {?}, 'public'),
                                       ({?}, 'hq', 0, 1, 'fax', {?}, {?}, 'public')",
                         $jobid, format_phone_number($this->tel), $display_tel,
                         $jobid, format_phone_number($this->fax), $display_fax);

            $gmapsGeocoder = new GMapsGeocoder();
            $address = $gmapsGeocoder->getGeocodedAddress($this->address);
            Geocoder::getAreaId($address, 'administrativeArea');
            Geocoder::getAreaId($address, 'subAdministrativeArea');
            Geocoder::getAreaId($address, 'locality');
            XDB::execute("INSERT INTO  profile_addresses (jobid, type, id, accuracy,
                                                          text, postalText, postalCode, localityId,
                                                          subAdministrativeAreaId, administrativeAreaId,
                                                          countryId, latitude, longitude, updateTime,
                                                          north, south, east, west)
                               VALUES  ({?}, 'hq', 0, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?},
                                        {?}, {?}, FROM_UNIXTIME({?}), {?}, {?}, {?}, {?})",
                         $jobid, $this->address['accuracy'], $this->address['text'], $this->address['postalText'],
                         $this->address['postalCode'], $this->address['localityId'],
                         $this->address['subAdministrativeAreaId'], $this->address['administrativeAreaId'],
                         $this->address['countryId'], $this->address['latitude'], $this->address['longitude'],
                         $this->address['updateTime'], $this->address['north'], $this->address['south'],
                         $this->address['east'], $this->address['west']);
        } else {
            $jobid = $res->fetchOneCell();
        }
        XDB::execute('UPDATE  profile_job
                         SET  jobid = {?}
                       WHERE  pid = {?} AND id = {?}',
                     $jobid, $this->profile->id(), $this->id);
        if (XDB::affectedRows() == 0) {
            return XDB::execute('INSERT INTO  profile_job (jobid, pid, id)
                                      VALUES  ({?}, {?}, {?})',
                                $jobid, $this->profile->id(), $this->id);
        }
        return true;
    }

    // }}}
}

// }}}

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