| 1 |
fraynaud |
332 |
<?php |
| 2 |
|
|
//$Id: form_sig_point.php 709 2011-09-15 16:23:16Z fmichon $ |
| 3 |
|
|
// *** dossier |
| 4 |
fraynaud |
334 |
/* |
| 5 |
|
|
post traitement de mise a jour du geom dans dossier |
| 6 |
|
|
- reprise du numero de parcelle -> modification en fendata (tab.php appelant) |
| 7 |
|
|
- reprise du POS |
| 8 |
|
|
- reprise des servitudes |
| 9 |
|
|
*/ |
| 10 |
|
|
|
| 11 |
|
|
if($table=="dossier" and $champ=="geom"){ |
| 12 |
fraynaud |
332 |
echo "</center>"; |
| 13 |
|
|
if (file_exists ("../dyn/var.inc")) |
| 14 |
|
|
include ("../dyn/var.inc"); |
| 15 |
|
|
// parcelle |
| 16 |
|
|
if($auto_parcelle==1){ |
| 17 |
|
|
$sql="select parcelle from ".DB_PREFIXE."parcelle WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
| 18 |
|
|
$parcelle = $f->db -> getOne($sql); |
| 19 |
|
|
if($parcelle!=''){ |
| 20 |
fraynaud |
334 |
$sql ="update ".DB_PREFIXE."dossier set parcelle = '".$parcelle."' where dossier = '".$idx."'"; |
| 21 |
|
|
$res1 = $f->db -> query($sql); |
| 22 |
|
|
echo "<br>"._("parcelle")." ".$parcelle; |
| 23 |
|
|
// Envoi des donnees dans le formulaire f1 si la fenetre est popup : A TESTER |
| 24 |
|
|
if($popup==1){ |
| 25 |
|
|
echo "\n<script type=\"text/javascript\">\n"; |
| 26 |
|
|
echo "window.opener.fendata.document.f1.parcelle.value = '".$parcelle."';\n"; |
| 27 |
|
|
//echo "window.opener.fendata.reload"; |
| 28 |
|
|
echo "</script>\n"; |
| 29 |
|
|
} |
| 30 |
fraynaud |
332 |
} |
| 31 |
|
|
} |
| 32 |
|
|
//pos |
| 33 |
|
|
if($auto_pos==1){ |
| 34 |
|
|
$sql="select pos from ".DB_PREFIXE."pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
| 35 |
|
|
$pos = $f->db -> getOne($sql); |
| 36 |
fraynaud |
334 |
if($pos!=''){ |
| 37 |
fraynaud |
332 |
$sql ="update ".DB_PREFIXE."dossier set pos = '".$pos."' where dossier = '".$idx."'"; |
| 38 |
|
|
$res1 = $f->db -> query($sql); |
| 39 |
|
|
echo "<br>"._("pos")." ".$pos; |
| 40 |
fraynaud |
334 |
} |
| 41 |
fraynaud |
332 |
} |
| 42 |
|
|
// servitude |
| 43 |
|
|
$servitude =""; |
| 44 |
|
|
if($auto_servitude_surfacique==1){ |
| 45 |
|
|
$sql="select * from ".DB_PREFIXE."servitude_surfacique WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
| 46 |
|
|
$res2=$f->db->query($sql); |
| 47 |
|
|
if (database:: isError($res2)) die($res2->getMessage()."erreur ".$sql); |
| 48 |
|
|
while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 49 |
|
|
echo "<br>"._("servitude")." "._("surfacique")." : ".$row2['libelle']." - ".$row2['observation']; |
| 50 |
|
|
$servitude.=" [".$row2['libelle']."] ".$row2['observation']." - "; |
| 51 |
|
|
} |
| 52 |
|
|
} |
| 53 |
|
|
if($auto_servitude_ligne==1){ |
| 54 |
|
|
$sql="select * from ".DB_PREFIXE."servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre), geometryfromtext('".$geom."', ".$projection."))"; |
| 55 |
|
|
$res3=$f->db->query($sql); |
| 56 |
|
|
if (database:: isError($res3)) die($res3->getMessage()."erreur ".$sql); |
| 57 |
|
|
while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 58 |
fraynaud |
334 |
echo "<br>"._("servitude")." "._("ligne")." : ".$row3['libelle']." - ".$row3['observation']." < ".round($row3['perimetre'],2)." m - "; |
| 59 |
|
|
$servitude.=" [".$row3['libelle']."] ".$row3['observation']." < ".round($row3['perimetre'],2)." m - "; |
| 60 |
fraynaud |
332 |
} |
| 61 |
|
|
} |
| 62 |
|
|
if($auto_servitude_point==1){ |
| 63 |
|
|
$sql="select libelle,observation, distance(geom, geometryfromtext('".$geom."', ".$projection.")) as distance from ".DB_PREFIXE."servitude_point WHERE distance(geom, geometryfromtext('".$geom."', ".$projection."))< perimetre"; |
| 64 |
|
|
$res4=$f->db->query($sql); |
| 65 |
|
|
if (database:: isError($res4)) die($res4->getMessage()."erreur ".$sql); |
| 66 |
|
|
while ($row4=& $res4->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 67 |
|
|
echo "<br>"._("servitude")." "._("point")." : ".$row4['libelle']." - ". |
| 68 |
|
|
$row4['observation']." a ".round($row4['distance'],2)." m "; |
| 69 |
|
|
$servitude.=" [".$row4['libelle']."] ".$row4['observation']." a ". |
| 70 |
|
|
round($row4['distance'],2)." m - "; |
| 71 |
|
|
} |
| 72 |
|
|
} |
| 73 |
fraynaud |
334 |
$temp=strtr($servitude,"'"," "); // enleve le ' (pb avec le sql) |
| 74 |
fraynaud |
332 |
//$temp=$servitude; |
| 75 |
|
|
$sql ="update ".DB_PREFIXE."dossier set servitude = '".$temp."' where dossier = '".$idx."'"; |
| 76 |
|
|
$res5 = $f->db -> query($sql); |
| 77 |
|
|
if (database:: isError($res5)) die($res5->getMessage()."erreur ".$sql); |
| 78 |
|
|
echo "<center>"; |
| 79 |
|
|
} |
| 80 |
|
|
?> |
Parent Directory
| 
Revision Log