Subversion Repositories DevTools

/*
 * Created on 31/03/2005
 */
package DMS;

import java.text.SimpleDateFormat;
import java.util.Vector;
import java.net.URLEncoder;
import java.io.InputStream;
import java.io.File;
import java.io.FileWriter;
import java.sql.Timestamp;

/**
 * @author mtayler
 */
public class DMSUtils {
        
        //log errors for debugging
        public static void log(String s) {
                File log=null;
                FileWriter fw=null;
                
                if (log==null) {
                        log = new File ("C:\\Program Files\\Apache Software Foundation\\Tomcat 5.0\\logs\\log.txt");
                        try {
                        if (!log.exists())      log.createNewFile();                    
                        fw = new FileWriter(log, true);
                        } catch (Exception e){e.printStackTrace();}
                }
                
                try {
                fw.write(s);
                fw.write(13);
                fw.write(10);
                fw.flush();
                fw.close();             
                } catch (Exception e){e.printStackTrace();}
        }
        
        public static Object NVL(Object obj, Object defValue) {
                if (obj==null) return defValue;
                else return obj;
        }

        public static String NVL(String obj, String defValue) {
                return (String)NVL((Object)obj,(Object)defValue);
        }

        public static String NVL(String obj) {
                return (String)NVL((Object)obj,(Object)new String(""));
        }
        
        public static comboDataItem[] genComboDataItemArray(String[] values, String[] descrips) {
                Vector v = new Vector();
                
                for (int i=0;i<values.length;i++) {
                        comboDataItem di = new comboDataItem(values[i],descrips[i]);
                        v.add(di);
                }
                return (comboDataItem[])v.toArray(new comboDataItem[0]);                
        }       
        
        
        //generate a properly encoded URL string
        public static String cleanURLStr(String value) {
                String ret = null;
                try {
                        ret = URLEncoder.encode(value, "UTF8");
                } catch (Exception e) {
                        e.printStackTrace();
                }
                
                return ret;
        }       
        
        //generate a properly encoded HTML string
        public static String cleanHTMLStr(String value, boolean showlinebreak) {
            StringBuffer sbClean = new StringBuffer("");            
            
            if (value == null || value.trim().equals("")) sbClean.append("&nbsp;");
            
            if (value != null) {
              for (int i=0; i<value.length(); i++) {
                switch (value.charAt(i)) {
                  case '<': sbClean.append("&lt;"); break;
                  case '>': sbClean.append("&gt;"); break;
                  case '\"': sbClean.append("&quot;"); break;
                  case '\'': sbClean.append("&#39;"); break;
                  case '&': sbClean.append("&amp;"); break;
                  case '\r': break;
                  case '\n':
                    if (showlinebreak)
                      sbClean.append("<br>\n");
                    else
                      sbClean.append('\r');
                  default:
                    int c = (int)value.charAt(i);
                    if (c<32 && c>126) sbClean.append("&#" + String.valueOf(c) + ";");
                    else sbClean.append(value.charAt(i));
                }
              }
            }
            return sbClean.toString();
        }

        //generate a properly encoded HTML string
        public static String cleanHTMLStr(String value){
            return cleanHTMLStr(value, false);
        }

        //generate a properly encoded Javascript string
        public static String cleanJStr(String value) {
                String ret = value;
                try {
                        ret = DMSUtils.StrReplace(ret, "\\\\", "\\", true);
                        ret = DMSUtils.StrReplace(ret, "\\\"", "\"", true);
                        ret = DMSUtils.StrReplace(ret, "\\'", "'", true);                       
                } catch (Exception e) {
                        e.printStackTrace();
                }
                
                return ret;
        }
        

        public static InputStream getResourceAsStream(String aFileName) {
            //return ClassLoader.getSystemResourceAsStream(aFileName);
                DMSUtils c = new DMSUtils();
            return c.getClass().getClassLoader().getResourceAsStream(aFileName);
        }
          
        public static String StrReplace(String aStr, String aNew, String aOld,boolean aRepAll){
                int iStart = aStr.indexOf(aOld);
                if (iStart==-1){
                  return aStr;
                }
                if (aRepAll){
                  return aStr.substring(0,iStart)+aNew+StrReplace(aStr.substring(iStart+aOld.length()),aNew,aOld,aRepAll);
                }
                else {
                  return aStr.substring(0,iStart)+aNew+aStr.substring(iStart+aOld.length());
                }
        }         
          
        public static String replaceParams(String URL, dbTemplateData templateData) {
                int startIndex;
                int endIndex;
                String fieldName, data, tempURL;

                tempURL = URL;
                startIndex = 0;
                while (startIndex != -1) {
                        startIndex = tempURL.indexOf("{");
                        endIndex = tempURL.indexOf("}");
                        if (startIndex != -1) {
                                fieldName = tempURL.substring(startIndex+1,endIndex).trim();
                                data=DMSUtils.NVL(templateData.getFieldValue(fieldName));
                                tempURL=tempURL.substring(0,startIndex) + DMSUtils.cleanURLStr(data) + tempURL.substring(endIndex+1,tempURL.length());
                        }
                }
                
                return tempURL;
        }
          
        public static int compareToValue(String value1, String value2, boolean isAscending) {
                return compareToValue(value1, value2, "string", "", isAscending);               
        }
        
