db_designer.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * phpMyAdmin designer general code
   5  *
   6  * @package PhpMyAdmin-Designer
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10 require_once 'libraries/pmd_common.php';
  11 require_once 'libraries/db_designer.lib.php';
  12
  13 $response = PMA_Response::getInstance();
  14
  15 if (isset($_REQUEST['dialog'])) {
  16
  17     if ($_REQUEST['dialog'] == 'edit') {
  18         $html = PMA_getHtmlForEditOrDeletePages($GLOBALS['db'], 'editPage');
  19     } else if ($_REQUEST['dialog'] == 'delete') {
  20         $html = PMA_getHtmlForEditOrDeletePages($GLOBALS['db'], 'deletePage');
  21     } else if ($_REQUEST['dialog'] == 'save_as') {
  22         $html = PMA_getHtmlForPageSaveAs($GLOBALS['db']);
  23     } else if ($_REQUEST['dialog'] == 'export') {
  24         include_once 'libraries/plugin_interface.lib.php';
  25         $html = PMA_getHtmlForSchemaExport(
  26             $GLOBALS['db'], $_REQUEST['selected_page']
  27         );
  28     }
  29
  30     if (! empty($html)) {
  31         $response->addHTML($html);
  32     }
  33     return;
  34 }
  35
  36 if (isset($_REQUEST['operation'])) {
  37
  38     if ($_REQUEST['operation'] == 'deletePage') {
  39         $success = PMA_deletePage($_REQUEST['selected_page']);
  40         $response->isSuccess($success);
  41     } elseif ($_REQUEST['operation'] == 'savePage') {
  42         if ($_REQUEST['save_page'] == 'same') {
  43             $page = $_REQUEST['selected_page'];
  44         } else { // new
  45             $page = PMA_createNewPage($_REQUEST['selected_value'], $GLOBALS['db']);
  46             $response->addJSON('id', $page);
  47         }
  48         $success = PMA_saveTablePositions($page);
  49         $response->isSuccess($success);
  50     } elseif ($_REQUEST['operation'] == 'setDisplayField') {
  51         PMA_saveDisplayField(
  52             $_REQUEST['db'], $_REQUEST['table'], $_REQUEST['field']
  53         );
  54         $response->isSuccess(true);
  55     } elseif ($_REQUEST['operation'] == 'addNewRelation') {
  56         list($success, $message) = PMA_addNewRelation(
  57             $_REQUEST['db'],
  58             $_REQUEST['T1'],
  59             $_REQUEST['F1'],
  60             $_REQUEST['T2'],
  61             $_REQUEST['F2'],
  62             $_REQUEST['on_delete'],
  63             $_REQUEST['on_update']
  64         );
  65         $response->isSuccess($success);
  66         $response->addJSON('message', $message);
  67     } elseif ($_REQUEST['operation'] == 'removeRelation') {
  68         list($success, $message) = PMA_removeRelation(
  69             $_REQUEST['T1'],
  70             $_REQUEST['F1'],
  71             $_REQUEST['T2'],
  72             $_REQUEST['F2']
  73         );
  74         $response->isSuccess($success);
  75         $response->addJSON('message', $message);
  76     } elseif ($_REQUEST['operation'] == 'save_setting_value') {
  77         $success = PMA_saveDesignerSetting($_REQUEST['index'], $_REQUEST['value']);
  78         $response->isSuccess($success);
  79     }
  80
  81     return;
  82 }
  83
  84 $script_display_field = PMA_getTablesInfo();
  85 $tab_column = PMA_getColumnsInfo();
  86 $script_tables = PMA_getScriptTabs();
  87 $tables_pk_or_unique_keys = PMA_getPKOrUniqueKeys();
  88 $tables_all_keys = PMA_getAllKeys();
  89 $classes_side_menu = PMA_returnClassNamesFromMenuButtons();
  90
  91 $display_page = -1;
  92 $selected_page = null;
  93
  94 if (isset($_REQUEST['query'])) {
  95     $display_page = PMA_getDefaultPage($_REQUEST['db']);
  96 } else {
  97     if (! empty($_REQUEST['page'])) {
  98         $display_page = $_REQUEST['page'];
  99     } else {
 100         $display_page = PMA_getLoadingPage($_REQUEST['db']);
 101     }
 102 }
 103 if ($display_page != -1) {
 104     $selected_page = PMA_getPageName($display_page);
 105 }
 106 $tab_pos = PMA_getTablePositions($display_page);
 107 $script_contr = PMA_getScriptContr();
 108
 109 $params = array('lang' => $GLOBALS['lang']);
 110 if (isset($_GET['db'])) {
 111     $params['db'] = $_GET['db'];
 112 }
 113
 114 $response = PMA_Response::getInstance();
 115 $response->getFooter()->setMinimal();
 116 $header   = $response->getHeader();
 117 $header->setBodyId('pmd_body');
 118
 119 $scripts  = $header->getScripts();
 120 $scripts->addFile('jquery/jquery.fullscreen.js');
 121 $scripts->addFile('pmd/designer_db.js');
 122 $scripts->addFile('pmd/designer_objects.js');
 123 $scripts->addFile('pmd/designer_page.js');
 124 $scripts->addFile('pmd/history.js');
 125 $scripts->addFile('pmd/move.js');
 126 $scripts->addFile('pmd/iecanvas.js', true);
 127 $scripts->addFile('pmd/init.js');
 128
 129 require 'libraries/db_common.inc.php';
 130 require 'libraries/db_info.inc.php';
 131
 132 // Embed some data into HTML, later it will be read
 133 // by pmd/init.js and converted to JS variables.
 134 $response->addHTML(
 135     PMA_getHtmlForJSFields(
 136         $script_tables, $script_contr, $script_display_field, $display_page
 137     )
 138 );
 139 $response->addHTML(
 140     PMA_getDesignerPageMenu(isset($_REQUEST['query']), $selected_page, $classes_side_menu)
 141 );
 142
 143
 144
 145 $response->addHTML('<div id="canvas_outer">');
 146 $response->addHTML(
 147     '<form action="" id="container-form" method="post" name="form1">'
 148 );
 149
 150 $response->addHTML(PMA_getHTMLCanvas());
 151 $response->addHTML(PMA_getHTMLTableList($tab_pos, $display_page));
 152
 153 $response->addHTML(
 154     PMA_getDatabaseTables(
 155         $tab_pos, $display_page, $tab_column,
 156         $tables_all_keys, $tables_pk_or_unique_keys
 157     )
 158 );
 159 $response->addHTML('</form>');
 160 $response->addHTML('</div>'); // end canvas_outer
 161
 162 $response->addHTML('<div id="pmd_hint"></div>');
 163
 164 $response->addHTML(PMA_getNewRelationPanel());
 165 $response->addHTML(PMA_getDeleteRelationPanel());
 166
 167 if (isset($_REQUEST['query'])) {
 168     $response->addHTML(PMA_getOptionsPanel());
 169     $response->addHTML(PMA_getRenameToPanel());
 170     $response->addHTML(PMA_getHavingQueryPanel());
 171     $response->addHTML(PMA_getAggregateQueryPanel());
 172     $response->addHTML(PMA_getWhereQueryPanel());
 173     $response->addHTML(PMA_getQueryDetails());
 174 }
 175
 176 $response->addHTML('<div id="PMA_disable_floating_menubar"></div>');