/[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 1138 by nhaye, Thu Jan 3 15:18:21 2013 UTC revision 1355 by vpihour, Mon Mar 11 13:57:07 2013 UTC
# Line 47  where consultation.dossier = '".$id."'"; Line 47  where consultation.dossier = '".$id."'";
47  $sql_terrain ="SELECT   terrain.parcelle, ' ' as proprietaire, parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ".  $sql_terrain ="SELECT   terrain.parcelle, ' ' as proprietaire, parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ".
48          "where dossier = '".$id."'";          "where dossier = '".$id."'";
49    
   
 $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,  
                         shon_anterieure, shon_demolie, shon_anterieure_supprimee,  
                         shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee  
                         from ".DB_PREFIXE."destination_shon inner join ".  
                         DB_PREFIXE."destination on destination_shon.destination=destination.destination  
                         where dossier = '".$id."'";  
   
50  $sql_modificatif="select dossier,  $sql_modificatif="select dossier,
51  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,
52  demandeur_nom,etat from ".DB_PREFIXE."dossier  demandeur_nom,etat from ".DB_PREFIXE."dossier
Legend:
Removed from v.1138  
changed lines
  Added in v.1355
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26