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

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

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

revision 312 by atreal, Wed Mar 28 17:19:49 2012 UTC revision 489 by vpihour, Thu Oct 11 08:27:21 2012 UTC
# Line 14  $reqmo['sql']="select dossier, Line 14  $reqmo['sql']="select dossier,
14                      [to_char(date_limite,'DD/MM/YYYY') as date_limite],                      [to_char(date_limite,'DD/MM/YYYY') as date_limite],
15                      [accord_tacite],                      [accord_tacite],
16                      [to_char(date_decision,'DD/MM/YYYY') as date_decision],                      [to_char(date_decision,'DD/MM/YYYY') as date_decision],
17                      [avis],                      [avis_decision],
18                      [to_char(date_validite,'DD/MM/YYYY') as date_validite],                      [to_char(date_validite,'DD/MM/YYYY') as date_validite],
19                      [to_char(date_chantier,'DD/MM/YYYY') as date_chantier],                      [to_char(date_chantier,'DD/MM/YYYY') as date_chantier],
20                      [to_char(date_achevement,'DD/MM/YYYY') as date_achevement],                      [to_char(date_achevement,'DD/MM/YYYY') as date_achevement],
# Line 51  $reqmo['sql']="select dossier, Line 51  $reqmo['sql']="select dossier,
51                       from ".DB_PREFIXE."dossier left join ".DB_PREFIXE."travaux on travaux.travaux = dossier.travaux                       from ".DB_PREFIXE."dossier left join ".DB_PREFIXE."travaux on travaux.travaux = dossier.travaux
52                       left join ".DB_PREFIXE."categorie_demandeur on categorie_demandeur.categorie_demandeur= dossier.demandeur_categorie                       left join ".DB_PREFIXE."categorie_demandeur on categorie_demandeur.categorie_demandeur= dossier.demandeur_categorie
53                       where dossier.nature = '[selection]' and types ='Initial'                       where dossier.nature = '[selection]' and types ='Initial'
54                       and (avis like 'F%' or avis like 'T%')                       and (avis_decision like 'F%' or avis_decision like 'T%')
55                       order by [tri]";                       order by [tri]";
56    
57    
# Line 73  $reqmo['delai']="checked"; Line 73  $reqmo['delai']="checked";
73  $reqmo['date_limite']="checked";  $reqmo['date_limite']="checked";
74  $reqmo['accord_tacite']="checked";  $reqmo['accord_tacite']="checked";
75  $reqmo['date_decision']="checked";  $reqmo['date_decision']="checked";
76  $reqmo['avis']="checked";  $reqmo['avis_decision']="checked";
77  $reqmo['date_validite']="checked";  $reqmo['date_validite']="checked";
78  $reqmo['date_chantier']="checked";  $reqmo['date_chantier']="checked";
79  $reqmo['date_achevement']="checked";  $reqmo['date_achevement']="checked";
Legend:
Removed from v.312  
changed lines
  Added in v.489
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26