25 |
JOIN ".DB_PREFIXE."lot ON dossier.dossier=lot.dossier |
JOIN ".DB_PREFIXE."lot ON dossier.dossier=lot.dossier |
26 |
WHERE lot.lot = ".$this->getParameter("idxformulaire"); |
WHERE lot.lot = ".$this->getParameter("idxformulaire"); |
27 |
|
|
28 |
|
} elseif($this->getParameter("retourformulaire") == "dossier_autorisation"){ |
29 |
|
$sql = "SELECT cerfa FROM ".DB_PREFIXE."dossier_autorisation_type_detaille |
30 |
|
JOIN ".DB_PREFIXE."dossier_instruction_type ON dossier_instruction_type.dossier_autorisation_type_detaille= |
31 |
|
dossier_autorisation_type_detaille.dossier_autorisation_type_detaille |
32 |
|
JOIN ".DB_PREFIXE."dossier ON dossier.dossier_instruction_type= |
33 |
|
dossier_instruction_type.dossier_instruction_type |
34 |
|
WHERE dossier_autorisation = '"; |
35 |
|
$sql .= $this->getParameter("idxformulaire")."'"; |
36 |
} else { |
} else { |
37 |
$sql = "SELECT cerfa FROM ".DB_PREFIXE."dossier_autorisation_type_detaille |
$sql = "SELECT cerfa FROM ".DB_PREFIXE."dossier_autorisation_type_detaille |
38 |
JOIN ".DB_PREFIXE."dossier_instruction_type ON dossier_instruction_type.dossier_autorisation_type_detaille= |
JOIN ".DB_PREFIXE."dossier_instruction_type ON dossier_instruction_type.dossier_autorisation_type_detaille= |
494 |
$form->setFieldset('am_lotiss','D' |
$form->setFieldset('am_lotiss','D' |
495 |
,_("Projet d'amenagement"), "startClosed alignFormSpec"); |
,_("Projet d'amenagement"), "startClosed alignFormSpec"); |
496 |
// bloc 4.1 |
// bloc 4.1 |
497 |
$form->setBloc('am_lotiss','DF',_("Nature des travaux, instalations |
$form->setBloc('am_lotiss','DF',_("Nature des travaux, installations |
498 |
ou amenagements envisages"), "group"); |
ou amenagements envisages"), "group"); |
499 |
$form->setBloc('am_div_mun','DF',"", "group"); |
$form->setBloc('am_div_mun','DF',"", "group"); |
500 |
$form->setBloc('am_autre_div','DF',"", "group"); |
$form->setBloc('am_autre_div','DF',"", "group"); |