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

<?php
/***************************************************************************
 *  Copyright (C) 2003-2009 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

class ProfileJob extends ProfileGeocoding
{
    private $pub;
    private $mail_new;
    private $mail;
    private $web;
    private $bool;
    private $checks;

    public function __construct()
    {
        $this->pub    = new ProfilePub();
        $this->mail
                      = $this->mail_new
                      = new ProfileEmail();
        $this->web    = new ProfileWeb();
        $this->bool   = new ProfileBool();
        $this->checks = array('web'      => array('w_web'),
                              'mail_new' => array('w_email_new'),
                              'mail'     => array('w_email'),
                              'pub'      => array('pub', 'w_email_pub'));
    }

    private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
    {
        $success = true;
        foreach ($this->checks as $obj=>&$fields) {
            $chk =& $this->$obj;
            foreach ($fields as $field) {
                if ($field == "w_email_new") {
                    if ($job['w_email'] == "new@example.org") {
                        $job['w_email'] = $job[$field];
                    }
                    continue;
                }
                $job[$field] = $chk->value($page, $field, $job[$field], $s);
                if (!$s) {
                    $success = false;
                    $job[$field . '_error'] = true;
                }
            }
        }
        if (!$job['sss_secteur_name']) {
            $res = XDB::query("SELECT  name
                                 FROM  profile_job_subsubsector_enum
                                WHERE  id = {?}",
                              $job['sss_secteur']);
            $job['sss_secteur_name'] = $res->fetchOneCell();
        } else {
            $res = XDB::query("SELECT  sectorid, subsectorid, id
                                 FROM  profile_job_subsubsector_enum
                                WHERE  name = {?}",
                              $job['sss_secteur_name']);
            if ($res->numRows() != 1) {
                $success = false;
                $job['sector_error'] = true;
            } else {
                list($job['secteur'], $job['ss_secteur'], $job['sss_secteur']) = $res->fetchOneRow();
            }
        }
        if ($job['name']) {
            $res = XDB::query("SELECT  id
                                 FROM  profile_job_enum
                                WHERE  name = {?}",
                              $job['name']);
            if ($res->numRows() != 1) {
                $user = S::user();
                $req = new EntrReq($user, $jobid, $job['name'], $job['acronym'], $job['hq_web'], $job['hq_email'], $job['hq_tel'], $job['hq_fax']);
                $req->submit();
                $job['jobid'] = null;
            } else {
                $job['jobid'] = $res->fetchOneCell();
            }
        }
        $job['w_adr']['pub'] = $this->pub->value($page, 'adr_pub', @$job['w_adr']['pub'], $s);
        $job['w_adr']['checked'] = $this->bool->value($page, 'adr_checked', @$job['w_adr']['checked'], $s);
        if (!isset($job['w_tel'])) {
            $job['w_tel'] = array();
        }
        $profiletel = new ProfilePhones('pro', $jobid);
        $job['w_tel'] = $profiletel->value($page, 'tel', $job['w_tel'], $s);
        unset($job['removed']);
        unset($job['new']);
        unset($job['w_adr']['changed']);
        unset($job['w_adr']['parsevalid']);
        unset($job['w_adr']['display']);
    }

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

        $init = false;
        if (is_null($value)) {
            $value = $page->values['jobs'];
            $init = true;
        }
        $success = true;
        foreach ($value as $key=>&$job) {
            $job['name'] = trim($job['name']);
            if (!$job['name']) {
                $job['tmp_name'] = $entreprise[$entr_val]->name;
                $entr_val ++;
            }
            if (@$job['removed']) {
                unset($value[$key]);
            }
        }
        foreach ($value as $key=>&$job) {
            $ls = true;
            $this->geocodeAddress($job['w_adr'], $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)
    {
        require_once('profil.func.inc.php');
        require_once('validations.inc.php');

        XDB::execute("DELETE FROM  profile_job
                            WHERE  uid = {?}",
                     S::i('uid'));
        XDB::execute("DELETE FROM  profile_phones
                            WHERE  uid = {?} AND link_type = 'pro'",
                     S::i('uid'));
        foreach ($value as $id=>&$job) {
            if ($job['w_email'] == "new@example.org") {
                $job['w_email'] = $job['w_email_new'];
            }
            if ($job['jobid']) {
                XDB::execute("INSERT INTO  profile_job (uid, id, functionid, description, sectorid, subsectorid,
                                                        subsubsectorid, email, url, pub, email_pub, jobid)
                                   VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
                             S::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
                             $job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub'], $job['jobid']);
            } else {
                XDB::execute("INSERT INTO  profile_job (uid, id, functionid, description, sectorid, subsectorid,
                                                        subsubsectorid, email, url, pub, email_pub)
                                   VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
                             S::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
                             $job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub']);
            }
            $profiletel = new ProfilePhones('pro', $id);
            $profiletel->saveTels('tel', $job['w_tel']);
        }
    }
}

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

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

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

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

        // Build the jobs tree
        $res = XDB::iterRow("SELECT  j.id, je.name, j.functionid, j.sectorid, j.subsectorid,
                                     j.subsubsectorid, j.description, e.adr1, e.adr2, e.adr3,
                                     e.postcode, e.city, e.cityid, e.region, e.regiontxt,
                                     e.country, gc.countryFR,
                                     j.email, j.url, j.pub,
                                     e.adr_pub, j.email_pub,
                                     e.glat, e.glng, s.name
                               FROM  profile_job                   AS j
                          LEFT JOIN  profile_job_enum              AS je ON (j.jobid = je.id)
                          LEFT JOIN  entreprises                   AS e  ON (j.uid = e.uid AND j.id = e.entrid)
                          LEFT JOIN  geoloc_countries              AS gc ON (gc.iso_3166_1_a2 = e.country)
                          LEFT JOIN  profile_job_subsubsector_enum AS s  ON (s.id = j.subsubsectorid)
                              WHERE  j.uid = {?}
                           ORDER BY  entrid", S::i('uid'));
        $this->values['jobs'] = array();
        while (list($id, $name, $function, $secteur, $ss_secteur, $sss_secteur, $description,
                    $w_adr1, $w_adr2, $w_adr3, $w_postcode, $w_city, $w_cityid,
                    $w_region, $w_regiontxt, $w_country, $w_countrytxt,
                    $w_email, $w_web,
                    $pub, $w_adr_pub, $w_email_pub, $w_glat, $w_glng, $sss_secteur_name
                   ) = $res->next()) {
            $this->values['jobs'][] = array('id'               => $id,
                                            'name'             => $name,
                                            'fonction'         => $function,
                                            'secteur'          => $secteur,
                                            'ss_secteur'       => $ss_secteur,
                                            'sss_secteur'      => $sss_secteur,
                                            'sss_secteur_name' => $sss_secteur_name,
                                            'description'      => $description,
                                            'w_adr'            => array('adr1'        => $w_adr1,
                                                                        'adr2'        => $w_adr2,
                                                                        'adr3'        => $w_adr3,
                                                                        'postcode'    => $w_postcode,
                                                                        'city'        => $w_city,
                                                                        'cityid'      => $w_cityid,
                                                                        'region'      => $w_region,
                                                                        'regiontxt'   => $w_regiontxt,
                                                                        'country'     => $w_country,
                                                                        'countrytxt'  => $w_countrytxt,
                                                                        'pub'         => $w_adr_pub,
                                                                        'checked'     => (($w_checked == 0)? true : false),
                                                                        'precise_lat' => $w_glat,
                                                                        'precise_lon' => $w_glng),
                                            'w_email'          => $w_email,
                                            'w_web'            => $w_web,
                                            'pub'              => $pub,
                                            'w_email_pub'      => $w_email_pub);
        }

        $res = XDB::iterator("SELECT  link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
                                FROM  profile_phones
                               WHERE  uid = {?} AND link_type = 'pro'
                            ORDER BY  link_id",
                             S::i('uid'));
        $i = 0;
        $jobNb = count($this->values['jobs']);
        while ($tel = $res->next()) {
            $jobid = $tel['jobid'];
            unset($tel['jobid']);
            while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
                $i++;
            }
            if ($i >= $jobNb) {
                break;
            }
            $job =& $this->values['jobs'][$i];
            if (!isset($job['w_tel'])) {
                $job['w_tel'] = array();
            }
            if ($job['id'] == $jobid) {
                $job['w_tel'][] = $tel;
            }
        }
        foreach ($this->values['jobs'] as $id=>&$job) {
            if (!isset($job['w_tel'])) {
                $job['w_tel'] = array();
            }
            unset($job['id']);
        }
    }

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

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

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

        $res = XDB::query("SELECT  id, name AS label
                             FROM  profile_job_sector_enum");
        $page->assign('secteurs', $res->fetchAllAssoc());
        $res = XDB::query("SELECT  id, fonction_fr, FIND_IN_SET('titre', flags) AS title
                             FROM  fonctions_def
                         ORDER BY  id");
        $page->assign('fonctions', $res->fetchAllAssoc());

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

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

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

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
3950bc21 FB	1	<?php
3950bc21 FB	2	/***************************************************************************
8d84c630	3	* Copyright (C) 2003-2009 Polytechnique.org *
3950bc21 FB	4	* http://opensource.polytechnique.org/ *
	5	* *
	6	* This program is free software; you can redistribute it and/or modify *
	7	* it under the terms of the GNU General Public License as published by *
	8	* the Free Software Foundation; either version 2 of the License, or *
	9	* (at your option) any later version. *
	10	* *
	11	* This program is distributed in the hope that it will be useful, *
	12	* but WITHOUT ANY WARRANTY; without even the implied warranty of *
	13	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
	14	* GNU General Public License for more details. *
	15	* *
	16	* You should have received a copy of the GNU General Public License *
	17	* along with this program; if not, write to the Free Software *
	18	* Foundation, Inc., *
	19	* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
	20	***************************************************************************/
	21
