sql/pgsql/messages_tous_retours.inc.php

<?php

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

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

//
$tab_description = _("Les messages non lus qui".
                     " concernent des dossiers d'instruction situes dans ma".
                     " division.");
//
$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").'"',
    'instructeur.nom as "'._("instructeur").'"',
    'CASE WHEN dossier.enjeu_erp IS TRUE THEN \'<span class="enjeu">ERP</span>\' ELSE \'\' END ||
    CASE WHEN dossier.enjeu_urba IS TRUE THEN \'<span class="enjeu">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 dossier.division = ".$_SESSION['division']."";

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

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

$tab_actions['corner']['ajouter']=NULL;
$tab_actions['left']['consulter']=array('lien' => '../spg/direct_link.php?obj=dossier_instruction_tous_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,);


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