Helper\Stats::dataUsage PHP Метод

    public static function dataUsage($type = 0)
    {
        $querySQL = "SELECT count(*) FROM member WHERE 1=1 ";
        switch ($type) {
            case 1:
                $querySQL .= "AND flow_up+flow_down BETWEEN " . (Utils::GB * 10 + 1) . " AND " . Utils::GB * 30;
                // 11GB ~ 30GB
                break;
            case 2:
                $querySQL .= "AND flow_up+flow_down BETWEEN " . (Utils::GB * 30 + 1) . " AND " . Utils::GB * 100;
                // 30GB ~ 100GB
                break;
            case 3:
                $querySQL .= "AND flow_up+flow_down > " . (Utils::GB * 100 + 1);
                // 大于 100GB
                break;
            case 0:
            default:
                $querySQL .= "AND flow_up+flow_down < " . Utils::GB * 10;
                // 小于10GB
                break;
        }
        $statement = DB::getInstance()->prepare($querySQL);
        $statement->execute();
        $count = $statement->fetch(DB::FETCH_NUM);
        return $count[0];
    }

 public function index()
 {
     $data['user'] = User::getCurrent();
     $data['flow_num10'] = Stats::dataUsage(0);
     $data['flow_num30'] = Stats::dataUsage(1);
     $data['flow_num100'] = Stats::dataUsage(2);
     $data['flow_max'] = Stats::dataUsage(3);
     $data['userCount'] = Stats::countUser();
     $data['money'] = Stats::countMoney();
     Template::setContext($data);
     Template::setView('admin/index');
 }