<?php
// +-------------------------------------------------+
// © 2002-2010 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: affiliate_search.class.php,v 1.7 2012-09-10 13:33:35 ngantier Exp $

require_once($class_path."/connecteurs.class.php");
require_once($class_path."/marc_table.class.php");
require_once($include_path."/parser.inc.php");
require_once($class_path."/search.class.php");
require_once($include_path."/notice_affichage.inc.php");
require_once($include_path."/navbar.inc.php");
require_once($include_path."/surlignage.inc.php");
/*
 *  Classe pilotant les recherches affiliées dans les sources externes
 */
 
class affiliate_search {
	var $affiliate_source = array();
	var $affiliate_source_name = array();
	var $look_array = array(
		"title" => 6,
		"author" => 8,
		"publisher" => 3,
		"collection" => 4,
		"subcollection" => 5,
		"category" => 1,
		"indexint" => 2,
		"keywords" => 12,
		"abstract" => 13,
		"titre_uniforme" => 27,
		"all" => 7
	);
	var $authorities_extended_array = array(
		'2'  => "author",
		'3'  => "publisher",
		'4'  => "collection",
		'5'  => "subcollection",
		'11' => "category",
		'12' => "indexint",
		'51' => "titre_uniforme",
		'6'  => "serie"
	);

    function affiliate_search($user_query="",$search_type="notices") {
    	$this->user_query = $user_query;
    	$this->search_type = $search_type;
    	$this->fetch_sources();
    	$this->generateSearch();
    }
    
    //On récupère la liste des sources affiliées
    function fetch_sources(){
  		global $base_path;
  		
  		$connectors = new connecteurs();
  		$this->catalog = $connectors->catalog;
    	foreach ($connectors->catalog as $id=>$prop) {
			$comment=$prop['COMMENT'];
			//Recherche du nombre de sources
			$n_sources=0;
			if (is_file($base_path."/admin/connecteurs/in/".$prop['PATH']."/".$prop['NAME'].".class.php")) {
				require_once($base_path."/admin/connecteurs/in/".$prop['PATH']."/".$prop['NAME'].".class.php");
				eval("\$conn=new ".$prop['NAME']."(\"".$base_path."/admin/connecteurs/in/".$prop['PATH']."\");");
				$conn->get_sources();
				foreach($conn->sources as $source_id=>$s) {
					if($s['OPAC_AFFILIATE_SEARCH'] == 1 ){
					
						$this->affiliate_source[]= $s['SOURCE_ID'];
						$this->affiliate_source_name[]= $s['NAME'];
					}
	    		}
			}
    	}  	
    }
    
    function generateSearch(){
 		//A surcharger
    }
    
    function generateGlobals(){
    	global $search;
    	
    	$field_label = "f_".$this->look_array[$this->type];
		$search = array();
		$search[0] = $field_label;
		//opérateur
		$op_="BOOLEAN";
	    $op="op_0_".$field_label;
	    global $$op;
	    $$op=$op_;
	    
	   	//contenu de la recherche
	    $field="field_0_".$field_label;
	    $field_=array();
	    $field_[0]=$this->user_query;
		global $$field;
		$$field=$field_;
	    
	    //opérateur inter-champ
	    $inter="inter_0_".$field_label;
	    global $$inter;
	    $$inter="and";
	    		    		
	    //variables auxiliaires
	    $fieldvar_="fieldvar_0_".$field_label;
	    global $$fieldvar_;
	    $$fieldvar_="";
	    $fieldvar=$$fieldvar_;
    }
    
    function addSources(){
    	global $search;
    	global $op_0_s_2;
		global $field_0_s_2;
		
		$flag_found=false;
		for ($i=0; $i<count($search); $i++) {
			if ($search[$i]=="s_2") { $flag_found=true; break; }
		}
		if (!$flag_found) {
			//Pas trouve, on decale tout !!
			for ($i=count($search)-1; $i>=0; $i--) {
				$search[$i+1]=$search[$i];
				$c_field = "field_".$i."_".$search[$i];
				$n_field = "field_".($i+1)."_".$search[$i];
				global $$c_field, $$n_field;
				
				$$n_field=$$c_field;
				$$c_field = "";
				
				$c_op = "op_".$i."_".$search[$i];
				$n_op = "op_".($i+1)."_".$search[$i];
				global $$c_op ,$$n_op;
				$$n_op=$$c_op;
				$$c_op = "";
				
				$c_inter = "inter_".$i."_".$search[$i];
				$n_inter = "inter_".($i+1)."_".$search[$i];
				global $$c_inter,$$n_inter;
				$$n_inter=$$c_inter;
				$$c_inter = "";
				
				$c_fieldvar = "fieldvar_".$i."_".$search[$i];
				$n_fieldvar = "fieldvar_".($i+1)."_".$search[$i];
				global $$c_fieldvar,$$n_fieldvar;
				$$n_fieldvar=$$c_fieldvar;
				$$c_fieldvar = "";
			}
			$search[0]="s_2";
			$op_0_s_2="EQ";
			$field_0_s_2=$this->affiliate_source;
		}
    }
    
