• Home
• net.sf.ucanaccess
• ucanaccess
• 4.0.2
• source code
• Functions.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

net.ucanaccess.converters.Functions Maven / Gradle / Ivy

/*
Copyright (c) 2012 Marco Amadei.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

NOTICE:
Most of the financial functions (PMT, NPER, IPMT, PPMT, RATE, PV Function class methods) have been originally copied from the Apache POI project (Apache Software Foundation) . 
They have been then modified and adapted so that they are integrated with UCanAccess, in a consistent manner. 
The  Apache POI project is licensed under Apache License, Version 2.0 http://www.apache.org/licenses/LICENSE-2.0.

 */
package net.ucanaccess.converters;

import java.math.BigDecimal;
import java.math.MathContext;
import java.sql.Timestamp;
import java.text.DateFormatSymbols;
import java.text.DecimalFormat;
import java.text.DecimalFormatSymbols;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Currency;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.List;
import java.util.Locale;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import net.ucanaccess.converters.TypesMap.AccessType;
import net.ucanaccess.ext.FunctionType;
import net.ucanaccess.jdbc.UcanaccessSQLException;
import net.ucanaccess.jdbc.UcanaccessSQLException.ExceptionMessages;

import com.healthmarketscience.jackcess.DataType;

public class Functions {
	private static Double rnd;
	private static Double lastRnd;
	public final static ArrayList LDF = new ArrayList();
	public final static ArrayList LDFY = new ArrayList();
	public final static  RegionalSettings reg=new RegionalSettings();
	private final static double APPROX=0.00000001;
	private static boolean pointDateSeparator;
	static {
		pointDateSeparator=getPointDateSeparator();
		addDateP("yyyy-MM-dd h:m:s a");
		addDateP("yyyy-MM-dd H:m:s");
		addDateP("yyyy-MM-dd");
		addDateP("yyyy/MM/dd h:m:s a");
		addDateP("yyyy/MM/dd H:m:s");
		addDateP("yyyy/MM/dd");
		
		
		addDateP(reg.getGeneralPattern(),true);
		addDateP(reg.getLongDatePattern(),true);
		addDateP(reg.getMediumDatePattern(),true);
		
		addDateP(reg.getShortDatePattern(),true);
		
		
		if(!Locale.getDefault().equals(Locale.US)){
			
			RegionalSettings s=new RegionalSettings(Locale.US);
			addDateP(s.getGeneralPattern(),false);
			addDateP(s.getLongDatePattern(),true);
			addDateP(s.getMediumDatePattern(),true);
			addDateP(s.getShortDatePattern(),true);
			
		}
		addDateP("MMM dd,yyyy");
		addDateP("MM dd,yyyy");
		addDateP("MMM dd hh:mm:ss",false,true);
		addDateP("MM dd hh:mm:ss",false,true);
		addDateP("MMM yy hh:mm:ss");
		addDateP("MM yy hh:mm:ss");
		//locale  is MM/dd/yyyy like in US but user is trying to parse something like 22/11/2003
		addDateP("dd/MM/yyyy h:m:s a",true);
		addDateP("dd/MM/yyyy H:m:s",true);
		addDateP("dd/MM/yyyy",true);
	
	}
	
	private static boolean getPointDateSeparator(){
		String[] dfsp=new String[]{reg.getGeneralPattern(),reg.getLongDatePattern(),reg.getMediumDatePattern(),reg.getShortDatePattern()};
		for(String pattern:dfsp){
			if(pattern.indexOf(".")>0&&pattern.indexOf("h.")<0&&pattern.indexOf("H.")<0){ 
				return true;
			}
		}
		return false;
	}
	
	private static void addDateP(String sdfs){
		 addDateP(sdfs,false,false);
	}
	private static void addDateP(String sdfs,boolean euristic){
		 addDateP(sdfs,euristic,false);
	}
	
	private static void addTogglePattern(String pattern){
		
		if(pattern.indexOf("/")>0){
				addDateP(pattern.replaceAll("/","-"));
			if(pointDateSeparator){
				addDateP(pattern.replaceAll("/","."));	
			}
		}else
		if(pattern.indexOf("-")>0){
			addDateP(pattern.replaceAll(Pattern.quote("-"),"/"));
			if(pointDateSeparator){
				addDateP(pattern.replaceAll(Pattern.quote("-"),"."));	
			}
		
		}else if(pattern.indexOf(".")>0&&pattern.indexOf("h.")<0&&pattern.indexOf("H.")<0){
			addDateP(pattern.replaceAll(Pattern.quote("."),"/"));
		}
	}
	private static SimpleDateFormat simpleDateFormat(String pt){
		SimpleDateFormat sdf=new SimpleDateFormat(pt);
		 ((GregorianCalendar)sdf.getCalendar()).setGregorianChange(new java.util.Date(Long.MIN_VALUE));
		 return sdf;
	}
	
	private static void addDateP( String sdfs,boolean euristic,boolean yearOverride){
		if(euristic){
			if(sdfs.indexOf("a")<0&&sdfs.indexOf("H")>0){
				String chg=sdfs.replaceAll("H","h")+" a";
				addDateP(chg);
				addTogglePattern(chg);
			}
		}
		
		SimpleDateFormat sdf=simpleDateFormat(sdfs);
		sdf.setLenient(false);
		
		if("true".equalsIgnoreCase(reg.getRS())){
			
			DateFormatSymbols df=new DateFormatSymbols();
			df.setAmPmStrings(new String[]{"AM","PM"});
			sdf.setDateFormatSymbols(df);
		}
		
		LDF.add(sdf);
		LDFY.add(yearOverride);
		if(euristic){
			addTogglePattern(sdfs);
			if(sdfs.endsWith(" a")&&sdfs.indexOf("h")>0){
				String chg=sdfs.substring(0,sdfs.length()-2).trim().replaceAll("h","H");
				addDateP(chg);
				addTogglePattern(chg);
			}
		}
        
	}


	@FunctionType(functionName = "ASC", argumentTypes = { AccessType.MEMO }, returnType = AccessType.LONG)
	public static Integer asc(String s) {
		if (s == null || s.length() == 0)
			return null;
		return (int) s.charAt(0);
	}
	
	@FunctionType(functionName = "EQUALS", argumentTypes = { AccessType.COMPLEX,AccessType.COMPLEX }, returnType = AccessType.YESNO)
	public static Boolean equals(Object obj1,Object obj2) {
		if(obj1==null||obj2==null)return false;
		if(!obj1.getClass().equals(obj2.getClass()))
		return false;
		if(obj1.getClass().isArray()){
			return Arrays.equals((Object[])obj1,(Object[])obj2);
		}
		return obj1.equals(obj2);
	}
	
	
	@FunctionType(functionName = "EQUALSIGNOREORDER", argumentTypes = { AccessType.COMPLEX,AccessType.COMPLEX }, returnType = AccessType.YESNO)
	public static Boolean equalsIgnoreOrder(Object obj1,Object obj2) {
		if(obj1==null||obj2==null)return false;
		if(!obj1.getClass().equals(obj2.getClass()))
		return false;
		if(obj1.getClass().isArray()){
			List