$selectable_tables_sql_result = PMA_getSQLResultForSelectableTables(); if ($GLOBALS['dbi']->numRows($selectable_tables_sql_result) > 0) { $html .= PMA_getHtmlForSelectableTables( $selectable_tables_sql_result, $url_query ); } $html .= '<br />'; /* * List versions of current table */ $sql_result = PMA_getListOfVersionsOfTable(); $last_version = PMA_getTableLastVersionNumber($sql_result); if ($last_version > 0) { $html .= PMA_getHtmlForTableVersionDetails( $sql_result, $last_version, $url_params, $url_query, $pmaThemeImage, $text_dir ); } $type = $GLOBALS['dbi']->getTable($GLOBALS['db'], $GLOBALS['table']) ->isView() ? 'view' : 'table'; $html .= PMA_getHtmlForDataDefinitionAndManipulationStatements( 'tbl_tracking.php' . $url_query, $last_version, $GLOBALS['db'], array($GLOBALS['table']), $type ); $html .= '<br class="clearfloat"/>';
/** * Tests for PMA_getHtmlForTableVersionDetails() method. * * @return void * @test */ public function testPMAGetHtmlForTableVersionDetails() { $sql_result = true; $last_version = "10"; $url_params = array(); $url_query = "select * from PMA"; $pmaThemeImage = "themePath/img"; $text_dir = "ltr"; $dbi_old = $GLOBALS['dbi']; $dbi = $this->getMockBuilder('PMA_DatabaseInterface')->disableOriginalConstructor()->getMock(); $fetchArray = array('tracking_active' => 1, 'version' => "10", 'db_name' => 'db_name', 'table_name' => 'table_name', 'date_created' => 'date_created', 'date_updated' => 'date_updated'); $dbi->expects($this->at(0))->method('fetchArray')->will($this->returnValue($fetchArray)); $dbi->expects($this->at(1))->method('fetchArray')->will($this->returnValue($fetchArray)); $dbi->expects($this->at(2))->method('fetchArray')->will($this->returnValue(false)); $GLOBALS['dbi'] = $dbi; $ret = PMA_getHtmlForTableVersionDetails($sql_result, $last_version, $url_params, $url_query, $pmaThemeImage, $text_dir); $this->assertContains(__('Version'), $ret); $this->assertContains(__('Created'), $ret); $this->assertContains(__('Updated'), $ret); $this->assertContains(__('Status'), $ret); $this->assertContains(__('Action'), $ret); $this->assertContains(__('Show'), $ret); $this->assertContains($fetchArray['version'], $ret); $this->assertContains($fetchArray['date_created'], $ret); $this->assertContains($fetchArray['date_updated'], $ret); $this->assertContains(__('Tracking report'), $ret); $this->assertContains(__('Structure snapshot'), $ret); $html = sprintf(__('Deactivate tracking for %s'), htmlspecialchars($GLOBALS['db'] . '.' . $GLOBALS['table'])); $this->assertContains($html, $ret); //restore DBI $GLOBALS['dbi'] = $dbi_old; }
*/ if (isset($_REQUEST['report']) && (isset($_REQUEST['delete_ddlog']) || isset($_REQUEST['delete_dmlog']))) { PMA_deleteTrackingReportRows($data); } if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) { $html .= PMA_getHtmlForTrackingReport($url_query, $data, $url_params, $selection_schema, $selection_data, $selection_both, $filter_ts_to, $filter_ts_from, $filter_users); } // end of report /* * List selectable tables */ $selectable_tables_sql_result = PMA_getSQLResultForSelectableTables(); if ($GLOBALS['dbi']->numRows($selectable_tables_sql_result) > 0) { $html .= PMA_getHtmlForSelectableTables($selectable_tables_sql_result, $url_query); } $html .= '<br />'; /* * List versions of current table */ $sql_result = PMA_getListOfVersionsOfTable(); $last_version = PMA_getTableLastVersionNumber($sql_result); if ($last_version > 0) { $html .= PMA_getHtmlForTableVersionDetails($sql_result, $last_version, $url_params, $url_query); } $html .= PMA_getHtmlForDataDefinitionAndManipulationStatements($url_query, $last_version); $html .= '<br class="clearfloat"/>'; $response = PMA_Response::getInstance(); $response->addHTML($html); ?> >>>>>>> b875702c9c06ab5012e52ff4337439b03918f453