diff options
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Plugins/Export/ExportHtmlword.php')
| -rw-r--r-- | srcs/phpmyadmin/libraries/classes/Plugins/Export/ExportHtmlword.php | 670 |
1 files changed, 0 insertions, 670 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Plugins/Export/ExportHtmlword.php b/srcs/phpmyadmin/libraries/classes/Plugins/Export/ExportHtmlword.php deleted file mode 100644 index cbf4fce..0000000 --- a/srcs/phpmyadmin/libraries/classes/Plugins/Export/ExportHtmlword.php +++ /dev/null @@ -1,670 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * HTML-Word export code - * - * @package PhpMyAdmin-Export - * @subpackage HTML-Word - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Plugins\Export; - -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Export; -use PhpMyAdmin\Plugins\ExportPlugin; -use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyMainGroup; -use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyRootGroup; -use PhpMyAdmin\Properties\Options\Items\BoolPropertyItem; -use PhpMyAdmin\Properties\Options\Items\RadioPropertyItem; -use PhpMyAdmin\Properties\Options\Items\TextPropertyItem; -use PhpMyAdmin\Properties\Plugins\ExportPluginProperties; -use PhpMyAdmin\Relation; -use PhpMyAdmin\Transformations; -use PhpMyAdmin\Util; - -/** - * Handles the export for the HTML-Word format - * - * @package PhpMyAdmin-Export - * @subpackage HTML-Word - */ -class ExportHtmlword extends ExportPlugin -{ - /** - * Constructor - */ - public function __construct() - { - parent::__construct(); - $this->setProperties(); - } - - /** - * Sets the export HTML-Word properties - * - * @return void - */ - protected function setProperties() - { - $exportPluginProperties = new ExportPluginProperties(); - $exportPluginProperties->setText('Microsoft Word 2000'); - $exportPluginProperties->setExtension('doc'); - $exportPluginProperties->setMimeType('application/vnd.ms-word'); - $exportPluginProperties->setForceFile(true); - $exportPluginProperties->setOptionsText(__('Options')); - - // create the root group that will be the options field for - // $exportPluginProperties - // this will be shown as "Format specific options" - $exportSpecificOptions = new OptionsPropertyRootGroup( - "Format Specific Options" - ); - - // what to dump (structure/data/both) - $dumpWhat = new OptionsPropertyMainGroup( - "dump_what", - __('Dump table') - ); - // create primary items and add them to the group - $leaf = new RadioPropertyItem("structure_or_data"); - $leaf->setValues( - [ - 'structure' => __('structure'), - 'data' => __('data'), - 'structure_and_data' => __('structure and data'), - ] - ); - $dumpWhat->addProperty($leaf); - // add the main group to the root group - $exportSpecificOptions->addProperty($dumpWhat); - - // data options main group - $dataOptions = new OptionsPropertyMainGroup( - "dump_what", - __('Data dump options') - ); - $dataOptions->setForce('structure'); - // create primary items and add them to the group - $leaf = new TextPropertyItem( - "null", - __('Replace NULL with:') - ); - $dataOptions->addProperty($leaf); - $leaf = new BoolPropertyItem( - "columns", - __('Put columns names in the first row') - ); - $dataOptions->addProperty($leaf); - // add the main group to the root group - $exportSpecificOptions->addProperty($dataOptions); - - // set the options for the export plugin property item - $exportPluginProperties->setOptions($exportSpecificOptions); - $this->properties = $exportPluginProperties; - } - - /** - * Outputs export header - * - * @return bool Whether it succeeded - */ - public function exportHeader() - { - global $charset; - - return $this->export->outputHandler( - '<html xmlns:o="urn:schemas-microsoft-com:office:office" - xmlns:x="urn:schemas-microsoft-com:office:word" - xmlns="http://www.w3.org/TR/REC-html40"> - - <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"' - . ' "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> - <html> - <head> - <meta http-equiv="Content-type" content="text/html;charset=' - . (isset($charset) ? $charset : 'utf-8') . '" /> - </head> - <body>' - ); - } - - /** - * Outputs export footer - * - * @return bool Whether it succeeded - */ - public function exportFooter() - { - return $this->export->outputHandler('</body></html>'); - } - - /** - * Outputs database header - * - * @param string $db Database name - * @param string $db_alias Aliases of db - * - * @return bool Whether it succeeded - */ - public function exportDBHeader($db, $db_alias = '') - { - if (empty($db_alias)) { - $db_alias = $db; - } - - return $this->export->outputHandler( - '<h1>' . __('Database') . ' ' . htmlspecialchars($db_alias) . '</h1>' - ); - } - - /** - * Outputs database footer - * - * @param string $db Database name - * - * @return bool Whether it succeeded - */ - public function exportDBFooter($db) - { - return true; - } - - /** - * Outputs CREATE DATABASE statement - * - * @param string $db Database name - * @param string $export_type 'server', 'database', 'table' - * @param string $db_alias Aliases of db - * - * @return bool Whether it succeeded - */ - public function exportDBCreate($db, $export_type, $db_alias = '') - { - return true; - } - - /** - * Outputs the content of a table in HTML-Word format - * - * @param string $db database name - * @param string $table table name - * @param string $crlf the end of line sequence - * @param string $error_url the url to go back in case of error - * @param string $sql_query SQL query for obtaining data - * @param array $aliases Aliases of db/table/columns - * - * @return bool Whether it succeeded - */ - public function exportData( - $db, - $table, - $crlf, - $error_url, - $sql_query, - array $aliases = [] - ) { - global $what; - - $db_alias = $db; - $table_alias = $table; - $this->initAlias($aliases, $db_alias, $table_alias); - - if (! $this->export->outputHandler( - '<h2>' - . __('Dumping data for table') . ' ' . htmlspecialchars($table_alias) - . '</h2>' - ) - ) { - return false; - } - if (! $this->export->outputHandler( - '<table class="width100" cellspacing="1">' - ) - ) { - return false; - } - - // Gets the data from the database - $result = $GLOBALS['dbi']->query( - $sql_query, - DatabaseInterface::CONNECT_USER, - DatabaseInterface::QUERY_UNBUFFERED - ); - $fields_cnt = $GLOBALS['dbi']->numFields($result); - - // If required, get fields name at the first line - if (isset($GLOBALS['htmlword_columns'])) { - $schema_insert = '<tr class="print-category">'; - for ($i = 0; $i < $fields_cnt; $i++) { - $col_as = $GLOBALS['dbi']->fieldName($result, $i); - if (! empty($aliases[$db]['tables'][$table]['columns'][$col_as])) { - $col_as = $aliases[$db]['tables'][$table]['columns'][$col_as]; - } - $col_as = stripslashes($col_as); - $schema_insert .= '<td class="print"><strong>' - . htmlspecialchars($col_as) - . '</strong></td>'; - } // end for - $schema_insert .= '</tr>'; - if (! $this->export->outputHandler($schema_insert)) { - return false; - } - } // end if - - // Format the data - while ($row = $GLOBALS['dbi']->fetchRow($result)) { - $schema_insert = '<tr class="print-category">'; - for ($j = 0; $j < $fields_cnt; $j++) { - if (! isset($row[$j]) || $row[$j] === null) { - $value = $GLOBALS[$what . '_null']; - } elseif ($row[$j] == '0' || $row[$j] != '') { - $value = $row[$j]; - } else { - $value = ''; - } - $schema_insert .= '<td class="print">' - . htmlspecialchars((string) $value) - . '</td>'; - } // end for - $schema_insert .= '</tr>'; - if (! $this->export->outputHandler($schema_insert)) { - return false; - } - } // end while - $GLOBALS['dbi']->freeResult($result); - - return $this->export->outputHandler('</table>'); - } - - /** - * Returns a stand-in CREATE definition to resolve view dependencies - * - * @param string $db the database name - * @param string $view the view name - * @param string $crlf the end of line sequence - * @param array $aliases Aliases of db/table/columns - * - * @return string resulting definition - */ - public function getTableDefStandIn($db, $view, $crlf, $aliases = []) - { - $schema_insert = '<table class="width100" cellspacing="1">' - . '<tr class="print-category">' - . '<th class="print">' - . __('Column') - . '</th>' - . '<td class="print"><strong>' - . __('Type') - . '</strong></td>' - . '<td class="print"><strong>' - . __('Null') - . '</strong></td>' - . '<td class="print"><strong>' - . __('Default') - . '</strong></td>' - . '</tr>'; - - /** - * Get the unique keys in the view - */ - $unique_keys = []; - $keys = $GLOBALS['dbi']->getTableIndexes($db, $view); - foreach ($keys as $key) { - if ($key['Non_unique'] == 0) { - $unique_keys[] = $key['Column_name']; - } - } - - $columns = $GLOBALS['dbi']->getColumns($db, $view); - foreach ($columns as $column) { - $col_as = $column['Field']; - if (! empty($aliases[$db]['tables'][$view]['columns'][$col_as])) { - $col_as = $aliases[$db]['tables'][$view]['columns'][$col_as]; - } - $schema_insert .= $this->formatOneColumnDefinition( - $column, - $unique_keys, - $col_as - ); - $schema_insert .= '</tr>'; - } - - $schema_insert .= '</table>'; - - return $schema_insert; - } - - /** - * Returns $table's CREATE definition - * - * @param string $db the database name - * @param string $table the table name - * @param bool $do_relation whether to include relation comments - * @param bool $do_comments whether to include the pmadb-style column - * comments as comments in the structure; - * this is deprecated but the parameter is - * left here because export.php calls - * PMA_exportStructure() also for other - * export types which use this parameter - * @param bool $do_mime whether to include mime comments - * at the end - * @param bool $view whether we're handling a view - * @param array $aliases Aliases of db/table/columns - * - * @return string resulting schema - */ - public function getTableDef( - $db, - $table, - $do_relation, - $do_comments, - $do_mime, - $view = false, - array $aliases = [] - ) { - // set $cfgRelation here, because there is a chance that it's modified - // since the class initialization - global $cfgRelation; - - $schema_insert = ''; - - /** - * Gets fields properties - */ - $GLOBALS['dbi']->selectDb($db); - - // Check if we can use Relations - list($res_rel, $have_rel) = $this->relation->getRelationsAndStatus( - $do_relation && ! empty($cfgRelation['relation']), - $db, - $table - ); - - /** - * Displays the table structure - */ - $schema_insert .= '<table class="width100" cellspacing="1">'; - - $schema_insert .= '<tr class="print-category">'; - $schema_insert .= '<th class="print">' - . __('Column') - . '</th>'; - $schema_insert .= '<td class="print"><strong>' - . __('Type') - . '</strong></td>'; - $schema_insert .= '<td class="print"><strong>' - . __('Null') - . '</strong></td>'; - $schema_insert .= '<td class="print"><strong>' - . __('Default') - . '</strong></td>'; - if ($do_relation && $have_rel) { - $schema_insert .= '<td class="print"><strong>' - . __('Links to') - . '</strong></td>'; - } - if ($do_comments) { - $schema_insert .= '<td class="print"><strong>' - . __('Comments') - . '</strong></td>'; - $comments = $this->relation->getComments($db, $table); - } - if ($do_mime && $cfgRelation['mimework']) { - $schema_insert .= '<td class="print"><strong>' - . __('Media (MIME) type') - . '</strong></td>'; - $mime_map = $this->transformations->getMime($db, $table, true); - } - $schema_insert .= '</tr>'; - - $columns = $GLOBALS['dbi']->getColumns($db, $table); - /** - * Get the unique keys in the table - */ - $unique_keys = []; - $keys = $GLOBALS['dbi']->getTableIndexes($db, $table); - foreach ($keys as $key) { - if ($key['Non_unique'] == 0) { - $unique_keys[] = $key['Column_name']; - } - } - foreach ($columns as $column) { - $col_as = $column['Field']; - if (! empty($aliases[$db]['tables'][$table]['columns'][$col_as])) { - $col_as = $aliases[$db]['tables'][$table]['columns'][$col_as]; - } - $schema_insert .= $this->formatOneColumnDefinition( - $column, - $unique_keys, - $col_as - ); - $field_name = $column['Field']; - if ($do_relation && $have_rel) { - $schema_insert .= '<td class="print">' - . htmlspecialchars( - $this->getRelationString( - $res_rel, - $field_name, - $db, - $aliases - ) - ) - . '</td>'; - } - if ($do_comments && $cfgRelation['commwork']) { - $schema_insert .= '<td class="print">' - . (isset($comments[$field_name]) - ? htmlspecialchars($comments[$field_name]) - : '') . '</td>'; - } - if ($do_mime && $cfgRelation['mimework']) { - $schema_insert .= '<td class="print">' - . (isset($mime_map[$field_name]) ? - htmlspecialchars( - str_replace('_', '/', $mime_map[$field_name]['mimetype']) - ) - : '') . '</td>'; - } - - $schema_insert .= '</tr>'; - } // end foreach - - $schema_insert .= '</table>'; - - return $schema_insert; - } - - /** - * Outputs triggers - * - * @param string $db database name - * @param string $table table name - * - * @return string Formatted triggers list - */ - protected function getTriggers($db, $table) - { - $dump = '<table class="width100" cellspacing="1">'; - $dump .= '<tr class="print-category">'; - $dump .= '<th class="print">' . __('Name') . '</th>'; - $dump .= '<td class="print"><strong>' . __('Time') . '</strong></td>'; - $dump .= '<td class="print"><strong>' . __('Event') . '</strong></td>'; - $dump .= '<td class="print"><strong>' . __('Definition') . '</strong></td>'; - $dump .= '</tr>'; - - $triggers = $GLOBALS['dbi']->getTriggers($db, $table); - - foreach ($triggers as $trigger) { - $dump .= '<tr class="print-category">'; - $dump .= '<td class="print">' - . htmlspecialchars($trigger['name']) - . '</td>' - . '<td class="print">' - . htmlspecialchars($trigger['action_timing']) - . '</td>' - . '<td class="print">' - . htmlspecialchars($trigger['event_manipulation']) - . '</td>' - . '<td class="print">' - . htmlspecialchars($trigger['definition']) - . '</td>' - . '</tr>'; - } - - $dump .= '</table>'; - - return $dump; - } - - /** - * Outputs table's structure - * - * @param string $db database name - * @param string $table table name - * @param string $crlf the end of line sequence - * @param string $error_url the url to go back in case of error - * @param string $export_mode 'create_table', 'triggers', 'create_view', - * 'stand_in' - * @param string $export_type 'server', 'database', 'table' - * @param bool $do_relation whether to include relation comments - * @param bool $do_comments whether to include the pmadb-style column - * comments as comments in the structure; - * this is deprecated but the parameter is - * left here because export.php calls - * PMA_exportStructure() also for other - * export types which use this parameter - * @param bool $do_mime whether to include mime comments - * @param bool $dates whether to include creation/update/check dates - * @param array $aliases Aliases of db/table/columns - * - * @return bool Whether it succeeded - */ - public function exportStructure( - $db, - $table, - $crlf, - $error_url, - $export_mode, - $export_type, - $do_relation = false, - $do_comments = false, - $do_mime = false, - $dates = false, - array $aliases = [] - ) { - $db_alias = $db; - $table_alias = $table; - $this->initAlias($aliases, $db_alias, $table_alias); - - $dump = ''; - - switch ($export_mode) { - case 'create_table': - $dump .= '<h2>' - . __('Table structure for table') . ' ' - . htmlspecialchars($table_alias) - . '</h2>'; - $dump .= $this->getTableDef( - $db, - $table, - $do_relation, - $do_comments, - $do_mime, - false, - $aliases - ); - break; - case 'triggers': - $dump = ''; - $triggers = $GLOBALS['dbi']->getTriggers($db, $table); - if ($triggers) { - $dump .= '<h2>' - . __('Triggers') . ' ' . htmlspecialchars($table_alias) - . '</h2>'; - $dump .= $this->getTriggers($db, $table); - } - break; - case 'create_view': - $dump .= '<h2>' - . __('Structure for view') . ' ' . htmlspecialchars($table_alias) - . '</h2>'; - $dump .= $this->getTableDef( - $db, - $table, - $do_relation, - $do_comments, - $do_mime, - true, - $aliases - ); - break; - case 'stand_in': - $dump .= '<h2>' - . __('Stand-in structure for view') . ' ' - . htmlspecialchars($table_alias) - . '</h2>'; - // export a stand-in definition to resolve view dependencies - $dump .= $this->getTableDefStandIn($db, $table, $crlf, $aliases); - } // end switch - - return $this->export->outputHandler($dump); - } - - /** - * Formats the definition for one column - * - * @param array $column info about this column - * @param array $unique_keys unique keys of the table - * @param string $col_alias Column Alias - * - * @return string Formatted column definition - */ - protected function formatOneColumnDefinition( - array $column, - array $unique_keys, - $col_alias = '' - ) { - if (empty($col_alias)) { - $col_alias = $column['Field']; - } - $definition = '<tr class="print-category">'; - - $extracted_columnspec = Util::extractColumnSpec($column['Type']); - - $type = htmlspecialchars($extracted_columnspec['print_type']); - if (empty($type)) { - $type = ' '; - } - - if (! isset($column['Default'])) { - if ($column['Null'] != 'NO') { - $column['Default'] = 'NULL'; - } - } - - $fmt_pre = ''; - $fmt_post = ''; - if (in_array($column['Field'], $unique_keys)) { - $fmt_pre = '<strong>' . $fmt_pre; - $fmt_post .= '</strong>'; - } - if ($column['Key'] == 'PRI') { - $fmt_pre = '<em>' . $fmt_pre; - $fmt_post .= '</em>'; - } - $definition .= '<td class="print">' . $fmt_pre - . htmlspecialchars($col_alias) . $fmt_post . '</td>'; - $definition .= '<td class="print">' . htmlspecialchars($type) . '</td>'; - $definition .= '<td class="print">' - . (($column['Null'] == '' || $column['Null'] == 'NO') - ? __('No') - : __('Yes')) - . '</td>'; - $definition .= '<td class="print">' - . htmlspecialchars(isset($column['Default']) ? $column['Default'] : '') - . '</td>'; - - return $definition; - } -} |