/[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 152 by fraynaud, Thu Sep 29 15:23:51 2011 UTC revision 197 by fraynaud, Sun Oct 16 19:03:32 2011 UTC
# Line 26  where dossier = '".$id."'"; Line 26  where dossier = '".$id."'";
26    
27  $sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi,  $sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi,
28  to_char(date_retour,'DD/MM/YYYY') as retour,  to_char(date_retour,'DD/MM/YYYY') as retour,
29  to_char(date_limite,'DD/MM/YYYY') as limite  to_char(date_limite,'DD/MM/YYYY') as limite,
30    avis.libelle as avis
31  from consultation inner join service on service.service = consultation.service  from consultation inner join service on service.service = consultation.service
32  left join avis on avis.avis=consultation.avis  left join avis on avis.avis=consultation.avis
33  where consultation.dossier = '".$id."'";  where consultation.dossier = '".$id."'";
# Line 35  $sql_terrain ="SELECT   terrain.parcelle Line 36  $sql_terrain ="SELECT   terrain.parcelle
36  parcelle.surface  from terrain inner join parcelle on terrain.parcelle = parcelle.parcelle left join proprietaire on proprietaire.proprietaire = parcelle.proprietaire  parcelle.surface  from terrain inner join parcelle on terrain.parcelle = parcelle.parcelle left join proprietaire on proprietaire.proprietaire = parcelle.proprietaire
37  where dossier = '".$id."'";  where dossier = '".$id."'";
38    
39  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon  from destination_shon inner join destination on destination_shon.destination=destination.destination  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,
40                            shon_anterieure, shon_demolie, shon_anterieure_supprimee,
41                            shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee
42                            from destination_shon inner join destination on destination_shon.destination=destination.destination
43  where dossier = '".$id."'";  where dossier = '".$id."'";
44    
45  $sql_modificatif="select dossier,  $sql_modificatif="select dossier,
46  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,
47  demandeur_nom,etat from dossier  demandeur_nom,etat from dossier
48  where substring(dossier,1,9) like substring('".$id."',1,9)";  where substring(dossier,1,9) like substring('".$id."',1,9)";
49    
50    $sql_statistique= "select * from statistique where dossier='".$id."'";
51    
52  ?>  ?>
Legend:
Removed from v.152  
changed lines
  Added in v.197
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26