/[openfoncier]/branches/3.14.x/sql/pgsql/dossier.scr.inc.php
ViewVC logotype

Diff of /branches/3.14.x/sql/pgsql/dossier.scr.inc.php

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

trunk/sql/pgsql/dossier.scr.inc.php revision 1367 by nhaye, Mon Mar 11 17:57:35 2013 UTC branches/3.14.x/sql/pgsql/dossier.scr.inc.php revision 3343 by vpihour, Thu Mar 19 17:34:18 2015 UTC
# Line 4  $sql_dossier=" Line 4  $sql_dossier="
4  SELECT  SELECT
5  dossier,  dossier,
6  dossier_autorisation_type_detaille.libelle as nature,  dossier_autorisation_type_detaille.libelle as nature,
7  parcelle,  dossier.parcelle,
8  hauteur, shon, shob, batiment_nombre, logement_nombre, delai,  dossier.hauteur, dossier.shon, dossier.shob, dossier.batiment_nombre, dossier.logement_nombre, dossier.delai,
9  to_char(date_depot,'DD/MM/YYYY') as date_depot,  to_char(dossier.date_depot,'DD/MM/YYYY') as date_depot,
10  to_char(date_validite,'DD/MM/YYYY') as date_validite,  to_char(dossier.date_validite,'DD/MM/YYYY') as date_validite,
11  to_char(date_chantier,'DD/MM/YYYY') as date_chantier,  to_char(dossier.date_chantier,'DD/MM/YYYY') as date_chantier,
12  to_char(date_achevement,'DD/MM/YYYY') as date_achevement,  to_char(dossier.date_achevement,'DD/MM/YYYY') as date_achevement,
13  to_char(date_conformite,'DD/MM/YYYY') as date_conformite,  to_char(dossier.date_conformite,'DD/MM/YYYY') as date_conformite,
14  to_char(date_complet,'DD/MM/YYYY') as date_complet,  to_char(dossier.date_complet,'DD/MM/YYYY') as date_complet,
15  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,  to_char(dossier.date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
16  to_char(date_limite,'DD/MM/YYYY') as date_limite, servitude,  to_char(dossier.date_limite,'DD/MM/YYYY') as date_limite, servitude,
17  amenagement,parcelle_lot_lotissement  amenagement,parcelle_lot_lotissement
18  FROM ".DB_PREFIXE."dossier  FROM ".DB_PREFIXE."dossier
19  INNER JOIN ".DB_PREFIXE."dossier_autorisation  INNER JOIN ".DB_PREFIXE."dossier_autorisation
Legend:
Removed from v.1367  
changed lines
  Added in v.3343
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26