text_query = "select t0.notice_id, (".$select_pert.") as pert from ".$from." join notices on t0.notice_id = notices.notice_id ".str_replace("notice_id",'t0.notice_id',$acces_j)." group by t0.notice_id order by pert desc, notices.index_sew ";
$result = pmb_mysql_query($this->text_query,$dbh);
if($result) {
$this->nbresults = pmb_mysql_num_rows($result);
} else {
$this->nbresults = 0;
}
}
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
return NOTICE_LIST;
}
}
public function make_aut_search() {
global $msg;
global $charset;
global $nb_per_page_a_search;
global $typdoc_query, $statut_query;
global $acces_j;
global $aut_type;
$restrict='';
if ($typdoc_query) $restrict = "and typdoc='".$typdoc_query."' ";
if ($statut_query) $restrict.= "and statut='".$statut_query."' ";
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
switch ($aut_type) {
case 'concept':
$requete_count = "select count(num_object) from index_concept ";
$requete_count .= $acces_j;
$requete_count .= "where num_concept = ".$this->id." and type_object = ".TYPE_NOTICE." ";
$requete_count .= $restrict;
$requete = "select num_object as notice_id from index_concept ";
$requete .= $acces_j;
$requete .= "where num_concept = ".$this->id." and type_object = ".TYPE_NOTICE." ";
$requete .= $restrict." ";
break;
default:
$requete_count = "select count(distinct notice_id) from notices ";
$requete_count.= $acces_j;
$requete_count.= ", responsability where notice_id=responsability_notice and responsability_author=".$this->id." ";
$requete_count.= $restrict;
$requete = "select distinct notice_id from notices ";
$requete.= $acces_j;
$requete.= ", responsability where notice_id=responsability_notice and responsability_author=".$this->id." ";
$requete.= $restrict." ";
$requete.= "order by index_serie, tnvol, index_sew ";
// $requete.= "limit ".($this->page*$this->nb_per_page).", ".$this->nb_per_page;
break;
}
$this->nbresults=@pmb_mysql_result(@pmb_mysql_query($requete_count),0,0);
$this->t_query=@pmb_mysql_query($requete);
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
$this->text_query=$requete;
}
public function store_search() {
global $title_query,$all_query, $author_query,$typdoc_query, $statut_query,$categ_query,$docnum_query,$pmb_indexation_docnum, $author_query_id, $categ_query_id;
global $thesaurus_concepts_active,$concept_query, $concept_query_id, $thesaurus_concepts_autopostage, $concepts_autopostage_query;
global $date_parution_start_query, $date_parution_end_query, $date_parution_exact_query;
global $charset;
$author_query_id+= 0;
$categ_query_id+= 0;
$concept_query_id+= 0;
$champs="${msg[234]} ".htmlentities(stripslashes($author_query),ENT_QUOTES,$charset);
$this->human_query=$research;
$this->human_aut_query=$research;
if ($this->nbresults) {
$research .= " => ".$this->nbresults." ".$msg["search_resultat"];
print pmb_bidi("$research
");
$author_list="\n";
$parity = 0 ;
while ($row=pmb_mysql_fetch_object($this->t_query)) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$authority = new authority($row->id_authority);
$auteur = new auteur($authority->get_num_object());
$notice_count_sql = "SELECT count(DISTINCT responsability_notice) FROM responsability WHERE responsability_author = ".$authority->get_num_object();
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
if($auteur->see) {
$notice_auteur_see_count_sql = "SELECT count(DISTINCT responsability_notice) FROM responsability WHERE responsability_author = ".$auteur->see;
$notice_auteur_see_count = pmb_mysql_result(pmb_mysql_query($notice_auteur_see_count_sql), 0, 0);
$link = $this->base_url."&aut_id=".$auteur->id."&etat=aut_search&typdoc_query=".$typdoc_query."&statut_query=".$statut_query;
$link_see = $this->base_url."&aut_id=".$auteur->see."&etat=aut_search&typdoc_query=".$typdoc_query."&statut_query=".$statut_query;
$forme = $auteur->display.". - ".$msg["see"]." : $auteur->see_libelle (".$notice_auteur_see_count.") ";
} else {
$link = $this->base_url."&aut_id=".$auteur->id."&etat=aut_search&typdoc_query=".$typdoc_query."&statut_query=".$statut_query;
$forme = $auteur->display;
}
$tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='$link';\" ";
$author_list .= "$forme ".$notice_count."
\n";
print pmb_bidi($author_list);
} else {
$this->show_form();
$cles="".htmlentities(stripslashes($author_query),ENT_QUOTES, $charset)." ";
//if ($pmb_allow_external_search) $external="".$msg["connecteurs_external_search_sources"]." ";
//error_message($msg[357], sprintf($msg["connecteurs_no_title"],$cles,$external), 0, "./catalog.php?categ=search&mode=0");
error_message($msg[357], $msg[362]." ".$cles, 0, "./catalog.php?categ=search&mode=0");
}
}
public function notice_list_common($title) {
global $begin_result_liste;
global $end_result_liste;
global $msg;
global $charset;
global $pmb_nb_max_tri;
global $title_query,$author_query, $all_query,$categ_query;
global $link,$link_expl,$link_explnum,$link_serial,$link_analysis,$link_bulletin,$link_explnum_serial,$link_explnum_analysis,$link_explnum_bulletin,$link_notice_bulletin;
global $pmb_allow_external_search;
global $load_tablist_js;
if ($this->nbresults) {
$research=$title;
$research .= " => ".sprintf($msg["searcher_results"],$this->nbresults);
print pmb_bidi("$research
");
print $this->get_current_search_map(0);
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
if (($this->etat=='first_search')&&((string)$this->page=="")) {
$current=count($_SESSION["session_history"]);
} else {
$current=$_SESSION["CURRENT"];
}
if ($current!==false) {
echo " ";
echo " ";
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
echo "";
echo " ";
echo "";
echo " ";
if ($pmb_allow_external_search) {
echo " ";
echo " ";
}
// on affiche l'icone de tri seulement si on a atteint un nb maxi de résultats
if ($this->nbresults<=$pmb_nb_max_tri) {
//affichage de l'icone de tri
echo "";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
if($nb++>5) $recherche_ajax_mode=1;
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
switch ($n->niveau_biblio) {
case 's' :
// on a affaire à un périodique
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1 ,$recherche_ajax_mode);
print $serial->result;
break;
case 'a' :
// on a affaire à un article
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1 ,$recherche_ajax_mode);
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
//si on a les droits
if(SESSrights & CATALOGAGE_AUTH){
//on teste la validité du lien
if(!$link_notice_bulletin){
$real_link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
} else {
$real_link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
} elseif($link_notice_bulletin) {
$real_link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $real_link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
print $display->result;
break;
default:
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
}
}
// fin de liste
print $end_result_liste;
} else {
$this->show_form();
$cles="".$title." ";
if ($pmb_allow_external_search) $external="".$msg["connecteurs_external_search_sources"]." ";
error_message($msg[357], sprintf($msg["connecteurs_no_title"],$cles,$external), 0, "./catalog.php?categ=search&mode=0");
}
}
public function notice_list() {
global $msg;
global $charset;
global $title_query,$author_query,$all_query,$categ_query;
global $thesaurus_concepts_active,$concept_query;
global $typdoc_query, $statut_query,$dbh;
global $date_parution_start_query, $date_parution_end_query, $date_parution_exact_query;
$research = '';
if($this->docnum){
$libelle = " [".$msg['docnum_search_with']."]";
} else $libelle ='';
if ($title_query) {
$research .= "${msg[233]} ".htmlentities(stripslashes($title_query),ENT_QUOTES,$charset);
}
if ($all_query && !$title_query) {
$research.="".$msg['global_search'].$libelle." ".htmlentities(stripslashes($all_query),ENT_QUOTES,$charset);
} else if (($all_query && $title_query)) {
$research.= ", ".$msg['global_search'].$libelle." ".htmlentities(stripslashes($all_query),ENT_QUOTES,$charset);
}
if ($categ_query) {
if ($research != "") $research .= ", ";
$research .= "${msg["search_categorie_title"]} ".htmlentities(stripslashes($categ_query),ENT_QUOTES,$charset);
}
if ($author_query) {
$research.=", ${msg[234]} ".htmlentities(stripslashes($author_query),ENT_QUOTES,$charset);
}
if ($thesaurus_concepts_active && $concept_query) {
if ($research != "") $research .= ", ";
$research.="${msg['search_concept_title']} ".htmlentities(stripslashes($concept_query),ENT_QUOTES,$charset);
}
if ($typdoc_query){
if ($research != "") $research .= ", ";
$doctype = new marc_list('doctype');
$research.= "".$msg["17"].$msg["1901"]." ".$doctype->table[$typdoc_query];
}
if ($statut_query){
if ($research != "") $research .= ", ";
$query = "SELECT gestion_libelle FROM notice_statut WHERE id_notice_statut='".$statut_query."'";
$result = pmb_mysql_query($query, $dbh);
if($result && pmb_mysql_num_rows($result)){
$row=pmb_mysql_fetch_object($result);
$statut_libelle=$row->gestion_libelle;
}else{
$statut_libelle="";
}
$research.= "".$msg["noti_statut_noti"].$msg["1901"]." ".htmlentities(stripslashes($statut_libelle),ENT_QUOTES,$charset);
}
if ($date_parution_start_query || $date_parution_end_query){
if ($research != "") $research .= ", ";
if ($date_parution_start_query && $date_parution_end_query && !$date_parution_exact_query){
$research.= ''.$msg['search_date_parution'].': '.$msg['search_date_parution_start'].' '.$date_parution_start_query
.', '.$msg['search_date_parution_end'].' '.$date_parution_end_query;
}elseif ($date_parution_start_query && $date_parution_exact_query){
$research.= ''.$msg['search_date_parution'].': '.$date_parution_start_query;
}elseif ($date_parution_start_query ){
$research.= ''.$msg['search_date_parution'].': '.$msg['search_date_parution_start'].' '.$date_parution_start_query;
}elseif ($date_parution_end_query ){
$research.= ''.$msg['search_date_parution'].': '.$msg['search_date_parution_end'].' '.$date_parution_end_query;
}
}
$this->human_query=$research;
$this->human_notice_query=$research;
$this->notice_list_common($research);
}
public function aut_notice_list() {
global $msg;
global $charset;
global $aut_type;
$research = "";
switch ($aut_type) {
case 'concept' :
$concept = new concept($this->id);
$research.="${msg['search_concept_title']} ".$concept->get_display_label();
break;
default :
$auteur = new auteur($this->id);
$research.="${msg[234]} ".$auteur->display;
break;
}
$this->human_notice_query=$research;
$this->notice_list_common($research);
}
public function rec_env() {
global $msg;
global $memo_tempo_table_to_rebuild;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
if(isset($_SESSION["session_history"])) $_SESSION["CURRENT"] = count($_SESSION["session_history"]);
else $_SESSION["CURRENT"] = 0;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$msg["354"];
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["DOCNUM_QUERY"]=$this->docnum;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["AUTO_POSTAGE_QUERY"]=$this->auto_postage_query;
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["DOCNUM_QUERY"]=$this->docnum;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["AUTO_POSTAGE_QUERY"]=$this->auto_postage_query;
}
break;
case 'aut_search':
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
$x=0;
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"]) {
$op_="BOOLEAN";
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"];
$search[$x]="f_6";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"];
$op_="BOOLEAN";
$search[$x]="f_7";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
$t["is_num"][0]=$_SESSION["session_history"][$id_champ]["NOTI"]["DOCNUM_QUERY"];
$t["ck_affiche"][0]=$_SESSION["session_history"][$id_champ]["NOTI"]["DOCNUM_QUERY"];
${$fieldvar_}=$t;
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"];
$op_="BOOLEAN";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
} else {
if ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"];
$op_="EQ";
$search[$x]="f_9";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["statut_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["statut_query"];
$op_="EQ";
$search[$x]="f_10";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
}
public static function convert_simple_multi_unimarc($id_champ) {
global $search;
$x=0;
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"]) {
$op_="BOOLEAN";
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"];
$search[$x]="f_6";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"];
$op_="BOOLEAN";
$search[$x]="f_7";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"];
$op_="BOOLEAN";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
} else {
if ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"]) {
$author_id=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$requete="select concat(author_name,', ',author_rejete) from authors where author_id=".$author_id;
$r_author=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_author)) {
$valeur_champ=pmb_mysql_result($r_author,0,0);
}
$op_="BOOLEAN";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"];
$op_="EQ";
$search[$x]="f_9";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
//Pas de statut !
}
}
class searcher_subject extends searcher {
public $s_query="";
public $i_query="";
public $id_query="";
public $nb_s;
public $nb_i;
public $nb_id;
public $t_query;
public function show_form() {
global $search_subject;
global $search_indexint,$search_indexint_id;
global $msg;
global $charset;
global $current_module;
global $select3_prop,$search_form_categ,$browser;
global $browser_url;
global $thesaurus_mode_pmb;
global $id_thes;
//affichage du selectionneur de thesaurus et du lien vers les thésaurus
$liste_thesaurus = thesaurus::getThesaurusList();
$sel_thesaurus = '';
$lien_thesaurus = '';
if ($thesaurus_mode_pmb != 0) { //la liste des thesaurus n'est pas affichée en mode monothesaurus
$sel_thesaurus = "" ;
foreach($liste_thesaurus as $id_thesaurus=>$libelle_thesaurus) {
$sel_thesaurus.= "";
}
$sel_thesaurus.= " ";
$sel_thesaurus.= " ";
}
$search_form_categ=str_replace("",$sel_thesaurus,$search_form_categ);
//affichage du choix de langue pour la recherche
// $sel_langue = '';
// $sel_langue = "";
// $sel_langue.= "
" ;
foreach($liste_thesaurus as $id_thesaurus=>$libelle_thesaurus) {
$sel_thesaurus.= "";
}
$sel_thesaurus.= " ";
$sel_thesaurus.= " ";
}
$search_form_categ=str_replace("",$sel_thesaurus,$search_form_categ);
//affichage du choix de langue pour la recherche
// $sel_langue = '';
// $sel_langue = "";
// $sel_langue.= "
".$msg["histo_subject"]." ".htmlentities(stripslashes($search_subject),ENT_QUOTES,$charset);
if ($search_indexint) $human[]="".$msg["histo_indexint"]." ".htmlentities(stripslashes($search_indexint),ENT_QUOTES,$charset);
$this->human_query=implode(", ",$human);
$this->human_aut_query=implode(", ",$human);
if ($this->nb_s) {
$empty=false;
print "${msg[23]} : ".sprintf($msg["searcher_results"],$this->nb_s)." ";
while($categ=@pmb_mysql_fetch_object($this->s_query)) {
$pair_impair = $parity % 2 ? "even" : "odd";
$temp = new category($categ->categ_id);
if($temp->voir_id) {
$cr=$temp->catalog_form;
$temp = new category($temp->voir_id);
$display = htmlentities($cr,ENT_QUOTES,$charset)." -> ".htmlentities($temp->catalog_form,ENT_QUOTES,$charset)."@ ";
} else {
$display = htmlentities($temp->catalog_form,ENT_QUOTES,$charset);
}
if($temp->has_notices()) {
$notice_count = $temp->notice_count(false);
$link_categ = "$display $notice_count ";
}
else {
$empty=true;
if ($show_empty) $link_categ = "$display $link_categ ";
}
print "
";
if (($empty)&&(!$show_empty)) print "".$msg["searcher_categ_empty_results"]." ";
}
if (($this->nb_i)||($this->nb_id)) {
if ($this->nb_id) {
print "".$msg['indexint_catal_title']." ".$msg["searcher_exact_indexint"].": ".sprintf($msg["searcher_results"],$this->nb_id)." ";
$id_=array();
$empty=false;
while($indexint=@pmb_mysql_fetch_object($this->id_query)) {
$pair_impair = $parity % 2 ? "even" : "odd";
$id_[$indexint->indexint_id]=1;
$temp = new indexint($indexint->indexint_id);
$display = htmlentities($temp->name." - ".$temp->comment,ENT_QUOTES,$charset);
if($temp->has_notices()) {
$notice_count_sql = "SELECT count(*) FROM notices WHERE indexint = ".$temp->indexint_id;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
$link = "$display ".$notice_count." ";
}
else {
$empty=true;
if ($show_empty) $link = "$display $link ";
$parity += 1;
}
}
print "
";
if (($empty)&&(!$show_empty)) print "".$msg["searcher_indexint_empty_results"]." $display ".$notice_count." ";
}
else {
$empty=true;
if ($show_empty) $link = "$display $link ";
$parity += 1;
}
} else $this->nb_i--;
}
$i_="".$msg['indexint_catal_title']." ".$msg["searcher_descr_indexint"]." : ".sprintf($msg["searcher_results"],$this->nb_i)." ".$msg["searcher_indexint_empty_results"]." ";
print $i_;
}
}
}
public function notice_list_common($title) {
global $begin_result_liste;
global $end_result_liste;
global $msg;
global $charset;
global $pmb_nb_max_tri;
global $link,$link_expl,$link_explnum,$link_serial,$link_analysis,$link_bulletin,$link_explnum_serial,$link_explnum_analysis,$link_explnum_bulletin,$link_notice_bulletin;
global $pmb_allow_external_search;
global $load_tablist_js;
$research=$title;
$research .= " => ".sprintf($msg["searcher_results"],$this->nbresults);
if($this->auto_postage_form) $research.=" ".$this->auto_postage_form;
print "$research
";
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
if ((($this->etat=='first_search')&&((string)$this->page==""))||($this->direct))
$current=count($_SESSION["session_history"]);
else
$current=$_SESSION["CURRENT"];
if ($current!==false) {
echo " ";
echo " ";
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
echo "";
echo " ";
echo "";
echo " ";
if ($pmb_allow_external_search) {
print " ";
echo " ";
}
// on affiche l'icone de tri seulement si on a atteint un nb maxi de résultats
if ($this->nbresults<=$pmb_nb_max_tri) {
//affichage de l'icone de tri
echo "";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(1);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
if($nb++>5)$recherche_ajax_mode=1;
switch($n->niveau_biblio) {
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
case 's' :
// on a affaire à un périodique
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'a' :
// on a affaire à un article
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
if(!$link_notice_bulletin){
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
} else {
$link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
$link_notice_bulletin = '';
print $display->result;
break;
}
}
// fin de liste
print $end_result_liste;
}
public function aut_notice_list() {
global $msg;
global $charset;
global $aut_type;
global $search_subject,$search_indexint;
if ($this->direct) {
if ($search_subject) $human[]="".$msg["histo_subject"]." ".htmlentities(stripslashes($search_subject),ENT_QUOTES,$charset);
if ($search_indexint) $human[]="".$msg["histo_indexint"]." ".htmlentities(stripslashes($search_indexint),ENT_QUOTES,$charset);
$this->human_query=implode(", ",$human);
$this->human_aut_query=implode(", ",$human);
}
switch ($aut_type) {
case "indexint":
$temp = new indexint($this->id);
$display = "".$msg["searcher_indexint"]." ".htmlentities($temp->name." - ".$temp->comment,ENT_QUOTES,$charset);
$this->human_notice_query=$display;
break;
case "categ":
$display = "".$msg["searcher_categ"]." ";
$temp = new category($this->id);
if($temp->voir_id) {
$cr=$temp->catalog_form;
$temp = new category($temp->voir_id);
$display.=htmlentities($cr,ENT_QUOTES,$charset)." -> ".htmlentities($temp->catalog_form,ENT_QUOTES,$charset)."@ ";
} else {
$display.=htmlentities($temp->catalog_form,ENT_QUOTES,$charset);
}
$this->human_notice_query=$display;
break;
}
$this->notice_list_common($display);
}
public function rec_env() {
global $msg;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$msg["355"];
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
}
break;
case 'aut_search':
if ($this->direct) {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
// $_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["HUMAN_TITLE"]=$msg["335"];
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint_id"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint_id"];
$op_="EQ";
$search[0]="f_2";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint"];
$op_="EXACT";
$search[0]="f_2";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_subject"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_subject"];
$op_="EQ";
$search[0]="f_1";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"]) {
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "indexint":
$search[0]="f_2";
break;
case "categ":
$search[0]="f_1";
break;
}
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
public static function convert_simple_multi_unimarc($id_champ) {
global $search;
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint_id"]) {
$indexint_id=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint_id"];
//Recherche de l'indexation
$requete="select indexint_name from indexint where indexint_id=".$indexint_id;
$r_indexint=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_indexint)) {
$valeur_champ=pmb_mysql_result($r_indexint,0,0);
}
$op_="BOOLEAN";
$search[0]="f_2";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_indexint"];
$op_="BOOLEAN";
$search[0]="f_2";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_subject"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["search_subject"];
$op_="BOOLEAN";
$search[0]="f_1";
} elseif ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"]) {
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "indexint":
$search[0]="f_2";
//Recherche de l'indexation
$indexint_id=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$requete="select indexint_name from indexint where indexint_id=".$indexint_id;
$r_indexint=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_indexint)) {
$valeur_champ=pmb_mysql_result($r_indexint,0,0);
}
break;
case "categ":
$search[0]="f_1";
//Recherche de la catégorie
$categ_id=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$requete="select libelle_categorie from categories where num_noeud=".$categ_id;
$r_cat=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_cat)) {
$valeur_champ=pmb_mysql_result($r_cat,0,0);
}
break;
}
$op_="BOOLEAN";
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
}
class searcher_publisher extends searcher {
public $p_query;
public $c_query;
public $s_query;
public $nb_p;
public $nb_c;
public $nb_s;
public $t_query;
public function show_form() {
global $search_form_editeur,$browser_editeur,$browser_url;
$search_form_editeur=str_replace("!!base_url!!",$this->base_url,$search_form_editeur);
$browser_editeur=str_replace("!!browser_url!!",$browser_url,$browser_editeur);
print $search_form_editeur.$browser_editeur;
}
public function show_error($car,$input,$error_message) {
global $browser_url;
global $browser,$search_form_editeur;
global $msg;
$search_form_editeur=str_replace("!!base_url!!",$this->base_url,$search_form_editeur);
print $search_form_editeur;
error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$car,$input,$error_message));
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
}
public function make_first_search() {
global $search_ed;
global $msg,$charset;
global $browser,$browser_url,$search_form_editeur;
$aq=new analyse_query(stripslashes($search_ed),0,0,1,1);
if (!$aq->error) {
$this->nbresults=0;
//Recherche dans les éditeurs
$rq_p_c=$aq->get_query_count("publishers","ed_name","index_publisher","ed_id");
$this->nb_p=@pmb_mysql_result(@pmb_mysql_query($rq_p_c),0,0);
if ($this->nb_p) {
$rq_p=$aq->get_query("publishers","ed_name","index_publisher","ed_id");
$this->p_query=@pmb_mysql_query($rq_p);
}
//Recherche des collections
$rq_c_c=$aq->get_query_count("collections","collection_name","index_coll","collection_id");
$this->nb_c=@pmb_mysql_result(@pmb_mysql_query($rq_c_c),0,0);
if ($this->nb_c) {
$rq_c=$aq->get_query("collections","collection_name","index_coll","collection_id");
$this->c_query=@pmb_mysql_query($rq_c);
}
//Recherche des sous collections
$rq_s_c=$aq->get_query_count("sub_collections","sub_coll_name","index_sub_coll","sub_coll_id");
$this->nb_s=@pmb_mysql_result(@pmb_mysql_query($rq_s_c),0,0);
if ($this->nb_s) {
$rq_s=$aq->get_query("sub_collections","sub_coll_name","index_sub_coll","sub_coll_id");
$this->s_query=@pmb_mysql_query($rq_s);
}
if (($this->nb_p+$this->nb_c+$this->nb_s)==0) {
$search_form_editeur=str_replace("!!base_url!!",$this->base_url,$search_form_editeur);
print $search_form_editeur;
error_message($msg["searcher_no_result"],$msg["searcher_no_result_desc"]);
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
return;
} else return AUT_LIST;
} else {
$this->show_error($aq->current_car,$aq->input_html,$aq->error_message);
}
}
public function make_aut_search() {
global $aut_type,$mag,$charset,$nb_per_page_a_search;
global $acces_j;
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
switch ($aut_type) {
case "publisher":
$requete_count = "select count(distinct notice_id) from notices ";
$requete_count.= $acces_j;
$requete_count.= "where (ed1_id='".$this->id."' or ed2_id='".$this->id."') ";
$requete = "select distinct notice_id from notices ";
$requete.= $acces_j;
$requete.= "where (ed1_id='".$this->id."' or ed2_id='".$this->id."') ";
// $requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
break;
case "collection":
$requete_count = "select count(distinct notice_id) from notices ";
$requete_count.= $acces_j;
$requete_count.= "where coll_id='".$this->id."' ";
$requete = "select distinct notice_id from notices ";
$requete.= $acces_j;
$requete.= "where coll_id='".$this->id."' ";
// $requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
break;
case "subcoll":
$requete_count = "select count(distinct notice_id) from notices ";
$requete_count.= $acces_j;
$requete_count.= "where subcoll_id='".$this->id."' ";
$requete = "select distinct notice_id from notices ";
$requete.= $acces_j;
$requete.= "where subcoll_id='".$this->id."' ";
// $requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
break;
}
$this->nbresults=@pmb_mysql_result(@pmb_mysql_query($requete_count),0,0);
$this->t_query=@pmb_mysql_query($requete);
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
$this->text_query=$requete;
}
public function store_search() {
global $search_ed;
global $show_empty;
global $charset;
$champs="".$msg["356"]." ".htmlentities(stripslashes($search_ed),ENT_QUOTES,$charset);
$this->human_aut_query=$this->human_query;
$pair_impair = "";
$parity = 0;
if ($this->nb_p) {
print "".$msg["searcher_publisher"]." : ".sprintf($msg["searcher_results"],$this->nb_p)." ";
while ($p=@pmb_mysql_fetch_object($this->p_query)) {
$pair_impair = $parity % 2 ? "even" : "odd";
$temp=new editeur($p->ed_id);
$notice_count_sql = "SELECT count(*) FROM notices WHERE ed1_id = ".$p->ed_id." OR ed2_id = ".$p->ed_id;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
print "".htmlentities($temp->display,ENT_QUOTES,$charset)." ";
if($temp->web) {
print " web."\" target=\"_web\">";
print " ";
}
print "$notice_count
\n";
}
if ($this->nb_c) {
print "".$msg["searcher_coll"]." : ".sprintf($msg["searcher_results"],$this->nb_c)." ";
while ($c=@pmb_mysql_fetch_object($this->c_query)) {
$pair_impair = $parity % 2 ? "even" : "odd";
$temp=new collection($c->collection_id);
$notice_count_sql = "SELECT count(*) FROM notices WHERE coll_id = ".$c->collection_id;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
print "".htmlentities($temp->display,ENT_QUOTES,$charset)." $notice_count
\n";
}
if ($this->nb_s) {
print "".$msg["searcher_subcoll"]." : ".sprintf($msg["searcher_results"],$this->nb_s)." ";
while ($s=@pmb_mysql_fetch_object($this->s_query)) {
$pair_impair = $parity % 2 ? "even" : "odd";
$temp=new subcollection($s->sub_coll_id);
$notice_count_sql = "SELECT count(*) FROM notices WHERE subcoll_id = ".$s->sub_coll_id;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
print "".$temp->display." $notice_count
\n";
}
}
public function notice_list_common($title) {
global $begin_result_liste;
global $end_result_liste;
global $msg;
global $charset;
global $pmb_nb_max_tri;
global $link,$link_expl,$link_explnum,$link_serial,$link_analysis,$link_bulletin,$link_explnum_serial,$link_explnum_analysis,$link_explnum_bulletin,$link_notice_bulletin;
global $pmb_allow_external_search;
global $load_tablist_js;
$research=$title;
$research .= " => ".sprintf($msg["searcher_results"],$this->nbresults);
print "$research
";
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
$current=$_SESSION["CURRENT"];
if ($current!==false) {
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
print " ";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(2);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
if($nb++>5)$recherche_ajax_mode=1;
switch($n->niveau_biblio) {
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
case 's' :
// on a affaire à un périodique
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'a' :
// on a affaire à un article
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
if(!$link_notice_bulletin){
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
} else {
$link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
$link_notice_bulletin = '';
print $display->result;
break;
}
}
// fin de liste
print $end_result_liste;
}
public function aut_notice_list() {
global $msg;
global $charset;
global $aut_type;
switch ($aut_type) {
case "publisher":
$temp = new editeur($this->id);
$display = "".$msg["searcher_publisher"]." ".htmlentities($temp->display,ENT_QUOTES,$charset);
$this->human_notice_query=$display;
break;
case "collection":
$display = "".$msg["searcher_coll"]." ";
$temp = new collection($this->id);
$display.= htmlentities($temp->display,ENT_QUOTES,$charset);
$this->human_notice_query=$display;
break;
case "subcoll":
$display = "".$msg["searcher_subcoll"]." ";
$temp = new subcollection($this->id);
$display.=$temp->display;
$this->human_notice_query=$display;
break;
}
$this->notice_list_common($display);
}
public function rec_env() {
global $msg;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$msg["356"];
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
}
break;
case 'aut_search':
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "publisher":
$search[0]="f_3";
break;
case "collection":
$search[0]="f_4";
break;
case "subcoll":
$search[0]="f_5";
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
public static function convert_simple_multi_unimarc($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="BOOLEAN";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "publisher":
$search[0]="f_3";
//Recherche de l'éditeur
$publisher_id=$valeur_champ;
$requete="select ed_name from publishers where ed_id=".$publisher_id;
$r_pub=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_pub)) {
$valeur_champ=pmb_mysql_result($r_pub,0,0);
}
break;
case "collection":
$search[0]="f_4";
//Recherche de l'indexation
$coll_id=$valeur_champ;
$requete="select collection_name from collections where collection_id=".$coll_id;
$r_coll=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_coll)) {
$valeur_champ=pmb_mysql_result($r_coll,0,0);
}
break;
case "subcoll":
$search[0]="f_5";
//Recherche de la sous-collection
$subcoll_id=$valeur_champ;
$requete="select sub_coll_name from sub_collections where sub_coll_id=".$subcoll_id;
$r_subcoll=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_subcoll)) {
$valeur_champ=pmb_mysql_result($r_subcoll,0,0);
}
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
}
class searcher_titre_uniforme extends searcher {
public $p_query;
public $c_query;
public $s_query;
public $nb_p;
public $nb_c;
public $nb_s;
public $t_query;
public function show_form() {
global $search_form_titre_uniforme,$browser_titre_uniforme,$browser_url;
$search_form_titre_uniforme=str_replace("!!base_url!!",$this->base_url,$search_form_titre_uniforme);
$browser_titre_uniforme=str_replace("!!browser_url!!",$browser_url,$browser_titre_uniforme);
print $search_form_titre_uniforme.$browser_titre_uniforme;
}
public function show_error($car,$input,$error_message) {
global $browser_url;
global $browser,$search_form_editeur;
global $msg;
$search_form_editeur=str_replace("!!base_url!!",$this->base_url,$search_form_editeur);
print $search_form_editeur;
error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$car,$input,$error_message));
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
}
public function make_first_search() {
global $search_tu;
global $msg,$charset;
global $browser,$browser_url,$search_form_titre_uniforme;
//Recherche dans les titres uniformes
$searcher_authorities_titres_uniformes = searcher_factory::get_searcher("titres_uniformes", "",stripslashes($search_tu));
// $searcher_authorities_authors = new searcher_authorities_authors(stripslashes($author_query));
$aq=new analyse_query(stripslashes($search_tu),0,0,1,1);
if (!$aq->error) {
$this->nbresults=0;
$this->nb_tu=$searcher_authorities_titres_uniformes->get_nb_results();
if ($this->nb_tu) {
$this->tu_query=pmb_mysql_query('select num_object as tu_id from authorities where id_authority in (select id_authority from ('.$searcher_authorities_titres_uniformes->get_full_query().')as uni) and type_object = 7');
return AUT_LIST;
} else {
$search_form_titre_uniforme=str_replace("!!base_url!!",$this->base_url,$search_form_titre_uniforme);
print $search_form_titre_uniforme;
error_message($msg["searcher_no_result"],$msg["searcher_no_result_desc"]);
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
return;
}
} else {
$this->show_error($aq->current_car,$aq->input_html,$aq->error_message);
}
}
public function make_aut_search() {
global $aut_type,$mag,$charset,$nb_per_page_a_search;
global $acces_j;
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
switch ($aut_type) {
case "titre_uniforme":
$requete_count = "select count(distinct ntu_num_notice) from notices_titres_uniformes, notices ";
$requete_count.= $acces_j;
$requete_count.= "where ntu_num_notice=notice_id and ntu_num_tu='".$this->id."' ";
$requete = "select distinct notice_id from notices_titres_uniformes, notices ";
$requete.= $acces_j;
$requete.= "where ntu_num_notice=notice_id and ntu_num_tu='".$this->id."' ";
$requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
break;
}
$this->nbresults=@pmb_mysql_result(@pmb_mysql_query($requete_count),0,0);
$this->t_query=@pmb_mysql_query($requete);
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
$this->text_query=$requete;
}
public function store_search() {
global $search_ed;
global $show_empty;
global $charset;
$champs="".$msg["356"]." ".htmlentities(stripslashes($search_tu),ENT_QUOTES,$charset);
$this->human_aut_query=$this->human_query;
$pair_impair = "";
$parity = 0;
if ($this->nb_tu) {
print "".$msg["search_by_titre_uniforme"]." : ".sprintf($msg["searcher_results"],$this->nb_tu)." ";
while (($p=@pmb_mysql_fetch_object($this->tu_query))) {
$pair_impair = $parity % 2 ? "even" : "odd";
$temp=new titre_uniforme($p->tu_id);
$notice_count_sql = "SELECT count(*) FROM notices_titres_uniformes WHERE ntu_num_tu = ".$p->tu_id ;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
print "".htmlentities($temp->get_isbd(),ENT_QUOTES,$charset)." ";
print "$notice_count
\n";
}
}
public function notice_list_common($title) {
global $begin_result_liste;
global $end_result_liste;
global $msg;
global $charset;
global $pmb_nb_max_tri;
global $link,$link_expl,$link_explnum,$link_serial,$link_analysis,$link_bulletin,$link_explnum_serial,$link_explnum_analysis,$link_explnum_bulletin;
global $pmb_allow_external_search;
global $load_tablist_js;
$research=$title;
$research .= " => ".sprintf($msg["searcher_results"],$this->nbresults);
print "$research
";
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
$current=$_SESSION["CURRENT"];
if ($current!==false) {
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
print " ";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(9);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
if($nb++>5)$recherche_ajax_mode=1;
switch($n->niveau_biblio) {
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
case 's' :
// on a affaire à un périodique
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'a' :
// on a affaire à un article
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
print $display->result;
break;
}
}
// fin de liste
print $end_result_liste;
}
public function aut_notice_list() {
global $msg;
global $charset;
global $aut_type;
switch ($aut_type) {
case "titre_uniforme":
$temp = new titre_uniforme($this->id);
$display = "".$msg["search_by_titre_uniforme"]." ".htmlentities($temp->name,ENT_QUOTES,$charset);
$this->human_notice_query=$display;
break;
}
$this->notice_list_common($display);
}
public function rec_env() {
global $msg;
global $memo_tempo_table_to_rebuild;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$msg["356"];
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
}
break;
case 'aut_search':
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "titre_uniforme":
$search[0]="f_3";//!!!!!!!!! a modifier
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
public static function convert_simple_multi_unimarc($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="BOOLEAN";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "titre_uniforme":
$search[0]="f_3";
//Recherche de l'éditeur
$tu_id=$valeur_champ;
$requete="select tu_name from titres_uniformes where tu_id=".$tu_id;
$r_pub=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_pub)) {
$valeur_champ=pmb_mysql_result($r_pub,0,0);
}
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
}
class searcher_serie extends searcher {
public $p_query;
public $c_query;
public $s_query;
public $nb_p;
public $nb_c;
public $nb_s;
public $t_query;
public function show_form() {}
public function show_error($car,$input,$error_message) {}
public function make_first_search() {}
public function make_aut_search() {
global $aut_type,$mag,$charset,$nb_per_page_a_search;
global $acces_j;
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
switch($aut_type){
case 'tit_serie':
$requete_count = "select count(distinct notice_id) from notices ";
$requete_count.= $acces_j;
$requete_count.= "where index_serie in (select serie_index from series where serie_id='".$this->id."' ) ";
$requete = "select distinct notice_id from notices ";
$requete.= $acces_j;
$requete.= "where index_serie in (select serie_index from series where serie_id='".$this->id."' ) ";
// $requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
}
$this->nbresults=@pmb_mysql_result(@pmb_mysql_query($requete_count),0,0);
$this->t_query=@pmb_mysql_query($requete);
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
$this->text_query=$requete;
}
public function store_search() {
global $search_ed;
global $show_empty;
global $charset;
$champs="$research
";
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
$current=$_SESSION["CURRENT"];
if ($current!==false) {
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
print " ";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(3);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
if($nb++>5)$recherche_ajax_mode=1;
switch($n->niveau_biblio) {
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
case 's' :
// on a affaire à un périodique
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'a' :
// on a affaire à un article
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
if(!$link_notice_bulletin){
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
} else {
$link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
$link_notice_bulletin='';
print $display->result;
break;
}
}
// fin de liste
print $end_result_liste;
}
public function aut_notice_list() {
$this->notice_list_common($display);
}
public function rec_env() {
global $msg;
global $memo_tempo_table_to_rebuild;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$msg["356"];
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
}
break;
case 'aut_search':
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {}
public static function convert_simple_multi_unimarc($id_champ) {}
}
class searcher_authperso extends searcher {
public $p_query;
public $c_query;
public $s_query;
public $nb_p;
public $nb_c;
public $nb_s;
public $t_query;
public function show_form() {
global $search_form_authperso,$browser_authperso,$browser_url;
global $msg;
global $info_authpersos,$id_authperso;
$authperso_seach_title=str_replace("!!name!!",$info_authpersos[$id_authperso]['name'],$msg["search_by_authperso"]);
$search_form_authperso=str_replace("!!authperso_search_title!!",$authperso_seach_title,$search_form_authperso);
$search_form_authperso=str_replace("!!base_url!!",$this->base_url,$search_form_authperso);
$browser_authperso=str_replace("!!browser_url!!",$browser_url,$browser_authperso);
print $search_form_authperso.$browser_authperso;
}
public function show_error($car,$input,$error_message) {
global $browser_url;
global $browser,$search_form_editeur;
global $msg;
$search_form_editeur=str_replace("!!base_url!!",$this->base_url,$search_form_editeur);
print $search_form_editeur;
error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$car,$input,$error_message));
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
}
public function make_first_search() {
global $search_authperso;
global $msg,$charset;
global $browser,$browser_url,$search_form_authperso;
global $info_authpersos,$id_authperso;
global $mode;
$aq=new analyse_query(stripslashes($search_authperso),0,0,1,1);
if (!$aq->error) {
$this->nbresults=0;
//Recherche dans les authperso
$members=$aq->get_query_members("authperso_authorities","authperso_infos_global","authperso_index_infos_global","id_authperso_authority");
$clause= "where ".$members["where"] ." and authperso_authority_authperso_num=".($mode-1000);
$rq_authperso_count="select count(1) FROM authperso_authorities $clause ";
$this->nb_authperso=@pmb_mysql_result(@pmb_mysql_query($rq_authperso_count),0,0);
if ($this->nb_authperso) {
$rq_authperso="select id_authperso_authority FROM authperso_authorities $clause ";
$this->authperso_query=@pmb_mysql_query($rq_authperso);
return AUT_LIST;
}else {
$authperso_seach_title=str_replace("!!name!!",$info_authpersos[$id_authperso]['name'],$msg["search_by_authperso"]);
$search_form_authperso=str_replace("!!authperso_search_title!!",$authperso_seach_title,$search_form_authperso);
$search_form_authperso=str_replace("!!base_url!!",$this->base_url,$search_form_authperso);
print $search_form_authperso;
error_message($msg["searcher_no_result"],$msg["searcher_no_result_desc"]);
$browser=str_replace("!!browser_url!!",$browser_url,$browser);
print $browser;
return;
}
} else {
$this->show_error($aq->current_car,$aq->input_html,$aq->error_message);
}
}
public function make_aut_search() {
global $aut_type,$mag,$charset,$nb_per_page_a_search;
global $acces_j;
global $mode,$aut_id;
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
switch ($aut_type) {
case "authperso":
$requete_count = "select count(distinct notice_authperso_notice_num) from notices_authperso, notices ";
$requete_count.= $acces_j;
$requete_count.= "where notice_authperso_notice_num=notice_id and notice_authperso_authority_num='".$aut_id."' ";
$requete = "select distinct notice_id from notices_authperso, notices ";
$requete.= $acces_j;
$requete.= "where notice_authperso_notice_num=notice_id and notice_authperso_authority_num='".$aut_id."' ";
// $requete.= "order by index_serie,tnvol,index_sew limit ".($this->page*$this->nb_per_page).",".$this->nb_per_page;
break;
}
$this->nbresults=@pmb_mysql_result(@pmb_mysql_query($requete_count),0,0);
$this->t_query=@pmb_mysql_query($requete);
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
$this->text_query=$requete;
}
public function store_search() {
global $search_ed;
global $show_empty;
global $charset;
$champs="".$info['name']." ".htmlentities(stripslashes($search_authperso),ENT_QUOTES,$charset);
$this->human_aut_query=$this->human_query;
$pair_impair = "";
$parity = 0;
if ($this->nb_authperso) {
$authperso_seach_title=str_replace("!!name!!",$info['name'],$msg["search_by_authperso"]);
print "".$authperso_seach_title." : ".sprintf($msg["searcher_results"],$this->nb_authperso)." ";
while (($p=@pmb_mysql_fetch_object($this->authperso_query))) {
$pair_impair = $parity % 2 ? "even" : "odd";
$notice_count_sql = "SELECT count(*) FROM notices_authperso WHERE notice_authperso_authority_num = ".$p->id_authperso_authority ;
$notice_count = pmb_mysql_result(pmb_mysql_query($notice_count_sql), 0, 0);
$isbd = authperso::get_isbd($p->id_authperso_authority);
print "".htmlentities($isbd,ENT_QUOTES,$charset)." ";
print "$notice_count
\n";
}
}
public function notice_list_common($title) {
global $begin_result_liste;
global $end_result_liste;
global $msg;
global $charset;
global $pmb_nb_max_tri;
global $link,$link_expl,$link_explnum,$link_serial,$link_analysis,$link_bulletin,$link_explnum_serial,$link_explnum_analysis,$link_explnum_bulletin;
global $pmb_allow_external_search;
global $load_tablist_js,$mode;
$research=$title;
$research .= " => ".sprintf($msg["searcher_results"],$this->nbresults);
print "$research
";
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
$current=$_SESSION["CURRENT"];
if ($current!==false) {
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
print " ";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(1000);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
if($nb++>5)$recherche_ajax_mode=1;
switch($n->niveau_biblio) {
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
case 's' :
// on a affaire à un périodique
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'a' :
// on a affaire à un article
// function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) {
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1,$recherche_ajax_mode );
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
print $display->result;
break;
}
}
// fin de liste
print $end_result_liste;
}
public function aut_notice_list() {
global $msg;
global $charset;
global $aut_type,$mode,$aut_id;
switch ($aut_type) {
case "authperso":
$authperso=new authperso($mode-1000);
$info=$authperso->get_data();
$isbd = authperso::get_isbd($aut_id);
$display = "".$info['name']." ".htmlentities($isbd,ENT_QUOTES,$charset);
$this->human_notice_query=$display;
break;
}
$this->notice_list_common($display);
}
public function rec_env() {
global $msg;
global $info_authpersos,$id_authperso;
global $memo_tempo_table_to_rebuild;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$info_authpersos[$id_authperso]['name'];
}
if ((string)$this->page=="") {
$_POST["page"]=0; $page=0;
}
if (($this->first_search_result==AUT_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]["HUMAN_QUERY"]=$this->human_aut_query;
}
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
}
break;
case 'aut_search':
if (($_SESSION["CURRENT"]!==false) && (is_int($_SESSION["CURRENT"]))) {
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['HUMAN_QUERY']=$this->human_notice_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "authperso":
$search[0]="f_3";//!!!!!!!!! a modifier
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
public static function convert_simple_multi_unimarc($id_champ) {
global $search;
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="BOOLEAN";
switch ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_type"]) {
case "authperso":
$search[0]="f_3";
//Recherche de l'éditeur
$tu_id=$valeur_champ;
$requete="select tu_name from titres_uniformes where tu_id=".$tu_id;
$r_pub=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($r_pub)) {
$valeur_champ=pmb_mysql_result($r_pub,0,0);
}
break;
}
//opérateur
$op="op_0_".$search[0];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_0_".$search[0];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_0_".$search[0];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_0_".$search[0];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
}
class searcher_map extends searcher {
public $t_query;
public function show_form() {
global $msg;
global $dbh;
global $charset,$lang;
global $search_form_map;
global $all_query,$typdoc_query, $statut_query, $docnum_query, $pmb_indexation_docnum_allfields, $pmb_indexation_docnum;
global $categ_query,$thesaurus_auto_postage_search,$auto_postage_query;
global $thesaurus_concepts_active,$concept_query, $thesaurus_concepts_autopostage, $concepts_autopostage_query;
global $map_echelle_query,$map_projection_query,$map_ref_query,$map_equinoxe_query;
global $pmb_map_size_search_edition;
global $pmb_map_base_layer_type;
global $pmb_map_base_layer_params;
global $map_emprises_query, $pmb_map_bounding_box;
if(!isset($typdoc))$typdoc='';
// on commence par créer le champ de sélection de document
// récupération des types de documents utilisés.
$query = "SELECT count(typdoc), typdoc ";
$query .= "FROM notices where typdoc!='' GROUP BY typdoc";
$result = @pmb_mysql_query($query, $dbh);
$toprint_typdocfield = " $msg[tous_types_docs] \n";
$doctype = new marc_list('doctype');
while (($rt = pmb_mysql_fetch_row($result))) {
$obj[$rt[1]]=1;
$qte[$rt[1]]=$rt[0];
}
foreach ($doctype->table as $key=>$libelle){
if (isset($obj[$key]) && ($obj[$key]==1)){
$toprint_typdocfield .= " \n";
}
}
// récupération des statuts de documents utilisés.
$query = "SELECT count(statut), id_notice_statut, gestion_libelle ";
$query .= "FROM notices, notice_statut where id_notice_statut=statut GROUP BY id_notice_statut order by gestion_libelle";
$result = pmb_mysql_query($query, $dbh);
$toprint_statutfield = " $msg[tous_statuts_notice] \n";
while ($obj = @pmb_mysql_fetch_row($result)) {
$toprint_statutfield .= " \n";
}
$search_form_map = str_replace("!!typdocfield!!", $toprint_typdocfield, $search_form_map);
$search_form_map = str_replace("!!statutfield!!", $toprint_statutfield, $search_form_map);
$search_form_map = str_replace("!!all_query!!", htmlentities(stripslashes($all_query),ENT_QUOTES, $charset), $search_form_map);
$search_form_map = str_replace("!!categ_query!!", htmlentities(stripslashes($categ_query),ENT_QUOTES, $charset), $search_form_map);
if($thesaurus_concepts_active){
$search_form_map = str_replace("!!concept_query!!", htmlentities(stripslashes($concept_query),ENT_QUOTES, $charset), $search_form_map);
}
// map
$layer_params = json_decode($pmb_map_base_layer_params,true);
$baselayer = "baseLayerType: dojox.geo.openlayers.BaseLayerType.".$pmb_map_base_layer_type;
if(count($layer_params)){
if($layer_params['name']) $baselayer.=",baseLayerName:\"".$layer_params['name']."\"";
if($layer_params['url']) $baselayer.=",baseLayerUrl:\"".$layer_params['url']."\"";
if($layer_params['options']) $baselayer.=",baseLayerOptions:".json_encode($layer_params['options']);
}
$size=explode("*",$pmb_map_size_search_edition);
if(count($size)!=2)$map_size="width:800px; height:480px;";
$map_size= "width:".$size[0]."px; height:".$size[1]."px;";
$initialFit = '';
if(!$map_emprises_query){
$map_emprises_query = array();
if( $pmb_map_bounding_box) {
$map_bounding_box = $pmb_map_bounding_box;
} else {
$map_bounding_box = '-5 50,9 50,9 40,-5 40,-5 50';
}
$map_hold = new map_hold_polygon("bounding", 0, "polygon((".$map_bounding_box."))");
if ($map_hold) {
$coords = $map_hold->get_coords();
$initialFit = explode(',', map_objects_controler::get_coord_initialFit($coords));
} else{
$initialFit = array(0, 0, 0, 0);
}
}
$map_holds=array();
foreach($map_emprises_query as $map_hold){
$map_holds[] = array(
"wkt" => $map_hold,
"type"=> "search",
"color"=> null,
"objects"=> array()
);
}
$r="
";
$search_form_map = str_replace("!!map!!", $r, $search_form_map);
//champs maps
$requete = "SELECT map_echelle_id, map_echelle_name FROM map_echelles ORDER BY map_echelle_name ";
$projections=gen_liste($requete,"map_echelle_id","map_echelle_name","map_echelle_query","",$map_echelle_query,0,"",0,$msg['map_echelle_vide']);
$search_form_map=str_replace("!!map_echelle_list!!",$projections,$search_form_map);
$requete = "SELECT map_projection_id, map_projection_name FROM map_projections ORDER BY map_projection_name ";
$projections=gen_liste($requete,"map_projection_id","map_projection_name","map_projection_query","",$map_projection_query,0,"",0,$msg['map_projection_vide']);
$search_form_map=str_replace("!!map_projection_list!!",$projections,$search_form_map);
$requete = "SELECT map_ref_id, map_ref_name FROM map_refs ORDER BY map_ref_name ";
$refs=gen_liste($requete,"map_ref_id","map_ref_name","map_ref_query","",$map_ref_query,0,"",0,$msg['map_ref_vide']);
$search_form_map=str_replace("!!map_ref_list!!",$refs,$search_form_map);
$search_form_map=str_replace("!!map_equinoxe_value!!",$map_equinoxe_query,$search_form_map);
$checkbox="";
if($thesaurus_auto_postage_search){
$checkbox = "
";
$checkbox = str_replace("!!auto_postage_checked!!", (($auto_postage_query) ? 'checked' : ''), $checkbox);
}
$search_form_map = str_replace("!!auto_postage!!", $checkbox, $search_form_map);
$checkbox_concepts_autopostage = "";
if($thesaurus_concepts_autopostage){
$checkbox_concepts_autopostage = "
";
$checkbox_concepts_autopostage = str_replace("!!concepts_autopostage_checked!!", (($concepts_autopostage_query) ? 'checked' : ''), $checkbox_concepts_autopostage);
}
$search_form_map = str_replace("!!concepts_autopostage!!", $checkbox_concepts_autopostage, $search_form_map);
if($pmb_indexation_docnum){
$checkbox = "";
$checkbox = str_replace("!!docnum_query_checked!!", (($pmb_indexation_docnum_allfields || $docnum_query) ? 'checked' : ''), $checkbox);
$search_form_map = str_replace("!!docnum_query!!", $checkbox, $search_form_map);
} else $search_form_map = str_replace("!!docnum_query!!", '' , $search_form_map);
$search_form_map = str_replace("!!base_url!!", $this->base_url,$search_form_map);
print pmb_bidi($search_form_map);
}
public function make_first_search() {
global $msg,$charset,$lang,$dbh;
global $all_query,$typdoc_query, $statut_query, $etat, $docnum_query;
global $categ_query,$thesaurus_auto_postage_search, $auto_postage_query;
global $nb_per_page_a_search;
global $class_path;
global $pmb_default_operator;
global $acces_j;
global $thesaurus_concepts_active,$concept_query;
global $map_echelle_query,$map_projection_query,$map_ref_query,$map_equinoxe_query,$map_emprises_query;
global $dbh;
if ($nb_per_page_a_search) $this->nb_per_page=$nb_per_page_a_search; else $this->nb_per_page=3;
$restrict='';
//Ou les notices qui ont une catégories qui a une emprise
$restriction_emprise = "and (notices.notice_id IN (select distinct map_emprise_obj_num FROM map_emprises where map_emprise_type=11) or (notices.notice_id IN (select distinct notcateg_notice from notices_categories join map_emprises on map_emprises.map_emprise_obj_num = notices_categories.num_noeud where map_emprises.map_emprise_type=2)))";
//$restrict.= "and notice_id IN (select distinct map_emprise_obj_num FROM map_emprises)";
$no_results = false;
if(!$concept_query && !$categ_query && !$map_equinoxe_query && !$map_ref_query && !$map_projection_query && !$map_emprises_query && !$all_query && !$map_echelle_query) $all_query="*";
//tous les champs
if($all_query){
//TODO Searcher all_fields, pas le temps de le faire là...
// Recherche sur tous les champs (index global) uniquement :
$aq=new analyse_query(stripslashes($all_query),0,0,1,1);
$aq2=new analyse_query(stripslashes($all_query));
if (!$aq->error) {
$aq1=new analyse_query(stripslashes($all_query),0,0,1,1);
$members1=$aq1->get_query_members("notices","index_wew","index_sew","notice_id",$restrict);
global $pmb_title_ponderation;
$pert1="+".$members1["select"]."*".$pmb_title_ponderation;
$members=$aq->get_query_members("notices_global_index","infos_global","index_infos_global","num_notice");
$members2=$aq2->get_query_members("notices_global_index","infos_global","index_infos_global","num_notice");
if (($members2["where"]!="()")&&($pmb_default_operator)) {
$where_term="(".$members["where"]." or ".$members2["where"].")";
} else {
$where_term=$members["where"];
}
if($docnum_query && $all_query!='*'){
//Si on a activé la recherche dans les docs num
//On traite les notices
$members_num_noti = $aq2->get_query_members("explnum","explnum_index_wew","explnum_index_sew","explnum_notice","",0,0,true);
$members_num_bull = $aq2->get_query_members("explnum","explnum_index_wew","explnum_index_sew","explnum_bulletin","",0,0,true);
$join = "(
select tc.notice_id, sum(tc.pert) as pert, tc.typdoc from (
(
select notice_id, ".$members["select"]."+".$members1["select"]." as pert,typdoc
from notices join notices_global_index on num_notice=notice_id $acces_j
where ".$members["where"]." $restrict
)
union
(
select notice_id, ".$members_num_noti["select"]." as pert,typdoc
from notices join explnum on explnum_notice=notice_id $acces_j
where ".$members_num_noti["where"]." $restrict
)
union
(
select if(num_notice,num_notice,bulletin_notice) as notice_id, ".$members_num_bull["select"]." as pert,typdoc
from explnum join bulletins on explnum_bulletin=bulletin_id ,notices $acces_j
where bulletin_notice=notice_id and ".$members_num_bull["where"]." $restrict
)
)as tc group by notice_id
)";
$requete_count = "select count(distinct notice_id) from ($join) as union_table";
$requete="select uni.notice_id, sum(pert) as pert from ($join) as uni join notices n on n.notice_id=uni.notice_id group by uni.notice_id order by pert desc, index_serie, tnvol, index_sew ";
} elseif($all_query=="*") {
$restrict.= " and num_notice = notice_id ";
$requete_count = "select count(1) from notices ";
$requete_count.= $acces_j;
$requete_count.= ", notices_global_index ";
$requete_count.= "where ".$where_term." ";
$requete_count.= $restrict;
$requete = "select notice_id,100 as pert from notices ";
$requete.= $acces_j;
$requete.= ", notices_global_index ";
$requete.= "where $where_term ";
$requete.= $restrict." order by index_serie, tnvol, index_sew ";
} else {
$restrict.= " and num_notice = notice_id ";
$requete_count = "select count(1) from notices ";
$requete_count.= $acces_j;
$requete_count.= ", notices_global_index ";
$requete_count.= "where ".$where_term." ";
$requete_count.= $restrict;
$requete = "select notice_id,".$members["select"]."$pert1 as pert from notices ";
$requete.= $acces_j;
$requete.= ", notices_global_index ";
$requete.= "where $where_term ";
$requete.= $restrict." order by pert desc, index_serie, tnvol, index_sew ";
}
$queries[]=$requete;
}
}
//pour la suite, avant de déclencher les recherches, on vérifie si la recherche est différente de celle tous les champs (on s'économise quelques requetes qui ne serviront à rien)
//les concepts
if($thesaurus_concepts_active && $concept_query && $concept_query != $all_query){
$concept_searcher = searcher_factory::get_searcher("records", "concepts",stripslashes($concept_query));
// $concept_searcher = new searcher_records_concepts(stripslashes($concept_query));
if($concept_searcher->get_nb_results()){
$queries[]=$concept_searcher->get_full_query()." ";
}else{
$no_results =true;
}
}
//catégorie
if($categ_query && $categ_query != $all_query){
$categ_searcher = searcher_factory::get_searcher("records", "categories",stripslashes($categ_query));
// $categ_searcher = new searcher_records_categories(stripslashes($categ_query));
if($categ_searcher->get_nb_results()){
$queries[]=$categ_searcher->get_full_query()." ";
}else{
$no_results = true;
}
}
//echelle
if($map_echelle_query){
//$queries[] = "select notice_id from notices where map_echelle_num=".$map_echelle_query." ";
$queries[]= " select notice_id, 100 as pert from notices where map_echelle_num='".$map_echelle_query."' ";
}
//projection
if($map_projection_query){
$queries[]= " select notice_id, 100 as pert from notices where map_projection_num='".$map_projection_query."' ";
}
//ref
if($map_ref_query){
$queries[]= " select notice_id, 100 as pert from notices where map_ref_num='".$map_ref_query."' ";
}
//équinoxe
if($map_equinoxe_query){
$queries[]= " select notice_id, 100 as pert from notices where map_equinoxe='".$map_equinoxe_query."' ";
}
//map
if($map_emprises_query){
/*
$map_map_emprises_searcher = new searcher_records_map_emprises($map_emprises_query);
if($map_emprises_searcher->get_nb_results()){
$queries[]=$map_map_emprises_searcher->get_full_query()." ";
}
*/
foreach($map_emprises_query as $map_emprise_query){
//récupération des emprise de notices correspondantes
$query_notice="select map_emprise_obj_num as notice_id, 100 as pert from map_emprises where map_emprise_type=11 and contains(geomfromtext('$map_emprise_query'),map_emprise_data) = 1 ";
//récupération des emprise d'autorité correspondantes
$query_categories = "select notcateg_notice as notice_id, 100 as pert from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and contains(geomfromtext('$map_emprise_query'),map_emprise_data) = 1";
//récupérations des notices indexés avec une categorie
//$query = "select notcateg_notice as notice_id, 100 as pert from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and contains(geomfromtext('$map_emprise_query'),map_emprise_data) = 1 union select map_emprise_obj_num as notice_id, 100 as pert from map_emprises where map_emprise_type=11 and contains(geomfromtext('$map_emprise_query'),map_emprise_data) = 1";
$queries[] = "select * from (".$query_notice." union ".$query_categories.") as uni";//TODO-> faire le mapage et mettre le tout dans $queries...
}
}
//on fait un et donc si un élément ne renvoi rien ,on s'embete pas avec les jointures...
if($no_results || !count($queries)){
$this->nbresults = 0;
if($typdoc_query || $statut_query){
if($typdoc_query && $statut_query){
$restrict = "notices.typdoc=".$typdoc_query." and notices.statut=".$statut_query." ";
}elseif ($typdoc_query){
$restrict = "notices.typdoc=".$typdoc_query;
}elseif ($statut_query){
$restrict = "notices.statut=".$statut_query;
}
}else{
$restrict = "notice_id = 0";
}
$this->text_query = "select notice_id from notices where ".$restrict;
}else{
//TODO le tri sur la pertinance desc, titre devrait être automatique...
$from = "";
$select_pert = "";
for($i=0 ; $itext_query = "select t0.notice_id, (".$select_pert.") as pert from ".$from." join notices on t0.notice_id = notices.notice_id ".$restriction_emprise.$restrict." group by t0.notice_id order by pert desc, notices.index_sew ";
$result = pmb_mysql_query($this->text_query,$dbh);
$this->nbresults = pmb_mysql_num_rows($result);
}
$this->nbepage=ceil($this->nbresults/$this->nb_per_page);
return NOTICE_LIST;
}
public function store_search() {
global $all_query,$typdoc_query, $statut_query,$categ_query,$docnum_query,$pmb_indexation_docnum;
global $thesaurus_concepts_active,$concept_query, $thesaurus_concepts_autopostage, $concepts_autopostage_query;
global $map_echelle_query,$map_projection_query,$map_ref_query,$map_equinoxe_query,$map_emprises_query;
global $charset;
$champs="$research
");
print $begin_result_liste;
$load_tablist_js=1;
//Affichage des liens paniers et impression
if ($this->rec_history) {
if (($this->etat=='first_search')&&((string)$this->page=="")) {
$current=count($_SESSION["session_history"]);
} else {
$current=$_SESSION["CURRENT"];
}
if ($current!==false) {
echo " ";
echo " ";
$tri_id_info = $_SESSION["tri"] ? "&sort_id=".$_SESSION["tri"] : "";
echo "";
echo " ";
echo "";
echo " ";
if ($pmb_allow_external_search) {
echo " ";
echo " ";
}
// on affiche l'icone de tri seulement si on a atteint un nb maxi de résultats
if ($this->nbresults<=$pmb_nb_max_tri) {
//affichage de l'icone de tri
echo "";
echo " ";
//si on a un tri actif on affiche sa description
if ($_SESSION["tri"]) {
echo $msg['tri_par']." ".$this->sort->descriptionTriParId($_SESSION["tri"]);
}
}
}
}
print $this->get_current_search_map(11);
// on lance la requête
$recherche_ajax_mode=0;
$nb=0;
while(($nz=@pmb_mysql_fetch_object($this->t_query))) {
if($nb++>5) $recherche_ajax_mode=1;
$n=@pmb_mysql_fetch_object(@pmb_mysql_query("SELECT * FROM notices WHERE notice_id=".$nz->notice_id));
switch ($n->niveau_biblio) {
case 's' :
// on a affaire à un périodique
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1 ,$recherche_ajax_mode);
print $serial->result;
break;
case 'a' :
// on a affaire à un article
$serial = new serial_display($n, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_analysis, 0, 0, 1, 1, true, 1 ,$recherche_ajax_mode);
print $serial->result;
break;
case 'b' :
// on a affaire à un bulletin
$rqt_bull_info = "SELECT s.notice_id as id_notice_mere, bulletin_id as id_du_bulletin, b.notice_id as id_notice_bulletin FROM notices as s, notices as b, bulletins WHERE b.notice_id=$n->notice_id and s.notice_id=bulletin_notice and num_notice=b.notice_id";
$bull_ids=@pmb_mysql_fetch_object(pmb_mysql_query($rqt_bull_info));
//si on a les droits
if(SESSrights & CATALOGAGE_AUTH){
//on teste la validité du lien
if(!$link_notice_bulletin){
$link_notice_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id='.$bull_ids->id_du_bulletin;
} else {
$link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
}
}
elseif($link_notice_bulletin) $link_notice_bulletin = str_replace("!!id!!",$bull_ids->id_du_bulletin,$link_notice_bulletin);
$link_explnum_bulletin = str_replace("!!bul_id!!",$bull_ids->id_du_bulletin,$link_explnum_bulletin);
$display = new mono_display($n, 6, $link_notice_bulletin, 1, $link_expl, '', $link_explnum_bulletin,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode);
$link_notice_bulletin='';
print $display->result;
break;
default:
case 'm' :
// notice de monographie
$display = new mono_display($n, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1, "", 1 , false,true,$recherche_ajax_mode,1);
print $display->result;
break ;
}
}
// fin de liste
print $end_result_liste;
} else {
$this->show_form();
$cles="".$title." ";
if ($pmb_allow_external_search) $external="".$msg["connecteurs_external_search_sources"]." ";
error_message($msg[357], sprintf($msg["connecteurs_no_title"],$cles,$external), 0, "./catalog.php?categ=search&mode=0");
}
}
public function notice_list() {
global $msg,$dbh;
global $charset;
global $all_query,$categ_query;
global $thesaurus_concepts_active,$concept_query;
global $map_echelle_query,$map_projection_query,$map_ref_query,$map_equinoxe_query,$map_emprises_query;
$research = '';
if($this->docnum){
$libelle = " [".$msg['docnum_search_with']."]";
} else $libelle ='';
if ($all_query) {
$research.="".$msg['global_search'].$libelle." ".htmlentities(stripslashes($all_query),ENT_QUOTES,$charset);
}
if ($categ_query) {
if ($research != "") $research .= ", ";
$research .= "${msg["search_categorie_title"]} ".htmlentities(stripslashes($categ_query),ENT_QUOTES,$charset);
}
if ($thesaurus_concepts_active && $concept_query) {
if ($research != "") $research .= ", ";
$research.="${msg['search_concept_title']} ".htmlentities(stripslashes($concept_query),ENT_QUOTES,$charset);
}
if ($map_echelle_query) {
$requete = "select map_echelle_name from map_echelles where map_echelle_id=".$map_echelle_query;
$result = pmb_mysql_query($requete, $dbh);
if ($result) {
if ($research != "") $research .= ", ";
$research .= "${msg["map_echelle"]} ".htmlentities(pmb_mysql_result($result,0,"map_echelle_name"),ENT_QUOTES,$charset);
}
}
if ($map_projection_query) {
$requete = "select map_projection_name from map_projections where map_projection_id=".$map_projection_query;
$result = pmb_mysql_query($requete, $dbh);
if ($result) {
if ($research != "") $research .= ", ";
$research .= "${msg["map_projection"]} ".htmlentities(pmb_mysql_result($result,0,"map_projection_name"),ENT_QUOTES,$charset);
}
}
if ($map_ref_query) {
$requete = "select map_ref_name from map_refs where map_ref_id=".$map_ref_query;
$result = pmb_mysql_query($requete, $dbh);
if ($result) {
if ($research != "") $research .= ", ";
$research .= "${msg["map_ref"]} ".htmlentities(pmb_mysql_result($result,0,"map_ref_name"),ENT_QUOTES,$charset);
}
}
if ($map_equinoxe_query) {
if ($research != "") $research .= ", ";
$research .= "${msg["map_equinoxe"]} ".htmlentities(stripslashes($map_equinoxe_query),ENT_QUOTES,$charset);
}
if ($map_emprises_query) {
foreach($map_emprises_query as $map_emprise_query){
if ($research != "") $research .= ", ";
$research .= "${msg["map_emprises_query"]} ".htmlentities(stripslashes($map_emprise_query),ENT_QUOTES,$charset);
}
}
$this->human_title=$msg["search_map"];
$this->human_query=$research;
$this->human_notice_query=$research;
$this->notice_list_common($research);
}
public function rec_env() {
global $msg;
global $memo_tempo_table_to_rebuild;
switch ($this->etat) {
case 'first_search':
if ((string)$this->page=="") {
$_SESSION["CURRENT"]=count($_SESSION["session_history"]);
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["URI"]=$this->base_url;
$_POST["etat"]="";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["AUT"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]=array();
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_QUERY"]=$this->human_query;
if(!$this->human_title)$this->human_title=$msg["354"];
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["HUMAN_TITLE"]=$this->human_title;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["QUERY"]["DOCNUM_QUERY"]=$this->docnum;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["AUTO_POSTAGE_QUERY"]=$this->auto_postage_query;
}
if ((string)$this->page=="") { $_POST["page"]=0; $page=0; }
if (($this->first_search_result==NOTICE_LIST)&&($_SESSION["CURRENT"]!==false)) {
$_POST["etat"]="first_search";
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['URI']=$this->base_url;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['POST']=$_POST;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['GET']=$_GET;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_LIST_QUERY']=$memo_tempo_table_to_rebuild;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['TEXT_QUERY']=$this->text_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]['PAGE']=$this->page+1;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["HUMAN_QUERY"]=$this->human_notice_query;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["DOCNUM_QUERY"]=$this->docnum;
$_SESSION["session_history"][$_SESSION["CURRENT"]]["NOTI"]["AUTO_POSTAGE_QUERY"]=$this->auto_postage_query;
}
break;
}
$_SESSION["last_required"]=false;
}
public static function convert_simple_multi($id_champ) {
global $search;
$x=0;
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"]) {
$op_="BOOLEAN";
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["title_query"];
$search[$x]="f_6";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["all_query"];
$op_="BOOLEAN";
$search[$x]="f_7";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
${$inter}="";
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
$t["is_num"][0]=$_SESSION["session_history"][$id_champ]["NOTI"]["DOCNUM_QUERY"];
$t["ck_affiche"][0]=$_SESSION["session_history"][$id_champ]["NOTI"]["DOCNUM_QUERY"];
${$fieldvar_}=$t;
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["author_query"];
$op_="BOOLEAN";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
} else {
if ($_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["GET"]["aut_id"];
$op_="EQ";
$search[$x]="f_8";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["typdoc_query"];
$op_="EQ";
$search[$x]="f_9";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
$x++;
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["statut_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["statut_query"];
$op_="EQ";
$search[$x]="f_10";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_[0]=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
//variables auxiliaires
$fieldvar_="fieldvar_".$x."_".$search[$x];
global ${$fieldvar_};
${$fieldvar_}="";
$fieldvar=${$fieldvar_};
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_emprises_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_emprises_query"];
$op_="CONTAINS";
$search[$x]="f_78";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_echelle_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_echelle_query"];
$op_="EQ";
$search[$x]="f_74";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_projection_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_projection_query"];
$op_="EQ";
$search[$x]="f_75";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_ref_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_ref_query"];
$op_="EQ";
$search[$x]="f_76";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_equinoxe_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["map_equinoxe_query"];
$op_="BOOLEAN";
$search[$x]="f_77";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["categ_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["categ_query"];
$op_="EQ";
$search[$x]="f_1";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
if ($_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["concept_query"]) {
$valeur_champ=$_SESSION["session_history"][$id_champ]["NOTI"]["POST"]["concept_query"];
$op_="BOOLEAN";
$search[$x]="f_1000";
//opérateur
$op="op_".$x."_".$search[$x];
global ${$op};
${$op}=$op_;
//contenu de la recherche
$field="field_".$x."_".$search[$x];
$field_=array();
$field_=$valeur_champ;
global ${$field};
${$field}=$field_;
//opérateur inter-champ
$inter="inter_".$x."_".$search[$x];
global ${$inter};
if ($x>0) {
${$inter}="and";
} else {
${$inter}="";
}
}
}
}
?>