//执行新版公式
function formulaTrigger(triInfo) {
    var destcellArray = triInfo.destcell;
    var formulatxtArray = triInfo.formulatxt;
    var cellrangeArray = triInfo.cellrange;

    try {
        for (var i = 0; i < formulatxtArray.length; i++) {
            var formulatxt = formulatxtArray[i];
            var cellrange = cellrangeArray[i];
            //没有目标单元格时，只执行函数，不用将函数的执行结果进行赋值
            if (!destcellArray || destcellArray.length == 0 || (destcellArray.length == 1 && !destcellArray[0])) {
                var singleInfo = Object.assign({}, triInfo);
                singleInfo.formulatxt = triInfo.formulatxt[i];
                singleInfo.cellrange = triInfo.cellrange[i];
                return this.calculateNew(singleInfo);
            } else {
                var singleInfo = Object.assign({}, triInfo);
                singleInfo.formulatxt = triInfo.formulatxt[i];
                singleInfo.destcell = triInfo.destcell[i];
                singleInfo.cellrange = triInfo.cellrange[i];
                singleInfo.destfield = triInfo.destfield[i];
                this.calculateNew(singleInfo);
            }
        }
    } catch(ex){
        if(window.console)  console.log("9>>>>>formula calculate error: "+ex);
    }
}

