/**
 * 明细添加addRow触发相应公式计算
 * 解决主字段参与计算赋值给明细字段，新添加的明细行不触发问题
 */
function triFormula_addRow(groupid){
	try{
		var hasTri = {};
		jQuery(".excelMainTable").find("td[_cellattr][_formula]").each(function(){
			var _cellattr = jQuery(this).attr("_cellattr");
			var _formula = jQuery(this).attr("_formula");
			var reg = new RegExp("^(MAIN|TAB_\d+)\.");
			var reg1 = new RegExp("DETAIL_"+(parseInt(groupid)+1)+"\.");
			if(!reg.test(_cellattr) || !reg1.test(_formula))
				return true;
			//主表字段触发计算明细表行
			var needTri = false;
			var _formulaArr = _formula.split(",");
			jQuery.each(_formulaArr, function(i,value){
				if(!(value in hasTri)){		//避免重复计算
					hasTri[value] = value;
					needTri = true;
				}
			});
			if(needTri){
				var _fieldObj = jQuery(this).find("input[name='field"+jQuery(this).attr("_fieldid")+"']").get(0);
				formulaTrigger(_fieldObj, "addRow");		//手动触发公式计算一次
			}
		});
	}catch(e){
		if(window.console)	console.log("triFormula_addRowError:"+e);
	}
}

/**
 * 明细删除deleteRow触发相应公式计算
 */
function triFormula_delRow(groupid){
	try{
		var needTriFormula = {};
		var reg = new RegExp("^(MAIN|TAB_\d+)\.");
		var detailTable = jQuery(".excelMainTable").find("table#oTable"+groupid);
		if(jQuery("#nodesnum"+groupid).val() == "0"){		//明细记录全删除情况
			var reg_detail = new RegExp("DETAIL_"+(parseInt(groupid)+1)+"\.");
			for(var key in globalFormula){
				var formulaObj = globalFormula[key];
				var destcell = formulaObj["destcell"];
				var formulatxt = formulaObj["formulatxt"];
				if(reg.test(destcell) && reg_detail.test(formulatxt)){	//取值字段含明细字段且赋值字段为主字段
					this.setFieldValueById("field"+formulaObj["destfield"], 0); 	//直接赋值零
				}
			}
		}else{
			detailTable.find("td[_cellattr][_formula]").each(function(){
				var _formulaArr = jQuery(this).attr("_formula").split(",");
				var _vthis = jQuery(this);
				jQuery.each(_formulaArr, function(i,value){
					if(reg.test(value) && !(value in needTriFormula))	//赋值给主字段,避免重复计算
						needTriFormula[value] = _vthis;
				});
			});
			for(var _formula in needTriFormula){
				var _tdObj = needTriFormula[_formula];
				var _fieldObj = _tdObj.find("input[name='field"+_tdObj.attr("_fieldid")+"']").get(0);
				formulaTrigger(_fieldObj, "delRow");		//手动触发公式计算一次
			}
		}
	}catch(e){
		if(window.console)	console.log("triFormula_delRowError:"+e);
	}
}

/**
 * 触发公式，所有公式计算总入口
 */
function formulaTrigger(vthis, triTag){
	try{
		if(typeof(triTag) == "undefined"){		//onpropertychange、_listener触发
			triTag = "";
			if(jQuery.browser.msie && window.event){
				var propertyName = window.event.propertyName;
				if(!!!propertyName || propertyName != 'value')
					return;
			}
			try{	//输入中input不触发公式优化性能
				var activeElm = document.activeElement;
				if(typeof(activeElm) != "undefined"){
					//if(window.console)	console.log(activeElm.tagName+"---"+activeElm.id+"---"+jQuery(vthis).attr("id"))
					//if(activeElm.tagName.toUpperCase()=="INPUT" && (activeElm.id=="" || activeElm.id==jQuery(vthis).attr("id")))
                    if(activeElm.tagName.toUpperCase()=="INPUT" && activeElm.id=="")
						return;
				}
			}catch(e){
				if(window.console)	console.log("Get ActiveElement Error");
			}
		}
        var triggerGroupid;
        if (jQuery(vthis).parent()) {
            var tempCellAttr = jQuery(vthis).parent().attr("_cellattr");
            if (tempCellAttr && tempCellAttr.indexOf("DETAIL_") >= 0) {
                triggerGroupid = parseInt(tempCellAttr.substring(tempCellAttr.indexOf("_")+1, tempCellAttr.indexOf("."))) - 1;
            }
        }
		var triggerFieldid = jQuery(vthis).attr("name").replace("field","");
		var _formula = jQuery("td[_fieldid='"+triggerFieldid+"']").attr("_formula");
		var formulaArr = _formula.split(",");
		for(var len=0;len<formulaArr.length;len++){
			try{
				var formulaJson = globalFormula[formulaArr[len]]
                if (formulaArr[len].indexOf("#new#") > -1) {
                    formulaTriggerByJson(formulaJson, triggerFieldid, triggerGroupid);
                } else {
    				var destcell = formulaJson["destcell"];
    				var formulatxt = formulaJson["formulatxt"];
    				var cellrange = formulaJson["cellrange"];
    				formulatxt = jQuery.trim(formulatxt).substring(1);
    				
    				if(window.console) console.log("1>>>destcell: "+destcell+">>>formulatxt: "+formulatxt);
    				//公式解析分如下几种情况
    				if(destcell.indexOf("DETAIL_")==-1){				//赋值给主表字段
    					if(formulatxt.match(/DETAIL_\d+\./g)){			//取值字段包含明细表字段
    						var reg = /^(EXCEL_AVERAGE|EXCEL_MIN|EXCEL_MAX)\((\s*(MAIN|TAB_\d+|DETAIL_\d+)\.[A-Z]+\d+\s*(\,)?)+\)$/;
    						if(reg.test(formulatxt)){	//针对明细平均计算特殊处理
    							this.calculate_special_detailfield(destcell, formulatxt, cellrange, triTag);
    						}else{
    							this.calculate_detailSumVal(destcell,formulatxt,cellrange, triTag);
    						}
    					}else{											//取值字段全部为主表字段
    						this.calculate_single(destcell,formulatxt,cellrange,false,"", triTag);
    					}
    				}else{												//赋值给明细表字段
    					if(formulatxt.match(/(MAIN|TAB_\d+)\./g)){		//取值字段包含主表字段
    						var triggerCellAttr = jQuery("td[_fieldid='"+triggerFieldid+"']").attr("_cellattr");
    						if(triggerCellAttr.indexOf("DETAIL_")==-1){	//触发字段为主字段，需计算明细所有行记录
    							this.calculate_detailAllRow(destcell,formulatxt,cellrange, triTag);
    						}else{										//触发字段为明细字段，则只计算当前行
    							this.calculate_single(destcell,formulatxt,cellrange,true,triggerFieldid, triTag);
    						}
    					}else{											//取值字段全部为明细表字段
    						this.calculate_single(destcell,formulatxt,cellrange,true,triggerFieldid, triTag);
    					}
    				}
                }
			}catch(ex){
				if(window.console)	console.log("9>>>>>formula calculate error: "+ex);
			}
		}
	}catch(e){
		if(window.console)	console.log("formulaTrigger Error");
	}
}

