[platal.git] / modules / search.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2011 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),
            'search/list/count'         => $this->make_hook('list_count',         AUTH_COOKIE, 'directory_ax', NO_AUTH),
            'jobs'                      => $this->make_hook('referent',           AUTH_COOKIE, 'user'),
            'emploi'                    => $this->make_hook('referent',           AUTH_COOKIE, 'user'),
            'referent/search'           => $this->make_hook('referent',           AUTH_COOKIE, 'user'),
            'search/referent/countries' => $this->make_hook('referent_countries', AUTH_COOKIE, 'user'),
        );
    }

    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);
                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());
                }
                Get::set('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 QuickSearchSet();
            $view->addMod('minifiche', 'Mini-fiches', true, array('with_score' => true, 'starts_with' => $byletter));
            $view->addMod('map', 'Planisphère');
            if (S::logged() && !Env::i('nonins')) {
                $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
            }
            $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->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->addJsLink('jquery.ui.xorg.js');
        $page->addJsLink('search.js');
        $page->assign('advanced',1);

        $networks = DirEnum::getOptions(DirEnum::NETWORKS);
        $networks[-1] = 'Tous types';
        $networks[0] = '-';
        ksort($networks);
        $page->assign('networking_types', $networks);
        $origin_corps_list = DirEnum::getOptions(DirEnum::CURRENTCORPS);
        $current_corps_list = DirEnum::getOptions(DirEnum::ORIGINCORPS);
        $corps_rank_list = DirEnum::getOptions(DirEnum::CORPSRANKS);
        $origin_corps_list[0] = '-';
        $current_corps_list[0] = '-';
        $corps_rank_list[0] = '-';
        ksort($origin_corps_list);
        ksort($current_corps_list);
        ksort($corps_rank_list);
        $page->assign('origin_corps_list', $origin_corps_list);
        $page->assign('current_corps_list', $current_corps_list);
        $page->assign('corps_rank_list', $corps_rank_list);

        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';
            // Enable X.org fields for X.org admins, and AX fields for AX secretaries.
            $view = new AdvancedSearchSet(S::admin(),
                                          S::user()->checkPerms(User::PERM_EDIT_DIRECTORY));

            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));
                $view->addMod('map', 'Planisphère');
                if (S::user()->checkPerms(User::PERM_EDIT_DIRECTORY) || S::admin()) {
                    $view->addMod('addresses', 'Adresses postales', false);
                }
                $view->apply('search/adv', $page, $model);

                $nb_tot = $view->count();
                if ($nb_tot > $globals->search->private_max) {
                    $this->form_prepare();
                    if ($model != 'addresses' && (S::user()->checkPerms(User::PERM_EDIT_DIRECTORY) || S::admin())) {
                        $page->assign('suggestAddresses', true);
                    }
                    $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->assign('public_directory',0);
    }

    private function format_autocomplete(array $item)
    {
        return $item['field'] . ' (' . $item['nb'] . ' camarade' . ($item['nb'] > 1 ? 's' : '') . ')';
    }

    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',
                                 '.*'),
                           Get::t('term'));
        if (!$q) {
            exit();
        }

        // Try to look in cached results.
        $cached = false;
        $cache = XDB::query('SELECT  result
                               FROM  search_autocomplete
                              WHERE  name = {?} AND query = {?} AND generated > NOW() - INTERVAL 1 DAY',
                             $type, $q);

        if ($cache->numRows() > 0) {
            $cached = true;
            $data = explode("\n", $cache->fetchOneCell());
            $list = array();
            foreach ($data as $line) {
                if ($line != '') {
                    $aux = explode("\t", $line);
                    $item = array(
                        'field' => $aux[0],
                        'nb'    => $aux[1],
                        'id'    => $aux[2]
                    );
                    $item['value'] = $this->format_autocomplete($item);
                    array_push($list, $item);
                }
            }
        } else {
            $enums = array(
                'binet_text'           => DirEnum::BINETS,
                'groupex_text'         => DirEnum::GROUPESX,
                'section_text'         => DirEnum::SECTIONS,
                'networking_type_text' => DirEnum::NETWORKS,
                'locality_text'        => DirEnum::LOCALITIES,
                'country_text'         => DirEnum::COUNTRIES,
                'entreprise'           => DirEnum::COMPANIES,
                'jobterm_text'         => DirEnum::JOBTERMS,
                'description'          => DirEnum::JOBDESCRIPTION,
                'nationalite_text'     => DirEnum::NATIONALITIES,
                'school_text'          => DirEnum::EDUSCHOOLS,
            );
            if (!array_key_exists($type, $enums)) {
                exit();
            }

            $list = DirEnum::getAutoComplete($enums[$type], $q);
            $to_cache = '';
            foreach ($list as &$item) {
                $to_cache .= $item['field'] . "\t" . $item['nb'] . "\t" . $item['id'] . "\n";
                $item['value'] = $this->format_autocomplete($item);
            }
        }

        $count = count($list);
        if ($count == DirEnumeration::AUTOCOMPLETE_LIMIT) {
            $list[] = array(
                'value' => '…',
                'field' => '',
                'nb'    => 0,
                'id'    => -1
            );
        } elseif ($count == 0) {
            $list[] = array(
                'value' => 'Aucun camarade trouvé pour ' . $q . '.',
                'field' => '',
                'nb'    => 0,
                'id'    => -1
            );
        }

        if (!$cached) {
            XDB::query('INSERT INTO  search_autocomplete (name, query, result, generated)
                             VALUES  ({?}, {?}, {?}, NOW())
            ON DUPLICATE KEY UPDATE  result = VALUES(result), generated = VALUES(generated)',
                       $type, $q, $to_cache);
        }
        echo json_encode($list);
        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', 'changeAddressComponents(\'' . $type . '\', this.value)');
            break;
          case 'administrative_area_level_1':
          case 'administrative_area_level_2':
          case 'locality':
            $page->assign('onchange', 'changeAddressComponents(\'' . $type . '\', this.value)');
          case 'postal_code':
            $ids = XDB::iterator("SELECT  pace1.id, pace1.long_name AS field
                                    FROM  profile_addresses_components_enum AS pace1
                              INNER JOIN  profile_addresses_components      AS pac1  ON (pac1.component_id = pace1.id)
                              INNER JOIN  profile_addresses_components      AS pac2  ON (pac1.pid = pac2.pid AND pac1.jobid = pac2.jobid AND pac1.id = pac2.id
                                                                                         AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type)
                              INNER JOIN  profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET({?}, pace2.types))
                                   WHERE  pace2.id = {?} AND FIND_IN_SET({?}, pace1.types) AND pac1.type = 'home'
                                GROUP BY  pace1.long_name",
                                 Env::v('previous'), Env::v('value'), $type);
            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 '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());

        // 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.country 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  gc.iso_3166_1_a2
                           ORDER BY  gc.country", $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	/***************************************************************************
