[platal.git] / modules / search.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2010 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

class SearchModule extends PLModule
{
    function handlers()
    {
        return array(
            'search'              => $this->make_hook('quick',          AUTH_PUBLIC),
            'search/adv'          => $this->make_hook('advanced',       AUTH_COOKIE, 'directory_ax'),
            'advanced_search.php' => $this->make_hook('redir_advanced', AUTH_PUBLIC),
            'search/autocomplete' => $this->make_hook('autocomplete',   AUTH_COOKIE, 'directory_ax', NO_AUTH),
            'search/list'         => $this->make_hook('list',           AUTH_COOKIE, 'directory_ax', NO_AUTH),
            'jobs'                => $this->make_hook('referent',       AUTH_COOKIE),
            'emploi'              => $this->make_hook('referent',       AUTH_COOKIE),
            'referent/search'     => $this->make_hook('referent',       AUTH_COOKIE),
            'search/referent/countries' => $this->make_hook('referent_countries',     AUTH_COOKIE),
        );
    }

    function handler_redir_advanced(&$page, $mode = null)
    {
        pl_redirect('search/adv');
        exit;
    }

    function form_prepare()
    {
        Platal::page()->assign('formulaire',1);
    }

    /** 
     * $model: The way of presenting the results: minifiche, trombi, geoloc.
     * $byletter: Show only names beginning with this letter
     */
    function handler_quick(&$page, $model = null, $byletter = null)
    {
        global $globals;

        if (Env::has('quick') || $model == 'geoloc') {
            $quick = Env::t('quick');
            if (S::logged() && !Env::has('page')) {
                S::logger()->log('search', 'quick=' . $quick);
            }

            if ($quick == '') {
                $page->trigWarning('Aucun critère de recherche n\'est spécifié.');
                $page->changeTpl('search/index.tpl');
                $page->setTitle('Annuaire');
                $page->assign('formulaire', 1);
                $page->addJsLink('ajax.js');
                return;
            }

            $list = 'profile|prf|fiche|fic|referent|ref|mentor';
            if (S::admin()) {
                $list .= '|admin|adm|ax';
            }
            $suffixes = array_keys(DirEnum::getOptions(DirEnum::ACCOUNTTYPES));
            $suffixes = implode('|', $suffixes);
            if (preg_match('/^(' . $list . '):([-a-z]+(\.[-a-z]+(\.(?:[md]?\d{2,4}|' . $suffixes . '))?)?)$/', replace_accent($quick), $matches)) {
                $login = $matches[2];
                switch($matches[1]) {
                  case 'admin': case 'adm':
                    $base = 'admin/user/';
                    break;
                  case 'ax':
                    $base = 'profile/ax/';
                    break;
                  case 'profile': case 'prf': case 'fiche': case 'fic':
                    $base = 'profile/';
                    break;
                  case 'referent': case 'ref': case 'mentor':
                    $base = 'referent/';
                    break;
                }

                $user = User::getSilent($login);
                if ($user) {
                    pl_redirect($base . $user->login());
                }
                $_REQUEST['quick'] = $login;
                $_GET['quick'] = $login;
            } elseif (strpos($quick, 'doc:') === 0) {
                $url = 'Docs/Recherche?';
                $url .= 'action=search&q=' . urlencode(substr($quick, 4));
                $url .= '&group=' . urlencode('-Equipe,-Main,-PmWiki,-Site,-Review');
                pl_redirect($url);
            } elseif (strpos($quick, 'trombi:') === 0) {
                $promo = substr($quick, 7);
                $res = XDB::query("SELECT  diminutif
                                     FROM  groups
                                    WHERE  cat = 'Promotions' AND diminutif = {?}",
                                  $promo);
                if ($res->numRows() == 0) {
                    $page->trigWarning("La promotion demandée n'est pas valide: $promo");
                } else {
                    http_redirect('http://www.polytechnique.net/login/' . $promo . '/annuaire/trombi');
                }
            }

            $page->assign('formulaire', 0);

            require_once 'userset.inc.php';
            $view = new SearchSet(true);
            $view->addMod('minifiche', 'Mini-fiches', true, array('with_score' => true, 'starts_with' => $byletter));
            if (S::logged() && !Env::i('nonins')) {
                $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
                // TODO: Reactivate when the new map is completed.
                // $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'search/adv'));
            }
            $view->apply('search', $page, $model);

            $nb_tot = $view->count();
            $page->assign('search_results_nb', $nb_tot);
            if (!S::logged() && $nb_tot > $globals->search->public_max) {
                $page->trigError('Votre recherche a généré trop de résultats pour un affichage public.');
            } elseif ($nb_tot > $globals->search->private_max) {
                $page->trigError('Recherche trop générale. Une <a href="search/adv">recherche avancée</a> permet de préciser la recherche.');
            } elseif (empty($nb_tot)) {
                $page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
            }
        } else {
            $page->assign('formulaire',1);
            $page->addJsLink('ajax.js');
        }

        $page->changeTpl('search/index.tpl');
        $page->setTitle('Annuaire');
    }

