sql/pgsql/messages.inc.php

<?php
//$Id$ 
//gen openMairie le 06/11/2012 12:04

include('../gen/sql/pgsql/messages.inc.php');

//$tab_actions['corner']['ajouter'] = NULL;


$champAffiche = array(
    'messages.message as "'._("message").'"',
    //'dossier.nature as "'._("dossier").'"',
    'messages.type as "'._("type").'"',
    'messages.emetteur as "'._("emetteur").'"',
    //'messages.date_emission as "'._("date_emission").'"',
    'to_char(messages.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
    //'messages.enjeux_erp as "'._("enjeux_erp").'"',
    //'messages.enjeux_urba as "'._("enjeux_urba").'"',
    /*'CASE WHEN dossier.enjeu_erp IS TRUE AND dossier.enjeu_urba IS TRUE THEN \'Tous\' ELSE
        CASE WHEN dossier.enjeu_erp IS TRUE THEN \'Erp\' ELSE
            CASE WHEN dossier.enjeu_urba IS TRUE THEN \'Urba\' END END END as  "'._("enjeu").'"',*/
    '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 ||
     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
     as "'._("enjeu").'"',
    "case messages.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
    );

    
if ($retourformulaire == 'dossier'
        OR $retourformulaire == 'PC'
        OR $retourformulaire == 'PA'
        OR $retourformulaire == 'PD'
        OR $retourformulaire == 'DP') {
    $selection=" WHERE (messages.dossier ='".$idx."')";
    // ordering only by messages.enjux_erp, may need to change this so that
    //  ordering is done by messages.enjeux_urba = true as well
    $tri= ""; //ORDER BY CASE messages.enjeux_erp WHEN true THEN 1 WHEN false THEN 2 END, messages.date_emission ASC";

}

?>
1	<?php
2	//$Id$
3	//gen openMairie le 06/11/2012 12:04
4
5	include('../gen/sql/pgsql/messages.inc.php');
6
7	//$tab_actions['corner']['ajouter'] = NULL;
8
9
10	$champAffiche = array(
11	'messages.message as "'._("message").'"',
12	//'dossier.nature as "'._("dossier").'"',
13	'messages.type as "'._("type").'"',
14	'messages.emetteur as "'._("emetteur").'"',
15	//'messages.date_emission as "'._("date_emission").'"',
16	'to_char(messages.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
17	//'messages.enjeux_erp as "'._("enjeux_erp").'"',
18	//'messages.enjeux_urba as "'._("enjeux_urba").'"',
19	/*'CASE WHEN dossier.enjeu_erp IS TRUE AND dossier.enjeu_urba IS TRUE THEN \'Tous\' ELSE
20	CASE WHEN dossier.enjeu_erp IS TRUE THEN \'Erp\' ELSE
21	CASE WHEN dossier.enjeu_urba IS TRUE THEN \'Urba\' END END END as "'._("enjeu").'"',*/
22	'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_erp-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
24	as "'._("enjeu").'"',
25	"case messages.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
26	);
27
28
29	if ($retourformulaire == 'dossier'
30	OR $retourformulaire == 'PC'
31	OR $retourformulaire == 'PA'
32	OR $retourformulaire == 'PD'
33	OR $retourformulaire == 'DP') {
34	$selection=" WHERE (messages.dossier ='".$idx."')";
35	// ordering only by messages.enjux_erp, may need to change this so that
36	// ordering is done by messages.enjeux_urba = true as well
37	$tri= ""; //ORDER BY CASE messages.enjeux_erp WHEN true THEN 1 WHEN false THEN 2 END, messages.date_emission ASC";
38
39	}
40
41	?>