sql/pgsql/dossier_message.inc.php

<?php
//$Id$ 

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

// SELECT
$champAffiche = array(
    'dossier_message.message as "'._("message").'"',
    'dossier_message.dossier as "'._("dossier").'"',
    'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
    'dossier_message.type as "'._("type").'"',
    'dossier_message.emetteur as "'._("emetteur").'"',
    "case dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
    );
// Tri par date
$tri = "order by date_emission desc, lu";

/**
 * Gestion de l'affichage dans le contexte du dossier
 */
if ($retourformulaire == 'dossier'
    OR $retourformulaire == 'dossier_instruction'
    OR $retourformulaire == 'dossier_instruction_mes_encours'
    OR $retourformulaire == 'dossier_instruction_tous_encours'
    OR $retourformulaire == 'dossier_instruction_mes_clotures'
    OR $retourformulaire == 'dossier_instruction_tous_clotures') {
    // SELECT
    $champAffiche = array(
        'dossier_message.message as "'._("message").'"',
        'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
        'dossier_message.type as "'._("type").'"',
        'dossier_message.emetteur as "'._("emetteur").'"',
        "case dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
        );
    // Filtre sur le dossier
    $selection=" WHERE (dossier_message.dossier ='".$idx."')";
}

/**
 * Options
 */
// On affiche le champ lu en gras
$options[] = array(
    "type" => "condition",
    "field" => "case dossier_message.lu when 't' then 'Oui' else 'Non' end",
    "case" => array(
            "0" => array(
                "values" => array("Non", ),
                "style" => "non_lu",
                ),
            ),
);

?>
1	<?php
2	//$Id$
3
4	include('../gen/sql/pgsql/dossier_message.inc.php');
5
6	// SELECT
7	$champAffiche = array(
8	'dossier_message.message as "'._("message").'"',
9	'dossier_message.dossier as "'._("dossier").'"',
10	'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
11	'dossier_message.type as "'._("type").'"',
12	'dossier_message.emetteur as "'._("emetteur").'"',
13	"case dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
14	);
15	// Tri par date
16	$tri = "order by date_emission desc, lu";
17
18	/**
19	* Gestion de l'affichage dans le contexte du dossier
20	*/
21	if ($retourformulaire == 'dossier'
22	OR $retourformulaire == 'dossier_instruction'
23	OR $retourformulaire == 'dossier_instruction_mes_encours'
24	OR $retourformulaire == 'dossier_instruction_tous_encours'
25	OR $retourformulaire == 'dossier_instruction_mes_clotures'
26	OR $retourformulaire == 'dossier_instruction_tous_clotures') {
27	// SELECT
28	$champAffiche = array(
29	'dossier_message.message as "'._("message").'"',
30	'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
31	'dossier_message.type as "'._("type").'"',
32	'dossier_message.emetteur as "'._("emetteur").'"',
33	"case dossier_message.lu when 't' then 'Oui' else 'Non' end as \""._("lu")."\"",
34	);
35	// Filtre sur le dossier
36	$selection=" WHERE (dossier_message.dossier ='".$idx."')";
37	}
38
39	/**
40	* Options
41	*/
42	// On affiche le champ lu en gras
43	$options[] = array(
44	"type" => "condition",
45	"field" => "case dossier_message.lu when 't' then 'Oui' else 'Non' end",
46	"case" => array(
47	"0" => array(
48	"values" => array("Non", ),
49	"style" => "non_lu",
50	),
51	),
52	);
53
54	?>