    /** $model is the way of presenting the results: minifiche, trombi, geoloc.
     */
    function handler_advanced(&$page, $model = null, $byletter = null)
    {
        global $globals;
        $page->assign('advanced',1);
        $page->addJsLink('jquery.autocomplete.js');

        if (!Env::has('rechercher') && $model != 'geoloc') {
            $this->form_prepare();
        } else {
            if (!Env::has('page')) {
                S::logger()->log('search', 'adv=' . var_export($_GET, true));
            }

            require_once 'userset.inc.php';
            $view = new SearchSet(false);
            if (!$view->isValid()) {
                $this->form_prepare();
                $page->trigError('Recherche invalide.');
            } else {
                $view->addMod('minifiche', 'Mini-fiches', true, array('starts_with' => $byletter));
                $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
                // TODO: Reactivate when the new map is completed.
                // $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'search/adv'));
                $view->apply('search/adv', $page, $model);

                $nb_tot = $view->count();
                if ($nb_tot > $globals->search->private_max) {
                    $this->form_prepare();
                    $page->trigError('Recherche trop générale.');
                } else if ($nb_tot == 0) {
                    $this->form_prepare();
                    $page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
                }
            }
        }

        $page->changeTpl('search/index.tpl', $model == 'mini' ? SIMPLE : SKINNED);
        $page->addJsLink('ajax.js');
        $page->assign('public_directory',0);
    }

    function handler_autocomplete(&$page, $type = null)
    {
        // Autocompletion : according to type required, return
        // a list of results matching with the number of matches.
        // The output format is :
        //   result1|nb1
        //   result2|nb2
        //   ...
        pl_content_headers("text/plain");
        $q = preg_replace(array('/\*+$/', // always look for $q*
                                '/([\^\$\[\]])/', // escape special regexp char
                                '/\*/'), // replace joker by regexp joker
                           array('',
                                 '\\\\\1',
                                 '.*'),
                           Env::s('q'));
        if (!$q) exit();

        // 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);
        if ($res = $cache->fetchOneCell()) {
            echo $res;
            die();
        }

        $enums = array(
            'binetTxt'           => DirEnum::BINETS,
            'groupexTxt'         => DirEnum::GROUPESX,
            'sectionTxt'         => DirEnum::SECTIONS,
            'networking_typeTxt' => DirEnum::NETWORKS,
            'city'               => DirEnum::LOCALITIES,
            'countryTxt'         => DirEnum::COUNTRIES,
            'entreprise'         => DirEnum::COMPANIES,
            'jobtermTxt'         => DirEnum::JOBTERMS,
            'description'        => DirEnum::JOBDESCRIPTION,
            'nationaliteTxt'     => DirEnum::NATIONALITIES,
            'schoolTxt'          => DirEnum::EDUSCHOOLS,
        );
        if (!array_key_exists($type, $enums)) {
            exit();
        }

        $enum = $enums[$type];

        $list = DirEnum::getAutoComplete($enum, $q);
        $nbResults = 0;
        $res = "";
        while ($result = $list->next()) {
            $nbResults++;
            if ($nbResults == 11) {
                $res .= $q."|-1\n";
            } else {
                $res .= $result['field'].'|';
                if (isset($result['nb'])) {
                    $res .= $result['nb'];
                }
                if (isset($result['id'])) {
                    $res  .= '|'.$result['id'];
                }
                $res .= "\n";
            }
        }
        if ($nbResults == 0) {
            $res = $q."|-2\n";
        }
        XDB::query('REPLACE INTO  search_autocomplete
                          VALUES  ({?}, {?}, {?}, NOW())',
                    $type, $q, $res);
        echo $res;
        exit();
    }