5e1513f6	3	* Copyright (C) 2003-2011 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(
5ae3e9a9 SJ	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),
a67a14b4	32	'search/list/count' => $this->make_hook('list_count', AUTH_COOKIE, 'directory_ax', NO_AUTH),
e5ceaa8c RB	33	'jobs' => $this->make_hook('referent', AUTH_COOKIE, 'user'),
	34	'emploi' => $this->make_hook('referent', AUTH_COOKIE, 'user'),
	35	'referent/search' => $this->make_hook('referent', AUTH_COOKIE, 'user'),
	36	'search/referent/countries' => $this->make_hook('referent_countries', AUTH_COOKIE, 'user'),
09824164	37	);
	38	}
	39
26ba053e	40	function handler_redir_advanced($page, $mode = null)
ba2afb88	41	{
	42	pl_redirect('search/adv');
	43	exit;
	44	}
	45
09824164	46	function form_prepare()
09824164	47	{
d7610c35	48	Platal::page()->assign('formulaire',1);
3c640222	49	}
3c640222	50
8eb6931f RB	51	/**
	52	* $model: The way of presenting the results: minifiche, trombi, geoloc.
	53	* $byletter: Show only names beginning with this letter
	54	*/
26ba053e	55	function handler_quick($page, $model = null, $byletter = null)
09824164	56	{
	57	global $globals;
	58
8eb6931f	59	if (Env::has('quick') \|\| $model == 'geoloc') {
dd23c027	60	$quick = Env::t('quick');
85bb670b	61	if (S::logged() && !Env::has('page')) {
732e5855	62	S::logger()->log('search', 'quick=' . $quick);
e31c1c3e	63	}
dd23c027 SJ	64
	65	if ($quick == '') {
	66	$page->trigWarning('Aucun critère de recherche n\'est spécifié.');
	67	$page->changeTpl('search/index.tpl');
	68	$page->setTitle('Annuaire');
	69	$page->assign('formulaire', 1);
dd23c027 SJ	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	}
ed06daba	100	Get::set('quick', $login);
8fee4fbd	101	} elseif (strpos($quick, 'doc:') === 0) {
	102	$url = 'Docs/Recherche?';
	103	$url .= 'action=search&q=' . urlencode(substr($quick, 4));
7511200d	104	$url .= '&group=' . urlencode('-Equipe,-Main,-PmWiki,-Site,-Review');
8fee4fbd	105	pl_redirect($url);
85b45717 FB	106	} elseif (strpos($quick, 'trombi:') === 0) {
	107	$promo = substr($quick, 7);
	108	$res = XDB::query("SELECT diminutif
	109	FROM groups
	110	WHERE cat = 'Promotions' AND diminutif = {?}",
	111	$promo);
	112	if ($res->numRows() == 0) {
	113	$page->trigWarning("La promotion demandée n'est pas valide: $promo");
	114	} else {
	115	http_redirect('http://www.polytechnique.net/login/' . $promo . '/annuaire/trombi');
	116	}
383bcdec	117	}
8fee4fbd	118
09824164	119	$page->assign('formulaire', 0);
09824164	120
8c4a0c30	121	require_once 'userset.inc.php';
78a47eb4	122	$view = new QuickSearchSet();
8eb6931f	123	$view->addMod('minifiche', 'Mini-fiches', true, array('with_score' => true, 'starts_with' => $byletter));
6bcd8813	124	$view->addMod('map', 'Planisphère');
35fa92e8	125	if (S::logged() && !Env::i('nonins')) {
35fa92e8	126	$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
35fa92e8	127	}
8eb6931f	128	$view->apply('search', $page, $model);
09824164	129
8c4a0c30	130	$nb_tot = $view->count();
e35882be	131	$page->assign('search_results_nb', $nb_tot);
cab08090	132	if (!S::logged() && $nb_tot > $globals->search->public_max) {
825a13a4	133	$page->trigError('Votre recherche a généré trop de résultats pour un affichage public.');
09824164	134	} elseif ($nb_tot > $globals->search->private_max) {
825a13a4	135	$page->trigError('Recherche trop générale. Une <a href="search/adv">recherche avancée</a> permet de préciser la recherche.');
09824164	136	} elseif (empty($nb_tot)) {
825a13a4	137	$page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
09824164	138	}
	139	} else {
	140	$page->assign('formulaire',1);
	141	}
	142
