phpmyadmin working

1 files changed, 221 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/db_designer.php b/srcs/phpmyadmin/db_designer.php
new file mode 100644
index 0000000..064b4b2
--- /dev/null
+++ b/srcs/phpmyadmin/db_designer.php
@@ -0,0 +1,221 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * phpMyAdmin designer general code
+ *
+ * @package PhpMyAdmin-Designer
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Database\Designer;
+use PhpMyAdmin\Database\Designer\Common;
+use PhpMyAdmin\DatabaseInterface;
+use PhpMyAdmin\Response;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
+}
+
+global $db;
+
+require_once ROOT_PATH . 'libraries/common.inc.php';
+
+/** @var Response $response */
+$response = $containerBuilder->get(Response::class);
+
+/** @var DatabaseInterface $dbi */
+$dbi = $containerBuilder->get(DatabaseInterface::class);
+
+/** @var Designer $databaseDesigner */
+$databaseDesigner = $containerBuilder->get('designer');
+
+/** @var Common $designerCommon */
+$designerCommon = $containerBuilder->get('designer_common');
+
+if (isset($_POST['dialog'])) {
+    if ($_POST['dialog'] == 'edit') {
+        $html = $databaseDesigner->getHtmlForEditOrDeletePages($_POST['db'], 'editPage');
+    } elseif ($_POST['dialog'] == 'delete') {
+        $html = $databaseDesigner->getHtmlForEditOrDeletePages($_POST['db'], 'deletePage');
+    } elseif ($_POST['dialog'] == 'save_as') {
+        $html = $databaseDesigner->getHtmlForPageSaveAs($_POST['db']);
+    } elseif ($_POST['dialog'] == 'export') {
+        $html = $databaseDesigner->getHtmlForSchemaExport(
+            $_POST['db'],
+            $_POST['selected_page']
+        );
+    } elseif ($_POST['dialog'] == 'add_table') {
+        // Pass the db and table to the getTablesInfo so we only have the table we asked for
+        $script_display_field = $designerCommon->getTablesInfo($_POST['db'], $_POST['table']);
+        $tab_column = $designerCommon->getColumnsInfo($script_display_field);
+        $tables_all_keys = $designerCommon->getAllKeys($script_display_field);
+        $tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys($script_display_field);
+
+        $html = $databaseDesigner->getDatabaseTables(
+            $_POST['db'],
+            $script_display_field,
+            [],
+            -1,
+            $tab_column,
+            $tables_all_keys,
+            $tables_pk_or_unique_keys
+        );
+    }
+
+    if (! empty($html)) {
+        $response->addHTML($html);
+    }
+    return;
+}
+
+if (isset($_POST['operation'])) {
+    if ($_POST['operation'] == 'deletePage') {
+        $success = $designerCommon->deletePage($_POST['selected_page']);
+        $response->setRequestStatus($success);
+    } elseif ($_POST['operation'] == 'savePage') {
+        if ($_POST['save_page'] == 'same') {
+            $page = $_POST['selected_page'];
+        } else { // new
+            $page = $designerCommon->createNewPage($_POST['selected_value'], $_POST['db']);
+            $response->addJSON('id', $page);
+        }
+        $success = $designerCommon->saveTablePositions($page);
+        $response->setRequestStatus($success);
+    } elseif ($_POST['operation'] == 'setDisplayField') {
+        [
+            $success,
+            $message,
+        ] = $designerCommon->saveDisplayField(
+            $_POST['db'],
+            $_POST['table'],
+            $_POST['field']
+        );
+        $response->setRequestStatus($success);
+        $response->addJSON('message', $message);
+    } elseif ($_POST['operation'] == 'addNewRelation') {
+        list($success, $message) = $designerCommon->addNewRelation(
+            $_POST['db'],
+            $_POST['T1'],
+            $_POST['F1'],
+            $_POST['T2'],
+            $_POST['F2'],
+            $_POST['on_delete'],
+            $_POST['on_update'],
+            $_POST['DB1'],
+            $_POST['DB2']
+        );
+        $response->setRequestStatus($success);
+        $response->addJSON('message', $message);
+    } elseif ($_POST['operation'] == 'removeRelation') {
+        list($success, $message) = $designerCommon->removeRelation(
+            $_POST['T1'],
+            $_POST['F1'],
+            $_POST['T2'],
+            $_POST['F2']
+        );
+        $response->setRequestStatus($success);
+        $response->addJSON('message', $message);
+    } elseif ($_POST['operation'] == 'save_setting_value') {
+        $success = $designerCommon->saveSetting($_POST['index'], $_POST['value']);
+        $response->setRequestStatus($success);
+    }
+
+    return;
+}
+
+require ROOT_PATH . 'libraries/db_common.inc.php';
+
+$script_display_field = $designerCommon->getTablesInfo();
+
+$display_page = -1;
+$selected_page = null;
+
+if (isset($_GET['query'])) {
+    $display_page = $designerCommon->getDefaultPage($_GET['db']);
+} elseif (! empty($_GET['page'])) {
+    $display_page = $_GET['page'];
+} else {
+    $display_page = $designerCommon->getLoadingPage($_GET['db']);
+}
+if ($display_page != -1) {
+    $selected_page = $designerCommon->getPageName($display_page);
+}
+$tab_pos = $designerCommon->getTablePositions($display_page);
+
+$fullTableNames = [];
+
+foreach ($script_display_field as $designerTable) {
+    $fullTableNames[] = $designerTable->getDbTableString();
+}
+
+foreach ($tab_pos as $position) {
+    if (! in_array($position['dbName'] . '.' . $position['tableName'], $fullTableNames)) {
+        foreach ($designerCommon->getTablesInfo($position['dbName'], $position['tableName']) as $designerTable) {
+            $script_display_field[] = $designerTable;
+        }
+    }
+}
+
+
+$tab_column = $designerCommon->getColumnsInfo($script_display_field);
+$script_tables = $designerCommon->getScriptTabs($script_display_field);
+$tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys($script_display_field);
+$tables_all_keys = $designerCommon->getAllKeys($script_display_field);
+$classes_side_menu = $databaseDesigner->returnClassNamesFromMenuButtons();
+
+
+$script_contr = $designerCommon->getScriptContr($script_display_field);
+
+$params = ['lang' => $GLOBALS['lang']];
+if (isset($_GET['db'])) {
+    $params['db'] = $_GET['db'];
+}
+
+$response = Response::getInstance();
+$response->getFooter()->setMinimal();
+$header   = $response->getHeader();
+$header->setBodyId('designer_body');
+
+$scripts  = $header->getScripts();
+$scripts->addFile('vendor/jquery/jquery.fullscreen.js');
+$scripts->addFile('designer/database.js');
+$scripts->addFile('designer/objects.js');
+$scripts->addFile('designer/page.js');
+$scripts->addFile('designer/history.js');
+$scripts->addFile('designer/move.js');
+$scripts->addFile('designer/init.js');
+
+list(
+    $tables,
+    $num_tables,
+    $total_num_tables,
+    $sub_part,
+    $is_show_stats,
+    $db_is_system_schema,
+    $tooltip_truename,
+    $tooltip_aliasname,
+    $pos
+) = PhpMyAdmin\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
+
+// Embed some data into HTML, later it will be read
+// by designer/init.js and converted to JS variables.
+$response->addHTML(
+    $databaseDesigner->getHtmlForMain(
+        $db,
+        $_GET['db'],
+        $script_display_field,
+        $script_tables,
+        $script_contr,
+        $script_display_field,
+        $display_page,
+        isset($_GET['query']),
+        $selected_page,
+        $classes_side_menu,
+        $tab_pos,
+        $tab_column,
+        $tables_all_keys,
+        $tables_pk_or_unique_keys
+    )
+);
+
+$response->addHTML('<div id="PMA_disable_floating_menubar"></div>');