/[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 624 by nhaye, Tue Nov 6 13:49:46 2012 UTC revision 625 by nhaye, Wed Nov 7 16:39:11 2012 UTC
# Line 17  $champAffiche=array( Line 17  $champAffiche=array(
17      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',      'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
18      'etat as "'._("etat").'"',      'etat as "'._("etat").'"',
19      'avis_decision.libelle as "'._("avis_decision").'"',      'avis_decision.libelle as "'._("avis_decision").'"',
20      'CASE WHEN dossier.enjeu_erp IS TRUE AND dossier.enjeu_urba IS TRUE THEN \'Tous\' ELSE      '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 ||
21          CASE WHEN dossier.enjeu_erp IS TRUE THEN \'Erp\' ELSE       CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
22              CASE WHEN dossier.enjeu_urba IS TRUE THEN \'Urba\' END END END as  "'._("enjeu").'"',       as "'._("enjeu").'"',
23  );  );
24    
25  $tri= "order by dossier.dossier";  $tri= "order by dossier.dossier";
Legend:
Removed from v.624  
changed lines
  Added in v.625
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26