/[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 197 by fraynaud, Sun Oct 16 19:03:32 2011 UTC revision 242 by fraynaud, Wed Nov 23 19:39:04 2011 UTC
# Line 16  to_char(date_notification_delai,'DD/MM/Y Line 16  to_char(date_notification_delai,'DD/MM/Y
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, servitude,
18  amenagement,parcelle_lot_lotissement  amenagement,parcelle_lot_lotissement
19  from dossier inner join nature on nature.nature = dossier.nature  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature
20  left join travaux on dossier.travaux=travaux.travaux  left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux
21  where dossier =  '".$id."'";  where dossier =  '".$id."'";
22    
23  $sql_instruction="SELECT  instruction,evenement.libelle as evenement,  instruction.lettretype,  $sql_instruction="SELECT  instruction,evenement.libelle as evenement,  instruction.lettretype,
24  to_char(datecourrier,'DD/MM/YYYY') as datecourrier  from instruction inner join evenement on evenement.evenement = instruction.evenement  to_char(datecourrier,'DD/MM/YYYY') as datecourrier  from ".DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on evenement.evenement = instruction.evenement
25  where dossier = '".$id."'";  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  avis.libelle as avis
31  from consultation inner join service on service.service = consultation.service  from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service
32  left join 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 terrain inner join parcelle on terrain.parcelle = parcelle.parcelle left join proprietaire on proprietaire.proprietaire = parcelle.proprietaire  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
38  where dossier = '".$id."'";  where dossier = '".$id."'";
39    
40  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,  $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,
41                          shon_anterieure, shon_demolie, shon_anterieure_supprimee,                          shon_anterieure, shon_demolie, shon_anterieure_supprimee,
42                          shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee                          shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee
43                          from destination_shon inner join destination on destination_shon.destination=destination.destination                          from ".DB_PREFIXE."destination_shon inner join ".
44  where dossier = '".$id."'";                          DB_PREFIXE."destination on destination_shon.destination=destination.destination
45                            where dossier = '".$id."'";
46    
47  $sql_modificatif="select dossier,  $sql_modificatif="select dossier,
48  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,
49  demandeur_nom,etat from dossier  demandeur_nom,etat from ".DB_PREFIXE."dossier
50  where substring(dossier,1,9) like substring('".$id."',1,9)";  where substring(dossier,1,9) like substring('".$id."',1,9)";
51    
52  $sql_statistique= "select * from statistique where dossier='".$id."'";  $sql_statistique= "select * from ".DB_PREFIXE."statistique where dossier='".$id."'";
53    
54  ?>  ?>
Legend:
Removed from v.197  
changed lines
  Added in v.242
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26