diff options
| author | Michal Čihař <michal@cihar.com> | 2006-11-17 11:49:30 +0300 |
|---|---|---|
| committer | Michal Čihař <michal@cihar.com> | 2006-11-17 11:49:30 +0300 |
| commit | fb9a3a598ee9b59ace10f5874c62f2cd1c77ccdb (patch) | |
| tree | ec8b2d44eaef0c2c138d5551976ae1ef6a681d6f /pmd_pdf.php | |
| parent | f0780e312984f178baba99b54acdf6a2f9fadac9 (diff) | |
Check before commit!
Diffstat (limited to 'pmd_pdf.php')
| -rw-r--r-- | pmd_pdf.php | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/pmd_pdf.php b/pmd_pdf.php new file mode 100644 index 0000000000..0bc7420e65 --- /dev/null +++ b/pmd_pdf.php @@ -0,0 +1,91 @@ +<?php +/* $Id$ */ +// vim: expandtab sw=4 ts=4 sts=4: + +include_once 'pmd_session.php'; +if ( ! isset($scale)) { + $no_die_save_pos = 1; + include_once 'pmd_save_pos.php'; +} +require_once './libraries/relation.lib.php'; +require_once 'pmd_config.php'; + +if (isset($scale)) { + if (empty($pdf_page_number)) { + die("<script>alert('Pages not found!');history.go(-2);</script>"); + } + $cfgRelation = PMA_getRelationsParam(); + + $pmd_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($GLOBALS['cfgRelation']['designer_coords']); + $pma_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']); + + if (isset($exp)) { + + $sql = "REPLACE INTO " . $pma_table . " (db_name, table_name, pdf_page_number, x, y) SELECT db_name, table_name, " . $pdf_page_number . ", x, y FROM " . $pmd_table . " WHERE db_name = '" . $db . "'"; + + PMA_query_as_cu($sql,TRUE,PMA_DBI_QUERY_STORE); + } + + if (isset($imp)) { + PMA_query_as_cu( + 'UPDATE ' . $pma_table . ',' . $pmd_table . + ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale . ', + ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '.$scale.' + WHERE + ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name` + AND + ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name` + AND + ' . $pmd_table . '.`db_name`=\''.$db.'\' + AND pdf_page_number = '.$pdf_page_number.';',TRUE,PMA_DBI_QUERY_STORE); } + + die("<script>alert('$strModifications');history.go(-2);</script>"); +} +?> +<html> +<head> +<?php if(0){ ?> +<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> +<link rel="stylesheet" type="text/css" href="pmd/styles/default/style1.css"> +<?php } ?> +<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset ?>" /> +<link rel="stylesheet" type="text/css" href="pmd/styles/<?php echo $GLOBALS['PMD']['STYLE'] ?>/style1.css"> +<title>phpMyDesigner</title> +</head> +<body> +<br> +<div style="text-align:center; font-weight:bold;"> + <form name="form1" method="post" action="pmd_pdf.php?db=<? echo $db ?>&token=<? echo $token ?>"> + <p><?php echo $strExportImportToScale; ?>: + <select name="scale"> + <option value="1">1:1</option> + <option value="2">1:2</option> + <option value="3" selected>1:3 (<?php echo $strRecommended; ?>)</option> + <option value="4">1:4</option> + <option value="5">1:5</option> + </select> + </p> + <p><?php echo $strToFromPage; ?>: + + <select name="pdf_page_number"> + <? + $table_info_result = PMA_query_as_cu('SELECT * FROM '.PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']).' + WHERE db_name = \''.$db.'\''); + while($page = PMA_DBI_fetch_assoc($table_info_result)) + { + ?> + <option value="<? echo $page['page_nr'] ?>"><? echo $page['page_descr'] ?></option> + <? + } + ?> + </select> + <br> + <br> + <input type="submit" name="exp" value="<?php echo $strExport; ?>"> + <input type="submit" name="imp" value="<?php echo $strImport; ?>"> + </p> + </form> +</div> +</body> +</html> + |