function calculateNew(triInfo) {
    var destcell = triInfo.destcell;
    var cellrange = triInfo.cellrange;
    var formulatxt = triInfo.formulatxt;
    var rowid = triInfo.triggerRowIndex;
    var systemdata = triInfo.systemdata;
    var triggerGroupid = triInfo.triggerGroupid;
    if (!formulatxt) {
        return;
    }
    var hasDestCell = true;
    if (!destcell || destcell.length == 0 || (destcell.length == 1 && !destcell[0])) {
        hasDestCell = false;
    }
    try {
        var vars = {};
        if (formulatxt) {
            formulatxt = formulatxt.replace(/^\s+|\s+$/gm,'');//去掉前后多余空格

            if (formulatxt.toUpperCase().indexOf("SYSTEMFORMULAOPERATE.IF") == 0) {
                var beforeIf = formulatxt.substring(0, formulatxt.indexOf("(") + 1);
                var firstParam = formulatxt.substring(formulatxt.indexOf("(") + 1, formulatxt.indexOf(","));
                var divFirstParam = formulatxt.substring(formulatxt.indexOf(",") + 1);
                var chars = divFirstParam.split("");
                var cnt = 0;
                var secondParam = "";
                var thirdParam = "";
                var temp = '';
                var secondIdx = 0;
                for (var idx = 0; idx < chars.length; idx++) {
                    temp = chars[idx];
                    if (temp == "(") {
                        cnt = cnt + 1;
                    }else if (temp == ")" && idx != chars.length - 1) {
                        cnt = cnt - 1;
                    }else if ((temp == "," && cnt == 0) || (temp == ")" && idx == chars.length - 1)) {
                        if (secondParam) {
                            thirdParam = divFirstParam.substring(secondIdx + 1, divFirstParam.length - 1);
                        } else {
                            secondParam = divFirstParam.substring(0, idx);
                            secondIdx = idx;
                        }
                    }
                }
                formulatxt = beforeIf + firstParam + ", secondParam, thirdParam, triInfo)";
            }
            if ((hasDestCell && destcell.indexOf("detail_")==-1)
                || (!hasDestCell && typeof triggerGroupid == "undefined")) {//赋值给主表字段
                for(var idx=0;cellrange && idx<cellrange.length;idx++){
                    var tempFunction = "";
                    var newTempFunction = "";
                    var tempValue;

                    var cellattr = cellrange[idx];
                    var fieldid = convertCellAttrToFieldid(cellattr);
                    if (cellattr.toLowerCase().indexOf(".id") > -1) {
                        var tempcellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                        tempFunction = "["+tempcellattr+"].id";
                    } else {
                        tempFunction = "["+cellattr+"]";
                    }
                    if(cellattr.indexOf("detail_")>-1){//取值字段为明细字段
                        tempValue = getAllRowValue(cellattr);
                        var varname = "var"+idx;
                        if (cellattr.toLowerCase().indexOf(".id") > -1) {
                            cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                            newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                        } else {
                            newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                        }
                        var wholeFunction = getFunction(formulatxt, cellattr);
                        var isAllNumber = true;
                        var isAllBlank = true;
                        if (isFieldTxt(fieldid)) {
                            for (var i = 0; tempValue && i < tempValue.length; i++) {
                                if (tempValue[i] != "") {
                                    isAllBlank = false;
                                }
                                if (!systemFormulaOperate.IsNumber(tempValue[i])) {
                                    isAllNumber = false;
                                    break;
                                }
                                if (systemFormulaOperate.IsNumber(tempValue[i]) && tempValue[i].length >= 16) {
                                    isAllNumber = false;
                                    break;
                                }
                            }
                        }
                        //明细字段为数字时，将明细中所有的数相加求和后赋值给主表字段
                        if(isFieldNum(fieldid)
                            || (isFieldTxt(fieldid) && (isAllNumber || isAllBlank))
                            || wholeFunction.toUpperCase().indexOf("MAXDATE") > -1
                            || wholeFunction.toUpperCase().indexOf("MINDATE") > -1) {
                            //当计算公式可能为systemFormulaOperate.MAX([detail_1.236662])
                            //也可能为systemFormulaOperate.MAX([detail_1.236662],[detail_1.236663])
                            //两种都是返回所有明细行数据中的最大值
                            if (wholeFunction.toUpperCase().indexOf("MAX") > -1
                                || wholeFunction.toUpperCase().indexOf("MIN") > -1
                                || wholeFunction.toUpperCase().indexOf("AVERAGE") > -1
                                || wholeFunction.toUpperCase().indexOf("RAND") > -1
                                || wholeFunction.toUpperCase().indexOf("COUNTIF") > -1
                                || wholeFunction.toUpperCase().indexOf("COUNT") > -1
                                || wholeFunction.toUpperCase().indexOf("SUMIF") > -1
                                || wholeFunction.toUpperCase().indexOf("MAXDATE") > -1
                                || wholeFunction.toUpperCase().indexOf("MINDATE") > -1) {
                                var newtempFunction = wholeFunction.replace("["+cellattr+"]", "tempValue");
                                if (newtempFunction.indexOf("[") > -1 && newtempFunction.indexOf("]") > -1) {
                                    //当计算公式为systemFormulaOperate.MAX([detail_1.236662],[detail_1.236663])时
                                    vars[varname] = tempValue;
                                    formulatxt = formulatxt.replace(tempFunction,  newTempFunction);
                                } else {
                                    //对公式内容进行计算前的处理
                                    newtempFunction = formatBeforeEval(newtempFunction);
                                    //当计算公式为systemFormulaOperate.MAX([detail_1.236662])时
                                    vars[varname] = eval(newtempFunction);
                                    formulatxt = formulatxt.replace(wholeFunction, "vars."+varname);
                                }
                            } else {
                                var tempSumValue = 0;
                                for (var i=0; tempValue && i < tempValue.length;i++){
                                    tempSumValue = systemFormulaOperate.rewrite_add(tempSumValue, tempValue[i]);
                                }
                                vars[varname] = tempSumValue;
                                formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                            }
                        } else {
                            var tempSumValue = "";
                            if (isFieldBrowser(fieldid)) {
                                for (var i=0; tempValue && i < tempValue.length;i++){
                                    if (tempSumValue && tempSumValue.length > 0) {
                                        tempSumValue = tempSumValue + ",";
                                    }
                                    tempSumValue = tempSumValue + tempValue[i];
                                }
                            } else {
                                for (var i=0; tempValue && i < tempValue.length;i++){
                                    tempSumValue = tempSumValue + tempValue[i];
                                }
                            }

                            vars[varname] = tempSumValue
                            formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                        }
                    } else if (cellattr.indexOf("sys")>-1) {//取值字段为系统字段
                        tempValue = getSystemValue(systemdata, cellattr, triInfo);
                        var varname = "var"+idx;
                        vars[varname] = tempValue;
                        if (cellattr.toLowerCase().indexOf(".id") > -1) {
                            cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                            newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                        } else {
                            newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                        }
                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                    } else if (cellattr.indexOf("main")>-1) {//取值字段为主表字段
                        tempValue = getSingleFieldValue(fieldid);
                        var varname = "var"+idx;
                        vars[varname] = tempValue;
                        if (cellattr.toLowerCase().indexOf(".id") > -1) {
                            cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                            newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                        } else {
                            newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                        }
                        if(isFieldNum(fieldid) || systemFormulaOperate.IsNumber(tempValue)) {
                            if (formulatxt.toUpperCase().indexOf("MAX") > -1
                                || formulatxt.toUpperCase().indexOf("MIN") > -1
                                || formulatxt.toUpperCase().indexOf("AVERAGE") > -1
                                || formulatxt.toUpperCase().indexOf("RAND") > -1
                                || formulatxt.toUpperCase().indexOf("COUNTIF") > -1
                                || formulatxt.toUpperCase().indexOf("COUNT") > -1) {
                                formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                            } else {
                                formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                            }
                        } else {
                            formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                        }
                    }
                }
            } else {//赋值给明细字段
                var destGroupid = hasDestCell ? getGroupid(destcell) : triggerGroupid;
                var srcGroupid;

                for(var idx=0;cellrange && idx<cellrange.length;idx++) {
                    var tempFunction = "";
                    var newTempFunction = "";
                    var tempValue;

                    var cellattr = cellrange[idx];
                    var fieldid = convertCellAttrToFieldid(cellattr);
                    if (cellattr.toLowerCase().indexOf(".id") > -1) {
                        var tempcellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                        tempFunction = "["+tempcellattr+"].id";
                    } else {
                        tempFunction = "["+cellattr+"]";
                    }
                    if(cellattr.indexOf("detail_")>-1){//取值字段为明细字段
                        srcGroupid = getGroupid(cellattr);
                        if (destGroupid === srcGroupid) {//取值字段和赋值字段在同一个明细中
                            if (rowid == undefined || rowid < 0 || triggerGroupid != srcGroupid) {//触发字段与取值字段不在同一个明细中
                                var detailMark = "detail_"+destGroupid;
                                var allRowIndex = window.WfForm.getDetailAllRowIndexStr(detailMark);
                                if (!!allRowIndex) {
                                    var indexs = allRowIndex.split(",");
                                    var varname = "var" + idx;
                                    if (cellattr.toLowerCase().indexOf(".id") > -1) {
                                        cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                                        newTempFunction = tempFunction.replace("[" + cellattr + "].id", "vars." + varname);
                                    } else {
                                        newTempFunction = tempFunction.replace("[" + cellattr + "]", "vars." + varname);
                                    }
                                    if (isFieldNum(fieldid) || systemFormulaOperate.IsNumber(tempValue)) {
                                        formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                                    } else {
                                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                                    }
                                    for (var idx1 = 0; idx1 < indexs.length; idx1++) {
                                        rowid = indexs[idx1];
                                        var singleRowInfo = Object.assign({}, triInfo);
                                        singleRowInfo.triggerGroupid = srcGroupid;
                                        singleRowInfo.triggerRowIndex = rowid;
                                        //分别计算每行的数据
                                        calculateNew(singleRowInfo);
                                    }
                                    return;
                                }
                            } else {//触发字段与取值字段和赋值字段都在同一个明细中
                                tempValue = getSingleFieldValue(fieldid, rowid);
                                var varname = "var" + idx;
                                vars[varname] = tempValue;
                                if (cellattr.toLowerCase().indexOf(".id") > -1) {
                                    cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                                    newTempFunction = tempFunction.replace("[" + cellattr + "].id", "vars." + varname);
                                } else {
                                    newTempFunction = tempFunction.replace("[" + cellattr + "]", "vars." + varname);
                                }
                                if (isFieldNum(fieldid) || systemFormulaOperate.IsNumber(tempValue)) {
                                    formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                                } else {
                                    formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                                }
                            }
                        } else {//取值字段和赋值字段在不同的明细中
                            tempValue = getAllRowValue(cellattr, rowid);
                            var varname = "var"+idx;
                            if (cellattr.toLowerCase().indexOf(".id") > -1) {
                                cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                                newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                            } else {
                                newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                            }
                            //明细字段为数字时，将明细中所有的数相加求和后赋值给主表字段
                            if(isFieldNum(fieldid) || systemFormulaOperate.IsNumber(tempValue)) {
                                var tempSumValue = 0;
                                for (var i=0; tempValue && i < tempValue.length;i++){
                                    tempSumValue = systemFormulaOperate.rewrite_add(tempSumValue, tempValue[i]);
                                }
                                vars[varname] = tempSumValue;
                                formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                            } else {
                                var tempSumValue = "";
                                if (isFieldBrowser(fieldid)) {
                                    for (var i=0; tempValue && i < tempValue.length;i++){
                                        if (tempSumValue && tempSumValue.length > 0) {
                                            tempSumValue = tempSumValue + ",";
                                        }
                                        tempSumValue = tempSumValue + tempValue[i];
                                    }
                                } else {
                                    for (var i=0; tempValue && i < tempValue.length;i++){
                                        tempSumValue = tempSumValue + tempValue[i];
                                    }
                                }

                                vars[varname] = tempSumValue
                                formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                            }
                        }
                    } else if (cellattr.indexOf("sys")>-1) {//取值字段为系统字段
                        tempValue = getSystemValue(systemdata, cellattr, triInfo);
                        var varname = "var"+idx;
                        vars[varname] = tempValue;
                        if (cellattr.toLowerCase().indexOf(".id") > -1) {
                            cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                            newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                        } else {
                            newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                        }
                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                    } else if (cellattr.indexOf("main")>-1) {//取值字段为主表字段
                        tempValue = getSingleFieldValue(fieldid);
                        var varname = "var"+idx;
                        vars[varname] = tempValue;
                        if (cellattr.toLowerCase().indexOf(".id") > -1) {
                            cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
                            newTempFunction = tempFunction.replace("["+cellattr+"].id", "vars."+varname);
                        } else {
                            newTempFunction = tempFunction.replace("["+cellattr+"]", "vars."+varname);
                        }
                        if(isFieldNum(fieldid) || systemFormulaOperate.IsNumber(tempValue)) {
                            formulatxt = formulatxt.replace(tempFunction, "getFormulaFloatValue(" + newTempFunction + ", " + fieldid + ")");
                        } else {
                            formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                        }
                    }
                }
            }
        }
        //对公式内容进行计算前的处理
        formulatxt = formatBeforeEval(formulatxt);
        if (hasDestCell) {
            var calculateResult = eval(formulatxt);
            setValue(destcell, rowid, triggerGroupid, calculateResult, triInfo);
        } else {
            if (formulatxt) {
                if (formulatxt.toLowerCase().indexOf("return") < 0) {
                    var functionStr = "var tempFormulaFunction = function() {\n var ret = " + formulatxt + "\n if(ret != undefined) return ret;\n}";
                } else {
                    var functionStr = "var tempFormulaFunction = function() {\n " + formulatxt + "\n}";
                }
                eval(functionStr);
                var ret = tempFormulaFunction();
                if (ret || ret == 0) {
                    return ret;
                }
            }
        }
    } catch(ex) {
        if(window.console)  console.log("Formula calculate error: "+ex);
    }
}