    function makeSearch(){
 		//A surcharger
    } 
    
    function getNbResults(){
 		//A surcharger
    }
    
    function getTotalNbResults(){
    	$this->getNbResults();
    	if(is_array($this->getNbResults())){
			$nb_results = $this->nb_results['total'];
		}else $nb_results = $this->nb_results;
		return $nb_results;
    }
    
    function getResults(){
    	switch($this->search_type){
    		case "authorities" :
    			return $this->getAuthoritiesResults();
    			break;
    		case "notices_authority" :
    			return $this->getNoticesAuthorityResults();
    			break;
    		case "notices" :
    		default :
    			return $this->getNoticesResults();
    			break;
    	}
    }
    
    function getAuthoritiesResults(){
		//A surcharger
    }
    
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		$this->results.="&nbsp;&nbsp;";
		
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }
   
	function getNoticesAuthorityResults(){
		//A surcharger
	}   
	function make_hidden_search_form($url,$form_name="form_values",$target="",$close_form=true){
		$form = $this->external_search->make_hidden_search_form("",$form_name,"",$close_form);
		return $form;
	}
	
	function getAuthorityLabel($id,$type){
		global $lang;
		switch ($type){
			case "author":
				$aut=new auteur($id);
				if($aut->rejete) $libelle = $aut->name.', '.$aut->rejete;
				else $libelle = $aut->name;
				if($aut->date) $libelle .= " ($aut->author_date)";
				break;
			case "category":
				$libelle = categories::getlibelle($id,$lang);
				break;
			case "publisher":
				$ed = new publisher($id);
				$libelle=$ed->name;
				if ($ed->ville) {
					if ($ed->pays) $libelle.=" ($ed->ville - $ed->pays)";
					else $libelle.=" ($ed->ville)";
				}
				break;
			case "collection" :
				$coll = new collection($id);
				$libelle = $coll->name;
				break;
			case "subcollection" :
				$coll = new subcollection($id);
				$libelle = $coll->name;
				break;
			case "serie" :
				$serie = new serie($id);
				$libelle = $serie->name;
				break;
			case "indexint" :
				$indexint = new indexint($id);
				$libelle = $indexint->display ;
				break;
			case "titre_uniforme" :
				$tu = new titre_uniforme($id);
				$libelle = $tu->name;
				break;
			default :
				$libelle = "";
				break;		
		}
		return $libelle;
	}
}

/*
 * Classe de recherche sur les auteurs
 */
class affiliate_search_author extends affiliate_search {
	
