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