sql/pgsql/commission_retours.inc.php

<?php
/**
 * Ce script permet de ...
 *
 * @package openfoncier
 * @version SVN : $Id: commission_retours.inc.php 4418 2015-02-24 17:30:28Z tbenita $
 */

//
include "../sql/pgsql/dossier_commission.inc.php";

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

//
$tab_description = _("Toutes les retours de commission, non lus, qui".
                     " concernent des dossiers d'instruction situes dans ma".
                     " division.");

//
$champAffiche_debut_commun = array(
    'dossier_commission.dossier_commission as "'._("id").'"',
    'dossier.dossier_libelle as "'._("dossier").'"',
    'to_char(dossier_commission.date_souhaitee ,\'DD/MM/YYYY\') as "'._("date_souhaitee").'"',
    'to_char(commission.date_commission ,\'DD/MM/YYYY\') as "'._("date_commission").'"',
    'commission.libelle as "'._("commission").'"',
    'dossier_commission.avis as "'._("avis").'"',
);

// 
$champAffiche_fin_commun = array(
    '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 ||
     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
     as "'._("enjeu").'"',
);

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

//
$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_commission&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'];

?>
1	<?php
2	/**
3	* Ce script permet de ...
4	*
5	* @package openfoncier
6	* @version SVN : $Id: commission_retours.inc.php 4418 2015-02-24 17:30:28Z tbenita $
7	*/
8
9	//
10	include "../sql/pgsql/dossier_commission.inc.php";
11
12	//
13	$ent = _("instruction")." -> "._("commissions")." -> ";
14
15	//
16	$tab_description = _("Toutes les retours de commission, non lus, qui".
17	" concernent des dossiers d'instruction situes dans ma".
18	" division.");
19
20	//
21	$champAffiche_debut_commun = array(
22	'dossier_commission.dossier_commission as "'._("id").'"',
23	'dossier.dossier_libelle as "'._("dossier").'"',
24	'to_char(dossier_commission.date_souhaitee ,\'DD/MM/YYYY\') as "'._("date_souhaitee").'"',
25	'to_char(commission.date_commission ,\'DD/MM/YYYY\') as "'._("date_commission").'"',
26	'commission.libelle as "'._("commission").'"',
27	'dossier_commission.avis as "'._("avis").'"',
28	);
29
30	//
31	$champAffiche_fin_commun = array(
32	'CASE WHEN dossier.enjeu_urba is TRUE
33	THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._("Enjeu URBA").'">URBA</span>\'
34	ELSE \'\'
35	END \|\|
36	CASE WHEN dossier.enjeu_erp is TRUE
37	THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._("Enjeu ERP").'">ERP</span>\'
38	ELSE \'\'
39	END
40	as "'._("enjeu").'"',
41	);
42
43	// FROM
44	$table .= "LEFT JOIN ".DB_PREFIXE."instructeur
45	ON instructeur.instructeur=dossier.instructeur
46	LEFT JOIN ".DB_PREFIXE."om_utilisateur
47	ON instructeur.om_utilisateur = om_utilisateur.om_utilisateur";
48
49	//
50	$tab_actions['corner']['ajouter']=NULL;
51	$tab_actions['left']['consulter']=array(
52	'lien' => '../spg/direct_link.php?obj=dossier_instruction_tous_encours&action=3'.
53	'&direct_field=dossier&direct_form=dossier_commission&direct_action=3&direct_idx=',
54	'id' => '',
55	'lib' => '<span class="om-icon om-icon-16 om-icon-fix consult-16" title="'._('Consulter').'">'._('Consulter').'</span>',
56	'rights' => array('list' => array($obj, $obj.'_consulter'), 'operator' => 'OR'),
57	'ordre' => 10,);
58	$tab_actions['content'] = $tab_actions['left']['consulter'];
59
60	?>