skyversation
/
meidu2021


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
							<%@ 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:100%"></div>
</body>
</html>
 <script type="text/javascript">
  $(function(){
      var spread = top.spread;
      var sheet =spread.getActiveSheet();
      var arr =[];
      var colCount = sheet.getColumnCount();
      loopAllRow(sheet,function(row){
          var wb ,zy,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=='wbygslhj'){
                  var value = sheet.getValue(row,col);
                  wb = value;
              }else if(findKey=='zyygslhj'){
                  var value = sheet.getValue(row,col);
                  zy = value;
              }else if(findKey=='ygslhj'){
                  var value = sheet.getValue(row,col);
                  shichang = value;
              }
              if(cellTag.entityName){
                  entityName = cellTag.entityName;
              }
              if(wb&&zy&&shichang) {
                  break;
              }
          }
          var diff = wb+zy-shichang;
          console.log(wb+','+zy+","+shichang+","+diff);
          if(diff>0){
              arr.push({v:diff.toFixed(2),entityName:entityName});
          }
      });


      var option = getOption('人员数量超额分析');
      arr.sort(function(o1,o2){
          return o2.v-o1.v;
      });
      arr= arr.slice(0,arr.length>30?30:arr.length);
      var xItem = [];
      var xItemData = [];
      for(var i=0;i<arr.length;i++){
          var one = arr[i];
          xItem.push(one.entityName);
          xItemData.push(one.v);
      }
      // option.legend.data = xItem;
      option.xAxis[0].data = xItem;
      option.series[0].data = xItemData;

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

  })
 </script>