<?php
/***************************************************************************
- * Copyright (C) 2003-2010 Polytechnique.org *
+ * Copyright (C) 2003-2011 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 ProfileSettingJob extends ProfileSettingGeocoding
+class ProfileSettingJob implements ProfileSetting
{
private $pub;
private $email_new;
);
}
- public function emptyJob()
+ private function emptyJob()
{
+ $address = new Address();
+ $phone = new Phone();
return array(
'id' => '0',
'jobid' => '',
- 'pub' => 'private',
+ 'pub' => 'ax',
'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_address' => $address->toFormArray(),
'w_email' => '',
- 'w_email_pub' => 'private',
+ 'w_email_pub' => 'ax',
'w_email_new' => '',
- 'w_phone' => array(0 => array(
- 'type' => 'fixed',
- 'tel' => '',
- 'pub' => 'private',
- 'comment' => '',
- ),
- 'terms' => array()),
+ 'w_phone' => array(0 => $phone->toFormArray()),
+ 'terms' => array()
);
}
- private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
+ 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, j.entry_year AS w_entry_year
+ 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->link_id]['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, $job_level)
{
- $success = true;
if ($job['w_email'] == "new@example.org") {
$job['w_email'] = $job['w_email_new'];
}
}
}
}
- 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 (count($job['terms'])) {
$termsid = array();
foreach ($job['terms'] as $term) {
- if (!$term['full_name']) {
+ if (!isset($term['full_name'])) {
$termsid[] = $term['jtid'];
}
}
$termsid);
$term_id_to_name = $res->fetchAllAssoc('jtid', false);
foreach ($job['terms'] as &$term) {
- if (!$term['full_name']) {
+ if (!isset($term['full_name'])) {
$term['full_name'] = $term_id_to_name[$term['jtid']];
}
}
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);
+
+ if (Visibility::isLessRestrictive($job['w_email_pub'], $job_level)) {
+ $job['w_email_pub'] = $job_level;
+ }
+ $job['w_phone'] = Phone::formatFormArray($job['w_phone'], $s, $job_level);
+
+ if ($job['w_entry_year'] && strlen($job['w_entry_year']) != 4) {
+ $job['w_entry_year_error'] = true;
+ $success = false;
+ }
unset($job['removed']);
unset($job['new']);
}
- public function value(ProfilePage &$page, $field, $value, &$success)
+
+
+ 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'];
+ $value = $this->fetchJobs($page);
$init = true;
}
$success = true;
- foreach ($value as $key => &$job) {
+ foreach ($value as $key => $job) {
$job['name'] = trim($job['name']);
- if ($job['name'] == '' && $entreprise) {
+ if ($job['name'] == '' && $entreprise[$entr_val]->id == $key) {
$job['tmp_name'] = $entreprise[$entr_val]->name;
++$entr_val;
} else if ($job['name'] == '') {
- if ($job['subSubSectorName'] == '' && $job['description'] == '' && $job['w_url'] == ''
+ if ($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);
+ && count($job['w_phone']) >= 1 && $job['w_phone'][0]['display'] == '') {
+ unset($value[$key]);
continue;
}
- $job['name_error'] = true;
- $success = false;
+ if (!$init) {
+ $job['name_error'] = true;
+ $success = false;
+ }
}
if (isset($job['removed']) && $job['removed']) {
- if ($job['name'] == '' && $entreprise) {
- $entreprise[$entr_val - 1]->clean();
+ if (!S::user()->checkPerms('directory_private')
+ && (Phone::hasPrivate($job['w_phone']) || Address::hasPrivate($job['w_address']) || $job['w_email_pub'] == 'private')) {
+ Platal::page()->trigWarning("L'entreprise ne peut être supprimée car elle contient des informations pour lesquelles vous n'avez pas le droit d'édition.");
+ } else {
+ if ($job['name'] == '' && $entreprise && isset($entreprise[$entr_val - 1])) {
+ $entreprise[$entr_val - 1]->clean();
+ }
+ unset($value[$key]);
+ continue;
}
- array_splice($value, $key, 1);
}
- foreach (array('sectorid', 'subsectorid', 'subsubsectorid') as $key) {
- if ($job[$key] == 0) {
- $job[$key] = null;
- }
+ if (!isset($job['pub']) || !$job['pub']) {
+ $job['pub'] = 'private';
+ }
+ $value[$key] = $job;
}
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);
+ $address = new Address($job['w_address']);
+ $s = $address->format();
+
+ // Force the address publicity to be at least as restricted as
+ // the job publicity.
+ $job_level = $job['pub'];
+ if (Visibility::isLessRestrictive($address->pub, $job_level)) {
+ $address->pub = $job_level;
+ }
+ $job['w_address'] = $address->toFormArray();
+ $this->cleanJob($page, $key, $job, $s, $job_level);
if (!$init) {
- $success = ($success && $ls);
+ $success = ($success && $s);
}
}
+ usort($value, 'Visibility::comparePublicity');
return $value;
}
- public function save(ProfilePage &$page, $field, $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'",
+
+ $deletePrivate = S::user()->isMe($page->owner) || S::admin();
+ XDB::execute('DELETE FROM pj, pjt
+ USING profile_job AS pj
+ LEFT JOIN profile_job_term AS pjt ON (pj.pid = pjt.pid AND pj.id = pjt.jid)
+ WHERE pj.pid = {?}' . (($deletePrivate) ? '' : ' AND pj.pub IN (\'public\', \'ax\')'),
$page->pid());
- Phone::deletePhones($page->pid(), Phone::LINK_JOB);
+ Address::deleteAddresses($page->pid(), Address::LINK_JOB, null, null, $deletePrivate);
+ Phone::deletePhones($page->pid(), Phone::LINK_JOB, null, $deletePrivate);
+ $previous_requests = EntrReq::get_typed_requests($page->pid(), 'entreprise');
+ foreach ($previous_requests as $request) {
+ $request->clean();
+ }
$terms_values = array();
foreach ($value as $id => &$job) {
- if (isset($job['name']) && $job['name']) {
+ if (($job['pub'] != 'private' || $deletePrivate) && (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']);
+ XDB::execute('INSERT INTO profile_job (pid, id, description, email, entry_year,
+ url, pub, email_pub, jobid)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $page->pid(), $id, $job['description'], $job['w_email'], $job['w_entry_year'],
+ $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']);
+ XDB::execute('INSERT INTO profile_job (pid, id, description, email, entry_year,
+ url, pub, email_pub)
+ VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
+ $page->pid(), $id, $job['description'], $job['w_email'], $job['w_entry_year'],
+ $job['w_url'], $job['pub'], $job['w_email_pub']);
+ $request = new EntrReq(S::user(), $page->profile, $id, $job['name'], $job['hq_acronym'], $job['hq_url'],
+ $job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
+ $request->submit();
+ sleep(1);
}
- $address = new ProfileSettingAddress();
- $address->saveAddress($page->pid(), $id, $job['w_address'], 'job');
+ $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::escape($page->pid()).', '. XDB::escape($id).', '.XDB::escape($term['jtid']).', "original")';
+ $terms_values[] = XDB::format('({?}, {?}, {?}, {?})',
+ $page->pid(), $id, $term['jtid'], "original");
}
}
}
}
if (count($terms_values) > 0) {
- XDB::execute('INSERT INTO profile_job_term (pid, jid, jtid, computed)
- VALUES '.implode(', ', $terms_values));
+ XDB::rawExecute('INSERT INTO profile_job_term (pid, jid, jtid, computed)
+ VALUES ' . implode(', ', $terms_values) . '
+ ON DUPLICATE KEY UPDATE computed = VALUES(computed)');
+ }
+ if (S::user()->isMe($page->owner) && count($value) > 1) {
+ Platal::page()->trigWarning('Attention, tu as plusieurs emplois sur ton profil. Pense à supprimer ceux qui sont obsolètes.');
}
}
- public function getText($value) {
+ public function getText($value)
+ {
+ static $pubs = array('public' => 'publique', 'ax' => 'annuaire AX', 'private' => 'privé');
$jobs = array();
foreach ($value as $id => $job) {
- $address = new ProfileSettingAddress();
+ $address = Address::formArrayToString(array($job['w_address']));
$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']);
+ $jobs[$id] = $job['name'];
+ $jobs[$id] .= ($job['description'] ? (', ' . $job['description']) : '');
+ $jobs[$id] .= ' (affichage ' . $pubs[$job['pub']];
+ if (count($job['terms'])) {
+ $terms = array();
+ foreach ($job['terms'] as $term) {
+ $terms[] = $term['full_name'];
+ }
+ $jobs[$id] .= ', mots-clefs : ' . implode(', ', $terms);
+ }
+ if ($job['w_url']) {
+ $jobs[$id] .= ', page perso : ' . $job['w_url'];
+ }
+ if ($address) {
+ $jobs[$id] .= ', adresse : ' . $address;
+ }
+ if ($job['w_email']) {
+ $jobs[$id] .= ', email : ' . $job['w_email'];
+ }
+ if ($phones) {
+ $jobs[$id] .= ', téléphones : ' . $phones;
+ }
+ $jobs[$id] .= ')';
}
return implode(' ; ' , $jobs);
}
class ProfileSettingCorps implements ProfileSetting
{
- public function value(ProfilePage &$page, $field, $value, &$success)
+ 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 = {?}",
+ $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)
+ 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());
+ 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);
+ static $pubs = array('public' => 'publique', 'ax' => 'annuaire AX', 'private' => 'privé');
+ $corpsList = DirEnum::getOptions(DirEnum::ORIGINCORPS);
$rankList = DirEnum::getOptions(DirEnum::CORPSRANKS);
- return 'Corps actuel : ' . $corpsList[$value['current']] . ' , rang : ' . $corpsList[$value['rank']]
- . ' , corps d\'origine : ' . $corpsList[$value['original']] . ' , affichage : ' . $value['pub'];
+ return $corpsList[$value['current']] . ', ' . $corpsList[$value['rank']] . ' ('
+ . 'corps d\'origine : ' . $corpsList[$value['original']] . ', affichage ' . $pubs[$value['pub']] . ')';
}
}
-class ProfileSettingJobs extends ProfilePage
+class ProfilePageJobs extends ProfilePage
{
protected $pg_template = 'profile/jobs.tpl';
- public function __construct(PlWizard &$wiz)
+ public function __construct(PlWizard $wiz)
{
parent::__construct($wiz);
- $this->settings['cv'] = null;
+ 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);
+ Platal::page()->assign('geocoding_removal', 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();
- }
- $res = XDB::iterator("SELECT e.jtid, e.full_name, j.jid AS jobid
- FROM profile_job_term_enum AS e
- INNER JOIN profile_job_term AS j USING(jtid)
- WHERE pid = {?}
- ORDER BY j.jid",
- $this->pid());
- $i = 0;
- $jobNb = count($this->values['jobs']);
- while ($term = $res->next()) {
- $jobid = $term['jobid'];
- while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
- $i++;
- }
- if ($i >= $jobNb) {
- break;
- }
- $job =& $this->values['jobs'][$i];
- if ($job['id'] != $jobid) {
- continue;
- }
- if (!isset($job['terms'])) {
- $job['terms'] = array();
- }
- $job['terms'][] = $term;
- }
-
- 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();
+ 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 profiles
- SET cv = {?}
- WHERE pid = {?}",
- $this->values['cv'], $this->pid());
+ 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)
+ public function _prepare(PlPage $page, $id)
{
require_once 'emails.combobox.inc.php';
- fill_email_combobox($page, $this->owner);
+ fill_email_combobox($page, array('redirect', 'job', 'stripped_directory'), $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());
+ if (!S::user()->isMe($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