1 |
fraynaud |
337 |
<?php |
2 |
|
|
//$Id$ |
3 |
nhaye |
398 |
//gen openMairie le 20/09/2012 14:59 |
4 |
|
|
|
5 |
fraynaud |
337 |
require_once ("../obj/om_dbform.class.php"); |
6 |
|
|
|
7 |
|
|
class om_sig_map_wms_gen extends om_dbform { |
8 |
|
|
var $table="om_sig_map_wms"; |
9 |
|
|
var $clePrimaire="om_sig_map_wms"; |
10 |
|
|
var $typeCle="N"; |
11 |
nhaye |
398 |
var $required_field=array( |
12 |
|
|
"om_sig_map_wms", |
13 |
|
|
"om_sig_wms", |
14 |
|
|
"om_sig_map", |
15 |
|
|
"ol_map", |
16 |
|
|
"ordre", |
17 |
|
|
"visibility" |
18 |
|
|
); |
19 |
fraynaud |
337 |
var $retourformulaire; |
20 |
|
|
|
21 |
|
|
function setvalF($val) { |
22 |
|
|
//affectation valeur formulaire |
23 |
nhaye |
398 |
if(!is_numeric($val['om_sig_map_wms'])) { |
24 |
fraynaud |
337 |
unset($this->valF['om_sig_map_wms']); |
25 |
nhaye |
398 |
} else { |
26 |
fraynaud |
337 |
$this->valF['om_sig_map_wms'] = $val['om_sig_map_wms']; |
27 |
nhaye |
398 |
} |
28 |
|
|
if(!is_numeric($val['om_sig_wms'])) { |
29 |
fraynaud |
337 |
unset($this->valF['om_sig_wms']); |
30 |
nhaye |
398 |
} else { |
31 |
fraynaud |
337 |
$this->valF['om_sig_wms'] = $val['om_sig_wms']; |
32 |
nhaye |
398 |
} |
33 |
|
|
if(!is_numeric($val['om_sig_map'])) { |
34 |
fraynaud |
337 |
unset($this->valF['om_sig_map']); |
35 |
nhaye |
398 |
} else { |
36 |
fraynaud |
337 |
$this->valF['om_sig_map'] = $val['om_sig_map']; |
37 |
nhaye |
398 |
} |
38 |
fraynaud |
337 |
$this->valF['ol_map'] = $val['ol_map']; |
39 |
nhaye |
398 |
if(!is_numeric($val['ordre'])) { |
40 |
fraynaud |
337 |
unset($this->valF['ordre']); |
41 |
nhaye |
398 |
} else { |
42 |
fraynaud |
337 |
$this->valF['ordre'] = $val['ordre']; |
43 |
nhaye |
398 |
} |
44 |
fraynaud |
337 |
$this->valF['visibility'] = $val['visibility']; |
45 |
|
|
$this->valF['panier'] = $val['panier']; |
46 |
|
|
$this->valF['pa_nom'] = $val['pa_nom']; |
47 |
|
|
$this->valF['pa_layer'] = $val['pa_layer']; |
48 |
|
|
$this->valF['pa_attribut'] = $val['pa_attribut']; |
49 |
|
|
$this->valF['pa_encaps'] = $val['pa_encaps']; |
50 |
|
|
$this->valF['pa_sql'] = $val['pa_sql']; |
51 |
|
|
$this->valF['pa_type_geometrie'] = $val['pa_type_geometrie']; |
52 |
|
|
} |
53 |
|
|
|
54 |
|
|
//================================================= |
55 |
|
|
//cle primaire automatique [automatic primary key] |
56 |
|
|
//================================================== |
57 |
|
|
|
58 |
|
|
function setId(&$db) { |
59 |
|
|
//numero automatique |
60 |
nhaye |
398 |
$this->valF[$this->clePrimaire] = $db->nextId(DB_PREFIXE.$this->table); |
61 |
fraynaud |
337 |
} |
62 |
|
|
|
63 |
|
|
function setValFAjout($val) { |
64 |
|
|
//numero automatique -> pas de controle ajout cle primaire |
65 |
|
|
} |
66 |
|
|
|
67 |
|
|
function verifierAjout() { |
68 |
|
|
//numero automatique -> pas de verfication de cle primaire |
69 |
|
|
} |
70 |
|
|
|
71 |
|
|
//========================== |
72 |
|
|
// Formulaire [form] |
73 |
|
|
//========================== |
74 |
|
|
|
75 |
|
|
function setType(&$form,$maj) { |
76 |
|
|
//type |
77 |
|
|
if ($maj==0){ //ajout |
78 |
|
|
$form->setType('om_sig_map_wms','hidden');// cle automatique |
79 |
nhaye |
398 |
|
80 |
|
|
if($this->retourformulaire=='om_sig_wms' |
81 |
|
|
and $form->val['om_sig_wms'] == $this->getParameter('idxformulaire')) { |
82 |
|
|
$form->setType('om_sig_wms','selecthiddenstatic'); |
83 |
|
|
} else { |
84 |
fraynaud |
337 |
$form->setType('om_sig_wms','select'); |
85 |
nhaye |
398 |
} |
86 |
|
|
|
87 |
|
|
if($this->retourformulaire=='om_sig_map' |
88 |
|
|
and $form->val['om_sig_map'] == $this->getParameter('idxformulaire')) { |
89 |
|
|
$form->setType('om_sig_map','selecthiddenstatic'); |
90 |
|
|
} else { |
91 |
fraynaud |
337 |
$form->setType('om_sig_map','select'); |
92 |
nhaye |
398 |
} |
93 |
fraynaud |
337 |
$form->setType('ol_map','text'); |
94 |
|
|
$form->setType('ordre','text'); |
95 |
|
|
$form->setType('visibility','text'); |
96 |
|
|
$form->setType('panier','text'); |
97 |
|
|
$form->setType('pa_nom','text'); |
98 |
|
|
$form->setType('pa_layer','text'); |
99 |
|
|
$form->setType('pa_attribut','text'); |
100 |
|
|
$form->setType('pa_encaps','text'); |
101 |
|
|
$form->setType('pa_sql','textarea'); |
102 |
|
|
$form->setType('pa_type_geometrie','text'); |
103 |
|
|
}// fin ajout |
104 |
|
|
if ($maj==1){ //modifier |
105 |
|
|
$form->setType('om_sig_map_wms','hiddenstatic'); |
106 |
nhaye |
398 |
|
107 |
|
|
if($this->retourformulaire=='om_sig_wms' |
108 |
|
|
and $form->val['om_sig_wms'] == $this->getParameter('idxformulaire')) { |
109 |
|
|
$form->setType('om_sig_wms','selecthiddenstatic'); |
110 |
|
|
} else { |
111 |
fraynaud |
337 |
$form->setType('om_sig_wms','select'); |
112 |
nhaye |
398 |
} |
113 |
|
|
|
114 |
|
|
if($this->retourformulaire=='om_sig_map' |
115 |
|
|
and $form->val['om_sig_map'] == $this->getParameter('idxformulaire')) { |
116 |
|
|
$form->setType('om_sig_map','selecthiddenstatic'); |
117 |
|
|
} else { |
118 |
fraynaud |
337 |
$form->setType('om_sig_map','select'); |
119 |
nhaye |
398 |
} |
120 |
fraynaud |
337 |
$form->setType('ol_map','text'); |
121 |
|
|
$form->setType('ordre','text'); |
122 |
|
|
$form->setType('visibility','text'); |
123 |
|
|
$form->setType('panier','text'); |
124 |
|
|
$form->setType('pa_nom','text'); |
125 |
|
|
$form->setType('pa_layer','text'); |
126 |
|
|
$form->setType('pa_attribut','text'); |
127 |
|
|
$form->setType('pa_encaps','text'); |
128 |
|
|
$form->setType('pa_sql','textarea'); |
129 |
|
|
$form->setType('pa_type_geometrie','text'); |
130 |
|
|
}// fin modifier |
131 |
|
|
if ($maj==2){ //supprimer |
132 |
|
|
$form->setType('om_sig_map_wms','hiddenstatic'); |
133 |
nhaye |
398 |
$form->setType('om_sig_wms','selectstatic'); |
134 |
|
|
$form->setType('om_sig_map','selectstatic'); |
135 |
fraynaud |
337 |
$form->setType('ol_map','hiddenstatic'); |
136 |
|
|
$form->setType('ordre','hiddenstatic'); |
137 |
|
|
$form->setType('visibility','hiddenstatic'); |
138 |
|
|
$form->setType('panier','hiddenstatic'); |
139 |
|
|
$form->setType('pa_nom','hiddenstatic'); |
140 |
|
|
$form->setType('pa_layer','hiddenstatic'); |
141 |
|
|
$form->setType('pa_attribut','hiddenstatic'); |
142 |
|
|
$form->setType('pa_encaps','hiddenstatic'); |
143 |
|
|
$form->setType('pa_sql','hiddenstatic'); |
144 |
|
|
$form->setType('pa_type_geometrie','hiddenstatic'); |
145 |
|
|
}//fin supprimer |
146 |
nhaye |
398 |
if ($maj==3){ //consulter |
147 |
|
|
$form->setType('om_sig_map_wms','static'); |
148 |
|
|
$form->setType('om_sig_wms','selectstatic'); |
149 |
|
|
$form->setType('om_sig_map','selectstatic'); |
150 |
|
|
$form->setType('ol_map','static'); |
151 |
|
|
$form->setType('ordre','static'); |
152 |
|
|
$form->setType('visibility','static'); |
153 |
|
|
$form->setType('panier','static'); |
154 |
|
|
$form->setType('pa_nom','static'); |
155 |
|
|
$form->setType('pa_layer','static'); |
156 |
|
|
$form->setType('pa_attribut','static'); |
157 |
|
|
$form->setType('pa_encaps','static'); |
158 |
|
|
$form->setType('pa_sql','textareastatic'); |
159 |
|
|
$form->setType('pa_type_geometrie','static'); |
160 |
|
|
}//fin consulter |
161 |
fraynaud |
337 |
} |
162 |
|
|
|
163 |
|
|
function setOnchange(&$form,$maj) { |
164 |
|
|
//javascript controle client |
165 |
|
|
$form->setOnchange('om_sig_map_wms','VerifNum(this)'); |
166 |
|
|
$form->setOnchange('om_sig_wms','VerifNum(this)'); |
167 |
|
|
$form->setOnchange('om_sig_map','VerifNum(this)'); |
168 |
|
|
$form->setOnchange('ordre','VerifNum(this)'); |
169 |
|
|
} |
170 |
|
|
/** |
171 |
|
|
* Methode setTaille |
172 |
|
|
*/ |
173 |
|
|
function setTaille(&$form, $maj) { |
174 |
|
|
$form->setTaille("om_sig_map_wms", 11); |
175 |
|
|
$form->setTaille("om_sig_wms", 11); |
176 |
|
|
$form->setTaille("om_sig_map", 11); |
177 |
|
|
$form->setTaille("ol_map", 30); |
178 |
|
|
$form->setTaille("ordre", 11); |
179 |
|
|
$form->setTaille("visibility", 10); |
180 |
|
|
$form->setTaille("panier", 10); |
181 |
|
|
$form->setTaille("pa_nom", 30); |
182 |
|
|
$form->setTaille("pa_layer", 30); |
183 |
|
|
$form->setTaille("pa_attribut", 30); |
184 |
|
|
$form->setTaille("pa_encaps", 10); |
185 |
|
|
$form->setTaille("pa_sql", 80); |
186 |
|
|
$form->setTaille("pa_type_geometrie", 30); |
187 |
|
|
} |
188 |
|
|
|
189 |
|
|
/** |
190 |
|
|
* Methode setMax |
191 |
|
|
*/ |
192 |
|
|
function setMax(&$form, $maj) { |
193 |
|
|
$form->setMax("om_sig_map_wms", 11); |
194 |
|
|
$form->setMax("om_sig_wms", 11); |
195 |
|
|
$form->setMax("om_sig_map", 11); |
196 |
|
|
$form->setMax("ol_map", 50); |
197 |
|
|
$form->setMax("ordre", 11); |
198 |
|
|
$form->setMax("visibility", 3); |
199 |
|
|
$form->setMax("panier", 3); |
200 |
|
|
$form->setMax("pa_nom", 50); |
201 |
|
|
$form->setMax("pa_layer", 50); |
202 |
|
|
$form->setMax("pa_attribut", 50); |
203 |
|
|
$form->setMax("pa_encaps", 3); |
204 |
|
|
$form->setMax("pa_sql", 6); |
205 |
|
|
$form->setMax("pa_type_geometrie", 30); |
206 |
|
|
} |
207 |
|
|
|
208 |
|
|
|
209 |
|
|
function setLib(&$form,$maj) { |
210 |
|
|
//libelle des champs |
211 |
|
|
$form->setLib('om_sig_map_wms',_('om_sig_map_wms')); |
212 |
|
|
$form->setLib('om_sig_wms',_('om_sig_wms')); |
213 |
|
|
$form->setLib('om_sig_map',_('om_sig_map')); |
214 |
|
|
$form->setLib('ol_map',_('ol_map')); |
215 |
|
|
$form->setLib('ordre',_('ordre')); |
216 |
|
|
$form->setLib('visibility',_('visibility')); |
217 |
|
|
$form->setLib('panier',_('panier')); |
218 |
|
|
$form->setLib('pa_nom',_('pa_nom')); |
219 |
|
|
$form->setLib('pa_layer',_('pa_layer')); |
220 |
|
|
$form->setLib('pa_attribut',_('pa_attribut')); |
221 |
|
|
$form->setLib('pa_encaps',_('pa_encaps')); |
222 |
|
|
$form->setLib('pa_sql',_('pa_sql')); |
223 |
|
|
$form->setLib('pa_type_geometrie',_('pa_type_geometrie')); |
224 |
|
|
} |
225 |
|
|
|
226 |
|
|
function setSelect(&$form, $maj,&$db,$debug) { |
227 |
|
|
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
228 |
|
|
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
229 |
|
|
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
230 |
|
|
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
231 |
nhaye |
398 |
|
232 |
|
|
// om_sig_map |
233 |
|
|
$this->init_select($form, $db, $maj, $debug, "om_sig_map", |
234 |
|
|
$sql_om_sig_map, $sql_om_sig_map_by_id, false); |
235 |
|
|
|
236 |
|
|
// om_sig_wms |
237 |
|
|
$this->init_select($form, $db, $maj, $debug, "om_sig_wms", |
238 |
|
|
$sql_om_sig_wms, $sql_om_sig_wms_by_id, false); |
239 |
fraynaud |
337 |
}// fin select |
240 |
|
|
|
241 |
|
|
//================================== |
242 |
|
|
// sous Formulaire [subform] |
243 |
|
|
//================================== |
244 |
|
|
|
245 |
|
|
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
246 |
|
|
$this->retourformulaire = $retourformulaire; |
247 |
nhaye |
398 |
if($validation == 0) { |
248 |
|
|
if($retourformulaire =='om_sig_map') |
249 |
|
|
$form->setVal('om_sig_map', $idxformulaire); |
250 |
fraynaud |
337 |
if($retourformulaire =='om_sig_wms') |
251 |
|
|
$form->setVal('om_sig_wms', $idxformulaire); |
252 |
|
|
}// fin validation |
253 |
|
|
}// fin setValsousformulaire |
254 |
|
|
|
255 |
|
|
//================================== |
256 |
|
|
// cle secondaire [secondary key] |
257 |
|
|
//================================== |
258 |
|
|
|
259 |
|
|
}// fin classe |
260 |
|
|
?> |