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.
package toolgood.algorithm.internals;
import org.antlr.v4.runtime.tree.AbstractParseTreeVisitor;
import org.antlr.v4.runtime.tree.TerminalNode;
import org.apache.commons.text.StringEscapeUtils;
import org.joda.time.DateTime;
import org.joda.time.DateTimeConstants;
import org.joda.time.DateTimeZone;
import toolgood.algorithm.MyDate;
import toolgood.algorithm.Operand;
import toolgood.algorithm.enums.*;
import toolgood.algorithm.litJson.JsonData;
import toolgood.algorithm.litJson.JsonMapper;
import toolgood.algorithm.math.mathParser.*;
import toolgood.algorithm.math.mathVisitor;
import toolgood.algorithm.mathNet.ExcelFunctions;
import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;
import java.net.URLDecoder;
import java.net.URLEncoder;
import java.text.DecimalFormat;
import java.util.*;
import java.util.function.Function;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class MathVisitor extends AbstractParseTreeVisitor implements mathVisitor {
private static final Pattern sumifRegex = Pattern
.compile("(<|<=|>|>=|=|==|===|!=|!==|<>) *([-+]?\\d+(\\.(\\d+)?)?)");
private static final Pattern bit_2 = Pattern.compile("^[01]+");
private static final Pattern bit_8 = Pattern.compile("^[0-8]+");
private static final Pattern bit_16 = Pattern.compile("^[0-9a-fA-F]+");
private static final Pattern clearRegex = Pattern.compile("[\\f\\n\\r\\t\\v]");
private static final Pattern numberRegex = Pattern.compile("^-?(0|[1-9])\\d*(\\.\\d+)?$");
public Function GetParameter;
public Function DiyFunction;
public int excelIndex;
public boolean useLocalTime;
public DistanceUnitType DistanceUnit = DistanceUnitType.M;
public AreaUnitType AreaUnit = AreaUnitType.M2;
public VolumeUnitType VolumeUnit = VolumeUnitType.M3;
public MassUnitType MassUnit = MassUnitType.KG;
public Operand visitProg(final ProgContext context) {
return context.expr().accept(this);
}
public Operand visitMulDiv_fun(final MulDiv_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0);
Operand secondValue = args.get(1);
final String t = context.op.getText();
if (firstValue.Type() == OperandType.TEXT) {
if (numberRegex.matcher(firstValue.TextValue()).find()) {
final Operand a = firstValue.ToNumber(null);
if (a.IsError() == false)
firstValue = a;
} else {
final Operand a = firstValue.ToDate(null);
if (a.IsError() == false)
firstValue = a;
}
}
if (secondValue.Type() == OperandType.TEXT) {
if (numberRegex.matcher(secondValue.TextValue()).find()) {
final Operand a = secondValue.ToNumber(null);
if (a.IsError() == false)
secondValue = a;
} else {
final Operand a = secondValue.ToDate(null);
if (a.IsError() == false)
secondValue = a;
}
}
if (CharUtil.Equals(t, "*")) {
if (secondValue.Type() == OperandType.BOOLEAN) {
if (secondValue.BooleanValue())
return firstValue;
else
return Operand.Create(0);
} else if (firstValue.Type() == OperandType.BOOLEAN) {
if (firstValue.BooleanValue())
return secondValue;
else
return Operand.Create(0);
}
if (firstValue.Type() == OperandType.DATE) {
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.DateValue().MUL(secondValue.NumberValue()));
}
if (secondValue.Type() == OperandType.DATE) {
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(secondValue.DateValue().MUL(firstValue.NumberValue()));
}
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.NumberValue().multiply(secondValue.NumberValue()));
} else if (CharUtil.Equals(t, "/")) {
if (firstValue.Type() == OperandType.DATE) {
return Operand.Create(firstValue.DateValue().DIV(secondValue.NumberValue()));
}
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Div fun right value");
if (secondValue.IsError()) {
return secondValue;
}
if (secondValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return Operand.Error("Function '" + t + "' parameter 2 is error!");
}
return Operand.Create(firstValue.NumberValue().divide(secondValue.NumberValue(), MathContext.DECIMAL32));
} else if (CharUtil.Equals(t, "%")) {
firstValue = firstValue.ToNumber("% fun right value");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("% fun right value");
if (secondValue.IsError()) {
return secondValue;
}
if (secondValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return Operand.Error("Div 0 is error!");
}
return Operand.Create(
firstValue.NumberValue().divideAndRemainder(secondValue.NumberValue(), MathContext.DECIMAL32)[1]);
}
return Operand.Error("Function '" + t + "' parameter is error!");
}
public Operand visitAddSub_fun(final AddSub_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0);
Operand secondValue = args.get(1);
final String t = context.op.getText();
if (CharUtil.Equals(t, "&")) {
if (firstValue.IsNull() && secondValue.IsNull()) {
return firstValue;
} else if (firstValue.IsNull()) {
secondValue = secondValue.ToText("Function '" + t + "' parameter 2 is error!");
return secondValue;
} else if (secondValue.IsNull()) {
firstValue = firstValue.ToText("Function '" + t + "' parameter 1 is error!");
return firstValue;
}
firstValue = firstValue.ToText("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToText("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.TextValue() + secondValue.TextValue());
}
if (firstValue.Type() == OperandType.TEXT) {
if (numberRegex.matcher(firstValue.TextValue()).find()) {
final Operand a = firstValue.ToNumber(null);
if (a.IsError() == false)
firstValue = a;
} else {
final Operand a = firstValue.ToDate(null);
if (a.IsError() == false)
firstValue = a;
}
}
if (secondValue.Type() == OperandType.TEXT) {
if (numberRegex.matcher(secondValue.TextValue()).find()) {
final Operand a = secondValue.ToNumber(null);
if (a.IsError() == false)
secondValue = a;
} else {
final Operand a = secondValue.ToDate(null);
if (a.IsError() == false)
secondValue = a;
}
}
if (CharUtil.Equals(t, "+")) {
if (firstValue.Type() == OperandType.DATE && secondValue.Type() == OperandType.DATE) {
return Operand.Create(firstValue.DateValue().ADD(secondValue.DateValue()));
} else if (firstValue.Type() == OperandType.DATE) {
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.DateValue().ADD(secondValue.NumberValue()));
} else if (secondValue.Type() == OperandType.DATE) {
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(secondValue.DateValue().ADD(firstValue.NumberValue()));
}
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.NumberValue().add(secondValue.NumberValue()));
} else if (CharUtil.Equals(t, "-")) {
if (firstValue.Type() == OperandType.DATE && secondValue.Type() == OperandType.DATE) {
return Operand.Create(firstValue.DateValue().SUB(secondValue.DateValue()));
} else if (firstValue.Type() == OperandType.DATE) {
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.DateValue().SUB(secondValue.NumberValue()));
} else if (secondValue.Type() == OperandType.DATE) {
firstValue = firstValue.ToNumber("Function '" + t + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(secondValue.DateValue().SUB(firstValue.NumberValue()));
}
firstValue = firstValue.ToNumber(null);
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Function '" + t + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.NumberValue().subtract(secondValue.NumberValue()));
}
return Operand.Error("Function '" + t + "' parameter is error!");
}
public Operand visitJudge_fun(final Judge_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0);
Operand secondValue = args.get(1);
final String type = context.op.getText();
if (firstValue.IsNull()) {
if (secondValue.IsNull() && CharUtil.Equals(type, "=", "==", "===")) {
return Operand.True;
} else if (secondValue.IsNull() == false && CharUtil.Equals(type, "<>", "!=", "!==")) {
return Operand.True;
}
return Operand.False;
} else if (secondValue.IsNull()) {
if (CharUtil.Equals(type, "=", "==", "===")) {
return Operand.False;
}
return Operand.True;
}
int r;
if (firstValue.Type() == secondValue.Type()) {
if (firstValue.Type() == OperandType.TEXT || firstValue.Type() == OperandType.JSON) {
firstValue = firstValue.ToText("Function '" + type + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToText("Function '" + type + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
r = firstValue.TextValue().compareTo(secondValue.TextValue());
} else if (firstValue.Type() == OperandType.ARRARY) {
return Operand.Error("The two types cannot be compared.");
} else {
firstValue = firstValue.ToNumber("Function '" + type + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Function '" + type + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
r = firstValue.NumberValue().setScale(12, RoundingMode.HALF_UP)
.compareTo(secondValue.NumberValue().setScale(12, RoundingMode.HALF_UP));
}
} else if ((firstValue.Type() == OperandType.DATE && secondValue.Type() == OperandType.TEXT)
|| (secondValue.Type() == OperandType.DATE && firstValue.Type() == OperandType.TEXT)
|| (firstValue.Type() == OperandType.NUMBER && secondValue.Type() == OperandType.TEXT)
|| (secondValue.Type() == OperandType.NUMBER && firstValue.Type() == OperandType.TEXT)) {
firstValue = firstValue.ToText("Function '" + type + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToText("Function '" + type + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
r = firstValue.TextValue().compareTo(secondValue.TextValue());
} else if ((firstValue.Type() == OperandType.BOOLEAN && secondValue.Type() == OperandType.TEXT)
|| (secondValue.Type() == OperandType.BOOLEAN && firstValue.Type() == OperandType.TEXT)) {
firstValue = firstValue.ToText("Function '" + type + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToText("Function '" + type + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
r = firstValue.TextValue().compareToIgnoreCase(secondValue.TextValue());
// r = String.Compare(firstValue.TextValue(), secondValue.TextValue(), true);
} else if (firstValue.Type() == OperandType.TEXT || secondValue.Type() == OperandType.TEXT
|| firstValue.Type() == OperandType.JSON || secondValue.Type() == OperandType.JSON
|| firstValue.Type() == OperandType.ARRARY || secondValue.Type() == OperandType.ARRARY) {
return Operand.Error("The two types cannot be compared.");
} else {
firstValue = firstValue.ToNumber("Function '" + type + "' parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
secondValue = secondValue.ToNumber("Function '" + type + "' parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
r = firstValue.NumberValue().setScale(12, RoundingMode.HALF_UP)
.compareTo(secondValue.NumberValue().setScale(12, RoundingMode.HALF_UP));
}
if (CharUtil.Equals(type, "<")) {
return Operand.Create(r == -1);
} else if (CharUtil.Equals(type, "<=")) {
return Operand.Create(r <= 0);
} else if (CharUtil.Equals(type, ">")) {
return Operand.Create(r == 1);
} else if (CharUtil.Equals(type, ">=")) {
return Operand.Create(r >= 0);
} else if (CharUtil.Equals(type, "=", "==", "===")) {
return Operand.Create(r == 0);
}
return Operand.Create(r != 0);
}
public Operand visitAndOr_fun(final AndOr_funContext context) {
// 程序 && and || or 与 excel的 AND(x,y) OR(x,y) 有区别
// 在excel内 AND(x,y) OR(x,y) 先报错，
// 在程序中，&& and 有true 直接返回true 就不会检测下一个会不会报错
// 在程序中，|| or 有false 直接返回false 就不会检测下一个会不会报错
final String t = context.op.getText();
final Operand first = context.expr(0).accept(this).ToBoolean("Function '" + t + "' parameter 1 is error!");
if (first.IsError())
return first;
if (CharUtil.Equals(t, "&&", "and")) {
if (first.BooleanValue() == false)
return Operand.False;
} else {
if (first.BooleanValue())
return Operand.True;
}
return context.expr(1).accept(this).ToBoolean("Function '" + t + "' parameter 2 is error!");
}
public Operand visitIF_fun(final IF_funContext context) {
List exprs = context.expr();
Operand b = exprs.get(0).accept(this).ToBoolean("Function IF first parameter is error!");
if (b.IsError()) {
return b;
}
if (b.BooleanValue()) {
if (exprs.size() > 1) {
return exprs.get(1).accept(this);
}
return Operand.True;
}
if (exprs.size() == 3) {
return exprs.get(2).accept(this);
}
return Operand.False;
}
public Operand visitIFERROR_fun(final IFERROR_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this);
args.add(a);
}
if (args.get(0).IsError()) {
return args.get(1);
}
if (args.size() == 3) {
return args.get(2);
}
return Operand.False;
}
public Operand visitISNUMBER_fun(final ISNUMBER_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.IsError()) {
return firstValue;
}
if (firstValue.Type() == OperandType.NUMBER) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISTEXT_fun(final ISTEXT_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.IsError()) {
return firstValue;
}
if (firstValue.Type() == OperandType.TEXT) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISERROR_fun(final ISERROR_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
args.add(aa);
}
if (args.size() == 2) {
if (args.get(0).IsError()) {
return args.get(1);
}
return args.get(0);
}
if (args.get(0).IsError()) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISNULL_fun(final ISNULL_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
args.add(aa);
}
if (args.size() == 2) {
if (args.get(0).IsNull()) {
return args.get(1);
}
return args.get(0);
}
if (args.get(0).IsNull()) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISNULLORERROR_fun(final ISNULLORERROR_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
args.add(aa);
}
if (args.size() == 2) {
if (args.get(0).IsNull() || args.get(0).IsError()) {
return args.get(1);
}
return args.get(0);
}
if (args.get(0).IsNull() || args.get(0).IsError()) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISEVEN_fun(final ISEVEN_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.Type() == OperandType.NUMBER) {
if (firstValue.IntValue() % 2 == 0) {
return Operand.True;
}
}
return Operand.False;
}
public Operand visitISLOGICAL_fun(final ISLOGICAL_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.Type() == OperandType.BOOLEAN) {
return Operand.True;
}
return Operand.False;
}
public Operand visitISODD_fun(final ISODD_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.Type() == OperandType.NUMBER) {
if (firstValue.IntValue() % 2 == 1) {
return Operand.True;
}
}
return Operand.False;
}
public Operand visitISNONTEXT_fun(final ISNONTEXT_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.Type() != OperandType.TEXT) {
return Operand.True;
}
return Operand.False;
}
public Operand visitAND_fun(final AND_funContext context) {
int index = 1;
Boolean b = true;
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this).ToBoolean("Function AND parameter " + (index++) + " is error!");
if (a.IsError())
return a;
if (a.BooleanValue() == false)
b = false;
}
return b ? Operand.True : Operand.False;
}
public Operand visitOR_fun(final OR_funContext context) {
int index = 1;
boolean b = false;
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this).ToBoolean("Function OR parameter " + (index++) + " is error!");
if (a.IsError())
return a;
if (a.BooleanValue())
b = true;
}
return b ? Operand.True : Operand.False;
}
public Operand visitNOT_fun(final NOT_funContext context) {
final Operand firstValue = context.expr().accept(this).ToBoolean("Function NOT parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(!firstValue.BooleanValue());
}
public Operand visitTRUE_fun(final TRUE_funContext context) {
return Operand.True;
}
public Operand visitFALSE_fun(final FALSE_funContext context) {
return Operand.False;
}
public Operand visitE_fun(final E_funContext context) {
return Operand.Create(Math.E);
}
public Operand visitPI_fun(final PI_funContext context) {
return Operand.Create(Math.PI);
}
public Operand visitABS_fun(final ABS_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ABS parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.abs(firstValue.NumberValue().doubleValue()));
}
public Operand visitQUOTIENT_fun(final QUOTIENT_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function QUOTIENT parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
if (secondValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return Operand.Error("Function QUOTIENT div 0 error!");
}
return Operand.Create(
(double) (int) (firstValue.NumberValue().doubleValue() / secondValue.NumberValue().doubleValue()));
}
public Operand visitMOD_fun(final MOD_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MOD parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
if (secondValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return Operand.Error("Function MOD div 0 error!");
}
return Operand.Create((int) (firstValue.NumberValue().doubleValue() % secondValue.NumberValue().doubleValue()));
}
public Operand visitSIGN_fun(final SIGN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function SIGN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(sign(firstValue.NumberValue().doubleValue()));
}
public Operand visitSQRT_fun(final SQRT_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function SQRT parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.sqrt(firstValue.NumberValue().doubleValue()));
}
public Operand visitTRUNC_fun(final TRUNC_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function TRUNC parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create((int) (firstValue.NumberValue().doubleValue()));
}
public Operand visitINT_fun(final INT_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function INT parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create((int) (firstValue.NumberValue().doubleValue()));
}
public Operand visitGCD_fun(final GCD_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function GCD parameter is error!");
}
return Operand.Create(F_base_gcd(list));
}
public Operand visitLCM_fun(final LCM_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function GCD parameter is error!");
}
return Operand.Create(F_base_lgm(list));
}
public Operand visitCOMBIN_fun(final COMBIN_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function COMBIN parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
final int total = firstValue.IntValue();
final int count = secondValue.IntValue();
double sum = 1;
double sum2 = 1;
for (int i = 0; i < count; i++) {
sum *= (total - i);
sum2 *= (i + 1);
}
return Operand.Create(sum / sum2);
}
public Operand visitPERMUT_fun(final PERMUT_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function PERMUT parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
final int total = firstValue.IntValue();
final int count = secondValue.IntValue();
double sum = 1;
for (int i = 0; i < count; i++) {
sum *= (total - i);
}
return Operand.Create(sum);
}
public Operand visitPercentage_fun(Percentage_funContext context) {
Operand firstValue = context.expr().accept(this).ToNumber("Function Percentage parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.NumberValue().divide(new BigDecimal(100), MathContext.DECIMAL32));
}
private int F_base_gcd(List list) {
list = ShellSort(list);
// list = list.OrderBy(q => q).ToList();
int g = F_base_gcd(list.get(1).intValue(), list.get(0).intValue());
for (int i = 2; i < list.size(); i++) {
g = F_base_gcd(list.get(i).intValue(), g);
}
return g;
}
private int F_base_gcd(final int a, final int b) {
if (b == 1) {
return 1;
}
if (b == 0) {
return a;
}
return F_base_gcd(b, a % b);
}
private int F_base_lgm(List list) {
for (int i = list.size() - 1; i >= 0; i--) {
final int item = list.get(i).intValue();// [i];
if (item <= 1) {
list.remove(i);
}
}
list = ShellSort(list);
int a = list.get(0).intValue();// [0];
for (int i = 1; i < list.size(); i++) {
final int b = list.get(i).intValue();
final int g = b > a ? F_base_gcd(b, a) : F_base_gcd(a, b);
a = a / g * b;
}
return a;
}
private List ShellSort(final List array) {
final int len = array.size();
BigDecimal temp;
int gap = len / 2;
while (gap > 0) {
for (int i = gap; i < len; i++) {
temp = array.get(i);
int preIndex = i - gap;
while (preIndex >= 0 && array.get(preIndex).compareTo(temp) > 0) {
array.set(preIndex + gap, array.get(preIndex));
// array[preIndex + gap] = array[preIndex];
preIndex -= gap;
}
array.set(preIndex + gap, temp);
// array[preIndex + gap] = temp;
}
gap /= 2;
}
return array;
}
public Operand visitDEGREES_fun(final DEGREES_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function DEGREES parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double z = firstValue.NumberValue().doubleValue();
final double r = (z / Math.PI * 180);
return Operand.Create(r);
}
public Operand visitRADIANS_fun(final RADIANS_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function RADIANS parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double r = firstValue.NumberValue().doubleValue() / 180 * Math.PI;
return Operand.Create(r);
}
public Operand visitCOS_fun(final COS_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function COS parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.cos(firstValue.NumberValue().doubleValue()));
}
public Operand visitCOSH_fun(final COSH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function COSH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.cosh(firstValue.NumberValue().doubleValue()));
}
public Operand visitSIN_fun(final SIN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function SIN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.sin(firstValue.NumberValue().doubleValue()));
}
public Operand visitSINH_fun(final SINH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function SINH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.sinh(firstValue.NumberValue().doubleValue()));
}
public Operand visitTAN_fun(final TAN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function TAN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.tan(firstValue.NumberValue().doubleValue()));
}
public Operand visitTANH_fun(final TANH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function TANH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.tanh(firstValue.NumberValue().doubleValue()));
}
public Operand visitACOS_fun(final ACOS_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ACOS parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double x = firstValue.NumberValue().doubleValue();
if (x < -1 || x > 1) {
return Operand.Error("Function ACOS parameter is error!");
}
return Operand.Create(Math.acos(x));
}
public Operand visitACOSH_fun(final ACOSH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ACOSH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double z = firstValue.NumberValue().doubleValue();
if (z < 1) {
return Operand.Error("Function ACOSH parameter is error!");
}
final double r = Math.log(z + Math.pow(z * z - 1, 0.5));
return Operand.Create(r);
}
public Operand visitASIN_fun(final ASIN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ASIN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double x = firstValue.NumberValue().doubleValue();
if (x < -1 || x > 1) {
return Operand.Error("Function ASIN parameter is error!");
}
return Operand.Create(Math.asin(x));
}
public Operand visitASINH_fun(final ASINH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ASINH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double x = firstValue.NumberValue().doubleValue();
final double d = Math.log(x + Math.sqrt(x * x + 1));
return Operand.Create(d);
}
public Operand visitATAN_fun(final ATAN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ATAN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.atan(firstValue.NumberValue().doubleValue()));
}
public Operand visitATANH_fun(final ATANH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ATANH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double x = firstValue.NumberValue().doubleValue();
if (x >= 1 || x <= -1) {
return Operand.Error("Function ATANH parameter is error!");
}
final double d = Math.log((1 + x) / (1 - x)) / 2;
return Operand.Create(d);
}
public Operand visitATAN2_fun(final ATAN2_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function ATAN2 parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
return Operand
.Create(Math.atan2(secondValue.NumberValue().doubleValue(), firstValue.NumberValue().doubleValue()));
}
public Operand visitFIXED_fun(final FIXED_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
int num = 2;
if (args.size() > 1) {
final Operand secondValue = args.get(1).ToNumber("Function FIXED parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
num = secondValue.IntValue();
}
final Operand firstValue = args.get(0).ToNumber("Function FIXED parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final double s = round(firstValue.NumberValue().doubleValue(), num);
boolean no = false;
if (args.size() == 3) {
final Operand thirdValue = args.get(2).ToBoolean("Function FIXED parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
no = thirdValue.BooleanValue();
}
if (num <= 0) {
String f = no ? "#" : "#,###";
final DecimalFormat myFormatter = new DecimalFormat(f);
return Operand.Create(myFormatter.format(s));
} else {
String f = no ? "#." : "#,###.";
for (int i = 0; i < num; i++) {
f += "#";
}
final DecimalFormat myFormatter = new DecimalFormat(f);
return Operand.Create(myFormatter.format(s));
}
// return Operand.Create(((Double)s).toString());
}
public Operand visitBIN2OCT_fun(final BIN2OCT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function BIN2OCT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_2.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function BIN2OCT parameter 1 is error!");
}
final String num = Integer.toOctalString(Integer.parseUnsignedInt(firstValue.TextValue(), 2));
// String num = Convert.toString(Convert.ToInt32(firstValue.TextValue(), 2), 8);
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function BIN2OCT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function BIN2OCT parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitBIN2DEC_fun(final BIN2DEC_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function BIN2DEC parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_2.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function BIN2DEC parameter is error!");
}
final int num = Integer.parseUnsignedInt(firstValue.TextValue(), 2);
// String num = Convert.ToInt32(firstValue.TextValue(), 2);
return Operand.Create(num);
}
public Operand visitBIN2HEX_fun(final BIN2HEX_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function BIN2HEX parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_2.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function BIN2HEX parameter 1 is error!");
}
final String num = Integer.toHexString(Integer.parseUnsignedInt(firstValue.TextValue(), 2)).toUpperCase();
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function BIN2HEX parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function BIN2HEX parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitOCT2BIN_fun(final OCT2BIN_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function OCT2BIN parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_8.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function OCT2BIN parameter 1 is error!");
}
final String num = Integer.toBinaryString(Integer.parseUnsignedInt(firstValue.TextValue(), 8));
// String num = Convert.toString(Convert.ToInt32(firstValue.TextValue(), 8), 2);
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function OCT2BIN parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function OCT2BIN parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitOCT2DEC_fun(final OCT2DEC_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function OCT2DEC parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_8.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function OCT2DEC parameter is error!");
}
final int num = Integer.parseUnsignedInt(firstValue.TextValue(), 8);
// String num = Convert.ToInt32(firstValue.TextValue(), 8);
return Operand.Create(num);
}
public Operand visitOCT2HEX_fun(final OCT2HEX_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function OCT2HEX parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_8.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function OCT2HEX parameter 1 is error!");
}
final String num = Integer.toHexString(Integer.parseUnsignedInt(firstValue.TextValue(), 8)).toUpperCase();
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function OCT2HEX parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function OCT2HEX parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitDEC2BIN_fun(final DEC2BIN_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToNumber("Function DEC2BIN parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String num = Integer.toBinaryString(firstValue.IntValue());
// String num = System.Convert.toString(firstValue.IntValue(), 2);
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function DEC2BIN parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function DEC2BIN parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitDEC2OCT_fun(final DEC2OCT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToNumber("Function DEC2OCT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String num = Integer.toOctalString(firstValue.IntValue());
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function DEC2OCT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function DEC2OCT parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitDEC2HEX_fun(final DEC2HEX_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToNumber("Function DEC2HEX parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String num = Integer.toHexString(firstValue.IntValue()).toUpperCase();
// String num = System.Convert.toString(firstValue.IntValue(), 16).ToUpper();
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function DEC2HEX parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function DEC2HEX parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitHEX2BIN_fun(final HEX2BIN_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function HEX2BIN parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_16.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function HEX2BIN parameter 1 is error!");
}
final String num = Integer.toBinaryString(Integer.parseUnsignedInt(firstValue.TextValue(), 16));
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function HEX2BIN parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function HEX2BIN parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitHEX2OCT_fun(final HEX2OCT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function HEX2OCT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_16.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function HEX2OCT parameter 1 is error!");
}
final String num = Integer.toOctalString(Integer.parseUnsignedInt(firstValue.TextValue(), 16));
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function HEX2OCT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (num.length() > secondValue.IntValue()) {
return Operand.Create(padLeft(num, secondValue.IntValue(), '0'));
}
return Operand.Error("Function HEX2OCT parameter 2 is error!");
}
return Operand.Create(num);
}
public Operand visitHEX2DEC_fun(final HEX2DEC_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function HEX2DEC parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (bit_16.matcher(firstValue.TextValue()).find() == false) {
return Operand.Error("Function HEX2DEC parameter is error!");
}
final int num = Integer.parseUnsignedInt(firstValue.TextValue(), 16);
// String num = Convert.ToInt32(firstValue.TextValue(), 16);
return Operand.Create(num);
}
public Operand visitROUND_fun(final ROUND_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function ROUND parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
if (args.size() == 1) {
return Operand.Create(Math.round(firstValue.NumberValue().doubleValue()));
}
final Operand secondValue = args.get(1);
return Operand.Create(round(firstValue.NumberValue().doubleValue(), secondValue.IntValue()));
}
public Operand visitROUNDDOWN_fun(final ROUNDDOWN_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function ROUNDDOWN parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
if (firstValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return firstValue;
}
final double a = Math.pow(10, secondValue.IntValue());
double b = firstValue.NumberValue().doubleValue();
b = ((double) (int) (b * a)) / a;
return Operand.Create(b);
}
public Operand visitROUNDUP_fun(final ROUNDUP_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function ROUNDUP parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
if (firstValue.NumberValue().compareTo(new BigDecimal(0)) == 0) {
return firstValue;
}
final double a = Math.pow(10, secondValue.IntValue());
final double b = firstValue.NumberValue().doubleValue();
final double t = (Math.ceil(Math.abs(b) * a)) / a;
if (b > 0)
return Operand.Create(t);
return Operand.Create(-t);
}
public Operand visitCEILING_fun(final CEILING_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function CEILING parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
if (args.size() == 1)
return Operand.Create(Math.ceil(firstValue.NumberValue().doubleValue()));
final Operand secondValue = args.get(1);
final double b = secondValue.NumberValue().doubleValue();
if (b == 0) {
return Operand.Create(0);
}
if (b < 0) {
return Operand.Error("Function CEILING parameter 2 is error!");
}
final double a = firstValue.NumberValue().doubleValue();
final double d = Math.ceil(a / b) * b;
return Operand.Create(d);
}
public Operand visitFLOOR_fun(final FLOOR_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function FLOOR parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
if (args.size() == 1)
return Operand.Create(Math.floor(firstValue.NumberValue().doubleValue()));
final Operand secondValue = args.get(1);
final double b = secondValue.NumberValue().doubleValue();
if (b >= 1) {
return Operand.Create(firstValue.IntValue());
}
if (b <= 0) {
return Operand.Error("Function FLOOR parameter 2 is error!");
}
final double a = firstValue.NumberValue().doubleValue();
final double d = Math.floor(a / b) * b;
return Operand.Create(d);
}
public Operand visitEVEN_fun(final EVEN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function EVEN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
double z = firstValue.NumberValue().doubleValue();
if (z % 2 == 0) {
return firstValue;
}
z = Math.ceil(z);
if (z % 2 == 0) {
return Operand.Create(z);
}
z = z + 1;
return Operand.Create(z);
}
public Operand visitODD_fun(final ODD_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function ODD parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
double z = firstValue.NumberValue().doubleValue();
if (z % 2 == 1) {
return firstValue;
}
z = Math.ceil(z);
if (z % 2 == 1) {
return Operand.Create(z);
}
z = z + 1;
return Operand.Create(z);
}
public Operand visitMROUND_fun(final MROUND_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MROUND parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
final double a = secondValue.NumberValue().doubleValue();
if (a <= 0) {
return Operand.Error("Function MROUND parameter 2 is error!");
}
final double b = firstValue.NumberValue().doubleValue();
final double r = round(b / a, 0) * a;
return Operand.Create(r);
}
public Operand visitRAND_fun(final RAND_funContext context) {
final long tick = DateTime.now().getMillis();
final Random rand = new Random((int) (tick & 0xffffffffL) | (int) (tick >> 32));
return Operand.Create(rand.nextDouble());
}
public Operand visitRANDBETWEEN_fun(final RANDBETWEEN_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function RANDBETWEEN parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
final long tick = DateTime.now().getMillis();
final Random rand = new Random((int) (tick & 0xffffffffL) | (int) (tick >> 32));
return Operand.Create(
rand.nextDouble() * (secondValue.NumberValue().doubleValue() - firstValue.NumberValue().doubleValue())
+ firstValue.NumberValue().doubleValue());
}
public Operand visitFACT_fun(final FACT_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function FACT parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final int z = firstValue.IntValue();
if (z < 0) {
return Operand.Error("Function FACT parameter is error!");
}
double d = 1;
for (int i = 1; i <= z; i++) {
d *= i;
}
return Operand.Create(d);
}
public Operand visitFACTDOUBLE_fun(final FACTDOUBLE_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function FACTDOUBLE parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final int z = firstValue.IntValue();
if (z < 0) {
return Operand.Error("Function FACTDOUBLE parameter is error!");
}
double d = 1;
for (int i = z; i > 0; i -= 2) {
d *= i;
}
return Operand.Create(d);
}
public Operand visitPOWER_fun(final POWER_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function POWER parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
return Operand
.Create(Math.pow(firstValue.NumberValue().doubleValue(), secondValue.NumberValue().doubleValue()));
}
public Operand visitEXP_fun(final EXP_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function EXP parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.exp(firstValue.NumberValue().doubleValue()));
}
public Operand visitLN_fun(final LN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function LN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.log(firstValue.NumberValue().doubleValue()));
}
public Operand visitLOG_fun(final LOG_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this).ToNumber("Function LOG parameter " + (index++) + " is error!");
if (a.IsError()) {
return a;
}
args.add(a);
}
if (args.size() > 1) {
return Operand
.Create(log(args.get(0).NumberValue().doubleValue(), args.get(1).NumberValue().doubleValue()));
}
return Operand.Create(Math.log10(args.get(0).NumberValue().doubleValue()));
}
public Operand visitLOG10_fun(final LOG10_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function LOG10 parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.log10(firstValue.NumberValue().doubleValue()));
}
public Operand visitMULTINOMIAL_fun(final MULTINOMIAL_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function MULTINOMIAL parameter is error!");
}
int sum = 0;
int n = 1;
for (final BigDecimal a : list) {
n *= F_base_Factorial(a.intValue());
sum += a.intValue();
}
final int r = F_base_Factorial(sum) / n;
return Operand.Create(r);
}
public Operand visitPRODUCT_fun(final PRODUCT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function PRODUCT parameter is error!");
}
BigDecimal d = new BigDecimal(1);
for (final BigDecimal a : list) {
d = d.multiply(a);
}
return Operand.Create(d);
}
public Operand visitSQRTPI_fun(final SQRTPI_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function SQRTPI parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(Math.sqrt(firstValue.NumberValue().doubleValue() * Math.PI));
}
public Operand visitSUMSQ_fun(final SUMSQ_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function SUMSQ parameter is error!");
}
BigDecimal d = new BigDecimal(0);
for (final BigDecimal a : list) {
d = d.add(a.multiply(a));
}
return Operand.Create(d);
}
private int F_base_Factorial(final int a) {
if (a == 0) {
return 1;
}
int r = 1;
for (int i = a; i > 0; i--) {
r *= i;
}
return r;
}
public Operand visitASC_fun(final ASC_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function ASC parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(F_base_ToDBC(firstValue.TextValue()));
}
public Operand visitJIS_fun(final JIS_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function JIS parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(F_base_ToSBC(firstValue.TextValue()));
}
public Operand visitCHAR_fun(final CHAR_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function CHAR parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final char c = (char) firstValue.NumberValue().intValue();
return Operand.Create(((Character) c).toString());
}
public Operand visitCLEAN_fun(final CLEAN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function CLEAN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
String t = firstValue.TextValue();
t = clearRegex.matcher(t).replaceAll("");
return Operand.Create(t);
}
public Operand visitCODE_fun(final CODE_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function CODE parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String t = firstValue.TextValue();
if (t.length() == 0) {
return Operand.Error("Function CODE parameter is error!");
}
return Operand.Create((double) (int) t.charAt(0));
}
public Operand visitCONCATENATE_fun(final CONCATENATE_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this).ToText("Function CONCATENATE parameter " + (index++) + " is error!");
if (a.IsError()) {
return a;
}
args.add(a);
}
final StringBuilder sb = new StringBuilder();
for (final Operand item : args) {
sb.append(item.TextValue());
}
return Operand.Create(sb.toString());
}
public Operand visitEXACT_fun(final EXACT_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToText("Function EXACT parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0);
final Operand secondValue = args.get(1);
return Operand.Create(firstValue.TextValue().equals(secondValue.TextValue()));
}
public Operand visitFIND_fun(final FIND_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function FIND parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToText("Function FIND parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (args.size() == 2) {
final int p = secondValue.TextValue().indexOf(firstValue.TextValue()) + excelIndex;
return Operand.Create(p);
}
final Operand count = args.get(2).ToNumber("Function FIND parameter 3 is error!");
if (count.IsError()) {
return count;
}
final int p2 = secondValue.TextValue().indexOf(firstValue.TextValue(), count.IntValue()) + excelIndex;
return Operand.Create(p2);
}
public Operand visitLEFT_fun(final LEFT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function LEFT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (args.size() == 1) {
return Operand.Create(((Character) firstValue.TextValue().charAt(0)).toString());
}
final Operand secondValue = args.get(1).ToNumber("Function LEFT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.TextValue().substring(0, secondValue.IntValue()));
}
public Operand visitLEN_fun(final LEN_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function LEN parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.TextValue().length());
}
public Operand visitLOWER_fun(final LOWER_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function LOWER/TOLOWER parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.TextValue().toLowerCase());
}
public Operand visitMID_fun(final MID_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function MID parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function MID parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final Operand thirdValue = args.get(2).ToNumber("Function MID parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
return Operand.Create(firstValue.TextValue().substring(secondValue.IntValue() - excelIndex,
secondValue.IntValue() - excelIndex + thirdValue.IntValue()));
}
public Operand visitPROPER_fun(final PROPER_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function PROPER parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String text = firstValue.TextValue();
final StringBuilder sb = new StringBuilder(text);
boolean isFirst = true;
for (int i = 0; i < text.length(); i++) {
final char t = text.charAt(i);
if (t == ' ' || t == '\r' || t == '\n' || t == '\t' || t == '.') {
isFirst = true;
} else if (isFirst) {
sb.setCharAt(i, Character.toUpperCase(t));
isFirst = false;
}
}
return Operand.Create(sb.toString());
}
public Operand visitREPLACE_fun(final REPLACE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function REPLACE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final String oldtext = firstValue.TextValue();
if (args.size() == 3) {
final Operand secondValue2 = args.get(1).ToText("Function REPLACE parameter 2 is error!");
final Operand thirdValue2 = args.get(2).ToText("Function REPLACE parameter 3 is error!");
final String old = secondValue2.TextValue();
final String newstr = thirdValue2.TextValue();
return Operand.Create(oldtext.replace(old, newstr));
}
final Operand secondValue = args.get(1).ToNumber("Function REPLACE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final Operand thirdValue = args.get(2).ToNumber("Function REPLACE parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
final Operand fourthValue = args.get(3).ToText("Function REPLACE parameter 3 is error!");
if (fourthValue.IsError()) {
return fourthValue;
}
final int start = secondValue.IntValue() - excelIndex;
final int length = thirdValue.IntValue();
final String newtext = fourthValue.TextValue();
final StringBuilder sb = new StringBuilder();
for (int i = 0; i < oldtext.length(); i++) {
if (i < start) {
sb.append(oldtext.charAt(i));
} else if (i == start) {
sb.append(newtext);
} else if (i >= start + length) {
sb.append(oldtext.charAt(i));
}
}
return Operand.Create(sb.toString());
}
public Operand visitREPT_fun(final REPT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function REPT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function REPT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final String newtext = firstValue.TextValue();
final int length = secondValue.IntValue();
final StringBuilder sb = new StringBuilder();
for (int i = 0; i < length; i++) {
sb.append(newtext);
}
return Operand.Create(sb.toString());
}
public Operand visitRIGHT_fun(final RIGHT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function RIGHT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (args.size() == 1) {
return Operand.Create(
((Character) firstValue.TextValue().charAt(firstValue.TextValue().length() - 1)).toString());
}
final Operand secondValue = args.get(1).ToNumber("Function RIGHT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand
.Create(firstValue.TextValue().substring(firstValue.TextValue().length() - secondValue.IntValue()));
}
public Operand visitRMB_fun(final RMB_funContext context) {
final Operand firstValue = context.expr().accept(this).ToNumber("Function RMB parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(F_base_ToChineseRMB(firstValue.NumberValue()));
}
public Operand visitSEARCH_fun(final SEARCH_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function SEARCH parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToText("Function SEARCH parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (args.size() == 2) {
final int p = secondValue.TextValue().toLowerCase().indexOf(firstValue.TextValue().toLowerCase())
+ excelIndex;
return Operand.Create(p);
}
final Operand thirdValue = args.get(2).ToNumber("Function SEARCH parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
final int p2 = secondValue.TextValue().toLowerCase().indexOf(firstValue.TextValue().toLowerCase(),
thirdValue.IntValue()) + excelIndex;
return Operand.Create(p2);
}
public Operand visitSUBSTITUTE_fun(final SUBSTITUTE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToText("Function SUBSTITUTE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToText("Function SUBSTITUTE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final Operand thirdValue = args.get(2).ToText("Function SUBSTITUTE parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
if (args.size() == 3) {
return Operand.Create(firstValue.TextValue().replace(secondValue.TextValue(), thirdValue.TextValue()));
}
final Operand fourthValue = args.get(3).ToNumber("Function SUBSTITUTE parameter 4 is error!");
if (fourthValue.IsError()) {
return fourthValue;
}
final String text = firstValue.TextValue();
final String oldtext = secondValue.TextValue();
final String newtext = thirdValue.TextValue();
final int index = fourthValue.IntValue();
int index2 = 0;
final StringBuilder sb = new StringBuilder();
for (int i = 0; i < text.length(); i++) {
boolean b = true;
for (int j = 0; j < oldtext.length(); j++) {
final char t = text.charAt(i + j);
final char t2 = oldtext.charAt(j);
if (t != t2) {
b = false;
break;
}
}
if (b) {
index2++;
}
if (b && index2 == index) {
sb.append(newtext);
i += oldtext.length() - 1;
} else {
sb.append(text.charAt(i));
}
}
return Operand.Create(sb.toString());
}
public Operand visitT_fun(final T_funContext context) {
final Operand firstValue = context.expr().accept(this);
if (firstValue.Type() == OperandType.TEXT) {
return firstValue;
}
return Operand.Create("");
}
public Operand visitTEXT_fun(final TEXT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0);
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToText("Function TEXT parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (firstValue.Type() == OperandType.TEXT) {
return firstValue;
} else if (firstValue.Type() == OperandType.BOOLEAN) {
return Operand.Create(firstValue.BooleanValue() ? "TRUE" : "FALSE");
} else if (firstValue.Type() == OperandType.NUMBER) {
final DecimalFormat myFormatter = new DecimalFormat(secondValue.TextValue());
return Operand.Create(myFormatter.format(firstValue.NumberValue()));
} else if (firstValue.Type() == OperandType.DATE) {
return Operand.Create(firstValue.DateValue().toString(secondValue.TextValue()));
}
firstValue = firstValue.ToText("Function TEXT parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.TextValue());
}
public Operand visitTRIM_fun(final TRIM_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function TRIM parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.TextValue().trim());
}
public Operand visitUPPER_fun(final UPPER_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function UPPER/TOUPPER parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.TextValue().toUpperCase());
}
public Operand visitVALUE_fun(final VALUE_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function VALUE parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
try {
final BigDecimal d = new BigDecimal(firstValue.TextValue());
return Operand.Create(d);
} catch (final Exception e) {
}
// if (double.TryParse(firstValue.TextValue(), NumberStyles.Any, cultureInfo,
// out double d)) {
// return Operand.Create(d);
// }
return Operand.Error("Function VALUE parameter is error!");
}
private String F_base_ToSBC(final String input) {
final StringBuilder sb = new StringBuilder(input);
for (int i = 0; i < input.length(); i++) {
final char c = input.charAt(i);// [i];
if (c == ' ') {
sb.setCharAt(i, (char) 12288);
// sb[i] = (char) 12288;
} else if (c < 127) {
sb.setCharAt(i, (char) (c + 65248));
// sb[i] = (char) (c + 65248);
}
}
return sb.toString();
}
private String F_base_ToDBC(final String input) {
final StringBuilder sb = new StringBuilder(input);
for (int i = 0; i < input.length(); i++) {
final char c = input.charAt(i);// [i];
if (c == 12288) {
sb.setCharAt(i, (char) 32);
} else if (c > 65280 && c < 65375) {
sb.setCharAt(i, (char) (c - 65248));
}
}
return sb.toString();
}
static final String[] CN_UPPER_NUMBER = {"零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖"};
static final String[] CN_UPPER_MONETRAY_UNIT = {"分", "角", "元", "拾", "佰", "仟", "万", "拾", "佰", "仟", "亿", "拾", "佰",
"仟", "兆", "拾", "佰", "仟"};
static final String CN_FULL = "整";
static final String CN_NEGATIVE = "负";
static final int MONEY_PRECISION = 2;
static final String CN_ZEOR_FULL = "零元" + CN_FULL;
//@SuppressWarnings("deprecation")
private String F_base_ToChineseRMB(final BigDecimal numberOfMoney) {
StringBuffer sb = new StringBuffer();
int signum = numberOfMoney.signum();
if (signum == 0) {
return CN_ZEOR_FULL;
}
long number = numberOfMoney.movePointRight(MONEY_PRECISION).setScale(0, RoundingMode.HALF_UP).abs().longValue();
long scale = number % 100;
int numUnit;
int numIndex = 0;
boolean getZero = false;
if (!(scale > 0)) {
numIndex = 2;
number = number / 100;
getZero = true;
}
if ((scale > 0) && (!(scale % 10 > 0))) {
numIndex = 1;
number = number / 10;
getZero = true;
}
int zeroSize = 0;
while (true) {
if (number <= 0) {
break;
}
// 每次获取到最后一个数
numUnit = (int) (number % 10);
if (numUnit > 0) {
if ((numIndex == 9) && (zeroSize >= 3)) {
sb.insert(0, CN_UPPER_MONETRAY_UNIT[6]);
}
if ((numIndex == 13) && (zeroSize >= 3)) {
sb.insert(0, CN_UPPER_MONETRAY_UNIT[10]);
}
sb.insert(0, CN_UPPER_MONETRAY_UNIT[numIndex]);
sb.insert(0, CN_UPPER_NUMBER[numUnit]);
getZero = false;
zeroSize = 0;
} else {
++zeroSize;
if (!(getZero)) {
sb.insert(0, CN_UPPER_NUMBER[numUnit]);
}
if (numIndex == 2) {
if (number > 0) {
sb.insert(0, CN_UPPER_MONETRAY_UNIT[numIndex]);
}
} else if (((numIndex - 2) % 4 == 0) && (number % 1000 > 0)) {
sb.insert(0, CN_UPPER_MONETRAY_UNIT[numIndex]);
}
getZero = true;
}
// 让number每次都去掉最后一个数
number = number / 10;
++numIndex;
}
// 如果signum == -1，则说明输入的数字为负数，就在最前面追加特殊字符：负
if (signum == -1) {
sb.insert(0, CN_NEGATIVE);
}
// 输入的数字小数点后两位为"00"的情况，则要在最后追加特殊字符：整
if (!(scale > 0)) {
sb.append(CN_FULL);
}
return sb.toString();
}
public Operand visitDATEVALUE_fun(final DATEVALUE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
if (args.get(0).Type() == OperandType.DATE) {
return args.get(0);
}
int type = 0;
if (args.size() == 2) {
Operand secondValue = args.get(1).ToNumber("Function DATEVALUE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
type = secondValue.IntValue();
}
if (type == 0) {
if (args.get(0).Type() == OperandType.TEXT) {
MyDate date = MyDate.parse(args.get(0).TextValue());
if (date != null) {
return Operand.Create(date);
}
}
Operand firstValue = args.get(0).ToNumber("Function DATEVALUE parameter 1 is error!");
if (firstValue.LongValue() <= 2958465L) { // 9999-12-31 日时间在excel的数字为 2958465
return firstValue.ToDate("Function DATEVALUE parameter 1 is error!");
}
if (firstValue.LongValue() <= 253402232399L) { // 9999-12-31 12:59:59 日时间 转 时间截 为 253402232399L，
DateTime time = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeZone.UTC).plus(firstValue.LongValue() * 1000);
if (useLocalTime) {
return Operand.Create(time.toDateTime(DateTimeZone.getDefault()));
}
return Operand.Create(time);
}
// 注：时间截 253402232399 ms 转时间 为 1978-01-12 05:30:32
DateTime time2 = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeZone.UTC).plus(firstValue.LongValue());
if (useLocalTime) {
return Operand.Create(time2.toDateTime(DateTimeZone.getDefault()));
}
return Operand.Create(time2);
} else if (type == 1) {
Operand firstValue = args.get(0).ToText("Function DATEVALUE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
MyDate date = MyDate.parse(firstValue.TextValue());
if (date != null) {
return Operand.Create(date);
}
} else if (type == 2) {
return args.get(0).ToNumber("Function DATEVALUE parameter is error!").ToDate("");
} else if (type == 3) {
Operand firstValue = args.get(0).ToNumber("Function DATEVALUE parameter 1 is error!");
DateTime time = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeZone.UTC).plus(firstValue.LongValue());
if (useLocalTime) {
return Operand.Create(time.toDateTime(DateTimeZone.getDefault()));
}
return Operand.Create(time);
} else if (type == 4) {
Operand firstValue = args.get(0).ToNumber("Function DATEVALUE parameter 1 is error!");
DateTime time = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeZone.UTC).plus(firstValue.LongValue() * 1000);
if (useLocalTime) {
return Operand.Create(time.toDateTime(DateTimeZone.getDefault()));
}
return Operand.Create(time);
}
return Operand.Error("Function DATEVALUE parameter is error!");
}
@Override
public Operand visitTIMESTAMP_fun(TIMESTAMP_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
int type = 0; // 毫秒
if (args.size() == 2) {
Operand secondValue = args.get(1).ToNumber("Function TIMESTAMP parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
type = secondValue.IntValue();
}
DateTime firstValue;
if (useLocalTime) {
firstValue = args.get(0).ToDate("Function TIMESTAMP parameter 1 is error!").DateValue()
.ToDateTime(DateTimeZone.getDefault());
} else {
firstValue = args.get(0).ToDate("Function TIMESTAMP parameter 1 is error!").DateValue()
.ToDateTime(DateTimeZone.UTC);
}
if (type == 0) {
firstValue.getMillis();
return Operand.Create(firstValue.getMillis());
} else if (type == 1) {
return Operand.Create(firstValue.getMillis() / 1000);
}
return Operand.Error("Function TIMESTAMP parameter is error!");
}
public Operand visitTIMEVALUE_fun(final TIMEVALUE_funContext context) {
final Operand firstValue = context.expr().accept(this).ToText("Function TIMEVALUE parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
MyDate date = MyDate.parse(firstValue.TextValue());
if (date != null) {
return Operand.Create(date);
}
return Operand.Error("Function TIMEVALUE parameter is error!");
}
public Operand visitDATE_fun(final DATE_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function DATE parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
MyDate d;
if (args.size() == 3) {
d = new MyDate(args.get(0).IntValue(), args.get(1).IntValue(), args.get(2).IntValue(), 0, 0, 0);
} else if (args.size() == 4) {
d = new MyDate(args.get(0).IntValue(), args.get(1).IntValue(), args.get(2).IntValue(),
args.get(3).IntValue(), 0, 0);
} else if (args.size() == 5) {
d = new MyDate(args.get(0).IntValue(), args.get(1).IntValue(), args.get(2).IntValue(),
args.get(3).IntValue(), args.get(4).IntValue(), 0);
} else {
d = new MyDate(args.get(0).IntValue(), args.get(1).IntValue(), args.get(2).IntValue(),
args.get(3).IntValue(), args.get(4).IntValue(), args.get(5).IntValue());
}
return Operand.Create(d);
}
public Operand visitTIME_fun(final TIME_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function TIME parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
MyDate d;
if (args.size() == 3) {
d = new MyDate(0, 0, 0, args.get(0).IntValue(), args.get(1).IntValue(), args.get(2).IntValue());
} else {
d = new MyDate(0, 0, 0, args.get(0).IntValue(), args.get(1).IntValue(), 0);
}
return Operand.Create(d);
}
public Operand visitNOW_fun(final NOW_funContext context) {
return Operand.Create(new MyDate(DateTime.now()));
}
public Operand visitTODAY_fun(final TODAY_funContext context) {
final DateTime dt = DateTime.now();
return Operand.Create(new MyDate(dt.getYear(), dt.getMonthOfYear(), dt.getDayOfMonth(), 0, 0, 0));
}
@Override
public Operand visitERROR_fun(ERROR_funContext context) {
if (context.expr() == null) {
return Operand.Error("");
}
Operand args1 = this.visit(context.expr());
if (args1.Type() != OperandType.TEXT) {
args1 = args1.ToText("");
if (args1.IsError())
return args1;
}
return Operand.Error(args1.TextValue());
}
public Operand visitYEAR_fun(final YEAR_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function YEAR parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (firstValue.DateValue().Year == null) {
return Operand.Error("Function YEAR is error!");
}
return Operand.Create(firstValue.DateValue().Year);
}
public Operand visitMONTH_fun(final MONTH_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function MONTH parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (firstValue.DateValue().Month == null) {
return Operand.Error("Function MONTH is error!");
}
return Operand.Create(firstValue.DateValue().Month);
}
public Operand visitDAY_fun(final DAY_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function DAY parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
if (firstValue.DateValue().Day == null) {
return Operand.Error("Function DAY is error!");
}
return Operand.Create(firstValue.DateValue().Day);
}
public Operand visitHOUR_fun(final HOUR_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function HOUR parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.DateValue().Hour);
}
public Operand visitMINUTE_fun(final MINUTE_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function MINUTE parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.DateValue().Minute);
}
public Operand visitSECOND_fun(final SECOND_funContext context) {
final Operand firstValue = context.expr().accept(this).ToDate("Function SECOND parameter is error!");
if (firstValue.IsError()) {
return firstValue;
}
return Operand.Create(firstValue.DateValue().Second);
}
public Operand visitWEEKDAY_fun(final WEEKDAY_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function WEEKDAY parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
int type = 1;
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function WEEKDAY parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
type = secondValue.IntValue();
}
final int t = firstValue.DateValue().DayOfWeek();
if (type == 1) {
if (t == 7) {
return Operand.Create(1);
}
return Operand.Create((double) (t + 1));
} else if (type == 2) {
if (t == 0)
return Operand.Create(7d);
return Operand.Create((double) t);
}
if (t == 0) {
return Operand.Create(6d);
}
return Operand.Create((double) (t - 1));
}
public Operand visitDATEDIF_fun(final DATEDIF_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function DATEDIF parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToDate("Function DATEDIF parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final Operand thirdValue = args.get(2).ToText("Function DATEDIF parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
final MyDate startDate = firstValue.DateValue();
final MyDate endDate = secondValue.DateValue();
final String t = thirdValue.TextValue().toLowerCase();
if (CharUtil.Equals(t, "y")) {
boolean b = false;
if (startDate.Month < endDate.Month) {
b = true;
} else if (startDate.Month.equals(endDate.Month)) {
if (startDate.Day <= endDate.Day)
b = true;
}
if (b) {
return Operand.Create((endDate.Year - startDate.Year));
} else {
return Operand.Create((endDate.Year - startDate.Year - 1));
}
} else if (CharUtil.Equals(t, "m")) {
boolean b = startDate.Day <= endDate.Day;
if (b) {
return Operand.Create((endDate.Year * 12 + endDate.Month - startDate.Year * 12 - startDate.Month));
} else {
return Operand.Create((endDate.Year * 12 + endDate.Month - startDate.Year * 12 - startDate.Month - 1));
}
} else if (CharUtil.Equals(t, "d")) {
return Operand.Create((endDate.ToNumber().subtract(startDate.ToNumber())).intValue());
} else if (CharUtil.Equals(t, "yd")) {
int day = endDate.DayOfYear() - startDate.DayOfYear();
if (endDate.Year > startDate.Year && day < 0) {
final int days = new DateTime(startDate.Year, 12, 31, 0, 0, 0, DateTimeZone.UTC).getDayOfYear();
day = days + day;
}
return Operand.Create((day));
} else if (CharUtil.Equals(t, "md")) {
int mo = endDate.Day - startDate.Day;
if (mo < 0) {
final int days;
if (startDate.Month == 12) {
days = new DateTime(startDate.Year + 1, 1, 1, 0, 0, DateTimeZone.UTC).plusDays(-1)
.dayOfMonth().get();
} else {
days = new DateTime(startDate.Year, startDate.Month + 1, 1, 0, 0, DateTimeZone.UTC)
.plusDays(-1).dayOfMonth().get();
}
mo += days;
}
return Operand.Create((mo));
} else if (CharUtil.Equals(t, "ym")) {
int mo = endDate.Month - startDate.Month;
if (endDate.Day < startDate.Day)
mo = mo - 1;
if (mo < 0)
mo += 12;
return Operand.Create((mo));
}
return Operand.Error("Function DATEDIF parameter 3 is error!");
}
public Operand visitDAYS360_fun(final DAYS360_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function DAYS360 parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToDate("Function DAYS360 parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final MyDate startDate = firstValue.DateValue();
final MyDate endDate = secondValue.DateValue();
boolean method = false;
if (args.size() == 3) {
final Operand thirdValue = args.get(2).ToDate("Function DAYS360 parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
method = thirdValue.BooleanValue();
}
int days = endDate.Year * 360 + (endDate.Month - 1) * 30 - startDate.Year * 360 - (startDate.Month - 1) * 30;
if (method) {
if (endDate.Day == 31)
days += 30;
if (startDate.Day == 31)
days -= 30;
} else {
if (startDate.Month == 12) {
if (startDate.Day == new DateTime(startDate.Year + 1, 1, 1, 0, 0, 0, DateTimeZone.UTC).plusDays(-1)
.dayOfMonth().get()) {
days -= 30;
} else {
days -= startDate.Day;
}
} else {
if (startDate.Day == new DateTime(startDate.Year, startDate.Month + 1, 1, 0, 0, 0, DateTimeZone.UTC)
.plusDays(-1).dayOfMonth().get()) {
days -= 30;
} else {
days -= startDate.Day;
}
}
if (endDate.Month == 12) {
if (endDate.Day == new DateTime(endDate.Year + 1, 1, 1, 0, 0, 0, DateTimeZone.UTC).plusDays(-1)
.dayOfMonth().get()) {
if (startDate.Day < 30) {
days += 31;
} else {
days += 30;
}
} else {
days += endDate.Day;
}
} else {
if (endDate.Day == new DateTime(endDate.Year, endDate.Month + 1, 1, 0, 0, 0, DateTimeZone.UTC)
.plusDays(-1).dayOfMonth().get()) {
if (startDate.Day < 30) {
days += 31;
} else {
days += 30;
}
} else {
days += endDate.Day;
}
}
}
return Operand.Create(days);
}
public Operand visitEDATE_fun(final EDATE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function EDATE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function EDATE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
return Operand.Create(firstValue.DateValue().AddMonths(secondValue.IntValue()));
}
public Operand visitEOMONTH_fun(final EOMONTH_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function EOMONTH parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function EOMONTH parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final MyDate dt = firstValue.DateValue().AddMonths(secondValue.IntValue() + 1);
final DateTime dt2 = new DateTime(dt.Year, dt.Month, 1, 0, 0, 0, DateTimeZone.UTC).plusDays(-1);
return Operand.Create(dt2);
}
public Operand visitNETWORKDAYS_fun(final NETWORKDAYS_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand a = item.accept(this).ToDate("Function NETWORKDAYS parameter " + (index++) + " is error!");
if (a.IsError()) {
return a;
}
args.add(a);
}
DateTime startDate = args.get(0).DateValue().ToDateTime();
final DateTime endDate = args.get(1).DateValue().ToDateTime();
final List list = new ArrayList();
for (int i = 2; i < args.size(); i++) {
list.add(args.get(i).DateValue().ToDateTime());
}
int days = 0;
while (startDate.isBefore(endDate) || startDate.isEqual(endDate)) {
if (startDate.dayOfWeek().get() != DateTimeConstants.SUNDAY
&& startDate.dayOfWeek().get() != DateTimeConstants.SATURDAY) {
if (list.contains(startDate) == false) {
days++;
}
}
startDate = startDate.plusDays(1);
}
return Operand.Create(days);
}
public Operand visitWORKDAY_fun(final WORKDAY_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function WORKDAY parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function WORKDAY parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
DateTime startDate = firstValue.DateValue().ToDateTime();
int days = secondValue.IntValue();
final List list = new ArrayList();
for (int i = 2; i < args.size(); i++) {
args.set(i, args.get(i).ToDate("Function WORKDAY parameter {i + 1} is error!"));
if (args.get(i).IsError()) {
return args.get(i);
}
list.add(args.get(i).DateValue().ToDateTime());
}
while (days > 0) {
startDate = startDate.plusDays(1);
if (startDate.dayOfWeek().get() == DateTimeConstants.SATURDAY)
continue;
if (startDate.dayOfWeek().get() == DateTimeConstants.SUNDAY)
continue;
if (list.contains(startDate))
continue;
days--;
}
return Operand.Create(startDate);
}
public Operand visitWEEKNUM_fun(final WEEKNUM_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToDate("Function WEEKNUM parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final DateTime startDate = firstValue.DateValue().ToDateTime();
int days = startDate.dayOfYear().get()
+ new DateTime(startDate.getYear(), 1, 1, 0, 0, 0, DateTimeZone.UTC).dayOfWeek().get();
if (args.size() == 2) {
final Operand secondValue = args.get(1).ToNumber("Function WEEKNUM parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
if (secondValue.IntValue() == 2) {
days--;
}
}
final double week = Math.ceil(days / 7.0);
return Operand.Create(week);
}
@Override
public Operand visitADDYEARS_fun(ADDYEARS_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddYears parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddYears parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddYears(secondValue.IntValue());
return Operand.Create(date);
}
@Override
public Operand visitADDMONTHS_fun(ADDMONTHS_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddMonths parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddMonths parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddMonths(secondValue.IntValue());
return Operand.Create(date);
}
@Override
public Operand visitADDDAYS_fun(ADDDAYS_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddDays parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddDays parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddDays(secondValue.IntValue());
return Operand.Create(date);
}
@Override
public Operand visitADDHOURS_fun(ADDHOURS_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddHours parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddHours parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddHours(secondValue.IntValue());
return Operand.Create(date);
}
@Override
public Operand visitADDMINUTES_fun(ADDMINUTES_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddMinutes parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddMinutes parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddMinutes(secondValue.IntValue());
return Operand.Create(date);
}
@Override
public Operand visitADDSECONDS_fun(ADDSECONDS_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
Operand firstValue = args.get(0).ToDate("Function AddSeconds parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
Operand secondValue = args.get(1).ToNumber("Function AddSeconds parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
MyDate date = firstValue.DateValue().AddSeconds(secondValue.IntValue());
return Operand.Create(date);
}
public Operand visitMAX_fun(final MAX_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MAX parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function MAX parameter error!");
}
return Operand.Create(Max(list));
}
public Operand visitMEDIAN_fun(final MEDIAN_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MEDIAN parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function MEDIAN parameter error!");
}
list = ShellSort(list);
// list = list.OrderBy(q => q).ToList();
return Operand.Create(list.get(list.size() / 2));
}
public Operand visitMIN_fun(final MIN_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MIN parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function MIN parameter error!");
}
return Operand.Create(Min(list));
}
public Operand visitQUARTILE_fun(final QUARTILE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToArray("Function QUARTILE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function QUARTILE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(firstValue, list);
if (o == false) {
return Operand.Error("Function QUARTILE parameter 1 error!");
}
final int quant = secondValue.IntValue();
if (quant < 0 || quant > 4) {
return Operand.Error("Function QUARTILE parameter 2 is error!");
}
final List list2 = new ArrayList();
for (BigDecimal item : list) {
list2.add(item.doubleValue());
}
try {
return Operand.Create(ExcelFunctions.Quartile(list2, quant));
} catch (final Exception e) {
}
return Operand.Error("Function QUARTILE is error!");
}
public Operand visitMODE_fun(final MODE_funContext context) {
final List args = new ArrayList();
int index = 1;
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this).ToNumber("Function MODE parameter " + (index++) + " is error!");
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function MODE parameter error!");
}
final Map dict = new HashMap();
for (final BigDecimal item : list) {
if (dict.containsKey(item)) {
dict.put(item, dict.get(item) + 1);
} else {
dict.put(item, 1);
}
}
int maxCount = 0;
BigDecimal maxValue = new BigDecimal(0);
for (final BigDecimal d : dict.keySet()) {
final int count = dict.get(d);
if (count > maxCount) {
maxCount = count;
maxValue = d;
}
}
return Operand.Create(maxValue);
// return Operand.Create(dict.OrderByDescending(q => q.Value).First().Key);
}
public Operand visitLARGE_fun(final LARGE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToArray("Function LARGE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function LARGE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function LARGE parameter error!");
}
list = ShellSort(list);
// list = list.OrderByDescending(q => q).ToList();
// int quant = secondValue.IntValue();
return Operand.Create(list.get(list.size() - 1 - (secondValue.IntValue() - excelIndex)));
}
public Operand visitSMALL_fun(final SMALL_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToArray("Function SMALL parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function SMALL parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function SMALL parameter error!");
}
list = ShellSort(list);
// list = list.OrderBy(q => q).ToList();
// int quant = secondValue.IntValue();
return Operand.Create(list.get(secondValue.IntValue() - excelIndex));
// return Operand.Create(list[secondValue.IntValue() - excelIndex]);
}
public Operand visitPERCENTILE_fun(final PERCENTILE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToArray("Function PERCENTILE parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function PERCENTILE parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(firstValue, list);
if (o == false) {
return Operand.Error("Function PERCENTILE parameter error!");
}
final double k = secondValue.NumberValue().doubleValue();
final List list2 = new ArrayList();
for (BigDecimal item : list) {
list2.add(item.doubleValue());
}
try {
return Operand.Create(ExcelFunctions.Percentile(list2, k));
} catch (final Exception e) {
}
return Operand.Error("Function PERCENTILE parameter error!");
}
public Operand visitPERCENTRANK_fun(final PERCENTRANK_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final Operand firstValue = args.get(0).ToArray("Function PERCENTRANK parameter 1 is error!");
if (firstValue.IsError()) {
return firstValue;
}
final Operand secondValue = args.get(1).ToNumber("Function PERCENTRANK parameter 2 is error!");
if (secondValue.IsError()) {
return secondValue;
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(firstValue, list);
if (o == false) {
return Operand.Error("Function PERCENTRANK parameter error!");
}
final double k = secondValue.NumberValue().doubleValue();
final List list2 = new ArrayList();
for (BigDecimal item : list) {
list2.add(item.doubleValue());
}
final double v = ExcelFunctions.PercentRank(list2, k);
int d = 3;
if (args.size() == 3) {
final Operand thirdValue = args.get(2).ToNumber("Function PERCENTRANK parameter 3 is error!");
if (thirdValue.IsError()) {
return thirdValue;
}
d = thirdValue.IntValue();
}
return Operand.Create(round(v, d));
}
public Operand visitAVERAGE_fun(final AVERAGE_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function AVERAGE parameter error!");
}
return Operand.Create(Average(list));
}
public Operand visitAVERAGEIF_fun(final AVERAGEIF_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(args.get(0), list);
if (o == false) {
return Operand.Error("Function AVERAGE parameter 1 error!");
}
List sumdbs;
if (args.size() == 3) {
sumdbs = new ArrayList();
final boolean o2 = F_base_GetList_2(args.get(2), sumdbs);
if (o2 == false) {
return Operand.Error("Function AVERAGE parameter 3 error!");
}
} else {
sumdbs = list;
}
BigDecimal sum;
int count;
if (args.get(1).Type() == OperandType.NUMBER) {
count = F_base_countif(list, args.get(1).NumberValue());
sum = args.get(1).NumberValue().multiply(new BigDecimal(count));
} else {
try {
final BigDecimal d = new BigDecimal(args.get(1).TextValue().trim());
count = F_base_countif(list, d);
sum = F_base_sumif(list, "=" + args.get(1).TextValue().trim(), sumdbs);
} catch (final Exception e) {
final String sunif = args.get(1).TextValue().trim();
if (sumifRegex.matcher(sunif).find()) {
count = F_base_countif(list, sunif);
sum = F_base_sumif(list, sunif, sumdbs);
} else {
return Operand.Error("Function AVERAGE parameter 2 error!");
}
}
}
return Operand.Create(sum.divide(new BigDecimal(count), MathContext.DECIMAL32));
}
@Override
public Operand visitPARAM_fun(PARAM_funContext context) {
List exprs = context.expr();
Operand args1 = this.visit(exprs.get(0));
if (args1.Type() != OperandType.TEXT) {
args1 = args1.ToText("");
if (args1.IsError())
return args1;
}
Operand result = GetParameter.apply(args1.TextValue());
if (result.IsError()) {
if (exprs.size() == 2) {
return this.visit(exprs.get(1));
}
}
return result;
}
public Operand visitGEOMEAN_fun(final GEOMEAN_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
if (args.size() == 1)
return args.get(0);
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function GEOMEAN parameter error!");
}
double sum = 1;
for (final BigDecimal db : list) {
sum *= db.doubleValue();
}
return Operand.Create(Math.pow(sum, 1.0 / list.size()));
}
public Operand visitHARMEAN_fun(final HARMEAN_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
if (args.size() == 1)
return args.get(0);
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function HARMEAN parameter error!");
}
double sum = 0;
for (final BigDecimal db : list) {
if (db.compareTo(new BigDecimal(0)) == 0) {
return Operand.Error("Function HARMEAN parameter error!");
}
sum += 1 / db.doubleValue();
}
return Operand.Create(list.size() / sum);
}
public Operand visitCOUNT_fun(final COUNT_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function COUNT parameter error!");
}
return Operand.Create(list.size());
}
public Operand visitCOUNTIF_fun(final COUNTIF_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(args.get(0), list);
if (o == false) {
return Operand.Error("Function COUNTIF parameter error!");
}
int count;
if (args.get(1).Type() == OperandType.NUMBER) {
count = F_base_countif(list, args.get(1).NumberValue());
} else {
try {
final BigDecimal d = new BigDecimal(args.get(1).TextValue().trim());
count = F_base_countif(list, d);
} catch (final Exception e) {
final String sunif = args.get(1).TextValue().trim();
if (sumifRegex.matcher(sunif).find()) {
count = F_base_countif(list, sunif);
} else {
return Operand.Error("Function COUNTIF parameter 2 error!");
}
}
// if (double.TryParse(args.get(1).TextValue().trim(), NumberStyles.Any,
// cultureInfo, out double d)) {
// count = F_base_countif(list, d);
// } else {
// String sunif = args.get(1).TextValue().trim();
// if (sumifRegex.matcher(sunif)) {
// count = F_base_countif(list, sunif);
// } else {
// return Operand.Error("Function COUNTIF parameter 2 error!");
// }
// }
}
return Operand.Create(count);
}
public Operand visitSUM_fun(final SUM_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
if (args.size() == 1)
return args.get(0);
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function SUM parameter error!");
}
final BigDecimal sum = Sum(list);
return Operand.Create(sum);
}
public Operand visitSUMIF_fun(final SUMIF_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_2(args.get(0), list);
if (o == false) {
return Operand.Error("Function SUMIF parameter 1 error!");
}
List sumdbs;
if (args.size() == 3) {
sumdbs = new ArrayList();
final boolean o2 = F_base_GetList_2(args.get(2), sumdbs);
if (o2 == false) {
return Operand.Error("Function SUMIF parameter 3 error!");
}
} else {
sumdbs = list;
}
BigDecimal sum;
if (args.get(1).Type() == OperandType.NUMBER) {
sum = args.get(1).NumberValue().multiply(new BigDecimal(F_base_countif(list, args.get(1).NumberValue())));
} else {
if (Pattern.compile("^-?(\\d+)(\\.\\d+)?$").matcher(args.get(1).TextValue().trim()).find()) {
sum = F_base_sumif(list, "=" + args.get(1).TextValue().trim(), sumdbs);
} else {
final String sunif = args.get(1).TextValue().trim();
if (sumifRegex.matcher(sunif).find()) {
sum = F_base_sumif(list, sunif, sumdbs);
} else {
return Operand.Error("Function SUMIF parameter 2 error!");
}
}
// if (double.TryParse(args.get(1).TextValue().trim(), NumberStyles.Any,
// cultureInfo, out _)) {
// sum = F_base_sumif(list, "=" + args.get(1).TextValue().trim(), sumdbs);
// } else {
// String sunif = args.get(1).TextValue().trim();
// if (sumifRegex.matcher(sunif)) {
// sum = F_base_sumif(list, sunif, sumdbs);
// } else {
// return Operand.Error("Function SUMIF parameter 2 error!");
// }
// }
}
return Operand.Create(sum);
}
public Operand visitAVEDEV_fun(final AVEDEV_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function AVEDEV parameter error!");
}
final double avg = Average(list).doubleValue();
double sum = 0;
for (int i = 0; i < list.size(); i++) {
sum += Math.abs(list.get(i).doubleValue() - avg);
}
return Operand.Create(sum / list.size());
}
public Operand visitSTDEV_fun(final STDEV_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
if (args.size() == 1) {
return Operand.Error("Function STDEV parameter only one error!");
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function STDEV parameter error!");
}
final double avg = Average(list).doubleValue();
double sum = 0;
for (int i = 0; i < list.size(); i++) {
sum += (list.get(i).doubleValue() - avg) * (list.get(i).intValue() - avg);
}
return Operand.Create(Math.sqrt(sum / (list.size() - 1)));
}
public Operand visitSTDEVP_fun(final STDEVP_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList();
final boolean o = F_base_GetList_1(args, list);
if (o == false) {
return Operand.Error("Function STDEVP parameter error!");
}
double sum = 0;
final double avg = Average(list).doubleValue();
for (int i = 0; i < list.size(); i++) {
sum += (list.get(i).doubleValue() - avg) * (list.get(i).doubleValue() - avg);
}
return Operand.Create(Math.sqrt(sum / (list.size())));
}
public Operand visitDEVSQ_fun(final DEVSQ_funContext context) {
final List args = new ArrayList();
for (final ExprContext item : context.expr()) {
final Operand aa = item.accept(this);
if (aa.IsError()) {
return aa;
}
args.add(aa);
}
final List list = new ArrayList
