diff --git a/htdocs/sql/libraries/export/latex.php b/htdocs/sql/libraries/export/latex.php new file mode 100755 --- /dev/null +++ b/htdocs/sql/libraries/export/latex.php @@ -0,0 +1,473 @@ + 'strLaTeX', + 'extension' => 'tex', + 'mime_type' => 'application/x-tex', + 'options' => array( + array('type' => 'bool', 'name' => 'caption', 'text' => 'strLatexIncludeCaption'), + ), + 'options_text' => 'strOptions', + ); + /* Structure options */ + if (!$hide_structure) { + $plugin_list['latex']['options'][] = + array('type' => 'bgroup', 'name' => 'structure', 'text' => 'strStructure', 'force' => 'data'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'structure_caption', 'text' => 'strLatexCaption'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'structure_continued_caption', 'text' => 'strLatexContinuedCaption'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'structure_label', 'text' => 'strLatexLabel'); + if (!empty($GLOBALS['cfgRelation']['relation'])) { + $plugin_list['latex']['options'][] = + array('type' => 'bool', 'name' => 'relation', 'text' => 'strRelations'); + } + if (!empty($GLOBALS['cfgRelation']['commwork']) || PMA_MYSQL_INT_VERSION >= 40100) { + $plugin_list['latex']['options'][] = + array('type' => 'bool', 'name' => 'comments', 'text' => 'strComments'); + } + if (!empty($GLOBALS['cfgRelation']['mimework'])) { + $plugin_list['latex']['options'][] = + array('type' => 'bool', 'name' => 'mime', 'text' => 'strMIME_MIMEtype'); + } + $plugin_list['latex']['options'][] = + array('type' => 'egroup'); + } + /* Data */ + $plugin_list['latex']['options'][] = + array('type' => 'bgroup', 'name' => 'data', 'text' => 'strData', 'force' => 'structure'); + $plugin_list['latex']['options'][] = + array('type' => 'bool', 'name' => 'columns', 'text' => 'strPutColNames'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'data_caption', 'text' => 'strLatexCaption'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'data_continued_caption', 'text' => 'strLatexContinuedCaption'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'data_label', 'text' => 'strLatexLabel'); + $plugin_list['latex']['options'][] = + array('type' => 'text', 'name' => 'null', 'text' => 'strReplaceNULLBy'); + $plugin_list['latex']['options'][] = + array('type' => 'egroup'); +} else { + +/** + * Escapes some special characters for use in TeX/LaTeX + * + * @param string the string to convert + * + * @return string the converted string with escape codes + * + * @access private + */ +function PMA_texEscape($string) { + $escape = array('$', '%', '{', '}', '&', '#', '_', '^'); + $cnt_escape = count($escape); + for ($k=0; $k < $cnt_escape; $k++) { + $string = str_replace($escape[$k], '\\' . $escape[$k], $string); + } + return $string; +} + +/** + * Outputs comment + * + * @param string Text of comment + * + * @return bool Whether it suceeded + */ +function PMA_exportComment($text) { + return PMA_exportOutputHandler('% ' . $text . $GLOBALS['crlf']); +} + +/** + * Outputs export footer + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportFooter() { + return TRUE; +} + +/** + * Outputs export header + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportHeader() { + global $crlf; + global $cfg; + + $head = '% phpMyAdmin LaTeX Dump' . $crlf + . '% version ' . PMA_VERSION . $crlf + . '% http://www.phpmyadmin.net' . $crlf + . '%' . $crlf + . '% ' . $GLOBALS['strHost'] . ': ' . $cfg['Server']['host']; + if (!empty($cfg['Server']['port'])) { + $head .= ':' . $cfg['Server']['port']; + } + $head .= $crlf + . '% ' . $GLOBALS['strGenTime'] . ': ' . PMA_localisedDate() . $crlf + . '% ' . $GLOBALS['strServerVersion'] . ': ' . substr(PMA_MYSQL_INT_VERSION, 0, 1) . '.' . (int) substr(PMA_MYSQL_INT_VERSION, 1, 2) . '.' . (int) substr(PMA_MYSQL_INT_VERSION, 3) . $crlf + . '% ' . $GLOBALS['strPHPVersion'] . ': ' . phpversion() . $crlf; + return PMA_exportOutputHandler($head); +} + +/** + * Outputs database header + * + * @param string Database name + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportDBHeader($db) { + global $crlf; + $head = '% ' . $crlf + . '% ' . $GLOBALS['strDatabase'] . ': ' . (isset($GLOBALS['use_backquotes']) ? PMA_backquote($db) : '\'' . $db . '\''). $crlf + . '% ' . $crlf; + return PMA_exportOutputHandler($head); +} + +/** + * Outputs database footer + * + * @param string Database name + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportDBFooter($db) { + return TRUE; +} + +/** + * Outputs create database database + * + * @param string Database name + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportDBCreate($db) { + return TRUE; +} + +/** + * Outputs the content of a table in LaTeX table/sideways table environment + * + * @param string the database name + * @param string the table name + * @param string the end of line sequence + * @param string the url to go back in case of error + * @param string SQL query for obtaining data + * + * @return bool Whether it suceeded + * + * @access public + */ +function PMA_exportData($db, $table, $crlf, $error_url, $sql_query) { + $result = PMA_DBI_try_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED); + + $columns_cnt = PMA_DBI_num_fields($result); + for ($i = 0; $i < $columns_cnt; $i++) { + $columns[$i] = PMA_DBI_field_name($result, $i); + } + unset($i); + + $buffer = $crlf . '%' . $crlf . '% ' . $GLOBALS['strData'] . ': ' . $table . $crlf . '%' . $crlf + . ' \\begin{longtable}{|'; + + for ($index=0;$index<$columns_cnt;$index++) { + $buffer .= 'l|'; + } + $buffer .= '} ' . $crlf ; + + $buffer .= ' \\hline \\endhead \\hline \\endfoot \\hline ' . $crlf; + if (isset($GLOBALS['latex_caption'])) { + $buffer .= ' \\caption{' . str_replace('__TABLE__', PMA_texEscape($table), $GLOBALS['latex_data_caption']) + . '} \\label{' . str_replace('__TABLE__', $table, $GLOBALS['latex_data_label']) . '} \\\\'; + } + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + + // show column names + if (isset($GLOBALS['latex_columns'])) { + $buffer = '\\hline '; + for ($i = 0; $i < $columns_cnt; $i++) { + $buffer .= '\\multicolumn{1}{|c|}{\\textbf{' . PMA_texEscape(stripslashes($columns[$i])) . '}} & '; + } + + $buffer = substr($buffer, 0, -2) . '\\\\ \\hline \hline '; + if (!PMA_exportOutputHandler($buffer . ' \\endfirsthead ' . $crlf)) { + return FALSE; + } + if (isset($GLOBALS['latex_caption'])) { + if (!PMA_exportOutputHandler('\\caption{' . str_replace('__TABLE__', PMA_texEscape($table), $GLOBALS['latex_data_continued_caption']) . '} \\\\ ')) return FALSE; + } + if (!PMA_exportOutputHandler($buffer . '\\endhead \\endfoot' . $crlf)) { + return FALSE; + } + } else { + if (!PMA_exportOutputHandler('\\\\ \hline')) { + return FALSE; + } + } + + // print the whole table + while ($record = PMA_DBI_fetch_assoc($result)) { + + $buffer = ''; + // print each row + for ($i = 0; $i < $columns_cnt; $i++) { + if (isset($record[$columns[$i]]) + && (! function_exists('is_null') || !is_null($record[$columns[$i]]))) { + $column_value = PMA_texEscape(stripslashes($record[$columns[$i]])); + } else { + $column_value = $GLOBALS['latex_null']; + } + + // last column ... no need for & character + if ($i == ($columns_cnt - 1)) { + $buffer .= $column_value; + } else { + $buffer .= $column_value . " & "; + } + } + $buffer .= ' \\\\ \\hline ' . $crlf; + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + } + + $buffer = ' \\end{longtable}' . $crlf; + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + + PMA_DBI_free_result($result); + return TRUE; + +} // end getTableLaTeX + +/** + * Returns $table's structure as LaTeX + * + * @param string the database name + * @param string the table name + * @param string the end of line sequence + * @param string the url to go back in case of error + * @param boolean whether to include relation comments + * @param boolean whether to include column comments + * @param boolean whether to include mime comments + * @param string future feature: support view dependencies + * + * @return bool Whether it suceeded + * + * @access public + */ + // @@@ $strTableStructure +function PMA_exportStructure($db, $table, $crlf, $error_url, $do_relation = false, $do_comments = false, $do_mime = false, $dates = false, $dummy) +{ + global $cfgRelation; + + /** + * Get the unique keys in the table + */ + $keys_query = 'SHOW KEYS FROM ' . PMA_backquote($table) . ' FROM '. PMA_backquote($db); + $keys_result = PMA_DBI_query($keys_query); + $unique_keys = array(); + while ($key = PMA_DBI_fetch_assoc($keys_result)) { + if ($key['Non_unique'] == 0) { + $unique_keys[] = $key['Column_name']; + } + } + PMA_DBI_free_result($keys_result); + + /** + * Gets fields properties + */ + PMA_DBI_select_db($db); + $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table); + $result = PMA_DBI_query($local_query); + $fields_cnt = PMA_DBI_num_rows($result); + + // Check if we can use Relations (Mike Beck) + if ($do_relation && !empty($cfgRelation['relation'])) { + // Find which tables are related with the current one and write it in + // an array + $res_rel = PMA_getForeigners($db, $table); + + if ($res_rel && count($res_rel) > 0) { + $have_rel = TRUE; + } else { + $have_rel = FALSE; + } + } else { + $have_rel = FALSE; + } // end if + + /** + * Displays the table structure + */ + $buffer = $crlf . '%' . $crlf . '% ' . $GLOBALS['strStructure'] . ': ' . $table . $crlf . '%' . $crlf + . ' \\begin{longtable}{'; + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + + $columns_cnt = 4; + $alignment = '|l|c|c|c|'; + if ($do_relation && $have_rel) { + $columns_cnt++; + $alignment .= 'l|'; + } + if ($do_comments && ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100)) { + $columns_cnt++; + $alignment .= 'l|'; + } + if ($do_mime && $cfgRelation['mimework']) { + $columns_cnt++; + $alignment .='l|'; + } + $buffer = $alignment . '} ' . $crlf ; + + $header = ' \\hline '; + $header .= '\\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strField'] . '}} & \\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strType'] . '}} & \\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strNull'] . '}} & \\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strDefault'] . '}}'; + if ($do_relation && $have_rel) { + $header .= ' & \\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strLinksTo'] . '}}'; + } + if ($do_comments && ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100)) { + $header .= ' & \\multicolumn{1}{|c|}{\\textbf{' . $GLOBALS['strComments'] . '}}'; + $comments = PMA_getComments($db, $table); + } + if ($do_mime && $cfgRelation['mimework']) { + $header .= ' & \\multicolumn{1}{|c|}{\\textbf{MIME}}'; + $mime_map = PMA_getMIME($db, $table, true); + } + + $local_buffer = PMA_texEscape($table); + + // Table caption for first page and label + if (isset($GLOBALS['latex_caption'])) { + $buffer .= ' \\caption{'. str_replace('__TABLE__', PMA_texEscape($table), $GLOBALS['latex_structure_caption']) + . '} \\label{' . str_replace('__TABLE__', $table, $GLOBALS['latex_structure_label']) + . '} \\\\' . $crlf; + } + $buffer .= $header . ' \\\\ \\hline \\hline' . $crlf . '\\endfirsthead' . $crlf; + // Table caption on next pages + if (isset($GLOBALS['latex_caption'])) { + $buffer .= ' \\caption{'. str_replace('__TABLE__', PMA_texEscape($table), $GLOBALS['latex_structure_continued_caption']) + . '} \\\\ ' . $crlf; + } + $buffer .= $header . ' \\\\ \\hline \\hline \\endhead \\endfoot ' . $crlf; + + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + + while ($row = PMA_DBI_fetch_assoc($result)) { + + $type = $row['Type']; + // reformat mysql query output - staybyte - 9. June 2001 + // loic1: set or enum types: slashes single quotes inside options + if (eregi('^(set|enum)\((.+)\)$', $type, $tmp)) { + $tmp[2] = substr(ereg_replace('([^,])\'\'', '\\1\\\'', ',' . $tmp[2]), 1); + $type = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')'; + $type_nowrap = ''; + + $binary = 0; + $unsigned = 0; + $zerofill = 0; + } else { + $type_nowrap = ' nowrap="nowrap"'; + $type = eregi_replace('BINARY', '', $type); + $type = eregi_replace('ZEROFILL', '', $type); + $type = eregi_replace('UNSIGNED', '', $type); + if (empty($type)) { + $type = ' '; + } + + $binary = eregi('BINARY', $row['Type']); + $unsigned = eregi('UNSIGNED', $row['Type']); + $zerofill = eregi('ZEROFILL', $row['Type']); + } + if (!isset($row['Default'])) { + if ($row['Null'] != '') { + $row['Default'] = 'NULL'; + } + } else { + $row['Default'] = $row['Default']; + } + + $field_name = $row['Field']; + + $local_buffer = $field_name . "\000" . $type . "\000" . (($row['Null'] == '') ? $GLOBALS['strNo'] : $GLOBALS['strYes']) . "\000" . (isset($row['Default']) ? $row['Default'] : ''); + + if ($do_relation && $have_rel) { + $local_buffer .= "\000"; + if (isset($res_rel[$field_name])) { + $local_buffer .= $res_rel[$field_name]['foreign_table'] . ' (' . $res_rel[$field_name]['foreign_field'] . ')'; + } + } + if ($do_comments && $cfgRelation['commwork']) { + $local_buffer .= "\000"; + if (isset($comments[$field_name])) { + $local_buffer .= $comments[$field_name]; + } + } + if ($do_mime && $cfgRelation['mimework']) { + $local_buffer .= "\000"; + if (isset($mime_map[$field_name])) { + $local_buffer .= str_replace('_', '/', $mime_map[$field_name]['mimetype']); + } + } + $local_buffer = PMA_texEscape($local_buffer); + if ($row['Key']=='PRI') { + $pos=strpos($local_buffer, "\000"); + $local_buffer = '\\textit{' . substr($local_buffer, 0, $pos) . '}' . substr($local_buffer, $pos); + } + if (in_array($field_name, $unique_keys)) { + $pos=strpos($local_buffer, "\000"); + $local_buffer = '\\textbf{' . substr($local_buffer, 0, $pos) . '}' . substr($local_buffer, $pos); + } + $buffer = str_replace("\000", ' & ', $local_buffer); + $buffer .= ' \\\\ \\hline ' . $crlf; + + if (!PMA_exportOutputHandler($buffer)) { + return FALSE; + } + } // end while + PMA_DBI_free_result($result); + + $buffer = ' \\end{longtable}' . $crlf; + return PMA_exportOutputHandler($buffer); +} // end of the 'PMA_exportStructure' function + +} // end else +?>