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