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	fraynaud	184	<?php
2	nhaye	1138	$reqmo['libelle']="Evenement etat cloturer";
3
4	fraynaud	184	$reqmo['sql']="select instruction.dossier,
5			dossier.demandeur_nom,
6	vpihour	1127	date_evenement,
7	fraynaud	184	[instruction.evenement as evenement],
8	nhaye	1192	evenement.libelle
9	nhaye	1138	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	fraynaud	184	$reqmo['evenement']="checked";
20	nhaye	1138
21			$reqmo['selection']= array('PCI','PCA','PD','DP','PA','CU','AZ','DAT');
22
23			?>