skyversation
/
meidu2021


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
							<%@ 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 ywArr =[];
      var scArr =[];
      loopAll(sheet,function(row,col){
          var cellTag = sheet.getTag(row,col);
          if(!cellTag) return;
          var findKey = cellTag.findKey;
          if(!findKey) return;
          var value = sheet.getValue(row,col);
          if(value<0){
              if(findKey=='yyf-yewu'){
                  ywArr.push({v:-value,entityName:cellTag.entityName})
              }else if(findKey=='yyf-shichang'){
                  scArr.push({v:-value,entityName:cellTag.entityName})
              }
          }
      })

      var option = getOption('市场配置超额情况');
      var option2=getOption('业务配置超额情况');
      scArr.sort(function(o1,o2){
          return o2.v-o1.v;
      });
      ywArr.sort(function(o1,o2){
          return o2.v-o1.v;
      });
      var xItem = [];
      var xItemData = [];
      for(var i=0;i<scArr.length;i++){
          var one = scArr[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<ywArr.length;i++){
          var one = ywArr[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>