sql/pgsql/instruction_etat.reqmo.inc.php

<?php
// $Id: instruction_etat.reqmo.inc,v 1.2 2009-12-15 09:19:01 fraynaud Exp $
$reqmo['libelle']="dossier evenement par rapport a un etat";
$reqmo['sql']= "SELECT instruction.dossier, evenement.libelle, instruction.etat as etat, [logement_nombre] 
FROM  ".DB_PREFIXE."instruction INNER  JOIN ".DB_PREFIXE."evenement ON evenement.evenement = instruction.evenement 
inner join ".DB_PREFIXE."dossier on instruction.dossier=dossier.dossier
WHERE instruction.etat =  '[instruction_etat]' and dossier.etat = '[dossier_etat]'";

//$reqmo['selection']= array('PC','PD','DP','PA','CU');
//$reqmo['tri']= array('dossier','etat','demandeur_nom');
$reqmo['logement_nombre']="checked";
$reqmo['instruction_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
$reqmo['dossier_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
?>
1	<?php
2	// $Id: instruction_etat.reqmo.inc,v 1.2 2009-12-15 09:19:01 fraynaud Exp $
3	$reqmo['libelle']="dossier evenement par rapport a un etat";
4	$reqmo['sql']= "SELECT instruction.dossier, evenement.libelle, instruction.etat as etat, [logement_nombre]
5	FROM ".DB_PREFIXE."instruction INNER JOIN ".DB_PREFIXE."evenement ON evenement.evenement = instruction.evenement
6	inner join ".DB_PREFIXE."dossier on instruction.dossier=dossier.dossier
7	WHERE instruction.etat = '[instruction_etat]' and dossier.etat = '[dossier_etat]'";
8
9	//$reqmo['selection']= array('PC','PD','DP','PA','CU');
10	//$reqmo['tri']= array('dossier','etat','demandeur_nom');
11	$reqmo['logement_nombre']="checked";
12	$reqmo['instruction_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
13	$reqmo['dossier_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
14	?>