diff options
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Database')
7 files changed, 0 insertions, 3855 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Database/DatabaseList.php b/srcs/phpmyadmin/libraries/classes/Database/DatabaseList.php deleted file mode 100644 index a9d3889..0000000 --- a/srcs/phpmyadmin/libraries/classes/Database/DatabaseList.php +++ /dev/null @@ -1,60 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * holds the PhpMyAdmin\Database\DatabaseList class - * - * @package PhpMyAdmin - * - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Database; - -use PhpMyAdmin\ListDatabase; - -/** - * holds the DatabaseList class - * - * @package PhpMyAdmin - */ -class DatabaseList -{ - /** - * Holds database list - * - * @var ListDatabase - */ - protected $databases = null; - - /** - * magic access to protected/inaccessible members/properties - * - * @param string $param parameter name - * - * @return mixed - * @see https://www.php.net/language.oop5.overloading - */ - public function __get($param) - { - switch ($param) { - case 'databases': - return $this->getDatabaseList(); - } - - return null; - } - - /** - * Accessor to PMA::$databases - * - * @return ListDatabase - */ - public function getDatabaseList() - { - if (null === $this->databases) { - $this->databases = new ListDatabase(); - } - - return $this->databases; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Database/Designer.php b/srcs/phpmyadmin/libraries/classes/Database/Designer.php deleted file mode 100644 index f9d6775..0000000 --- a/srcs/phpmyadmin/libraries/classes/Database/Designer.php +++ /dev/null @@ -1,407 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Database\Designer class - * - * @package PhpMyAdmin - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Database; - -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Message; -use PhpMyAdmin\Plugins; -use PhpMyAdmin\Plugins\SchemaPlugin; -use PhpMyAdmin\Relation; -use PhpMyAdmin\Template; -use PhpMyAdmin\Util; -use PhpMyAdmin\Database\Designer\DesignerTable; -use stdClass; - -/** - * Set of functions related to database designer - * - * @package PhpMyAdmin - */ -class Designer -{ - /** - * @var DatabaseInterface - */ - private $dbi; - - /** - * @var Relation - */ - private $relation; - - /** - * @var Template - */ - public $template; - - /** - * Designer constructor. - * - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Relation $relation Relation instance - * @param Template $template Template instance - */ - public function __construct(DatabaseInterface $dbi, Relation $relation, Template $template) - { - $this->dbi = $dbi; - $this->relation = $relation; - $this->template = $template; - } - - /** - * Function to get html for displaying the page edit/delete form - * - * @param string $db database name - * @param string $operation 'edit' or 'delete' depending on the operation - * - * @return string html content - */ - public function getHtmlForEditOrDeletePages($db, $operation) - { - $cfgRelation = $this->relation->getRelationsParam(); - return $this->template->render('database/designer/edit_delete_pages', [ - 'db' => $db, - 'operation' => $operation, - 'pdfwork' => $cfgRelation['pdfwork'], - 'pages' => $this->getPageIdsAndNames($db), - ]); - } - - /** - * Function to get html for displaying the page save as form - * - * @param string $db database name - * - * @return string html content - */ - public function getHtmlForPageSaveAs($db) - { - $cfgRelation = $this->relation->getRelationsParam(); - return $this->template->render('database/designer/page_save_as', [ - 'db' => $db, - 'pdfwork' => $cfgRelation['pdfwork'], - 'pages' => $this->getPageIdsAndNames($db), - ]); - } - - /** - * Retrieve IDs and names of schema pages - * - * @param string $db database name - * - * @return array array of schema page id and names - */ - private function getPageIdsAndNames($db) - { - $result = []; - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return $result; - } - - $page_query = "SELECT `page_nr`, `page_descr` FROM " - . Util::backquote($cfgRelation['db']) . "." - . Util::backquote($cfgRelation['pdf_pages']) - . " WHERE db_name = '" . $this->dbi->escapeString($db) . "'" - . " ORDER BY `page_descr`"; - $page_rs = $this->relation->queryAsControlUser( - $page_query, - false, - DatabaseInterface::QUERY_STORE - ); - - while ($curr_page = $this->dbi->fetchAssoc($page_rs)) { - $result[intval($curr_page['page_nr'])] = $curr_page['page_descr']; - } - return $result; - } - - /** - * Function to get html for displaying the schema export - * - * @param string $db database name - * @param int $page the page to be exported - * - * @return string - */ - public function getHtmlForSchemaExport($db, $page) - { - /* Scan for schema plugins */ - /** @var SchemaPlugin[] $export_list */ - $export_list = Plugins::getPlugins( - "schema", - 'libraries/classes/Plugins/Schema/', - null - ); - - /* Fail if we didn't find any schema plugin */ - if (empty($export_list)) { - return Message::error( - __('Could not load schema plugins, please check your installation!') - )->getDisplay(); - } - - return $this->template->render('database/designer/schema_export', [ - 'db' => $db, - 'page' => $page, - 'export_list' => $export_list, - ]); - } - - /** - * Returns array of stored values of Designer Settings - * - * @return array stored values - */ - private function getSideMenuParamsArray() - { - $params = []; - - $cfgRelation = $this->relation->getRelationsParam(); - - if ($cfgRelation['designersettingswork']) { - $query = 'SELECT `settings_data` FROM ' - . Util::backquote($cfgRelation['db']) . '.' - . Util::backquote($cfgRelation['designer_settings']) - . ' WHERE ' . Util::backquote('username') . ' = "' - . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) - . '";'; - - $result = $this->dbi->fetchSingleRow($query); - - $params = json_decode((string) $result['settings_data'], true); - } - - return $params; - } - - /** - * Returns class names for various buttons on Designer Side Menu - * - * @return array class names of various buttons - */ - public function returnClassNamesFromMenuButtons() - { - $classes_array = []; - $params_array = $this->getSideMenuParamsArray(); - - if (isset($params_array['angular_direct']) - && $params_array['angular_direct'] == 'angular' - ) { - $classes_array['angular_direct'] = 'M_butt_Selected_down'; - } else { - $classes_array['angular_direct'] = 'M_butt'; - } - - if (isset($params_array['snap_to_grid']) - && $params_array['snap_to_grid'] == 'on' - ) { - $classes_array['snap_to_grid'] = 'M_butt_Selected_down'; - } else { - $classes_array['snap_to_grid'] = 'M_butt'; - } - - if (isset($params_array['pin_text']) - && $params_array['pin_text'] == 'true' - ) { - $classes_array['pin_text'] = 'M_butt_Selected_down'; - } else { - $classes_array['pin_text'] = 'M_butt'; - } - - if (isset($params_array['relation_lines']) - && $params_array['relation_lines'] == 'false' - ) { - $classes_array['relation_lines'] = 'M_butt_Selected_down'; - } else { - $classes_array['relation_lines'] = 'M_butt'; - } - - if (isset($params_array['small_big_all']) - && $params_array['small_big_all'] == 'v' - ) { - $classes_array['small_big_all'] = 'M_butt_Selected_down'; - } else { - $classes_array['small_big_all'] = 'M_butt'; - } - - if (isset($params_array['side_menu']) - && $params_array['side_menu'] == 'true' - ) { - $classes_array['side_menu'] = 'M_butt_Selected_down'; - } else { - $classes_array['side_menu'] = 'M_butt'; - } - - return $classes_array; - } - - /** - * Get HTML to display tables on designer page - * - * @param string $db The database name from the request - * @param DesignerTable[] $designerTables The designer tables - * @param array $tab_pos tables positions - * @param int $display_page page number of the selected page - * @param array $tab_column table column info - * @param array $tables_all_keys all indices - * @param array $tables_pk_or_unique_keys unique or primary indices - * - * @return string html - */ - public function getDatabaseTables( - string $db, - array $designerTables, - array $tab_pos, - $display_page, - array $tab_column, - array $tables_all_keys, - array $tables_pk_or_unique_keys - ) { - $columns_type = []; - foreach ($designerTables as $designerTable) { - $table_name = $designerTable->getDbTableString(); - $limit = count($tab_column[$table_name]['COLUMN_ID']); - for ($j = 0; $j < $limit; $j++) { - $table_column_name = $table_name . '.' . $tab_column[$table_name]['COLUMN_NAME'][$j]; - if (isset($tables_pk_or_unique_keys[$table_column_name])) { - $columns_type[$table_column_name] = 'designer/FieldKey_small'; - } else { - $columns_type[$table_column_name] = 'designer/Field_small'; - if (false !== strpos($tab_column[$table_name]['TYPE'][$j], 'char') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'text')) { - $columns_type[$table_column_name] .= '_char'; - } elseif (false !== strpos($tab_column[$table_name]['TYPE'][$j], 'int') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'float') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'double') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'decimal')) { - $columns_type[$table_column_name] .= '_int'; - } elseif (false !== strpos($tab_column[$table_name]['TYPE'][$j], 'date') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'time') - || false !== strpos($tab_column[$table_name]['TYPE'][$j], 'year')) { - $columns_type[$table_column_name] .= '_date'; - } - } - } - } - return $this->template->render('database/designer/database_tables', [ - 'db' => $GLOBALS['db'], - 'get_db' => $db, - 'has_query' => isset($_REQUEST['query']), - 'tab_pos' => $tab_pos, - 'display_page' => $display_page, - 'tab_column' => $tab_column, - 'tables_all_keys' => $tables_all_keys, - 'tables_pk_or_unique_keys' => $tables_pk_or_unique_keys, - 'tables' => $designerTables, - 'columns_type' => $columns_type, - 'theme' => $GLOBALS['PMA_Theme'], - ]); - } - - - /** - * Returns HTML for Designer page - * - * @param string $db database in use - * @param string $getDb database in url - * @param DesignerTable[] $designerTables The designer tables - * @param array $scriptTables array on foreign key support for each table - * @param array $scriptContr initialization data array - * @param DesignerTable[] $scriptDisplayField displayed tables in designer with their display fields - * @param int $displayPage page number of the selected page - * @param boolean $hasQuery whether this is visual query builder - * @param string $selectedPage name of the selected page - * @param array $paramsArray array with class name for various buttons on side menu - * @param array|null $tabPos table positions - * @param array $tabColumn table column info - * @param array $tablesAllKeys all indices - * @param array $tablesPkOrUniqueKeys unique or primary indices - * - * @return string html - */ - public function getHtmlForMain( - string $db, - string $getDb, - array $designerTables, - array $scriptTables, - array $scriptContr, - array $scriptDisplayField, - $displayPage, - $hasQuery, - $selectedPage, - array $paramsArray, - ?array $tabPos, - array $tabColumn, - array $tablesAllKeys, - array $tablesPkOrUniqueKeys - ): string { - $cfgRelation = $this->relation->getRelationsParam(); - $columnsType = []; - foreach ($designerTables as $designerTable) { - $tableName = $designerTable->getDbTableString(); - $limit = count($tabColumn[$tableName]['COLUMN_ID']); - for ($j = 0; $j < $limit; $j++) { - $tableColumnName = $tableName . '.' . $tabColumn[$tableName]['COLUMN_NAME'][$j]; - if (isset($tablesPkOrUniqueKeys[$tableColumnName])) { - $columnsType[$tableColumnName] = 'designer/FieldKey_small'; - } else { - $columnsType[$tableColumnName] = 'designer/Field_small'; - if (false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'char') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'text')) { - $columnsType[$tableColumnName] .= '_char'; - } elseif (false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'int') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'float') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'double') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'decimal')) { - $columnsType[$tableColumnName] .= '_int'; - } elseif (false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'date') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'time') - || false !== strpos($tabColumn[$tableName]['TYPE'][$j], 'year')) { - $columnsType[$tableColumnName] .= '_date'; - } - } - } - } - - $displayedFields = []; - foreach ($scriptDisplayField as $designerTable) { - if ($designerTable->getDisplayField() !== null) { - $displayedFields[$designerTable->getTableName()] = $designerTable->getDisplayField(); - } - } - - $designerConfig = new stdClass(); - $designerConfig->db = $db; - $designerConfig->scriptTables = $scriptTables; - $designerConfig->scriptContr = $scriptContr; - $designerConfig->server = $GLOBALS['server']; - $designerConfig->scriptDisplayField = $displayedFields; - $designerConfig->displayPage = (int) $displayPage; - $designerConfig->tablesEnabled = $cfgRelation['pdfwork']; - - return $this->template->render('database/designer/main', [ - 'db' => $db, - 'get_db' => $getDb, - 'designer_config' => json_encode($designerConfig), - 'display_page' => (int) $displayPage, - 'has_query' => $hasQuery, - 'selected_page' => $selectedPage, - 'params_array' => $paramsArray, - 'theme' => $GLOBALS['PMA_Theme'], - 'tab_pos' => $tabPos, - 'tab_column' => $tabColumn, - 'tables_all_keys' => $tablesAllKeys, - 'tables_pk_or_unique_keys' => $tablesPkOrUniqueKeys, - 'designerTables' => $designerTables, - 'columns_type' => $columnsType, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Database/Designer/Common.php b/srcs/phpmyadmin/libraries/classes/Database/Designer/Common.php deleted file mode 100644 index b80f323..0000000 --- a/srcs/phpmyadmin/libraries/classes/Database/Designer/Common.php +++ /dev/null @@ -1,830 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Database\Designer\Common class - * - * @package PhpMyAdmin-Designer - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Database\Designer; - -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Index; -use PhpMyAdmin\Relation; -use PhpMyAdmin\Table; -use PhpMyAdmin\Util; -use function rawurlencode; -use PhpMyAdmin\Database\Designer\DesignerTable; - -/** - * Common functions for Designer - * - * @package PhpMyAdmin-Designer - */ -class Common -{ - /** - * @var Relation - */ - private $relation; - - /** - * @var DatabaseInterface - */ - private $dbi; - - /** - * Common constructor. - * - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Relation $relation Relation instance - */ - public function __construct(DatabaseInterface $dbi, Relation $relation) - { - $this->dbi = $dbi; - $this->relation = $relation; - } - - /** - * Retrieves table info and returns it - * - * @param string $db (optional) Filter only a DB ($table is required if you use $db) - * @param string $table (optional) Filter only a table ($db is now required) - * @return DesignerTable[] with table info - */ - public function getTablesInfo(string $db = null, string $table = null): array - { - $designerTables = []; - $db = ($db === null) ? $GLOBALS['db'] : $db; - // seems to be needed later - $this->dbi->selectDb($db); - if ($db === null && $table === null) { - $tables = $this->dbi->getTablesFull($db); - } else { - $tables = $this->dbi->getTablesFull($db, $table); - } - - foreach ($tables as $one_table) { - $DF = $this->relation->getDisplayField($db, $one_table['TABLE_NAME']); - $DF = is_string($DF) ? $DF : ''; - $DF = ($DF !== '') ? $DF : null; - $designerTables[] = new DesignerTable( - $db, - $one_table['TABLE_NAME'], - is_string($one_table['ENGINE']) ? $one_table['ENGINE'] : '', - $DF - ); - } - - return $designerTables; - } - - /** - * Retrieves table column info - * - * @param DesignerTable[] $designerTables The designer tables - * @return array table column nfo - */ - public function getColumnsInfo(array $designerTables): array - { - //$this->dbi->selectDb($GLOBALS['db']); - $tabColumn = []; - - foreach ($designerTables as $designerTable) { - $fieldsRs = $this->dbi->query( - $this->dbi->getColumnsSql( - $designerTable->getDatabaseName(), - $designerTable->getTableName(), - null, - true - ), - DatabaseInterface::CONNECT_USER, - DatabaseInterface::QUERY_STORE - ); - $j = 0; - while ($row = $this->dbi->fetchAssoc($fieldsRs)) { - if (! isset($tabColumn[$designerTable->getDbTableString()])) { - $tabColumn[$designerTable->getDbTableString()] = []; - } - $tabColumn[$designerTable->getDbTableString()]['COLUMN_ID'][$j] = $j; - $tabColumn[$designerTable->getDbTableString()]['COLUMN_NAME'][$j] = $row['Field']; - $tabColumn[$designerTable->getDbTableString()]['TYPE'][$j] = $row['Type']; - $tabColumn[$designerTable->getDbTableString()]['NULLABLE'][$j] = $row['Null']; - $j++; - } - } - - return $tabColumn; - } - - /** - * Returns JavaScript code for initializing vars - * - * @param DesignerTable[] $designerTables The designer tables - * @return array JavaScript code - */ - public function getScriptContr(array $designerTables): array - { - $this->dbi->selectDb($GLOBALS['db']); - $con = []; - $con["C_NAME"] = []; - $i = 0; - $alltab_rs = $this->dbi->query( - 'SHOW TABLES FROM ' . Util::backquote($GLOBALS['db']), - DatabaseInterface::CONNECT_USER, - DatabaseInterface::QUERY_STORE - ); - while ($val = @$this->dbi->fetchRow($alltab_rs)) { - $row = $this->relation->getForeigners($GLOBALS['db'], $val[0], '', 'internal'); - - if ($row !== false) { - foreach ($row as $field => $value) { - $con['C_NAME'][$i] = ''; - $con['DTN'][$i] = rawurlencode($GLOBALS['db'] . "." . $val[0]); - $con['DCN'][$i] = rawurlencode($field); - $con['STN'][$i] = rawurlencode( - $value['foreign_db'] . "." . $value['foreign_table'] - ); - $con['SCN'][$i] = rawurlencode($value['foreign_field']); - $i++; - } - } - $row = $this->relation->getForeigners($GLOBALS['db'], $val[0], '', 'foreign'); - - // We do not have access to the foreign keys if he user has partial access to the columns - if ($row !== false && isset($row['foreign_keys_data'])) { - foreach ($row['foreign_keys_data'] as $one_key) { - foreach ($one_key['index_list'] as $index => $one_field) { - $con['C_NAME'][$i] = rawurlencode($one_key['constraint']); - $con['DTN'][$i] = rawurlencode($GLOBALS['db'] . "." . $val[0]); - $con['DCN'][$i] = rawurlencode($one_field); - $con['STN'][$i] = rawurlencode( - (isset($one_key['ref_db_name']) ? - $one_key['ref_db_name'] : $GLOBALS['db']) - . "." . $one_key['ref_table_name'] - ); - $con['SCN'][$i] = rawurlencode($one_key['ref_index_list'][$index]); - $i++; - } - } - } - } - - $tableDbNames = []; - foreach ($designerTables as $designerTable) { - $tableDbNames[] = $designerTable->getDbTableString(); - } - - $ti = 0; - $retval = []; - for ($i = 0, $cnt = count($con["C_NAME"]); $i < $cnt; $i++) { - $c_name_i = $con['C_NAME'][$i]; - $dtn_i = $con['DTN'][$i]; - $retval[$ti] = []; - $retval[$ti][$c_name_i] = []; - if (in_array($dtn_i, $tableDbNames) && in_array($con['STN'][$i], $tableDbNames)) { - $retval[$ti][$c_name_i][$dtn_i] = []; - $retval[$ti][$c_name_i][$dtn_i][$con['DCN'][$i]] = [ - 0 => $con['STN'][$i], - 1 => $con['SCN'][$i], - ]; - } - $ti++; - } - return $retval; - } - - /** - * Returns UNIQUE and PRIMARY indices - * - * @param DesignerTable[] $designerTables The designer tables - * @return array unique or primary indices - */ - public function getPkOrUniqueKeys(array $designerTables): array - { - return $this->getAllKeys($designerTables, true); - } - - /** - * Returns all indices - * - * @param DesignerTable[] $designerTables The designer tables - * @param bool $unique_only whether to include only unique ones - * - * @return array indices - */ - public function getAllKeys(array $designerTables, bool $unique_only = false): array - { - $keys = []; - - foreach ($designerTables as $designerTable) { - $schema = $designerTable->getDatabaseName(); - // for now, take into account only the first index segment - foreach (Index::getFromTable($designerTable->getTableName(), $schema) as $index) { - if ($unique_only && ! $index->isUnique()) { - continue; - } - $columns = $index->getColumns(); - foreach ($columns as $column_name => $dummy) { - $keys[$schema . '.' . $designerTable->getTableName() . '.' . $column_name] = 1; - } - } - } - return $keys; - } - - /** - * Return j_tab and h_tab arrays - * - * @param DesignerTable[] $designerTables The designer tables - * @return array - */ - public function getScriptTabs(array $designerTables): array - { - $retval = [ - 'j_tabs' => [], - 'h_tabs' => [], - ]; - - foreach ($designerTables as $designerTable) { - $key = rawurlencode($designerTable->getDbTableString()); - $retval['j_tabs'][$key] = $designerTable->supportsForeignkeys() ? 1 : 0; - $retval['h_tabs'][$key] = 1; - } - - return $retval; - } - - /** - * Returns table positions of a given pdf page - * - * @param int $pg pdf page id - * - * @return array|null of table positions - */ - public function getTablePositions($pg): ?array - { - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return []; - } - - $query = " - SELECT CONCAT_WS('.', `db_name`, `table_name`) AS `name`, - `db_name` as `dbName`, `table_name` as `tableName`, - `x` AS `X`, - `y` AS `Y`, - 1 AS `V`, - 1 AS `H` - FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['table_coords']) . " - WHERE pdf_page_number = " . intval($pg); - - return $this->dbi->fetchResult( - $query, - 'name', - null, - DatabaseInterface::CONNECT_CONTROL, - DatabaseInterface::QUERY_STORE - ); - } - - /** - * Returns page name of a given pdf page - * - * @param int $pg pdf page id - * - * @return string|null table name - */ - public function getPageName($pg) - { - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return null; - } - - $query = "SELECT `page_descr`" - . " FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['pdf_pages']) - . " WHERE " . Util::backquote('page_nr') . " = " . intval($pg); - $page_name = $this->dbi->fetchResult( - $query, - null, - null, - DatabaseInterface::CONNECT_CONTROL, - DatabaseInterface::QUERY_STORE - ); - return ( is_array($page_name) && isset($page_name[0]) ) ? $page_name[0] : null; - } - - /** - * Deletes a given pdf page and its corresponding coordinates - * - * @param int $pg page id - * - * @return boolean success/failure - */ - public function deletePage($pg) - { - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return false; - } - - $query = "DELETE FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['table_coords']) - . " WHERE " . Util::backquote('pdf_page_number') . " = " . intval($pg); - $success = $this->relation->queryAsControlUser( - $query, - true, - DatabaseInterface::QUERY_STORE - ); - - if ($success) { - $query = "DELETE FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['pdf_pages']) - . " WHERE " . Util::backquote('page_nr') . " = " . intval($pg); - $success = $this->relation->queryAsControlUser( - $query, - true, - DatabaseInterface::QUERY_STORE - ); - } - - return (bool) $success; - } - - /** - * Returns the id of the default pdf page of the database. - * Default page is the one which has the same name as the database. - * - * @param string $db database - * - * @return int|null id of the default pdf page for the database - */ - public function getDefaultPage($db): ?int - { - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return -1; - } - - $query = "SELECT `page_nr`" - . " FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['pdf_pages']) - . " WHERE `db_name` = '" . $this->dbi->escapeString($db) . "'" - . " AND `page_descr` = '" . $this->dbi->escapeString($db) . "'"; - - $default_page_no = $this->dbi->fetchResult( - $query, - null, - null, - DatabaseInterface::CONNECT_CONTROL, - DatabaseInterface::QUERY_STORE - ); - - if (is_array($default_page_no) && isset($default_page_no[0])) { - return intval($default_page_no[0]); - } - return -1; - } - - /** - * Get the id of the page to load. If a default page exists it will be returned. - * If no such exists, returns the id of the first page of the database. - * - * @param string $db database - * - * @return int id of the page to load - */ - public function getLoadingPage($db) - { - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return -1; - } - - $page_no = -1; - - $default_page_no = $this->getDefaultPage($db); - if ($default_page_no != -1) { - $page_no = $default_page_no; - } else { - $query = "SELECT MIN(`page_nr`)" - . " FROM " . Util::backquote($cfgRelation['db']) - . "." . Util::backquote($cfgRelation['pdf_pages']) - . " WHERE `db_name` = '" . $this->dbi->escapeString($db) . "'"; - - $min_page_no = $this->dbi->fetchResult( - $query, - null, - null, - DatabaseInterface::CONNECT_CONTROL, - DatabaseInterface::QUERY_STORE - ); - if (is_array($min_page_no) && isset($min_page_no[0])) { - $page_no = $min_page_no[0]; - } - } - return intval($page_no); - } - - /** - * Creates a new page and returns its auto-incrementing id - * - * @param string $pageName name of the page - * @param string $db name of the database - * - * @return int|null - */ - public function createNewPage($pageName, $db) - { - $cfgRelation = $this->relation->getRelationsParam(); - if ($cfgRelation['pdfwork']) { - return $this->relation->createPage( - $pageName, - $cfgRelation, - $db - ); - } - return null; - } - - /** - * Saves positions of table(s) of a given pdf page - * - * @param int $pg pdf page id - * - * @return boolean success/failure - */ - public function saveTablePositions($pg) - { - $pageId = $this->dbi->escapeString($pg); - - $db = $this->dbi->escapeString($_POST['db']); - - $cfgRelation = $this->relation->getRelationsParam(); - if (! $cfgRelation['pdfwork']) { - return false; - } - - $query = "DELETE FROM " - . Util::backquote($cfgRelation['db']) - . "." . Util::backquote( - $cfgRelation['table_coords'] - ) - . " WHERE `pdf_page_number` = '" . $pageId . "'"; - - $res = $this->relation->queryAsControlUser( - $query, - true, - DatabaseInterface::QUERY_STORE - ); - - if (! $res) { - return (bool) $res; - } - - foreach ($_POST['t_h'] as $key => $value) { - $DB = $_POST['t_db'][$key]; - $TAB = $_POST['t_tbl'][$key]; - if (! $value) { - continue; - } - - $query = "INSERT INTO " - . Util::backquote($cfgRelation['db']) . "." - . Util::backquote($cfgRelation['table_coords']) - . " (`db_name`, `table_name`, `pdf_page_number`, `x`, `y`)" - . " VALUES (" - . "'" . $this->dbi->escapeString($DB) . "', " - . "'" . $this->dbi->escapeString($TAB) . "', " - . "'" . $pageId . "', " - . "'" . $this->dbi->escapeString($_POST['t_x'][$key]) . "', " - |