1 |
<?php |
2 |
//$Id$ |
3 |
//gen openMairie le 22/08/2013 17:20 |
4 |
|
5 |
require_once ("../obj/om_dbform.class.php"); |
6 |
|
7 |
class sig_elyx_gen extends om_dbform { |
8 |
var $table="sig_elyx"; |
9 |
var $clePrimaire="sig_elyx"; |
10 |
var $typeCle="N"; |
11 |
var $required_field=array( |
12 |
"dossier", |
13 |
"sig_elyx" |
14 |
); |
15 |
var $retourformulaire; |
16 |
|
17 |
function setvalF($val) { |
18 |
//affectation valeur formulaire |
19 |
if (!is_numeric($val['sig_elyx'])) { |
20 |
$this->valF['sig_elyx'] = ""; // -> requis |
21 |
} else { |
22 |
$this->valF['sig_elyx'] = $val['sig_elyx']; |
23 |
} |
24 |
$this->valF['dossier'] = $val['dossier']; |
25 |
if ($val['date_verif_parcelle'] != "") { |
26 |
$this->valF['date_verif_parcelle'] = $this->dateDB($val['date_verif_parcelle']); |
27 |
} else { |
28 |
$this->valF['date_verif_parcelle'] = NULL; |
29 |
} |
30 |
if ($val['etat_verif_parcelle'] == 1 || $val['etat_verif_parcelle'] == "t" || $val['etat_verif_parcelle'] == "Oui") { |
31 |
$this->valF['etat_verif_parcelle'] = true; |
32 |
} else { |
33 |
$this->valF['etat_verif_parcelle'] = false; |
34 |
} |
35 |
$this->valF['message_verif_parcelle'] = $val['message_verif_parcelle']; |
36 |
if ($val['date_calcul_emprise'] != "") { |
37 |
$this->valF['date_calcul_emprise'] = $this->dateDB($val['date_calcul_emprise']); |
38 |
} else { |
39 |
$this->valF['date_calcul_emprise'] = NULL; |
40 |
} |
41 |
if ($val['etat_calcul_emprise'] == 1 || $val['etat_calcul_emprise'] == "t" || $val['etat_calcul_emprise'] == "Oui") { |
42 |
$this->valF['etat_calcul_emprise'] = true; |
43 |
} else { |
44 |
$this->valF['etat_calcul_emprise'] = false; |
45 |
} |
46 |
$this->valF['message_calcul_emprise'] = $val['message_calcul_emprise']; |
47 |
if ($val['date_dessin_emprise'] != "") { |
48 |
$this->valF['date_dessin_emprise'] = $this->dateDB($val['date_dessin_emprise']); |
49 |
} else { |
50 |
$this->valF['date_dessin_emprise'] = NULL; |
51 |
} |
52 |
if ($val['etat_dessin_emprise'] == 1 || $val['etat_dessin_emprise'] == "t" || $val['etat_dessin_emprise'] == "Oui") { |
53 |
$this->valF['etat_dessin_emprise'] = true; |
54 |
} else { |
55 |
$this->valF['etat_dessin_emprise'] = false; |
56 |
} |
57 |
$this->valF['message_dessin_emprise'] = $val['message_dessin_emprise']; |
58 |
if ($val['date_calcul_centroide'] != "") { |
59 |
$this->valF['date_calcul_centroide'] = $this->dateDB($val['date_calcul_centroide']); |
60 |
} else { |
61 |
$this->valF['date_calcul_centroide'] = NULL; |
62 |
} |
63 |
if ($val['etat_calcul_centroide'] == 1 || $val['etat_calcul_centroide'] == "t" || $val['etat_calcul_centroide'] == "Oui") { |
64 |
$this->valF['etat_calcul_centroide'] = true; |
65 |
} else { |
66 |
$this->valF['etat_calcul_centroide'] = false; |
67 |
} |
68 |
$this->valF['message_calcul_centroide'] = $val['message_calcul_centroide']; |
69 |
if ($val['date_recup_contrainte'] != "") { |
70 |
$this->valF['date_recup_contrainte'] = $this->dateDB($val['date_recup_contrainte']); |
71 |
} else { |
72 |
$this->valF['date_recup_contrainte'] = NULL; |
73 |
} |
74 |
if ($val['etat_recup_contrainte'] == 1 || $val['etat_recup_contrainte'] == "t" || $val['etat_recup_contrainte'] == "Oui") { |
75 |
$this->valF['etat_recup_contrainte'] = true; |
76 |
} else { |
77 |
$this->valF['etat_recup_contrainte'] = false; |
78 |
} |
79 |
$this->valF['message_recup_contrainte'] = $val['message_recup_contrainte']; |
80 |
if ($val['terrain_references_cadastrales_archive'] == "") { |
81 |
$this->valF['terrain_references_cadastrales_archive'] = NULL; |
82 |
} else { |
83 |
$this->valF['terrain_references_cadastrales_archive'] = $val['terrain_references_cadastrales_archive']; |
84 |
} |
85 |
} |
86 |
|
87 |
//================================================= |
88 |
//cle primaire automatique [automatic primary key] |
89 |
//================================================== |
90 |
|
91 |
function setId(&$db) { |
92 |
//numero automatique |
93 |
$this->valF[$this->clePrimaire] = $db->nextId(DB_PREFIXE.$this->table); |
94 |
} |
95 |
|
96 |
function setValFAjout($val) { |
97 |
//numero automatique -> pas de controle ajout cle primaire |
98 |
} |
99 |
|
100 |
function verifierAjout() { |
101 |
//numero automatique -> pas de verfication de cle primaire |
102 |
} |
103 |
|
104 |
//========================== |
105 |
// Formulaire [form] |
106 |
//========================== |
107 |
|
108 |
function setType(&$form,$maj) { |
109 |
//type |
110 |
if ($maj==0){ //ajout |
111 |
$form->setType('sig_elyx','hidden');// cle automatique |
112 |
|
113 |
if($this->retourformulaire=='dossier' |
114 |
and $form->val['dossier'] == $this->getParameter('idxformulaire')) { |
115 |
$form->setType('dossier','selecthiddenstatic'); |
116 |
} else { |
117 |
$form->setType('dossier','select'); |
118 |
} |
119 |
if($this->retourformulaire=='') |
120 |
$form->setType('date_verif_parcelle','date'); |
121 |
else |
122 |
$form->setType('date_verif_parcelle','date2'); |
123 |
$form->setType('etat_verif_parcelle','checkbox'); |
124 |
$form->setType('message_verif_parcelle','textarea'); |
125 |
if($this->retourformulaire=='') |
126 |
$form->setType('date_calcul_emprise','date'); |
127 |
else |
128 |
$form->setType('date_calcul_emprise','date2'); |
129 |
$form->setType('etat_calcul_emprise','checkbox'); |
130 |
$form->setType('message_calcul_emprise','textarea'); |
131 |
if($this->retourformulaire=='') |
132 |
$form->setType('date_dessin_emprise','date'); |
133 |
else |
134 |
$form->setType('date_dessin_emprise','date2'); |
135 |
$form->setType('etat_dessin_emprise','checkbox'); |
136 |
$form->setType('message_dessin_emprise','textarea'); |
137 |
if($this->retourformulaire=='') |
138 |
$form->setType('date_calcul_centroide','date'); |
139 |
else |
140 |
$form->setType('date_calcul_centroide','date2'); |
141 |
$form->setType('etat_calcul_centroide','checkbox'); |
142 |
$form->setType('message_calcul_centroide','textarea'); |
143 |
if($this->retourformulaire=='') |
144 |
$form->setType('date_recup_contrainte','date'); |
145 |
else |
146 |
$form->setType('date_recup_contrainte','date2'); |
147 |
$form->setType('etat_recup_contrainte','checkbox'); |
148 |
$form->setType('message_recup_contrainte','textarea'); |
149 |
$form->setType('terrain_references_cadastrales_archive','text'); |
150 |
}// fin ajout |
151 |
if ($maj==1){ //modifier |
152 |
$form->setType('sig_elyx','hiddenstatic'); |
153 |
|
154 |
if($this->retourformulaire=='dossier' |
155 |
and $form->val['dossier'] == $this->getParameter('idxformulaire')) { |
156 |
$form->setType('dossier','selecthiddenstatic'); |
157 |
} else { |
158 |
$form->setType('dossier','select'); |
159 |
} |
160 |
if($this->retourformulaire=='') |
161 |
$form->setType('date_verif_parcelle','date'); |
162 |
else |
163 |
$form->setType('date_verif_parcelle','date2'); |
164 |
$form->setType('etat_verif_parcelle','checkbox'); |
165 |
$form->setType('message_verif_parcelle','textarea'); |
166 |
if($this->retourformulaire=='') |
167 |
$form->setType('date_calcul_emprise','date'); |
168 |
else |
169 |
$form->setType('date_calcul_emprise','date2'); |
170 |
$form->setType('etat_calcul_emprise','checkbox'); |
171 |
$form->setType('message_calcul_emprise','textarea'); |
172 |
if($this->retourformulaire=='') |
173 |
$form->setType('date_dessin_emprise','date'); |
174 |
else |
175 |
$form->setType('date_dessin_emprise','date2'); |
176 |
$form->setType('etat_dessin_emprise','checkbox'); |
177 |
$form->setType('message_dessin_emprise','textarea'); |
178 |
if($this->retourformulaire=='') |
179 |
$form->setType('date_calcul_centroide','date'); |
180 |
else |
181 |
$form->setType('date_calcul_centroide','date2'); |
182 |
$form->setType('etat_calcul_centroide','checkbox'); |
183 |
$form->setType('message_calcul_centroide','textarea'); |
184 |
if($this->retourformulaire=='') |
185 |
$form->setType('date_recup_contrainte','date'); |
186 |
else |
187 |
$form->setType('date_recup_contrainte','date2'); |
188 |
$form->setType('etat_recup_contrainte','checkbox'); |
189 |
$form->setType('message_recup_contrainte','textarea'); |
190 |
$form->setType('terrain_references_cadastrales_archive','text'); |
191 |
}// fin modifier |
192 |
if ($maj==2){ //supprimer |
193 |
$form->setType('sig_elyx','hiddenstatic'); |
194 |
$form->setType('dossier','selectstatic'); |
195 |
$form->setType('date_verif_parcelle','hiddenstatic'); |
196 |
$form->setType('etat_verif_parcelle','hiddenstatic'); |
197 |
$form->setType('message_verif_parcelle','hiddenstatic'); |
198 |
$form->setType('date_calcul_emprise','hiddenstatic'); |
199 |
$form->setType('etat_calcul_emprise','hiddenstatic'); |
200 |
$form->setType('message_calcul_emprise','hiddenstatic'); |
201 |
$form->setType('date_dessin_emprise','hiddenstatic'); |
202 |
$form->setType('etat_dessin_emprise','hiddenstatic'); |
203 |
$form->setType('message_dessin_emprise','hiddenstatic'); |
204 |
$form->setType('date_calcul_centroide','hiddenstatic'); |
205 |
$form->setType('etat_calcul_centroide','hiddenstatic'); |
206 |
$form->setType('message_calcul_centroide','hiddenstatic'); |
207 |
$form->setType('date_recup_contrainte','hiddenstatic'); |
208 |
$form->setType('etat_recup_contrainte','hiddenstatic'); |
209 |
$form->setType('message_recup_contrainte','hiddenstatic'); |
210 |
$form->setType('terrain_references_cadastrales_archive','hiddenstatic'); |
211 |
}//fin supprimer |
212 |
if ($maj==3){ //consulter |
213 |
$form->setType('sig_elyx','static'); |
214 |
$form->setType('dossier','selectstatic'); |
215 |
$form->setType('date_verif_parcelle','datestatic'); |
216 |
$form->setType('etat_verif_parcelle','checkboxstatic'); |
217 |
$form->setType('message_verif_parcelle','textareastatic'); |
218 |
$form->setType('date_calcul_emprise','datestatic'); |
219 |
$form->setType('etat_calcul_emprise','checkboxstatic'); |
220 |
$form->setType('message_calcul_emprise','textareastatic'); |
221 |
$form->setType('date_dessin_emprise','datestatic'); |
222 |
$form->setType('etat_dessin_emprise','checkboxstatic'); |
223 |
$form->setType('message_dessin_emprise','textareastatic'); |
224 |
$form->setType('date_calcul_centroide','datestatic'); |
225 |
$form->setType('etat_calcul_centroide','checkboxstatic'); |
226 |
$form->setType('message_calcul_centroide','textareastatic'); |
227 |
$form->setType('date_recup_contrainte','datestatic'); |
228 |
$form->setType('etat_recup_contrainte','checkboxstatic'); |
229 |
$form->setType('message_recup_contrainte','textareastatic'); |
230 |
$form->setType('terrain_references_cadastrales_archive','static'); |
231 |
}//fin consulter |
232 |
} |
233 |
|
234 |
function setOnchange(&$form,$maj) { |
235 |
//javascript controle client |
236 |
$form->setOnchange('sig_elyx','VerifNum(this)'); |
237 |
$form->setOnchange('date_verif_parcelle','fdate(this)'); |
238 |
$form->setOnchange('date_calcul_emprise','fdate(this)'); |
239 |
$form->setOnchange('date_dessin_emprise','fdate(this)'); |
240 |
$form->setOnchange('date_calcul_centroide','fdate(this)'); |
241 |
$form->setOnchange('date_recup_contrainte','fdate(this)'); |
242 |
} |
243 |
/** |
244 |
* Methode setTaille |
245 |
*/ |
246 |
function setTaille(&$form, $maj) { |
247 |
$form->setTaille("sig_elyx", 11); |
248 |
$form->setTaille("dossier", 30); |
249 |
$form->setTaille("date_verif_parcelle", 12); |
250 |
$form->setTaille("etat_verif_parcelle", 1); |
251 |
$form->setTaille("message_verif_parcelle", 80); |
252 |
$form->setTaille("date_calcul_emprise", 12); |
253 |
$form->setTaille("etat_calcul_emprise", 1); |
254 |
$form->setTaille("message_calcul_emprise", 80); |
255 |
$form->setTaille("date_dessin_emprise", 12); |
256 |
$form->setTaille("etat_dessin_emprise", 1); |
257 |
$form->setTaille("message_dessin_emprise", 80); |
258 |
$form->setTaille("date_calcul_centroide", 12); |
259 |
$form->setTaille("etat_calcul_centroide", 1); |
260 |
$form->setTaille("message_calcul_centroide", 80); |
261 |
$form->setTaille("date_recup_contrainte", 12); |
262 |
$form->setTaille("etat_recup_contrainte", 1); |
263 |
$form->setTaille("message_recup_contrainte", 80); |
264 |
$form->setTaille("terrain_references_cadastrales_archive", 30); |
265 |
} |
266 |
|
267 |
/** |
268 |
* Methode setMax |
269 |
*/ |
270 |
function setMax(&$form, $maj) { |
271 |
$form->setMax("sig_elyx", 11); |
272 |
$form->setMax("dossier", 30); |
273 |
$form->setMax("date_verif_parcelle", 12); |
274 |
$form->setMax("etat_verif_parcelle", 1); |
275 |
$form->setMax("message_verif_parcelle", 6); |
276 |
$form->setMax("date_calcul_emprise", 12); |
277 |
$form->setMax("etat_calcul_emprise", 1); |
278 |
$form->setMax("message_calcul_emprise", 6); |
279 |
$form->setMax("date_dessin_emprise", 12); |
280 |
$form->setMax("etat_dessin_emprise", 1); |
281 |
$form->setMax("message_dessin_emprise", 6); |
282 |
$form->setMax("date_calcul_centroide", 12); |
283 |
$form->setMax("etat_calcul_centroide", 1); |
284 |
$form->setMax("message_calcul_centroide", 6); |
285 |
$form->setMax("date_recup_contrainte", 12); |
286 |
$form->setMax("etat_recup_contrainte", 1); |
287 |
$form->setMax("message_recup_contrainte", 6); |
288 |
$form->setMax("terrain_references_cadastrales_archive", 100); |
289 |
} |
290 |
|
291 |
|
292 |
function setLib(&$form,$maj) { |
293 |
//libelle des champs |
294 |
$form->setLib('sig_elyx',_('sig_elyx')); |
295 |
$form->setLib('dossier',_('dossier')); |
296 |
$form->setLib('date_verif_parcelle',_('date_verif_parcelle')); |
297 |
$form->setLib('etat_verif_parcelle',_('etat_verif_parcelle')); |
298 |
$form->setLib('message_verif_parcelle',_('message_verif_parcelle')); |
299 |
$form->setLib('date_calcul_emprise',_('date_calcul_emprise')); |
300 |
$form->setLib('etat_calcul_emprise',_('etat_calcul_emprise')); |
301 |
$form->setLib('message_calcul_emprise',_('message_calcul_emprise')); |
302 |
$form->setLib('date_dessin_emprise',_('date_dessin_emprise')); |
303 |
$form->setLib('etat_dessin_emprise',_('etat_dessin_emprise')); |
304 |
$form->setLib('message_dessin_emprise',_('message_dessin_emprise')); |
305 |
$form->setLib('date_calcul_centroide',_('date_calcul_centroide')); |
306 |
$form->setLib('etat_calcul_centroide',_('etat_calcul_centroide')); |
307 |
$form->setLib('message_calcul_centroide',_('message_calcul_centroide')); |
308 |
$form->setLib('date_recup_contrainte',_('date_recup_contrainte')); |
309 |
$form->setLib('etat_recup_contrainte',_('etat_recup_contrainte')); |
310 |
$form->setLib('message_recup_contrainte',_('message_recup_contrainte')); |
311 |
$form->setLib('terrain_references_cadastrales_archive',_('terrain_references_cadastrales_archive')); |
312 |
} |
313 |
|
314 |
function setSelect(&$form, $maj,&$db,$debug) { |
315 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
316 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
317 |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
318 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
319 |
|
320 |
// dossier |
321 |
$this->init_select($form, $db, $maj, $debug, "dossier", |
322 |
$sql_dossier, $sql_dossier_by_id, false); |
323 |
}// fin select |
324 |
|
325 |
//================================== |
326 |
// sous Formulaire [subform] |
327 |
//================================== |
328 |
|
329 |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
330 |
$this->retourformulaire = $retourformulaire; |
331 |
if($validation == 0) { |
332 |
if($retourformulaire =='dossier') |
333 |
$form->setVal('dossier', $idxformulaire); |
334 |
}// fin validation |
335 |
}// fin setValsousformulaire |
336 |
|
337 |
//================================== |
338 |
// cle secondaire [secondary key] |
339 |
//================================== |
340 |
|
341 |
}// fin classe |
342 |
?> |