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

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

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

revision 184 by fraynaud, Mon Oct 10 15:07:38 2011 UTC revision 242 by fraynaud, Wed Nov 23 19:39:04 2011 UTC
# Line 2  Line 2 
2  $reqmo['libelle']=" Evenement �tat cloturer";  $reqmo['libelle']=" Evenement �tat cloturer";
3  $reqmo['sql']="select instruction.dossier,  $reqmo['sql']="select instruction.dossier,
4                          dossier.demandeur_nom,                          dossier.demandeur_nom,
5                     datecourrier,                          datecourrier,
6                          [instruction.evenement as evenement],                          [instruction.evenement as evenement],
7                          libelle                            libelle  
8                         from instruction inner join dossier on instruction.dossier = dossier.dossier                         from ".DB_PREFIXE."instruction inner join ".DB_PREFIXE."dossier on instruction.dossier = dossier.dossier
9                         inner join evenement on instruction.evenement =evenement.evenement                         inner join ".DB_PREFIXE."evenement on instruction.evenement =evenement.evenement
10                         where dossier.nature = '[SELECTION]' and instruction.etat ='cloturer'";                         where dossier.nature = '[SELECTION]' and instruction.etat ='cloturer'";
11  $reqmo['SELECTION']= array('PC','PD','DP','PA','CU');  $reqmo['SELECTION']= array('PC','PD','DP','PA','CU');
12  $reqmo['evenement']="checked";  $reqmo['evenement']="checked";
Legend:
Removed from v.184  
changed lines
  Added in v.242
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26