/**
 * 触发公式，所有公式计算总入口
 */
function formulaTriggerBrowser(vthis, triggerFieldid){
    try{
        var triggerGroupid;
        if (jQuery(vthis).parent()) {
            var tempCellAttr = jQuery(vthis).parent().attr("_cellattr");
            if (tempCellAttr && tempCellAttr.indexOf("DETAIL_") >= 0) {
                triggerGroupid = parseInt(tempCellAttr.substring(tempCellAttr.indexOf("_")+1, tempCellAttr.indexOf("."))) - 1;
            }
        }
        var _formula = jQuery("td[_fieldid='"+triggerFieldid+"']").attr("_formula");
        var formulaArr = _formula.split(",");
        for(var len=0;len<formulaArr.length;len++){
            try{
                var formulaJson = globalFormula[formulaArr[len]]
                if (formulaArr[len].indexOf("#new#") > -1) {
                    formulaTriggerByJson(formulaJson, triggerFieldid, triggerGroupid);
                }
            }catch(ex){
                if(window.console)  console.log("9>>>>>formula calculate error: "+ex);
            }
        }
    }catch(e){
        if(window.console)  console.log("formulaTriggerBrowser Error");
    }
}

function formulaTriggerByJson(formulaJson, triggerFieldid, triggerGroupid){
    try{
        if(typeof(triTag) == "undefined"){      //onpropertychange、_listener触发
            triTag = "";
            if(jQuery.browser.msie && window.event){
                var propertyName = window.event.propertyName;
                if(!!!propertyName || propertyName != 'value')
                    return;
            }
        }
        try{
            var destcellArray = formulaJson["destcell"];
            var formulatxtArray = formulaJson["formulatxt"];
            var cellrangeArray = formulaJson["cellrange"];
            
            for (var i = 0; i < formulatxtArray.length; i++) {
                var destcell = destcellArray[i];
                var formulatxt = formulatxtArray[i];
                var cellrange = cellrangeArray[i];
                
                //没有目标单元格时，只执行函数，不用将函数的执行结果进行赋值
                if (!destcellArray || destcellArray.length == 0 || (destcellArray.length == 1 && !destcellArray[0])) {
                    if (formulatxt && formulatxt.indexOf("(") > -1) {
                        formulatxt = formulatxt.replace(/^\s+|\s+$/gm,'');//去掉前后多余空格
                        if (formulatxt.toUpperCase().indexOf("SYSTEMFORMULAOPERATE.IF") == 0) {
                            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;
                                    }
                                }
                            }
                            if (thirdParam) {
                                var a=formulatxt.split('');
                                a.splice("SYSTEMFORMULAOPERATE.IF(".length + firstParam.length + secondIdx + 2, thirdParam.length, "thirdParam");
                                formulatxt = a.join('');
                                //formulatxt = formulatxt.replace(thirdParam, "thirdParam");
                            }
                            if (secondParam.trim()) {
                                formulatxt = formulatxt.replace(secondParam, "secondParam");
                            }
                            //拼接触发参数
                            formulatxt = formulatxt.substring(0, formulatxt.length - 1);
                            formulatxt = formulatxt + "," + triggerFieldid + "," + triggerGroupid + ")";
                        }
                    }
                    if (cellrange) {
                        var vars = {};
                        var rowid = "";
                        if(triggerFieldid) {
                            triggerFieldid = triggerFieldid.toString();
                            if (triggerFieldid.indexOf("_")>-1) {
                                rowid = triggerFieldid.substring(triggerFieldid.indexOf("_")+1);
                            }
                        }
                        for(var idx=0;idx<cellrange.length;idx++){
                            var cellattr = cellrange[idx];
                            //tempFunction = getFunction(formulatxt, 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, 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);
                                }
                                var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                                //明细字段为数字时，将明细中所有的数相加求和后赋值给主表字段
                                if(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                                    var tempSumValue = 0;
                                    for (var i=0; tempValue && i < tempValue.length;i++){
                                        tempSumValue = tempSumValue + Number(tempValue[i]);
                                    }
                                    vars[varname] = tempSumValue;
                                    formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                                } else {
                                    vars[varname] = tempValue;
                                    formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                                }
                            } else if (cellattr.indexOf("sys")>-1) {//取值字段为系统字段
                                tempValue = getSystemValue(cellattr);
                                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 = getSingleRowValue(cellattr, 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);
                                }
                                var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                                if(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                                    formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                                } else {
                                    formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                                }
                            }
                        }
                    }
                    
                    if (formulatxt && formulatxt.toLowerCase().indexOf("return") < 0) {
                        var functionStr = "var tempFormulaFunction = function() {\n var ret = " + formulatxt + "\n if(ret) return ret;\n}";
                    } else {
                        var functionStr = "var tempFormulaFunction = function() {\n " + formulatxt + "\n}";
                    }
                    eval(functionStr);
                    var ret = tempFormulaFunction();
                    if (ret && ret.trim()) {
                        return ret;
                    }
                } else {
                    if(window.console) console.log("1>>>destcell: "+destcell+">>>formulatxt: "+formulatxt);
                    calculate(destcell, formulatxt, cellrange, triggerFieldid, triggerGroupid);
                }
            }
            
        }catch(ex){
            if(window.console)  console.log("9>>>>>formula calculate error: "+ex);
        }
    }catch(e){
        if(window.console)  console.log("formulaTrigger Error");
    }
}

