From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../Server/Status/QueriesController.php            | 75 ++++++++++++++++++++++
 1 file changed, 75 insertions(+)
 create mode 100644 srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php

(limited to 'srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php')

diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php
new file mode 100644
index 0000000..76430d4
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php
@@ -0,0 +1,75 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Displays query statistics for the server
+ *
+ * @package PhpMyAdmin\Controllers
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin\Controllers\Server\Status;
+
+/**
+ * Class QueriesController
+ * @package PhpMyAdmin\Controllers\Server\Status
+ */
+class QueriesController extends AbstractController
+{
+    /**
+     * @return string HTML
+     */
+    public function index(): string
+    {
+        if ($this->data->dataLoaded) {
+            $hourFactor = 3600 / $this->data->status['Uptime'];
+            $usedQueries = $this->data->used_queries;
+            $totalQueries = array_sum($usedQueries);
+
+            $stats = [
+                'total' => $totalQueries,
+                'per_hour' => $totalQueries * $hourFactor,
+                'per_minute' => $totalQueries * 60 / $this->data->status['Uptime'],
+                'per_second' => $totalQueries / $this->data->status['Uptime'],
+            ];
+
+            // reverse sort by value to show most used statements first
+            arsort($usedQueries);
+
+            $chart = [];
+            $querySum = array_sum($usedQueries);
+            $otherSum = 0;
+            $queries = [];
+            foreach ($usedQueries as $key => $value) {
+                // For the percentage column, use Questions - Connections, because
+                // the number of connections is not an item of the Query types
+                // but is included in Questions. Then the total of the percentages is 100.
+                $name = str_replace(['Com_', '_'], ['', ' '], $key);
+                // Group together values that make out less than 2% into "Other", but only
+                // if we have more than 6 fractions already
+                if ($value < $querySum * 0.02 && count($chart) > 6) {
+                    $otherSum += $value;
+                } else {
+                    $chart[$name] = $value;
+                }
+
+                $queries[$key] = [
+                    'name' => $name,
+                    'value' => $value,
+                    'per_hour' => $value * $hourFactor,
+                    'percentage' => $value * 100 / $totalQueries,
+                ];
+            }
+
+            if ($otherSum > 0) {
+                $chart[__('Other')] = $otherSum;
+            }
+        }
+
+        return $this->template->render('server/status/queries/index', [
+            'is_data_loaded' => $this->data->dataLoaded,
+            'stats' => $stats ?? null,
+            'queries' => $queries ?? [],
+            'chart' => $chart ?? [],
+        ]);
+    }
+}
-- 
cgit