sql/pgsql/messages_mes_retours.inc.php

<?php

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

//
$ent = _("instruction")." -> "._("mes messages");

//
$tab_description = _("Les messages non lus qui".
                     " concernent des dossiers d'instruction dont je suis".
                     " l'instructeur.");

//
$champAffiche = array(
    'dossier_message.message as "'._("message").'"',
    'dossier_message.dossier as "'._("dossier").'"',
    'dossier_message.type as "'._("type").'"',
    'dossier_message.emetteur as "'._("emetteur").'"',
    'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
    '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_urba-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
     as "'._("enjeu").'"',
    );

$table = DB_PREFIXE."dossier_message
    LEFT JOIN ".DB_PREFIXE."dossier 
        ON dossier_message.dossier=dossier.dossier
    LEFT JOIN ".DB_PREFIXE."instructeur 
        ON instructeur.instructeur=dossier.instructeur
    LEFT JOIN ".DB_PREFIXE."om_utilisateur
        ON instructeur.om_utilisateur = om_utilisateur.om_utilisateur";

//
$selection=" WHERE
dossier_message.lu IS FALSE
AND om_utilisateur.login='".$_SESSION['login']."'";

$tri="ORDER BY dossier.enjeu_erp DESC, dossier.enjeu_urba DESC, dossier_message.date_emission ASC";

$tab_actions['corner']['ajouter']=NULL;
$tab_actions['left']['consulter']=array('lien' => '../spg/direct_link.php?obj=dossier_instruction_mes_encours&amp;action=3'.
                    '&amp;direct_field=dossier&direct_form=dossier_message&direct_action=3&direct_idx=',
          'id' => '',
          'lib' => '<span class="om-icon om-icon-16 om-icon-fix consult-16" title="'._('Consulter').'">'._('Consulter').'</span>',
          'rights' => array('list' => array($obj, $obj.'_consulter'), 'operator' => 'OR'),
          'ordre' => 10,);


$champRecherche = array(
    'dossier.dossier as "'._("dossier").'"',
    );


$tab_actions['content'] = $tab_actions['left']['consulter'];


$champs = array();


$champs['dossier'] = array(
    'table' => 'dossier_message',
    'colonne' => 'dossier',
    'type' => 'text',
    'libelle' => _('Dossier'));

$champs['type'] = array(
    'table' => 'dossier_message',
    'colonne' => 'type',
    'type' => 'select',
    'libelle' => _('Type message'));

$champs['emetteur'] =
    array('colonne' => 'emetteur',
          'table' => 'dossier_message',
          'libelle' => _('Emetteur'),
          'type' => 'text');
    
$champs['date_emission'] =
    array('colonne' => 'date_emission',
          'table' => 'dossier_message',
          'libelle' => _('Date d\'emission'),
          'type' => 'date',
          'where' => 'intervaldate');

$options_enjeu = array();
$options_enjeu[0] = array("", "true", "false");
$options_enjeu[1] = array(_("Tous"), _("Oui"), _("Non"));
$champs['enjeu_erp'] =
    array('colonne' => 'enjeu_erp',
          'table' => 'dossier',
          'libelle' => _('Dossier enjeu ERP'),
          "subtype" => "manualselect",
          'type' => 'select',
          "args" => $options_enjeu);

$champs['enjeu_urba'] =
    array('colonne' => 'enjeu_urba',
          'table' => 'dossier',
          'libelle' => _('Dossier enjeu URBA'),
          'type' => 'select',
          "subtype" => "manualselect",
          "args" => $options_enjeu);

$options[] =  array('type' => 'search',
                     'display' => true,
                     'advanced' => $champs,
                     'absolute_object' => 'dossier_message');
