/[openfoncier]/trunk/gen/obj/sig_elyx.class.php
ViewVC logotype

Contents of /trunk/gen/obj/sig_elyx.class.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 2166 - (show annotations)
Thu Aug 22 15:39:21 2013 UTC (11 years, 5 months ago) by softime
File size: 16227 byte(s)
- Ajout de la table sig_elyx
- Génération OM
- Création de l'interface pour la Géolocalisation
- Traductions

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 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26