1 |
<?php |
<?php |
2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 28/06/2012 16:26 |
//gen openMairie le 26/09/2012 11:38 |
4 |
|
|
5 |
require_once ("../obj/om_dbform.class.php"); |
require_once ("../obj/om_dbform.class.php"); |
6 |
|
|
7 |
class dossier_gen extends om_dbform { |
class dossier_gen extends om_dbform { |
8 |
var $table="dossier"; |
var $table="dossier"; |
9 |
var $clePrimaire="dossier"; |
var $clePrimaire="dossier"; |
10 |
var $typeCle="A"; |
var $typeCle="A"; |
11 |
|
var $required_field=array( |
12 |
|
"dossier", |
13 |
|
"date_depot" |
14 |
|
); |
15 |
var $retourformulaire; |
var $retourformulaire; |
16 |
|
|
17 |
function setvalF($val) { |
function setvalF($val) { |
18 |
//affectation valeur formulaire |
//affectation valeur formulaire |
19 |
$this->valF['dossier'] = $val['dossier']; |
$this->valF['dossier'] = $val['dossier']; |
20 |
$this->valF['nature'] = $val['nature']; |
if($val['nature'] == "") { |
21 |
|
$this->valF['nature'] = NULL; |
22 |
|
} else { |
23 |
|
$this->valF['nature'] = $val['nature']; |
24 |
|
} |
25 |
$this->valF['annee'] = $val['annee']; |
$this->valF['annee'] = $val['annee']; |
26 |
$this->valF['etat'] = $val['etat']; |
if($val['etat'] == "") { |
27 |
|
$this->valF['etat'] = NULL; |
28 |
|
} else { |
29 |
|
$this->valF['etat'] = $val['etat']; |
30 |
|
} |
31 |
$this->valF['types'] = $val['types']; |
$this->valF['types'] = $val['types']; |
32 |
$this->valF['objet_dossier'] = $val['objet_dossier']; |
$this->valF['objet_dossier'] = $val['objet_dossier']; |
33 |
if(!is_numeric($val['instructeur'])) |
if(!is_numeric($val['instructeur'])) { |
34 |
$this->valF['instructeur']= null; |
$this->valF['instructeur']= null; |
35 |
else |
} else { |
36 |
$this->valF['instructeur'] = $val['instructeur']; |
$this->valF['instructeur'] = $val['instructeur']; |
37 |
if($val['date_demande']!="") $this->valF['date_demande'] = $this->dateDB($val['date_demande']); |
} |
38 |
if($val['date_depot']!="") $this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
if ($val['date_demande'] != "") { |
39 |
if($val['date_complet']!="") $this->valF['date_complet'] = $this->dateDB($val['date_complet']); |
$this->valF['date_demande'] = $this->dateDB($val['date_demande']); |
40 |
if($val['date_rejet']!="") $this->valF['date_rejet'] = $this->dateDB($val['date_rejet']); |
} else { |
41 |
if($val['date_notification_delai']!="") $this->valF['date_notification_delai'] = $this->dateDB($val['date_notification_delai']); |
$this->valF['date_demande'] = NULL; |
42 |
if(!is_numeric($val['delai'])) |
} |
43 |
unset($this->valF['delai']); |
if ($val['date_depot'] != "") { |
44 |
else |
$this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
45 |
|
} |
46 |
|
if ($val['date_complet'] != "") { |
47 |
|
$this->valF['date_complet'] = $this->dateDB($val['date_complet']); |
48 |
|
} else { |
49 |
|
$this->valF['date_complet'] = NULL; |
50 |
|
} |
51 |
|
if ($val['date_rejet'] != "") { |
52 |
|
$this->valF['date_rejet'] = $this->dateDB($val['date_rejet']); |
53 |
|
} else { |
54 |
|
$this->valF['date_rejet'] = NULL; |
55 |
|
} |
56 |
|
if ($val['date_notification_delai'] != "") { |
57 |
|
$this->valF['date_notification_delai'] = $this->dateDB($val['date_notification_delai']); |
58 |
|
} else { |
59 |
|
$this->valF['date_notification_delai'] = NULL; |
60 |
|
} |
61 |
|
if(!is_numeric($val['delai'])) { |
62 |
|
$this->valF['delai'] = ""; |
63 |
|
} else { |
64 |
$this->valF['delai'] = $val['delai']; |
$this->valF['delai'] = $val['delai']; |
65 |
if($val['date_limite']!="") $this->valF['date_limite'] = $this->dateDB($val['date_limite']); |
} |
66 |
|
if ($val['date_limite'] != "") { |
67 |
|
$this->valF['date_limite'] = $this->dateDB($val['date_limite']); |
68 |
|
} else { |
69 |
|
$this->valF['date_limite'] = NULL; |
70 |
|
} |
71 |
$this->valF['accord_tacite'] = $val['accord_tacite']; |
$this->valF['accord_tacite'] = $val['accord_tacite']; |
72 |
if($val['date_decision']!="") $this->valF['date_decision'] = $this->dateDB($val['date_decision']); |
if ($val['date_decision'] != "") { |
73 |
$this->valF['avis'] = $val['avis']; |
$this->valF['date_decision'] = $this->dateDB($val['date_decision']); |
74 |
if($val['date_validite']!="") $this->valF['date_validite'] = $this->dateDB($val['date_validite']); |
} else { |
75 |
if($val['date_chantier']!="") $this->valF['date_chantier'] = $this->dateDB($val['date_chantier']); |
$this->valF['date_decision'] = NULL; |
76 |
if($val['date_achevement']!="") $this->valF['date_achevement'] = $this->dateDB($val['date_achevement']); |
} |
77 |
if($val['date_conformite']!="") $this->valF['date_conformite'] = $this->dateDB($val['date_conformite']); |
if($val['avis'] == "") { |
78 |
$this->valF['demandeur_civilite'] = $val['demandeur_civilite']; |
$this->valF['avis'] = NULL; |
79 |
|
} else { |
80 |
|
$this->valF['avis'] = $val['avis']; |
81 |
|
} |
82 |
|
if ($val['date_validite'] != "") { |
83 |
|
$this->valF['date_validite'] = $this->dateDB($val['date_validite']); |
84 |
|
} else { |
85 |
|
$this->valF['date_validite'] = NULL; |
86 |
|
} |
87 |
|
if ($val['date_chantier'] != "") { |
88 |
|
$this->valF['date_chantier'] = $this->dateDB($val['date_chantier']); |
89 |
|
} else { |
90 |
|
$this->valF['date_chantier'] = NULL; |
91 |
|
} |
92 |
|
if ($val['date_achevement'] != "") { |
93 |
|
$this->valF['date_achevement'] = $this->dateDB($val['date_achevement']); |
94 |
|
} else { |
95 |
|
$this->valF['date_achevement'] = NULL; |
96 |
|
} |
97 |
|
if ($val['date_conformite'] != "") { |
98 |
|
$this->valF['date_conformite'] = $this->dateDB($val['date_conformite']); |
99 |
|
} else { |
100 |
|
$this->valF['date_conformite'] = NULL; |
101 |
|
} |
102 |
|
if($val['demandeur_civilite'] == "") { |
103 |
|
$this->valF['demandeur_civilite'] = NULL; |
104 |
|
} else { |
105 |
|
$this->valF['demandeur_civilite'] = $val['demandeur_civilite']; |
106 |
|
} |
107 |
$this->valF['demandeur_nom'] = $val['demandeur_nom']; |
$this->valF['demandeur_nom'] = $val['demandeur_nom']; |
108 |
$this->valF['demandeur_societe'] = $val['demandeur_societe']; |
$this->valF['demandeur_societe'] = $val['demandeur_societe']; |
109 |
$this->valF['demandeur_adresse'] = $val['demandeur_adresse']; |
$this->valF['demandeur_adresse'] = $val['demandeur_adresse']; |
110 |
|
$this->valF['demandeur_adresse_complement'] = $val['demandeur_adresse_complement']; |
111 |
$this->valF['demandeur_cp'] = $val['demandeur_cp']; |
$this->valF['demandeur_cp'] = $val['demandeur_cp']; |
112 |
$this->valF['demandeur_ville'] = $val['demandeur_ville']; |
$this->valF['demandeur_ville'] = $val['demandeur_ville']; |
113 |
$this->valF['demandeur_pays'] = $val['demandeur_pays']; |
$this->valF['demandeur_pays'] = $val['demandeur_pays']; |
114 |
$this->valF['demandeur_telephone'] = $val['demandeur_telephone']; |
$this->valF['demandeur_telephone'] = $val['demandeur_telephone']; |
115 |
$this->valF['demandeur_email'] = $val['demandeur_email']; |
$this->valF['demandeur_email'] = $val['demandeur_email']; |
116 |
if(!is_numeric($val['demandeur_categorie'])) |
if(!is_numeric($val['demandeur_categorie'])) { |
117 |
$this->valF['demandeur_categorie']= null; |
$this->valF['demandeur_categorie']= null; |
118 |
else |
} else { |
119 |
$this->valF['demandeur_categorie'] = $val['demandeur_categorie']; |
$this->valF['demandeur_categorie'] = $val['demandeur_categorie']; |
120 |
|
} |
121 |
$this->valF['delegataire'] = $val['delegataire']; |
$this->valF['delegataire'] = $val['delegataire']; |
122 |
$this->valF['delegataire_civilite'] = $val['delegataire_civilite']; |
if($val['delegataire_civilite'] == "") { |
123 |
|
$this->valF['delegataire_civilite'] = NULL; |
124 |
|
} else { |
125 |
|
$this->valF['delegataire_civilite'] = $val['delegataire_civilite']; |
126 |
|
} |
127 |
$this->valF['delegataire_nom'] = $val['delegataire_nom']; |
$this->valF['delegataire_nom'] = $val['delegataire_nom']; |
128 |
$this->valF['delegataire_societe'] = $val['delegataire_societe']; |
$this->valF['delegataire_societe'] = $val['delegataire_societe']; |
129 |
$this->valF['delegataire_adresse'] = $val['delegataire_adresse']; |
$this->valF['delegataire_adresse'] = $val['delegataire_adresse']; |
130 |
|
$this->valF['delegataire_adresse_complement'] = $val['delegataire_adresse_complement']; |
131 |
$this->valF['delegataire_cp'] = $val['delegataire_cp']; |
$this->valF['delegataire_cp'] = $val['delegataire_cp']; |
132 |
$this->valF['delegataire_ville'] = $val['delegataire_ville']; |
$this->valF['delegataire_ville'] = $val['delegataire_ville']; |
133 |
$this->valF['delegataire_pays'] = $val['delegataire_pays']; |
$this->valF['delegataire_pays'] = $val['delegataire_pays']; |
139 |
$this->valF['terrain_adresse_complement'] = $val['terrain_adresse_complement']; |
$this->valF['terrain_adresse_complement'] = $val['terrain_adresse_complement']; |
140 |
$this->valF['terrain_cp'] = $val['terrain_cp']; |
$this->valF['terrain_cp'] = $val['terrain_cp']; |
141 |
$this->valF['terrain_ville'] = $val['terrain_ville']; |
$this->valF['terrain_ville'] = $val['terrain_ville']; |
142 |
if(!is_numeric($val['architecte'])) |
if(!is_numeric($val['architecte'])) { |
143 |
$this->valF['architecte']= null; |
$this->valF['architecte']= null; |
144 |
else |
} else { |
145 |
$this->valF['architecte'] = $val['architecte']; |
$this->valF['architecte'] = $val['architecte']; |
146 |
$this->valF['terrain_surface'] = $val['terrain_surface']; |
} |
147 |
$this->valF['terrain_surface_calcul'] = $val['terrain_surface_calcul']; |
if(!is_numeric($val['terrain_surface'])) { |
148 |
$this->valF['rivoli'] = $val['rivoli']; |
$this->valF['terrain_surface']= null; |
149 |
if(!is_numeric($val['travaux'])) |
} else { |
150 |
|
$this->valF['terrain_surface'] = $val['terrain_surface']; |
151 |
|
} |
152 |
|
if(!is_numeric($val['terrain_surface_calcul'])) { |
153 |
|
$this->valF['terrain_surface_calcul']= null; |
154 |
|
} else { |
155 |
|
$this->valF['terrain_surface_calcul'] = $val['terrain_surface_calcul']; |
156 |
|
} |
157 |
|
if($val['rivoli'] == "") { |
158 |
|
$this->valF['rivoli'] = NULL; |
159 |
|
} else { |
160 |
|
$this->valF['rivoli'] = $val['rivoli']; |
161 |
|
} |
162 |
|
if(!is_numeric($val['travaux'])) { |
163 |
$this->valF['travaux']= null; |
$this->valF['travaux']= null; |
164 |
else |
} else { |
165 |
$this->valF['travaux'] = $val['travaux']; |
$this->valF['travaux'] = $val['travaux']; |
166 |
$this->valF['parcelle'] = $val['parcelle']; |
} |
167 |
$this->valF['pos'] = $val['pos']; |
$this->valF['travaux_complement'] = $val['travaux_complement']; |
168 |
|
if($val['parcelle'] == "") { |
169 |
|
$this->valF['parcelle'] = NULL; |
170 |
|
} else { |
171 |
|
$this->valF['parcelle'] = $val['parcelle']; |
172 |
|
} |
173 |
|
if($val['pos'] == "") { |
174 |
|
$this->valF['pos'] = NULL; |
175 |
|
} else { |
176 |
|
$this->valF['pos'] = $val['pos']; |
177 |
|
} |
178 |
$this->valF['sig'] = $val['sig']; |
$this->valF['sig'] = $val['sig']; |
179 |
if(!is_numeric($val['batiment_nombre'])) |
if(!is_numeric($val['batiment_nombre'])) { |
180 |
$this->valF['batiment_nombre']= null; |
$this->valF['batiment_nombre']= null; |
181 |
else |
} else { |
182 |
$this->valF['batiment_nombre'] = $val['batiment_nombre']; |
$this->valF['batiment_nombre'] = $val['batiment_nombre']; |
183 |
if(!is_numeric($val['logement_nombre'])) |
} |
184 |
|
if(!is_numeric($val['logement_nombre'])) { |
185 |
$this->valF['logement_nombre']= null; |
$this->valF['logement_nombre']= null; |
186 |
else |
} else { |
187 |
$this->valF['logement_nombre'] = $val['logement_nombre']; |
$this->valF['logement_nombre'] = $val['logement_nombre']; |
188 |
$this->valF['shon'] = $val['shon']; |
} |
189 |
$this->valF['shon_calcul'] = $val['shon_calcul']; |
if(!is_numeric($val['shon'])) { |
190 |
$this->valF['shob'] = $val['shob']; |
$this->valF['shon']= null; |
191 |
if(!is_numeric($val['lot'])) |
} else { |
192 |
|
$this->valF['shon'] = $val['shon']; |
193 |
|
} |
194 |
|
if(!is_numeric($val['shon_calcul'])) { |
195 |
|
$this->valF['shon_calcul']= null; |
196 |
|
} else { |
197 |
|
$this->valF['shon_calcul'] = $val['shon_calcul']; |
198 |
|
} |
199 |
|
if(!is_numeric($val['shob'])) { |
200 |
|
$this->valF['shob']= null; |
201 |
|
} else { |
202 |
|
$this->valF['shob'] = $val['shob']; |
203 |
|
} |
204 |
|
if(!is_numeric($val['lot'])) { |
205 |
$this->valF['lot']= null; |
$this->valF['lot']= null; |
206 |
else |
} else { |
207 |
$this->valF['lot'] = $val['lot']; |
$this->valF['lot'] = $val['lot']; |
208 |
$this->valF['hauteur'] = $val['hauteur']; |
} |
209 |
if(!is_numeric($val['piece_nombre'])) |
if(!is_numeric($val['hauteur'])) { |
210 |
|
$this->valF['hauteur']= null; |
211 |
|
} else { |
212 |
|
$this->valF['hauteur'] = $val['hauteur']; |
213 |
|
} |
214 |
|
if(!is_numeric($val['piece_nombre'])) { |
215 |
$this->valF['piece_nombre']= null; |
$this->valF['piece_nombre']= null; |
216 |
else |
} else { |
217 |
$this->valF['piece_nombre'] = $val['piece_nombre']; |
$this->valF['piece_nombre'] = $val['piece_nombre']; |
218 |
|
} |
219 |
$this->valF['amenagement'] = $val['amenagement']; |
$this->valF['amenagement'] = $val['amenagement']; |
220 |
if(!is_numeric($val['parcelle_lot'])) |
if(!is_numeric($val['parcelle_lot'])) { |
221 |
$this->valF['parcelle_lot']= null; |
$this->valF['parcelle_lot']= null; |
222 |
else |
} else { |
223 |
$this->valF['parcelle_lot'] = $val['parcelle_lot']; |
$this->valF['parcelle_lot'] = $val['parcelle_lot']; |
224 |
|
} |
225 |
$this->valF['parcelle_lot_lotissement'] = $val['parcelle_lot_lotissement']; |
$this->valF['parcelle_lot_lotissement'] = $val['parcelle_lot_lotissement']; |
226 |
$this->valF['description'] = $val['description']; |
$this->valF['description'] = $val['description']; |
227 |
$this->valF['temp1'] = $val['temp1']; |
$this->valF['temp1'] = $val['temp1']; |
231 |
$this->valF['temp5'] = $val['temp5']; |
$this->valF['temp5'] = $val['temp5']; |
232 |
$this->valF['servitude'] = $val['servitude']; |
$this->valF['servitude'] = $val['servitude']; |
233 |
$this->valF['geom'] = $val['geom']; |
$this->valF['geom'] = $val['geom']; |
|
$this->valF['travaux_complement'] = $val['travaux_complement']; |
|
|
$this->valF['demandeur_adresse_complement'] = $val['demandeur_adresse_complement']; |
|
|
$this->valF['delegataire_adresse_complement'] = $val['delegataire_adresse_complement']; |
|
234 |
$this->valF['geom1'] = $val['geom1']; |
$this->valF['geom1'] = $val['geom1']; |
235 |
} |
} |
236 |
|
|
|
//==================================== |
|
|
// verifier avant validation [verify] |
|
|
//===================================== |
|
|
/** |
|
|
* Methode verifier |
|
|
*/ |
|
|
function verifier($val = array(), &$db = NULL, $DEBUG = false) { |
|
|
// On appelle la methode de la classe parent |
|
|
parent::verifier($val, $db, $DEBUG); |
|
|
// On verifie si le champ n'est pas vide |
|
|
if ($this->valF['nature'] == "") { |
|
|
$this->correct = false; |
|
|
$this->addToMessage(_("Le champ")." "._("nature")." "._("est obligatoire")); |
|
|
} |
|
|
} |
|
|
|
|
|
|
|
237 |
//========================== |
//========================== |
238 |
// Formulaire [form] |
// Formulaire [form] |
239 |
//========================== |
//========================== |
242 |
//type |
//type |
243 |
if ($maj==0){ //ajout |
if ($maj==0){ //ajout |
244 |
$form->setType('dossier','text'); |
$form->setType('dossier','text'); |
245 |
if($this->retourformulaire=='nature') |
|
246 |
$form->setType('nature','hiddenstatic'); |
if($this->retourformulaire=='nature' |
247 |
else |
and $form->val['nature'] == $this->getParameter('idxformulaire')) { |
248 |
|
$form->setType('nature','selecthiddenstatic'); |
249 |
|
} else { |
250 |
$form->setType('nature','select'); |
$form->setType('nature','select'); |
251 |
|
} |
252 |
$form->setType('annee','text'); |
$form->setType('annee','text'); |
253 |
if($this->retourformulaire=='etat') |
|
254 |
$form->setType('etat','hiddenstatic'); |
if($this->retourformulaire=='etat' |
255 |
else |
and $form->val['etat'] == $this->getParameter('idxformulaire')) { |
256 |
|
$form->setType('etat','selecthiddenstatic'); |
257 |
|
} else { |
258 |
$form->setType('etat','select'); |
$form->setType('etat','select'); |
259 |
|
} |
260 |
$form->setType('types','text'); |
$form->setType('types','text'); |
261 |
$form->setType('objet_dossier','text'); |
$form->setType('objet_dossier','text'); |
262 |
$form->setType('instructeur','text'); |
|
263 |
|
if($this->retourformulaire=='om_utilisateur' |
264 |
|
and $form->val['instructeur'] == $this->getParameter('idxformulaire')) { |
265 |
|
$form->setType('instructeur','selecthiddenstatic'); |
266 |
|
} else { |
267 |
|
$form->setType('instructeur','select'); |
268 |
|
} |
269 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
270 |
$form->setType('date_demande','date'); |
$form->setType('date_demande','date'); |
271 |
else |
else |
296 |
$form->setType('date_decision','date'); |
$form->setType('date_decision','date'); |
297 |
else |
else |
298 |
$form->setType('date_decision','date2'); |
$form->setType('date_decision','date2'); |
299 |
if($this->retourformulaire=='avis') |
|
300 |
$form->setType('avis','hiddenstatic'); |
if($this->retourformulaire=='avis' |
301 |
else |
and $form->val['avis'] == $this->getParameter('idxformulaire')) { |
302 |
|
$form->setType('avis','selecthiddenstatic'); |
303 |
|
} else { |
304 |
$form->setType('avis','select'); |
$form->setType('avis','select'); |
305 |
|
} |
306 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
307 |
$form->setType('date_validite','date'); |
$form->setType('date_validite','date'); |
308 |
else |
else |
319 |
$form->setType('date_conformite','date'); |
$form->setType('date_conformite','date'); |
320 |
else |
else |
321 |
$form->setType('date_conformite','date2'); |
$form->setType('date_conformite','date2'); |
322 |
$form->setType('demandeur_civilite','text'); |
|
323 |
|
if($this->retourformulaire=='civilite' |
324 |
|
and $form->val['demandeur_civilite'] == $this->getParameter('idxformulaire')) { |
325 |
|
$form->setType('demandeur_civilite','selecthiddenstatic'); |
326 |
|
} else { |
327 |
|
$form->setType('demandeur_civilite','select'); |
328 |
|
} |
329 |
$form->setType('demandeur_nom','text'); |
$form->setType('demandeur_nom','text'); |
330 |
$form->setType('demandeur_societe','text'); |
$form->setType('demandeur_societe','text'); |
331 |
$form->setType('demandeur_adresse','text'); |
$form->setType('demandeur_adresse','text'); |
332 |
|
$form->setType('demandeur_adresse_complement','text'); |
333 |
$form->setType('demandeur_cp','text'); |
$form->setType('demandeur_cp','text'); |
334 |
$form->setType('demandeur_ville','text'); |
$form->setType('demandeur_ville','text'); |
335 |
$form->setType('demandeur_pays','text'); |
$form->setType('demandeur_pays','text'); |
336 |
$form->setType('demandeur_telephone','text'); |
$form->setType('demandeur_telephone','text'); |
337 |
$form->setType('demandeur_email','text'); |
$form->setType('demandeur_email','text'); |
338 |
$form->setType('demandeur_categorie','text'); |
|
339 |
|
if($this->retourformulaire=='categorie_demandeur' |
340 |
|
and $form->val['demandeur_categorie'] == $this->getParameter('idxformulaire')) { |
341 |
|
$form->setType('demandeur_categorie','selecthiddenstatic'); |
342 |
|
} else { |
343 |
|
$form->setType('demandeur_categorie','select'); |
344 |
|
} |
345 |
$form->setType('delegataire','text'); |
$form->setType('delegataire','text'); |
346 |
$form->setType('delegataire_civilite','text'); |
|
347 |
|
if($this->retourformulaire=='civilite' |
348 |
|
and $form->val['delegataire_civilite'] == $this->getParameter('idxformulaire')) { |
349 |
|
$form->setType('delegataire_civilite','selecthiddenstatic'); |
350 |
|
} else { |
351 |
|
$form->setType('delegataire_civilite','select'); |
352 |
|
} |
353 |
$form->setType('delegataire_nom','text'); |
$form->setType('delegataire_nom','text'); |
354 |
$form->setType('delegataire_societe','text'); |
$form->setType('delegataire_societe','text'); |
355 |
$form->setType('delegataire_adresse','text'); |
$form->setType('delegataire_adresse','text'); |
356 |
|
$form->setType('delegataire_adresse_complement','text'); |
357 |
$form->setType('delegataire_cp','text'); |
$form->setType('delegataire_cp','text'); |
358 |
$form->setType('delegataire_ville','text'); |
$form->setType('delegataire_ville','text'); |
359 |
$form->setType('delegataire_pays','text'); |
$form->setType('delegataire_pays','text'); |
365 |
$form->setType('terrain_adresse_complement','text'); |
$form->setType('terrain_adresse_complement','text'); |
366 |
$form->setType('terrain_cp','text'); |
$form->setType('terrain_cp','text'); |
367 |
$form->setType('terrain_ville','text'); |
$form->setType('terrain_ville','text'); |
368 |
if($this->retourformulaire=='architecte') |
|
369 |
$form->setType('architecte','hiddenstatic'); |
if($this->retourformulaire=='architecte' |
370 |
else |
and $form->val['architecte'] == $this->getParameter('idxformulaire')) { |
371 |
|
$form->setType('architecte','selecthiddenstatic'); |
372 |
|
} else { |
373 |
$form->setType('architecte','select'); |
$form->setType('architecte','select'); |
374 |
|
} |
375 |
$form->setType('terrain_surface','text'); |
$form->setType('terrain_surface','text'); |
376 |
$form->setType('terrain_surface_calcul','text'); |
$form->setType('terrain_surface_calcul','text'); |
377 |
if($this->retourformulaire=='rivoli') |
|
378 |
$form->setType('rivoli','hiddenstatic'); |
if($this->retourformulaire=='rivoli' |
379 |
else |
and $form->val['rivoli'] == $this->getParameter('idxformulaire')) { |
380 |
|
$form->setType('rivoli','selecthiddenstatic'); |
381 |
|
} else { |
382 |
$form->setType('rivoli','select'); |
$form->setType('rivoli','select'); |
383 |
if($this->retourformulaire=='travaux') |
} |
384 |
$form->setType('travaux','hiddenstatic'); |
|
385 |
else |
if($this->retourformulaire=='travaux' |
386 |
|
and $form->val['travaux'] == $this->getParameter('idxformulaire')) { |
387 |
|
$form->setType('travaux','selecthiddenstatic'); |
388 |
|
} else { |
389 |
$form->setType('travaux','select'); |
$form->setType('travaux','select'); |
390 |
if($this->retourformulaire=='parcelle') |
} |
391 |
$form->setType('parcelle','hiddenstatic'); |
$form->setType('travaux_complement','text'); |
392 |
else |
|
393 |
|
if($this->retourformulaire=='parcelle' |
394 |
|
and $form->val['parcelle'] == $this->getParameter('idxformulaire')) { |
395 |
|
$form->setType('parcelle','selecthiddenstatic'); |
396 |
|
} else { |
397 |
$form->setType('parcelle','select'); |
$form->setType('parcelle','select'); |
398 |
if($this->retourformulaire=='pos') |
} |
399 |
$form->setType('pos','hiddenstatic'); |
|
400 |
else |
if($this->retourformulaire=='pos' |
401 |
|
and $form->val['pos'] == $this->getParameter('idxformulaire')) { |
402 |
|
$form->setType('pos','selecthiddenstatic'); |
403 |
|
} else { |
404 |
$form->setType('pos','select'); |
$form->setType('pos','select'); |
405 |
|
} |
406 |
$form->setType('sig','text'); |
$form->setType('sig','text'); |
407 |
$form->setType('batiment_nombre','text'); |
$form->setType('batiment_nombre','text'); |
408 |
$form->setType('logement_nombre','text'); |
$form->setType('logement_nombre','text'); |
413 |
$form->setType('hauteur','text'); |
$form->setType('hauteur','text'); |
414 |
$form->setType('piece_nombre','text'); |
$form->setType('piece_nombre','text'); |
415 |
$form->setType('amenagement','text'); |
$form->setType('amenagement','text'); |
416 |
if($this->retourformulaire=='parcelle_lot') |
|
417 |
$form->setType('parcelle_lot','hiddenstatic'); |
if($this->retourformulaire=='parcelle_lot' |
418 |
else |
and $form->val['parcelle_lot'] == $this->getParameter('idxformulaire')) { |
419 |
|
$form->setType('parcelle_lot','selecthiddenstatic'); |
420 |
|
} else { |
421 |
$form->setType('parcelle_lot','select'); |
$form->setType('parcelle_lot','select'); |
422 |
|
} |
423 |
$form->setType('parcelle_lot_lotissement','text'); |
$form->setType('parcelle_lot_lotissement','text'); |
424 |
$form->setType('description','textarea'); |
$form->setType('description','textarea'); |
425 |
$form->setType('temp1','text'); |
$form->setType('temp1','text'); |
429 |
$form->setType('temp5','text'); |
$form->setType('temp5','text'); |
430 |
$form->setType('servitude','textarea'); |
$form->setType('servitude','textarea'); |
431 |
$form->setType('geom','geom'); |
$form->setType('geom','geom'); |
|
$form->setType('travaux_complement','text'); |
|
|
$form->setType('demandeur_adresse_complement','text'); |
|
|
$form->setType('delegataire_adresse_complement','text'); |
|
432 |
$form->setType('geom1','geom'); |
$form->setType('geom1','geom'); |
433 |
}// fin ajout |
}// fin ajout |
434 |
if ($maj==1){ //modifier |
if ($maj==1){ //modifier |
435 |
$form->setType('dossier','hiddenstatic'); |
$form->setType('dossier','hiddenstatic'); |
436 |
if($this->retourformulaire=='nature') |
|
437 |
$form->setType('nature','hiddenstatic'); |
if($this->retourformulaire=='nature' |
438 |
else |
and $form->val['nature'] == $this->getParameter('idxformulaire')) { |
439 |
|
$form->setType('nature','selecthiddenstatic'); |
440 |
|
} else { |
441 |
$form->setType('nature','select'); |
$form->setType('nature','select'); |
442 |
|
} |
443 |
$form->setType('annee','text'); |
$form->setType('annee','text'); |
444 |
if($this->retourformulaire=='etat') |
|
445 |
$form->setType('etat','hiddenstatic'); |
if($this->retourformulaire=='etat' |
446 |
else |
and $form->val['etat'] == $this->getParameter('idxformulaire')) { |
447 |
|
$form->setType('etat','selecthiddenstatic'); |
448 |
|
} else { |
449 |
$form->setType('etat','select'); |
$form->setType('etat','select'); |
450 |
|
} |
451 |
$form->setType('types','text'); |
$form->setType('types','text'); |
452 |
$form->setType('objet_dossier','text'); |
$form->setType('objet_dossier','text'); |
453 |
$form->setType('instructeur','text'); |
|
454 |
|
if($this->retourformulaire=='om_utilisateur' |
455 |
|
and $form->val['instructeur'] == $this->getParameter('idxformulaire')) { |
456 |
|
$form->setType('instructeur','selecthiddenstatic'); |
457 |
|
} else { |
458 |
|
$form->setType('instructeur','select'); |
459 |
|
} |
460 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
461 |
$form->setType('date_demande','date'); |
$form->setType('date_demande','date'); |
462 |
else |
else |
487 |
$form->setType('date_decision','date'); |
$form->setType('date_decision','date'); |
488 |
else |
else |
489 |
$form->setType('date_decision','date2'); |
$form->setType('date_decision','date2'); |
490 |
if($this->retourformulaire=='avis') |
|
491 |
$form->setType('avis','hiddenstatic'); |
if($this->retourformulaire=='avis' |
492 |
else |
and $form->val['avis'] == $this->getParameter('idxformulaire')) { |
493 |
|
$form->setType('avis','selecthiddenstatic'); |
494 |
|
} else { |
495 |
$form->setType('avis','select'); |
$form->setType('avis','select'); |
496 |
|
} |
497 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
498 |
$form->setType('date_validite','date'); |
$form->setType('date_validite','date'); |
499 |
else |
else |
510 |
$form->setType('date_conformite','date'); |
$form->setType('date_conformite','date'); |
511 |
else |
else |
512 |
$form->setType('date_conformite','date2'); |
$form->setType('date_conformite','date2'); |
513 |
$form->setType('demandeur_civilite','text'); |
|
514 |
|
if($this->retourformulaire=='civilite' |
515 |
|
and $form->val['demandeur_civilite'] == $this->getParameter('idxformulaire')) { |
516 |
|
$form->setType('demandeur_civilite','selecthiddenstatic'); |
517 |
|
} else { |
518 |
|
$form->setType('demandeur_civilite','select'); |
519 |
|
} |
520 |
$form->setType('demandeur_nom','text'); |
$form->setType('demandeur_nom','text'); |
521 |
$form->setType('demandeur_societe','text'); |
$form->setType('demandeur_societe','text'); |
522 |
$form->setType('demandeur_adresse','text'); |
$form->setType('demandeur_adresse','text'); |
523 |
|
$form->setType('demandeur_adresse_complement','text'); |
524 |
$form->setType('demandeur_cp','text'); |
$form->setType('demandeur_cp','text'); |
525 |
$form->setType('demandeur_ville','text'); |
$form->setType('demandeur_ville','text'); |
526 |
$form->setType('demandeur_pays','text'); |
$form->setType('demandeur_pays','text'); |
527 |
$form->setType('demandeur_telephone','text'); |
$form->setType('demandeur_telephone','text'); |
528 |
$form->setType('demandeur_email','text'); |
$form->setType('demandeur_email','text'); |
529 |
$form->setType('demandeur_categorie','text'); |
|
530 |
|
if($this->retourformulaire=='categorie_demandeur' |
531 |
|
and $form->val['demandeur_categorie'] == $this->getParameter('idxformulaire')) { |
532 |
|
$form->setType('demandeur_categorie','selecthiddenstatic'); |
533 |
|
} else { |
534 |
|
$form->setType('demandeur_categorie','select'); |
535 |
|
} |
536 |
$form->setType('delegataire','text'); |
$form->setType('delegataire','text'); |
537 |
$form->setType('delegataire_civilite','text'); |
|
538 |
|
if($this->retourformulaire=='civilite' |
539 |
|
and $form->val['delegataire_civilite'] == $this->getParameter('idxformulaire')) { |
540 |
|
$form->setType('delegataire_civilite','selecthiddenstatic'); |
541 |
|
} else { |
542 |
|
$form->setType('delegataire_civilite','select'); |
543 |
|
} |
544 |
$form->setType('delegataire_nom','text'); |
$form->setType('delegataire_nom','text'); |
545 |
$form->setType('delegataire_societe','text'); |
$form->setType('delegataire_societe','text'); |
546 |
$form->setType('delegataire_adresse','text'); |
$form->setType('delegataire_adresse','text'); |
547 |
|
$form->setType('delegataire_adresse_complement','text'); |
548 |
$form->setType('delegataire_cp','text'); |
$form->setType('delegataire_cp','text'); |
549 |
$form->setType('delegataire_ville','text'); |
$form->setType('delegataire_ville','text'); |
550 |
$form->setType('delegataire_pays','text'); |
$form->setType('delegataire_pays','text'); |
556 |
$form->setType('terrain_adresse_complement','text'); |
$form->setType('terrain_adresse_complement','text'); |
557 |
$form->setType('terrain_cp','text'); |
$form->setType('terrain_cp','text'); |
558 |
$form->setType('terrain_ville','text'); |
$form->setType('terrain_ville','text'); |
559 |
if($this->retourformulaire=='architecte') |
|
560 |
$form->setType('architecte','hiddenstatic'); |
if($this->retourformulaire=='architecte' |
561 |
else |
and $form->val['architecte'] == $this->getParameter('idxformulaire')) { |
562 |
|
$form->setType('architecte','selecthiddenstatic'); |
563 |
|
} else { |
564 |
$form->setType('architecte','select'); |
$form->setType('architecte','select'); |
565 |
|
} |
566 |
$form->setType('terrain_surface','text'); |
$form->setType('terrain_surface','text'); |
567 |
$form->setType('terrain_surface_calcul','text'); |
$form->setType('terrain_surface_calcul','text'); |
568 |
if($this->retourformulaire=='rivoli') |
|
569 |
$form->setType('rivoli','hiddenstatic'); |
if($this->retourformulaire=='rivoli' |
570 |
else |
and $form->val['rivoli'] == $this->getParameter('idxformulaire')) { |
571 |
|
$form->setType('rivoli','selecthiddenstatic'); |
572 |
|
} else { |
573 |
$form->setType('rivoli','select'); |
$form->setType('rivoli','select'); |
574 |
if($this->retourformulaire=='travaux') |
} |
575 |
$form->setType('travaux','hiddenstatic'); |
|
576 |
else |
if($this->retourformulaire=='travaux' |
577 |
|
and $form->val['travaux'] == $this->getParameter('idxformulaire')) { |
578 |
|
$form->setType('travaux','selecthiddenstatic'); |
579 |
|
} else { |
580 |
$form->setType('travaux','select'); |
$form->setType('travaux','select'); |
581 |
if($this->retourformulaire=='parcelle') |
} |
582 |
$form->setType('parcelle','hiddenstatic'); |
$form->setType('travaux_complement','text'); |
583 |
else |
|
584 |
|
if($this->retourformulaire=='parcelle' |
585 |
|
and $form->val['parcelle'] == $this->getParameter('idxformulaire')) { |
586 |
|
$form->setType('parcelle','selecthiddenstatic'); |
587 |
|
} else { |
588 |
$form->setType('parcelle','select'); |
$form->setType('parcelle','select'); |
589 |
if($this->retourformulaire=='pos') |
} |
590 |
$form->setType('pos','hiddenstatic'); |
|
591 |
else |
if($this->retourformulaire=='pos' |
592 |
|
and $form->val['pos'] == $this->getParameter('idxformulaire')) { |
593 |
|
$form->setType('pos','selecthiddenstatic'); |
594 |
|
} else { |
595 |
$form->setType('pos','select'); |
$form->setType('pos','select'); |
596 |
|
} |
597 |
$form->setType('sig','text'); |
$form->setType('sig','text'); |
598 |
$form->setType('batiment_nombre','text'); |
$form->setType('batiment_nombre','text'); |
599 |
$form->setType('logement_nombre','text'); |
$form->setType('logement_nombre','text'); |
604 |
$form->setType('hauteur','text'); |
$form->setType('hauteur','text'); |
605 |
$form->setType('piece_nombre','text'); |
$form->setType('piece_nombre','text'); |
606 |
$form->setType('amenagement','text'); |
$form->setType('amenagement','text'); |
607 |
if($this->retourformulaire=='parcelle_lot') |
|
608 |
$form->setType('parcelle_lot','hiddenstatic'); |
if($this->retourformulaire=='parcelle_lot' |
609 |
else |
and $form->val['parcelle_lot'] == $this->getParameter('idxformulaire')) { |
610 |
|
$form->setType('parcelle_lot','selecthiddenstatic'); |
611 |
|
} else { |
612 |
$form->setType('parcelle_lot','select'); |
$form->setType('parcelle_lot','select'); |
613 |
|
} |
614 |
$form->setType('parcelle_lot_lotissement','text'); |
$form->setType('parcelle_lot_lotissement','text'); |
615 |
$form->setType('description','textarea'); |
$form->setType('description','textarea'); |
616 |
$form->setType('temp1','text'); |
$form->setType('temp1','text'); |
620 |
$form->setType('temp5','text'); |
$form->setType('temp5','text'); |
621 |
$form->setType('servitude','textarea'); |
$form->setType('servitude','textarea'); |
622 |
$form->setType('geom','geom'); |
$form->setType('geom','geom'); |
|
$form->setType('travaux_complement','text'); |
|
|
$form->setType('demandeur_adresse_complement','text'); |
|
|
$form->setType('delegataire_adresse_complement','text'); |
|
623 |
$form->setType('geom1','geom'); |
$form->setType('geom1','geom'); |
624 |
}// fin modifier |
}// fin modifier |
625 |
if ($maj==2){ //supprimer |
if ($maj==2){ //supprimer |
626 |
$form->setType('dossier','hiddenstatic'); |
$form->setType('dossier','hiddenstatic'); |
627 |
$form->setType('nature','hiddenstatic'); |
$form->setType('nature','selectstatic'); |
628 |
$form->setType('annee','hiddenstatic'); |
$form->setType('annee','hiddenstatic'); |
629 |
$form->setType('etat','hiddenstatic'); |
$form->setType('etat','selectstatic'); |
630 |
$form->setType('types','hiddenstatic'); |
$form->setType('types','hiddenstatic'); |
631 |
$form->setType('objet_dossier','hiddenstatic'); |
$form->setType('objet_dossier','hiddenstatic'); |
632 |
$form->setType('instructeur','hiddenstatic'); |
$form->setType('instructeur','selectstatic'); |
633 |
$form->setType('date_demande','hiddenstatic'); |
$form->setType('date_demande','hiddenstatic'); |
634 |
$form->setType('date_depot','hiddenstatic'); |
$form->setType('date_depot','hiddenstatic'); |
635 |
$form->setType('date_complet','hiddenstatic'); |
$form->setType('date_complet','hiddenstatic'); |
639 |
$form->setType('date_limite','hiddenstatic'); |
$form->setType('date_limite','hiddenstatic'); |
640 |
$form->setType('accord_tacite','hiddenstatic'); |
$form->setType('accord_tacite','hiddenstatic'); |
641 |
$form->setType('date_decision','hiddenstatic'); |
$form->setType('date_decision','hiddenstatic'); |
642 |
$form->setType('avis','hiddenstatic'); |
$form->setType('avis','selectstatic'); |
643 |
$form->setType('date_validite','hiddenstatic'); |
$form->setType('date_validite','hiddenstatic'); |
644 |
$form->setType('date_chantier','hiddenstatic'); |
$form->setType('date_chantier','hiddenstatic'); |
645 |
$form->setType('date_achevement','hiddenstatic'); |
$form->setType('date_achevement','hiddenstatic'); |
646 |
$form->setType('date_conformite','hiddenstatic'); |
$form->setType('date_conformite','hiddenstatic'); |
647 |
$form->setType('demandeur_civilite','hiddenstatic'); |
$form->setType('demandeur_civilite','selectstatic'); |
648 |
$form->setType('demandeur_nom','hiddenstatic'); |
$form->setType('demandeur_nom','hiddenstatic'); |
649 |
$form->setType('demandeur_societe','hiddenstatic'); |
$form->setType('demandeur_societe','hiddenstatic'); |
650 |
$form->setType('demandeur_adresse','hiddenstatic'); |
$form->setType('demandeur_adresse','hiddenstatic'); |
651 |
|
$form->setType('demandeur_adresse_complement','hiddenstatic'); |
652 |
$form->setType('demandeur_cp','hiddenstatic'); |
$form->setType('demandeur_cp','hiddenstatic'); |
653 |
$form->setType('demandeur_ville','hiddenstatic'); |
$form->setType('demandeur_ville','hiddenstatic'); |
654 |
$form->setType('demandeur_pays','hiddenstatic'); |
$form->setType('demandeur_pays','hiddenstatic'); |
655 |
$form->setType('demandeur_telephone','hiddenstatic'); |
$form->setType('demandeur_telephone','hiddenstatic'); |
656 |
$form->setType('demandeur_email','hiddenstatic'); |
$form->setType('demandeur_email','hiddenstatic'); |
657 |
$form->setType('demandeur_categorie','hiddenstatic'); |
$form->setType('demandeur_categorie','selectstatic'); |
658 |
$form->setType('delegataire','hiddenstatic'); |
$form->setType('delegataire','hiddenstatic'); |
659 |
$form->setType('delegataire_civilite','hiddenstatic'); |
$form->setType('delegataire_civilite','selectstatic'); |
660 |
$form->setType('delegataire_nom','hiddenstatic'); |
$form->setType('delegataire_nom','hiddenstatic'); |
661 |
$form->setType('delegataire_societe','hiddenstatic'); |
$form->setType('delegataire_societe','hiddenstatic'); |
662 |
$form->setType('delegataire_adresse','hiddenstatic'); |
$form->setType('delegataire_adresse','hiddenstatic'); |
663 |
|
$form->setType('delegataire_adresse_complement','hiddenstatic'); |
664 |
$form->setType('delegataire_cp','hiddenstatic'); |
$form->setType('delegataire_cp','hiddenstatic'); |
665 |
$form->setType('delegataire_ville','hiddenstatic'); |
$form->setType('delegataire_ville','hiddenstatic'); |
666 |
$form->setType('delegataire_pays','hiddenstatic'); |
$form->setType('delegataire_pays','hiddenstatic'); |
672 |
$form->setType('terrain_adresse_complement','hiddenstatic'); |
$form->setType('terrain_adresse_complement','hiddenstatic'); |
673 |
$form->setType('terrain_cp','hiddenstatic'); |
$form->setType('terrain_cp','hiddenstatic'); |
674 |
$form->setType('terrain_ville','hiddenstatic'); |
$form->setType('terrain_ville','hiddenstatic'); |
675 |
$form->setType('architecte','hiddenstatic'); |
$form->setType('architecte','selectstatic'); |
676 |
$form->setType('terrain_surface','hiddenstatic'); |
$form->setType('terrain_surface','hiddenstatic'); |
677 |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
678 |
$form->setType('rivoli','hiddenstatic'); |
$form->setType('rivoli','selectstatic'); |
679 |
$form->setType('travaux','hiddenstatic'); |
$form->setType('travaux','selectstatic'); |
680 |
$form->setType('parcelle','hiddenstatic'); |
$form->setType('travaux_complement','hiddenstatic'); |
681 |
$form->setType('pos','hiddenstatic'); |
$form->setType('parcelle','selectstatic'); |
682 |
|
$form->setType('pos','selectstatic'); |
683 |
$form->setType('sig','hiddenstatic'); |
$form->setType('sig','hiddenstatic'); |
684 |
$form->setType('batiment_nombre','hiddenstatic'); |
$form->setType('batiment_nombre','hiddenstatic'); |
685 |
$form->setType('logement_nombre','hiddenstatic'); |
$form->setType('logement_nombre','hiddenstatic'); |
690 |
$form->setType('hauteur','hiddenstatic'); |
$form->setType('hauteur','hiddenstatic'); |
691 |
$form->setType('piece_nombre','hiddenstatic'); |
$form->setType('piece_nombre','hiddenstatic'); |
692 |
$form->setType('amenagement','hiddenstatic'); |
$form->setType('amenagement','hiddenstatic'); |
693 |
$form->setType('parcelle_lot','hiddenstatic'); |
$form->setType('parcelle_lot','selectstatic'); |
694 |
$form->setType('parcelle_lot_lotissement','hiddenstatic'); |
$form->setType('parcelle_lot_lotissement','hiddenstatic'); |
695 |
$form->setType('description','hiddenstatic'); |
$form->setType('description','hiddenstatic'); |
696 |
$form->setType('temp1','hiddenstatic'); |
$form->setType('temp1','hiddenstatic'); |
700 |
$form->setType('temp5','hiddenstatic'); |
$form->setType('temp5','hiddenstatic'); |
701 |
$form->setType('servitude','hiddenstatic'); |
$form->setType('servitude','hiddenstatic'); |
702 |
$form->setType('geom','hiddenstatic'); |
$form->setType('geom','hiddenstatic'); |
|
$form->setType('travaux_complement','hiddenstatic'); |
|
|
$form->setType('demandeur_adresse_complement','hiddenstatic'); |
|
|
$form->setType('delegataire_adresse_complement','hiddenstatic'); |
|
703 |
$form->setType('geom1','hiddenstatic'); |
$form->setType('geom1','hiddenstatic'); |
704 |
}//fin supprimer |
}//fin supprimer |
705 |
|
if ($maj==3){ //consulter |
706 |
|
$form->setType('dossier','static'); |
707 |
|
$form->setType('nature','selectstatic'); |
708 |
|
$form->setType('annee','static'); |
709 |
|
$form->setType('etat','selectstatic'); |
710 |
|
$form->setType('types','static'); |
711 |
|
$form->setType('objet_dossier','static'); |
712 |
|
$form->setType('instructeur','selectstatic'); |
713 |
|
$form->setType('date_demande','datestatic'); |
714 |
|
$form->setType('date_depot','datestatic'); |
715 |
|
$form->setType('date_complet','datestatic'); |
716 |
|
$form->setType('date_rejet','datestatic'); |
717 |
|
$form->setType('date_notification_delai','datestatic'); |
718 |
|
$form->setType('delai','static'); |
719 |
|
$form->setType('date_limite','datestatic'); |
720 |
|
$form->setType('accord_tacite','static'); |
721 |
|
$form->setType('date_decision','datestatic'); |
722 |
|
$form->setType('avis','selectstatic'); |
723 |
|
$form->setType('date_validite','datestatic'); |
724 |
|
$form->setType('date_chantier','datestatic'); |
725 |
|
$form->setType('date_achevement','datestatic'); |
726 |
|
$form->setType('date_conformite','datestatic'); |
727 |
|
$form->setType('demandeur_civilite','selectstatic'); |
728 |
|
$form->setType('demandeur_nom','static'); |
729 |
|
$form->setType('demandeur_societe','static'); |
730 |
|
$form->setType('demandeur_adresse','static'); |
731 |
|
$form->setType('demandeur_adresse_complement','static'); |
732 |
|
$form->setType('demandeur_cp','static'); |
733 |
|
$form->setType('demandeur_ville','static'); |
734 |
|
$form->setType('demandeur_pays','static'); |
735 |
|
$form->setType('demandeur_telephone','static'); |
736 |
|
$form->setType('demandeur_email','static'); |
737 |
|
$form->setType('demandeur_categorie','selectstatic'); |
738 |
|
$form->setType('delegataire','static'); |
739 |
|
$form->setType('delegataire_civilite','selectstatic'); |
740 |
|
$form->setType('delegataire_nom','static'); |
741 |
|
$form->setType('delegataire_societe','static'); |
742 |
|
$form->setType('delegataire_adresse','static'); |
743 |
|
$form->setType('delegataire_adresse_complement','static'); |
744 |
|
$form->setType('delegataire_cp','static'); |
745 |
|
$form->setType('delegataire_ville','static'); |
746 |
|
$form->setType('delegataire_pays','static'); |
747 |
|
$form->setType('delegataire_telephone','static'); |
748 |
|
$form->setType('delegataire_email','static'); |
749 |
|
$form->setType('terrain_numero','static'); |
750 |
|
$form->setType('terrain_numero_complement','static'); |
751 |
|
$form->setType('terrain_adresse','static'); |
752 |
|
$form->setType('terrain_adresse_complement','static'); |
753 |
|
$form->setType('terrain_cp','static'); |
754 |
|
$form->setType('terrain_ville','static'); |
755 |
|
$form->setType('architecte','selectstatic'); |
756 |
|
$form->setType('terrain_surface','static'); |
757 |
|
$form->setType('terrain_surface_calcul','static'); |
758 |
|
$form->setType('rivoli','selectstatic'); |
759 |
|
$form->setType('travaux','selectstatic'); |
760 |
|
$form->setType('travaux_complement','static'); |
761 |
|
$form->setType('parcelle','selectstatic'); |
762 |
|
$form->setType('pos','selectstatic'); |
763 |
|
$form->setType('sig','static'); |
764 |
|
$form->setType('batiment_nombre','static'); |
765 |
|
$form->setType('logement_nombre','static'); |
766 |
|
$form->setType('shon','static'); |
767 |
|
$form->setType('shon_calcul','static'); |
768 |
|
$form->setType('shob','static'); |
769 |
|
$form->setType('lot','static'); |
770 |
|
$form->setType('hauteur','static'); |
771 |
|
$form->setType('piece_nombre','static'); |
772 |
|
$form->setType('amenagement','static'); |
773 |
|
$form->setType('parcelle_lot','selectstatic'); |
774 |
|
$form->setType('parcelle_lot_lotissement','static'); |
775 |
|
$form->setType('description','textareastatic'); |
776 |
|
$form->setType('temp1','static'); |
777 |
|
$form->setType('temp2','static'); |
778 |
|
$form->setType('temp3','static'); |
779 |
|
$form->setType('temp4','static'); |
780 |
|
$form->setType('temp5','static'); |
781 |
|
$form->setType('servitude','textareastatic'); |
782 |
|
$form->setType('geom','geom'); |
783 |
|
$form->setType('geom1','geom'); |
784 |
|
}//fin consulter |
785 |
} |
} |
786 |
|
|
787 |
function setOnchange(&$form,$maj) { |
function setOnchange(&$form,$maj) { |
801 |
$form->setOnchange('date_conformite','fdate(this)'); |
$form->setOnchange('date_conformite','fdate(this)'); |
802 |
$form->setOnchange('demandeur_categorie','VerifNum(this)'); |
$form->setOnchange('demandeur_categorie','VerifNum(this)'); |
803 |
$form->setOnchange('architecte','VerifNum(this)'); |
$form->setOnchange('architecte','VerifNum(this)'); |
804 |
|
$form->setOnchange('terrain_surface','VerifNum(this)'); |
805 |
|
$form->setOnchange('terrain_surface_calcul','VerifNum(this)'); |
806 |
$form->setOnchange('travaux','VerifNum(this)'); |
$form->setOnchange('travaux','VerifNum(this)'); |
807 |
$form->setOnchange('batiment_nombre','VerifNum(this)'); |
$form->setOnchange('batiment_nombre','VerifNum(this)'); |
808 |
$form->setOnchange('logement_nombre','VerifNum(this)'); |
$form->setOnchange('logement_nombre','VerifNum(this)'); |
809 |
|
$form->setOnchange('shon','VerifNum(this)'); |
810 |
|
$form->setOnchange('shon_calcul','VerifNum(this)'); |
811 |
|
$form->setOnchange('shob','VerifNum(this)'); |
812 |
$form->setOnchange('lot','VerifNum(this)'); |
$form->setOnchange('lot','VerifNum(this)'); |
813 |
|
$form->setOnchange('hauteur','VerifNum(this)'); |
814 |
$form->setOnchange('piece_nombre','VerifNum(this)'); |
$form->setOnchange('piece_nombre','VerifNum(this)'); |
815 |
$form->setOnchange('parcelle_lot','VerifNum(this)'); |
$form->setOnchange('parcelle_lot','VerifNum(this)'); |
816 |
} |
} |
843 |
$form->setTaille("demandeur_nom", 30); |
$form->setTaille("demandeur_nom", 30); |
844 |
$form->setTaille("demandeur_societe", 30); |
$form->setTaille("demandeur_societe", 30); |
845 |
$form->setTaille("demandeur_adresse", 30); |
$form->setTaille("demandeur_adresse", 30); |
846 |
|
$form->setTaille("demandeur_adresse_complement", 30); |
847 |
$form->setTaille("demandeur_cp", 10); |
$form->setTaille("demandeur_cp", 10); |
848 |
$form->setTaille("demandeur_ville", 30); |
$form->setTaille("demandeur_ville", 30); |
849 |
$form->setTaille("demandeur_pays", 30); |
$form->setTaille("demandeur_pays", 30); |
855 |
$form->setTaille("delegataire_nom", 30); |
$form->setTaille("delegataire_nom", 30); |
856 |
$form->setTaille("delegataire_societe", 30); |
$form->setTaille("delegataire_societe", 30); |
857 |
$form->setTaille("delegataire_adresse", 30); |
$form->setTaille("delegataire_adresse", 30); |
858 |
|
$form->setTaille("delegataire_adresse_complement", 30); |
859 |
$form->setTaille("delegataire_cp", 10); |
$form->setTaille("delegataire_cp", 10); |
860 |
$form->setTaille("delegataire_ville", 30); |
$form->setTaille("delegataire_ville", 30); |
861 |
$form->setTaille("delegataire_pays", 30); |
$form->setTaille("delegataire_pays", 30); |
868 |
$form->setTaille("terrain_cp", 10); |
$form->setTaille("terrain_cp", 10); |
869 |
$form->setTaille("terrain_ville", 30); |
$form->setTaille("terrain_ville", 30); |
870 |
$form->setTaille("architecte", 11); |
$form->setTaille("architecte", 11); |
871 |
$form->setTaille("terrain_surface", 8); |
$form->setTaille("terrain_surface", 20); |
872 |
$form->setTaille("terrain_surface_calcul", 8); |
$form->setTaille("terrain_surface_calcul", 20); |
873 |
$form->setTaille("rivoli", 10); |
$form->setTaille("rivoli", 10); |
874 |
$form->setTaille("travaux", 11); |
$form->setTaille("travaux", 11); |
875 |
|
$form->setTaille("travaux_complement", 30); |
876 |
$form->setTaille("parcelle", 20); |
$form->setTaille("parcelle", 20); |
877 |
$form->setTaille("pos", 10); |
$form->setTaille("pos", 10); |
878 |
$form->setTaille("sig", 10); |
$form->setTaille("sig", 10); |
879 |
$form->setTaille("batiment_nombre", 11); |
$form->setTaille("batiment_nombre", 11); |
880 |
$form->setTaille("logement_nombre", 11); |
$form->setTaille("logement_nombre", 11); |
881 |
$form->setTaille("shon", 8); |
$form->setTaille("shon", 20); |
882 |
$form->setTaille("shon_calcul", 8); |
$form->setTaille("shon_calcul", 20); |
883 |
$form->setTaille("shob", 8); |
$form->setTaille("shob", 20); |
884 |
$form->setTaille("lot", 11); |
$form->setTaille("lot", 11); |
885 |
$form->setTaille("hauteur", 8); |
$form->setTaille("hauteur", 20); |
886 |
$form->setTaille("piece_nombre", 11); |
$form->setTaille("piece_nombre", 11); |
887 |
$form->setTaille("amenagement", 12); |
$form->setTaille("amenagement", 12); |
888 |
$form->setTaille("parcelle_lot", 11); |
$form->setTaille("parcelle_lot", 11); |
895 |
$form->setTaille("temp5", 30); |
$form->setTaille("temp5", 30); |
896 |
$form->setTaille("servitude", 80); |
$form->setTaille("servitude", 80); |
897 |
$form->setTaille("geom", 10); |
$form->setTaille("geom", 10); |
|
$form->setTaille("travaux_complement", 30); |
|
|
$form->setTaille("demandeur_adresse_complement", 30); |
|
|
$form->setTaille("delegataire_adresse_complement", 30); |
|
898 |
$form->setTaille("geom1", 10); |
$form->setTaille("geom1", 10); |
899 |
} |
} |
900 |
|
|
927 |
$form->setMax("demandeur_nom", 80); |
$form->setMax("demandeur_nom", 80); |
928 |
$form->setMax("demandeur_societe", 80); |
$form->setMax("demandeur_societe", 80); |
929 |
$form->setMax("demandeur_adresse", 80); |
$form->setMax("demandeur_adresse", 80); |
930 |
|
$form->setMax("demandeur_adresse_complement", 39); |
931 |
$form->setMax("demandeur_cp", 5); |
$form->setMax("demandeur_cp", 5); |
932 |
$form->setMax("demandeur_ville", 30); |
$form->setMax("demandeur_ville", 30); |
933 |
$form->setMax("demandeur_pays", 40); |
$form->setMax("demandeur_pays", 40); |
939 |
$form->setMax("delegataire_nom", 80); |
$form->setMax("delegataire_nom", 80); |
940 |
$form->setMax("delegataire_societe", 80); |
$form->setMax("delegataire_societe", 80); |
941 |
$form->setMax("delegataire_adresse", 80); |
$form->setMax("delegataire_adresse", 80); |
942 |
|
$form->setMax("delegataire_adresse_complement", 39); |
943 |
$form->setMax("delegataire_cp", 5); |
$form->setMax("delegataire_cp", 5); |
944 |
$form->setMax("delegataire_ville", 30); |
$form->setMax("delegataire_ville", 30); |
945 |
$form->setMax("delegataire_pays", 40); |
$form->setMax("delegataire_pays", 40); |
952 |
$form->setMax("terrain_cp", 5); |
$form->setMax("terrain_cp", 5); |
953 |
$form->setMax("terrain_ville", 30); |
$form->setMax("terrain_ville", 30); |
954 |
$form->setMax("architecte", 11); |
$form->setMax("architecte", 11); |
955 |
$form->setMax("terrain_surface", 8); |
$form->setMax("terrain_surface", 20); |
956 |
$form->setMax("terrain_surface_calcul", 8); |
$form->setMax("terrain_surface_calcul", 20); |
957 |
$form->setMax("rivoli", 4); |
$form->setMax("rivoli", 4); |
958 |
$form->setMax("travaux", 11); |
$form->setMax("travaux", 11); |
959 |
|
$form->setMax("travaux_complement", 100); |
960 |
$form->setMax("parcelle", 20); |
$form->setMax("parcelle", 20); |
961 |
$form->setMax("pos", 10); |
$form->setMax("pos", 10); |
962 |
$form->setMax("sig", 3); |
$form->setMax("sig", 3); |
963 |
$form->setMax("batiment_nombre", 11); |
$form->setMax("batiment_nombre", 11); |
964 |
$form->setMax("logement_nombre", 11); |
$form->setMax("logement_nombre", 11); |
965 |
$form->setMax("shon", 8); |
$form->setMax("shon", 20); |
966 |
$form->setMax("shon_calcul", 8); |
$form->setMax("shon_calcul", 20); |
967 |
$form->setMax("shob", 8); |
$form->setMax("shob", 20); |
968 |
$form->setMax("lot", 11); |
$form->setMax("lot", 11); |
969 |
$form->setMax("hauteur", 8); |
$form->setMax("hauteur", 20); |
970 |
$form->setMax("piece_nombre", 11); |
$form->setMax("piece_nombre", 11); |
971 |
$form->setMax("amenagement", 12); |
$form->setMax("amenagement", 12); |
972 |
$form->setMax("parcelle_lot", 11); |
$form->setMax("parcelle_lot", 11); |
979 |
$form->setMax("temp5", 100); |
$form->setMax("temp5", 100); |
980 |
$form->setMax("servitude", 6); |
$form->setMax("servitude", 6); |
981 |
$form->setMax("geom", -5); |
$form->setMax("geom", -5); |
|
$form->setMax("travaux_complement", 100); |
|
|
$form->setMax("demandeur_adresse_complement", 39); |
|
|
$form->setMax("delegataire_adresse_complement", 39); |
|
982 |
$form->setMax("geom1", -5); |
$form->setMax("geom1", -5); |
983 |
} |
} |
984 |
|
|
1010 |
$form->setLib('demandeur_nom',_('demandeur_nom')); |
$form->setLib('demandeur_nom',_('demandeur_nom')); |
1011 |
$form->setLib('demandeur_societe',_('demandeur_societe')); |
$form->setLib('demandeur_societe',_('demandeur_societe')); |
1012 |
$form->setLib('demandeur_adresse',_('demandeur_adresse')); |
$form->setLib('demandeur_adresse',_('demandeur_adresse')); |
1013 |
|
$form->setLib('demandeur_adresse_complement',_('demandeur_adresse_complement')); |
1014 |
$form->setLib('demandeur_cp',_('demandeur_cp')); |
$form->setLib('demandeur_cp',_('demandeur_cp')); |
1015 |
$form->setLib('demandeur_ville',_('demandeur_ville')); |
$form->setLib('demandeur_ville',_('demandeur_ville')); |
1016 |
$form->setLib('demandeur_pays',_('demandeur_pays')); |
$form->setLib('demandeur_pays',_('demandeur_pays')); |
1022 |
$form->setLib('delegataire_nom',_('delegataire_nom')); |
$form->setLib('delegataire_nom',_('delegataire_nom')); |
1023 |
$form->setLib('delegataire_societe',_('delegataire_societe')); |
$form->setLib('delegataire_societe',_('delegataire_societe')); |
1024 |
$form->setLib('delegataire_adresse',_('delegataire_adresse')); |
$form->setLib('delegataire_adresse',_('delegataire_adresse')); |
1025 |
|
$form->setLib('delegataire_adresse_complement',_('delegataire_adresse_complement')); |
1026 |
$form->setLib('delegataire_cp',_('delegataire_cp')); |
$form->setLib('delegataire_cp',_('delegataire_cp')); |
1027 |
$form->setLib('delegataire_ville',_('delegataire_ville')); |
$form->setLib('delegataire_ville',_('delegataire_ville')); |
1028 |
$form->setLib('delegataire_pays',_('delegataire_pays')); |
$form->setLib('delegataire_pays',_('delegataire_pays')); |
1039 |
$form->setLib('terrain_surface_calcul',_('terrain_surface_calcul')); |
$form->setLib('terrain_surface_calcul',_('terrain_surface_calcul')); |
1040 |
$form->setLib('rivoli',_('rivoli')); |
$form->setLib('rivoli',_('rivoli')); |
1041 |
$form->setLib('travaux',_('travaux')); |
$form->setLib('travaux',_('travaux')); |
1042 |
|
$form->setLib('travaux_complement',_('travaux_complement')); |
1043 |
$form->setLib('parcelle',_('parcelle')); |
$form->setLib('parcelle',_('parcelle')); |
1044 |
$form->setLib('pos',_('pos')); |
$form->setLib('pos',_('pos')); |
1045 |
$form->setLib('sig',_('sig')); |
$form->setLib('sig',_('sig')); |
1062 |
$form->setLib('temp5',_('temp5')); |
$form->setLib('temp5',_('temp5')); |
1063 |
$form->setLib('servitude',_('servitude')); |
$form->setLib('servitude',_('servitude')); |
1064 |
$form->setLib('geom',_('geom')); |
$form->setLib('geom',_('geom')); |
|
$form->setLib('travaux_complement',_('travaux_complement')); |
|
|
$form->setLib('demandeur_adresse_complement',_('demandeur_adresse_complement')); |
|
|
$form->setLib('delegataire_adresse_complement',_('delegataire_adresse_complement')); |
|
1065 |
$form->setLib('geom1',_('geom1')); |
$form->setLib('geom1',_('geom1')); |
1066 |
} |
} |
1067 |
|
|
1070 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
1071 |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
1072 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
1073 |
if($maj<2){ |
|
1074 |
// nature |
// instructeur |
1075 |
$contenu=array(); |
$this->init_select($form, $db, $maj, $debug, "instructeur", |
1076 |
$res = $db->query($sql_nature); |
$sql_instructeur, $sql_instructeur_by_id, false); |
1077 |
// Logger |
|
1078 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_nature."\");", VERBOSE_MODE); |
// travaux |
1079 |
if (database::isError($res)) |
$this->init_select($form, $db, $maj, $debug, "travaux", |
1080 |
die($res->getMessage().$sql_nature); |
$sql_travaux, $sql_travaux_by_id, false); |
1081 |
else{ |
|
1082 |
if ($debug == 1) |
// demandeur_categorie |
1083 |
echo " la requete ".$sql_nature." est executee<br>"; |
$this->init_select($form, $db, $maj, $debug, "demandeur_categorie", |
1084 |
$contenu[0][0]=''; |
$sql_demandeur_categorie, $sql_demandeur_categorie_by_id, false); |
1085 |
$contenu[1][0]=_('choisir')." "._('nature'); |
|
1086 |
$k=1; |
// demandeur_civilite |
1087 |
while ($row=& $res->fetchRow()){ |
$this->init_select($form, $db, $maj, $debug, "demandeur_civilite", |
1088 |
$contenu[0][$k]=$row[0]; |
$sql_demandeur_civilite, $sql_demandeur_civilite_by_id, false); |
1089 |
$contenu[1][$k]=$row[1]; |
|
1090 |
$k++; |
// delegataire_civilite |
1091 |
} |
$this->init_select($form, $db, $maj, $debug, "delegataire_civilite", |
1092 |
$form->setSelect('nature',$contenu); |
$sql_delegataire_civilite, $sql_delegataire_civilite_by_id, false); |
1093 |
}// fin error db |
|
1094 |
// etat |
// architecte |
1095 |
$contenu=array(); |
$this->init_select($form, $db, $maj, $debug, "architecte", |
1096 |
$res = $db->query($sql_etat); |
$sql_architecte, $sql_architecte_by_id, false); |
1097 |
// Logger |
|
1098 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_etat."\");", VERBOSE_MODE); |
// etat |
1099 |
if (database::isError($res)) |
$this->init_select($form, $db, $maj, $debug, "etat", |
1100 |
die($res->getMessage().$sql_etat); |
$sql_etat, $sql_etat_by_id, false); |
1101 |
else{ |
|
1102 |
if ($debug == 1) |
// nature |
1103 |
echo " la requete ".$sql_etat." est executee<br>"; |
$this->init_select($form, $db, $maj, $debug, "nature", |
1104 |
$contenu[0][0]=''; |
$sql_nature, $sql_nature_by_id, false); |
1105 |
$contenu[1][0]=_('choisir')." "._('etat'); |
|
1106 |
$k=1; |
// avis |
1107 |
while ($row=& $res->fetchRow()){ |
$this->init_select($form, $db, $maj, $debug, "avis", |
1108 |
$contenu[0][$k]=$row[0]; |
$sql_avis, $sql_avis_by_id, false); |
1109 |
$contenu[1][$k]=$row[1]; |
|
1110 |
$k++; |
// rivoli |
1111 |
} |
$this->init_select($form, $db, $maj, $debug, "rivoli", |
1112 |
$form->setSelect('etat',$contenu); |
$sql_rivoli, $sql_rivoli_by_id, false); |
1113 |
}// fin error db |
|
1114 |
// avis |
// pos |
1115 |
$contenu=array(); |
$this->init_select($form, $db, $maj, $debug, "pos", |
1116 |
$res = $db->query($sql_avis); |
$sql_pos, $sql_pos_by_id, false); |
1117 |
// Logger |
|
1118 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_avis."\");", VERBOSE_MODE); |
// parcelle_lot |
1119 |
if (database::isError($res)) |
$this->init_select($form, $db, $maj, $debug, "parcelle_lot", |
1120 |
die($res->getMessage().$sql_avis); |
$sql_parcelle_lot, $sql_parcelle_lot_by_id, false); |
1121 |
else{ |
|
1122 |
if ($debug == 1) |
// parcelle |
1123 |
echo " la requete ".$sql_avis." est executee<br>"; |
$this->init_select($form, $db, $maj, $debug, "parcelle", |
1124 |
$contenu[0][0]=''; |
$sql_parcelle, $sql_parcelle_by_id, false); |
|
$contenu[1][0]=_('choisir')." "._('avis'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('avis',$contenu); |
|
|
}// fin error db |
|
|
// architecte |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_architecte); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_architecte."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_architecte); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_architecte." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('architecte'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('architecte',$contenu); |
|
|
}// fin error db |
|
|
// rivoli |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_rivoli); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_rivoli."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_rivoli); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_rivoli." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('rivoli'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('rivoli',$contenu); |
|
|
}// fin error db |
|
|
// travaux |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_travaux); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_travaux."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_travaux); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_travaux." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('travaux'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('travaux',$contenu); |
|
|
}// fin error db |
|
|
// parcelle |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_parcelle); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_parcelle); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_parcelle." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('parcelle'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('parcelle',$contenu); |
|
|
}// fin error db |
|
|
// pos |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_pos); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_pos."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_pos); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_pos." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('pos'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('pos',$contenu); |
|
|
}// fin error db |
|
|
// parcelle_lot |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_parcelle_lot); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle_lot."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_parcelle_lot); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_parcelle_lot." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('parcelle_lot'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('parcelle_lot',$contenu); |
|
|
}// fin error db |
|
|
}// fin maj |
|
1125 |
// geom |
// geom |
1126 |
if($maj==1){ //modification |
if($maj==1){ //modification |
1127 |
$contenu=array(); |
$contenu=array(); |
1142 |
|
|
1143 |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
1144 |
$this->retourformulaire = $retourformulaire; |
$this->retourformulaire = $retourformulaire; |
1145 |
if($validation==0) { |
if($validation == 0) { |
1146 |
if($retourformulaire =='nature') |
if($retourformulaire =='om_utilisateur') |
1147 |
$form->setVal('nature', $idxformulaire); |
$form->setVal('instructeur', $idxformulaire); |
1148 |
|
if($retourformulaire =='travaux') |
1149 |
|
$form->setVal('travaux', $idxformulaire); |
1150 |
|
if($retourformulaire =='categorie_demandeur') |
1151 |
|
$form->setVal('demandeur_categorie', $idxformulaire); |
1152 |
|
if($retourformulaire =='architecte') |
1153 |
|
$form->setVal('architecte', $idxformulaire); |
1154 |
if($retourformulaire =='etat') |
if($retourformulaire =='etat') |
1155 |
$form->setVal('etat', $idxformulaire); |
$form->setVal('etat', $idxformulaire); |
1156 |
|
if($retourformulaire =='nature') |
1157 |
|
$form->setVal('nature', $idxformulaire); |
1158 |
if($retourformulaire =='avis') |
if($retourformulaire =='avis') |
1159 |
$form->setVal('avis', $idxformulaire); |
$form->setVal('avis', $idxformulaire); |
|
if($retourformulaire =='architecte') |
|
|
$form->setVal('architecte', $idxformulaire); |
|
1160 |
if($retourformulaire =='rivoli') |
if($retourformulaire =='rivoli') |
1161 |
$form->setVal('rivoli', $idxformulaire); |
$form->setVal('rivoli', $idxformulaire); |
|
if($retourformulaire =='travaux') |
|
|
$form->setVal('travaux', $idxformulaire); |
|
|
if($retourformulaire =='parcelle') |
|
|
$form->setVal('parcelle', $idxformulaire); |
|
1162 |
if($retourformulaire =='pos') |
if($retourformulaire =='pos') |
1163 |
$form->setVal('pos', $idxformulaire); |
$form->setVal('pos', $idxformulaire); |
1164 |
if($retourformulaire =='parcelle_lot') |
if($retourformulaire =='parcelle_lot') |
1165 |
$form->setVal('parcelle_lot', $idxformulaire); |
$form->setVal('parcelle_lot', $idxformulaire); |
1166 |
|
if($retourformulaire =='parcelle') |
1167 |
|
$form->setVal('parcelle', $idxformulaire); |
1168 |
|
}// fin validation |
1169 |
|
if ($validation == 0 and $maj == 0) { |
1170 |
|
if($retourformulaire =='civilite') |
1171 |
|
$form->setVal('demandeur_civilite', $idxformulaire); |
1172 |
|
if($retourformulaire =='civilite') |
1173 |
|
$form->setVal('delegataire_civilite', $idxformulaire); |
1174 |
}// fin validation |
}// fin validation |
1175 |
}// fin setValsousformulaire |
}// fin setValsousformulaire |
1176 |
|
|
1185 |
parent::cleSecondaire($id, $db, $val, $DEBUG); |
parent::cleSecondaire($id, $db, $val, $DEBUG); |
1186 |
// Verification de la cle secondaire : blocnote |
// Verification de la cle secondaire : blocnote |
1187 |
$this->rechercheTable($db, "blocnote", "dossier", $id); |
$this->rechercheTable($db, "blocnote", "dossier", $id); |
|
// Verification de la cle secondaire : terrain |
|
|
$this->rechercheTable($db, "terrain", "dossier", $id); |
|
1188 |
// Verification de la cle secondaire : instruction |
// Verification de la cle secondaire : instruction |
1189 |
$this->rechercheTable($db, "instruction", "dossier", $id); |
$this->rechercheTable($db, "instruction", "dossier", $id); |
1190 |
|
// Verification de la cle secondaire : terrain |
1191 |
|
$this->rechercheTable($db, "terrain", "dossier", $id); |
1192 |
// Verification de la cle secondaire : consultation |
// Verification de la cle secondaire : consultation |
1193 |
$this->rechercheTable($db, "consultation", "dossier", $id); |
$this->rechercheTable($db, "consultation", "dossier", $id); |
1194 |
// Verification de la cle secondaire : destination_shon |
// Verification de la cle secondaire : destination_shon |