cxinv/app/admin/controller/Stat.php

<?php


namespace app\admin\controller;
use app\BaseController;
use think\App;
use think\facade\Cache;use think\facade\Db;

class Stat extends BaseController{
	public function __construct(App $app) {parent::__construct($app);}

	public function stats(){
		 $data=Cache::get("statContent");

		 return app_show(0,"获取成功",$data);
	}

	public function depart(){
		 $data=Cache::get("departContent");
		 return app_show(0,"获取成功",$data);
	}
	public function total(){
		$list =Db::name("total_tips")->where("year",date("Y"))->column("depart_id,depart_ment,tips,month,year,total,th_total,profit,rate,prate");
		$data=[
			[
				"depart_ment"=>'总计',
				"content"=>[
					1=>["tips"=>0,"month"=>1,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					2=>["tips"=>0,"month"=>2,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					3=>["tips"=>0,"month"=>3,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					4=>["tips"=>0,"month"=>4,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					5=>["tips"=>0,"month"=>5,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					6=>["tips"=>0,"month"=>6,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					7=>["tips"=>0,"month"=>7,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					8=>["tips"=>0,"month"=>8,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					9=>["tips"=>0,"month"=>9,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					10=>["tips"=>0,"month"=>10,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					11=>["tips"=>0,"month"=>11,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],
					12=>["tips"=>0,"month"=>12,"year"=>date("Y"),"total"=>0,"th_total"=>0,"profit"=>0,"rate"=>0,"prate"=>0],

				]
			]
		];
		foreach ($list as $value){
			$temp=["tips"=>$value['tips'],"month"=>$value['month'],"year"=>date("Y"),"total"=>$value['total'],"th_total"=>$value['th_total'],"profit"=>$value['profit'],"rate"=>$value['rate'],"prate"=>$value['prate']];
			$data[0]['content'][$value['month']]["tips"]+=$value['tips'];
			$data[0]['content'][$value['month']]["total"]+=$value['total'];
			$data[0]['content'][$value['month']]["th_total"]+=$value['th_total'];
			$data[0]['content'][$value['month']]["profit"]=$data[0]['content'][$value['month']]["total"] - $data[0]['content'][$value['month']]["th_total"];
			$data[0]['content'][$value['month']]["rate"]=round($data[0]['content'][$value['month']]["total"]/$data[0]['content'][$value['month']]["tips"] *100,2);
			$data[0]['content'][$value['month']]["prate"]=round($data[0]['content'][$value['month']]["profit"]/$data[0]['content'][$value['month']]["tips"] *100,2);
			if (isset($data[$value['depart_id']])){
				$data[$value['depart_id']]['content'][$value['month']]= $temp;
			}else{
				$data[$value['depart_id']]["depart_ment"]=$value['depart_ment'];
				$data[$value['depart_id']]['content'][$value['month']]= $temp;
			}
		}
		return app_show(0,"获取成功",$data);
	}
}