    function handler_list(&$page, $type = null, $idVal = null)
    {
        $page->assign('name', $type);
        $page->assign('with_text_value', true);
        $page->assign('onchange', "document.forms.recherche.{$type}Txt.value = this.options[this.selectedIndex].text");

        // Give the list of all values possible of type and builds a select input for it
        $ids = null;

        switch ($type) {
        case 'binet':
            $ids = DirEnum::getOptionsIter(DirEnum::BINETS);
            break;
          case 'networking_type':
            $ids = DirEnum::getOptionsIter(DirEnum::NETWORKS);
            break;
          case 'country':
            $ids = DirEnum::getOptionsIter(DirEnum::COUNTRIES);
            $page->assign('onchange', 'changeCountry(this.value)');
            break;
          case 'diploma':
            if (Env::has('school') && Env::i('school') != 0) {
              $ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES, Env::i('school'));
            } else {
              $ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES);
            }
            break;
          case 'groupex':
            $ids = DirEnum::getOptionsIter(DirEnum::GROUPESX);
            break;
          case 'nationalite':
            $ids = DirEnum::getOptionsIter(DirEnum::NATIONALITIES);
            break;
          case 'region':
            if (Env::has('country')) {
                $ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS, Env::v('country'));
            } else {
                $ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS);
            }
            break;
          case 'school':
            $ids = DirEnum::getOptionsIter(DirEnum::EDUSCHOOLS);
            $page->assign('onchange', 'changeSchool(this.value)');
            break;
          case 'section':
            $ids = DirEnum::getOptionsIter(DirEnum::SECTIONS);
            break;
          case 'jobterm':
            if (Env::has('jtid')) {
                JobTerms::ajaxGetBranch(&$page, JobTerms::ONLY_JOBS);
                return;
            } else {
                pl_content_headers('text/xml');
                echo '<div>'; // global container so that response is valid xml
                echo '<input name="jobtermTxt" type="text" style="display:none" size="32" />';
                echo '<input name="jobterm" type="hidden"/>';
                echo '<div class="term_tree"></div>'; // container where to create the tree
                echo '<script type="text/javascript" src="javascript/jquery.jstree.js"></script>';
                echo '<script type="text/javascript" src="javascript/jobtermstree.js"></script>';
                echo '<script type="text/javascript">createJobTermsTree(".term_tree", "search/list/jobterm", "search", "searchForJobTerm");</script>';
                echo '</div>';
                exit();
            }
          default: exit();
        }
        if (isset($idVal)) {
            pl_content_headers("text/plain");
            echo $ids[$idVal];
            exit();
        }
        pl_content_headers("text/xml");
        $page->changeTpl('include/field.select.tpl', NO_SKIN);
        $page->assign('list', $ids);
    }

    function handler_referent(&$page, $action = null, $subaction = null)
    {
        global $globals;

        $wp = new PlWikiPage('Docs.Emploi');
        $wp->buildCache();

        $page->setTitle('Emploi et Carrières');

        // Count mentors
        $res = XDB::query("SELECT count(distinct pid) FROM profile_mentor_term");
        $page->assign('mentors_number', $res->fetchOneCell());

        $page->addJsLink('jquery.autocomplete.js');

        // Search for mentors matching filters
        require_once 'ufbuilder.inc.php';
        $ufb = new UFB_MentorSearch();
        if (!$ufb->isEmpty()) {
            require_once 'userset.inc.php';
            $ufc = $ufb->getUFC();
            $set = new ProfileSet($ufc);
            $set->addMod('mentor', 'Référents');
            $set->apply('referent/search', $page, $action, $subaction);
            $nb_tot = $set->count();
            if ($nb_tot > $globals->search->private_max) {
                $this->form_prepare();
                $page->trigError('Recherche trop générale.');
                $page->assign('plset_count', 0);
            } else if ($nb_tot == 0) {
                $this->form_prepare();
                $page->trigError('Il n\'existe personne correspondant à ces critères dans la base.');
            }
        }

        $page->changeTpl('search/referent.tpl');
    }

    /**
     * Builds a select field to choose among countries that referents
     * know about. Only referents linked to term (jtid) are displayed.
     * @param $jtid id of job term to restrict referents
     */
    function handler_referent_countries(&$page, $jtid = null)
    {
        pl_content_headers("text/xml");
        $page->changeTpl('include/field.select.tpl', NO_SKIN);
        $page->assign('name', 'country');
        $it = XDB::iterator("SELECT  gc.iso_3166_1_a2 AS id, gc.countryFR AS field
                               FROM  geoloc_countries       AS gc
                         INNER JOIN  profile_mentor_country AS mp ON (mp.country = gc.iso_3166_1_a2)
                         INNER JOIN  profile_mentor_term    AS mt ON (mt.pid = mp.pid)
                         INNER JOIN  profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid)
                              WHERE  jtr.jtid_1 = {?}
                           GROUP BY  iso_3166_1_a2
                           ORDER BY  countryFR", $jtid);
        $page->assign('list', $it);
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
09824164	1	<?php
09824164	2	/***************************************************************************
9f5bd98e	3	* Copyright (C) 2003-2010 Polytechnique.org *
09824164	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(
abed2826	27	'search' => $this->make_hook('quick', AUTH_PUBLIC),
20f36c54	28	'search/adv' => $this->make_hook('advanced', AUTH_COOKIE, 'directory_ax'),
ba2afb88	29	'advanced_search.php' => $this->make_hook('redir_advanced', AUTH_PUBLIC),
20f36c54 FB	30	'search/autocomplete' => $this->make_hook('autocomplete', AUTH_COOKIE, 'directory_ax', NO_AUTH),
20f36c54 FB	31	'search/list' => $this->make_hook('list', AUTH_COOKIE, 'directory_ax', NO_AUTH),
4ec03752 RB	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),
459e6f81	35	'search/referent/countries' => $this->make_hook('referent_countries', AUTH_COOKIE),
09824164	36	);
	37	}
	38
ba2afb88	39	function handler_redir_advanced(&$page, $mode = null)
	40	{
	41	pl_redirect('search/adv');
	42	exit;
	43	}
	44
09824164	45	function form_prepare()
09824164	46	{
d7610c35	47	Platal::page()->assign('formulaire',1);
3c640222	48	}
3c640222	49
8eb6931f RB	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)
09824164	55	{
	56	global $globals;
	57
8eb6931f	58	if (Env::has('quick') \|\| $model == 'geoloc') {
dd23c027	59	$quick = Env::t('quick');
85bb670b	60	if (S::logged() && !Env::has('page')) {
732e5855	61	S::logger()->log('search', 'quick=' . $quick);
e31c1c3e	62	}
dd23c027 SJ	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
383bcdec	73	$list = 'profile\|prf\|fiche\|fic\|referent\|ref\|mentor';
dd70cd28	74	if (S::admin()) {
383bcdec	75	$list .= '\|admin\|adm\|ax';
383bcdec	76	}
251ac585 FB	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)) {
4514bea3	80	$login = $matches[2];
383bcdec	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	}
7511200d	95
4514bea3 VZ	96	$user = User::getSilent($login);
	97	if ($user) {
	98	pl_redirect($base . $user->login());
7511200d	99	}
90c614cd VZ	100	$_REQUEST['quick'] = $login;
90c614cd VZ	101	$_GET['quick'] = $login;
8fee4fbd	102	} elseif (strpos($quick, 'doc:') === 0) {
	103	$url = 'Docs/Recherche?';
	104	$url .= 'action=search&q=' . urlencode(substr($quick, 4));
7511200d	105	$url .= '&group=' . urlencode('-Equipe,-Main,-PmWiki,-Site,-Review');
8fee4fbd	106	pl_redirect($url);
85b45717 FB	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	}
383bcdec	118	}
8fee4fbd	119
09824164	120	$page->assign('formulaire', 0);
09824164	121
8c4a0c30	122	require_once 'userset.inc.php';
8eb6931f RB	123	$view = new SearchSet(true);
8eb6931f RB	124	$view->addMod('minifiche', 'Mini-fiches', true, array('with_score' => true, 'starts_with' => $byletter));
35fa92e8	125	if (S::logged() && !Env::i('nonins')) {
35fa92e8	126	$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
1fe46b8f SJ	127	// TODO: Reactivate when the new map is completed.
1fe46b8f SJ	128	// $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'search/adv'));
35fa92e8	129	}
8eb6931f	130	$view->apply('search', $page, $model);
09824164	131
8c4a0c30	132	$nb_tot = $view->count();
e35882be	133	$page->assign('search_results_nb', $nb_tot);
cab08090	134	if (!S::logged() && $nb_tot > $globals->search->public_max) {
825a13a4	135	$page->trigError('Votre recherche a généré trop de résultats pour un affichage public.');
09824164	136	} elseif ($nb_tot > $globals->search->private_max) {
825a13a4	137	$page->trigError('Recherche trop générale. Une <a href="search/adv">recherche avancée</a> permet de préciser la recherche.');
09824164	138	} elseif (empty($nb_tot)) {
825a13a4	139	$page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
09824164	140	}
	141	} else {
	142	$page->assign('formulaire',1);
e654517d	143	$page->addJsLink('ajax.js');
09824164	144	}
09824164	145
eaf30d86	146	$page->changeTpl('search/index.tpl');
46f272fe	147	$page->setTitle('Annuaire');
09824164	148	}
09824164	149
8eb6931f RB	150	/** $model is the way of presenting the results: minifiche, trombi, geoloc.
	151	*/
	152	function handler_advanced(&$page, $model = null, $byletter = null)
09824164	153	{
09824164	154	global $globals;
bc67c37c	155	$page->assign('advanced',1);
4b4b4b67	156	$page->addJsLink('jquery.autocomplete.js');
bc67c37c	157
8eb6931f	158	if (!Env::has('rechercher') && $model != 'geoloc') {
09824164	159	$this->form_prepare();
09824164	160	} else {
e31c1c3e	161	if (!Env::has('page')) {
732e5855	162	S::logger()->log('search', 'adv=' . var_export($_GET, true));
e31c1c3e	163	}
137e819f	164
8c4a0c30	165	require_once 'userset.inc.php';
8eb6931f	166	$view = new SearchSet(false);
51fcda84	167	if (!$view->isValid()) {
09824164	168	$this->form_prepare();
51fcda84 RB	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	}
09824164	185	}
09824164	186	}
09824164	187
8eb6931f	188	$page->changeTpl('search/index.tpl', $model == 'mini' ? SIMPLE : SKINNED);
3c640222	189	$page->addJsLink('ajax.js');
8c4a0c30	190	$page->assign('public_directory',0);
09824164	191	}
3c640222	192
838cc16a	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	// ...
3cb500d5	201	pl_content_headers("text/plain");
ff3eb9b7	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	'.*'),
78e4b1f6	208	Env::s('q'));
838cc16a	209	if (!$q) exit();
c15afc4e	210
eaf30d86	211	// try to look in cached results
78e4b1f6 FB	212	$cache = XDB::query('SELECT result
	213	FROM search_autocomplete
	214	WHERE name = {?} AND
	215	query = {?} AND
	216	generated > NOW() - INTERVAL 1 DAY',
ff3eb9b7	217	$type, $q);
c15afc4e	218	if ($res = $cache->fetchOneCell()) {
ff3eb9b7	219	echo $res;
ff3eb9b7	220	die();
c15afc4e	221	}
eaf30d86	222
8e720253 RB	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,
3ac45f10	231	'jobtermTxt' => DirEnum::JOBTERMS,
8e720253 RB	232	'description' => DirEnum::JOBDESCRIPTION,
8e720253 RB	233	'nationaliteTxt' => DirEnum::NATIONALITIES,
fb3b6547	234	'schoolTxt' => DirEnum::EDUSCHOOLS,
8e720253	235	);
9d44d2c7	236	if (!array_key_exists($type, $enums)) {
8e720253	237	exit();
838cc16a	238	}
838cc16a	239
8e720253	240	$enum = $enums[$type];
f781871c	241
8e720253	242	$list = DirEnum::getAutoComplete($enum, $q);
838cc16a	243	$nbResults = 0;
c15afc4e	244	$res = "";
2ab7a09f	245	while ($result = $list->next()) {
838cc16a	246	$nbResults++;
838cc16a	247	if ($nbResults == 11) {
b3ec63d5	248	$res .= $q."\|-1\n";
838cc16a	249	} else {
f6818108	250	$res .= $result['field'].'\|';
c7139c07 SJ	251	if (isset($result['nb'])) {
	252	$res .= $result['nb'];
	253	}
ff3eb9b7	254	if (isset($result['id'])) {
	255	$res .= '\|'.$result['id'];
	256	}
	257	$res .= "\n";
838cc16a	258	}
838cc16a	259	}
fb6dc875 PC	260	if ($nbResults == 0) {
	261	$res = $q."\|-2\n";
	262	}