        public static int compareToValue(String value1, String value2, String datatype, String format, boolean isAscending) {
                int sign = 0;
                if (isAscending) sign = 1;
                else sign = -1;

                if (datatype.equals("date")||datatype.equals("datetime")) {
                        Timestamp tvalue1 = StringToTimestamp(value1, format);
                        Timestamp tvalue2 = StringToTimestamp(value2, format);
                                                
                        if (tvalue1==null && tvalue2!=null) return -1*sign; 
                        else if (tvalue1==null && tvalue2==null) return 0;
                        else if (tvalue1!=null && tvalue2==null) return 1*sign;                         
                        else return tvalue1.compareTo(tvalue2)*sign;
                        
                } else if (datatype.equals("number")||datatype.equals("integer")||datatype.equals("int")||datatype.equals("bigint")) {
                        Integer ivalue1 = DMSUtils.StringToInteger(value1);
                        Integer ivalue2 = DMSUtils.StringToInteger(value2);

                        if (ivalue1==null && ivalue2!=null) return -1*sign; 
                        else if (ivalue1==null && ivalue2==null) return 0;
                        else if (ivalue1!=null && ivalue2==null) return 1*sign;                         
                        else return ivalue1.compareTo(ivalue2)*sign;
                        
                } else {
                        return DMSUtils.NVL(value1).compareToIgnoreCase(DMSUtils.NVL(value2))*sign;
                }
        }
        
          
        private static void addSortedStringArray(Vector array, boolean isAscending, String data, int startIndex, int endIndex) {
                String firstRecordValue = DMSUtils.NVL((String)array.get(startIndex));
                String lastRecordValue = DMSUtils.NVL((String)array.get(endIndex));
                String newValue = DMSUtils.NVL(data);
                        
                if (compareToValue(firstRecordValue, newValue, isAscending)>0) { //if newValue is less than firstValue
                        array.insertElementAt(data,startIndex); //insert before the first record
                } else if (compareToValue(lastRecordValue, newValue, isAscending)<=0) { //if newValue is greater than or equal to the lastValue                         
                        array.insertElementAt(data,endIndex+1); //insert after the last record
                } else if (startIndex == endIndex-1) { //if there are no more records in between
                        array.insertElementAt(data,startIndex+1); //insert after the first record
                } else {
                        //recursive sort
                        int midIndex = (startIndex + endIndex) / 2;                                                                     
                        String midRecordValue = DMSUtils.NVL((String)array.get(midIndex));
                                                
                        if (compareToValue(midRecordValue, newValue, isAscending)>0) { //if newValue is less than midRecordValue
                                addSortedStringArray(array, isAscending, data, startIndex+1, midIndex);
                        } else {
                                addSortedStringArray(array, isAscending, data, midIndex, endIndex-1);
                        }                       
                }               
        }         
          
        public static String[] SortArray(String [] data) {
                 Vector v = new Vector();
                 
                 for (int i=0; i< data.length; i++) {
                        if (i==0) v.add(data[i]);
                        else addSortedStringArray(v, true, data[i], 0, i-1);
                 }
                 
                 return (String[])v.toArray(new String[0]);
        }
          
        //generate a properly encoded CSV cell string
        public static String cleanCSV(String value) {
                String ret = DMSUtils.NVL(value);
                try {
                        ret = DMSUtils.StrReplace(ret, "\"\"", "\"", true);
                        ret = DMSUtils.StrReplace(ret, "\n","\r\n", true);
                        ret = "\"" + ret + "\"";
                } catch (Exception e) {
                        e.printStackTrace();
                }
                        
                return ret;
        }

        public static String TimestampToString(Timestamp value, String format) {        
                SimpleDateFormat df = new SimpleDateFormat(format);                     
                return df.format(value);
        }

        public static int StringToInt(String value) {
                return Integer.valueOf(value).intValue();
        }
        
        public static Integer StringToInteger(String value) {
                Integer ret = null;             
                try {
                        ret = new Integer(value);       
                } catch (Exception e){e.printStackTrace();}
                return ret;
        }


        public static Timestamp StringToTimestampEndOfDay(String year, String month, String day) {
                return StringToTimestamp(year, month, day, "23", "59", "59");
        }

        public static Timestamp StringToTimestamp(String year, String month, String day, String hour, String minute, String second) {
                Timestamp data = null;
                
                try {
                        int iYear = StringToInt(year);
                        if (iYear>1900) iYear = iYear-1900;
                        int iMonth = StringToInt(month);
                        int iDay = StringToInt(day);
                        int iHour = StringToInt(hour);
                        int iMinute = StringToInt(minute);
                        int iSecond = StringToInt(second);
                        
                        data = new Timestamp(iYear, iMonth, iDay, iHour, iMinute, iSecond,0);   
                } catch (Exception e) {e.printStackTrace();}
                                                
                return data;
        }
        
        public static Timestamp StringToTimestamp(String year, String month, String day) {
                return StringToTimestamp(year, month, day, "0", "0", "0");
        }
        
        public static Timestamp StringToTimestamp(String value, String format) {
                Timestamp data = null;
                
                SimpleDateFormat df = new SimpleDateFormat(format);                     

                try {
                        java.util.Date d = df.parse(value); 

                        data = new Timestamp(d.getYear(), d.getMonth(), d.getDate(),d.getHours(),d.getMinutes(),d.getSeconds(),0);
                } catch (Exception e) {e.printStackTrace();}
                        
                return data;
        }
        

}