eaf30d86	143	$page->changeTpl('search/index.tpl');
46f272fe	144	$page->setTitle('Annuaire');
09824164	145	}
09824164	146
8eb6931f RB	147	/** $model is the way of presenting the results: minifiche, trombi, geoloc.
8eb6931f RB	148	*/
26ba053e	149	function handler_advanced($page, $model = null, $byletter = null)
09824164	150	{
09824164	151	global $globals;
23ccdf38	152	$page->addJsLink('jquery.ui.xorg.js');
e16215c4	153	$page->addJsLink('search.js');
bc67c37c	154	$page->assign('advanced',1);
bc67c37c	155
1d364832 RB	156	$networks = DirEnum::getOptions(DirEnum::NETWORKS);
	157	$networks[-1] = 'Tous types';
	158	$networks[0] = '-';
	159	ksort($networks);
	160	$page->assign('networking_types', $networks);
00f25ab1 SJ	161	$origin_corps_list = DirEnum::getOptions(DirEnum::CURRENTCORPS);
	162	$current_corps_list = DirEnum::getOptions(DirEnum::ORIGINCORPS);
	163	$corps_rank_list = DirEnum::getOptions(DirEnum::CORPSRANKS);
	164	$origin_corps_list[0] = '-';
	165	$current_corps_list[0] = '-';
	166	$corps_rank_list[0] = '-';
	167	ksort($origin_corps_list);
	168	ksort($current_corps_list);
	169	ksort($corps_rank_list);
	170	$page->assign('origin_corps_list', $origin_corps_list);
	171	$page->assign('current_corps_list', $current_corps_list);
	172	$page->assign('corps_rank_list', $corps_rank_list);
1d364832	173
8eb6931f	174	if (!Env::has('rechercher') && $model != 'geoloc') {
09824164	175	$this->form_prepare();
09824164	176	} else {
e31c1c3e	177	if (!Env::has('page')) {
732e5855	178	S::logger()->log('search', 'adv=' . var_export($_GET, true));
e31c1c3e	179	}
137e819f	180
8c4a0c30	181	require_once 'userset.inc.php';
0f567f55 RB	182	// Enable X.org fields for X.org admins, and AX fields for AX secretaries.
	183	$view = new AdvancedSearchSet(S::admin(),
	184	S::user()->checkPerms(User::PERM_EDIT_DIRECTORY));
	185
51fcda84	186	if (!$view->isValid()) {
09824164	187	$this->form_prepare();
51fcda84 RB	188	$page->trigError('Recherche invalide.');
	189	} else {
	190	$view->addMod('minifiche', 'Mini-fiches', true, array('starts_with' => $byletter));
	191	$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
0a928a2f	192	$view->addMod('map', 'Planisphère');
39394cbf	193	if (S::user()->checkPerms(User::PERM_EDIT_DIRECTORY) \|\| S::admin()) {
c442573a	194	$view->addMod('addresses', 'Adresses postales', false);
39394cbf	195	}
51fcda84 RB	196	$view->apply('search/adv', $page, $model);
	197
	198	$nb_tot = $view->count();
	199	if ($nb_tot > $globals->search->private_max) {
	200	$this->form_prepare();
39394cbf SJ	201	if ($model != 'addresses' && (S::user()->checkPerms(User::PERM_EDIT_DIRECTORY) \|\| S::admin())) {
	202	$page->assign('suggestAddresses', true);
	203	}
51fcda84 RB	204	$page->trigError('Recherche trop générale.');
	205	} else if ($nb_tot == 0) {
	206	$this->form_prepare();
	207	$page->trigError('Il n\'existe personne correspondant à ces critères dans la base !');
	208	}
09824164	209	}
09824164	210	}
09824164	211
8eb6931f	212	$page->changeTpl('search/index.tpl', $model == 'mini' ? SIMPLE : SKINNED);
8c4a0c30	213	$page->assign('public_directory',0);
09824164	214	}
3c640222	215
23ccdf38 SJ	216	private function format_autocomplete(array $item)
	217	{
	218	return $item['field'] . ' (' . $item['nb'] . ' camarade' . ($item['nb'] > 1 ? 's' : '') . ')';
	219	}
	220