function calculate(destcell, formulatxtParam, cellrange, triggerFieldid, triggerGroupid) {
    var vars = {};
    var destFieldid;

    var rowid = "";
    if(triggerFieldid) {
        triggerFieldid = triggerFieldid.toString();
        if (triggerFieldid.indexOf("_")>-1) {
            rowid = triggerFieldid.substring(triggerFieldid.indexOf("_")+1);
        }
    }

    var formulatxt = formulatxtParam;
    var tempFunction;
    var newTempFunction;
    var tempValue;
    if (formulatxt) {
        formulatxt = formulatxt.replace(/^\s+|\s+$/gm,'');//去掉前后多余空格
        if (formulatxt.toUpperCase().indexOf("SYSTEMFORMULAOPERATE.IF") == 0) {
            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 = formulatxt.replace(secondParam, "secondParam");
            formulatxt = formulatxt.replace(thirdParam, "thirdParam");
            //拼接触发参数
            formulatxt = formulatxt.substring(0, formulatxt.length - 1);
            formulatxt = formulatxt + "," + triggerFieldid + "," + triggerGroupid + ")";
        }
        if (destcell.indexOf("detail_")==-1) {//赋值给主表字段
            for(var idx=0;cellrange && idx<cellrange.length;idx++){
                var cellattr = cellrange[idx];
                // tempFunction = getFunction(formulatxt, 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, rowid);
                    var varname = "var"+idx;
                    var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                    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(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                        var tempSumValue = 0;
                        for (var i=0; tempValue && i < tempValue.length;i++){
                            tempSumValue = tempSumValue + tempValue[i];
                        }
                        vars[varname] = tempSumValue;
                        formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                    } else {
                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                    }
                } else if (cellattr.indexOf("sys")>-1) {//取值字段为系统字段
                    tempValue = getSystemValue(cellattr);
                    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 = getSingleRowValue(cellattr, rowid);
                    var varname = "var"+idx;
                    vars[varname] = tempValue;
                    var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                    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(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                        formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                    } else {
                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                    }
                }
                
            }
        } else {//赋值给明细字段
            var destGroupid = getGroupid(destcell);
            var srcGroupid;

            for(var idx=0;cellrange && idx<cellrange.length;idx++) {
                var cellattr = cellrange[idx];
                // tempFunction = getFunction(formulatxt, 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) {//取值字段和赋值字段在同一个明细中
                        tempValue = getSingleRowValue(cellattr, 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);
                        }
                        var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                        if(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                            formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                        } 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);
                        }
                        var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                        //明细字段为数字时，将明细中所有的数相加求和后赋值给主表字段
                        if(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                            var tempSumValue = 0;
                            for (var i=0; tempValue && i < tempValue.length;i++){
                                tempSumValue = tempSumValue + tempValue[i];
                            }
                            vars[varname] = tempSumValue;
                            formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                        } else {
                            formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                        }
                    }
                } else if (cellattr.indexOf("sys")>-1) {//取值字段为系统字段
                    tempValue = getSystemValue(cellattr);
                    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 = getSingleRowValue(cellattr, rowid);
                    var varname = "var"+idx;
                    vars[varname] = tempValue;
                    var fieldObj = getFieldObjByCellattr(cellattr, rowid);
                    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(fieldObj.attr("datatype")=="int" || fieldObj.attr("datatype")=="float") {
                        formulatxt = formulatxt.replace(tempFunction, "Number(" + newTempFunction + ")");
                    } else {
                        formulatxt = formulatxt.replace(tempFunction, newTempFunction);
                    }
                }
            }
        }
    }
    

    var calculateResult = eval(formulatxt);
    if(window.console)  console.log("2>>>formulatxt: "+destFieldid+"=="+formulatxtParam+">>>calResult: "+calculateResult);
    setValue(destcell, rowid, triggerGroupid, calculateResult);
}

function setValue(destcell, rowid, triggerGroupid, calculateResult) {
    var destGroupid = getGroupid(destcell);
    var destFieldid;
    if (destcell.indexOf("detail_") == -1) {//目标字段为主表字段
        if(destcell && destcell.indexOf(".")>-1) {
            destcell = destcell.substring(destcell.indexOf(".")+1);
        }
        destFieldid = "field"+destcell;
        this.setFieldValueByIdNew(destFieldid, calculateResult);
    } else if (destGroupid == triggerGroupid) {
        //目标字段为明细字段，并且与触发字段在同一个明细表中，
        //值更新触发字段所在行的目标字段值
        if(destcell && destcell.indexOf(".")>-1) {
            destcell = destcell.substring(destcell.indexOf(".")+1);
        }
        destFieldid = "field"+destcell + "_" + rowid;
        this.setFieldValueByIdNew(destFieldid, calculateResult);
    } else {
        //目标字段为明细字段，但是与触发字段不在同一个明细表中
        //目标字段的所有行的字段数据都更新
        if(destcell && destcell.indexOf(".")>-1) {
            destcell = destcell.substring(destcell.indexOf(".")+1);
        }
        var eachRowObj = jQuery("input[type='checkbox'][name='check_node_"+destGroupid+"']");
        eachRowObj.each(function(){
            try{
                var rowid = jQuery(this).val();
                destFieldid = "field"+destcell + "_" + rowid;
                setFieldValueByIdNew(destFieldid, calculateResult);
            }catch(ev){}
        }); 
    }
}

