<?php
/***************************************************************************
- * Copyright (C) 2003-2009 Polytechnique.org *
+ * Copyright (C) 2003-2010 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
-class ProfileJob extends ProfileGeoloc
+class ProfileSettingJob implements ProfileSetting
{
private $pub;
- private $mail;
- private $web;
- private $tel;
+ private $email_new;
+ private $email;
+ private $url;
private $bool;
private $checks;
public function __construct()
{
- $this->pub = new ProfilePub();
- $this->mail = new ProfileEmail();
- $this->web = new ProfileWeb();
- $this->tel = new ProfileTel();
- $this->bool = new ProfileBool();
- $this->checks = array('web' => array('web'),
- 'mail' => array('email'),
- 'tel' => array('tel', 'fax', 'mobile'),
- 'pub' => array('pub', 'tel_pub', 'email_pub'));
+ $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 cleanJob(ProfilePage &$page, array &$job, &$success)
+ private function emptyJob()
{
- $success = true;
+ $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['adr']['pub'] = $this->pub->value($page, 'adr_pub', @$job['adr']['pub'], $s);
- $job['adr']['checked'] = $this->bool->value($page, 'adr_checked', @$job['adr']['checked'], $s);
+ 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']);
- unset($job['adr']['changed']);
- unset($job['adr']['parsevalid']);
- unset($job['adr']['display']);
}
+
+
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 = $page->values['jobs'];
+ $value = $this->fetchJobs($page);
$init = true;
}
$success = true;
- foreach ($value as $key=>&$job) {
- if (@$job['removed'] || !trim($job['name'])) {
+ 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) {
- $ls = true;
- $this->geolocAddress($job['adr'], $s);
- $ls = ($ls && $s);
- $this->cleanJob($page, $job, $s);
- $ls = ($ls && $s);
+ 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 && $ls);
+ $success = ($success && $s);
}
}
return $value;
public function save(ProfilePage &$page, $field, $value)
{
- XDB::execute("DELETE FROM entreprises
- WHERE uid = {?}",
- S::i('uid'));
- $i = 0;
- foreach ($value as &$job) {
- XDB::execute("INSERT INTO entreprises (uid, entrid, entreprise, secteur, ss_secteur,
- fonction, poste, adr1, adr2, adr3, postcode,
- city, cityid, country, region, regiontxt,
- tel, fax, mobile, email, web,
- pub, adr_pub, tel_pub, email_pub, flags,
- glat, glng)
- VALUES ({?}, {?}, {?}, {?}, {?},
- {?}, {?}, {?}, {?}, {?}, {?},
- {?}, {?}, {?}, {?}, {?},
- {?}, {?}, {?}, {?}, {?},
- {?}, {?}, {?}, {?}, {?},
- {?}, {?})",
- S::i('uid'), $i++, $job['name'], $job['secteur'], $job['ss_secteur'],
- $job['fonction'], $job['poste'], $job['adr']['adr1'], $job['adr']['adr2'], $job['adr']['adr3'],
- $job['adr']['postcode'],
- $job['adr']['city'], $job['adr']['cityid'], $job['adr']['country'], $job['adr']['region'],
- $job['adr']['regiontxt'],
- $job['tel'], $job['fax'], $job['mobile'], $job['email'], $job['web'],
- $job['pub'], $job['adr']['pub'], $job['tel_pub'], $job['email_pub'],
- $job['adr']['checked'] ? 'geoloc' : '', $job['adr']['precise_lat'],
- $job['adr']['precise_lon']);
+ 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 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('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());
+ }
+
+ 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 ProfileJobs extends ProfilePage
+class ProfilePageJobs extends ProfilePage
{
protected $pg_template = 'profile/jobs.tpl';
public function __construct(PlWizard &$wiz)
{
parent::__construct($wiz);
- $this->settings['cv'] = null;
- $this->settings['jobs'] = new ProfileJob();
- $this->watched['cv'] = $this->watched['jobs'] = true;
+ 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()
{
- // Checkout the CV
- $res = XDB::query("SELECT cv
- FROM auth_user_md5
- WHERE user_id = {?}",
- S::i('uid'));
- $this->values['cv'] = $res->fetchOneCell();
-
- // Build the jobs tree
- $res = XDB::iterRow("SELECT e.entreprise, e.secteur, e.ss_secteur,
- e.fonction, e.poste, e.adr1, e.adr2, e.adr3,
- e.postcode, e.city, e.cityid, e.region, e.regiontxt,
- e.country, gp.pays, gp.display,
- FIND_IN_SET('geoloc', flags),
- e.tel, e.fax, e.mobile, e.email, e.web, e.pub,
- e.adr_pub, e.tel_pub, e.email_pub,
- e.glat AS precise_lat, e.glng AS precise_lon
- FROM entreprises AS e
- LEFT JOIN geoloc_pays AS gp ON(gp.a2 = e.country)
- WHERE uid = {?} AND entreprise != ''
- ORDER BY entrid", S::i('uid'));
- $this->values['jobs'] = array();
- while (list($name, $secteur, $ss_secteur, $fonction, $poste,
- $adr1, $adr2, $adr3, $postcode, $city, $cityid,
- $region, $regiontxt, $country, $countrytxt, $display,
- $checked, $tel, $fax, $mobile, $email, $web,
- $pub, $adr_pub, $tel_pub, $email_pub, $glat, $glng) = $res->next()) {
- $this->values['jobs'][] = array('name' => $name,
- 'secteur' => $secteur,
- 'ss_secteur' => $ss_secteur,
- 'fonction' => $fonction,
- 'poste' => $poste,
- 'adr' => array('adr1' => $adr1,
- 'adr2' => $adr2,
- 'adr3' => $adr3,
- 'postcode' => $postcode,
- 'city' => $city,
- 'cityid' => $cityid,
- 'region' => $region,
- 'regiontxt' => $regiontxt,
- 'country' => $country,
- 'countrytxt' => $countrytxt,
- 'display' => $display,
- 'pub' => $adr_pub,
- 'checked' => $checked,
- 'precise_lat'=> $glat,
- 'precise_lon'=> $glng),
- 'tel' => $tel,
- 'fax' => $fax,
- 'mobile' => $mobile,
- 'email' => $email,
- 'web' => $web,
- 'pub' => $pub,
- 'tel_pub' => $tel_pub,
- 'email_pub' => $email_pub);
+ 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 ($this->changed['cv']) {
- XDB::execute("UPDATE auth_user_md5
- SET cv = {?}
- WHERE user_id = {?}",
- $this->values['cv'], S::i('uid'));
+ 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)
{
- $res = XDB::query("SELECT id, label
- FROM emploi_secteur");
- $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());
+ require_once 'emails.combobox.inc.php';
+ fill_email_combobox($page, $this->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());
}
}