1 |
mbroquet |
3730 |
<?php |
2 |
softime |
6929 |
//$Id$ |
3 |
softime |
7996 |
//gen openMairie le 03/05/2018 09:18 |
4 |
mbroquet |
3730 |
|
5 |
|
|
require_once "../obj/om_dbform.class.php"; |
6 |
|
|
|
7 |
|
|
class direction_gen extends om_dbform { |
8 |
|
|
|
9 |
softime |
7996 |
protected $_absolute_class_name = "direction"; |
10 |
|
|
|
11 |
mbroquet |
3730 |
var $table = "direction"; |
12 |
|
|
var $clePrimaire = "direction"; |
13 |
|
|
var $typeCle = "N"; |
14 |
|
|
var $required_field = array( |
15 |
|
|
"chef", |
16 |
|
|
"code", |
17 |
|
|
"direction", |
18 |
|
|
"libelle", |
19 |
|
|
"om_collectivite" |
20 |
|
|
); |
21 |
|
|
|
22 |
|
|
var $foreign_keys_extended = array( |
23 |
|
|
"om_collectivite" => array("om_collectivite", ), |
24 |
|
|
); |
25 |
softime |
7996 |
|
26 |
|
|
/** |
27 |
|
|
* |
28 |
|
|
* @return string |
29 |
|
|
*/ |
30 |
|
|
function get_default_libelle() { |
31 |
|
|
return $this->getVal($this->clePrimaire)." ".$this->getVal("libelle"); |
32 |
|
|
} |
33 |
mbroquet |
3730 |
|
34 |
softime |
7996 |
/** |
35 |
|
|
* |
36 |
|
|
* @return array |
37 |
|
|
*/ |
38 |
|
|
function get_var_sql_forminc__champs() { |
39 |
|
|
return array( |
40 |
|
|
"direction", |
41 |
|
|
"code", |
42 |
|
|
"libelle", |
43 |
|
|
"description", |
44 |
|
|
"chef", |
45 |
|
|
"om_validite_debut", |
46 |
|
|
"om_validite_fin", |
47 |
|
|
"om_collectivite", |
48 |
|
|
); |
49 |
|
|
} |
50 |
mbroquet |
3730 |
|
51 |
softime |
7996 |
/** |
52 |
|
|
* |
53 |
|
|
* @return string |
54 |
|
|
*/ |
55 |
|
|
function get_var_sql_forminc__sql_om_collectivite() { |
56 |
|
|
return "SELECT om_collectivite.om_collectivite, om_collectivite.libelle FROM ".DB_PREFIXE."om_collectivite ORDER BY om_collectivite.libelle ASC"; |
57 |
|
|
} |
58 |
mbroquet |
3730 |
|
59 |
softime |
7996 |
/** |
60 |
|
|
* |
61 |
|
|
* @return string |
62 |
|
|
*/ |
63 |
|
|
function get_var_sql_forminc__sql_om_collectivite_by_id() { |
64 |
|
|
return "SELECT om_collectivite.om_collectivite, om_collectivite.libelle FROM ".DB_PREFIXE."om_collectivite WHERE om_collectivite = <idx>"; |
65 |
|
|
} |
66 |
|
|
|
67 |
|
|
|
68 |
|
|
|
69 |
|
|
|
70 |
softime |
6929 |
function setvalF($val = array()) { |
71 |
mbroquet |
3730 |
//affectation valeur formulaire |
72 |
|
|
if (!is_numeric($val['direction'])) { |
73 |
|
|
$this->valF['direction'] = ""; // -> requis |
74 |
|
|
} else { |
75 |
|
|
$this->valF['direction'] = $val['direction']; |
76 |
|
|
} |
77 |
|
|
$this->valF['code'] = $val['code']; |
78 |
|
|
$this->valF['libelle'] = $val['libelle']; |
79 |
|
|
$this->valF['description'] = $val['description']; |
80 |
|
|
$this->valF['chef'] = $val['chef']; |
81 |
|
|
if ($val['om_validite_debut'] != "") { |
82 |
|
|
$this->valF['om_validite_debut'] = $this->dateDB($val['om_validite_debut']); |
83 |
|
|
} else { |
84 |
|
|
$this->valF['om_validite_debut'] = NULL; |
85 |
|
|
} |
86 |
|
|
if ($val['om_validite_fin'] != "") { |
87 |
|
|
$this->valF['om_validite_fin'] = $this->dateDB($val['om_validite_fin']); |
88 |
|
|
} else { |
89 |
|
|
$this->valF['om_validite_fin'] = NULL; |
90 |
|
|
} |
91 |
|
|
if (!is_numeric($val['om_collectivite'])) { |
92 |
|
|
$this->valF['om_collectivite'] = ""; // -> requis |
93 |
|
|
} else { |
94 |
|
|
if($_SESSION['niveau']==1) { |
95 |
|
|
$this->valF['om_collectivite'] = $_SESSION['collectivite']; |
96 |
|
|
} else { |
97 |
|
|
$this->valF['om_collectivite'] = $val['om_collectivite']; |
98 |
|
|
} |
99 |
|
|
} |
100 |
|
|
} |
101 |
|
|
|
102 |
|
|
//================================================= |
103 |
|
|
//cle primaire automatique [automatic primary key] |
104 |
|
|
//================================================== |
105 |
|
|
|
106 |
softime |
7685 |
function setId(&$dnu1 = null) { |
107 |
mbroquet |
3730 |
//numero automatique |
108 |
|
|
$this->valF[$this->clePrimaire] = $this->f->db->nextId(DB_PREFIXE.$this->table); |
109 |
|
|
} |
110 |
|
|
|
111 |
softime |
7685 |
function setValFAjout($val = array()) { |
112 |
mbroquet |
3730 |
//numero automatique -> pas de controle ajout cle primaire |
113 |
|
|
} |
114 |
|
|
|
115 |
softime |
7685 |
function verifierAjout($val = array(), &$dnu1 = null) { |
116 |
mbroquet |
3730 |
//numero automatique -> pas de verfication de cle primaire |
117 |
|
|
} |
118 |
|
|
/** |
119 |
|
|
* Methode verifier |
120 |
|
|
*/ |
121 |
softime |
7685 |
function verifier($val = array(), &$dnu1 = null, $dnu2 = null) { |
122 |
mbroquet |
3730 |
// On appelle la methode de la classe parent |
123 |
|
|
parent::verifier($val, $this->f->db, null); |
124 |
|
|
|
125 |
|
|
// gestion des dates de validites |
126 |
|
|
$date_debut = $this->valF['om_validite_debut']; |
127 |
|
|
$date_fin = $this->valF['om_validite_fin']; |
128 |
|
|
|
129 |
|
|
if ($date_debut != '' and $date_fin != '') { |
130 |
|
|
|
131 |
|
|
$date_debut = explode('-', $this->valF['om_validite_debut']); |
132 |
|
|
$date_fin = explode('-', $this->valF['om_validite_fin']); |
133 |
|
|
|
134 |
|
|
$time_debut = mktime(0, 0, 0, $date_debut[1], $date_debut[2], |
135 |
|
|
$date_debut[0]); |
136 |
|
|
$time_fin = mktime(0, 0, 0, $date_fin[1], $date_fin[2], |
137 |
|
|
$date_fin[0]); |
138 |
|
|
|
139 |
|
|
if ($time_debut > $time_fin or $time_debut == $time_fin) { |
140 |
|
|
$this->correct = false; |
141 |
softime |
7996 |
$this->addToMessage(__('La date de fin de validite doit etre future a la de debut de validite.')); |
142 |
mbroquet |
3730 |
} |
143 |
|
|
} |
144 |
|
|
} |
145 |
|
|
|
146 |
|
|
|
147 |
|
|
//========================== |
148 |
|
|
// Formulaire [form] |
149 |
|
|
//========================== |
150 |
|
|
/** |
151 |
|
|
* |
152 |
|
|
*/ |
153 |
|
|
function setType(&$form, $maj) { |
154 |
|
|
// Récupération du mode de l'action |
155 |
|
|
$crud = $this->get_action_crud($maj); |
156 |
|
|
|
157 |
|
|
// MODE AJOUTER |
158 |
|
|
if ($maj == 0 || $crud == 'create') { |
159 |
|
|
$form->setType("direction", "hidden"); |
160 |
|
|
$form->setType("code", "text"); |
161 |
|
|
$form->setType("libelle", "text"); |
162 |
|
|
$form->setType("description", "textarea"); |
163 |
|
|
$form->setType("chef", "text"); |
164 |
|
|
if ($this->f->isAccredited(array($this->table."_modifier_validite", $this->table, ))) { |
165 |
|
|
$form->setType("om_validite_debut", "date"); |
166 |
|
|
} else { |
167 |
|
|
$form->setType("om_validite_debut", "hiddenstaticdate"); |
168 |
|
|
} |
169 |
|
|
if ($this->f->isAccredited(array($this->table."_modifier_validite", $this->table, ))) { |
170 |
|
|
$form->setType("om_validite_fin", "date"); |
171 |
|
|
} else { |
172 |
|
|
$form->setType("om_validite_fin", "hiddenstaticdate"); |
173 |
|
|
} |
174 |
|
|
if ($this->is_in_context_of_foreign_key("om_collectivite", $this->retourformulaire)) { |
175 |
|
|
if($_SESSION["niveau"] == 2) { |
176 |
|
|
$form->setType("om_collectivite", "selecthiddenstatic"); |
177 |
|
|
} else { |
178 |
|
|
$form->setType("om_collectivite", "hidden"); |
179 |
|
|
} |
180 |
|
|
} else { |
181 |
|
|
if($_SESSION["niveau"] == 2) { |
182 |
|
|
$form->setType("om_collectivite", "select"); |
183 |
|
|
} else { |
184 |
|
|
$form->setType("om_collectivite", "hidden"); |
185 |
|
|
} |
186 |
|
|
} |
187 |
|
|
} |
188 |
|
|
|
189 |
|
|
// MDOE MODIFIER |
190 |
|
|
if ($maj == 1 || $crud == 'update') { |
191 |
|
|
$form->setType("direction", "hiddenstatic"); |
192 |
|
|
$form->setType("code", "text"); |
193 |
|
|
$form->setType("libelle", "text"); |
194 |
|
|
$form->setType("description", "textarea"); |
195 |
|
|
$form->setType("chef", "text"); |
196 |
|
|
if ($this->f->isAccredited(array($this->table."_modifier_validite", $this->table, ))) { |
197 |
|
|
$form->setType("om_validite_debut", "date"); |
198 |
|
|
} else { |
199 |
|
|
$form->setType("om_validite_debut", "hiddenstaticdate"); |
200 |
|
|
} |
201 |
|
|
if ($this->f->isAccredited(array($this->table."_modifier_validite", $this->table, ))) { |
202 |
|
|
$form->setType("om_validite_fin", "date"); |
203 |
|
|
} else { |
204 |
|
|
$form->setType("om_validite_fin", "hiddenstaticdate"); |
205 |
|
|
} |
206 |
|
|
if ($this->is_in_context_of_foreign_key("om_collectivite", $this->retourformulaire)) { |
207 |
|
|
if($_SESSION["niveau"] == 2) { |
208 |
|
|
$form->setType("om_collectivite", "selecthiddenstatic"); |
209 |
|
|
} else { |
210 |
|
|
$form->setType("om_collectivite", "hidden"); |
211 |
|
|
} |
212 |
|
|
} else { |
213 |
|
|
if($_SESSION["niveau"] == 2) { |
214 |
|
|
$form->setType("om_collectivite", "select"); |
215 |
|
|
} else { |
216 |
|
|
$form->setType("om_collectivite", "hidden"); |
217 |
|
|
} |
218 |
|
|
} |
219 |
|
|
} |
220 |
|
|
|
221 |
|
|
// MODE SUPPRIMER |
222 |
|
|
if ($maj == 2 || $crud == 'delete') { |
223 |
|
|
$form->setType("direction", "hiddenstatic"); |
224 |
|
|
$form->setType("code", "hiddenstatic"); |
225 |
|
|
$form->setType("libelle", "hiddenstatic"); |
226 |
|
|
$form->setType("description", "hiddenstatic"); |
227 |
|
|
$form->setType("chef", "hiddenstatic"); |
228 |
|
|
$form->setType("om_validite_debut", "hiddenstatic"); |
229 |
|
|
$form->setType("om_validite_fin", "hiddenstatic"); |
230 |
|
|
if ($_SESSION["niveau"] == 2) { |
231 |
|
|
$form->setType("om_collectivite", "selectstatic"); |
232 |
|
|
} else { |
233 |
|
|
$form->setType("om_collectivite", "hidden"); |
234 |
|
|
} |
235 |
|
|
} |
236 |
|
|
|
237 |
|
|
// MODE CONSULTER |
238 |
|
|
if ($maj == 3 || $crud == 'read') { |
239 |
|
|
$form->setType("direction", "static"); |
240 |
|
|
$form->setType("code", "static"); |
241 |
|
|
$form->setType("libelle", "static"); |
242 |
|
|
$form->setType("description", "textareastatic"); |
243 |
|
|
$form->setType("chef", "static"); |
244 |
|
|
$form->setType("om_validite_debut", "datestatic"); |
245 |
|
|
$form->setType("om_validite_fin", "datestatic"); |
246 |
|
|
if ($this->is_in_context_of_foreign_key("om_collectivite", $this->retourformulaire)) { |
247 |
|
|
if($_SESSION["niveau"] == 2) { |
248 |
|
|
$form->setType("om_collectivite", "selectstatic"); |
249 |
|
|
} else { |
250 |
|
|
$form->setType("om_collectivite", "hidden"); |
251 |
|
|
} |
252 |
|
|
} else { |
253 |
|
|
if($_SESSION["niveau"] == 2) { |
254 |
|
|
$form->setType("om_collectivite", "selectstatic"); |
255 |
|
|
} else { |
256 |
|
|
$form->setType("om_collectivite", "hidden"); |
257 |
|
|
} |
258 |
|
|
} |
259 |
|
|
} |
260 |
|
|
|
261 |
|
|
} |
262 |
|
|
|
263 |
|
|
|
264 |
|
|
function setOnchange(&$form, $maj) { |
265 |
|
|
//javascript controle client |
266 |
|
|
$form->setOnchange('direction','VerifNum(this)'); |
267 |
|
|
$form->setOnchange('om_validite_debut','fdate(this)'); |
268 |
|
|
$form->setOnchange('om_validite_fin','fdate(this)'); |
269 |
|
|
$form->setOnchange('om_collectivite','VerifNum(this)'); |
270 |
|
|
} |
271 |
|
|
/** |
272 |
|
|
* Methode setTaille |
273 |
|
|
*/ |
274 |
|
|
function setTaille(&$form, $maj) { |
275 |
|
|
$form->setTaille("direction", 11); |
276 |
|
|
$form->setTaille("code", 20); |
277 |
|
|
$form->setTaille("libelle", 30); |
278 |
|
|
$form->setTaille("description", 80); |
279 |
|
|
$form->setTaille("chef", 30); |
280 |
|
|
$form->setTaille("om_validite_debut", 12); |
281 |
|
|
$form->setTaille("om_validite_fin", 12); |
282 |
|
|
$form->setTaille("om_collectivite", 11); |
283 |
|
|
} |
284 |
|
|
|
285 |
|
|
/** |
286 |
|
|
* Methode setMax |
287 |
|
|
*/ |
288 |
|
|
function setMax(&$form, $maj) { |
289 |
|
|
$form->setMax("direction", 11); |
290 |
|
|
$form->setMax("code", 20); |
291 |
|
|
$form->setMax("libelle", 100); |
292 |
|
|
$form->setMax("description", 6); |
293 |
|
|
$form->setMax("chef", 100); |
294 |
|
|
$form->setMax("om_validite_debut", 12); |
295 |
|
|
$form->setMax("om_validite_fin", 12); |
296 |
|
|
$form->setMax("om_collectivite", 11); |
297 |
|
|
} |
298 |
|
|
|
299 |
|
|
|
300 |
|
|
function setLib(&$form, $maj) { |
301 |
|
|
//libelle des champs |
302 |
softime |
7996 |
$form->setLib('direction', __('direction')); |
303 |
|
|
$form->setLib('code', __('code')); |
304 |
|
|
$form->setLib('libelle', __('libelle')); |
305 |
|
|
$form->setLib('description', __('description')); |
306 |
|
|
$form->setLib('chef', __('chef')); |
307 |
|
|
$form->setLib('om_validite_debut', __('om_validite_debut')); |
308 |
|
|
$form->setLib('om_validite_fin', __('om_validite_fin')); |
309 |
|
|
$form->setLib('om_collectivite', __('om_collectivite')); |
310 |
mbroquet |
3730 |
} |
311 |
|
|
/** |
312 |
|
|
* |
313 |
|
|
*/ |
314 |
|
|
function setSelect(&$form, $maj, &$dnu1 = null, $dnu2 = null) { |
315 |
|
|
|
316 |
|
|
// om_collectivite |
317 |
softime |
7996 |
$this->init_select( |
318 |
|
|
$form, |
319 |
|
|
$this->f->db, |
320 |
|
|
$maj, |
321 |
|
|
null, |
322 |
|
|
"om_collectivite", |
323 |
|
|
$this->get_var_sql_forminc__sql("om_collectivite"), |
324 |
|
|
$this->get_var_sql_forminc__sql("om_collectivite_by_id"), |
325 |
|
|
false |
326 |
|
|
); |
327 |
mbroquet |
3730 |
} |
328 |
|
|
|
329 |
|
|
|
330 |
softime |
7685 |
function setVal(&$form, $maj, $validation, &$dnu1 = null, $dnu2 = null) { |
331 |
mbroquet |
3730 |
if($validation==0 and $maj==0 and $_SESSION['niveau']==1) { |
332 |
|
|
$form->setVal('om_collectivite', $_SESSION['collectivite']); |
333 |
|
|
}// fin validation |
334 |
|
|
$this->set_form_default_values($form, $maj, $validation); |
335 |
|
|
}// fin setVal |
336 |
|
|
|
337 |
|
|
//================================== |
338 |
softime |
7685 |
// sous Formulaire |
339 |
mbroquet |
3730 |
//================================== |
340 |
|
|
|
341 |
|
|
|
342 |
softime |
7685 |
function setValsousformulaire(&$form, $maj, $validation, $idxformulaire, $retourformulaire, $typeformulaire, &$dnu1 = null, $dnu2 = null) { |
343 |
mbroquet |
3730 |
$this->retourformulaire = $retourformulaire; |
344 |
|
|
if($validation==0 and $maj==0 and $_SESSION['niveau']==1) { |
345 |
|
|
$form->setVal('om_collectivite', $_SESSION['collectivite']); |
346 |
|
|
}// fin validation |
347 |
|
|
if($validation == 0) { |
348 |
|
|
if($this->is_in_context_of_foreign_key('om_collectivite', $this->retourformulaire)) |
349 |
|
|
$form->setVal('om_collectivite', $idxformulaire); |
350 |
|
|
}// fin validation |
351 |
|
|
$this->set_form_default_values($form, $maj, $validation); |
352 |
|
|
}// fin setValsousformulaire |
353 |
|
|
|
354 |
|
|
//================================== |
355 |
softime |
7685 |
// cle secondaire |
356 |
mbroquet |
3730 |
//================================== |
357 |
|
|
|
358 |
|
|
/** |
359 |
|
|
* Methode clesecondaire |
360 |
|
|
*/ |
361 |
softime |
7685 |
function cleSecondaire($id, &$dnu1 = null, $val = array(), $dnu2 = null) { |
362 |
mbroquet |
3730 |
// On appelle la methode de la classe parent |
363 |
|
|
parent::cleSecondaire($id); |
364 |
|
|
// Verification de la cle secondaire : division |
365 |
|
|
$this->rechercheTable($this->f->db, "division", "direction", $id); |
366 |
|
|
} |
367 |
|
|
|
368 |
|
|
|
369 |
|
|
} |