74 |
include ("../dyn/var.inc"); |
include ("../dyn/var.inc"); |
75 |
if($numero_unique==1){ |
if($numero_unique==1){ |
76 |
// numero unique (voir dyn/var.inc) |
// numero unique (voir dyn/var.inc) |
77 |
$temp=$db->nextId($this->table); |
$temp=$db->nextId(DB_PREFIXE.$this->table); |
78 |
}else{ |
}else{ |
79 |
// numero suivant nature |
// numero suivant nature |
80 |
$temp=$db->nextId("dossier_".$this->nature); |
$temp=$db->nextId(DB_PREFIXE."dossier_".$this->nature); |
81 |
} |
} |
82 |
$temp=str_pad($temp,4,"0", STR_PAD_LEFT); |
$temp=str_pad($temp,4,"0", STR_PAD_LEFT); |
83 |
$this->valF['dossier'] = $this->valF['nature'].$this->valF['annee']. |
$this->valF['dossier'] = $this->valF['nature'].$this->valF['annee']. |
105 |
} |
} |
106 |
// regles travaux verification |
// regles travaux verification |
107 |
if ($this->valF['travaux']!=""){ |
if ($this->valF['travaux']!=""){ |
108 |
$sql= "select * from regle where id = '".$this->valF['travaux']. |
$sql= "select * from ".DB_PREFIXE."regle where id = '".$this->valF['travaux']. |
109 |
"' and controle = 'travaux' order by ordre"; |
"' and controle = 'travaux' order by ordre"; |
110 |
$res = $db->query($sql); |
$res = $db->query($sql); |
111 |
if (database :: isError($res)) die($res->getMessage().$sql); |
if (database :: isError($res)) die($res->getMessage().$sql); |
236 |
$form->setType('parcelle_lot_lotissement','hidden'); // PC |
$form->setType('parcelle_lot_lotissement','hidden'); // PC |
237 |
$form->setType('geom', 'hidden'); |
$form->setType('geom', 'hidden'); |
238 |
$form->setType('servitude', 'hiddenstatic'); |
$form->setType('servitude', 'hiddenstatic'); |
239 |
|
$form->setType('description', 'textarea'); |
240 |
|
|
241 |
// date |
// date |
242 |
$form->setType('date_depot','date'); |
$form->setType('date_depot','date'); |
249 |
$form->setType('delegataire_civilite','select'); |
$form->setType('delegataire_civilite','select'); |
250 |
$form->setType('demandeur_civilite','select'); |
$form->setType('demandeur_civilite','select'); |
251 |
$form->setType('demandeur_categorie','select'); |
$form->setType('demandeur_categorie','select'); |
252 |
$form->setType('pos','select'); |
|
253 |
|
|
254 |
// combo |
// combo |
255 |
$form->setType('rivoli','comboD'); |
$form->setType('rivoli','comboD'); |
294 |
|
|
295 |
|
|
296 |
// temp |
// temp |
297 |
include ("../dyn/var.inc"); |
if (file_exists ("../dyn/var.inc")) |
298 |
|
include ("../dyn/var.inc"); |
299 |
|
if(!isset($auto_pos)) |
300 |
|
$auto_pos=0; |
301 |
|
if($auto_pos==1) |
302 |
|
$form->setType('pos','hiddenstatic'); |
303 |
|
else |
304 |
|
$form->setType('pos','select'); |
305 |
$form->setType('temp1',$temp1_type); |
$form->setType('temp1',$temp1_type); |
306 |
$form->setType('temp2',$temp2_type); |
$form->setType('temp2',$temp2_type); |
307 |
$form->setType('temp3',$temp3_type); |
$form->setType('temp3',$temp3_type); |
313 |
} |
} |
314 |
} |
} |
315 |
|
|
|
|
|
|
function setMax(&$form,$maj){ |
|
|
$form->setMax('architecte_nom', 30); |
|
|
|
|
|
$form->setMax('demandeur_nom', 80); |
|
|
$form->setMax('demandeur_societe', 80); |
|
|
$form->setMax('demandeur_adresse', 40); |
|
|
$form->setMax('demandeur_cp', 5); |
|
|
$form->setMax('demandeur_ville', 30); |
|
|
$form->setMax('demandeur_pays', 40); |
|
|
$form->setMax('demandeur_telephone', 14); |
|
|
$form->setMax('demandeur_email', 40); |
|
|
|
|
|
$form->setMax('delegataire_societe', 80); |
|
|
$form->setMax('delegataire_nom', 80); |
|
|
$form->setMax('delegataire_adresse', 80); |
|
|
$form->setMax('delegataire_pays', 40); |
|
|
$form->setMax('delegataire_cp', 5); |
|
|
$form->setMax('delegataire_ville', 30); |
|
|
$form->setMax('delegataire_telephone', 14); |
|
|
$form->setMax('delegataire_email', 40); |
|
|
|
|
|
$form->setMax('terrain_adresse', 80); |
|
|
$form->setMax('terrain_numero', 4); |
|
|
$form->setMax('terrain_adresse_complement', 80); |
|
|
$form->setMax('rivoli', 4); |
|
|
$form->setMax('terrain_cp', 5); |
|
|
$form->setMax('terrain_ville', 30); |
|
|
|
|
|
$form->setMax('parcelle', 20); |
|
|
|
|
|
$form->setMax('temp1', 100); |
|
|
$form->setMax('temp2', 100); |
|
|
$form->setMax('temp3', 100); |
|
|
$form->setMax('temp4', 100); |
|
|
$form->setMax('temp5', 100); |
|
|
} |
|
|
|
|
|
function setTaille(&$form,$maj){ |
|
|
// date |
|
|
$form->setTaille('date_demande', 12); |
|
|
$form->setTaille('date_notification_delai', 12); |
|
|
$form->setTaille('date_decision', 12); |
|
|
$form->setTaille('date_limite', 12); |
|
|
$form->setTaille('date_depot', 12); |
|
|
// demandeur |
|
|
$form->setTaille('demandeur_nom', 20); |
|
|
$form->setTaille('demandeur_societe', 20); |
|
|
$form->setTaille('demandeur_adresse', 30); |
|
|
$form->setTaille('demandeur_cp', 5); |
|
|
$form->setTaille('demandeur_ville', 20); |
|
|
$form->setTaille('demandeur_pays', 20); |
|
|
$form->setTaille('demandeur_telephone', 14); |
|
|
$form->setTaille('demandeur_email', 20); |
|
|
// delegataire |
|
|
$form->setTaille('delegataire_societe', 20); |
|
|
$form->setTaille('delegataire_nom', 20); |
|
|
$form->setTaille('delegataire_adresse', 30); |
|
|
$form->setTaille('delegataire_pays', 20); |
|
|
$form->setTaille('delegataire_cp', 5); |
|
|
$form->setTaille('delegataire_ville', 20); |
|
|
$form->setTaille('delegataire_telephone', 14); |
|
|
$form->setTaille('delegataire_email', 20); |
|
|
// terrain |
|
|
$form->setTaille('terrain_surface', 6); |
|
|
$form->setTaille('terrain_surface_calcul', 6); |
|
|
$form->setTaille('terrain_adresse', 20); |
|
|
$form->setTaille('terrain_adresse_complement', 20); |
|
|
$form->setTaille('terrain_numero', 4); |
|
|
$form->setTaille('terrain_cp', 5); |
|
|
$form->setTaille('terrain_ville', 20); |
|
|
$form->setTaille('rivoli', 4); |
|
|
$form->setTaille('parcelle', 20); |
|
|
// |
|
|
$form->setTaille('architecte_nom', 30); |
|
|
$form->setTaille('architecte', 3); |
|
|
// description |
|
|
$form->setTaille('hauteur','3'); |
|
|
|
|
|
$form->setTaille('temp1', 100); |
|
|
$form->setTaille('temp2', 100); |
|
|
$form->setTaille('temp3', 100); |
|
|
$form->setTaille('temp4', 100); |
|
|
$form->setTaille('temp5', 100); |
|
|
} |
|
|
|
|
316 |
function setVal(&$form,$maj,$validation){ |
function setVal(&$form,$maj,$validation){ |
317 |
$this->maj=$maj; |
$this->maj=$maj; |
318 |
if ($validation==0) { |
if ($validation==0) { |
342 |
|
|
343 |
function setSelect(&$form, $maj,&$db,$debug) { |
function setSelect(&$form, $maj,&$db,$debug) { |
344 |
//optimisation sur table importante parcelle -> pas d appel methode parent |
//optimisation sur table importante parcelle -> pas d appel methode parent |
345 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
346 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
347 |
if($maj<2){ |
if($maj<2){ |
348 |
// travaux |
// travaux |
349 |
$contenu=array(); |
$contenu=array(); |
523 |
|
|
524 |
$form->setGroupe('architecte','D'); |
$form->setGroupe('architecte','D'); |
525 |
$form->setGroupe('architecte_nom','G'); |
$form->setGroupe('architecte_nom','G'); |
526 |
$form->setGroupe('saisie_architecte','G'); |
$form->setGroupe('saisie_architecte','F'); |
527 |
$form->setGroupe('travaux','F'); |
|
528 |
|
$form->setGroupe('travaux','D'); |
529 |
|
$form->setGroupe('travaux_complement','F'); |
530 |
|
|
531 |
// terrain |
// terrain |
532 |
$form->setGroupe('terrain_numero','D'); |
$form->setGroupe('terrain_numero','D'); |
629 |
$form->setLib('terrain_cp','cp'); |
$form->setLib('terrain_cp','cp'); |
630 |
$form->setLib('terrain_ville','ville'); |
$form->setLib('terrain_ville','ville'); |
631 |
|
|
632 |
$form->setLib('terrain_surface',' '._('surface').' : '); |
$form->setLib('terrain_surface',' '._('superficie').' : '); |
633 |
$form->setLib('terrain_surface_calcul',' '._('calcul').' : '); |
$form->setLib('terrain_surface_calcul',' '._('calcul').' : '); |
634 |
$form->setLib('parcelle',' '._('parcelle').' : '); |
$form->setLib('parcelle',' '._('parcelle').' : '); |
635 |
|
|
646 |
|
|
647 |
|
|
648 |
// travaux |
// travaux |
649 |
$form->setLib('objet_dossier',''); |
$form->setLib('objet_dossier',_('objet_dossier')); |
650 |
$form->setLib('travaux',''); |
$form->setLib('travaux',_('travaux')); |
651 |
$form->setLib('architecte_nom',""); |
$form->setLib('travaux_complement',_('travaux_complement')); |
652 |
$form->setLib('architecte',''); |
$form->setLib('architecte_nom',_('architecte_nom')); |
653 |
|
$form->setLib('architecte',_('architecte')); |
654 |
|
|
655 |
// description |
// description |
656 |
$form->setLib('batiment_nombre',' '._('nombre de batiment').' : '); |
$form->setLib('batiment_nombre',' '._('nombre de batiment').' : '); |
687 |
$form->setOnchange("delegataire_societe","this.value=this.value.toUpperCase()"); |
$form->setOnchange("delegataire_societe","this.value=this.value.toUpperCase()"); |
688 |
$form->setOnchange("architecte_nom","this.value=this.value.toUpperCase()"); |
$form->setOnchange("architecte_nom","this.value=this.value.toUpperCase()"); |
689 |
$form->setOnchange("terrain_adresse","this.value=this.value.toUpperCase()"); |
$form->setOnchange("terrain_adresse","this.value=this.value.toUpperCase()"); |
690 |
|
$form->setOnchange('shon','VerifNumdec(this)'); |
691 |
|
$form->setOnchange('shob','VerifNumdec(this)'); |
692 |
|
$form->setOnchange('hauteur','VerifNumdec(this)'); |
693 |
|
$form->setOnchange('terrain_surface','VerifNumdec(this)'); |
694 |
} |
} |
695 |
|
|
696 |
function setRegroupe(&$form,$maj){ |
function setRegroupe(&$form,$maj){ |
708 |
// travaux |
// travaux |
709 |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
710 |
$form->setRegroupe('architecte_nom','G',''); |
$form->setRegroupe('architecte_nom','G',''); |
711 |
$form->setRegroupe('travaux','F',''); |
$form->setRegroupe('travaux','G',''); |
712 |
|
$form->setRegroupe('travaux_complement','F',''); |
713 |
|
|
714 |
// instruction |
// instruction |
715 |
$form->setRegroupe('date_complet','D',_('Instruction'), $this->aff_instruction); |
$form->setRegroupe('date_complet','D',_('Instruction'), $this->aff_instruction); |
770 |
|
|
771 |
|
|
772 |
// description |
// description |
773 |
$form->setRegroupe('batiment_nombre','D',_('description'), $this->aff_description); |
$form->setRegroupe('batiment_nombre','D',_('statistique'), $this->aff_description); |
774 |
$form->setRegroupe('logement_nombre','G',''); |
$form->setRegroupe('logement_nombre','G',''); |
775 |
$form->setRegroupe('hauteur','G',''); |
$form->setRegroupe('hauteur','G',''); |
776 |
$form->setRegroupe('piece_nombre','G',''); |
$form->setRegroupe('piece_nombre','G',''); |
779 |
$form->setRegroupe('shob','G',''); |
$form->setRegroupe('shob','G',''); |
780 |
$form->setRegroupe('lot','F',''); |
$form->setRegroupe('lot','F',''); |
781 |
|
|
782 |
|
$form->setRegroupe('description','D',_('description').' '._('servitude'), $this->aff_amenagement); |
783 |
|
$form->setRegroupe('servitude','F',''); |
784 |
|
|
785 |
// amenagement |
// amenagement |
786 |
$form->setRegroupe('amenagement','D',_('Amenagement'), $this->aff_amenagement); |
$form->setRegroupe('amenagement','D',_('Amenagement'), $this->aff_amenagement); |
787 |
$form->setRegroupe('parcelle_lot','G',''); |
$form->setRegroupe('parcelle_lot','G',''); |
817 |
or $val['parcelle_lot']!=$val['parcelle_lot_archive'])){ // parcelle_lot_archive |
or $val['parcelle_lot']!=$val['parcelle_lot_archive'])){ // parcelle_lot_archive |
818 |
if($val['parcelle']!='' or $val['parcelle_lot']!='') |
if($val['parcelle']!='' or $val['parcelle_lot']!='') |
819 |
$this->sig_interne($this->valF['dossier'],&$db,$val,$DEBUG); |
$this->sig_interne($this->valF['dossier'],&$db,$val,$DEBUG); |
820 |
else |
else{ |
821 |
|
if($this->maj ==1){ // en maj mettre a null la geometrie si parcelle changée inexistante |
822 |
|
$sql ="update ".DB_PREFIXE."dossier set geom = null, servitude = '', pos= '' where dossier ='".$id."'"; |
823 |
|
$res = $db -> query($sql); |
824 |
|
$this->addToLog("requete trigger modifier parcelle vide -> maj pos et servitude :".$sql, VERBOSE_MODE); |
825 |
|
if (database :: isError($res)) |
826 |
|
die($res->getMessage()."erreur ".$sql); |
827 |
|
} |
828 |
$this->addToMessage("<br>"._("Parcelle ou parcelle_lot non renseignee dans dossier")." ".$id." <br>"); |
$this->addToMessage("<br>"._("Parcelle ou parcelle_lot non renseignee dans dossier")." ".$id." <br>"); |
829 |
|
} |
830 |
} |
} |
831 |
} |
} |
832 |
|
|
879 |
$parcelle=$val["parcelle"]; |
$parcelle=$val["parcelle"]; |
880 |
$projection = $db -> getOne("select srid from geometry_columns where f_table_name='dossier'"); |
$projection = $db -> getOne("select srid from geometry_columns where f_table_name='dossier'"); |
881 |
if($this->auto_parcelle==1 and $val["parcelle"]!=''){ |
if($this->auto_parcelle==1 and $val["parcelle"]!=''){ |
882 |
$sql= "select astext(centroid(geom)) from parcelle where parcelle ='".$val["parcelle"]."'"; |
$sql= "select astext(centroid(geom)) from ".DB_PREFIXE."parcelle where parcelle ='".$val["parcelle"]."'"; |
883 |
$this->addToLog("recherche centroid parcelle :".$sql, VERBOSE_MODE); |
$this->addToLog("recherche centroid parcelle :".$sql, VERBOSE_MODE); |
884 |
$geom = $db -> getOne($sql); |
$geom = $db -> getOne($sql); |
885 |
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
886 |
} |
} |
887 |
if($geom=='' and $this->auto_parcelle_lot==1 and $val["parcelle_lot"]!=''){ // lot |
if($geom=='' and $this->auto_parcelle_lot==1 and $val["parcelle_lot"]!=''){ // lot |
888 |
$sql= "select astext(centroid(geom)) from parcelle_lot where parcelle_lot ='".$val["parcelle_lot"]."'"; |
$sql= "select astext(centroid(geom)) from ".DB_PREFIXE."parcelle_lot where parcelle_lot ='".$val["parcelle_lot"]."'"; |
889 |
$this->addToLog("recherche centroid parcelle lot :".$sql, VERBOSE_MODE); |
$this->addToLog("recherche centroid parcelle lot :".$sql, VERBOSE_MODE); |
890 |
$geom = $db -> getOne($sql); |
$geom = $db -> getOne($sql); |
891 |
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
892 |
$parcelle=$val["parcelle_lot"]." ".$val["parcelle_lot_lotissement"]; |
$parcelle=$val["parcelle_lot"]." ".$val["parcelle_lot_lotissement"]; |
893 |
} |
} |
|
|
|
894 |
if($geom!=''){ // la parcelle est exitante dans la table ou vue parcelle |
if($geom!=''){ // la parcelle est exitante dans la table ou vue parcelle |
895 |
$sql ="update dossier set geom =geometryfromtext('".$geom."', ".$projection." ) where dossier ='".$id."'"; |
$sql ="update ".DB_PREFIXE."dossier set geom =geometryfromtext('".$geom."', ".$projection." ) where dossier ='".$id."'"; |
896 |
$this->addToLog("sig_interne maj geom :".$sql, VERBOSE_MODE); |
$this->addToLog("sig_interne maj geom :".$sql, VERBOSE_MODE); |
897 |
$res = $db -> query($sql); |
$res = $db -> query($sql); |
898 |
if (database :: isError($res)) die($res->getMessage()."erreur ".$sql); |
if (database :: isError($res)) die($res->getMessage()."erreur ".$sql); |
906 |
if($this->auto_servitude_point==1) // recherche de servitude point |
if($this->auto_servitude_point==1) // recherche de servitude point |
907 |
$this->calcul_auto_servitude_point($id,$db,$geom,$projection); |
$this->calcul_auto_servitude_point($id,$db,$geom,$projection); |
908 |
$temp=strtr($this->servitude,"'"," "); // enleve le ' |
$temp=strtr($this->servitude,"'"," "); // enleve le ' |
909 |
$sql1 ="update dossier set servitude = '".$temp."' where dossier = '".$id."'"; |
$sql1 ="update ".DB_PREFIXE."dossier set servitude = '".$temp."' where dossier = '".$id."'"; |
910 |
$res1 = $db -> query($sql1); |
$res1 = $db -> query($sql1); |
911 |
$this->addToLog("maj servitudes :".$sql1, VERBOSE_MODE); |
$this->addToLog("maj servitudes :".$sql1, VERBOSE_MODE); |
912 |
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
913 |
}else{ // parcelle inexistante |
}else{ // parcelle inexistante //*** |
914 |
if($this->maj ==1){ // en maj mettre a null la geometrie si parcelle changée inexistante |
if($this->maj ==1){ // en maj mettre a null la geometrie si parcelle changée inexistante |
915 |
$sql ="update dossier set geom = null where dossier ='".$id."'"; |
$sql ="update ".DB_PREFIXE."dossier set geom = null, servitude = '', pos= '' where dossier ='".$id."'"; |
916 |
$res = $db -> query($sql); |
$res = $db -> query($sql); |
917 |
$this->addToLog("requete sig_interne maj parcelle inexistante :".$sql, VERBOSE_MODE); |
$this->addToLog("requete sig_interne maj parcelle inexistante :".$sql, VERBOSE_MODE); |
918 |
if (database :: isError($res)) |
if (database :: isError($res)) |
924 |
|
|
925 |
function calcul_auto_pos($id,&$db,$geom,$projection){ |
function calcul_auto_pos($id,&$db,$geom,$projection){ |
926 |
// recherche du pos automatique |
// recherche du pos automatique |
927 |
$sql="select pos from pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
$sql="select pos from ".DB_PREFIXE."pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
928 |
$pos = $db -> getOne($sql); |
$pos = $db -> getOne($sql); |
929 |
$this->addToLog("recherche auto_pos :".$sql, VERBOSE_MODE); |
$this->addToLog("recherche auto_pos :".$sql, VERBOSE_MODE); |
930 |
if($pos!=''){ |
if($pos!=''){ |
931 |
$sql1 ="update dossier set pos = '".$pos."' where dossier = '".$id."'"; |
$sql1 ="update ".DB_PREFIXE."dossier set pos = '".$pos."' where dossier = '".$id."'"; |
932 |
$res1 = $db -> query($sql1); |
$res1 = $db -> query($sql1); |
933 |
$this->addToLog("maj auto_pos :".$sql1, VERBOSE_MODE); |
$this->addToLog("maj auto_pos :".$sql1, VERBOSE_MODE); |
934 |
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
940 |
|
|
941 |
function calcul_auto_servitude_surfacique($id,&$db,$geom,$projection){ |
function calcul_auto_servitude_surfacique($id,&$db,$geom,$projection){ |
942 |
// recherche servitude surfacique |
// recherche servitude surfacique |
943 |
$sql="select * from servitude_surfacique WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
$sql="select * from ".DB_PREFIXE."servitude_surfacique WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
944 |
$res=$db->query($sql); |
$res=$db->query($sql); |
945 |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
946 |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
952 |
|
|
953 |
function calcul_auto_servitude_ligne($id,&$db,$geom,$projection){ |
function calcul_auto_servitude_ligne($id,&$db,$geom,$projection){ |
954 |
// recherche servitude ligne |
// recherche servitude ligne |
955 |
$sql="select * from servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre), geometryfromtext('".$geom."', ".$projection."))"; |
$sql="select * from ".DB_PREFIXE."servitude_ligne WHERE ST_contains(ST_buffer(geom, perimetre), geometryfromtext('".$geom."', ".$projection."))"; |
956 |
$res=$db->query($sql); |
$res=$db->query($sql); |
957 |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
958 |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
964 |
|
|
965 |
function calcul_auto_servitude_point($id,&$db,$geom,$projection){ |
function calcul_auto_servitude_point($id,&$db,$geom,$projection){ |
966 |
// recherche servitude point |
// recherche servitude point |
967 |
$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 ". |
968 |
|
DB_PREFIXE."servitude_point WHERE distance(geom, geometryfromtext('".$geom."', ".$projection."))<perimetre"; |
969 |
$res=$db->query($sql); |
$res=$db->query($sql); |
970 |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
971 |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |