\n";
if($id) {
$id+=0;
// affichage des informations sur la collection
print "
\n";
$ourSubcoll = new subcollection($id);
print pmb_bidi($ourSubcoll->print_resume());
$aut_link= new aut_link(AUT_TABLE_SUB_COLLECTIONS,$id);
print pmb_bidi($aut_link->get_display());
print "
\n";
// affichage des notices associées
print "
$msg[available_docs_in_subcoll]
\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"] && $_SESSION["opac_view_query"] ){
$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(1) FROM notices, notice_statut ";
//$requete .= " where (subcoll_id='$i'd) 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(1) FROM notices $acces_j $statut_j ";
$requete.= " where subcoll_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 (subcoll_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)":"")."))";
$clause = "where subcoll_id='$id' $statut_r group by notices.typdoc";
if($opac_visionneuse_allow){
$req_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 $statut_j $clause";
$req_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 $statut_j $clause";
$requete ="select distinct typdoc, sum(nbexplnum) as nbexplnum from ($req_bull union $req_noti) as uni group by typdoc";
}else {
$requete="select distinct notices.typdoc FROM notices $acces_j $statut_j $clause";
}
$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){
$clause = "where subcoll_id='$id' $statut_r";
$req_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 $statut_j $clause";
$req_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 $statut_j $clause";
$requete ="select distinct typdoc, sum(nbexplnum) as nbexplnum from ($req_bull union $req_noti) as uni 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 requête de sélection des notices
//$requete = "SELECT notice_id FROM notices, notice_statut WHERE (subcoll_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 ";
$requete.= "WHERE subcoll_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!!","subcoll_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"]="subcoll_see";
$_SESSION["notice_view".$n]["search_id"]=$id;
$_SESSION["notice_view".$n]["search_page"]=$page;
//affichage
print "
".$msg["affiner_recherche"]."";
//fin affinage
print "
\n";
print aff_notice(-1);
$nb=0;
$recherche_ajax_mode=0;
while(($obj=mysql_fetch_object($res))) {
if($nb++>4) $recherche_ajax_mode=1;
print pmb_bidi(aff_notice($obj->notice_id, 0, 1, 0, "", "", 0, 0, $recherche_ajax_mode));
}
print aff_notice(-2);
print "
\n";
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
print "