[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_fixed'         => '',
            '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;
                sleep(1);
            } else {
                $job['jobid'] = $res->fetchOneCell();
            }
        }
        $job['w_address']['pub'] = $this->pub->value($page, 'address_pub', $job['w_address']['pub'], $s);
        $job['w_phone'] = Phone::formatFormArray($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 class to update profile_job_enum once it is done.
        XDB::execute("DELETE FROM  profile_job
                            WHERE  pid = {?}",
                     $page->pid());
        XDB::execute("DELETE FROM  profile_addresses
                            WHERE  pid = {?} AND type = 'job'",
                     $page->pid());
        Phone::deletePhones($page->pid(), Phone::LINK_JOB);
        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');
                Phone::savePhones($job['w_phone'], $page->pid(), Phone::LINK_JOB, $id);
            }
        }
    }

    public function getText($value) {
        $jobs = array();
        foreach ($value as $id => $job) {
            $address = new ProfileSettingAddress();
            $phones = Phone::formArrayToString($job['w_phone']);
            $jobs[] = 'Entreprise : ' . $job['name'] . ', secteur : ' . $job['subSubSectorName']
                    . ', description : ' . $job['description'] . ', web : ' . $job['w_url']
                    . ', email : ' . $job['w_email']
                    . ($phones ? ', ' . $phones : '') . ', ' .  $address->getText($job['w_address']);
        }
        return implode(' ; ' , $jobs);
    }
}

class ProfileSettingCorps implements ProfileSetting
{
    public function value(ProfilePage &$page, $field, $value, &$success)
    {
        $success = true;
        if (is_null($value)) {
            $res = XDB::query("SELECT  original_corpsid AS original, current_corpsid AS current,
                                       rankid AS rank, corps_pub AS pub
                                 FROM  profile_corps
                                WHERE  pid = {?}",
                            $page->pid());
            return $res->fetchOneAssoc();
        }
        return $value;
    }

    public function save(ProfilePage &$page, $field, $value)
    {
        XDB::execute('REPLACE INTO  profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
                            VALUES  ({?}, {?}, {?}, {?}, {?})',
                      $value['original'], $value['current'], $value['rank'], $value['pub'], $page->pid());
    }

    public function getText($value)
    {
        $corpsList = DirEnum::getOptions(DirEnum::CORPS);
        $rankList  = DirEnum::getOptions(DirEnum::CORPSRANKS);
        return 'Corps actuel : ' . $corpsList[$value['current']] . ' , rang : ' . $corpsList[$value['rank']]
            . ' , corps d\'origine : ' . $corpsList[$value['original']] . ' , affichage : ' . $value['pub'];
    }
}

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'] = new ProfileSettingCorps();
        $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();

        // 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,
                    ),
                );
            }

            $it = Phone::iterate(array($this->pid()), array(Phone::LINK_JOB));
            while ($phone = $it->next()) {
                $this->values['jobs'][$phone->linkId()]['w_phone'][$phone->id()] = $phone->toFormArray();
            }
            foreach ($this->values['jobs'] as $id => &$job) {
                $phone = new Phone();
                if (!isset($job['w_phone'])) {
                    $job['w_phone'] = array(0 => $phone->toFormArray());
                }
            }

            $job['w_email_new'] = '';
            if (!isset($job['hq_fixed'])) {
                $job['hq_fixed'] = '';
            }
            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());
        }
    }

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

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