-// {{{ 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'));
- }
-}
-// }}}