package customAdv;


import com.hof.mi.interfaces.AnalyticalFunction;
import com.hof.mi.interfaces.UserInputParameters;
import com.hof.mi.interfaces.UserInputParameters.Parameter;
import com.hof.util.Const;
import com.hof.util.UtilString;
import java.math.BigDecimal;
import java.sql.Date;
import java.util.HashMap;

public class GroupedPercentageOfTotal
  extends AnalyticalFunction
{
  private HashMap<String, BigDecimal> groupTotals;  
  public String getName()
  {
    return "Sectioned Percentage of Total";
  }
  
  public String getDescription()
  {
    return  "Calculates the percentage of total against the specified grouping column.";
  }
  
  public String getColumnHeading(String paramString)
  {
    return "Derived"+paramString;
  }
  
  public String getCategory()
  {
    return UtilString.getResourceString("mi.text.analysis");
  }
  
  public int getReturnType()
  {
    return TYPE_NUMERIC;
  }
  
  public boolean acceptsNativeType(int paramInt)
  {
    return paramInt == TYPE_NUMERIC;
  }
  
  protected void setupParameters()
  {
    Parameter p = new Parameter();
    p.setUniqueKey("REFCOL");
    p.setDisplayName(UtilString.getResourceString("mi.text.analytic.function.dividebycolumn.parameter.column.name"));
    p.setDescription("Reference Column");
    p.setDataType(100);
    p.setAcceptsFieldType(TYPE_DATE, true);
    p.setAcceptsFieldType(TYPE_TEXT, true);
    p.setDisplayType(6);
    addParameter(p);
    
    
    
    
  }
  public void preAnalyticFunction(Object[] selectedCol) {
	Object[] referenceCol = (Object[]) getParameterValue("REFCOL");
	groupTotals = new HashMap<String, BigDecimal>();
	for (int i=0;i<selectedCol.length;i++){
		if (selectedCol[i]!=null && referenceCol[i]!= null){
			if (groupTotals.keySet().contains(referenceCol[i])){
				BigDecimal total = groupTotals.get(referenceCol[i]);
				groupTotals.put(referenceCol[i].toString(), total.add(new BigDecimal(selectedCol[i].toString())));
			}else{
				groupTotals.put(referenceCol[i].toString(), new BigDecimal(selectedCol[i].toString()));
			}
		}
	}
	for (String key : groupTotals.keySet()){
		System.out.println(key + ":"  +groupTotals.get(key));

	}

  }
  public Object applyAnalyticFunction(int i, Object val)
  {
    Object[] referenceCol = (Object[])getParameterValue("REFCOL");
    BigDecimal total = groupTotals.get(referenceCol[i].toString());
    if (total==null || val==null || total.compareTo(new BigDecimal("0"))==0){
    	return null;
    }
    return new BigDecimal(val.toString()).divide(total,50,4).multiply(new BigDecimal("100"));
  }
}