function getSingleRowValue(cellattr, rowid) {
    return getValue(cellattr, rowid);

}

function getAllRowValue(cellattr, rowid) {

    var groupid = getGroupid(cellattr);
    if(groupid==-1)     throw new Error("Get detail groupid error!");
    
    var retArray = [];
    var eachRowObj = jQuery("input[type='checkbox'][name='check_node_"+groupid+"']");
    eachRowObj.each(function(){
        try{
            var rowid = jQuery(this).val();
            var rowValue = getValue(cellattr, rowid);
            retArray.push(rowValue);
        }catch(ev){}
    }); 

    return retArray;
}

function getSystemValue(cellattr) {
    var cellValue;  //请求标题
    if(cellattr && cellattr.indexOf(".")>-1) {
        cellattr = cellattr.substring(cellattr.indexOf(".")+1);
    }
    if (cellattr === "-1") {
        cellValue = getFieldValueByIdNew("requestname", "");
    }
    //紧急程度
    else if (cellattr === "-2") {
        cellValue = getFieldValueByIdNew("requestlevel", "");
    }
    //创建人
    else if (cellattr === "-10") {
        cellValue = systeminfo.creater;
    }
    //创建日期
    else if (cellattr === "-11") {
        cellValue = systeminfo.createdate;
    }
    //工作流ID
    else if (cellattr === "-12") {
        cellValue = jQuery("input[name='workflowid']").val();
    }
    //当前节点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;
    }
    return cellValue;
}

function getValue(cellattr, rowid) {

    var fieldval = "";
    var fieldid = getFieldIdByCellattr(cellattr, rowid);
    //浏览按钮且无.id，举例：[主表.多人力资源]
    if (jQuery("#"+fieldid+"_browserbtn").length > 0 && cellattr.toLowerCase().indexOf(".id") < 0) {
        fieldObj = jQuery("#"+fieldid+"span").children("span").children("a");
        if(fieldObj.size() == 1){
            fieldval = fieldObj.html();
        } else if (fieldObj.size() > 1) {
            for (var i = 0; i < fieldObj.size(); i++) {
                if (fieldval) {
                    fieldval = fieldval + ",";
                }
                fieldval = fieldval + fieldObj[i].innerHTML;
            }
        }
    } else {
        var type = document.getElementById(fieldid).type;
        fieldObj = jQuery("#"+fieldid);
        //下拉列表框且无.ID
        if (type.indexOf("select") > -1 && cellattr.toLowerCase().indexOf(".id") < 0 && fieldObj.size()>0) {
            console.log("fieldObj.type:"+type);
            fieldval = fieldObj.find("option:selected").text();
        } else {
            //文本框、多文本框、下拉列表框.id、浏览按钮.id
            if(fieldObj.size()>0){
                fieldval = fieldObj.val();
                if(!!fieldval&&fieldObj.attr("datavaluetype")=="5"){
                    fieldval = fieldval.replace(/,/g,"");
                }
            }
        }
    }
    
    if(fieldObj.attr("datatype")=="int") {
        if (fieldval != "") {
            fieldval = parseInt(fieldval);
        } else {
            fieldval = 0;
        }
    } else if (fieldObj.attr("datatype")=="float") {
        if (fieldval != "") {
            fieldval = parseFloat(fieldval);
        } else {
            fieldval = 0;
        }
    }
    return fieldval;
}

function getFieldObjByCellattr(cellattr, rowid) {
    //浏览字段取id值
    if (cellattr.toLowerCase().indexOf(".id") > -1) {
        cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
    }
    if(rowid !== "" && cellattr.indexOf("detail_")>-1)
        rowid = "_"+rowid;
    if(cellattr && cellattr.indexOf(".")>-1) {
        cellattr = cellattr.substring(cellattr.indexOf(".")+1);
    }

    var fieldid = "field" + cellattr;

    if (rowid) {
        fieldid = fieldid + rowid;
    }
    //var fieldObj = jQuery("input#"+fieldid);
    return jQuery("#"+fieldid);
}

function getFieldIdByCellattr(cellattr, rowid) {
    //浏览字段取id值
    if (cellattr.toLowerCase().indexOf(".id") > -1) {
        cellattr = cellattr.substring(0, cellattr.toLowerCase().indexOf(".id"));
    }
    if(rowid !== "" && cellattr.indexOf("detail_")>-1)
        rowid = "_"+rowid;
    if(cellattr && cellattr.indexOf(".")>-1) {
        cellattr = cellattr.substring(cellattr.indexOf(".")+1);
    }

    var fieldid = "field" + cellattr;

    if (rowid) {
        fieldid = fieldid + rowid;
    }
    return fieldid;
}

//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;
}
function replaceSystemValue(formulatxt, cellattr) {
    var cellValue;  //请求标题
    if (cellattr === "-1") {
        cellValue = getFieldValueByIdNew("requestname", "");
    }
    //紧急程度
    else if (cellattr === "-2") {
        cellValue = getFieldValueByIdNew("requestlevel", "");
    }
    //创建人
    else if (cellattr === "-10") {
        cellValue = systeminfo.creater;
    }
    //创建日期
    else if (cellattr === "-11") {
        cellValue = systeminfo.createdate;
    }
    //工作流ID
    else if (cellattr === "-12") {
        cellValue = jQuery("input[name='workflowid']").val();
    }
    //当前节点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;
    }
    if (formulatxt && cellValue) {
        var curindex = -1;
        var fieldCellAttr = "[" + cellattr + "]";
        while(formulatxt.indexOf(fieldCellAttr)>curindex){
            curindex = formulatxt.indexOf(fieldCellAttr);
            var str1 = formulatxt.substring(0,curindex);
            var str2 = formulatxt.substring(curindex+fieldCellAttr.length);
            var reg=/^[0-9]$/;
            var nextchar = str2.substr(0,1);
            if(reg.test(nextchar))  continue;
            formulatxt = str1+cellValue+str2;
        }
    }
    
    return formulatxt;
}
/**
 * 根据字段唯一ID获取字段
 */
