Edit C:\galaxie\Back\galaxie\admin\dictionary\fieldlist.jsp
<% /****************************************************************************** * Copyright (c) 2000-2005 e-Deal * * e-Deal S.A. * 55 rue Brillat Savarin * 75013 Paris * France * * T: +33 (0)1 53 80 80 30 * F: +33 (0)1 73 01 69 77 * http://www.e-deal.com * * La diffusion de ce code source sous quelque forme que ce soit sans * l'autorisation de E-DEAL est interdite. * * Vous êtes autorisés à modifier ce code source uniquement pour votre usage * propre et sous réserve que les mentions de copyright demeurent intactes. * * Ce code est fourni en l'état. Aucune garantie d'aucune sorte, explicite ou * implicite n'est donnée. En aucun cas E-DEAL ne pourra être tenu pour * responsable des dommages pouvant résulter de l'utilisation de ce code * source. ******************************************************************************/ %> <%@ page session="true" contentType="text/html; charset=UTF-8"%> <%@ page import="com.edeal.frontline.navigation.FlRequest" %> <%@ page import="com.edeal.frontline.FlContext" %> <%@ page import="com.edeal.frontline.DataDictionary" %> <%@ page import="java.util.Vector" %> <%@ page import="java.util.Hashtable" %> <%@ page import="java.text.DecimalFormat" %> <%@ page import="java.util.Date" %> <%@ page import="java.util.GregorianCalendar" %> <%@ page import="com.edeal.frontline.RefValuesBean" %> <%@ page import="com.edeal.frontline.FlLocale" %> <%@ page import="com.edeal.frontline.Utils" %> <%@ page import="com.edeal.frontline.TablesBean" %> <%@ page import="com.edeal.frontline.FieldNotInitializedException" %> <%@ page import="com.edeal.frontline.FieldBean" %> <%@ taglib uri="http://www.e-deal.com/taglib/fl" prefix="fl" %> <jsp:useBean class="com.edeal.frontline.ObjectsBean" id="Objects" scope="request"/> <% 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(); Vector values = Objects.getFieldsData(); String sfwID = flRequest.getRequestParameterOrAttribute("SfwID"); %> <div id="fieldList" style="width: 100%;"> <table class="container" cellpadding="0" id="tab1"> <tbody> <tr> <td class="column4"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjSql"/> <% String displayLabel = null; try { displayLabel = Objects.getObjDisplayLabel(); } catch (FieldNotInitializedException fnie) { } %> <tr class="fieldline"> <td class="dataLabel"><fl:getMessage code="L6015" alt="Nom affiché"/></td> <td class="dataValue"><%= displayLabel != null ? Utils.getMessage(session, displayLabel, null) : " "%></td> </tr> </table> </td> <td class="separation"><div class="separation"></div></td> <td class="column4"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjModule"/> <fl:fieldRead property="ObjDisplay"/> </table> </td> <td class="separation"><div class="separation"></div></td> <td class="column4"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjRadical"/> </table> </td> <td class="separation"><div class="separation"></div></td> <td class="column4"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjStandard" valueCodeIfTrue="L2005" valueCodeIfFalse="L2006"/> <fl:fieldRead property="ObjModificationLogged" valueCodeIfTrue="L2005" valueCodeIfFalse="L2006"/> </table> </td> </tr> </tbody> </table> <%-- div id="tab2"--%> <div class="edealGrid"> <div id="grid-data" class="data" id="tab2"> <table cellpadding="0" class="container"> <thead> <tr style="position:relative;top: expression(offsetParent.scrollTop);background-color:white"> <th> </th> <th><fl:getMessage code="F600E" alt="Nom SQL du champ"/></th> <th><fl:getMessage code="L6015" alt="Nom affiché"/></th> <th><fl:getMessage code="L601A" alt="Numéro d'ordre"/></th> <th><fl:getMessage code="F6010" alt="Standard"/></th> <th><fl:getMessage code="F600F" alt="Type du champ"/></th> <th><fl:getMessage code="F6013" alt="Taille "/></th> <th><fl:getMessage code="F6011" alt="Table de Référence"/></th> <th><fl:getMessage code="F6015" alt="Frontline Object"/></th> <th><fl:getMessage code="F608E" alt="Politique de suppression"/></th> <th><fl:getMessage code="L62DF" alt="Options"/></th> <th><fl:getMessage code="F65B1" alt="Affichage"/></th> <th><fl:getMessage code="F9901" alt="Indexation"/></th> </tr> </thead> <tfoot> <tr> <th> </th> <th><fl:getMessage code="F600E" alt="Nom SQL du champ"/></th> <th><fl:getMessage code="L6015" alt="Nom affiché"/></th> <th><fl:getMessage code="L601A" alt="Numéro d'ordre"/></th> <th><fl:getMessage code="F6010" alt="Standard"/></th> <th><fl:getMessage code="F600F" alt="Type du champ"/></th> <th><fl:getMessage code="F6013" alt="Taille "/></th> <th><fl:getMessage code="F6011" alt="Table de Référence"/></th> <th><fl:getMessage code="F6015" alt="Frontline Object"/></th> <th><fl:getMessage code="F608E" alt="Politique de suppression"/></th> <th><fl:getMessage code="L62DF" alt="Options"/></th> <th><fl:getMessage code="F65B1" alt="Affichage"/></th> <th><fl:getMessage code="F9901" alt="Indexation"/></th> </tr> </tfoot> <tbody> <% boolean colorBlue = true; for(int i = 0; i < values.size(); i++) { Hashtable row = (Hashtable)values.elementAt(i); colorBlue = !colorBlue; String fldLabelCode = (String)row.get("FldDisplayLabel"); String fldDispLabel = null; if (fldLabelCode!=null){ fldDispLabel = Utils.getMessage(session, fldLabelCode, ""); } %> <tr class="<%= colorBlue ? "odd bean" : "even bean" %>"> <td nowrap="nowrap"> <a href="javascript:editField('<%= (String)row.get("FldID") %>')"><img src="<fl:webapp/>/icons/ico/zoom.gif"/></a> <a href="javascript:deleteField('<%= (String)row.get("FldID") %>')"><img src="<fl:webapp/>/icons/ico/supprimer.gif"/></a> </td> <td> <%= Utils.formatToWeb((String)row.get("FldSql"), false) %> </td> <td> <%= fldDispLabel != null? fldDispLabel : Utils.formatToWeb((String)row.get("FldDisplay"), false) %> </td> <td style="text-align: right;"> <%= row.get("FldNum") %> </td> <td style="text-align: center;"> <% if (row.get("FldStd") != null && ((Boolean)row.get("FldStd")).booleanValue()) { %> <img src="<fl:webapp/>/icons/ico/cochevalid.gif" style="vertical-align: middle;" title="<fl:getMessage code="F6010" alt="Standard"/>" alt="<fl:getMessage code="F6010" alt="Standard"/>"/> <% } %> </td> <td> <%= Utils.formatToWeb((String)row.get("FldFltID:Val"), false) %> </td> <td style="text-align: right;"> <%= Utils.formatToWeb(row.get("FldSize") == null ? "" : row.get("FldSize").toString(), false) %> </td> <td> <a href="<fl:link url="<%= \"/referential.fl\" + (row.get(\"FldTabID:TabName\") != null ? \"?SfwID=\" + sfwID + \"&FldSql=\" + (String)row.get(\"FldSql\") : \"\") %>"/>"> <%= Utils.formatToWeb((String)row.get("FldTabID:TabName"), false) %> </a> </td> <td> <% if (row.get("FldFobID:ObjDisplay") != null) { %> <a href="<fl:link url="<%= \"/dictionary.fl\" + (row.get(\"FldFobID:ObjSql\") != null ? \"?SfwID=\" + sfwID + \"&ObjSql=\" + (String)row.get(\"FldFobID:ObjSql\") : \"\") %>"/>"> <%= Utils.formatToWeb((String)row.get("FldFobID:ObjDisplay"), false) %> </a> <% } %> </td> <td> <% int delPolicy = Integer.MIN_VALUE; String delPolicyDisplay = ""; if (row.get("FldDelPolicy") != null) { delPolicy = ((Integer)row.get("FldDelPolicy")).intValue(); } if (delPolicy == FieldBean.DEL_POLICY_NO_FK) { delPolicyDisplay = Utils.getMessage(session, "L6235", "NO FK"); } else if (delPolicy == FieldBean.DEL_POLICY_NO_ACTION) { delPolicyDisplay = Utils.getMessage(session, "L6232", "NO ACTION"); } else if (delPolicy == FieldBean.DEL_POLICY_SET_NULL) { delPolicyDisplay = Utils.getMessage(session, "L6233", "SET NULL"); } else if (delPolicy == FieldBean.DEL_POLICY_CASCADE) { delPolicyDisplay = Utils.getMessage(session, "L6234", "CASCADE"); } else if (delPolicy != Integer.MIN_VALUE) { logger.warn("!!! List of fields : field " + row.get("FldSql").toString() + " has unknown deletion policy " + delPolicy); } %> <%= delPolicyDisplay %> </td> <td style="text-align: center;"> <% if (row.get("FldMultival") != null && ((Boolean)row.get("FldMultival")).booleanValue()) { %> <img src="<fl:webapp/>/icons/ico/multival.png" style="vertical-align: middle;" title="<fl:getMessage code="F6014" alt="Multivalué"/>" alt="<fl:getMessage code="F6014" alt="Multivalué"/> "/> <% } %> <% if (row.get("FldCriteria") != null && ((Boolean)row.get("FldCriteria")).booleanValue()) { %> <img src="<fl:webapp/>/icons/ico/no-target.png" style="vertical-align: middle;" title="<fl:getMessage code="F6058" alt="Hors ciblage"/>" alt="<fl:getMessage code="F6058" alt="Hors ciblage"/>"/> <% } %> <% if (row.get("FldOwner") != null && ((Boolean)row.get("FldOwner")).booleanValue()) { %> <img src="<fl:webapp/>/icons/ico/lock.gif" style="vertical-align: middle;" title="<fl:getMessage code="F6016" alt="Propriétaire"/>" alt="<fl:getMessage code="F6016" alt="Propriétaire"/>"/> <% } %> <% if (row.get("FldModificationLogged") != null && ((Boolean)row.get("FldModificationLogged")).booleanValue()) { %> <img src="<fl:webapp/>/icons/ico/history.png" style="vertical-align: middle;" title="<fl:getMessage code="L6553" alt="Historisé"/>" alt="<fl:getMessage code="L6553" alt="Historisé"/>"/> <% } %> </td> <td> <%= Utils.formatToWeb((String)row.get("FldDisplayPolicy:Val"), false) %> </td> <td> <%= Utils.formatToWeb((String)row.get("FldIndexPolicy:Val"), false) %> </td> <% } %> </tr> </tbody> </table> </div></div> <table class="container" cellpadding="0" style="width: 100%" id="tab3"> <tbody> <tr> <td colspan="3"> </td> </tr> <tr> <td style="vertical-align:top; width: 50%;"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjSelectListCode"/> <fl:fieldRead property="ObjSelectFields"/> <fl:fieldRead property="ObjSelectDisplay"/> <fl:fieldRead property="ObjToString"/> </table> </td> <td class="separation"><div class="separation"></div></td> <td style="vertical-align:top; width: 50%;"> <table class="data_column" cellpadding="0"> <fl:fieldRead property="ObjAjaxSearch"/> <fl:fieldRead property="ObjAjaxOrder"/> <fl:fieldRead property="ObjAjaxMinChar"/> <fl:fieldRead property="ObjConnexObjs" bean="true"/> </table> </td> </tr> </tbody> </table> <fl:notes name="EntNotes" title="<%= Utils.getMessage(session, \"L2007\", \"Description\") %>" nbPix="30"><fl:getProperty name="Objects" property="ObjDescription" alt=""/></fl:notes> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de