1 |
<?php |
<?php |
2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 14/11/2012 16:22 |
//gen openMairie le 15/11/2012 09:53 |
4 |
|
|
5 |
require_once ("../obj/om_dbform.class.php"); |
require_once ("../obj/om_dbform.class.php"); |
6 |
|
|
25 |
} else { |
} else { |
26 |
$this->valF['type_demandeur'] = $val['type_demandeur']; |
$this->valF['type_demandeur'] = $val['type_demandeur']; |
27 |
} |
} |
|
if ($val['particulier_civilite'] == "") { |
|
|
$this->valF['particulier_civilite'] = NULL; |
|
|
} else { |
|
|
$this->valF['particulier_civilite'] = $val['particulier_civilite']; |
|
|
} |
|
28 |
if ($val['particulier_nom'] == "") { |
if ($val['particulier_nom'] == "") { |
29 |
$this->valF['particulier_nom'] = NULL; |
$this->valF['particulier_nom'] = NULL; |
30 |
} else { |
} else { |
70 |
} else { |
} else { |
71 |
$this->valF['personne_morale_categorie_juridique'] = $val['personne_morale_categorie_juridique']; |
$this->valF['personne_morale_categorie_juridique'] = $val['personne_morale_categorie_juridique']; |
72 |
} |
} |
|
if ($val['personne_morale_civilite'] == "") { |
|
|
$this->valF['personne_morale_civilite'] = NULL; |
|
|
} else { |
|
|
$this->valF['personne_morale_civilite'] = $val['personne_morale_civilite']; |
|
|
} |
|
73 |
if ($val['personne_morale_nom'] == "") { |
if ($val['personne_morale_nom'] == "") { |
74 |
$this->valF['personne_morale_nom'] = NULL; |
$this->valF['personne_morale_nom'] = NULL; |
75 |
} else { |
} else { |
160 |
} else { |
} else { |
161 |
$this->valF['frequent'] = false; |
$this->valF['frequent'] = false; |
162 |
} |
} |
163 |
|
if (!is_numeric($val['particulier_civilite'])) { |
164 |
|
$this->valF['particulier_civilite'] = NULL; |
165 |
|
} else { |
166 |
|
$this->valF['particulier_civilite'] = $val['particulier_civilite']; |
167 |
|
} |
168 |
|
if (!is_numeric($val['personne_morale_civilite'])) { |
169 |
|
$this->valF['personne_morale_civilite'] = NULL; |
170 |
|
} else { |
171 |
|
$this->valF['personne_morale_civilite'] = $val['personne_morale_civilite']; |
172 |
|
} |
173 |
} |
} |
174 |
|
|
175 |
//================================================= |
//================================================= |
198 |
if ($maj==0){ //ajout |
if ($maj==0){ //ajout |
199 |
$form->setType('demandeur','hidden');// cle automatique |
$form->setType('demandeur','hidden');// cle automatique |
200 |
$form->setType('type_demandeur','text'); |
$form->setType('type_demandeur','text'); |
|
|
|
|
if($this->retourformulaire=='civilite' |
|
|
and $form->val['particulier_civilite'] == $this->getParameter('idxformulaire')) { |
|
|
$form->setType('particulier_civilite','selecthiddenstatic'); |
|
|
} else { |
|
|
$form->setType('particulier_civilite','select'); |
|
|
} |
|
201 |
$form->setType('particulier_nom','text'); |
$form->setType('particulier_nom','text'); |
202 |
$form->setType('particulier_prenom','text'); |
$form->setType('particulier_prenom','text'); |
203 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
210 |
$form->setType('personne_morale_raison_sociale','text'); |
$form->setType('personne_morale_raison_sociale','text'); |
211 |
$form->setType('personne_morale_siret','text'); |
$form->setType('personne_morale_siret','text'); |
212 |
$form->setType('personne_morale_categorie_juridique','text'); |
$form->setType('personne_morale_categorie_juridique','text'); |
|
|
|
|
if($this->retourformulaire=='civilite' |
|
|
and $form->val['personne_morale_civilite'] == $this->getParameter('idxformulaire')) { |
|
|
$form->setType('personne_morale_civilite','selecthiddenstatic'); |
|
|
} else { |
|
|
$form->setType('personne_morale_civilite','select'); |
|
|
} |
|
213 |
$form->setType('personne_morale_nom','text'); |
$form->setType('personne_morale_nom','text'); |
214 |
$form->setType('personne_morale_prenom','text'); |
$form->setType('personne_morale_prenom','text'); |
215 |
$form->setType('numero','text'); |
$form->setType('numero','text'); |
228 |
$form->setType('courriel','text'); |
$form->setType('courriel','text'); |
229 |
$form->setType('notification','checkbox'); |
$form->setType('notification','checkbox'); |
230 |
$form->setType('frequent','checkbox'); |
$form->setType('frequent','checkbox'); |
|
}// fin ajout |
|
|
if ($maj==1){ //modifier |
|
|
$form->setType('demandeur','hiddenstatic'); |
|
|
$form->setType('type_demandeur','text'); |
|
231 |
|
|
232 |
if($this->retourformulaire=='civilite' |
if($this->retourformulaire=='civilite' |
233 |
and $form->val['particulier_civilite'] == $this->getParameter('idxformulaire')) { |
and $form->val['particulier_civilite'] == $this->getParameter('idxformulaire')) { |
235 |
} else { |
} else { |
236 |
$form->setType('particulier_civilite','select'); |
$form->setType('particulier_civilite','select'); |
237 |
} |
} |
238 |
|
|
239 |
|
if($this->retourformulaire=='civilite' |
240 |
|
and $form->val['personne_morale_civilite'] == $this->getParameter('idxformulaire')) { |
241 |
|
$form->setType('personne_morale_civilite','selecthiddenstatic'); |
242 |
|
} else { |
243 |
|
$form->setType('personne_morale_civilite','select'); |
244 |
|
} |
245 |
|
}// fin ajout |
246 |
|
if ($maj==1){ //modifier |
247 |
|
$form->setType('demandeur','hiddenstatic'); |
248 |
|
$form->setType('type_demandeur','text'); |
249 |
$form->setType('particulier_nom','text'); |
$form->setType('particulier_nom','text'); |
250 |
$form->setType('particulier_prenom','text'); |
$form->setType('particulier_prenom','text'); |
251 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
258 |
$form->setType('personne_morale_raison_sociale','text'); |
$form->setType('personne_morale_raison_sociale','text'); |
259 |
$form->setType('personne_morale_siret','text'); |
$form->setType('personne_morale_siret','text'); |
260 |
$form->setType('personne_morale_categorie_juridique','text'); |
$form->setType('personne_morale_categorie_juridique','text'); |
|
|
|
|
if($this->retourformulaire=='civilite' |
|
|
and $form->val['personne_morale_civilite'] == $this->getParameter('idxformulaire')) { |
|
|
$form->setType('personne_morale_civilite','selecthiddenstatic'); |
|
|
} else { |
|
|
$form->setType('personne_morale_civilite','select'); |
|
|
} |
|
261 |
$form->setType('personne_morale_nom','text'); |
$form->setType('personne_morale_nom','text'); |
262 |
$form->setType('personne_morale_prenom','text'); |
$form->setType('personne_morale_prenom','text'); |
263 |
$form->setType('numero','text'); |
$form->setType('numero','text'); |
276 |
$form->setType('courriel','text'); |
$form->setType('courriel','text'); |
277 |
$form->setType('notification','checkbox'); |
$form->setType('notification','checkbox'); |
278 |
$form->setType('frequent','checkbox'); |
$form->setType('frequent','checkbox'); |
279 |
|
|
280 |
|
if($this->retourformulaire=='civilite' |
281 |
|
and $form->val['particulier_civilite'] == $this->getParameter('idxformulaire')) { |
282 |
|
$form->setType('particulier_civilite','selecthiddenstatic'); |
283 |
|
} else { |
284 |
|
$form->setType('particulier_civilite','select'); |
285 |
|
} |
286 |
|
|
287 |
|
if($this->retourformulaire=='civilite' |
288 |
|
and $form->val['personne_morale_civilite'] == $this->getParameter('idxformulaire')) { |
289 |
|
$form->setType('personne_morale_civilite','selecthiddenstatic'); |
290 |
|
} else { |
291 |
|
$form->setType('personne_morale_civilite','select'); |
292 |
|
} |
293 |
}// fin modifier |
}// fin modifier |
294 |
if ($maj==2){ //supprimer |
if ($maj==2){ //supprimer |
295 |
$form->setType('demandeur','hiddenstatic'); |
$form->setType('demandeur','hiddenstatic'); |
296 |
$form->setType('type_demandeur','hiddenstatic'); |
$form->setType('type_demandeur','hiddenstatic'); |
|
$form->setType('particulier_civilite','selectstatic'); |
|
297 |
$form->setType('particulier_nom','hiddenstatic'); |
$form->setType('particulier_nom','hiddenstatic'); |
298 |
$form->setType('particulier_prenom','hiddenstatic'); |
$form->setType('particulier_prenom','hiddenstatic'); |
299 |
$form->setType('particulier_date_naissance','hiddenstatic'); |
$form->setType('particulier_date_naissance','hiddenstatic'); |
303 |
$form->setType('personne_morale_raison_sociale','hiddenstatic'); |
$form->setType('personne_morale_raison_sociale','hiddenstatic'); |
304 |
$form->setType('personne_morale_siret','hiddenstatic'); |
$form->setType('personne_morale_siret','hiddenstatic'); |
305 |
$form->setType('personne_morale_categorie_juridique','hiddenstatic'); |
$form->setType('personne_morale_categorie_juridique','hiddenstatic'); |
|
$form->setType('personne_morale_civilite','selectstatic'); |
|
306 |
$form->setType('personne_morale_nom','hiddenstatic'); |
$form->setType('personne_morale_nom','hiddenstatic'); |
307 |
$form->setType('personne_morale_prenom','hiddenstatic'); |
$form->setType('personne_morale_prenom','hiddenstatic'); |
308 |
$form->setType('numero','hiddenstatic'); |
$form->setType('numero','hiddenstatic'); |
321 |
$form->setType('courriel','hiddenstatic'); |
$form->setType('courriel','hiddenstatic'); |
322 |
$form->setType('notification','hiddenstatic'); |
$form->setType('notification','hiddenstatic'); |
323 |
$form->setType('frequent','hiddenstatic'); |
$form->setType('frequent','hiddenstatic'); |
324 |
|
$form->setType('particulier_civilite','selectstatic'); |
325 |
|
$form->setType('personne_morale_civilite','selectstatic'); |
326 |
}//fin supprimer |
}//fin supprimer |
327 |
if ($maj==3){ //consulter |
if ($maj==3){ //consulter |
328 |
$form->setType('demandeur','static'); |
$form->setType('demandeur','static'); |
329 |
$form->setType('type_demandeur','static'); |
$form->setType('type_demandeur','static'); |
|
$form->setType('particulier_civilite','selectstatic'); |
|
330 |
$form->setType('particulier_nom','static'); |
$form->setType('particulier_nom','static'); |
331 |
$form->setType('particulier_prenom','static'); |
$form->setType('particulier_prenom','static'); |
332 |
$form->setType('particulier_date_naissance','datestatic'); |
$form->setType('particulier_date_naissance','datestatic'); |
336 |
$form->setType('personne_morale_raison_sociale','static'); |
$form->setType('personne_morale_raison_sociale','static'); |
337 |
$form->setType('personne_morale_siret','static'); |
$form->setType('personne_morale_siret','static'); |
338 |
$form->setType('personne_morale_categorie_juridique','static'); |
$form->setType('personne_morale_categorie_juridique','static'); |
|
$form->setType('personne_morale_civilite','selectstatic'); |
|
339 |
$form->setType('personne_morale_nom','static'); |
$form->setType('personne_morale_nom','static'); |
340 |
$form->setType('personne_morale_prenom','static'); |
$form->setType('personne_morale_prenom','static'); |
341 |
$form->setType('numero','static'); |
$form->setType('numero','static'); |
354 |
$form->setType('courriel','static'); |
$form->setType('courriel','static'); |
355 |
$form->setType('notification','checkboxstatic'); |
$form->setType('notification','checkboxstatic'); |
356 |
$form->setType('frequent','checkboxstatic'); |
$form->setType('frequent','checkboxstatic'); |
357 |
|
$form->setType('particulier_civilite','selectstatic'); |
358 |
|
$form->setType('personne_morale_civilite','selectstatic'); |
359 |
}//fin consulter |
}//fin consulter |
360 |
} |
} |
361 |
|
|
363 |
//javascript controle client |
//javascript controle client |
364 |
$form->setOnchange('demandeur','VerifNum(this)'); |
$form->setOnchange('demandeur','VerifNum(this)'); |
365 |
$form->setOnchange('particulier_date_naissance','fdate(this)'); |
$form->setOnchange('particulier_date_naissance','fdate(this)'); |
366 |
|
$form->setOnchange('particulier_civilite','VerifNum(this)'); |
367 |
|
$form->setOnchange('personne_morale_civilite','VerifNum(this)'); |
368 |
} |
} |
369 |
/** |
/** |
370 |
* Methode setTaille |
* Methode setTaille |
372 |
function setTaille(&$form, $maj) { |
function setTaille(&$form, $maj) { |
373 |
$form->setTaille("demandeur", 11); |
$form->setTaille("demandeur", 11); |
374 |
$form->setTaille("type_demandeur", 30); |
$form->setTaille("type_demandeur", 30); |
|
$form->setTaille("particulier_civilite", 10); |
|
375 |
$form->setTaille("particulier_nom", 30); |
$form->setTaille("particulier_nom", 30); |
376 |
$form->setTaille("particulier_prenom", 30); |
$form->setTaille("particulier_prenom", 30); |
377 |
$form->setTaille("particulier_date_naissance", 12); |
$form->setTaille("particulier_date_naissance", 12); |
381 |
$form->setTaille("personne_morale_raison_sociale", 15); |
$form->setTaille("personne_morale_raison_sociale", 15); |
382 |
$form->setTaille("personne_morale_siret", 15); |
$form->setTaille("personne_morale_siret", 15); |
383 |
$form->setTaille("personne_morale_categorie_juridique", 15); |
$form->setTaille("personne_morale_categorie_juridique", 15); |
|
$form->setTaille("personne_morale_civilite", 10); |
|
384 |
$form->setTaille("personne_morale_nom", 30); |
$form->setTaille("personne_morale_nom", 30); |
385 |
$form->setTaille("personne_morale_prenom", 30); |
$form->setTaille("personne_morale_prenom", 30); |
386 |
$form->setTaille("numero", 10); |
$form->setTaille("numero", 10); |
399 |
$form->setTaille("courriel", 30); |
$form->setTaille("courriel", 30); |
400 |
$form->setTaille("notification", 1); |
$form->setTaille("notification", 1); |
401 |
$form->setTaille("frequent", 1); |
$form->setTaille("frequent", 1); |
402 |
|
$form->setTaille("particulier_civilite", 11); |
403 |
|
$form->setTaille("personne_morale_civilite", 11); |
404 |
} |
} |
405 |
|
|
406 |
/** |
/** |
409 |
function setMax(&$form, $maj) { |
function setMax(&$form, $maj) { |
410 |
$form->setMax("demandeur", 11); |
$form->setMax("demandeur", 11); |
411 |
$form->setMax("type_demandeur", 40); |
$form->setMax("type_demandeur", 40); |
|
$form->setMax("particulier_civilite", 10); |
|
412 |
$form->setMax("particulier_nom", 40); |
$form->setMax("particulier_nom", 40); |
413 |
$form->setMax("particulier_prenom", 40); |
$form->setMax("particulier_prenom", 40); |
414 |
$form->setMax("particulier_date_naissance", 12); |
$form->setMax("particulier_date_naissance", 12); |
418 |
$form->setMax("personne_morale_raison_sociale", 15); |
$form->setMax("personne_morale_raison_sociale", 15); |
419 |
$form->setMax("personne_morale_siret", 15); |
$form->setMax("personne_morale_siret", 15); |
420 |
$form->setMax("personne_morale_categorie_juridique", 15); |
$form->setMax("personne_morale_categorie_juridique", 15); |
|
$form->setMax("personne_morale_civilite", 10); |
|
421 |
$form->setMax("personne_morale_nom", 40); |
$form->setMax("personne_morale_nom", 40); |
422 |
$form->setMax("personne_morale_prenom", 40); |
$form->setMax("personne_morale_prenom", 40); |
423 |
$form->setMax("numero", 5); |
$form->setMax("numero", 5); |
436 |
$form->setMax("courriel", 40); |
$form->setMax("courriel", 40); |
437 |
$form->setMax("notification", 1); |
$form->setMax("notification", 1); |
438 |
$form->setMax("frequent", 1); |
$form->setMax("frequent", 1); |
439 |
|
$form->setMax("particulier_civilite", 11); |
440 |
|
$form->setMax("personne_morale_civilite", 11); |
441 |
} |
} |
442 |
|
|
443 |
|
|
445 |
//libelle des champs |
//libelle des champs |
446 |
$form->setLib('demandeur',_('demandeur')); |
$form->setLib('demandeur',_('demandeur')); |
447 |
$form->setLib('type_demandeur',_('type_demandeur')); |
$form->setLib('type_demandeur',_('type_demandeur')); |
|
$form->setLib('particulier_civilite',_('particulier_civilite')); |
|
448 |
$form->setLib('particulier_nom',_('particulier_nom')); |
$form->setLib('particulier_nom',_('particulier_nom')); |
449 |
$form->setLib('particulier_prenom',_('particulier_prenom')); |
$form->setLib('particulier_prenom',_('particulier_prenom')); |
450 |
$form->setLib('particulier_date_naissance',_('particulier_date_naissance')); |
$form->setLib('particulier_date_naissance',_('particulier_date_naissance')); |
454 |
$form->setLib('personne_morale_raison_sociale',_('personne_morale_raison_sociale')); |
$form->setLib('personne_morale_raison_sociale',_('personne_morale_raison_sociale')); |
455 |
$form->setLib('personne_morale_siret',_('personne_morale_siret')); |
$form->setLib('personne_morale_siret',_('personne_morale_siret')); |
456 |
$form->setLib('personne_morale_categorie_juridique',_('personne_morale_categorie_juridique')); |
$form->setLib('personne_morale_categorie_juridique',_('personne_morale_categorie_juridique')); |
|
$form->setLib('personne_morale_civilite',_('personne_morale_civilite')); |
|
457 |
$form->setLib('personne_morale_nom',_('personne_morale_nom')); |
$form->setLib('personne_morale_nom',_('personne_morale_nom')); |
458 |
$form->setLib('personne_morale_prenom',_('personne_morale_prenom')); |
$form->setLib('personne_morale_prenom',_('personne_morale_prenom')); |
459 |
$form->setLib('numero',_('numero')); |
$form->setLib('numero',_('numero')); |
472 |
$form->setLib('courriel',_('courriel')); |
$form->setLib('courriel',_('courriel')); |
473 |
$form->setLib('notification',_('notification')); |
$form->setLib('notification',_('notification')); |
474 |
$form->setLib('frequent',_('frequent')); |
$form->setLib('frequent',_('frequent')); |
475 |
|
$form->setLib('particulier_civilite',_('particulier_civilite')); |
476 |
|
$form->setLib('personne_morale_civilite',_('personne_morale_civilite')); |
477 |
} |
} |
478 |
|
|
479 |
function setSelect(&$form, $maj,&$db,$debug) { |
function setSelect(&$form, $maj,&$db,$debug) { |
484 |
|
|
485 |
// particulier_civilite |
// particulier_civilite |
486 |
$this->init_select($form, $db, $maj, $debug, "particulier_civilite", |
$this->init_select($form, $db, $maj, $debug, "particulier_civilite", |
487 |
$sql_particulier_civilite, $sql_particulier_civilite_by_id, false); |
$sql_particulier_civilite, $sql_particulier_civilite_by_id, true); |
488 |
|
|
489 |
// personne_morale_civilite |
// personne_morale_civilite |
490 |
$this->init_select($form, $db, $maj, $debug, "personne_morale_civilite", |
$this->init_select($form, $db, $maj, $debug, "personne_morale_civilite", |
491 |
$sql_personne_morale_civilite, $sql_personne_morale_civilite_by_id, false); |
$sql_personne_morale_civilite, $sql_personne_morale_civilite_by_id, true); |
492 |
}// fin select |
}// fin select |
493 |
|
|
494 |
//================================== |
//================================== |