/[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 242 by fraynaud, Wed Nov 23 19:39:04 2011 UTC revision 252 by fraynaud, Tue Nov 29 16:39:34 2011 UTC
# Line 32  from ".DB_PREFIXE."consultation inner jo Line 32  from ".DB_PREFIXE."consultation inner jo
32  left join ".DB_PREFIXE."avis on avis.avis=consultation.avis  left join ".DB_PREFIXE."avis on avis.avis=consultation.avis
33  where consultation.dossier = '".$id."'";  where consultation.dossier = '".$id."'";
34    
35  $sql_terrain ="SELECT   terrain.parcelle, (proprietaire.nom|| ' '||  proprietaire.prenom) as proprietaire,  //$sql_terrain ="SELECT   terrain.parcelle, (proprietaire.nom|| ' '||  proprietaire.prenom) as proprietaire,
36  parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle left join ".  //parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle left join ".
37  DB_PREFIXE."proprietaire on proprietaire.proprietaire = parcelle.proprietaire  //DB_PREFIXE."proprietaire on proprietaire.proprietaire = parcelle.proprietaire
38  where dossier = '".$id."'";  //where dossier = '".$id."'";
39    
40    $sql_terrain ="SELECT   terrain.parcelle, ' ' as proprietaire, parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ".
41            "where dossier = '".$id."'";
42    
43    
44  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,
45                          shon_anterieure, shon_demolie, shon_anterieure_supprimee,                          shon_anterieure, shon_demolie, shon_anterieure_supprimee,
Legend:
Removed from v.242  
changed lines
  Added in v.252
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26