2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:39 |
//gen openMairie le 10/02/2011 20:39 |
4 |
require_once ("../gen/obj/dossier.class.php"); |
require_once ("../gen/obj/dossier.class.php"); |
|
//require_once ("../sig/strategyDynmap.class.php"); //specific |
|
5 |
|
|
6 |
class dossier extends dossier_gen { |
class dossier extends dossier_gen { |
7 |
|
|
8 |
var $maj; |
var $maj; |
9 |
|
var $sig; |
10 |
|
var $servitude=""; |
11 |
|
var $auto_pos; |
12 |
|
var $auto_servitude_surfacique; |
13 |
|
var $auto_servitude_ligne; |
14 |
|
var $auto_servitude_point; |
15 |
|
var $auto_parcelle; |
16 |
|
var $auto_parcelle_lot; |
17 |
|
|
18 |
|
|
19 |
function setvalF($val){ |
function setvalF($val){ |
20 |
parent::setvalF($val); |
parent::setvalF($val); |
|
|
|
21 |
// cles secondaires numerique (contrainte integrite pgsql) |
// cles secondaires numerique (contrainte integrite pgsql) |
22 |
if(!is_numeric($val['instructeur'])) $this->valF['instructeur']= null; |
if(!is_numeric($val['instructeur'])) $this->valF['instructeur']= null; |
23 |
if(!is_numeric($val['architecte'])) $this->valF['architecte']= null; |
if(!is_numeric($val['architecte'])) $this->valF['architecte']= null; |
24 |
if(!is_numeric($val['travaux'])) $this->valF['travaux']= null; |
if(!is_numeric($val['travaux'])) $this->valF['travaux']= null; |
25 |
if(!is_numeric($val['demandeur_categorie'])) $this->valF['demandeur_categorie']= null; |
if(!is_numeric($val['demandeur_categorie'])) $this->valF['demandeur_categorie']= null; |
|
|
|
26 |
// cle secondaire alpha vide (contrainte integrite pgsql) |
// cle secondaire alpha vide (contrainte integrite pgsql) |
27 |
if($val['demandeur_civilite']=='') $this->valF['demandeur_civilite']= null; |
if($val['demandeur_civilite']=='') $this->valF['demandeur_civilite']= null; |
28 |
if($val['delegataire_civilite']=='') $this->valF['delegataire_civilite']= null; |
if($val['delegataire_civilite']=='') $this->valF['delegataire_civilite']= null; |
|
|
|
29 |
// zone numerique non valorisée a 0 |
// zone numerique non valorisée a 0 |
30 |
if(!is_numeric($val['delai'])) unset ($this->valF['delai']); |
if(!is_numeric($val['delai'])) unset ($this->valF['delai']); |
31 |
if(!is_numeric($val['terrain_surface'])) unset ($this->valF['terrain_surface']); |
if(!is_numeric($val['terrain_surface'])) unset ($this->valF['terrain_surface']); |
36 |
if(!is_numeric($val['lot'])) unset ($this->valF['lot']); |
if(!is_numeric($val['lot'])) unset ($this->valF['lot']); |
37 |
if(!is_numeric($val['hauteur'])) unset ($this->valF['hauteur']); |
if(!is_numeric($val['hauteur'])) unset ($this->valF['hauteur']); |
38 |
if(!is_numeric($val['piece_nombre'])) unset ($this->valF['piece_nombre']); |
if(!is_numeric($val['piece_nombre'])) unset ($this->valF['piece_nombre']); |
39 |
|
if(!is_numeric($val['parcelle_lot'])) unset ($this->valF['parcelle_lot']); |
40 |
|
// enlever les valeurs a ne pas saisir -> recherche en trigger ajouter et modifier |
41 |
// enlever les valeurs a ne pas saisir -> recherche en trigger ajouter et modifier |
// $sig = 1 |
42 |
// $sig = 1 |
unset ($this->valF['geom']); |
|
unset ($this->valF['geom']); |
|
|
|
|
43 |
// valeurs hiddenstatic (calcule) |
// valeurs hiddenstatic (calcule) |
44 |
if($this->maj==1){ |
if($this->maj==1){ |
45 |
// par defaut |
// par defaut |
52 |
unset ($this->valF['terrain_surface_calcul']); |
unset ($this->valF['terrain_surface_calcul']); |
53 |
unset ($this->valF['shon_calcul']); |
unset ($this->valF['shon_calcul']); |
54 |
unset ($this->valF['parcelle_archive']); |
unset ($this->valF['parcelle_archive']); |
55 |
|
unset ($this->valF['parcelle_lot_archive']); |
56 |
unset ($this->valF['date_notification_delai']); |
unset ($this->valF['date_notification_delai']); |
57 |
unset ($this->valF['date_decision']); |
unset ($this->valF['date_decision']); |
58 |
unset ($this->valF['date_limite']); |
unset ($this->valF['date_limite']); |
91 |
function verifier($val,&$db,$DEBUG){ |
function verifier($val,&$db,$DEBUG){ |
92 |
$this->correct=True; |
$this->correct=True; |
93 |
// obligatoire |
// obligatoire |
94 |
if($val['date_depot']!=""){ |
if($val['date_depot']==""){ |
95 |
$this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
// $this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
96 |
}else{ |
//}else{ |
97 |
$this->correct=false; |
$this->correct=false; |
98 |
$this->msg= $this->msg."<br>date_depot obligatoire"; |
$this->addToMessage("<br>date_depot obligatoire"); |
99 |
} |
} |
100 |
if($val['parcelle']!="" and $val['sig']!='Oui'){ |
if($val['parcelle']!="" and $val['sig']!='Oui'){ |
101 |
if (!preg_match('/^[A-Z]{2}[0-9]{4}$/', $val['parcelle'])){ |
if (!preg_match('/^[A-Z]{2}[0-9]{4}$/', $val['parcelle'])){ |
102 |
$this->correct=false; |
$this->correct=false; |
103 |
$this->msg= $this->msg."<br>format parcelle AANNNN"; |
$this->addToMessage("<br>format parcelle AANNNN"); |
104 |
} |
} |
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 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 (DB :: isError($res)) |
if (database :: isError($res)) die($res->getMessage().$sql); |
112 |
die($res->getMessage().$sql); |
$this->addToLog("requete ".$sql." execute <br>", EXTRA_VERBOSE_MODE); |
113 |
else{ |
$regle=0; |
114 |
if ($DEBUG == 1) |
$msg=""; |
115 |
echo " la requete ".$sql." est executee<br>"; |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
116 |
$regle=0; |
switch ($row['operateur']) { |
117 |
$msg=""; |
case ">" : |
118 |
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
if($row['sens']=="plus"){ |
119 |
switch ($row['operateur']) { |
if($this->valF[$row['champ']] > $row['valeur']) |
120 |
case ">" : |
$condition = 1; |
121 |
if($row['sens']=="plus"){ |
else |
122 |
if($this->valF[$row['champ']] > $row['valeur']) |
$condition = 0; |
123 |
$condition = 1; |
if($regle==1 or $condition == 1) |
124 |
else |
$regle=1; |
125 |
$condition = 0; |
else |
126 |
if($regle==1 or $condition == 1) |
$regle=0; |
127 |
$regle=1; |
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
128 |
else |
$this->valF[$row['champ']]."]"; |
129 |
$regle=0; |
}else{ |
130 |
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
if($this->valF[$row['champ']] > $row['valeur']){ |
131 |
$this->valF[$row['champ']]."]"; |
$condition = 0; |
|
}else{ |
|
|
if($this->valF[$row['champ']] > $row['valeur']){ |
|
|
$condition = 0; |
|
|
}else{ |
|
|
$condition = 1; |
|
|
$regle=0; |
|
|
} |
|
|
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
|
|
$this->valF[$row['champ']]."]"; |
|
|
} |
|
|
break; |
|
|
case ">=": |
|
|
if($row['sens']=="plus"){ |
|
|
if($this->valF[$row['champ']] >= $row['valeur']) |
|
|
$condition = 1; |
|
|
else |
|
|
$condition = 0; |
|
|
if($regle==1 or $condition == 1) |
|
|
$regle=1; |
|
|
else |
|
|
$regle=0; |
|
|
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
|
|
$this->valF[$row['champ']]."]"; |
|
|
}else{ |
|
|
if($this->valF[$row['champ']] >= $row['valeur']){ |
|
|
$condition = 0; |
|
|
|
|
|
}else{ |
|
|
$condition = 1; |
|
|
$regle=0; |
|
|
} |
|
|
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
|
|
$this->valF[$row['champ']]."]"; |
|
|
} |
|
|
break; |
|
|
case "<" : |
|
|
if($row['sens']=="plus"){ |
|
|
if($this->valF[$row['champ']] < $row['valeur']) |
|
|
$condition = 1; |
|
|
else |
|
|
$condition = 0; |
|
|
if($regle==1 or $condition == 1) |
|
|
$regle=1; |
|
|
else |
|
|
$regle=0; |
|
|
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
|
|
$this->valF[$row['champ']]."]"; |
|
132 |
}else{ |
}else{ |
133 |
if($this->valF[$row['champ']] < $row['valeur']){ |
$condition = 1; |
134 |
$condition = 0; |
$regle=0; |
|
}else{ |
|
|
$condition = 1; |
|
|
$regle=0; |
|
|
} |
|
|
$msg=$msg."<br> et ".$row['message']." [".$row['champ']." = ". |
|
|
$this->valF[$row['champ']]."]"; |
|
135 |
} |
} |
136 |
|
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
137 |
|
$this->valF[$row['champ']]."]"; |
138 |
|
} |
139 |
break; |
break; |
140 |
case "==": |
case ">=": |
141 |
if($row['sens']=="plus"){ |
if($row['sens']=="plus"){ |
142 |
if($this->valF[$row['champ']] == $row['valeur']) |
if($this->valF[$row['champ']] >= $row['valeur']) |
143 |
$condition = 1; |
$condition = 1; |
144 |
else |
else |
145 |
$condition = 0; |
$condition = 0; |
149 |
$regle=0; |
$regle=0; |
150 |
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
151 |
$this->valF[$row['champ']]."]"; |
$this->valF[$row['champ']]."]"; |
152 |
}else{ |
}else{ |
153 |
if($this->valF[$row['champ']] == $row['valeur']){ |
if($this->valF[$row['champ']] >= $row['valeur']){ |
154 |
$condition = 0; |
$condition = 0; |
155 |
|
|
156 |
}else{ |
}else{ |
159 |
} |
} |
160 |
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
161 |
$this->valF[$row['champ']]."]"; |
$this->valF[$row['champ']]."]"; |
162 |
|
} |
163 |
|
break; |
164 |
|
case "<" : |
165 |
|
if($row['sens']=="plus"){ |
166 |
|
if($this->valF[$row['champ']] < $row['valeur']) |
167 |
|
$condition = 1; |
168 |
|
else |
169 |
|
$condition = 0; |
170 |
|
if($regle==1 or $condition == 1) |
171 |
|
$regle=1; |
172 |
|
else |
173 |
|
$regle=0; |
174 |
|
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
175 |
|
$this->valF[$row['champ']]."]"; |
176 |
|
}else{ |
177 |
|
if($this->valF[$row['champ']] < $row['valeur']){ |
178 |
|
$condition = 0; |
179 |
|
}else{ |
180 |
|
$condition = 1; |
181 |
|
$regle=0; |
182 |
|
} |
183 |
|
$msg=$msg."<br> et ".$row['message']." [".$row['champ']." = ". |
184 |
|
$this->valF[$row['champ']]."]"; |
185 |
} |
} |
186 |
break; |
break; |
187 |
|
case "==": |
188 |
|
if($row['sens']=="plus"){ |
189 |
|
if($this->valF[$row['champ']] == $row['valeur']) |
190 |
|
$condition = 1; |
191 |
|
else |
192 |
|
$condition = 0; |
193 |
|
if($regle==1 or $condition == 1) |
194 |
|
$regle=1; |
195 |
|
else |
196 |
|
$regle=0; |
197 |
|
$msg=$msg."<br> + ".$row['message']." [".$row['champ']." = ". |
198 |
|
$this->valF[$row['champ']]."]"; |
199 |
|
}else{ |
200 |
|
if($this->valF[$row['champ']] == $row['valeur']){ |
201 |
|
$condition = 0; |
202 |
|
|
203 |
|
}else{ |
204 |
|
$condition = 1; |
205 |
|
$regle=0; |
206 |
|
} |
207 |
|
$msg=$msg."<br> ou ".$row['message']." [".$row['champ']." = ". |
208 |
|
$this->valF[$row['champ']]."]"; |
209 |
|
} |
210 |
|
break; |
211 |
break; |
break; |
212 |
} // switch |
} // switch |
213 |
} |
if($regle==0) |
214 |
if($regle==0) |
$this->addToMessage(" <br><br>"); |
215 |
$this->msg= $this->msg.$msg." <br><br>"; |
} // while |
216 |
} |
} // travaux |
|
} |
|
217 |
}//verifier |
}//verifier |
218 |
|
|
219 |
|
|
224 |
if($maj==0) $form->setType('dossier', 'hidden'); |
if($maj==0) $form->setType('dossier', 'hidden'); |
225 |
$form->setType('annee', 'hidden'); |
$form->setType('annee', 'hidden'); |
226 |
$form->setType('nature', 'hidden'); |
$form->setType('nature', 'hidden'); |
227 |
$form->setType('parcelle_archive','hidden'); |
$form->setType('parcelle_archive','hidden'); |
228 |
|
$form->setType('parcelle_lot_archive','hidden'); |
229 |
$form->setType('objet_dossier','hidden'); // PC |
$form->setType('objet_dossier','hidden'); // PC |
230 |
$form->setType('amenagement','hidden'); // PC |
$form->setType('amenagement','hidden'); // PC |
231 |
|
$form->setType('parcelle_lot','hidden'); // PC |
232 |
// a voir a quoi cela peut servir |
$form->setType('parcelle_lot_lotissement','hidden'); // PC |
233 |
$form->setType('sig','hidden'); // PC |
$form->setType('geom', 'hidden'); |
234 |
$form->setType('siglien','hidden'); // PC |
$form->setType('servitude', 'hiddenstatic'); |
235 |
|
|
236 |
// date |
// date |
237 |
$form->setType('date_depot','date'); |
$form->setType('date_depot','date'); |
238 |
$form->setType('date_demande','date'); |
$form->setType('date_demande','date'); |
244 |
$form->setType('delegataire_civilite','select'); |
$form->setType('delegataire_civilite','select'); |
245 |
$form->setType('demandeur_civilite','select'); |
$form->setType('demandeur_civilite','select'); |
246 |
$form->setType('demandeur_categorie','select'); |
$form->setType('demandeur_categorie','select'); |
247 |
|
$form->setType('pos','select'); |
248 |
|
|
249 |
// combo |
// combo |
250 |
$form->setType('rivoli','comboD'); |
$form->setType('rivoli','comboD'); |
251 |
$form->setType('terrain_adresse','comboG'); |
$form->setType('terrain_adresse','comboG'); |
|
//$form->setType('architecte','comboD'); |
|
|
//$form->setType('architecte','textdisabled'); // ne valorise pas |
|
252 |
$form->setType('architecte_nom','comboG'); |
$form->setType('architecte_nom','comboG'); |
253 |
|
$form->setType('architecte','comboD'); |
254 |
|
|
255 |
|
|
256 |
// hiddenstatic |
// hiddenstatic |
257 |
if($maj==1) $form->setType('dossier', 'hiddenstatic'); |
if($maj==1) $form->setType('dossier', 'hiddenstatic'); |
278 |
$form->setType('date_conformite','hiddenstaticdate'); |
$form->setType('date_conformite','hiddenstaticdate'); |
279 |
|
|
280 |
// checkbox |
// checkbox |
281 |
//$form->setType('sig','checkbox'); |
$form->setType('sig','checkbox'); |
282 |
$form->setType('delegataire','checkbox'); |
$form->setType('delegataire','checkbox'); |
283 |
|
|
|
// http |
|
|
//$form->setType('siglien','http'); |
|
|
$form->setType('saisie_architecte', 'httpclick'); |
|
|
|
|
284 |
// mail |
// mail |
285 |
$form->setType('delegataire_email','mail'); |
$form->setType('delegataire_email','mail'); |
286 |
$form->setType('demandeur_email','mail'); |
$form->setType('demandeur_email','mail'); |
287 |
|
|
288 |
// zones temp et strategysig |
// zones temp et strategysig |
289 |
|
|
290 |
|
|
291 |
|
// temp |
292 |
include ("../dyn/var.inc"); |
include ("../dyn/var.inc"); |
|
if(!isset($sauvegardeDossier)) $sauvegardeDossier=''; |
|
|
if($sauvegardeDossier != '') // strategie sig |
|
|
$form->setType('pos','hiddenstatic'); |
|
|
else |
|
|
$form->setType('pos','select'); |
|
|
// temp |
|
293 |
$form->setType('temp1',$temp1_type); |
$form->setType('temp1',$temp1_type); |
294 |
$form->setType('temp2',$temp2_type); |
$form->setType('temp2',$temp2_type); |
295 |
$form->setType('temp3',$temp3_type); |
$form->setType('temp3',$temp3_type); |
410 |
$form->setVal('accord_tacite', 'Non'); |
$form->setVal('accord_tacite', 'Non'); |
411 |
$form->setVal('etat', 'initialiser'); |
$form->setVal('etat', 'initialiser'); |
412 |
$form->setVal('types', 'Initial'); |
$form->setVal('types', 'Initial'); |
|
$form->setVal("saisie_architecte","saisie3()"); |
|
|
}else{ |
|
|
$form->setVal("saisie_architecte","saisie3()"); |
|
413 |
} |
} |
414 |
} |
} |
415 |
} |
} |
416 |
|
|
417 |
function setSelect(&$form, $maj,&$db,$debug) { |
function setSelect(&$form, $maj,&$db,$debug) { |
418 |
//optimisation sur table importante parcelle -> pas d appel methode parent |
//optimisation sur table importante parcelle -> pas d appel methode parent |
419 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
420 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
421 |
if($maj<2){ |
if($maj<2){ |
422 |
// travaux |
// travaux |
423 |
$contenu=array(); |
$contenu=array(); |
429 |
$sql_travaux = $sql_travaux. |
$sql_travaux = $sql_travaux. |
430 |
" order by libelle"; |
" order by libelle"; |
431 |
$res = $db->query($sql_travaux); |
$res = $db->query($sql_travaux); |
432 |
if (database::isError($res)) |
if (database::isError($res)) die($res->getMessage()).$sql_travaux; |
433 |
die($res->getMessage()); |
$this->addToLog(" la requete ".$sql_travaux." est executee", VERBOSE_MODE); |
434 |
else{ |
$contenu[0][0]=""; |
435 |
if ($debug == 1) |
$contenu[1][0]=_('choisir')." "._('travaux'); |
436 |
echo " la requete ".$sql_travaux." est executee<br>"; |
$k=1; |
437 |
$contenu[0][0]=""; |
while ($row=& $res->fetchRow()){ |
438 |
$contenu[1][0]=_('choisir')." "._('travaux'); |
$contenu[0][$k]=$row[0]; |
439 |
$k=1; |
$contenu[1][$k]=$row[1]; |
440 |
while ($row=& $res->fetchRow()){ |
$k++; |
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect("travaux",$contenu); |
|
441 |
} |
} |
442 |
|
$form->setSelect("travaux",$contenu); |
443 |
|
|
444 |
// instructeur |
//// instructeur |
445 |
$contenu=array(); |
$contenu=array(); |
446 |
$res = $db->query($sql_instructeur); |
$res = $db->query($sql_instructeur); |
447 |
if (DB :: isError($res)) |
if (database::isError($res)) die($res->getMessage().$sql_instructeur); |
448 |
die($res->getMessage().$sql_instructeur); |
$this->addToLog(" la requete ".$sql_instructeur." est executee", VERBOSE_MODE); |
449 |
else{ |
$contenu[0][0]=""; |
450 |
if ($debug == 1) |
$contenu[1][0]=_('choisir')." "._('instructeur'); |
451 |
echo " la requete ".$sql_instructeur." est executee<br>"; |
$k=1; |
452 |
$contenu[0][0]=""; |
while ($row=& $res->fetchRow()){ |
|
$contenu[1][0]=$this->lang('choisir')." ".$this->lang('instructeur'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
453 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
454 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
455 |
$k++; |
$k++; |
|
} |
|
|
$form->setSelect("instructeur",$contenu); |
|
456 |
} |
} |
457 |
|
$form->setSelect("instructeur",$contenu); |
458 |
|
|
459 |
// demandeur et delegataire civilite |
// demandeur et delegataire civilite |
460 |
$contenu=array(); |
$contenu=array(); |
461 |
$res = $db->query($sql_civilite); |
$res = $db->query($sql_civilite); |
462 |
if (database::isError($res)) |
if (database::isError($res)) die($res->getMessage().$sql_); |
463 |
die($res->getMessage().$sql_travaux); |
$this->addToLog(" la requete ".$sql_civilite." est executee", VERBOSE_MODE); |
464 |
else{ |
$contenu[0][0]=""; |
465 |
if ($debug == 1) |
$contenu[1][0]=_('choisir')." "._('civilite'); |
466 |
echo " la requete ".$sql_civilite." est execute<br>"; |
$k=1; |
467 |
$contenu[0][0]=""; |
while ($row=& $res->fetchRow()){ |
|
$contenu[1][0]=_('choisir')." "._('civilite'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
468 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
469 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
470 |
$k++; |
$k++; |
471 |
} |
} |
472 |
$form->setSelect("demandeur_civilite",$contenu); |
$form->setSelect("demandeur_civilite",$contenu); |
473 |
$form->setSelect("delegataire_civilite",$contenu); |
$form->setSelect("delegataire_civilite",$contenu); |
474 |
} |
|
475 |
// demandeur categorie |
// demandeur categorie |
476 |
$contenu=array(); |
$contenu=array(); |
477 |
$res = $db->query($sql_categorie_demandeur); |
$res = $db->query($sql_categorie_demandeur); |
478 |
if (database::isError($res)) |
if (database::isError($res)) die($res->getMessage().$sql_categorie_demandeur); |
479 |
die($res->getMessage().$sql_categorie_demandeur); |
$this->addToLog(" la requete ".$sql_categorie_demandeur." est executee", VERBOSE_MODE); |
480 |
else{ |
$contenu[0][0]=""; |
481 |
if ($debug == 1) |
$contenu[1][0]=_('choisir')." "._('categorie'); |
482 |
echo " la requete ".$sql_categorie_demandeur." est execute<br>"; |
$k=1; |
483 |
$contenu[0][0]=""; |
while ($row=& $res->fetchRow()){ |
|
$contenu[1][0]=_('choisir')." "._('categorie'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
484 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
485 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
486 |
$k++; |
$k++; |
|
} |
|
|
$form->setSelect("demandeur_categorie",$contenu); |
|
487 |
} |
} |
488 |
|
$form->setSelect("demandeur_categorie",$contenu); |
489 |
|
|
490 |
// pos |
// pos |
491 |
$contenu=array(); |
$contenu=array(); |
492 |
$res = $db->query($sql_pos); |
$res = $db->query($sql_pos); |
493 |
if (database::isError($res)) |
if (database::isError($res)) die($res->getMessage().$sql_pos); |
494 |
die($res->getMessage().$sql_pos); |
$this->addToLog(" la requete ".$sql_pos." est executee", VERBOSE_MODE); |
495 |
else{ |
$contenu[0][0]=""; |
496 |
if ($debug == 1) |
$contenu[1][0]=_('choisir')." "._('pos'); |
497 |
echo " la requete ".$sql_architecte." est execute<br>"; |
$k=1; |
498 |
$contenu[0][0]=""; |
while ($row=& $res->fetchRow()){ |
|
$contenu[1][0]=$this->lang('choisir')." ".$this->lang('pos'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
499 |
$contenu[0][$k]=$row[0]; |
$contenu[0][$k]=$row[0]; |
500 |
$contenu[1][$k]=$row[1]; |
$contenu[1][$k]=$row[1]; |
501 |
$k++; |
$k++; |
|
} |
|
|
$form->setSelect("pos",$contenu); |
|
502 |
} |
} |
503 |
// lien sig |
$form->setSelect("pos",$contenu); |
504 |
include ("../dyn/var.inc"); |
|
|
$contenu=array(); |
|
|
$contenu[0]="<img src='".$image_sig."'>"; |
|
|
$form->setSelect("siglien",$contenu); |
|
505 |
// code et libelle voie |
// code et libelle voie |
506 |
$contenu=""; |
$contenu=""; |
507 |
$contenu[0][0]="rivoli";// table |
$contenu[0][0]="rivoli";// table |
509 |
$contenu[1][0]="libelle"; |
$contenu[1][0]="libelle"; |
510 |
$contenu[1][1]="terrain_adresse"; |
$contenu[1][1]="terrain_adresse"; |
511 |
$form->setSelect("rivoli",$contenu); |
$form->setSelect("rivoli",$contenu); |
512 |
|
//terrain_adresse |
513 |
$contenu=""; |
$contenu=""; |
514 |
$contenu[0][0]="rivoli";// table |
$contenu[0][0]="rivoli";// table |
515 |
$contenu[0][1]="libelle"; // zone origine |
$contenu[0][1]="libelle"; // zone origine |
529 |
$contenu[1][0]="architecte"; |
$contenu[1][0]="architecte"; |
530 |
$contenu[1][1]="architecte"; |
$contenu[1][1]="architecte"; |
531 |
$form->setSelect("architecte_nom",$contenu); |
$form->setSelect("architecte_nom",$contenu); |
532 |
|
// parcelle_lot |
533 |
|
$contenu=""; |
534 |
|
$contenu[0][0]="parcelle_lot";// table |
535 |
|
$contenu[0][1]="parcelle_lot"; // zone origine |
536 |
|
$contenu[1][0]="lotissement"; |
537 |
|
$contenu[1][1]="parcelle_lot_lotissement"; |
538 |
|
$form->setSelect("parcelle_lot",$contenu); |
539 |
|
$contenu=""; |
540 |
|
$contenu[0][0]="parcelle_lot";// table |
541 |
|
$contenu[0][1]="lotissement"; // zone origine |
542 |
|
$contenu[1][0]="parcelle_lot"; |
543 |
|
$contenu[1][1]="parcelle_lot"; |
544 |
|
$form->setSelect("parcelle_lot_lotissement",$contenu); |
545 |
// accord tacite |
// accord tacite |
546 |
$contenu=array(); |
$contenu=array(); |
547 |
$contenu[0]=array('Non','Oui'); |
$contenu[0]=array('Non','Oui'); |
553 |
$contenu[0]=array('','bis','ter','quater'); |
$contenu[0]=array('','bis','ter','quater'); |
554 |
$contenu[1]=array('','bis','ter','quater'); |
$contenu[1]=array('','bis','ter','quater'); |
555 |
$form->setSelect("terrain_numero_complement",$contenu); |
$form->setSelect("terrain_numero_complement",$contenu); |
|
// lien demandeur |
|
|
$contenu=array(); |
|
|
$contenu[0]=" <img src='../img/modifier.gif' border ='0'> "; |
|
|
$form->setSelect("saisie_demandeur",$contenu); |
|
|
// lien demandeur |
|
|
$contenu=array(); |
|
|
$contenu[0]=" <img src='../img/modifier.gif' border ='0'> "; |
|
|
$form->setSelect("saisie_delegataire",$contenu); |
|
|
// lien architecte |
|
|
$contenu=array(); |
|
|
$contenu[0]=" <img src='../img/ajouter.gif' border ='0'> "; |
|
|
$form->setSelect("saisie_architecte",$contenu); |
|
556 |
} |
} |
557 |
} |
} |
558 |
|
|
633 |
$form->setGroupe('date_chantier','D'); |
$form->setGroupe('date_chantier','D'); |
634 |
$form->setGroupe('date_achevement','G'); |
$form->setGroupe('date_achevement','G'); |
635 |
$form->setGroupe('date_conformite','F'); |
$form->setGroupe('date_conformite','F'); |
636 |
|
|
637 |
// localisation |
// localisation |
638 |
$form->setGroupe('parcelle','D'); |
$form->setGroupe('parcelle','D'); |
639 |
$form->setGroupe('pos','F'); |
$form->setGroupe('pos','G'); |
640 |
//$form->setGroupe('sig','G'); |
$form->setGroupe('sig','F'); |
|
//$form->setGroupe('siglien','F'); |
|
641 |
|
|
642 |
// description |
// description |
643 |
$form->setGroupe('batiment_nombre','D'); |
$form->setGroupe('batiment_nombre','D'); |
649 |
$form->setGroupe('shon_calcul','G'); |
$form->setGroupe('shon_calcul','G'); |
650 |
$form->setGroupe('shob','G'); |
$form->setGroupe('shob','G'); |
651 |
$form->setGroupe('lot','F'); |
$form->setGroupe('lot','F'); |
652 |
|
|
653 |
|
$form->setGroupe('amenagement','D'); |
654 |
|
$form->setGroupe('parcelle_lot','G'); |
655 |
|
$form->setGroupe('parcelle_lot_lotissement','F'); |
656 |
} |
} |
657 |
|
|
658 |
|
|
720 |
// travaux |
// travaux |
721 |
$form->setLib('objet_dossier',''); |
$form->setLib('objet_dossier',''); |
722 |
$form->setLib('travaux',''); |
$form->setLib('travaux',''); |
|
$form->setLib('saisie_architecte',""); // *** |
|
723 |
$form->setLib('architecte_nom',""); |
$form->setLib('architecte_nom',""); |
724 |
$form->setLib('architecte',''); |
$form->setLib('architecte',''); |
725 |
|
|
731 |
$form->setLib('shon',' '._('shon').' : '); |
$form->setLib('shon',' '._('shon').' : '); |
732 |
$form->setLib('shon_calcul',' '._('calcul shon').' : '); |
$form->setLib('shon_calcul',' '._('calcul shon').' : '); |
733 |
$form->setLib('shob',' '._('shob').' : '); |
$form->setLib('shob',' '._('shob').' : '); |
734 |
|
|
735 |
|
|
736 |
|
// amenagement |
737 |
$form->setLib('amenagement',' '._('amenagement').' : '); |
$form->setLib('amenagement',' '._('amenagement').' : '); |
738 |
|
$form->setLib('parcelle_lot',''); |
739 |
|
$form->setLib('parcelle_lot_lotissement',' '._('lotissement').' : '); |
740 |
|
$form->setLib('parcelle_lot_numero',' '._('no').' : '); |
741 |
|
$form->setLib('sig',' '._('verrou').' '._('sig').' : '); |
742 |
|
|
743 |
// zones temp |
// zones temp |
744 |
include ("../dyn/var.inc"); |
include ("../dyn/var.inc"); |
757 |
$form->setOnchange("delegataire_nom","this.value=this.value.toUpperCase()"); |
$form->setOnchange("delegataire_nom","this.value=this.value.toUpperCase()"); |
758 |
$form->setOnchange("delegataire_societe","this.value=this.value.toUpperCase()"); |
$form->setOnchange("delegataire_societe","this.value=this.value.toUpperCase()"); |
759 |
$form->setOnchange("architecte_nom","this.value=this.value.toUpperCase()"); |
$form->setOnchange("architecte_nom","this.value=this.value.toUpperCase()"); |
760 |
|
$form->setOnchange("terrain_adresse","this.value=this.value.toUpperCase()"); |
761 |
|
|
762 |
} |
} |
763 |
|
|
764 |
function setRegroupe(&$form,$maj){ |
function setRegroupe(&$form,$maj){ |
765 |
// depot |
// depot |
766 |
If ($maj==0){ |
If ($maj==0){ |
767 |
$form->setRegroupe('date_demande','D',_(Depot),$this->aff_depot ); |
$form->setRegroupe('date_demande','D',_("Depot"),$this->aff_depot ); |
768 |
} |
} |
769 |
If ($maj==1){ |
If ($maj==1){ |
770 |
$form->setRegroupe('dossier','D',_(Depot), $this->aff_depot); |
$form->setRegroupe('dossier','D',_("Depot"), $this->aff_depot); |
771 |
$form->setRegroupe('date_demande','G',''); |
$form->setRegroupe('date_demande','G',''); |
772 |
} |
} |
773 |
$form->setRegroupe('date_depot','G',''); |
$form->setRegroupe('date_depot','G',''); |
776 |
// travaux |
// travaux |
777 |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
$form->setRegroupe('architecte','D',_('Architecte')." / "._("Travaux"), $this->aff_travaux); |
778 |
$form->setRegroupe('architecte_nom','G',''); |
$form->setRegroupe('architecte_nom','G',''); |
|
$form->setRegroupe('saisie_architecte','G',''); |
|
779 |
$form->setRegroupe('travaux','F',''); |
$form->setRegroupe('travaux','F',''); |
780 |
|
|
781 |
// instruction |
// instruction |
832 |
|
|
833 |
// localisation |
// localisation |
834 |
$form->setRegroupe('parcelle','D',_('localisation'), $this->aff_localisation); |
$form->setRegroupe('parcelle','D',_('localisation'), $this->aff_localisation); |
835 |
$form->setRegroupe('pos','F',''); |
$form->setRegroupe('pos','G',''); |
836 |
//$form->setRegroupe('sig','G',''); |
$form->setRegroupe('sig','F',''); |
837 |
//$form->setRegroupe('siglien','F',''); |
|
838 |
|
|
839 |
// description |
// description |
840 |
$form->setRegroupe('batiment_nombre','D',_('description'), $this->aff_description); |
$form->setRegroupe('batiment_nombre','D',_('description'), $this->aff_description); |
845 |
$form->setRegroupe('shon_calcul','G',''); |
$form->setRegroupe('shon_calcul','G',''); |
846 |
$form->setRegroupe('shob','G',''); |
$form->setRegroupe('shob','G',''); |
847 |
$form->setRegroupe('lot','F',''); |
$form->setRegroupe('lot','F',''); |
848 |
|
|
849 |
|
// amenagement |
850 |
|
$form->setRegroupe('amenagement','D',_('Amenagement'), $this->aff_amenagement); |
851 |
|
$form->setRegroupe('parcelle_lot','G',''); |
852 |
|
$form->setRegroupe('parcelle_lot_lotissement','F',''); |
853 |
|
|
854 |
|
|
855 |
// temp |
// temp |
856 |
} |
} |
857 |
|
|
863 |
* =============================================================== |
* =============================================================== |
864 |
*/ |
*/ |
865 |
|
|
|
|
|
866 |
function triggerajouterapres($id,&$db,$val,$DEBUG) { |
function triggerajouterapres($id,&$db,$val,$DEBUG) { |
867 |
if (file_exists ("../dyn/var.inc")) |
$this->sig_parametre($db); |
|
include ("../dyn/var.inc"); |
|
|
if(!isset($sig)) $sig=0; |
|
|
if(!isset($auto_pos)) $auto_pos=0; |
|
868 |
$id=$this->valF['dossier']; // id n est pas valorise en ajout |
$id=$this->valF['dossier']; // id n est pas valorise en ajout |
869 |
if($sig==1 ){ |
if($this->sig==1 and $val['sig']!='Oui'){ |
870 |
if($val['parcelle']!='') |
if($val['parcelle']!=''or $val['parcelle_lot']!='') |
871 |
$this->sig_interne($id,&$db,$val,$DEBUG,$auto_pos); |
$this->sig_interne($id,&$db,$val,$DEBUG); |
872 |
else |
else |
873 |
$this->msg = $this->msg."<br>"._("Parcelle non renseignee dans dossier")." ".$id." <br>"; |
$this->addToMessage("<br>"._("Parcelle non renseignee dans dossier")." ".$id." <br>"); |
874 |
} |
} |
875 |
} |
} |
876 |
|
|
877 |
function triggermodifierapres($id,&$db,$val,$DEBUG) { |
function triggermodifierapres($id,&$db,$val,$DEBUG) { |
878 |
if (file_exists ("../dyn/var.inc")) |
$this->sig_parametre($db); |
|
include ("../dyn/var.inc"); |
|
|
if(!isset($sig)) $sig=0; |
|
|
if(!isset($auto_pos)) $auto_pos=0; |
|
879 |
// si la parcelle est changée |
// si la parcelle est changée |
880 |
if($sig==1 and $val['parcelle']!=$val['parcelle_archive']){ |
if(($this->sig==1 and $val['sig']!='Oui' and ($val['parcelle']!=$val['parcelle_archive']) |
881 |
if($val['parcelle']!='') |
or $val['parcelle_lot']!=$val['parcelle_lot_archive'])){ // parcelle_lot_archive |
882 |
$this->sig_interne($this->valF['dossier'],&$db,$val,$DEBUG,$auto_pos); |
if($val['parcelle']!='' or $val['parcelle_lot']!='') |
883 |
} |
$this->sig_interne($this->valF['dossier'],&$db,$val,$DEBUG); |
884 |
|
else |
885 |
|
$this->addToMessage("<br>"._("Parcelle ou parcelle_lot non renseignee dans dossier")." ".$id." <br>"); |
886 |
|
} |
887 |
} |
} |
888 |
|
|
889 |
function sig_interne($id,&$db,$val,$DEBUG,$auto_pos){ |
function sig_parametre(&$db){ |
890 |
|
if (file_exists ("../dyn/var.inc")) |
891 |
|
include ("../dyn/var.inc"); |
892 |
|
if(!isset($sig)) |
893 |
|
$this->sig=0; |
894 |
|
else |
895 |
|
$this->sig=1; |
896 |
|
if(!isset($auto_pos)) |
897 |
|
$this->auto_pos=0; |
898 |
|
else |
899 |
|
$this->auto_pos=$auto_pos; |
900 |
|
if(!isset($auto_servitude_surfacique)) |
901 |
|
$this->auto_servitude_surfacique=0; |
902 |
|
else |
903 |
|
$this->auto_servitude_surfacique=$auto_servitude_surfacique; |
904 |
|
if(!isset($auto_servitude_ligne)) |
905 |
|
$this->auto_servitude_ligne=0; |
906 |
|
else |
907 |
|
$this->auto_servitude_ligne=$auto_servitude_ligne; |
908 |
|
if(!isset($auto_servitude_point)) |
909 |
|
$this->auto_servitude_point=0; |
910 |
|
else |
911 |
|
$this->auto_servitude_point=$auto_servitude_point; |
912 |
|
if(!isset($auto_parcelle)) |
913 |
|
$this->auto_parcelle=0; |
914 |
|
else |
915 |
|
$this->auto_parcelle=$auto_parcelle; |
916 |
|
if(!isset($auto_parcelle_lot)) |
917 |
|
$this->auto_parcelle_lot=0; |
918 |
|
else |
919 |
|
$this->auto_parcelle_lot=$auto_parcelle_lot; |
920 |
|
$this->addToLog("trigger valeur sig :".$this->sig, VERBOSE_MODE); |
921 |
|
$this->addToLog("trigger valeur auto_pos :". $this->auto_pos, VERBOSE_MODE); |
922 |
|
$this->addToLog("trigger valeur auto_servitude_surfacique :".$this->auto_servitude_surfacique, VERBOSE_MODE); |
923 |
|
$this->addToLog("trigger valeur auto_servitude_ligne :". $this->auto_servitude_ligne, VERBOSE_MODE); |
924 |
|
$this->addToLog("trigger valeur auto_servitude_point :".$this->auto_servitude_point, VERBOSE_MODE); |
925 |
|
$this->addToLog("trigger valeur auto_parcelle :". $this->auto_parcelle, VERBOSE_MODE); |
926 |
|
$this->addToLog("trigger valeur auto_parcelle_lot :".$this->auto_parcelle_lot, VERBOSE_MODE); |
927 |
|
} |
928 |
|
|
929 |
|
|
930 |
|
function sig_interne($id,&$db,$val,$DEBUG){ |
931 |
// Strategy interne dans var.inc |
// Strategy interne dans var.inc |
932 |
// si la parcelle existe, il est cree un point au milieu de la parcelle |
// si la parcelle existe, il est cree un point au milieu de la parcelle |
933 |
// de maniere automatique |
// de maniere automatique |
934 |
|
$geom=''; |
935 |
|
$parcelle=$val["parcelle"]; |
936 |
$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'"); |
937 |
$sql= "select astext(centroid(geom)) from parcelle where parcelle ='".$val["parcelle"]."'"; |
if($this->auto_parcelle==1 and $val["parcelle"]!=''){ |
938 |
$geom = $db -> getOne($sql); |
$sql= "select astext(centroid(geom)) from parcelle where parcelle ='".$val["parcelle"]."'"; |
939 |
if($geom!=''){ // la parcelle est exitante dans la table / vue parcelle |
$this->addToLog("recherche centroid parcelle :".$sql, VERBOSE_MODE); |
940 |
|
$geom = $db -> getOne($sql); |
941 |
|
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
942 |
|
} |
943 |
|
if($geom=='' and $this->auto_parcelle_lot==1 and $val["parcelle_lot"]!=''){ // lot |
944 |
|
$sql= "select astext(centroid(geom)) from parcelle_lot where parcelle_lot ='".$val["parcelle_lot"]."'"; |
945 |
|
$this->addToLog("recherche centroid parcelle lot :".$sql, VERBOSE_MODE); |
946 |
|
$geom = $db -> getOne($sql); |
947 |
|
if (database :: isError($geom))die($res->getMessage()."erreur ".$sql); |
948 |
|
$parcelle=$val["parcelle_lot"]." ".$val["parcelle_lot_lotissement"]; |
949 |
|
} |
950 |
|
|
951 |
|
if($geom!=''){ // la parcelle est exitante dans la table ou vue parcelle |
952 |
$sql ="update dossier set geom =geometryfromtext('".$geom."', ".$projection." ) where dossier ='".$id."'"; |
$sql ="update dossier set geom =geometryfromtext('".$geom."', ".$projection." ) where dossier ='".$id."'"; |
953 |
|
$this->addToLog("sig_interne maj geom :".$sql, VERBOSE_MODE); |
954 |
$res = $db -> query($sql); |
$res = $db -> query($sql); |
955 |
if (database :: isError($res)){ |
if (database :: isError($res)) die($res->getMessage()."erreur ".$sql); |
956 |
die($res->getMessage()."erreur ".$sql); |
$this->addToMessage(""._("centroid de parcelle calculé")." ".$parcelle." "); |
957 |
}else{ |
if($this->auto_pos==1) // recherche du pos |
958 |
$this->msg = $this->msg."<br>"._("centroid de parcelle calculé")." ".$val["parcelle"]. |
$this->calcul_auto_pos($id,$db,$geom,$projection); |
959 |
" "._("dossier")." ".$id."<br>"; |
if($this->auto_servitude_surfacique==1) // recherche de servitude surfacique |
960 |
} |
$this->calcul_auto_servitude_surfacique($id,$db,$geom,$projection); |
961 |
if($auto_pos==1) // recherche du pos |
if($this->auto_servitude_ligne==1) // recherche de servitude ligne |
962 |
$this->auto_pos($id,$db,$geom,$projection); |
$this->calcul_auto_servitude_ligne($id,$db,$geom,$projection); |
963 |
|
if($this->auto_servitude_point==1) // recherche de servitude point |
964 |
|
$this->calcul_auto_servitude_point($id,$db,$geom,$projection); |
965 |
|
$temp=strtr($this->servitude,"'"," "); // enleve le ' |
966 |
|
$sql1 ="update dossier set servitude = '".$temp."' where dossier = '".$id."'"; |
967 |
|
$res1 = $db -> query($sql1); |
968 |
|
$this->addToLog("maj servitudes :".$sql1, VERBOSE_MODE); |
969 |
|
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
970 |
}else{ // parcelle inexistante |
}else{ // parcelle inexistante |
971 |
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 |
972 |
$sql ="update dossier set geom = null where dossier ='".$id."'"; |
$sql ="update dossier set geom = null where dossier ='".$id."'"; |
973 |
$res = $db -> query($sql); |
$res = $db -> query($sql); |
974 |
|
$this->addToLog("requete sig_interne maj parcelle inexistante :".$sql, VERBOSE_MODE); |
975 |
if (database :: isError($res)) |
if (database :: isError($res)) |
976 |
die($res->getMessage()."erreur ".$sql); |
die($res->getMessage()."erreur ".$sql); |
977 |
} |
} |
978 |
$this->msg = $this->msg."<br> parcelle ".$val["parcelle"]." "._("inexistante")." ".$id."<br>"; |
$this->addToMessage("<br> parcelle ".$parcelle." "._("inexistante")." ".$id.""); |
979 |
} |
} |
980 |
} |
} |
981 |
|
|
982 |
function auto_pos($id,&$db,$geom,$projection){ |
function calcul_auto_pos($id,&$db,$geom,$projection){ |
983 |
// recherche du pos automatique dans le geom de la table / vue pos |
// recherche du pos automatique |
984 |
$sql="select pos from pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
$sql="select pos from pos WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
985 |
$pos = $db -> getOne($sql); |
$pos = $db -> getOne($sql); |
986 |
|
$this->addToLog("recherche auto_pos :".$sql, VERBOSE_MODE); |
987 |
if($pos!=''){ |
if($pos!=''){ |
988 |
$sql1 ="update dossier set pos = '".$pos."' where dossier = '".$id."'"; |
$sql1 ="update dossier set pos = '".$pos."' where dossier = '".$id."'"; |
989 |
$res1 = $db -> query($sql1); |
$res1 = $db -> query($sql1); |
990 |
if (database:: isError($res1)){ // ok |
$this->addToLog("maj auto_pos :".$sql1, VERBOSE_MODE); |
991 |
die($res1->getMessage()."erreur ".$sql1); |
if (database:: isError($res1)) die($res1->getMessage()."erreur ".$sql1); |
992 |
}else{ |
$this->addToMessage("<br>"._("POS/PLU")." : ".$pos.""); |
|
$this->msg = $this->msg."<br>"._("POS/PLU renseignee automatiquement dans dossier")." ".$id." -> ".$pos."<br>"; |
|
|
} |
|
993 |
}else{ |
}else{ |
994 |
$this->msg = $this->msg."<br>"._("POS/PLU non trouvé pour dossier")." ".$id."<br>"; |
$this->addToMessage("<br>"._("POS/PLU non trouvé")." ".$id.""); |
995 |
} |
} |
996 |
} |
} |
997 |
|
|
998 |
|
function calcul_auto_servitude_surfacique($id,&$db,$geom,$projection){ |
999 |
|
// recherche servitude surfacique |
1000 |
|
$sql="select * from servitude_surfacique WHERE ST_contains(geom, geometryfromtext('".$geom."', ".$projection."))"; |
1001 |
|
$res=$db->query($sql); |
1002 |
|
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
1003 |
|
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
1004 |
|
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
1005 |
|
$this->addToMessage("<br>"._("servitude")." : ".$row['libelle']." - ".$row['observation']); |
1006 |
|
$this->servitude.=" [".$row['libelle']."] ".$row['observation']." - "; |
1007 |
|
} |
1008 |
|
} |
1009 |
|
|
1010 |
|
function calcul_auto_servitude_ligne($id,&$db,$geom,$projection){ |
1011 |
|
// recherche servitude ligne |
1012 |
|
$distance=100; |
1013 |
|
$sql="select * from servitude_ligne WHERE ST_contains(ST_buffer(geom, ".$distance."), geometryfromtext('".$geom."', ".$projection."))"; |
1014 |
|
$res=$db->query($sql); |
1015 |
|
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
1016 |
|
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
1017 |
|
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
1018 |
|
$this->addToMessage("<br>"._("servitude")." : ".$row['libelle']." - ".$row['observation']); |
1019 |
|
$this->servitude.=" [".$row['libelle']."] ".$row['observation']." - "; |
1020 |
|
} |
1021 |
|
} |
1022 |
|
|
1023 |
|
function calcul_auto_servitude_point($id,&$db,$geom,$projection){ |
1024 |
|
// recherche servitude point |
1025 |
|
$distance=500; // monuments historiques |
1026 |
|
$sql="select libelle,observation, distance(geom, geometryfromtext('".$geom."', ".$projection.")) as distance from servitude_point WHERE distance(geom, geometryfromtext('".$geom."', ".$projection."))<".$distance.""; |
1027 |
|
$res=$db->query($sql); |
1028 |
|
if (database:: isError($res)) die($res1->getMessage()."erreur ".$sql); |
1029 |
|
$this->addToLog("requete :".$sql." executee ", VERBOSE_MODE); |
1030 |
|
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
1031 |
|
$this->addToMessage("<br>"._("servitude")." : ".$row['libelle']." - *** ".$row['observation'])." a ".round($row['distance'],2)." m "; |
1032 |
|
$this->servitude.=" [".$row['libelle']."] ".$row['observation']." a ".round($row['distance'],2)." m - "; |
1033 |
|
} |
1034 |
|
} |
1035 |
|
|
1036 |
|
|
1037 |
}// fin classe |
}// fin classe |
1038 |
?> |
?> |