	function affiliate_search_author($user_query="",$search_type="notices"){
		$this->type= "author";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_auteurs();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0); 
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
	function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";
				switch($this->filter){
					case "71":
						$result_label = $msg['collectivites_found'];
						break;
					case "72" :
						$result_label = $msg['congres_found'];
						break;
					case "70" :
					default :
						$result_label = $msg['authors_found'];
						break;															
				}
				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$result_label." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";
				$aut = $this->fetch_auteurs();
				$authors_tab = array_merge($aut['authors'],$aut['collectivities'],$aut['congres']);
				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($authors_tab) ? ($start_page+$opac_search_results_per_page) : count($authors_tab);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=author&filter=".$authors_tab[$i]['type']."&ext_value=".urlencode($authors_tab[$i]['value'])."\";document.form_values.submit();return false;'>".$authors_tab[$i]['label']."</a></font></li>";
	    		}

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    } 
    	
	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			switch($this->filter){
				case "70" :
					$joins[] = "join entrepot_source_$aff_source on recid = notice_id and ufield like '70_' and value like '$ext_value'";
					break;	
				case "71" :
					$joins[] = "join entrepot_source_$aff_source on recid = notice_id and ufield like '71_' and field_ind not like '1%' and value like '$ext_value'";
					break;	
				case "72" :
					$joins[] = "join entrepot_source_$aff_source on recid = notice_id and ufield like '71_' and field_ind like '1%' and value like '$ext_value'";
					break;
				default :
					$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
					break;
			}
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		switch($this->filter){
			case "71":
				$authority_title = $msg['collectivite_see_title']; 
				break;
			case "72":
				$authority_title = $msg['congres_see_title'];
				break;
			case "70":
			default :
				$authority_title = $msg['author_see_title'];
				break;
		}

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				switch($this->filter){
					case "70" :
						$where = " and ufield like '70_' and value like '$ext_value'";
						break;	
					case "71" :
						$where = " and ufield like '71_' and field_ind not like '1%' and value like '$ext_value'";
						break;	
					case "72" :
						$where = " and ufield like '71_' and field_ind like '1%' and value like '$ext_value'";
						break;
					default :
						$where = " and ufield like '7%' and value like '$ext_value'";
						break;												
				}	
				
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id $where group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ufield = '".$col->ufield."' and field_order = '".$col->field_order."' group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch ($elem->usubfield) {
									case "4":
										$auteur["fonction"]=$elem->value;
										$auteur["fonction_aff"]=$fonction_auteur[$elem->value];
										break;
									case "a":
										$auteur["name"]=$elem->value;
										break;
									case "b":
										$auteur["rejete"]=$elem->value;
										break;
									case "d":
										$auteur["numéro"]=$elem->value;
										break;
									case "e":
										$auteur["lieu"]=$elem->value;
										break;
									case "f":
										$auteur["date"]=$elem->value;
										break;
								}
							}
						}
					}
					$aut_titre=$auteur["rejete"].($auteur["rejete"]?" ":"").$auteur["name"];
					$auteur_cplt = ($auteur["numéro"]?" ".$auteur["numéro"]:"");
					$auteur_cplt.=($auteur_cplt ? " ; " : "").($auteur["date"]? $auteur["date"] : "");
					$auteur_cplt.=($auteur_cplt ? " ; " : "").($auteur["lieu"]? $auteur["lieu"] : "");
					$aut_titre.=($auteur_cplt ? " > ".$auteur_cplt : "");
						
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='authorlevel2'>
					<h3>".htmlentities($aut_titre,ENT_QUOTES)."</h3>
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}
	
	function fetch_auteurs() {
		global $fonction_auteur;
		global $dbh ;
		global $opac_url_base ;

		switch($this->filter){
			case "70" :
				$rqt =  "select *,'70' as type from ".$this->table_tempo." where infos like '70%'";
				break;	
			case "71" :
				$rqt =  "select *,'71' as type from ".$this->table_tempo." where infos not like '71_|1%' and infos  like '71%'";
				break;	
			case "72" :
				$rqt =  "select *,'72' as type from ".$this->table_tempo." where infos like '71_|1%'";
				break;
			default :
				$rqt =  "select *,if(infos like '70%','70',if(infos like '71_|1%','72','71')) as type from ".$this->table_tempo;
				break;
		}

		$res_sql=mysql_query($rqt) or die (mysql_error());
		$authors = $collectivities = $congres = array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			switch($row->type){
				case "70" :
					$rqt  = "select * from entrepot_source_".$infos[7]." where recid='".$infos[6]."' and ufield = '".$infos[0]."' and field_order='".$infos[2]."'";
					$res = mysql_query($rqt);
					$rejete=$entree="";
					if(mysql_num_rows($res))
						while($r = mysql_fetch_object($res)){
							switch($r->usubfield){
								case "a" :
									$entree = $r->value;
									break;
								case "b" :
									$rejete = $r->value;
									break;
							}
						}
					$authors[]=array(
						'value' => $infos[5],
						'label' =>($rejete ? $rejete." " : "").$entree,
						'type' => "70"
					);
					break;
				case "71" :
					$rqt  = "select * from entrepot_source_".$infos[7]." where recid='".$infos[6]."' and ufield = '".$infos[0]."' and field_order='".$infos[2]."'";
					$res = mysql_query($rqt);
					$rejete=$entree="";
					if(mysql_num_rows($res))
						while($r = mysql_fetch_object($res)){
							switch($r->usubfield){
								case "a" :
									$entree = $r->value;
									break;
								case "c" :
									$rejete = $r->value;
									break;
							}
						}
					$collectivities[]=array(
						'value' => $infos[5],
						'label' =>$entree.($rejete ? ", ".$rejete : ""),
						'type' => "71"
					);
					break;
				case "72" :
					$rqt  = "select * from entrepot_source_".$infos[7]." where recid='".$infos[6]."' and ufield = '".$infos[0]."' and field_order='".$infos[2]."'";
					$res = mysql_query($rqt);
					$rejete=$entree="";
					if(mysql_num_rows($res))
						while($r = mysql_fetch_object($res)){
							switch($r->usubfield){
								case "a" :
									$entree = $r->value;
									break;
								case "c" :
									$rejete = $r->value;
									break;
							}
						}
					$congres[]=array(
						'value' => $infos[5],
						'label' =>$entree.($rejete ? ", ".$rejete : ""),
						'type' => "72"
					);
					break;
			}
		}
		$authors = array_unique($authors,SORT_REGULAR);
		$collectivities = array_unique($collectivities,SORT_REGULAR);
		$congres = array_unique($congres,SORT_REGULAR);
		
		$this->nb_results['total'] = count($authors)+count($collectivities)+count($congres);
		$this->nb_results['authors'] = count($authors);
		$this->nb_results['coll'] = count($collectivities);
		$this->nb_results['congres'] = count($congres);
		return array(
			'authors' => $authors,
			'collectivities' => $collectivities,
			'congres' => $congres
		);
	} // fin fetch_auteurs	   
}

/*
 * Classe de recherche sur les auteurs
 */
class affiliate_search_collection extends affiliate_search {
	
	function affiliate_search_collection($user_query="",$search_type="notices"){
		$this->type= "collection";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_collections();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0);
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['collections_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$coll = $this->fetch_collections();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($coll) ? ($start_page+$opac_search_results_per_page) : count($coll);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=collection&ext_value=".urlencode($coll[$i])."\";document.form_values.submit();return false;'>".$coll[$i]."</a></font></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['detail_coll'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and ufield like '225' and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ((ufield = '".$col->ufield."' and field_order = '".$col->field_order."') or ufield = '210') group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->ufield){
									case "225" :
										switch($elem->usubfield){
											case "a" :
												$coll_name = $elem->value;
												break;
											case "x" :
												$issn = $elem->value;
												break;												
										}
									
										break;
									case "210" :
										switch($elem->usubfield){
											case "c" :
												$publisher = $elem->value;
												break;
										}								
										break;
								}
								
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='collectionlevel2'>
					<h3>".$msg['collection_tpl_coll']." ".htmlentities($coll_name,ENT_QUOTES)."</h3>
					<ul>
						<li>".$msg['collection_tpl_publisher']." : ".htmlentities($publisher,ENT_QUOTES)."</li>";
		if($issn) $this->results .="
						<li>".$msg['collection_tpl_issn']." : ".htmlentities($issn,ENT_QUOTES)."</li>";
		$this->results .="				
					</ul>
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }    

	function fetch_collections() {
		global $fonction_auteur;
		global $dbh ;
		global $opac_url_base ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '225%' or infos like '410%'";
		
		$res_sql=mysql_query($rqt);
		$collections=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$collections))
				$collections[]=$infos[5];
		}
				
		$this->nb_results['total'] = count($collections);
		return $collections;
	} // fin fetch_collections	
}


class affiliate_search_abstract extends affiliate_search {
	
	function affiliate_search_abstract($user_query="",$search_type="notices"){
		$this->type= "abstract";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	$this->external_search=new search("search_simple_fields_unimarc");
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
   				$requete="select count(1) from ".$this->table_tempo;
				$resultat=mysql_query($requete);
				$this->nb_results = @mysql_result($resultat,0,0); 
				if(!$this->nb_results) $this->nb_results = 0;
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    }  
}

class affiliate_search_title extends affiliate_search {
	
	function affiliate_search_title($user_query=""){
		$this->type= "title";
		parent::affiliate_search($user_query,"notices");
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	$this->external_search=new search("search_simple_fields_unimarc");
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
   				$requete="select count(1) from ".$this->table_tempo;
				$resultat=mysql_query($requete);
				$this->nb_results = @mysql_result($resultat,0,0); 
				if(!$this->nb_results) $this->nb_results = 0;
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
}

class affiliate_search_all extends affiliate_search {
	
	function affiliate_search_all($user_query=""){
		$this->type= "all";
		parent::affiliate_search($user_query,"notices");
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	$this->external_search=new search("search_simple_fields_unimarc");
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
   				$requete="select count(1) from ".$this->table_tempo;
				$resultat=mysql_query($requete);
				$this->nb_results = @mysql_result($resultat,0,0); 
				if(!$this->nb_results) $this->nb_results = 0;
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
}

class affiliate_search_indexint extends affiliate_search {
	
