Profile::FETCH_MEDALS => 'ProfileMedals',
Profile::FETCH_NETWORKING => 'ProfileNetworking',
Profile::FETCH_PHONES => 'ProfilePhones',
- Profile::FETCH_MENTOR_SECTOR => 'ProfileMentoringSectors',
Profile::FETCH_MENTOR_COUNTRY => 'ProfileMentoringCountries',
Profile::FETCH_JOB_TERMS => 'ProfileJobTerms',
Profile::FETCH_MENTOR_TERMS => 'ProfileMentoringTerms',
public $user_site;
public $user_email;
- public $sector;
- public $subsector;
- public $subsubsector;
-
/** Fields are:
* pid, id, company_id, description, url, email
*/
}
$this->company = CompanyList::get($this->jobid);
if (is_null($this->company)) {
- $entreprise = ProfileValidate::get_typed_requests($this->pid, 'entreprise');
- $this->company = new Company(array('name' => $entreprise[$this->id]->name));
+ $entreprises = ProfileValidate::get_typed_requests($this->pid, 'entreprise');
+ foreach ($entreprises as $entreprise) {
+ if ($entreprise->id == $this->id) {
+ $this->company = new Company(array('name' => $entreprise->name));
+ }
+ }
}
}
public function setAddress(Address $address)
{
- if ($address->type == Address::LINK_JOB && $address->jobid == $this->id && $address->pid == $this->pid) {
+ if ($address->type == Address::LINK_JOB && $address->id == $this->id && $address->pid == $this->pid) {
$this->address = $address;
}
}
$data = XDB::iterator('SELECT pe.id, pe.pid,
pe.entry_year, pe.grad_year, pe.program, pe.flags,
pee.name AS school, pee.abbreviation AS school_short,
- pee.url AS school_url, gc.countryFR AS country,
+ pee.url AS school_url, gc.country,
pede.degree, pede.abbreviation AS degree_short, pede.level AS degree_level,
pefe.field
FROM profile_education AS pe
}
}
// }}}
-// {{{ class ProfileMentoringSectors [ Field ]
-class ProfileMentoringSectors extends ProfileField
-{
- public $sectors = array();
-
- public function __construct(PlInnerSubIterator $it)
- {
- $this->pid = $it->value();
- while ($sector = $it->next()) {
- $this->sectors[] = $sector;
- }
- }
-
- public static function fetchData(array $pids, ProfileVisibility $visibility)
- {
- $data = XDB::iterator('SELECT pms.pid, pjse.name AS sector, pjsse.name AS subsector
- FROM profile_mentor_sector AS pms
- LEFT JOIN profile_job_sector_enum AS pjse ON (pjse.id = pms.sectorid)
- LEFT JOIN profile_job_subsector_enum AS pjsse ON (pjsse.id = pms.subsectorid)
- WHERE pms.pid IN {?}
- ORDER BY ' . XDB::formatCustomOrder('pms.pid', $pids),
- $pids);
-
- return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
- }
-}
-// }}}
// {{{ class ProfileMentoringCountries [ Field ]
class ProfileMentoringCountries extends ProfileField
{
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
- $data = XDB::iterator('SELECT pmc.pid, pmc.country AS id, gc.countryFR AS name
+ $data = XDB::iterator('SELECT pmc.pid, pmc.country AS id, gc.country AS name
FROM profile_mentor_country AS pmc
LEFT JOIN geoloc_countries AS gc ON (gc.iso_3166_1_a2 = pmc.country)
WHERE pmc.pid IN {?}
{
$p = $phones->get(Profile::PHONE_LINK_ADDRESS | Profile::PHONE_TYPE_ANY);
foreach ($p as $phone) {
- if ($phone->linkType() == Phone::LINK_ADDRESS && array_key_exists($phone->linkId(), $this->addresses)) {
- $this->addresses[$phone->linkId()]->addPhone($phone);
+ /* We must iterate on the addresses because id is not uniq thus,
+ * $this->addresse[$phone->linkId()] is invalid.
+ */
+ foreach ($this->addresses as $address) {
+ if ($address->type == Address::LINK_PROFILE && $address->id == $phone->linkId()) {
+ $address->addPhone($phone);
+ }
}
}
}
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
CompanyList::preload($pids);
- $data = XDB::iterator('SELECT pj.id, pj.pid, pj.description, pj.url as user_site,
- IF(pj.email_pub IN {?}, pj.email, NULL) AS user_email,
- pj.jobid, pjse.name AS sector, pjsse.name AS subsector,
- pjssse.name AS subsubsector
- FROM profile_job AS pj
- LEFT JOIN profile_job_sector_enum AS pjse ON (pjse.id = pj.sectorid)
- LEFT JOIN profile_job_subsector_enum AS pjsse ON (pjsse.id = pj.subsectorid)
- LEFT JOIN profile_job_subsubsector_enum AS pjssse ON (pjssse.id = pj.subsubsectorid)
- WHERE pj.pid IN {?} AND pj.pub IN {?}
- ORDER BY ' . XDB::formatCustomOrder('pid', $pids) . ',
- pj.id',
+ $data = XDB::iterator('SELECT id, pid, description, url as user_site, jobid,
+ IF(email_pub IN {?}, email, NULL) AS user_email
+ FROM profile_job
+ WHERE pid IN {?} AND pub IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('pid', $pids) . ', id',
$visibility->levels(), $pids, $visibility->levels());
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
}
$a = $addresses->get(Profile::ADDRESS_PRO);
foreach ($a as $address) {
if ($address->type == Address::LINK_JOB && array_key_exists($address->jobid, $this->jobs)) {
- $this->jobs[$address->jobid]->setAddress($address);
+ $this->jobs[$address->id]->setAddress($address);
}
}
}
if (!array_key_exists($id, self::$companies)) {
self::preload();
}
- return self::$companies[$id];
+ if (isset(self::$companies[$id])) {
+ return self::$companies[$id];
+ }
+ return null;
}
}