function evalFormual(expression) {
    var result = "";
    try{
        result = eval(expression);
    }catch(e){
        if(window.console)  console.log("formulaNew evalFormual Appear Exception:"+expression);
    }
    if (result === undefined) {
        return "";
    } else {
        return result.toString();
    }
}

//赋值
function setValue(destcell, rowid, triggerGroupid, calculateResult, triInfo) {
    var destGroupid = getGroupid(destcell);
    var destFieldid;

    //判断是否是单元格位置，如果是就是非字段单元格
    var cellPositionClass = convertCellPosition(destcell);
    if (cellPositionClass) {
        $("td." + cellPositionClass + " span").text(calculateResult);
    } else {
        if (destcell.indexOf("detail_") == -1) {//目标字段为主表字段
            if (destcell && destcell.indexOf(".") > -1) {
                destcell = destcell.substring(destcell.indexOf(".") + 1);
            }
            setFieldValue(destcell, calculateResult, triInfo);
        } else if (destGroupid == triggerGroupid) {
            //目标字段为明细字段，并且与触发字段在同一个明细表中，
            //值更新触发字段所在行的目标字段值
            if (destcell && destcell.indexOf(".") > -1) {
                destcell = destcell.substring(destcell.indexOf(".") + 1);
            }
            setFieldValue(destcell, calculateResult, triInfo, rowid);
        } else {
            //目标字段为明细字段，但是与触发字段不在同一个明细表中
            //目标字段的所有行的字段数据都更新
            if (destcell && destcell.indexOf(".") > -1) {
                destcell = destcell.substring(destcell.indexOf(".") + 1);
            }
            var destDetailMark = "detail_" + destGroupid;
            var destDetailAllRowIndex = WfForm.getDetailAllRowIndexStr(destDetailMark);
            if (!!destDetailAllRowIndex) {
                var indexs = destDetailAllRowIndex.split(",");
                for (var idx = 0; idx < indexs.length; idx++) {
                    var temp = indexs[idx];
                    try {
                        setFieldValue(destcell, calculateResult, triInfo, temp);
                    } catch (ev) {
                    }
                }
            }
        }
    }
}

