echarts 饼图 结合thinkphp 的使用

public function index(){

		//var_dump($res_es);

		$gno = M("auth_group")->count();
		$this->assign('gno',$gno);

		$uno = M("auth_user")->count();
		$this->assign('uno',$uno);




		$ino = M("info")->count();
		$this->assign('ino',$ino);

		$bcno = M("bike_company")->count();
		$this->assign('bcno',$bcno);


		$uid = $_SESSION['auth']['id'];
		//暂时先将超级管理员区别开
		if($uid!=1){


			//非管理员，根据行政级别进行过滤
			//echo "x";

			//根据行政级别，做相应的过滤
			$province = $_SESSION['auth']['province'];
			$city = $_SESSION['auth']['city'];
			$area = $_SESSION['auth']['area'];

			if($_SESSION['auth']['class']=='省级'){
				$sql .= " and province = '$province' ";
				$where["province"] = $_SESSION['auth']['province'];
			}
			if($_SESSION['auth']['class']=='市级'){
				$sql .= " and province = '$province' ";
				$sql .= " and city = '$city' ";
				$where["province"] = $_SESSION['auth']['province'];
				$where["city"] = $_SESSION['auth']['city'];
			}
			if($_SESSION['auth']['class']=='区级'){
				$this->assign('ibno',1);
				$this->assign('uno',1);
				$this->assign('gno',1);

				$sql_area_count = "SELECT COUNT(*) as count FROM dwz_info where area = '$area'";
				$count = M()->query($sql_area_count);
				$this->assign('ino',$count[0]['count']);

				$sql .= " and province = '$province' ";
				$sql .= " and city = '$city' ";
				$sql .= " and area = '$area' ";
				$where["province"] = $_SESSION['auth']['province'];
				$where["city"] = $_SESSION['auth']['city'];
				$where["area"] = $_SESSION['auth']['area'];
			}

			$res_es = $this->getbikes_pca($province,$city,$area);
			$buckets = $res_es['aggregations'][3]['buckets'];

			//var_dump($res_es['hits']['total']);
			foreach($buckets as $k => $v){
				//var_dump($v);
				$arr1[]=$v['key'];
				$temp['name']=$v['key'].'('.$v['doc_count'].')';
				$temp['value']=$v['doc_count'];
				$arr2[]=(object)$temp;
			}

			//var_dump($arr1);
			//var_dump($arr2);
			$str1 = json_encode($arr1);
			$str2 = json_encode($arr2);
			$this->assign('length',$length);
			$this->assign('str1',$str1);
			//var_dump($str2);
			$this->assign('str2',$str2);

			$this->assign('bno',$res_es['hits']['total']);
			$this->display();
		}else{

			$sql_area_count = 'SELECT COUNT(DISTINCT area) as count FROM dwz_info';
			$count = M()->query($sql_area_count);
			$this->assign('ibno',$count[0]['count']);
			//超级管理员暂时去数据库获取
			//echo "xx";

			$data=array();
			//获取每家公司的单车数量
			$list = M("bike_company")->select();
			$this->assign('list1',$list);
			//var_dump($list);
			foreach($list as $k=>$v){
				$nm = $v['title'];
				//var_dump($nm);
				//模糊查询相关的记录情况
				//查询的同时，将当前时刻的数据记录到数据库表
				$arr = explode('|',$v['keyword']);
				//var_dump($arr);
				//echo sizeof($arr);
				$condition = '' ;
				foreach($arr as $k=>$v){
					if($k < sizeof($arr)-1)
					{

						if($v=='ofo'){
							$condition .= " name like '$v' or ";
						}else{
							$condition .= " name like '$v%' or ";
						}

						/*if($v=='' or $v=='NULL' or $v=='null'){
                            $condition .= " name like '' or ";
                        }else{
                            $condition .= " name like '$v%' or ";
                        }*/

					}
					else
					{
						if($v=='ofo'){
							$condition .= " name like '$v' ";
						}else{
							$condition .= " name like '$v%' ";
						}
						/*
                        if($v=='' or $v=='NULL' or $v=='null'){
                            $condition .= " name like '' ";
                        }else{
                            $condition .= " name like '$v%' ";
                        }*/

					}
				}
				//var_dump($condition);
				//$name = $v['title'];
				$sql="select count(*) as numbers ,' $nm ' AS name  from dwz_bike where ".$condition;
				$Model = M();
				$res = $Model->query($sql);
				//var_dump($res);
				$data[]=$res;
			}
			//一定的时间记录一次,做数量变化统计图表


			//var_dump($data);
			$arr1=array();
			$arr2=array();
			$length=sizeof($data);
			$bnoo=0;
			foreach($data as $k => $v){
				//var_dump($v);
				$arr1[]=$v[0]['name'];
				$temp['name']=$v[0]['name'].'('.$v[0]['numbers'].')';
				$temp['value']=$v[0]['numbers'];
				$arr2[]=(object)$temp;
				$bnoo+=$v[0]['numbers'];
			}
			//$arr1[]='其他';

			//$temp['value']=$bno - $bnoo;
			//$temp['name']='其他'.'('.$temp['value'].')';
			//$arr2[]=(object)$temp;
			$bno = 0;
			//var_dump($arr2);
			foreach($arr2 as $k=>$v){
				$bno = $bno + $v->value;
			}
			$this->assign('bno',$bno);

			//var_dump($arr1);
			//var_dump($arr2);
			$str1 = json_encode($arr1);
			$str2 = json_encode($arr2);
			$this->assign('length',$length);
			$this->assign('str1',$str1);
			//var_dump($str2);
			$this->assign('str2',$str2);
			$this->assign('title','首页');
			$this->display();

		}