setFlag("htmlonly"); } } $f->display(); if($menu==1) // html only $f->displayStartContent(); // db if(file_exists ("../sql/".$f->db->phptype."/dossier.scr.inc.php")) include ("../sql/".$f->db->phptype."/dossier.scr.inc.php"); $res=$f->db->query($sql_dossier); $f->isDatabaseError($res); if(isset($f->collectivite["departement"])) $departement =$f->collectivite["departement"]; else $departement=""; if(isset($f->collectivite["commune"])) $commune = $f->collectivite["commune"]; else $commune=""; while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ $existe=1; // dossier echo "

\n"; echo "\t

"; echo _("Dossier ")."

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // dossier caracteristique echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\t\t\t

"._("tableau_bord")." "._("dossier")." ".$row['nature']."
No ".$departement." ".$commune." ".$row['dossier']." "._("date_depot")." :".$row['date_depot']."
"._("demandeur_nom")." : ".$row['demandeur_civilite']." ". $row['demandeur_nom']." "; echo ""._("demandeur_adresse")." : ".$row['demandeur_adresse']." ". $row['demandeur_cp']." - ".$row['demandeur_ville']."
"._("demandeur_societe")." : ".$row['demandeur_societe']."
"._("Sig")." adresse du terrain : ". $row['terrain_numero']." ". $row['terrain_adresse']." ".$row['terrain_cp']." - ". $row['terrain_ville']." "; echo ""._("Sig")." parcelle : ". $row['parcelle']." "; echo ""._("Sig")." dossier : ". $row['dossier']."
Amenagement : ". $row['amenagement']." - ".$row['parcelle_lot_lotissement']."
"._("servitude")." : ".$row['servitude']." "; echo ""; echo "
"._("caracteristique")." :
"._("shob")." : ".$row['shob']. " m2	"._("shon")." : ".$row['shon']." m2 "; echo "	"._("hauteur")." :".$row['hauteur']." m	"._("logement_nombre")." :". $row['logement_nombre']."	"._("batiment_nombre")." : ".$row['batiment_nombre']."
"._("travaux")." : ".$row['travaux'].' - '.$row['travaux_complement']."
"._("Etat")." "._("instruction")." :
"._("date_depot")." : ".$row['date_depot']." "; echo "	"._("date_notification_delai")." : ". $row['date_notification_delai']." - "; echo "	"._("date_limite").": ".$row['date_limite']. "
"._("date_validite")." : ".$row['date_validite']." "; echo "	"._("date_chantier")." : ". $row['date_chantier'].""; echo "	"._("date_achevement").": ".$row['date_achevement']. "	"._("date_conformite").": ".$row['date_conformite']."

\n"; echo "

"; // instruction $res1=$f->db->query($sql_instruction); $f->isDatabaseError($res1); echo "

\n"; echo "\t

"; echo _("Instruction ")."

"; echo ""; echo ""; while ($row1=& $res1->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; } echo "

	"._("evenement")."	"._("lettretype")."	"._("datecourrier")."
"._("Edition")."	".$row1['evenement']."	". $row1['lettretype']."	".$row1['datecourrier']."

"; echo "

"; // consultation echo "

\n"; echo "\t

"; echo _("Consultation ")."

"; $res2=$f->db->query($sql_consultation); $f->isDatabaseError($res2); echo ""; echo ""; while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; } echo "

	"._("date_envoi")."	"._("avis"). "	"._("date_envoi")."	"._("date_limite")."
"._("Edition")."	".$row2['envoi']."	".$row2['avis']."	". $row2['retour']."	".$row2['limite']."

"; echo "

"; // terrain echo "

\n"; echo "\t

"; echo _("Terrain ")."

"; $res3=$f->db->query($sql_terrain); $f->isDatabaseError($res3); echo ""; echo ""; while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; } echo "

"._("parcelle")."	"._("proprietaire"). "	"._("surface")."
"._("Sig")." ".$row3['parcelle']."	". $row3['proprietaire']."	".$row3['surface']." m2

"; echo "

"; // destination_shon echo "

\n"; echo "\t

"; echo _("Destination")."

"; $res4=$f->db->query($sql_destination_shon); $f->isDatabaseError($res4); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($row4=& $res4->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

No	"._("destination")."	". _("shon")."	"._("shon_anterieure")."	"._("shon_demolie")."	"._("shon_anterieure_supprimee")."	"._("shon_nouvelle_transformee")."	"._("shon_nouvelle")."	"._("shon_shob_transformee")."
".$row4['no']."	". $row4['libelle']."	".$row4['shon']." m2	".$row4['shon_anterieure']." m2	".$row4['shon_demolie']." m2	".$row4['shon_anterieure_supprimee']." m2	".$row4['shon_nouvelle_transformee']." m2	".$row4['shon_nouvelle']." m2	".$row4['shon_shob_transformee']." m2

"; echo "

"; // modificatif echo "

\n"; echo "\t

"; echo _("Modificatif")." "._("transfert")."

"; $res5=$f->db->query($sql_modificatif); $f->isDatabaseError($res5); echo ""; echo ""; while ($row5=& $res5->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; }else{ echo "".$row5['demande'].""; echo ""; } } echo "

"._("date_demande")."	"._("demandeur_nom"). "	"._("Etat")."
"; if($modificatif==0){ echo " ".$row5['demande']."	".$row5['demandeur_nom']."	".$row5['etat']."
".$row5['demandeur_nom']."	".$row5['etat']."

"; echo "

"; // statistique echo "

\n"; echo "\t

"; echo _("Statistique")." "."

"; $res6=$f->db->query($sql_statistique); $f->isDatabaseError($res6); echo ""; echo ""; while ($row6=& $res6->fetchRow(DB_FETCHMODE_ASSOC)){ echo ""; echo ""; echo ""; } echo "

"._("statistique")."	". _("parametre")."	"._("valeur")."
"; echo $row6['statistique']."	".$row6['parametre']."	".$row6['valeur']."

"; echo "

"; } // while dossier if($menu==0){ if($modificatif==0){ echo ""; $f->displayLinkJsCloseWindow(); // **** echo ""; $f->displayEndContent(); } } if($existe==0){ $msg=$idx._(" inexistant en base openFoncier"); $f->displayMessage($class, $message); } ?>