\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("

".$msg["congres_see_title"]." $renvoi

\n"); } else if($ourAuteur->type == 71) { // Collectivités print pmb_bidi("

".$msg["collectivite_see_title"]." $renvoi

\n"); } else { print pmb_bidi("

".$msg["author_see_title"]." $renvoi

\n"); } print "
\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 = "   "; 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 "\n"; } else { print $msg[no_document_found]; print "
\n"; } } else { print pmb_bidi("

".$msg["author_see_title"]." $renvoi

\n"); print "
\n"; } print "
\n"; print " \n";