��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/tie.cx/app/controllers/api/ApiStatistics.php

��ѧ٧ѧ�
<?php namespace Altum\Controllers; use Altum\Database\Database; use Altum\Response; use Altum\Traits\Apiable; class ApiStatistics extends Controller { use Apiable; public function index() { $this->verify_request(); /* Decide what to continue with / switch($_SERVER['REQUEST_METHOD']) { case 'GET': / Detect if we only need an object, or the whole list / if(isset($this->params[0])) { $this->get(); } break; } $this->return_404(); } private function get() { $link_id = isset($this->params[0]) ? (int) $this->params[0] : null; / Try to get details about the resource id / $this->link = $link = db()->where('link_id', $link_id)->where('user_id', $this->api_user->user_id)->getOne('links'); / We haven't found the resource / if(!$link) { Response::jsonapi_error([[ 'title' => language()->api->error_message->not_found, 'status' => '404' ]], null, 404); } / :) / $this->datetime = \Altum\Date::get_start_end_dates_new(); $type = isset($_GET['type']) && in_array($_GET['type'], [ 'overview', 'referrer_host', 'referrer_path', 'country_code', 'city_name', 'os_name', 'browser_name', 'device_type', 'browser_language', 'utm_source', 'utm_medium', 'utm_campaign' ]) ? Database::clean_string($_GET['type']) : 'overview'; / :) / $data = []; switch($type) { case 'overview': $result = database()->query(" SELECT COUNT(`id`) AS `pageviews`, SUM(`is_unique`) AS `visitors`, DATE_FORMAT(`datetime`, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `formatted_date` ORDER BY `formatted_date` "); while($row = $result->fetch_object()) { $data[] = [ 'pageviews' => (int) $row->pageviews, 'visitors' => (int) $row->visitors, 'formatted_date' => $this->datetime['process']($row->formatted_date), ]; } break; case 'referrer_host': case 'country_code': case 'os_name': case 'browser_name': case 'device_type': case 'browser_language': $result = database()->query(" SELECT `{$type}`, COUNT() AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `{$type}` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; case 'referrer_path': $referrer_host = trim(Database::clean_string($_GET['referrer_host'])); $result = database()->query(" SELECT `referrer_host`, `referrer_path`, COUNT() AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND `referrer_host` = '{$referrer_host}' AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `referrer_host`, `referrer_path` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ 'referrer_host' => $row->referrer_host, $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; case 'city_name': $country_code = trim(Database::clean_string($_GET['country_code'])); $result = database()->query(" SELECT `country_code`, `city_name`, COUNT() AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND `country_code` = '{$country_code}' AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `country_code`, `city_name` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ 'country_code' => $row->country_code, 'country_name' => $row->country_code ? get_country_from_country_code($row->country_code) : null, $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; case 'utm_source': $result = database()->query(" SELECT `utm_source`, COUNT() AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') AND `utm_source` IS NOT NULL GROUP BY `utm_source` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; case 'utm_medium': $utm_source = trim(Database::clean_string($_GET['utm_source'])); $result = database()->query(" SELECT `utm_source`, `utm_medium`, COUNT() AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND `utm_source` = '{$utm_source}' AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `utm_source`, `utm_medium` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ 'utm_source' => $row->utm_source, $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; case 'utm_campaign': $utm_source = trim(Database::clean_string($_GET['utm_source'])); $utm_medium = trim(Database::clean_string($_GET['utm_medium'])); $result = database()->query(" SELECT `utm_source`, `utm_medium`, `utm_campaign`, COUNT(*) AS `pageviews` FROM `track_links` WHERE `link_id` = {$this->link->link_id} AND `utm_source` = '{$utm_source}' AND `utm_medium` = '{$utm_medium}' AND (`datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}') GROUP BY `utm_source`, `utm_campaign`, `utm_campaign` ORDER BY `pageviews` DESC LIMIT 250 "); while($row = $result->fetch_object()) { $data[] = [ 'utm_source' => $row->utm_source, 'utm_medium' => $row->utm_medium, $type => $row->{$type}, 'pageviews' => (int) $row->pageviews ]; } break; } Response::jsonapi_success($data); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.01 | proxy | phpinfo | ��ѧ��ۧܧ