| 1 |
<?php |
| 2 |
//$Id$ |
| 3 |
//gen openMairie le 15/11/2012 18:30 |
| 4 |
|
| 5 |
include('../gen/sql/pgsql/dossier_message.inc.php'); |
| 6 |
|
| 7 |
$champAffiche = array( |
| 8 |
'dossier_message.message as "'._("message").'"', |
| 9 |
'dossier_message.type as "'._("type").'"', |
| 10 |
'dossier_message.emetteur as "'._("emetteur").'"', |
| 11 |
'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"', |
| 12 |
/*'CASE WHEN dossier.enjeu_erp IS TRUE AND dossier.enjeu_urba IS TRUE THEN \'Tous\' ELSE |
| 13 |
CASE WHEN dossier.enjeu_erp IS TRUE THEN \'Erp\' ELSE |
| 14 |
CASE WHEN dossier.enjeu_urba IS TRUE THEN \'Urba\' END END END as "'._("enjeu").'"',*/ |
| 15 |
'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 || |
| 16 |
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 |
| 17 |
as "'._("enjeu").'"', |
| 18 |
"case dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"", |
| 19 |
); |
| 20 |
|
| 21 |
|
| 22 |
if ($retourformulaire == 'dossier' |
| 23 |
OR $retourformulaire == 'PC' |
| 24 |
OR $retourformulaire == 'PA' |
| 25 |
OR $retourformulaire == 'PD' |
| 26 |
OR $retourformulaire == 'DP') { |
| 27 |
$selection=" WHERE (dossier_message.dossier ='".$idx."')"; |
| 28 |
$tri= ""; |
| 29 |
|
| 30 |
} |
| 31 |
|
| 32 |
?> |
Parent Directory
| 
Revision Log