";
$r.="";
$requete="select location_libelle,idlocation from docs_location where location_visible_opac=1";
$result = mysql_query($requete, $dbh);
if (mysql_numrows($result)){
while ($loc = mysql_fetch_object($result)) {
$selected="";
if ($cnl_bibli==$loc->idlocation) {$selected="selected";}
$r.= "";
}
}
$r.="";
// Année de parution : fonctionnel mais désactivé pour l'instant
//$r.="Année de parution ";
$r.=" Restreindre à Articles de revues Revues Tout sauf revues";
return $r;
}
function search_other_function_clause() {
global $typ_notice,$annee_parution;
global $cnl_bibli;
reset($typ_notice);
$from="";
$where="";
if ($cnl_bibli) {
$from .= ",exemplaires";
$where .= " and notices.notice_id=exemplaires.expl_notice and expl_location=$cnl_bibli";
}
$t_n=array();
while (list($key,$val)=each($typ_notice)) {
$t_n[]=$key;
}
$t_n=implode("','",$t_n);
if ($t_n) {
$t_n="'".$t_n."'";
$where .= " and niveau_biblio in (".$t_n.")";
}
if ($annee_parution) {
$where .= " and year like '%".$annee_parution."%'";
}
if ($cnl_bibli || $t_n || $annee_parution) {
$r = "select distinct notice_id from notices $from where 1 $where";
}
return $r;
}
function search_other_function_has_values() {
global $typ_notice, $annee_parution;
global $cnl_bibli;
if (((count($typ_notice))||($annee_parution))||($cnl_bibli)) return true; else return false;
}
function search_other_function_get_values(){
global $typ_notice, $annee_parution, $cnl_bibli;
return $typ_notice."---".$annee_parution."---".$cnl_bibli;
}
function search_other_function_rec_history($n) {
global $typ_notice,$annee_parution;
global $cnl_bibli;
$_SESSION["cnl_bibli".$n]=$cnl_bibli;
$_SESSION["typ_notice".$n]=$typ_notice;
$_SESSION["annee_parution".$n]=$annee_parution;
}
function search_other_function_get_history($n) {
global $typ_notice,$annee_parution;
global $cnl_bibli;
$cnl_bibli=$_SESSION["cnl_bibli".$n];
$typ_notice=$_SESSION["typ_notice".$n];
$annee_parution=$_SESSION["annee_parution".$n];
}
function search_other_function_human_query($n) {
global $dbh;
global $typ_notice,$annee_parution;
global $cnl_bibli;
$r="";
$cnl_bibli=$_SESSION["cnl_bibli".$n];
if ($cnl_bibli) {
$r="bibliotheque : ";
$requete="select location_libelle from docs_location where id_location='".$cnl_bibli."' limit 1";
$res=mysql_query($requete);
$r.=@mysql_result($res,0,0);
$r=" ";
}
$notices_t=array("m"=>"Monographies","s"=>"Périodiques","a"=>"Articles");
$typ_notice=$_SESSION["typ_notice".$n];
$annee_parution=$_SESSION["annee_parution".$n];
if (count($typ_notice)) {
$r.="pour les types de notices ";
reset($typ_notice);
$t_l=array();
while (list($key,$val)=each($typ_notice)) {
$t_l[]=$notices_t[$key];
}
$r.=implode(", ",$t_l);
}
if ($annee_parution) {
if ($r) $r.=" ";
$r.="parus en ".$annee_parution;
}
return $r;
}
function search_other_function_post_values() {
global $cnl_bibli;
return "\n";
}
?>