"; if ($current!==false) { $print_action = " "; } $visualise_click_notice=" "; $base_url = "./catalog.php?categ=serials&sub=view&serial_id=$serial_id"; $serial_action_bar = str_replace('!!serial_id!!', $serial_id, $serial_action_bar); if ($serial_id) $myQuery = mysql_query("SELECT * FROM notices WHERE notice_id=$serial_id ", $dbh); if ($serial_id && mysql_num_rows($myQuery)) { //Bulletins $myPerio = mysql_fetch_object($myQuery); // 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 ) { $isbd = new serial_display($myPerio, 5, "", "", "", "", "./catalog.php?categ=serials&sub=explnum_form&serial_id=!!serial_id!!&explnum_id=!!explnum_id!!"); $perio_header = $isbd->header; // isbd du périodique $perio_isbd = $isbd->isbd; $isbd->get_etat_periodique(); $perio_isbd.=$isbd->print_etat_periodique(); global $avis_quoifaire,$valid_id_avis; $perio_isbd = str_replace('', avis_notice($serial_id,$avis_quoifaire,$valid_id_avis), $perio_isbd); if (!$page) $page=1; $debut = ($page-1)*$nb_per_page_a_search; switch ($view) { case "abon": $base_url = "./catalog.php?categ=serials&sub=view&serial_id=$serial_id&view=abon"; require_once("views/view_abon.inc.php"); break; case "modele": require_once("views/view_modeles.inc.php"); break; case "collstate": $base_url = "./catalog.php?categ=serials&sub=view&serial_id=$serial_id&view=collstate"; require_once("views/view_collstate.inc.php"); break; default: // barre de restriction des bulletins affichés $clause=""; if ($aff_bulletins_restrict_numero) { $clause = " and bulletin_numero like '%".str_replace("*","%",$aff_bulletins_restrict_numero)."%' "; $base_url .= "&aff_bulletins_restrict_numero=".urlencode($aff_bulletins_restrict_numero) ; } if ($aff_bulletins_restrict_date) { $aff_bulletins_restrict_date_traite = str_replace("*","%",$aff_bulletins_restrict_date) ; $tab_bulletins_restrict_date = explode ($msg[format_date_input_separator],$aff_bulletins_restrict_date_traite) ; if(count($tab_bulletins_restrict_date)==3)$aff_bulletins_restrict_date_traite = $tab_bulletins_restrict_date[2]."-".$tab_bulletins_restrict_date[1]."-".$tab_bulletins_restrict_date[0]; if(count($tab_bulletins_restrict_date)==2)$aff_bulletins_restrict_date_traite = $tab_bulletins_restrict_date[1]."-".$tab_bulletins_restrict_date[0]; if(count($tab_bulletins_restrict_date)==1)$aff_bulletins_restrict_date_traite = $tab_bulletins_restrict_date[0]; $clause .= " and date_date like '%".$aff_bulletins_restrict_date_traite."%'" ; $base_url .= "&aff_bulletins_restrict_date=".urlencode($aff_bulletins_restrict_date) ; } if ($aff_bulletins_restrict_periode) { $aff_bulletins_restrict_periode_traite = str_replace("*","%",$aff_bulletins_restrict_periode) ; $clause .= " and mention_date like '%".$aff_bulletins_restrict_periode_traite."%'" ; $base_url .= "&aff_bulletins_restrict_periode=".urlencode($aff_bulletins_restrict_periode) ; } //On compte les expl de la localisation $rqt="SELECT COUNT(1) FROM bulletins ".($location?", exemplaires":"")." WHERE ".($location?"(expl_bulletin=bulletin_id and expl_location='$location' or expl_location is null) and ":"")." bulletin_notice='$serial_id' "; $myQuery = mysql_query($rqt, $dbh); $nb_expl_loc = mysql_result($myQuery,0,0); //On compte les bulletins de la localisation $rqt="SELECT count(distinct bulletin_id) FROM bulletins ".($location?",exemplaires ":"")." WHERE ".($location?"(expl_bulletin=bulletin_id and expl_location='$location') and ":"")." bulletin_notice='$serial_id' "; $myQuery = mysql_query($rqt, $dbh); if ($execute_query&&mysql_num_rows($myQuery)) { $nb_bull_loc = mysql_result($myQuery,0,0); } //On compte les bulletinsà afficher $rqt="SELECT count(distinct bulletin_id) FROM bulletins ".($location?", exemplaires":"")." WHERE ".($location?"(expl_bulletin=bulletin_id and expl_location='$location' or expl_location is null) and ":"")." bulletin_notice='$serial_id' $clause "; $myQuery = mysql_query($rqt, $dbh); $nbr_lignes = mysql_result($myQuery,0,0); require_once("views/view_bulletins.inc.php"); break; } // Gestion de la supression de la notice si les droits de modification des exemplaires sont localisés. $flag_no_delete_notice=0; //visibilité des exemplaires if ($pmb_droits_explr_localises) { global $explr_visible_mod; $explr_tab_modif=explode(",",$explr_visible_mod); $requete = "SELECT expl_location from exemplaires, bulletins,notices where expl_bulletin=bulletin_id and bulletin_notice=notice_id and notice_id= $serial_id"; $execute_query=mysql_query($requete); if ($execute_query&&mysql_num_rows($execute_query)) { while ($r=mysql_fetch_object($execute_query)) { if(!in_array ($r->expl_location,$explr_tab_modif )) $flag_no_delete_notice=1; } } } if(!$flag_no_delete_notice)$serial_action_bar = str_replace('!!delete_serial_button!!', "", $serial_action_bar); else $serial_action_bar=str_replace('!!delete_serial_button!!', "", $serial_action_bar); $serial_action_bar = str_replace('!!issn!!', $myPerio->code, $serial_action_bar); // action_bar : serials.tpl.php... // mise à jour des info du javascript $serial_action_bar = str_replace('!!nb_bulletins!!', $isbd->serial_nb_bulletins, $serial_action_bar); $serial_action_bar = str_replace('!!nb_articles!!', $isbd->serial_nb_articles, $serial_action_bar); $serial_action_bar = str_replace('!!nb_expl!!', $isbd->serial_nb_exemplaires, $serial_action_bar); $serial_action_bar = str_replace('!!nb_etat_coll!!', $isbd->serial_nb_etats_collection, $serial_action_bar); $serial_action_bar = str_replace('!!nb_abo!!', $isbd->serial_nb_abo_actif, $serial_action_bar); // titre général du périodique print pmb_bidi("