/[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 649 by nhaye, Fri Nov 9 16:43:47 2012 UTC revision 681 by fmichon, Wed Nov 14 07:09:49 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."instructeur on dossier.instructeur = instructeur.instructeur left join ".         DB_PREFIXE."instructeur on dossier.instructeur = instructeur.instructeur left join ".
7         DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision";         DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision
8    LEFT JOIN ".DB_PREFIXE."division
9        on dossier.division=division.division";
10    
11  $champAffiche=array(  $champAffiche=array(
12      'dossier.dossier as "'._("dossier").'"',      'dossier.dossier as "'._("dossier").'"',
13      'dossier.demandeur_nom as "'._("demandeur_nom").'"',      'dossier.demandeur_nom as "'._("demandeur_nom").'"',
# Line 16  $champAffiche=array( Line 19  $champAffiche=array(
19      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
20      'etat as "'._("etat").'"',      'etat as "'._("etat").'"',
21      'avis_decision.libelle as "'._("avis_decision").'"',      'avis_decision.libelle as "'._("avis_decision").'"',
22      'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END ||      'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END ||
23       CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END       CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
24       as "'._("enjeu").'"',       as "'._("enjeu").'"',
25  );  );
26    
Legend:
Removed from v.649  
changed lines
  Added in v.681
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26