\n"; $ourSerie = new serie($id); print pmb_bidi($ourSerie->print_resume()); $aut_link= new aut_link(AUT_TABLE_SERIES,$id); print pmb_bidi($aut_link->get_display()); print "

\n

$msg[doc_serie_title]

\n"; // comptage des notices associées if(!$nbr_lignes) { //$requete = "SELECT COUNT(notice_id) FROM notices, notice_statut "; //$requete .= " where tparent_id='$id' 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)":"")."))"; $requete = "SELECT COUNT(*) FROM notices $acces_j $statut_j where tparent_id=$id $statut_r "; $res = mysql_query($requete, $dbh); $nbr_lignes = @mysql_result($res, 0, 0); //Recherche des types doc //$requete="select distinct notices.typdoc FROM notices, notice_statut "; //$requete .= " where tparent_id='$id' 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)":"")."))"; $requete="select distinct typdoc,count(explnum_id) as nbexplnum FROM notices left join explnum on explnum_notice=notice_id $acces_j $statut_j where tparent_id=$id $statut_r group by typdoc"; $res = mysql_query($requete, $dbh); $t_typdoc=array(); $nbexplnum_to_photo=0; if ($res) { while ($tpd=mysql_fetch_object($res)) { $t_typdoc[]=$tpd->typdoc; $nbexplnum_to_photo += $tpd->nbexplnum; } } $l_typdoc=implode(",",$t_typdoc); }else if($opac_visionneuse_allow){ $requete="select count(explnum_id) as nbexplnum FROM notices left join explnum on explnum_notice=notice_id $acces_j $statut_j where tparent_id=$id $statut_r group by typdoc"; $res = mysql_query($requete, $dbh); $nbexplnum_to_photo=0; if ($res) { while ($tpd=mysql_fetch_object($res)) { $nbexplnum_to_photo += $tpd->nbexplnum; } } } if(!$page) $page=1; $debut =($page-1)*$opac_nb_aut_rec_per_page; if($nbr_lignes) { // on lance la vraie requête //$requete = "SELECT notice_id FROM notices, notice_statut WHERE tparent_id='$id' 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)":"")."))"; $requete = "SELECT notice_id FROM notices $acces_j $statut_j where tparent_id=$id $statut_r "; //gestion du tri if (isset($_GET["sort"])) { $_SESSION["last_sortnotices"]=$_GET["sort"]; } if ($nbr_lignes>$opac_nb_max_tri) { $_SESSION["last_sortnotices"]=""; } if ($_SESSION["last_sortnotices"]!="") { $sort = new sort('notices','session'); $requete = $sort->appliquer_tri($_SESSION["last_sortnotices"], $requete, "notice_id", $debut, $opac_nb_aut_rec_per_page); } else { $requete .= " LIMIT $debut,$opac_nb_aut_rec_per_page "; } //fin gestion du tri $res = @mysql_query($requete, $dbh); if ($opac_notices_depliable) print $begin_result_liste; //gestion du tri if ($nbr_lignes<=$opac_nb_max_tri) { $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)); $para1=substr($_SERVER['REQUEST_URI'],$pos+1,$pos1-$pos+1); $affich_tris_result_liste=str_replace("!!page_en_cours!!",$para,$affich_tris_result_liste); $affich_tris_result_liste=str_replace("!!page_en_cours1!!",$para1,$affich_tris_result_liste); print $affich_tris_result_liste; if ($_SESSION["last_sortnotices"]!="") { print "".$msg['tri_par']." ".$sort->descriptionTriParId($_SESSION["last_sortnotices"])." "; } } else print " "; //fin gestion du tri print $add_cart_link; if($opac_visionneuse_allow && $nbexplnum_to_photo){ print "   ".$link_to_visionneuse; $sendToVisionneuseByGet = str_replace("!!mode!!","serie_see",$sendToVisionneuseByGet); $sendToVisionneuseByGet = str_replace("!!idautorite!!",$id,$sendToVisionneuseByGet); print $sendToVisionneuseByGet; } print "

\n"; print aff_notice(-1); while(($obj=mysql_fetch_object($res))) { print pmb_bidi(aff_notice($obj->notice_id)); } print aff_notice(-2); print "

\n"; mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes/$opac_nb_aut_rec_per_page); print "