26ba053e	221	function handler_autocomplete($page, $type = null)
838cc16a	222	{
	223	// Autocompletion : according to type required, return
	224	// a list of results matching with the number of matches.
	225	// The output format is :
	226	// result1\|nb1
	227	// result2\|nb2
	228	// ...
3cb500d5	229	pl_content_headers("text/plain");
ff3eb9b7	230	$q = preg_replace(array('/\+$/', // always look for $q
	231	'/([\^\$\[\]])/', // escape special regexp char
	232	'/\*/'), // replace joker by regexp joker
	233	array('',
	234	'\\\\\1',
	235	'.*'),
23ccdf38 SJ	236	Get::t('term'));
	237	if (!$q) {
	238	exit();
	239	}
c15afc4e	240
23ccdf38 SJ	241	// Try to look in cached results.
23ccdf38 SJ	242	$cached = false;
78e4b1f6 FB	243	$cache = XDB::query('SELECT result
78e4b1f6 FB	244	FROM search_autocomplete
23ccdf38	245	WHERE name = {?} AND query = {?} AND generated > NOW() - INTERVAL 1 DAY',
ff3eb9b7	246	$type, $q);
838cc16a	247
23ccdf38 SJ	248	if ($cache->numRows() > 0) {
	249	$cached = true;
	250	$data = explode("\n", $cache->fetchOneCell());
	251	$list = array();
	252	foreach ($data as $line) {
	253	if ($line != '') {
	254	$aux = explode("\t", $line);
	255	$item = array(
	256	'field' => $aux[0],
	257	'nb' => $aux[1],
	258	'id' => $aux[2]
	259	);
	260	$item['value'] = $this->format_autocomplete($item);
	261	array_push($list, $item);
ff3eb9b7	262	}
23ccdf38 SJ	263	}
	264	} else {
	265	$enums = array(
	266	'binet_text' => DirEnum::BINETS,
	267	'groupex_text' => DirEnum::GROUPESX,
	268	'section_text' => DirEnum::SECTIONS,
	269	'networking_type_text' => DirEnum::NETWORKS,
	270	'locality_text' => DirEnum::LOCALITIES,
	271	'country_text' => DirEnum::COUNTRIES,
	272	'entreprise' => DirEnum::COMPANIES,
	273	'jobterm_text' => DirEnum::JOBTERMS,
	274	'description' => DirEnum::JOBDESCRIPTION,
	275	'nationalite_text' => DirEnum::NATIONALITIES,
	276	'school_text' => DirEnum::EDUSCHOOLS,
	277	);
	278	if (!array_key_exists($type, $enums)) {
	279	exit();
	280	}
	281
	282	$list = DirEnum::getAutoComplete($enums[$type], $q);
	283	$to_cache = '';
	284	foreach ($list as &$item) {
	285	$to_cache .= $item['field'] . "\t" . $item['nb'] . "\t" . $item['id'] . "\n";
	286	$item['value'] = $this->format_autocomplete($item);
838cc16a	287	}
838cc16a	288	}
23ccdf38 SJ	289
	290	$count = count($list);
	291	if ($count == DirEnumeration::AUTOCOMPLETE_LIMIT) {
	292	$list[] = array(
	293	'value' => '…',
	294	'field' => '',
	295	'nb' => 0,
	296	'id' => -1
	297	);
	298	} elseif ($count == 0) {
	299	$list[] = array(
	300	'value' => 'Aucun camarade trouvé pour ' . $q . '.',
	301	'field' => '',
	302	'nb' => 0,
	303	'id' => -1
	304	);
	305	}
	306
	307	if (!$cached) {
	308	XDB::query('INSERT INTO search_autocomplete (name, query, result, generated)
	309	VALUES ({?}, {?}, {?}, NOW())
	310	ON DUPLICATE KEY UPDATE result = VALUES(result), generated = VALUES(generated)',
	311	$type, $q, $to_cache);
fb6dc875	312	}
23ccdf38	313	echo json_encode($list);
838cc16a	314	exit();
838cc16a	315	}
eaf30d86	316
26ba053e	317	function handler_list($page, $type = null, $idVal = null)
2ab7a09f	318	{
ffd70398 PC	319	$page->assign('name', $type);
	320	$page->assign('with_text_value', true);
	321	$page->assign('onchange', "document.forms.recherche.{$type}Txt.value = this.options[this.selectedIndex].text");
	322
ff3eb9b7	323	// Give the list of all values possible of type and builds a select input for it
8e720253	324	$ids = null;
ff3eb9b7	325
ff3eb9b7	326	switch ($type) {
8e720253	327	case 'binet':
2998edf1	328	$ids = DirEnum::getOptionsIter(DirEnum::BINETS);
ff3eb9b7	329	break;
92c3f9e5	330	case 'networking_type':
2998edf1	331	$ids = DirEnum::getOptionsIter(DirEnum::NETWORKS);
92c3f9e5	332	break;
ff3eb9b7	333	case 'country':
2998edf1	334	$ids = DirEnum::getOptionsIter(DirEnum::COUNTRIES);
a67a14b4 SJ	335	$page->assign('onchange', 'changeAddressComponents(\'' . $type . '\', this.value)');
	336	break;
	337	case 'administrative_area_level_1':
	338	case 'administrative_area_level_2':
a67a14b4 SJ	339	case 'locality':
a67a14b4 SJ	340	$page->assign('onchange', 'changeAddressComponents(\'' . $type . '\', this.value)');
e76e94fb	341	case 'postal_code':
a67a14b4 SJ	342	$ids = XDB::iterator("SELECT pace1.id, pace1.long_name AS field
	343	FROM profile_addresses_components_enum AS pace1
	344	INNER JOIN profile_addresses_components AS pac1 ON (pac1.component_id = pace1.id)
	345	INNER JOIN profile_addresses_components AS pac2 ON (pac1.pid = pac2.pid AND pac1.jobid = pac2.jobid AND pac1.id = pac2.id
	346	AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type)
	347	INNER JOIN profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET({?}, pace2.types))
7757efd6	348	WHERE pace2.id = {?} AND FIND_IN_SET({?}, pace1.types) AND pac1.type = 'home'
a67a14b4 SJ	349	GROUP BY pace1.long_name",
a67a14b4 SJ	350	Env::v('previous'), Env::v('value'), $type);
ff3eb9b7	351	break;
ff3eb9b7	352	case 'diploma':
8e720253	353	if (Env::has('school') && Env::i('school') != 0) {
2998edf1	354	$ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES, Env::i('school'));
8e720253	355	} else {
2998edf1	356	$ids = DirEnum::getOptionsIter(DirEnum::EDUDEGREES);
8e720253 RB	357	}
8e720253 RB	358	break;
ff3eb9b7	359	case 'groupex':
2998edf1	360	$ids = DirEnum::getOptionsIter(DirEnum::GROUPESX);
ff3eb9b7	361	break;
ff3eb9b7	362	case 'nationalite':
2998edf1	363	$ids = DirEnum::getOptionsIter(DirEnum::NATIONALITIES);
ff3eb9b7	364	break;
ff3eb9b7	365	case 'school':
2998edf1	366	$ids = DirEnum::getOptionsIter(DirEnum::EDUSCHOOLS);
ff3eb9b7	367	$page->assign('onchange', 'changeSchool(this.value)');
	368	break;
	369	case 'section':