//tab_1.E12 =>  tab_1_11_4
function convertCellPosition(cell) {
    var reg = /(main|tab_\d+|detail_\d+)![a-z]+\d+/g;
    cell = cell.toLowerCase();
    cell = cell.match(reg);
    if (cell && cell.length > 0) {
        var tempSymbol = cell[0].split("!")[0];
        if (tempSymbol == "main") {
            tempSymbol = "mainTd";
        }
        var cellPosition = getCellIndexByLetterNew(cell[0].split("!")[1]);
        if (cellPosition) {
            var retPosition = tempSymbol + "_" + cellPosition.split(",")[0] + "_" + cellPosition.split(",")[1];
            return retPosition;
        }
    }
}

//将B8转换为7,1
function getCellIndexByLetterNew(cellletter){
    var tempLetter;

    cellletter = cellletter.toLowerCase();
    var reg = /[a-z]+\d+/g;
    var matchField = cellletter.match(reg);
    if (matchField && matchField.length > 0) {
        var row = 0;
        var column = 0;

        reg = /[a-z]+/g;
        var columnField = matchField[0].match(reg);
        if (columnField && columnField.length > 0) {
            column = convertNum(columnField[0])
            column = column - 1;
        }

        reg = /\d+/g;
        var rowField = matchField[0].match(reg);
        if (rowField && rowField.length > 0) {
            row = parseInt(rowField[0]) - 1;
        }
        return row+","+column;
    }
}

