static function del_expl($id = 0)
{
global $dbh;
global $explr_invisible, $explr_visible_unmod, $explr_visible_mod, $pmb_droits_explr_localises;
$sql_pret = pmb_mysql_query("select 1 from pret where pret_idexpl ='{$id}' ");
if (pmb_mysql_num_rows($sql_pret)) {
return 0;
}
// visibilite de l'exemplaire
if ($pmb_droits_explr_localises) {
$query = "select expl_location from exemplaires where expl_id='" . $id . "'";
$result = pmb_mysql_query($query, $dbh);
$location_id = pmb_mysql_result($result, 0, 0);
$tab_mod = explode(",", $explr_visible_mod);
$as_modif = array_search($location_id, $tab_mod);
if ($as_modif === false) {
return 0;
}
}
$requete = "select idcaddie FROM caddie where type='EXPL' ";
$result = pmb_mysql_query($requete, $dbh);
for ($i = 0; $i < pmb_mysql_num_rows($result); $i++) {
$temp = pmb_mysql_fetch_object($result);
$requete_suppr = "delete from caddie_content where caddie_id='" . $temp->idcaddie . "' and object_id='" . $id . "' ";
$result_suppr = pmb_mysql_query($requete_suppr, $dbh);
}
audit::delete_audit(AUDIT_EXPL, $id);
$p_perso = new parametres_perso("expl");
$p_perso->delete_values($id);
// nettoyage transfert
$requete_suppr = "delete from transferts_demande where num_expl='{$id}'";
$result_suppr = pmb_mysql_query($requete_suppr);
// nettoyage circulation des périodiques
serialcirc::delete_expl($id);
// nettoyage doc. à ranger
$requete_suppr = "delete from resa_ranger where resa_cb in (select expl_cb from exemplaires where expl_id='" . $id . "') ";
$result_suppr = pmb_mysql_query($requete_suppr, $dbh);
// nettoyage indexation concepts
$index_concept = new index_concept($id, TYPE_EXPL);
$index_concept->delete();
$sql_del = pmb_mysql_query("delete from exemplaires where expl_id='{$id}' ");
return 1;
}
public function resume_ask()
{
global $charset, $msg;
global $opac_url_base;
$query = "select * from serialcirc_ask where num_serialcirc_ask_empr = " . $this->empr_id . " order by serialcirc_ask_type asc, serialcirc_ask_statut asc";
$result = mysql_query($query);
$display = "\n\t\t\t<div class='row'>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>" . htmlentities($msg['serialcirc_ask_type'], ENT_QUOTES, $charset) . "</th>\n\t\t\t\t\t\t<th>" . htmlentities($msg['serialcirc_serial_name'], ENT_QUOTES, $charset) . "</th>\n\t\t\t\t\t\t<th>" . htmlentities($msg['serialcirc_ask_date'], ENT_QUOTES, $charset) . "</th>\n\t\t\t\t\t\t<th>" . htmlentities($msg['serialcirc_ask_statut'], ENT_QUOTES, $charset) . "</th>\n\t\t\t\t\t\t<th>" . htmlentities($msg['serialcirc_ask_msg'], ENT_QUOTES, $charset) . "</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t!!rows!!\n\t\t\t\t</table>\n\t\t\t</div>\n\t\t";
$rows = "";
if (mysql_num_rows($result)) {
$i = 0;
while ($row = mysql_fetch_object($result)) {
if ($row->num_serialcirc_ask_perio != 0) {
$query = "select tit1 from notices where notice_id = " . $row->num_serialcirc_ask_perio;
$res = mysql_query($query);
if (mysql_num_rows($res)) {
$serial = mysql_result($res, 0, 0);
}
} else {
$serialcirc = new serialcirc($row->num_serialcirc_ask_serialcirc);
$serial = $serialcirc->get_serial_title();
}
$rows .= "\n\t\t\t\t\t<tr class='" . ($i % 2 == 0 ? "odd" : "even") . "'>\n\t\t\t\t\t\t<td>" . htmlentities($msg['serialcirc_ask_type_' . $row->serialcirc_ask_type], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td><a href='" . $opac_url_base . "index.php?lvl=notice_display&id=" . $row->num_serialcirc_ask_perio . "'>" . htmlentities($serial, ENT_QUOTES, $charset) . "</a></td>\n\t\t\t\t\t\t<td>" . htmlentities(formatdate($row->serialcirc_ask_date), ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td>" . htmlentities($msg['serialcirc_ask_statut_' . $row->serialcirc_ask_statut], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td>" . htmlentities($row->serialcirc_ask_comment, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t</tr>";
$i++;
}
}
$display = str_replace("!!rows!!", $rows, $display);
return $display;
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: serialcirc.inc.php,v 1.2 2011-12-05 15:17:34 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/serialcirc.class.php";
$serialcirc = new serialcirc($location_id);
switch ($sub) {
// Zone de pointage
case 'cb_enter':
print $serialcirc->gen_circ_cb($cb);
break;
case 'print_diff':
$cb_list[] = $cb;
print $serialcirc->print_diff_list($cb_list);
break;
case 'del_circ':
break;
// Zone de liste
// Zone de liste
case 'print_diff_list':
print $serialcirc->print_diff_list($cb_list);
break;
default:
print $serialcirc->gen_circ_form();
break;
}
function get_serialcirc_form_actions()
{
global $charset, $msg;
global $opac_serialcirc_active;
global $allow_serialcirc;
$display = "";
//si on n'est pas connecté, il n'y a pas de boutons à afficher
if ($_SESSION['id_empr_session'] && $opac_serialcirc_active) {
if ($this->notice->niveau_biblio == "s") {
// pour un pério, on affiche un bouton pour demander l'inscription à un liste de diffusion
//TODO si le statut le permet...
$display .= "\n\t\t\t<div class='row'> </div>\n\t\t\t<div class='row'> </div>\t\n\t\t\t<div class='row'>\n\t\t\t\t<form method='post' action='empr.php?tab=serialcirc&lvl=ask&action=subscribe'>\n\t\t\t\t\t<input type='hidden' name='serial_id' value='" . htmlentities($this->notice_id, ENT_QUOTES, $charset) . "'/>\n\t\t\t\t\t<input type='submit' class='bouton' value='" . htmlentities($msg['serialcirc_ask_subscribtion'], ENT_QUOTES, $charset) . "'/>\n\t\t\t\t</form>\n\t\t\t</div>";
} else {
if ($this->notice->niveau_biblio == "b") {
// pour un bulletin, on regarde s'il est pas en cours d'inscription...
// récup la circulation si existante...
$query = "select id_serialcirc from serialcirc join abts_abts on abt_id = num_serialcirc_abt join bulletins on bulletin_notice = abts_abts.num_notice where bulletins.num_notice = " . $this->notice_id;
$result = mysql_query($query);
if (mysql_num_rows($result)) {
$id_serialcirc = mysql_result($result, 0, 0);
$serialcirc = new serialcirc($id_serialcirc);
if ($serialcirc->is_virtual()) {
if ($serialcirc->empr_is_subscribe($_SESSION['id_empr_session'])) {
$query = "select num_serialcirc_expl_id from serialcirc_expl where num_serialcirc_expl_serialcirc = " . $id_serialcirc . " and serialcirc_expl_start_date = 0";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
$expl_id = mysql_result($result, 0, 0);
$serialcirc_empr_circ = new serialcirc_empr_circ($_SESSION['id_empr_session'], $id_serialcirc, $expl_id);
$display .= $serialcirc_empr_circ->get_actions_form();
}
}
}
}
}
}
}
return $display;
}
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: serialcirc_ajax.inc.php,v 1.9 2016-01-06 09:13:03 jpermanne Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/serialcirc.class.php";
if ($pmb_lecteurs_localises && !$location_id && isset($_SESSION['serialcirc_location'])) {
$location_id = $_SESSION['serialcirc_location'];
}
if ($pmb_serialcirc_subst) {
require_once "{$class_path}/" . $pmb_serialcirc_subst;
$serialcirc = new serialcirc_subst($location_id);
} else {
$serialcirc = new serialcirc($location_id);
}
switch ($sub) {
// Zone de pointage
case 'cb_enter':
ajax_http_send_response($serialcirc->gen_circ_cb($cb));
break;
case 'send_alert':
ajax_http_send_response($serialcirc->send_alert($expl_id));
break;
case 'print_diffusion':
// retourne le pdf, donc pas de ajax_http_send_response
print $serialcirc->print_diffusion($expl_id, $start_diff_id);
break;
case 'print_sel_diffusion':
// retourne le pdf des fiches de circulation sélectionnées, donc pas de ajax_http_send_response
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: copy_isdone.inc.php,v 1.1 2011-12-05 15:17:35 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/serialcirc.class.php";
$serialcirc = new serialcirc(0);
$serialcirc->copy_isdone($bul_id);
// mise à jour de l'entête de page
echo str_replace('!!page_title!!', $msg[4000] . $msg[1003] . $msg[4011], $serial_header);
$form = show_bulletinage_info_catalogage($bul_id);
if ($art_to_show) {
$form .= "<script>document.location='#anchor_{$art_to_show}'</script>";
}
print $form;
