<?php

namespace Admin\Controller;

use Think\Controller;

class AdmincrontabController extends Controller
{
    //后台定时任务
    /**
     * 版本：
     * 新增/更新：
     * 简述：更新后台新增和所有用户的活跃
     * @param  $templateid []
     * @return $type    消息类型
     */
    public function all_huoyue_renshu_shuju()
    {
        set_time_limit(0);
        ini_set('memory_limit', '1500M');
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //今日时间
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;
        //昨日时间
        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;
        $todayTimestamp = time(); // 获取当前时间戳
        //三日时间
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳

        //周时间
        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();
        //月时间
        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();
        //用户新增
        $user_info_list = M('user_info');
        $arr['jinri'] = $user_info_list->where("add_time BETWEEN $jinri_start_time  and $jinri_end_time  ")->count();
        $arr['zuori'] = $user_info_list->where("add_time BETWEEN $zuo_start_time  and  $zuo_end_time  ")->count();
        $arr['sanri'] = $user_info_list->where("add_time BETWEEN $san_start_time  and  $san_end_time  ")->count();
        $arr['zhou'] = $user_info_list->where("add_time BETWEEN $zhou_start_time  and $zhou_end_time  ")->count();
        $arr['yue'] = $user_info_list->where("add_time BETWEEN  $yue_start_time and $yue_end_time  ")->count();
        $arr['jilei'] = $user_info_list->where("id>0  ")->count();

        //独立
        $arr_cs['jinri'] = $user_info_list->where("add_time BETWEEN $jinri_start_time  and $jinri_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();
        $arr_cs['zuori'] = $user_info_list->where("add_time BETWEEN $zuo_start_time  and  $zuo_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();
        $arr_cs['sanri'] = $user_info_list->where("add_time BETWEEN $san_start_time  and  $san_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();
        $arr_cs['zhou'] = $user_info_list->where("add_time BETWEEN $zhou_start_time  and $zhou_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();
        $arr_cs['yue'] = $user_info_list->where("add_time BETWEEN  $yue_start_time and $yue_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();
        $arr_cs['jilei'] = $user_info_list->where("id>0 and add_url  = 'https://c2.9169kkxstzsjkyy333.app/register.html' ")->count();

        //所有用户活跃
        $huoyue_jin = M("huoyue_list")->where("time>$jinri_start_time")->field("uid")->group("uid")->select();
        $huoyue_zuo = M("huoyue_list")->where("time BETWEEN $zuo_start_time  and  $zuo_end_time ")->field("uid")->group("uid")->select();
        $huoyue_san = M("huoyue_list")->where("time BETWEEN $san_start_time  and  $san_end_time  ")->field("uid")->group("uid")->select();;
        $huoyue_zhou = M("huoyue_list")->where(" time BETWEEN $zhou_start_time  and $zhou_end_time ")->field("uid")->group("uid")->select();
        $huoyue_yue = M("huoyue_list")->where(" time BETWEEN  $yue_start_time and $yue_end_time")->field("uid")->group("uid")->select();
        $huoyue_jilei = $user_info_list->field("id")->count();


        $arrs['jinri'] = count($huoyue_jin);
        $arrs['zuori'] = count($huoyue_zuo);
        $arrs['sanri'] = count($huoyue_san);
        $arrs['zhou'] = count($huoyue_zhou);
        $arrs['yue'] = count($huoyue_yue);
        $arrs['jilei'] = $huoyue_jilei;
//        $arrs['zuori'] ='维护中';
//        $arrs['sanri'] = '维护中';
//        $arrs['zhou'] ='维护中';
//        $arrs['yue'] ='维护中';
//        $arrs['jilei'] ='维护中';
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arr['time'] = $time_chuo;
        $arr['date'] = $time_data;
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        $arr_cs['time'] = $time_chuo;
        $arr_cs['date'] = $time_data;
        M("admin_shuju_list")->where("title ='全部新增'")->save($arr);
        M("admin_shuju_list")->where("title ='独立测试新增人数'")->save($arr_cs);
        M("admin_shuju_list")->where("title ='全部活跃'")->save($arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        $data['data'] = $arrs;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：免费用户的活跃状况
     * @param  $templateid []
     * @return $type    消息类型
     */
    public function free_huoyue_renshu_shuju()
    {
        set_time_limit(0);
        ini_set('memory_limit', '1500M');
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;


        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();
        $vip_user = M("user_info")->where("vip_money=''")->getField("id", true);
//        $last_id = array_map(function($element) {
//            return $element['id'];
//        }, $vip_user);
//        dump($last_id);die;
//        $str = json_encode($last_id);
//        $str = substr($str, 1, -1);
        $huoyue = M("huoyue_list");
//        $huoyue_jin = M("huoyue_list")->where("uid in($str) and time BETWEEN $jinri_start_time  and $jinri_end_time  ")->field("uid")->group("uid")->select();
        $now_time = time();
        $where_uid['uid'] = array("in", $vip_user);
        $huoyue_jin = M("huoyue_list")->where($where_uid)->where("time>$jinri_start_time")->field("uid")->group("uid")->select();
//        echo PHP_EOL.M("user_info")->_sql();
        $huoyue_zuo = M("huoyue_list")->where($where_uid)->where("time BETWEEN $zuo_start_time  and  $zuo_end_time ")->field("uid")->group("uid")->select();
        $huoyue_san = M("huoyue_list")->where($where_uid)->where("time BETWEEN $san_start_time  and  $san_end_time  ")->field("uid")->group("uid")->select();;
        $huoyue_zhou = M("huoyue_list")->where($where_uid)->where("time BETWEEN $zhou_start_time  and $zhou_end_time ")->field("uid")->group("uid")->select();
        $huoyue_yue = M("huoyue_list")->where($where_uid)->where("time BETWEEN  $yue_start_time and $yue_end_time")->field("uid")->group("uid")->select();
        $huoyue_jilei = M("user_info")->where("last_login_time is not null and vip_money=''")->field("id")->select();

        $arrs['jinri'] = count($huoyue_jin);
        $arrs['zuori'] = count($huoyue_zuo);
        $arrs['sanri'] = count($huoyue_san);
        $arrs['zhou'] = count($huoyue_zhou);
        $arrs['yue'] = count($huoyue_yue);
        $arrs['jilei'] = count($huoyue_jilei);
//        $arrs['zuori'] ='维护中';
//        $arrs['sanri'] = '维护中';
//        $arrs['zhou'] ='维护中';
//        $arrs['yue'] ='维护中';
//        $arrs['jilei'] ='维护中';
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        M("admin_shuju_list")->where("title ='免费活跃'")->save($arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        $data['data'] = $arrs;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：统计sw9169
     * @param  $templateid []
     * @return $type    消息类型
     */
    public function all_tong_ji_sw9169()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $url = $_POST['url'];
        $arr["url"]= $url;
        $arr["time"]= $time_data;
        $ret = M("tongji_url")->add($arr);
        if ($ret) {
            $data['code'] = '200';
            $data['msg'] = '请求成功';
            echo json_encode($data);
        } else {
            $data['code'] = '201';
            $data['msg'] = '请求失败';
            echo json_encode($data);
        }
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：付费用户的活跃状况
     * @param  $templateid []
     * @return $type    消息类型
     */
    public function vip_huoyue_renshu_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //全部活跃
        $total_huoyue = M("admin_shuju_list")->where("title='全部活跃'")->find();
        //免费活跃
        $free_huoyue = M("admin_shuju_list")->where("title='免费活跃'")->find();
        $jinri = $total_huoyue['jinri'] - $free_huoyue['jinri'];
        if ($jinri < 0) {
            $arrs['jinri'] = "0";
        } else {
            $arrs['jinri'] = $jinri;
        }
        $arrs['zuori'] = $total_huoyue['zuori'] - $free_huoyue['zuori'];
        $arrs['sanri'] = $total_huoyue['sanri'] - $free_huoyue['sanri'];
        $arrs['zhou'] = $total_huoyue['zhou'] - $free_huoyue['zhou'];
        $arrs['yue'] = $total_huoyue['yue'] - $free_huoyue['yue'];
        $arrs['jilei'] = $total_huoyue['jilei'] - $free_huoyue['jilei'];
//        $arrs['zuori'] ='维护中';
//        $arrs['sanri'] = '维护中';
//        $arrs['zhou'] ='维护中';
//        $arrs['yue'] ='维护中';
//        $arrs['jilei'] ='维护中';

        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        M("admin_shuju_list")->where("title ='付费活跃'")->save($arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        $data['data'] = $arrs;
        echo json_encode($data);
    }


    /**
     *
     * 添加开奖
     * @return void
     */
    public function add_bet_qishu()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        $current_qi = M("game_bet_qishu")->field("id,bet_jie_zhi,bet_result,bet_time,bet_jiang_rd")->where("bet_hit = 0 ")->find(); //当前期
        if (empty($current_qi)) {
            //插入新的一期
            $this->add_new_qi();
            return;
        }

        //未到开奖时间
        if (strtotime($current_qi['bet_time']) > time()) {
            //未到开奖时间
            return;
        }

        //开奖
        $old['bet_hit'] = 2;
        M("game_bet_qishu")->where("bet_hit = 1")->save($old); //上期改为往期

        $jiang = rand(1, 100);//投注类型1老虎，2熊猫、3猴子rand(1, 100)
        $pei_lv = 1.8;//默认未猴子
        if ($jiang <= 5) {
            $jiang = 1;
            $pei_lv = 8;
        } elseif ($jiang > 5 && $jiang <= 50) {
            $jiang = 2;
            $pei_lv = 1.9;
        } elseif ($jiang > 50 && $jiang <= 100) {
            $jiang = 3;
            $pei_lv = 1.8;
        }

        $qishu_id = $current_qi['id'];//$current_qi['id'];
        $updata_info['bet_result'] = $jiang;//开奖
        $updata_info['bet_hit'] = 1;//当前期数0/1上期/2往期z
        $qishu_count = M("game_bet_qishu_count")->field("id,qishu_id,touzhu_renshu,touzhu_leixing_coins")->where("qishu_id = '$qishu_id'  AND touzhu_leixing = '$jiang' ")->find();
        if (!empty($qishu_count)) {
            //真实中奖人数和派发金额
            $updata_info['bet_zhong_jian'] = $qishu_count['touzhu_leixing_coins'] * $pei_lv; //真实派发金额
            $updata_info['bet_jiang'] = $qishu_count['touzhu_renshu'];  //真实中奖人数
        }
        //随机人数和派奖金额
        $r_shu = M("admin_shuju_list")->field("jinri")->where("title ='在线人数'")->find();
        if($r_shu["jinri"] == 0){
            $r_shu["jinri"]=1;
        }
        $b = rand(15, 20) / 100;//100
        $c1 = 0;
        if ($jiang == 1) {
            $c1 = ceil($r_shu["jinri"] * $b) / 5;
        } else{
            $c1 = ceil($r_shu["jinri"] * $b);
        }
        $c2 = $c1 * 60 *  $pei_lv;
        if ($c2 > $updata_info['bet_zhong_jian'] ) {
            $updata_info['bet_zhong_jian_rd'] = $c2; //真实派发金额
        }else{
            $updata_info['bet_zhong_jian_rd'] = $updata_info['bet_zhong_jian'];
        }
        $c11 = ceil($c1);
        $updata_info['bet_jiang_rd'] = $c11;
        $rs = M("game_bet_qishu")->where("id='$qishu_id'")->save($updata_info);

        $this->add_new_qi(); //补全新第一期
        //删除统计表
        M("game_bet_qishu_count")->where("qishu_id='$qishu_id'")->delete();

        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = $rs;
        echo json_encode($data);
    }


    /**
     *
     * 添加数字100开奖
     * @return void
     */
    public function add_bet_100()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        $current_qi = M("game_luck_100_qishu")->field("id,bet_time,bet_result,bet_jie_zhi,bet_amount")->where("bet_hit = 0 ")->find(); //当前期
        if (empty($current_qi)) {
            //插入新的一期
            $this->add_new_qi_100();
            return;
        }

        //未到开奖时间
        if (strtotime($current_qi['bet_time']) > time()) {
            //未到开奖时间
            return;
        }

        //开奖
        $old['bet_hit'] = 2;
        M("game_luck_100_qishu")->where("bet_hit = 1")->save($old); //上期改为往期
        $A1 = 0;
        for($i=0; $i <=10000 ; $i++) {
            $A1++;
            $A = rand(0, 9) ;//0-9
            $B = rand(0, 9);//0-9
            $C = rand(0, 9);//0-9
            $D = rand(0, 9);//0-9
            $qishu_id =$current_qi['id'];//$current_qi['id'];
            $jiang = M("game_luck_100_touzhu")->field("id")->where("qishu_id = {$qishu_id} and tz_luck_number = '$A.$B.$C.$D' ")->find(); //查询没有的中奖号码
            if(empty($jiang)){

                $updata_info['bet_result'] = $A.$B.$C.$D;;//开奖
                $updata_info['bet_hit'] = 1;//当前期数0/1上期/2往期z
                M("game_luck_100_qishu")->where("id='$qishu_id'")->save($updata_info);
                $this->add_new_qi_100(); //补全新第一期
                return;
            }
        }
//        if($A1 == 10000){
//            $updata_info['bet_result'] = $A.$B.$C.$D;;//开奖
//            $updata_info['bet_hit'] = 1;//当前期数0/1上期/2往期z
//            M("game_luck_100_qishu")->where("id='$qishu_id'")->save($updata_info);
//            $this->add_new_qi_100(); //补全新第一期
//            return;
//        }

        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '1';
        echo json_encode($data);
    }
    private
    function add_new_qi()
    {
        $date_i = date("i");
        if ($date_i < 5) {
            $date_i = "5";
            $datetime = strtotime(date("Y-m-d" . " H:" . $date_i . ":00", time()));
            //$nextHalfHour = $datetime - 300 ;// 300秒 = 5分钟
        } else if ($date_i / 5 >= 1) {
            $date_i = intval($date_i / 5) * 5;
            // $date_i = $date_i+10;
            $datetime = strtotime(date("Y-m-d" . " H:" . $date_i . ":00", time())) + 300; //1800
        }

        $new_qi['bet_jie_zhi'] = date('Y-m-d H:i:s', $datetime - 30);  //截止时间时间
        $new_qi['bet_hit'] = 0;  //当前期数0/1上期/2往期
        $new_qi['bet_time'] = date('Y-m-d H:i:s', $datetime);  //开奖时间
         M("game_bet_qishu")->add($new_qi);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：
     * @param  $templateid  []
     * @return $type    消息类型
     */
    public function select_zuori_rshu(){
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
            $current_qi = M("game_luck_100_qishu")->field("id,touzhu_renshu,bet_amount")->where("bet_hit = 0 ")->find(); //当前期
            $r_shu = M("admin_shuju_list")->field("zuori")->where("id = 2 ")->find();
            $count_r_shu = $r_shu["zuori"];
            $count =  intval($count_r_shu/10) ;///  $r_shu["zuori"] 10 intval( $str)
            if($current_qi["touzhu_renshu"]<= $count  ){
                $id = $current_qi["id"];
                $A = rand(3, 9);
                $new_r_shu = $current_qi["touzhu_renshu"] + $A;
                $jin = $A * 2;

                $updata_info['touzhu_renshu'] = $new_r_shu ;
                $updata_info['bet_amount'] = $current_qi["bet_amount"] + $jin;
                M("game_luck_100_qishu")->where("id='$id'")->save($updata_info);
            }

            $data['code'] = '200';
            $data['status'] = '1';
            $data['message'] = 'ok';
            $data['data'] =null;
            echo json_encode($data);

    }


    /**
     * 版本：
     * 查询随机免费10
     * 简述：
     * @param  $templateid  []
     * @return $type    消息类型
     */
    public function select_mian_fei_10(){
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
            $current_qi = M("video_list_test")->field("id")->where("uploader not in('顶臀街射','素人反差','粉嫩少女','另类猎奇','漫画','色情小说','雪白美乳','极品色图','成人动漫','有声小说','吃瓜') ")->order("rand()")->limit(10)->select();; //当前期
            $next_time= date('Y-m-'."01",strtotime('next month'));
            if($current_qi){
                M("video_mian_10")->where("id>=1")->delete();
                foreach ($current_qi as $k=>$v){
                    $new_qi["vid"] =  $v["id"];
                    $new_qi["time"] = $next_time;
                    M("video_mian_10")->add($new_qi);
                }
            }
            $data['code'] = '200';
            $data['status'] = '1';
            $data['message'] = 'ok';
            $data['data'] ="请求成功";
            echo json_encode($data);

    }
    private
    function add_new_qi_100()
    {
        $ref = M("game_luck_100_qishu")->field("bet_time,bet_zhong_jian,bet_amount,bet_hit")->where("bet_hit = 1 ")->find(); //当前期
        if( strtotime(($ref['bet_time'])) <= strtotime(date('Y-m-d H:i:s', time()))) {
            $date_i = date("H");
            if ($date_i <= 22 ) {
                $date_i = 22;
                $datetime = strtotime(date("Y-m-d" . $date_i . ":00" . ":00", time())) + 86400; //加一天
                $new_qi['bet_jie_zhi'] = date('Y-m-d H:i:s', $datetime - 180);  //截止时间时间
                $new_qi['bet_hit'] = 0;  //当前期数0/1上期/2往期
                //$new_qi['bet_amount'] = 100000;  //初始金额
                $new_qi['bet_time'] = date('Y-m-d H:i:s', $datetime);  //开奖时间
                if($ref){
                    $bet_zhong_jian = $ref["bet_zhong_jian"];
                    $bet_amount = $ref["bet_amount"];
                    if($bet_zhong_jian == 0){
                        $new_qi['bet_amount'] = $ref["bet_amount"];
                    }else{
                        $new_qi['bet_amount'] = 100000;
                    }
//                    if($bet_zhong_jian > 0){
//
//                    }
                }
                M("game_luck_100_qishu")->add($new_qi);
            }
        }
//        $date_i = date("i");
//        if ($date_i < 5) {
//            $date_i = "5";
//            $datetime = strtotime(date("Y-m-d" . " H:" . $date_i . ":00", time()));
//            //$nextHalfHour = $datetime - 300 ;// 300秒 = 5分钟
//        } else if ($date_i / 5 >= 1) {
//            $date_i = intval($date_i / 5) * 5;
//            // $date_i = $date_i+10;
//            $datetime = strtotime(date("Y-m-d" . " H:" . $date_i . ":00", time())) + 300; //1800
//        }
//                 $new_qi['bet_jie_zhi'] = date('Y-m-d H:i:s', $datetime - 180);  //截止时间时间
//                $new_qi['bet_hit'] = 0;  //当前期数0/1上期/2往期
//                $new_qi['bet_time'] = date('Y-m-d H:i:s', $datetime);  //开奖时间
//                $bet_zhong_jian = $ref["bet_zhong_jian"];
//                if($bet_zhong_jian == 0){
//                    $new_qi['bet_amount'] = $ref["bet_amount"];
//                }
//                M("game_luck_100_qishu")->add($new_qi);

    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：游戏100开奖后回写
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function add_luck_100_hui_dia()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $refs = M("game_luck_100_qishu")->field("id,bet_result,bet_time,bet_amount,bet_zhong_jian")->where("bet_hit = 1 ")->find(); //把上期中奖数据回写
        if( strtotime(($refs['bet_time'])) <= strtotime(date('Y-m-d H:i:s', time()))) {

            //今日
            $todaytime = strtotime(date("Y-m-d", time()) . "00:00:00");
            $todaytime1 = strtotime(date("Y-m-d", time()) . "23:59:59");

            $qid = $refs["id"];
            $tz_luck_number = $refs["bet_result"];
            $bet_amount= $refs["bet_amount"];
            $bet_zhong_jian= $refs["bet_zhong_jian"];
            $bet_time= $refs["bet_time"];

            $shu = M("game_luck_100_touzhu")->field("id,uid,qishu_id,tz_luck_number,tz_jin,tz_yingli")->where("qishu_id = {$qid} and tz_luck_number != $tz_luck_number and shu_ying =  0 ")->select(); //查询未中奖
            if ($shu) {
                foreach ($shu as $k => $v) {

                    $zhong_jiang['shu_ying'] = 2; //输
                    $zhong_jiang['tz_yingli'] = -$v['tz_jin'];
                    M("game_luck_100_touzhu")->where("qishu_id = {$qid} ")->save($zhong_jiang); //未中奖

                    $uid = $v['uid'];
                    $arr1['tz_shu'] = $v['tz_jin'];
                    M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $todaytime and $todaytime1 and uid=$uid and game_type = 1 ")->save($arr1);

                }
            }
            $zhong= M("user_info")->field("id,name")->where("user_type = 1 and kai_jiang = 1")->select(); //新增一条内部中奖记录
            $zhong_count= M("user_info")->field("id,name")->where("user_type = 1 and kai_jiang = 1")->count();; //新增一条内部中奖记录

            if(!$bet_zhong_jian){
                if($zhong){
                    foreach ($zhong as $k => $v) {

                        $id = $v["id"];
                        $zhong_jiang['shu_ying'] = 1; //赢
                        $zhong_jiang['tz_yingli'] = $bet_amount * 0.8/$zhong_count;
                        $zhong_jiang['uid'] = $id;
                        $zhong_jiang['tz_luck_number'] = $tz_luck_number;
                        $zhong_jiang['tz_jin'] = 2;
                        $zhong_jiang['qishu_id'] = $qid;
                        $zhong_jiang['tz_time'] = $bet_time;
                        $zhong_jiang1 = M("game_luck_100_touzhu")->field("id")->where("qishu_id = {$qid} and uid = $id")->find();
                        M("game_luck_100_touzhu")->where("id = {$zhong_jiang1["id"]}")->save($zhong_jiang); //中奖

                        $arr1['bet_zhong_jian'] = $bet_amount * 0.8/$zhong_count;
                        M("game_luck_100_qishu")->where("id = {$qid}")->save($arr1); //中奖

                        $arr2['kai_jiang'] = 0;
                        M("user_info")->where("id = {$id}")->save($arr2); //清空中奖状态
                    }
                }
            }


        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：新增内部账号
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function add_user_nei_bu()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        for ($i=0; $i <=50 ; $i++) {
            $chars = range('a', 'z'); //生成小写字母数组
            $A = rand(0, 9) ;//0-9
            $B = rand(0, 9);//0-9
            $C = rand(0, 9);//0-9
            $D = rand(0, 9);//0-9
            shuffle($chars); //随机打乱数组元素
            $rand_str = implode(array_slice($chars, 0, 4));
            $ref = M("user_info")->field("name")->where("name = '$A.$B.$C.$D.$rand_str' ")->find(); //当前期
            if($ref){
            }else{
                $user_info['name'] = $A.$B.$C.$D.$rand_str;
                $user_info['password'] = 919611;
                $user_info['add_time'] = time();
                $user_info['balance'] = 0;
                $user_info['ip_address'] = '海南三亚';
                $user_info['user_type'] = 1;
                M("user_info")->add($user_info);
            }
        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        echo json_encode($data);
    }
    /**
     * 版本：
     * 新增/更新：
     * 简述：游戏开奖后回写
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function add_bet_qishu_huidiao()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $refs = M("game_bet_qishu")->field("id,bet_result,bet_time,bet_jiang_rd")->where("bet_hit = 1 ")->select(); //把上期中奖数据回写
        if ($refs) {
            if (strtotime($refs[0]["bet_time"]) - 5 <= strtotime(date('Y-m-d H:i:s', time()))) { //整点开奖

                $qid = $refs[0]["id"];
                $tou_type = $refs[0]['bet_result']; //开奖结果
                $zhong = M("game_bet_touzhu")->field("id,uid,qishu_id,touzhu_jin")->where("qishu_id = {$qid} and touzhu_type = $tou_type and shu_ying is  null ")->select(); //查询中奖
                $arrayUidTx = [1, 2, 3, 4, 5]; //每期开奖后控制用户提现‘额度

                //今日
                $todaytime = strtotime(date("Y-m-d", time()) . "00:00:00");
                $todaytime1 = strtotime(date("Y-m-d", time()) . "23:59:59");

                if ($zhong) {//开奖兑奖
                    foreach ($zhong as $k => $v) { //投注类型1老虎，2熊猫、3猴子

                        if (!in_array($v['uid'], $arrayUidTx)) {
                            array_push($arrayUidTx, $v['uid']);
                        }//添加需要控制的用户

                        if ($tou_type == 1) {  //老虎
                            $uid = $v['id'];
                            $zhong_jiang['shu_ying'] = 1; //赢
                            $zhong_jiang['yingli'] = $v['touzhu_jin'] * 8;
                            M("game_bet_touzhu")->where("id = {$uid} ")->save($zhong_jiang); //中奖

                            $usr_uid = $v['uid'];
                            M("user_info")->where("id = {$usr_uid} ")->setInc("gold_coins_number", $zhong_jiang['yingli']);; //中奖

                            $arr1['tz_yingli'] = $v['touzhu_jin'] * 8;
                            M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $todaytime and $todaytime1 and uid=$usr_uid and game_type = 0")->save($arr1);
                        } elseif ($tou_type == 2) { //熊猫
                            $uid = $v['id'];
                            $zhong_jiang['shu_ying'] = 1; //赢
                            $zhong_jiang['yingli'] = $v['touzhu_jin'] * 1.9;
                            M("game_bet_touzhu")->where("id = {$uid} ")->save($zhong_jiang); //中奖

                            $usr_uid = $v['uid'];
                            M("user_info")->where("id = {$usr_uid} ")->setInc("gold_coins_number", $zhong_jiang['yingli']);; //中奖

                            $arr1['tz_yingli'] =  $v['touzhu_jin'] * 1.9;
                            M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $todaytime and $todaytime1 and uid=$usr_uid and game_type = 0")->save($arr1);
                        } elseif ($tou_type == 3) { //3猴子
                            $uid = $v['id'];
                            $zhong_jiang['shu_ying'] = 1; //赢
                            $zhong_jiang['yingli'] = $v['touzhu_jin'] * 1.8;
                            M("game_bet_touzhu")->where("id = {$uid} ")->save($zhong_jiang); //中奖

                            $usr_uid = $v['uid'];
                            M("user_info")->where("id = {$usr_uid} ")->setInc("gold_coins_number", $zhong_jiang['yingli']);; //中奖

                            $arr1['tz_yingli'] = $v['touzhu_jin'] * 1.8;
                            M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $todaytime and $todaytime1 and uid=$usr_uid and game_type = 0 ")->save($arr1);
                        }

                    }

                }
                $shu = M("game_bet_touzhu")->field("id,uid,touzhu_jin")->where("qishu_id = {$qid} and touzhu_type != $tou_type and shu_ying is  null ")->select(); //查询未中奖
                if ($shu) {
                    foreach ($shu as $k => $v) {

                        if (!in_array($v['uid'], $arrayUidTx)) {
                            array_push($arrayUidTx, $v['uid']);
                        }//添加需要控制的用户

                        $uid = $v['id'];
                        $zhong_jiang['shu_ying'] = 2; //输
                        $zhong_jiang['yingli'] = -$v['touzhu_jin'];
                        M("game_bet_touzhu")->where("id = {$uid} ")->save($zhong_jiang); //未中奖

                        $arr1['tz_shu'] = $v['touzhu_jin'];
                        M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $todaytime and $todaytime1 and uid=$uid  and game_type = 0")->save($arr1);
                    }
                }
                //调用用户提现控制
                foreach ($arrayUidTx as $key => $value) {
                    $this->kai_jiang($value, $qid);
                }

            }

        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        echo json_encode($data);
    }

    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖详情期数
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function bet_qishu_details()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $arr = M("game_bet_qishu")->field("id,bet_time,bet_result,bet_amount")->page($page, $size)->order("bet_time desc")->select();
            $count = M("game_bet_qishu")->count();
            if ($arr) {//开奖兑奖
                foreach ($arr as $k => $v) {
                    $uid = $v['id'];
                    $arr[$k]['ying_sum'] = M("game_bet_touzhu")->where("qishu_id=$uid and shu_ying = 1")->count();; //统计赢订单数
                    $arr[$k]['yingli_sum'] = $v['bet_amount'] - M("game_bet_touzhu")->where("qishu_id=$uid and shu_ying = 1")->sum('yingli');; //统计赢金额
                    $arr[$k]['shu_sum'] = M("game_bet_touzhu")->where("qishu_id=$uid and shu_ying = 2")->count();; //统计订单数
                    $arr[$k]['he_sum'] = M("game_bet_touzhu")->where("qishu_id=$uid ")->count();; //合计订单数
                }
                $data['code'] = '200';
                $data['msg'] = '请求成功';
                $data['count'] = $count;
                $data['data'] = $arr;
                echo json_encode($data);
            }
        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖游戏100详情期数
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function luck_100_qishu_details()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $arr = M("game_luck_100_qishu")->page($page, $size)->order("bet_time desc")->select();
            $count = M("game_luck_100_qishu")->count();
            if ($arr) {//开奖兑奖
                foreach ($arr as $k => $v) {
                    $uid = $v['id'];
                    $arr[$k]['ying_sum'] = M("game_luck_100_touzhu")->where("qishu_id=$uid and shu_ying = 1")->count();; //统计赢订单数
                    $arr[$k]['yingli_sum'] = $v['bet_amount'] - M("game_luck_100_touzhu")->where("qishu_id=$uid and shu_ying = 1")->sum('tz_yingli');; //统计赢金额
                    $arr[$k]['shu_sum'] = M("game_luck_100_touzhu")->where("qishu_id=$uid and shu_ying = 2")->count();; //统计订单数
                    $arr[$k]['he_sum'] = M("game_luck_100_touzhu")->where("qishu_id=$uid ")->count();; //合计订单数
                    $tz = M("game_luck_100_touzhu")->field("tz_jin")->where("qishu_id=$uid ")->find();; //投注金额
                    $arr[$k]['tz_jin'] =  $tz['tz_jin'] ;

                }
                $data['code'] = '200';
                $data['msg'] = '请求成功';
                $data['count'] = $count;
                $data['data'] = $arr;
                echo json_encode($data);
            }
        } else {
            echo $this->returnData();
        }
    }
    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖详情期数结果
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function bet_qi_shu_jie_guo()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $arr = M("game_bet_qishu")->field("bet_result")->page($page, $size)->order("bet_time desc")->select();
            //$count = M("game_bet_qishu")->count();
            $data['code'] = '200';
            $data['msg'] = '请求成功';
            // $data['count'] = $count;
            $data['data'] = $arr;
            echo json_encode($data);
        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：快乐100开奖详情期数结果
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function luck_100_jie_guo()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $arr = M("game_luck_100_qishu")->field("bet_result")->page($page, $size)->order("bet_time desc")->select();
            //$count = M("game_bet_qishu")->count();
            $data['code'] = '200';
            $data['msg'] = '请求成功';
            // $data['count'] = $count;
            $data['data'] = $arr;
            echo json_encode($data);
        } else {
            echo $this->returnData();
        }
    }
    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖用户期数
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function bet_user_details()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $id = $_POST['qishu_id'];
            $arr = M("game_bet_touzhu")->where("qishu_id=$id")->page($page, $size)->select();
            $count = M("game_bet_touzhu")->where("qishu_id=$id")->count();
            if ($arr) {//开奖兑奖
                foreach ($arr as $k => $v) {
                    $uid = $v['uid'];
                    $ref = M("user_info")->field("name,add_date")->where("id=$uid")->select();
                    $arr[$k]['name'] = $ref[0]['name'];
                    $arr[$k]['add_date'] = $ref[0]['add_date'];

                }
                $data['code'] = '200';
                $data['msg'] = '请求成功';
                $data['data'] = $arr;
                $data['count'] = $count;
                echo json_encode($data);
            } else {
                $data['code'] = '201';
                $data['msg'] = '暂无数据';
                $data['data'] = $arr;
                echo json_encode($data);
            }
        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖快乐100用户期数
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function luck_100_user_details()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $page = $_POST['page'];
            $size = $_POST['size'];
            $id = $_POST['qishu_id'];
            $arr = M("game_luck_100_touzhu")->where("qishu_id=$id")->page($page, $size)->select();
            $count = M("game_luck_100_touzhu")->where("qishu_id=$id")->count();
            if ($arr) {//开奖兑奖
                foreach ($arr as $k => $v) {
                    $uid = $v['uid'];
                    $ref = M("user_info")->field("name,add_date")->where("id=$uid")->select();
                    $arr[$k]['name'] = $ref[0]['name'];
                    $arr[$k]['add_date'] = $ref[0]['add_date'];

                }
                $data['code'] = '200';
                $data['msg'] = '请求成功';
                $data['data'] = $arr;
                $data['count'] = $count;
                echo json_encode($data);
            } else {
                $data['code'] = '201';
                $data['msg'] = '暂无数据';
                $data['data'] = $arr;
                echo json_encode($data);
            }
        } else {
            echo $this->returnData();
        }
    }
    /**
     * 版本：
     * 删除：
     * 简述：删除既不付费又不登陆
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_user_guoqi()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        #获取前半年
        $zhuce = strtotime("-6 month");
        // 半年前的时间戳
        $last_login_time = strtotime('-6 month', strtotime(date("Y-m-d")));

        $user_info = M("user_info as info")
            ->join('bb_pay_test as pay ON info.id = pay.uid', 'left')
            ->field("info.id")
            ->where("info.add_time  <= $zhuce and info.last_login_time  <=  $last_login_time    and pay.uid is null ")
            ->group("info.id")
            ->limit(50)
            ->select();
        if ($user_info) {
            foreach ($user_info as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                $pay_test = M('pay_test')->field("id,uid")->where("uid= $uid")->select();
                if ($pay_test) {
                } else {
                    M("user_info")->where("id = '$uid'")->delete();
                }
            }
        }


        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $user_info;
        echo json_encode($data);
    }
    /**
     * 版本：
     * 删除：
     * 简述：删除token_tmpl
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_user_token_tmpl()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        #获取1天前
        $zhuce = strtotime("-1 day");
        // 1天前的时间戳
        $last_login_time = date("Y-m-d H:i:s ",$zhuce);

        M("token_tmpl")->where("token_time_out  <= '$last_login_time' ")->delete();
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $user_info;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 删除：
     * 简述：修改状态
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function upde_ys_tu_url()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');


        $todayTimestamp = time(); // 获取当前时间戳
        $wan = strtotime("22:00:00",time());
        $zao= strtotime("06:00:00",time());

        if ($zao>=$todayTimestamp){
            M("ys_guang_tu_url")->where("type= '1' ")->save();
        }
        if ($wan<=$todayTimestamp){
            M("ys_guang_tu_url")->where("type= '0' ")->save();
        }

        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        echo json_encode($data);
    }

    /**
     * 版本：
     * 删除：
     * 简述：删除历史数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_user_video_lishi()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        #获取前半年
        $zhuce = strtotime("-1 month");

        $user_info = M("video_lishi")->field("id")->where("time  <= $zhuce  ")->limit(50)->select();
        if ($user_info) {
            foreach ($user_info as $ks => $vs) {
                $id = $vs['id'];//数据分流
                M("video_lishi")->where("id = '$id'")->delete();
            }
        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $user_info;
        echo json_encode($data);
    }
    /**
     * 版本：
     * 删除：
     * 简述：删除游戏过期投注期数
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_game_add()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');


        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");

        $bet_touzhu =  M("game_bet_touzhu")->where("UNIX_TIMESTAMP(touzhu_time) <=  $yue_start_time ")->select();
        if ($bet_touzhu) {
            foreach ($bet_touzhu as $ks => $vs) {
                     $id = $vs['id'];//数据分流
                    M("game_bet_touzhu")->where("id = '$id'")->delete();
            }
        }

        $uck_100_touzhu =  M("game_luck_100_touzhu")->where("UNIX_TIMESTAMP(tz_time) <=  $yue_start_time ")->select();
        if ($uck_100_touzhu) {
            foreach ($uck_100_touzhu as $ks => $vs) {
                $id = $vs['id'];//数据分流
                M("game_luck_100_touzhu")->where("id = '$id'")->delete();
            }
        }

        $bet_qishu =  M("game_bet_qishu")->where("UNIX_TIMESTAMP(bet_time) <=  $yue_start_time ")->select();
        if ($bet_qishu) {
            foreach ($bet_qishu as $ks => $vs) {
                $id = $vs['id'];//数据分流
                M("game_bet_qishu")->where("id = '$id'")->delete();
            }
        }

        $luck_100_qishu=  M("game_luck_100_qishu")->where("UNIX_TIMESTAMP(bet_time) <=  $yue_start_time ")->select();
        if ($luck_100_qishu) {
            foreach ($luck_100_qishu as $ks => $vs) {
                $id = $vs['id'];//数据分流
                M("game_luck_100_qishu")->where("id = '$id'")->delete();
            }
        }


        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $user_info;
        echo json_encode($data);
    }
    /**
     * 版本：
     * 删除：
     * 简述：删除片源统计
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_pian_count()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        #获取四天前
        $fourday_end = date("Y-m-d", strtotime("-4 day")) . " 23:59:59";
        // 半年前的时间戳
        $last_login_time = strtotime('-6 month', strtotime(date("Y-m-d")));
        $fourri = M("search_count as aa")
            ->join('bb_search_count_sub as bb on aa.id = bb.search_count_id', 'left')
            ->field("bb.id")
            ->where("bb.search_date<='$fourday_end' ")
            ->limit(50)
            ->select();
        if ($fourri) {
            foreach ($fourri as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("search_count_sub")->where("id = '$uid'")->delete();
            }
        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $user_info;
        echo json_encode($data);
    }

    /**
     * 版本：
     * 删除：
     * 简述：删除软删除素材数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function del_guoqi_sucai()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        #获取前二月
        $task_time = strtotime("-2 month");
        $dy_ks_task = M('dy_ks_task')->field("id")->where("task_time <= $task_time  and task_type = 1 ")->limit(50)->select();
        $douyin_sucaiku = M('douyin_sucaiku')->field("id")->where("task_time <= $task_time  and task_type = 1 ")->limit(50)->select();
        $dy_wx_sucaiku = M('dy_wx_sucaiku')->field("id")->where("task_time <= $task_time  and task_type = 1 ")->limit(50)->select();
        $dy_ks_sucaiku = M('dy_ks_sucaiku')->field("id")->where("task_time <= $task_time  and task_type = 1 ")->limit(50)->select();
        $kuaishou_sucaiku = M('dy_kuaishou_sucaiku')->field("id")->where("task_time <= $task_time  and task_type = 1 ")->limit(50)->select();

        if ($dy_ks_task) {
            foreach ($dy_ks_task as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("dy_ks_task")->where("id = '$uid'")->delete();
            }
        }
        if ($douyin_sucaiku) {
            foreach ($douyin_sucaiku as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("douyin_sucaiku")->where("id = '$uid'")->delete();
            }
        }
        if ($dy_wx_sucaiku) {
            foreach ($dy_wx_sucaiku as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("dy_wx_sucaiku")->where("id = '$uid'")->delete();
            }
        }
        if ($dy_ks_sucaiku) {
            foreach ($dy_ks_sucaiku as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("dy_ks_sucaiku")->where("id = '$uid'")->delete();
            }
        }
        if ($kuaishou_sucaiku) {
            foreach ($kuaishou_sucaiku as $ks => $vs) {
                $uid = $vs['id'];//数据分流
                M("dy_kuaishou_sucaiku")->where("id = '$uid'")->delete();
            }
        }
        $data['code'] = '200';
        $data['status'] = '1';
        $data['message'] = '';
        //$data['data'] = $dy_ks_task;
        echo json_encode($data);
    }

//    /**
//     * 版本：
//     * 新增/更新：
//     * 简述：付费用户的活跃状况
//     * @param  $templateid  []
//     * @return $type    消息类型
//     */
//    public function vip_huoyue_renshu_shuju(){
//        header('Content-Type:text/json;charset=utf-8');
//        header('Access-Control-Allow-Origin:*');
//        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
//        header('Access-Control-Allow-Methods:POST');
//        header('Access-Control-Expose-Headers:*');
//        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
//        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;
//
//        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
//        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;
//
//
//        $todayTimestamp = time(); // 获取当前时间戳
//        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
//        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
//        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳
//
//
//
//        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
//        $zhou_end_time = time();
//
//        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
//        $yue_end_time = time();
//        $vip_user=  M("user_info")->where("vip_money=1")->field("id")->select();
//        $last_id = array_map(function($element) {
//            return $element['id'];
//        }, $vip_user);
//        $str = json_encode($last_id);
//        $str = substr($str, 1, -1);
//
//        $huoyue = M("huoyue_list");
////        $huoyue_jin = M("huoyue_list")->where("uid in($str) and time BETWEEN $jinri_start_time  and $jinri_end_time  ")->field("uid")->group("uid")->select();
//        $now_time = time();
//        $huoyue_jin = M("user_info")->where("last_login_time>$jinri_start_time  and vip_money=1")->field("id")->group("id")->select();
//        $huoyue_zuo = M("huoyue_list")->where(" uid in($str) and time BETWEEN $zuo_start_time  and  $zuo_end_time ")->field("uid")->group("uid")->select();
//        $huoyue_san = M("huoyue_list")->where("uid in($str) and time BETWEEN $san_start_time  and  $san_end_time  ")->field("uid")->group("uid")->select();;
////				echo PHP_EOL.M("huoyue_list")->_sql();
//        $huoyue_zhou = M("huoyue_list")->where("uid in($str) and  time BETWEEN $zhou_start_time  and $zhou_end_time ")->field("uid")->group("uid")->select();
//        $huoyue_yue = M("huoyue_list")->where(" uid in($str) and time BETWEEN  $yue_start_time and $yue_end_time")->field("uid")->group("uid")->select();
//        $huoyue_jilei =  M("user_info")->where("last_login_time is not null and vip_money=1")->field("id")->select();
//
//
//        $arrs['jinri'] =count($huoyue_jin);
////        $arrs['zuori'] =count($huoyue_zuo);
////        $arrs['sanri'] = count($huoyue_san);
////        $arrs['zhou'] =count($huoyue_zhou);
////        $arrs['yue'] =count($huoyue_yue);
////        $arrs['jilei'] =count($huoyue_jilei);
//        $arrs['zuori'] ='维护中';
//        $arrs['sanri'] = '维护中';
//        $arrs['zhou'] ='维护中';
//        $arrs['yue'] ='维护中';
//        $arrs['jilei'] ='维护中';
//
//        $time_chuo = time();
//        $time_data=  date("Y-m-d H:i",$time_chuo);
//        $arrs['time'] =$time_chuo;
//        $arrs['date'] =$time_data;
//        M("admin_shuju_list")->where("title ='付费活跃'")->save($arrs);
//
//
//
//
//        $data['code'] = '200';
//        $data['status'] = '1';
//        $data['message'] = '';
//        $data['data'] =$arrs;
//        echo json_encode($data);
//    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：充值金额 相关数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function pay_shuju_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳

        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

//        $pay_list_table = M('pay_test');
//        $arr['jinri']= $pay_list_table->where("pay_time BETWEEN $jinri_start_time  and $jinri_end_time and order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//        //充值人数
//        $arr['zuori'] = $pay_list_table->where("pay_time BETWEEN $zuo_start_time  and  $zuo_end_time and order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//        $arr['sanri'] = $pay_list_table->where("pay_time BETWEEN $san_start_time  and  $san_end_time and order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//        $arr['zhou'] = $pay_list_table->where("pay_time BETWEEN $zhou_start_time  and $zhou_end_time and order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//        $arr['yue'] = $pay_list_table->where("pay_time BETWEEN  $yue_start_time and $yue_end_time and order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//        $arr['jilei'] = $pay_list_table->where("order_type='已支付' and order_str!= '手动打金' ")->count("DISTINCT uid");
//
//        //自动充值金额
//        $arrs['jinri'] = $pay_list_table->where("pay_time BETWEEN $jinri_start_time  and $jinri_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time BETWEEN $jinri_start_time  and $jinri_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : "0";
//        $arrs['zuori'] = $pay_list_table->where("pay_time BETWEEN $zuo_start_time  and  $zuo_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time BETWEEN $zuo_start_time  and  $zuo_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : "0";
//        $arrs['sanri'] = $pay_list_table->where("pay_time  BETWEEN $san_start_time  and  $san_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $san_start_time  and  $san_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : '0';
//        $arrs['zhou'] = $pay_list_table->where("pay_time  BETWEEN $zhou_start_time  and  $zhou_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $zhou_start_time  and  $zhou_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : '0';
//        $arrs['yue'] = $pay_list_table->where("pay_time  BETWEEN $yue_start_time  and  $yue_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $yue_start_time  and  $yue_end_time and order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : '0';
//        $arrs['jilei'] = $pay_list_table->where("order_type='已支付'")->sum('amount') ? $pay_list_table->where("order_type='已支付' and order_str!= '手动打金' ")->sum('amount') : '0';


        $pay_list_table = M('huidiao_test ');
        $arr['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time  ")->count("DISTINCT uid");
        //充值人数
        $arr['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time  ")->count("DISTINCT uid");
        $arr['sanri'] = $pay_list_table->where("time BETWEEN $san_start_time  and  $san_end_time  ")->count("DISTINCT uid");
        $arr['zhou'] = $pay_list_table->where("time BETWEEN $zhou_start_time  and $zhou_end_time  ")->count("DISTINCT uid");
        $arr['yue'] = $pay_list_table->where("time BETWEEN  $yue_start_time and $yue_end_time  ")->count("DISTINCT uid");
        $arr['jilei'] = $pay_list_table->count("DISTINCT uid");

        //自动充值金额
        $arrs['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum('amount') ? $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time   ")->sum('amount') : "0";
        $arrs['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum('amount') ? $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time    ")->sum('amount') : "0";
        $arrs['sanri'] = $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time   ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time    ")->sum('amount') : '0';
        $arrs['zhou'] = $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time   ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time  ")->sum('amount') : '0';
        $arrs['yue'] = $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time  ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time  ")->sum('amount') : '0';
        $arrs['jilei'] = $pay_list_table->sum('amount') ? $pay_list_table->sum('amount') : '0';

        //充值金额   总的
        $arr_all['jinri'] = $arrs['jinri'];
        $arr_all['zuori'] = $arrs['zuori'];
        $arr_all['sanri'] = $arrs['sanri'];
        $arr_all['zhou'] = $arrs['zhou'];
        $arr_all['yue'] = $arrs['yue'];
        $arr_all['jilei'] = $arrs['jilei'];


        //充值人数   总的
        $arr_num_all['jinri'] = $arr['jinri'];
        $arr_num_all['zuori'] = $arr['zuori'];
        $arr_num_all['sanri'] = $arr['sanri'];
        $arr_num_all['zhou'] = $arr['zhou'];
        $arr_num_all['yue'] = $arr['yue'];
        $arr_num_all['jilei'] = $arr['jilei'];
        //
        //用户新增
        $user_info_list = M('user_info');
        $arr_insert['jinri'] = $user_info_list->where("add_time BETWEEN $jinri_start_time  and $jinri_end_time  ")->count();
        $arr_insert['zuori'] = $user_info_list->where("add_time BETWEEN $zuo_start_time  and  $zuo_end_time  ")->count();
        $arr_insert['sanri'] = $user_info_list->where("add_time BETWEEN $san_start_time  and  $san_end_time  ")->count();
        $arr_insert['zhou'] = $user_info_list->where("add_time BETWEEN $zhou_start_time  and $zhou_end_time  ")->count();
        $arr_insert['yue'] = $user_info_list->where("add_time BETWEEN  $yue_start_time and $yue_end_time  ")->count();
        //付费率-----      付费人数/新增人数
        $jinri_pay_rate = sprintf("%.1f", $arr['jinri'] / $arr_insert['jinri'] * 100) . "%";
        if ($jinri_pay_rate == 'NaN%' || $jinri_pay_rate == '0.0%' || $jinri_pay_rate == 'INF%') {
            $arr_pay_rate['jinri'] = "0%";
        } else {
            $arr_pay_rate['jinri'] = $jinri_pay_rate;
        }

        $zuori_pay_rate = sprintf("%.1f", $arr['zuori'] / $arr_insert['zuori'] * 100) . "%";
        if ($zuori_pay_rate == 'NaN%' || $zuori_pay_rate == '0.0%' || $zuori_pay_rate == 'INF%') {
            $arr_pay_rate['zuori'] = "0%";
        } else {
            $arr_pay_rate['zuori'] = $zuori_pay_rate;
        }

        $sanri_pay_rate = sprintf("%.1f", $arr['sanri'] / $arr_insert['sanri'] * 100) . "%";
        if ($sanri_pay_rate == 'NaN%' || $sanri_pay_rate == '0.0%' || $sanri_pay_rate == 'INF%') {
            $arr_pay_rate['sanri'] = "0%";
        } else {
            $arr_pay_rate['sanri'] = $sanri_pay_rate;
        }

        $zhou_pay_rate = sprintf("%.1f", $arr['zhou'] / $arr_insert['zhou'] * 100) . "%";
        if ($zhou_pay_rate == 'NaN%' || $zhou_pay_rate == '0.0%' || $zhou_pay_rate == 'INF%') {
            $arr_pay_rate['zhou'] = "0%";
        } else {
            $arr_pay_rate['zhou'] = $zhou_pay_rate;
        }

        $yue_pay_rate = sprintf("%.1f", $arr['yue'] / $arr_insert['yue'] * 100) . "%";
        if ($yue_pay_rate == 'NaN%' || $yue_pay_rate == '0.0%' || $yue_pay_rate == 'INF%') {
            $arr_pay_rate['yue'] = "0%";
        } else {
            $arr_pay_rate['yue'] = $yue_pay_rate;
        }
        //人均付费-----
        $jinri_pay_capita = sprintf("%.1f", $arrs['jinri'] / $arr['jinri']);
        if ($jinri_pay_capita == 'NaN') {
            $arr_pay_capita['jinri'] = "0";
        } else {
            $arr_pay_capita['jinri'] = $jinri_pay_capita;
        }

        $zuori_pay_capita = sprintf("%.1f", $arrs['zuori'] / $arr['zuori']);
        if ($zuori_pay_capita == 'NaN') {
            $arr_pay_capita['zuori'] = "0";
        } else {
            $arr_pay_capita['zuori'] = $zuori_pay_capita;
        }

        $sanri_pay_capita = sprintf("%.1f", $arrs['sanri'] / $arr['sanri']);
        if ($sanri_pay_capita == 'NaN') {
            $arr_pay_capita['sanri'] = "0";
        } else {
            $arr_pay_capita['sanri'] = $sanri_pay_capita;
        }

        $zhou_pay_capita = sprintf("%.1f", $arrs['zhou'] / $arr['zhou']);
        if ($zhou_pay_capita == 'NaN') {
            $arr_pay_capita['zhou'] = "0";
        } else {
            $arr_pay_capita['zhou'] = $zhou_pay_capita;
        }

        $yue_pay_capita = sprintf("%.1f", $arrs['yue'] / $arr['yue']);
        if ($yue_pay_capita == 'NaN') {
            $arr_pay_capita['yue'] = "0";
        } else {
            $arr_pay_capita['yue'] = $yue_pay_capita;
        }


        $arr1['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");
        //充值人数
        $arr1['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");
        $arr1['sanri'] = $pay_list_table->where("time BETWEEN $san_start_time  and  $san_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");
        $arr1['zhou'] = $pay_list_table->where("time BETWEEN $zhou_start_time  and $zhou_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");
        $arr1['yue'] = $pay_list_table->where("time BETWEEN  $yue_start_time and $yue_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");
        $arr1['jilei'] = $pay_list_table->where(" add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->count("DISTINCT uid");

        //自动充值金额
        $arrs1['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') : "0";
        $arrs1['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') : "0";
        $arrs1['sanri'] = $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') : '0';
        $arrs1['zhou'] = $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx'")->sum('amount') : '0';
        $arrs1['yue'] = $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') : '0';
        $arrs1['jilei'] = $pay_list_table->where(" add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') ? $pay_list_table->where(" add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html' and  attach = 'xx' ")->sum('amount') : '0';

        //充值金额   总的
        $arr_all1['jinri'] = $arrs1['jinri'];
        $arr_all1['zuori'] = $arrs1['zuori'];
        $arr_all1['sanri'] = $arrs1['sanri'];
        $arr_all1['zhou'] = $arrs1['zhou'];
        $arr_all1['yue'] = $arrs1['yue'];
        $arr_all1['jilei'] = $arrs1['jilei'];


        //充值人数   总的
        $arr_num_all1['jinri'] = $arr1['jinri'];
        $arr_num_all1['zuori'] = $arr1['zuori'];
        $arr_num_all1['sanri'] = $arr1['sanri'];
        $arr_num_all1['zhou'] = $arr1['zhou'];
        $arr_num_all1['yue'] = $arr1['yue'];
        $arr_num_all1['jilei'] = $arr1['jilei'];

        //用户新增
        $user_info_list = M('user_info');
        $arr_insert1['jinri'] = $user_info_list->where("add_time BETWEEN $jinri_start_time  and $jinri_end_time  and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  ")->count();
        $arr_insert1['zuori'] = $user_info_list->where("add_time BETWEEN $zuo_start_time  and  $zuo_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  ")->count();
        $arr_insert1['sanri'] = $user_info_list->where("add_time BETWEEN $san_start_time  and  $san_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  ")->count();
        $arr_insert1['zhou'] = $user_info_list->where("add_time BETWEEN $zhou_start_time  and $zhou_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  ")->count();
        $arr_insert1['yue'] = $user_info_list->where("add_time BETWEEN  $yue_start_time and $yue_end_time and add_url = 'https://c2.9169kkxstzsjkyy333.app/register.html'  ")->count();
        //付费率-----      付费人数/新增人数
        $jinri_pay_rate1 = sprintf("%.1f", $arr1['jinri'] / $arr_insert1['jinri'] * 100) . "%";
        if ($jinri_pay_rate1 == 'NaN%' || $jinri_pay_rate1 == '0.0%' || $jinri_pay_rate1 == 'INF%') {
            $arr_pay_rate1['jinri'] = "0%";
        } else {
            $arr_pay_rate1['jinri'] = $jinri_pay_rate1;
        }

        $zuori_pay_rate1 = sprintf("%.1f", $arr1['zuori'] / $arr_insert1['zuori'] * 100) . "%";
        if ($zuori_pay_rate1 == 'NaN%' || $zuori_pay_rate1 == '0.0%' || $zuori_pay_rate1 == 'INF%') {
            $arr_pay_rate1['zuori'] = "0%";
        } else {
            $arr_pay_rate1['zuori'] = $zuori_pay_rate1;
        }

        $sanri_pay_rate1 = sprintf("%.1f", $arr1['sanri'] / $arr_insert1['sanri'] * 100) . "%";
        if ($sanri_pay_rate1 == 'NaN%' || $sanri_pay_rate1 == '0.0%' || $sanri_pay_rate1 == 'INF%') {
            $arr_pay_rate1['sanri'] = "0%";
        } else {
            $arr_pay_rate1['sanri'] = $sanri_pay_rate1;
        }

        $zhou_pay_rate1 = sprintf("%.1f", $arr1['zhou'] / $arr_insert1['zhou'] * 100) . "%";
        if ($zhou_pay_rate1 == 'NaN%' || $zhou_pay_rate1 == '0.0%' || $zhou_pay_rate1 == 'INF%') {
            $arr_pay_rate1['zhou'] = "0%";
        } else {
            $arr_pay_rate1['zhou'] = $zhou_pay_rate1;
        }

        $yue_pay_rate1 = sprintf("%.1f", $arr1['yue'] / $arr_insert1['yue'] * 100) . "%";
        if ($yue_pay_rate1 == 'NaN%' || $yue_pay_rate1 == '0.0%' || $yue_pay_rate1 == 'INF%') {
            $arr_pay_rate1['yue'] = "0%";
        } else {
            $arr_pay_rate1['yue'] = $yue_pay_rate1;
        }
        //人均付费-----
        $jinri_pay_capita1 = sprintf("%.1f", $arrs1['jinri'] / $arr1['jinri']);
        if ($jinri_pay_capita1 == 'NaN') {
            $arr_pay_capita1['jinri'] = "0";
        } else {
            $arr_pay_capita1['jinri'] = $jinri_pay_capita1;
        }

        $zuori_pay_capita1 = sprintf("%.1f", $arrs1['zuori'] / $arr1['zuori']);
        if ($zuori_pay_capita1 == 'NaN') {
            $arr_pay_capita1['zuori'] = "0";
        } else {
            $arr_pay_capita1['zuori'] = $zuori_pay_capita1;
        }

        $sanri_pay_capita1 = sprintf("%.1f", $arrs1['sanri'] / $arr1['sanri']);
        if ($sanri_pay_capita1 == 'NaN') {
            $arr_pay_capita1['sanri'] = "0";
        } else {
            $arr_pay_capita1['sanri'] = $sanri_pay_capita1;
        }

        $zhou_pay_capita1 = sprintf("%.1f", $arrs1['zhou'] / $arr1['zhou']);
        if ($zhou_pay_capita1 == 'NaN') {
            $arr_pay_capita1['zhou'] = "0";
        } else {
            $arr_pay_capita1['zhou'] = $zhou_pay_capita1;
        }

        $yue_pay_capita1 = sprintf("%.1f", $arrs1['yue'] / $arr1['yue']);
        if ($yue_pay_capita1 == 'NaN') {
            $arr_pay_capita1['yue'] = "0";
        } else {
            $arr_pay_capita1['yue'] = $yue_pay_capita1;
        }

        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        $arr_all['time'] = $time_chuo;
        $arr_all['date'] = $time_data;
        $arr_rengong['time'] = $time_chuo;
        $arr_rengong['date'] = $time_data;
        $arr_pay_rate['time'] = $time_chuo;
        $arr_pay_rate['date'] = $time_data;
        $arr_pay_capita['time'] = $time_chuo;
        $arr_pay_capita['date'] = $time_data;
        $arr_num_all['time'] = $time_chuo;
        $arr_num_all['date'] = $time_data;


        $time_chuo1 = time();
        $time_data1 = date("Y-m-d H:i", $time_chuo1);
        $arrs1['time'] = $time_chuo1;
        $arrs1['date'] = $time_data1;
        $arr_all1['time'] = $time_chuo1;
        $arr_all1['date'] = $time_data1;
        $arr_rengong1['time'] = $time_chuo1;
        $arr_rengong1['date'] = $time_data1;
        $arr_pay_rate1['time'] = $time_chuo1;
        $arr_pay_rate1['date'] = $time_data1;
        $arr_pay_capita1['time'] = $time_chuo1;
        $arr_pay_capita1['date'] = $time_data1;
        $arr_num_all1['time'] = $time_chuo1;
        $arr_num_all1['date'] = $time_data1;
        M("admin_shuju_list")->where("title ='充值金额'")->save($arr_all);
        M("admin_shuju_list")->where("title ='充值人数'")->save($arr_num_all);

        M("admin_shuju_list")->where("title ='付费率'")->save($arr_pay_rate);
        M("admin_shuju_list")->where("title ='人均付费'")->save($arr_pay_capita);

        M("admin_shuju_list")->where("title ='独立测试充值金额'")->save($arr_all1);
        M("admin_shuju_list")->where("title ='独立测试充值人数'")->save($arr_num_all1);

        M("admin_shuju_list")->where("title ='独立测试付费率'")->save($arr_pay_rate1);
        M("admin_shuju_list")->where("title ='独立测试人均付费'")->save($arr_pay_capita1);

        $arr_list = array($arr, $arrs, $arr_rengong, $arr1, $arrs1, $arr_rengong1);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }

    /**
     * 版本：
     * 新增/更新：
     * 简述：充值金额 相关数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function pay_shuju_shoudong()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳

        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

        $pay_list_table = M('pay_test');

        //自动充值金额
        $arrs['jinri'] = $pay_list_table->where("pay_time BETWEEN $jinri_start_time  and $jinri_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time BETWEEN $jinri_start_time  and $jinri_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') : "0";
        $arrs['zuori'] = $pay_list_table->where("pay_time BETWEEN $zuo_start_time  and  $zuo_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time BETWEEN $zuo_start_time  and  $zuo_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') : "0";
        $arrs['sanri'] = $pay_list_table->where("pay_time  BETWEEN $san_start_time  and  $san_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $san_start_time  and  $san_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') : '0';
        $arrs['zhou'] = $pay_list_table->where("pay_time  BETWEEN $zhou_start_time  and  $zhou_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $zhou_start_time  and  $zhou_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') : '0';
        $arrs['yue'] = $pay_list_table->where("pay_time  BETWEEN $yue_start_time  and  $yue_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') ? $pay_list_table->where("pay_time  BETWEEN $yue_start_time  and  $yue_end_time and order_type='已支付' and order_str = '手动打金' ")->sum('amount') : '0';
        $arrs['jilei'] = $pay_list_table->where("order_type='已支付'")->sum('amount') ? $pay_list_table->where("order_type='已支付' and order_str = '手动打金' ")->sum('amount') : '0';

        //充值金额   总的
        $arr_all['jinri'] = $arrs['jinri'];
        $arr_all['zuori'] = $arrs['zuori'];
        $arr_all['sanri'] = $arrs['sanri'];
        $arr_all['zhou'] = $arrs['zhou'];
        $arr_all['yue'] = $arrs['yue'];
        $arr_all['jilei'] = $arrs['jilei'];
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arr_all['time'] = $time_chuo;
        $arr_all['date'] = $time_data;

        M("admin_shuju_list")->where("title ='手动打金'")->save($arr_all);

        $arr_list = array($arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }

    /**
     * 版本：
     * 新增/更新：
     * 简述：会员相关数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function huiyuan_shuju_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

        $pay_list_table = M('vip_add_list');
        $arr['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time ")->count("DISTINCT uid");
        $arr['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time")->count("DISTINCT uid");
        $arr['sanri'] = $pay_list_table->where("time BETWEEN $san_start_time  and  $san_end_time")->count("DISTINCT uid");
        $arr['zhou'] = $pay_list_table->where("time BETWEEN $zhou_start_time  and $zhou_end_time ")->count("DISTINCT uid");
        $arr['yue'] = $pay_list_table->where("time BETWEEN  $yue_start_time and $yue_end_time ")->count("DISTINCT uid");
        $arr['jilei'] = $pay_list_table->where("id>0")->count("DISTINCT uid");


        $arrs['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time")->sum('amount') ? $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time")->sum('amount') : '0';
        $arrs['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time")->sum('amount') ? $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time")->sum('amount') : '0';
        $arrs['sanri'] = $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time")->sum('amount') ? $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time")->sum('amount') : '0';
        $arrs['zhou'] = $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time")->sum('amount') ? $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time")->sum('amount') : '0';
        $arrs['yue'] = $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time")->sum('amount') ? $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time")->sum('amount') : '0';
        $arrs['jilei'] = $pay_list_table->where("time is not null")->sum('amount') ? $pay_list_table->where("time is not null")->sum('amount') : '0';

        if (empty($arr['jinri_pay_num'])) {
            $arrs['jinri_amount'] = "0";
        }
        if (empty($arrs['jinri_amount'])) {
            $arrs['jinri_amount'] = "0";
        }
        $arr_list = array($arr, $arrs);


        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        $arr['time'] = $time_chuo;
        $arr['date'] = $time_data;
        M("admin_shuju_list")->where("title ='会员人数'")->save($arr);
        M("admin_shuju_list")->where("title ='会员金额'")->save($arrs);


        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：金币栏目数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function jinbi_lanmu_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //时间戳格式
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

        //日期格式
        $jinri_start_date = date("Y-m-d", time()) . " 00:00:00";
        $jinri_end_date = date("Y-m-d", time()) . " 23:59:59";

        $zuo_start_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
        $zuo_end_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

        $san_start_date = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
        $san_end_date = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳


        $zhou_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
        $zhou_end_date = date("Y-m-d H:i:s", time());

        $yue_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
        $yue_end_date = date("Y-m-d H:i:s", time());

        //隐私查询的用户金币
        $yinsi_num['jinri'] = M("search_info")->where("search_time BETWEEN $jinri_start_time  and $jinri_end_time and status=1 and tuikuan=0")->count();
        $yinsi_num['zuori'] = M("search_info")->where("search_time BETWEEN $zuo_start_time  and  $zuo_end_time and status=1 and tuikuan=0")->count();
        $yinsi_num['sanri'] = M("search_info")->where("search_time BETWEEN $san_start_time  and  $san_end_time and status=1 and tuikuan=0")->count();
        $yinsi_num['zhou'] = M("search_info")->where("search_time BETWEEN $zhou_start_time  and $zhou_end_time and status=1 and tuikuan=0")->count();
        $yinsi_num['yue'] = M("search_info")->where("search_time BETWEEN  $yue_start_time and $yue_end_time and status=1 and tuikuan=0")->count();
        $yinsi_num['leiji'] = M("search_info")->where("status=1 and tuikuan=0")->count();

        //用户解锁栏目花费金币的人数 已回复确收款
        $pay_list_table = M('hj_fc_buy_record');
        $jinbi_renshu['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time  ")->count("DISTINCT uid");
        $jinbi_renshu['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time ")->count("DISTINCT uid");
        $jinbi_renshu['sanri'] = $pay_list_table->where("time BETWEEN $san_start_time  and  $san_end_time  ")->count("DISTINCT uid");
        $jinbi_renshu['zhou'] = $pay_list_table->where("time BETWEEN $zhou_start_time  and $zhou_end_time  ")->count("DISTINCT uid");
        $jinbi_renshu['yue'] = $pay_list_table->where("time BETWEEN  $yue_start_time and $yue_end_time   ")->count("DISTINCT uid");
        $jinbi_renshu['jilei'] = $pay_list_table->where("id>0 ")->count("DISTINCT uid");

        //用户解锁字母圈人数
        $zimuquan_table = M('zimuquan_jiesuo');
        $zumuquan_num['jinri'] = $zimuquan_table->where("jiesuo_date BETWEEN '$jinri_start_date' and '$jinri_end_date'")->count();
        $zumuquan_num['zuori'] = $zimuquan_table->where("jiesuo_date BETWEEN '$zuo_start_date' and '$zuo_end_date'")->count();
        $zumuquan_num['sanri'] = $zimuquan_table->where("jiesuo_date BETWEEN '$san_start_date' and '$san_end_date'")->count();
        $zumuquan_num['zhou'] = $zimuquan_table->where("jiesuo_date BETWEEN '$zhou_start_date' and '$zhou_end_date'")->count();
        $zumuquan_num['yue'] = $zimuquan_table->where("jiesuo_date BETWEEN  '$yue_start_date' and '$yue_end_date'")->count();
        $zumuquan_num['jilei'] = $zimuquan_table->count();

        //用户解锁字母圈金币
        $zumuquan_coins['jinri'] = $zimuquan_table->where("jiesuo_date BETWEEN '$jinri_start_date' and '$jinri_end_date'")->sum('coins') ? $zimuquan_table->where("jiesuo_date BETWEEN '$jinri_start_date' and '$jinri_end_date'")->sum('coins') : '0';
        $zumuquan_coins['zuori'] = $zimuquan_table->where("jiesuo_date BETWEEN '$zuo_start_date' and '$zuo_end_date'")->sum('coins') ? $zimuquan_table->where("jiesuo_date BETWEEN '$zuo_start_date' and '$zuo_end_date'")->sum('coins') : '0';
        $zumuquan_coins['sanri'] = $zimuquan_table->where("jiesuo_date BETWEEN '$san_start_date' and '$san_end_date'")->sum('coins') ? $zimuquan_table->where("jiesuo_date BETWEEN '$san_start_date' and '$san_end_date'")->sum('coins') : '0';
        $zumuquan_coins['zhou'] = $zimuquan_table->where("jiesuo_date BETWEEN '$zhou_start_date' and '$zhou_end_date'")->sum('coins') ? $zimuquan_table->where("jiesuo_date BETWEEN '$zhou_start_date' and '$zhou_end_date'")->sum('coins') : '0';
        $zumuquan_coins['yue'] = $zimuquan_table->where("jiesuo_date BETWEEN  '$yue_start_date' and '$yue_end_date'")->sum('coins') ? $zimuquan_table->where("jiesuo_date BETWEEN '$yue_start_date' and '$yue_end_date'")->sum('coins') : '0';
        $zumuquan_coins['jilei'] = $zimuquan_table->sum('coins') ? $zimuquan_table->sum('coins') : '0';


        //查询吃瓜 短信轰炸  qq群付费的人数
        $three_lanmu_num['jinri'] = M("admin_coins_pay")->where("id>23")->sum("jinri_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("jinri_pay_num") : '0';
        $three_lanmu_num['zuori'] = M("admin_coins_pay")->where("id>23")->sum("zuori_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("zuori_pay_num") : '0';
        $three_lanmu_num['sanri'] = M("admin_coins_pay")->where("id>23")->sum("sanri_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("sanri_pay_num") : '0';
        $three_lanmu_num['zhou'] = M("admin_coins_pay")->where("id>23")->sum("zhou_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("zhou_pay_num") : '0';
        $three_lanmu_num['yue'] = M("admin_coins_pay")->where("id>23")->sum("yue_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("yue_pay_num") : '0';
        $three_lanmu_num['jilei'] = M("admin_coins_pay")->where("id>23")->sum("jilei_pay_num") ? M("admin_coins_pay")->where("id>23")->sum("jilei_pay_num") : '0';

        //用户解锁经典AV  网曝门等3金币栏目的花费人数
        $three_coins_lanmu = M('free_riben_jiesuo');
        $three_jinbi_renshu['jinri'] = $three_coins_lanmu->where("create_at>='$jinri_start_date' and create_at<='$jinri_end_date'")->count("DISTINCT uid");
        $three_jinbi_renshu['zuori'] = $three_coins_lanmu->where("create_at>='$zuo_start_date' and create_at<='$zuo_end_date'")->count("DISTINCT uid");
        $three_jinbi_renshu['sanri'] = $three_coins_lanmu->where("create_at>='$san_start_date' and create_at<='$san_end_date'")->count("DISTINCT uid");
        $three_jinbi_renshu['zhou'] = $three_coins_lanmu->where("create_at>='$zhou_start_date'and create_at<='$zhou_end_date'")->count("DISTINCT uid");
        $three_jinbi_renshu['yue'] = $three_coins_lanmu->where("create_at>='$yue_start_date' and create_at<='$yue_end_date'")->count("DISTINCT uid");
        $three_jinbi_renshu['jilei'] = $three_coins_lanmu->count("DISTINCT uid");

        //用户解锁经典AV  网曝门等3金币栏目的花费金额
        $three_jinbi_coins['jinri'] = $three_coins_lanmu->where("create_at>='$jinri_start_date' and create_at<='$jinri_end_date'")->sum("take_coin") ? $three_coins_lanmu->where("create_at>='$jinri_start_date' and create_at<='$jinri_end_date'")->sum("take_coin") : '0';
        $three_jinbi_coins['zuori'] = $three_coins_lanmu->where("create_at>='$zuo_start_date' and create_at<='$zuo_end_date'")->sum("take_coin") ? $three_coins_lanmu->where("create_at>='$zuo_start_date' and create_at<='$zuo_end_date'")->sum("take_coin") : '0';
        $three_jinbi_coins['sanri'] = $three_coins_lanmu->where("create_at>='$san_start_date' and create_at<='$san_end_date'")->sum("take_coin") ? $three_coins_lanmu->where("create_at>='$san_start_date' and create_at<='$san_end_date'")->sum("take_coin") : '0';
        $three_jinbi_coins['zhou'] = $three_coins_lanmu->where("create_at>='$zhou_start_date'and create_at<='$zhou_end_date'")->sum("take_coin") ? $three_coins_lanmu->where("create_at>='$zhou_start_date'and create_at<='$zhou_end_date'")->sum("take_coin") : '0';
        $three_jinbi_coins['yue'] = $three_coins_lanmu->where("create_at>='$yue_start_date' and create_at<='$yue_end_date'")->sum("take_coin") ? $three_coins_lanmu->where("create_at>='$yue_start_date' and create_at<='$yue_end_date'")->sum("take_coin") : '0';
        $three_jinbi_coins['jilei'] = $three_coins_lanmu->sum("take_coin") ? $three_coins_lanmu->sum("take_coin") : '0';

        //用户解锁栏目花费金币的人数+隐私花费的人数已回复确收款+字母圈人数
        $arr['jinri'] = $yinsi_num['jinri'] + $jinbi_renshu['jinri'] + $three_lanmu_num['jinri'] + $three_jinbi_renshu['jinri'] + $zumuquan_num['jinri'];
        $arr['zuori'] = $yinsi_num['zuori'] + $jinbi_renshu['zuori'] + $three_lanmu_num['zuori'] + $three_jinbi_renshu['zuori'] + $zumuquan_num['zuori'];
        $arr['sanri'] = $yinsi_num['sanri'] + $jinbi_renshu['sanri'] + $three_lanmu_num['sanri'] + $three_jinbi_renshu['sanri'] + $zumuquan_num['sanri'];
        $arr['zhou'] = $yinsi_num['zhou'] + $jinbi_renshu['zhou'] + $three_lanmu_num['zhou'] + $three_jinbi_renshu['zhou'] + $zumuquan_num['zhou'];
        $arr['yue'] = $yinsi_num['yue'] + $jinbi_renshu['yue'] + $three_lanmu_num['yue'] + $three_jinbi_renshu['yue'] + $zumuquan_num['yue'];
        $arr['jilei'] = $yinsi_num['jilei'] + $jinbi_renshu['jilei'] + $three_lanmu_num['jilei'] + $three_jinbi_renshu['jilei'] + $zumuquan_num['jilei'];


        //查询吃瓜 短信轰炸  qq群付费的花费
        $three_lanmu_coin['jinri'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("jinri_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("jinri_amount") : '0';
        $three_lanmu_coin['zuori'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("zuori_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("zuori_amount") : '0';
        $three_lanmu_coin['sanri'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("sanri_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("sanri_amount") : '0';
        $three_lanmu_coin['zhou'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("zhou_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("zhou_amount") : '0';
        $three_lanmu_coin['yue'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("yue_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("yue_amount") : '0';
        $three_lanmu_coin['jilei'] = M("admin_coins_pay")->where("id>23 and id<27")->sum("jilei_amount") ? M("admin_coins_pay")->where("id>23 and id<27")->sum("jilei_amount") : '0';


        //用户解锁栏目花费的金币
        $jinbi_sum['jinri'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum('coins');
        $jinbi_sum['zuori'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum('coins');
        $jinbi_sum['sanri'] = $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time   ")->sum('coins');
        $jinbi_sum['zhou'] = $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time ")->sum('coins');
        $jinbi_sum['yue'] = $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time ")->sum('coins');
        $jinbi_sum['jilei'] = $pay_list_table->where("time is not null  ")->sum('coins');
        //用户解锁栏目花费的金币 + 已回复确收款隐私花费的人数x20金币+字母圈金币
        $arrs['jinri'] = $jinbi_sum['jinri'] + $yinsi_num['jinri'] * 20 + $three_lanmu_coin['jinri'] + $three_jinbi_coins['jinri'] + $zumuquan_coins['jinri'];
        $arrs['zuori'] = $jinbi_sum['zuori'] + $yinsi_num['zuori'] * 20 + $three_lanmu_coin['zuori'] + $three_jinbi_coins['zuori'] + $zumuquan_coins['zuori'];
        $arrs['sanri'] = $jinbi_sum['sanri'] + $yinsi_num['sanri'] * 20 + $three_lanmu_coin['sanri'] + $three_jinbi_coins['sanri'] + $zumuquan_coins['sanri'];
        $arrs['zhou'] = $jinbi_sum['zhou'] + $yinsi_num['zhou'] * 20 + $three_lanmu_coin['zhou'] + $three_jinbi_coins['zhou'] + $zumuquan_coins['zhou'];
        $arrs['yue'] = $jinbi_sum['yue'] + $yinsi_num['yue'] * 20 + $three_lanmu_coin['yue'] + $three_jinbi_coins['yue'] + $zumuquan_coins['yue'];
        $arrs['jilei'] = $jinbi_sum['jilei'] + $yinsi_num['jilei'] * 20 + $three_lanmu_coin['jilei'] + $three_jinbi_coins['jilei'] + $zumuquan_coins['jilei'];

        if (empty($arrs['jinri'])) {
            $arrs['jinri'] = "0";
        }
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arr['time'] = $time_chuo;
        $arr['date'] = $time_data;
        $arrs['time'] = $time_chuo;
        $arrs['date'] = $time_data;
        M("admin_shuju_list")->where("title ='金币人数'")->save($arr);
        M("admin_shuju_list")->where("title ='金币金额'")->save($arrs);
        $arr_list = array($arr, $arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：开奖游戏栏目数据
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function kai_jiang_lanmu_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //时间戳格式
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

        //日期格式
        $jinri_start_date = date("Y-m-d", time()) . " 00:00:00";
        $jinri_end_date = date("Y-m-d", time()) . " 23:59:59";

        $zuo_start_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
        $zuo_end_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

        $san_start_date = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
        $san_end_date = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳


        $zhou_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
        $zhou_end_date = date("Y-m-d H:i:s", time());

        $yue_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
        $yue_end_date = date("Y-m-d H:i:s", time());


        //查询投注订单数
        $touzhu_num['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 0")->sum("tz_count");
        $touzhu_num['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 0")->sum("tz_count");
        $touzhu_num['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 0")->sum("tz_count");
        $touzhu_num['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 0")->sum("tz_count");
        $touzhu_num['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 0 ")->sum("tz_count");
        $touzhu_num['jilei'] = M("game_user_tongji")->where("game_type = 0")->sum("tz_count");

        //查询投注人数
        $touzhu_num1['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 0  ")->count("DISTINCT uid");
        $touzhu_num1['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 0 ")->count("DISTINCT uid");
        $touzhu_num1['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 0 ")->count("DISTINCT uid");
        $touzhu_num1['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 0 ")->count("DISTINCT uid");
        $touzhu_num1['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 0 ")->count("DISTINCT uid");
        $touzhu_num1['jilei'] = M("game_user_tongji")->where("game_type = 0")->count("DISTINCT uid");


        //查询投注金额
        $touzhu_num2['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 0 ")->sum("tz_jin");
        $touzhu_num2['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 0 ")->sum("tz_jin");
        $touzhu_num2['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 0 ")->sum("tz_jin");
        $touzhu_num2['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 0 ")->sum("tz_jin");
        $touzhu_num2['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 0 ")->sum("tz_jin");
        $touzhu_num2['jilei'] = M("game_user_tongji")->where("game_type = 0")->sum("tz_jin");


        //查询输赢金额
        $touzhu_num3['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time  and game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 0")->sum("tz_yingli");
        $touzhu_num3['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time  and game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 0")->sum("tz_yingli");
        $touzhu_num3['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time  and game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 0")->sum("tz_yingli");
        $touzhu_num3['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time  and game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 0")->sum("tz_yingli");
        $touzhu_num3['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time  and game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 0")->sum("tz_yingli");
        $touzhu_num3['jilei'] = M("game_user_tongji")->where("game_type = 0")->sum("tz_jin") - M("game_user_tongji")->where("game_type = 0")->sum("tz_yingli");


        //查询提现金额
        $touzhu_nu4['jinri'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $jinri_start_time  and $jinri_end_time and status_ = 2 ")->sum("amount_");
        $touzhu_num4['zuori'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $zuo_start_time  and  $zuo_end_time and status_ = 2 ")->sum("amount_");
        $touzhu_num4['sanri'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $san_start_time  and  $san_end_time and status_ = 2 ")->sum("amount_");
        $touzhu_num4['zhou'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $zhou_start_time  and $zhou_end_time and status_ = 2 ")->sum("amount_");
        $touzhu_num4['yue'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN  $yue_start_time and $yue_end_time and status_ = 2 ")->sum("amount_");
        $touzhu_num4['jilei'] = M("game_user_tixian")->where("id>0 and status_ = 2 ")->sum("amount_");


        //查询投注订单数
        $luck_touzhu_num['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 1 ")->sum("tz_count");
        $luck_touzhu_num['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 1 ")->sum("tz_count");
        $luck_touzhu_num['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 1 ")->sum("tz_count");
        $luck_touzhu_num['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 1 ")->sum("tz_count");
        $luck_touzhu_num['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 1 ")->sum("tz_count");
        $luck_touzhu_num['jilei'] = M("game_user_tongji")->where("game_type = 1")->sum("tz_count");

        //查询投注人数
        $luck_touzhu_num1['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 1")->count("DISTINCT uid");
        $luck_touzhu_num1['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 1")->count("DISTINCT uid");
        $luck_touzhu_num1['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 1")->count("DISTINCT uid");
        $luck_touzhu_num1['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 1")->count("DISTINCT uid");
        $luck_touzhu_num1['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 1")->count("DISTINCT uid");
        $luck_touzhu_num1['jilei'] = M("game_user_tongji")->where("game_type = 1")->count("DISTINCT uid");


        //查询投注金额
        $luck_touzhu_num2['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 1")->sum("tz_jin");
        $luck_touzhu_num2['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 1")->sum("tz_jin");
        $luck_touzhu_num2['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 1")->sum("tz_jin");
        $luck_touzhu_num2['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 1")->sum("tz_jin");
        $luck_touzhu_num2['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 1")->sum("tz_jin");
        $luck_touzhu_num2['jilei'] = M("game_user_tongji")->where("game_type = 1")->sum("tz_jin");


        //查询输赢金额
        $luck_touzhu_num3['jinri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time  and game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $jinri_start_time  and $jinri_end_time and game_type = 1")->sum("tz_yingli");
        $luck_touzhu_num3['zuori'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time  and game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zuo_start_time  and  $zuo_end_time and game_type = 1")->sum("tz_yingli");
        $luck_touzhu_num3['sanri'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time  and game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $san_start_time  and  $san_end_time and game_type = 1")->sum("tz_yingli");
        $luck_touzhu_num3['zhou'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time  and game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN $zhou_start_time  and $zhou_end_time and game_type = 1")->sum("tz_yingli");
        $luck_touzhu_num3['yue'] = M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time  and game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("UNIX_TIMESTAMP(tz_day) BETWEEN  $yue_start_time and $yue_end_time and game_type = 1")->sum("tz_yingli");
        $luck_touzhu_num3['jilei'] = M("game_user_tongji")->where("game_type = 1")->sum("tz_jin") - M("game_user_tongji")->where("game_type = 1 ")->sum("tz_yingli");


//        //查询提现金额
//        $luck_touzhu_num4['jinri'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $jinri_start_time  and $jinri_end_time and status_ = 2 ")->sum("amount_");
//        $luck_touzhu_num4['zuori'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $zuo_start_time  and  $zuo_end_time and status_ = 2 ")->sum("amount_");
//        $luck_touzhu_num4['sanri'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $san_start_time  and  $san_end_time and status_ = 2 ")->sum("amount_");
//        $luck_touzhu_num4['zhou'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN $zhou_start_time  and $zhou_end_time and status_ = 2 ")->sum("amount_");
//        $luck_touzhu_num4['yue'] = M("game_user_tixian")->where("UNIX_TIMESTAMP(pay_time) BETWEEN  $yue_start_time and $yue_end_time and status_ = 2 ")->sum("amount_");
//        $luck_touzhu_num4['jilei'] = M("game_user_tixian")->where("id>0 and status_ = 2 ")->sum("amount_");
        //查询投注订单数
        $arr['jinri'] = $touzhu_num['jinri'];
        $arr['zuori'] = $touzhu_num['zuori'];
        $arr['sanri'] = $touzhu_num['sanri'];
        $arr['zhou'] = $touzhu_num['zhou'];
        $arr['yue'] = $touzhu_num['yue'];
        $arr['jilei'] = $touzhu_num['jilei'];

        //查询投注金额
        $arr2['jinri'] = $touzhu_num2['jinri'];
        $arr2['zuori'] = $touzhu_num2['zuori'];
        $arr2['sanri'] = $touzhu_num2['sanri'];
        $arr2['zhou'] = $touzhu_num2['zhou'];
        $arr2['yue'] = $touzhu_num2['yue'];
        $arr2['jilei'] = $touzhu_num2['jilei'];

        //查询投注金额
        $arr1['jinri'] = $touzhu_num1['jinri'];
        $arr1['zuori'] = $touzhu_num1['zuori'];
        $arr1['sanri'] = $touzhu_num1['sanri'];
        $arr1['zhou'] = $touzhu_num1['zhou'];
        $arr1['yue'] = $touzhu_num1['yue'];
        $arr1['jilei'] = $touzhu_num1['jilei'];

        //查询输赢金额
        $arr3['jinri'] = $touzhu_num3['jinri'];
        $arr3['zuori'] = $touzhu_num3['zuori'];
        $arr3['sanri'] = $touzhu_num3['sanri'];
        $arr3['zhou'] = $touzhu_num3['zhou'];
        $arr3['yue'] = $touzhu_num3['yue'];
        $arr3['jilei'] = $touzhu_num3['jilei'];

        //查询提现金额
        $tz4['jinri'] = $touzhu_num4['jinri'];
        $tz4['zuori'] = $touzhu_num4['zuori'];
        $tz4['sanri'] = $touzhu_num4['sanri'];
        $tz4['zhou'] = $touzhu_num4['zhou'];
        $tz4['yue'] = $touzhu_num4['yue'];
        $tz4['jilei'] = $touzhu_num4['jilei'];


        //查询投注订单数
        $tz['jinri'] = $luck_touzhu_num['jinri'];
        $tz['zuori'] = $luck_touzhu_num['zuori'];
        $tz['sanri'] = $luck_touzhu_num['sanri'];
        $tz['zhou'] = $luck_touzhu_num['zhou'];
        $tz['yue'] = $luck_touzhu_num['yue'];
        $tz['jilei'] = $luck_touzhu_num['jilei'];

        //查询投注金额
        $tz2['jinri'] = $luck_touzhu_num2['jinri'];
        $tz2['zuori'] = $luck_touzhu_num2['zuori'];
        $tz2['sanri'] = $luck_touzhu_num2['sanri'];
        $tz2['zhou'] = $luck_touzhu_num2['zhou'];
        $tz2['yue'] = $luck_touzhu_num2['yue'];
        $tz2['jilei'] = $luck_touzhu_num2['jilei'];

        //查询投注金额
        $tz1['jinri'] = $luck_touzhu_num1['jinri'];
        $tz1['zuori'] = $luck_touzhu_num1['zuori'];
        $tz1['sanri'] = $luck_touzhu_num1['sanri'];
        $tz1['zhou'] = $luck_touzhu_num1['zhou'];
        $tz1['yue'] = $luck_touzhu_num1['yue'];
        $tz1['jilei'] = $luck_touzhu_num1['jilei'];

        //查询输赢金额
        $tz3['jinri'] = $luck_touzhu_num3['jinri'];
        $tz3['zuori'] = $luck_touzhu_num3['zuori'];
        $tz3['sanri'] = $luck_touzhu_num3['sanri'];
        $tz3['zhou'] = $luck_touzhu_num3['zhou'];
        $tz3['yue'] = $luck_touzhu_num3['yue'];
        $tz3['jilei'] = $luck_touzhu_num3['jilei'];

        $noe_time = time();
        $ten_min = $noe_time - (60 * 10);
        $video_seven_add['online'] = M("user_info")->where("last_login_time>'$ten_min'")->count();;

        $arr5['jinri'] = $video_seven_add['online'];
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arr['time'] = $time_chuo;
        $arr['date'] = $time_data;
        $arr1['time'] = $time_chuo;
        $arr1['date'] = $time_data;
        $arr2['time'] = $time_chuo;
        $arr2['date'] = $time_data;
        $arr3['time'] = $time_chuo;
        $arr3['date'] = $time_data;
        $arr4['time'] = $time_chuo;
        $arr4['date'] = $time_data;
        $arr5['time'] = $time_chuo;
        $arr5['date'] = $time_data;


        $tz['time'] = $time_chuo;
        $tz['date'] = $time_data;
        $tz1['time'] = $time_chuo;
        $tz1['date'] = $time_data;
        $tz2['time'] = $time_chuo;
        $tz2['date'] = $time_data;
        $tz3['time'] = $time_chuo;
        $tz3['date'] = $time_data;

        M("admin_shuju_list")->where("title ='投注订单'")->save($arr);
        M("admin_shuju_list")->where("title ='投注人数'")->save($arr1);
        M("admin_shuju_list")->where("title ='投注金额'")->save($arr2);
        M("admin_shuju_list")->where("title ='投注输赢'")->save($arr3);
        M("admin_shuju_list")->where("title ='提现金额'")->save($arr4);
        M("admin_shuju_list")->where("title ='在线人数'")->save($arr5);


        M("admin_shuju_list")->where("title ='快乐100投注订单'")->save($tz);
        M("admin_shuju_list")->where("title ='快乐100投注人数'")->save($tz1);
        M("admin_shuju_list")->where("title ='快乐100投注金额'")->save($tz2);
        M("admin_shuju_list")->where("title ='快乐100投注输赢'")->save($tz3);

        $arr_list = array($arr, $arr1, $arr2, $arr3, $arr4);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：新增情趣商品详细统计
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function add_qq_shopping_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //时间戳格式
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

        $todayTimestamp = time(); // 获取当前时间戳
        $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();

        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();

        //日期格式
        $jinri_start_date = date("Y-m-d", time()) . " 00:00:00";
        $jinri_end_date = date("Y-m-d", time()) . " 23:59:59";

        $zuo_start_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
        $zuo_end_date = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

        $san_start_date = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
        $san_end_date = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳


        $zhou_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
        $zhou_end_date = date("Y-m-d H:i:s", time());

        $yue_start_date = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
        $yue_end_date = date("Y-m-d H:i:s", time());


        //查询商品订单数
        $touzhu_num['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time ")->count();
        $touzhu_num['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time ")->count();
        $touzhu_num['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time ")->count();
        $touzhu_num['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time ")->count();
        $touzhu_num['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time  ")->count();
        $touzhu_num['jilei'] = M("qq_user_shopping")->count();

        //取消订单数
        $touzhu_num1['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time and shop_type >= 3  ")->count();
        $touzhu_num1['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time and shop_type >= 3 ")->count();
        $touzhu_num1['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time and shop_type >= 3 ")->count();
        $touzhu_num1['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time and shop_type >= 3 ")->count();
        $touzhu_num1['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time and shop_type >= 3 ")->count();
        $touzhu_num1['jilei'] = M("qq_user_shopping")->where("shop_type >= 3")->count();


        //查询订单金额
        $touzhu_num2['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum("amount");
        $touzhu_num2['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum("amount");
        $touzhu_num2['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time ")->sum("amount");
        $touzhu_num2['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time  ")->sum("amount");
        $touzhu_num2['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time  ")->sum("amount");
        $touzhu_num2['jilei'] = M("qq_user_shopping")->sum("amount");


        //查询退款金额
        $touzhu_num3['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time  and shop_type >= 3")->sum("amount");
        $touzhu_num3['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time  and shop_type >= 3")->sum("amount");
        $touzhu_num3['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time and shop_type >= 3")->sum("amount");
        $touzhu_num3['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time and shop_type >= 3 ")->sum("amount");
        $touzhu_num3['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time and shop_type >= 3 ")->sum("amount");
        $touzhu_num3['jilei'] = M("qq_user_shopping")->where("shop_type >= 3")->sum("amount");

        //查询货物金额
        $touzhu_num4['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum("amount_due");
        $touzhu_num4['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum("amount_due");
        $touzhu_num4['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time ")->sum("amount_due");
        $touzhu_num4['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time ")->sum("amount_due");
        $touzhu_num4['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time  ")->sum("amount_due");
        $touzhu_num4['jilei'] = M("qq_user_shopping")->sum("amount_due");

        //查询利润金额
        $touzhu_num5['jinri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time  and shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $jinri_start_time  and $jinri_end_time and shop_type <= 2")->sum("amount_due");
        $touzhu_num5['zuori'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time  and shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zuo_start_time  and  $zuo_end_time and shop_type <= 2")->sum("amount_due");
        $touzhu_num5['sanri'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time  and shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $san_start_time  and  $san_end_time and shop_type <= 2")->sum("amount_due");
        $touzhu_num5['zhou'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time  and shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN $zhou_start_time  and $zhou_end_time and shop_type <= 2")->sum("amount_due");
        $touzhu_num5['yue'] = M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time  and shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where("UNIX_TIMESTAMP(pay_date) BETWEEN  $yue_start_time and $yue_end_time  and shop_type <= 2")->sum("amount_due");
        $touzhu_num5['jilei'] = M("qq_user_shopping")->where("shop_type <= 2")->sum("amount") - M("qq_user_shopping")->where(" shop_type <= 2")->sum("amount_due");


        //查询商品订单数
        $arr['jinri'] = $touzhu_num['jinri'];
        $arr['zuori'] = $touzhu_num['zuori'];
        $arr['sanri'] = $touzhu_num['sanri'];
        $arr['zhou'] = $touzhu_num['zhou'];
        $arr['yue'] = $touzhu_num['yue'];
        $arr['jilei'] = $touzhu_num['jilei'];

        //查询订单金额
        $arr2['jinri'] = $touzhu_num2['jinri'];
        $arr2['zuori'] = $touzhu_num2['zuori'];
        $arr2['sanri'] = $touzhu_num2['sanri'];
        $arr2['zhou'] = $touzhu_num2['zhou'];
        $arr2['yue'] = $touzhu_num2['yue'];
        $arr2['jilei'] = $touzhu_num2['jilei'];

        //取消订单数
        $arr1['jinri'] = $touzhu_num1['jinri'];
        $arr1['zuori'] = $touzhu_num1['zuori'];
        $arr1['sanri'] = $touzhu_num1['sanri'];
        $arr1['zhou'] = $touzhu_num1['zhou'];
        $arr1['yue'] = $touzhu_num1['yue'];
        $arr1['jilei'] = $touzhu_num1['jilei'];

        //查询退款金额
        $arr3['jinri'] = $touzhu_num3['jinri'];
        $arr3['zuori'] = $touzhu_num3['zuori'];
        $arr3['sanri'] = $touzhu_num3['sanri'];
        $arr3['zhou'] = $touzhu_num3['zhou'];
        $arr3['yue'] = $touzhu_num3['yue'];
        $arr3['jilei'] = $touzhu_num3['jilei'];

        //查询货物金额
        $arr4['jinri'] = $touzhu_num4['jinri'];
        $arr4['zuori'] = $touzhu_num4['zuori'];
        $arr4['sanri'] = $touzhu_num4['sanri'];
        $arr4['zhou'] = $touzhu_num4['zhou'];
        $arr4['yue'] = $touzhu_num4['yue'];
        $arr4['jilei'] = $touzhu_num4['jilei'];

        //查询货物金额
        $arr5['jinri'] = $touzhu_num5['jinri'];
        $arr5['zuori'] = $touzhu_num5['zuori'];
        $arr5['sanri'] = $touzhu_num5['sanri'];
        $arr5['zhou'] = $touzhu_num5['zhou'];
        $arr5['yue'] = $touzhu_num5['yue'];
        $arr5['jilei'] = $touzhu_num5['jilei'];


        $noe_time = time();
        $ten_min = $noe_time - (60 * 10);
       // $video_seven_add['online'] = M("user_info")->where("last_login_time>'$ten_min'")->count();;

        //$arr5['jinri'] = $video_seven_add['online'];
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $arr['time'] = $time_chuo;
        $arr['date'] = $time_data;
        $arr1['time'] = $time_chuo;
        $arr1['date'] = $time_data;
        $arr2['time'] = $time_chuo;
        $arr2['date'] = $time_data;
        $arr3['time'] = $time_chuo;
        $arr3['date'] = $time_data;
        $arr4['time'] = $time_chuo;
        $arr4['date'] = $time_data;
        $arr5['time'] = $time_chuo;
        $arr5['date'] = $time_data;


        M("admin_shuju_list")->where("title ='订单数'")->save($arr);
        M("admin_shuju_list")->where("title ='取消订单数'")->save($arr1);
        M("admin_shuju_list")->where("title ='订单金额'")->save($arr2);
        M("admin_shuju_list")->where("title ='退款金额'")->save($arr3);
        M("admin_shuju_list")->where("title ='货物金额'")->save($arr4);
        M("admin_shuju_list")->where("title ='利润'")->save($arr5);


        $arr_list = array($arr, $arr1, $arr2, $arr3, $arr4);
        $data['code'] = '200';
        $data['status'] = '1';
        $data['data'] = $arr_list;
        echo json_encode($data);
    }

    /**
     * 版本：2.0
     * 新增/更新：详细统计
     * 简述：详细统计
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function kai_detailed()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['message'] = 'token错误';
                echo json_encode($data);
                die;
            }
            //本月时间
            $benyue_start = strtotime(date('Y-m-01 00:00:00'));
            $benyue_end = strtotime(date('Y-m-t 23:59:59'));
            //上月时间
            $shangyue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 1, 1, date("Y"))));
            $shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), 0, date("Y"))));
            //上上月时间
            $shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 2, 1, date("Y"))));
            $shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 1, 0, date("Y"))));

            //上上上月时间
            $shang_shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 3, 1, date("Y"))));
            $shang_shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 2, 0, date("Y"))));

            $shang_month = date('n', $shangyue_start);
            $shang_shang_month = date('n', $shangyue_shangyue_end);
            $shang_shang_shang_month = date('n', $shang_shangyue_shangyue_end);
            $yuefen = array($shang_month, $shang_shang_month, $shang_shang_shang_month);

            //月份盈亏
            $touzhu_list = M('game_user_tongji');
            $month_num['benyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $benyue_start  and $benyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $benyue_start  and $benyue_end ")->sum("tz_yingli");
            $month_num['syue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shangyue_start  and $shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shangyue_start  and $shangyue_end ")->sum("tz_yingli");
            $month_num['ssyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end ")->sum("tz_yingli");
            $month_num['sssyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end ")->sum("tz_yingli");

            //月份提现
            $touzhu_list = M('game_user_tixian');
            $month_tixian['benyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $benyue_start  and $benyue_end  and status_ = 2 ")->sum("amount_");
            $month_tixian['syue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shangyue_start  and $shangyue_end   and status_ = 2 ")->sum("amount_");
            $month_tixian['ssyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end   and status_ = 2 ")->sum("amount_");
            $month_tixian['sssyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end   and status_ = 2 ")->sum("amount_");

            $ding = M("admin_shuju_list")->field("time,date", true)->where("title='投注订单'")->find();
            $r_shu = M("admin_shuju_list")->field("time,date", true)->where("title='投注人数'")->find();
            $jin_ = M("admin_shuju_list")->field("time,date", true)->where("title='投注金额'")->find();
            $yin_li = M("admin_shuju_list")->field("time,date", true)->where("title='投注输赢'")->find();
            $ti_xian = M("admin_shuju_list")->field("time,date", true)->where("title='提现金额'")->find();


            $luck_100_ding = M("admin_shuju_list")->field("time,date", true)->where("title='快乐100投注订单'")->find();
            $luck_100_r_shu = M("admin_shuju_list")->field("time,date", true)->where("title='快乐100投注人数'")->find();
            $luck_100_jin_ = M("admin_shuju_list")->field("time,date", true)->where("title='快乐100投注金额'")->find();
            $luck_100_yin_li = M("admin_shuju_list")->field("time,date", true)->where("title='快乐100投注输赢'")->find();
            //$luck_100_ti_xian = M("admin_shuju_list")->field("time,date", true)->where("title='提现金额'")->find();
            $arr['ding'] = $ding;
            $arr['r_shu'] = $r_shu;
            $arr['jin_'] = $jin_;
            $arr['yin_li'] = $yin_li;

            $arr['luck_100_ding'] = $luck_100_ding;
            $arr['luck_100_r_shu'] = $luck_100_r_shu;
            $arr['luck_100_jin_'] = $luck_100_jin_;
            $arr['luck_100_yin_li'] = $luck_100_yin_li;


            $arr['ti_xian'] = $ti_xian;
            $arr['month_ying'] = $month_num;
            $arr['yuefen'] = $yuefen;
            $arr['month_tixian'] = $month_tixian;
            $data['code'] = '200';
            $data['message'] = '请求成功';
            $data['data'] = $arr;
            echo json_encode($data);
        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：2.0
     * 新增/更新：情趣商品详细统计
     * 简述：情趣商品详细统计
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function qq_shopping_detailed()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['message'] = 'token错误';
                echo json_encode($data);
                die;
            }
            //本月时间
            $benyue_start = strtotime(date('Y-m-01 00:00:00'));
            $benyue_end = strtotime(date('Y-m-t 23:59:59'));
            //上月时间
            $shangyue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 1, 1, date("Y"))));
            $shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), 0, date("Y"))));
            //上上月时间
            $shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 2, 1, date("Y"))));
            $shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 1, 0, date("Y"))));

            //上上上月时间
            $shang_shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 3, 1, date("Y"))));
            $shang_shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 2, 0, date("Y"))));

            $shang_month = date('n', $shangyue_start);
            $shang_shang_month = date('n', $shangyue_shangyue_end);
            $shang_shang_shang_month = date('n', $shang_shangyue_shangyue_end);
            $yuefen = array($shang_month, $shang_shang_month, $shang_shang_shang_month);

            //月份盈亏
            $touzhu_list = M('game_user_tongji');
            $month_num['benyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $benyue_start  and $benyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $benyue_start  and $benyue_end ")->sum("tz_yingli");
            $month_num['syue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shangyue_start  and $shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shangyue_start  and $shangyue_end ")->sum("tz_yingli");
            $month_num['ssyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end ")->sum("tz_yingli");
            $month_num['sssyue_ying'] = $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end ")->sum("tz_jin") - $touzhu_list->where("UNIX_TIMESTAMP(tz_day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end ")->sum("tz_yingli");

            //月份提现
            $touzhu_list = M('game_user_tixian');
            $month_tixian['benyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $benyue_start  and $benyue_end  and status_ = 2 ")->sum("amount_");
            $month_tixian['syue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shangyue_start  and $shangyue_end   and status_ = 2 ")->sum("amount_");
            $month_tixian['ssyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end   and status_ = 2 ")->sum("amount_");
            $month_tixian['sssyue_tixian'] = $touzhu_list->where("UNIX_TIMESTAMP(pay_time)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end   and status_ = 2 ")->sum("amount_");

            $ding = M("admin_shuju_list")->field("time,date", true)->where("title='订单数'")->find();
            $q_shu = M("admin_shuju_list")->field("time,date", true)->where("title='取消订单数'")->find();
            $jin_ = M("admin_shuju_list")->field("time,date", true)->where("title='订单金额'")->find();
            $tui_jin = M("admin_shuju_list")->field("time,date", true)->where("title='退款金额'")->find();
            $huo_jin = M("admin_shuju_list")->field("time,date", true)->where("title='货物金额'")->find();
            $yin_jin = M("admin_shuju_list")->field("time,date", true)->where("title='利润'")->find();


            $arr['ding'] = $ding;
            $arr['q_shu'] = $q_shu;
            $arr['jin_'] = $jin_;
            $arr['tui_jin'] = $tui_jin;
            $arr['huo_jin'] = $huo_jin;
            $arr['yin_jin'] = $yin_jin;

            $data['code'] = '200';
            $data['message'] = '请求成功';
            $data['data'] = $arr;
            echo json_encode($data);
        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：2.0
     * 新增/更新：快乐100签到
     * 简述：详细统计
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function luck_100_sign()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['message'] = 'token错误';
                echo json_encode($data);
                die;
            }
            //本月时间
            $benyue_start = strtotime(date('Y-m-01 00:00:00'));
            $benyue_end = strtotime(date('Y-m-t 23:59:59'));
            //上月时间
            $shangyue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 1, 1, date("Y"))));
            $shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), 0, date("Y"))));
            //上上月时间
            $shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 2, 1, date("Y"))));
            $shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 1, 0, date("Y"))));

            //上上上月时间
            $shang_shang_shang_yue_start = strtotime(date("Y-m-d H:i:s", mktime(0, 0, 0, date("m") - 3, 1, date("Y"))));
            $shang_shangyue_shangyue_end = strtotime(date("Y-m-d H:i:s", mktime(23, 59, 59, date("m") - 2, 0, date("Y"))));

            $shang_month = date('n', $shangyue_start);
            $shang_shang_month = date('n', $shangyue_shangyue_end);
            $shang_shang_shang_month = date('n', $shang_shangyue_shangyue_end);
            $yuefen = array($shang_month, $shang_shang_month, $shang_shang_shang_month);

            //月份签到
            $touzhu_list = M('game_user_sign');
            $month_sing['benyue_sing_7'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $benyue_start  and $benyue_end and award  >= 1")->count("uid") ;
            $month_sing['benyue_sing_14'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $benyue_start  and $benyue_end and award  >= 2")->count("uid") ;
            $month_sing['benyue_sing_28'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $benyue_start  and $benyue_end and award  >= 3")->count("uid") ;

            $month_sing['syue_sing_7'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shangyue_start  and $shangyue_end and award  >= 1")->count("uid") ;
            $month_sing['syue_sing_14'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shangyue_start  and $shangyue_end and award  >= 2")->count("uid") ;
            $month_sing['syue_sing_28'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shangyue_start  and $shangyue_end and award  >= 3")->count("uid") ;

            $month_sing['ssyue_sing_7'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end and award  >= 1")->count("uid") ;
            $month_sing['ssyue_sing_14'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end and award  >= 2")->count("uid") ;
            $month_sing['ssyue_sing_28'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_yue_start  and $shangyue_shangyue_end and award  >= 3")->count("uid") ;

            $month_sing['sssyue_sing_7'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end and award  >= 1")->count("uid") ;
            $month_sing['sssyue_sing_14'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end and award  >= 2")->count("uid") ;
            $month_sing['sssyue_sing_28'] = $touzhu_list->where("UNIX_TIMESTAMP(day)  BETWEEN $shang_shang_shang_yue_start  and $shang_shangyue_shangyue_end and award  >= 3")->count("uid") ;


            $arr['$month_sing'] = $month_sing;
            $arr['yuefen'] = $yuefen;
            $data['code'] = '200';
            $data['message'] = '请求成功';
            $data['data'] = $arr;
            echo json_encode($data);
        } else {
            echo $this->returnData();
        }
    }
    /**
     * tianmeiluolishuju
     * @param  $templateid []
     * @return $type    消息类型
     * 抄底偷拍
     */
    public
    function admin_coins_list()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $type = $_POST['type'];  //b8e3bb6ef8747d7
            switch ($type) {
                case 'se_liao':
                    $type_name = 'se_liao';
                    $sql_name = '色情聊天';
                    $shuju_id = "1000";
                    break;
                case 'chi_gua':
                    $type_name = 'chi_gua';
                    $sql_name = '吃瓜';
                    $shuju_id = "1000";
                    break;
                case 'yuepao':
                    $type_name = 'yuepao';
                    $sql_name = '凤楼约炮';
                    $shuju_id = "0";
                    break;
                case 'hei_liao':
                    $type_name = 'hei_liao';
                    $sql_name = '黑料吃瓜';
                    $shuju_id = "1000";
                    break;
                case 'wangbao':
                    $type_name = 'wangbao';
                    $sql_name = '网曝门';
                    $shuju_id = "1000";
                    break;
                case 'su_yan':
                    $type_name = 'su_yan';
                    $sql_name = '素颜反差';
                    $shuju_id = "1000";
                    break;
                case 'fancha':
                    $type_name = 'fancha';
                    $sql_name = '素人反差';
                    $shuju_id = "1000";
                    break;
                case 'lieqi':
                    $type_name = 'lieqi';
                    $sql_name = '另类猎奇';
                    $shuju_id = "1000";
                    break;
                case 'luoli':
                    $type_name = 'luoli';
                    $sql_name = '粉嫩少女';
                    $shuju_id = "1000";
                    break;
                case 'nvzi_spa':
                    $type_name = 'nvzi_spa';
                    $sql_name = '女子SPA';
                    $shuju_id = "1000";
                    break;
                case 'dingtun':
                    $type_name = 'dingtun';
                    $sql_name = '顶臀街射';
                    $shuju_id = "1000";
                    break;
                case 'wuma_av':
                    $type_name = 'wuma_av';
                    $sql_name = '无码AV';
                    $shuju_id = "1000";
                    break;
                case 'mh':
                    $type_name = 'mh';
                    $sql_name = '成人漫画';
                    $shuju_id = "1000";
                    break;
                case 'cesuo':
                    $type_name = 'cesuo';
                    $sql_name = '厕所偷拍';
                    $shuju_id = "1000";
                    break;
                case 'chaodi':
                    $type_name = 'chaodi';
                    $sql_name = '偷拍露出';
                    $shuju_id = "1000";
                    break;
                case 'xiaoshuo':
                    $type_name = 'xiaoshuo';
                    $sql_name = '色情小说';
                    $shuju_id = "1000";
                    break;

                case 'gangtai_sanji':
                    $type_name = 'gangtai_sanji';
                    $sql_name = '港台经典三级';
                    $shuju_id = "0";
                    break;
                case 'zhanjie_nv':
                    $type_name = 'zhanjie_nv';
                    $sql_name = '嫖娼站街女';
                    $shuju_id = "0";
                    break;
                case 'jipin_setu':
                    $type_name = 'jipin_setu';
                    $sql_name = '极品色图';
                    $shuju_id = "0";
                    break;

                case 'age_18':
                    $type_name = 'age_18';
                    $sql_name = '18岁';
                    $shuju_id = "0";
                    break;
                case 'jin_3p':
                    $type_name = 'jin_3p';
                    $sql_name = '3P';
                    $shuju_id = "0";
                    break;
                case 'kou_jiao':
                    $type_name = 'kou_jiao';
                    $sql_name = '口交';
                    $shuju_id = "0";
                    break;
                case 'ysxs':
                    $type_name = 'ysxs';
                    $sql_name = '有声小说';
                    $shuju_id = "0";
                    break;
                case 'xazs':
                    $type_name = 'xazs';
                    $sql_name = '性爱知识';
                    $shuju_id = "0";
                    break;
                case 'cgx':
                    //2.37版本后只统计新加的陈冠希栏目付费，之前的不统计了
                    $type_name = 'cgx';
                    $sql_name = '陈冠希';
                    $shuju_id = "35929";
                    break;
                default:
                    echo "type error";
            }
            $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
            $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

            $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
            $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

            $todayTimestamp = time(); // 获取当前时间戳
            $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
            $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
            $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳


            $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
            $zhou_end_time = time();

            $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
            $yue_end_time = time();


            if ($type_name == 'chi_gua') {
                $chigua_list_table = M('vip_chigua');

                $arr['jinri_pay_num'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $jinri_start_time and $jinri_end_time ")->count("DISTINCT uid");
                $arr['zuori_pay_num'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $zuo_start_time  and  $zuo_end_time ")->count("DISTINCT uid");
                $arr['sanri_pay_num'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $san_start_time  and  $san_end_time ")->count("DISTINCT uid");
                $arr['zhou_pay_num'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $zhou_start_time  and $zhou_end_time  ")->count("DISTINCT uid");
                $arr['yue_pay_num'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $yue_start_time  and   $yue_end_time ")->count("DISTINCT uid");
                $arr['jilei_pay_num'] = $chigua_list_table->where("id>0 ")->count("DISTINCT uid");

                $arrs['jinri_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $jinri_start_time  and $jinri_end_time  ")->sum('take_coins') : '0';
                $arrs['zuori_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $zuo_start_time  and  $zuo_end_time  ")->sum('take_coins') : '0';
                $arrs['sanri_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $san_start_time  and  $san_end_time  ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $san_start_time  and  $san_end_time  ")->sum('take_coins') : '0';
                $arrs['zhou_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $zhou_start_time  and  $zhou_end_time  ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $zhou_start_time  and  $zhou_end_time ")->sum('take_coins') : '0';
                $arrs['yue_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) BETWEEN $yue_start_time  and  $yue_end_time ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at)  BETWEEN $yue_start_time  and  $yue_end_time  ")->sum('take_coins') : '0';
                $arrs['jilei_amount'] = $chigua_list_table->where("UNIX_TIMESTAMP(create_at) is not null  ")->sum('take_coins') ? $chigua_list_table->where("UNIX_TIMESTAMP(create_at) is not null  ")->sum('take_coins') : '0';

            } else {
                $pay_list_table = M('hj_fc_buy_record');
                $arr['jinri_pay_num'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");
                $arr['zuori_pay_num'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");
                $arr['sanri_pay_num'] = $pay_list_table->where("time BETWEEN $san_start_time  and  $san_end_time and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");
                $arr['zhou_pay_num'] = $pay_list_table->where("time BETWEEN $zhou_start_time  and $zhou_end_time  and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");
                $arr['yue_pay_num'] = $pay_list_table->where("time BETWEEN  $yue_start_time and $yue_end_time  and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");
                $arr['jilei_pay_num'] = $pay_list_table->where("id>0  and type='$type_name' and id>'$shuju_id'")->count("DISTINCT uid");

                $arrs['jinri_amount'] = $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time BETWEEN $jinri_start_time  and $jinri_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';
                $arrs['zuori_amount'] = $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';
                $arrs['sanri_amount'] = $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time  BETWEEN $san_start_time  and  $san_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';
                $arrs['zhou_amount'] = $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time  BETWEEN $zhou_start_time  and  $zhou_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';
                $arrs['yue_amount'] = $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time  BETWEEN $yue_start_time  and  $yue_end_time and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';
                $arrs['jilei_amount'] = $pay_list_table->where("time is not null  and type='$type_name' and id>'$shuju_id'")->sum('coins') ? $pay_list_table->where("time is not null  and type='$type_name' and id>'$shuju_id'")->sum('coins') : '0';

            }

            if (empty($arrs['jinri_amount'])) {
                $arrs['jinri_amount'] = "0";
            }
            if (empty($arrs['zuori_amount'])) {
                $arrs['zuori_amount'] = "0";
            }
            if (empty($arrs['sanri_amount'])) {
                $arrs['sanri_amount'] = "0";
            }
            if (empty($arrs['zhou_amount'])) {
                $arrs['zhou_amount'] = "0";
            }
            if (empty($arrs['yue_amount'])) {
                $arrs['yue_amount'] = "0";
            }
            if (empty($arrs['jilei_amount'])) {
                $arrs['jilei_amount'] = "0";
            }

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='$sql_name'")->save($arr);
            M("admin_coins_pay")->where("uploader ='$sql_name'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.0
     * @param  $templateid []
     * @return $type    消息类型
     * 隐私查询 -查信息
     */
    public
    function yinsi_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
            $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;

            $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
            $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;

            $todayTimestamp = time(); // 获取当前时间戳
            $threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
            $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
            $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳

            $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
            $zhou_end_time = time();

            $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
            $yue_end_time = time();

            $pay_list_table = M('search_info');
            $arr['jinri_pay_num'] = $pay_list_table->where("search_time BETWEEN $jinri_start_time  and $jinri_end_time and status=1 and tuikuan=0")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("search_time BETWEEN $zuo_start_time  and  $zuo_end_time and status=1 and tuikuan=0")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("search_time BETWEEN $san_start_time  and  $san_end_time and status=1 and tuikuan=0")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("search_time BETWEEN $zhou_start_time  and $zhou_end_time  and status=1 and tuikuan=0")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("search_time BETWEEN  $yue_start_time and $yue_end_time  and status=1 and tuikuan=0")->count();
            $arr['jilei_pay_num'] = $pay_list_table->where("status=1 and tuikuan=0")->count();


            $arrs['jinri_amount'] = $arr['jinri_pay_num'] * 30;
            $arrs['zuori_amount'] = $arr['zuori_pay_num'] * 30;
            $arrs['sanri_amount'] = $arr['sanri_pay_num'] * 30;
            $arrs['zhou_amount'] = $arr['zhou_pay_num'] * 30;
            $arrs['yue_amount'] = $arr['yue_pay_num'] * 30;
            $arrs['jilei_amount'] = $arr['jilei_pay_num'] * 30;

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='隐私查询'")->save($arr);
            M("admin_coins_pay")->where("uploader ='隐私查询'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * 吃瓜栏目付费
     */
    public
    function chigua_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $jinri_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')));
            $jinri_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1);

            $zuo_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
            $zuo_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

            $todayTimestamp = time(); // 获取当前时间戳
            $san_start_time = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
            $san_end_time = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳

            $zhou_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
            $zhou_end_time = date("Y-m-d H:i:s", time());

            $yue_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
            $yue_end_time = date("Y-m-d H:i:s", time());

            $pay_list_table = M('chigua_vieo_jiesuo');
            $arr['jinri_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$jinri_start_time' and '$jinri_end_time'")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$zuo_start_time' and '$zuo_end_time'")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$san_start_time' and '$san_end_time'")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$zhou_start_time' and '$zhou_end_time'")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$yue_start_time' and '$yue_end_time'")->count();
            $arr['jilei_pay_num'] = $pay_list_table->count();


            $arrs['jinri_amount'] = $pay_list_table->where("creater_at BETWEEN '$jinri_start_time' and '$jinri_end_time'")->sum('consume_coin_num') ? $pay_list_table->where("creater_at BETWEEN '$jinri_start_time'  and '$jinri_end_time'")->sum('consume_coin_num') : '0';
            $arrs['zuori_amount'] = $pay_list_table->where("creater_at BETWEEN '$zuo_start_time' and  '$zuo_end_time'")->sum('consume_coin_num') ? $pay_list_table->where("creater_at BETWEEN '$zuo_start_time'  and  '$zuo_end_time'")->sum('consume_coin_num') : '0';
            $arrs['sanri_amount'] = $pay_list_table->where("creater_at BETWEEN '$san_start_time' and  '$san_end_time'")->sum('consume_coin_num') ? $pay_list_table->where("creater_at BETWEEN '$san_start_time'  and  '$san_end_time'")->sum('consume_coin_num') : '0';
            $arrs['zhou_amount'] = $pay_list_table->where("creater_at BETWEEN '$zhou_start_time' and '$zhou_end_time'")->sum('consume_coin_num') ? $pay_list_table->where("creater_at BETWEEN '$zhou_start_time'  and '$zhou_end_time'")->sum('consume_coin_num') : '0';
            $arrs['yue_amount'] = $pay_list_table->where("creater_at BETWEEN '$yue_start_time' and '$yue_end_time'")->sum('consume_coin_num') ? $pay_list_table->where("creater_at BETWEEN  '$yue_start_time' and '$yue_end_time'")->sum('consume_coin_num') : '0';
            $arrs['jilei_amount'] = $pay_list_table->sum('consume_coin_num') ? $pay_list_table->sum('consume_coin_num') : '0';

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='吃瓜'")->save($arr);
            M("admin_coins_pay")->where("uploader ='吃瓜'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * 短信轰炸付费
     */
    public
    function sms_hongzha_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $jinri_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')));
            $jinri_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1);

            $zuo_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
            $zuo_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

            $todayTimestamp = time(); // 获取当前时间戳
            $san_start_time = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
            $san_end_time = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳

            $zhou_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
            $zhou_end_time = date("Y-m-d H:i:s", time());

            $yue_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
            $yue_end_time = date("Y-m-d H:i:s", time());

            $pay_list_table = M('sms_hongzha');
            $arr['jinri_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and status_=2")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$zuo_start_time' and '$zuo_end_time' and status_=2")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$san_start_time' and '$san_end_time' and status_=2")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("creater_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and status_=2")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("creater_at BETWEEN  '$yue_start_time' and '$yue_end_time' and status_=2")->count();
            $arr['jilei_pay_num'] = $pay_list_table->where("status_=2")->count();


            $arrs['jinri_amount'] = $pay_list_table->where("creater_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and status_=2")->sum('coin_num') ? $pay_list_table->where("creater_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and status_=2")->sum('coin_num') : '0';
            $arrs['zuori_amount'] = $pay_list_table->where("creater_at BETWEEN '$zuo_start_time' and '$zuo_end_time' and status_=2")->sum('coin_num') ? $pay_list_table->where("creater_at BETWEEN '$zuo_start_time' and '$zuo_end_time' and status_=2")->sum('coin_num') : '0';
            $arrs['sanri_amount'] = $pay_list_table->where("creater_at BETWEEN '$san_start_time' and '$san_end_time' and status_=2")->sum('coin_num') ? $pay_list_table->where("creater_at BETWEEN '$san_start_time' and '$san_end_time' and status_=2")->sum('coin_num') : '0';
            $arrs['zhou_amount'] = $pay_list_table->where("creater_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and status_=2")->sum('coin_num') ? $pay_list_table->where("creater_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and status_=2")->sum('coin_num') : '0';
            $arrs['yue_amount'] = $pay_list_table->where("creater_at BETWEEN  '$yue_start_time' and '$yue_end_time' and status_=2")->sum('coin_num') ? $pay_list_table->where("creater_at BETWEEN '$yue_start_time' and '$yue_end_time' and status_=2")->sum('coin_num') : '0';
            $arrs['jilei_amount'] = $pay_list_table->where("status_=2")->sum('coin_num') ? $pay_list_table->where("status_=2")->sum('coin_num') : '0';

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='短信轰炸'")->save($arr);
            M("admin_coins_pay")->where("uploader ='短信轰炸'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.39
     * @param  $templateid []
     * @return $type    消息类型
     * 字母圈付费
     */
    public
    function zimu_quan_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $jinri_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')));
            $jinri_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1);

            $zuo_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
            $zuo_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

            $todayTimestamp = time(); // 获取当前时间戳
            $san_start_time = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
            $san_end_time = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳

            $zhou_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
            $zhou_end_time = date("Y-m-d H:i:s", time());

            $yue_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
            $yue_end_time = date("Y-m-d H:i:s", time());

            $pay_list_table = M('zimuquan_jiesuo');
            $arr['jinri_pay_num'] = $pay_list_table->where("jiesuo_date BETWEEN '$jinri_start_time' and '$jinri_end_time'")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("jiesuo_date BETWEEN '$zuo_start_time' and '$zuo_end_time'")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("jiesuo_date BETWEEN '$san_start_time' and '$san_end_time'")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("jiesuo_date BETWEEN '$zhou_start_time' and '$zhou_end_time'")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("jiesuo_date BETWEEN  '$yue_start_time' and '$yue_end_time'")->count();
            $arr['jilei_pay_num'] = $pay_list_table->count();


            $arrs['jinri_amount'] = $pay_list_table->where("jiesuo_date BETWEEN '$jinri_start_time' and '$jinri_end_time'")->sum('coins') ? $pay_list_table->where("jiesuo_date BETWEEN '$jinri_start_time' and '$jinri_end_time'")->sum('coins') : '0';
            $arrs['zuori_amount'] = $pay_list_table->where("jiesuo_date BETWEEN '$zuo_start_time' and '$zuo_end_time'")->sum('coins') ? $pay_list_table->where("jiesuo_date BETWEEN '$zuo_start_time' and '$zuo_end_time'")->sum('coins') : '0';
            $arrs['sanri_amount'] = $pay_list_table->where("jiesuo_date BETWEEN '$san_start_time' and '$san_end_time'")->sum('coins') ? $pay_list_table->where("jiesuo_date BETWEEN '$san_start_time' and '$san_end_time'")->sum('coins') : '0';
            $arrs['zhou_amount'] = $pay_list_table->where("jiesuo_date BETWEEN '$zhou_start_time' and '$zhou_end_time'")->sum('coins') ? $pay_list_table->where("jiesuo_date BETWEEN '$zhou_start_time' and '$zhou_end_time'")->sum('coins') : '0';
            $arrs['yue_amount'] = $pay_list_table->where("jiesuo_date BETWEEN  '$yue_start_time' and '$yue_end_time'")->sum('coins') ? $pay_list_table->where("jiesuo_date BETWEEN '$yue_start_time' and '$yue_end_time'")->sum('coins') : '0';
            $arrs['jilei_amount'] = $pay_list_table->sum('coins') ? $pay_list_table->sum('coins') : '0';

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='字母圈'")->save($arr);
            M("admin_coins_pay")->where("uploader ='字母圈'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * qq群付费   ---解锁
     */
    public
    function qq_group_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $jinri_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')));
            $jinri_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1);

            $zuo_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
            $zuo_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

            $todayTimestamp = time(); // 获取当前时间戳
            $san_start_time = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
            $san_end_time = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳

            $zhou_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
            $zhou_end_time = date("Y-m-d H:i:s", time());

            $yue_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
            $yue_end_time = date("Y-m-d H:i:s", time());

            $pay_list_table = M('qq_group_unlock');
            $arr['jinri_pay_num'] = $pay_list_table->where("un_lock_at BETWEEN '$jinri_start_time' and '$jinri_end_time'")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("un_lock_at BETWEEN '$zuo_start_time' and '$zuo_end_time'")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("un_lock_at BETWEEN '$san_start_time' and '$san_end_time'")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("un_lock_at BETWEEN '$zhou_start_time' and '$zhou_end_time'")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("un_lock_at BETWEEN '$yue_start_time' and '$yue_end_time'")->count();
            $arr['jilei_pay_num'] = $pay_list_table->count();


            $arrs['jinri_amount'] = $pay_list_table->where("un_lock_at BETWEEN '$jinri_start_time' and '$jinri_end_time'")->sum('cion_num') ? $pay_list_table->where("un_lock_at BETWEEN '$jinri_start_time' and '$jinri_end_time'")->sum('cion_num') : '0';
            $arrs['zuori_amount'] = $pay_list_table->where("un_lock_at BETWEEN '$zuo_start_time' and  '$zuo_end_time'")->sum('cion_num') ? $pay_list_table->where("un_lock_at BETWEEN '$zuo_start_time' and '$zuo_end_time'")->sum('cion_num') : '0';
            $arrs['sanri_amount'] = $pay_list_table->where("un_lock_at BETWEEN '$san_start_time' and  '$san_end_time'")->sum('cion_num') ? $pay_list_table->where("un_lock_at BETWEEN '$san_start_time' and '$san_end_time'")->sum('cion_num') : '0';
            $arrs['zhou_amount'] = $pay_list_table->where("un_lock_at BETWEEN '$zhou_start_time' and '$zhou_end_time'")->sum('cion_num') ? $pay_list_table->where("un_lock_at BETWEEN '$zhou_start_time' and '$zhou_end_time'")->sum('cion_num') : '0';
            $arrs['yue_amount'] = $pay_list_table->where("un_lock_at BETWEEN '$yue_start_time' and '$yue_end_time'")->sum('cion_num') ? $pay_list_table->where("un_lock_at BETWEEN '$yue_start_time' and '$yue_end_time'")->sum('cion_num') : '0';
            $arrs['jilei_amount'] = $pay_list_table->sum('cion_num') ? $pay_list_table->sum('cion_num') : '0';

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='qq群付费'")->save($arr);
            M("admin_coins_pay")->where("uploader ='qq群付费'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * 付费亚洲   ---3金币解锁的亚洲视频
     * 以及后加的3金币栏目
     */
    public
    function fufei_yazhou_shuju()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $type = $_POST['type'];  //b8e3bb6ef8747d7
            switch ($type) {
                case '经典AV':
                    $type_name = '付费亚洲';
                    $sql_name = '经典AV';
                    break;
                case '厕所偷拍':
                    $type_name = '厕所偷拍';
                    $sql_name = '厕所偷拍';
                    break;
                case '网曝门':
                    $type_name = '网曝门';
                    $sql_name = '网曝门';
                    break;
                case '粉嫩少女':
                    $type_name = '粉嫩少女';
                    $sql_name = '粉嫩少女';
                    break;
                case '另类猎奇':
                    $type_name = '另类猎奇';
                    $sql_name = '另类猎奇';
                    break;
                case '顶臀街射':
                    $type_name = '顶臀街射';
                    $sql_name = '顶臀街射';
                    break;
                case '女子SPA':
                    $type_name = '女子SPA';
                    $sql_name = '女子SPA';
                    break;
                case '素人反差':
                    $type_name = '素人反差';
                    $sql_name = '素人反差';
                    break;
                case '抄底偷拍':
                    $type_name = '抄底偷拍';
                    $sql_name = '抄底偷拍';
                    break;
                default:
                    echo "type error";
            }
            $jinri_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')));
            $jinri_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1);

            $zuo_start_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
            $zuo_end_time = date("Y-m-d H:i:s", mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1);

            $todayTimestamp = time(); // 获取当前时间戳
            $san_start_time = date("Y-m-d H:i:s", strtotime('midnight', strtotime('-3 days', $todayTimestamp))); // 获取三天前的0点时间戳
            $san_end_time = date("Y-m-d H:i:s", strtotime('23:59:59', strtotime('-1 day', $todayTimestamp))); // 获取前天的23:59:59时间戳

            $zhou_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00"));
            $zhou_end_time = date("Y-m-d H:i:s", time());

            $yue_start_time = date("Y-m-d H:i:s", strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00"));
            $yue_end_time = date("Y-m-d H:i:s", time());

            $pay_list_table = M('free_riben_jiesuo');
            $arr['jinri_pay_num'] = $pay_list_table->where("create_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and uploader='$sql_name'")->count();
            $arr['zuori_pay_num'] = $pay_list_table->where("create_at BETWEEN '$zuo_start_time' and '$zuo_end_time' and uploader='$sql_name'")->count();
            $arr['sanri_pay_num'] = $pay_list_table->where("create_at BETWEEN '$san_start_time' and '$san_end_time' and uploader='$sql_name'")->count();
            $arr['zhou_pay_num'] = $pay_list_table->where("create_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and uploader='$sql_name'")->count();
            $arr['yue_pay_num'] = $pay_list_table->where("create_at BETWEEN '$yue_start_time' and '$yue_end_time' and uploader='$sql_name'")->count();
            $arr['jilei_pay_num'] = $pay_list_table->where("uploader='$sql_name'")->count();


            $arrs['jinri_amount'] = $pay_list_table->where("create_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("create_at BETWEEN '$jinri_start_time' and '$jinri_end_time' and uploader='$sql_name'")->sum('take_coin') : '0';
            $arrs['zuori_amount'] = $pay_list_table->where("create_at BETWEEN '$zuo_start_time' and  '$zuo_end_time' and uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("create_at BETWEEN '$zuo_start_time' and '$zuo_end_time' and uploader='$sql_name'")->sum('take_coin') : '0';
            $arrs['sanri_amount'] = $pay_list_table->where("create_at BETWEEN '$san_start_time' and  '$san_end_time' and uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("create_at BETWEEN '$san_start_time' and '$san_end_time' and uploader='$sql_name'")->sum('take_coin') : '0';
            $arrs['zhou_amount'] = $pay_list_table->where("create_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("create_at BETWEEN '$zhou_start_time' and '$zhou_end_time' and uploader='$sql_name'")->sum('take_coin') : '0';
            $arrs['yue_amount'] = $pay_list_table->where("create_at BETWEEN '$yue_start_time' and '$yue_end_time' and uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("create_at BETWEEN '$yue_start_time' and '$yue_end_time' and uploader='$sql_name'")->sum('take_coin') : '0';
            $arrs['jilei_amount'] = $pay_list_table->where("uploader='$sql_name'")->sum('take_coin') ? $pay_list_table->where("uploader='$sql_name'")->sum('take_coin') : '0';

            $time_chuo = time();
            $time_data = date("Y-m-d H:i", $time_chuo);
            $arrs['time'] = $time_chuo;
            $arrs['date'] = $time_data;
            M("admin_coins_pay")->where("uploader ='$type_name'")->save($arr);
            M("admin_coins_pay")->where("uploader ='$type_name'")->save($arrs);
            $arr_list = array($arr, $arrs);

            $data['code'] = '200';
            $data['status'] = '1';
            $data['data'] = $arr_list;

            echo json_encode($data);

        } else {
            echo $this->returnData();
        }
    }


    /**
     * 版本：
     * 新增/更新：
     * 简述：更新安卓和ios后台新增和用户的活跃
     * @param  $templateid []
     * @return $type    消息类型
     */
    public
    function qudao_huoyue_renshu_shuju()
    {
        set_time_limit(0);
        ini_set('memory_limit', '1000M');
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        //今日时间
        $jinri_start_time = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        $jinri_end_time = mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')) - 1;
        //昨日时间
        $zuo_start_time = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
        $zuo_end_time = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - 1;
        $todayTimestamp = time(); // 获取当前时间戳
        //三日时间
        $san_start_time = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
        $san_end_time = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳

        //周时间
        $zhou_start_time = strtotime(date("Y-m-d", strtotime("-1 week")) . "00:00:00");
        $zhou_end_time = time();
        //月时间
        $yue_start_time = strtotime(date("Y-m-d", strtotime("-1 month")) . "00:00:00");
        $yue_end_time = time();
        //android用户新增
        $user_info_list = M('user_info');
        $android_arr['jinri'] = $user_info_list->where("device_type='android' and add_time BETWEEN $jinri_start_time  and $jinri_end_time ")->count();
        $android_arr['zuori'] = $user_info_list->where("device_type='android' and add_time BETWEEN $zuo_start_time  and  $zuo_end_time ")->count();
        $android_arr['sanri'] = $user_info_list->where("device_type='android' and add_time BETWEEN $san_start_time  and  $san_end_time")->count();
        $android_arr['zhou'] = $user_info_list->where("device_type='android' and add_time BETWEEN $zhou_start_time  and $zhou_end_time ")->count();
        $android_arr['yue'] = $user_info_list->where("device_type='android' and add_time BETWEEN  $yue_start_time and $yue_end_time")->count();
        $android_arr['jilei'] = $user_info_list->where("device_type='android'")->count();

        //ios用户新增
        $ios_arr['jinri'] = $user_info_list->where("device_type='ios' and add_time BETWEEN $jinri_start_time  and $jinri_end_time ")->count();
        $ios_arr['zuori'] = $user_info_list->where("device_type='ios' and add_time BETWEEN $zuo_start_time  and  $zuo_end_time ")->count();
        $ios_arr['sanri'] = $user_info_list->where("device_type='ios' and add_time BETWEEN $san_start_time  and  $san_end_time")->count();
        $ios_arr['zhou'] = $user_info_list->where("device_type='ios' and add_time BETWEEN $zhou_start_time  and $zhou_end_time ")->count();
        $ios_arr['yue'] = $user_info_list->where("device_type='ios' and add_time BETWEEN  $yue_start_time and $yue_end_time")->count();
        $ios_arr['jilei'] = $user_info_list->where("device_type='ios'")->count();

        //android用户活跃
        $android_huoyue_jin = M("huoyue_list")->where("time>$jinri_start_time  and device_type='android'")->field("uid")->group("uid")->select();
        $android_huoyue_zuo = M("huoyue_list")->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and device_type='android'")->field("uid")->group("uid")->select();
        $android_huoyue_san = M("huoyue_list")->where("time BETWEEN $san_start_time  and  $san_end_time and device_type='android'  ")->field("uid")->group("uid")->select();;
        $android_huoyue_zhou = M("huoyue_list")->where(" time BETWEEN $zhou_start_time  and $zhou_end_time and device_type='android' ")->field("uid")->group("uid")->select();
        $android_huoyue_yue = M("huoyue_list")->where(" time BETWEEN  $yue_start_time and $yue_end_time and device_type='android'")->field("uid")->group("uid")->select();
        $android_huoyue_jilei = $user_info_list->where("last_login_time is not null and device_type='android'")->field("id")->select();

        $android_arrs['jinri'] = count($android_huoyue_jin);
        $android_arrs['zuori'] = count($android_huoyue_zuo);
        $android_arrs['sanri'] = count($android_huoyue_san);
        $android_arrs['zhou'] = count($android_huoyue_zhou);
        $android_arrs['yue'] = count($android_huoyue_yue);
        $android_arrs['jilei'] = count($android_huoyue_jilei);

        //ios用户活跃
        $ios_huoyue_jin = M("huoyue_list")->where("time>$jinri_start_time and device_type='ios'")->field("uid")->group("uid")->select();
        $ios_huoyue_zuo = M("huoyue_list")->where("time BETWEEN $zuo_start_time  and  $zuo_end_time and device_type='ios'")->field("uid")->group("uid")->select();
        $ios_huoyue_san = M("huoyue_list")->where("time BETWEEN $san_start_time  and  $san_end_time and device_type='ios'  ")->field("uid")->group("uid")->select();;
        $ios_huoyue_zhou = M("huoyue_list")->where(" time BETWEEN $zhou_start_time  and $zhou_end_time and device_type='ios' ")->field("uid")->group("uid")->select();
        $ios_huoyue_yue = M("huoyue_list")->where(" time BETWEEN  $yue_start_time and $yue_end_time and device_type='ios'")->field("uid")->group("uid")->select();
        $ios_huoyue_jilei = $user_info_list->where("last_login_time is not null and device_type='ios'")->field("id")->select();

        $ios_arrs['jinri'] = count($ios_huoyue_jin);
        $ios_arrs['zuori'] = count($ios_huoyue_zuo);
        $ios_arrs['sanri'] = count($ios_huoyue_san);
        $ios_arrs['zhou'] = count($ios_huoyue_zhou);
        $ios_arrs['yue'] = count($ios_huoyue_yue);
        $ios_arrs['jilei'] = count($ios_huoyue_jilei);
//        $arrs['zuori'] ='维护中';
//        $arrs['sanri'] = '维护中';
//        $arrs['zhou'] ='维护中';
//        $arrs['yue'] ='维护中';
//        $arrs['jilei'] ='维护中';
        $time_chuo = time();
        $time_data = date("Y-m-d H:i", $time_chuo);
        $android_arr['time'] = $time_chuo;
        $android_arr['date'] = $time_data;
        $android_arrs['time'] = $time_chuo;
        $android_arrs['date'] = $time_data;
        $ios_arr['time'] = $time_chuo;
        $ios_arr['date'] = $time_data;
        $ios_arrs['time'] = $time_chuo;
        $ios_arrs['date'] = $time_data;
        M("admin_shuju_list")->where("title ='android新增'")->save($android_arr);
        M("admin_shuju_list")->where("title ='android活跃'")->save($android_arrs);
        M("admin_shuju_list")->where("title ='ios新增'")->save($ios_arr);
        M("admin_shuju_list")->where("title ='ios活跃'")->save($ios_arrs);
        $data['code'] = '200';
        $data['status'] = '1';
        $arr_all = array($android_arr, $ios_arrs);
        $data['data'] = $arr_all;
        echo json_encode($data);
    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * 短信轰炸判断结束时间
     */
    public
    function smsHongzha_endtime()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        set_time_limit(0);
        for ($i = 1; $i <= 12; $i++) {
            if (!empty($_POST)) {
                $token = $_POST['token'];  //b8e3bb6ef8747d7
                if ($token != 'b8e3bb6ef8747d7') {
                    $data['code'] = '203';
                    $data['msg'] = 'token错误';
                    echo json_encode($data);
                    die;
                }
                $now_date = date("Y-m-d H:i", time());
                $sms = M("sms_hongzha")->where("status_=1")->select();
                if ($sms) {
                    foreach ($sms as $k => $v) {
                        if ($v['end_time'] < $now_date) {
                            //超出时间，状态修改为结束
                            M("sms_hongzha")->where("id={$v['id']}")->save(array("status_" => 2));
                        } else {
                            continue;
                        }
                    }
                } else {
                    die;
                }
            }
            sleep(4);
        }
    }


//    /**
//     * 2.1
//     * @param  $templateid []
//     * @return $type    消息类型
//     * 打款
//     * 满50会自动进入待打款订单
//     */
//    public function  user_to_dakuan()
//    {
//        header('Content-Type:text/json;charset=utf-8');
//        header('Access-Control-Allow-Origin:*');
//        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
//        header('Access-Control-Allow-Methods:POST');
//        header('Access-Control-Expose-Headers:*');
//            if (!empty($_POST)) {
//                $token = $_POST['token'];  //b8e3bb6ef8747d7
//                if ($token != 'b8e3bb6ef8747d7') {
//                    $data['code'] = '203';
//                    $data['msg'] = 'token错误';
//                    echo json_encode($data);
//                    die;
//                }
//                $daidakuan=M("user_info")->field("id,name")->where("balance>=50")->select();
//                if ($daidakuan){
//                   foreach ($daidakuan as $k=>$v){
//                       $arr['uid']=$v['id'];
//                       $arr['amount_']="50";
////                       $name=$v['name'];
//                       $arr['apply_time']=date("Y-m-d H:i:s",time());
//                       $arr['status_']="1";
//                       M("dy_ks_tixian")->add($arr);
//                       M("user_info")->where(array("id"=>$v['id']))->setDec("balance",50);
////                       $this->send_msg_to_telegram("6543542631:AAGRvYWAXAk4VV45yEHtQY3mG8h13MhLT-k","-4190639794",$name);
//                   }
//            }else{
//                    die;
//                }
//            }
//            }


//    protected function send_msg_to_telegram($botToken,$chatId,$name)
//    {
//        $website = "https://api.telegram.org/bot".$botToken;
//        $text = "抖快打款🧧🧧🧧
//9169用户：$name
//完成多个抖快任务
//提现金额50元\n
//请尽快给用户发送口令红包打款";
//        $params = [
//            'chat_id' => $chatId,
//            'text' => $text
//        ];
//        $ch = curl_init($website . '/sendMessage');
//        curl_setopt($ch, CURLOPT_HEADER, false);
//        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
//        curl_setopt($ch, CURLOPT_POST, 1);
//        curl_setopt($ch, CURLOPT_POSTFIELDS, ($params));
//        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
//        $result = curl_exec($ch);
//        if ($result === false) {
//            // 如果请求失败，获取错误信息
//            $error = curl_error($ch);
//            $error_code = curl_errno($ch);
//            // 输出错误信息
//            curl_close($ch);
//            return $error;
//        }
//        curl_close($ch);
//        if ($result !== false) {
//            // 如果请求成功，你可以对结果进行处理
//           echo "success";
//        }
//    }


    /**
     * 2.1
     * @param  $templateid []
     * @return $type    消息类型
     * 打款
     * 用户口令红包的领取状态24小时后自动修改为完成
     */
    public
    function kouling_save_end()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');
        if (!empty($_POST)) {
            $token = $_POST['token'];  //b8e3bb6ef8747d7
            if ($token != 'b8e3bb6ef8747d7') {
                $data['code'] = '203';
                $data['msg'] = 'token错误';
                echo json_encode($data);
                die;
            }
            $ersi_date = date("Y-m-d H:i:s", strtotime("-1 days"));
            //查询已超过二十四小时的口令红包
            $arr = M("dy_ks_tixian")->field("id")->where("pay_time<='$ersi_date' and status_=3")->select();
            if ($arr) {
                foreach ($arr as $k => $v) {
                    M("dy_ks_tixian")->where(array("id" => $v['id']))->save(array("status_" => 5));
                }
            } else {
                die;
            }
        }
    }

    //把原先的牛逼改成吃瓜
    public
    function saveChiGuaNiubi()
    {
        M("upload_videos_list")->where("uploader='牛逼'")->save(array("uploader" => "吃瓜"));
        M("video_list_test")->where("uploader='牛逼'")->save(array("uploader" => "吃瓜"));
        echo "执行成功";
    }

    //代理佣金
    //如果代理6月的佣金不足200，就会自动累计到7月，不会显示在代打款里
    //每月1号零点执行
    public
    function daili_yongjin_hebing()
    {
        //查询上月佣金小于200的代理
        //上月日期
        $last_month = date("Y-m", strtotime("-1 month"));
        $this_month = date("Y-m", strtotime("-1 month"));
        $lt_erbai = M("user_proxy_month")->where("uid is not null and yongjin_all<200 and date_month='$last_month'")->select();
        if ($lt_erbai) {
            $nowdate = date("Y-m-d H:i:s", time());
            foreach ($lt_erbai as $k => $v) {
                //查询本月有没有数据
                $this_month_have = M("user_proxy_month")->where(array("uid" => $v['uid'], "date_month" => $this_month))->find();
                if ($this_month_have) {
                    $jia['yongjin_all'] = $v['yongjin_all'] + $this_month_have['yongjin_all'];
                    $jia['renshu_all'] = $v['renshu_all'] + $this_month_have['renshu_all'];
                    $jia['chognzhi_all'] = $v['chognzhi_all'] + $this_month_have['chognzhi_all'];
                    $jia['last_update'] = $nowdate;
                    M("user_proxy_month")->where(array("id" => $this_month_have['id']))->save($jia);
                    M("user_proxy_month")->where(array("id" => $v['id']))->delete();
                } else {
                    M("user_proxy_month")->where(array("id" => $v['id']))->save(array("date_month" => $this_month, "last_update" => $nowdate));
                }
            }
        } else {
            die("暂无数据");
        }

    }

    /**********************************************  华丽的分割线（幸运动物园）******************************************************/
    /**
     * 幸运游戏，开奖后限定用户提现规则测试函数，勿动
     * @return void
     */
    public
    function test_bet_game()
    {
        header('Content-Type:text/json;charset=utf-8');
        header('Access-Control-Allow-Origin:*');
        header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
        header('Access-Control-Allow-Methods:POST');
        header('Access-Control-Expose-Headers:*');

        $uid = $_POST["uid"]; //用户id
        $qishu = $_POST['qishu'];//当期-期数
        $this->kai_jiang($uid, $qishu);


        $data['code'] = '200';
        $data['message'] = 'ok';
        echo json_encode($data);
    }


    /**
     * 开奖结果刷新提现限制：
     *  开奖后统计非当期提现额度，如果累计盈利小于=0，刷新当期投注的批次号为信的批次号
     * @return void
     */
    public
    function kai_jiang($uid, $qishu)
    {

        //生成uuid
        $uuid = $this->generateUUIDv4();

        if (empty($qishu)) {
            // $this->returnDataAndSendMsg("当前期数不能为空");
            // die();
            return;
        }
        $is_touzhu = M("game_bet_touzhu")->field("id,tx_batch")->where("uid='$uid' AND qishu_id='$qishu'")->order("id DESC")->find();
        if (empty($is_touzhu)) {
            //本期没有投注
            return;
        }

        //最后一个批次号
        $shangqi_batch = M("game_bet_touzhu")->field("id,tx_batch,qishu_id")->where("uid='$uid' AND tx_batch is NOT NULL AND tx_batch!=''")->order("id DESC")->find();
        if (empty($shangqi_batch)) {

            //本期有投注
            $this->upload_batch_for_u($uid, $qishu, $uuid);
            $keti_jin = M("game_bet_touzhu")->where("tx_batch='$uuid' AND yingli>0")->sum('yingli');//为防止脏数据重新计算
            $this->set_tx_count($uid, $uuid, 0, 0, $keti_jin);
//            $data['code'] = '200';
//            $data['message'] = 'ok';
//            echo json_encode($data);
//            die();
            return;
        }

        if ($shangqi_batch['qishu_id'] == $qishu) {
            //重复处理
            return;
        }

        //提现批次号
        $tx_batch_no = $shangqi_batch["tx_batch"];
        //累加批次号流水，如果大于0则刷新可提现金额（继续累加），小于等于0则从新生成批次
        $touzhuAmount = M("game_bet_touzhu")->where("tx_batch='$tx_batch_no'")->sum('touzhu_jin'); //非本期投注总金额
        $totalAmount = M("game_bet_touzhu")->where("tx_batch='$tx_batch_no' AND yingli>0")->sum('yingli');  //非本期盈利总金额
        $back_totalAmount = $totalAmount;
        $totalAmount = $totalAmount - $touzhuAmount;
        if ($totalAmount <= 0) {
            //还需判断本期是否是赢，本期赢的需要刷新可提金额
            $currut_Amount_total = M("game_bet_touzhu")->where("uid='$uid' AND qishu_id='$qishu' AND yingli>0")->sum('yingli');
            //上期预留额度
            $tx_count_info = M("game_user_tixian_count")->where("uid='$uid' AND tx_batch_no='$tx_batch_no'")->find();
            if (!empty($tx_count_info)) {
                $pre_erdu = $tx_count_info["can_tixian"];
                $currut_Amount_total = $currut_Amount_total + $pre_erdu;
            }

            $this->upload_batch_for_u($uid, $qishu, $uuid);
            $this->set_tx_count($uid, $uuid, 0, empty($tx_count_info) ? 0 : $tx_count_info["tx_count"], $currut_Amount_total);
//            $data['code'] = '200';
//            $data['message'] = 'ok';
//            echo json_encode($data);
//            die();
            return;
        }

        //>0则用户直接给用户累加可提现金额
        $this->upload_batch_for_u($uid, $qishu, $tx_batch_no);
        //还需判断本期是否是赢，本期赢的需要刷新可提金额
        $keti_jin = M("game_bet_touzhu")->where("tx_batch='$tx_batch_no'  AND yingli>0")->sum('yingli');//为防止脏数据重新计算
        $tx_count_info = M("game_user_tixian_count")->where("uid='$uid' AND game_type='0'")->find(); //用户提现汇总
        $tx_count = $tx_count_info["tx_count"]; //用户提现汇总
        $tx_can_tx = $tx_count_info["can_tixian"]; //用可提现
        if ($keti_jin <= 0) {
            $keti_jin = 0;
            $this->set_tx_count($uid, $tx_batch_no, 0, 0, $keti_jin);
        } else {
            if ($tx_can_tx - $back_totalAmount > 0) //上期预留额度（延续清0值的可提现金额）
            {
                $keti_jin = $keti_jin + $tx_can_tx - $back_totalAmount;
            }
            $this->set_tx_count($uid, $tx_batch_no, 0, $tx_count, $keti_jin);
        }


//        $data['code'] = '200';
//        $data['message'] = 'ok';
//        echo json_encode($data);
    }

    protected
    function generateUUIDv4()
    {
        $data = random_bytes(16);
        $data[6] = chr(ord($data[6]) & 0x0f | 0x40); // Set version to 0100
        $data[8] = chr(ord($data[8]) & 0x3f | 0x80); // Set bits 6-7 to 10
        return vsprintf('%s%s-%s-%s-%s-%s%s%s', str_split(bin2hex($data), 4));
    }

    /**
     * 刷新用户当期批次号
     * @param $uid
     * @param $qishu
     * @param $uuid
     * @return void
     */
    private
    function upload_batch_for_u($uid, $qishu_id, $uuid)
    {
        $updateData['tx_batch'] = $uuid;
        $list_touzhu_info = M("game_bet_touzhu")->field("id")->where("uid='$uid' AND qishu_id='$qishu_id'")->select();
        foreach ($list_touzhu_info as $key => $value) {
            M("game_bet_touzhu")->where("uid='$uid' AND qishu_id='$qishu_id'")->save($updateData);
        }
    }

    /**
     *  清空提现汇总表
     * @param $uid
     * @param $uuid
     * @return void
     */
    private
    function set_tx_count($uid, $uuid, $game_type, $tx_count, $can_tixian)
    {
        //设置用户提现’额度，并清空提现汇总
        $tx_count_info = M("game_user_tixian_count")->where("uid='$uid' AND game_type='$game_type'")->field("id")->find();

        $save_info['uid'] = $uid;
        $save_info['game_type'] = $game_type;//游戏类型：幸运动物园
        $save_info['tx_count'] = empty($tx_count) ? 0 : $tx_count; //提现累计汇总清0
        $save_info['tx_batch_no'] = $uuid; //设置批次号
        $save_info['can_tixian'] = empty($can_tixian) || $can_tixian < 0 ? 0 : $can_tixian;
        $save_info['last_update'] = date('Y-m-d H:i:s');
        if (empty($tx_count_info)) {
            M("game_user_tixian_count")->add($save_info);
            return;
        }
        M("game_user_tixian_count")->where("uid='$uid'")->save($save_info);
    }

    /**********************************************  华丽的分割线（幸运动物园）******************************************************/
}