function convertNum(str) {
    var n = 0;
    var s = str.match(/./g);//求出字符数组
    var j = 0;
    for (var i = str.length - 1, j = 1; i >= 0; i--, j *= 26) {
        var c = s[i].toUpperCase();
        if (c < 'A' || c > 'Z') {
            return 0;
        }
        n += (c.charCodeAt(0) - 64) * j;
    }
    return n;
}

//给字段赋值赋值
function setFieldValue(fieldid, fieldvalue, triInfo, rownum) {
    if (isFieldBrowser(fieldid)) {
        try {
            jQuery.ajax({
                type: "POST",
                dataType : "JSON",
                url: "/workflow/exceldesign/excelUploadFormula_AssignValue.jsp",
                data : {
                    formid : triInfo.formid,
                    isbill : triInfo.isbill,
                    fieldid : fieldid,
                    fieldvalue : fieldvalue,
                    requestid : triInfo.requestid
                },
                async: false,
                success: function (res) {
                    var destFieldid;
                    if (rownum != undefined && rownum !== "") {
                        destFieldid = "field"+fieldid + "_" + rownum;
                    } else {
                        destFieldid = "field"+fieldid;
                    }

                    WfForm.changeFieldValue(destFieldid, res);
                },
            });
        } catch (e) {
        }
    } else {
        var destFieldid;
        if (rownum != undefined && rownum !== "") {
            destFieldid = "field"+fieldid + "_" + rownum;
        } else {
            destFieldid = "field"+fieldid;
        }
        WfForm.changeFieldValue(destFieldid, {value:fieldvalue});
    }
}

/**
 * 通过单元格位置返回fieldid，如果当前单元格没有字段，则返回空
 * @param cellAttr   MAIN.B5  或 main.21943
 * 返回  21943 或空字符串
 */
function convertCellAttrToFieldid (cellAttr) {
    var symbol = cellAttr.split(".")[0].toLowerCase();
    var fieldid = cellAttr.split(".")[1];
    if (isFieldId(fieldid) == false) {
        return "";
    }
    return fieldid;
}

