sql/pgsql/evenement_nature.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],
                        [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
                where dossier_instruction_type.dossier_autorisation_type_detaille = [nature]
                order by [tri]";
$reqmo['evenement']='checked';
$reqmo['libelle']='checked';
$reqmo['action']='checked';
$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['nature']="select dossier_autorisation_type_detaille,code from ".DB_PREFIXE."dossier_autorisation_type_detaille";

$reqmo['tri']=array('evenement','libelle','action','etat','delai','accord_tacite','delai_notification','avis_decision','lettretype','consultation');
?>
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	[etat],
9	[delai],
10	[accord_tacite],
11	[delai_notification],
12	[avis_decision],
13	[lettretype],
14	[consultation]
15	from ".DB_PREFIXE."evenement
16	INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
17	evenement.evenement=lien_dossier_instruction_type_evenement.evenement
18	INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
19	lien_dossier_instruction_type_evenement.dossier_instruction_type =
20	dossier_instruction_type.dossier_instruction_type
21	where dossier_instruction_type.dossier_autorisation_type_detaille = [nature]
22	order by [tri]";
23	$reqmo['evenement']='checked';
24	$reqmo['libelle']='checked';
25	$reqmo['action']='checked';
26	$reqmo['etat']='checked';
27	$reqmo['delai']='checked';
28	$reqmo['accord_tacite']='checked';
29	$reqmo['delai_notification']='checked';
30	$reqmo['avis_decision']='checked';
31	$reqmo['lettretype']='checked';
32	$reqmo['consultation']='checked';
33	$reqmo['nature']="select dossier_autorisation_type_detaille,code from ".DB_PREFIXE."dossier_autorisation_type_detaille";
34
35	$reqmo['tri']=array('evenement','libelle','action','etat','delai','accord_tacite','delai_notification','avis_decision','lettretype','consultation');
36	?>