function getFieldValueByIdNew(cellattr, _row){
//  var fieldid = "field"+jQuery("td[_cellattr='"+cellattr+_row+"']").attr("_fieldid");
    var fieldid = "field" + cellattr;
    var fieldval = "";
    //var fieldObj = jQuery("input#"+fieldid);
    var fieldObj = jQuery("#"+fieldid);
    if(fieldObj.size()>0){
        fieldval = fieldObj.val();
        if(!!fieldval&&fieldObj.attr("datavaluetype")=="5"){
            fieldval = fieldval.replace(/,/g,"");
        }
    }
    if(fieldval == "")
        fieldval = "";
    if(isNaN(fieldval)) 
        fieldval = "\""+fieldval+"\"";
    return fieldval;
}
/**
 * 将计算结果更新到赋值字段中
 */
function setFieldValueByIdNew(fieldid,calculateResult){
    if($.client=='mobile'){
         setFieldMobileValueById(fieldid,calculateResult)
        return;
    }
    var fieldElement=jQuery("#"+fieldid);
    if(fieldElement.size()==0 && jQuery("#"+fieldid)[0].tagName!= "SELECT") return;
    var fieldvalue = "";
    var regnum = /^(-?\d+)(\.\d+)?$/;
    var isNumber = regnum.test(calculateResult);
    //eval(23*1.4)=32.19999，eval都存在误差，赋值前都toFixed下
    if(fieldElement.attr("datatype")=="int"){       //转换为整数
        if(isNumber)
            fieldvalue = Math.round(parseFloat(calculateResult)).toString();
    }else if(fieldElement.attr("datatype")=="float"){   //调用format_wev8.js的方法转换为浮点数、千分位
        if(isNumber){
            var decimals = parseInt(fieldElement.attr("datalength"));
            var calculateResult_num = new Number(calculateResult);
            calculateResult = toFix(calculateResult_num,decimals).toString();
            if(fieldElement.attr("datavaluetype")=="5"){
                fieldvalue = formatValue_float(calculateResult,decimals,1,1);
            }else{
                fieldvalue = formatValue_float(calculateResult,decimals,0,1);
            }
        }
    }else{
        //if(isNumber){   //数值赋值给文本，取两位小数
            //var calculateResult_num = new Number(calculateResult);
            //calculateResult = toFix(calculateResult_num,2).toString();
        //}
        fieldvalue = calculateResult;
    }
    
    fieldElement.attr("value",fieldvalue);
    if(jQuery("#"+fieldid)[0].tagName== "SELECT"){
        jQuery("#"+fieldid).find("option").each(function(index,ele){
            jQuery(ele).removeAttr("selected");
        });
        if(fieldvalue !== ""){
            jQuery("#"+fieldid).find("option[value='" + parseInt(fieldvalue,10) + "']").attr("selected","selected");
        }
    }
    if(fieldElement.attr("type")=="hidden" && !(jQuery("#dis"+fieldid).length > 0 && jQuery("#dis"+fieldid)[0].tagName== "SELECT")){        //只读
        if(jQuery("span#"+fieldid+"span").size()>0){
            jQuery("span#"+fieldid+"span").text(fieldvalue);
        }
    }
    if(jQuery("#dis"+fieldid).length > 0 && jQuery("#dis"+fieldid)[0].tagName== "SELECT"){
        jQuery("#dis"+fieldid).find("option").each(function(index,ele){
            jQuery(ele).removeAttr("selected");
        });
        if(fieldvalue !== ""){
            jQuery("#dis"+fieldid).find("option[value='" + parseInt(fieldvalue,10) + "']").attr("selected","selected");
            fieldElement.attr("value",parseInt(fieldvalue,10));
        }
    }
    window.setTimeout(function(){           //明细字段触发SQL赋值，需延时执行，why
        fieldElement.trigger("change");     //触发合计函数
    },100);
}


/**
 * 单一公式计算---包含三种情况(纯主表间计算、纯明细表间计算、触发字段为明细字段且赋值字段为明细字段计算)
 * @argument hasDetail 计算是否包含明细表
 */
function calculate_single(destcell,formulatxt,cellrange,hasDetail,triggerFieldid, triTag){
	var rowid = "";
	if(hasDetail){		//涉及到明细表，需传入明细行id
		if(triggerFieldid.indexOf("_")>-1){
			rowid = triggerFieldid.substring(triggerFieldid.indexOf("_")+1);
			if(!isInt(rowid))
				throw new Error("Detail current rowid is not a int");
		}else{
			throw new Error("Get detail current rowid error");
		}
	}
	formulatxt = this.formulaReplaceValue(formulatxt,cellrange,rowid);
	
	if(destcell.indexOf("DETAIL_")>-1){
		destcell += "_"+rowid;
	}
	var destFieldid = "field"+jQuery("td[_cellattr='"+destcell+"']").attr("_fieldid");
	var calculateResult = eval(formulatxt);
	
	if(window.console)	console.log("2>>>formulatxt: "+destFieldid+"=="+formulatxt+">>>calResult: "+calculateResult);
	this.setFieldValueById(destFieldid,calculateResult);
}

/**
 * 求和公式计算--赋值字段为主字段，取值字段为明细/主表字段混合情况；需明细每条记录计算，再求和，再赋值给主表字段
 * @argument groupid   对应明细表ID
 */
