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	mlimic	709	<?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			?>