	function affiliate_search_indexint($user_query="",$search_type="notices"){
		$this->type= "indexint";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_indexint();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0);
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['indexint_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$indexint = $this->fetch_indexint();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($indexint) ? ($start_page+$opac_search_results_per_page) : count($indexint);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li><a href='#' onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=".$this->type."&ext_value=".urlencode($indexint[$i])."\";document.form_values.submit();return false;'><img border='0' src='./images/folder.gif'> ".$indexint[$i]."</a></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['detail_indexint'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and (ufield like '67%' or ufield like '68%') and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ((ufield = '".$col->ufield."' and field_order = '".$col->field_order."')) group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->usubfield){
									case "a" :
										$indexint_lib = $elem->value;
										break;											
								}
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='indexintlevel2'>
					<h3>".htmlentities($indexint_lib,ENT_QUOTES)."</h3>
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }
    
    function fetch_indexint(){
		global $dbh ;
		global $opac_url_base ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '67%' or infos like '68%'";
		
		$res_sql=mysql_query($rqt);
		$indexint=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$indexint))
				$indexint[]=$infos[5];
		}
		$this->nb_results['total'] = count($indexint);
		return $indexint;
    	
    }
}

class affiliate_search_publisher extends affiliate_search {
	
	function affiliate_search_publisher($user_query="",$search_type="notices"){
		$this->type= "publisher";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_publishers();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0); 
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['collections_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$eds = $this->fetch_publishers();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($eds) ? ($start_page+$opac_search_results_per_page) : count($eds);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=publisher&ext_value=".urlencode($eds[$i])."\";document.form_values.submit();return false;'>".$eds[$i]."</a></font></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['publisher_see_title'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and ufield like '210' and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ufield = '210' group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->usubfield){
									case "c" :
										$publisher = $elem->value;
										break;
									case "a" :
										$lieu = $elem->value;
										break;
								}								
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='collectionlevel2'>
					<h3>".sprintf($msg["publisher_details_publisher"],$publisher)."</h3>
					".($lieu ? "<p>".sprintf($msg["publisher_details_location"],$lieu)."</p>." : "")."
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }    

	function fetch_publishers() {
		global $dbh ;
		global $opac_url_base ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '210%'";
		
		$res_sql=mysql_query($rqt);
		$publishers=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$publishers))
				$publishers[]=$infos[5];
		}
				
		$this->nb_results['total'] = count($publishers);
		return $publishers;
	} // fin fetch_publishers	
}

class affiliate_search_keywords extends affiliate_search {
	
	function affiliate_search_keywords($user_query="",$search_type="notices"){
		$this->type= "keywords";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	$this->external_search=new search("search_simple_fields_unimarc");
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
   				$requete="select count(1) from ".$this->table_tempo;
				$resultat=mysql_query($requete);
				$this->nb_results = @mysql_result($resultat,0,0); 
				if(!$this->nb_results) $this->nb_results = 0;
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    }  
}

class affiliate_search_category extends affiliate_search {
	
	function affiliate_search_category($user_query="",$search_type="notices"){
		$this->type= "category";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_categories();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0); 
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['categs_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$categ = $this->fetch_categories();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($categ) ? ($start_page+$opac_search_results_per_page) : count($categ);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=".$this->type."&ext_value=".urlencode($categ[$i])."\";document.form_values.submit();return false;'>".$categ[$i]."</a></font></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['categories'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and ufield like '606' and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ((ufield = '".$col->ufield."' and field_order = '".$col->field_order."')) group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->usubfield){
									case "a" :
										$categ_lib = $elem->value;
										
										break;
								}								
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='categorylevel2'>
					<h3>".$msg['category']." ".htmlentities($categ_lib,ENT_QUOTES)."</h3>
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }    

	function fetch_categories() {
		global $dbh ;
		global $opac_url_base ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '606%'";
		
		$res_sql=mysql_query($rqt);
		$categ=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$categ))
				$categ[]=$infos[5];
		}
				
		$this->nb_results['total'] = count($categ);
		return $categ;
	} // fin fetch_categories	
}

class affiliate_search_subcollection extends affiliate_search {
	