2998edf1	370	$ids = DirEnum::getOptionsIter(DirEnum::SECTIONS);
ff3eb9b7	371	break;
3ac45f10 PC	372	case 'jobterm':
3ac45f10 PC	373	if (Env::has('jtid')) {
26ba053e	374	JobTerms::ajaxGetBranch($page, JobTerms::ONLY_JOBS);
3ac45f10 PC	375	return;
	376	} else {
	377	pl_content_headers('text/xml');
	378	echo '<div>'; // global container so that response is valid xml
	379	echo '<input name="jobtermTxt" type="text" style="display:none" size="32" />';
	380	echo '<input name="jobterm" type="hidden"/>';
	381	echo '<div class="term_tree"></div>'; // container where to create the tree
	382	echo '<script type="text/javascript" src="javascript/jquery.jstree.js"></script>';
	383	echo '<script type="text/javascript" src="javascript/jobtermstree.js"></script>';
	384	echo '<script type="text/javascript">createJobTermsTree(".term_tree", "search/list/jobterm", "search", "searchForJobTerm");</script>';
	385	echo '</div>';
	386	exit();
	387	}
ff3eb9b7	388	default: exit();
	389	}
	390	if (isset($idVal)) {
3cb500d5	391	pl_content_headers("text/plain");
8e720253	392	echo $ids[$idVal];
ff3eb9b7	393	exit();
ff3eb9b7	394	}
3cb500d5	395	pl_content_headers("text/xml");
05cb05c0	396	$page->changeTpl('include/field.select.tpl', NO_SKIN);
8e720253	397	$page->assign('list', $ids);
2ab7a09f	398	}
9dc65790	399
26ba053e	400	function handler_referent($page, $action = null, $subaction = null)
9dc65790	401	{
459e6f81 PC	402	global $globals;
459e6f81 PC	403
9dc65790 PC	404	$wp = new PlWikiPage('Docs.Emploi');
	405	$wp->buildCache();
	406
	407	$page->setTitle('Emploi et Carrières');
	408
4ec03752	409	// Count mentors
9dc65790 PC	410	$res = XDB::query("SELECT count(distinct pid) FROM profile_mentor_term");
	411	$page->assign('mentors_number', $res->fetchOneCell());
	412
4ec03752	413	// Search for mentors matching filters
9dc65790 PC	414	require_once 'ufbuilder.inc.php';
	415	$ufb = new UFB_MentorSearch();
	416	if (!$ufb->isEmpty()) {
	417	require_once 'userset.inc.php';
	418	$ufc = $ufb->getUFC();
	419	$set = new ProfileSet($ufc);
	420	$set->addMod('mentor', 'Référents');
	421	$set->apply('referent/search', $page, $action, $subaction);
459e6f81 PC	422	$nb_tot = $set->count();
	423	if ($nb_tot > $globals->search->private_max) {
	424	$this->form_prepare();
	425	$page->trigError('Recherche trop générale.');
	426	$page->assign('plset_count', 0);
	427	} else if ($nb_tot == 0) {
	428	$this->form_prepare();
	429	$page->trigError('Il n\'existe personne correspondant à ces critères dans la base.');
9dc65790 PC	430	}
	431	}
	432
	433	$page->changeTpl('search/referent.tpl');
	434	}
	435
