sql/pgsql/evenement_action.reqmo.inc.php

<?php
//$Id$ 
//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],
                        [etat],
                        [delai],
                        [accord_tacite],
                        [delai_notification],
                        [avis_decision],
                        [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 action = '[action]' order by [tri]";
$reqmo['evenement']='checked';
$reqmo['libelle']='checked';
$reqmo['nature']='checked';
$reqmo['action']="select * from ".DB_PREFIXE."action";
$reqmo['etat']='checked';
$reqmo['delai']='checked';
$reqmo['accord_tacite']='checked';
$reqmo['delai_notification']='checked';
$reqmo['avis_decision']='checked';
$reqmo['lettretype']='checked';
$reqmo['consultation']='checked';
$reqmo['tri']=array('evenement','libelle','nature','etat','delai','accord_tacite','delai_notification','avis_decision','lettretype','consultation');
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:33
4			$reqmo['libelle']=' public.evenement';
5			$reqmo['reqmo_libelle']=' public.evenement';
6	nhaye	1138	$reqmo['sql']="select [evenement.evenement as evenement],
7			[evenement.libelle as libelle],
8			[dossier_autorisation_type_detaille.code as nature],
9			[etat],
10			[delai],
11			[accord_tacite],
12			[delai_notification],
13			[avis_decision],
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 action = '[action]' order by [tri]";
26	fraynaud	3	$reqmo['evenement']='checked';
27			$reqmo['libelle']='checked';
28			$reqmo['nature']='checked';
29			$reqmo['action']="select * from ".DB_PREFIXE."action";
30			$reqmo['etat']='checked';
31			$reqmo['delai']='checked';
32			$reqmo['accord_tacite']='checked';
33			$reqmo['delai_notification']='checked';
34	vpihour	489	$reqmo['avis_decision']='checked';
35	fraynaud	3	$reqmo['lettretype']='checked';
36			$reqmo['consultation']='checked';
37	vpihour	489	$reqmo['tri']=array('evenement','libelle','nature','etat','delai','accord_tacite','delai_notification','avis_decision','lettretype','consultation');
38	fraynaud	3	?>