sql/pgsql/dossier_message.inc.php

<?php
//$Id$ 
//gen openMairie le 15/11/2012 18:30

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

$champAffiche = array(
    'dossier_message.message as "'._("message").'"',
    'dossier_message.type as "'._("type").'"',
    'dossier_message.emetteur as "'._("emetteur").'"',
    'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
    "case dossier_message.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 (dossier_message.dossier ='".$idx."')";
    $tri= "";

}

?>
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 dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
13	);
14
15
16	if ($retourformulaire == 'dossier'
17	OR $retourformulaire == 'PC'
18	OR $retourformulaire == 'PA'
19	OR $retourformulaire == 'PD'
20	OR $retourformulaire == 'DP') {
21	$selection=" WHERE (dossier_message.dossier ='".$idx."')";
22	$tri= "";
23
24	}
25
26	?>