[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 implements ProfileSetting
{
    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'),
                             );
    }

    private function emptyJob()
    {
        $address = new Address();
        $phone = new Phone();
        return array(
            'id'               => '0',
            'jobid'            => '',
            'pub'              => 'private',
            'name'             => '',
            'description'      => '',
            'w_url'            => '',
            'w_address'        => $address->toFormArray(),
            'w_email'          => '',
            'w_email_pub'      => 'private',
            'w_email_new'      => '',
            'w_phone'          => array(0 => $phone->toFormArray()),
            'terms'            => array()
        );
    }

    private function fetchJobs(ProfilePage $page)
    {
        // Build the jobs tree
        $jobs  = XDB::fetchAllAssoc('SELECT  j.id, j.jobid, je.name,
                                             j.description, j.email AS w_email,
                                             j.email_pub AS w_email_pub,
                                             j.url AS w_url, j.pub
                                       FROM  profile_job      AS j
                                  LEFT JOIN  profile_job_enum AS je ON (j.jobid = je.id)
                                      WHERE  j.pid = {?}
                                   ORDER BY  j.id',
                                    $page->pid());

        if (empty($jobs)) {
            return array($this->emptyJob());
        }

        $compagnies = array();
        $backtrack = array();
        foreach ($jobs as $key=>$job) {
            $compagnies[] = $job['jobid'];
            $backtrack[$job['id']] = $key;
        }

        $it = Address::iterate(array($page->pid()), array(Address::LINK_JOB));
        while ($address = $it->next()) {
            $jobs[$address->id]['w_address'] = $address->toFormArray();
        }
        $it = Phone::iterate(array($page->pid()), array(Phone::LINK_JOB));
        while ($phone = $it->next()) {
            $jobs[$phone->linkId()]['w_phone'][$phone->id()] = $phone->toFormArray();
        }
        $res = XDB::iterator("SELECT  e.jtid, e.full_name, j.jid
                                FROM  profile_job_term_enum AS e
                          INNER JOIN  profile_job_term AS j USING(jtid)
                               WHERE  pid = {?}
                            ORDER BY  j.jid",
                             $page->pid());
        while ($term = $res->next()) {
            // $jid is the ID of the job among this user's jobs
            $jid = $term['jid'];
            if (!isset($backtrack[$jid])) {
                continue;
            }
            $job =& $jobs[$backtrack[$jid]];
            if (!isset($job['terms'])) {
                $job['terms'] = array();
            }
            $job['terms'][] = $term;
        }

        $phone = new Phone();
        $address = new Address();
        foreach ($jobs as $id => &$job) {
            if (!isset($job['w_phone'])) {
                $job['w_phone'] = array(0 => $phone->toFormArray());
            }
            if (!isset($job['w_address'])) {
                $job['w_address'] = $address->toFormArray();
            }

            $job['w_email_new'] = '';
            if (!isset($job['w_email_pub'])) {
                $job['w_email_pub'] = 'private';
            }
        }
        return $jobs;
    }

    private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
    {
        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 (count($job['terms'])) {
            $termsid = array();
            foreach ($job['terms'] as $term) {
                if (!$term['full_name']) {
                    $termsid[] = $term['jtid'];
                }
            }
            if (count($termsid)) {
                $res = XDB::query("SELECT  jtid, full_name
                                    FROM  profile_job_term_enum
                                   WHERE  jtid IN {?}",
                                 $termsid);
                $term_id_to_name = $res->fetchAllAssoc('jtid', false);
                foreach ($job['terms'] as &$term) {
                    if (!$term['full_name']) {
                        $term['full_name'] = $term_id_to_name[$term['jtid']];
                    }
                }
            }
        }
        if ($job['name']) {
            $res = XDB::query("SELECT  id
                                 FROM  profile_job_enum
                                WHERE  name = {?}",
                              $job['name']);
            if ($res->numRows() != 1) {
                $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_phone'] = Phone::formatFormArray($job['w_phone'], $s);

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


    public function value(ProfilePage &$page, $field, $value, &$success)
    {
        $entreprise = ProfileValidate::get_typed_requests($page->pid(), 'entreprise');
        $entr_val = 0;

        $init = false;
        if (is_null($value)) {
            $value = $this->fetchJobs($page);
            $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['description'] == '' && $job['w_url'] == ''
                    && $job['w_address']['text'] == '' && $job['w_email'] == ''
                    && count($job['w_phone']) >= 1 && $job['w_phone'][0]['display'] == '') {
                    unset($value[$key]);
                    continue;
                }

                if (!$init) {
                    $job['name_error'] = true;
                    $success = false;
                }
            }

            if (isset($job['removed']) && $job['removed']) {
                if ($job['name'] == '' && $entreprise) {
                    $entreprise[$entr_val - 1]->clean();
                }
                unset($value[$key]);
                continue;
            }
            if (!isset($job['pub']) || !$job['pub']) {
                $job['pub'] = 'private';
            }
            $value[$key] = $job;
        }
        foreach ($value as $key => &$job) {
            $address = new Address($job['w_address']);
            $s = $address->format();
            $job['w_address'] = $address->toFormArray();
            $this->cleanJob($page, $key, $job, $s);
            if (!$init) {
                $success = ($success && $s);
            }
        }
        return $value;
    }

    public function save(ProfilePage &$page, $field, $value)
    {
        XDB::execute("DELETE FROM  profile_job
                            WHERE  pid = {?}",
                     $page->pid());
        XDB::execute("DELETE FROM  profile_job_term
                            WHERE  pid = {?}",
                     $page->pid());
        Address::deleteAddresses($page->pid(), Address::LINK_JOB);
        Phone::deletePhones($page->pid(), Phone::LINK_JOB);
        $terms_values = array();
        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, email,
                                                            url, pub, email_pub, jobid)
                                       VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
                                 $page->pid(), $id, $job['description'], $job['w_email'],
                                 $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
                } else {
                    XDB::execute('INSERT INTO  profile_job (pid, id, description, email,
                                                            url, pub, email_pub)
                                       VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
                                 $page->pid(), $id, $job['description'], $job['w_email'],
                                 $job['w_url'], $job['pub'], $job['w_email_pub']);
                }
                $address = new Address(array_merge($job['w_address'],
                                                   array('pid' => $page->pid(),
                                                         'id' => $id,
                                                         'type' => Address::LINK_JOB)));
                $address->save();
                Phone::savePhones($job['w_phone'], $page->pid(), Phone::LINK_JOB, $id);
                if (isset($job['terms'])) {
                    foreach ($job['terms'] as $term) {
                        $terms_values[] = XDB::format('({?}, {?}, {?}, {?})',
                                                      $page->pid(), $id, $term['jtid'], "original");
                    }
                }
            }
        }
        if (count($terms_values) > 0) {
            XDB::rawExecute('INSERT INTO  profile_job_term (pid, jid, jtid, computed)
                                  VALUES  ' . implode(', ', $terms_values) . '
                 ON DUPLICATE KEY UPDATE  computed = VALUES(computed)');
        }
    }

    public function getText($value)
    {
        $jobs = array();
        foreach ($value as $id => $job) {
            $address = Address::formArrayToString(array($job['w_address']));
            $phones = Phone::formArrayToString($job['w_phone']);
            // TODO: add jobterms here.
            $jobs[] = 'Entreprise : ' . $job['name']
                    . ', description : ' . $job['description'] . ', web : ' . $job['w_url']
                    . ', email : ' . $job['w_email']
                    . ($phones ? ', ' . $phones : '') . ($address ? ', ' . $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  c.original_corpsid AS original, e.name AS originalText,
                                       c.current_corpsid AS current, c.rankid AS rank, c.corps_pub AS pub
                                 FROM  profile_corps      AS c
                           INNER JOIN  profile_corps_enum AS e ON (c.original_corpsid = e.id)
                                WHERE  c.pid = {?}',
                            $page->pid());
            return $res->fetchOneAssoc();
        }
        return $value;
    }

    public function save(ProfilePage &$page, $field, $value)
    {
        if (!S::user()->isMe($page->owner)) {
            XDB::execute('INSERT INTO  profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
                               VALUES  ({?}, {?}, {?}, {?}, {?})
              ON DUPLICATE KEY UPDATE  original_corpsid = VALUES(original_corpsid), current_corpsid = VALUES(current_corpsid),
                                       rankid = VALUES(rankid), corps_pub = VALUES(corps_pub)',
                          $value['original'], $value['current'], $value['rank'], $value['pub'], $page->pid());
        } else {
            XDB::execute('INSERT INTO  profile_corps (current_corpsid, rankid, corps_pub, pid)
                               VALUES  ({?}, {?}, {?}, {?})
              ON DUPLICATE KEY UPDATE  current_corpsid = VALUES(current_corpsid),
                                       rankid = VALUES(rankid), corps_pub = VALUES(corps_pub)',
                          $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 ProfilePageJobs extends ProfilePage
{
    protected $pg_template = 'profile/jobs.tpl';

    public function __construct(PlWizard &$wiz)
    {
        parent::__construct($wiz);
        if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
            $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()
    {
        if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
            // Checkout the CV
            $res = XDB::query("SELECT  cv
                                 FROM  profiles
                                WHERE  pid = {?}",
                              $this->pid());
            $this->values['cv'] = $res->fetchOneCell();
        }
    }

    protected function _saveData()
    {
        if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
            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);

        if (!S::user()->isMe($page->owner)) {
            $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
eb54852e	22	class ProfileSettingJob implements ProfileSetting
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
237f662f	45	private function emptyJob()
afaa2cc7	46	{
eb54852e	47	$address = new Address();
972fd3c5	48	$phone = new Phone();
afaa2cc7 SJ	49	return array(
	50	'id' => '0',
	51	'jobid' => '',
	52	'pub' => 'private',
	53	'name' => '',
afaa2cc7 SJ	54	'description' => '',
afaa2cc7 SJ	55	'w_url' => '',
eb54852e	56	'w_address' => $address->toFormArray(),
afaa2cc7 SJ	57	'w_email' => '',
	58	'w_email_pub' => 'private',
	59	'w_email_new' => '',
972fd3c5 SJ	60	'w_phone' => array(0 => $phone->toFormArray()),
972fd3c5 SJ	61	'terms' => array()
afaa2cc7 SJ	62	);
	63	}
	64
237f662f FB	65	private function fetchJobs(ProfilePage $page)
	66	{
	67	// Build the jobs tree
	68	$jobs = XDB::fetchAllAssoc('SELECT j.id, j.jobid, je.name,
	69	j.description, j.email AS w_email,
	70	j.email_pub AS w_email_pub,
	71	j.url AS w_url, j.pub
	72	FROM profile_job AS j
	73	LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
	74	WHERE j.pid = {?}
	75	ORDER BY j.id',
	76	$page->pid());
	77
	78	if (empty($jobs)) {
	79	return array($this->emptyJob());
	80	}
	81
	82	$compagnies = array();
	83	$backtrack = array();
	84	foreach ($jobs as $key=>$job) {
	85	$compagnies[] = $job['jobid'];
1a0064e8	86	$backtrack[$job['id']] = $key;
237f662f FB	87	}
	88
	89	$it = Address::iterate(array($page->pid()), array(Address::LINK_JOB));
	90	while ($address = $it->next()) {
10a574ea	91	$jobs[$address->id]['w_address'] = $address->toFormArray();
237f662f FB	92	}
	93	$it = Phone::iterate(array($page->pid()), array(Phone::LINK_JOB));
	94	while ($phone = $it->next()) {
	95	$jobs[$phone->linkId()]['w_phone'][$phone->id()] = $phone->toFormArray();
	96	}
1a0064e8	97	$res = XDB::iterator("SELECT e.jtid, e.full_name, j.jid
237f662f FB	98	FROM profile_job_term_enum AS e
	99	INNER JOIN profile_job_term AS j USING(jtid)
	100	WHERE pid = {?}
	101	ORDER BY j.jid",
	102	$page->pid());
	103	while ($term = $res->next()) {
1a0064e8 RB	104	// $jid is the ID of the job among this user's jobs
	105	$jid = $term['jid'];
	106	if (!isset($backtrack[$jid])) {
237f662f FB	107	continue;
237f662f FB	108	}
1a0064e8	109	$job =& $jobs[$backtrack[$jid]];
237f662f FB	110	if (!isset($job['terms'])) {
	111	$job['terms'] = array();
	112	}
	113	$job['terms'][] = $term;
	114	}
	115
	116	$phone = new Phone();
	117	$address = new Address();
	118	foreach ($jobs as $id => &$job) {
	119	if (!isset($job['w_phone'])) {
	120	$job['w_phone'] = array(0 => $phone->toFormArray());
	121	}
	122	if (!isset($job['w_address'])) {
	123	$job['w_address'] = $address->toFormArray();
	124	}
	125
	126	$job['w_email_new'] = '';
	127	if (!isset($job['w_email_pub'])) {
	128	$job['w_email_pub'] = 'private';
	129	}
	130	}
	131	return $jobs;
	132	}
	133
b814a8b8	134	private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
37d44b3b	135	{
541e8d03 SJ	136	if ($job['w_email'] == "new@example.org") {
	137	$job['w_email'] = $job['w_email_new'];
	138	}
37d44b3b FB	139	foreach ($this->checks as $obj=>&$fields) {
	140	$chk =& $this->$obj;
	141	foreach ($fields as $field) {
	142	$job[$field] = $chk->value($page, $field, $job[$field], $s);
	143	if (!$s) {
	144	$success = false;
	145	$job[$field . '_error'] = true;
	146	}
	147	}
	148	}
3ac45f10 PC	149	if (count($job['terms'])) {
	150	$termsid = array();
	151	foreach ($job['terms'] as $term) {
	152	if (!$term['full_name']) {
	153	$termsid[] = $term['jtid'];
	154	}
	155	}
	156	if (count($termsid)) {
	157	$res = XDB::query("SELECT jtid, full_name
	158	FROM profile_job_term_enum
	159	WHERE jtid IN {?}",
	160	$termsid);
	161	$term_id_to_name = $res->fetchAllAssoc('jtid', false);
	162	foreach ($job['terms'] as &$term) {
	163	if (!$term['full_name']) {
	164	$term['full_name'] = $term_id_to_name[$term['jtid']];
	165	}
	166	}
	167	}
	168	}
b814a8b8	169	if ($job['name']) {
c7139c07 SJ	170	$res = XDB::query("SELECT id
	171	FROM profile_job_enum
	172	WHERE name = {?}",
	173	$job['name']);
	174	if ($res->numRows() != 1) {
024ec1e5	175	$req = new EntrReq(S::user(), $page->profile, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
4d7d27fc	176	$job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
b814a8b8 SJ	177	$req->submit();
b814a8b8 SJ	178	$job['jobid'] = null;
858a5b42	179	sleep(1);
c7139c07 SJ	180	} else {
	181	$job['jobid'] = $res->fetchOneCell();
	182	}
	183	}
0b6c8b36	184	$job['w_phone'] = Phone::formatFormArray($job['w_phone'], $s);
afaa2cc7	185
37d44b3b FB	186	unset($job['removed']);
37d44b3b FB	187	unset($job['new']);
37d44b3b FB	188	}
37d44b3b FB	189
237f662f FB	190
237f662f FB	191
37d44b3b FB	192	public function value(ProfilePage &$page, $field, $value, &$success)
37d44b3b FB	193	{
024ec1e5	194	$entreprise = ProfileValidate::get_typed_requests($page->pid(), 'entreprise');
b814a8b8 SJ	195	$entr_val = 0;
b814a8b8 SJ	196
37d44b3b FB	197	$init = false;
37d44b3b FB	198	if (is_null($value)) {
237f662f	199	$value = $this->fetchJobs($page);
37d44b3b FB	200	$init = true;
	201	}
	202	$success = true;
237f662f	203	foreach ($value as $key => $job) {
b814a8b8	204	$job['name'] = trim($job['name']);
a6483c12	205	if ($job['name'] == '' && $entreprise) {
b814a8b8	206	$job['tmp_name'] = $entreprise[$entr_val]->name;
a6483c12 SJ	207	++$entr_val;
a6483c12 SJ	208	} else if ($job['name'] == '') {
ea9cfc3e	209	if ($job['description'] == '' && $job['w_url'] == ''
ba6ee875	210	&& $job['w_address']['text'] == '' && $job['w_email'] == ''
cbbf5ac9	211	&& count($job['w_phone']) >= 1 && $job['w_phone'][0]['display'] == '') {
237f662f	212	unset($value[$key]);
ba6ee875 SJ	213	continue;
	214	}
	215
d1d01361 SJ	216	if (!$init) {
	217	$job['name_error'] = true;
	218	$success = false;
	219	}
b814a8b8	220	}
b94719c1	221
541e8d03	222	if (isset($job['removed']) && $job['removed']) {
b94719c1 SJ	223	if ($job['name'] == '' && $entreprise) {
	224	$entreprise[$entr_val - 1]->clean();
	225	}
237f662f FB	226	unset($value[$key]);
237f662f FB	227	continue;
37d44b3b	228	}
0fc3d4a7 FB	229	if (!isset($job['pub']) \|\| !$job['pub']) {
	230	$job['pub'] = 'private';
	231	}
237f662f	232	$value[$key] = $job;
37d44b3b	233	}
a6483c12	234	foreach ($value as $key => &$job) {
eb54852e SJ	235	$address = new Address($job['w_address']);
	236	$s = $address->format();
	237	$job['w_address'] = $address->toFormArray();
bde2be3b	238	$this->cleanJob($page, $key, $job, $s);
37d44b3b	239	if (!$init) {
eb54852e	240	$success = ($success && $s);
37d44b3b FB	241	}
	242	}
	243	return $value;
	244	}
	245
	246	public function save(ProfilePage &$page, $field, $value)
	247	{
c7139c07	248	XDB::execute("DELETE FROM profile_job
ce0b2c6f	249	WHERE pid = {?}",
a6483c12	250	$page->pid());
237f662f FB	251	XDB::execute("DELETE FROM profile_job_term
	252	WHERE pid = {?}",
	253	$page->pid());
781a24bc	254	Address::deleteAddresses($page->pid(), Address::LINK_JOB);
0b6c8b36	255	Phone::deletePhones($page->pid(), Phone::LINK_JOB);
3ac45f10	256	$terms_values = array();
a6483c12	257	foreach ($value as $id => &$job) {
afaa2cc7 SJ	258	if (isset($job['name']) && $job['name']) {
afaa2cc7 SJ	259	if (isset($job['jobid']) && $job['jobid']) {
237f662f FB	260	XDB::execute('INSERT INTO profile_job (pid, id, description, email,
237f662f FB	261	url, pub, email_pub, jobid)
ea9cfc3e	262	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
237f662f FB	263	$page->pid(), $id, $job['description'], $job['w_email'],
237f662f FB	264	$job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
afaa2cc7	265	} else {
237f662f FB	266	XDB::execute('INSERT INTO profile_job (pid, id, description, email,
237f662f FB	267	url, pub, email_pub)
ea9cfc3e	268	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
237f662f FB	269	$page->pid(), $id, $job['description'], $job['w_email'],
237f662f FB	270	$job['w_url'], $job['pub'], $job['w_email_pub']);
afaa2cc7	271	}
237f662f FB	272	$address = new Address(array_merge($job['w_address'],
	273	array('pid' => $page->pid(),
	274	'id' => $id,
	275	'type' => Address::LINK_JOB)));
eb54852e	276	$address->save();
0b6c8b36	277	Phone::savePhones($job['w_phone'], $page->pid(), Phone::LINK_JOB, $id);
3ac45f10 PC	278	if (isset($job['terms'])) {
3ac45f10 PC	279	foreach ($job['terms'] as $term) {
237f662f FB	280	$terms_values[] = XDB::format('({?}, {?}, {?}, {?})',
237f662f FB	281	$page->pid(), $id, $term['jtid'], "original");
3ac45f10 PC	282	}
3ac45f10 PC	283	}
b814a8b8	284	}
37d44b3b	285	}
3ac45f10	286	if (count($terms_values) > 0) {
00ba8a74 SJ	287	XDB::rawExecute('INSERT INTO profile_job_term (pid, jid, jtid, computed)
	288	VALUES ' . implode(', ', $terms_values) . '
	289	ON DUPLICATE KEY UPDATE computed = VALUES(computed)');
3ac45f10	290	}
37d44b3b	291	}
a0fce0c6	292
4dbd6184 FB	293	public function getText($value)
4dbd6184 FB	294	{
a0fce0c6 SJ	295	$jobs = array();
a0fce0c6 SJ	296	foreach ($value as $id => $job) {
4dbd6184	297	$address = Address::formArrayToString(array($job['w_address']));
0b6c8b36	298	$phones = Phone::formArrayToString($job['w_phone']);
ea9cfc3e SJ	299	// TODO: add jobterms here.
ea9cfc3e SJ	300	$jobs[] = 'Entreprise : ' . $job['name']
a0fce0c6 SJ	301	. ', description : ' . $job['description'] . ', web : ' . $job['w_url']
a0fce0c6 SJ	302	. ', email : ' . $job['w_email']
eb54852e	303	. ($phones ? ', ' . $phones : '') . ($address ? ', ' . $address : '');
a0fce0c6 SJ	304	}
	305	return implode(' ; ' , $jobs);
	306	}
37d44b3b FB	307	}
37d44b3b FB	308
603aeb6c SJ	309	class ProfileSettingCorps implements ProfileSetting
	310	{
	311	public function value(ProfilePage &$page, $field, $value, &$success)
	312	{
	313	$success = true;
	314	if (is_null($value)) {
8c5f91c4 SJ	315	$res = XDB::query('SELECT c.original_corpsid AS original, e.name AS originalText,
	316	c.current_corpsid AS current, c.rankid AS rank, c.corps_pub AS pub
	317	FROM profile_corps AS c
	318	INNER JOIN profile_corps_enum AS e ON (c.original_corpsid = e.id)
	319	WHERE c.pid = {?}',
603aeb6c SJ	320	$page->pid());
	321	return $res->fetchOneAssoc();
	322	}
	323	return $value;
	324	}
	325
	326	public function save(ProfilePage &$page, $field, $value)
	327	{
8c5f91c4 SJ	328	if (!S::user()->isMe($page->owner)) {
	329	XDB::execute('INSERT INTO profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
	330	VALUES ({?}, {?}, {?}, {?}, {?})
	331	ON DUPLICATE KEY UPDATE original_corpsid = VALUES(original_corpsid), current_corpsid = VALUES(current_corpsid),
	332	rankid = VALUES(rankid), corps_pub = VALUES(corps_pub)',
	333	$value['original'], $value['current'], $value['rank'], $value['pub'], $page->pid());
	334	} else {
	335	XDB::execute('INSERT INTO profile_corps (current_corpsid, rankid, corps_pub, pid)
	336	VALUES ({?}, {?}, {?}, {?})
	337	ON DUPLICATE KEY UPDATE current_corpsid = VALUES(current_corpsid),
	338	rankid = VALUES(rankid), corps_pub = VALUES(corps_pub)',
	339	$value['current'], $value['rank'], $value['pub'], $page->pid());
	340	}
603aeb6c SJ	341	}
	342
	343	public function getText($value)
	344	{
	345	$corpsList = DirEnum::getOptions(DirEnum::CORPS);
	346	$rankList = DirEnum::getOptions(DirEnum::CORPSRANKS);
	347	return 'Corps actuel : ' . $corpsList[$value['current']] . ' , rang : ' . $corpsList[$value['rank']]
	348	. ' , corps d\'origine : ' . $corpsList[$value['original']] . ' , affichage : ' . $value['pub'];
	349	}
	350	}
	351
66c4bdaf	352	class ProfilePageJobs extends ProfilePage
3950bc21 FB	353	{
	354	protected $pg_template = 'profile/jobs.tpl';
	355
	356	public function __construct(PlWizard &$wiz)
	357	{
	358	parent::__construct($wiz);
b539d596 FB	359	if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
	360	$this->settings['cv'] = null;
	361	}
603aeb6c	362	$this->settings['corps'] = new ProfileSettingCorps();
12bcf04b	363	$this->settings['jobs'] = new ProfileSettingJob();
72e96bc0	364	$this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
37d44b3b FB	365	}
37d44b3b FB	366
7c2e0f0d	367	protected function _fetchData()
37d44b3b	368	{
b539d596 FB	369	if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
	370	// Checkout the CV
	371	$res = XDB::query("SELECT cv
	372	FROM profiles
	373	WHERE pid = {?}",
	374	$this->pid());
	375	$this->values['cv'] = $res->fetchOneCell();
	376	}
37d44b3b FB	377	}
37d44b3b FB	378
7c2e0f0d	379	protected function _saveData()
37d44b3b	380	{
b539d596 FB	381	if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
	382	if ($this->changed['cv']) {
	383	XDB::execute("UPDATE profiles
	384	SET cv = {?}
	385	WHERE pid = {?}",
	386	$this->values['cv'], $this->pid());
	387	}
37d44b3b	388	}
3950bc21	389	}
2dcac0f5	390
04334c61	391	public function _prepare(PlPage &$page, $id)
2dcac0f5	392	{
a6483c12	393	require_once 'emails.combobox.inc.php';
4e698dc9	394	fill_email_combobox($page, $this->owner);
b715c1e1	395
8c5f91c4 SJ	396	if (!S::user()->isMe($page->owner)) {
	397	$res = XDB::iterator('SELECT id, name
	398	FROM profile_corps_enum
	399	ORDER BY id = 1 DESC, name');
	400	$page->assign('original_corps', $res->fetchAllAssoc());
	401	}
72e96bc0 SJ	402
	403	$res = XDB::iterator("SELECT id, name
	404	FROM profile_corps_enum
	405	WHERE still_exists = 1
	406	ORDER BY id = 1 DESC, name");
	407	$page->assign('current_corps', $res->fetchAllAssoc());
	408
	409	$res = XDB::iterator("SELECT id, name
e489faf7 SJ	410	FROM profile_corps_rank_enum
e489faf7 SJ	411	ORDER BY id = 1 DESC, name");
72e96bc0	412	$page->assign('corps_rank', $res->fetchAllAssoc());
2dcac0f5	413	}
3950bc21 FB	414	}
	415
	416	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
	417	?>