Geoloc and other fixes

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

<?php
/***************************************************************************
 *  Copyright (C) 2003-2007 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 ProfileJob extends ProfileGeoloc
{
    private $pub;
    private $mail;
    private $web;
    private $tel;
    private $checks;

    public function __construct()
    {
        $this->pub  = new ProfilePub();
        $this->mail = new ProfileEmail();
        $this->web  = new ProfileWeb();
        $this->tel  = new ProfileTel();
        $this->checks = array('web' => array('web'),
                              'mail' => array('email'),
                              'tel' => array('tel', 'fax', 'mobile'),
                              'pub' => array('pub', 'tel_pub', 'email_pub'));
    }

    private function cleanJob(ProfilePage &$page, array &$job, &$success)
    {
        $success = true;
        foreach ($this->checks as $obj=>&$fields) {
            $chk =& $this->$obj;
            foreach ($fields as $field) {
                $job[$field] = $chk->value($page, $field, $job[$field], $s);
                if (!$s) {
                    $success = false;
                    $job[$field . '_error'] = true;
                }
            }
        }
        unset($job['removed']);
        unset($job['new']);
        unset($job['adr']['changed']);
        unset($job['adr']['parsevalid']);
        unset($job['adr']['display']);
    }

    public function value(ProfilePage &$page, $field, $value, &$success)
    {
        $init = false;
        if (is_null($value)) {
            $value = $page->values['jobs'];
            $init = true;
        }
        $success = true;
        foreach ($value as $key=>&$job) {
            if (@$job['removed'] || !trim($job['name'])) {
                unset($value[$key]);
            }
        }
        foreach ($value as $key=>&$job) {
            $ls = true;
            $this->geolocAddress($job['adr'], $s);
            $ls = ($ls && $s);
            $this->cleanJob($page, $job, $s);
            $ls = ($ls && $s);
            if (!$init) {
                $success = ($success && $ls);
            }
        }
        return $value;
    }

    public function save(ProfilePage &$page, $field, $value)
    {
        XDB::execute("DELETE FROM  entreprises
                            WHERE  uid = {?}",
                     S::i('uid'));
        $i = 0;
        foreach ($value as &$job) {
            XDB::execute("INSERT INTO  entreprises (uid, entrid, entreprise, secteur, ss_secteur,
                                                    fonction, poste, adr1, adr2, adr3, postcode,
                                                    city, cityid, country, region, regiontxt,
                                                    tel, fax, mobile, email, web,
                                                    pub, adr_pub, tel_pub, email_pub)
                               VALUES  ({?}, {?}, {?}, {?}, {?},
                                        {?}, {?}, {?}, {?}, {?}, {?},
                                        {?}, {?}, {?}, {?}, {?},
                                        {?}, {?}, {?}, {?}, {?},
                                        {?}, {?}, {?}, {?})",
                         S::i('uid'), $i++, $job['name'], $job['secteur'], $job['ss_secteur'],
                         $job['fonction'], $job['poste'], $job['adr']['adr1'], $job['adr']['adr2'], $job['adr']['adr3'],
                         $job['adr']['postcode'],
                         $job['adr']['city'], $job['adr']['cityid'], $job['adr']['country'], $job['adr']['region'], 
                         $job['adr']['regiontxt'],
                         $job['tel'], $job['fax'], $job['mobile'], $job['email'], $job['web'],
                         $job['pub'], $job['adr']['pub'], $job['tel_pub'], $job['email_pub']);
        }
    }
}

class ProfileJobs extends ProfilePage
{
    protected $pg_template = 'profile/jobs.tpl';

    public function __construct(PlWizard &$wiz)
    {
        parent::__construct($wiz);
        $this->settings['cv'] = null;
        $this->settings['jobs'] = new ProfileJob();
    }

    protected function fetchData()
    {
        if (count($this->orig) > 0) {
            $this->values = $this->orig;
            return;
        }
        // Checkout the CV
        $res = XDB::query("SELECT  cv
                             FROM  auth_user_md5
                            WHERE  user_id = {?}",
                          S::i('uid'));
        $this->values['cv'] = $res->fetchOneCell();

        // Build the jobs tree
        $res = XDB::iterRow("SELECT  e.entreprise, e.secteur, e.ss_secteur,
                                     e.fonction, e.poste, e.adr1, e.adr2, e.adr3,
                                     e.postcode, e.city, e.cityid, e.region, e.regiontxt,
                                     e.country, gp.pays, gp.display,
                                     e.tel, e.fax, e.mobile, e.email, e.web, e.pub,
                                     e.adr_pub, e.tel_pub, e.email_pub
                               FROM  entreprises AS e
                         INNER JOIN  geoloc_pays AS gp ON(gp.a2 = e.country)
                              WHERE  uid = {?} AND entreprise != ''
                           ORDER BY  entrid", S::i('uid'));
        $this->values['jobs'] = array();
        while (list($name, $secteur, $ss_secteur, $fonction, $poste,
                    $adr1, $adr2, $adr3, $postcode, $city, $cityid,
                    $region, $regiontxt, $country, $countrytxt, $display,
                    $tel, $fax, $mobile, $email, $web,
                    $pub, $adr_pub, $tel_pub, $email_pub) = $res->next()) {
            $this->values['jobs'][] = array('name'       => $name,
                                            'secteur'    => $secteur,
                                            'ss_secteur' => $ss_secteur,
                                            'fonction'   => $fonction,
                                            'poste'      => $poste,
                                            'adr'        => array('adr1'       => $adr1,
                                                                  'adr2'       => $adr2,
                                                                  'adr3'       => $adr3,
                                                                  'postcode'   => $postcode,
                                                                  'city'       => $city,
                                                                  'cityid'     => $cityid,
                                                                  'region'     => $region,
                                                                  'regiontxt'  => $regiontxt,
                                                                  'country'    => $country,
                                                                  'countrytxt' => $countrytxt,
                                                                  'display'    => $display,
                                                                  'pub'        => $adr_pub),
                                            'tel'        => $tel,
                                            'fax'        => $fax,
                                            'mobile'     => $mobile,
                                            'email'      => $email,
                                            'web'        => $web,
                                            'pub'        => $pub,
                                            'adr_pub'    => $adr_pub,
                                            'tel_pub'    => $tel_pub,
                                            'email_pub'  => $email_pub);
        }
        parent::fetchData();
    }

    protected function saveData()
    {
        if ($this->changed['cv']) {
            XDB::execute("UPDATE  auth_user_md5
                             SET  cv = {?}
                           WHERE  user_id = {?}",
                         $this->values['cv'], S::i('uid'));
        }
        parent::saveData();
    }

    public function prepare(PlatalPage &$page)
    {
        parent::prepare($page);
        $page->assign('secteurs', XDB::iterator("SELECT  id, label
                                                   FROM  emploi_secteur"));
        $page->assign('fonctions', XDB::iterator("SELECT  id, fonction_fr, FIND_IN_SET('titre', flags) AS title
                                                    FROM  fonctions_def
                                                ORDER BY  id"));
    }
}

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