/[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 489 by vpihour, Thu Oct 11 08:27:21 2012 UTC revision 1127 by vpihour, Thu Dec 27 15:07:37 2012 UTC
# Line 21  left join ".DB_PREFIXE."travaux on dossi Line 21  left join ".DB_PREFIXE."travaux on dossi
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,
Legend:
Removed from v.489  
changed lines
  Added in v.1127
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26