function calculate_detailSumVal(destcell,formulatxt,cellrange, triTag){
	var groupid = -1;
	for(var idx=0;idx<cellrange.length;idx++){
		var cellattr = cellrange[idx];
		if(cellattr.indexOf("DETAIL_")>-1){
			groupid = getGroupid(cellattr);
			break;
		}
	}
	if(groupid==-1)		throw new Error("Get detail groupid error!");
						
	var calculateSumResult = 0;
	jQuery("input[type='checkbox'][name='check_node_"+groupid+"']").each(function(){
		try{
			var rowid = jQuery(this).val();
			if($.client=='mobile'){
				var rowindex_=jQuery(this).attr("_rowindex");
				if(rowindex_!=null&& rowindex_!=undefined){
				   rowid = rowindex_;
				}
			}
			var formulatxt_clone = formulatxt;
			formulatxt_clone = formulaReplaceValue(formulatxt_clone,cellrange,rowid);
			var calculateResult = eval(formulatxt_clone);
			
			if(window.console)	console.log("2>>>rowid: "+rowid+">>>formulatxt_clone: "+formulatxt_clone+">>>calResult: "+calculateResult);
			if(!isNaN(parseFloat(calculateResult))){
				calculateSumResult = rewrite_add(calculateSumResult,calculateResult);
			}
		}catch(ev){}
	});
	var destFieldid = "field"+jQuery("td[_cellattr='"+destcell+"']").attr("_fieldid");
	this.setFieldValueById(destFieldid,calculateSumResult);
}

/**
 * 明细所有行公式计算--赋值字段为明细字段，触发字段为主表字段；明细表每条记录都需经过公式计算再赋值
 * @argument groupid   对应明细表ID
 */
function calculate_detailAllRow(destcell,formulatxt,cellrange, triTag){
	var groupid = getGroupid(destcell);
	if(groupid==-1)		throw new Error("Get detail groupid error!");
	
	var eachRowObj = jQuery("input[type='checkbox'][name='check_node_"+groupid+"']");
	if(triTag === "addRow")
		eachRowObj = eachRowObj.last();
	eachRowObj.each(function(){
		try{
			var rowid = jQuery(this).val();
			if($.client=='mobile'){
				var rowindex_=jQuery(this).attr("_rowindex");
				if(rowindex_!=null&& rowindex_!=undefined){
				   rowid = rowindex_;
				}
			}
			var formulatxt_clone = formulatxt;
			formulatxt_clone = formulaReplaceValue(formulatxt_clone,cellrange,rowid);
			var calculateResult = eval(formulatxt_clone);
			
			if(window.console)	console.log("2>>>rowid: "+rowid+">>>formulatxt_clone: "+formulatxt_clone+">>>calResult: "+calculateResult);
			var destFieldid = "field"+jQuery("td[_cellattr='"+destcell+"_"+rowid+"']").attr("_fieldid");
			setFieldValueById(destFieldid,calculateResult);
		}catch(ev){}
	}); 
}

/**
 * 公式特殊处理，只计算一次，明细字段替换时取明细所有行字段的值
 */
function calculate_special_detailfield(destcell,formulatxt,cellrange, triTag){
	formulatxt = this.formulaReplaceValue(formulatxt,cellrange,"all");
	var destFieldid = "field"+jQuery("td[_cellattr='"+destcell+"']").attr("_fieldid");
	var calculateResult = eval(formulatxt);
	
	if(window.console)	console.log("2>>>formulatxt: "+destFieldid+"=="+formulatxt+">>>calResult: "+calculateResult);
	this.setFieldValueById(destFieldid,calculateResult);
}

/**
 * 将公式字符串中的单元格ID替换为对应的值
 * @param {} formulatxt		公式原字符串
 * @param {} cellrange		公式中所有单元格ID
 * @param {} rowid	明细当前行
 */
function formulaReplaceValue(formulatxt,cellrange,rowid){
	jQuery.each(cellrange,function(index,cellattr){
		var cellValue = "";
		if(rowid === "all" && cellattr.indexOf("DETAIL_")>-1){	//需替换明细所有行字段
			var groupid = getGroupid(cellattr);
			jQuery("input[type='checkbox'][name='check_node_"+groupid+"']").each(function(index){
				var _row = "_"+jQuery(this).val();
				if($.client=='mobile'){
					var rowindex_=jQuery(this).attr("_rowindex");
					if(rowindex_!=null&& rowindex_!=undefined){
					   _row = "_"+rowindex_;
					}
				}
				var _cellValue = getFieldValueById(cellattr, _row);
				if(index != 0)	_cellValue = ","+_cellValue;
				cellValue += _cellValue;
			});
		}else{
			var _row = "";
			if(rowid !== "" && cellattr.indexOf("DETAIL_")>-1)
				_row = "_"+rowid;
			cellValue = getFieldValueById(cellattr, _row);
		}
		if(cellValue == "")		cellValue = "\""+cellValue+"\"";
		//不能简单的用replace，需判断替换串后一个字符是否是数字，避免例如MAIN.D1的值替换了MAIN.D11串
		var curindex = -1;
		while(formulatxt.indexOf(cellattr)>curindex){
			curindex = formulatxt.indexOf(cellattr);
			var str1 = formulatxt.substring(0,curindex);
			var str2 = formulatxt.substring(curindex+cellattr.length);
			var reg=/^[0-9]$/;
			var nextchar = str2.substr(0,1);
			if(reg.test(nextchar))	continue;
			formulatxt = str1+cellValue+str2;
		}
	});
	return formulatxt;
}

/**
 * 根据字段唯一ID获取字段
 */
function getFieldValueById(cellattr, _row){
	var fieldid = "field"+jQuery("td[_cellattr='"+cellattr+_row+"']").attr("_fieldid");
	var fieldval = "";
	//var fieldObj = jQuery("input#"+fieldid);
	var fieldObj = jQuery("#"+fieldid);
	if(fieldObj.size()>0){
		fieldval = fieldObj.val();
		if(!!fieldval&&fieldObj.attr("datavaluetype")=="5"){
			fieldval = fieldval.replace(/,/g,"");
		}
	}
	if(fieldval == "")
		fieldval = "";
	if(isNaN(fieldval))	
		fieldval = "\""+fieldval+"\"";
	return fieldval;
}

/**
 * 移动端将计算结果更新到赋值字段中
 */
