\n "; $requete="select recouvr_id,id_expl,date_rec,libelle,montant, expl_notice,expl_bulletin, recouvr_type, date_pret,date_relance1,date_relance2,date_relance3, expl_cote , expl_cb from recouvrements left join exemplaires on expl_id=id_expl where empr_id=$id_empr order by date_rec,recouvr_id"; $resultat=mysql_query($requete); $pair=false; while ($r=mysql_fetch_object($resultat)) { if (!$pair) $class="odd"; else $class="even"; $pair=!$pair; if ($r->id_expl) { if ($r->expl_notice) $notice=new mono_display($r->expl_notice); elseif ($r->expl_bulletin) { $req="select bulletin_notice from bulletins where bulletin_id=$r->expl_bulletin"; $res=mysql_query($req); $id_bull_notice=mysql_result($res,0,0); $notice = new serial_display($id_bull_notice); } $libelle=strip_tags(html_entity_decode($notice->header,ENT_QUOTES,$charset)); } else $libelle=$r->libelle; if(!$r->recouvr_type) { print pmb_bidi(""; print ""; }elseif ($r->id_expl) { $requete="select expl_prix, prix from exemplaires, notices where (notice_id=expl_notice or notice_id=expl_bulletin) and expl_id =".$r->id_expl; //http://localhost/~ngantier/pmb/circ.php?categ=visu_ex&form_cb_expl=p $res_prix=mysql_query($requete); $comment_prix=''; if($r_prix=mysql_fetch_object($res_prix)) { if(!$comment_prix=$r_prix->expl_prix)$comment_prix=$r_prix->prix; } print pmb_bidi(""; print ""; } } print "

".htmlentities($msg["relance_recouvrement_date"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_type"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_titre"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_cb"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_cote"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_pret_date"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_relance_date1"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_relance_date2"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_relance_date3"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_prix_calcul"],ENT_QUOTES,$charset)."	".htmlentities($msg["relance_recouvrement_montant"],ENT_QUOTES,$charset)."
".format_date($r->date_rec)."	".htmlentities($msg["relance_recouvrement_amende"],ENT_QUOTES,$charset)."	".htmlentities($libelle,ENT_QUOTES,$charset)."	".$r->expl_cb."	".htmlentities($r->expl_cote,ENT_QUOTES,$charset)."	".format_date($r->date_pret)."	".format_date($r->date_relance1)."	".format_date($r->date_relance2)."	".format_date($r->date_relance3)."		".comptes::format_simple($r->montant)."		"); if (!$r->id_expl) print ""; else print " "; print "
".format_date($r->date_rec)."	".htmlentities($msg["relance_recouvrement_prix"],ENT_QUOTES,$charset)."	".htmlentities($libelle,ENT_QUOTES,$charset)."	".$r->expl_cb."	".htmlentities($r->expl_cote,ENT_QUOTES,$charset)."	".format_date($r->date_pret)."	".format_date($r->date_relance1)."	".format_date($r->date_relance2)."	".format_date($r->date_relance3)."	".htmlentities($comment_prix,ENT_QUOTES,$charset)."	".comptes::format_simple($r->montant)."		"); print "