phpmyadmin working

1 files changed, 261 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
new file mode 100644
index 0000000..b2c4176
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/Controllers/Table/ChartController.php
@@ -0,0 +1,261 @@
+<?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));
+    }
+}