\n";
if($id) {
$id+=0;
$rqt_auteurs = "select author_id as aut from authors where author_see='$id' and author_id!=0 ";
$rqt_auteurs .= "union select author_see as aut from authors where author_id='$id' and author_see!=0 " ;
$res_auteurs = mysql_query($rqt_auteurs, $dbh);
$clause_auteurs = " in ('$id' ";
while(($id_aut=mysql_fetch_object($res_auteurs))) {
$clause_auteurs .= ", '".$id_aut->aut."' ";
$rqt_auteursuite = "select author_id as aut from authors where author_see='$id_aut->aut' and author_id!=0 ";
$res_auteursuite = mysql_query($rqt_auteursuite, $dbh);
while(($id_autsuite=mysql_fetch_object($res_auteursuite))) $clause_auteurs .= ", '".$id_autsuite->aut."' ";
}
$clause_auteurs .= " ) " ;
// affichage des informations sur l'auteur
$ourAuteur = new auteur($id);
if($ourAuteur->type == 72) {
// Congrès
print pmb_bidi("
\n";
print "
\n
>\n";
print pmb_bidi($ourAuteur->print_congres_titre());
$ourAuteur->get_similar_name($ourAuteur->type);
print $ourAuteur->print_similar_name();
print $ourAuteur->author_comment;
// récupération des formes rejetées pour affichage
$requete = "select distinct author_id as aut from authors where author_id $clause_auteurs and author_id!=$id " ;
$res = mysql_query($requete, $dbh);
while (($obj=mysql_fetch_object($res))) {
$objRenvoi = new auteur($obj->aut);
pmb_strlen($renvoi) ? $renvoi .= ', ('.$objRenvoi->isbd_entry.")" : $renvoi = $objRenvoi->isbd_entry;
}
if (pmb_strlen($renvoi)) print pmb_bidi("
$renvoi\n");
$aut_link= new aut_link(AUT_TABLE_AUTHORS,$id);
print pmb_bidi($aut_link->get_display());
print "
\n";
// affichage des notices associées
print "
\n";
if($ourAuteur->type == 72) {
//Congrès
print pmb_bidi("
$msg[documents_disponibles_meme_congres]");
} else if($ourAuteur->type == 71) {
// Collectivités
print pmb_bidi("".$msg["doc_collectivite_title"]." $renvoi
\n");
} else {
print pmb_bidi("$msg[documents_disponibles_meme_auteur]");
}
print "
\n";
//droits d'acces emprunteur/notice
$acces_j='';
if ($gestion_acces_active==1 && $gestion_acces_empr_notice==1) {
require_once("$class_path/acces.class.php");
$ac= new acces();
$dom_2= $ac->setDomain(2);
$acces_j = $dom_2->getJoin($_SESSION['id_empr_session'],4,'notice_id');
}
if($acces_j) {
$statut_j='';
$statut_r='';
} else {
$statut_j=',notice_statut';
$statut_r="and statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)".($_SESSION["user_code"]?" or (notice_visible_opac_abon=1 and notice_visible_opac=1)":"").")";
}
if($_SESSION["opac_view"]){
$opac_view_restrict=" notice_id in (select opac_view_num_notice from opac_view_notices_".$_SESSION["opac_view"].") ";
$statut_r.=" and ".$opac_view_restrict;
}
// comptage des notices associées
if(!$nbr_lignes) {
$requete = "SELECT count(distinct notices.notice_id) FROM notices $acces_j, responsability $statut_j ";
$requete.= "where responsability_author $clause_auteurs and notice_id=responsability_notice $statut_r ";
$res = mysql_query($requete, $dbh);
if ($res) $nbr_lignes = mysql_result($res,0,0); else $nbr_lignes=0;
//Recherche des types doc
$where = "where responsability_author $clause_auteurs and notice_id=responsability_notice $statut_r group by notices.typdoc";
if ($opac_visionneuse_allow){
$requete_noti = "select distinct notices.typdoc, count(explnum_id) as nbexplnum FROM notices left join explnum on explnum_mimetype in ($opac_photo_filtre_mimetype) and explnum_notice = notice_id $acces_j, responsability $statut_j ";
$requete_bull = "select distinct notices.typdoc, count(explnum_id) as nbexplnum FROM notices left join bulletins on bulletins.num_notice = notice_id and bulletins.num_notice != 0 left join explnum on explnum_mimetype in ($opac_photo_filtre_mimetype) and explnum_bulletin = bulletin_id and explnum_bulletin != 0 $acces_j, responsability $statut_j ";
$where = "where responsability_author $clause_auteurs and notice_id=responsability_notice $statut_r group by notices.typdoc";
$requete = "select distinct uni.typdoc, sum(nbexplnum) as nbexplnum from ($requete_noti $where union $requete_bull $where) as uni group by typdoc";
}else{
$requete = "select distinct notices.typdoc FROM notices $acces_j, responsability $statut_j $where";
}
$res = mysql_query($requete, $dbh);
$t_typdoc=array();
$nbexplnum_to_photo=0;
while ($tpd=mysql_fetch_object($res)) {
$t_typdoc[]=$tpd->typdoc;
$nbexplnum_to_photo += $tpd->nbexplnum;
}
$l_typdoc=implode(",",$t_typdoc);
}
if(!$page) $page=1;
$debut =($page-1)*$opac_nb_aut_rec_per_page;
if($nbr_lignes) {
if ($opac_notices_depliable) print $begin_result_liste;
//gestion du tri
//si on dépasse le nombre de lignes maxi à trier
if ($nbr_lignes>$opac_nb_max_tri) {
//on annule tri selectionner
$_SESSION["last_sortnotices"]="";
print " ";
} else {
$pos=strpos($_SERVER['REQUEST_URI'],"?");
$pos1=strpos($_SERVER['REQUEST_URI'],"get");
if ($pos1==0) $pos1=strlen($_SERVER['REQUEST_URI']);
else $pos1=$pos1-3;
$para=urlencode(substr($_SERVER['REQUEST_URI'],$pos+1,$pos1-$pos+1));
$affich_tris_result_liste=str_replace("!!page_en_cours!!",$para,$affich_tris_result_liste);
print $affich_tris_result_liste;
//on recupere le tri à appliquer
if (isset($_GET["sort"])) {
$_SESSION["last_sortnotices"]=$_GET["sort"];
}
if ($_SESSION["last_sortnotices"]!="") {
$sort = new sort('notices','session');
print " ".$msg['tri_par']." ".$sort->descriptionTriParId($_SESSION["last_sortnotices"])." ";
}
}
//fin gestion du tri
print $add_cart_link;
if($opac_visionneuse_allow && $nbexplnum_to_photo){
print " ".$link_to_visionneuse;
$sendToVisionneuseByGet = str_replace("!!mode!!","congres_see",$sendToVisionneuseByGet);
$sendToVisionneuseByGet = str_replace("!!idautorite!!",$id,$sendToVisionneuseByGet);
print $sendToVisionneuseByGet;
}
if ($opac_show_suggest) {
$bt_sugg = " ".$msg[empr_bt_make_sugg]."";
print $bt_sugg;
}
//affinage
//enregistrement de l'endroit actuel dans la session
if ($_SESSION["last_query"]) { $n=$_SESSION["last_query"]; } else { $n=$_SESSION["nb_queries"]; }
$_SESSION["notice_view".$n]["search_mod"]="author_see";
$_SESSION["notice_view".$n]["search_id"]=$id;
$_SESSION["notice_view".$n]["search_page"]=$page;
//affichage
print " ".$msg["affiner_recherche"]."";
//fin affinage
//Etendre
if ($opac_allow_external_search) print " ".$msg["connecteurs_external_search_sources"]."";
//fin etendre
print "\n";
print aff_notice(-1);
// on lance la vraie requête
$requete = "SELECT distinct notices.notice_id FROM notices $acces_j, responsability $statut_j ";
$requete.= "where responsability_author $clause_auteurs and notice_id=responsability_notice $statut_r";
//gestion du tri
if ($_SESSION["last_sortnotices"]!="") {
$requete = $sort->appliquer_tri($_SESSION["last_sortnotices"], $requete, "notice_id", $debut, $opac_nb_aut_rec_per_page);
} else {
$requete.= " ORDER BY index_serie,tnvol,index_sew";
$requete .= " LIMIT $debut,$opac_nb_aut_rec_per_page ";
}
//fin gestion du tri
$res = mysql_query($requete, $dbh);
while(($obj=mysql_fetch_object($res))) {
global $infos_notice;
print pmb_bidi(aff_notice($obj->notice_id));
$infos_notice['nb_pages'] = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
}
mysql_free_result($res);
// constitution des liens pur affichage de la barre de navigation
$nbepages = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
print aff_notice(-2);
print "
\n
\n";
print "
".printnavbar($page, $nbepages, "./index.php?lvl=author_see&id=$id&page=!!page!!&nbr_lignes=$nbr_lignes&l_typdoc=".rawurlencode($l_typdoc))."\n";
} else {
print $msg[no_document_found];
print "
\n";
}
} else {
print pmb_bidi("