skyversation
/
meidu2021


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
							<%@ 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>
  <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 postTypeArray=[
          {k:"bgs",v:0,name:"办公室",findKey:["bgs-wbygfy","bgs-zyygfy","bgs-rywzfy"]},
          {k:"kf",v:0,name:"客服",findKey:["kf-wbygfy","kf-zyygfy","kf-rywzfy"]},
          {k:"ba",v:0,name:"保安",findKey:["ba-wbygfy","ba-zyygfy","ba-rywzfy"]},
          {k:"bj",v:0,name:"保洁",findKey:["bj-wbygfy","bj-zyygfy","bj-rywzfy"]},
          {k:"gc",v:0,name:"工程",findKey:["gc-wbygfy","gc-zyygfy","gc-rywzfy"]},
          {k:"hw",v:0,name:"会务",findKey:["hw-wbygfy","hw-zyygfy","hw-rywzfy"]},
          {k:"sg",v:0,name:"宿管",findKey:["sg-wbygfy","sg-zyygfy","sg-rywzfy"]},
          {k:"qt",v:0,name:"其他",findKey:["qt-wbygfy","qt-zyygfy","qt-rywzfy"]}
      ]

      loopAll(sheet,function(row,col){
          var cellTag = sheet.getTag(row,col);
          if(!cellTag) return;
          var findKey = cellTag.findKey;
          if(!findKey) return;
          for(var i=0;i<postTypeArray.length;i++){
              var postType = postTypeArray[i];
              var typeFindKey =postType.findKey;
              if($.inArray(findKey,typeFindKey)!=-1){
                  var value = sheet.getValue(row,col);
                  if(value){
                      postType.v = postType.v+parseFloat(value);
                  }
              }
          }
      })
      var option = {
          // color: ["#2f89cf"],
          title: {
              text: '人员费用占比分析',
              subtext: '',
              left: 'center'
          },
          grid: {
              containLabel: true
          },
          tooltip: {
              trigger: "axis",
              axisPointer: {
                  type: 'shadow'
              }
          },
          legend: {
              orient: 'horizontal',
              left: 'left',
              data: []
          },
          xAxis: [
              {
                  'type':'category',
                  'data':[]
              }
          ],
          yAxis: [
              {
                  type: 'value',
                  name: ''
              }
          ],
          series: [
              {
                  name: '',
                  type: 'bar',
                  radius: '55%',
                  center: ['50%', '60%'],
                  data: [],
                  emphasis: {
                      itemStyle: {
                          shadowBlur: 10,
                          shadowOffsetX: 0,
                          shadowColor: 'rgba(0, 0, 0, 0.5)'
                      }
                  }
              },
              {
                  name: '',
                  type: 'pie',
                  center: ['85%', '35%'],
                  radius: '28%',
                  z: 100,
                  tooltip: {
                      trigger: 'item',
                      formatter: '{c} ({d}%)'
                  },
                  legend:{}

              }
          ]
      };

      postTypeArray.sort(function(o1,o2){
          return o2.v-o1.v;
      });
      var xItem = [];
      var xItemData = [];
      var pieItemData=[];
      for(var i=0;i<postTypeArray.length;i++){
          var postType = postTypeArray[i];
          xItem.push(postType.name);
          xItemData.push(postType.v);
          pieItemData.push({value:postType.v,name:postType.name})
      }
      // option.legend.data = xItem;
      option.xAxis[0].data = xItem;
      option.series[0].data = xItemData;
      option.series[1].data = pieItemData;
      var myChart = echarts.init(document.getElementById('e1'));
      setTimeout(function(){
          myChart.setOption(option,true);
          myChart.resize();
      },200);

  })
 </script>