setFlag("htmlonly"); } $f->display(); if($menu==0) // html only $f->displayStartContent(); // db if(file_exists ("../sql/".$f->db->phptype."/emplacement.scr.inc.php")) include ("../sql/".$f->db->phptype."/emplacement.scr.inc.php"); $res=$f->db->query($sql_emplacement); $f->isDatabaseError($res); while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ $existe=1; // dossier echo "

\n"; echo "\t"; echo _("emplacement").""; echo ""; echo ""; echo ""; echo "

"; echo "".$row['nature']." ".$row['famille'].""; echo "

"; echo "".$row['numero']." ".$row['complement']." ".$row['voietype']." ".$row['voielib']."
"; echo "".$row['cimetierelib']." ".$row['zonetype']." ".$row['zonelib']."
"; echo "

"._("observation")." :

";
    echo $row['observation'];
    echo "

"; echo "

\n"; echo "\t"; echo _("place").""; echo "

"; echo _("nombre de place(s) libre(s)")." ".$row['nombreplace']." ". _("occupee(s)")." ".$row['placeoccupe']."
"; echo "

"._("nombre de place(s)")." ".$row['placeconstat']." ". _("constate le")." ".$row['dateconstat']."
"; echo "

"; echo "

"; // defunt $res1=$f->db->query($sql_defunt); $f->isDatabaseError($res1); echo "

\n"; echo "\t"; echo _("defunt").""; echo ""; echo ""; while ($row1=& $res1->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; } echo "

"._("nom")."	"._("ne(e) le")."	"._("inhume le"). "	"._("exhume le")."	"._("nature")." "._("place")."
". $row1['nom'].' '.$row1['prenom'].' '.$row1['marital']."	".$row1['datenaissance']."	". $row1['dateinhumation']."	". $row1['dateexhumation']."	". $row1['nature']." [".$row1['taille']."]

"; echo "

"; // concessionnaire $res2=$f->db->query($sql_concessionnaire); $f->isDatabaseError($res2); echo "

\n"; echo "\t"; echo _("concessionnaire").""; echo ""; echo ""; while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("nom")."	"._("datenaissance")."	"._("dcd"). "
".$row2['nom'].' '.$row2['prenom'].' '.$row2['marital']."	".$row2['datenaissance']."	".$row2['dcd']."

"; echo "

"; // ayantdroit $res3=$f->db->query($sql_ayantdroit); $f->isDatabaseError($res3); echo "

\n"; echo "\t"; echo _("ayantdroit").""; echo ""; echo ""; while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("nom")."	"._("datenaissance")."	"._("dcd"). "	"._("dcd")."	"._("parente")."
".$row3['nom'].' '.$row3['prenom'].' '.$row3['marital']."	".$row3['datenaissance']."	".$row3['dcd']."	".$row3['parente']."

"; echo "

"; // courrier $res4=$f->db->query($sql_courrier); $f->isDatabaseError($res4); echo "

\n"; echo "\t"; echo _("courrier").""; echo ""; echo ""; while ($row4=& $res4->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("id")."	"._("nom")."	"._("lettretype"). "	"._("date")."
"._("Edition")."	".$row4['nom']."	".$row4['lettretype']."	".$row4['date']."

"; echo "

"; // operation $res5=$f->db->query($sql_operation); $f->isDatabaseError($res5); echo "

\n"; echo "\t"; echo _("operation").""; echo ""; echo ""; while ($row5=& $res5->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("numdossier")."	"._("nom")."	"._("categorie"). "	"._("date")."	"._("etat")."
".$row5['numdossier']."	".$row5['nom']."	".$row5['categorie']."	".$row5['date']."	".$row5['etat']."

"; echo "

"; // dossier $res6=$f->db->query($sql_dossier); $f->isDatabaseError($res6); echo "

\n"; echo "\t"; echo _("dossier").""; echo ""; echo ""; while ($row6=& $res6->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("fichier")."	"._("date")."	"._("typedossier")."
	".$row6['date']."	".$row6['typedossier']."

"; echo "

"; // travaux $res7=$f->db->query($sql_travaux); $f->isDatabaseError($res7); echo "

\n"; echo "\t"; echo _("travaux").""; echo ""; echo ""; while ($row7=& $res7->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"._("entreprise")."	"._("debut")."	". _("fin")."	"._("demandeur")."	"._("nature")."
".$row7['entreprise']."	".$row7['debut']."	".$row7['fin']."	".$row7['demandeur']."	".$row7['nature']."

"; echo "

"; } if($existe==0){ $msg=$idx._("inexistant")." "._("dans")." "._("openCimetiere"); $f->displayMessage($class, $message); } ?>