package helper;

import com.yanzuoguang.util.helper.FormulaHelper;
import org.junit.Test;

public class TestFormulaHelper {

    @Test
    public void test() {
        System.out.println(FormulaHelper.calc("120 + 2 * ( a + b * d )", new FormulaHelper.CalcParameter() {
            @Override
            public double getValue(String parameterName) {
                switch (parameterName){
                    case "a":
                        return 5;
                    case "b":
                        return 3;
                    case "d":
                        return 11;
                    default:
                        return 0;
                }
            }
        }));
    }

    @Test
    public void test1() {

        System.out.println(FormulaHelper.calc("= a * 120 + 2 * ( a + b * d )", new FormulaHelper.CalcParameter() {
            @Override
            public double getValue(String parameterName) {
                switch (parameterName){
                    case "a":
                        return 5;
                    case "b":
                        return 3;
                    case "d":
                        return 11;
                    default:
                        return 0;
                }
            }
        }));
    }

    @Test
    public void test3() {
        System.out.println(FormulaHelper.calc("a * 0.006", new FormulaHelper.CalcParameter() {
            @Override
            public double getValue(String parameterName) {
                switch (parameterName){
                    case "a":
                        return 1500;
                    default:
                        return 0;
                }
            }
        }));
    }

    @Test
    public void test2() {
        System.out.println(FormulaHelper.getExcelIndex("aa"));
        System.out.println(FormulaHelper.getExcelIndex("ba"));
        System.out.println(FormulaHelper.getExcelIndex("ab"));
        System.out.println(FormulaHelper.getExcelIndex("a"));
    }
}