Edit C:\galaxie\Back\galaxie\netbusiness\massemailing\list_fusion

Edit C:\galaxie\Back\galaxie\netbusiness\massemailing\list_fusion_fields.jsp

<%@page session="true" %>
<%@page import="com.edeal.frontline.navigation.FlRequest" %>
<%@page import="com.edeal.frontline.Utils" %>
<%@page import="org.apache.commons.lang.StringUtils" %>
<%@taglib uri="http://www.e-deal.com/taglib/fl" prefix="fl" %>
<%@ page import="com.edeal.frontline.*" %>
<%@ page import="com.edeal.frontline.navigation.*" %>
<%@ page import="org.apache.commons.logging.*" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="com.edeal.frontline.FieldBean" %>
<%@ page import="com.edeal.frontline.FieldNotInitializedException" %>
<%@ page import="java.util.Hashtable" %>    
<%@ page import="java.util.Vector" %> 
<%@ page import="com.edeal.frontline.navigation.WebUtils" %>
<%@ page import="com.edeal.frontline.helper.custom.FieldHelper" %> 
<%
		final org.apache.commons.logging.Log logger = org.apache.commons.logging.LogFactory.getLog(getClass());
		// Recuperation du FlRequest 
		FlRequest flRequest = new FlRequest(request);
		String root = flRequest.getParameter("root");
		String name = flRequest.getParameter("name");
		logger.debug("call the jsp for root:" + root);
		logger.debug("call the jsp for name sql:" + name);
		%>
		[
		<%
		// Recuperation du context 
		FlContext context = flRequest.getContext();
		// Recuperation du DataDictionary 
		DataDictionary dico = context.getDataDictionary();
		boolean isFirstTimeIn = true;
		if ((root != null) && (root.length() != 0)) {
				String[] tabFields = { "FldObjID", "FldDisplay", "FldDisplayLabel", "FldID", "FldFobID", "FldSql" };
				String[][] tabQuery = { {"FldMultival = 0", "FldObjID = " + Utils.formatToSQL(context, root)} };
				String[] tabOrderBy = { "FldDisplay" };
				Vector fields = null;
				try {
					fields = FieldBean.listSummary(session, tabFields, tabQuery, tabOrderBy);
				} catch (FrontlineException e) {
					logger.error("STACK TRACE", e);
				}
			
				if (fields != null && fields.size() > 0) {
					for (int i = 0; i < fields.size(); i++) {
						Hashtable row = (Hashtable) fields.elementAt(i);
						//ID champs
						String fldID = (String) row.get("FldID");

//nom sql du champs
						String fldSql = (String) row.get("FldSql");
						//nom du champs			
						String fldDisplay = (String) row.get("FldDisplay");
						
						
						fldSql = fldSql == null ? "" : fldSql;
						fldSql = (((name != null) && (name.length() != 0))) ? name + ":" + fldSql : fldSql;
						
						
						String fldFobID = (String) row.get("FldFobID");
						
						if (fldDisplay != null) {
							if (fldFobID != null) {
								if (!isFirstTimeIn) { %>,<%}
								%>
								{
									"id":"<%= fldFobID %>","name":"<%= fldSql %>","text":"<%= fldDisplay %>","hasChildren":true
								}
								<% 
								isFirstTimeIn = false;
							} else {
								if (!isFirstTimeIn) { %>,<%}
								%>
								{
									"id":"","name":"<%= fldSql %>","text":"<a href=\"javascript:selectField('<%= fldSql %>','<%= fldDisplay.replace("'", "\\\\'") %>','<%= fldID %>')\"><%= fldDisplay %></a>"
								}
								<%
								isFirstTimeIn = false;	
							}	
					 	}
					}
				}		
		}
%>
]

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de