modules/search.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2010 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 class SearchModule extends PLModule
  23 {
  24     function handlers()
  25     {
  26         return array(
  27             'search'              => $this->make_hook('quick',          AUTH_PUBLIC),
  28             'search/adv'          => $this->make_hook('advanced',       AUTH_COOKIE, 'directory_ax'),
  29             'advanced_search.php' => $this->make_hook('redir_advanced', AUTH_PUBLIC),
  30             'search/autocomplete' => $this->make_hook('autocomplete',   AUTH_COOKIE, 'directory_ax', NO_AUTH),
  31             'search/list'         => $this->make_hook('list',           AUTH_COOKIE, 'directory_ax', NO_AUTH),
  32             'jobs'                => $this->make_hook('referent',       AUTH_COOKIE),
  33             'emploi'              => $this->make_hook('referent',       AUTH_COOKIE),
  34             'referent/search'     => $this->make_hook('referent',       AUTH_COOKIE),
  35             'search/referent/countries' => $this->make_hook('referent_countries',     AUTH_COOKIE),
  36         );
  37     }
  38
  39     function handler_redir_advanced(&$page, $mode = null)
  40     {
  41         pl_redirect('search/adv');
  42         exit;
  43     }
  44
  45     function form_prepare()
  46     {
  47         Platal::page()->assign('formulaire',1);
  48     }
  49
  50     /**
  51      * $model: The way of presenting the results: minifiche, trombi, geoloc.
  52      * $byletter: Show only names beginning with this letter
  53      */
  54     function handler_quick(&$page, $model = null, $byletter = null)
  55     {
  56         global $globals;
  57
  58         if (Env::has('quick') || $model == 'geoloc') {
  59             $quick = Env::t('quick');
  60             if (S::logged() && !Env::has('page')) {
  61                 S::logger()->log('search', 'quick=' . $quick);
  62             }
  63
  64             if ($quick == '') {
  65                 $page->trigWarning('Aucun critère de recherche n\'est spécifié.');
  66                 $page->changeTpl('search/index.tpl');
  67                 $page->setTitle('Annuaire');
  68                 $page->assign('formulaire', 1);
  69                 $page->addJsLink('ajax.js');
  70                 return;
  71             }
  72
  73             $list = 'profile|prf|fiche|fic|referent|ref|mentor';
  74             if (S::admin()) {
  75                 $list .= '|admin|adm|ax';
  76             }
  77             $suffixes = array_keys(DirEnum::getOptions(DirEnum::ACCOUNTTYPES));
  78             $suffixes = implode('|', $suffixes);
  79             if (preg_match('/^(' . $list . '):([-a-z]+(\.[-a-z]+(\.(?:[md]?\d{2,4}|' . $suffixes . '))?)?)$/', replace_accent($quick), $matches)) {
  80                 $login = $matches[2];
  81                 switch($matches[1]) {
  82                   case 'admin': case 'adm':
  83                     $base = 'admin/user/';
  84                     break;
  85                   case 'ax':
  86                     $base = 'profile/ax/';
  87                     break;
  88                   case 'profile': case 'prf': case 'fiche': case 'fic':
  89                     $base = 'profile/';
  90                     break;
  91                   case 'referent': case 'ref': case 'mentor':
  92                     $base = 'referent/';
  93                     break;
  94                 }
  95
  96                 $user = User::getSilent($login);
  97                 if ($user) {
  98                     pl_redirect($base . $user->login());
  99                 }
 100                 $_REQUEST['quick'] = $login;
 101                 $_GET['quick'] = $login;
 102             } elseif (strpos($quick, 'doc:') === 0) {
 103                 $url = 'Docs/Recherche?';
 104                 $url .= 'action=search&q=' . urlencode(substr($quick, 4));
 105                 $url .= '&group=' . urlencode('-Equipe,-Main,-PmWiki,-Site,-Review');
 106                 pl_redirect($url);
 107             } elseif (strpos($quick, 'trombi:') === 0) {
 108                 $promo = substr($quick, 7);
 109                 $res = XDB::query("SELECT  diminutif
 110                                      FROM  groups
 111                                     WHERE  cat = 'Promotions' AND diminutif = {?}",
 112                                   $promo);
 113                 if ($res->numRows() == 0) {
 114                     $page->trigWarning("La promotion demandée n'est pas valide: $promo");
 115                 } else {
 116                     http_redirect('http://www.polytechnique.net/login/' . $promo . '/annuaire/trombi');
 117                 }
 118             }
 119
 120             $page->assign('formulaire', 0);
 121
 122             require_once 'userset.inc.php';
 123             $view = new SearchSet(true);
 124             $view->addMod('minifiche', 'Mini-fiches', true, array('with_score' => true, 'starts_with' => $byletter));
 125             if (S::logged() && !Env::i('nonins')) {
 126                 $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
 127                 // TODO: Reactivate when the new map is completed.
 128                 // $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'search/adv'));
 129             }
 130             $view->apply('search', $page, $model);
 131
 132             $nb_tot = $view->count();
 133             $page->assign('search_results_nb', $nb_tot);
 134             if (!S::logged() && $nb_tot > $globals->search->public_max) {
 135                 $page->trigError('Votre recherche a généré trop de résultats pour un affichage public.');
 136             } elseif ($nb_tot > $globals->search->private_max) {
 137                 $page->trigError('Recherche trop générale. Une <a href="search/adv">recherche avancée</a> permet de préciser la recherche.');
 138             } elseif (empty($nb_tot)) {
 139                 $page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
 140             }
 141         } else {
 142             $page->assign('formulaire',1);
 143             $page->addJsLink('ajax.js');
 144         }
 145
 146         $page->changeTpl('search/index.tpl');
 147         $page->setTitle('Annuaire');
 148     }
 149
 150     /** $model is the way of presenting the results: minifiche, trombi, geoloc.
 151      */
 152     function handler_advanced(&$page, $model = null, $byletter = null)
 153     {
 154         global $globals;
 155         $page->assign('advanced',1);
 156         $page->addJsLink('jquery.autocomplete.js');
 157
 158         if (!Env::has('rechercher') && $model != 'geoloc') {
 159             $this->form_prepare();
 160         } else {
 161             if (!Env::has('page')) {
 162                 S::logger()->log('search', 'adv=' . var_export($_GET, true));
 163             }
 164
 165             require_once 'userset.inc.php';
 166             $view = new SearchSet(false);
 167             if (!$view->isValid()) {
 168                 $this->form_prepare();
 169                 $page->trigError('Recherche invalide.');
 170             } else {
 171                 $view->addMod('minifiche', 'Mini-fiches', true, array('starts_with' => $byletter));
 172                 $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
 173                 // TODO: Reactivate when the new map is completed.
 174                 // $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'search/adv'));
 175                 $view->apply('search/adv', $page, $model);
 176
 177                 $nb_tot = $view->count();
 178                 if ($nb_tot > $globals->search->private_max) {
 179                     $this->form_prepare();
 180                     $page->trigError('Recherche trop générale.');
 181                 } else if ($nb_tot == 0) {
 182                     $this->form_prepare();
 183                     $page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
 184                 }
 185             }
 186         }
 187
 188         $page->changeTpl('search/index.tpl', $model == 'mini' ? SIMPLE : SKINNED);
 189         $page->addJsLink('ajax.js');
 190         $page->assign('public_directory',0);
 191     }
 192
 193     function handler_autocomplete(&$page, $type = null)
 194     {
 195         // Autocompletion : according to type required, return
 196         // a list of results matching with the number of matches.
 197         // The output format is :
 198         //   result1|nb1
 199         //   result2|nb2
 200         //   ...
 201         pl_content_headers("text/plain");
 202         $q = preg_replace(array('/\*+$/', // always look for $q*
 203                                 '/([\^\$\[\]])/', // escape special regexp char
 204                                 '/\*/'), // replace joker by regexp joker
 205                            array('',
 206                                  '\\\\\1',
 207                                  '.*'),
 208                            Env::s('q'));
 209         if (!$q) exit();
 210
 211         // try to look in cached results
 212         $cache = XDB::query('SELECT  result
 213                                FROM  search_autocomplete
 214                               WHERE  name = {?} AND
 215                                      query = {?} AND
 216                                      generated > NOW() - INTERVAL 1 DAY',
 217                              $type, $q);
 218         if ($res = $cache->fetchOneCell()) {
 219             echo $res;
 220             die();
 221         }
 222
 223         $enums = array(
 224             'binetTxt'           => DirEnum::BINETS,
 225             'groupexTxt'         => DirEnum::GROUPESX,
 226             'sectionTxt'         => DirEnum::SECTIONS,
 227             'networking_typeTxt' => DirEnum::NETWORKS,
 228             'city'               => DirEnum::LOCALITIES,
 229             'countryTxt'         => DirEnum::COUNTRIES,
 230             'entreprise'         => DirEnum::COMPANIES,
 231             'jobtermTxt'         => DirEnum::JOBTERMS,
 232             'description'        => DirEnum::JOBDESCRIPTION,
 233             'nationaliteTxt'     => DirEnum::NATIONALITIES,
 234             'schoolTxt'          => DirEnum::EDUSCHOOLS,
 235         );
 236         if (!array_key_exists($type, $enums)) {
 237             exit();
 238         }
 239
 240         $enum = $enums[$type];
 241
 242         $list = DirEnum::getAutoComplete($enum, $q);
 243         $nbResults = 0;
 244         $res = "";
 245         while ($result = $list->next()) {
 246             $nbResults++;
 247             if ($nbResults == 11) {
 248                 $res .= $q."|-1\n";
 249             } else {
 250                 $res .= $result['field'].'|';
 251                 if (isset($result['nb'])) {
 252                     $res .= $result['nb'];
 253                 }
 254                 if (isset($result['id'])) {
 255                     $res  .= '|'.$result['id'];
 256                 }
 257                 $res .= "\n";
 258             }
 259         }
 260         if ($nbResults == 0) {
 261             $res = $q."|-2\n";
 262         }
 263         XDB::query('REPLACE INTO  search_autocomplete
 264                           VALUES  ({?}, {?}, {?}, NOW())',
 265                     $type, $q, $res);
 266         echo $res;
 267         exit();
 268     }
 269
 270     function handler_list(&$page, $type = null, $idVal = null)
 271     {
 272         $page->assign('name', $type);
 273         $page->assign('with_text_value', true);
 274         $page->assign('onchange', "document.forms.recherche.{$type}Txt.value = this.options[this.selectedIndex].text");
 275
 276         // Give the list of all values possible of type and builds a select input for it
 277         $ids = null;
 278
 279         switch ($type) {
 280         case 'binet':
 281             $ids = DirEnum::getOptionsIter(DirEnum::BINETS);
 282             break;
 283           case 'networking_type':
 284             $ids = DirEnum::getOptionsIter(DirEnum::NETWORKS);
 285             break;
 286           case 'country':
 287             $ids = DirEnum::getOptionsIter(DirEnum::COUNTRIES);
 288             $page->assign('onchange', 'changeCountry(this.value)');
 289             break;
 290           case 'diploma':
 291             if (Env::has('school') && Env::i('school') != 0) {
 292               $ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES, Env::i('school'));
 293             } else {
 294               $ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES);
 295             }
 296             break;
 297           case 'groupex':
 298             $ids = DirEnum::getOptionsIter(DirEnum::GROUPESX);
 299             break;
 300           case 'nationalite':
 301             $ids = DirEnum::getOptionsIter(DirEnum::NATIONALITIES);
 302             break;
 303           case 'region':
 304             if (Env::has('country')) {
 305                 $ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS, Env::v('country'));
 306             } else {
 307                 $ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS);
 308             }
 309             break;
 310           case 'school':
 311             $ids = DirEnum::getOptionsIter(DirEnum::EDUSCHOOLS);
 312             $page->assign('onchange', 'changeSchool(this.value)');
 313             break;
 314           case 'section':
 315             $ids = DirEnum::getOptionsIter(DirEnum::SECTIONS);
 316             break;
 317           case 'jobterm':
 318             if (Env::has('jtid')) {
 319                 JobTerms::ajaxGetBranch(&$page, JobTerms::ONLY_JOBS);
 320                 return;
 321             } else {
 322                 pl_content_headers('text/xml');
 323                 echo '<div>'; // global container so that response is valid xml
 324                 echo '<input name="jobtermTxt" type="text" style="display:none" size="32" />';
 325                 echo '<input name="jobterm" type="hidden"/>';
 326                 echo '<div class="term_tree"></div>'; // container where to create the tree
 327                 echo '<script type="text/javascript" src="javascript/jquery.jstree.js"></script>';
 328                 echo '<script type="text/javascript" src="javascript/jobtermstree.js"></script>';
 329                 echo '<script type="text/javascript">createJobTermsTree(".term_tree", "search/list/jobterm", "search", "searchForJobTerm");</script>';
 330                 echo '</div>';
 331                 exit();
 332             }
 333           default: exit();
 334         }
 335         if (isset($idVal)) {
 336             pl_content_headers("text/plain");
 337             echo $ids[$idVal];
 338             exit();
 339         }
 340         pl_content_headers("text/xml");
 341         $page->changeTpl('include/field.select.tpl', NO_SKIN);
 342         $page->assign('list', $ids);
 343     }
 344
 345     function handler_referent(&$page, $action = null, $subaction = null)
 346     {
 347         global $globals;
 348
 349         $wp = new PlWikiPage('Docs.Emploi');
 350         $wp->buildCache();
 351
 352         $page->setTitle('Emploi et Carrières');
 353
 354         // Count mentors
 355         $res = XDB::query("SELECT count(distinct pid) FROM profile_mentor_term");
 356         $page->assign('mentors_number', $res->fetchOneCell());
 357
 358         $page->addJsLink('jquery.autocomplete.js');
 359
 360         // Search for mentors matching filters
 361         require_once 'ufbuilder.inc.php';
 362         $ufb = new UFB_MentorSearch();
 363         if (!$ufb->isEmpty()) {
 364             require_once 'userset.inc.php';
 365             $ufc = $ufb->getUFC();
 366             $set = new ProfileSet($ufc);
 367             $set->addMod('mentor', 'Référents');
 368             $set->apply('referent/search', $page, $action, $subaction);
 369             $nb_tot = $set->count();
 370             if ($nb_tot > $globals->search->private_max) {
 371                 $this->form_prepare();
 372                 $page->trigError('Recherche trop générale.');
 373                 $page->assign('plset_count', 0);
 374             } else if ($nb_tot == 0) {
 375                 $this->form_prepare();
 376                 $page->trigError('Il n\'existe personne correspondant à ces critères dans la base.');
 377             }
 378         }
 379
 380         $page->changeTpl('search/referent.tpl');
 381     }
 382
 383     /**
 384      * Builds a select field to choose among countries that referents
 385      * know about. Only referents linked to term (jtid) are displayed.
 386      * @param $jtid id of job term to restrict referents
 387      */
 388     function handler_referent_countries(&$page, $jtid = null)
 389     {
 390         pl_content_headers("text/xml");
 391         $page->changeTpl('include/field.select.tpl', NO_SKIN);
 392         $page->assign('name', 'country');
 393         $it = XDB::iterator("SELECT  gc.iso_3166_1_a2 AS id, gc.countryFR AS field
 394                                FROM  geoloc_countries       AS gc
 395                          INNER JOIN  profile_mentor_country AS mp ON (mp.country = gc.iso_3166_1_a2)
 396                          INNER JOIN  profile_mentor_term    AS mt ON (mt.pid = mp.pid)
 397                          INNER JOIN  profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid)
 398                               WHERE  jtr.jtid_1 = {?}
 399                            GROUP BY  iso_3166_1_a2
 400                            ORDER BY  countryFR", $jtid);
 401         $page->assign('list', $it);
 402     }
 403 }
 404
 405 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 406 ?>