芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/www/status.pulsehost.co.uk/app/controllers/admin/AdminStatistics.php

<?php
/*
 * @copyright Copyright (c) 2024 AltumCode (https://altumcode.com/)
 *
 * This software is exclusively sold through https://altumcode.com/ by the AltumCode author.
 * Downloading this product from any other sources and running it without a proper license is illegal,
 *  except the official ones linked from https://altumcode.com/.
 */

namespace Altum\Controllers;

use Altum\Title;

class AdminStatistics extends Controller {
    public $type;
    public $datetime;

public function index() {

$this->type = isset($this->params[0]) && method_exists($this, $this->params[0]) ? input_clean($this->params[0]) : 'growth';

$this->datetime = \Altum\Date::get_start_end_dates_new();

/* Process only data that is needed for that specific page */
        $type_data = $this->{$this->type}();

/* Set a custom title */
        $dynamic_title = l('admin_statistics.' . $this->type . '.header', null, true) ?? l('admin_' . $this->type . '.title');
        Title::set(sprintf(l('admin_statistics.title'), $dynamic_title));

/* Main View */
        $data = [
            'type' => $this->type,
            'datetime' => $this->datetime
        ];
        $data = array_merge($data, $type_data);

$view = new \Altum\View('admin/statistics/index', (array) $this);

$this->add_view_content('content', $view->run($data));

}

protected function database() {
        //ALTUMCODE:DEMO if(DEMO) { \Altum\Alerts::add_error('This command is blocked on the demo.'); redirect('admin/statistics'); };

/* Database details */
        $database_name = DATABASE_NAME;
        $tables = [];
        $result = database()->query("
            SELECT
                TABLE_NAME AS `table`,
                ROUND((DATA_LENGTH + INDEX_LENGTH)) AS `bytes`,
                TABLE_ROWS as 'rows'
            FROM
                information_schema.TABLES
            WHERE
                TABLE_SCHEMA = '{$database_name}'
            ORDER BY
                (DATA_LENGTH + INDEX_LENGTH)
            DESC;
        ");
        while($row = $result->fetch_object()) {

$tables[] = $row;

}

return [
            'tables' => $tables,
        ];
    }

protected function growth() {

$total = ['users' => 0, 'users_logs' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

/* Users */
        $users_chart = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                 `users`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$users_chart[$row->formatted_date] = [
                'users' => $row->total
            ];

$total['users'] += $row->total;
        }

$users_chart = get_chart_data($users_chart);

/* Users logs */
        $users_logs_chart = [];
        $result = database()->query("
            SELECT
                 COUNT(DISTINCT `user_id`) AS `total`,
                 DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                 `users_logs`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$users_logs_chart[$row->formatted_date] = [
                'users_logs' => $row->total
            ];

$total['users_logs'] += $row->total;
        }

$users_logs_chart = get_chart_data($users_logs_chart);

return [
            'total' => $total,
            'users_chart' => $users_chart,
            'users_logs_chart' => $users_logs_chart,
        ];
    }

protected function users_map() {

$total = ['continents' => 0, 'countries' => 0, 'cities' => 0,];

/* Continents */
        $continents = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `continent_code`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `continent_code`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $continents[$row->continent_code] = $row->total;
            $total['continents'] += $row->total;
        }

/* Countries */
        $countries_map = [];
        $countries = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `country`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `country`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $countries[$row->country] = $row->total;
            $countries_map[$row->country] = ['users' => $row->total];
            $total['countries'] += $row->total;
        }

/* Cities */
        $cities = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `country`,
                 `city_name`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `country`,
                `city_name`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $cities[$row->country . '#' . $row->city_name] = $row->total;
            $total['cities'] += $row->total;
        }

return [
            'continents' => $continents,
            'countries' => $countries,
            'countries_map' => $countries_map,
            'cities' => $cities,
            'total' => $total,
        ];
    }

protected function users() {

$total = ['devices' => 0, 'sources' => 0, 'plans' => 0, 'operating_systems' => 0, 'browsers' => 0,];

/* Device types */
        $devices = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `device_type`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `device_type`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $devices[$row->device_type] = $row->total;
            $total['devices'] += $row->total;
        }

