14 |
$menu=$_GET['menu']; |
$menu=$_GET['menu']; |
15 |
else |
else |
16 |
$menu=0; |
$menu=0; |
17 |
|
if(isset($_GET['modificatif'])) |
18 |
|
$modificatif=$_GET['modificatif']; |
19 |
|
else |
20 |
|
$modificatif=0; |
21 |
// utils |
// utils |
22 |
require_once "../obj/utils.class.php"; |
require_once "../obj/utils.class.php"; |
23 |
if($menu==1) |
if($menu==1) |
27 |
$f->setFlag("htmlonly"); |
$f->setFlag("htmlonly"); |
28 |
} |
} |
29 |
$f->display(); |
$f->display(); |
30 |
|
if($menu==0) // html only |
31 |
|
$f->displayStartContent(); |
32 |
// db |
// db |
33 |
if(file_exists ("../sql/".$f->db->phptype."/dossier.scr.inc")) |
if(file_exists ("../sql/".$f->db->phptype."/dossier.scr.inc")) |
34 |
include ("../sql/".$f->db->phptype."/dossier.scr.inc"); |
include ("../sql/".$f->db->phptype."/dossier.scr.inc"); |
35 |
$res=$f->db->query($sql_dossier); |
$res=$f->db->query($sql_dossier); |
36 |
$f->isDatabaseError($res); |
$f->isDatabaseError($res); |
37 |
|
|
38 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
39 |
$existe=1; |
$existe=1; |
40 |
// dossier |
// dossier |
41 |
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content collapsible\">\n"; |
echo "<fieldset class=\"cadre ui-corner-all ui-widget-content collapsible\">\n"; |
42 |
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
echo "\t<legend class=\"ui-corner-all ui-widget-content ui-state-active\">"; |
43 |
echo _("Dossier ")."</legend>"; |
echo _("Dossier ")."</legend>"; |
44 |
echo "<table width='95%'>"; |
echo "<b>"._("tableau_bord")." "._("dossier")." ".$row['nature']."</b><br>"; |
45 |
echo "<tr><td><b>"._("tableau_bord")." "._("dossier")." ".$row['nature']."</b></td>"; |
echo " No ".$departement." ".$commune." ". |
46 |
if($menu==1){ |
$row['dossier']." "._("date_depot")." ".$row['date_depot']."<br>"; |
47 |
echo "<td align='right'>"; |
echo " "._("demandeur_nom")." : ".$row['demandeur_civilite']." ". |
48 |
echo "</center></a></span></td><tr></table>"; |
$row['demandeur_nom']."<br>"; |
49 |
}else{ |
echo ""._("demandeur_adresse")." : ".$row['demandeur_adresse']." ". |
50 |
echo "<td align='right'><a href='#' onclick='window.close();'><img src='../img/fermer_fenetre.gif' align='middle' alt='"._("fermer")."' title='"._("fermer")."' hspace='5' border='0'>"; |
$row['demandeur_cp']." - ".$row['demandeur_ville']."<br>"; |
51 |
echo "</center></a></span></td><tr></table>"; |
echo " "._("demandeur_societe")." : ".$row['demandeur_societe']."<br>"; |
52 |
} |
echo "<br>"; |
53 |
echo "<table width='95%'><tr><td> No ".$departement." ".$commune." ". |
echo "<a class='liendossier' href='".$lien_sig1.$row['rivoli'].$row['terrain_numero']. |
54 |
$row['dossier']." "._("date_depot")." ".$row['date_depot']."</td><tr>"; |
"' target=_blank><img src='img/sig.png'> adresse du terrain : ". |
55 |
echo "<tr ><td> "._("demandeur_nom")." : ".$row['demandeur_civilite']." ". |
$row['terrain_numero']." ". |
56 |
$row['demandeur_nom']."</td><tr>"; |
$row['terrain_adresse']." ".$row['terrain_cp']." - ". |
57 |
echo "<tr><td>"._("demandeur_adresse")." : ".$row['demandeur_adresse']." ". |
$row['terrain_ville']."</a><br>"; |
58 |
$row['demandeur_cp']." - ".$row['demandeur_ville']."</td><tr>"; |
echo "<a class='liendossier' href='".$lien_sig.$row['parcelle']."' target=_blank><img src='img/sig.png'> parcelle : ". |
59 |
echo "<tr><td> "._("demandeur_societe")." : ".$row['demandeur_societe']."</td><tr>"; |
$row['parcelle']."</a><br>"; |
60 |
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='". |
echo "<a class='liendossier' href='".$lien_sig2.$row['dossier']."' target=_blank><img src='img/sig.png'> dossier : ". |
61 |
$lien_sig1.$row['rivoli'].$row['terrain_numero']. |
$row['dossier']."</a><br>"; |
62 |
"' target=_blank><img src='../trs/".$image_sig."'> adresse du terrain : ". |
// dossier caracteristique |
|
$row['terrain_numero']." ". |
|
|
$row['terrain_adresse']." ".$row['terrain_cp']." - ". |
|
|
$row['terrain_ville']. |
|
|
"<br></td><tr>"; |
|
|
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='". |
|
|
$lien_sig.$row['parcelle']."' target=_blank><img src='../trs/".$image_sig."'> parcelle : ". |
|
|
$row['parcelle']."<br></td>"; |
|
|
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='". |
|
|
$lien_sig2.$row['dossier']."' target=_blank><img src='../trs/".$image_sig."'> dossier : ". |
|
|
$row['dossier']."<br></td><tr>"; |
|
|
echo "</table>"; |
|
63 |
echo "<table width='95%'>"; |
echo "<table width='95%'>"; |
64 |
echo "<tr ><td colspan='5'><b>"._("caracteristique")." : </b></td><tr>"; |
echo "<tr ><td colspan='5'><b>"._("caracteristique")." : </b></td><tr>"; |
65 |
echo "<tr><td>"._("shob")." : ".$row['shob']. |
echo "<tr><td>"._("shob")." : ".$row['shob']. |
79 |
"</td><td>"._("date_conformite").": ".$row['date_conformite']."</td><td></td></tr>"; |
"</td><td>"._("date_conformite").": ".$row['date_conformite']."</td><td></td></tr>"; |
80 |
echo "\t\t\t</table>\n"; |
echo "\t\t\t</table>\n"; |
81 |
echo "</fieldset>"; |
echo "</fieldset>"; |
|
|
|
82 |
// instruction |
// instruction |
83 |
$res1=$f->db->query($sql_instruction); |
$res1=$f->db->query($sql_instruction); |
84 |
$f->isDatabaseError($res1); |
$f->isDatabaseError($res1); |
89 |
echo "<tr ><td colspan='4'><b>"._("instruction")."</b></td><tr>"; |
echo "<tr ><td colspan='4'><b>"._("instruction")."</b></td><tr>"; |
90 |
echo "<tr><td></td><td>"._("evenement")."</td><td>"._("lettretype")."</td><td>"._("datecourrier")."</td><tr>"; |
echo "<tr><td></td><td>"._("evenement")."</td><td>"._("lettretype")."</td><td>"._("datecourrier")."</td><tr>"; |
91 |
while ($row1=& $res1->fetchRow(DB_FETCHMODE_ASSOC)){ |
while ($row1=& $res1->fetchRow(DB_FETCHMODE_ASSOC)){ |
92 |
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='../app/pdflettretype_instruction.php?idx=". |
echo "<tr><td><img src='img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='../app/pdflettretype_instruction.php?idx=". |
93 |
$row1['instruction']."' ><img src='../img/ico_pdf.png' border=0 ></a></td>"; |
$row1['instruction']."' ><img src='img/ico_pdf.png' border=0 ></a></td>"; |
94 |
echo "<td>".$row1['evenement']."</td><td>". |
echo "<td>".$row1['evenement']."</td><td>". |
95 |
$row1['lettretype']."</td><td>".$row1['datecourrier']."</td><tr>"; |
$row1['lettretype']."</td><td>".$row1['datecourrier']."</td><tr>"; |
96 |
} |
} |
108 |
echo "<tr><td></td><td>"._("date_envoi")."</td><td>"._("avis"). |
echo "<tr><td></td><td>"._("date_envoi")."</td><td>"._("avis"). |
109 |
"</td><td>"._("date_limite")."</td><tr>"; |
"</td><td>"._("date_limite")."</td><tr>"; |
110 |
while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ |
while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ |
111 |
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='../pdf/pdfetat.php?obj=consultation&idx=". |
echo "<tr><td><img src='img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='../pdf/pdfetat.php?obj=consultation&idx=". |
112 |
$row2['consultation']."' ><img src='../img/ico_pdf.png' border=0 ></a></td>"; |
$row2['consultation']."' ><img src='img/ico_pdf.png' border=0 ></a></td>"; |
113 |
echo "<td>".$row2['envoi']."</td><td>". |
echo "<td>".$row2['envoi']."</td><td>". |
114 |
$row2['retour']."</td><td>".$row2['limite']."</td><tr>"; |
$row2['retour']."</td><td>".$row2['limite']."</td><tr>"; |
115 |
} |
} |
127 |
echo "<tr><td>"._("parcelle")."</td><td>"._("proprietaire"). |
echo "<tr><td>"._("parcelle")."</td><td>"._("proprietaire"). |
128 |
"</td><td>"._("surface")."</td><tr>"; |
"</td><td>"._("surface")."</td><tr>"; |
129 |
while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ |
while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ |
130 |
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='".$lien_sig.$row3['parcelle']. |
echo "<tr><td><img src='img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='".$lien_sig.$row3['parcelle']. |
131 |
"' target=_blank><img src='../trs/".$image_sig."'> ".$row3['parcelle']."</td><td>". |
"' target=_blank><img src='img/sig.png'> ".$row3['parcelle']."</td><td>". |
132 |
$row3['proprietaire']."</td><td>".$row3['surface']." m2</td><tr>"; |
$row3['proprietaire']."</td><td>".$row3['surface']." m2</td><tr>"; |
133 |
} |
} |
134 |
echo "</table>"; |
echo "</table>"; |
162 |
_("transfert")." : </b></td><tr>"; |
_("transfert")." : </b></td><tr>"; |
163 |
echo "<tr><td>"._("date_demande")."</td><td>"._("demandeur_nom")."</td><td>Etat</td><tr>"; |
echo "<tr><td>"._("date_demande")."</td><td>"._("demandeur_nom")."</td><td>Etat</td><tr>"; |
164 |
while ($row5=& $res5->fetchRow(DB_FETCHMODE_ASSOC)){ |
while ($row5=& $res5->fetchRow(DB_FETCHMODE_ASSOC)){ |
165 |
echo "<tr><td><img src='../img/tb_fleche.png' alt='' title='' style='vertical-align:middle'/><a class='liendossier' href='dossier.php?id=". |
echo "<tr><td>"; |
166 |
$row5['dossier']."&menu=".$menu."' ><img src='../img/ico_exemplaire.png' border=0 > ".$row5['demande']."</a></td>"; |
echo "<img src='img/ico_exemplaire.png'><a class='liendossier' href='dossier.php?id=". |
167 |
|
$row5['dossier']."&menu=".$menu."' > ".$row5['demande']."</a></td>"; |
168 |
echo "<td>".$row5['demandeur_nom']."</td><td>".$row5['etat']."</td><tr>"; |
echo "<td>".$row5['demandeur_nom']."</td><td>".$row5['etat']."</td><tr>"; |
169 |
} |
} |
170 |
echo "</table>"; |
echo "</table>"; |
171 |
echo "</fieldset>"; |
echo "</fieldset>"; |
172 |
} // while dossier |
} // while dossier |
173 |
|
if($menu==0){ |
174 |
|
if($modificatif==0){ |
175 |
|
echo "<center>"; |
176 |
|
$f->displayLinkJsCloseWindow(); // **** |
177 |
|
echo "</center>"; |
178 |
|
$f->displayEndContent(); |
179 |
|
}else{ |
180 |
|
echo "\n<a class=\"retour\" "; |
181 |
|
//echo "href=\""; |
182 |
|
//echo "#"; |
183 |
|
//echo "\" "; |
184 |
|
//echo $objsf; |
185 |
|
//echo "onclick=\"ajaxIt('modificatif', '"; |
186 |
|
//// |
187 |
|
//echo "soustab.php"; |
188 |
|
//echo "?"; |
189 |
|
//echo "obj=modificatif"; |
190 |
|
////echo "&retourformulaire=".$retourformulaire; |
191 |
|
//echo "&idxformulaire=".$id; |
192 |
|
////echo "&premier=".$premiersf; |
193 |
|
////echo "&tricol=".$tricolsf; |
194 |
|
//// |
195 |
|
//echo "');"; |
196 |
|
//echo "\""; |
197 |
|
echo "href='../soustab.php?obj=modificatif&idxformulaire=".$id; |
198 |
|
echo ">"; |
199 |
|
// |
200 |
|
echo _("Retour"); |
201 |
|
// |
202 |
|
echo "</a>\n"; |
203 |
|
} |
204 |
|
} |
205 |
if($existe==0){ |
if($existe==0){ |
206 |
$msg=$idx." inexistant en base odp"; |
$msg=$idx._(" inexistant en base openFoncier"); |
207 |
$f->displayMessage($class, $message); |
$f->displayMessage($class, $message); |
208 |
} |
} |
209 |
?> |
?> |