/**
 * 判断当前字段描述信息是单元格位置还是字段ID
 * @param cellAttr   MAIN.B5
 */
function isFieldId(cellAttr) {
    var reg = /^[0-9]*$/;
    if (reg.test(cellAttr)) {
        return true;
    } else {
        return false;
    }
}

//param为比较表达式，[main.227950]>=[main.227951]
//解决高精度的数值比较问题
function convertCompareFunction(param){
    var paramArray;
    var newFunction = "";
    var param1;
    var param2;
    if (param.indexOf(">=") > -1) {
        paramArray = param.split(">=");
        if (paramArray && paramArray.length == 2) {
            param1 = paramArray[0];
            param1 = paramArray[1];
            newFunction = "systemFormulaOperate.compare(" + paramArray[0] + ", " + paramArray[1] + ") >= 0";
        }
    } else if (param.indexOf("<=") > -1) {
        paramArray = param.split("<=");
        if (paramArray && paramArray.length == 2) {
            param1 = paramArray[0];
            param1 = paramArray[1];
            newFunction = "systemFormulaOperate.compare(" + paramArray[0] + ", " + paramArray[1] + ") <= 0";
        }
    } else if (param.indexOf(">") > -1) {
        paramArray = param.split(">");
        if (paramArray && paramArray.length == 2) {
            param1 = paramArray[0];
            param1 = paramArray[1];
            newFunction = "systemFormulaOperate.compare(" + paramArray[0] + ", " + paramArray[1] + ") > 0";
        }
    } else if (param.indexOf("<") > -1) {
        paramArray = param.split("<");
        if (paramArray && paramArray.length == 2) {
            param1 = paramArray[0];
            param1 = paramArray[1];
            newFunction = "systemFormulaOperate.compare(" + paramArray[0] + ", " + paramArray[1] + ") < 0";
        }
    }
    return newFunction;
}

//获取属于哪个明细表groupid
function getGroupid(cellattr){
    cellattr = cellattr.toUpperCase();
    var idx = cellattr.indexOf("DETAIL_");
    var groupid = -1;
    if(idx == -1)
        return groupid;
    if (cellattr.indexOf(".") == -1) {
        groupid = cellattr.substring(idx+7 ,cellattr.length);
    } else {
        groupid = cellattr.substring(idx+7 ,cellattr.indexOf("."));
    }
    return groupid;
}

//获取单个字段值
function getSingleFieldValue(fieldid, rowIndex) {
    var fieldMark = "";
    if (rowIndex != undefined && rowIndex >= 0) {
        fieldMark = "field" + fieldid + "_" + rowIndex;
    } else {
        fieldMark = "field" + fieldid;
    }
    var fieldValue = window.WfForm.getFieldValue(fieldMark);
    var fieldAttr = window.WfForm.getFieldInfo(fieldid);
    if(fieldAttr.htmltype === 1 && fieldAttr.detailtype === 5)
        fieldValue = fieldValue.toString().replace(/,/g, "");

    if(fieldAttr.htmltype === 1 && fieldAttr.detailtype === 2) {
        if (fieldValue !== "") {
            fieldValue = parseInt(fieldValue);
        }
    } else if (fieldAttr.htmltype === 1 &&
            (fieldAttr.detailtype === 3 || fieldAttr.detailtype === 5)) {
        if (fieldValue !== "") {
            fieldValue = parseFloat(fieldValue);
        }
    }
    return fieldValue;

}
//返回所有行数据，以数组形式返回
function getAllRowValue(cellattr) {
    var fieldid = convertCellAttrToFieldid(cellattr);

    var groupid = getGroupid(cellattr);
    if(groupid==0)     throw new Error("Get detail groupid error!");

    var retArray = [];
    var detailMark = "detail_"+groupid;
    var allRowIndex = window.WfForm.getDetailAllRowIndexStr(detailMark);
    if (!!allRowIndex) {
        var indexs = allRowIndex.split(",");
        for (var idx = 0; idx < indexs.length; idx++) {
            var temp = indexs[idx];
            try{
                var rowValue = getSingleFieldValue(fieldid, temp);
                retArray.push(rowValue);
            }catch(ev){}
        }
    }

    return retArray;
}

