\n";
$index_title=$ourIndexInt->name;
if ($ourIndexInt->comment) $index_title.=" : ".$ourIndexInt->comment;
print pmb_bidi("
".$index_title."
\n");
// si la catégorie à des enfants, on les affiche
if($ourIndexInt->has_child)
print pmb_bidi($ourIndexInt->child_list('./images/folder.gif',$css, 0));
$aut_link= new aut_link(AUT_TABLE_INDEXINT,$ourIndexInt->indexint_id);
print pmb_bidi($aut_link->get_display());
print " \n";
$indexint_notices ="
".$msg["indexint_see_title"]." !!indexint_name!!
";
print pmb_bidi(str_replace('!!indexint_name!!', htmlentities($ourIndexInt->name,ENT_QUOTES, $charset) , $indexint_notices));
//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 && $ourIndexInt->indexint_id) {
$requete = "SELECT COUNT(1) FROM notices $acces_j $statut_j ";
$requete.= "where indexint='".$ourIndexInt->indexint_id."' $statut_r ";
$res = mysql_query($requete, $dbh);
$nbr_lignes = @mysql_result($res, 0, 0);
//Recherche des types doc
$clause = "where indexint='".$ourIndexInt->indexint_id."' $statut_r group by typdoc";
if ($opac_visionneuse_allow){
$requete_noti = "SELECT distinct typdoc, count(explnum_id) as nbexplnum FROM notices left join explnum on explnum_notice=notice_id and explnum_mimetype in ($opac_photo_filtre_mimetype) $acces_j $statut_j $clause ";
$requete_bull = "SELECT distinct 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_bulletin=bulletin_id and explnum_bulletin != 0 and explnum_mimetype in ($opac_photo_filtre_mimetype) $acces_j $statut_j $clause ";
$requete = "SELECT distinct typdoc, sum(nbexplnum) as nbexplnum FROM ($requete_noti union $requete_bull) as uni group by uni.typdoc";
}else{
$requete = "SELECT distinct 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 indexint='".$ourIndexInt->indexint_id."' $statut_r group by typdoc";
$requete_noti = "SELECT distinct typdoc, count(explnum_id) as nbexplnum FROM notices left join explnum on explnum_notice=notice_id and explnum_mimetype in ($opac_photo_filtre_mimetype) $acces_j $statut_j $clause ";
$requete_bull = "SELECT distinct 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_bulletin=bulletin_id and explnum_bulletin != 0 and explnum_mimetype in ($opac_photo_filtre_mimetype) $acces_j $statut_j $clause ";
$requete = "SELECT distinct typdoc, sum(nbexplnum) as nbexplnum FROM ($requete_noti union $requete_bull) as uni group by uni.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 && $ourIndexInt->indexint_id) {
// on lance la vraie requête
$requete = "SELECT notice_id FROM notices $acces_j $statut_j ";
$requete.= "WHERE indexint='".$ourIndexInt->indexint_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.= " ORDER BY $opac_categories_categ_sort_records";
$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!!","indexint_see",$sendToVisionneuseByGet);
$sendToVisionneuseByGet = str_replace("!!idautorite!!",$ourIndexInt->indexint_id,$sendToVisionneuseByGet);
print $sendToVisionneuseByGet;
}
if ($opac_show_suggest) {
$bt_sugg = "
";
print $bt_sugg;
}
//affinage
if ($main) {
//enregistrement de l'endroit actuel dans la session
$_SESSION["last_module_search"]["search_mod"]="indexint_see";
$_SESSION["last_module_search"]["search_id"]=$ourIndexInt->indexint_id;
$_SESSION["last_module_search"]["search_page"]=$page;
//affichage
print "
".$msg["affiner_recherche"]."";
//Etendre
if ($opac_allow_external_search) print "
".$msg["connecteurs_external_search_sources"]."";
//fin etendre
} else {
//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"]="indexint_see";
$_SESSION["notice_view".$n]["search_id"]=$ourIndexInt->indexint_id;
$_SESSION["notice_view".$n]["search_page"]=$page;
//affichage
print "
".$msg["affiner_recherche"]."";
//Etendre
if ($opac_allow_external_search) print "
".$msg["connecteurs_external_search_sources"]."";
//fin etendre
}
//fin affinage
print "
\n";
print aff_notice(-1);
$nb=0;
$recherche_ajax_mode=0;
while (($obj=mysql_fetch_object($res))) {
global $infos_notice;
if($nb++>4) $recherche_ajax_mode=1;
print pmb_bidi(aff_notice($obj->notice_id, 0, 1, 0, "", "", 0, 0, $recherche_ajax_mode));
$infos_notice['nb_pages'] = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
}
print aff_notice(-2);
print "
\n";
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes/$opac_nb_aut_rec_per_page);
print "