skyversation
/
meidu2021


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
							<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
 <%@include file="/context/mytags.jsp"%>
 <t:base type="jquery"></t:base>
 <script src="plug-in/echarts/echarts.js" type="text/javascript"></script>
 <script src="webpage/cn/com/lzt/budget/data/js/budget_tools.js" type="text/javascript"></script>
 <script src="webpage/cn/com/lzt/budget/costbreakdown/statis.js" type="text/javascript"></script>
 <link rel="stylesheet" type="text/css" href="webpage/cn/com/lzt/budget/costbreakdown/statis.css">

</head>
<body>
<div id="e1" style="width:100%;height:50%"></div>
<div id="e2"  style="width:100%;height:50%"></div>
</body>
</html>
<script type="text/javascript">
    $(function(){
        var spread = top.spread;
        var sheet =spread.getActiveSheet();
        var moreArr =[];
        var lessArr =[];
        var colCount = sheet.getColumnCount();
        loopAllRow(sheet,function(row){
            var yewu ,shichang,entityName;
            for(var col=colCount-1;col>=0;col--){
                var cellTag = sheet.getTag(row,col);
                if(!cellTag) continue;
                var findKey = cellTag.findKey;
                if(!findKey) continue;
                if(findKey=='yyf-yewu'){
                    var value = sheet.getValue(row,col);
                    yewu = value;
                }else if(findKey=='yyf-shichang'){
                    var value = sheet.getValue(row,col);
                    shichang = value;
                }
                if(cellTag.entityName){
                    entityName = cellTag.entityName;
                }
                if(yewu&&shichang) {
                    break;
                }
            }
            var diff = yewu-shichang;
            if(diff>0){
                moreArr.push({v:diff.toFixed(2),entityName:entityName});
            }else if(diff<0){
                lessArr.push({v:diff.toFixed(2),entityName:entityName});
            }
        });

        var option = getOption('低于预期盈利分析');
        var option2=getOption('高于预期盈利分析');
        moreArr.sort(function(o1,o2){
            return o2.v-o1.v;
        });
        lessArr.sort(function(o1,o2){
            return o1.v-o2.v;
        });
        var xItem = [];
        var xItemData = [];
        for(var i=0;i<lessArr.length;i++){
            var one = lessArr[i];
            xItem.push(one.entityName);
            xItemData.push(one.v);
        }
        // option.legend.data = xItem;
        option.xAxis[0].data = xItem;
        option.series[0].data = xItemData;

        var xItem2 = [];
        var xItemData2 = [];
        for(var i=0;i<moreArr.length;i++){
            var one = moreArr[i];
            xItem2.push(one.entityName);
            xItemData2.push(one.v);
        }
        // option.legend.data = xItem;
        option2.xAxis[0].data = xItem2;
        option2.series[0].data = xItemData2;

        var myChart = echarts.init(document.getElementById('e1'));
        var myChart2 = echarts.init(document.getElementById('e2'));
        setTimeout(function(){
            myChart.setOption(option,true);
            myChart.resize();
            myChart2.setOption(option2,true);
            myChart2.resize();
        },200);

    })
</script>