pdf_pages.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Gets some core libraries
   8  */
   9 require('./libraries/grab_globals.lib.php3');
  10 require('./libraries/common.lib.php3');
  11 require('./db_details_common.php3');
  12
  13
  14 /**
  15  * Settings for relation stuff
  16  */
  17 require('./libraries/relation.lib.php3');
  18 $cfgRelation = PMA_getRelationsParam();
  19
  20
  21 /**
  22  * Now in ./libraries/relation.lib.php3 we check for all tables
  23  * that we need, but if we don't find them we are quiet about it
  24  * so people can work without.
  25  * This page is absolutely useless if you didn't set up your tables
  26  * correctly, so it is a good place to see which tables we can and
  27  * complain ;-)
  28  */
  29 if (!$cfgRelation['relwork']) {
  30     echo sprintf($strNotSet, 'relation', 'config.inc.php3') . '<br />' . "\n"
  31          . '<a href="./Documentation.html#relation" target="documentation">' . $strDocu . '</a>' . "\n";
  32     exit();
  33 }
  34
  35 if (!$cfgRelation['displaywork']) {
  36     echo sprintf($strNotSet, 'table_info', 'config.inc.php3') . '<br />' . "\n"
  37          . '<a href="./Documentation.html#table_info" target="documentation">' . $strDocu . '</a>' . "\n";
  38     exit();
  39 }
  40
  41 if (!isset($cfgRelation['table_coords'])){
  42     echo sprintf($strNotSet, 'table_coords', 'config.inc.php3') . '<br />' . "\n"
  43          . '<a href="./Documentation.html#table_coords" target="documentation">' . $strDocu . '</a>' . "\n";
  44     exit();
  45 }
  46 if (!isset($cfgRelation['pdf_pages'])) {
  47     echo sprintf($strNotSet, 'pdf_page', 'config.inc.php3') . '<br />' . "\n"
  48          . '<a href="./Documentation.html#pdf_pages" target="documentation">' . $strDocu . '</a>' . "\n";
  49     exit();
  50 }
  51
  52 if ($cfgRelation['pdfwork']) {
  53     // Now is the time to work on all changes
  54     if (isset($do)) {
  55         switch ($do) {
  56             case 'choosepage':
  57                 if ($action_choose=="1") {
  58                     $ch_query = 'DELETE FROM ' . PMA_backquote($cfgRelation['table_coords'])
  59                               .   ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
  60                               .   ' AND   pdf_page_number = ' . $chpage;
  61                     PMA_query_as_cu($ch_query);
  62
  63                     $ch_query = 'DELETE FROM ' . PMA_backquote($cfgRelation['pdf_pages'])
  64                               .   ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
  65                               .   ' AND   page_nr = ' . $chpage;
  66                     PMA_query_as_cu($ch_query);
  67                 }
  68                 break;
  69             case 'createpage':
  70                 if (!isset($newpage) || $newpage == '') {
  71                     $newpage = $strNoDescription;
  72                 }
  73                 $ins_query   = 'INSERT INTO ' . PMA_backquote($cfgRelation['pdf_pages'])
  74                              . ' (db_name, page_descr)'
  75                              . ' VALUES (\'' . PMA_sqlAddslashes($db) . '\', \'' . PMA_sqlAddslashes($newpage) . '\')';
  76                 PMA_query_as_cu($ins_query);
  77
  78                 // A u t o m a t i c    l a y o u t
  79
  80                 if (isset($autolayout)) {
  81                     // save the page number
  82                     $pdf_page_number = mysql_insert_id((isset($dbh)?$dbh:''));
  83
  84                     // get the tables that have relations, by descending
  85                     // number of links
  86                     $master_tables = 'SELECT COUNT(master_table), master_table'
  87                                 . ' FROM ' . PMA_backquote($cfgRelation['relation'])
  88                                 . ' WHERE master_db = \'' . $db . '\''
  89                                 . ' GROUP BY master_table'
  90                                 . ' ORDER BY ' . PMA_backquote('COUNT(master_table)') . ' DESC ';
  91                     $master_tables_rs = PMA_query_as_cu($master_tables);
  92                     if ($master_tables_rs && mysql_num_rows($master_tables_rs) > 0) {
  93                         // first put all the master tables at beginning
  94                         // of the list, so they are near the center of
  95                         // the schema
  96                         while (list(,$master_table) = mysql_fetch_row($master_tables_rs)) {
  97                             $all_tables[] = $master_table;
  98                         }
  99
 100                         // then for each master, add its foreigns into an array
 101                         // of foreign tables, if not already there
 102                         // (a foreign might be foreign for more than
 103                         // one table, and might be a master itself)
 104
 105                         $foreign_tables = array();
 106                         while (list(,$master_table) = each($all_tables)) {
 107                             $foreigners = PMA_getForeigners($db, $master_table);
 108                             while (list(, $foreigner) = each($foreigners)) {
 109                                 if (!in_array($foreigner['foreign_table'], $foreign_tables)) {
 110                                     $foreign_tables[] = $foreigner['foreign_table'];
 111                                 }
 112                             }
 113                         }
 114
 115                         // then merge the arrays
 116
 117                         while (list(,$foreign_table) = each($foreign_tables)) {
 118                             if (!in_array($foreign_table, $all_tables)) {
 119                                 $all_tables[] = $foreign_table;
 120                             }
 121
 122                         }
 123                         // now generate the coordinates for the schema,
 124                         // in a clockwise spiral
 125
 126                         $pos_x = 500;
 127                         $pos_y = 500;
 128                         $delta = 50;
 129                         $delta_mult = 1.34;
 130                         $direction = "right";
 131                         reset($all_tables);
 132
 133                         while (list(,$current_table) = each($all_tables)) {
 134
 135                             // save current table's coordinates
 136                             $insert_query = 'INSERT INTO ' . PMA_backquote($cfgRelation['table_coords']) . ' '
 137                                           . '(db_name, table_name, pdf_page_number, x, y) '
 138                                           . 'VALUES (\'' . PMA_sqlAddslashes($db) . '\', \'' . PMA_sqlAddslashes($current_table) . '\',' . $pdf_page_number . ',' . $pos_x . ',' . $pos_y . ')';
 139                             PMA_query_as_cu($insert_query);
 140
 141
 142                             // compute for the next table
 143                             switch ($direction) {
 144                                 case 'right':
 145                                     $pos_x += $delta;
 146                                     $direction = "down";
 147                                     $delta *= $delta_mult;
 148                                     break;
 149                                 case 'down':
 150                                     $pos_y += $delta;
 151                                     $direction = "left";
 152                                     $delta *= $delta_mult;
 153                                     break;
 154                                 case 'left':
 155                                     $pos_x -= $delta;
 156                                     $direction = "up";
 157                                     $delta *= $delta_mult;
 158                                     break;
 159                                 case 'up':
 160                                     $pos_y -= $delta;
 161                                     $direction = "right";
 162                                     $delta *= $delta_mult;
 163                                     break;
 164                             } // end switch
 165                         } // end while
 166                     } // end if there are master tables
 167
 168                     $chpage = $pdf_page_number;
 169                 } // end if isset autolayout
 170
 171                 break;
 172
 173             case 'edcoord':
 174                 for ($i = 0; $i < $c_table_rows; $i++) {
 175                     $arrvalue = 'c_table_' . $i;
 176                     $arrvalue = $$arrvalue;
 177                     if (!isset($arrvalue['x']) || $arrvalue['x'] == '') {
 178                         $arrvalue['x'] = 0;
 179                     }
 180                     if (!isset($arrvalue['y']) || $arrvalue['y'] == '') {
 181                         $arrvalue['y'] = 0;
 182                     }
 183                     if (isset($arrvalue['name']) && $arrvalue['name'] != '--') {
 184                         $test_query = 'SELECT * FROM ' . PMA_backquote($cfgRelation['table_coords'])
 185                                     .   ' WHERE db_name = \'' .  PMA_sqlAddslashes($db) . '\''
 186                                     .   ' AND   table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\''
 187                                     .   ' AND   pdf_page_number = ' . $chpage;
 188                         $test_rs    = PMA_query_as_cu($test_query);
 189                         if ($test_rs && mysql_num_rows($test_rs) > 0) {
 190                             if (isset($arrvalue['delete']) && $arrvalue['delete'] == 'y') {
 191                                 $ch_query = 'DELETE FROM ' . PMA_backquote($cfgRelation['table_coords'])
 192                                           .   ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
 193                                           .   ' AND   table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\''
 194                                           .   ' AND   pdf_page_number = ' . $chpage;
 195                             } else {
 196                                 $ch_query = 'UPDATE ' . PMA_backquote($cfgRelation['table_coords']) . ' '
 197                                           . 'SET x = ' . $arrvalue['x'] . ', y= ' . $arrvalue['y']
 198                                           .   ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
 199                                           .   ' AND   table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\''
 200                                           .   ' AND   pdf_page_number = ' . $chpage;
 201                             }
 202                         } else {
 203                             $ch_query     = 'INSERT INTO ' . PMA_backquote($cfgRelation['table_coords']) . ' '
 204                                           . '(db_name, table_name, pdf_page_number, x, y) '
 205                                           . 'VALUES (\'' . PMA_sqlAddslashes($db) . '\', \'' . PMA_sqlAddslashes($arrvalue['name']) . '\',' . $chpage . ',' . $arrvalue['x'] . ',' . $arrvalue['y'] . ')';
 206                         }
 207                         PMA_query_as_cu($ch_query);
 208                     } // end if
 209                 } // end for
 210                 break;
 211         } // end switch
 212     } // end if (isset($do))
 213
 214     // We will need an array of all tables in this db
 215     $selectboxall[] = '--';
 216     $alltab_qry     = 'SHOW TABLES FROM ' . PMA_backquote($db);
 217     $alltab_rs      = @PMA_mysql_query($alltab_qry) or PMA_mysqlDie('', $alltab_qry, '', $err_url_0);
 218     while (list($table) = @PMA_mysql_fetch_array($alltab_rs)) {
 219         $selectboxall[] = $table;
 220     }
 221
 222     // Now first show some possibility to choose a page for the pdf
 223     $page_query = 'SELECT * FROM ' . PMA_backquote($cfgRelation['pdf_pages'])
 224                 . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'';
 225     $page_rs    = PMA_query_as_cu($page_query);
 226     if ($page_rs && mysql_num_rows($page_rs) > 0) {
 227         ?>
 228 <form method="post" action="pdf_pages.php3" name="selpage">
 229     <?php echo $strChoosePage . "\n"; ?>
 230     <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 231     <input type="hidden" name="do" value="choosepage" />
 232     <select name="chpage" onchange="this.form.submit()">
 233         <?php
 234         while ($curr_page = @PMA_mysql_fetch_array($page_rs)) {
 235             echo "\n" . '        '
 236                  . '<option value="' . $curr_page['page_nr'] . '"';
 237             if (isset($chpage) && $chpage == $curr_page['page_nr']) {
 238                 echo ' selected="selected"';
 239             }
 240             echo '>' . $curr_page['page_nr'] . ': ' . $curr_page['page_descr'] . '</option>';
 241         } // end while
 242         echo "\n";
 243         ?>
 244     </select>
 245     <input type="radio" name="action_choose" value="0" id="radio_choose0" checked="checked" style="vertical-align: middle" /> <label for="radio_choose0">
 246 <?php echo $strEdit; ?> </label>
 247     <input type="radio" name="action_choose" value="1" id="radio_choose1"  style="vertical-align: middle" /> <label for="radio_choose1">
 248 <?php echo $strDelete; ?> </label>
 249
 250     <input type="submit" value="<?php echo $strGo; ?>" />
 251 </form>
 252         <?php
 253     }
 254     echo "\n";
 255
 256     // Possibility to create a new page:
 257     ?>
 258 <form method="post" action="pdf_pages.php3" name="crpage">
 259     <?php echo $strCreatePage . "\n"; ?>
 260     <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 261     <input type="hidden" name="do" value="createpage" />
 262     <input type="text" name="newpage" size="20" maxlength="50" />
 263     <input type="checkbox" name="autolayout" />
 264     <?php echo '(' . $strAutomaticLayout . ')' . "\n"; ?>
 265     <input type="submit" value="<?php echo $strGo; ?>" />
 266 </form>
 267     <?php
 268     // Now if we already have chosen a page number then we should show the
 269     // tables involved
 270     if (isset($chpage) && $chpage > 0) {
 271         echo "\n";
 272         ?>
 273 <hr />
 274
 275 <h2><?php echo $strSelectTables ;?></h2>
 276 <form method="post" action="pdf_pages.php3" name="edcoord">
 277     <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 278     <input type="hidden" name="chpage" value="<?php echo $chpage; ?>" />
 279     <input type="hidden" name="do" value="edcoord" />
 280     <table border="0">
 281     <tr>
 282         <th><?php echo $strTable; ?></th>
 283         <th><?php echo $strDelete; ?></th>
 284         <th>X</th>
 285         <th>Y</th>
 286     </tr>
 287         <?php
 288         if (isset($ctable)) {
 289             unset($ctable);
 290         }
 291
 292         $page_query = 'SELECT * FROM ' . PMA_backquote($cfgRelation['table_coords'])
 293                     . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
 294                     . ' AND pdf_page_number = ' . $chpage;
 295         $page_rs    = PMA_query_as_cu($page_query);
 296
 297         $i = 0;
 298         while ($sh_page = @PMA_mysql_fetch_array($page_rs)) {
 299             echo "\n" . '    <tr ';
 300             if ($i % 2 == 0) {
 301                 echo 'bgcolor="' . $cfg['BgcolorOne'] . '"';
 302             } else {
 303                 echo 'bgcolor="' . $cfg['BgcolorTwo'] . '"';
 304             }
 305             echo '>';
 306             echo "\n" . '        <td>'
 307                  . "\n" . '            <select name="c_table_' . $i . '[name]">';
 308             reset($selectboxall);
 309             while (list($key, $value) = each($selectboxall)) {
 310                 echo "\n" . '                <option value="' . $value . '"';
 311                 if ($value == $sh_page['table_name']) {
 312                     echo ' selected="selected"';
 313                 }
 314                 echo '>' . $value . '</option>';
 315             } // end while
 316             echo "\n" . '            </select>'
 317                  . "\n" . '        </td>';
 318             echo "\n" . '        <td>'
 319                  . "\n" . '            <input type="checkbox" name="c_table_' . $i . '[delete]" value="y" />' . $strDelete;
 320             echo "\n" . '        </td>';
 321             echo "\n" . '        <td>'
 322                  . "\n" . '            <input type="text" name="c_table_' . $i . '[x]" value="' . $sh_page['x'] . '" />';
 323             echo "\n" . '        </td>';
 324             echo "\n" . '        <td>'
 325                  . "\n" . '            <input type="text" name="c_table_' . $i . '[y]" value="' . $sh_page['y'] . '" />';
 326             echo "\n" . '        </td>';
 327             echo "\n" . '    </tr>';
 328             $i++;
 329         } // end while
 330         // Do one more empty row
 331         echo "\n" . '    <tr ';
 332         if ($i % 2 == 0) {
 333             echo 'bgcolor="' . $cfg['BgcolorOne'] . '"';
 334         } else {
 335             echo 'bgcolor="' . $cfg['BgcolorTwo'] . '"';
 336         }
 337         echo '>';
 338         echo "\n" . '        <td>'
 339              . "\n" . '            <select name="c_table_' . $i . '[name]">';
 340         reset($selectboxall);
 341         while (list($key, $value) = each($selectboxall)) {
 342             echo "\n" . '                <option value="' . $value . '">' . $value . '</option>';
 343         }
 344         echo "\n" . '            </select>'
 345              . "\n" . '        </td>';
 346         echo "\n" . '        <td>'
 347              . "\n" . '            <input type="checkbox" name="c_table_' . $i . '[delete]" value="y" />' . $strDelete;
 348         echo "\n" . '        </td>';
 349         echo "\n" . '        <td>'
 350              . "\n" . '            <input type="text" name="c_table_' . $i . '[x]" value="' . $sh_page['x'] . '" />';
 351         echo "\n" . '        </td>';
 352         echo "\n" . '        <td>'
 353              . "\n" . '            <input type="text" name="c_table_' . $i . '[y]" value="' . $sh_page['y'] . '" />';
 354         echo "\n" . '        </td>';
 355         echo "\n" . '    </tr>';
 356         echo "\n" . '    </table>' . "\n";
 357
 358         echo "\n" . '    <input type="hidden" name="c_table_rows" value="' . ($i + 1) . '" />';
 359         echo "\n" . '    <input type="submit" value="' . $strGo . '" />';
 360         echo "\n" . '</form>' . "\n\n";
 361     } // end if
 362
 363     //    ------------------------------------
 364     //    d i s p l a y   p d f    s c h e m a
 365     //    ------------------------------------
 366
 367     if (isset($do)
 368     && ($do == 'edcoord'
 369        || $do == 'choosepage'
 370        || ($do == 'createpage' && isset($chpage)))) {
 371         ?>
 372 <form method="post" action="pdf_schema.php3">
 373     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 374     <input type="hidden" name="pdf_page_number" value="<?php echo $chpage; ?>" />
 375     <?php echo $strDisplayPDF; ?>&nbsp;:<br />
 376     <input type="checkbox" name="show_grid" id="show_grid_opt" />
 377     <label for="show_grid_opt"><?php echo $strShowGrid; ?></label><br />
 378     <input type="checkbox" name="show_color" id="show_color_opt" checked="checked" />
 379     <label for="show_color_opt"><?php echo $strShowColor; ?></label><br />
 380     <input type="checkbox" name="show_table_dimension" id="show_table_dim_opt" />
 381     <label for="show_table_dim_opt"><?php echo $strShowTableDimension; ?></label><br />
 382     <input type="checkbox" name="all_tab_same_wide" id="all_tab_same_wide" />
 383     <label for="all_tab_same_wide"><?php echo $strAllTableSameWidth; ?></label><br />
 384     <input type="checkbox" name="with_doc" id="with_doc" checked="checked" />
 385     <label for="with_doc"><?php echo $strDataDict; ?></label> <br />
 386     <?php echo $strShowDatadictAs; ?>
 387     <select name="orientation">
 388         <option value="L"><?php echo $strLandscape;?></option>
 389         <option value="P"><?php echo $strPortrait;?></option>
 390     </select>
 391     &nbsp;&nbsp;<input type="submit" value="<?php echo $strGo; ?>" />
 392 </form>
 393         <?php
 394     } // end if
 395 } // end if ($cfgRelation['pdfwork'])
 396
 397
 398 /**
 399  * Displays the footer
 400  */
 401 echo "\n";
 402 require('./footer.inc.php3');
 403 ?>