function get_notice_by_meta($name, $filename)
{
global $pmb_keyword_sep;
global $pmb_type_audit;
global $webdav_current_user_name, $webdav_current_user_id;
\create_tableau_mimetype();
$mimetype = \trouve_mimetype($filename, extension_fichier($name));
//on commence avec la gymnatisque des métas...
if ($mimetype == "application/epub+zip") {
//pour les ebook, on gère ca directement ici !
$epub = new \epubData(realpath($filename));
$metas = $epub->metas;
$img = imagecreatefromstring($epub->getCoverContent());
$file = tempnam(sys_get_temp_dir(), "vign");
imagepng($img, $file);
$metas['thumbnail_content'] = file_get_contents($file);
unlink($file);
} else {
$metas = \extract_metas(realpath($filename), $mimetype);
}
if ($this->config['metasMapper_class']) {
$className = "Sabre\\PMB\\" . $this->config['metasMapper_class'];
if (class_exists($className)) {
$metasMapper = new $className($this->config, $metas, $mimetype, $name);
}
}
if (!is_object($metasMapper)) {
$metasMapper = new metasMapper($this->config, $metas, $mimetype, $name);
}
return $metasMapper->get_notice_id();
}
function analyse_file()
{
if ($this->explnum_doc_file) {
create_tableau_mimetype();
$userfile_name = $this->explnum_doc_file['name'];
$userfile_temp = $this->explnum_doc_file['tmp_name'];
$userfile_moved = basename($userfile_temp);
$userfile_name = preg_replace("/ |'|\\|\"|\\//m", "_", $userfile_name);
$userfile_ext = '';
if ($userfile_name) {
$userfile_ext = extension_fichier($userfile_name);
}
move_uploaded_file($userfile_temp, "./temp/" . $userfile_moved);
$file_name = "./temp/" . $userfile_moved;
$fp = fopen($file_name, "r");
$contenu = fread($fp, filesize($file_name));
fclose($fp);
$mime = trouve_mimetype($userfile_moved, $userfile_ext);
if (!$mime) {
$mime = "application/data";
}
$this->explnum_doc_mime = $mime;
$this->explnum_doc_nomfichier = $userfile_name;
$this->explnum_doc_extfichier = $userfile_ext;
$this->explnum_doc_contenu = $contenu;
unlink($file_name);
}
}
function get_notice_by_meta($name, $filename)
{
\create_tableau_mimetype();
$mimetype = \trouve_mimetype($filename, extension_fichier($name));
//on commence avec la gymnatisque des métas...
if ($mimetype == "application/epub+zip") {
//pour les ebook, on gère ca directement ici !
$epub = new \epubData(realpath($filename));
$metas = $epub->metas;
$img = imagecreatefromstring($epub->getCoverContent());
$file = tempnam(sys_get_temp_dir(), "vign");
imagepng($img, $file);
$metas['thumbnail_content'] = file_get_contents($file);
unlink($file);
} else {
$metas = \extract_metas(realpath($filename), $mimetype);
}
$metasMapper = $this->load_metas_mapper();
return $metasMapper->get_notice_id($metas, $mimetype, $name);
}
/**
* Affichage sous forme de tableau des exemplaires
*/
function construire_tableau()
{
global $_mimetypes_bymimetype_, $_mimetypes_byext_, $dbh, $charset, $opac_url_base;
global $opac_visionneuse_allow;
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,\n\t\t\t\t\t\t explnum_doc_url as explnum_url, explnum_doc_data as explnum_data, explnum_doc_extfichier as explnum_extfichier\n\t\t\t\t\t\t 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,\n\t\t\t\t\t\t explnum_doc_url as explnum_url, explnum_doc_data as explnum_data, explnum_doc_extfichier as explnum_extfichier\n\t\t\t\t\t\t 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,\n\t\t\t\t\t\t explnum_url, explnum_data, explnum_vignette, explnum_nomfichier, explnum_extfichier\n\t\t\t\t\t\t FROM explnum WHERE explnum_id in (" . implode(',', $this->tableau_id) . ")";
$url_docnum = "/doc_num.php?explnum_id=";
break;
}
$res = 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 = 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 = "<div class='row'><div class='colonne3' >!!1!!</div><div class='colonne3' width='33%'>!!2!!</div><div class='colonne3' >!!3!!</div></div>";
}
$alt = htmlentities($expl->explnum_nom . " - " . $expl->explnum_mimetype, ENT_QUOTES, $charset);
if ($expl->explnum_vignette) {
$obj = "<img src='" . $opac_url_base . "/vig_num.php?explnum_id={$expl->explnum_id}' alt='{$alt}' title='{$alt}' border='0'>";
} else {
// trouver l'icone correspondant au mime_type
$obj = "<img src='" . $opac_url_base . "/images/mimetype/" . icone_mimetype($expl->explnum_mimetype, $expl->explnum_extfichier) . "' alt='{$alt}' title='{$alt}' border='0'>";
}
$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 = "<div class='explnum-titre' style=\"margin-top:20px;margin-bottom:10px;text-align:center;font-weight:bold;\" ><a href='{$lien}'>{$titre}</a></div>";
$expl_liste_obj .= "<div style=\"text-align:center; word-wrap: break-word\">";
if ($allowed_mimetype && in_array($expl->explnum_mimetype, $allowed_mimetype)) {
$link = "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\n\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\n\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t<a href='#' onclick=\"open_visionneuse(sendToVisionneuse," . $expl->explnum_id . ");return false;\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$expl_liste_obj .= $link;
} else {
$expl_liste_obj .= "<a href='" . $opac_url_base . $url_docnum . $expl->explnum_id . $words_to_find . "' alt='{$alt}' title='{$alt}' target='_blank'>" . $obj . "</a><br />";
}
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) . "<div class='explnum_type'>" . htmlentities($explmime_nom, ENT_QUOTES, $charset) . "</div>";
$expl_liste_obj .= "</div>";
$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;
}
}
function show_docnum_table($docnum_tab = array(), $action)
{
global $charset;
create_tableau_mimetype();
$display = "";
if ($docnum_tab) {
$nb_doc = 0;
for ($i = 0; $i < count($docnum_tab); $i++) {
$nb_doc++;
if ($nb_doc == 1) {
$display .= "<tr >";
}
$alt = htmlentities($docnum_tab[$i]['tache_docnum_nomfichier'], ENT_QUOTES, $charset) . ' - ' . htmlentities($docnum_tab[$i]['tache_docnum_mimetype'], ENT_QUOTES, $charset);
$display .= "<td class='docnum' style='width:25%;border:1px solid #CCCCCC;padding : 5px 5px'>\n\t\t\t\t\t\t<a target='_blank' alt='{$alt}' title='{$alt}' href=\"./tache_docnum.php?tache_docnum_id=" . $docnum_tab[$i]['id_tache_docnum'] . "\">\n\t\t\t\t\t\t\t<img src='./images/mimetype/" . icone_mimetype($docnum_tab[$i]['tache_docnum_mimetype'], $docnum_tab[$i]['tache_docnum_extfichier']) . "' alt='{$alt}' title='{$alt}' >\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t<br />\n\t\t\t\t\t\t<a target='_blank' href='./tache_docnum.php?tache_docnum_id=" . $docnum_tab[$i]['id_tache_docnum'] . "'>" . htmlentities($docnum_tab[$i]['tache_docnum_nomfichier'], ENT_QUOTES, $charset) . "\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t<div class='explnum_type'>" . $docnum_tab[$i]['tache_docnum_mimetype'] . "</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t";
if ($nb_doc == 4) {
$display .= "</tr>";
$nb_doc = 0;
}
}
}
return $display;
}
function create_docnum($doc)
{
global $bull_id;
global $notice_id;
$id_rep = 1;
$rep = new upload_folder($id_rep);
$name = $doc['nom_fic'] ? $doc['nom_fic'] : $doc['titre'];
$filename = strtolower(implode("_", explode(" ", $name)));
$filename = checkIfExist($rep->repertoire_path, $filename, $filename);
file_put_contents($rep->repertoire_path . $filename, file_get_contents($doc['url']));
$ext_fichier = extension_fichier($filename);
if ($doc['mimetype'] == "") {
create_tableau_mimetype();
$mimetype = trouve_mimetype($filename, $ext_fichier);
} else {
$mimetype = $doc['mimetype'];
}
$insert = "insert into explnum set ";
if ($bull_id != 0) {
$insert .= "explnum_bulletin = {$bull_id}, ";
} else {
$insert .= "explnum_notice = {$notice_id}, ";
}
$insert .= "explnum_nom = '" . $doc['titre'] . "', ";
$insert .= "explnum_mimetype = '{$mimetype}', ";
$insert .= "explnum_nomfichier = '" . $filename . "', ";
$insert .= "explnum_extfichier = '{$ext_fichier}', ";
$insert .= "explnum_repertoire = {$id_rep}, ";
$insert .= "explnum_path = '/'";
$result = mysql_query($insert);
$explnum_id = mysql_insert_id();
return $explnum_id;
}
function show_docnum_table($docnum_tab = array())
{
global $charset;
create_tableau_mimetype();
$display = "";
if ($docnum_tab) {
$nb_doc = 0;
$display .= "<table>\r\n\t\t\t<tbody>";
for ($i = 0; $i < count($docnum_tab); $i++) {
$nb_doc++;
if ($nb_doc == 1) {
$display .= "<tr>";
}
$alt = htmlentities($docnum_tab[$i]['explnum_doc_nomfichier'], ENT_QUOTES, $charset) . ' - ' . htmlentities($docnum_tab[$i]['explnum_doc_mimetype'], ENT_QUOTES, $charset);
$display .= "<td class='docnum' style='width:25%;border:1px solid #CCCCCC;padding : 5px 5px'>\r\n\t\t\t\t<a target='_blank' alt='{$alt}' title='{$alt}' href=\"./explnum_doc.php?explnumdoc_id=" . $docnum_tab[$i]['id_explnum_doc'] . "\">\r\n\t\t\t\t<img src='" . get_url_icon('mimetype/' . icone_mimetype($docnum_tab[$i]['explnum_doc_mimetype'], $docnum_tab[$i]['explnum_doc_extfichier'])) . "' alt='{$alt}' title='{$alt}' >\r\n\t\t\t\t</a>\r\n\t\t\t\t<br />\r\n\t\t\t\t<div class='explnum_type'>" . $docnum_tab[$i]['explnum_doc_mimetype'] . "</div>\r\n\t\t\t\t</td>\r\n\t\t\t\t";
if ($nb_doc == 4) {
$display .= "</tr>";
$nb_doc = 0;
}
}
$display .= "</tbody></table>";
}
return $display;
}
/**
* @param $name : file name
* @param $filename : file name with path
* @return Array : le tableau des métadonnées du fichier
*/
static function getMetadata($filename, $name)
{
\create_tableau_mimetype();
$mimetype = \trouve_mimetype($filename, extension_fichier($name));
if ($mimetype == "application/epub+zip") {
//récupération de l'image
$epub = new \epubData(realpath($filename));
//TODO : Vérifier la récupération des métadonnées d'un epub avec \extract_metas(), sinon rétablir les commentaires ici et le else plus bas
// $tmp=array();
// $tmp=$epub->metas;
// foreach($tmp as $key=>$val){
// $metas[strtoupper(substr($key,0,1)).substr($key,1)]=$val;
// }
$img = imagecreatefromstring($epub->getCoverContent());
$file = tempnam(sys_get_temp_dir(), "vign");
imagepng($img, $file);
$entry['thumbnail_url'] = 'data:image/png;base64,' . base64_encode(file_get_contents($file));
unlink($file);
}
// else{
return \extract_metas(realpath($filename), $mimetype);
// }
}
/**
* Fonction retournant les infos d'exemplaires numériques pour une notice ou un bulletin donné
* @param int $explnum_id Identifiant du document numérique
* @return string
*/
function show_explnum_per_id($explnum_id, $link_explnum = "")
{
global $dbh;
global $charset;
global $opac_url_base;
global $opac_visionneuse_allow;
global $opac_photo_filtre_mimetype;
global $opac_explnum_order;
global $opac_show_links_invisible_docnums;
global $gestion_acces_active, $gestion_acces_empr_notice, $gestion_acces_empr_docnum;
global $search_terms;
if (!$explnum_id) {
return "";
}
global $_mimetypes_bymimetype_, $_mimetypes_byext_;
create_tableau_mimetype();
// récupération des infos du document
$query = "select explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier , explnum_docnum_statut FROM explnum WHERE explnum_id = " . $explnum_id;
$result = pmb_mysql_query($query, $dbh);
if ($result && pmb_mysql_num_rows($result)) {
if ($explnum = pmb_mysql_fetch_object($result)) {
$docnum_visible = true;
$id_for_right = $explnum->explnum_notice;
if ($gestion_acces_active == 1 && $gestion_acces_empr_notice == 1) {
$ac = new acces();
$dom_2 = $ac->setDomain(2);
$docnum_visible = $dom_2->getRights($_SESSION['id_empr_session'], $id_for_right, 16);
} else {
$requete = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM notices, notice_statut WHERE notice_id ='" . $id_for_right . "' and id_notice_statut=statut ";
$myQuery = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($myQuery)) {
$statut_temp = pmb_mysql_fetch_object($myQuery);
if (!$statut_temp->explnum_visible_opac) {
$docnum_visible = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$docnum_visible = false;
}
} else {
$docnum_visible = false;
}
}
if ($docnum_visible) {
if ($gestion_acces_active == 1 && $gestion_acces_empr_docnum == 1) {
$ac = new acces();
$dom_3 = $ac->setDomain(3);
$docnum_visible = $dom_3->getRights($_SESSION['id_empr_session'], $explnum->explnum_id, 16);
} else {
$requete = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM explnum, explnum_statut WHERE explnum_id ='" . $explnum->explnum_id . "' and id_explnum_statut=explnum_docnum_statut ";
$myQuery = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($myQuery)) {
$statut_temp = pmb_mysql_fetch_object($myQuery);
if (!$statut_temp->explnum_visible_opac) {
$docnum_visible = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$docnum_visible = false;
}
} else {
$docnum_visible = false;
}
}
}
if ($link_explnum) {
$tlink = str_replace("!!explnum_id!!", $explnum->explnum_id, $link_explnum);
$tlink = str_replace("!!notice_id!!", $explnum->explnum_notice, $tlink);
$tlink = str_replace("!!bulletin_id!!", $explnum->explnum_bulletin, $tlink);
}
$alt = htmlentities($explnum->explnum_nom . " - " . $explnum->explnum_mimetype, ENT_QUOTES, $charset);
// couleur de l'img en fonction du statut
if ($expl->explnum_docnum_statut) {
$rqt_st = "SELECT * FROM explnum_statut WHERE id_explnum_statut='" . $expl->explnum_docnum_statut . "' ";
$Query_statut = pmb_mysql_query($rqt_st, $dbh) or die($rqt_st . " " . pmb_mysql_error());
$r_statut = pmb_mysql_fetch_object($Query_statut);
$class_img = " class='docnum_" . $r_statut->class_html . "' ";
if ($expl->explnum_docnum_statut > 1) {
$txt = $r_statut->opac_libelle;
} else {
$txt = "";
}
$statut_libelle_div = "\r\n\t\t\t\t\t<div id='zoom_statut_docnum" . $expl->explnum_id . "' style='border: 2px solid rgb(85, 85, 85); background-color: rgb(255, 255, 255); position: absolute; z-index: 2000; display: none;'>\r\n\t\t\t\t\t\t<b>{$txt}</b>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t";
} else {
$class_img = " class='docnum_statutnot1' ";
$txt = "";
}
if ($explnum->explnum_vignette) {
$obj = "<img src='" . $opac_url_base . "vig_num.php?explnum_id={$explnum->explnum_id}' alt='{$alt}' title='{$alt}' border='0'>";
} else {
// trouver l'icone correspondant au mime_type
$obj = "<img src='" . get_url_icon('mimetype/' . icone_mimetype($explnum->explnum_mimetype, $explnum->explnum_extfichier), 1) . "' alt='{$alt}' title='{$alt}' border='0'>";
}
$explnum_liste_obj = "<center>";
$obj .= "{$statut_libelle_div}\r\n\t\t\t\t<a href='#' onmouseout=\"z=document.getElementById('zoom_statut_docnum" . $expl->explnum_id . "'); z.style.display='none'; \" onmouseover=\"z=document.getElementById('zoom_statut_docnum" . $expl->explnum_id . "'); z.style.display=''; \">\r\n\t\t\t\t\t<div class='vignette_doc_num' ><img {$class_img} width='10' height='10' src='./images/spacer.gif'></div>\r\n\t\t\t\t</a>\r\n\t\t\t";
$words_to_find = "";
if ($explnum->explnum_mimetype == 'application/pdf' || $explnum->explnum_mimetype == 'URL' && strpos($explnum->explnum_nom, '.pdf') !== false) {
if (is_array($search_terms)) {
$words_to_find = "#search=\"" . trim(str_replace('*', '', implode(' ', $search_terms))) . "\"";
}
}
//si l'affichage du lien vers les documents numériques est forcé et qu'on est pas connecté, on propose l'invite de connexion!
if (!$docnum_visible && !$_SESSION['user_code'] && $opac_show_links_invisible_docnums) {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($explnum->explnum_mimetype, $allowed_mimetype)) {
$link = "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\n\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\n\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\tfunction sendToVisionneuse_" . $explnum->explnum_id . "(){\n\t\t\t\t\t\t\t\topen_visionneuse(sendToVisionneuse," . $explnum->explnum_id . ");\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&callback_func=sendToVisionneuse_" . $explnum->explnum_id . "');\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
} else {
$link = "\n\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&new_tab=1&callback_url=" . rawurlencode($opac_url_base . "doc_num.php?explnum_id=" . $explnum->explnum_id) . "')\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
}
} else {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($explnum->explnum_mimetype, $allowed_mimetype)) {
$link = "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\n\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\n\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t<a href='#' onclick=\"open_visionneuse(sendToVisionneuse," . $explnum->explnum_id . ");return false;\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
} else {
$suite_url_explnum = "doc_num.php?explnum_id={$explnum->explnum_id}";
if (!$r_statut->explnum_download_opac) {
$explnum_liste_obj .= $obj . "<br />";
} else {
$explnum_liste_obj .= "<a href='" . $opac_url_base . $suite_url_explnum . "' alt='{$alt}' title='{$alt}' target='_blank'>" . $obj . "</a><br />";
}
}
}
if ($_mimetypes_byext_[$explnum->explnum_extfichier]["label"]) {
$explnummime_nom = $_mimetypes_byext_[$explnum->explnum_extfichier]["label"];
} elseif ($_mimetypes_bymimetype_[$explnum->explnum_mimetype]["label"]) {
$explnummime_nom = $_mimetypes_bymimetype_[$explnum->explnum_mimetype]["label"];
} else {
$explnummime_nom = $explnum->explnum_mimetype;
}
if ($tlink) {
$explnum_liste_obj .= "<a href='{$tlink}'>";
$explnum_liste_obj .= htmlentities($explnum->explnum_nom, ENT_QUOTES, $charset) . "</a><div class='explnum_type'>" . htmlentities($explnummime_nom, ENT_QUOTES, $charset) . "</div>";
} else {
$explnum_liste_obj .= htmlentities($explnum->explnum_nom, ENT_QUOTES, $charset) . "<div class='explnum_type'>" . htmlentities($explnummime_nom, ENT_QUOTES, $charset) . "</div>";
}
$explnum_liste_obj .= "</center>";
} else {
return "";
}
} else {
return "";
}
return $explnum_liste_obj;
}
/**
* Exécution du processus d'indexation
*/
function run_index()
{
if ($this->mimetype == 'URL') {
//récupération par cURL
$this->get_file_from_curl($this->file_url);
create_tableau_mimetype();
$this->mimetype = trouve_mimetype($this->fichier);
if (!$this->mimetype) {
//Test sur l'extension du fichier
$this->ext = extension_fichier($this->file_url);
$this->mimetype = trouve_mimetype($this->file_url, $this->ext);
}
if (!$this->mimetype && $this->explnum_nomfichier) {
//Test sur l'extension du fichier
$this->ext = extension_fichier($this->explnum_nomfichier);
$this->mimetype = trouve_mimetype($this->file_url, $this->ext);
}
if ($this->mimetype && !$this->ext) {
$this->ext = extension_fichier($this->file_url);
}
if ($this->mimetype && $this->explnum_nomfichier && !$this->ext) {
$this->ext = extension_fichier($this->explnum_nomfichier);
}
if (!$this->mimetype) {
$this->mimetype = "URL";
}
global $prefix_url_image;
if ($prefix_url_image) {
$tmpprefix_url_image = $prefix_url_image;
} else {
$tmpprefix_url_image = "./";
}
if ($tmp = construire_vignette('', "", $this->file_url)) {
$this->vignette = $tmp;
} else {
$this->vignette = construire_vignette('', $tmpprefix_url_image . "images/mimetype/" . icone_mimetype($this->mimetype, $this->ext));
}
} else {
//récupération dans la base
$this->get_file($this->file_content);
create_tableau_mimetype();
if (!$this->mimetype) {
$this->mimetype = trouve_mimetype($this->fichier);
}
if (!$this->mimetype && $this->explnum_nomfichier) {
//Test sur l'extension du fichier
$this->ext = extension_fichier($this->explnum_nomfichier);
$this->mimetype = trouve_mimetype($this->fichier, $this->ext);
}
}
if (file_exists($this->fichier)) {
//On parse le XML pour recupérer le nom de la classe
$this->parse_xml();
//On choisit la classe correspondant au traitement du type MIME
$this->choose_class($this->class_associee);
}
}
function get_file_from_temp($filename, $name, $upload_place)
{
global $base_path;
global $ck_index;
global $id_rep, $up_place;
$up_place = $upload_place;
create_tableau_mimetype();
$ck_index = true;
//Initialisation des tableaux d'infos
$this->infos_docnum = $this->params = array();
$this->infos_docnum["mime"] = trouve_mimetype($filename, extension_fichier($name));
$this->infos_docnum["nom"] = substr($name, 0, strrpos($name, "."));
if (!$this->infos_docnum["nom"]) {
$this->infos_docnum["nom"] = $name;
}
$this->infos_docnum["notice"] = $this->explnum_notice;
$this->infos_docnum["bull"] = $this->explnum_bulletin;
$this->infos_docnum["url"] = "";
$this->infos_docnum["fic"] = false;
$this->infos_docnum["contenu_vignette"] = construire_vignette('', substr($filename, strrpos($filename, "/")));
$this->infos_docnum["userfile_name"] = $name;
$this->infos_docnum["userfile_ext"] = extension_fichier($name);
if ($up_place && $id_rep != 0) {
$upfolder = new upload_folder($id_rep);
$chemin_hasher = "/";
if ($upfolder->isHashing()) {
$rep = $upfolder->hachage($this->infos_docnum["userfile_name"]);
@mkdir($rep);
$chemin_hasher = $upfolder->formate_path_to_nom($rep);
$file_name = $rep . $this->infos_docnum["userfile_name"];
$chemin = $upfolder->formate_path_to_save($chemin_hasher);
} else {
$file_name = $upfolder->get_path($this->infos_docnum["userfile_name"]) . $this->infos_docnum["userfile_name"];
$chemin = $upfolder->formate_path_to_save("/");
}
$this->infos_docnum["path"] = $chemin;
$file_name = $upfolder->encoder_chaine($file_name);
if (!$this->explnum_nomfichier) {
//Si je suis en création de fichier numérique
$nom_tmp = $this->infos_docnum["userfile_name"];
$continue = true;
$compte = 1;
do {
$query = "select explnum_notice,explnum_id from explnum where explnum_nomfichier = '" . addslashes($nom_tmp) . "' AND explnum_repertoire='" . $id_rep . "' AND explnum_path='" . addslashes($this->infos_docnum["path"]) . "'";
$result = mysql_query($query);
if (mysql_num_rows($result) && mysql_result($result, 0, 0) != $this->infos_docnum["notice"]) {
//Si j'ai déjà un document numérique avec ce fichier pour une autre notice je dois le renommer pour ne pas perdre l'ancien
if (preg_match("/^(.+)(\\..+)\$/i", $this->infos_docnum["userfile_name"], $matches)) {
$nom_tmp = $matches[1] . "_" . $compte . $matches[2];
} else {
$nom_tmp = $this->infos_docnum["userfile_name"] . "_" . $compte;
}
$compte++;
} else {
if (mysql_num_rows($result)) {
//J'ai déjà ce fichier pour cette notice
//Je dois enlever l'ancien document numérique pour ne pas l'avoir en double
$old_docnum = new explnum(mysql_result($result, 0, 1));
$old_docnum->delete();
} else {
}
$continue = false;
}
} while ($continue);
if ($compte != 1) {
$this->infos_docnum["userfile_name"] = $nom_tmp;
if ($upfolder->isHashing()) {
$file_name = $rep . $this->infos_docnum["userfile_name"];
} else {
$file_name = $upfolder->get_path($this->infos_docnum["userfile_name"]) . $this->infos_docnum["userfile_name"];
}
$file_name = $upfolder->encoder_chaine($file_name);
} else {
}
} else {
}
rename($filename, $file_name);
} else {
//enregistrement en base
$this->infos_docnum["contenu"] = file_get_contents($filename);
}
$this->params["maj_mimetype"] = true;
$this->params["maj_data"] = true;
$this->params["maj_vignette"] = true;
}
function show_explnum_per_notice($no_notice, $no_bulletin, $link_expl = '')
{
global $class_path;
require_once $class_path . "/auth_popup.class.php";
// params :
// $link_expl= lien associé à l'exemplaire avec !!explnum_id!! à mettre à jour
global $dbh, $msg, $charset;
global $opac_url_base;
global $opac_visionneuse_allow;
global $opac_photo_filtre_mimetype;
global $opac_explnum_order;
global $opac_show_links_invisible_docnums;
global $gestion_acces_active, $gestion_acces_empr_notice;
if (!$no_notice && !$no_bulletin) {
return "";
}
global $_mimetypes_bymimetype_, $_mimetypes_byext_;
create_tableau_mimetype();
// récupération du nombre d'exemplaires
$requete = "SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier FROM explnum WHERE ";
if ($no_notice && !$no_bulletin) {
$requete .= "explnum_notice='{$no_notice}' ";
} elseif (!$no_notice && $no_bulletin) {
$requete .= "explnum_bulletin='{$no_bulletin}' ";
} elseif ($no_notice && $no_bulletin) {
$requete .= "explnum_bulletin='{$no_bulletin}' or explnum_notice='{$no_notice}' ";
}
if ($opac_explnum_order) {
$requete .= " order by " . $opac_explnum_order;
} else {
$requete .= " order by explnum_mimetype, explnum_nom, explnum_id ";
}
$res = pmb_mysql_query($requete, $dbh);
$nb_ex = pmb_mysql_num_rows($res);
$docnum_visible = true;
$id_for_right = $no_notice;
if ($no_bulletin) {
$query = "select num_notice,bulletin_notice from bulletins where bulletin_id = " . $no_bulletin;
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$infos = pmb_mysql_fetch_object($result);
if ($infos->num_notice) {
$id_for_right = $infos->num_notice;
} else {
$id_for_right = $infos->bulletin_notice;
}
}
}
if ($gestion_acces_active == 1 && $gestion_acces_empr_notice == 1) {
$ac = new acces();
$dom_2 = $ac->setDomain(2);
$docnum_visible = $dom_2->getRights($_SESSION['id_empr_session'], $id_for_right, 16);
} else {
$requete = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM notices, notice_statut WHERE notice_id ='" . $id_for_right . "' and id_notice_statut=statut ";
$myQuery = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($myQuery)) {
$statut_temp = pmb_mysql_fetch_object($myQuery);
if (!$statut_temp->explnum_visible_opac) {
$docnum_visible = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$docnum_visible = false;
}
} else {
$docnum_visible = false;
}
}
//on peut appeller cette méthode sans avoir le droit de voir les documents...
if (!$docnum_visible && $opac_show_links_invisible_docnums) {
$auth_popup = new auth_popup();
}
if ($nb_ex) {
// on récupère les données des exemplaires
$i = 1;
global $search_terms;
while ($expl = pmb_mysql_fetch_object($res)) {
if ($i == 1) {
$ligne = "<tr><td class='docnum' width='33%'>!!1!!</td><td class='docnum' width='33%'>!!2!!</td><td class='docnum' width='33%'>!!3!!</td></tr>";
}
if ($link_expl) {
$tlink = str_replace("!!explnum_id!!", $expl->explnum_id, $link_expl);
$tlink = str_replace("!!notice_id!!", $expl->explnum_notice, $tlink);
$tlink = str_replace("!!bulletin_id!!", $expl->explnum_bulletin, $tlink);
}
$alt = htmlentities($expl->explnum_nom . " - " . $expl->explnum_mimetype, ENT_QUOTES, $charset);
if ($expl->explnum_vignette) {
$obj = "<img src='" . $opac_url_base . "vig_num.php?explnum_id={$expl->explnum_id}' alt='{$alt}' title='{$alt}' border='0'>";
} else {
// trouver l'icone correspondant au mime_type
$obj = "<img src='" . $opac_url_base . "images/mimetype/" . icone_mimetype($expl->explnum_mimetype, $expl->explnum_extfichier) . "' alt='{$alt}' title='{$alt}' border='0'>";
}
$expl_liste_obj = "<center>";
$words_to_find = "";
if ($expl->explnum_mimetype == 'application/pdf' || $expl->explnum_mimetype == 'URL' && strpos($expl->explnum_nom, '.pdf') !== false) {
if (is_array($search_terms)) {
$words_to_find = "#search=\"" . trim(str_replace('*', '', implode(' ', $search_terms))) . "\"";
}
}
//si l'affichage du lien vers les documents numériques est forcé et qu'on est pas connecté, on propose l'invite de connexion!
if (!$docnum_visible && !$_SESSION['user_code'] && $opac_show_links_invisible_docnums) {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($expl->explnum_mimetype, $allowed_mimetype)) {
$link = "\r\n\t\t\t\t\t\t\t<script type='text/javascript'>\r\n\t\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\r\n\t\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\r\n\t\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\r\n\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\tfunction sendToVisionneuse_" . $expl->explnum_id . "(){\r\n\t\t\t\t\t\t\t\t\topen_visionneuse(sendToVisionneuse," . $expl->explnum_id . ");\r\n\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t</script>\r\n\t\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&callback_func=sendToVisionneuse_" . $expl->explnum_id . "');\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$expl_liste_obj .= $link;
} else {
$link = "\r\n\t\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&new_tab=1&callback_url=" . rawurlencode($opac_url_base . "doc_num.php?explnum_id=" . $expl->explnum_id) . "')\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$expl_liste_obj .= $link;
}
} else {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($expl->explnum_mimetype, $allowed_mimetype)) {
$link = "\r\n\t\t\t\t\t\t\t<script type='text/javascript'>\r\n\t\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\r\n\t\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\r\n\t\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\r\n\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t</script>\r\n\t\t\t\t\t\t\t<a href='#' onclick=\"open_visionneuse(sendToVisionneuse," . $expl->explnum_id . ");return false;\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$expl_liste_obj .= $link;
$suite_url_explnum = "doc_num.php?explnum_id={$expl->explnum_id}";
$expl_liste_obj .= "<a href='" . $opac_url_base . $suite_url_explnum . "' alt='{$alt}' title='{$alt}' target='_blank'>" . htmlentities($msg['download'], ENT_QUOTES, $charset) . "</a><br />";
} else {
$suite_url_explnum = "doc_num.php?explnum_id={$expl->explnum_id}";
$expl_liste_obj .= "<a href='" . $opac_url_base . $suite_url_explnum . "' alt='{$alt}' title='{$alt}' target='_blank'>" . $obj . "</a><br />";
}
}
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;
}
if ($tlink) {
$expl_liste_obj .= "<a href='{$tlink}'>";
$expl_liste_obj .= htmlentities($expl->explnum_nom, ENT_QUOTES, $charset) . "</a><div class='explnum_type'>" . htmlentities($explmime_nom, ENT_QUOTES, $charset) . "</div>";
} else {
$expl_liste_obj .= htmlentities($expl->explnum_nom, ENT_QUOTES, $charset) . "<div class='explnum_type'>" . htmlentities($explmime_nom, ENT_QUOTES, $charset) . "</div>";
}
$expl_liste_obj .= "</center>";
$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);
} else {
return "";
}
$entry .= "<table class='docnum'>{$ligne_finale}</table>";
return $entry;
}
/**
* Retourne les infos de documents numériques associés à la notice
* @return array
*/
public function get_explnums_datas()
{
if (!isset($this->explnums_datas)) {
global $dbh;
global $charset;
global $opac_url_base;
global $opac_visionneuse_allow;
global $opac_photo_filtre_mimetype;
global $opac_explnum_order;
global $opac_show_links_invisible_docnums;
global $gestion_acces_active, $gestion_acces_empr_notice, $gestion_acces_empr_docnum;
$this->explnums_datas = array('nb_explnums' => 0, 'explnums' => array(), 'visionneuse_script' => '
<script type="text/javascript">
if(typeof(sendToVisionneuse) == "undefined"){
var sendToVisionneuse = function (explnum_id){
document.getElementById("visionneuseIframe").src = "visionneuse.php?"+(typeof(explnum_id) != "undefined" ? "explnum_id="+explnum_id : "");
}
}
</script>');
global $_mimetypes_bymimetype_, $_mimetypes_byext_;
if (!count($_mimetypes_bymimetype_)) {
create_tableau_mimetype();
}
$this->get_bul_info();
// récupération du nombre d'exemplaires
$query = "SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier, explnum_docnum_statut FROM explnum WHERE ";
if ($this->get_niveau_biblio() != 'b') {
$query .= "explnum_notice='" . $this->id . "' ";
} else {
$query .= "explnum_bulletin='" . $this->parent['bulletin_id'] . "' or explnum_notice='" . $this->id . "' ";
}
$query .= "union SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier, explnum_docnum_statut\n\t\t\tFROM explnum, bulletins\n\t\t\tWHERE bulletin_id = explnum_bulletin\n\t\t\tAND bulletins.num_notice='" . $this->id . "'";
if ($opac_explnum_order) {
$query .= " order by " . $opac_explnum_order;
} else {
$query .= " order by explnum_mimetype, explnum_nom, explnum_id ";
}
$res = pmb_mysql_query($query, $dbh);
$nb_explnums = pmb_mysql_num_rows($res);
$docnum_visible = true;
if ($gestion_acces_active == 1 && $gestion_acces_empr_notice == 1) {
$docnum_visible = $this->dom_2->getRights($_SESSION['id_empr_session'], $this->id, 16);
} else {
$query = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM notices, notice_statut WHERE notice_id ='" . $this->id . "' and id_notice_statut=statut ";
$result = pmb_mysql_query($query, $dbh);
if ($result && pmb_mysql_num_rows($result)) {
$statut_temp = pmb_mysql_fetch_object($result);
if (!$statut_temp->explnum_visible_opac) {
$docnum_visible = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$docnum_visible = false;
}
} else {
$docnum_visible = false;
}
}
if ($nb_explnums && ($docnum_visible || $opac_show_links_invisible_docnums)) {
// on récupère les données des exemplaires
global $search_terms;
while ($expl = pmb_mysql_fetch_object($res)) {
// couleur de l'img en fonction du statut
if ($expl->explnum_docnum_statut) {
$rqt_st = "SELECT * FROM explnum_statut WHERE id_explnum_statut='" . $expl->explnum_docnum_statut . "' ";
$Query_statut = pmb_mysql_query($rqt_st, $dbh) or die($rqt_st . " " . pmb_mysql_error());
$r_statut = pmb_mysql_fetch_object($Query_statut);
$explnum_class = 'docnum_' . $r_statut->class_html;
if ($expl->explnum_docnum_statut > 1) {
$explnum_opac_label = $r_statut->opac_libelle;
} else {
$explnum_opac_label = '';
}
} else {
$explnum_class = 'docnum_statutnot1';
$explnum_opac_label = '';
}
$explnum_docnum_visible = true;
$explnum_docnum_consult = true;
if ($gestion_acces_active == 1 && $gestion_acces_empr_docnum == 1) {
$explnum_docnum_visible = $this->dom_3->getRights($_SESSION['id_empr_session'], $expl->explnum_id, 16);
$explnum_docnum_consult = $this->dom_3->getRights($_SESSION['id_empr_session'], $expl->explnum_id, 4);
} else {
$requete = "SELECT explnum_visible_opac, explnum_visible_opac_abon, explnum_consult_opac, explnum_consult_opac_abon FROM explnum, explnum_statut WHERE explnum_id ='" . $expl->explnum_id . "' and id_explnum_statut=explnum_docnum_statut ";
$myQuery = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($myQuery)) {
$statut_temp = pmb_mysql_fetch_object($myQuery);
if (!$statut_temp->explnum_visible_opac) {
$explnum_docnum_visible = false;
}
if (!$statut_temp->explnum_consult_opac) {
$explnum_docnum_consult = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$explnum_docnum_visible = false;
}
if ($statut_temp->explnum_consult_opac_abon && !$_SESSION['id_empr_session']) {
$explnum_docnum_consult = false;
}
} else {
$explnum_docnum_visible = false;
}
}
if ($explnum_docnum_visible || $opac_show_links_invisible_docnums) {
$this->explnums_datas['nb_explnums']++;
$explnum_datas = array('id' => $expl->explnum_id, 'name' => $expl->explnum_nom, 'mimetype' => $expl->explnum_mimetype, 'url' => $expl->explnum_url, 'filename' => $expl->explnum_nomfichier, 'extension' => $expl->explnum_extfichier, 'statut' => $expl->explnum_docnum_statut, 'consultation' => $explnum_docnum_consult);
if ($expl->explnum_vignette) {
$explnum_datas['thumbnail_url'] = $opac_url_base . 'vig_num.php?explnum_id=' . $expl->explnum_id;
} else {
// trouver l'icone correspondant au mime_type
$explnum_datas['thumbnail_url'] = get_url_icon('mimetype/' . icone_mimetype($expl->explnum_mimetype, $expl->explnum_extfichier), 1);
}
$words_to_find = "";
if ($expl->explnum_mimetype == 'application/pdf' || $expl->explnum_mimetype == 'URL' && strpos($expl->explnum_nom, '.pdf') !== false) {
if (is_array($search_terms)) {
$words_to_find = "#search=\"" . trim(str_replace('*', '', implode(' ', $search_terms))) . "\"";
}
}
$explnum_datas['access_datas'] = array('script' => '', 'href' => '#', 'onclick' => '');
//si l'affichage du lien vers les documents numériques est forcé et qu'on est pas connecté, on propose l'invite de connexion!
if (!$explnum_docnum_visible && $opac_show_links_invisible_docnums && !$_SESSION['id_empr_session']) {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($expl->explnum_mimetype, $allowed_mimetype)) {
$explnum_datas['access_datas']['script'] = "\n\t\t\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\t\t\tfunction sendToVisionneuse_" . $expl->explnum_id . "(){\n\t\t\t\t\t\t\t\t\t\topen_visionneuse(sendToVisionneuse," . $expl->explnum_id . ");\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t</script>";
$explnum_datas['access_datas']['onclick'] = "auth_popup('./ajax.php?module=ajax&categ=auth&callback_func=sendToVisionneuse_" . $expl->explnum_id . "');";
} else {
$explnum_datas['access_datas']['onclick'] = "auth_popup('./ajax.php?module=ajax&categ=auth&new_tab=1&callback_url=" . rawurlencode($opac_url_base . "doc_num.php?explnum_id=" . $expl->explnum_id) . "')";
}
} else {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($expl->explnum_mimetype, $allowed_mimetype)) {
$explnum_datas['access_datas']['onclick'] = "open_visionneuse(sendToVisionneuse," . $expl->explnum_id . ");return false;";
} else {
$explnum_datas['access_datas']['href'] = $opac_url_base . 'doc_num.php?explnum_id=' . $expl->explnum_id;
}
}
if ($_mimetypes_byext_[$expl->explnum_extfichier]["label"]) {
$explnum_datas['mimetype_label'] = $_mimetypes_byext_[$expl->explnum_extfichier]["label"];
} elseif ($_mimetypes_bymimetype_[$expl->explnum_mimetype]["label"]) {
$explnum_datas['mimetype_label'] = $_mimetypes_bymimetype_[$expl->explnum_mimetype]["label"];
} else {
$explnum_datas['mimetype_label'] = $expl->explnum_mimetype;
}
$this->explnums_datas['explnums'][] = $explnum_datas;
}
}
}
}
return $this->explnums_datas;
}
/**
* Fonction retournant les infos d'exemplaires numériques pour une notice ou un bulletin donné
* @param int $explnum_id Identifiant du document numérique
* @return string
*/
function show_explnum_per_id($explnum_id, $link_explnum = "")
{
global $dbh;
global $charset;
global $opac_url_base;
global $opac_visionneuse_allow;
global $opac_photo_filtre_mimetype;
global $opac_explnum_order;
global $opac_show_links_invisible_docnums;
global $gestion_acces_active, $gestion_acces_empr_notice;
global $search_terms;
if (!$explnum_id) {
return "";
}
global $_mimetypes_bymimetype_, $_mimetypes_byext_;
create_tableau_mimetype();
// récupération des infos du document
$query = "select explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier FROM explnum WHERE explnum_id = " . $explnum_id;
$result = mysql_query($query, $dbh);
if ($result && mysql_num_rows($result)) {
if ($explnum = mysql_fetch_object($result)) {
$docnum_visible = true;
$id_for_right = $explnum->explnum_notice;
if ($gestion_acces_active == 1 && $gestion_acces_empr_notice == 1) {
$ac = new acces();
$dom_2 = $ac->setDomain(2);
$docnum_visible = $dom_2->getRights($_SESSION['id_empr_session'], $id_for_right, 16);
} else {
$requete = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM notices, notice_statut WHERE notice_id ='" . $id_for_right . "' and id_notice_statut=statut ";
$myQuery = mysql_query($requete, $dbh);
if (mysql_num_rows($myQuery)) {
$statut_temp = mysql_fetch_object($myQuery);
if (!$statut_temp->explnum_visible_opac) {
$docnum_visible = false;
}
if ($statut_temp->explnum_visible_opac_abon && !$_SESSION['id_empr_session']) {
$docnum_visible = false;
}
} else {
$docnum_visible = false;
}
}
//on peut appeller cette méthode sans avoir le droit de voir les documents...
if (!$docnum_visible && $opac_show_links_invisible_docnums) {
$auth_popup = new auth_popup();
}
if ($link_explnum) {
$tlink = str_replace("!!explnum_id!!", $explnum->explnum_id, $link_explnum);
$tlink = str_replace("!!notice_id!!", $explnum->explnum_notice, $tlink);
$tlink = str_replace("!!bulletin_id!!", $explnum->explnum_bulletin, $tlink);
}
$alt = htmlentities($explnum->explnum_nom . " - " . $explnum->explnum_mimetype, ENT_QUOTES, $charset);
if ($explnum->explnum_vignette) {
$obj = "<img src='" . $opac_url_base . "vig_num.php?explnum_id={$explnum->explnum_id}' alt='{$alt}' title='{$alt}' border='0'>";
} else {
// trouver l'icone correspondant au mime_type
$obj = "<img src='" . $opac_url_base . "images/mimetype/" . icone_mimetype($explnum->explnum_mimetype, $explnum->explnum_extfichier) . "' alt='{$alt}' title='{$alt}' border='0'>";
}
$explnum_liste_obj = "<center>";
$words_to_find = "";
if ($explnum->explnum_mimetype == 'application/pdf' || $explnum->explnum_mimetype == 'URL' && strpos($explnum->explnum_nom, '.pdf') !== false) {
if (is_array($search_terms)) {
$words_to_find = "#search=\"" . trim(str_replace('*', '', implode(' ', $search_terms))) . "\"";
}
}
//si l'affichage du lien vers les documents numériques est forcé et qu'on est pas connecté, on propose l'invite de connexion!
if (!$docnum_visible && !$_SESSION['user_code'] && $opac_show_links_invisible_docnums) {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($explnum->explnum_mimetype, $allowed_mimetype)) {
$link = "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\n\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\n\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\tfunction sendToVisionneuse_" . $explnum->explnum_id . "(){\n\t\t\t\t\t\t\t\topen_visionneuse(sendToVisionneuse," . $explnum->explnum_id . ");\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&callback_func=sendToVisionneuse_" . $explnum->explnum_id . "');\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
} else {
$link = "\n\t\t\t\t\t\t<a href='#' onclick=\"auth_popup('./ajax.php?module=ajax&categ=auth&new_tab=1&callback_url=" . rawurlencode($opac_url_base . "doc_num.php?explnum_id=" . $explnum->explnum_id) . "')\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
}
} else {
if ($opac_visionneuse_allow) {
$allowed_mimetype = explode(",", str_replace("'", "", $opac_photo_filtre_mimetype));
}
if ($allowed_mimetype && in_array($explnum->explnum_mimetype, $allowed_mimetype)) {
$link = "\n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\tif(typeof(sendToVisionneuse) == 'undefined'){\n\t\t\t\t\t\t\t\tvar sendToVisionneuse = function (explnum_id){\n\t\t\t\t\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?'+(typeof(explnum_id) != 'undefined' ? 'explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t<a href='#' onclick=\"open_visionneuse(sendToVisionneuse," . $explnum->explnum_id . ");return false;\" alt='{$alt}' title='{$alt}'>" . $obj . "</a><br />";
$explnum_liste_obj .= $link;
} else {
$suite_url_explnum = "doc_num.php?explnum_id={$explnum->explnum_id}";
$explnum_liste_obj .= "<a href='" . $opac_url_base . $suite_url_explnum . "' alt='{$alt}' title='{$alt}' target='_blank'>" . $obj . "</a><br />";
}
}
if ($_mimetypes_byext_[$explnum->explnum_extfichier]["label"]) {
$explnummime_nom = $_mimetypes_byext_[$explnum->explnum_extfichier]["label"];
} elseif ($_mimetypes_bymimetype_[$explnum->explnum_mimetype]["label"]) {
$explnummime_nom = $_mimetypes_bymimetype_[$explnum->explnum_mimetype]["label"];
} else {
$explnummime_nom = $explnum->explnum_mimetype;
}
if ($tlink) {
$explnum_liste_obj .= "<a href='{$tlink}'>";
$explnum_liste_obj .= htmlentities($explnum->explnum_nom, ENT_QUOTES, $charset) . "</a><div class='explnum_type'>" . htmlentities($explnummime_nom, ENT_QUOTES, $charset) . "</div>";
} else {
$explnum_liste_obj .= htmlentities($explnum->explnum_nom, ENT_QUOTES, $charset) . "<div class='explnum_type'>" . htmlentities($explnummime_nom, ENT_QUOTES, $charset) . "</div>";
}
$explnum_liste_obj .= "</center>";
} else {
return "";
}
} else {
return "";
}
return $explnum_liste_obj;
}
function show_explnum_in_relation($no_notice, $link_expl = '', $param_aff = array())
{
global $dbh;
global $charset;
global $base_path, $msg;
global $_mimetypes_bymimetype_, $_mimetypes_byext_;
global $prefix_url_image;
if (!$no_notice) {
return "";
}
create_tableau_mimetype();
// recuperation du nombre d'exemplaires
$requete = "SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_vignette, explnum_nomfichier, explnum_extfichier, explnum_docnum_statut\n\t\t\tFROM explnum \n\t\t\tJOIN index_concept on index_concept.num_object = explnum_id AND index_concept.type_object=11\n\t\t\tJOIN vedette_link on vedette_link.num_object=index_concept.num_concept AND vedette_link.type_object=1\n\t\t\tJOIN vedette_object on vedette_object.num_vedette=vedette_link.num_vedette AND vedette_object.object_type=10 and vedette_object.object_id='{$no_notice}'\n\t\t\tORDER BY explnum_mimetype, explnum_id ";
$res = pmb_mysql_query($requete, $dbh) or die($requete . " " . pmb_mysql_error());
$nb_ex = pmb_mysql_num_rows($res);
if ($nb_ex) {
// on recupere les donnees des exemplaires
$i = 1;
while ($expl = pmb_mysql_fetch_object($res)) {
// couleur de l'img en fonction du statut
if ($expl->explnum_docnum_statut) {
$rqt_st = "SELECT * FROM explnum_statut WHERE id_explnum_statut='" . $expl->explnum_docnum_statut . "' ";
$Query_statut = pmb_mysql_query($rqt_st, $dbh) or die($rqt_st . " " . pmb_mysql_error());
$r_statut = pmb_mysql_fetch_object($Query_statut);
$class_img = " class='docnum_" . $r_statut->class_html . "' ";
if ($expl->explnum_docnum_statut > 1) {
$txt = $r_statut->opac_libelle;
} else {
$txt = "";
}
$statut_libelle_div = "\n\t\t\t\t\t<div id='zoom_statut_docnum" . $expl->explnum_id . "' style='border: 2px solid rgb(85, 85, 85); background-color: rgb(255, 255, 255); position: absolute; z-index: 2000; display: none;'>\n\t\t\t\t\t<b>{$txt}</b>\n\t\t\t\t\t</div>\n\t\t\t\t\t";
} else {
$class_img = " class='docnum_statutnot1' ";
$txt = "";
}
if ($i == 1) {
$ligne = "<tr><td class='docnum' width='25%'>!!1!!</td><td class='docnum' width='25%'>!!2!!</td><td class='docnum' width='25%'>!!3!!</td><td class='docnum' width='25%'>!!4!!</td></tr>";
}
if ($link_expl) {
$tlink = str_replace("!!explnum_id!!", $expl->explnum_id, $link_expl);
$tlink = str_replace("!!notice_id!!", $expl->explnum_notice, $tlink);
$tlink = str_replace("!!bulletin_id!!", $expl->explnum_bulletin, $tlink);
}
$alt = htmlentities($expl->explnum_nom . " - " . $expl->explnum_mimetype, ENT_QUOTES, $charset);
if ($prefix_url_image) {
$tmpprefix_url_image = $prefix_url_image;
} else {
$tmpprefix_url_image = "./";
}
if ($expl->explnum_vignette) {
$obj = "<img src='" . $tmpprefix_url_image . "vig_num.php?explnum_id={$expl->explnum_id}' alt='{$alt}' title='{$alt}' border='0'>";
} else {
// trouver l'icone correspondant au mime_type
$obj = "<img src='" . $tmpprefix_url_image . "images/mimetype/" . icone_mimetype($expl->explnum_mimetype, $expl->explnum_extfichier) . "' alt='{$alt}' title='{$alt}' border='0'>";
}
$obj_suite = "{$statut_libelle_div}\n\t\t\t<a href='#' onmouseout=\"z=document.getElementById('zoom_statut_docnum" . $expl->explnum_id . "'); z.style.display='none'; \" onmouseover=\"z=document.getElementById('zoom_statut_docnum" . $expl->explnum_id . "'); z.style.display=''; \">\n\t\t\t<div class='vignette_doc_num' ><img {$class_img} width='10' height='10' src='./images/spacer.gif'></div>\n\t\t\t</a>\n\t\t\t";
$expl_liste_obj = "<center>";
$expl_liste_obj .= "<a href='" . $tmpprefix_url_image . "doc_num.php?explnum_id={$expl->explnum_id}' alt='{$alt}' title='{$alt}' target='_blank'>" . $obj . "</a>{$obj_suite}<br />";
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;
}
if ($param_aff["mine_type"]) {
$explmime_nom = "";
}
if ($tlink) {
$expl_liste_obj .= "<a href='{$tlink}'>";
$expl_liste_obj .= htmlentities($expl->explnum_nom, ENT_QUOTES, $charset) . "</a><div class='explnum_type'>" . htmlentities($explmime_nom, ENT_QUOTES, $charset) . "</div>";
} else {
$expl_liste_obj .= htmlentities($expl->explnum_nom, ENT_QUOTES, $charset) . "<div class='explnum_type'>" . htmlentities($explmime_nom, ENT_QUOTES, $charset) . "</div>";
}
//recherche des concepts...
$query = "select num_concept,value from index_concept join skos_fields_global_index on num_concept = id_item and code_champ = 1 where num_object = " . $expl->explnum_id . " and type_object = 11 order by order_concept";
$result = pmb_mysql_query($query, $dbh);
$concept = "";
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
if ($concept) {
$concept .= " / ";
}
if (SESSrights & AUTORITES_AUTH) {
$concept .= "<a href='" . $base_path . "/autorites.php?categ=see&sub=concept&id=" . $row->num_concept . "' title='" . addslashes($msg['concept_menu'] . ": " . htmlentities($row->value, ENT_QUOTES, $charset)) . "'>" . htmlentities($row->value, ENT_QUOTES, $charset) . "</a>";
} else {
$concept .= "<span title='" . addslashes($msg['concept_menu'] . ": " . htmlentities($row->value, ENT_QUOTES, $charset)) . "'>" . htmlentities($row->value, ENT_QUOTES, $charset) . "</span>";
}
}
}
$expl_liste_obj .= $concept . "</center>";
$ligne = str_replace("!!{$i}!!", $expl_liste_obj, $ligne);
$i++;
if ($i == 5) {
$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);
$ligne_finale = str_replace('!!4!!', " ", $ligne_finale);
} else {
return "";
}
$entry .= "<table class='docnum'>{$ligne_finale}</table>";
return $entry;
}
function do_explnum($no_notice)
{
global $dbh;
global $charset;
global $opac_url_base;
if (!$no_notice) {
return "";
}
if (!$charset) {
$charset = 'ISO-8859-1';
}
create_tableau_mimetype();
// recuperation du nombre d'exemplaires
$requete = "SELECT explnum_id, explnum_notice, explnum_nom, explnum_mimetype, explnum_url, length(explnum_data) as taille ";
$requete .= "FROM explnum join explnum_statut on id_explnum_statut = explnum_docnum_statut where explnum_visible_opac=1 and explnum_visible_opac_abon=0 ";
$requete .= "AND explnum_notice in (SELECT notice_id FROM notices join notice_statut on statut=id_notice_statut ";
$requete .= "WHERE explnum_notice=" . $no_notice . " and explnum_visible_opac=1 and explnum_visible_opac_abon=0) ";
$requete .= "ORDER BY explnum_mimetype, explnum_id ";
$res = pmb_mysql_query($requete, $dbh);
$retour = "";
while ($expl = pmb_mysql_fetch_object($res)) {
$url = htmlspecialchars($opac_url_base . "doc_num.php?explnum_id=" . $expl->explnum_id, ENT_QUOTES, $charset);
$mime = htmlspecialchars($expl->explnum_mimetype, ENT_QUOTES, $charset);
$retour .= "<enclosure url=\"" . $url . "\" type=\"" . $mime . "\" length=\"" . $expl->taille . "\" />";
}
return $retour;
}
if ($css == "") {
$css = 1;
}
// récupération paramètres MySQL et connection á la base
require_once $base_path . '/includes/opac_db_param.inc.php';
require_once $base_path . '/includes/opac_mysql_connect.inc.php';
$dbh = connection_mysql();
require_once $base_path . '/includes/start.inc.php';
require_once $base_path . "/includes/check_session_time.inc.php";
// récupération localisation
require_once $base_path . '/includes/localisation.inc.php';
// version actuelle de l'opac
require_once $base_path . '/includes/opac_version.inc.php';
require_once $include_path . "/explnum.inc.php";
$resultat = mysql_query("SELECT explnum_id, explnum_mimetype, explnum_vignette,explnum_extfichier FROM explnum WHERE explnum_id = '{$explnum_id}' ", $dbh);
$nb_res = mysql_num_rows($resultat);
if (!$nb_res) {
exit;
}
$ligne = mysql_fetch_object($resultat);
if ($ligne->explnum_vignette) {
print $ligne->explnum_vignette;
exit;
} else {
create_tableau_mimetype();
$iconname = icone_mimetype($ligne->explnum_mimetype, $ligne->explnum_extfichier);
$fp = fopen("./images/mimetype/{$iconname}", "r");
$contenu_vignette = fread($fp, filesize("./images/mimetype/{$iconname}"));
fclose($fp);
print $contenu_vignette;
}
function get_notice_by_meta($name, $filename)
{
global $pmb_keyword_sep;
global $pmb_type_audit;
global $webdav_current_user_name, $webdav_current_user_id;
\create_tableau_mimetype();
$mimetype = \trouve_mimetype($filename, extension_fichier($name));
$notice_id = 0;
$title = $cplt = $code = $pages = $year = $keywords = $url = $thumbnail_content = "";
//on commence avec la gymnatisque des métas...
if ($mimetype == "application/epub+zip") {
//pour les ebook, on gère ca directement ici !
$epub = new \epubData(realpath($filename));
$title = $epub->metas['title'][0];
$authors = $epub->metas['creator'];
$co_authors = $epub->metas['contributor'];
if ($epub->metas['identifier']['isbn']) {
$code = \formatISBN($epub->metas['identifier']['isbn'], 13);
} else {
if ($epub->metas['identifier']['ean']) {
$code = \EANtoISBN($epub->metas['identifier']['ean']);
$code = \formatISBN($code, 13);
}
}
if ($epub->metas['identifier']['uri']) {
$url = \clean_string($epub->metas['identifier']['uri']);
}
$publisher = $epub->metas['publisher'][0];
$year = $epub->metas['date'][0]['value'];
if (strlen($year) && strlen($year) != 4) {
$year = \formatdate(detectFormatDate($year));
}
$lang = $epub->metas['language'];
$resume = implode("\n", $epub->metas['description']);
$keywords = implode($pmb_keyword_sep, $epub->metas['subject']);
//jouons à et si on trouvait a vignette...
$img = imagecreatefromstring($epub->getCoverContent());
$file = tempnam(sys_get_temp_dir(), "vign");
imagepng($img, $file);
$thumbnail_content = file_get_contents($file);
unlink($file);
} else {
$metas = \extract_metas(realpath($filename), $mimetype);
if ($metas['Title'] && $metas['Author'] && $metas['Subject']) {
$title = $metas['Title'];
$author = $metas['Author'];
$cplt = $metas['Subject'];
} else {
// métas non fiable, on regarde avec le titre...
$title = $name;
}
//date de création...
if ($metas["CreateDate"]) {
$year = substr($metas["CreateDate"], 0, 4);
}
//pages
if ($metas['PageCount']) {
$pages = $metas['PageCount'];
}
//keywords
if ($metas['Keywords']) {
foreach ($metas['Keywords'] as $keyword) {
if ($keywords != "") {
$keywords .= $pmb_keyword_sep;
}
$keywords .= $keyword;
}
}
}
$query = "select notice_id from notices where tit1 = '" . addslashes($title) . "'";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
$notice_id = mysql_result($result, 0, 0);
}
if (!$notice_id) {
//en cas d'une leture moyenne des infos, on s'assure d'avoir au moins un titre....
if (!$title) {
$title = $name;
}
if ($publisher) {
$ed_1 = \editeur::import(array('name' => $publisher));
} else {
$ed_1 = 0;
}
$ind_wew = $title . " " . $cplt;
$ind_sew = \strip_empty_words($ind_wew);
$query = "insert into notices set \n\t\t\t\ttit1 = '" . addslashes($title) . "'," . ($code ? "code='" . $code . "'," : "") . "ed1_id = '" . $ed_1 . "'," . ($cplt ? "tit4 = '" . addslashes($cplt) . "'," : "") . ($pages ? "npages = '" . addslashes($pages) . "'," : "") . ($keywords ? "index_l = '" . addslashes($keywords) . "'," : "") . "\n\t\t\t\tyear = '" . $year . "',\n\t\t\t\tniveau_biblio='m', \n\t\t\t\tniveau_hierar='0',\n\t\t\t\tstatut = '" . $this->config['default_statut'] . "',\n\t\t\t\tindex_wew = '" . $ind_wew . "',\n\t\t\t\tindex_sew = '" . $ind_sew . "',\n\t\t\t\tn_resume = '" . addslashes($resume) . "',\n\t\t\t\tlien = '" . addslashes($url) . "',\n\t\t\t\tindex_n_resume = '" . \strip_empty_words($resume) . "'," . ($thumbnail_content ? "thumbnail_url = 'data:image/png;base64," . base64_encode($thumbnail_content) . "'," : "") . "create_date = sysdate(), \n\t\t\t\tupdate_date = sysdate()";
mysql_query($query);
$notice_id = mysql_insert_id();
$sign = new \notice_doublon();
mysql_query("update notices set signature = '" . $sign->gen_signature($notice_id) . "' where notice_id = " . $notice_id);
//traitement audit
if ($pmb_type_audit) {
$query = "INSERT INTO audit SET ";
$query .= "type_obj='1', ";
$query .= "object_id='{$notice_id}', ";
$query .= "user_id='{$webdav_current_user_id}', ";
$query .= "user_name='{$webdav_current_user_name}', ";
$query .= "type_modif=1 ";
$result = @mysql_query($query);
}
if (count($authors)) {
$i = 0;
foreach ($authors as $author) {
$aut = array();
if ($author['file-as']) {
$infos = explode(",", $author['file-as']);
$aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70);
}
if (!$aut['name']) {
$aut = array('name' => $author['value'], 'type' => 70);
}
$aut_id = \auteur::import($aut);
if ($aut_id) {
$query = "insert into responsability set \n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0'";
mysql_query($query);
$i++;
}
}
}
if (count($co_authors)) {
foreach ($co_authors as $author) {
$aut = array();
if ($author['file-as']) {
$infos = explode(",", $author['file-as']);
$aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70);
}
if (!$aut['name']) {
$aut = array('name' => $author['value'], 'type' => 70);
}
$aut_id = \auteur::import($aut);
if ($aut_id) {
$query = "insert into responsability set \n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0',\n\t\t\t\t\t\t\trepsonsability_ordre = '" . $i . "'";
mysql_query($query);
$i++;
}
}
}
}
return $notice_id;
}
