<% } %> <% if(vectObjs != null && !vectObjs.isEmpty()) { ObjectsBean actBean = dico.getTable("sql", "Actor"); ObjectsBean perBean = dico.getTable("sql", "Person"); ObjectsBean entBean = dico.getTable("sql", "Enterprise"); ObjectsBean jouBean = dico.getTable("sql", "Journalist"); ObjectsBean supBean = dico.getTable("sql", "Support"); java.sql.Connection cx = null; java.sql.PreparedStatement pstmtAttID = null; java.sql.PreparedStatement pstmtActID = null; java.sql.PreparedStatement pstmtCorID = null; try { cx = context.getConnection(); String attIDQuery = Utils.formatPreparedStatementQueryForUnicode(context, "SELECT MvaText FROM MvaIntAttID WHERE MvaColID = ?", new int[]{1}); pstmtAttID = cx.prepareStatement(attIDQuery); String actIDQuery = Utils.formatPreparedStatementQueryForUnicode(context, "SELECT ActID, ActCivID, ActFstName,ActName FROM MvaIntActID, Actor WHERE MvaColID = ? AND ActID = MvaText", new int[]{1}); pstmtActID = cx.prepareStatement(actIDQuery); String corQuery = ""; if (isOracle) { corQuery = "SELECT PerID, PerCivID, PerFstName, PerName, EntID, EntCorpName, SupID, SupTitle, JouID, JouCivID, JouFstName, JouName "; corQuery += "FROM MvaIntCorID, Correspondent, Person, Enterprise, Journalist, Support "; corQuery += "WHERE MvaText = CorID (+) AND CorPerID = PerID (+) AND CorEntID = EntID (+) AND CorJouID = JouID (+) AND CorSupID = SupID (+) "; corQuery += "AND MvaColID = ? "; corQuery += "ORDER BY EntCorpName, PerName, PerFstName, SupTitle, JouName, JouFstName"; } else { corQuery = "SELECT PerID, PerCivID, PerFstName, PerName, EntID, EntCorpName, SupID, SupTitle, JouID, JouCivID, JouFstName, JouName "; corQuery += "FROM MvaIntCorID LEFT OUTER JOIN Correspondent ON MvaText = CorID "; corQuery += "LEFT OUTER JOIN Person ON PerID = CorPerID "; corQuery += "LEFT OUTER JOIN Enterprise ON EntID = CorEntID "; corQuery += "LEFT OUTER JOIN Journalist ON JouID = CorJouID "; corQuery += "LEFT OUTER JOIN Support ON SupID = CorSupID "; corQuery += "WHERE MvaColID = ? "; corQuery += "ORDER BY EntCorpName, PerName, PerFstName, SupTitle, JouName, JouFstName"; } pstmtCorID = cx.prepareStatement(Utils.formatPreparedStatementQueryForUnicode(context, corQuery, new int[]{1})); for (int i = 0; i < vectObjs.size(); i++) { Hashtable row = (Hashtable)vectObjs.elementAt(i); String strIntID = (String)row.get("IntID"); String intAtvID = (String)row.get("IntAtvID"); Date IntDate = (Date)row.get("IntDate"); String subject = (String)row.get("IntSubject"); String strStiID = (String)row.get("IntStiID"); String formatIntSubject = ""; if(subject != null){ formatIntSubject = Utils.formatToWeb(session,subject,false) + " - "; } String formatIntDate = Utils.formatToWeb(session,IntDate,false,"dd/MM/yyyy"); String elastic = ""; String afterElastic = ""; String formatIntAtvID = ""; if(intAtvID != null){ formatIntAtvID = Utils.formatToWeb(session,(String)dico.getRefCode("IntAtvID",intAtvID),false) + " - "; } String formatDone = ""; if(strStiID != null && dico.getRefIdByCode("IntStiID", "DONE").equals(strStiID)){ formatDone = Utils.getMessage(session, "A3020", "Fait"); } else { formatDone = Utils.getMessage(session, "A3009", "A faire"); } %> <% } } catch (Exception ex) { logger.error("[/sales/interaction/embedded_list.jsp] " + ex.getClass().getName() + " : " + ex.getMessage()); logger.error("STACK TRACE",ex); } finally { try { pstmtAttID.close(); } catch (Exception ex) {} try { pstmtActID.close(); } catch (Exception ex) {} try { pstmtCorID.close(); } catch (Exception ex) {} try { cx.close(); } catch (Exception ex) {} } } %>

<% if (Utils.getRequestParameter(context, request, "perID") != null ) { %> " style="text-decoration:none;">[+]

> <%= formatIntDate %> - <%= formatIntSubject %> <%= formatIntAtvID %> <%= formatDone %>