<?php
// +----------------------------------------------------------------------
// | 每日12更新数据统计缓存 [ WE CAN DO IT JUST THINK IT ]
// +----------------------------------------------------------------------

namespace app\admin\controller;
use app\common\controller\Admin;
use think\Cache;
use think\Controller;

class Dailyupcache extends Controller{


	public function index(){

        $info = $this->orderCoutInfo();
        $a = Cache::store('redis')->set('info-30',$info);
	}

    //订单大数据统计 30天数据展示
    public function orderCoutInfo(){
        $sourceid = 1;
        $agentid = '';
        $wxmpid = '';
        $map = array();
        $nowday= date('Y-m-d');
        $info=array();
        // 30天历史统计列表
        for($i=30;$i>=1;$i--){  
            $date=strtotime($nowday)-(30-$i)*24*3600;
            $map['create_time'] = array(array('gt',$date),array('lt',$date+86399));
            $map['status'] = 1; 
            
            $info[date('Y-m-d',$date)] = array(
                // 充值金额
                "pay"=> db('order')->where('iscontrol',0)->where($map)->sum('money'),
                // 普通充值  
                "paynormal"=> db('order')->where('iscontrol',0)->where($map)->where(array(
                    'type'=>1
                ))->sum('money'),
                    
                "normalnum"=> db('order')->where('iscontrol',0)->where(array_merge($map,array('type'=>1)))->count('uid'),//普通充值人数

                "payvip"=> db('order')->where('iscontrol',0)->where($map)->where(array(
                    'type'=>2
                ))->sum('money'),//年费VIP会员充值金额
                "vipnum"=> db('order')->where('iscontrol',0)->where(array_merge($map,array('type'=>2)))->count(),//充值人数

                "payOffer"=> db('order')->where('iscontrol',0)->where($map)->where(array(
                    'type'=>3
                ))->sum('money'),//活动充值充值金额
                "Offernum"=> db('order')->where('iscontrol',0)->where(array_merge($map,array('type'=>3)))->count(),//活动充值充值人数


                "payPaid"=>$this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,1,1,0,0,$agentid),//普通充值支付订单数
                "payUnpaid"=> $this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,1,0,0,0,$agentid),//未付款

                "payYaerPaid"=>$this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,2,1,0,0,$agentid),//年费VIP会员支付订单数
                "payYaerUnpaid"=> $this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,2,0,0,0,$agentid),//未付款

                "payOfferPaid"=>$this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,3,1,0,0,$agentid),//活动充值支付订单数
                "payOfferUnpaid"=> $this->statistics($wxmpid,$sourceid,'1',0,$date,$date+86399,3,0,0,0,$agentid),//活动充值未付款
            
            );
        }
        return $info;
    }
        /**
      * statistics [充值笔数]
      *
      * @param type $sourceid [来源 1：cps 2：APP]
      * @param type $model [1:小说,2:漫画]
      * @param type $is_kouliang [是否扣量]
      * @param type $startData [开始时间]
      * @param type $endData   [结束时间]
      * @param type $type      [订单类型]
      * @param type $status    [订单状态]
      * @param type $recharge_type      [充值方式 1：直接充值 2：引导充值]
      * @return type
    **/
    protected function statistics($wxmpid,$sourceid,$model='1',$is_kouliang=0,$startData,$endData,$type=0,$status=0,$articleid=0,$recharge_type=0,$agentid=0) {

        if($startData && $endData){
            $map['create_time'] =  array(array('gt',$startData),array('lt',$endData)) ;
        }
        if($sourceid){
            $map['sourceid'] = $sourceid;
        }
        if($type){
            $map['type'] = array('in',$type);
        }

        if($recharge_type){
            $map['recharge_type'] = $recharge_type;
        }
        if($articleid){
            $map['articleid'] = $articleid;
        }
        
        if(strpos($model,",")!==false){
            $map['model'] = array('IN',$model);
        }else{
            $map['model'] = $model;
        }

        if($is_kouliang){
            $map['is_kouliang'] = 1;
        }else{
            $map['is_kouliang'] = 0;
        }
        $map['status'] = $status;

        if($endData<strtotime(date("Y-m-d"))){
            $cachename = 'statistics'.md5(serialize($map));
            $total = db('order')->where('iscontrol',0)->where($map)->count();
        }else{
            $total = db('order')->where('iscontrol',0)->where($map)->count();
        }
        return $total;
    }

    
}