<?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 *
Profile::FETCH_MENTOR_COUNTRY => 'ProfileMentoringCountries',
Profile::FETCH_JOB_TERMS => 'ProfileJobTerms',
Profile::FETCH_MENTOR_TERMS => 'ProfileMentoringTerms',
+ Profile::FETCH_SKILL => 'ProfileSkills',
+ Profile::FETCH_LANGUAGE => 'ProfileLanguages',
+ Profile::FETCH_PARTNER => 'ProfilePartnerSharing',
);
/** The profile to which this field belongs
*
* MUST be reimplemented for each kind of ProfileField.
*/
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
return PlIteratorUtils::emptyIterator();
}
- public static function buildForPID($cls, $pid, ProfileVisibility $visibility)
+ public static function buildForPID($cls, $pid, Visibility $visibility)
{
$res = self::buildFromPIDs($cls, array($pid), $visibility);
return array_pop($res);
* @param $visibility An array of allowed visibility contexts
* @return An array of $pid => ProfileField
*/
- public static function buildFromPIDs($cls, array $pids, ProfileVisibility $visibility)
+ public static function buildFromPIDs($cls, array $pids, Visibility $visibility)
{
$it = new ProfileFieldIterator($cls, $pids, $visibility);
$res = array();
return $res;
}
- public static function getForPID($cls, $pid, ProfileVisibility $visibility)
+ public static function getForPID($cls, $pid, Visibility $visibility)
{
$it = new ProfileFieldIterator($cls, array($pid), $visibility);
return $it->next();
private $data;
private $cls;
- public function __construct($cls, array $pids, ProfileVisibility $visibility)
+ public function __construct($cls, array $pids, Visibility $visibility)
{
if (is_numeric($cls) && isset(ProfileField::$fields[$cls])) {
$cls = ProfileField::$fields[$cls];
}
}
- public function setPhone(Phone &$phone)
+ public function setPhone(Phone $phone)
{
- if ($phone->linkType() == Phone::LINK_COMPANY && $phone->linkId() == $this->id) {
+ if ($phone->link_type == Phone::LINK_COMPANY && $phone->link_id == $this->id) {
$this->phone = $phone;
}
}
- public function setAddress(Address &$address)
+ public function setAddress(Address $address)
{
if ($address->type == Address::LINK_COMPANY && $address->jobid == $this->id) {
$this->address = $address;
public $user_site;
public $user_email;
+ public $pub;
+ public $email_pub;
+
/** Fields are:
* pid, id, company_id, description, url, email
*/
return $this->address;
}
- public function addPhone(Phone &$phone)
+ public function addPhone(Phone $phone)
{
- if ($phone->linkType() == Phone::LINK_JOB && $phone->linkId() == $this->id && $phone->pid() == $this->pid) {
+ if ($phone->link_type == Phone::LINK_JOB && $phone->link_id == $this->id && $phone->pid == $this->pid) {
$this->phones[$phone->uniqueId()] = $phone;
}
}
}
}
- public function addTerm(JobTerm &$term)
+ public function addTerm(JobTerm $term)
{
$this->terms[$term->jtid] = $term;
}
return $educations;
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT pe.id, pe.pid,
pe.entry_year, pe.grad_year, pe.program, pe.flags,
}
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
- $data = XDB::iterator('SELECT pm.pid, pm.mid, pm.gid, pme.text, pme.img, pmge.text AS grade
+ $data = XDB::iterator('SELECT pm.pid, pm.mid, pm.gid, pme.text, pme.img, pmge.text AS grade, pm.level
FROM profile_medals AS pm
LEFT JOIN profiles AS p ON (pm.pid = p.pid)
LEFT JOIN profile_medal_enum AS pme ON (pme.id = pm.mid)
LEFT JOIN profile_medal_grade_enum AS pmge ON (pmge.mid = pm.mid AND pmge.gid = pm.gid)
- WHERE pm.pid IN {?} AND p.medals_pub IN {?}
+ LEFT JOIN profile_visibility_enum AS pve ON (pve.access_level = {?})
+ WHERE pm.pid IN {?} AND pve.best_display_level + 0 <= p.medals_pub + 0
ORDER BY ' . XDB::formatCustomOrder('pm.pid', $pids),
- $pids, $visibility->levels());
+ $visibility->level(), $pids);
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
}
}
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT pid, id, address, pne.nwid, pne.network_type, pne.link, pne.name
FROM profile_networking AS pn
LEFT JOIN profile_networking_enum AS pne USING(nwid)
- WHERE pid IN {?} AND pub IN {?}
+ LEFT JOIN profile_visibility_enum AS pve ON (pve.access_level = {?})
+ WHERE pn.pid IN {?} AND pve.best_display_level + 0 <= pn.pub + 0
ORDER BY ' . XDB::formatCustomOrder('pid', $pids) . ',
pn.nwid, id',
- $pids, $visibility->levels());
+ $visibility->level(), $pids);
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
}
}
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT pc.pid, pc.original_corpsid AS original, pc.current_corpsid AS current,
pceo.name AS original_name, pceo.abbreviation AS original_abbrev,
LEFT JOIN profile_corps_enum AS pceo ON (pceo.id = pc.original_corpsid)
LEFT JOIN profile_corps_enum AS pcec ON (pcec.id = pc.current_corpsid)
LEFT JOIN profile_corps_rank_enum AS pcrec ON (pcrec.id = pc.rankid)
- WHERE pc.pid IN {?} AND pc.corps_pub IN {?} AND pceo.id != 1
+ LEFT JOIN profile_visibility_enum AS pve ON (pve.access_level = {?})
+ WHERE pc.pid IN {?} AND pve.best_display_level + 0 <= pc.corps_pub + 0 AND pceo.id != 1
ORDER BY ' . XDB::formatCustomOrder('pid', $pids),
- $pids, $visibility->levels());
+ $visibility->level(), $pids);
return $data;
}
}
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT pmc.pid, pmc.country AS id, gc.country AS name
FROM profile_mentor_country AS pmc
return $addresses;
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
- $it = Address::iterate($pids, array(), array(), $visibility->levels());
+ $it = Address::iterate($pids, array(), array(), $visibility);
return PlIteratorUtils::subIterator($it->value(), PlIteratorUtils::arrayValueCallback('pid'));
}
$p = $phones->get(Profile::PHONE_LINK_ADDRESS | Profile::PHONE_TYPE_ANY);
foreach ($p as $phone) {
/* We must iterate on the addresses because id is not uniq thus,
- * $this->addresse[$phone->linkId()] is invalid.
+ * $this->addresse[$phone->link_id] is invalid.
*/
foreach ($this->addresses as $address) {
- if ($address->type == Address::LINK_PROFILE && $address->id == $phone->linkId()) {
+ if ($address->type == Address::LINK_PROFILE && $address->id == $phone->link_id) {
$address->addPhone($phone);
}
}
return $phones;
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
- $it = Phone::iterate($pids, array(), array(), $visibility->levels());
+ $it = Phone::iterate($pids, array(), array(), $visibility);
return PlIteratorUtils::subIterator($it->value(), PlIteratorUtils::arrayValueCallback('pid'));
}
}
}
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
CompanyList::preload($pids);
- $data = XDB::iterator('SELECT id, pid, description, url as user_site, jobid,
- IF(email_pub IN {?}, email, NULL) AS user_email
+ $data = XDB::iterator('SELECT id, pid, description, url as user_site, jobid, pub, IF(pve.best_display_level + 0 <= email_pub + 0, email, NULL) AS user_email, email_pub
FROM profile_job
- WHERE pid IN {?} AND pub IN {?}
+ LEFT JOIN profile_visibility_enum AS pve ON (pve.access_level = {?})
+ WHERE pid IN {?} AND pve.best_display_level + 0 <= pub + 0
ORDER BY ' . XDB::formatCustomOrder('pid', $pids) . ', id',
- $visibility->levels(), $pids, $visibility->levels());
+ $visibility->level(), $pids);
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
}
{
$p = $phones->get(Profile::PHONE_LINK_JOB | Profile::PHONE_TYPE_ANY);
foreach ($p as $phone) {
- if ($phone->linkType() == Phone::LINK_JOB && array_key_exists($phone->linkId(), $this->jobs)) {
- $this->jobs[$phone->linkId()]->addPhone($phone);
+ if ($phone->link_type == Phone::LINK_JOB && array_key_exists($phone->link_id, $this->jobs)) {
+ $this->jobs[$phone->link_id]->addPhone($phone);
}
}
}
{
$a = $addresses->get(Profile::ADDRESS_PRO);
foreach ($a as $address) {
- if ($address->type == Address::LINK_JOB && array_key_exists($address->jobid, $this->jobs)) {
+ if ($address->type == Address::LINK_JOB && array_key_exists($address->id, $this->jobs)) {
$this->jobs[$address->id]->setAddress($address);
}
}
$terms = $jobterms->get();
foreach ($terms as $term) {
if ($this->pid == $term->pid && array_key_exists($term->jid, $this->jobs)) {
- $this->jobs[$term->jid]->addTerm(&$term);
+ $this->jobs[$term->jid]->addTerm($term);
}
}
}
return $this->jobterms;
}
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT jt.jtid, jte.full_name, jt.pid, jt.jid
FROM profile_job_term AS jt
INNER JOIN profile_job AS j ON (jt.pid = j.pid AND jt.jid = j.id)
LEFT JOIN profile_job_term_enum AS jte USING(jtid)
- WHERE jt.pid IN {?} AND j.pub IN {?}
+ LEFT JOIN profile_visibility_enum AS pve ON (pve.access_level = {?})
+ WHERE jt.pid IN {?} AND pve.best_display_level + 0 <= j.pub + 0
ORDER BY ' . XDB::formatCustomOrder('jt.pid', $pids),
- $pids, $visibility->levels());
+ $visibility->level(), $pids);
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
}
}
// {{{ class ProfileMentoringTerms [ Field ]
class ProfileMentoringTerms extends ProfileJobTerms
{
- public static function fetchData(array $pids, ProfileVisibility $visibility)
+ public static function fetchData(array $pids, Visibility $visibility)
{
$data = XDB::iterator('SELECT mt.jtid, jte.full_name, mt.pid
FROM profile_mentor_term AS mt
}
}
// }}}
+// {{{ class ProfileSkills [ Field ]
+class ProfileSkills extends ProfileField
+{
+ public $skills = array();
+
+ public function __construct(PlInnerSubIterator $it)
+ {
+ $this->pid = $it->value();
+ while ($skill = $it->next()) {
+ $this->skills[$skill['cid']] = $skill;
+ }
+ }
+
+ public static function fetchData(array $pids, Visibility $visibility)
+ {
+ $data = XDB::iterator('SELECT ps.cid, pse.text_fr, ps.level, ps.pid
+ FROM profile_skills AS ps
+ INNER JOIN profile_skill_enum AS pse ON (pse.id = ps.cid)
+ WHERE ps.pid IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('ps.pid', $pids),
+ $pids);
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}
+// {{{ class ProfileLanguages [ Field ]
+class ProfileLanguages extends ProfileField
+{
+ public $languages = array();
+
+ public function __construct(PlInnerSubIterator $it)
+ {
+ static $levels = array(
+ 1 => 'connaissance basique',
+ 2 => 'maîtrise des bases',
+ 3 => 'maîtrise limitée',
+ 4 => 'maîtrise générale',
+ 5 => 'bonne maîtrise',
+ 6 => 'maîtrise complète'
+ );
+
+ $this->pid = $it->value();
+ while ($language = $it->next()) {
+ $this->languages[$language['lid']] = $language;
+ $this->languages[$language['lid']]['level'] = $levels[$language['level']];
+ }
+ }
+
+ public static function fetchData(array $pids, Visibility $visibility)
+ {
+ $data = XDB::iterator('SELECT ps.lid, pse.language, ps.level, ps.pid
+ FROM profile_langskills AS ps
+ INNER JOIN profile_langskill_enum AS pse ON (pse.iso_639_2b = ps.lid)
+ WHERE ps.pid IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('ps.pid', $pids),
+ $pids);
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}
+// {{{ class ProfilePartnerSharing [ Field ]
+class ProfilePartnerSharing extends ProfileField
+{
+ public function __construct(PlInnerSubIterator $it)
+ {
+ require_once 'partnersharing.inc.php';
+
+ $this->pid = $it->value();
+ while ($partner_settings = $it->next()) {
+ $settings = new PartnerSettings($partner_settings);
+ $this->partners_settings[$settings->partner->id] = $settings;
+ }
+ }
+
+ public static function fetchData(array $pids, Visibility $visibility)
+ {
+ $data = XDB::iterator('SELECT ppss.pid, ppss.exposed_uid, ppss.sharing_level,
+ ppss.allow_email, ppss.partner_id,
+ ppse.shortname AS partner_shortname,
+ ppse.name AS partner_name,
+ ppse.url AS partner_url
+ FROM profile_partnersharing_settings AS ppss
+ LEFT JOIN profile_partnersharing_enum AS ppse ON (ppss.partner_id = ppse.id)
+ WHERE ppss.pid IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('ppss.pid', $pids),
+ $pids);
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+
+ public function get($partner_id)
+ {
+ if (isset($this->partners_settings[$partner_id])) {
+ return $this->partners_settings[$partner_id];
+ } else {
+ return PartnerSettings::getEmpty($partner_id);
+ }
+ }
+}
+// }}}
// {{{ class CompanyList
class CompanyList
{
}
$it = XDB::iterator('SELECT pje.id, pje.name, pje.acronym, pje.url,
- pa.flags, pa.text, pa.postalCode, pa.countryId,
- pa.type, pa.pub
+ pa.flags, pa.text, pa.type, pa.pub
FROM profile_job_enum AS pje
LEFT JOIN profile_addresses AS pa ON (pje.id = pa.jobid AND pa.type = \'hq\')
' . $join . '
// Add phones to hq
if (count($newcompanies)) {
- $it = Phone::iterate(array(), array(Phone::LINK_COMPANY), $newcompanies);
+ $it = Phone::iterate(array(), array(Phone::LINK_COMPANY), $newcompanies, Visibility::defaultForRead());
while ($phone = $it->next()) {
- self::$companies[$phone->linkId()]->setPhone($phone);
+ self::$companies[$phone->link_id]->setPhone($phone);
}
}
static public function get($id)
{
- if (!array_key_exists($id, self::$companies)) {
+ if (!is_null($id) && !array_key_exists($id, self::$companies)) {
self::preload();
}
if (isset(self::$companies[$id])) {
return null;
}
}
+// }}}
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>