/*
    * $Source: /usr/cvsroot/jal/src/main/java/org/paneris/jal/model/HTMLUtil.java,v $
    * $Revision: 1.24 $
    *
    * Copyright (C) 2002 Paneris
    */
   package org.paneris.jal.model;
   
   import java.sql.Connection;
  import java.sql.ResultSet;
  import java.sql.ResultSetMetaData;
  import java.sql.SQLException;
  import java.sql.Statement;
  import java.text.SimpleDateFormat;
  import java.util.Calendar;
  import java.util.Enumeration;
  import java.util.Hashtable;
  
  import org.paneris.util.ExtendedHash;
  
  import org.apache.oro.text.regex.MalformedPatternException;
  import org.apache.oro.text.regex.Pattern;
  import org.apache.oro.text.regex.PatternCompiler;
  import org.apache.oro.text.regex.PatternMatcher;
  import org.apache.oro.text.regex.Perl5Compiler;
  import org.apache.oro.text.regex.Perl5Matcher;
  import org.apache.oro.text.regex.StringSubstitution;
  import org.apache.oro.text.regex.Util;
  
  /**
   * <p> 
   * Output format (HTML) dependant formatters.
   * </p>
   *
   * @author  Paneris
   * @author  timp@paneris.org
   **/
  
  
  public final class HTMLUtil {
  
    private static final String[] months = {"dummy","Jan","Feb","Mar","Apr",
                            "May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
  
  
    /**
     * Do basic escaping of html text
     *
     * @param htm   a String to escape
     * @return      the escaped string
     */
    public static String escapeHTML(String htm) {
      ExtendedHash escapeHash = new ExtendedHash();
        escapeHash.put("&","&amp;");
        escapeHash.put("<","&lt;");
        escapeHash.put(">","&gt;");
        escapeHash.put("\"","&quot;");
      return escape(htm, escapeHash);
    }
  
    public static String escapeJavascript(String s) {
        ExtendedHash escapeHash = new ExtendedHash();
        escapeHash.put("\"","\\\"");
        return escape(s, escapeHash);
    }
  
    public static String escape(String s, ExtendedHash h) {
      PatternCompiler compiler = new Perl5Compiler();
      PatternMatcher matcher = new Perl5Matcher();
      String result = s;
      for (Enumeration en = h.keys() ; en.hasMoreElements() ;) {
        String regularExpression = (String) en.nextElement();
        try {
          Pattern pattern = compiler.compile(regularExpression);
          result = Util.substitute(
                    matcher, pattern, new StringSubstitution((String) h.get(regularExpression)), 
                    result, Util.SUBSTITUTE_ALL);
        } catch (MalformedPatternException e) {
        throw new RuntimeException
            ("MalformedPatternException: " + e.toString());
        }
      }
      return result;
    }
  
  
  
    /**
     * Return a drop down list (HTML select tag) where the options
     * are the rows of a ResultSet. When an option is selected its
     * value is copied into the input box called name.
     * <p>
     * Each row of the ResultSet should have only one value
     * Each row becomes an HTML option tag
     * <P>
     * Unique only puts an element into the select box if it's
     * value is not already
     * <P>
     * Takes a selectvalue so that the correct option can be chosen
    * <P>
    * You can also add an extra option using allName and allValue
    *
    * @param rs          a list of value pairs
    * @param name        the name of the input box to copy to
    * @param unique      make sure that each entry has a different value
    * @param allValue    the value of first option on select
    * @param allName     the name of first value on select
    * @param selectValue the entry to be selected by default
    * @return            a HTML select tag
    */
   public static String getLinkedSelect(ResultSet rs, String name, 
                    boolean unique, String allName, String selectValue) 
     throws Exception {
     return getLinkedSelect(rs,name,unique,"0",allName,selectValue);
   }
 
   public static String getLinkedSelect(ResultSet rs, String name,
                     boolean unique, 
                     String allValue, String allName, String selectValue) 
   throws Exception {
     String result = "<select name=\""+name+"s\" onchange=\""+name+
               ".value = options[selectedIndex].value;return true;\">\n";
     if (allName != null) {
       if (allValue == null) allValue = "";
       result += "<option value=\"" + allValue + "\">" + 
                                      allName + "</option>\n";
     }
     Hashtable values = new Hashtable();
     while (rs.next()) {
       String value = new String(rs.getString(1));
       String display = value;
       if (((ResultSetMetaData) rs.getMetaData()).getColumnCount() >= 2) {
         display = new String(rs.getString(2));
       } 
       if (!unique || (unique && !values.containsKey(value))) {
         values.put(value,display);
         result += "<option value=\"" + value +"\"";
         if (selectValue != null && value.equals(selectValue))
           result += " selected";
         result += ">" + display + "</option>\n";
       }
     }
     result += "</select>";
     return result;
   }
 
 
  /**
   * Return a drop down list (select tag) from a DDField where the
   * options are given by the possible values of that Field.
   * <p>
   * You can add another option using allName and allValue so long
   * as mandatory is not set
   * <p>
   * The current value of the DDField is used to decide which option is
   * selected by default
   *
   * @param dd        a DDField which we want to create a select box for
   *                  This may be a field in a lookup table
   * @param db        name of the database to query
   * @param fieldname the name of the field (and the select tag)
   *                  This may be the name of the field containing the lookup
   * @param mandatory if 'false' then a default extra option ("None") is
   *                  added, unless allName is set
   * @param unique    ensure that each entry has a different value
   * @param allValue  the value of first option on select
   * @param allName   the name of first value on select
   * @return          a HTML select tag
   */
   public static String getLinkedSelect(DDField ddf, String db, 
                                      String fieldname, boolean mandatory, 
                                      boolean unique, String allName)
     throws Exception {
       return getLinkedSelect(ddf,db,fieldname,mandatory,unique,"0",allName);
   }
 
   public static String getLinkedSelect(DDField ddf, String db, 
                                          String allName) throws Exception {
     return getLinkedSelect(ddf,db,ddf.getMetaData().getFieldName(),
                            allName==null,true,"0",allName);
   }
 
   public static String getLinkedSelect(DDField ddf, String db, 
                                      String fieldname,
                                      boolean mandatory, boolean unique,
                                      String allValue, String allName)
     throws Exception {
 
       Connection conn = null;
       Statement s = null;
 
       DBConnectionManager connMgr = DBConnectionManager.getInstance();
       String returnString = "<select name=\""+fieldname+"s\" onchange=\""+
                             fieldname+".value = " + 
                             "options[selectedIndex].value;return true;\">\n";
       if (!mandatory || allName != null) {
         if (allName == null) allName = "None";
         if (allValue == null) allValue = "";
         returnString += "<option value=\"" + allValue + "\">" + 
                         allName + "</option>\n";
       }
       try {
         conn = connMgr.getConnection("HTMLUtil",db);
         s = conn.createStatement();
         String sqlString = new String("SELECT  ");
         sqlString += ddf.getMetaData().getFieldName() + " FROM " + 
                      ddf.getMetaData().getTableName();
         if (!ddf.getMetaData().getType().equals("textarea") &&
             !ddf.getMetaData().getType().equals("preformattedtextarea")) {
           sqlString += " ORDER BY " + ddf.getMetaData().getFieldName();
         }
         ResultSet rs = s.executeQuery(sqlString);
         while (rs.next()) {
           String value = rs.getString(1);
           if (value != null) {
             value = value.trim();
             returnString += "<option value=" + value;
             if ((ddf.getValue() != null) && 
                 (value.equals(ddf.getValue().toString())))
                         returnString += " selected";
             returnString += ">" + value + "</option>\n";
           }
         }
         returnString += "</select>\n";
         connMgr.freeConnection(db, conn);
         return returnString;
       } catch (Exception e) {
         throw new Exception("Failed to build LinkedSelect:" + e.toString());
       }  finally {
         s.close();
         connMgr.freeConnection(db, conn);
       }
     }
 
 
 
 
     /**
      * Return a drop down list (HTML select tag) where the options
      * are defined by the records returned by an SQL query.
      * <p>
      * Unique only puts an element into the select box if it's
      * value is not already
      * <P>
      *
      * @param db          name of the database to query
      * @param sqlString   the SQL query to evaluate
      * @param name        the name of the select tag
      * @param unique      make sure that each entry has a different value
      * @param allValue    the value of first option on select
      * @param allName     the name of first value on select
      * @param selectValue the value which should be selected
      * @return            a HTML select tag
      */
 
     public static String getLinkedSelect(String db, String sqlString, 
                        String name,
                        boolean unique, String allName)
       throws Exception {
         return getLinkedSelect(db, sqlString, name, unique, "0", allName, null);
     }
 
     public static String getLinkedSelect(String db, String sqlString, 
                                          String name, boolean unique)
       throws Exception {
         return getLinkedSelect(db, sqlString, name, unique, null, null, null);
     }
 
     public static String getLinkedSelect(String db, String sqlString, 
                                          String name) 
       throws Exception {
         return getLinkedSelect(db, sqlString, name, false, null, null, null);
     }
     public static String getLinkedSelect(String db, String sqlString, 
                                          String name, 
                                          boolean unique, 
                                          String allValue, String allName, 
                                          String selectValue
                                          )
       throws Exception {
         DBConnectionManager connMgr = DBConnectionManager.getInstance();
         Connection conn = connMgr.getConnection("HTMLUtil",db);
         if (conn == null) throw new RuntimeException("can't get connection: " + db);
         Statement s = conn.createStatement();
         ResultSet rs = null;
         try {
            rs = s.executeQuery(sqlString);
         } catch (Exception e) {
             throw new Exception("Problem with query (" + sqlString + "):" +e.toString());
         }  finally {
             s.close();
             connMgr.freeConnection(db, conn);
         }
         connMgr.freeConnection(db, conn);
         return getLinkedSelect(rs, name, unique, allValue, allName, selectValue);
     }
 
   /**
    * Return a drop down list (HTML select tag) where the options
    * are the rows of a ResultSet.
    * <p>
    * It is assumed that each row of the ResultSet has at least
    * 2 fields in it - the first is used as the value of the
    * option, the 2nd is the displayed value. Each row becomes
    * a HTML option tag
    * <P>
    * Unique only puts an element into the select box if it's
    * value is not already
    * <P>
    * Takes a selectvalue so that the correct option can be chosen
    * <P>
    * You can also add an extra option using allName and allValue
    *
    * @param rs         a list of value/display pairs
    * @param name       the name of the select tag
    * @param unique     make sure that each entry has a different value
    * @param allValue   the value of first option on select
    * @param allName    the name of first value on select
    * @param selectValue a String indicating the entry to be selected by default
    * @return           a HTML select tag
    */
    public static String getDropDown(ResultSet rs, String name, boolean unique,
                                      String allName, String selectValue) 
      throws Exception {
         return getDropDown(rs, name, unique, "0",  allName, selectValue);
    } 
    public static String getDropDown(ResultSet rs, String name, boolean unique,
                                      String allName) 
      throws Exception {
        return getDropDown(rs, name, unique, "0",  allName, null);
    }
    public static String getDropDown(ResultSet rs, String name, boolean unique)
      throws Exception {
         return getDropDown(rs, name, unique, null, null,    null);
    }
    public static String getDropDown(ResultSet rs, String name) 
      throws Exception {
        return getDropDown(rs, name, false,  null, null,    null);
    }
 
   public static String getDropDown(ResultSet rs, String name, boolean unique,
                                     String allValue, String allName, 
                                     String selectValue) 
     throws Exception {
       String result = "<select name=\""+name+"\">\n";
       if (allValue == null) allValue = "";
       if (allName != null) {
         result += "<option value=\"" + allValue + "\">" + allName + 
                   "</option>\n";
       }
       Hashtable values = new Hashtable();
       try {
         while (rs.next()) {
           String value = new String(rs.getString(1));
           String display = value;
           if (((ResultSetMetaData) rs.getMetaData()).getColumnCount() >= 2) {
             display = new String(rs.getString(2));
           } 
           if (!unique || (unique && !values.containsKey(value))) {
             values.put(value,display);
             result += "<option value=\"" + value +"\"";
             if (selectValue != null && value.equals(selectValue))
               result += " selected";
               result += ">" + display + "</option>\n";
             }
          }
          result += "</select>";
        } catch (SQLException e) {
          throw new Exception("More than one field required in getDropDown:" + 
                               e.toString());
        } 
        return result;
   }
 
 
   /**
    * Return a drop down list (HTML select tag) where the options
    * are defined by the records returned by an SQL query.
    * <p>
    * It is assumed that the query returns a ResultSet in which
    * each row has at least 2 fields in it - the first is used as
    * the value of the option, the 2nd is the displayed value. Each
    * row becomes a HTML option tag
    * <P>
    * Unique only puts an element into the select box if it's
    * value is not already
    * <P>
    *
    * @param db          name of the database to query
    * @param sqlString   the SQL query to evaluate
    * @param name        the name of the select tag
    * @param unique      ensure that each entry has a different value
    * @param allValue    the value of first option on select
    * @param allName     the name of first value on select
    * @param selectValue The String to be selected by default
    * @return            a HTML select tag
    */
    public static String getDropDown(String db, String sqlString, String name) 
      throws Exception {
        return getDropDown(db, sqlString, name, false, null,null,null);
    }
    public static String getDropDown(String db, String sqlString, String name, 
                                     boolean unique)
      throws Exception {
        return getDropDown(db, sqlString, name, unique, null, null, null);
    }
    public static String getDropDown(String db, String sqlString, String name, 
                                     boolean unique, String allName)
      throws Exception {
        return getDropDown(db, sqlString, name, unique, "0", allName, null);
    }
    public static String getDropDown(String db, String sqlString, String name, 
                                     boolean unique, String allName, 
                                     String selectValue)
      throws Exception {
        return getDropDown(db, sqlString, name, unique, "0", allName, selectValue);
    }
 
    public static String getDropDown(String db, String sqlString, String name, 
                                     boolean unique, String allName, 
                                     String allValue, String selectValue)
      throws Exception {
        DBConnectionManager connMgr = DBConnectionManager.getInstance();
        Connection conn = connMgr.getConnection("HTMLUtil",db);
        if (conn == null) throw 
                           new RuntimeException("can't get connection: " + db);
        Statement s = conn.createStatement();
        ResultSet rs = null;
        try {
           rs = s.executeQuery(sqlString);
           return getDropDown(rs, name, unique, allName, 
                              allValue, selectValue);
        } catch (Exception e) {
            throw new Exception("Problem with query (" + sqlString + "):" +e.toString());
        }  finally {
            s.close();
            connMgr.freeConnection(db, conn);
        }
    }
 
 
 
     /**
      * Return a drop down list (select tag) from a DDField where the
      * options are given by the possible values of that Field.
      * <p>
      * This field should be a field linked (in the datadictionary)
      * to another table. The contents of (each record of) that table
      * are used to create the select box. Also, the field could be
      * a boolean field.
      * <p>
      * You can add another option using allName and allValue if mandatory is not set
      * <p>
      * The current value of the DDField is used to decide which option is
      * selected by default
      *
      * @param ddf         a DDField which we want to create a select box for
      *                      This is a field in a lookup table
      * @param db        name of the database to query
      * @param fieldname     the name of the field (and the select tag)
      *                      This is the name of the field containing the lookup
      * @param mandatory     if 'false' then a default extra option ("None") is
      *                      added, unless allName is set
      * @param allValue    the value of first option on select
      * @param allName    the name of first value on select
      * @return              a HTML select tag
      */
     public static String getDropDown(DDField ddf, String db, String allName) throws Exception {
         return getDropDown(ddf,db,ddf.getMetaData().getFieldName(),allName==null,"0",allName);
     }
 
     public static String getDropDown(DDField ddf, String db, String fieldname,
                                      boolean mandatory, String allValue, String allName)
                                                          throws Exception {
 
         Connection conn = null;
         Statement s = null;
 
         DBConnectionManager connMgr = DBConnectionManager.getInstance();
         String returnString = ("<select name=" + fieldname + ">\n");
         if (!mandatory || allName != null) {
             if (allName == null) allName = "None";
             if (allValue == null) allValue = "";
             returnString += "<option value=\"" + allValue + "\">" + allName + "</option>\n";
         }
         try {
             conn = connMgr.getConnection("HTMLUtil",db);
             s = conn.createStatement();
             String sqlString = new String("SELECT id, ");
             sqlString += ddf.getMetaData().getFieldName() + " FROM " + ddf.getMetaData().getTableName();
             if (!ddf.getMetaData().getType().equals("textarea") &&
                 !ddf.getMetaData().getType().equals("preformattedtextarea")
                ) {
                 sqlString += " ORDER BY " + ddf.getMetaData().getFieldName();
             }
             ResultSet rs = s.executeQuery(sqlString);
             while (rs.next()) {
                 String lookupId = rs.getString(1).trim();
                 String lookupValue = rs.getString(2);
                 if (lookupValue != null) {
                     lookupValue = lookupValue.trim();
                     returnString += "<option value=" + lookupId;
                     if ((ddf.getValue() != null) && (lookupId.equals(ddf.getValue().toString())))
                         returnString += " selected";
                     returnString += ">" + lookupValue + "</option>\n";
                 }
             }
             returnString += "</select>\n";
             connMgr.freeConnection(db, conn);
             return returnString;
         } catch (SQLException e) {
             throw new Exception("More than one field required in getDropDown:" + e.toString());
         } catch (Exception e) {
             throw new Exception("Failed to build Lookup list:" + e.toString());
         }  finally {
             s.close();
             connMgr.freeConnection(db, conn);
         }
     }
 
 
 
 
 
 
 
 
 
 
     /**
      * Formats a DDField to be displayed on a html page as in input box of the correct type
      *
      * @param ddf             a DDField which we want to create an input box for
      * @param db            name of the database to query
      * @param dateFormatter     format for dates
      * @param dateTimeFormatter format for date and times
      * @return                  a HTML input tag
      */
     public static String getInputValue(DDField ddf, String db, SimpleDateFormat dateFormatter,
                                        SimpleDateFormat datetimeFormatter, String allValue, String postfix) throws Exception {
         String fieldname = ddf.getMetaData().getFieldName();
         if (postfix != null) fieldname += postfix;
         String returnString = "";
         if (ddf.getMetaData().getRelationshipTable().equals("")) {
 
             // Textarea and preformattedtextarea
             if (ddf.getMetaData().getType().equals("textarea") ||
                 ddf.getMetaData().getType().equals("preformattedtextarea")
                ) {
                 returnString += "<textarea name=" + fieldname;
                 returnString += " cols=";
                 if (ddf.getMetaData().getSize() > 0) {
                     returnString += ddf.getMetaData().getSize();
                 } else {
                     returnString += "40";
                 }
                 returnString += " rows=";
                 if (ddf.getMetaData().getHeight() > 0) {
                     returnString += ddf.getMetaData().getHeight();
                 } else {
                     returnString += "6";
                 }
                 returnString += " wrap=virtual>";
                 if (ddf.getValue() != null) {
                     returnString += escapeHTML(ddf.getValue().toString());
                 }
                 returnString += "</textarea>";
                 return returnString;
 
             // boolean
             } else if (ddf.getMetaData().getType().equals("boolean")) {
                 returnString += "<input type=checkbox value=true name=" + fieldname;
                 if ((ddf.getValue() != null) && ((Boolean)ddf.getValue()).booleanValue()) {
                     returnString += " checked ";
                 }
                 returnString += ">";
                 return returnString;
 
             // autorandom
             } else if (ddf.getMetaData().getType().equals("autorandom")) {
                 if (ddf.getValue() != null) {
                     returnString += escapeHTML(ddf.getValue().toString());
                 }
                 returnString += " (read-only)";
                 return returnString;
 
             // id
             } else if (ddf.getMetaData().getType().equals("id")) {
                 if (ddf.getValue() != null) {
                     returnString += ddf.getValue().toString();
                 }
                 return returnString;
 
             // date
             } else if (ddf.getMetaData().getType().equals("date")) {
                 returnString += "<input type=text name=" + fieldname + " value=\"";
                 if (ddf.getValue() != null) {
                     returnString += dateFormatter.format((java.util.Date) ddf.getValue());
                 }
                 returnString += "\" size=" + ddf.getMetaData().getSize();
                 returnString += "\"> (dd/mm/yyyy)";
                 return returnString;
 
             // datedrop
             } else if (ddf.getMetaData().getType().equals("datedrop")) {
                 java.util.Date thisDate = (java.util.Date) ddf.getValue();
                 Calendar calendar = Calendar.getInstance();
                 if (thisDate != null) calendar.setTime(thisDate);
 
                 returnString += "<select name=" + fieldname + "_date>\n";
                 for (int i=1;i<32;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.DAY_OF_MONTH) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_month>\n";
                 for (int i=1;i<13;i++) {
                     returnString += "<option value="+i;
                     if (thisDate != null && calendar.get(Calendar.MONTH)+1 == i) returnString += " selected";
                     returnString += ">"+months[i]+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_year>\n";
 
                 int startyear;
                 int endyear;
                 try {
                     SystemProperties sp = new SystemProperties(db);
                     String start = sp.getProperty("startyear");
                     String end = sp.getProperty("endyear");
                     if (start.equals("") || end.equals(""))
                         throw new Exception("Can't get startyear or endyear from SystemProperties");
                     startyear = Integer.parseInt(start);
                     endyear = Integer.parseInt(end);
                 } catch (Exception e) {
                     throw new Exception("Can't get startyear or endyear from SystemProperties: "+e.toString());
                 }
 
                 for (int i=startyear;i<=endyear;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.YEAR) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 return returnString;
 
             // datetime
             } else if (ddf.getMetaData().getType().equals("datetime")) {
                 returnString += "<input type=text name=" + fieldname + " value=\"";
                 if (ddf.getValue() != null) {
                     returnString += datetimeFormatter.format((java.util.Date) ddf.getValue());
                 }
                 returnString += "\" size=" + ddf.getMetaData().getSize();
                 returnString += "\"> (dd/mm/yyyy hh:mm)";
                 return returnString;
 
             // timestamp
             } else if (ddf.getMetaData().getType().equals("timestamp")) {
                 if (ddf.getValue() != null) {
                     returnString += datetimeFormatter.format((java.util.Date) ddf.getValue());
                 }
                 return returnString;
 
             // datetimedrop
             } else if (ddf.getMetaData().getType().equals("datetimedrop")) {
                 java.util.Date thisDate = (java.util.Date) ddf.getValue();
                 Calendar calendar = Calendar.getInstance();
                 if (thisDate != null) calendar.setTime(thisDate);
 
                 returnString += "<select name=" + fieldname + "_date>\n";
                 for (int i=1;i<32;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.DAY_OF_MONTH) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_month>\n";
                 for (int i=1;i<13;i++) {
                     returnString += "<option value="+i;
                     if (thisDate != null && calendar.get(Calendar.MONTH)+1 == i) returnString += " selected";
                     returnString += ">"+months[i]+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_year>\n";
                 for (int i=1999;i<2011;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.YEAR) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_hour>\n";
                 for (int i=0;i<24;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.HOUR) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 returnString += "<select name=" + fieldname + "_minute>\n";
                 for (int i=0;i<60;i++) {
                     returnString += "<option";
                     if (thisDate != null && calendar.get(Calendar.MINUTE) == i) returnString += " selected";
                     returnString += ">"+i+"\n";
                 }
                 returnString += "</select>\n\n";
                 return returnString;
 
             // text, password, uploadurl
             } else {
                 returnString += "<input type=";
                 if (ddf.getMetaData().getType().equals("password")) {
                     returnString += "password";
                 } else {
                     returnString += "text";
                 }
                 returnString += " name=" + fieldname + " value=\"";
                 if (ddf.getValue() != null)  {
                    
         //28/01/2000 code reinstated as i don't think it should have been removed
                 // display 0 numbers as blank
                     if (ddf.getMetaData().getType().equals("integer") && ((Integer)ddf.getValue()).equals(new Integer(0))) {}
                         else if ((ddf.getMetaData().getType().equals("number") || ddf.getMetaData().getType().equals("currency")) && ((Double)ddf.getValue()).equals(new Double(0))) {}
                         else if (ddf.getMetaData().getType().equals("long") && ((Long)ddf.getValue()).equals(new Long(0))) {}
                         else { 
                         returnString += escapeHTML(ddf.getValue().toString().trim());
                         }
                 }
                 returnString += "\" size=" + ddf.getMetaData().getSize();
                 if (ddf.getMetaData().getMaxLength() > 0) {
                     returnString += " maxlength=" + ddf.getMetaData().getMaxLength();
                 }
                 returnString += ">";
                 return returnString;
             }
         } else {
             if (ddf.getMetaData().getType().equals("lookupwindow")) {
                 return "";
             } else if (ddf.getMetaData().getType().equals("lookupnodrop")) {
                 returnString += "<input type=text name=" + fieldname + " value=\"";
                 DDRecord rs = ddf.getLookup();
                 if (ddf.getValue() != null)  {
                     DDField field = (DDField) rs.get("id");
                     returnString += field.getDisplayValue();
                 }
                 returnString += "\" size=" + ddf.getMetaData().getSize() + ">";
                 if (ddf.getValue() != null)  {
                     DDField field = (DDField) rs.get(ddf.getMetaData().getRelationshipField());
                     returnString += " " + field.getDisplayValue();
                 }
                 return returnString;
             } else {
                 DDRecord relationship = new DDRecord(db,ddf.getMetaData().getRelationshipTable());
                 DDField field = (DDField) relationship.get(ddf.getMetaData().getRelationshipField());
                 if (ddf.getValue() != null) {
                     field.setValue(ddf.getValue().toString());
                 }
                 String lookup = field.getDropDown(fieldname,ddf.getMetaData().getMandatory(),allValue);
                 return lookup;
             }
         }
     }
 
     /**
      * Formats a DDField to be displayed on a html page as a hidden field
      *
      * @param ddf               The DDField to create an input box for
      * @param db                name of the database to query
      * @param dateFormatter     format for dates
      * @param dateTimeFormatter format for date and times
      * @return                  a HTML input tag
      */
     public static String getHiddenValue(DDField ddf, String db, 
                                        SimpleDateFormat dateFormatter,
                                        SimpleDateFormat datetimeFormatter, 
                                        String postfix) 
       throws Exception {
         String fieldname = ddf.getMetaData().getFieldName();
         if (postfix != null) fieldname += postfix;
         String returnString = "<input type=hidden name=" + fieldname + 
                               " value=\"";
         if (ddf.getValue() != null) {
             if (ddf.getMetaData().getType().equals("date") ||
                 ddf.getMetaData().getType().equals("datedrop") ) {
                     returnString += dateFormatter.format(
                                       (java.util.Date) ddf.getValue());
             }
             else if (ddf.getMetaData().getType().equals("datetime") ||
                      ddf.getMetaData().getType().equals("datetimedrop") ) {
                     returnString += datetimeFormatter.format(
                                       (java.util.Date) ddf.getValue());
             }
             else
                 returnString += ddf.getValue().toString().trim();
         }
         returnString += "\">";
         return returnString;
     }
 
 
    /**
     * Returns a JavaScript tag which will validate the field using JS
     * (remember to include the relevant functions to handle the validation
     * request in your template). This file is also the place to look for
     * the most up-to-date documentation.
     *<P>
     * Presently the returned String should look like:
     *<pre>
     * <SCRIPT language="JavaScript1.2">
     * add_rule("fieldname_1","Display Name",0,"^regular\\w expression$", "statements")
     * </SCRIPT>
     *</pre>
     * The <b>first 2 arguments</b> are strings which contain the name of 
     * the input field and what to call it. 
     * These should be the params fieldname and displayname for
     * this function, but remember to wrap quotes around them!
     * <p>
     * The <b>third argument<b> should be 0 if mand is false, 1 otherwise 
     * (actually, javascript treats anything other than 0, "0", false and 
     * the null object as true).
     * <p>
     * The fourth argument is a regular expression which any value entered 
     * into the HTML form must match against for validation to succeed. 
     * Note that this needs to have quotes wrapped around it. 
     * Since this ends up as a JavaScript string, we also
     * need to escape special characters with '\', 
     * including '\' itself (hence the '\\w'
     * in the example above - 
     * we want the expression to contain the 2 characters '\w',
     * not CTRL-w. 
     * If you put brackets into your expression then JavaScript will allow
     * you to access them through the global (to each window) variable RegExp as
     * RegExp.$1 ... RegExp.$9. 
     * You can leave this out if you only want to check if a
     * a mandatory value is set or not.
     * <p>
     * The fifth argument is the body of JavaScript function. 
     * You can use this to
     * perform more general validation tests than just matching a regular 
     * expression, or you can leave it out altogether. 
     * It has access to one formal paramater,
     * 'value' - the value of the input field being validated. It also
     * has access to global variables such as RegExp.$1. 
     * It should return nothing
     * (or an empty string) if validation succeeds, otherwise it should return a
     * string to be shown to the user explaining the problem. Remeber to print
     * double quotes around it.
     * <p>
     * Because we've got to escape all these quotes and escapes in this 
     * function, the strings are a bit messy, especially since there are 
     * a few '\n's to improve readability in the HTML source. Be careful.
     * <p>
     * <b>ALTERNATIVELY</b>, 
     * you can use some rules which are predefined in the javascript:
     *   add_integer("fieldname_1", "Display Name", 0);
     *   add_number("fieldname_1", "Display Name", 0);
     *   add_date("fieldname_1", "Display Name", 0);
     *   add_datetime("fieldname_1", "Display Name", 0);
     *
     *
     * @param  ddf          A DDField representing a field in the datadictionary
     * @param  fieldname    The name of the input tag to be validated
     * @param  displayname  What to call the input field for the user's benefit
     * @param  mand         Whether the field is mandatory (cannot be empty)
     * @return A            JavaScript tag which will validate ddf on the 
     *                      client side when the form is submitted. 
     *
     */
     public static String getJSValidation(DDField ddf, String fieldname, 
                                          String displayname, boolean mand) {
 
         String whichRule = "";
         String mandatory    = (mand) ? "1":"0";
 
 /*
     A demo of how to create a new validation field in java
 
         // Pretend fieldtype
         if (ddf.getMetaData().getType().equals("time") {
             return "<SCRIPT language=\"JavaScript1.2\">add_rule("
                     +"\""+fieldname+"\", "
                     +"\""+displayname+"\", "
                     +mandatory+ ", "
                     +"\"(\\d\\d):\\d\\d\", "
                     +"\"return (RegExp.$1>23)?'There are only 24 hours in a day!':'';\""
                    +")</SCRIPT>";
         }
 */
         // No validation (incl. mandatory) for lookups
 //        if (!ddf.getMetaData().getRelationshipTable().equals("")) { return ""; }
         // No validation (incl. mandatory) for booleans
         if (ddf.getMetaData().getType().equals("boolean")) { return ""; }
         // No validation (incl. mandatory) for autorandom
         if (ddf.getMetaData().getType().equals("autorandom")) { return ""; }
         // No validation (incl. mandatory) for id
         if (ddf.getMetaData().getType().equals("id")) { return ""; }
         // No validation (incl. mandatory) for datedrop
         if (ddf.getMetaData().getType().equals("datedrop")) { return ""; }
         // No validation (incl. mandatory) for datetimedrop
         if (ddf.getMetaData().getType().equals("datetimedrop")) { return ""; }
 
         if (ddf.getMetaData().getType().equals("date")) { whichRule = "add_date"; }
         // Only check for mandatory for lookups
         else if (!ddf.getMetaData().getRelationshipTable().equals("")) { whichRule = "add_rule"; }
         else if (ddf.getMetaData().getType().equals("datetime")) { whichRule = "add_datetime"; }
         else if (ddf.getMetaData().getType().equals("integer")) { whichRule = "add_integer"; }
         else if (ddf.getMetaData().getType().equals("number") || ddf.getMetaData().getType().equals("currency"))   { whichRule = "add_number"; }
 // Only check for mandatory in text, textarea, preformattedtextarea, 
 // password, uploadurl
         else { whichRule = "add_rule"; }
 
         return "<SCRIPT language=\"JavaScript1.2\">"+
                whichRule+"(\""+fieldname+"\", \""+displayname+"\", "+mandatory+")</SCRIPT>";
     }
 
 }