	function affiliate_search_subcollection($user_query="",$search_type="notices"){
		$this->type= "subcollection";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_subcollections();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0); 
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['subcolls_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$subcoll = $this->fetch_subcollections();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($subcoll) ? ($start_page+$opac_search_results_per_page) : count($subcoll);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=subcollection&ext_value=".urlencode($subcoll[$i])."\";document.form_values.submit();return false;'>".$subcoll[$i]."</a></font></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['detail_coll'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and ufield like '225' and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ((ufield = '".$col->ufield."' and field_order = '".$col->field_order."') or ufield = '210' or ufield = '410' or ufield = '411') group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->ufield){
									case "410" :
										$coll_name = $elem->value;
										break;
									case "411" :
										$subcoll_name = $elem->value;
										break;
									case "225" :
										switch($elem->usubfield){
											case "a" :
												$coll_name = $elem->value;
												break;
											case "i" :
												$subcoll_name = $elem->value;
												break;
											case "x" :
												$issn = $elem->value;
												break;												
										}
										break;
									case "210" :
										switch($elem->usubfield){
											case "c" :
												$publisher = $elem->value;
												break;
										}								
										break;
								}
								
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<h3>".sprintf($msg["subcollection_details_subcollection"],$subcoll_name)."</h3>
				<ul>
				  <li>".sprintf($msg["subcollection_details_author"],$publisher)."</li>
				  <li>".sprintf($msg["subcollection_details_collection"],$coll_name)."</li>";
		if($issn) $this->results .="
						<li>".sprintf($msg["subcollection_details_issn"],$issn)."</li>";
		$this->results .="				
				</ul>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }    

	function fetch_subcollections() {
		global $dbh ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '225|%|%|i%' or infos like '411|%|%|t%'";
		$res_sql=mysql_query($rqt);
		$subcollections=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$subcollections))
				$subcollections[]=$infos[5];
		}
				
		$this->nb_results['total'] = count($subcollections);
		return $subcollections;
	} // fin fetch_subcollections	
}
class affiliate_search_titre_uniforme extends affiliate_search {
	
	function affiliate_search_titre_uniforme($user_query="",$search_type="notices"){
		$this->type= "titre_uniforme";
		parent::affiliate_search($user_query,$search_type);
	} 
	
	function generateSearch(){
		$this->generateGlobals();	
		$this->addSources();
    }	
    
    function makeSearch(){
    	global $search;
    	if($this->search_type == "authorities"){
   			$search_file="search_simple_fields_authorities";
    	}else $search_file="search_simple_fields_unimarc";

    	$this->external_search=new search($search_file);
		$this->table_tempo = $this->external_search->make_search("f_".$this->look_array[$this->type]);
    }

	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
    			if($this->search_type == "authorities"){
   					$this->fetch_tu();
    			}else{
    				$requete="select count(1) from ".$this->table_tempo;
					$resultat=mysql_query($requete);
					$this->nb_results = @mysql_result($resultat,0,0); 
					if(!$this->nb_results) $this->nb_results = 0;
    			}
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
    
   function getAuthoritiesResults(){
    	global $msg;
    	global $opac_search_results_per_page;
    	global $page;
    	    	
    	if($this->table_tempo){
 			if(!$this->authoritiesResult){
		    	$this->authoritiesResult ="
				<div id='resultatrech_container'>
					<div id='resultatrech_see'>";


				$this->authoritiesResult.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titres_uniformes_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
				$this->authoritiesResult.= "
					</div>
					<div id='resultatrech_liste'>
						<ul>";	
				$tus = $this->fetch_tu();

				if(!$page) $page = 1; 
	    		$start_page=$opac_search_results_per_page*($page-1);
	    		$last_item = ($start_page+$opac_search_results_per_page) <= count($tus) ? ($start_page+$opac_search_results_per_page) : count($tus);
	    		for($i = $start_page ; $i<$last_item ; $i++){
	    			$this->authoritiesResult.= "
					<li class='categ_colonne'><font class='notice_fort'><a href='#'  onclick='document.form_values.action=\"./index.php?lvl=external_authorities&type=titre_uniforme&ext_value=".urlencode($tus[$i])."\";document.form_values.submit();return false;'>".$tus[$i]."</a></font></li>";
	    		}												

		    	$this->authoritiesResult.= "
						</ul>
		    		</div>
				</div>";
				//gestion de la pagination...
				$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
				$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
				$this->authoritiesResult.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
 			}
    	}else{
    		global $search;
    		$this->makeSearch();
    		$this->getAuthoritiesResults();
    	}
    	return $this->authoritiesResult;
    }   
    
