| 1 |
fraynaud |
88 |
<?php |
| 2 |
|
|
/* |
| 3 |
fmichon |
1184 |
$Id$ |
| 4 |
fraynaud |
88 |
*/ |
| 5 |
|
|
// INITIALISATION DES VARIABLES |
| 6 |
|
|
include ("../dyn/var.inc"); |
| 7 |
|
|
$DEBUG = 0; |
| 8 |
|
|
$existe=0; |
| 9 |
|
|
if(isset($_GET['menu'])) |
| 10 |
|
|
$menu=$_GET['menu']; |
| 11 |
|
|
else |
| 12 |
|
|
$menu=0; |
| 13 |
|
|
// utils |
| 14 |
|
|
require_once "../obj/utils.class.php"; |
| 15 |
jbastide |
158 |
if($menu==1 or $menu==2) |
| 16 |
fraynaud |
88 |
$f = new utils(NULL, "dossier", _("dossier"), "ico_dossier.png", "dossier"); |
| 17 |
|
|
else{ // sans menu |
| 18 |
jbastide |
158 |
if($menu==0){ |
| 19 |
fraynaud |
88 |
$f = new utils('nohtml', "dossier", _("dossier"), "ico_dossier.png", "dossier"); |
| 20 |
jbastide |
158 |
$f->setFlag("htmlonly"); |
| 21 |
|
|
} |
| 22 |
fraynaud |
88 |
} |
| 23 |
vpihour |
3229 |
$menu = $f->get_submitted_get_value('menu'); |
| 24 |
|
|
if($f->get_submitted_get_value('id')!==null) |
| 25 |
|
|
$id=$f->get_submitted_get_value('id'); |
| 26 |
|
|
else |
| 27 |
|
|
$id=""; |
| 28 |
|
|
if($f->get_submitted_get_value('modificatif')!==null) |
| 29 |
|
|
$modificatif=$f->get_submitted_get_value('modificatif'); |
| 30 |
|
|
else |
| 31 |
|
|
$modificatif=0; |
| 32 |
fraynaud |
88 |
$f->display(); |
| 33 |
jbastide |
156 |
if($menu==1) // html only |
| 34 |
fraynaud |
104 |
$f->displayStartContent(); |
| 35 |
jbastide |
158 |
|
| 36 |
fraynaud |
88 |
// db |
| 37 |
fmichon |
3172 |
if(file_exists ("../sql/".OM_DB_PHPTYPE."/dossier.scr.inc.php")) |
| 38 |
|
|
include ("../sql/".OM_DB_PHPTYPE."/dossier.scr.inc.php"); |
| 39 |
fraynaud |
88 |
$res=$f->db->query($sql_dossier); |
| 40 |
|
|
$f->isDatabaseError($res); |
| 41 |
fraynaud |
126 |
if(isset($f->collectivite["departement"])) |
| 42 |
|
|
$departement =$f->collectivite["departement"]; |
| 43 |
|
|
else |
| 44 |
|
|
$departement=""; |
| 45 |
|
|
|
| 46 |
|
|
if(isset($f->collectivite["commune"])) |
| 47 |
|
|
$commune = $f->collectivite["commune"]; |
| 48 |
|
|
else |
| 49 |
|
|
$commune=""; |
| 50 |
fraynaud |
104 |
|
| 51 |
fraynaud |
88 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 52 |
|
|
$existe=1; |
| 53 |
|
|
// dossier |
| 54 |
|
|
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content collapsible\">\n"; |
| 55 |
|
|
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
| 56 |
|
|
echo _("Dossier ")."</legend>"; |
| 57 |
fraynaud |
152 |
echo "<table width='95%'>"; |
| 58 |
|
|
echo "<tr><td colspan='5'><b>"._("tableau_bord")." "._("dossier")." ".$row['nature']."</b></td></tr>"; |
| 59 |
fraynaud |
197 |
echo "<tr><td colspan='5'><i> No </i> ".$departement." ".$commune." ".$row['dossier']." <i>"._("date_depot")." :</i>".$row['date_depot']."</td></tr>"; |
| 60 |
nhaye |
1373 |
echo "<tr><td colspan='5'>"; |
| 61 |
fraynaud |
197 |
echo "<a class='liendossier' href='".$lien_sig.$row['parcelle']."' target=_blank><span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span><i> parcelle : </i>". |
| 62 |
fraynaud |
104 |
$row['parcelle']."</a><br>"; |
| 63 |
fraynaud |
197 |
echo "<a class='liendossier' href='".$lien_sig2.$row['dossier']."' target=_blank><span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span><i> dossier : </i>". |
| 64 |
fraynaud |
152 |
$row['dossier']."</a></td></tr>"; |
| 65 |
fraynaud |
197 |
echo "<tr><td colspan='5'><b><i>Amenagement : </i></b><a class='liendossier' href='dossier.php?id=".$row['amenagement']."&menu=1'>". |
| 66 |
fraynaud |
152 |
$row['amenagement']."</a> - ".$row['parcelle_lot_lotissement']."</td></tr>"; |
| 67 |
fraynaud |
104 |
// dossier caracteristique |
| 68 |
fraynaud |
197 |
echo "<tr><td colspan='5'><b><i>"._("servitude")." : </i></b>".$row['servitude']."<br>"; |
| 69 |
fraynaud |
152 |
echo ""; |
| 70 |
fraynaud |
197 |
echo "<tr ><td colspan='5'><b><i>"._("caracteristique")." : </i></b></td><tr>"; |
| 71 |
|
|
echo "<tr><td><i>"._("shob")." : </i>".$row['shob']. |
| 72 |
|
|
" m2 </td><td><i>"._("shon")." : </i>".$row['shon']." m2 "; |
| 73 |
|
|
echo "</td><td><i>"._("hauteur")." :</i>".$row['hauteur']." m </td><td><i>"._("logement_nombre")." :</i>". |
| 74 |
|
|
$row['logement_nombre']."</td><td><i>"._("batiment_nombre")." : </i>".$row['batiment_nombre']."</td><tr>"; |
| 75 |
|
|
echo "<tr ><td colspan='5'><b><i>"._("Etat")." "._("instruction")." : </i></b></td><tr>"; |
| 76 |
|
|
echo "<tr><td><i>"._("date_depot")." : </i>".$row['date_depot']." "; |
| 77 |
|
|
echo "</td><td><i>"._("date_notification_delai")." : </i>". |
| 78 |
fraynaud |
88 |
$row['date_notification_delai']." - "; |
| 79 |
fraynaud |
197 |
echo "</td><td><i>"._("date_limite").": </i>".$row['date_limite']. |
| 80 |
fraynaud |
88 |
"</td><td></td><td></td></tr>"; |
| 81 |
fraynaud |
197 |
echo "<tr><td><i>"._("date_validite")." : </i>".$row['date_validite']." "; |
| 82 |
|
|
echo "</td><td><i>"._("date_chantier")." : </i>". |
| 83 |
|
|
$row['date_chantier'].""; |
| 84 |
|
|
echo "</td><td><i>"._("date_achevement").": </i>".$row['date_achevement']. |
| 85 |
|
|
"</td><td><i>"._("date_conformite").": </i>".$row['date_conformite']."</td><td></td></tr>"; |
| 86 |
fraynaud |
88 |
echo "\t\t\t</table>\n"; |
| 87 |
|
|
echo "</fieldset>"; |
| 88 |
|
|
// instruction |
| 89 |
|
|
$res1=$f->db->query($sql_instruction); |
| 90 |
|
|
$f->isDatabaseError($res1); |
| 91 |
|
|
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content startClosed\">\n"; |
| 92 |
|
|
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
| 93 |
|
|
echo _("Instruction ")."</legend>"; |
| 94 |
|
|
echo "<table width='95%'>"; |
| 95 |
vpihour |
1127 |
echo "<tr><td></td><td><i>"._("evenement")."</i></td><td><i>"._("lettretype")."</i></td><td><i>"._("date_evenement")."</i></td><tr>"; |
| 96 |
fraynaud |
88 |
while ($row1=& $res1->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 97 |
fmichon |
1363 |
echo "<tr><td><a class='liendossier' target='_blank' href='../app/pdf_instruction.php?idx=". |
| 98 |
jbastide |
162 |
$row1['instruction']."' ><span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\""._("Edition")."\">"._("Edition")."</span></a></td>"; |
| 99 |
fraynaud |
88 |
echo "<td>".$row1['evenement']."</td><td>". |
| 100 |
vpihour |
1127 |
$row1['lettretype']."</td><td>".$row1['date_evenement']."</td><tr>"; |
| 101 |
fraynaud |
88 |
} |
| 102 |
|
|
echo "</table>"; |
| 103 |
|
|
echo "</fieldset>"; |
| 104 |
|
|
|
| 105 |
|
|
// consultation |
| 106 |
|
|
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content startClosed\">\n"; |
| 107 |
|
|
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
| 108 |
|
|
echo _("Consultation ")."</legend>"; |
| 109 |
|
|
$res2=$f->db->query($sql_consultation); |
| 110 |
|
|
$f->isDatabaseError($res2); |
| 111 |
|
|
echo "<table width='95%'>"; |
| 112 |
vpihour |
510 |
echo "<tr><td></td><td><i>"._("date_envoi")."</i></td><td><i>"._("avis_consultation"). |
| 113 |
fraynaud |
197 |
"</i></td><td><i>"._("date_envoi")."</i></td><td><i>"._("date_limite")."</i></td><tr>"; |
| 114 |
fraynaud |
88 |
while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 115 |
fmichon |
1341 |
echo "<tr><td><a class='liendossier' href='../app/pdf_consultation.php?obj=consultation&idx=". |
| 116 |
jbastide |
162 |
$row2['consultation']."' ><span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\""._("Edition")."\">"._("Edition")."</span></a></td>"; |
| 117 |
vpihour |
510 |
echo "<td>".$row2['envoi']."</td><td>".$row2['avis_consultation']."</td><td>". |
| 118 |
fraynaud |
88 |
$row2['retour']."</td><td>".$row2['limite']."</td><tr>"; |
| 119 |
|
|
} |
| 120 |
|
|
echo "</table>"; |
| 121 |
|
|
echo "</fieldset>"; |
| 122 |
|
|
|
| 123 |
|
|
// terrain |
| 124 |
|
|
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content startClosed\">\n"; |
| 125 |
|
|
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
| 126 |
|
|
echo _("Terrain ")."</legend>"; |
| 127 |
|
|
$res3=$f->db->query($sql_terrain); |
| 128 |
|
|
$f->isDatabaseError($res3); |
| 129 |
|
|
echo "<table width='95%'>"; |
| 130 |
fraynaud |
197 |
echo "<tr><td><i>"._("parcelle")."</i></td><td><i>"._("proprietaire"). |
| 131 |
|
|
"</i></td><td><i>"._("surface")."</i></td><tr>"; |
| 132 |
fraynaud |
88 |
while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 133 |
jbastide |
162 |
echo "<tr><td><a class='liendossier' href='".$lien_sig.$row3['parcelle']. |
| 134 |
|
|
"' target=_blank><span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span> ".$row3['parcelle']."</td><td>". |
| 135 |
fraynaud |
88 |
$row3['proprietaire']."</td><td>".$row3['surface']." m2</td><tr>"; |
| 136 |
|
|
} |
| 137 |
|
|
echo "</table>"; |
| 138 |
|
|
echo "</fieldset>"; |
| 139 |
|
|
|
| 140 |
fraynaud |
196 |
|
| 141 |
fraynaud |
88 |
// modificatif |
| 142 |
|
|
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content startClosed\">\n"; |
| 143 |
|
|
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
| 144 |
fraynaud |
152 |
echo _("Modificatif")." "._("transfert")."</legend>"; |
| 145 |
fraynaud |
88 |
$res5=$f->db->query($sql_modificatif); |
| 146 |
|
|
$f->isDatabaseError($res5); |
| 147 |
|
|
echo "<table width='95%'>"; |
| 148 |
nhaye |
1373 |
echo "<tr><td><i>"._("date_demande")."</i></td><td></td><td><i>"._("Etat")."</i></td><tr>"; |
| 149 |
fraynaud |
88 |
while ($row5=& $res5->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 150 |
fraynaud |
104 |
echo "<tr><td>"; |
| 151 |
fraynaud |
196 |
if($modificatif==0){ |
| 152 |
|
|
echo "<a class='liendossier' href='dossier.php?id=". |
| 153 |
|
|
$row5['dossier']."&menu=".$menu."' ><img src='img/ico_exemplaire.png'> ".$row5['demande']."</a></td>"; |
| 154 |
nhaye |
1373 |
echo "<td></td><td>".$row5['etat']."</td><tr>"; |
| 155 |
fraynaud |
196 |
}else{ |
| 156 |
|
|
echo "".$row5['demande']."</td>"; |
| 157 |
nhaye |
1373 |
echo "<td></td><td>".$row5['etat']."</td><tr>"; |
| 158 |
fraynaud |
196 |
} |
| 159 |
fraynaud |
88 |
} |
| 160 |
|
|
echo "</table>"; |
| 161 |
|
|
echo "</fieldset>"; |
| 162 |
|
|
} // while dossier |
| 163 |
fraynaud |
104 |
if($menu==0){ |
| 164 |
fraynaud |
122 |
if($modificatif==0){ |
| 165 |
fraynaud |
104 |
echo "<center>"; |
| 166 |
|
|
$f->displayLinkJsCloseWindow(); // **** |
| 167 |
|
|
echo "</center>"; |
| 168 |
|
|
$f->displayEndContent(); |
| 169 |
fraynaud |
122 |
} |
| 170 |
fraynaud |
104 |
} |
| 171 |
jbastide |
158 |
|
| 172 |
fraynaud |
88 |
if($existe==0){ |
| 173 |
fraynaud |
104 |
$msg=$idx._(" inexistant en base openFoncier"); |
| 174 |
fraynaud |
88 |
$f->displayMessage($class, $message); |
| 175 |
|
|
} |
| 176 |
|
|
?> |
Parent Directory
| 
Revision Log