/[openfoncier]/trunk/obj/dossier.class.php
ViewVC logotype

Diff of /trunk/obj/dossier.class.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 152 by fraynaud, Thu Sep 29 15:23:51 2011 UTC revision 160 by fraynaud, Fri Sep 30 17:15:17 2011 UTC
# Line 1013  class dossier extends dossier_gen { Line 1013  class dossier extends dossier_gen {
1013    
1014      function calcul_auto_servitude_ligne($id,&$db,$geom,$projection){      function calcul_auto_servitude_ligne($id,&$db,$geom,$projection){
1015          // recherche servitude ligne          // recherche servitude ligne
         //$distance=100;  
1016          $sql="select * from servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre),  geometryfromtext('".$geom."', ".$projection."))";          $sql="select * from servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre),  geometryfromtext('".$geom."', ".$projection."))";
1017          $res=$db->query($sql);          $res=$db->query($sql);
1018          if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql);          if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql);
# Line 1026  class dossier extends dossier_gen { Line 1025  class dossier extends dossier_gen {
1025    
1026      function calcul_auto_servitude_point($id,&$db,$geom,$projection){      function calcul_auto_servitude_point($id,&$db,$geom,$projection){
1027          // recherche servitude point          // recherche servitude point
         //$distance=500; // monuments historiques  
1028          $sql="select libelle,observation, perimetre, distance(geom, geometryfromtext('".$geom."', ".$projection.")) as distance from servitude_point WHERE distance(geom,  geometryfromtext('".$geom."', ".$projection."))<perimetre";          $sql="select libelle,observation, perimetre, distance(geom, geometryfromtext('".$geom."', ".$projection.")) as distance from servitude_point WHERE distance(geom,  geometryfromtext('".$geom."', ".$projection."))<perimetre";
1029          $res=$db->query($sql);          $res=$db->query($sql);
1030          if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql);          if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql);
Legend:
Removed from v.152  
changed lines
  Added in v.160
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26