/[openfoncier]/trunk/sql/pgsql/dossier.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/dossier.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 488 by fmichon, Fri Oct 5 12:22:13 2012 UTC revision 489 by vpihour, Thu Oct 11 08:27:21 2012 UTC
# Line 4  Line 4 
4  include('../gen/sql/pgsql/dossier.inc.php');  include('../gen/sql/pgsql/dossier.inc.php');
5  $table=DB_PREFIXE."dossier left join ".  $table=DB_PREFIXE."dossier left join ".
6         DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".         DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
7         DB_PREFIXE."avis on avis.avis=dossier.avis";         DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision";
8  $champAffiche=array(  $champAffiche=array(
9      'dossier.dossier as "'._("dossier").'"',      'dossier.dossier as "'._("dossier").'"',
10      'dossier.demandeur_nom as "'._("demandeur_nom").'"',      'dossier.demandeur_nom as "'._("demandeur_nom").'"',
# Line 15  $champAffiche=array( Line 15  $champAffiche=array(
15      'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',      'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',
16      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
17      'etat as "'._("etat").'"',      'etat as "'._("etat").'"',
18      'avis.libelle as "'._("avis").'"',      'avis_decision.libelle as "'._("avis_decision").'"',
19  );  );
20    
21  $tri= "order by dossier.dossier";  $tri= "order by dossier.dossier";
Legend:
Removed from v.488  
changed lines
  Added in v.489
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26