+ public function __construct(PlInnerSubIterator $it)
+ {
+ $this->pid = $it->value();
+ while ($term = $it->next()) {
+ $this->jobterms[] = new JobTerm($term);
+ }
+ }
+
+ public function get()
+ {
+ return $this->jobterms;
+ }
+
+ public static function fetchData(array $pids, ProfileVisibility $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 {?}
+ ORDER BY ' . XDB::formatCustomOrder('jt.pid', $pids),
+ $pids, $visibility->levels());
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}
+// {{{ class ProfileMentoringTerms [ Field ]
+class ProfileMentoringTerms extends ProfileJobTerms
+{
+ public static function fetchData(array $pids, ProfileVisibility $visibility)
+ {
+ $data = XDB::iterator('SELECT mt.jtid, jte.full_name, mt.pid
+ FROM profile_mentor_term AS mt
+ LEFT JOIN profile_job_term_enum AS jte USING(jtid)
+ WHERE mt.pid IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('mt.pid', $pids),
+ $pids);
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}