/* Operating systems */
        $operating_systems = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `os_name`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `os_name`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $operating_systems[$row->os_name] = $row->total;
            $total['operating_systems'] += $row->total;
        }

/* Browsers */
        $browsers = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `browser_name`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `browser_name`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $browsers[$row->browser_name] = $row->total;
            $total['browsers'] += $row->total;
        }

/* Sources */
        $sources = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `source`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `source`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $sources[$row->source] = $row->total;
            $total['sources'] += $row->total;
        }

/* Plans */
        $plans = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `plan_id`
            FROM
                 `users`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `plan_id`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $plans[$row->plan_id] = $row->total;
            $total['plans'] += $row->total;
        }

return [
            'devices' => $devices,
            'operating_systems' => $operating_systems,
            'browsers' => $browsers,
            'sources' => $sources,
            'plans' => $plans,
            'total' => $total,
        ];
    }

protected function payments() {

$total = ['total_amount' => 0, 'total_payments' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$payments_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total_payments`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, TRUNCATE(SUM(`total_amount_default_currency`), 2) AS `total_amount` FROM `payments` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$payments_chart[$row->formatted_date] = [
                'total_amount' => $row->total_amount,
                'total_payments' => $row->total_payments
            ];

$total['total_amount'] += $row->total_amount;
            $total['total_payments'] += $row->total_payments;
        }

$payments_chart = get_chart_data($payments_chart);

/* Payment processors */
        $processors = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `processor`,
                 TRUNCATE(SUM(`total_amount_default_currency`), 2) AS `total_amount`
            FROM
                 `payments`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `processor`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $processors[] = [
                'processor' => $row->processor,
                'total' => $row->total,
                'total_amount' => $row->total_amount,
            ];
        }

/* Plans */
        $payments_plans = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `plan_id`,
                 TRUNCATE(SUM(`total_amount_default_currency`), 2) AS `total_amount`
            FROM
                 `payments`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `plan_id`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $payments_plans[] = [
                'plan_id' => $row->plan_id,
                'total' => $row->total,
                'total_amount' => $row->total_amount,
            ];
        }

/* Payment types */
        $types = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `type`,
                 TRUNCATE(SUM(`total_amount_default_currency`), 2) AS `total_amount`
            FROM
                 `payments`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `type`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $types[] = [
                'type' => $row->type,
                'total' => $row->total,
                'total_amount' => $row->total_amount,
            ];
        }

/* Payment freuqencies */
        $frequencies = [];
        $result = database()->query("
            SELECT
                 COUNT(*) AS `total`,
                 `frequency`,
                 TRUNCATE(SUM(`total_amount_default_currency`), 2) AS `total_amount`
            FROM
                 `payments`
            WHERE
                `datetime` BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}'
            GROUP BY
                `frequency`
            ORDER BY
                `total` DESC
        ");
        while($row = $result->fetch_object()) {
            $frequencies[] = [
                'frequency' => $row->frequency,
                'total' => $row->total,
                'total_amount' => $row->total_amount,
            ];
        }

return [
            'total' => $total,
            'payments_chart' => $payments_chart,
            'payments_plans' => $payments_plans,
            'frequencies' => $frequencies,
            'types' => $types,
            'processors' => $processors,
            'payment_processors' => require APP_PATH . 'includes/payment_processors.php',
            'plans' => (new \Altum\Models\Plan())->get_plans(),
        ];

}

protected function redeemed_codes() {

$total = ['discount_codes' => 0, 'redeemable_codes' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$chart = [];
        $result = database()->query("SELECT `type`, COUNT(`type`) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `redeemed_codes` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`, `type`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

if(isset($chart[$row->formatted_date])) {
                $chart[$row->formatted_date] = [
                    'discount' => $row->type == 'discount' ? $chart[$row->formatted_date]['discount'] + $row->total : $chart[$row->formatted_date]['discount'],
                    'redeemable' => $row->type == 'redeemable' ? $chart[$row->formatted_date]['redeemable'] + $row->total : $chart[$row->formatted_date]['redeemable'],
                ];
            } else {
                $chart[$row->formatted_date] = [
                    'discount' => $row->type == 'discount' ? $row->total : 0,
                    'redeemable' => $row->type == 'redeemable' ? $row->total : 0,
                ];
            }

$total['discount_codes'] += $row->type == 'discount' ? $row->total : 0;
            $total['redeemable_codes'] += $row->type == 'redeemable' ? $row->total : 0;
        }

$chart = get_chart_data($chart);

return [
            'total' => $total,
            'chart' => $chart,
        ];

}

