sql/pgsql/instruction_observatoire.reqmo.inc.php

<?php
$reqmo['libelle']=" Evenement état cloturer";
$reqmo['sql']="select instruction.dossier,
                        dossier.demandeur_nom,
                        datecourrier,
                        [instruction.evenement as 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
                       where dossier.nature = '[SELECTION]' and instruction.etat ='cloturer'";
$reqmo['SELECTION']= array('PC','PD','DP','PA','CU');
$reqmo['evenement']="checked";
?>
1	<?php
2	$reqmo['libelle']=" Evenement état cloturer";
3	$reqmo['sql']="select instruction.dossier,
4	dossier.demandeur_nom,
5	datecourrier,
6	[instruction.evenement as evenement],
7	libelle
8	from ".DB_PREFIXE."instruction inner join ".DB_PREFIXE."dossier on instruction.dossier = dossier.dossier
9	inner join ".DB_PREFIXE."evenement on instruction.evenement =evenement.evenement
10	where dossier.nature = '[SELECTION]' and instruction.etat ='cloturer'";
11	$reqmo['SELECTION']= array('PC','PD','DP','PA','CU');
12	$reqmo['evenement']="checked";
13	?>