sql/pgsql/evenement_avis.reqmo.inc.php

<?php
//$Id: evenement_avis.reqmo.inc.php 4418 2015-02-24 17:30:28Z tbenita $ 
//gen openMairie le 10/02/2011 20:33 
$reqmo['libelle']=' public.evenement';
$reqmo['reqmo_libelle']=' public.evenement';
$reqmo['sql']="select [evenement.evenement as evenement],
                        [evenement.libelle as libelle],
                        [dossier_autorisation_type_detaille.code as nature],
                        [action],
                        [etat],
                        [delai],
                        [accord_tacite],
                        [delai_notification],
                        [lettretype],
                        [consultation]
                from ".DB_PREFIXE."evenement
                INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
                    evenement.evenement=lien_dossier_instruction_type_evenement.evenement
                INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON 
                    lien_dossier_instruction_type_evenement.dossier_instruction_type =
                    dossier_instruction_type.dossier_instruction_type
                INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON 
                    dossier_instruction_type.dossier_autorisation_type_detaille =
                    dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
                where avis_decision = '[avis_decision]' order by [tri]";
$reqmo['evenement']='checked';
$reqmo['libelle']='checked';
$reqmo['nature']='checked';
$reqmo['action']='checked';
$reqmo['etat']='checked';
$reqmo['delai']='checked';
$reqmo['accord_tacite']='checked';
$reqmo['delai_notification']='checked';
$reqmo['avis_decision']="select avis_decision,libelle from ".DB_PREFIXE."avis_decision";
$reqmo['lettretype']='checked';
$reqmo['consultation']='checked';
$reqmo['tri']=array('evenement','libelle','nature','action','etat','delai','accord_tacite','delai_notification','lettretype','consultation');
?>
1	mbroquet	3730	<?php
2			//$Id: evenement_avis.reqmo.inc.php 4418 2015-02-24 17:30:28Z tbenita $
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			?>