$filtre, ); /** * Récupération de la configuration de la requête à partir du widget. */ // require_once "../obj/om_widget.class.php"; $om_widget = new om_widget(0); // $conf = $om_widget->get_config_messages_retours($params); // $filtre = $conf["arguments"]["filtre"]; /** * */ // $tab_description = $conf["message_help"]; // $tab_title = _("message"); // $displayed_fields_begin = 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:SS\') as "'._("date_emission").'"', ); $displayed_field_instructeur = array( 'instructeur.nom as "'._("instructeur").'"', ); $displayed_field_division = array( 'division.code as "'._("division").'"', ); $displayed_field_collectivite = array( 'om_collectivite.libelle as "'._("collectivite").'"', ); $displayed_fields_end = array( 'CASE WHEN dossier.enjeu_erp is TRUE THEN \'ERP\' ELSE \'\' END || CASE WHEN dossier.enjeu_urba is TRUE THEN \'URBA\' ELSE \'\' END as "'._("enjeu").'"', ); // FROM $table = $conf["query_ct_from"]; // WHERE $selection = sprintf( "WHERE %s %s ", $conf["query_ct_where_common"], $conf["query_ct_where_user_filter"] ); // $tri = " ORDER BY dossier.enjeu_erp DESC, dossier.enjeu_urba DESC, dossier_message.date_emission ASC "; // $tab_actions['corner']['ajouter'] = null; /** * Options - ADVSEARCH */ // $advsearch_fields_begin = array( // 'dossier' => array( 'table' => 'dossier_message', 'colonne' => 'dossier', 'type' => 'text', 'libelle' => _('Dossier'), ), // 'type' => array( 'table' => 'dossier_message', 'colonne' => 'type', 'type' => 'select', 'libelle' => _('Type message'), ), // 'emetteur' => array( 'colonne' => 'emetteur', 'table' => 'dossier_message', 'libelle' => _('Emetteur'), 'type' => 'text', ), // 'date_emission' => array( 'colonne' => 'date_emission', 'table' => 'dossier_message', 'libelle' => _('Date d\'emission'), 'type' => 'date', 'where' => 'intervaldate', ), ); // $advsearch_field_instructeur = array( // 'instructeur' => array( 'colonne' => 'nom', 'table' => 'instructeur', 'libelle' => _('Instructeur'), 'type' => 'text', ), ); // $advsearch_field_division = array( // 'division' => array( 'colonne' => 'code', 'table' => 'division', 'libelle' => _('Division'), 'type' => 'text', ), ); // $advsearch_field_collectivite = array( // 'collectivite' => array( 'table' => 'om_collectivite', 'colonne' => 'libelle', 'type' => 'text', 'libelle' => _('om_collectivite'), ), ); // $advsearch_fields_end = array( // 'enjeu_erp' => array( 'colonne' => 'enjeu_erp', 'table' => 'dossier', 'libelle' => _('Dossier enjeu ERP'), "subtype" => "manualselect", 'type' => 'select', "args" => array( array("", "true", "false", ), array(_("Tous"), _("Oui"), _("Non"), ), ), ), // 'enjeu_urba' => array( 'colonne' => 'enjeu_urba', 'table' => 'dossier', 'libelle' => _('Dossier enjeu URBA'), 'type' => 'select', "subtype" => "manualselect", "args" => array( array("", "true", "false", ), array(_("Tous"), _("Oui"), _("Non"), ), ), ), ); ?>