/[openfoncier]/trunk/sql/pgsql/dossier.scr.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/dossier.scr.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 314 by atreal, Wed Mar 28 17:36:38 2012 UTC
# Line 14  to_char(date_conformite,'DD/MM/YYYY') as Line 14  to_char(date_conformite,'DD/MM/YYYY') as
14  to_char(date_complet,'DD/MM/YYYY') as date_complet,  to_char(date_complet,'DD/MM/YYYY') as date_complet,
15  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
16  to_char(date_limite,'DD/MM/YYYY') as date_limite,  to_char(date_limite,'DD/MM/YYYY') as date_limite,
17  travaux.libelle as travaux, servitude,  travaux.libelle as travaux, travaux_complement, servitude,
18  amenagement,parcelle_lot_lotissement  amenagement,parcelle_lot_lotissement
19  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature
20  left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux  left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux
Legend:
Removed from v.312  
changed lines
  Added in v.314
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26