[platal.git] / modules / search.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2007 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),
            'advanced_search.php' => $this->make_hook('redir_advanced', AUTH_PUBLIC),
            'search/autocomplete' => $this->make_hook('autocomplete', AUTH_COOKIE, 'user', NO_AUTH),
            'search/list' => $this->make_hook('list', AUTH_COOKIE, 'user', NO_AUTH),
        );
    }

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

    function on_subscribe($forlife, $uid, $promo, $pass)
    {
        require_once 'user.func.inc.php';
        user_reindex($uid);
    }


    function form_prepare()
    {
        global $page;

        $page->assign('formulaire',1);
    }

    function get_diplomas($school = null)
    {
        if (is_null($school) && Env::has('school')) {
            $school = Env::i('school');
        }

        if (!is_null($school)) {
            $sql = 'SELECT type FROM applis_def WHERE id=' . $school;
        } else {
            $sql = 'DESCRIBE applis_def type';
        }

        $res = XDB::query($sql);
        $row = $res->fetchOneRow();
        if (!is_null($school)) {
            $types = $row[0];
        } else {
            $types = explode('(',$row[1]);
            $types = str_replace("'","",substr($types[1],0,-1));
        }
        global $page;
        $page->assign('choix_diplomas', explode(',',$types));
    }

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

        if (Env::has('quick') || $action == 'geoloc') {
            $page->assign('formulaire', 0);

            require_once 'userset.inc.php';
            $view = new SearchSet(true, $action == 'geoloc' && substr($subaction, -3) == 'swf');
            $view->addMod('minifiche', 'Minifiches', true, array('with_score' => true));
            if (S::logged() && !Env::i('nonins')) {
                $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
                $view->addMod('geoloc', 'Planisphère');
            }
            $view->apply('search', $page, $action, $subaction);

            $nb_tot = $view->count();
            if ($subaction) {
                return;
            }
            if (!S::logged() && $nb_tot > $globals->search->public_max) {
                new ThrowError('Votre recherche a généré trop de résultats pour un affichage public.');
            } elseif ($nb_tot > $globals->search->private_max) {
                new ThrowError('Recherche trop générale');
            } elseif (empty($nb_tot)) {
                new ThrowError('il n\'existe personne correspondant à ces critères dans la base !');
            }
        } else {
            $res = XDB::query("SELECT  MIN(`diminutif`), MAX(`diminutif`)
                                 FROM  `groupex`.`asso`
                                WHERE  `cat` = 'Promotions'");
            list($min, $max) = $res->fetchOneRow();
            $page->assign('promo_min', $min);
            $page->assign('promo_max', $max); 
            $page->assign('formulaire',1);
            $page->addJsLink('ajax.js');
        }

        require_once dirname(__FILE__) . '/search/search.inc.php';
        $page->changeTpl('search/index.tpl');            
        $page->assign('xorg_title','Polytechnique.org - Annuaire');
        $page->assign('baseurl', $globals->baseurl);
    }

    function handler_advanced(&$page, $action = null, $subaction = null)
    {
        global $globals;
        require_once 'geoloc.inc.php';
        require_once dirname(__FILE__) . '/search/search.inc.php';
        $page->assign('advanced',1);

        if (!Env::has('rechercher') && $action != 'geoloc') {
            $this->form_prepare();
        } else {
            require_once 'userset.inc.php';
            $view = new SearchSet(false, $action == 'geoloc' && substr($subaction, -3) == 'swf');
            $view->addMod('minifiche', 'Minifiches', true);
            $view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
            $view->addMod('geoloc', 'Planishpère');
            $view->apply('search', $page, $action, $subaction);
            
            if ($subaction) {
                return;
            }
            $nb_tot = $view->count();
            if ($nb_tot > $globals->search->private_max) {
                $this->form_prepare();
                new ThrowError('Recherche trop générale');
            }
        }

        $page->changeTpl('search/index.tpl', $action == '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
        //   ...
        header('Content-Type: text/plain; charset="UTF-8"');
        $q = preg_replace(
						array(
								'/\*+$/', // always look for $q*
								'/([\^\$\[\]])/', // escape special regexp char
								'/\*/'), // replace joker by regexp joker
						array(
								'',
								'\\\\\1',
								'.*'),
						$_REQUEST['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();
        }
        
        // default search
        $unique = '`user_id`';
        $db = '`auth_user_md5`';
        $realid = false;
        $beginwith = true;
        $field2 = false;
        $qsearch = $q;
        
        switch ($type) {
        case 'binetTxt':
						$db = '`binets_def` INNER JOIN
								`binets_ins` ON(`binets_def`.`id` = `binets_ins`.`binet_id`)';
						$field='`binets_def`.`text`';
						if (strlen($q) > 2)
								$beginwith = false;
						$realid = '`binets_def`.`id`';
						break;
        case 'city':
						$db = '`geoloc_city` INNER JOIN
								`adresses` ON(`geoloc_city`.`id` = `adresses`.`cityid`)';
						$unique='`uid`';
						$field='`geoloc_city`.`name`';
						break;
        case 'countryTxt':
						$db = '`geoloc_pays` INNER JOIN
								`adresses` ON(`geoloc_pays`.`a2` = `adresses`.`country`)';
						$unique='`uid`';
						$field = '`geoloc_pays`.`pays`';
						$field2 = '`geoloc_pays`.`country`';
						$realid='`geoloc_pays`.`a2`';
						break;
        case 'entreprise':
						$db = '`entreprises`';
						$field = '`entreprise`';
						$unique='`uid`';
						break;
        case '`firstname`':
						$field = '`prenom`';
						$q = '(^|[ \\-])'.$q;
						$beginwith = false;
						break;
        case 'fonctionTxt':
        		$db = '`fonctions_def` INNER JOIN
								`entreprises` ON(`entreprises`.`fonction` = `fonctions_def`.`id`)';
        		$field = '`fonction_fr`';
        		$unique = '`uid`';
        		$realid = '`fonctions_def`.`id`';
						$qsearch = '(^|[ /\\-])'.$q;
						$beginwith = false;
        		break;
        case 'groupexTxt':
						$db = '`groupesx_def` INNER JOIN
								`groupesx_ins` ON(`groupesx_def`.`id` = `groupesx_ins`.`gid`)';
						$field='`groupesx_def`.`text`';
						if (strlen($q) > 2)
								$beginwith = false;
						$realid = '`groupesx_def`.`id`';
						$unique = '`guid`';
						break;
        case 'name':
						$field = '`nom`';
						$field2 = '`nom_usage`';
						$qsearch = '(^|[ \\-])'.$q;
						$beginwith = false;
						break;
    		case 'nationaliteTxt':
    				$db = '`geoloc_pays` INNER JOIN
								`auth_user_md5` ON(`geoloc_pays`.`a2` = `auth_user_md5`.`nationalite`)';
    				$field = 'IF(`geoloc_pays`.`nat`=\'\',
								`geoloc_pays`.`pays`,
								`geoloc_pays`.`nat`)';
    				$realid = '`geoloc_pays`.`a2`';
    				break;
        case 'nickname':
						$field = '`profile_nick`';
						$db = '`auth_user_quick`';
						$qsearch = '(^|[ \\-])'.$q;
						$beginwith = false;
						break;
        case 'poste':
						$db = '`entreprises`';
						$field = '`poste`';
						$unique='`uid`';
						break;
				case 'schoolTxt':
						$db = '`applis_def` INNER JOIN
								`applis_ins` ON(`applis_def`.`id` = `applis_ins`.`aid`)';
						$field='`applis_def`.`text`';
						$unique = '`uid`';
						$realid = '`applis_def`.`id`';
						if (strlen($q) > 2)
								$beginwith = false;
						break;
    		case 'secteurTxt':
    				$db = '`emploi_secteur` INNER JOIN
								`entreprises` ON(`entreprises`.`secteur` = `emploi_secteur`.`id`)';
    				$field = '`emploi_secteur`.`label`';
    				$realid = '`emploi_secteur`.`id`';
    				$unique = '`uid`';
						$beginwith = false;
    				break;
    		case 'sectionTxt':
    				$db = '`sections` INNER JOIN 
								`auth_user_md5` ON(`auth_user_md5`.`section` = `sections`.`id`)';
    				$field = '`sections`.`text`';
    				$realid = '`sections`.`id`';
						$beginwith = false;
    				break;
        default: exit();
        }

				$field_select = $field;
				if ($field2) {
						$field_select = 'IF('.$field.' REGEXP {?}, '.$field.', '.$field2.')';
				}
				
				if ($beginwith) {
						$qsearch = '^'.$qsearch;
				}
        $list = XDB::iterator('
						SELECT
								'.$field_select.' AS field,
								COUNT(DISTINCT '.$unique.') AS nb
								'.($realid?(', '.$realid.' AS id'):'').'
						FROM '.$db.'
						WHERE '.$field.' REGEXP {?}'.
						($field2?(' OR '.$field2.' REGEXP {?}'):'').'
						GROUP BY '.$field_select.'
						ORDER BY nb DESC
						LIMIT 11',
						$qsearch, 
						$qsearch,
						$qsearch,
						$qsearch);
        $nbResults = 0;
        $res = "";
        while ($result = $list->next()) {
            $nbResults++;
            if ($nbResults == 11) {
                $res .= '...|1'."\n";
            } else {
                $res .= $result['field'].'|';
								$res .= $result['nb'];
								if (isset($result['id'])) {
										$res  .= '|'.$result['id'];
								}
								$res .= "\n";
            }
        }
        XDB::query('
						REPLACE INTO `search_autocomplete`
						VALUES ({?}, {?}, {?}, NOW())',
        		$type, $q, $res);
        echo $res;
        exit();
    }
    
    function handler_list(&$page, $type = null, $idVal = null)
    {
    		// Give the list of all values possible of type and builds a select input for it
				$field = '`text`';
				$id = '`id`';
				$where = '';
				
    		switch ($type) {
    		case 'binet':
    				$db = '`binets_def`';
    				break;
    		case 'country':
    				$db = '`geoloc_pays`';
    				$field = '`pays`';
    				$id = '`a2`';
		        $page->assign('onchange', 'changeCountry(this.value)');
    				break;
    		case 'fonction':
    				$db = '`fonctions_def`';
    				$field = '`fonction_fr`';
    				break;
    		case 'diploma':
            header('Content-Type: text/xml; charset="UTF-8"');
    		    $this->get_diplomas();
    		    $page->changeTpl('search/adv.grade.form.tpl', NO_SKIN);
    		    return;
    		case 'groupex':
    				$db = '`groupesx_def`';
    				break;
    		case 'nationalite':
    				$db = '`geoloc_pays`';
    				$field = 'IF(`nat`=\'\', `pays`, `nat`)';
    				$id = '`a2`';
    				break;
    		case 'region':
    		    $db = '`geoloc_region`';
    		    $field = '`name`';
            $id = '`region`'; 
            if (isset($_REQUEST['country'])) {
                $where .= ' WHERE `a2` = "'.$_REQUEST['country'].'"';
            }
    		    break;
    		case 'school':
    				$db = '`applis_def`';
		        $page->assign('onchange', 'changeSchool(this.value)');
    				break;
    		case 'section':
    				$db = '`sections`';
    				break;
    		case 'secteur':
    				$db = '`emploi_secteur`';
    				$field = '`label`';
    				break;
    		default: exit();
    		}
    		if (isset($idVal)) {
       			header('Content-Type: text/plain; charset="UTF-8"');
    				$result = XDB::query('SELECT '.$field.' AS field FROM '.$db.' WHERE '.$id.' = {?} LIMIT 1',$idVal);
    				echo $result->fetchOneCell();
    				exit();
    		}
        header('Content-Type: text/xml; charset="UTF-8"');
        $page->changeTpl('search/adv.list.form.tpl', NO_SKIN);
        $page->assign('name', $type);
    		$page->assign('list', XDB::iterator('
    				SELECT
    						'.$field.' AS field,
    						'.$id.' AS id
    				FROM '.$db.$where.'
    				ORDER BY '.$field));
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
	1	<?php
	2	/***************************************************************************
	3	* Copyright (C) 2003-2007 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),
	29	'advanced_search.php' => $this->make_hook('redir_advanced', AUTH_PUBLIC),
	30	'search/autocomplete' => $this->make_hook('autocomplete', AUTH_COOKIE, 'user', NO_AUTH),
	31	'search/list' => $this->make_hook('list', AUTH_COOKIE, 'user', NO_AUTH),
	32	);
	33	}
	34
	35	function handler_redir_advanced(&$page, $mode = null)
	36	{
	37	pl_redirect('search/adv');
	38	exit;
	39	}
	40
	41	function on_subscribe($forlife, $uid, $promo, $pass)
	42	{
	43	require_once 'user.func.inc.php';
	44	user_reindex($uid);
	45	}
	46
	47
	48	function form_prepare()
	49	{
	50	global $page;
	51
	52	$page->assign('formulaire',1);
	53	}
	54
	55	function get_diplomas($school = null)
	56	{
	57	if (is_null($school) && Env::has('school')) {
	58	$school = Env::i('school');
	59	}
	60
	61	if (!is_null($school)) {
	62	$sql = 'SELECT type FROM applis_def WHERE id=' . $school;
	63	} else {
	64	$sql = 'DESCRIBE applis_def type';
	65	}
	66
	67	$res = XDB::query($sql);
	68	$row = $res->fetchOneRow();
	69	if (!is_null($school)) {
	70	$types = $row[0];
	71	} else {
	72	$types = explode('(',$row[1]);
	73	$types = str_replace("'","",substr($types[1],0,-1));
	74	}
	75	global $page;
	76	$page->assign('choix_diplomas', explode(',',$types));
	77	}
	78
	79	function handler_quick(&$page, $action = null, $subaction = null)
	80	{
	81	global $globals;
	82
	83	if (Env::has('quick') \|\| $action == 'geoloc') {
	84	$page->assign('formulaire', 0);
	85
	86	require_once 'userset.inc.php';
	87	$view = new SearchSet(true, $action == 'geoloc' && substr($subaction, -3) == 'swf');
	88	$view->addMod('minifiche', 'Minifiches', true, array('with_score' => true));
	89	if (S::logged() && !Env::i('nonins')) {
	90	$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true, 'with_score' => true));
	91	$view->addMod('geoloc', 'Planisphère');
	92	}
	93	$view->apply('search', $page, $action, $subaction);
	94
	95	$nb_tot = $view->count();
	96	if ($subaction) {
	97	return;
	98	}
	99	if (!S::logged() && $nb_tot > $globals->search->public_max) {
	100	new ThrowError('Votre recherche a généré trop de résultats pour un affichage public.');
	101	} elseif ($nb_tot > $globals->search->private_max) {
	102	new ThrowError('Recherche trop générale');
	103	} elseif (empty($nb_tot)) {
	104	new ThrowError('il n\'existe personne correspondant à ces critères dans la base !');
	105	}
	106	} else {
	107	$res = XDB::query("SELECT MIN(`diminutif`), MAX(`diminutif`)
	108	FROM `groupex`.`asso`
	109	WHERE `cat` = 'Promotions'");
	110	list($min, $max) = $res->fetchOneRow();
	111	$page->assign('promo_min', $min);
	112	$page->assign('promo_max', $max);
	113	$page->assign('formulaire',1);
	114	$page->addJsLink('ajax.js');
	115	}
	116
	117	require_once dirname(__FILE__) . '/search/search.inc.php';
	118	$page->changeTpl('search/index.tpl');
	119	$page->assign('xorg_title','Polytechnique.org - Annuaire');
	120	$page->assign('baseurl', $globals->baseurl);
	121	}
	122
	123	function handler_advanced(&$page, $action = null, $subaction = null)
	124	{
	125	global $globals;
	126	require_once 'geoloc.inc.php';
	127	require_once dirname(__FILE__) . '/search/search.inc.php';
	128	$page->assign('advanced',1);
	129
	130	if (!Env::has('rechercher') && $action != 'geoloc') {
	131	$this->form_prepare();
	132	} else {
	133	require_once 'userset.inc.php';
	134	$view = new SearchSet(false, $action == 'geoloc' && substr($subaction, -3) == 'swf');
	135	$view->addMod('minifiche', 'Minifiches', true);
	136	$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
	137	$view->addMod('geoloc', 'Planishpère');
	138	$view->apply('search', $page, $action, $subaction);
	139
	140	if ($subaction) {
	141	return;
	142	}
	143	$nb_tot = $view->count();
	144	if ($nb_tot > $globals->search->private_max) {
	145	$this->form_prepare();
	146	new ThrowError('Recherche trop générale');
	147	}
	148	}
	149
	150	$page->changeTpl('search/index.tpl', $action == 'mini' ? SIMPLE : SKINNED);
	151	$page->addJsLink('ajax.js');
	152	$page->assign('public_directory',0);
	153	}
	154
	155	function handler_autocomplete(&$page, $type = null)
	156	{
	157	// Autocompletion : according to type required, return
	158	// a list of results matching with the number of matches.
	159	// The output format is :
	160	// result1\|nb1
	161	// result2\|nb2
	162	// ...
	163	header('Content-Type: text/plain; charset="UTF-8"');
	164	$q = preg_replace(
	165	array(
	166	'/\+$/', // always look for $q
	167	'/([\^\$\[\]])/', // escape special regexp char
	168	'/\*/'), // replace joker by regexp joker
	169	array(
	170	'',
	171	'\\\\\1',
	172	'.*'),
	173	$_REQUEST['q']);
	174	if (!$q) exit();
	175
	176	// try to look in cached results
	177	$cache = XDB::query('
	178	SELECT `result`
	179	FROM `search_autocomplete`
	180	WHERE
	181	`name` = {?} AND
	182	`query` = {?} AND
	183	`generated` > NOW() - INTERVAL 1 DAY',
	184	$type, $q);
	185	if ($res = $cache->fetchOneCell()) {
	186	echo $res;
	187	die();
	188	}
	189
	190	// default search
	191	$unique = '`user_id`';
	192	$db = '`auth_user_md5`';
	193	$realid = false;
	194	$beginwith = true;
	195	$field2 = false;
	196	$qsearch = $q;
	197
	198	switch ($type) {
	199	case 'binetTxt':
	200	$db = '`binets_def` INNER JOIN
	201	`binets_ins` ON(`binets_def`.`id` = `binets_ins`.`binet_id`)';
	202	$field='`binets_def`.`text`';
	203	if (strlen($q) > 2)
	204	$beginwith = false;
	205	$realid = '`binets_def`.`id`';
	206	break;
	207	case 'city':
	208	$db = '`geoloc_city` INNER JOIN
	209	`adresses` ON(`geoloc_city`.`id` = `adresses`.`cityid`)';
	210	$unique='`uid`';
	211	$field='`geoloc_city`.`name`';
	212	break;
	213	case 'countryTxt':
	214	$db = '`geoloc_pays` INNER JOIN
	215	`adresses` ON(`geoloc_pays`.`a2` = `adresses`.`country`)';
	216	$unique='`uid`';
	217	$field = '`geoloc_pays`.`pays`';
	218	$field2 = '`geoloc_pays`.`country`';
	219	$realid='`geoloc_pays`.`a2`';
	220	break;
	221	case 'entreprise':
	222	$db = '`entreprises`';
	223	$field = '`entreprise`';
	224	$unique='`uid`';
	225	break;
	226	case '`firstname`':
	227	$field = '`prenom`';
	228	$q = '(^\|[ \\-])'.$q;
	229	$beginwith = false;
	230	break;
	231	case 'fonctionTxt':
	232	$db = '`fonctions_def` INNER JOIN
	233	`entreprises` ON(`entreprises`.`fonction` = `fonctions_def`.`id`)';
	234	$field = '`fonction_fr`';
	235	$unique = '`uid`';
	236	$realid = '`fonctions_def`.`id`';
	237	$qsearch = '(^\|[ /\\-])'.$q;
	238	$beginwith = false;
	239	break;
	240	case 'groupexTxt':
	241	$db = '`groupesx_def` INNER JOIN
	242	`groupesx_ins` ON(`groupesx_def`.`id` = `groupesx_ins`.`gid`)';
	243	$field='`groupesx_def`.`text`';
	244	if (strlen($q) > 2)
	245	$beginwith = false;
	246	$realid = '`groupesx_def`.`id`';
	247	$unique = '`guid`';
	248	break;
	249	case 'name':
	250	$field = '`nom`';
	251	$field2 = '`nom_usage`';
	252	$qsearch = '(^\|[ \\-])'.$q;
	253	$beginwith = false;
	254	break;
	255	case 'nationaliteTxt':
	256	$db = '`geoloc_pays` INNER JOIN
	257	`auth_user_md5` ON(`geoloc_pays`.`a2` = `auth_user_md5`.`nationalite`)';
	258	$field = 'IF(`geoloc_pays`.`nat`=\'\',
	259	`geoloc_pays`.`pays`,
	260	`geoloc_pays`.`nat`)';
	261	$realid = '`geoloc_pays`.`a2`';
	262	break;
	263	case 'nickname':
	264	$field = '`profile_nick`';
	265	$db = '`auth_user_quick`';
	266	$qsearch = '(^\|[ \\-])'.$q;
	267	$beginwith = false;
	268	break;
	269	case 'poste':
	270	$db = '`entreprises`';
	271	$field = '`poste`';
	272	$unique='`uid`';
	273	break;
	274	case 'schoolTxt':
	275	$db = '`applis_def` INNER JOIN
	276	`applis_ins` ON(`applis_def`.`id` = `applis_ins`.`aid`)';
	277	$field='`applis_def`.`text`';
	278	$unique = '`uid`';
	279	$realid = '`applis_def`.`id`';
	280	if (strlen($q) > 2)
	281	$beginwith = false;
	282	break;
	283	case 'secteurTxt':
	284	$db = '`emploi_secteur` INNER JOIN
	285	`entreprises` ON(`entreprises`.`secteur` = `emploi_secteur`.`id`)';
	286	$field = '`emploi_secteur`.`label`';
	287	$realid = '`emploi_secteur`.`id`';
	288	$unique = '`uid`';
	289	$beginwith = false;
	290	break;
	291	case 'sectionTxt':
	292	$db = '`sections` INNER JOIN
	293	`auth_user_md5` ON(`auth_user_md5`.`section` = `sections`.`id`)';
	294	$field = '`sections`.`text`';
	295	$realid = '`sections`.`id`';
	296	$beginwith = false;
	297	break;
	298	default: exit();
	299	}
	300
	301	$field_select = $field;
	302	if ($field2) {
	303	$field_select = 'IF('.$field.' REGEXP {?}, '.$field.', '.$field2.')';
	304	}
	305
	306	if ($beginwith) {
	307	$qsearch = '^'.$qsearch;
	308	}
	309	$list = XDB::iterator('
	310	SELECT
	311	'.$field_select.' AS field,
	312	COUNT(DISTINCT '.$unique.') AS nb
	313	'.($realid?(', '.$realid.' AS id'):'').'
	314	FROM '.$db.'
	315	WHERE '.$field.' REGEXP {?}'.
	316	($field2?(' OR '.$field2.' REGEXP {?}'):'').'
	317	GROUP BY '.$field_select.'
	318	ORDER BY nb DESC
	319	LIMIT 11',
	320	$qsearch,
	321	$qsearch,
	322	$qsearch,
	323	$qsearch);
	324	$nbResults = 0;
	325	$res = "";
	326	while ($result = $list->next()) {
	327	$nbResults++;
	328	if ($nbResults == 11) {
	329	$res .= '...\|1'."\n";
	330	} else {
	331	$res .= $result['field'].'\|';
	332	$res .= $result['nb'];
	333	if (isset($result['id'])) {
	334	$res .= '\|'.$result['id'];
	335	}
	336	$res .= "\n";
	337	}
	338	}
	339	XDB::query('
	340	REPLACE INTO `search_autocomplete`
	341	VALUES ({?}, {?}, {?}, NOW())',
	342	$type, $q, $res);
	343	echo $res;
	344	exit();
	345	}
	346
	347	function handler_list(&$page, $type = null, $idVal = null)
	348	{
	349	// Give the list of all values possible of type and builds a select input for it
	350	$field = '`text`';
	351	$id = '`id`';
	352	$where = '';
	353
	354	switch ($type) {
	355	case 'binet':
	356	$db = '`binets_def`';
	357	break;
	358	case 'country':
	359	$db = '`geoloc_pays`';
	360	$field = '`pays`';
	361	$id = '`a2`';
	362	$page->assign('onchange', 'changeCountry(this.value)');
	363	break;
	364	case 'fonction':
	365	$db = '`fonctions_def`';
	366	$field = '`fonction_fr`';
	367	break;
	368	case 'diploma':
	369	header('Content-Type: text/xml; charset="UTF-8"');
	370	$this->get_diplomas();
	371	$page->changeTpl('search/adv.grade.form.tpl', NO_SKIN);
	372	return;
	373	case 'groupex':
	374	$db = '`groupesx_def`';
	375	break;
	376	case 'nationalite':
	377	$db = '`geoloc_pays`';
	378	$field = 'IF(`nat`=\'\', `pays`, `nat`)';
	379	$id = '`a2`';
	380	break;
	381	case 'region':
	382	$db = '`geoloc_region`';
	383	$field = '`name`';
	384	$id = '`region`';
	385	if (isset($_REQUEST['country'])) {
	386	$where .= ' WHERE `a2` = "'.$_REQUEST['country'].'"';
	387	}
	388	break;
	389	case 'school':
	390	$db = '`applis_def`';
	391	$page->assign('onchange', 'changeSchool(this.value)');
	392	break;
	393	case 'section':
	394	$db = '`sections`';
	395	break;
	396	case 'secteur':
	397	$db = '`emploi_secteur`';
	398	$field = '`label`';
	399	break;
	400	default: exit();
	401	}
	402	if (isset($idVal)) {
	403	header('Content-Type: text/plain; charset="UTF-8"');
	404	$result = XDB::query('SELECT '.$field.' AS field FROM '.$db.' WHERE '.$id.' = {?} LIMIT 1',$idVal);
	405	echo $result->fetchOneCell();
	406	exit();
	407	}
	408	header('Content-Type: text/xml; charset="UTF-8"');
	409	$page->changeTpl('search/adv.list.form.tpl', NO_SKIN);
	410	$page->assign('name', $type);
	411	$page->assign('list', XDB::iterator('
	412	SELECT
	413	'.$field.' AS field,
	414	'.$id.' AS id
	415	FROM '.$db.$where.'
	416	ORDER BY '.$field));
	417	}
	418	}
	419
	420	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
	421	?>