tableau_id = $liste_id; $this->type_elt = $type; if($searchterms) $this->termes_recherche = trim(str_replace('*',' ',implode(' ',$searchterms))); $this->construire_tableau(); } /** * Affichage sous forme de tableau des exemplaires */ public function construire_tableau(){ global $_mimetypes_bymimetype_, $_mimetypes_byext_, $dbh, $charset, $opac_url_base; global $opac_visionneuse_allow; $ligne_finale = ""; if(!$this->tableau_id) $this->display = ""; else { create_tableau_mimetype() ; $url_docnum=""; switch($this->type_elt){ case DOCNUM_DMDE: $url_docnum="/explnum_doc.php?explnumdoc_id="; $requete = "SELECT id_explnum_doc as explnum_id, explnum_doc_nomfichier as explnum_nom, explnum_doc_mimetype as explnum_mimetype, explnum_doc_url as explnum_url, explnum_doc_data as explnum_data, explnum_doc_extfichier as explnum_extfichier FROM explnum_doc join explnum_doc_actions on id_explnum_doc=num_explnum_doc WHERE prive=0 and num_action in (".implode(',',$this->tableau_id).")"; break; case DOCNUM_SUGG: $url_docnum="/explnum_doc.php?explnumdoc_id="; $requete = "SELECT id_explnum_doc as explnum_id, explnum_doc_nomfichier as explnum_nom, explnum_doc_mimetype as explnum_mimetype, explnum_doc_url as explnum_url, explnum_doc_data as explnum_data, explnum_doc_extfichier as explnum_extfichier FROM explnum_doc join explnum_doc_sugg on id_explnum_doc=num_explnum_doc WHERE num_suggestion in (".implode(',',$this->tableau_id).")"; break; case DOCNUM_NOTI: default: // récupération des infos des explnum $requete = "SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_data, explnum_vignette, explnum_nomfichier, explnum_extfichier FROM explnum WHERE explnum_id in (".implode(',',$this->tableau_id).")"; $url_docnum="/doc_num.php?explnum_id="; break; } $res = pmb_mysql_query($requete, $dbh); $i=1; $allowed_mimetype=array(); if ($opac_visionneuse_allow){ global $opac_photo_filtre_mimetype; $allowed_mimetype = explode(",",str_replace("'","",$opac_photo_filtre_mimetype)); } while(($expl = pmb_mysql_fetch_object($res))){ if($expl->explnum_notice) { $notice_aff = new notice_affichage($expl->explnum_notice,''); $notice_aff->do_header_without_html(); $titre = $notice_aff->notice_header_without_html; } elseif($expl->explnum_bulletin) { $titre = $this->get_header_bulletin($expl->explnum_bulletin); } if ($i==1) $ligne="

!!1!!

!!2!!

!!3!!

" ; $alt = htmlentities($expl->explnum_nom." - ".$expl->explnum_mimetype,ENT_QUOTES, $charset) ; if ($expl->explnum_vignette) $obj=" $alt

"; else // trouver l'icone correspondant au mime_type $obj="

explnum_mimetype, $expl->explnum_extfichier), 1)."' alt='$alt' title='$alt' style='border:0px'>"; $lien=""; if($expl->explnum_notice) $lien = "index.php?lvl=notice_display&id=".$expl->explnum_notice; elseif($expl->explnum_bulletin) { $lien = "index.php?lvl=bulletin_display&id=".$expl->explnum_bulletin; } $words_to_find=""; if(($expl->explnum_mimetype=='application/pdf') ||($expl->explnum_mimetype=='URL' && (strpos($expl->explnum_nom,'.pdf')!==false))){ $words_to_find = "#search=\"".$this->termes_recherche."\""; } $expl_liste_obj = "

$titre

"; $expl_liste_obj .= "

"; if ($allowed_mimetype && in_array($expl->explnum_mimetype,$allowed_mimetype)){ $link=" explnum_id.");return false;\" title='$alt'>".$obj."
"; $expl_liste_obj .=$link; } else { $expl_liste_obj .= "".$obj."
" ; } if ($_mimetypes_byext_[$expl->explnum_extfichier]["label"]) $explmime_nom = $_mimetypes_byext_[$expl->explnum_extfichier]["label"] ; elseif ($_mimetypes_bymimetype_[$expl->explnum_mimetype]["label"]) $explmime_nom = $_mimetypes_bymimetype_[$expl->explnum_mimetype]["label"] ; else $explmime_nom = $expl->explnum_mimetype ; $expl_liste_obj .= htmlentities($expl->explnum_nom,ENT_QUOTES, $charset)."

".htmlentities($explmime_nom,ENT_QUOTES, $charset)."

"; $expl_liste_obj .= "

"; $ligne = str_replace("!!$i!!", $expl_liste_obj, $ligne); $i++; if ($i==4) { $ligne_finale .= $ligne ; $i=1; } } if (!$ligne_finale) $ligne_finale = $ligne ; elseif ($i!=1) $ligne_finale .= $ligne ; $ligne_finale = str_replace('!!2!!', " ", $ligne_finale); $ligne_finale = str_replace('!!3!!', " ", $ligne_finale); $this->display = $ligne_finale; } } /** * Affichage des exemplaires numériques */ public function show_explnum(){ print $this->display; } /** * Récupération des infos des bulletins */ public function get_header_bulletin($id){ global $dbh; $req = "select bulletin_notice, bulletin_numero, date_date, mention_date, bulletin_titre from bulletins where bulletin_id='".$id."'"; $res = pmb_mysql_query($req, $dbh); $header =''; while(($bull = pmb_mysql_fetch_object($res))){ $notice_mere = $bull->bulletin_notice; $titre_bull = $bull->bulletin_titre; $date = $bull->date_date; $mention = $bull->mention_date; $num_bull = $bull->bulletin_numero; } $notice_aff = new notice_affichage($notice_mere,''); $header = $notice_aff->notice->tit1.", ".$num_bull." (".($mention?$mention:"[$date]").")".($titre_bull?" - $titre_bull":''); return $header; } } ?>