function setFieldMobileValueById(fieldid,calculateResult){
	 	var fieldElement=jQuery("#"+fieldid);
		var field_id = fieldid.replace("field","");
	if(fieldElement.size()==0)	return;
	var fieldvalue = "";
	var regnum = /^(-?\d+)(\.\d+)?$/;
	var isNumber = regnum.test(calculateResult);
	//eval(23*1.4)=32.19999，eval都存在误差，赋值前都toFixed下
	if(fieldElement.attr("datatype")=="int"){		//转换为整数
		if(isNumber)
			fieldvalue = Math.round(parseFloat(calculateResult)).toString();
	}else if(fieldElement.attr("datatype")=="float"){	//调用format_wev8.js的方法转换为浮点数、千分位
		if(isNumber){
			var decimals = parseInt(fieldElement.attr("datalength"));
			var calculateResult_num = new Number(calculateResult);
			calculateResult = toFix(calculateResult_num,decimals).toString();
			if(fieldElement.attr("datavaluetype")=="5"){
				fieldvalue = formatValue_float(calculateResult,decimals,1,1);
			}else{
				fieldvalue = formatValue_float(calculateResult,decimals,0,1);
			}
		}
	}else{
		if(isNumber){	//数值赋值给文本，取两位小数
			var calculateResult_num = new Number(calculateResult);
			calculateResult = toFix(calculateResult_num,2).toString();
		}
		fieldvalue = calculateResult;
	}
	if (fieldvalue && fieldvalue instanceof Date) {
        fieldvalue = fieldvalue.toString();
    }
	var reg = new RegExp(",", "g" );
	var textFormartVal = fieldvalue.replace(reg,"");
	fieldElement.attr("value",textFormartVal);
	if(jQuery("#fieldformart"+field_id)){
		jQuery("#fieldformart"+field_id).val(fieldvalue);
	}
	if(fieldElement.attr("type")=="hidden"){		//只读
		if(jQuery("span#"+fieldid+"_span").size()>0){
			jQuery("span#"+fieldid+"_span").text(fieldvalue);
			if(jQuery("span#fieldformart"+field_id)){
				jQuery("span#fieldformart"+field_id).text(fieldvalue);
		    }
			try{
                  jQuery("span#fieldformart"+field_id).blur();
			}catch(e){}
		}
		if(jQuery( "span#"+fieldid+"_span_d").size()>0){  
			jQuery("span#"+fieldid+"_span_d").text(fieldvalue);   
			var  fieldidShowDiv=fieldid.replace("field","").replace("_","");  
			$("#"+$("#"+fieldidShowDiv).val()).text(fieldvalue);         
		}
	}
	//金额转换赋值
	 if(fieldElement.attr("datatype")=="float"&&fieldElement.attr("datavaluetype")=="4"){
	 	   if(jQuery("input#"+fieldid.replace("field","field_lable")+"").length>0){
	 	  	jQuery("input#"+fieldid.replace("field","field_lable")+"").val(fieldvalue);
	        jQuery("input#"+fieldid.replace("field","field_lable")+"").attr("value",fieldvalue);
	        jQuery("input#"+fieldid.replace("field","field_lable")+"").blur();
	 	  } 
	 	  if(jQuery("input#"+fieldid.replace("field","field_lable")+"_d").length>0){
	 	  	jQuery("input#"+fieldid.replace("field","field_lable")+"_d").val(fieldvalue);
	        jQuery("input#"+fieldid.replace("field","field_lable")+"_d").attr("value",fieldvalue);
	        jQuery("input#"+fieldid.replace("field","field_lable")+"_d").blur();
	 	  }   
	 }
	try{
	  jQuery("input#"+fieldid+"_d").val(fieldvalue);
	  jQuery("input#"+fieldid+"_d").attr("value",fieldvalue);
	  $("#"+$("#"+fieldid.replace("_","").replace("field","")).val()).html(fieldvalue);
	}catch(e){}

	window.setTimeout(function(){			//明细字段触发SQL赋值，需延时执行，why

		if($(fieldElement).attr("onfocus")!=undefined && $(fieldElement).attr("onfocus")!=null){
			   fieldElement.trigger("focus");		//触发合计函数
		}

		if($(fieldElement).attr("onblur")!=undefined && $(fieldElement).attr("onblur")!=null){
			   fieldElement.trigger("blur");		//触发合计函数
		}
		
		if($(fieldElement).attr("onchange")!=undefined && $(fieldElement).attr("onchange")!=null){
			   fieldElement.trigger("change");		//触发合计函数
		}
	},100);
}

/**
 * 将计算结果更新到赋值字段中
 */
function setFieldValueById(fieldid,calculateResult){
		if($.client=='mobile'){
         setFieldMobileValueById(fieldid,calculateResult)
		return;
	}
	var fieldElement=jQuery("input#"+fieldid);
	if(fieldElement.size()==0 && jQuery("#"+fieldid)[0].tagName!= "SELECT")	return;
	var fieldvalue = "";
	var regnum = /^(-?\d+)(\.\d+)?$/;
	var isNumber = regnum.test(calculateResult);
	//eval(23*1.4)=32.19999，eval都存在误差，赋值前都toFixed下
	if(fieldElement.attr("datatype")=="int"){		//转换为整数
		if(isNumber)
			fieldvalue = Math.round(parseFloat(calculateResult)).toString();
	}else if(fieldElement.attr("datatype")=="float"){	//调用format_wev8.js的方法转换为浮点数、千分位
		if(isNumber){
			var decimals = parseInt(fieldElement.attr("datalength"));
			var calculateResult_num = new Number(calculateResult);
			calculateResult = calculateResult_num.toFixed(decimals).toString();
			if(fieldElement.attr("datavaluetype")=="5"){
				fieldvalue = formatValue_float(calculateResult,decimals,1,1);
			}else{
				fieldvalue = formatValue_float(calculateResult,decimals,0,1);
			}
		}
	}else{
		if(isNumber){	//数值赋值给文本，取两位小数
			var calculateResult_num = new Number(calculateResult);
			calculateResult = calculateResult_num;
		}
		fieldvalue = calculateResult;
	}
	
	fieldElement.attr("value",fieldvalue);
	if(jQuery("#"+fieldid)[0].tagName== "SELECT"){
		jQuery("#"+fieldid).find("option").each(function(index,ele){
			jQuery(ele).removeAttr("selected");
		});
		if(fieldvalue !== ""){
		    jQuery("#"+fieldid).find("option[value='" + parseInt(fieldvalue,10) + "']").attr("selected","selected");
			window.setTimeout(function(){
				jQuery("#"+fieldid).trigger("change");
			},300);
		}
	}
	if(fieldElement.attr("type")=="hidden" && !(jQuery("#dis"+fieldid).length > 0 && jQuery("#dis"+fieldid)[0].tagName== "SELECT")){		//只读
		if(jQuery("span#"+fieldid+"span").size()>0){
			jQuery("span#"+fieldid+"span").text(fieldvalue);
		}
	}
	if(jQuery("#dis"+fieldid).length > 0 && jQuery("#dis"+fieldid)[0].tagName== "SELECT"){
		jQuery("#dis"+fieldid).find("option").each(function(index,ele){
			jQuery(ele).removeAttr("selected");
		});
		if(fieldvalue !== ""){
		    jQuery("#dis"+fieldid).find("option[value='" + parseInt(fieldvalue,10) + "']").attr("selected","selected");
			fieldElement.attr("value",parseInt(fieldvalue,10));
		}
	}
	window.setTimeout(function(){			//明细字段触发SQL赋值，需延时执行，why
		if(fieldElement.attr("datavaluetype")=="5"){
			fieldElement.attr("value",calculateResult); //合计之前去掉逗号，否则数据会被清空
		}
		fieldElement.trigger("change");		//触发合计函数
		fieldElement.trigger("blur");       //格式化千分位
	},100);
}

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

