/[openfoncier]/trunk/sql/pgsql/instruction_etat.reqmo.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/instruction_etat.reqmo.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 3 by fraynaud, Thu Feb 10 20:46:18 2011 UTC revision 242 by fraynaud, Wed Nov 23 19:39:04 2011 UTC
# Line 4  $reqmo['libelle']="dossier evenement par Line 4  $reqmo['libelle']="dossier evenement par
4  $reqmo['sql']= "SELECT instruction.dossier, evenement.libelle, instruction.etat as etat, [travaux.libelle as travaux],  $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],  [terrain_numero], [terrain_numero_complement], [terrain_adresse], [terrain_adresse_complement], [terrain_cp], [terrain_ville],
6  [rivoli], [logement_nombre]  [rivoli], [logement_nombre]
7  FROM  instruction INNER  JOIN evenement ON evenement.evenement = instruction.evenement  FROM  ".DB_PREFIXE."instruction INNER  JOIN ".DB_PREFIXE."evenement ON evenement.evenement = instruction.evenement
8  inner join dossier on instruction.dossier=dossier.dossier  inner join ".DB_PREFIXE."dossier on instruction.dossier=dossier.dossier
9  left join travaux on dossier.travaux=travaux.travaux  left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux
10  WHERE instruction.etat =  '[instruction_etat]' and dossier.etat = '[dossier_etat]'";  WHERE instruction.etat =  '[instruction_etat]' and dossier.etat = '[dossier_etat]'";
11    
12  //$reqmo['selection']= array('PC','PD','DP','PA','CU');  //$reqmo['selection']= array('PC','PD','DP','PA','CU');
# Line 20  $reqmo['terrain_cp']="checked"; Line 20  $reqmo['terrain_cp']="checked";
20  $reqmo['terrain_ville']="checked";  $reqmo['terrain_ville']="checked";
21  $reqmo['rivoli']="checked";  $reqmo['rivoli']="checked";
22  $reqmo['logement_nombre']="checked";  $reqmo['logement_nombre']="checked";
23  $reqmo['instruction_etat']="select etat,libelle from etat order by etat";  $reqmo['instruction_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
24  $reqmo['dossier_etat']="select etat,libelle from etat order by etat";  $reqmo['dossier_etat']="select etat,libelle from ".DB_PREFIXE."etat order by etat";
25  ?>  ?>
Legend:
Removed from v.3  
changed lines
  Added in v.242
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26