| 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 |
|
|
$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 |
fraynaud |
242 |
FROM ".DB_PREFIXE."instruction INNER JOIN ".DB_PREFIXE."evenement ON evenement.evenement = instruction.evenement |
| 8 |
|
|
inner join ".DB_PREFIXE."dossier on instruction.dossier=dossier.dossier |
| 9 |
|
|
left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux |
| 10 |
fraynaud |
3 |
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 |
fraynaud |
242 |
$reqmo['instruction_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat"; |
| 24 |
|
|
$reqmo['dossier_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat"; |
| 25 |
fraynaud |
3 |
?> |
Parent Directory
| 
Revision Log