73f6c165	22	class ProfileJob extends ProfileGeocoding
37d44b3b FB	23	{
37d44b3b FB	24	private $pub;
b715c1e1	25	private $mail_new;
37d44b3b FB	26	private $mail;
37d44b3b FB	27	private $web;
f93fb300	28	private $bool;
37d44b3b FB	29	private $checks;
	30
	31	public function __construct()
	32	{
c7139c07	33	$this->pub = new ProfilePub();
b715c1e1	34	$this->mail
c7139c07 SJ	35	= $this->mail_new
	36	= new ProfileEmail();
	37	$this->web = new ProfileWeb();
	38	$this->bool = new ProfileBool();
	39	$this->checks = array('web' => array('w_web'),
	40	'mail_new' => array('w_email_new'),
	41	'mail' => array('w_email'),
	42	'pub' => array('pub', 'w_email_pub'));
37d44b3b FB	43	}
37d44b3b FB	44
b814a8b8	45	private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
37d44b3b FB	46	{
	47	$success = true;
	48	foreach ($this->checks as $obj=>&$fields) {
	49	$chk =& $this->$obj;
	50	foreach ($fields as $field) {
c7139c07 SJ	51	if ($field == "w_email_new") {
	52	if ($job['w_email'] == "new@example.org") {
	53	$job['w_email'] = $job[$field];
b715c1e1 SJ	54	}
	55	continue;
	56	}
37d44b3b FB	57	$job[$field] = $chk->value($page, $field, $job[$field], $s);
	58	if (!$s) {
	59	$success = false;
	60	$job[$field . '_error'] = true;
	61	}
	62	}
	63	}
b814a8b8	64	if (!$job['sss_secteur_name']) {
c7139c07 SJ	65	$res = XDB::query("SELECT name
	66	FROM profile_job_subsubsector_enum
	67	WHERE id = {?}",
	68	$job['sss_secteur']);
	69	$job['sss_secteur_name'] = $res->fetchOneCell();
	70	} else {
	71	$res = XDB::query("SELECT sectorid, subsectorid, id
	72	FROM profile_job_subsubsector_enum
	73	WHERE name = {?}",
	74	$job['sss_secteur_name']);
	75	if ($res->numRows() != 1) {
	76	$success = false;
	77	$job['sector_error'] = true;
	78	} else {
	79	list($job['secteur'], $job['ss_secteur'], $job['sss_secteur']) = $res->fetchOneRow();
	80	}
	81	}
b814a8b8	82	if ($job['name']) {
c7139c07 SJ	83	$res = XDB::query("SELECT id
	84	FROM profile_job_enum
	85	WHERE name = {?}",
	86	$job['name']);
	87	if ($res->numRows() != 1) {
b814a8b8 SJ	88	$user = S::user();
	89	$req = new EntrReq($user, $jobid, $job['name'], $job['acronym'], $job['hq_web'], $job['hq_email'], $job['hq_tel'], $job['hq_fax']);
	90	$req->submit();
	91	$job['jobid'] = null;
c7139c07 SJ	92	} else {
	93	$job['jobid'] = $res->fetchOneCell();
	94	}
	95	}
	96	$job['w_adr']['pub'] = $this->pub->value($page, 'adr_pub', @$job['w_adr']['pub'], $s);
	97	$job['w_adr']['checked'] = $this->bool->value($page, 'adr_checked', @$job['w_adr']['checked'], $s);
	98	if (!isset($job['w_tel'])) {
	99	$job['w_tel'] = array();
bde2be3b GB	100	}
bde2be3b GB	101	$profiletel = new ProfilePhones('pro', $jobid);
c7139c07	102	$job['w_tel'] = $profiletel->value($page, 'tel', $job['w_tel'], $s);
37d44b3b FB	103	unset($job['removed']);
37d44b3b FB	104	unset($job['new']);
c7139c07 SJ	105	unset($job['w_adr']['changed']);
	106	unset($job['w_adr']['parsevalid']);
	107	unset($job['w_adr']['display']);
37d44b3b FB	108	}
	109
	110	public function value(ProfilePage &$page, $field, $value, &$success)
	111	{
b814a8b8 SJ	112	require_once('validations.inc.php');
	113	$entreprise = Validate::get_typed_requests(S::i('uid'), 'entreprise');
	114	$entr_val = 0;
	115
37d44b3b FB	116	$init = false;
	117	if (is_null($value)) {
	118	$value = $page->values['jobs'];
	119	$init = true;
	120	}
	121	$success = true;
	122	foreach ($value as $key=>&$job) {
b814a8b8 SJ	123	$job['name'] = trim($job['name']);
	124	if (!$job['name']) {
	125	$job['tmp_name'] = $entreprise[$entr_val]->name;
	126	$entr_val ++;
	127	}
	128	if (@$job['removed']) {
37d44b3b FB	129	unset($value[$key]);
	130	}
	131	}
	132	foreach ($value as $key=>&$job) {
	133	$ls = true;
73f6c165	134	$this->geocodeAddress($job['w_adr'], $s);
37d44b3b	135	$ls = ($ls && $s);
bde2be3b	136	$this->cleanJob($page, $key, $job, $s);
37d44b3b FB	137	$ls = ($ls && $s);
	138	if (!$init) {
	139	$success = ($success && $ls);
	140	}
	141	}
	142	return $value;
	143	}
	144
	145	public function save(ProfilePage &$page, $field, $value)
	146	{
5e4417a9	147	require_once('profil.func.inc.php');
b814a8b8 SJ	148	require_once('validations.inc.php');
b814a8b8 SJ	149
c7139c07	150	XDB::execute("DELETE FROM profile_job
37d44b3b FB	151	WHERE uid = {?}",
37d44b3b FB	152	S::i('uid'));
b235d980	153	XDB::execute("DELETE FROM profile_phones
5e4417a9 GB	154	WHERE uid = {?} AND link_type = 'pro'",
5e4417a9 GB	155	S::i('uid'));
b814a8b8	156	foreach ($value as $id=>&$job) {
c7139c07 SJ	157	if ($job['w_email'] == "new@example.org") {
c7139c07 SJ	158	$job['w_email'] = $job['w_email_new'];
b715c1e1	159	}
b814a8b8 SJ	160	if ($job['jobid']) {
	161	XDB::execute("INSERT INTO profile_job (uid, id, functionid, description, sectorid, subsectorid,
	162	subsubsectorid, email, url, pub, email_pub, jobid)
	163	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
	164	S::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
	165	$job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub'], $job['jobid']);
	166	} else {
	167	XDB::execute("INSERT INTO profile_job (uid, id, functionid, description, sectorid, subsectorid,
	168	subsubsectorid, email, url, pub, email_pub)
	169	VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
	170	S::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
	171	$job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub']);
	172	}
	173	$profiletel = new ProfilePhones('pro', $id);
c7139c07	174	$profiletel->saveTels('tel', $job['w_tel']);
37d44b3b FB	175	}
	176	}
	177	}
	178
