"._("messages")." -> "._("mes messages"); // $tab_description = _("Les messages non lus qui". " concernent des dossiers d'instruction dont je suis". " l'instructeur."); // $champAffiche = array( 'dossier_message.dossier_message as "'._("dossier_message").'"', 'dossier.dossier_libelle as "'._("dossier").'"', 'dossier_message.type as "'._("type").'"', 'dossier_message.emetteur as "'._("emetteur").'"', 'to_char(dossier_message.date_emission ,\'DD/MM/YYYY HH24:MI\') as "'._("date_emission").'"', 'CASE WHEN dossier.enjeu_erp is TRUE THEN \'ERP\' ELSE \'\' END || CASE WHEN dossier.enjeu_urba is TRUE THEN \'URBA\' 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&action=3'. '&direct_field=dossier&direct_form=dossier_message&direct_action=3&direct_idx=', 'id' => '', 'lib' => ''._('Consulter').'', 'rights' => array('list' => array($obj, $obj.'_consulter'), 'operator' => 'OR'), 'ordre' => 10,); $champRecherche = array( 'dossier.dossier as "'._("dossier").'"', ); $tab_actions['content'] = $tab_actions['left']['consulter']; /** * OPTIONS - ADVSEARCH */ // $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, ); // advsearch -> options $options[] = array( 'type' => 'search', 'display' => true, 'advanced' => $champs, 'absolute_object' => 'dossier_message', ); ?>