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

<?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 ProfileSettingJob extends ProfileSettingGeocoding
{
    private $pub;
    private $email_new;
    private $email;
    private $url;
    private $bool;
    private $checks;

    public function __construct()
    {
        $this->pub    = new ProfileSettingPub();
        $this->email
                      = $this->email_new
                      = new ProfileSettingEmail();
        $this->url    = new ProfileSettingWeb();
        $this->bool   = new ProfileSettingBool();
        $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) {
                $this->geocodeAddress($job['hq_address'], $s);
                if (!$s) {
                    $gmapsGeocoder = new GMapsGeocoder();
                    $job['hq_address'] = $gmapsGeocoder->stripGeocodingFromAddress($job['hq_address']);
                }
                $req = new EntrReq(S::user(), $page->profile, $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 ProfileSettingPhones('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 = ProfileValidate::get_typed_requests($page->pid(), '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;
            } else if ($job['name'] == '') {
                if ($job['subSubSectorName'] == '' && $job['description'] == '' && $job['w_url'] == ''
                    && $job['w_address']['text'] == '' && $job['w_email'] == ''
                    && count($job['w_phone']) == 1 && $job['w_phone']['tel'] == '') {
                    array_splice($value, $key, 1);
                    continue;
                }

                $job['name_error'] = true;
                $success = false;
            }

            if (isset($job['removed']) && $job['removed']) {
                if ($job['name'] == '' && $entreprise) {
                    $entreprise[$entr_val - 1]->clean();
                }
                array_splice($value, $key, 1);
            }
        }
        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';

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

class ProfileSettingJobs 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 ProfileSettingJob();
        $this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
    }

    protected function _fetchData()
    {
        // Checkout the CV
        $res = XDB::query("SELECT  cv
                             FROM  profiles
                            WHERE  pid = {?}",
                          $this->pid());
        $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  pid = {?}",
                        $this->pid());
        $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.pid 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.pid = {?}
                           ORDER BY  j.id",
                            $this->pid());
        $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  pid = {?} AND link_type = 'pro'
                                ORDER BY  link_id",
                                 $this->pid());
            $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  profiles
                             SET  cv = {?}
                           WHERE  pid = {?}",
                         $this->values['cv'], $this->pid());
        }

        if ($this->changed['corps']) {
            XDB::execute('REPLACE INTO  profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
                                VALUES  ({?}, {?}, {?}, {?}, {?})',
                          $this->values['corps']['original'], $this->values['corps']['current'],
                          $this->values['corps']['rank'], $this->values['corps']['pub'], $this->pid());
        }
    }

    public function _prepare(PlPage &$page, $id)
    {
        require_once 'emails.combobox.inc.php';
        fill_email_combobox($page, $this->owner, $this->profile);

        $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
                            ORDER BY  id = 1 DESC, name");
        $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	/***************************************************************************
9f5bd98e	3	* Copyright (C) 2003-2010 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
12bcf04b	22	class ProfileSettingJob extends ProfileSettingGeocoding
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	{
12bcf04b	33	$this->pub = new ProfileSettingPub();
541e8d03 SJ	34	$this->email
541e8d03 SJ	35	= $this->email_new
12bcf04b RB	36	= new ProfileSettingEmail();
	37	$this->url = new ProfileSettingWeb();
	38	$this->bool = new ProfileSettingBool();
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) {
4d7d27fc SJ	156	$this->geocodeAddress($job['hq_address'], $s);
	157	if (!$s) {
	158	$gmapsGeocoder = new GMapsGeocoder();
	159	$job['hq_address'] = $gmapsGeocoder->stripGeocodingFromAddress($job['hq_address']);
	160	}
024ec1e5	161	$req = new EntrReq(S::user(), $page->profile, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
4d7d27fc	162	$job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
b814a8b8 SJ	163	$req->submit();
b814a8b8 SJ	164	$job['jobid'] = null;
c7139c07 SJ	165	} else {
	166	$job['jobid'] = $res->fetchOneCell();
	167	}
	168	}
541e8d03 SJ	169	$job['w_address']['pub'] = $this->pub->value($page, 'address_pub', $job['w_address']['pub'], $s);
	170	if (!isset($job['w_phone'])) {
	171	$job['w_phone'] = array();
bde2be3b	172	}
12bcf04b	173	$profiletel = new ProfileSettingPhones('pro', $jobid);
541e8d03	174	$job['w_phone'] = $profiletel->value($page, 'tel', $job['w_phone'], $s);
afaa2cc7	175
37d44b3b FB	176	unset($job['removed']);
37d44b3b FB	177	unset($job['new']);
37d44b3b FB	178	}
	179
	180	public function value(ProfilePage &$page, $field, $value, &$success)
	181	{
a6483c12	182	require_once 'validations.inc.php';
024ec1e5	183	$entreprise = ProfileValidate::get_typed_requests($page->pid(), 'entreprise');
b814a8b8 SJ	184	$entr_val = 0;
b814a8b8 SJ	185
37d44b3b FB	186	$init = false;
	187	if (is_null($value)) {
	188	$value = $page->values['jobs'];
	189	$init = true;
	190	}
	191	$success = true;
a6483c12	192	foreach ($value as $key => &$job) {
b814a8b8	193	$job['name'] = trim($job['name']);
a6483c12	194	if ($job['name'] == '' && $entreprise) {
b814a8b8	195	$job['tmp_name'] = $entreprise[$entr_val]->name;
a6483c12 SJ	196	++$entr_val;
a6483c12 SJ	197	} else if ($job['name'] == '') {
ba6ee875 SJ	198	if ($job['subSubSectorName'] == '' && $job['description'] == '' && $job['w_url'] == ''
	199	&& $job['w_address']['text'] == '' && $job['w_email'] == ''
	200	&& count($job['w_phone']) == 1 && $job['w_phone']['tel'] == '') {
	201	array_splice($value, $key, 1);
	202	continue;
	203	}
	204
a6483c12 SJ	205	$job['name_error'] = true;
a6483c12 SJ	206	$success = false;
b814a8b8	207	}
b94719c1	208
541e8d03	209	if (isset($job['removed']) && $job['removed']) {
b94719c1 SJ	210	if ($job['name'] == '' && $entreprise) {
	211	$entreprise[$entr_val - 1]->clean();
	212	}
ed01acac	213	array_splice($value, $key, 1);
37d44b3b FB	214	}
37d44b3b FB	215	}
a6483c12	216	foreach ($value as $key => &$job) {
37d44b3b	217	$ls = true;
541e8d03	218	$this->geocodeAddress($job['w_address'], $s);
37d44b3b	219	$ls = ($ls && $s);
bde2be3b	220	$this->cleanJob($page, $key, $job, $s);
37d44b3b FB	221	$ls = ($ls && $s);
	222	if (!$init) {
	223	$success = ($success && $ls);
	224	}
	225	}
	226	return $value;
	227	}
	228
	229	public function save(ProfilePage &$page, $field, $value)
	230	{
ecad8a08 SJ	231	// TODO: use address and phone classes to update profile_job_enum and profile_phones once they are done.
ecad8a08 SJ	232
a6483c12	233	require_once 'profil.func.inc.php';
b814a8b8	234
c7139c07	235	XDB::execute("DELETE FROM profile_job
ce0b2c6f	236	WHERE pid = {?}",
a6483c12	237	$page->pid());
541e8d03 SJ	238	XDB::execute("DELETE FROM profile_addresses
541e8d03 SJ	239	WHERE pid = {?} AND type = 'job'",
a6483c12	240	$page->pid());
b235d980	241	XDB::execute("DELETE FROM profile_phones
ce0b2c6f	242	WHERE pid = {?} AND link_type = 'pro'",
a6483c12 SJ	243	$page->pid());
a6483c12 SJ	244	foreach ($value as $id => &$job) {
afaa2cc7 SJ	245	if (isset($job['name']) && $job['name']) {
afaa2cc7 SJ	246	if (isset($job['jobid']) && $job['jobid']) {
ce0b2c6f	247	XDB::execute("INSERT INTO profile_job (pid, id, description, sectorid, subsectorid,
afaa2cc7 SJ	248	subsubsectorid, email, url, pub, email_pub, jobid)
afaa2cc7 SJ	249	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
a6483c12	250	$page->pid(), $id, $job['description'], $job['sector'], $job['subSector'],
afaa2cc7 SJ	251	$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
afaa2cc7 SJ	252	} else {
ce0b2c6f	253	XDB::execute("INSERT INTO profile_job (pid, id, description, sectorid, subsectorid,
afaa2cc7 SJ	254	subsubsectorid, email, url, pub, email_pub)
afaa2cc7 SJ	255	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
a6483c12	256	$page->pid(), $id, $job['description'], $job['sector'], $job['subSector'],
afaa2cc7 SJ	257	$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
afaa2cc7 SJ	258	}
12bcf04b	259	$address = new ProfileSettingAddress();
a6483c12	260	$address->saveAddress($page->pid(), $id, $job['w_address'], 'job');
12bcf04b	261	$profiletel = new ProfileSettingPhones('pro', $id);
e3164bb1	262	$profiletel->saveTels($page->pid(), 'tel', $job['w_phone']);
b814a8b8	263	}
37d44b3b FB	264	}
	265	}
	266	}
	267
12bcf04b	268	class ProfileSettingJobs extends ProfilePage
3950bc21 FB	269	{
	270	protected $pg_template = 'profile/jobs.tpl';
	271
	272	public function __construct(PlWizard &$wiz)
	273	{
	274	parent::__construct($wiz);
37d44b3b	275	$this->settings['cv'] = null;
72e96bc0	276	$this->settings['corps'] = null;
12bcf04b	277	$this->settings['jobs'] = new ProfileSettingJob();
72e96bc0	278	$this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
37d44b3b FB	279	}
37d44b3b FB	280
7c2e0f0d	281	protected function _fetchData()
37d44b3b	282	{
37d44b3b FB	283	// Checkout the CV
37d44b3b FB	284	$res = XDB::query("SELECT cv
e5bcd851 FB	285	FROM profiles
	286	WHERE pid = {?}",
	287	$this->pid());
37d44b3b FB	288	$this->values['cv'] = $res->fetchOneCell();
37d44b3b FB	289
72e96bc0 SJ	290	// Checkout the corps
	291	$res = XDB::query("SELECT original_corpsid AS original, current_corpsid AS current,
	292	rankid AS rank, corps_pub AS pub
	293	FROM profile_corps
ce0b2c6f	294	WHERE pid = {?}",
e5bcd851	295	$this->pid());
72e96bc0 SJ	296	$this->values['corps'] = $res->fetchOneAssoc();
72e96bc0 SJ	297
37d44b3b	298	// Build the jobs tree
563f86f5	299	$res = XDB::iterRow("SELECT j.id, j.jobid, je.name, j.sectorid, j.subsectorid, j.subsubsectorid,
541e8d03 SJ	300	s.name, j.description, j.email, j.email_pub, j.url, j.pub,
	301	je.acronym, je.url, je.email,
	302	aw.accuracy, aw.text, aw.postalText, aw.postalCode, aw.localityId,
	303	aw.subAdministrativeAreaId, aw.administrativeAreaId, aw.countryId,
	304	aw.latitude, aw.longitude, aw.pub, aw.updateTime,
	305	aw.north, aw.south, aw.east, aw.west,
	306	ah.accuracy, ah.text, ah.postalText, ah.postalCode, ah.localityId,
	307	ah.subAdministrativeAreaId, ah.administrativeAreaId, ah.countryId,
	308	ah.latitude, ah.longitude, ah.pub, ah.updateTime,
	309	ah.north, ah.south, ah.east, ah.west
c7139c07 SJ	310	FROM profile_job AS j
c7139c07 SJ	311	LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
c7139c07	312	LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
ce0b2c6f	313	LEFT JOIN profile_addresses AS aw ON (aw.pid = j.pid AND aw.type = 'job'
4d7d27fc	314	AND aw.id = j.id)
541e8d03	315	LEFT JOIN profile_addresses AS ah ON (ah.jobid = j.jobid AND ah.type = 'hq')
ce0b2c6f	316	WHERE j.pid = {?}
541e8d03	317	ORDER BY j.id",
a6391000	318	$this->pid());
37d44b3b	319	$this->values['jobs'] = array();
bde2be3b	320
afaa2cc7 SJ	321	if ($res->numRows() > 0) {
	322	while (list($id, $jobid, $name, $sector, $subSector, $subSubSector,
	323	$subSubSectorName, $description, $w_email, $w_emailPub, $w_url, $pub,
	324	$hq_acronym, $hq_url, $hq_email,
	325	$w_accuracy, $w_text, $w_postalText, $w_postalCode, $w_localityId,
	326	$w_subAdministrativeAreaId, $w_administrativeAreaId, $w_countryId,
	327	$w_latitude, $w_longitude, $w_pub, $w_updateTime,
	328	$w_north, $w_south, $w_east, $w_west,
	329	$hq_accuracy, $hq_text, $hq_postalText, $hq_postalCode, $hq_localityId,
	330	$hq_subAdministrativeAreaId, $hq_administrativeAreaId, $hq_countryId,
	331	$hq_latitude, $hq_longitude, $hq_pub, $hq_updateTime,
	332	$hq_north, $hq_south, $hq_east, $hq_west,
	333	) = $res->next()) {
	334	$this->values['jobs'][] = array(
	335	'id' => $id,
	336	'jobid' => $jobid,
	337	'name' => $name,
	338	'sector' => $sector,
	339	'subSector' => $subSector,
	340	'subSubSector' => $subSubSector,
	341	'subSubSectorName' => $subSubSectorName,
	342	'description' => $description,
	343	'pub' => $pub,
	344	'w_email' => $w_email,
	345	'w_email_pub' => $w_emailPub,
	346	'w_url' => $w_url,
	347	'hq_acronym' => $hq_acronym,
	348	'hq_url' => $hq_url,
	349	'hq_email' => $hq_email,
	350	'w_address' => array(
	351	'accuracy' => $w_accuracy,
	352	'text' => $w_text,
	353	'postalText' => $w_postalText,
	354	'postalCode' => $w_postalCode,
	355	'localityId' => $w_localityId,
	356	'subAdministrativeAreaId' => $w_subAdministrativeAreaId,
	357	'administrativeAreaId' => $w_administrativeAreaId,
	358	'countryId' => $w_countryId,
	359	'latitude' => $w_latitude,
	360	'longitude' => $w_longitude,
	361	'pub' => $w_pub,
	362	'updateTime' => $w_updateTime,
	363	'north' => $w_north,
	364	'south' => $w_south,
	365	'east' => $w_east,
	366	'west' => $w_west,
	367	),
	368	'hq_address' => array(
	369	'accuracy' => $hq_accuracy,
	370	'text' => $hq_text,
	371	'postalText' => $hq_postalText,
	372	'postalCode' => $hq_postalCode,
	373	'localityId' => $hq_localityId,
	374	'subAdministrativeAreaId' => $hq_subAdministrativeAreaId,
	375	'administrativeAreaId' => $hq_administrativeAreaId,
	376	'countryId' => $hq_countryId,
	377	'latitude' => $hq_latitude,
	378	'longitude' => $hq_longitude,
	379	'pub' => $hq_pub,
	380	'updateTime' => $hq_updateTime,
	381	'north' => $hq_north,
	382	'south' => $hq_south,
	383	'east' => $hq_east,
	384	'west' => $hq_west,
385	),
386	);
bde2be3b	387	}
afaa2cc7 SJ	388
	389	$res = XDB::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
	390	FROM profile_phones
ce0b2c6f	391	WHERE pid = {?} AND link_type = 'pro'
afaa2cc7	392	ORDER BY link_id",
a6483c12	393	$this->pid());
afaa2cc7 SJ	394	$i = 0;
	395	$jobNb = count($this->values['jobs']);
	396	while ($phone = $res->next()) {
	397	$jobid = $phone['jobid'];
	398	while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
	399	$i++;
	400	}
	401	if ($i >= $jobNb) {
	402	break;
	403	}
	404	$job =& $this->values['jobs'][$i];
	405	if (!isset($job['w_phone'])) {
	406	$job['w_phone'] = array();
	407	}
	408	if ($job['id'] == $jobid) {
	409	$job['w_phone'][] = $phone;
	410	}
bde2be3b	411	}
afaa2cc7 SJ	412	foreach ($this->values['jobs'] as $id => &$job) {
	413	if (!isset($job['w_phone'])) {
	414	$job['w_phone'] = array(
	415	0 => array(
	416	'type' => 'fixed',
	417	'tel' => '',
	418	'pub' => 'private',
	419	'comment' => '',
	420	)
	421	);
	422	}
bde2be3b	423	}
afaa2cc7 SJ	424
	425	$job['w_email_new'] = '';
	426	if (!isset($job['hq_phone'])) {
	427	$job['hq_phone'] = '';
bde2be3b	428	}
afaa2cc7 SJ	429	if (!isset($job['hq_fax'])) {
afaa2cc7 SJ	430	$job['hq_fax'] = '';
bde2be3b	431	}
afaa2cc7 SJ	432	if (!isset($job['w_email_pub'])) {
afaa2cc7 SJ	433	$job['w_email_pub'] = 'private';
bde2be3b	434	}
afaa2cc7 SJ	435	if (!$job['hq_address']['text']) {
	436	$job['hq_address'] = array(
	437	'text' => '',
	438	'accuracy' => '',
	439	'postalText' => '',
	440	'postalCode' => '',
	441	'administrativeAreaId' => '',
	442	'subAdministrativeAreaId' => '',
	443	'localityId' => '',
	444	'countryId' => '',
	445	'latitude' => '',
	446	'longitude' => '',
	447	'north' => '',
	448	'south' => '',
	449	'east' => '',
	450	'west' => '',
	451	'cedex' => '',
	452	'updateTime' => '',
	453	'changed' => '0',
	454	'removed' => '0',
	455	);
	456	}
	457	$job['w_address']['cedex'] = '';
	458	$job['w_address']['changed'] = '0';
	459	$job['w_address']['removed'] = '0';
	460	} else {
	461	$this->values['jobs'][] = $this->settings['jobs']->emptyJob();
bde2be3b	462	}
37d44b3b FB	463	}
37d44b3b FB	464
7c2e0f0d	465	protected function _saveData()
37d44b3b FB	466	{
37d44b3b FB	467	if ($this->changed['cv']) {
e5bcd851	468	XDB::execute("UPDATE profiles
37d44b3b	469	SET cv = {?}
e5bcd851 FB	470	WHERE pid = {?}",
e5bcd851 FB	471	$this->values['cv'], $this->pid());
37d44b3b	472	}
72e96bc0 SJ	473
72e96bc0 SJ	474	if ($this->changed['corps']) {
34d09b54 SJ	475	XDB::execute('REPLACE INTO profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
34d09b54 SJ	476	VALUES ({?}, {?}, {?}, {?}, {?})',
72e96bc0	477	$this->values['corps']['original'], $this->values['corps']['current'],
e5bcd851	478	$this->values['corps']['rank'], $this->values['corps']['pub'], $this->pid());
72e96bc0	479	}
3950bc21	480	}
2dcac0f5	481
04334c61	482	public function _prepare(PlPage &$page, $id)
2dcac0f5	483	{
a6483c12	484	require_once 'emails.combobox.inc.php';
e5bcd851	485	fill_email_combobox($page, $this->owner, $this->profile);
b715c1e1	486
33b6f5a0 SJ	487	$res = XDB::query("SELECT id, name AS label
33b6f5a0 SJ	488	FROM profile_job_sector_enum");
541e8d03	489	$page->assign('sectors', $res->fetchAllAssoc());
72e96bc0 SJ	490
	491	$res = XDB::iterator("SELECT id, name
	492	FROM profile_corps_enum
	493	ORDER BY id = 1 DESC, name");
	494	$page->assign('original_corps', $res->fetchAllAssoc());
	495
	496	$res = XDB::iterator("SELECT id, name
	497	FROM profile_corps_enum
	498	WHERE still_exists = 1
	499	ORDER BY id = 1 DESC, name");
	500	$page->assign('current_corps', $res->fetchAllAssoc());
	501
	502	$res = XDB::iterator("SELECT id, name
e489faf7 SJ	503	FROM profile_corps_rank_enum
e489faf7 SJ	504	ORDER BY id = 1 DESC, name");
72e96bc0	505	$page->assign('corps_rank', $res->fetchAllAssoc());
2dcac0f5	506	}
3950bc21 FB	507	}
	508
	509	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
	510	?>