/[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

trunk/sql/pgsql/dossier.scr.inc revision 252 by fraynaud, Tue Nov 29 16:39:34 2011 UTC trunk/sql/pgsql/dossier.scr.inc.php revision 1127 by vpihour, Thu Dec 27 15:07:37 2012 UTC
# Line 14  to_char(date_conformite,'DD/MM/YYYY') as Line 14  to_char(date_conformite,'DD/MM/YYYY') as
14  to_char(date_complet,'DD/MM/YYYY') as date_complet,  to_char(date_complet,'DD/MM/YYYY') as date_complet,
15  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
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, travaux_complement, servitude,
18  amenagement,parcelle_lot_lotissement  amenagement,parcelle_lot_lotissement
19  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature
20  left join ".DB_PREFIXE."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 ".DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on evenement.evenement = instruction.evenement  to_char(date_evenement,'DD/MM/YYYY') as date_evenement  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_decision.libelle as avis_decision
31  from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service  from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service
32  left join ".DB_PREFIXE."avis on avis.avis=consultation.avis  left join ".DB_PREFIXE."avis_decision on avis_decision.avis_decision=consultation.avis_decision
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,
Legend:
Removed from v.252  
changed lines
  Added in v.1127
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26