?>
1	mlimic	599	<?php
2	fmichon	656
3			//
4	mlimic	712	include('../gen/sql/pgsql/dossier_message.inc.php');
5	mlimic	599
6	fmichon	656	//
7			$ent = _("instruction")." -> "._("mes messages");
8
9			//
10			$tab_description = _("Les messages non lus qui".
11			" concernent des dossiers d'instruction dont je suis".
12			" l'instructeur.");
13
14			//
15	mlimic	599	$champAffiche = array(
16	mlimic	712	'dossier_message.message as "'._("message").'"',
17			'dossier_message.dossier as "'._("dossier").'"',
18			'dossier_message.type as "'._("type").'"',
19			'dossier_message.emetteur as "'._("emetteur").'"',
20			'to_char(dossier_message.date_emission ,\'DD/MM/YYYY\') as "'._("date_emission").'"',
21	nhaye	650	'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 \|\|
22			CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END
23	nhaye	625	as "'._("enjeu").'"',
24	mlimic	599	);
25
26	mlimic	712	$table = DB_PREFIXE."dossier_message
27	mlimic	628	LEFT JOIN ".DB_PREFIXE."dossier
28	mlimic	712	ON dossier_message.dossier=dossier.dossier
29	mlimic	628	LEFT JOIN ".DB_PREFIXE."instructeur
30			ON instructeur.instructeur=dossier.instructeur
31			LEFT JOIN ".DB_PREFIXE."om_utilisateur
32			ON instructeur.om_utilisateur = om_utilisateur.om_utilisateur";
33	mlimic	599
34	fmichon	890	//
35			$selection=" WHERE
36			dossier_message.lu IS FALSE
37			AND om_utilisateur.login='".$_SESSION['login']."'";
38
39	mlimic	712	$tri="ORDER BY dossier.enjeu_erp DESC, dossier.enjeu_urba DESC, dossier_message.date_emission ASC";
40	mlimic	599
41			$tab_actions['corner']['ajouter']=NULL;
42	fmichon	895	$tab_actions['left']['consulter']=array('lien' => '../spg/direct_link.php?obj=dossier_instruction_mes_encours&action=3'.
43	mlimic	712	'&direct_field=dossier&direct_form=dossier_message&direct_action=3&direct_idx=',
44	mlimic	609	'id' => '',
45			'lib' => '<span class="om-icon om-icon-16 om-icon-fix consult-16" title="'._('Consulter').'">'._('Consulter').'</span>',
46			'rights' => array('list' => array($obj, $obj.'_consulter'), 'operator' => 'OR'),
47			'ordre' => 10,);
48	mlimic	612
49	mlimic	628
50	mlimic	599	$champRecherche = array(
51			'dossier.dossier as "'._("dossier").'"',
52			);
53
54
55	fmichon	895	$tab_actions['content'] = $tab_actions['left']['consulter'];
56	mlimic	599
57	mlimic	628
58	mlimic	599	$champs = array();
59
60
61	mlimic	634	$champs['dossier'] = array(
62	mlimic	712	'table' => 'dossier_message',
63	mlimic	628	'colonne' => 'dossier',
64	mlimic	599	'type' => 'text',
65	mlimic	628	'libelle' => _('Dossier'));
66	mlimic	599
67	mlimic	634	$champs['type'] = array(
68	mlimic	712	'table' => 'dossier_message',
69	mlimic	628	'colonne' => 'type',
70			'type' => 'select',
71			'libelle' => _('Type message'));
72
73	mlimic	634	$champs['emetteur'] =
74	mlimic	628	array('colonne' => 'emetteur',
75	mlimic	712	'table' => 'dossier_message',
76	mlimic	628	'libelle' => _('Emetteur'),
77			'type' => 'text');
78	mlimic	634
79			$champs['date_emission'] =
80	mlimic	628	array('colonne' => 'date_emission',
81	mlimic	712	'table' => 'dossier_message',
82	mlimic	628	'libelle' => _('Date d\'emission'),
83	mlimic	599	'type' => 'date',
84			'where' => 'intervaldate');
85
86	mlimic	628	$options_enjeu = array();
87			$options_enjeu[0] = array("", "true", "false");
88			$options_enjeu[1] = array(_("Tous"), _("Oui"), _("Non"));
89	mlimic	634	$champs['enjeu_erp'] =
90	mlimic	628	array('colonne' => 'enjeu_erp',
91			'table' => 'dossier',
92			'libelle' => _('Dossier enjeu ERP'),
93			"subtype" => "manualselect",
94			'type' => 'select',
95			"args" => $options_enjeu);
96
97	mlimic	634	$champs['enjeu_urba'] =
98	mlimic	628	array('colonne' => 'enjeu_urba',
99			'table' => 'dossier',
100			'libelle' => _('Dossier enjeu URBA'),
101			'type' => 'select',
102			"subtype" => "manualselect",
103			"args" => $options_enjeu);
104
105	mlimic	599	$options[] = array('type' => 'search',
106			'display' => true,
107			'advanced' => $champs,
108	mlimic	712	'absolute_object' => 'dossier_message');
109	mlimic	634	?>