contexte_dossier_instruction()) {
//
$ent = " -> ".__("commission");
//
$case_consultation_lu = "case when dossier_commission.avis = '' then ''
else case dossier_commission.lu
when 't' then 'Oui'
else 'Non'
end
end";
//
$champAffiche = array(
'dossier_commission.dossier_commission as "'.__("id").'"',
'commission_type.libelle as "'.__("commission_type").'"',
'to_char(date_souhaitee ,\'DD/MM/YYYY\') as "'.__("date_souhaitee").'"',
'commission.code as "'.__("commission").'"',
'to_char(commission.date_commission ,\'DD/MM/YYYY\') as "'.__("date_commission").'"',
"avis",
$case_consultation_lu." as \"".__("lu")."\"",
);
$options[] = array(
"type" => "condition",
"field" => $case_consultation_lu,
"case" => array(
array(
"values" => array("Non", ""),
"style" => "afficher-marquer-lu",
),
array(
"values" => array("Oui", ""),
"style" => "masquer-marquer-lu",
),
),
);
$tab_actions['left']['marquer_comme_lu'] = array(
'lien' => OM_ROUTE_FORM.'&obj='.$obj.'&action=50&idx=',
'lib' => "".__("Marquer comme lu")."",
'type' => 'action-direct',
'rights' => array('list' => array("{$obj}", "{$obj}_modifier_lu"), 'operator' => 'OR'),
'ordre' => 91
);
// Surcharge bouton ajouter
$tab_actions['corner']['ajouter'] =
array('lien' => "".OM_ROUTE_SOUSFORM."&obj=$obj&action=0&tri=&objsf=$obj&premiersf=0&retour=form&retourformulaire=$retourformulaire&idxformulaire=$idxformulaire",
'id' => "",
'lib' => ''.__('Ajouter').'',
'rights' => array('list' => array($obj, $obj.'_ajouter_instruction'), 'operator' => 'OR'),
);
}
// Change le lien du contenu si on est dans une commission
if ($retourformulaire=='commission') {
$tab_actions['left']['consulter'] =
array('lien' => ''.OM_ROUTE_SOUSFORM.'&obj='.$obj.'&action=1'.'&idx=',
'id' => '&premier='.$premier.'&retour=form&retourformulaire=commission',
'lib' => ''.__('Consulter').'',
'rights' => array('list' => array($obj, $obj.'_modifier'), 'operator' => 'OR'),
'ordre' => 10,);
$tab_actions['content'] = $tab_actions['left']['consulter'];
$tab_actions['corner']['ajouter'] = NULL;
}
// Gestion particulière de l'affichage du listing dans le contexte d'un dossier
// d'instruction
include "../sql/pgsql/dossier_instruction_droit_specifique_par_division.inc.php";
// Ajout de la gestion des groupes et confidentialité à la requête du listing
$sqlFiltreGroup = $this->get_sql_filtre_groupe($table.$selection);
$selection .= $sqlFiltreGroup['WHERE'];
$table .= $sqlFiltreGroup['FROM'];