[platal.git] / modules / profile / jobs.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 ProfileJob extends ProfileGeocoding
{
    private $pub;
    private $email_new;
    private $email;
    private $url;
    private $bool;
    private $checks;

    public function __construct()
    {
        $this->pub    = new ProfilePub();
        $this->email
                      = $this->email_new
                      = new ProfileEmail();
        $this->url    = new ProfileWeb();
        $this->bool   = new ProfileBool();
        $this->checks = array('url'      => array('w_url'),
                              'email'    => array('w_email'),
                              'pub'      => array('pub', 'w_email_pub'),
                             );
    }

    public function emptyJob()
    {
        return array(
            'id'               => '0',
            'jobid'            => '',
            'pub'              => 'private',
            'name'             => '',
            'hq_acronym'       => '',
            'hq_url'           => '',
            'hq_email'         => '',
            'hq_address'       => array(
                'text'                    => '',
                'accuracy'                => '',
                'postalText'              => '',
                'postalCode'              => '',
                'administrativeAreaId'    => '',
                'subAdministrativeAreaId' => '',
                'localityId'              => '',
                'countryId'               => '',
                'latitude'                => '',
                'longitude'               => '',
                'north'                   => '',
                'south'                   => '',
                'east'                    => '',
                'west'                    => '',
                'cedex'                   => '',
                'updateTime'              => '',
                'changed'                 => '0',
                'removed'                 => '0',
            ),
            'hq_phone'         => '',
            'hq_fax'           => '',
            'subSubSectorName' => null,
            'sector'           => '0',
            'subSector'        => '0',
            'subSubSector'     => '0',
            'description'      => '',
            'w_url'            => '',
            'w_address'        => array(
                'pub'                     => 'private',
                'text'                    => '',
                'accuracy'                => '',
                'postalText'              => '',
                'postalCode'              => '',
                'administrativeAreaId'    => '',
                'subAdministrativeAreaId' => '',
                'localityId'              => '',
                'countryId'               => '',
                'latitude'                => '',
                'longitude'               => '',
                'north'                   => '',
                'south'                   => '',
                'east'                    => '',
                'west'                    => '',
                'cedex'                   => '',
                'updateTime'              => '',
                'changed'                 => '0',
                'removed'                 => '0',
            ),
            'w_email'          => '',
            'w_email_pub'      => 'private',
            'w_email_new'      => '',
            'w_phone'          => array(0 => array(
                'type'    => 'fixed',
                'tel'     => '',
                'pub'     => 'private',
                'comment' => '',
            )),
        );
    }

    private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
    {
        $success = true;
        if ($job['w_email'] == "new@example.org") {
            $job['w_email'] = $job['w_email_new'];
        }
        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;
                }
            }
        }
        if (!$job['subSubSectorName']) {
            $res = XDB::query("SELECT  name
                                 FROM  profile_job_subsubsector_enum
                                WHERE  id = {?}",
                              $job['subSubSector']);
            $job['subSubSectorName'] = $res->fetchOneCell();
        } else {
            $res = XDB::query("SELECT  sectorid, subsectorid, id
                                 FROM  profile_job_subsubsector_enum
                                WHERE  name = {?}",
                              $job['subSubSectorName']);
            if ($res->numRows() != 1) {
                $success = false;
                $job['sector_error'] = true;
            } else {
                list($job['sector'], $job['subSector'], $job['subSubSector']) = $res->fetchOneRow();
            }
        }
        if ($job['name']) {
            $res = XDB::query("SELECT  id
                                 FROM  profile_job_enum
                                WHERE  name = {?}",
                              $job['name']);
            if ($res->numRows() != 1) {
                $user = S::user();
                $this->geocodeAddress($job['hq_address'], $s);
                if (!$s) {
                    $gmapsGeocoder = new GMapsGeocoder();
                    $job['hq_address'] = $gmapsGeocoder->stripGeocodingFromAddress($job['hq_address']);
                }
                $req = new EntrReq($user, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
                                   $job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
                $req->submit();
                $job['jobid'] = null;
            } else {
                $job['jobid'] = $res->fetchOneCell();
            }
        }
        $job['w_address']['pub'] = $this->pub->value($page, 'address_pub', $job['w_address']['pub'], $s);
        if (!isset($job['w_phone'])) {
            $job['w_phone'] = array();
        }
        $profiletel = new ProfilePhones('pro', $jobid);
        $job['w_phone'] = $profiletel->value($page, 'tel', $job['w_phone'], $s);

        unset($job['removed']);
        unset($job['new']);
    }

    public function value(ProfilePage &$page, $field, $value, &$success)
    {
        require_once('validations.inc.php');
        $entreprise = Validate::get_typed_requests(S::i('uid'), 'entreprise');
        $entr_val = 0;

        $init = false;
        if (is_null($value)) {
            $value = $page->values['jobs'];
            $init = true;
        }
        $success = true;
        foreach ($value as $key=>&$job) {
            $job['name'] = trim($job['name']);
            if (!$job['name'] && $entreprise) {
                $job['tmp_name'] = $entreprise[$entr_val]->name;
                $entr_val ++;
            }
            if (isset($job['removed']) && $job['removed']) {
                unset($value[$key]);
            }
        }
        foreach ($value as $key=>&$job) {
            $ls = true;
            $this->geocodeAddress($job['w_address'], $s);
            $ls = ($ls && $s);
            $this->cleanJob($page, $key, $job, $s);
            $ls = ($ls && $s);
            if (!$init) {
                $success = ($success && $ls);
            }
        }
        return $value;
    }

    public function save(ProfilePage &$page, $field, $value)
    {
        // TODO: use address and phone classes to update profile_job_enum and profile_phones once they are done.

        require_once('profil.func.inc.php');
        require_once('validations.inc.php');

        XDB::execute("DELETE FROM  profile_job
                            WHERE  uid = {?}",
                     S::i('uid'));
        XDB::execute("DELETE FROM  profile_addresses
                            WHERE  pid = {?} AND type = 'job'",
                     S::i('uid'));
        XDB::execute("DELETE FROM  profile_phones
                            WHERE  uid = {?} AND link_type = 'pro'",
                     S::i('uid'));
        foreach ($value as $id=>&$job) {
            if (isset($job['name']) && $job['name']) {
                if (isset($job['jobid']) && $job['jobid']) {
                    XDB::execute("INSERT INTO  profile_job (uid, id, description, sectorid, subsectorid,
                                                            subsubsectorid, email, url, pub, email_pub, jobid)
                                       VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
                                 S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
                                 $job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
                } else {
                    XDB::execute("INSERT INTO  profile_job (uid, id, description, sectorid, subsectorid,
                                                            subsubsectorid, email, url, pub, email_pub)
                                       VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
                                 S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
                                 $job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
                }
                $address = new ProfileAddress();
                $address->saveAddress($id, $job['w_address'], 'job');
                $profiletel = new ProfilePhones('pro', $id);
                $profiletel->saveTels('tel', $job['w_phone']);
            }
        }
    }
}

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

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

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

        // Checkout the corps
        $res = XDB::query("SELECT  original_corpsid AS original, current_corpsid AS current,
                                   rankid AS rank, corps_pub AS pub
                             FROM  profile_corps
                            WHERE  uid = {?}",
                          S::i('uid'));
        $this->values['corps'] = $res->fetchOneAssoc();

        // Build the jobs tree
        $res = XDB::iterRow("SELECT  j.id, j.jobid, je.name, j.sectorid, j.subsectorid, j.subsubsectorid,
                                     s.name, j.description, j.email, j.email_pub, j.url, j.pub,
                                     je.acronym, je.url, je.email,
                                     aw.accuracy, aw.text, aw.postalText, aw.postalCode, aw.localityId,
                                     aw.subAdministrativeAreaId, aw.administrativeAreaId, aw.countryId,
                                     aw.latitude, aw.longitude, aw.pub, aw.updateTime,
                                     aw.north, aw.south, aw.east, aw.west,
                                     ah.accuracy, ah.text, ah.postalText, ah.postalCode, ah.localityId,
                                     ah.subAdministrativeAreaId, ah.administrativeAreaId, ah.countryId,
                                     ah.latitude, ah.longitude, ah.pub, ah.updateTime,
                                     ah.north, ah.south, ah.east, ah.west
                               FROM  profile_job                   AS j
                          LEFT JOIN  profile_job_enum              AS je ON (j.jobid = je.id)
                          LEFT JOIN  profile_job_subsubsector_enum AS s  ON (s.id = j.subsubsectorid)
                          LEFT JOIN  profile_addresses             AS aw ON (aw.pid = j.uid AND aw.type = 'job'
                                                                             AND aw.id = j.id)
                          LEFT JOIN  profile_addresses             AS ah ON (ah.jobid = j.jobid AND ah.type = 'hq')
                              WHERE  j.uid = {?}
                           ORDER BY  j.id",
                            S::i('uid'));
        $this->values['jobs'] = array();

        if ($res->numRows() > 0) {
            while (list($id, $jobid, $name, $sector, $subSector, $subSubSector,
                        $subSubSectorName, $description, $w_email, $w_emailPub, $w_url, $pub,
                        $hq_acronym, $hq_url, $hq_email,
                        $w_accuracy, $w_text, $w_postalText, $w_postalCode, $w_localityId,
                        $w_subAdministrativeAreaId, $w_administrativeAreaId, $w_countryId,
                        $w_latitude, $w_longitude, $w_pub, $w_updateTime,
                        $w_north, $w_south, $w_east, $w_west,
                        $hq_accuracy, $hq_text, $hq_postalText, $hq_postalCode, $hq_localityId,
                        $hq_subAdministrativeAreaId, $hq_administrativeAreaId, $hq_countryId,
                        $hq_latitude, $hq_longitude, $hq_pub, $hq_updateTime,
                        $hq_north, $hq_south, $hq_east, $hq_west,
                       ) = $res->next()) {
                $this->values['jobs'][] = array(
                    'id'               => $id,
                    'jobid'            => $jobid,
                    'name'             => $name,
                    'sector'           => $sector,
                    'subSector'        => $subSector,
                    'subSubSector'     => $subSubSector,
                    'subSubSectorName' => $subSubSectorName,
                    'description'      => $description,
                    'pub'              => $pub,
                    'w_email'          => $w_email,
                    'w_email_pub'      => $w_emailPub,
                    'w_url'            => $w_url,
                    'hq_acronym'       => $hq_acronym,
                    'hq_url'           => $hq_url,
                    'hq_email'         => $hq_email,
                    'w_address'        => array(
                        'accuracy'                => $w_accuracy,
                        'text'                    => $w_text,
                        'postalText'              => $w_postalText,
                        'postalCode'              => $w_postalCode,
                        'localityId'              => $w_localityId,
                        'subAdministrativeAreaId' => $w_subAdministrativeAreaId,
                        'administrativeAreaId'    => $w_administrativeAreaId,
                        'countryId'               => $w_countryId,
                        'latitude'                => $w_latitude,
                        'longitude'               => $w_longitude,
                        'pub'                     => $w_pub,
                        'updateTime'              => $w_updateTime,
                        'north'                   => $w_north,
                        'south'                   => $w_south,
                        'east'                    => $w_east,
                        'west'                    => $w_west,
                    ),
                    'hq_address'       => array(
                        'accuracy'                => $hq_accuracy,
                        'text'                    => $hq_text,
                        'postalText'              => $hq_postalText,
                        'postalCode'              => $hq_postalCode,
                        'localityId'              => $hq_localityId,
                        'subAdministrativeAreaId' => $hq_subAdministrativeAreaId,
                        'administrativeAreaId'    => $hq_administrativeAreaId,
                        'countryId'               => $hq_countryId,
                        'latitude'                => $hq_latitude,
                        'longitude'               => $hq_longitude,
                        'pub'                     => $hq_pub,
                        'updateTime'              => $hq_updateTime,
                        'north'                   => $hq_north,
                        'south'                   => $hq_south,
                        'east'                    => $hq_east,
                        'west'                    => $hq_west,
                    ),
                );
            }

            $res = XDB::iterator("SELECT  link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
                                    FROM  profile_phones
                                   WHERE  uid = {?} AND link_type = 'pro'
                                ORDER BY  link_id",
                                 S::i('uid'));
            $i = 0;
            $jobNb = count($this->values['jobs']);
            while ($phone = $res->next()) {
                $jobid = $phone['jobid'];
                while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
                    $i++;
                }
                if ($i >= $jobNb) {
                    break;
                }
                $job =& $this->values['jobs'][$i];
                if (!isset($job['w_phone'])) {
                    $job['w_phone'] = array();
                }
                if ($job['id'] == $jobid) {
                    $job['w_phone'][] = $phone;
                }
            }
            foreach ($this->values['jobs'] as $id => &$job) {
                if (!isset($job['w_phone'])) {
                    $job['w_phone'] = array(
                        0 => array(
                            'type'    => 'fixed',
                            'tel'     => '',
                            'pub'     => 'private',
                            'comment' => '',
                        )
                    );
                }
            }
 
            $job['w_email_new'] = '';
            if (!isset($job['hq_phone'])) {
                $job['hq_phone'] = '';
            }
            if (!isset($job['hq_fax'])) {
                $job['hq_fax'] = '';
            }
            if (!isset($job['w_email_pub'])) {
                $job['w_email_pub'] = 'private';
            }
            if (!$job['hq_address']['text']) {
                $job['hq_address'] = array(
                    'text'                    => '',
                    'accuracy'                => '',
                    'postalText'              => '',
                    'postalCode'              => '',
                    'administrativeAreaId'    => '',
                    'subAdministrativeAreaId' => '',
                    'localityId'              => '',
                    'countryId'               => '',
                    'latitude'                => '',
                    'longitude'               => '',
                    'north'                   => '',
                    'south'                   => '',
                    'east'                    => '',
                    'west'                    => '',
                    'cedex'                   => '',
                    'updateTime'              => '',
                    'changed'                 => '0',
                    'removed'                 => '0',
                );
            }
            $job['w_address']['cedex'] = '';
            $job['w_address']['changed'] = '0';
            $job['w_address']['removed'] = '0';
        } else {
            $this->values['jobs'][] = $this->settings['jobs']->emptyJob();
        }
    }

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

        if ($this->changed['corps']) {
            XDB::execute("UPDATE  profile_corps
                             SET  original_corpsid = {?}, current_corpsid = {?},
                                  rankid = {?}, corps_pub = {?}
                           WHERE  uid = {?}",
                          $this->values['corps']['original'], $this->values['corps']['current'],
                          $this->values['corps']['rank'], $this->values['corps']['pub'], S::i('uid'));
        }
    }

    public function _prepare(PlPage &$page, $id)
    {
        require_once "emails.combobox.inc.php";
        fill_email_combobox($page);

        $res = XDB::query("SELECT  id, name AS label
                             FROM  profile_job_sector_enum");
        $page->assign('sectors', $res->fetchAllAssoc());

        $res = XDB::iterator("SELECT  id, name
                                FROM  profile_corps_enum
                            ORDER BY  id = 1 DESC, name");
        $page->assign('original_corps', $res->fetchAllAssoc());

        $res = XDB::iterator("SELECT  id, name
                                FROM  profile_corps_enum
                               WHERE  still_exists = 1
                            ORDER BY  id = 1 DESC, name");
        $page->assign('current_corps', $res->fetchAllAssoc());

        $res = XDB::iterator("SELECT  id, name
                                FROM  profile_corps_rank_enum");
        $page->assign('corps_rank', $res->fetchAllAssoc());
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
3950bc21 FB	1	<?php
3950bc21 FB	2	/***************************************************************************
8d84c630	3	* Copyright (C) 2003-2009 Polytechnique.org *
3950bc21 FB	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
73f6c165	22	class ProfileJob extends ProfileGeocoding
37d44b3b FB	23	{
37d44b3b FB	24	private $pub;
541e8d03 SJ	25	private $email_new;
	26	private $email;
	27	private $url;
f93fb300	28	private $bool;
37d44b3b FB	29	private $checks;
	30
	31	public function __construct()
	32	{
c7139c07	33	$this->pub = new ProfilePub();
541e8d03 SJ	34	$this->email
541e8d03 SJ	35	= $this->email_new
c7139c07	36	= new ProfileEmail();
541e8d03	37	$this->url = new ProfileWeb();
c7139c07	38	$this->bool = new ProfileBool();
541e8d03 SJ	39	$this->checks = array('url' => array('w_url'),
	40	'email' => array('w_email'),
	41	'pub' => array('pub', 'w_email_pub'),
	42	);
37d44b3b FB	43	}
37d44b3b FB	44
afaa2cc7 SJ	45	public function emptyJob()
	46	{
	47	return array(
	48	'id' => '0',
	49	'jobid' => '',
	50	'pub' => 'private',
	51	'name' => '',
	52	'hq_acronym' => '',
	53	'hq_url' => '',
	54	'hq_email' => '',
	55	'hq_address' => array(
	56	'text' => '',
	57	'accuracy' => '',
	58	'postalText' => '',
	59	'postalCode' => '',
	60	'administrativeAreaId' => '',
	61	'subAdministrativeAreaId' => '',
	62	'localityId' => '',
	63	'countryId' => '',
	64	'latitude' => '',
	65	'longitude' => '',
	66	'north' => '',
	67	'south' => '',
	68	'east' => '',
	69	'west' => '',
	70	'cedex' => '',
	71	'updateTime' => '',
	72	'changed' => '0',
	73	'removed' => '0',
	74	),
	75	'hq_phone' => '',
	76	'hq_fax' => '',
	77	'subSubSectorName' => null,
	78	'sector' => '0',
	79	'subSector' => '0',
	80	'subSubSector' => '0',
	81	'description' => '',
	82	'w_url' => '',
	83	'w_address' => array(
	84	'pub' => 'private',
	85	'text' => '',
	86	'accuracy' => '',
	87	'postalText' => '',
	88	'postalCode' => '',
	89	'administrativeAreaId' => '',
	90	'subAdministrativeAreaId' => '',
	91	'localityId' => '',
	92	'countryId' => '',
	93	'latitude' => '',
	94	'longitude' => '',
	95	'north' => '',
	96	'south' => '',
	97	'east' => '',
	98	'west' => '',
	99	'cedex' => '',
	100	'updateTime' => '',
	101	'changed' => '0',
	102	'removed' => '0',
	103	),
	104	'w_email' => '',
	105	'w_email_pub' => 'private',
	106	'w_email_new' => '',
	107	'w_phone' => array(0 => array(
	108	'type' => 'fixed',
109	'tel' => '',
110	'pub' => 'private',
111	'comment' => '',
112	)),
113	);
114	}
115
b814a8b8	116	private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
37d44b3b FB	117	{
37d44b3b FB	118	$success = true;
541e8d03 SJ	119	if ($job['w_email'] == "new@example.org") {
	120	$job['w_email'] = $job['w_email_new'];
	121	}
37d44b3b FB	122	foreach ($this->checks as $obj=>&$fields) {
	123	$chk =& $this->$obj;
	124	foreach ($fields as $field) {
	125	$job[$field] = $chk->value($page, $field, $job[$field], $s);
	126	if (!$s) {
	127	$success = false;
	128	$job[$field . '_error'] = true;
	129	}
	130	}
	131	}
541e8d03	132	if (!$job['subSubSectorName']) {
c7139c07 SJ	133	$res = XDB::query("SELECT name
	134	FROM profile_job_subsubsector_enum
	135	WHERE id = {?}",
541e8d03 SJ	136	$job['subSubSector']);
541e8d03 SJ	137	$job['subSubSectorName'] = $res->fetchOneCell();
c7139c07 SJ	138	} else {
	139	$res = XDB::query("SELECT sectorid, subsectorid, id
	140	FROM profile_job_subsubsector_enum
	141	WHERE name = {?}",
541e8d03	142	$job['subSubSectorName']);
c7139c07 SJ	143	if ($res->numRows() != 1) {
	144	$success = false;
	145	$job['sector_error'] = true;
	146	} else {
541e8d03	147	list($job['sector'], $job['subSector'], $job['subSubSector']) = $res->fetchOneRow();
c7139c07 SJ	148	}
c7139c07 SJ	149	}
b814a8b8	150	if ($job['name']) {
c7139c07 SJ	151	$res = XDB::query("SELECT id
	152	FROM profile_job_enum
	153	WHERE name = {?}",
	154	$job['name']);
	155	if ($res->numRows() != 1) {
b814a8b8	156	$user = S::user();
4d7d27fc SJ	157	$this->geocodeAddress($job['hq_address'], $s);
	158	if (!$s) {
	159	$gmapsGeocoder = new GMapsGeocoder();
	160	$job['hq_address'] = $gmapsGeocoder->stripGeocodingFromAddress($job['hq_address']);
	161	}
	162	$req = new EntrReq($user, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
	163	$job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
b814a8b8 SJ	164	$req->submit();
b814a8b8 SJ	165	$job['jobid'] = null;
c7139c07 SJ	166	} else {
	167	$job['jobid'] = $res->fetchOneCell();
	168	}
	169	}
541e8d03 SJ	170	$job['w_address']['pub'] = $this->pub->value($page, 'address_pub', $job['w_address']['pub'], $s);
	171	if (!isset($job['w_phone'])) {
	172	$job['w_phone'] = array();
bde2be3b GB	173	}
bde2be3b GB	174	$profiletel = new ProfilePhones('pro', $jobid);
541e8d03	175	$job['w_phone'] = $profiletel->value($page, 'tel', $job['w_phone'], $s);
afaa2cc7	176
37d44b3b FB	177	unset($job['removed']);
37d44b3b FB	178	unset($job['new']);
37d44b3b FB	179	}
	180
	181	public function value(ProfilePage &$page, $field, $value, &$success)
	182	{
b814a8b8 SJ	183	require_once('validations.inc.php');
	184	$entreprise = Validate::get_typed_requests(S::i('uid'), 'entreprise');
	185	$entr_val = 0;
	186
37d44b3b FB	187	$init = false;
	188	if (is_null($value)) {
	189	$value = $page->values['jobs'];
	190	$init = true;
	191	}
	192	$success = true;
	193	foreach ($value as $key=>&$job) {
b814a8b8	194	$job['name'] = trim($job['name']);
0345fc9d	195	if (!$job['name'] && $entreprise) {
b814a8b8 SJ	196	$job['tmp_name'] = $entreprise[$entr_val]->name;
	197	$entr_val ++;
	198	}
541e8d03	199	if (isset($job['removed']) && $job['removed']) {
37d44b3b FB	200	unset($value[$key]);
	201	}
	202	}
	203	foreach ($value as $key=>&$job) {
	204	$ls = true;
541e8d03	205	$this->geocodeAddress($job['w_address'], $s);
37d44b3b	206	$ls = ($ls && $s);
bde2be3b	207	$this->cleanJob($page, $key, $job, $s);
37d44b3b FB	208	$ls = ($ls && $s);
	209	if (!$init) {
	210	$success = ($success && $ls);
	211	}
	212	}
	213	return $value;
	214	}
	215
	216	public function save(ProfilePage &$page, $field, $value)
	217	{
ecad8a08 SJ	218	// TODO: use address and phone classes to update profile_job_enum and profile_phones once they are done.
ecad8a08 SJ	219
5e4417a9	220	require_once('profil.func.inc.php');
b814a8b8 SJ	221	require_once('validations.inc.php');
b814a8b8 SJ	222
c7139c07	223	XDB::execute("DELETE FROM profile_job
37d44b3b FB	224	WHERE uid = {?}",
37d44b3b FB	225	S::i('uid'));
541e8d03 SJ	226	XDB::execute("DELETE FROM profile_addresses
	227	WHERE pid = {?} AND type = 'job'",
	228	S::i('uid'));
b235d980	229	XDB::execute("DELETE FROM profile_phones
5e4417a9 GB	230	WHERE uid = {?} AND link_type = 'pro'",
5e4417a9 GB	231	S::i('uid'));
b814a8b8	232	foreach ($value as $id=>&$job) {
afaa2cc7 SJ	233	if (isset($job['name']) && $job['name']) {
	234	if (isset($job['jobid']) && $job['jobid']) {
	235	XDB::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
	236	subsubsectorid, email, url, pub, email_pub, jobid)
	237	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
	238	S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
	239	$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
	240	} else {
	241	XDB::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
	242	subsubsectorid, email, url, pub, email_pub)
	243	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
	244	S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
	245	$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
	246	}
	247	$address = new ProfileAddress();
	248	$address->saveAddress($id, $job['w_address'], 'job');
	249	$profiletel = new ProfilePhones('pro', $id);
	250	$profiletel->saveTels('tel', $job['w_phone']);
b814a8b8	251	}
37d44b3b FB	252	}
	253	}
	254	}
	255
3950bc21 FB	256	class ProfileJobs extends ProfilePage
	257	{
	258	protected $pg_template = 'profile/jobs.tpl';
	259
	260	public function __construct(PlWizard &$wiz)
	261	{
	262	parent::__construct($wiz);
37d44b3b	263	$this->settings['cv'] = null;
72e96bc0	264	$this->settings['corps'] = null;
37d44b3b	265	$this->settings['jobs'] = new ProfileJob();
72e96bc0	266	$this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
37d44b3b FB	267	}
37d44b3b FB	268
7c2e0f0d	269	protected function _fetchData()
37d44b3b	270	{
37d44b3b FB	271	// Checkout the CV
	272	$res = XDB::query("SELECT cv
	273	FROM auth_user_md5
	274	WHERE user_id = {?}",
	275	S::i('uid'));
	276	$this->values['cv'] = $res->fetchOneCell();
	277
72e96bc0 SJ	278	// Checkout the corps
	279	$res = XDB::query("SELECT original_corpsid AS original, current_corpsid AS current,
	280	rankid AS rank, corps_pub AS pub
	281	FROM profile_corps
	282	WHERE uid = {?}",
	283	S::i('uid'));
	284	$this->values['corps'] = $res->fetchOneAssoc();
	285
37d44b3b	286	// Build the jobs tree
563f86f5	287	$res = XDB::iterRow("SELECT j.id, j.jobid, je.name, j.sectorid, j.subsectorid, j.subsubsectorid,
541e8d03 SJ	288	s.name, j.description, j.email, j.email_pub, j.url, j.pub,
	289	je.acronym, je.url, je.email,
	290	aw.accuracy, aw.text, aw.postalText, aw.postalCode, aw.localityId,
	291	aw.subAdministrativeAreaId, aw.administrativeAreaId, aw.countryId,
	292	aw.latitude, aw.longitude, aw.pub, aw.updateTime,
	293	aw.north, aw.south, aw.east, aw.west,
	294	ah.accuracy, ah.text, ah.postalText, ah.postalCode, ah.localityId,
	295	ah.subAdministrativeAreaId, ah.administrativeAreaId, ah.countryId,
	296	ah.latitude, ah.longitude, ah.pub, ah.updateTime,
	297	ah.north, ah.south, ah.east, ah.west
c7139c07 SJ	298	FROM profile_job AS j
c7139c07 SJ	299	LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
c7139c07	300	LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
4d7d27fc SJ	301	LEFT JOIN profile_addresses AS aw ON (aw.pid = j.uid AND aw.type = 'job'
4d7d27fc SJ	302	AND aw.id = j.id)
541e8d03	303	LEFT JOIN profile_addresses AS ah ON (ah.jobid = j.jobid AND ah.type = 'hq')
c7139c07	304	WHERE j.uid = {?}
541e8d03 SJ	305	ORDER BY j.id",
541e8d03 SJ	306	S::i('uid'));
37d44b3b	307	$this->values['jobs'] = array();
bde2be3b	308
afaa2cc7 SJ	309	if ($res->numRows() > 0) {
	310	while (list($id, $jobid, $name, $sector, $subSector, $subSubSector,
	311	$subSubSectorName, $description, $w_email, $w_emailPub, $w_url, $pub,
	312	$hq_acronym, $hq_url, $hq_email,
	313	$w_accuracy, $w_text, $w_postalText, $w_postalCode, $w_localityId,
	314	$w_subAdministrativeAreaId, $w_administrativeAreaId, $w_countryId,
	315	$w_latitude, $w_longitude, $w_pub, $w_updateTime,
	316	$w_north, $w_south, $w_east, $w_west,
	317	$hq_accuracy, $hq_text, $hq_postalText, $hq_postalCode, $hq_localityId,
	318	$hq_subAdministrativeAreaId, $hq_administrativeAreaId, $hq_countryId,
	319	$hq_latitude, $hq_longitude, $hq_pub, $hq_updateTime,
	320	$hq_north, $hq_south, $hq_east, $hq_west,
	321	) = $res->next()) {
	322	$this->values['jobs'][] = array(
	323	'id' => $id,
	324	'jobid' => $jobid,
	325	'name' => $name,
	326	'sector' => $sector,
	327	'subSector' => $subSector,
	328	'subSubSector' => $subSubSector,
	329	'subSubSectorName' => $subSubSectorName,
	330	'description' => $description,
	331	'pub' => $pub,
	332	'w_email' => $w_email,
	333	'w_email_pub' => $w_emailPub,
	334	'w_url' => $w_url,
	335	'hq_acronym' => $hq_acronym,
	336	'hq_url' => $hq_url,
	337	'hq_email' => $hq_email,
	338	'w_address' => array(
	339	'accuracy' => $w_accuracy,
	340	'text' => $w_text,
	341	'postalText' => $w_postalText,
	342	'postalCode' => $w_postalCode,
	343	'localityId' => $w_localityId,
	344	'subAdministrativeAreaId' => $w_subAdministrativeAreaId,
	345	'administrativeAreaId' => $w_administrativeAreaId,
	346	'countryId' => $w_countryId,
	347	'latitude' => $w_latitude,
	348	'longitude' => $w_longitude,
	349	'pub' => $w_pub,
	350	'updateTime' => $w_updateTime,
	351	'north' => $w_north,
	352	'south' => $w_south,
	353	'east' => $w_east,
	354	'west' => $w_west,
	355	),
	356	'hq_address' => array(
	357	'accuracy' => $hq_accuracy,
	358	'text' => $hq_text,
	359	'postalText' => $hq_postalText,
	360	'postalCode' => $hq_postalCode,
	361	'localityId' => $hq_localityId,
	362	'subAdministrativeAreaId' => $hq_subAdministrativeAreaId,
	363	'administrativeAreaId' => $hq_administrativeAreaId,
	364	'countryId' => $hq_countryId,
	365	'latitude' => $hq_latitude,
	366	'longitude' => $hq_longitude,
	367	'pub' => $hq_pub,
	368	'updateTime' => $hq_updateTime,
	369	'north' => $hq_north,
	370	'south' => $hq_south,
	371	'east' => $hq_east,
	372	'west' => $hq_west,
373	),
374	);
bde2be3b	375	}
afaa2cc7 SJ	376
	377	$res = XDB::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
	378	FROM profile_phones
	379	WHERE uid = {?} AND link_type = 'pro'
	380	ORDER BY link_id",
	381	S::i('uid'));
	382	$i = 0;
	383	$jobNb = count($this->values['jobs']);
	384	while ($phone = $res->next()) {
	385	$jobid = $phone['jobid'];
	386	while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
	387	$i++;
	388	}
	389	if ($i >= $jobNb) {
	390	break;
	391	}
	392	$job =& $this->values['jobs'][$i];
	393	if (!isset($job['w_phone'])) {
	394	$job['w_phone'] = array();
	395	}
	396	if ($job['id'] == $jobid) {
	397	$job['w_phone'][] = $phone;
	398	}
	399	}
	400	foreach ($this->values['jobs'] as $id => &$job) {
	401	if (!isset($job['w_phone'])) {
	402	$job['w_phone'] = array(
	403	0 => array(
	404	'type' => 'fixed',
	405	'tel' => '',
	406	'pub' => 'private',
	407	'comment' => '',
	408	)
	409	);
	410	}
bde2be3b	411	}
afaa2cc7 SJ	412
	413	$job['w_email_new'] = '';
	414	if (!isset($job['hq_phone'])) {
	415	$job['hq_phone'] = '';
bde2be3b	416	}
afaa2cc7 SJ	417	if (!isset($job['hq_fax'])) {
afaa2cc7 SJ	418	$job['hq_fax'] = '';
bde2be3b	419	}
afaa2cc7 SJ	420	if (!isset($job['w_email_pub'])) {
afaa2cc7 SJ	421	$job['w_email_pub'] = 'private';
bde2be3b	422	}
afaa2cc7 SJ	423	if (!$job['hq_address']['text']) {
	424	$job['hq_address'] = array(
	425	'text' => '',
	426	'accuracy' => '',
	427	'postalText' => '',
	428	'postalCode' => '',
	429	'administrativeAreaId' => '',
	430	'subAdministrativeAreaId' => '',
	431	'localityId' => '',
	432	'countryId' => '',
	433	'latitude' => '',
	434	'longitude' => '',
	435	'north' => '',
	436	'south' => '',
	437	'east' => '',
	438	'west' => '',
	439	'cedex' => '',
	440	'updateTime' => '',
	441	'changed' => '0',
	442	'removed' => '0',
	443	);
	444	}
	445	$job['w_address']['cedex'] = '';
	446	$job['w_address']['changed'] = '0';
	447	$job['w_address']['removed'] = '0';
	448	} else {
	449	$this->values['jobs'][] = $this->settings['jobs']->emptyJob();
bde2be3b	450	}
37d44b3b FB	451	}
37d44b3b FB	452
7c2e0f0d	453	protected function _saveData()
37d44b3b FB	454	{
	455	if ($this->changed['cv']) {
	456	XDB::execute("UPDATE auth_user_md5
	457	SET cv = {?}
	458	WHERE user_id = {?}",
	459	$this->values['cv'], S::i('uid'));
	460	}
72e96bc0 SJ	461
	462	if ($this->changed['corps']) {
	463	XDB::execute("UPDATE profile_corps
	464	SET original_corpsid = {?}, current_corpsid = {?},
	465	rankid = {?}, corps_pub = {?}
	466	WHERE uid = {?}",
	467	$this->values['corps']['original'], $this->values['corps']['current'],
	468	$this->values['corps']['rank'], $this->values['corps']['pub'], S::i('uid'));
	469	}
3950bc21	470	}
2dcac0f5	471
04334c61	472	public function _prepare(PlPage &$page, $id)
2dcac0f5	473	{
b715c1e1 SJ	474	require_once "emails.combobox.inc.php";
	475	fill_email_combobox($page);
	476
33b6f5a0 SJ	477	$res = XDB::query("SELECT id, name AS label
33b6f5a0 SJ	478	FROM profile_job_sector_enum");
541e8d03	479	$page->assign('sectors', $res->fetchAllAssoc());
72e96bc0 SJ	480
	481	$res = XDB::iterator("SELECT id, name
	482	FROM profile_corps_enum
	483	ORDER BY id = 1 DESC, name");
	484	$page->assign('original_corps', $res->fetchAllAssoc());
	485
	486	$res = XDB::iterator("SELECT id, name
	487	FROM profile_corps_enum
	488	WHERE still_exists = 1
	489	ORDER BY id = 1 DESC, name");
	490	$page->assign('current_corps', $res->fetchAllAssoc());
	491
	492	$res = XDB::iterator("SELECT id, name
	493	FROM profile_corps_rank_enum");
	494	$page->assign('corps_rank', $res->fetchAllAssoc());
2dcac0f5	495	}
3950bc21 FB	496	}
	497
	498	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
	499	?>