pmd_pdf.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin-Designer
   6  */
   7
   8 require_once './libraries/common.inc.php';
   9 require_once 'libraries/pmd_common.php';
  10
  11 /**
  12  * If called directly from the designer, first save the positions
  13  */
  14 if (! isset($scale)) {
  15     $no_die_save_pos = 1;
  16     include_once 'pmd_save_pos.php';
  17 }
  18
  19 if (isset($mode)) {
  20     if ('create_export' != $mode && empty($pdf_page_number)) {
  21         die("<script>alert('Pages not found!');history.go(-2);</script>");
  22     }
  23
  24     $pmd_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($GLOBALS['cfgRelation']['designer_coords']);
  25     $pma_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']);
  26     $scale_q = PMA_sqlAddSlashes($scale);
  27
  28     if ('create_export' == $mode) {
  29         $pdf_page_number = PMA_REL_create_page($newpage, $cfgRelation, $db);
  30         if ($pdf_page_number > 0) {
  31             $message = PMA_Message::success(__('Page has been created'));
  32             $mode = 'export';
  33         } else {
  34             $message = PMA_Message::error(__('Page creation failed'));
  35         }
  36     }
  37
  38     $pdf_page_number_q = PMA_sqlAddSlashes($pdf_page_number);
  39
  40     if ('export' == $mode) {
  41         $sql = "REPLACE INTO " . $pma_table . " (db_name, table_name, pdf_page_number, x, y) SELECT db_name, table_name, " . $pdf_page_number_q . ", ROUND(x/" . $scale_q . ") , ROUND(y/" . $scale_q . ") y FROM " . $pmd_table . " WHERE db_name = '" . PMA_sqlAddSlashes($db) . "'";
  42
  43         PMA_query_as_controluser($sql, true, PMA_DBI_QUERY_STORE);
  44     }
  45
  46     if ('import' == $mode) {
  47         PMA_query_as_controluser(
  48             'UPDATE ' . $pma_table . ',' . $pmd_table .
  49             ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale_q . ',
  50             ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '. $scale_q .'
  51             WHERE
  52             ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name`
  53             AND
  54             ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name`
  55             AND
  56             ' . $pmd_table . '.`db_name`=\''. PMA_sqlAddSlashes($db) .'\'
  57             AND pdf_page_number = ' . $pdf_page_number_q . ';',
  58             true, PMA_DBI_QUERY_STORE
  59         );
  60     }
  61 }
  62
  63 // no need to use pmd/styles
  64 require_once 'libraries/header_meta_style.inc.php';
  65 ?>
  66 </head>
  67 <body>
  68 <br>
  69 <div>
  70 <?php
  71     if (!empty($message)) {
  72         $message->display();
  73     }
  74 ?>
  75   <form name="form1" method="post" action="pmd_pdf.php">
  76 <?php
  77 echo PMA_generate_common_hidden_inputs($db);
  78 echo '<div>';
  79 echo '<fieldset><legend>' . __('Import/Export coordinates for PDF schema') . '</legend>';
  80
  81 $choices = array();
  82
  83 $table_info_result = PMA_query_as_controluser(
  84     'SELECT * FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db'])
  85     . '.' . PMA_backquote($cfgRelation['pdf_pages'])
  86     . ' WHERE db_name = \'' . PMA_sqlAddSlashes($db) . '\''
  87 );
  88
  89 if (PMA_DBI_num_rows($table_info_result) > 0) {
  90     echo '<p>' . __('Page') . ':';
  91     echo '<select name="pdf_page_number">';
  92
  93     while ($page = PMA_DBI_fetch_assoc($table_info_result)) {
  94         echo '<option value="' . $page['page_nr'] . '">';
  95         echo htmlspecialchars($page['page_descr']);
  96         echo '</option>';
  97     }
  98     echo '</select>';
  99     echo '</p>';
 100     $choices['import'] = __('Import from selected page');
 101     $choices['export'] = __('Export to selected page');
 102 }
 103 $choices['create_export'] = __('Create a page and export to it');
 104
 105 if (1 == count($choices)) {
 106     echo $choices['create_export'];
 107     echo '<input type="hidden" name="mode" value="create_export" />';
 108 } else {
 109     PMA_display_html_radio('mode', $choices, $checked_choice = '', $line_break = true, $escape_label = false, $class = '');
 110 }
 111 echo '<br />';
 112 echo '<label for="newpage">' . __('New page name: ') . '</label>';
 113 echo '<input id="newpage" type="text" name="newpage" />';
 114
 115 echo '<p>' . __('Export/Import to scale') . ':';
 116 ?>
 117       <select name="scale">
 118         <option value="1">1:1</option>
 119         <option value="2">1:2</option>
 120         <option value="3" selected>1:3 (<?php echo __('recommended'); ?>)</option>
 121         <option value="4">1:4</option>
 122         <option value="5">1:5</option>
 123         </select>
 124       </p>
 125       <input type="submit" value="<?php echo __('Go'); ?>">
 126     </fieldset>
 127     </div>
 128   </form>
 129 </div>
 130 </body>
 131 </html>
 132