".$msg["4008"]."";
$notice = new mono_display($id, 1, './catalog.php?categ=modif&id=!!id!!', FALSE);
print pmb_bidi("".$notice->header."
");
print pmb_bidi($notice->isbd."
");
$nex = new exemplaire($cb, $expl_id,$id);
//on compte de nombre de prets pour cet exemplaire
$req = "select count(arc_expl_id) as nb_prets from pret_archive where arc_expl_id = ".$nex->expl_id;
$res = mysql_query($req);
if(mysql_num_rows($res)){
$arch_pret = mysql_fetch_object($res);
$nb_prets = $arch_pret->nb_prets ;
}else $nb_prets = 0;
if($nb_prets){
//dernière date de pret pour cet exemplaire
$req = "select date_format(last_loan_date, '".$msg["format_date"]."') as date_last from exemplaires where expl_id = ".$nex->expl_id;
$res = mysql_query($req);
if(mysql_num_rows($res)){
$expl_pret = mysql_fetch_object($res);
$date_last = $expl_pret->date_last ;
$info_nb_prets=str_replace("!!nb_prets!!",$nb_prets,$msg['expl_nbprets']);
$query = "select count(pret_idexpl) ";
$query .= "from pret, empr where pret_idexpl='".$nex->expl_id."' and pret_idempr=id_empr ";
$result = mysql_query($query, $dbh);
if ($result && mysql_result($result,0,0)) {
$info_date_last = str_replace("!!date_last!!",$date_last,$msg['expl_lastpret_encours']);
} else {
$info_date_last = str_replace("!!date_last!!",$date_last,$msg['expl_lastpret_retour']);
}
print $info_nb_prets." ".$info_date_last;
}
}
// visibilité des exemplaires
// $nex->explr_acces_autorise contient INVIS, MODIF ou UNMOD
if ($nex->explr_acces_autorise!="INVIS") {
print "";
$expl_form = $nex->expl_form("./catalog.php?categ=expl_update&sub=update&org_cb=".urlencode($cb)."&expl_id=".$expl_id, "./catalog.php?categ=isbd&id=$id");
if ($nex->explr_acces_autorise=="MODIF") {
// lien pour suppression
$supprimer = "
";
$dupliquer = "
";
// lien pour la modification
$modifier = "".$dupliquer;
} else {
$modifier="";
$supprimer="";
}
$expl_form = str_replace('!!modifier!!',$modifier,$expl_form);
$expl_form = str_replace('!!supprimer!!', $supprimer, $expl_form);
if ($pmb_rfid_activate==1 && $pmb_rfid_serveur_url) {
$script_rfid_encode="if(script_rfid_encode()==false) return false;";
$expl_form = str_replace('!!questionrfid!!', $script_rfid_encode, $expl_form);
} else {
$expl_form = str_replace('!!questionrfid!!', '', $expl_form);
}
print $expl_form;
print "
";
} else {
print "";
}
// zone du dernier emrunteur
if ($pmb_expl_show_lastempr && $nex->lastempr) {
$lastempr = new emprunteur($nex->lastempr, '', FALSE, 0) ;
print "
";
}
// zone de l'emprunteur
$query = "select empr_cb, empr_nom, empr_prenom, ";
$query .= " date_format(pret_date, '".$msg["format_date"]."') as aff_pret_date, ";
$query .= " date_format(pret_retour, '".$msg["format_date"]."') as aff_pret_retour, ";
$query .= " IF(pret_retour>sysdate(),0,1) as retard " ;
$query .= " from pret, empr where pret_idexpl='".$nex->expl_id."' and pret_idempr=id_empr ";
$result = mysql_query($query, $dbh);
if(mysql_num_rows($result)) {
$pret = mysql_fetch_object($result);
print "
";
}
?>
