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

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

��ѧ٧ѧ�
<?php namespace Altum\Controllers; use Altum\Database\Database; use Altum\Middlewares\Authentication; use Altum\Models\Domain; use Altum\Title; class BiolinkBlock extends Controller { public $biolink_block; public function index() { Authentication::guard(); $biolink_block_id = isset($this->params[0]) ? (int) $this->params[0] : null; $method = isset($this->params[1]) && in_array($this->params[1], ['statistics']) ? $this->params[1] : 'statistics'; /* Make sure the link exists and is accessible to the user / if(!$this->biolink_block = db()->where('biolink_block_id', $biolink_block_id)->where('user_id', $this->user->user_id)->getOne('biolinks_blocks')) { redirect('dashboard'); } $this->biolink_block->settings = json_decode($this->biolink_block->settings); / Handle code for different parts of the page / switch($method) { case 'statistics': if(!$this->user->plan_settings->statistics) { $_SESSION['info'][] = language()->global->info_message->plan_feature_no_access; redirect('links'); } $type = isset($_GET['type']) && in_array($_GET['type'], ['overview', 'referrer_host', 'referrer_path', 'country', 'city_name', 'os', 'browser', 'device', 'language', 'utm_source', 'utm_medium', 'utm_campaign']) ? Database::clean_string($_GET['type']) : 'overview'; $datetime = \Altum\Date::get_start_end_dates_new(); / Get the required statistics / $pageviews = []; $pageviews_chart = []; $pageviews_result = database()->query(" SELECT COUNT(`id`) AS `pageviews`, SUM(`is_unique`) AS `visitors`, DATE_FORMAT(`datetime`, '{$datetime['query_date_format']}') AS `formatted_date` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `formatted_date` ORDER BY `formatted_date` "); / Generate the raw chart data and save pageviews for later usage / while($row = $pageviews_result->fetch_object()) { $pageviews[] = $row; $row->formatted_date = $datetime['process']($row->formatted_date); $pageviews_chart[$row->formatted_date] = [ 'pageviews' => $row->pageviews, 'visitors' => $row->visitors ]; } $pageviews_chart = get_chart_data($pageviews_chart); / Get data based on what statistics are needed / switch($type) { case 'overview': $result = database()->query(" SELECT FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') ORDER BY `datetime` DESC "); break; case 'referrer_host': case 'country': case 'os': case 'browser': case 'device': case 'language': $columns = [ 'referrer_host' => 'referrer_host', 'referrer_path' => 'referrer_path', 'country' => 'country_code', 'city_name' => 'city_name', 'os' => 'os_name', 'browser' => 'browser_name', 'device' => 'device_type', 'language' => 'browser_language' ]; $result = database()->query(" SELECT `{$columns[$type]}`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `{$columns[$type]}` ORDER BY `total` DESC LIMIT 250 "); break; case 'referrer_path': $referrer_host = trim(Database::clean_string($_GET['referrer_host'])); $result = database()->query(" SELECT `referrer_path`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND `referrer_host` = '{$referrer_host}' AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `referrer_path` ORDER BY `total` DESC LIMIT 250 "); break; case 'city_name': $country_code = trim(Database::clean_string($_GET['country_code'])); $result = database()->query(" SELECT `city_name`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND `country_code` = '{$country_code}' AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `city_name` ORDER BY `total` DESC LIMIT 250 "); break; case 'utm_source': $result = database()->query(" SELECT `utm_source`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') AND `utm_source` IS NOT NULL GROUP BY `utm_source` ORDER BY `total` DESC LIMIT 250 "); break; case 'utm_medium': $utm_source = trim(Database::clean_string($_GET['utm_source'])); $result = database()->query(" SELECT `utm_medium`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND `utm_source` = '{$utm_source}' AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `utm_medium` ORDER BY `total` DESC LIMIT 250 "); 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_campaign`, COUNT() AS `total` FROM `track_links` WHERE `biolink_block_id` = {$this->biolink_block->biolink_block_id} AND `utm_source` = '{$utm_source}' AND `utm_medium` = '{$utm_medium}' AND (`datetime` BETWEEN '{$datetime['query_start_date']}' AND '{$datetime['query_end_date']}') GROUP BY `utm_campaign` ORDER BY `total` DESC LIMIT 250 "); break; } switch($type) { case 'overview': $statistics_keys = [ 'country_code', 'referrer_host', 'device_type', 'os_name', 'browser_name', 'browser_language' ]; $statistics = []; foreach($statistics_keys as $key) { $statistics[$key] = []; $statistics[$key . '_total_sum'] = 0; } /* Start processing the rows from the database / while($row = $result->fetch_object()) { foreach($statistics_keys as $key) { $statistics[$key][$row->{$key}] = isset($statistics[$key][$row->{$key}]) ? $statistics[$key][$row->{$key}] + 1 : 1; $statistics[$key . '_total_sum']++; } } foreach($statistics_keys as $key) { arsort($statistics[$key]); } / Prepare the statistics method View / $data = [ 'statistics' => $statistics, 'link' => $this->biolink_block, 'method' => $method, 'datetime' => $datetime, ]; break; case 'referrer_host': case 'country': case 'city_name': case 'os': case 'browser': case 'device': case 'language': case 'referrer_path': case 'utm_source': case 'utm_medium': case 'utm_campaign': / Store all the results from the database / $statistics = []; $statistics_total_sum = 0; while($row = $result->fetch_object()) { $statistics[] = $row; $statistics_total_sum += $row->total; } / Prepare the statistics method View / $data = [ 'rows' => $statistics, 'total_sum' => $statistics_total_sum, 'link' => $this->biolink_block, 'method' => $method, 'datetime' => $datetime, 'referrer_host' => $referrer_host ?? null, 'country_code' => $country_code ?? null, 'utm_source' => $utm_source ?? null, 'utm_medium' => $utm_medium ?? null, ]; break; } $view = new \Altum\Views\View('link/statistics/statistics_' . $type, (array) $this); $this->add_view_content('statistics', $view->run($data)); / Prepare variables for the view / $data = [ 'link' => $this->biolink_block, 'method' => $method, 'type' => $type, 'datetime' => $datetime, 'pageviews' => $pageviews, 'pageviews_chart' => $pageviews_chart ]; break; } / Prepare the method View / $view = new \Altum\Views\View('link/' . $method, (array) $this); $this->add_view_content('method', $view->run($data)); / Prepare the View */ $data = [ 'biolink_block' => $this->biolink_block, 'method' => $method ]; $view = new \Altum\Views\View('biolink-block/index', (array) $this); $this->add_view_content('content', $view->run($data)); } }

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