78e4b1f6	263	XDB::query('REPLACE INTO search_autocomplete
ff3eb9b7	264	VALUES ({?}, {?}, {?}, NOW())',
ff3eb9b7	265	$type, $q, $res);
c15afc4e	266	echo $res;
838cc16a	267	exit();
838cc16a	268	}
eaf30d86	269
2ab7a09f	270	function handler_list(&$page, $type = null, $idVal = null)
2ab7a09f	271	{
ffd70398 PC	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
ff3eb9b7	276	// Give the list of all values possible of type and builds a select input for it
8e720253	277	$ids = null;
ff3eb9b7	278
ff3eb9b7	279	switch ($type) {
8e720253	280	case 'binet':
2998edf1	281	$ids = DirEnum::getOptionsIter(DirEnum::BINETS);
ff3eb9b7	282	break;
92c3f9e5	283	case 'networking_type':
2998edf1	284	$ids = DirEnum::getOptionsIter(DirEnum::NETWORKS);
92c3f9e5	285	break;
ff3eb9b7	286	case 'country':
2998edf1	287	$ids = DirEnum::getOptionsIter(DirEnum::COUNTRIES);
ff3eb9b7	288	$page->assign('onchange', 'changeCountry(this.value)');
ff3eb9b7	289	break;
ff3eb9b7	290	case 'diploma':
8e720253	291	if (Env::has('school') && Env::i('school') != 0) {
2998edf1	292	$ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES, Env::i('school'));
8e720253	293	} else {
2998edf1	294	$ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES);
8e720253 RB	295	}
8e720253 RB	296	break;
ff3eb9b7	297	case 'groupex':
2998edf1	298	$ids = DirEnum::getOptionsIter(DirEnum::GROUPESX);
ff3eb9b7	299	break;
ff3eb9b7	300	case 'nationalite':
2998edf1	301	$ids = DirEnum::getOptionsIter(DirEnum::NATIONALITIES);
ff3eb9b7	302	break;
ffd70398 PC	303	case 'region':
	304	if (Env::has('country')) {
	305	$ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS, Env::v('country'));
