/[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 25 by fraynaud, Mon Jul 18 15:36:44 2011 UTC revision 126 by fraynaud, Tue Sep 20 15:12:14 2011 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  travaux.libelle as travaux, servitude
18  from dossier inner join nature on nature.nature = dossier.nature  from dossier inner join nature on nature.nature = dossier.nature
19  left join travaux on dossier.travaux=travaux.travaux  left join travaux on dossier.travaux=travaux.travaux
20  where dossier =  '".$id."'";  where dossier =  '".$id."'";
Legend:
Removed from v.25  
changed lines
  Added in v.126
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26