public function stats(){
        $this->Style->admin_header_new("Статистика");

        $start = '2018-01-01';
        $end = date("Y-m-d");

        $stats = array();

        foreach( array_reverse($this->createDateRangeArray( $start, $end )) as $v )
        {
            $stats[ $v ] = array(
                'users' => 0, 'payments' => 0, 'paids' => 0, 'games' => 0, 'wins' => 0, 'loosed' => 0, 'paids_count' => 0, 'payments_count' => 0
            );
        }

        $total = array(
            'users' => 0, 'payments' => 0, 'paids' => 0, 'games' => 0, 'wins' => 0, 'loosed' => 0, 'paids_count' => 0, 'payments_count' => 0
        );

        $q = $this->db->query("SELECT count(id) as new_users, cast( joined as date) as date FROM `users` where joined > '2018' group by dayofyear( joined )");

        foreach( $q->result_array() as $v )
        {
            if( !isset($stats[$v['date']]) ) continue;

            $total['users'] += $stats[ $v['date'] ]['users'] = $v['new_users'];
        }

        $q = $this->db->query("SELECT COUNT( id ) as paids, SUM( summ ) as withdraw, CAST( payed AS DATE ) as date FROM  `paids` where is_payed >= 1 && is_payed <= 2 and payed > '2018' GROUP BY DAYOFYEAR( payed ) ");

        foreach( $q->result_array() as $v )
        {
            if( !isset($stats[$v['date']]) ) continue;

            $total['paids_count'] += $stats[ $v['date'] ]['paids_count'] = $v['paids'];
            $total['paids'] += $stats[ $v['date'] ]['paids'] = $v['withdraw'];
        }

        $q = $this->db->query("SELECT COUNT( id ) as payments, SUM( amount ) as deposit, CAST( processed_time AS DATE ) as date FROM `payments` where `processed_time` > '2018' GROUP BY DAYOFYEAR( processed_time ) ");

        foreach( $q->result_array() as $v )
        {
            if( !isset($stats[$v['date']]) ) continue;

            $total['payments_count'] += $stats[ $v['date'] ]['payments_count'] = $v['payments'];
            $total['payments'] += $stats[ $v['date'] ]['payments'] = $v['deposit'];
        }

        $q = $this->db->query("SELECT count(game_id) as games, sum(user_bet_cash) as win, sum(user_win_cash) as bet, cast( gametime as date) as date FROM `games` where gametime > '2018' group by dayofyear( gametime )");

        foreach( $q->result_array() as $v )
        {
            if( !isset($stats[$v['date']]) ) continue;

            $total['wins'] += $stats[ $v['date'] ]['wins'] = $v['win'];
            $total['loosed'] += $stats[ $v['date'] ]['loosed'] = $v['bet'];
            $total['games'] += $stats[ $v['date'] ]['games'] = $v['games'];
        }

        $tpl['stats'] = $stats;
        $tpl['total'] = $total;

        $this->Style->build("stats",$tpl,'adminNew');
    }