<%@page session="true" import="com.edeal.frontline.*,java.util.*"%> <%@ page import="com.edeal.frontline.navigation.FlRequest" %> <%@ page import="com.edeal.frontline.controller.actions.custom.EventGuestWithFormAnswerList" %> <%@ page import="com.edeal.frontline.helper.EventBaseHelper.StatusType" %> <%@ page import="com.edeal.frontline.helper.custom.PersonEventHelper" %> <%@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()); String contextPath = (String) session.getAttribute("contextPath"); FlContext context = null; if (contextPath!=null) { context = Frontline.getContext(contextPath); } else { context = Frontline.getContext(request.getContextPath()); } DataDictionary dico = context.getDataDictionary(); String evtID = null; evtID = Utils.getRequestParameter(context,request,"evtID"); EventBean event = new EventBean(evtID,context); session.setAttribute("EventBean",event); Vector evtVectStatus = PersonEventHelper.getAllStatusID(context, StatusType.PARTICIPATION, evtID); %> <fl:getMessage code="L6546" alt="Inscrits"/>

<% String evtStatus = Utils.getRequestParameter(context,request,"EvtStatus"); Vector stgResult = new Vector(); String keys[] = {"PvtID", "PerID", "PvtParStatus", "PvtInsStatus", "PerCounselor","PerPhone","PerCiv", "PerFstName", "PerName", "EntID", "EntCorpName","FrpID","FrpStatus"}; String sqlQuery = "SELECT PvtID, PerID, PvtParStatus, PvtInsStatus, PerCounselor, PerPhone, PerCivility.RefTe1, Person.PerFstName, Person.PerName, Person.PerEntID, Enterprise.EntCorpName, FrpID, FrpStatus"; sqlQuery = sqlQuery + " FROM PersonEvent"; sqlQuery = sqlQuery + " LEFT OUTER JOIN Person ON PvtPersonID = PerID"; sqlQuery = sqlQuery + " LEFT OUTER JOIN Enterprise ON PerEntID = EntID"; sqlQuery = sqlQuery + " LEFT OUTER JOIN FormResponse ON PvtFrpID = FrpID"; sqlQuery = sqlQuery + " LEFT OUTER JOIN RefValues PerCivility ON Person.PerCivID = PerCivility.RefID"; sqlQuery = sqlQuery + " WHERE PvtEventID = " + Utils.formatToSQL(context, evtID); sqlQuery = sqlQuery + " ORDER BY Person.PerName, Person.PerFstName"; Vector objs = new Vector(); try{ objs = BasicBean.listSQL(context, keys, sqlQuery); }catch(FrontlineException frontlineexception) { logger.error("Exception in query :",frontlineexception); } for(int i = 0; i < objs.size(); i++) { Hashtable obj = (Hashtable)objs.elementAt(i); String interlocutorID = (String)obj.get("PerID");; String entID = (String)obj.get("EntID"); String corpName = (String)obj.get("EntCorpName"); String intCivID = (String)obj.get("PerCiv"); String intFstName = (String)obj.get("PerFstName"); String intName = (String)obj.get("PerName"); String interlocutor = null; interlocutor = intCivID == null ? "" : intCivID + " "; interlocutor += intFstName == null ? "" : intFstName + " "; interlocutor += intName == null ? "" : intName; String parStatus = (String) obj.get("PvtParStatus"); String insStatus = (String) obj.get("PvtInsStatus"); String pvtId = (String)obj.get("PvtID"); %>
" id="status-<%= pvtId %>" href="javascript:updateStatus('<%= pvtId %>')">
<%= interlocutor %><%= (corpName != null) ? " (" + corpName + ") " : "" %>
<% String statusDisplay = null; try { if (parStatus != null) { statusDisplay = (String) dico.getRefDisp("PvtParStatus", parStatus); } } catch (Exception e) { } %><%= (statusDisplay != null) ? statusDisplay : "" %>
<% } %>