protected function affiliates_commissions() {

$total = ['amount' => 0, 'total_affiliates_commissions' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$affiliates_commissions_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total_affiliates_commissions`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, TRUNCATE(SUM(`amount`), 2) AS `amount` FROM `affiliates_commissions` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$affiliates_commissions_chart[$row->formatted_date] = [
                'amount' => $row->amount,
                'total_affiliates_commissions' => $row->total_affiliates_commissions
            ];

$total['amount'] += $row->amount;
            $total['total_affiliates_commissions'] += $row->total_affiliates_commissions;
        }

$affiliates_commissions_chart = get_chart_data($affiliates_commissions_chart);

return [
            'total' => $total,
            'affiliates_commissions_chart' => $affiliates_commissions_chart
        ];

}
    protected function affiliates_withdrawals() {

$total = ['amount' => 0, 'total_affiliates_withdrawals' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$affiliates_withdrawals_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total_affiliates_withdrawals`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, TRUNCATE(SUM(`amount`), 2) AS `amount` FROM `affiliates_withdrawals` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$affiliates_withdrawals_chart[$row->formatted_date] = [
                'amount' => $row->amount,
                'total_affiliates_withdrawals' => $row->total_affiliates_withdrawals
            ];

$total['amount'] += $row->amount;
            $total['total_affiliates_withdrawals'] += $row->total_affiliates_withdrawals;
        }

$affiliates_withdrawals_chart = get_chart_data($affiliates_withdrawals_chart);

return [
            'total' => $total,
            'affiliates_withdrawals_chart' => $affiliates_withdrawals_chart
        ];

}

protected function broadcasts() {

$total = ['broadcasts' => 0, 'sent_emails' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$broadcasts_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, SUM(`sent_emails`) AS `sent_emails` FROM `broadcasts` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$broadcasts_chart[$row->formatted_date] = [
                'broadcasts' => $row->total,
                'sent_emails' => $row->sent_emails,
            ];

$total['broadcasts'] += $row->total;
            $total['sent_emails'] += $row->sent_emails;
        }

$broadcasts_chart = get_chart_data($broadcasts_chart);

return [
            'total' => $total,
            'broadcasts_chart' => $broadcasts_chart,
        ];

}

protected function internal_notifications() {

$total = ['internal_notifications' => 0, 'read_notifications' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$internal_notifications_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, SUM(`is_read`) AS `read_notifications` FROM `internal_notifications` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$internal_notifications_chart[$row->formatted_date] = [
                'internal_notifications' => $row->total,
                'read_notifications' => $row->read_notifications,
            ];

$total['internal_notifications'] += $row->total;
            $total['read_notifications'] += $row->read_notifications;
        }

$internal_notifications_chart = get_chart_data($internal_notifications_chart);

return [
            'total' => $total,
            'internal_notifications_chart' => $internal_notifications_chart,
        ];

}

