libraries/pmd_common.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * @package PhpMyAdmin-Designer
   5  */
   6
   7 /**
   8  *
   9  */
  10 require_once './libraries/common.inc.php';
  11 // not understand
  12 require_once './libraries/header_http.inc.php';
  13
  14 $GLOBALS['PMD']['STYLE']          = 'default';
  15
  16 $cfgRelation = PMA_getRelationsParam();
  17
  18 $GLOBALS['script_display_field'] =
  19     '<script type="text/javascript">' . "\n" .
  20     '// <![CDATA[' . "\n" .
  21     'var display_field = new Array();' . "\n";
  22
  23 /**
  24  * retrieves table info and stores it in $GLOBALS['PMD']
  25  *
  26  */
  27 function get_tabs()
  28 {
  29     $GLOBALS['PMD']['TABLE_NAME'] = array();// that foreach no error
  30     $GLOBALS['PMD']['OWNER'] = array();
  31     $GLOBALS['PMD']['TABLE_NAME_SMALL'] = array();
  32
  33     $tables = PMA_DBI_get_tables_full($GLOBALS['db']);
  34     // seems to be needed later
  35     PMA_DBI_select_db($GLOBALS['db']);
  36     $i = 0;
  37     foreach ($tables as $one_table) {
  38         $GLOBALS['PMD']['TABLE_NAME'][$i] = $GLOBALS['db'] . "." . $one_table['TABLE_NAME'];
  39         $GLOBALS['PMD']['OWNER'][$i] = $GLOBALS['db'];
  40         $GLOBALS['PMD']['TABLE_NAME_SMALL'][$i] = $one_table['TABLE_NAME'];
  41
  42         $GLOBALS['PMD_URL']['TABLE_NAME'][$i] = urlencode($GLOBALS['db'] . "." . $one_table['TABLE_NAME']);
  43         $GLOBALS['PMD_URL']['OWNER'][$i] = urlencode($GLOBALS['db']);
  44         $GLOBALS['PMD_URL']['TABLE_NAME_SMALL'][$i] = urlencode($one_table['TABLE_NAME']);
  45
  46         $GLOBALS['PMD_OUT']['TABLE_NAME'][$i] = htmlspecialchars($GLOBALS['db'] . "." . $one_table['TABLE_NAME'], ENT_QUOTES);
  47         $GLOBALS['PMD_OUT']['OWNER'][$i] = htmlspecialchars($GLOBALS['db'], ENT_QUOTES);
  48         $GLOBALS['PMD_OUT']['TABLE_NAME_SMALL'][$i] = htmlspecialchars($one_table['TABLE_NAME'], ENT_QUOTES);
  49
  50         $GLOBALS['PMD']['TABLE_TYPE'][$i] = strtoupper($one_table['ENGINE']);
  51
  52         $DF = PMA_getDisplayField($GLOBALS['db'], $one_table['TABLE_NAME']);
  53         if ($DF != '') {
  54             $GLOBALS['script_display_field'] .= "  display_field['"
  55                 . $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . "'] = '"
  56                 . urlencode($DF) . "';\n";
  57         }
  58
  59         $i++;
  60     }
  61
  62     $GLOBALS['script_display_field'] .=
  63         '// ]]>' . "\n" .
  64         '</script>' . "\n";
  65     //  return $GLOBALS['PMD'];       // many bases // not use ??????
  66 }
  67
  68 /**
  69  * retrieves table column info
  70  *
  71  * @return  array   table column nfo
  72  */
  73 function get_tab_info()
  74 {
  75     PMA_DBI_select_db($GLOBALS['db']);
  76     $tab_column = array();
  77     for ($i = 0, $cnt = count($GLOBALS['PMD']["TABLE_NAME"]); $i < $cnt; $i++) {
  78         $fields_rs   = PMA_DBI_query(PMA_DBI_get_columns_sql($GLOBALS['db'], $GLOBALS['PMD']["TABLE_NAME_SMALL"][$i], null, true), null, PMA_DBI_QUERY_STORE);
  79         $j = 0;
  80         while ($row = PMA_DBI_fetch_assoc($fields_rs)) {
  81             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_ID'][$j]   = $j;
  82             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_NAME'][$j] = $row['Field'];
  83             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['TYPE'][$j]        = $row['Type'];
  84             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['NULLABLE'][$j]    = $row['Null'];
  85             $j++;
  86         }
  87     }
  88     return $tab_column;
  89 }
  90
  91 /**
  92  * returns JavaScript code for intializing vars
  93  *
  94  * @return string   JavaScript code
  95  */
  96 function get_script_contr()
  97 {
  98     PMA_DBI_select_db($GLOBALS['db']);
  99     $con["C_NAME"] = array();
 100     $i = 0;
 101     $alltab_rs  = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($GLOBALS['db']), null, PMA_DBI_QUERY_STORE);
 102     while ($val = @PMA_DBI_fetch_row($alltab_rs)) {
 103         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'internal');
 104         //echo "<br> internal ".$GLOBALS['db']." - ".$val[0]." - ";
 105         //print_r($row);
 106         if ($row !== false) {
 107             foreach ($row as $field => $value) {
 108                 $con['C_NAME'][$i] = '';
 109                 $con['DTN'][$i]    = urlencode($GLOBALS['db'] . "." . $val[0]);
 110                 $con['DCN'][$i]    = urlencode($field);
 111                 $con['STN'][$i]    = urlencode($value['foreign_db'] . "." . $value['foreign_table']);
 112                 $con['SCN'][$i]    = urlencode($value['foreign_field']);
 113                 $i++;
 114             }
 115         }
 116         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'foreign');
 117         //echo "<br> INNO ";
 118         //print_r($row);
 119         if ($row !== false) {
 120             foreach ($row as $field => $value) {
 121                 $con['C_NAME'][$i] = '';
 122                 $con['DTN'][$i]    = urlencode($GLOBALS['db'].".".$val[0]);
 123                 $con['DCN'][$i]    = urlencode($field);
 124                 $con['STN'][$i]    = urlencode($value['foreign_db'].".".$value['foreign_table']);
 125                 $con['SCN'][$i]    = urlencode($value['foreign_field']);
 126                 $i++;
 127             }
 128         }
 129     }
 130
 131     $ti = 0;
 132     $script_contr =
 133         '<script type="text/javascript">' . "\n" .
 134         '// <![CDATA[' . "\n" .
 135         'var contr = new Array();' . "\n";
 136     for ($i = 0, $cnt = count($con["C_NAME"]); $i < $cnt; $i++) {
 137         $js_var = ' contr[' . $ti . ']';
 138         $script_contr .= $js_var . " = new Array();\n";
 139         $js_var .= "['" . $con['C_NAME'][$i] . "']";
 140         $script_contr .= $js_var . " = new Array();\n";
 141         if (in_array($con['DTN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])
 142          && in_array($con['STN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])) {
 143             $js_var .= "['" . $con['DTN'][$i] . "']";
 144             $script_contr .= $js_var . " = new Array();\n";
 145             $m_col = array();//}
 146             $js_var .= "['" . $con['DCN'][$i] . "']";
 147             $script_contr .= $js_var . " = new Array();\n";//}
 148             $script_contr .= $js_var . "[0] = '" . $con['STN'][$i] . "';\n"; //
 149             $script_contr .= $js_var . "[1] = '" . $con['SCN'][$i] . "';\n"; //
 150         }
 151         $ti++;
 152     }
 153     $script_contr .=
 154         '// ]]>' . "\n" .
 155         '</script>' . "\n";
 156     return $script_contr;
 157 }
 158
 159 /**
 160  * @return  array unique or primary indizes
 161  */
 162 function get_pk_or_unique_keys()
 163 {
 164     return get_all_keys(true);
 165 }
 166
 167 /**
 168  * returns all indizes
 169  *
 170  * @param boolean whether to include ony unique ones
 171  * @return  array indizes
 172  */
 173 function get_all_keys($unique_only = false)
 174 {
 175     include_once './libraries/Index.class.php';
 176
 177     $keys = array();
 178
 179     foreach ($GLOBALS['PMD']['TABLE_NAME_SMALL'] as $I => $table) {
 180         $schema = $GLOBALS['PMD']['OWNER'][$I];
 181         // for now, take into account only the first index segment
 182         foreach (PMA_Index::getFromTable($table, $schema) as $index) {
 183             if ($unique_only && ! $index->isUnique()) {
 184                 continue;
 185             }
 186             $columns = $index->getColumns();
 187             foreach ($columns as $column_name => $dummy) {
 188                 $keys[$schema . '.' .$table . '.' . $column_name] = 1;
 189             }
 190         }
 191     }
 192     return $keys;
 193 }
 194
 195 /**
 196  *
 197  *
 198  * @return  array   ???
 199  */
 200 function get_script_tabs()
 201 {
 202     $script_tabs =
 203         '<script type="text/javascript">' . "\n" .
 204         '// <![CDATA[' . "\n" .
 205         'var j_tabs = new Array();' . "\n" .
 206         'var h_tabs = new Array();' . "\n" ;
 207     for ($i = 0, $cnt = count($GLOBALS['PMD']['TABLE_NAME']); $i < $cnt; $i++) {
 208         $script_tabs .= "j_tabs['" . $GLOBALS['PMD_URL']['TABLE_NAME'][$i] . "'] = '"
 209             . (PMA_foreignkey_supported($GLOBALS['PMD']['TABLE_TYPE'][$i]) ? '1' : '0') . "';\n";
 210         $script_tabs .="h_tabs['" . $GLOBALS['PMD_URL']['TABLE_NAME'][$i] . "'] = 1;"."\n" ;
 211     }
 212     $script_tabs .=
 213         '// ]]>' . "\n" .
 214         '</script>' . "\n";
 215     return $script_tabs;
 216 }
 217
 218 /**
 219  * @return  array   table positions and sizes
 220  */
 221 function get_tab_pos()
 222 {
 223     $cfgRelation = PMA_getRelationsParam();
 224
 225     if (! $cfgRelation['designerwork']) {
 226         return null;
 227     }
 228
 229     $query = "
 230          SELECT CONCAT_WS('.', `db_name`, `table_name`) AS `name`,
 231                 `x` AS `X`,
 232                 `y` AS `Y`,
 233                 `v` AS `V`,
 234                 `h` AS `H`
 235            FROM " . PMA_backquote($cfgRelation['db']) . "." . PMA_backquote($cfgRelation['designer_coords']);
 236     $tab_pos = PMA_DBI_fetch_result($query, 'name', null, $GLOBALS['controllink'], PMA_DBI_QUERY_STORE);
 237     return count($tab_pos) ? $tab_pos : null;
 238 }
 239
 240 /**
 241  * returns  distinct values from $GLOBALS['PMD']['OWNER']
 242  *
 243  * @return  array   owner
 244  */
 245 function get_owners()
 246 {
 247     return array_values(array_unique($GLOBALS['PMD']['OWNER']));
 248 }
 249
 250 get_tabs();
 251 ?>