$reserver = "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_notice=" . $this->notice_id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$reserver = "<a href='./do_resa.php?lvl=resa&id_notice=" . $this->notice_id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$reservernbre = $message_nbresa;
} else {
$ret_resa = "";
}
print pmb_bidi($ret_resa);
}
}
if ($opac_show_exemplaires) {
if ($fonction == 'notice_affichage_custom_bretagne') {
print pmb_bidi(notice_affichage_custom_bretagne::expl_list("m", 0, $id));
} else {
print pmb_bidi(notice_affichage::expl_list("m", 0, $id));
}
}
}
if ($docnum_visible || $opac_show_links_invisible_docnums) {
if ($explnum = show_explnum_per_notice(0, $id, '')) {
print pmb_bidi("<a name='docnum'><h3>" . $msg["explnum"] . "</h3></a>" . $explnum);
}
}
}
print notice_affichage::autres_lectures(0, $id);
}
}
}
mysql_free_result($resdep);
function do_carroussel($bull)
function bulletin_affichage($id, $type = "")
{
global $dbh, $msg;
global $opac_show_exemplaires;
$display = "";
$requete = "SELECT bulletin_id, bulletin_numero, bulletin_notice, mention_date, date_date, bulletin_titre, bulletin_cb, date_format(date_date, '" . $msg["format_date_sql"] . "') as aff_date_date,num_notice FROM bulletins WHERE bulletin_id='{$id}'";
$res = @pmb_mysql_query($requete, $dbh);
while ($obj = pmb_mysql_fetch_array($res)) {
$requete3 = "SELECT notice_id FROM notices WHERE notice_id='" . $obj["bulletin_notice"] . "' ";
$res3 = @pmb_mysql_query($requete3, $dbh);
while ($obj3 = pmb_mysql_fetch_object($res3)) {
$notice3 = new notice($obj3->notice_id);
}
$notice3->fetch_visibilite();
//on vient poser l'ancre des docnums...
$req = "select explnum_id from explnum where explnum_bulletin = " . $obj["bulletin_id"];
$resultat = pmb_mysql_query($req, $dbh) or die($req . " " . pmb_mysql_error());
$nb_ex = pmb_mysql_num_rows($resultat);
$res_print = "<h3><img src=./images/icon_per.gif> " . $notice3->print_resume(1, $css) . "." . " <b>" . $obj["bulletin_numero"] . "</b>" . ($nb_ex ? " <a href='#docnum'>" . ($nb_ex > 1 ? "<img src='" . get_url_icon("globe_rouge.png") . "' />" : "<img src='" . get_url_icon("globe_orange.png") . "' />") . "</a>" : "") . "</h3>\n";
$num_notice = $obj['num_notice'];
if ($obj['bulletin_titre']) {
$res_print .= htmlentities($obj['bulletin_titre'], ENT_QUOTES, $charset) . "<br />";
}
if ($obj['mention_date']) {
$res_print .= $msg['bull_mention_date'] . " " . $obj['mention_date'] . "\n";
}
if ($obj['date_date']) {
$res_print .= "<br />" . $msg['bull_date_date'] . " " . $obj['aff_date_date'] . " \n";
}
if ($type != "visionneuse" && $nb_ex) {
$res_print .= "<br /><a href='#docnum'>" . ($nb_ex > 1 ? "<img src='" . get_url_icon("globe_rouge.png") . "' />" : "<img src='" . get_url_icon("globe_orange.png") . "' />") . "</a>";
}
if ($obj['bulletin_cb']) {
$res_print .= "<br />" . $msg["code_start"] . " " . htmlentities($obj['bulletin_cb'], ENT_QUOTES, $charset) . "\n";
$code_cb_bulletin = $obj['bulletin_cb'];
}
}
do_image($res_print, $code_cb_bulletin, 0);
if ($num_notice) {
// Il y a une notice de bulletin
$display .= $res_print;
$opac_notices_depliable = 0;
$seule = 1;
//$display .= pmb_bidi(aff_notice($num_notice,0,0)) ;
if ($type == "visionneuse") {
$display .= pmb_bidi(aff_notice($num_notice, 1, 1, 0, "", 0, 1));
} else {
$display .= pmb_bidi(aff_notice($num_notice, 0, 1, 0, "", 0));
}
} else {
// construction des dépouillements
$depouill = "<br /><h3>" . $msg['bull_dep'] . "</h3>";
$requete = "SELECT * FROM analysis, notices, notice_statut WHERE analysis_bulletin='{$id}' AND notice_id = analysis_notice 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)" : "") . ") ";
$res = @pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($res)) {
if ($opac_notices_depliable) {
$depouill .= $begin_result_liste;
}
if ($opac_cart_allow) {
$depouill .= "<a href=\"cart_info.php?id=" . $id . "&lvl=analysis&header=" . rawurlencode(strip_tags($notice_header)) . "\" target=\"cart_info\" class=\"img_basket\" title='" . $msg["cart_add_result_in"] . "'>" . $msg["cart_add_result_in"] . "</a>";
}
$depouill .= "<blockquote>";
while ($obj = pmb_mysql_fetch_array($res)) {
$depouill .= pmb_bidi(aff_notice($obj["analysis_notice"]));
}
$depouill .= "</blockquote>";
} else {
$depouill = $msg["no_analysis"];
}
$display .= $res_print;
$display .= $depouill;
if ($notice3->visu_expl && (!$notice3->visu_expl_abon || $notice3->visu_expl_abon && $_SESSION["user_code"])) {
if (!$opac_resa_planning) {
$resa_check = check_statut(0, $id);
if ($resa_check) {
$requete_resa = "SELECT count(1) FROM resa WHERE resa_idbulletin='{$id}'";
$nb_resa_encours = pmb_mysql_result(pmb_mysql_query($requete_resa, $dbh), 0, 0);
if ($nb_resa_encours) {
$message_nbresa = str_replace("!!nbresa!!", $nb_resa_encours, $msg["resa_nb_deja_resa"]);
}
if ($_SESSION["user_code"] && $allow_book && $opac_resa && !$popup_resa) {
$ret_resa .= "<h3>" . $msg["bulletin_display_resa"] . "</h3>";
if ($opac_max_resa == 0 || $opac_max_resa > $nb_resa_encours) {
if ($opac_resa_popup) {
$ret_resa .= "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$ret_resa .= "<a href='./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$ret_resa .= $message_nbresa;
} else {
$ret_resa .= str_replace("!!nb_max_resa!!", $opac_max_resa, $msg["resa_nb_max_resa"]);
}
$ret_resa .= "<br />";
} elseif (!$_SESSION["user_code"] && $opac_resa && !$popup_resa) {
// utilisateur pas connecté
// préparation lien réservation sans être connecté
$ret_resa .= "<h3>" . $msg["bulletin_display_resa"] . "</h3>";
if ($opac_resa_popup) {
$ret_resa .= "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$ret_resa .= "<a href='./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$ret_resa .= $message_nbresa;
$ret_resa .= "<br />";
} elseif ($fonction == 'notice_affichage_custom_bretagne') {
if ($opac_resa_popup) {
$reserver = "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_notice=" . $this->notice_id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$reserver = "<a href='./do_resa.php?lvl=resa&id_notice=" . $this->notice_id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$reservernbre = $message_nbresa;
} else {
$ret_resa = "";
}
$display .= pmb_bidi($ret_resa);
}
}
if ($opac_show_exemplaires) {
if ($fonction == 'notice_affichage_custom_bretagne') {
$display .= pmb_bidi(notice_affichage_custom_bretagne::expl_list("m", 0, $id));
} else {
$display .= pmb_bidi(notice_affichage::expl_list("m", 0, $id));
}
}
}
if ($type != "visionneuse" && $notice3->visu_explnum && (!$notice3->visu_explnum_abon || $notice3->visu_explnum_abon && $_SESSION["user_code"])) {
if ($explnum = show_explnum_per_notice(0, $id, '')) {
$display .= pmb_bidi("<a name='docnum'><h3>" . $msg["explnum"] . "</h3></a>" . $explnum);
}
}
}
pmb_mysql_free_result($res);
$display .= notice_affichage::autres_lectures(0, $id);
return $display;
}
function get_bulletin_list_func($id)
{
global $charset, $dbh, $msg, $css;
global $opac_visionneuse_allow, $icon_doc, $opac_cart_allow, $opac_max_resa;
global $begin_result_liste, $notice_header, $opac_resa_planning;
global $opac_show_exemplaires, $fonction, $opac_resa_popup, $opac_resa, $popup_resa, $allow_book;
global $opac_perio_a2z_show_bulletin_notice;
$resultat_aff = "";
$libelle = $msg[270];
$largeur = 500;
$requete = "SELECT bulletin_id, bulletin_numero, bulletin_notice, mention_date, date_date, bulletin_titre, bulletin_cb, date_format(date_date, '" . $msg["format_date_sql"] . "') as aff_date_date,num_notice FROM bulletins WHERE bulletin_id='{$id}'";
$res = @pmb_mysql_query($requete, $dbh);
while ($obj = pmb_mysql_fetch_array($res)) {
//on cherches des documents numériques
$req = "select explnum_id from explnum where explnum_bulletin = " . $obj["bulletin_id"];
$resultat = pmb_mysql_query($req, $dbh) or die($req . " " . pmb_mysql_error());
$nb_ex = pmb_mysql_num_rows($resultat);
//on met le nécessaire pour la visionneuse
if ($opac_visionneuse_allow && $nb_ex) {
$resultat_aff .= "\n\t\t\t<script type='text/javascript'>\n\t\t\t\tfunction sendToVisionneuse(explnum_id){\n\t\t\t\t\tdocument.getElementById('visionneuseIframe').src = 'visionneuse.php?mode=perio_bulletin&idperio=" . $obj['bulletin_notice'] . "'+(typeof(explnum_id) != 'undefined' ? '&explnum_id='+explnum_id+\"\" : '\\'');\n\t\t\t\t}\n\t\t\t</script>";
}
$typdocchapeau = "a";
$icon = "";
$requete3 = "SELECT notice_id,typdoc FROM notices WHERE notice_id='" . $obj["bulletin_notice"] . "' ";
$res3 = @pmb_mysql_query($requete3, $dbh);
while ($obj3 = pmb_mysql_fetch_object($res3)) {
$notice3 = new notice($obj3->notice_id);
$typdocchapeau = $obj3->typdoc;
}
$notice3->fetch_visibilite();
if (!$icon) {
$icon = "icon_per.gif";
}
$icon = $icon_doc["b" . $typdocchapeau];
$res_print .= "<h3><img src='" . get_url_icon($icon) . "' /> " . $notice3->print_resume(1, $css) . "." . " <b>" . $obj["bulletin_numero"] . "</b></h3>\n";
$num_notice = $obj['num_notice'];
if ($obj['date_date']) {
$res_print .= $msg['bull_date_date'] . " " . $obj['aff_date_date'] . " \n";
}
if ($obj['bulletin_cb']) {
$res_print .= "<br />" . $msg["code_start"] . " " . htmlentities($obj['bulletin_cb'], ENT_QUOTES, $charset) . "\n";
$code_cb_bulletin = $obj['bulletin_cb'];
}
}
do_image($res_print, $code_cb_bulletin, 0);
if ($opac_perio_a2z_show_bulletin_notice && $num_notice) {
// Il y a une notice de bulletin
$resultat_aff .= $res_print;
global $opac_notices_depliable;
global $seule;
$memo_opac_notices_depliable = $opac_notices_depliable;
$memo_seule = $seule;
$opac_notices_depliable = 0;
$seule = 1;
$resultat_aff .= pmb_bidi(aff_notice($num_notice, 0, 0));
$opac_notices_depliable = $memo_opac_notices_depliable;
$seule = $memo_seule;
} else {
// construction des dépouillements
$requete = "SELECT * FROM analysis, notices, notice_statut WHERE analysis_bulletin='{$id}' AND notice_id = analysis_notice 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)" : "") . ") ";
$res = @pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($res)) {
$depouill = "<h3>" . $msg['bull_dep'] . "</h3>";
if ($opac_notices_depliable) {
$depouill .= $begin_result_liste;
}
if ($opac_cart_allow) {
$depouill .= "<a href=\"cart_info.php?id=" . $id . "&lvl=analysis&header=" . rawurlencode(strip_tags($notice_header)) . "\" target=\"cart_info\" class=\"img_basket\" title='" . $msg["cart_add_result_in"] . "'>" . $msg["cart_add_result_in"] . "</a>";
}
$depouill .= "<blockquote>";
while ($obj = pmb_mysql_fetch_array($res)) {
$depouill .= pmb_bidi(aff_notice($obj["analysis_notice"]));
}
$depouill .= "</blockquote>";
}
$resultat_aff .= $res_print;
$resultat_aff .= $depouill;
if ($notice3->visu_expl && (!$notice3->visu_expl_abon || $notice3->visu_expl_abon && $_SESSION["user_code"])) {
if (!$opac_resa_planning) {
$resa_check = check_statut(0, $id);
if ($resa_check) {
$requete_resa = "SELECT count(1) FROM resa WHERE resa_idbulletin='{$id}'";
$nb_resa_encours = pmb_mysql_result(pmb_mysql_query($requete_resa, $dbh), 0, 0);
if ($nb_resa_encours) {
$message_nbresa = str_replace("!!nbresa!!", $nb_resa_encours, $msg["resa_nb_deja_resa"]);
}
if ($_SESSION["user_code"] && $allow_book && $opac_resa && !$popup_resa) {
$ret_resa .= "<h3>" . $msg["bulletin_display_resa"] . "</h3>";
if ($opac_max_resa == 0 || $opac_max_resa > $nb_resa_encours) {
if ($opac_resa_popup) {
$ret_resa .= "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$ret_resa .= "<a href='./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$ret_resa .= $message_nbresa;
} else {
$ret_resa .= str_replace("!!nb_max_resa!!", $opac_max_resa, $msg["resa_nb_max_resa"]);
}
$ret_resa .= "<br />";
} elseif (!$_SESSION["user_code"] && $opac_resa && !$popup_resa) {
// utilisateur pas connecté
// préparation lien réservation sans être connecté
$ret_resa .= "<h3>" . $msg["bulletin_display_resa"] . "</h3>";
if ($opac_resa_popup) {
$ret_resa .= "<a href='#' onClick=\"if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
} else {
$ret_resa .= "<a href='./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup' onClick=\"return confirm('" . $msg["confirm_resa"] . "')\" id=\"bt_resa\">" . $msg["bulletin_display_place_resa"] . "</a>";
}
$ret_resa .= $message_nbresa;
$ret_resa .= "<br />";
} else {
$ret_resa = "";
}
$resultat_aff .= pmb_bidi($ret_resa);
}
}
if ($opac_show_exemplaires) {
if ($fonction == 'notice_affichage_custom_bretagne') {
$resultat_aff .= pmb_bidi(notice_affichage_custom_bretagne::expl_list("m", 0, $id));
} else {
$resultat_aff .= pmb_bidi(notice_affichage::expl_list("m", 0, $id, 0));
}
}
}
if ($notice3->visu_explnum && (!$notice3->visu_explnum_abon || $notice3->visu_explnum_abon && $_SESSION["user_code"])) {
if ($explnum = show_explnum_per_notice(0, $id, '')) {
$resultat_aff .= pmb_bidi("<a name='docnum'><h3>" . $msg["explnum"] . "</h3></a>" . $explnum);
}
}
}
pmb_mysql_free_result($res);
$resultat_aff .= notice_affichage::autres_lectures(0, $id);
return $resultat_aff;
}
$resas_datas['onclick'] = "if(confirm('" . $msg["confirm_resa"] . "')){w=window.open('./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup','doresa','scrollbars=yes,width=500,height=600,menubar=0,resizable=yes'); w.focus(); return false;}else return false;";
} else {
$resas_datas['href'] = "./do_resa.php?lvl=resa&id_bulletin=" . $id . "&oresa=popup";
$resas_datas['onclick'] = "return confirm('" . $msg["confirm_resa"] . "')";
}
} else {
$resas_datas['flag_resa_possible'] = false;
}
} else {
$resas_datas['flag_resa_possible'] = false;
}
} else {
$resas_datas['flag_resa_possible'] = false;
}
if ($opac_show_exemplaires) {
$obj['display_expls'] = pmb_bidi(notice_affichage::expl_list("m", 0, $id));
}
} else {
$resas_datas['flag_resa_visible'] = false;
}
// On envoie le tout au template
if (file_exists($include_path . "/templates/record/" . $opac_notices_format_django_directory . "/bulletin_without_record_extended_display.tpl.html")) {
$template = $include_path . "/templates/record/" . $opac_notices_format_django_directory . "/bulletin_without_record_extended_display.tpl.html";
} else {
$template = $include_path . "/templates/record/common/bulletin_without_record_extended_display.tpl.html";
}
$h2o = new H2o($template);
print $h2o->render(array('bulletin' => $obj, 'parent' => $notice3, 'liens_opac' => $liens_opac, 'resas_datas' => $resas_datas));
}
}
}
function alert_mail_users_pmb($id_notice = 0, $id_bulletin = 0, $id_empr, $annul = 0)
{
global $dbh;
global $msg, $charset;
global $opac_biblio_name, $opac_biblio_email;
global $opac_url_base;
// paramétrage OPAC: choix du nom de la bibliothèque comme expéditeur
$requete = "select location_libelle, email from empr, docs_location where empr_location=idlocation and id_empr='{$id_empr}' ";
$res = mysql_query($requete, $dbh);
$loc = mysql_fetch_object($res);
$PMBusernom = $loc->location_libelle;
$PMBuserprenom = '';
$PMBuseremail = $loc->email;
if ($PMBuseremail) {
$query = "select distinct empr_prenom, empr_nom, empr_cb, empr_mail, empr_tel1, empr_tel2, empr_ville, location_libelle, nom, prenom, user_email, date_format(sysdate(), '" . $msg["format_date_heure"] . "') as aff_quand from empr, docs_location, users where id_empr='{$id_empr}' and empr_location=idlocation and user_email like('%@%') and user_alert_resamail=1";
$result = @mysql_query($query, $dbh);
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=" . $charset . "\n";
$output_final = '';
while ($empr = @mysql_fetch_object($result)) {
if (!$output_final) {
$output_final = "<html><body>";
if ($annul == 1) {
$output_final .= "<a href='" . $opac_url_base . "'><font color=red><strong>" . $msg["mail_obj_resa_canceled"];
$sujet = $msg["mail_obj_resa_canceled"];
} elseif ($annul == 2) {
$output_final .= "<a href='" . $opac_url_base . "'><font color=blue><strong>" . $msg["mail_obj_resa_reaffected"];
$sujet = $msg["mail_obj_resa_reaffected"];
} else {
$output_final .= "<a href='" . $opac_url_base . "'><font color=green><strong>" . $msg["mail_obj_resa_added"];
$sujet = $msg["mail_obj_resa_added"];
}
$output_final .= "</strong></font></a> " . $empr->aff_quand . "\n\t\t\t\t\t\t\t\t\t<br /><strong>" . $empr->empr_prenom . " " . $empr->empr_nom . "</strong>\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<br /><i>" . $empr->empr_mail . " / " . $empr->empr_tel1 . " / " . $empr->empr_tel2 . "</i>";
if ($empr->empr_cp || $empr->empr_ville) {
$output_final .= "<br /><u>" . $empr->empr_cp . " " . $empr->empr_ville . "</u>";
}
$output_final .= "<hr />" . $msg[situation] . ": " . $empr->location_libelle . "<hr />";
if ($id_notice) {
$current = new notice_affichage($id_notice, array(), 0, 1);
$current->do_header();
$current->do_isbd(1, 1);
$output_final .= "<h3>" . $current->notice_header . "</h3>";
$output_final .= $current->notice_isbd;
$output_final .= $current->affichage_expl;
} else {
$output_final .= bulletin_affichage_reduit($id_bulletin);
$output_final .= notice_affichage::expl_list("m", 0, $id_bulletin);
}
$output_final .= "<hr /></body></html> ";
}
$res_envoi = mailpmb($empr->nom . " " . $empr->prenom, $empr->user_email, $sujet . " " . $empr->aff_quand, $output_final, $PMBusernom, $PMBuseremail, $headers, "", "", 1);
}
}
}