3950bc21 FB	179	class ProfileJobs extends ProfilePage
	180	{
	181	protected $pg_template = 'profile/jobs.tpl';
	182
	183	public function __construct(PlWizard &$wiz)
	184	{
	185	parent::__construct($wiz);
37d44b3b	186	$this->settings['cv'] = null;
72e96bc0	187	$this->settings['corps'] = null;
37d44b3b	188	$this->settings['jobs'] = new ProfileJob();
72e96bc0	189	$this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
37d44b3b FB	190	}
37d44b3b FB	191
7c2e0f0d	192	protected function _fetchData()
37d44b3b	193	{
37d44b3b FB	194	// Checkout the CV
	195	$res = XDB::query("SELECT cv
	196	FROM auth_user_md5
	197	WHERE user_id = {?}",
	198	S::i('uid'));
	199	$this->values['cv'] = $res->fetchOneCell();
	200
72e96bc0 SJ	201	// Checkout the corps
	202	$res = XDB::query("SELECT original_corpsid AS original, current_corpsid AS current,
	203	rankid AS rank, corps_pub AS pub
	204	FROM profile_corps
	205	WHERE uid = {?}",
	206	S::i('uid'));
	207	$this->values['corps'] = $res->fetchOneAssoc();
	208
37d44b3b	209	// Build the jobs tree
c7139c07 SJ	210	$res = XDB::iterRow("SELECT j.id, je.name, j.functionid, j.sectorid, j.subsectorid,
c7139c07 SJ	211	j.subsubsectorid, j.description, e.adr1, e.adr2, e.adr3,
37d44b3b	212	e.postcode, e.city, e.cityid, e.region, e.regiontxt,
a0b12fc9	213	e.country, gc.countryFR,
c7139c07 SJ	214	j.email, j.url, j.pub,
	215	e.adr_pub, j.email_pub,
	216	e.glat, e.glng, s.name
	217	FROM profile_job AS j
	218	LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
	219	LEFT JOIN entreprises AS e ON (j.uid = e.uid AND j.id = e.entrid)
e4cd7a1f	220	LEFT JOIN geoloc_countries AS gc ON (gc.iso_3166_1_a2 = e.country)
c7139c07 SJ	221	LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
c7139c07 SJ	222	WHERE j.uid = {?}
37d44b3b FB	223	ORDER BY entrid", S::i('uid'));
37d44b3b FB	224	$this->values['jobs'] = array();
c7139c07 SJ	225	while (list($id, $name, $function, $secteur, $ss_secteur, $sss_secteur, $description,
c7139c07 SJ	226	$w_adr1, $w_adr2, $w_adr3, $w_postcode, $w_city, $w_cityid,
e4cd7a1f	227	$w_region, $w_regiontxt, $w_country, $w_countrytxt,
a0b12fc9	228	$w_email, $w_web,
c7139c07	229	$pub, $w_adr_pub, $w_email_pub, $w_glat, $w_glng, $sss_secteur_name
bde2be3b	230	) = $res->next()) {
c7139c07 SJ	231	$this->values['jobs'][] = array('id' => $id,
	232	'name' => $name,
	233	'fonction' => $function,
	234	'secteur' => $secteur,
	235	'ss_secteur' => $ss_secteur,
	236	'sss_secteur' => $sss_secteur,
	237	'sss_secteur_name' => $sss_secteur_name,
	238	'description' => $description,
	239	'w_adr' => array('adr1' => $w_adr1,
	240	'adr2' => $w_adr2,
	241	'adr3' => $w_adr3,
	242	'postcode' => $w_postcode,
	243	'city' => $w_city,
	244	'cityid' => $w_cityid,
	245	'region' => $w_region,
	246	'regiontxt' => $w_regiontxt,
	247	'country' => $w_country,
	248	'countrytxt' => $w_countrytxt,
c7139c07	249	'pub' => $w_adr_pub,
e4cd7a1f	250	'checked' => (($w_checked == 0)? true : false),
c7139c07 SJ	251	'precise_lat' => $w_glat,
	252	'precise_lon' => $w_glng),
	253	'w_email' => $w_email,
	254	'w_web' => $w_web,
	255	'pub' => $pub,
	256	'w_email_pub' => $w_email_pub);
37d44b3b	257	}
bde2be3b GB	258
	259	$res = XDB::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
	260	FROM profile_phones
	261	WHERE uid = {?} AND link_type = 'pro'
	262	ORDER BY link_id",
	263	S::i('uid'));
	264	$i = 0;
	265	$jobNb = count($this->values['jobs']);
	266	while ($tel = $res->next()) {
	267	$jobid = $tel['jobid'];
	268	unset($tel['jobid']);
	269	while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
	270	$i++;
	271	}
	272	if ($i >= $jobNb) {
	273	break;
	274	}
	275	$job =& $this->values['jobs'][$i];
c7139c07 SJ	276	if (!isset($job['w_tel'])) {
c7139c07 SJ	277	$job['w_tel'] = array();
bde2be3b GB	278	}
bde2be3b GB	279	if ($job['id'] == $jobid) {
c7139c07	280	$job['w_tel'][] = $tel;
bde2be3b GB	281	}
	282	}
	283	foreach ($this->values['jobs'] as $id=>&$job) {
c7139c07 SJ	284	if (!isset($job['w_tel'])) {
c7139c07 SJ	285	$job['w_tel'] = array();
bde2be3b GB	286	}
	287	unset($job['id']);
	288	}
37d44b3b FB	289	}
37d44b3b FB	290
7c2e0f0d	291	protected function _saveData()
37d44b3b FB	292	{
	293	if ($this->changed['cv']) {
	294	XDB::execute("UPDATE auth_user_md5
	295	SET cv = {?}
	296	WHERE user_id = {?}",
	297	$this->values['cv'], S::i('uid'));
	298	}
72e96bc0 SJ	299
	300	if ($this->changed['corps']) {
	301	XDB::execute("UPDATE profile_corps
	302	SET original_corpsid = {?}, current_corpsid = {?},
	303	rankid = {?}, corps_pub = {?}
	304	WHERE uid = {?}",
	305	$this->values['corps']['original'], $this->values['corps']['current'],
	306	$this->values['corps']['rank'], $this->values['corps']['pub'], S::i('uid'));
	307	}
3950bc21	308	}
2dcac0f5	309
04334c61	310	public function _prepare(PlPage &$page, $id)
2dcac0f5	311	{
b715c1e1 SJ	312	require_once "emails.combobox.inc.php";
	313	fill_email_combobox($page);
	314
33b6f5a0 SJ	315	$res = XDB::query("SELECT id, name AS label
	316	FROM profile_job_sector_enum");
	317	$page->assign('secteurs', $res->fetchAllAssoc());
	318	$res = XDB::query("SELECT id, fonction_fr, FIND_IN_SET('titre', flags) AS title
	319	FROM fonctions_def
	320	ORDER BY id");
	321	$page->assign('fonctions', $res->fetchAllAssoc());
72e96bc0 SJ	322
	323	$res = XDB::iterator("SELECT id, name
	324	FROM profile_corps_enum
	325	ORDER BY id = 1 DESC, name");
	326	$page->assign('original_corps', $res->fetchAllAssoc());
	327
	328	$res = XDB::iterator("SELECT id, name
	329	FROM profile_corps_enum
	330	WHERE still_exists = 1
	331	ORDER BY id = 1 DESC, name");
	332	$page->assign('current_corps', $res->fetchAllAssoc());
	333
	334	$res = XDB::iterator("SELECT id, name
	335	FROM profile_corps_rank_enum");
	336	$page->assign('corps_rank', $res->fetchAllAssoc());
2dcac0f5	337	}
3950bc21 FB	338	}
	339
	340	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
	341	?>