$requete = "SELECT * FROM abts_abts WHERE abt_id='{$abt_id}'"; $abtsQuery = pmb_mysql_query($requete, $dbh); if (pmb_mysql_num_rows($abtsQuery)) { $abts = pmb_mysql_fetch_object($abtsQuery); $expl->expl_cote = $abts->cote; $expl->expl_location = $abts->location_id; $expl->expl_section = $abts->section_id; $expl->expl_codestat = $abts->codestat_id; $expl->expl_typdoc = $abts->typdoc_id; $expl->expl_statut = $abts->statut_id; $expl->expl_owner = $abts->lender_id; $expl->type_antivol = $abts->type_antivol; $expl->expl_note = $abts->expl_note; $expl->expl_comment = $abts->expl_comment; $expl->expl_prix = $abts->expl_prix; $expl->destinataire = $abts->destinataire; } // sélection de la cote dewey de la notice chapeau pour pré-renseignement de la cote en création expl $query_cote = "select indexint_name from indexint, notices, bulletins where bulletin_id='{$bul_id}' and bulletin_notice=notice_id and notices.indexint=indexint.indexint_id "; $myQuery_cote = pmb_mysql_query($query_cote, $dbh); if (pmb_mysql_num_rows($myQuery_cote)) { $pre_cote = pmb_mysql_fetch_object($myQuery_cote); $expl->expl_cote = $pre_cote->indexint_name; } } $bull_form .= bul_do_form($expl); $templates = str_replace("!!form!!", $bull_form, $templates); } $templates = str_replace("!!serialcir_print!!", $serialcir_print, $templates); $templates = str_replace("!!print_cote!!", $print_cote, $templates); print $templates;
print "impossible d'accéder à cet exemplaire."; } } else { // création d'un exemplaire // avant toute chose, on regarde si ce cb n'existe pas déjà $requete = "SELECT count(1) FROM exemplaires WHERE expl_cb='" . $noex . "' "; $myQuery = pmb_mysql_query($requete, $dbh); if (!pmb_mysql_result($myQuery, 0, 0)) { $expl = new stdClass(); $expl->expl_cb = $noex; $expl->expl_id = 0; $expl->expl_bulletin = $bul_id; $expl->expl_location = $deflt_docs_location; $expl->expl_section = $deflt_docs_section; $expl->expl_codestat = $deflt_docs_codestat; $expl->expl_typdoc = $deflt_docs_type; $expl->expl_statut = $deflt_docs_statut; $expl->expl_owner = $deflt_lenders; $expl_create_date = ''; $expl_update_date = ''; $bulletin = new bulletinage($bul_id); $expl->expl_cote = prefill_cote($bulletin->bulletin_notice); print bul_do_form($expl); } else { print "<div class=\"row\"><div class=\"msg-perio\" size=\"+2\">" . $msg["expl_message_code_utilise"] . "</div></div>"; print "<div class=\"row\"><a href=\"./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id="; print $bulletinage->bul_id; print "\">Retour</a></div>"; } } }