//获取系统信息值
function getSystemValue(systeminfo, cellattr, triInfo) {
    var cellValue = "";  //请求标题
    if(cellattr && cellattr.indexOf(".")>-1) {
        cellattr = cellattr.substring(cellattr.indexOf(".")+1);
    }
    if (cellattr === "-1") {
        cellValue = this.getSingleFieldValue(cellattr, -1);
    }
    //紧急程度
    else if (cellattr === "-2") {
        cellValue = this.getSingleFieldValue(cellattr, -2);
    }
    //创建人
    else if (cellattr === "-10") {
        cellValue = systeminfo.creater;
    }
    //创建日期
    else if (cellattr === "-11") {
        cellValue = systeminfo.createdate;
    }
    //工作流ID
    else if (cellattr === "-12") {
        if (triInfo) {
            cellValue = triInfo.workflowid;
        }
    }
    //当前节点ID
    else if (cellattr === "-13") {
        cellValue = systeminfo.currentnodeid;
    }
    //未操作者
    else if (cellattr === "-14") {
        cellValue = systeminfo.nooperator;
    }
    //流程状态
    else if (cellattr === "-15") {
        cellValue = systeminfo.status;
    }
    //归档日期
    else if (cellattr === "-16") {
        cellValue = systeminfo.receivedate;
    }
    //签字意见
    else if (cellattr === "-17") {
        cellValue = systeminfo.remark;
    }
    //当前操作者
    else if (cellattr === "-18") {
        cellValue = systeminfo.userid;
    }
    //创建人所属部门
    else if (cellattr === "-19") {
        cellValue = systeminfo.createrdepartment;
    }
    //创建人所属分部
    else if (cellattr === "-20") {
        cellValue = systeminfo.creatersubcompany;
    }
    //表单ID
    else if (cellattr === "-51") {
        if (triInfo) {
            cellValue = triInfo.formid;
        }
    }
    //是否表单
    else if (cellattr === "-52") {
        if (triInfo) {
            cellValue = triInfo.isbill;
        }
    }
    //请求ID
    else if (cellattr === "-53") {
        if (triInfo) {
            cellValue = triInfo.requestid;
        }
    }
    return cellValue;
}

//判断是不是单行文本字段
function isFieldTxt(fieldid) {
    var fieldAttr = window.WfForm.getFieldInfo(fieldid);
    if(fieldAttr && fieldAttr.htmltype === 1 && fieldAttr.detailtype == 1) {
        return true;
    } else {
        return false;
    }
}

//判断字段是不是数值类型
function isFieldNum(fieldid) {
    var fieldAttr = window.WfForm.getFieldInfo(fieldid);
    if(fieldAttr && fieldAttr.htmltype === 1 && fieldAttr.detailtype != 1) {
        return true;
    } else {
        return false;
    }
}

//判断字段是不是浏览按钮
function isFieldBrowser(fieldid) {
    if (fieldid.indexOf("field") > -1) {
        var index = fieldid.indexOf("_");
        fieldid = index > -1 ? fieldid.substring(5, index) : fieldid.substring(5);
    }
    var fieldAttr = window.WfForm.getFieldInfo(fieldid);
    if(fieldAttr && fieldAttr.browserattr) {
        return true;
    } else {
        return false;
    }
}

