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	mlimic	709	<?php
2			//$Id$
3
4			include('../gen/sql/pgsql/dossier_message.inc.php');
5
6	fmichon	878	// SELECT
7	mlimic	709	$champAffiche = array(
8			'dossier_message.message as "'._("message").'"',
9	fmichon	878	'dossier_message.dossier as "'._("dossier").'"',
10			'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
11	mlimic	709	'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	fmichon	878	// Tri par date
16			$tri = "order by date_emission desc, lu";
17	mlimic	709
18	fmichon	878	/**
19			* Gestion de l'affichage dans le contexte du dossier
20			*/
21	mlimic	709	if ($retourformulaire == 'dossier'
22	fmichon	878	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	mlimic	709	$selection=" WHERE (dossier_message.dossier ='".$idx."')";
37			}
38
39	fmichon	878	/**
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	mlimic	709	?>