"._("Dossiers evenement incomplet ou majoration"); $tab_actions['left']['consulter'] = array('lien' => 'form.php?obj=dossier_instruction&action=3'.'&idx=', 'id' => '&premier='.$premier.'&advs_id='.$advs_id.'&recherche='.$recherche1.'&tricol='.$tricol.'&selectioncol='.$selectioncol.'&valide='.$valide.'&retour=tab', 'lib' => ''._('Consulter').'', 'rights' => array('list' => array($obj, $obj.'_consulter'), 'operator' => 'OR'), 'ordre' => 10,); $tab_actions['content'] = $tab_actions['left']['consulter']; $tab_actions['corner']['ajouter'] = ""; // $champAffiche = array( 'dossier.dossier as "'._("dossier").'"', 'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"' ); $table = DB_PREFIXE."dossier LEFT JOIN ".DB_PREFIXE."instruction ON dossier.dossier = instruction.dossier LEFT JOIN ".DB_PREFIXE."evenement ON instruction.evenement = evenement.evenement"; // $selection = " WHERE ( LOWER(evenement.type) = 'incompletude' OR LOWER(evenement.type) = 'majoration_delai' ) AND instruction.date_envoi_rar > CURRENT_TIMESTAMP - interval '1 month' AND instruction.date_retour_rar IS NULL AND evenement.retour = 'f'"; $tri=" ORDER BY dossier.date_depot desc"; ?>