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)":"").")";
}
// affichage des notices associées
$recordslist= "$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 = pmb_mysql_query($requete, $dbh);
$nbr_lignes = @pmb_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 = pmb_mysql_query($requete, $dbh);
$t_typdoc=array();
$nbexplnum_to_photo=0;
if ($res) {
while ($tpd=pmb_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 = pmb_mysql_query($requete, $dbh);
$nbexplnum_to_photo=0;
if ($res) {
while ($tpd=pmb_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 = @pmb_mysql_query($requete, $dbh);
if ($opac_notices_depliable) $recordslist.= $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);
$recordslist.= $affich_tris_result_liste;
if ($_SESSION["last_sortnotices"]!="") {
$recordslist.= "".$msg['tri_par']." ".$sort->descriptionTriParId($_SESSION["last_sortnotices"])." ";
}
} else $recordslist.= " ";
//fin gestion du tri
$recordslist.= $add_cart_link;
if($opac_visionneuse_allow && $nbexplnum_to_photo){
$recordslist.= " ".$link_to_visionneuse;
$sendToVisionneuseByGet = str_replace("!!mode!!","serie_see",$sendToVisionneuseByGet);
$sendToVisionneuseByGet = str_replace("!!idautorite!!",$id,$sendToVisionneuseByGet);
$recordslist.= $sendToVisionneuseByGet;
}
if ($opac_show_suggest) {
$bt_sugg = " ".$msg[empr_bt_make_sugg]."";
$recordslist.= $bt_sugg;
}
//affinage
//enregistrement de l'endroit actuel dans la session
rec_last_authorities();
//affichage
$recordslist.= " ".$msg["affiner_recherche"]."";
//fin affinage
$recordslist.= "\n";
$recordslist.= aff_notice(-1);
while(($obj=pmb_mysql_fetch_object($res))) {
$recordslist.= pmb_bidi(aff_notice($obj->notice_id));
}
$recordslist.= aff_notice(-2);
$recordslist.= "
\n";
pmb_mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
// $recordslist.= "\n";
$recordslist.= "
".printnavbar($page, $nbepages, "./index.php?lvl=serie_see&id=$id&page=!!page!!&nbr_lignes=$nbr_lignes&l_typdoc=".rawurlencode($l_typdoc))."\n";
} else {
$recordslist.= $msg["no_document_found"];
}
$context = array();
$context['authority']['recordslist'] = $recordslist;
$authority = new authority("serie", $id);
$authority->render($context);
//FACETTES
//gestion des facette si active
require_once($base_path.'/classes/facette_search.class.php');
$records = "";
if($nbr_lignes){
$requete = "SELECT notice_id FROM notices $acces_j $statut_j where tparent_id=$id $statut_r ";
$facettes_result = pmb_mysql_query($requete,$dbh);
while($row = pmb_mysql_fetch_object($facettes_result)){
if($records){
$records.=",";
}
$records.= $row->notice_id;
}
if(!$opac_facettes_ajax){
$str .= facettes::make_facette($records);
}else{
$_SESSION['tab_result']=$records;
$str .=facettes::get_facette_wrapper();
$str .="";
$str .="
";
}
//Formulaire "FACTICE" pour l'application du comparateur et du filetre multiple...
$str.= '
';
}
} 