phpmyadmin/server_status_monitor.php at master · team-php-developer/phpmyadmin · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Server status monitor feature
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

use PhpMyAdmin\Controllers\Server\Status\MonitorController;
use PhpMyAdmin\Server\Status\Data;
use PhpMyAdmin\Server\Status\Monitor;
use PhpMyAdmin\Response;

if (! defined('ROOT_PATH')) {
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
}

require_once ROOT_PATH . 'libraries/common.inc.php';
require_once ROOT_PATH . 'libraries/server_common.inc.php';
require_once ROOT_PATH . 'libraries/replication.inc.php';

$response = Response::getInstance();

$controller = new MonitorController(
    $response,
    $GLOBALS['dbi'],
    new Data,
    new Monitor($GLOBALS['dbi'])
);

/**
 * Ajax request
 */
if ($response->isAjax()) {
    // Send with correct charset
    header('Content-Type: text/html; charset=UTF-8');
}

// real-time charting data
if ($response->isAjax() && isset($_POST['chart_data']) && $_POST['type'] === 'chartgrid') {
    $response->addJSON($controller->chartingData([
        'requiredData' => $_POST['requiredData'] ?? null,
    ]));
} elseif ($response->isAjax() && isset($_POST['log_data']) && $_POST['type'] === 'slow') {
    $response->addJSON($controller->logDataTypeSlow([
        'time_start' => $_POST['time_start'] ?? null,
        'time_end' => $_POST['time_end'] ?? null,
    ]));
} elseif ($response->isAjax() && isset($_POST['log_data']) && $_POST['type'] === 'general') {
    $response->addJSON($controller->logDataTypeGeneral([
        'time_start' => $_POST['time_start'] ?? null,
        'time_end' => $_POST['time_end'] ?? null,
        'limitTypes' => $_POST['limitTypes'] ?? null,
        'removeVariables' => $_POST['removeVariables'] ?? null,
    ]));
} elseif ($response->isAjax() && isset($_POST['logging_vars'])) {
    $response->addJSON($controller->loggingVars([
        'varName' => $_POST['varName'] ?? null,
        'varValue' => $_POST['varValue'] ?? null,
    ]));
} elseif ($response->isAjax() && isset($_POST['query_analyzer'])) {
    $response->addJSON($controller->queryAnalyzer([
        'database' => $_POST['database'] ?? null,
        'query' => $_POST['query'] ?? null,
    ]));
} else {
    $header = $response->getHeader();
    $scripts = $header->getScripts();
    $scripts->addFile('vendor/jquery/jquery.tablesorter.js');
    $scripts->addFile('vendor/jquery/jquery.sortableTable.js');
    // for charting
    $scripts->addFile('vendor/jqplot/jquery.jqplot.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.pieRenderer.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.enhancedPieLegendRenderer.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.canvasTextRenderer.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.canvasAxisLabelRenderer.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.dateAxisRenderer.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.highlighter.js');
    $scripts->addFile('vendor/jqplot/plugins/jqplot.cursor.js');
    $scripts->addFile('jqplot/plugins/jqplot.byteFormatter.js');

    $scripts->addFile('server_status_monitor.js');
    $scripts->addFile('server_status_sorter.js');

    $response->addHTML($controller->index());
}