sql/pgsql/instruction_observatoire.reqmo.inc.php

<?php
$reqmo['libelle']="Evenement etat cloturer";

$reqmo['sql']="select instruction.dossier,
                        dossier.demandeur_nom,
                        date_evenement,
                        [instruction.evenement as evenement],
                        evenement.libelle
                        from ".DB_PREFIXE."instruction 
                        inner join ".DB_PREFIXE."dossier on instruction.dossier = dossier.dossier
                        inner join ".DB_PREFIXE."evenement on instruction.evenement =evenement.evenement
                        INNER JOIN ".DB_PREFIXE."dossier_autorisation
                            ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation
                        INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
                            ON dossier_autorisation.dossier_autorisation_type_detaille 
                            = dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
                       where dossier_autorisation_type_detaille.code = '[selection]' and instruction.etat ='cloturer'";

$reqmo['evenement']="checked";

$reqmo['selection']= array('PCI','PCA','PD','DP','PA','CU','AZ','DAT');

?>
1	<?php
2	$reqmo['libelle']="Evenement etat cloturer";
3
4	$reqmo['sql']="select instruction.dossier,
5	dossier.demandeur_nom,
6	date_evenement,
7	[instruction.evenement as evenement],
8	evenement.libelle
9	from ".DB_PREFIXE."instruction
10	inner join ".DB_PREFIXE."dossier on instruction.dossier = dossier.dossier
11	inner join ".DB_PREFIXE."evenement on instruction.evenement =evenement.evenement
12	INNER JOIN ".DB_PREFIXE."dossier_autorisation
13	ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation
14	INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
15	ON dossier_autorisation.dossier_autorisation_type_detaille
16	= dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
17	where dossier_autorisation_type_detaille.code = '[selection]' and instruction.etat ='cloturer'";
18
19	$reqmo['evenement']="checked";
20
21	$reqmo['selection']= array('PCI','PCA','PD','DP','PA','CU','AZ','DAT');
22
23	?>