459e6f81 PC	436	/**
	437	* Builds a select field to choose among countries that referents
	438	* know about. Only referents linked to term (jtid) are displayed.
	439	* @param $jtid id of job term to restrict referents
	440	*/
26ba053e	441	function handler_referent_countries($page, $jtid = null)
459e6f81 PC	442	{
	443	pl_content_headers("text/xml");
	444	$page->changeTpl('include/field.select.tpl', NO_SKIN);
	445	$page->assign('name', 'country');
1c305d4c	446	$it = XDB::iterator("SELECT gc.iso_3166_1_a2 AS id, gc.country AS field
459e6f81 PC	447	FROM geoloc_countries AS gc
	448	INNER JOIN profile_mentor_country AS mp ON (mp.country = gc.iso_3166_1_a2)
	449	INNER JOIN profile_mentor_term AS mt ON (mt.pid = mp.pid)
	450	INNER JOIN profile_job_term_relation AS jtr ON (jtr.jtid_2 = mt.jtid)
	451	WHERE jtr.jtid_1 = {?}
d6f2c926 SJ	452	GROUP BY gc.iso_3166_1_a2
d6f2c926 SJ	453	ORDER BY gc.country", $jtid);
459e6f81 PC	454	$page->assign('list', $it);
459e6f81 PC	455	}
09824164	456	}
09824164	457
a7de4ef7	458	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
09824164	459	?>