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, [travaux.libelle as travaux],
[terrain_numero], [terrain_numero_complement], [terrain_adresse], [terrain_adresse_complement], [terrain_cp], [terrain_ville],
[rivoli], [logement_nombre] 
FROM  instruction INNER  JOIN evenement ON evenement.evenement = instruction.evenement 
inner join dossier on instruction.dossier=dossier.dossier
left join travaux on dossier.travaux=travaux.travaux
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['travaux']="checked";
$reqmo['terrain_numero']="checked";
$reqmo['terrain_numero_complement']="checked";
$reqmo['terrain_adresse']="checked";
$reqmo['terrain_adresse_complement']="checked";
$reqmo['terrain_cp']="checked";
$reqmo['terrain_ville']="checked";
$reqmo['rivoli']="checked";
$reqmo['logement_nombre']="checked";
$reqmo['instruction_etat']="select etat,libelle from etat order by etat";
$reqmo['dossier_etat']="select etat,libelle from 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, [travaux.libelle as travaux],
5	[terrain_numero], [terrain_numero_complement], [terrain_adresse], [terrain_adresse_complement], [terrain_cp], [terrain_ville],
6	[rivoli], [logement_nombre]
7	FROM instruction INNER JOIN evenement ON evenement.evenement = instruction.evenement
8	inner join dossier on instruction.dossier=dossier.dossier
9	left join travaux on dossier.travaux=travaux.travaux
10	WHERE instruction.etat = '[instruction_etat]' and dossier.etat = '[dossier_etat]'";
11
12	//$reqmo['selection']= array('PC','PD','DP','PA','CU');
13	//$reqmo['tri']= array('dossier','etat','demandeur_nom');
14	$reqmo['travaux']="checked";
15	$reqmo['terrain_numero']="checked";
16	$reqmo['terrain_numero_complement']="checked";
17	$reqmo['terrain_adresse']="checked";
18	$reqmo['terrain_adresse_complement']="checked";
19	$reqmo['terrain_cp']="checked";
20	$reqmo['terrain_ville']="checked";
21	$reqmo['rivoli']="checked";
22	$reqmo['logement_nombre']="checked";
23	$reqmo['instruction_etat']="select etat,libelle from etat order by etat";
24	$reqmo['dossier_etat']="select etat,libelle from etat order by etat";
25	?>