protected function push_notifications() {

$total = ['push_notifications' => 0, 'sent_push_notifications' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$push_notifications_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`, SUM(`sent_push_notifications`) AS `sent_push_notifications` FROM `push_notifications` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$push_notifications_chart[$row->formatted_date] = [
                'push_notifications' => $row->total,
                'sent_push_notifications' => $row->sent_push_notifications,
            ];

$total['push_notifications'] += $row->total;
            $total['sent_push_notifications'] += $row->sent_push_notifications;
        }

$push_notifications_chart = get_chart_data($push_notifications_chart);

return [
            'total' => $total,
            'push_notifications_chart' => $push_notifications_chart,
        ];

}

protected function push_subscribers() {

$total = ['push_subscribers' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$push_subscribers_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `push_subscribers` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$push_subscribers_chart[$row->formatted_date] = [
                'push_subscribers' => $row->total,
            ];

$total['push_subscribers'] += $row->total;
        }

$push_subscribers_chart = get_chart_data($push_subscribers_chart);

return [
            'total' => $total,
            'push_subscribers_chart' => $push_subscribers_chart,
        ];

}

protected function teams() {

$total = ['teams' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$teams_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `teams` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date);

$teams_chart[$row->formatted_date] = [
                'teams' => $row->total,
            ];

$total['teams'] += $row->total;
        }

$teams_chart = get_chart_data($teams_chart);

return [
            'total' => $total,
            'teams_chart' => $teams_chart,
        ];

}

protected function teams_members() {

$total = ['teams_members' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$teams_members_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `teams_members` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date);

$teams_members_chart[$row->formatted_date] = [
                'teams_members' => $row->total,
            ];

$total['teams_members'] += $row->total;
        }

$teams_members_chart = get_chart_data($teams_members_chart);

return [
            'total' => $total,
            'teams_members_chart' => $teams_members_chart,
        ];

}

protected function monitors() {

$total = ['monitors' => 0];

/* Monitors */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$monitors_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `monitors`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$monitors_chart[$row->formatted_date] = [
                'monitors' => $row->total
            ];

$total['monitors'] += $row->total;
        }

$monitors_chart = get_chart_data($monitors_chart);

return [
            'total' => $total,
            'monitors_chart' => $monitors_chart,
        ];

}

protected function monitors_logs() {

$total = ['monitors_logs' => 0];

/* Monitors logs */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$monitors_logs_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `monitors_logs`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$monitors_logs_chart[$row->formatted_date] = [
                'monitors_logs' => $row->total
            ];

$total['monitors_logs'] += $row->total;
        }

$monitors_logs_chart = get_chart_data($monitors_logs_chart);

return [
            'total' => $total,
            'monitors_logs_chart' => $monitors_logs_chart,
        ];

}

protected function dns_monitors() {

$total = ['dns_monitors' => 0];

/* Monitors */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$dns_monitors_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `dns_monitors`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$dns_monitors_chart[$row->formatted_date] = [
                'dns_monitors' => $row->total
            ];

$total['dns_monitors'] += $row->total;
        }

$dns_monitors_chart = get_chart_data($dns_monitors_chart);

return [
            'total' => $total,
            'dns_monitors_chart' => $dns_monitors_chart,
        ];

}

protected function dns_monitors_logs() {

$total = ['dns_monitors_logs' => 0];

/* Monitors logs */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$dns_monitors_logs_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `dns_monitors_logs`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$dns_monitors_logs_chart[$row->formatted_date] = [
                'dns_monitors_logs' => $row->total
            ];

$total['dns_monitors_logs'] += $row->total;
        }

$dns_monitors_logs_chart = get_chart_data($dns_monitors_logs_chart);

return [
            'total' => $total,
            'dns_monitors_logs_chart' => $dns_monitors_logs_chart,
        ];

}

protected function server_monitors() {

$total = ['server_monitors' => 0];

/* Monitors */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$server_monitors_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `server_monitors`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$server_monitors_chart[$row->formatted_date] = [
                'server_monitors' => $row->total
            ];

$total['server_monitors'] += $row->total;
        }

$server_monitors_chart = get_chart_data($server_monitors_chart);

return [
            'total' => $total,
            'server_monitors_chart' => $server_monitors_chart,
        ];

}

protected function server_monitors_logs() {

$total = ['server_monitors_logs' => 0];

/* Monitors logs */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$server_monitors_logs_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `server_monitors_logs`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$server_monitors_logs_chart[$row->formatted_date] = [
                'server_monitors_logs' => $row->total
            ];

$total['server_monitors_logs'] += $row->total;
        }

$server_monitors_logs_chart = get_chart_data($server_monitors_logs_chart);

return [
            'total' => $total,
            'server_monitors_logs_chart' => $server_monitors_logs_chart,
        ];

}

protected function heartbeats() {

$total = ['heartbeats' => 0];

/* Heartbeats */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$heartbeats_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `heartbeats`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$heartbeats_chart[$row->formatted_date] = [
                'heartbeats' => $row->total
            ];

$total['heartbeats'] += $row->total;
        }

$heartbeats_chart = get_chart_data($heartbeats_chart);

return [
            'total' => $total,
            'heartbeats_chart' => $heartbeats_chart,
        ];

}

protected function heartbeats_logs() {

$total = ['heartbeats_logs' => 0];

/* Heartbeats logs */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$heartbeats_logs_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `heartbeats_logs`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$heartbeats_logs_chart[$row->formatted_date] = [
                'heartbeats_logs' => $row->total
            ];

$total['heartbeats_logs'] += $row->total;
        }

$heartbeats_logs_chart = get_chart_data($heartbeats_logs_chart);

return [
            'total' => $total,
            'heartbeats_logs_chart' => $heartbeats_logs_chart,
        ];

}

protected function domain_names() {

$total = ['domain_names' => 0];

/* Heartbeats */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$domain_names_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `domain_names`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$domain_names_chart[$row->formatted_date] = [
                'domain_names' => $row->total
            ];

$total['domain_names'] += $row->total;
        }

$domain_names_chart = get_chart_data($domain_names_chart);

return [
            'total' => $total,
            'domain_names_chart' => $domain_names_chart,
        ];

}

protected function status_pages() {

$total = ['status_pages' => 0];

/* Status pages */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$status_pages_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `status_pages`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$status_pages_chart[$row->formatted_date] = [
                'status_pages' => $row->total
            ];

$total['status_pages'] += $row->total;
        }

$status_pages_chart = get_chart_data($status_pages_chart);

return [
            'total' => $total,
            'status_pages_chart' => $status_pages_chart,
        ];

}

protected function statistics() {

$total = ['statistics' => 0];

/* Status pages statistics */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$statistics_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `statistics`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$statistics_chart[$row->formatted_date] = [
                'statistics' => $row->total
            ];

$total['statistics'] += $row->total;
        }

$statistics_chart = get_chart_data($statistics_chart);

return [
            'total' => $total,
            'statistics_chart' => $statistics_chart,
        ];

}

protected function domains() {

$total = ['domains' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$domains_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `domains` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$domains_chart[$row->formatted_date] = [
                'domains' => $row->total,
            ];

$total['domains'] += $row->total;
        }

$domains_chart = get_chart_data($domains_chart);

return [
            'total' => $total,
            'domains_chart' => $domains_chart,
        ];

}

protected function notification_handlers() {

$total = ['notification_handlers' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$notification_handlers_chart = [];
        $result = database()->query("SELECT COUNT(*) AS `total`, DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date` FROM `notification_handlers` WHERE {$convert_tz_sql} BETWEEN '{$this->datetime['query_start_date']}' AND '{$this->datetime['query_end_date']}' GROUP BY `formatted_date`");
        while($row = $result->fetch_object()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$notification_handlers_chart[$row->formatted_date] = [
                'notification_handlers' => $row->total,
            ];

$total['notification_handlers'] += $row->total;
        }

$notification_handlers_chart = get_chart_data($notification_handlers_chart);

return [
            'total' => $total,
            'notification_handlers_chart' => $notification_handlers_chart,
        ];

}

protected function email_reports() {

$total = ['email_reports' => 0];

$convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$email_reports_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `email_reports`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$email_reports_chart[$row->formatted_date] = [
                'email_reports' => $row->total
            ];

$total['email_reports'] += $row->total;
        }

$email_reports_chart = get_chart_data($email_reports_chart);

return [
            'total' => $total,
            'email_reports_chart' => $email_reports_chart
        ];
    }

protected function projects() {

$total = ['projects' => 0];

/* Monitors */
        $convert_tz_sql = get_convert_tz_sql('`datetime`', $this->user->timezone);

$projects_chart = [];
        $result = database()->query("
            SELECT
                COUNT(*) AS `total`,
                DATE_FORMAT({$convert_tz_sql}, '{$this->datetime['query_date_format']}') AS `formatted_date`
            FROM
                `projects`
            WHERE
                {$convert_tz_sql} 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()) {
            $row->formatted_date = $this->datetime['process']($row->formatted_date, true);

$projects_chart[$row->formatted_date] = [
                'projects' => $row->total
            ];

$total['projects'] += $row->total;
        }

$projects_chart = get_chart_data($projects_chart);

return [
            'total' => $total,
            'projects_chart' => $projects_chart,
        ];

}