| 1 |
<?php |
| 2 |
//$Id$ |
| 3 |
//gen openMairie le 10/02/2011 20:33 |
| 4 |
$reqmo['libelle']=' public.evenement'; |
| 5 |
$reqmo['reqmo_libelle']=' public.evenement'; |
| 6 |
$reqmo['sql']="select [evenement.evenement as evenement], |
| 7 |
[evenement.libelle as libelle], |
| 8 |
[dossier_autorisation_type_detaille.code as nature], |
| 9 |
[action], |
| 10 |
[etat], |
| 11 |
[delai], |
| 12 |
[accord_tacite], |
| 13 |
[delai_notification], |
| 14 |
[lettretype], |
| 15 |
[consultation] |
| 16 |
from ".DB_PREFIXE."evenement |
| 17 |
INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON |
| 18 |
evenement.evenement=lien_dossier_instruction_type_evenement.evenement |
| 19 |
INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON |
| 20 |
lien_dossier_instruction_type_evenement.dossier_instruction_type = |
| 21 |
dossier_instruction_type.dossier_instruction_type |
| 22 |
INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON |
| 23 |
dossier_instruction_type.dossier_autorisation_type_detaille = |
| 24 |
dossier_autorisation_type_detaille.dossier_autorisation_type_detaille |
| 25 |
where avis_decision = '[avis_decision]' order by [tri]"; |
| 26 |
$reqmo['evenement']='checked'; |
| 27 |
$reqmo['libelle']='checked'; |
| 28 |
$reqmo['nature']='checked'; |
| 29 |
$reqmo['action']='checked'; |
| 30 |
$reqmo['etat']='checked'; |
| 31 |
$reqmo['delai']='checked'; |
| 32 |
$reqmo['accord_tacite']='checked'; |
| 33 |
$reqmo['delai_notification']='checked'; |
| 34 |
$reqmo['avis_decision']="select avis_decision,libelle from ".DB_PREFIXE."avis_decision"; |
| 35 |
$reqmo['lettretype']='checked'; |
| 36 |
$reqmo['consultation']='checked'; |
| 37 |
$reqmo['tri']=array('evenement','libelle','nature','action','etat','delai','accord_tacite','delai_notification','lettretype','consultation'); |
| 38 |
?> |
Parent Directory
| 
Revision Log