<%@page session="true" import="com.edeal.frontline.*,java.util.*"%> <%@ page import="com.edeal.frontline.navigation.FlRequest" %> <%@taglib uri="http://www.e-deal.com/taglib/fl" prefix="fl"%> <% final org.apache.commons.logging.Log logger = org.apache.commons.logging.LogFactory.getLog(getClass()); FlRequest flRequest = new FlRequest(request); FlContext context = flRequest.getContext(); DataDictionary dico = context.getDataDictionary(); String evtSearch = null; evtSearch = Utils.getRequestParameter(context,request,"evtSearch"); String[] fields = new String[]{"EvtID","EvtLabel","EvtCode","EvtCategory:Val","EvtDate"}; Vector list = new Vector(); if(evtSearch != null && !evtSearch.trim().equals("")){ if(Utils.getMessage(session, "L2040", true, "").equals(evtSearch.trim())){ try{ list = EventBean.listSummary(session,fields); }catch(Exception e){ list = new Vector(); } }else{ String[][] query = {{"EvtLabel like " + Utils.formatToSQL(context, evtSearch.trim() + "%"), "EvtCategory:RefTe2 = " + Utils.formatToSQL(context, "MEET")}, {"EvtCode like " + Utils.formatToSQL(context, evtSearch.trim() + "%"), "EvtCategory:RefTe2 = " + Utils.formatToSQL(context, "MEET")}}; try{ list = EventBean.listSummary(session,fields,query); }catch(Exception e){ list = new Vector(); } } } %> <fl:getMessage code="L63D7" alt="Liste des evénements"/>
">
<% if(list != null && !list.isEmpty()){ for(int i=0; i < list.size(); i++){ Hashtable row = (Hashtable)list.elementAt(i); String evtID = (String)row.get("EvtID"); String evtLabel = (String)row.get("EvtLabel"); String evtCode = (String)row.get("EvtCode"); String evtCat = (String)row.get("EvtCategory:Val"); Date evtDate = (Date)row.get("EvtDate"); %> <% } } else if (evtSearch != null && evtSearch.trim().equals("")) { %> <% } else if (evtSearch != null) { %> <% } %>