phpmyadmin/pmd_pdf.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin-Designer
   7  */
   8
   9 /**
  10  *
  11  */
  12 include_once 'pmd_common.php';
  13 if (! isset($scale)) {
  14     $no_die_save_pos = 1;
  15     include_once 'pmd_save_pos.php';
  16 }
  17 require_once './libraries/relation.lib.php';
  18
  19 if (isset($scale)) {
  20     if (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
  27     if (isset($exp)) {
  28
  29         $sql = "REPLACE INTO " . $pma_table . " (db_name, table_name, pdf_page_number, x, y) SELECT db_name, table_name, " . $pdf_page_number . ", ROUND(x/" . $scale . ") , ROUND(y/" . $scale . ") y FROM " . $pmd_table . " WHERE db_name = '" . $db . "'";
  30
  31         PMA_query_as_cu($sql,TRUE,PMA_DBI_QUERY_STORE);
  32     }
  33
  34     if (isset($imp)) {
  35         PMA_query_as_cu(
  36         'UPDATE ' . $pma_table . ',' . $pmd_table .
  37         ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale . ',
  38         ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '.$scale.'
  39         WHERE
  40         ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name`
  41         AND
  42         ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name`
  43         AND
  44         ' . $pmd_table . '.`db_name`=\''.$db.'\'
  45         AND pdf_page_number = '.$pdf_page_number.';',TRUE,PMA_DBI_QUERY_STORE);     }
  46
  47     die("<script>alert('$strModifications');history.go(-2);</script>");
  48 }
  49 ?>
  50 <html>
  51 <head>
  52 <?php if(0){ ?>
  53 <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
  54 <link rel="stylesheet" type="text/css" href="pmd/styles/default/style1.css">
  55 <?php } ?>
  56 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset ?>" />
  57 <link rel="stylesheet" type="text/css" href="pmd/styles/<?php echo $GLOBALS['PMD']['STYLE'] ?>/style1.css">
  58 <title>Designer</title>
  59 </head>
  60 <body>
  61 <br>
  62 <div style="text-align:center; font-weight:bold;">
  63   <form name="form1" method="post" action="pmd_pdf.php">
  64 <?php echo PMA_generate_common_hidden_inputs($db); ?>
  65     <p><?php echo $strExportImportToScale; ?>:
  66       <select name="scale">
  67         <option value="1">1:1</option>
  68         <option value="2">1:2</option>
  69     <option value="3" selected>1:3 (<?php echo $strRecommended; ?>)</option>
  70         <option value="4">1:4</option>
  71         <option value="5">1:5</option>
  72         </select>
  73       </p>
  74   <p><?php echo $strToFromPage; ?>:
  75
  76       <select name="pdf_page_number">
  77       <?php
  78       $table_info_result = PMA_query_as_cu('SELECT * FROM '.PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']).'
  79                                              WHERE db_name = \''.$db.'\'');
  80       while($page = PMA_DBI_fetch_assoc($table_info_result))
  81       {
  82       ?>
  83       <option value="<?php echo $page['page_nr'] ?>"><?php echo $page['page_descr'] ?></option>
  84       <?php
  85       }
  86       ?>
  87       </select>
  88       <br>
  89       <br>
  90   <input type="submit" name="exp" value="<?php echo $strExport; ?>">
  91   <input type="submit" name="imp" value="<?php echo $strImport; ?>">
  92         </p>
  93   </form>
  94 </div>
  95 </body>
  96 </html>
  97