8e720253	306	} else {
2998edf1	307	$ids = DirEnum::getOptionsIter(DirEnum::ADMINAREAS);
f6818108	308	}
ff3eb9b7	309	break;
ff3eb9b7	310	case 'school':
2998edf1	311	$ids = DirEnum::getOptionsIter(DirEnum::EDUSCHOOLS);
ff3eb9b7	312	$page->assign('onchange', 'changeSchool(this.value)');
	313	break;
	314	case 'section':
2998edf1	315	$ids = DirEnum::getOptionsIter(DirEnum::SECTIONS);
ff3eb9b7	316	break;
3ac45f10 PC	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	}
ff3eb9b7	333	default: exit();
	334	}
	335	if (isset($idVal)) {
3cb500d5	336	pl_content_headers("text/plain");
8e720253	337	echo $ids[$idVal];
ff3eb9b7	338	exit();
ff3eb9b7	339	}
3cb500d5	340	pl_content_headers("text/xml");
05cb05c0	341	$page->changeTpl('include/field.select.tpl', NO_SKIN);
8e720253	342	$page->assign('list', $ids);
2ab7a09f	343	}
9dc65790 PC	344
	345	function handler_referent(&$page, $action = null, $subaction = null)
	346	{
459e6f81 PC	347	global $globals;
459e6f81 PC	348
9dc65790 PC	349	$wp = new PlWikiPage('Docs.Emploi');
	350	$wp->buildCache();
	351
	352	$page->setTitle('Emploi et Carrières');
	353
4ec03752	354	// Count mentors
9dc65790 PC	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
4ec03752	360	// Search for mentors matching filters
9dc65790 PC	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);
459e6f81 PC	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.');
9dc65790 PC	377	}
	378	}
	379
	380	$page->changeTpl('search/referent.tpl');
	381	}
	382
459e6f81 PC	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	}
09824164	403	}
09824164	404
a7de4ef7	405	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
09824164	406	?>