+ /**
+ * Page for url "referent/autocomplete". Display an "autocomplete" page (plain/text with values
+ * separated by "|" chars) for jobterms in referent (mentor) search.
+ * @see handler_jobterms
+ */
+ function handler_ref_autocomplete($page)
+ {
+ $this->handler_jobterms($page, 'mentor');
+ }
+
+ /**
+ * Page for url "profile/jobterms" (function also used for "referent/autocomplete" @see
+ * handler_ref_autocomplete). Displays an "autocomplete" page (plain text with values
+ * separated by "|" chars) for jobterms to add in profile.
+ * @param $page the Platal page
+ * @param $type set to 'mentor' to display the number of mentors for each term and order
+ * by descending number of mentors.
+ *
+ * @param Env::v('q') the text that has been typed and to complete automatically
+ */
+ function handler_jobterms($page, $type = 'nomentor')
+ {
+ pl_content_headers("text/plain");
+
+ $q = Env::v('q').'%';
+ $tokens = JobTerms::tokenize($q);
+ if (count($tokens) == 0) {
+ exit;
+ }
+ sort($tokens);
+ $q_normalized = implode(' ', $tokens);
+
+ // try to look in cached results
+ $cache = XDB::query('SELECT result
+ FROM search_autocomplete
+ WHERE name = {?} AND
+ query = {?} AND
+ generated > NOW() - INTERVAL 1 DAY',
+ $type, $q_normalized);
+ if ($res = $cache->fetchOneCell()) {
+ echo $res;
+ die();
+ }
+
+ $joins = JobTerms::token_join_query($tokens, 'e');
+ if ($type == 'mentor') {
+ $count = ', COUNT(DISTINCT pid) AS nb';
+ $countjoin = ' INNER JOIN profile_job_term_relation AS r ON(r.jtid_1 = e.jtid) INNER JOIN profile_mentor_term AS m ON(r.jtid_2 = m.jtid)';
+ $countorder = 'nb DESC, ';
+ } else {
+ $count = $countjoin = $countorder = '';
+ }
+ $list = XDB::iterator('SELECT e.jtid AS id, e.full_name AS field'.$count.'
+ FROM profile_job_term_enum AS e '.$joins.$countjoin.'
+ GROUP BY e.jtid
+ ORDER BY '.$countorder.'field
+ LIMIT 11');
+ $nbResults = 0;
+ $res = '';
+ while ($result = $list->next()) {
+ $nbResults++;
+ if ($nbResults == 11) {
+ $res .= $q."|-1\n";
+ } else {
+ $res .= $result['field'].'|';
+ if ($count) {
+ $res .= $result['nb'].'|';
+ }
+ $res .= $result['id'];
+ }
+ $res .= "\n";
+ }
+ XDB::query('INSERT INTO search_autocomplete (name, query, result, generated)
+ VALUES ({?}, {?}, {?}, NOW())
+ ON DUPLICATE KEY UPDATE result = VALUES(result), generated = VALUES(generated)',
+ $type, $q_normalized, $res);
+ echo $res;
+ exit();
+ }
+
+ function handler_xnet($page)