modification en fendata (tab.php appelant)
- reprise du POS
- reprise des servitudes
*/
if($table=="dossier" and $champ=="geom"){
echo "";
if (file_exists ("../dyn/var.inc"))
include ("../dyn/var.inc");
// parcelle
if($auto_parcelle==1){
$sql="select parcelle from ".DB_PREFIXE."parcelle WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))";
$parcelle = $f->db -> getOne($sql);
if($parcelle!=''){
$sql ="update ".DB_PREFIXE."dossier set parcelle = '".$parcelle."' where dossier = '".$idx."'";
$res1 = $f->db -> query($sql);
echo "
"._("parcelle")." ".$parcelle;
// Envoi des donnees dans le formulaire f1 si la fenetre est popup : A TESTER
if($popup==1){
echo "\n\n";
}
}
}
//pos
if($auto_pos==1){
$sql="select pos from ".DB_PREFIXE."pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))";
$pos = $f->db -> getOne($sql);
if($pos!=''){
$sql ="update ".DB_PREFIXE."dossier set pos = '".$pos."' where dossier = '".$idx."'";
$res1 = $f->db -> query($sql);
echo "
"._("pos")." ".$pos;
}
}
// servitude
$servitude ="";
if($auto_servitude_surfacique==1){
$sql="select * from ".DB_PREFIXE."servitude_surfacique WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))";
$res2=$f->db->query($sql);
if (database:: isError($res2)) die($res2->getMessage()."erreur ".$sql);
while ($row2=& $res2->fetchRow(DB_FETCHMODE_ASSOC)){
echo "
"._("servitude")." "._("surfacique")." : ".$row2['libelle']." - ".$row2['observation'];
$servitude.=" [".$row2['libelle']."] ".$row2['observation']." - ";
}
}
if($auto_servitude_ligne==1){
$sql="select * from ".DB_PREFIXE."servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre), geometryfromtext('".$geom."', ".$projection."))";
$res3=$f->db->query($sql);
if (database:: isError($res3)) die($res3->getMessage()."erreur ".$sql);
while ($row3=& $res3->fetchRow(DB_FETCHMODE_ASSOC)){
echo "
"._("servitude")." "._("ligne")." : ".$row3['libelle']." - ".$row3['observation']." < ".round($row3['perimetre'],2)." m - ";
$servitude.=" [".$row3['libelle']."] ".$row3['observation']." < ".round($row3['perimetre'],2)." m - ";
}
}
if($auto_servitude_point==1){
$sql="select libelle,observation, distance(geom, geometryfromtext('".$geom."', ".$projection.")) as distance from ".DB_PREFIXE."servitude_point WHERE distance(geom, geometryfromtext('".$geom."', ".$projection."))< perimetre";
$res4=$f->db->query($sql);
if (database:: isError($res4)) die($res4->getMessage()."erreur ".$sql);
while ($row4=& $res4->fetchRow(DB_FETCHMODE_ASSOC)){
echo "
"._("servitude")." "._("point")." : ".$row4['libelle']." - ".
$row4['observation']." a ".round($row4['distance'],2)." m ";
$servitude.=" [".$row4['libelle']."] ".$row4['observation']." a ".
round($row4['distance'],2)." m - ";
}
}
$temp=strtr($servitude,"'"," "); // enleve le ' (pb avec le sql)
//$temp=$servitude;
$sql ="update ".DB_PREFIXE."dossier set servitude = '".$temp."' where dossier = '".$idx."'";
$res5 = $f->db -> query($sql);
if (database:: isError($res5)) die($res5->getMessage()."erreur ".$sql);
echo "";
}
?>