//SUM(ABS([main.6306]),ABS([main.6307]))
//返回[main.6306]
function getFunction(formulatxt, cellattr) {
    var index = formulatxt.indexOf(cellattr);
    var beforeIndex = formulatxt.substring(0, index);
    var afterIndex = formulatxt.substring(index + cellattr.length);
    var funcStr = cellattr;
    var char = "";
    var flag = 0;
    var isFunc = false;
    while (beforeIndex) {
        char = beforeIndex.substring(beforeIndex.length - 1);
        beforeIndex = beforeIndex.substring(0, beforeIndex.length - 1);
        if (char == "(") {
            if (flag == 0) {
                isFunc = true;
                funcStr = char + funcStr;
            } else {
                flag += 1;
                isFunc = false;
                funcStr = char + funcStr;
            }

        } else if (char == ")") {
            flag -= 1;
            isFunc = false;
            funcStr = char + funcStr;
        } else if (isFunc == true && /[\+\-\－\>\≥\=\×\÷\<\≤\≠\%\,]/.test(char)) {
            break;
        } else {
            funcStr = char + funcStr;
        }
    }
    char = "";
    flag = 0;
    isFunc = false;
    while (afterIndex) {
        char = afterIndex.substring(0, 1);
        afterIndex = afterIndex.substring(1);
        if (char == ")") {
            if (flag == 0) {
                isFunc = true;
                funcStr = funcStr + char;
            } else {
                flag = flag + 1;
                isFunc = false;
                funcStr = funcStr + char;
            }

        } else if (char == "(") {
            flag = flag - 1;
            isFunc = false;
            funcStr = funcStr + char;
        } else if (isFunc == true && /[\+\-\－\>\≥\=\×\÷\<\≤\≠\%\,]/.test(char)) {
            break;
        } else {
            funcStr = funcStr + char;
        }
    }

    return funcStr;
}

/**
 * @param {String} realval   真实值
 */
function getFormulaFloatValue(realval, fieldid) {
    if (realval === "" || typeof realval == "undefined") {
        return 0;
    }
    if (isFieldTxt(fieldid) && systemFormulaOperate.IsNumber(realval) && realval.length >= 16) {//文本字段，字段值为纯数字，且长度超过16位，直接返回原始值
        return realval;
    }
    if(!systemFormulaOperate.IsNumber(realval))     //非数值直接返回原始值
        return realval;
    return parseFloat(realval);
}

//解析函数中的参数信息
function analyzeFormula(formulatxt) {
    if (formulatxt.indexOf("(") > -1) {
        var name = formulatxt.substring(0, formulatxt.indexOf("("));
        var paramtxt =  formulatxt.substring(formulatxt.indexOf("(") + 1, formulatxt.lastIndexOf(")"));
        var chars = paramtxt.split("");
        //括号个数，左括号+1， 右括号-1，为0时表示之前的括号都已经配对
        var bracketsCnt = 0;
        //存放解析出来的参数
        var params = [];
        var lastIdx = 0;
        for (var idx = 0; idx < chars.length; idx++) {
            var temp = chars[idx];
            if (temp == "(") {
                bracketsCnt = bracketsCnt + 1;
            }else if (temp == ")" && idx != chars.length - 1) {
                bracketsCnt = bracketsCnt - 1;
            }else if ((temp == "," && bracketsCnt == 0) || idx == chars.length - 1) {
                if (idx == chars.length - 1) {
                    params.push(paramtxt.substring(lastIdx));
                } else {
                    params.push(paramtxt.substring(lastIdx, idx));
                }
                if (temp == ",") {
                    lastIdx = idx + 1;
                } else {
                    lastIdx = idx;
                }

            }
        }
        var ret = {};
        ret.name = name;
        ret.params = params;
        return ret;
    }
}

//给函数增加参数信息，主要用于IF，SUMIF，COUNTIF函数
//IF函数需要增加参数triInfo
//SUMIF和COUNTIF增加参数vars
function addFormulaParam(formulatxt, param) {
    var retAnalyze = analyzeFormula(formulatxt);
    if (retAnalyze) {
        formulatxt = retAnalyze.name;
        var retParams = retAnalyze.params;

        if (retParams && retParams.length > 0) {
            formulatxt = formulatxt + "(";
            for (var idx = 0; retParams && idx <retParams.length; idx++) {
                var temp = retParams[idx];
                if (idx > 0) {
                    formulatxt = formulatxt + ",";
                }
                formulatxt = formulatxt + temp;
            }
            formulatxt = formulatxt + ", " + param + ")";
        } else {
            formulatxt = formulatxt + "()";
        }
    }
    return formulatxt;
}
//对公式内容进行计算前的处理
function formatBeforeEval(formulatxt) {
    if (formulatxt.toUpperCase().indexOf("SYSTEMFORMULAOPERATE.COUNTIF_") == 0
        || formulatxt.toUpperCase().indexOf("SYSTEMFORMULAOPERATE.SUMIF_") == 0) {
        //函数增加参数vars
        formulatxt = addFormulaParam(formulatxt, "vars");
    }
    formulatxt = formulatxt.replace(/%/g, "/100");
    return formulatxt;
}