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	fraynaud	3	<?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	nhaye	1367	$reqmo['sql']= "SELECT instruction.dossier, evenement.libelle, instruction.etat as etat, [logement_nombre]
5	fraynaud	242	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	fraynaud	3	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	fraynaud	242	$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	fraynaud	3	?>