//是否是纯数字
function isInt(str){
	var reg = /^[0-9]+$/;
	return reg.test(str);
}

//JS parseFloat求和精度不一致问题解决
function rewrite_add(arg1,arg2){
	var r1=0,r2=0; 
	try{
		r1=arg1.toString().split(".")[1].length;
	}catch(e){}
	try{
		r2=arg2.toString().split(".")[1].length;
	}catch(e){}
	var m=Math.pow(10,Math.max(r1,r2)); 
	return (arg1*m+arg2*m)/m; 
}

//求和
function EXCEL_SUM(){
	var result = 0;
	for(var i=0;i<arguments.length;i++){
		var par = arguments[i];
		if(!isNaN(parseFloat(par))){
			//result += parseFloat(par);
			result = rewrite_add(result,par);
		}
	}
	return result;
}
//求平均数
function EXCEL_AVERAGE(){
	var count = 0;
	var sumVal = 0;
	for(var i=0;i<arguments.length;i++){
		var par = arguments[i];
		if(!isNaN(parseFloat(par))){
			//sumVal += parseFloat(par);
			sumVal = rewrite_add(sumVal,par);
			count++;
		}
	}
	if(count>0){
		return parseFloat(sumVal/count);
	}else{
		throw new Error("EXCEL_AVERAGE divisor is zero");
	}
}
//求绝对值
function EXCEL_ABS(){
	if(arguments.length==1){
		var par = arguments[0];
		if(!isNaN(parseFloat(par))){
			var result = Math.abs(parseFloat(par));
			return result;
		}else{
			throw new Error("EXCEL_ABS arguments value is not a number");
		}
	}else{
		throw new Error("EXCEL_ABS arguments number must equal one");
	}
}
//精度计算
function EXCEL_ROUND(){
	if(arguments.length==2){
		var result = 0;
		var par1 = arguments[0];
		var par2 = arguments[1];
		if(!isNaN(parseFloat(par1))){
			par1 = parseFloat(par1);
		}else{
			throw new Error("EXCEL_ROUND first argument value is not a number");
		}
		if(isInt(par2)){
			par2 = parseInt(par2);
		}else{
			throw new Error("EXCEL_ROUND second argument value is not a int");
		}
		result = par1.toFixed(par2);
		return result;
	}else{
		throw new Error("EXCEL_ROUND arguments number must equal two");
	}
}
//条件判断
function EXCEL_IF(){
	if(arguments.length==3){
		if(eval(arguments[0])){
			return arguments[1];
		}else{
			return arguments[2];
		}
	}else{
		throw new Error("EXCEL_IF arguments number must equal three");
	}
}
//求最大值
function EXCEL_MAX(){
	var result;
	for(var i=0;i<arguments.length;i++){
		var par = arguments[i];
		if(!isNaN(parseFloat(par))){
			if(result==null){
				result = parseFloat(par);
			}else{
				if(parseFloat(par)>result)	
					result = parseFloat(par);
			}
		}
	}
	if(result!=null){
		return result;
	}else{
		throw new Error("EXCEL_MAX arguments value must contain a number");
	}
}
//求最小值
function EXCEL_MIN(){
	var result;
	for(var i=0;i<arguments.length;i++){
		var par = arguments[i];
		if(!isNaN(parseFloat(par))){
			if(result==null){
				result = parseFloat(par);
			}else{
				if(parseFloat(par)<result)	
					result = parseFloat(par);
			}
		}
	}
	if(result!=null){
		return result;
	}else{
		throw new Error("EXCEL_MIN arguments value must contain a number");
	}
}


/*jQuery(document).ready(function(){
	console.log("EXCEL_SUM:"+EXCEL_SUM("1","3.5","9","6.5"));
	console.log("EXCEL_AVERAGE:"+EXCEL_AVERAGE("1","3.5","9","6.5"));
	console.log("EXCEL_ABS:"+EXCEL_ABS("-0.00859"));
	console.log("EXCEL_ROUND:"+EXCEL_ROUND("-0.00859","3"));
	console.log("EXCEL_IF:"+EXCEL_IF("1>10","ETRUE","EFALSE"));
	console.log("EXCEL_MAX:"+EXCEL_MAX("1","3.5","9","6.5"));
	console.log("EXCEL_MIN:"+EXCEL_MIN("1","3.5","9","6.5"));
	console.log("简单嵌套:"+EXCEL_IF("1>0.2+0.9",EXCEL_SUM("1","3.5"),EXCEL_AVERAGE("1","3.5")));
});*/