 	function getNoticesAuthorityResults(){
		global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;
    	global $fonction_auteur;					
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	
    	global $ext_value;
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}	
    	
    	$joins = array();
		foreach($this->affiliate_source as $aff_source){
			$joins[] = "join entrepot_source_$aff_source on recid = notice_id and value like '$ext_value'";
		}		
		if(count($joins)){
			$result = array();
			$nb_results=0;
			foreach($joins as $join){
				$res =mysql_query("select distinct notice_id, pert from ".$this->table_tempo." ".$join);
				while($row = mysql_fetch_object($res)){
					$result[]=$row;
					$nb_results++;
				}
			}
			//TODO : Classsement du tableau par pert...
		}
		
		$authority_title = $msg['titre_uniforme_see_title'];

		//construction des infos de l'autorité...
		$rqt= "select distinct source_id from ".$this->table_tempo." join  external_count on notice_id = rid";
		$resultat = mysql_query($rqt);
		if(mysql_num_rows($resultat)){
			while($r = mysql_fetch_object($resultat)){
				$rqt = "select ufield,field_order,recid from entrepot_source_".$r->source_id." join ".$this->table_tempo." where recid=notice_id  and ufield like '500' and value like '$ext_value' group by ufield,field_order order by recid,field_order";
				$result_sql = mysql_query($rqt);
				if(mysql_num_rows($result_sql)){
					while($col = mysql_fetch_object($result_sql)){
						$rqt = "select ufield,field_order,usubfield,value from entrepot_source_".$r->source_id." where recid='".$col->recid."' and ufield = '500' group by ufield,usubfield,field_order,subfield_order,value order by recid,field_order,subfield_order";
						$plop = mysql_query($rqt);
						if(mysql_num_rows($plop)){
							while($elem = mysql_fetch_object($plop)){
								switch($elem->usubfield){
									case "a" :
										$tu = $elem->value;
										break;
								}								
							}
						}
					}
					//si on a trouvé un résultat, on insiste pas...
					break;
				}
			}
		}
		$this->results ="
		<div id='aut_details'>
			<h3>".htmlentities($authority_title,ENT_QUOTES)."</h3>
			<div id='aut_see'>
				<div class='collectionlevel2'>
					<h3>".sprintf($msg["titre_uniforme_detail"],$tu)."</h3>
				</div>
			</div>
			<div id='aut_details_liste'>
			<h3>".htmlentities($nb_results,ENT_QUOTES)." ".$msg['affiliate_search_external_authority_results'].implode($msg['affiliate_search_external_results_and'],$this->affiliate_source_name)."</h3>";

		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
		$last_item = ($start_page+$opac_search_results_per_page) <= count($result) ? ($start_page+$opac_search_results_per_page) : count($result);
    	for($i=$start_page ; $i<$last_item ; $i++){
			$this->results.= aff_notice_unimarc($result[$i]->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($nb_results/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;	
	}   
	
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//on a besoin d'un formulaire pour reposter la recherche
		//$this->results.= $this->make_hidden_search_form();
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }    

	function fetch_tu() {
		global $dbh ;
		global $opac_url_base ;
	
		$auteurs = array() ;

		$rqt = "select * from ".$this->table_tempo." where infos like '500%'";
		
		$res_sql=mysql_query($rqt);
		$tu=array();
		while($row= mysql_fetch_object($res_sql)){
			$infos = explode("|",$row->infos);
			if(!in_array($infos[5],$tu))
				$tu[]=$infos[5];
		}
				
		$this->nb_results['total'] = count($tu);
		return $tu;
	} // fin fetch_tu
}

class affiliate_search_extended extends affiliate_search {
//
	
	function affiliate_search_extended($user_query=""){
		$tempsearch = unserialize(stripslashes($user_query));
		for($i = 0 ; $i<count($tempsearch['SEARCH']) ; $i++){
			if($tempsearch[$i]['OP'] == "AUTHORITY"){
				$tempsearch[$i]['OP'] = "BOOLEAN";
				$s = explode("_",$tempsearch[$i]['SEARCH']);
				$tempsearch[$i]['FIELD'][0] = $this->getAuthorityLabel($tempsearch[$i]['FIELD'][0],$this->authorities_extended_array[$s[1]]);
			}
		}
		$this->serialized = serialize($tempsearch);
		$this->search_type = "notices";
    	$this->fetch_sources();
    	$this->generateSearch();
    	
	} 
		
