aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
diff options
context:
space:
mode:
authorCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
committerCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
commit5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch)
tree39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
parent5afd237bbd22028b85532b8c0b3fcead49a00764 (diff)
downloadft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz
ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2
ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php')
-rw-r--r--srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php261
1 files changed, 0 insertions, 261 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
deleted file mode 100644
index b2c4176..0000000
--- a/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
+++ /dev/null
@@ -1,261 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Holds the PhpMyAdmin\Controllers\Table\ChartController
- *
- * @package PhpMyAdmin\Controllers
- */
-declare(strict_types=1);
-
-namespace PhpMyAdmin\Controllers\Table;
-
-use PhpMyAdmin\DatabaseInterface;
-use PhpMyAdmin\Message;
-use PhpMyAdmin\Response;
-use PhpMyAdmin\SqlParser\Components\Limit;
-use PhpMyAdmin\SqlParser\Parser;
-use PhpMyAdmin\SqlParser\Statements\SelectStatement;
-use PhpMyAdmin\Template;
-use PhpMyAdmin\Util;
-
-/**
- * Handles table related logic
- *
- * @package PhpMyAdmin\Controllers
- */
-class ChartController extends AbstractController
-{
- /**
- * @var string
- */
- protected $sql_query;
-
- /**
- * @var string
- */
- protected $url_query;
-
- /**
- * @var array
- */
- protected $cfg;
-
- /**
- * Constructor
- *
- * @param Response $response Response object
- * @param DatabaseInterface $dbi DatabaseInterface object
- * @param Template $template Template object
- * @param string $db Database name
- * @param string $table Table name
- * @param string $sql_query Query
- * @param string $url_query Query URL
- * @param array $cfg Configuration
- */
- public function __construct(
- $response,
- $dbi,
- Template $template,
- $db,
- $table,
- $sql_query,
- $url_query,
- array $cfg
- ) {
- parent::__construct($response, $dbi, $template, $db, $table);
-
- $this->sql_query = $sql_query;
- $this->url_query = $url_query;
- $this->cfg = $cfg;
- }
-
- /**
- * Execute the query and return the result
- *
- * @return void
- */
- public function indexAction()
- {
- $response = Response::getInstance();
- if ($response->isAjax()
- && isset($_REQUEST['pos'])
- && isset($_REQUEST['session_max_rows'])
- ) {
- $this->ajaxAction();
- return;
- }
-
- // Throw error if no sql query is set
- if (! isset($this->sql_query) || $this->sql_query == '') {
- $this->response->setRequestStatus(false);
- $this->response->addHTML(
- Message::error(__('No SQL query was set to fetch data.'))
- );
- return;
- }
-
- $this->response->getHeader()->getScripts()->addFiles(
- [
- 'chart.js',
- 'table/chart.js',
- 'vendor/jqplot/jquery.jqplot.js',
- 'vendor/jqplot/plugins/jqplot.barRenderer.js',
- 'vendor/jqplot/plugins/jqplot.canvasAxisLabelRenderer.js',
- 'vendor/jqplot/plugins/jqplot.canvasTextRenderer.js',
- 'vendor/jqplot/plugins/jqplot.categoryAxisRenderer.js',
- 'vendor/jqplot/plugins/jqplot.dateAxisRenderer.js',
- 'vendor/jqplot/plugins/jqplot.pointLabels.js',
- 'vendor/jqplot/plugins/jqplot.pieRenderer.js',
- 'vendor/jqplot/plugins/jqplot.enhancedPieLegendRenderer.js',
- 'vendor/jqplot/plugins/jqplot.highlighter.js',
- ]
- );
-
- /**
- * Extract values for common work
- * @todo Extract common files
- */
- $db = &$this->db;
- $table = &$this->table;
- $url_params = [];
-
- /**
- * Runs common work
- */
- if (strlen($this->table) > 0) {
- $url_params['goto'] = Util::getScriptNameForOption(
- $this->cfg['DefaultTabTable'],
- 'table'
- );
- $url_params['back'] = 'tbl_sql.php';
- include ROOT_PATH . 'libraries/tbl_common.inc.php';
- $this->dbi->selectDb($GLOBALS['db']);
- } elseif (strlen($this->db) > 0) {
- $url_params['goto'] = Util::getScriptNameForOption(
- $this->cfg['DefaultTabDatabase'],
- 'database'
- );
- $url_params['back'] = 'sql.php';
- include ROOT_PATH . 'libraries/db_common.inc.php';
- } else {
- $url_params['goto'] = Util::getScriptNameForOption(
- $this->cfg['DefaultTabServer'],
- 'server'
- );
- $url_params['back'] = 'sql.php';
- include ROOT_PATH . 'libraries/server_common.inc.php';
- }
-
- $data = [];
-
- $result = $this->dbi->tryQuery($this->sql_query);
- $fields_meta = $this->dbi->getFieldsMeta($result);
- while ($row = $this->dbi->fetchAssoc($result)) {
- $data[] = $row;
- }
-
- $keys = array_keys($data[0]);
-
- $numeric_types = [
- 'int',
- 'real',
- ];
- $numeric_column_count = 0;
- foreach ($keys as $idx => $key) {
- if (in_array($fields_meta[$idx]->type, $numeric_types)) {
- $numeric_column_count++;
- }
- }
-
- if ($numeric_column_count == 0) {
- $this->response->setRequestStatus(false);
- $this->response->addJSON(
- 'message',
- __('No numeric columns present in the table to plot.')
- );
- return;
- }
-
- $url_params['db'] = $this->db;
- $url_params['reload'] = 1;
-
- /**
- * Displays the page
- */
- $this->response->addHTML(
- $this->template->render('table/chart/tbl_chart', [
- 'url_query' => $this->url_query,
- 'url_params' => $url_params,
- 'keys' => $keys,
- 'fields_meta' => $fields_meta,
- 'numeric_types' => $numeric_types,
- 'numeric_column_count' => $numeric_column_count,
- 'sql_query' => $this->sql_query,
- ])
- );
- }
-
- /**
- * Handle ajax request
- *
- * @return void
- */
- public function ajaxAction()
- {
- /**
- * Extract values for common work
- * @todo Extract common files
- */
- $db = &$this->db;
- $table = &$this->table;
-
- if (strlen($this->table) > 0 && strlen($this->db) > 0) {
- include ROOT_PATH . 'libraries/tbl_common.inc.php';
- }
-
- $parser = new Parser($this->sql_query);
- /**
- * @var SelectStatement $statement
- */
- $statement = $parser->statements[0];
- if (empty($statement->limit)) {
- $statement->limit = new Limit(
- $_REQUEST['session_max_rows'],
- $_REQUEST['pos']
- );
- } else {
- $start = $statement->limit->offset + $_REQUEST['pos'];
- $rows = min(
- $_REQUEST['session_max_rows'],
- $statement->limit->rowCount - $_REQUEST['pos']
- );
- $statement->limit = new Limit($rows, $start);
- }
- $sql_with_limit = $statement->build();
-
- $data = [];
- $result = $this->dbi->tryQuery($sql_with_limit);
- while ($row = $this->dbi->fetchAssoc($result)) {
- $data[] = $row;
- }
-
- if (empty($data)) {
- $this->response->setRequestStatus(false);
- $this->response->addJSON('message', __('No data to display'));
- return;
- }
- $sanitized_data = [];
-
- foreach ($data as $data_row_number => $data_row) {
- $tmp_row = [];
- foreach ($data_row as $data_column => $data_value) {
- $escaped_value = $data_value === null ? null : htmlspecialchars($data_value);
- $tmp_row[htmlspecialchars($data_column)] = $escaped_value;
- }
- $sanitized_data[] = $tmp_row;
- }
- $this->response->setRequestStatus(true);
- $this->response->addJSON('message', null);
- $this->response->addJSON('chartData', json_encode($sanitized_data));
- }
-}