$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