	function generateSearch(){
		$this->external_search=new search("search_fields_unimarc");
		$this->external_search->unserialize_search($this->serialized);
		$this->addSources();
		global $search;
    }	

    function makeSearch(){
    	global $search;	
		$this->external_search->remove_forbidden_fields();    	
		$this->table_tempo = $this->external_search->make_search();
    }
    
	function getNoticesResults() {
    	global $dbh;
    	global $begin_result_liste;
    	global $opac_notices_depliable;
    	global $opac_show_suggest;
    	global $opac_resa_popup;
    	global $opac_search_results_per_page;
    	$nb_per_page_search = $opac_search_results_per_page;
    	global $page;
    	global $charset;
    	global $search;
    	global $msg;						
						
    	global $affich_tris_result_liste;
    	global $count;
    	global $add_cart_link;    	
    	if(!$page) $page = 1; 
    	$start_page=$nb_per_page_search*($page-1);
    	
    	//Y-a-t-il des champs ?
    	if (count($search)==0) {
    		return;
    	}

    	if(!$this->table_tempo){
    		global $search;
    		$this->makeSearch();
    	}
    	
    	$requete = "select * from ".$this->table_tempo;
		$requete .= " limit ".$start_page.",".$nb_per_page_search;
		$resultat=mysql_query($requete,$dbh);

    	$this->results ="

		<div id=\"resultatrech_container\">
		<div id=\"resultatrech_see\">
		";

		$this->results.= pmb_bidi("<h3>".$this->getTotalNbResults()." ".$msg['titles_found']." ".$this->external_search->make_human_query().activation_surlignage()."</h3>");
		
		if ($opac_notices_depliable) $this->results.= $begin_result_liste;
		
		if ($opac_show_suggest) {
			$bt_sugg = "&nbsp;&nbsp;&nbsp;<a href=# ";		
			if ($opac_resa_popup) $bt_sugg .= " onClick=\"w=window.open('./do_resa.php?lvl=make_sugg&oresa=popup','doresa','scrollbars=yes,width=600,height=600,menubar=0,resizable=yes'); w.focus(); return false;\"";
			else $bt_sugg .= "onClick=\"document.location='./do_resa.php?lvl=make_sugg&oresa=popup' \" ";			
			$bt_sugg.= " >".$msg['empr_bt_make_sugg']."</a>";
			$this->results.= $bt_sugg;
		}
		$this->results.="&nbsp;&nbsp;";
		
		flush();
		
		$entrepots_localisations = array();
		$entrepots_localisations_sql = "SELECT * FROM entrepots_localisations ORDER BY loc_visible DESC";
		$res = mysql_query($entrepots_localisations_sql);
		while ($row = mysql_fetch_array($res)) {
			$entrepots_localisations[$row["loc_code"]] = array("libelle" => $row["loc_libelle"], "visible" => $row["loc_visible"]); 
		}	
		
		$this->results.= $add_cart_link;
		
		$this->results.= "	</div>\n
		<div id=\"resultatrech_liste\">";
		$this->results.= "<blockquote>";
    	while ($r=mysql_fetch_object($resultat)) {
			$this->results.= aff_notice_unimarc($r->notice_id, 0, $entrepots_localisations);
    	}
    	$this->results.= "</blockquote>";   
    	$this->results.= "</div>
		</div>";
		//gestion de la pagination...
		$nbepages = ceil($this->getTotalNbResults()/$opac_search_results_per_page);
		$url_page = "javascript:document.form_values.page.value=!!page!!; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$action = "javascript:document.form_values.page.value=document.form.page.value; document.form_values.action = \"./index.php?lvl=more_results&tab=affiliate\"; document.form_values.affiliate_page.value=document.form_values.page.value; document.form_values.submit()";
		$this->results.=  "<div id='navbar'><hr />\n<center>".printnavbar($page, $nbepages, $url_page,$action,"catal_pag")."</center></div>";
		return $this->results;
    }
    
	function getNbResults(){
    	if(!$this->nb_results){
    		if($this->table_tempo){
   				$requete="select count(1) from ".$this->table_tempo;
				$resultat=mysql_query($requete);
				$this->nb_results = @mysql_result($resultat,0,0); 
				if(!$this->nb_results) $this->nb_results = 0;
    		}else{
    			global $search;
    			$this->makeSearch();
    			$this->getNbResults();
    		}
    	}
    	return $this->nb_results;
    } 
}
?>