function gen_liste() { global $dbh, $msg, $deflt_docs_location, $begin_result_liste, $end_result_liste; if (!$deflt_docs_location) { return ""; } $sql = "SELECT expl_id, expl_cb FROM exemplaires where expl_retloc='" . $deflt_docs_location . "' "; $req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error()); while ($liste = pmb_mysql_fetch_object($req)) { if ($stuff = get_expl_info($liste->expl_id)) { $stuff = check_pret($stuff); $aff_final .= print_info($stuff, 0, 0, 0); } } if ($aff_final) { return "<h3>" . $msg['expl_todo_liste'] . "</h3>" . $begin_result_liste . $aff_final . $end_result_liste; } else { return $msg['resa_liste_docranger_nodoc']; } }
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) { die("no access"); } $prefix_url_image = "./"; if (!$back_to_visu) { get_cb_expl($msg[375], $msg[661], $msg[circ_tit_form_cb_expl], './circ.php?categ=visu_ex', 1); if ($form_cb_expl) { $query = "select expl_id, expl_notice, pret_flag, pret_idempr from docs_statut, exemplaires left join pret on pret_idexpl=expl_id where expl_cb='{$form_cb_expl}' and expl_statut=idstatut "; $result = pmb_mysql_query($query, $dbh); if (!pmb_mysql_num_rows($result)) { // exemplaire inconnu $alert_sound_list[] = "critique"; print "<strong>{$form_cb_expl} : {$msg[367]}</strong>"; } else { $expl_lu = pmb_mysql_fetch_object($result); if ($stuff = get_expl_info($expl_lu->expl_id, 1)) { $stuff = check_pret($stuff); // print $begin_result_liste; print print_info($stuff, 1, 1); // pour affichage de l'image de couverture if ($pmb_book_pics_show == '1' && ($pmb_book_pics_url && $stuff->code || $stuff->thumbnail_url)) { print "<script type='text/javascript'>\n\t\t\t\t\t\t<!--\n\t\t\t\t\t\tvar img = document.getElementById('PMBimagecover" . $expl_lu->expl_notice . "');\n\t\t\t\t\t\tisbn=img.getAttribute('isbn');\n\t\t\t\t\t\turl_image=img.getAttribute('url_image');\n\t\t\t\t\t\tif (isbn) {\n\t\t\t\t\t\t\tif (img.src.substring(img.src.length-8,img.src.length)=='vide.png') {\n\t\t\t\t\t\t\t\timg.src=url_image.replace(/!!noticecode!!/,isbn);\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\t\t\n\t\t\t\t\t\t//-->\n\t\t\t\t\t\t</script>\n\t\t\t\t\t\t"; } } else { // exemplaire inconnu $alert_sound_list[] = "critique"; print "<strong>{$form_cb_expl} : {$msg[367]}</strong>"; } } } } else {
switch ($action) { case 'add_item': $param->form_cb_expl = $form_cb_expl; if ($form_cb_expl) { $expl_ajout_ok = 1; $query = "select expl_id from exemplaires where expl_cb='{$form_cb_expl}'"; $result = pmb_mysql_query($query, $dbh); if (!pmb_mysql_num_rows($result)) { // exemplaire inconnu $param->message_ajout_expl = $msg[367]; $expl_ajout_ok = 0; } else { $expl_trouve = pmb_mysql_fetch_object($result); $item = $expl_trouve->expl_id; $param->expl_id = $expl_trouve->expl_id; if ($stuff = get_expl_info($item)) { $param->expl_notice = $stuff->expl_notice; $param->titre = $stuff->titre; $stuff = check_pret($stuff); } else { $param->message_ajout_expl = $msg[395]; $expl_ajout_ok = 0; } } } $res_ajout = $myCart->pointe_item($item, "EXPL", $form_cb_expl, "EXPL_CB"); // form de saisie cb exemplaire if ($expl_ajout_ok) { if ($res_ajout == CADDIE_ITEM_OK) { $param->message_ajout_expl = $msg["caddie_" . $myCart->type . "_pointe"]; }
function resa_ranger_list() { global $base_path, $dbh; global $msg; global $current_module; global $begin_result_liste; global $end_result_liste; global $deflt_docs_location; global $pmb_lecteurs_localises; global $f_loc; $aff_final = ""; if ($pmb_lecteurs_localises) { if ($f_loc == "") { $f_loc = $deflt_docs_location; } if ($f_loc) { $sql_expl_loc = " where expl_location='" . $f_loc . "' "; } } if ($pmb_lecteurs_localises) { //la liste de sélection de la localisation $aff_final .= "<form class='form-{$current_module}' name='check_docranger' action='" . $base_path . "/circ.php?categ=listeresa&sub=docranger' method='post'>"; $aff_final .= "<br />" . $msg["transferts_circ_resa_lib_localisation"]; $aff_final .= "<select name='f_loc' onchange='document.check_docranger.submit();'>"; $res = pmb_mysql_query("SELECT idlocation, location_libelle FROM docs_location order by location_libelle"); $aff_final .= "<option value='0'>" . $msg["all_location"] . "</option>"; //on parcours la liste des options while ($value = pmb_mysql_fetch_array($res)) { //debut de l'option $aff_final .= "<option value='" . $value[0] . "'"; if ($value[0] == $f_loc) { $aff_final .= " selected"; } //c'est l'option par défaut $aff_final .= ">" . $value[1] . "</option>"; } $aff_final .= "</select></form>"; } $sql = "SELECT resa_cb, expl_id from resa_ranger left join exemplaires on resa_cb=expl_cb " . $sql_expl_loc; $res = pmb_mysql_query($sql, $dbh); while ($ranger = pmb_mysql_fetch_object($res)) { if ($ranger->expl_id) { if ($stuff = get_expl_info($ranger->expl_id)) { $stuff = check_pret($stuff); $aff_final .= print_info($stuff, 0, 0, 0); } else { $aff_final .= "<strong>" . $ranger->resa_cb . " : {$msg[395]}</strong><br>"; } } else { $aff_final .= "<strong>" . $ranger->resa_cb . " : {$msg[395]}</strong><br>"; } } if ($aff_final) { return $begin_result_liste . $aff_final . $end_result_liste; } else { return $msg['resa_liste_docranger_nodoc']; } }
function aff_cart_notices($liste, $caddie_type, $idcaddie = 0) { global $msg; global $dbh; global $begin_result_liste; global $end_result_liste; global $page, $nbr_lignes, $nb_per_page; //Calcul des variables pour la suppression d'items if ($nb_per_page) { $modulo = $nbr_lignes % $nb_per_page; if ($modulo == 1) { $page_suppr = !$page ? 1 : $page - 1; } else { $page_suppr = $page; } $nb_after_suppr = $nbr_lignes ? $nbr_lignes - 1 : 0; } if (!sizeof($liste) || !is_array($liste)) { print $msg[399]; return; } else { // en fonction du type de caddie on affiche ce qu'il faut if ($caddie_type == "NOTI") { // boucle de parcours des notices trouvées // inclusion du javascript de gestion des listes dépliables // début de liste print $begin_result_liste; while (list($cle, $notice) = each($liste)) { // affichage de la liste des notices sous la forme 'expandable' $requete = "SELECT * FROM notices WHERE notice_id={$notice} LIMIT 1"; $fetch = mysql_query($requete, $dbh); if (mysql_num_rows($fetch)) { $notice = mysql_fetch_object($fetch); if ($notice->niveau_biblio != 's' && $notice->niveau_biblio != 'a') { // notice de monographie $link = './catalog.php?categ=isbd&id=!!id!!'; $link_expl = './catalog.php?categ=edit_expl&id=!!notice_id!!&cb=!!expl_cb!!&expl_id=!!expl_id!!'; $link_explnum = './catalog.php?categ=edit_explnum&id=!!notice_id!!&explnum_id=!!explnum_id!!'; $lien_suppr_cart = "<a href='./catalog.php?categ=search&mode=3&action=del_item&object_type=NOTI&idcaddie={$idcaddie}&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title='" . $msg[caddie_icone_suppr_elt] . "' /></a>"; $display = new mono_display($notice, 6, $link, 1, $link_expl, $lien_suppr_cart, $link_explnum, 1, 0, 1, 1); print pmb_bidi($display->result); } else { // on a affaire à un périodique // préparation des liens pour lui $link_serial = './catalog.php?categ=serials&sub=view&serial_id=!!id!!'; $link_analysis = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!bul_id!!&art_to_show=!!id!!'; $link_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!id!!'; $lien_suppr_cart = "<a href='./catalog.php?categ=search&mode=3&action=del_item&object_type=NOTI&idcaddie={$idcaddie}&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title='" . $msg[caddie_icone_suppr_elt] . "' /></a>"; // function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0, $show_opac_hidden_fields=true, $draggable=0 ) { $serial = new serial_display($notice, 6, $link_serial, $link_analysis, $link_bulletin, $lien_suppr_cart, "", 1, 0, 1, 1, true, 1); print pmb_bidi($serial->result); } } } // fin de liste print $end_result_liste; } // fin si NOTI // si EXPL if ($caddie_type == "EXPL") { // boucle de parcours des exemplaires trouvés // inclusion du javascript de gestion des listes dépliables // début de liste print $begin_result_liste; while (list($cle, $expl) = each($liste)) { if ($stuff = get_expl_info($expl)) { $stuff->lien_suppr_cart = "<a href='./catalog.php?categ=search&mode=3&action=del_item&object_type=EXPL&idcaddie={$idcaddie}&item={$expl}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title='" . $msg[caddie_icone_suppr_elt] . "' /></a>"; $stuff = check_pret($stuff); print pmb_bidi(print_info($stuff, 0, 1)); } else { print "<strong>{$form_cb_expl} : {$msg[395]}</strong>"; } } // fin de liste print $end_result_liste; } // fin si EXPL if ($caddie_type == "BULL") { // boucle de parcours des bulletins trouvés // inclusion du javascript de gestion des listes dépliables // début de liste print $begin_result_liste; while (list($cle, $expl) = each($liste)) { if ($bull_aff = show_bulletinage_info($expl)) { $javascript_template = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n \t\t\t\t\t\t<img src=\"./images/plus.gif\" class=\"img_plus\" name=\"imEx\" id=\"el!!id!!Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el!!id!!', true); return false;\" hspace=\"3\">\n \t\t\t\t\t\t<span class=\"notice-heada\">!!heada!!</span>\n \t\t\t\t\t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div id=\"el!!id!!Child\" class=\"notice-child\" style=\"margin-bottom:6px;display:none;\">\n \t\t\t\t \t\t!!CONTENU!!\n \t\t\t\t\t\t</div>"; $lien_suppr_cart = "<a href='./catalog.php?categ=search&mode=3&action=del_item&object_type=EXPL&idcaddie={$idcaddie}&item={$expl}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title='" . $msg[caddie_icone_suppr_elt] . "' /></a>"; $aff = str_replace('!!id!!', $expl, $javascript_template); $aff = str_replace('!!unique!!', md5(microtime()), $aff); $aff = str_replace('!!heada!!', $lien_suppr_cart . $bull_aff->header, $aff); $aff = str_replace('!!CONTENU!!', $bull_aff->display, $aff); print pmb_bidi($aff); } else { print "<strong>{$form_cb_expl} : {$msg[395]}</strong>"; } } // fin de liste print $end_result_liste; } // fin si BULL } }
function get_expl_display($tpl, $id) { global $msg, $dbh; $expl = get_expl_info($id, 1); $tpl = str_replace('!!cb!!', $expl->expl_cb, $tpl); $tpl = str_replace('!!notice!!', $expl->aff_reduit, $tpl); $tpl = str_replace('!!sur_loc_libelle!!', $expl->sur_loc_libelle, $tpl); $tpl = str_replace('!!location_libelle!!', $expl->location_libelle, $tpl); $tpl = str_replace('!!section_libelle!!', $expl->section_libelle, $tpl); $tpl = str_replace('!!expl_cote!!', $expl->expl_cote, $tpl); $tpl = str_replace('!!statut_libelle!!', $expl->statut_libelle, $tpl); return $tpl; }
function aff_cart_unique_object($item, $caddie_type, $url_base = "./catalog.php?categ=caddie&sub=gestion&quoi=panier&idcaddie=0") { global $msg; global $dbh; global $begin_result_liste; global $end_result_list; global $page, $nbr_lignes, $nb_per_page, $nb_per_page_search; // nombre de références par pages if ($nb_per_page_search != "") { $nb_per_page = $nb_per_page_search; } else { $nb_per_page = 10; } $cb_display = "\n\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t \t\t<span class=\"notice-heada\">!!heada!!</span>\n\t \t\t<br />\n\t\t\t</div>\n\t\t\t"; $liste[] = array('object_id' => $item, 'content' => "", 'blob_type' => ""); $aff_retour = ""; //Calcul des variables pour la suppression d'items $modulo = $nbr_lignes % $nb_per_page; if ($modulo == 1) { $page_suppr = !$page ? 1 : $page - 1; } else { $page_suppr = $page; } $nb_after_suppr = $nbr_lignes ? $nbr_lignes - 1 : 0; if (!sizeof($liste) || !is_array($liste)) { return $msg[399]; } else { // en fonction du type de caddie on affiche ce qu'il faut if ($caddie_type == "NOTI") { // boucle de parcours des notices trouvées while (list($cle, $object) = each($liste)) { if ($object[content] == "") { // affichage de la liste des notices sous la forme 'expandable' $requete = "SELECT * FROM notices WHERE notice_id={$object['object_id']} LIMIT 1"; $fetch = pmb_mysql_query($requete); if (pmb_mysql_num_rows($fetch)) { $notice = pmb_mysql_fetch_object($fetch); if ($notice->niveau_biblio == 'b') { // notice de bulletin $rqtbull = "select bulletin_id from bulletins where num_notice=" . $notice->notice_id; $fetchbull = pmb_mysql_query($rqtbull); $bull = pmb_mysql_fetch_object($fetchbull); $link = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . $bull->bulletin_id; // pas affichés pour l'instant: $link_expl = ''; $link_explnum = ''; $display = new mono_display($notice, 6, $link, 1, $link_expl, $lien_suppr_cart, $link_explnum); $aff_retour .= $display->result; } elseif ($notice->niveau_biblio != 's' && $notice->niveau_biblio != 'a') { // notice de monographie $link = './catalog.php?categ=isbd&id=!!id!!'; $link_expl = './catalog.php?categ=edit_expl&id=!!notice_id!!&cb=!!expl_cb!!&expl_id=!!expl_id!!'; $link_explnum = './catalog.php?categ=edit_explnum&id=!!notice_id!!&explnum_id=!!explnum_id!!'; $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=NOTI&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a>"; $display = new mono_display($notice, 6, $link, 1, $link_expl, $lien_suppr_cart, $link_explnum); $aff_retour .= $display->result; } else { // on a affaire à un périodique // préparation des liens pour lui $link_serial = './catalog.php?categ=serials&sub=view&serial_id=!!id!!'; $link_analysis = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!bul_id!!&art_to_show=!!id!!'; $link_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!id!!'; $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=NOTI&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a>"; $link_explnum = "./catalog.php?categ=serials&sub=analysis&action=explnum_form&bul_id=!!bul_id!!&analysis_id=!!analysis_id!!&explnum_id=!!explnum_id!!"; $serial = new serial_display($notice, 6, $link_serial, $link_analysis, $link_bulletin, $lien_suppr_cart, $link_explnum, 0); $aff_retour .= $serial->result; } } } else { $cb_display = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t\t\t\t \t\t<span class=\"notice-heada\"><strong>Code-barre : {$object['content']} : {$msg[395]}</strong></span>\n\t\t\t\t \t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t"; $aff_retour .= $cb_display; } } // fin de liste print $end_result_list; } // fin si NOTI // si EXPL if ($caddie_type == "EXPL") { // boucle de parcours des exemplaires trouvés // inclusion du javascript de gestion des listes dépliables // début de liste while (list($cle, $expl) = each($liste)) { if (!$expl[content]) { if ($stuff = get_expl_info($expl[object_id])) { $stuff->lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=EXPL&item={$expl}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a>"; $stuff = check_pret($stuff); $aff_retour .= print_info($stuff, 0, 1); } else { $aff_retour .= "<strong>ID : {$expl['object_id']} : {$msg[395]}</strong>"; } } else { $cb_display = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t\t\t\t \t\t<span class=\"notice-heada\"><strong>Code-barre : {$expl['content']} : {$msg[395]}</strong></span>\n\t\t\t\t \t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t"; $aff_retour .= $cb_display; } } // fin de liste print $end_result_list; } // fin si EXPL if ($caddie_type == "BULL") { // boucle de parcours des bulletins trouvés // inclusion du javascript de gestion des listes dépliables // début de liste while (list($cle, $expl) = each($liste)) { global $url_base_suppr_cart; $url_base_suppr_cart = $url_base; if ($bull_aff = show_bulletinage_info($expl["object_id"], 0, 1)) { $aff_retour .= $bull_aff; } else { $aff_retour .= "<strong>{$form_cb_expl} : {$msg[395]}</strong><br />"; } } // fin de liste print $end_result_list; } // fin si BULL } return $aff_retour; }
$form = str_replace('<!-- !!suite!! -->', $form_suite, $form); print $form; //si cb if ($form_cb_expl != "") { $formlocid = "f_ex_section" . $f_ex_location; $expl_section = ${$formlocid}; $query = "select * from exemplaires where expl_cb='" . $form_cb_expl . "' "; $result = pmb_mysql_query($query, $dbh); $expl_info = pmb_mysql_fetch_object($result); if ($expl_info->expl_id) { // Reset des transferts en cours $rqt = "UPDATE transferts,transferts_demande, exemplaires set etat_transfert=1, etat_demande=7\t\t\t\t\t\t\t\n\t\t\t\tWHERE id_transfert=num_transfert and num_expl=expl_id and etat_transfert=0 AND expl_cb='" . $form_cb_expl . "' "; pmb_mysql_query($rqt); //on met à jour la localisation de expl avec celle de l'utilisateur $rqt = "UPDATE exemplaires \n\t\t\t\tSET expl_location=" . $f_ex_location . ", transfert_location_origine =" . $f_ex_location . ", \n\t\t\t\texpl_statut=" . $f_ex_statut . ", transfert_statut_origine =" . $f_ex_statut . ", \n\t\t\t\texpl_section=" . $expl_section . ", transfert_section_origine =" . $expl_section . " \n\t\t\t\tWHERE expl_cb='" . $form_cb_expl . "' "; pmb_mysql_query($rqt); $rqt = "DELETE FROM transferts_source WHERE trans_source_numexpl=" . $expl_info->expl_id; pmb_mysql_query($rqt); $rqt = "insert transferts_source SET trans_source_numloc=" . $f_ex_location . " , trans_source_numexpl=" . $expl_info->expl_id; pmb_mysql_query($rqt); // le reset est fait $aff = str_replace("!!cb_expl!!", $form_cb_expl, $transferts_reset_OK); echo str_replace("!!new_location!!", $obj_transfert->new_location_libelle, $aff); $stuff = get_expl_info($expl_info->expl_id); $stuff = check_pret($stuff); print print_info($stuff, 1, 1, 0); } else { // cb inconnu print "<strong>" . $form_cb_expl . " : " . $msg[367] . "</strong>"; } }
function resa_ranger_list() { global $dbh; global $msg; global $begin_result_liste; global $end_result_liste; $sql = "SELECT resa_cb, expl_id from resa_ranger left join exemplaires on resa_cb=expl_cb "; $res = mysql_query($sql, $dbh); while ($ranger = mysql_fetch_object($res)) { if ($ranger->expl_id) { if ($stuff = get_expl_info($ranger->expl_id)) { $stuff = check_pret($stuff); $aff_final .= print_info($stuff, 0, 0, 0); } else { $aff_final .= "<strong>{$form_cb_expl} : {$msg[395]}</strong>"; } } } if ($aff_final) { return $begin_result_liste . $aff_final . $end_result_liste; } else { return $msg['resa_liste_docranger_nodoc']; } }
if (pmb_mysql_num_rows($result)) { $temp = pmb_mysql_fetch_object($result); $expl = get_expl_info($item, 0); $aff_reduit = $msg[376] . " " . $expl->expl_cb . " " . $expl->aff_reduit; if ($temp->expl_notice) { $notice = new mono_display($temp->expl_notice, 1, '', 0); $aff = $notice->isbd; } else { $bl = new bulletinage_display($temp->expl_bulletin); $aff = $bl->display; } } else { $aff = $msg["info_ex_introuvables"]; $aff_reduit = $msg["info_ex_introuvables"]; } $expl = get_expl_info($item); // informations de localisation $aff .= "<div class=\"row\">"; $aff .= "<u>" . $msg[298] . "</u> : " . $expl->location_libelle . '<br />'; $aff .= "<u>" . $msg[295] . "</u> : " . $expl->section_libelle . '<br />'; $aff .= "<u>" . $msg[296] . "</u> : " . $expl->expl_cote . '<br />'; $aff .= "<u>" . $msg[297] . "</u> : " . $expl->statut_libelle; $aff .= "</div>"; print '<strong>' . pmb_bidi($aff_reduit) . '</strong><br />'; switch ($action) { case 'add_item': if ($idcaddie) { $caddie[0] = $idcaddie; } foreach ($caddie as $idcaddie) { $myCart = new caddie($idcaddie);