aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/db_designer.php
diff options
context:
space:
mode:
Diffstat (limited to 'srcs/phpmyadmin/db_designer.php')
-rw-r--r--srcs/phpmyadmin/db_designer.php221
1 files changed, 0 insertions, 221 deletions
diff --git a/srcs/phpmyadmin/db_designer.php b/srcs/phpmyadmin/db_designer.php
deleted file mode 100644
index 064b4b2..0000000
--- a/srcs/phpmyadmin/db_designer.php
+++ /dev/null
@@ -1,221 +0,0 @@
-<?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>');