/**
* Function to get html for displaying last version number
*
* @param array $sql_result sql result
* @param int $last_version last version
* @param array $url_params url parameters
* @param string $url_query url query
*
* @return string
*/
function PMA_getHtmlForTableVersionDetails($sql_result, $last_version, $url_params, $url_query)
{
$html = '<table id="versions" class="data">';
$html .= '<thead>';
$html .= '<tr>';
$html .= '<th>' . __('Database') . '</th>';
$html .= '<th>' . __('Table') . '</th>';
$html .= '<th>' . __('Version') . '</th>';
$html .= '<th>' . __('Created') . '</th>';
$html .= '<th>' . __('Updated') . '</th>';
$html .= '<th>' . __('Status') . '</th>';
$html .= '<th>' . __('Show') . '</th>';
$html .= '</tr>';
$html .= '</thead>';
$html .= '<tbody>';
$style = 'odd';
$GLOBALS['dbi']->dataSeek($sql_result, 0);
while ($version = $GLOBALS['dbi']->fetchArray($sql_result)) {
if ($version['tracking_active'] == 1) {
$version_status = __('active');
} else {
$version_status = __('not active');
}
if ($version['version'] == $last_version) {
if ($version['tracking_active'] == 1) {
$tracking_active = true;
} else {
$tracking_active = false;
}
}
$html .= '<tr class="noclick ' . $style . '">';
$html .= '<td>' . htmlspecialchars($version['db_name']) . '</td>';
$html .= '<td>' . htmlspecialchars($version['table_name']) . '</td>';
$html .= '<td>' . htmlspecialchars($version['version']) . '</td>';
$html .= '<td>' . htmlspecialchars($version['date_created']) . '</td>';
$html .= '<td>' . htmlspecialchars($version['date_updated']) . '</td>';
$html .= '<td>' . $version_status . '</td>';
$html .= '<td><a href="tbl_tracking.php';
$html .= PMA_URL_getCommon($url_params + array('report' => 'true', 'version' => $version['version']));
$html .= '">' . __('Tracking report') . '</a>';
$html .= ' | ';
$html .= '<a href="tbl_tracking.php';
$html .= PMA_URL_getCommon($url_params + array('snapshot' => 'true', 'version' => $version['version']));
$html .= '">' . __('Structure snapshot') . '</a>';
$html .= '</td>';
$html .= '</tr>';
if ($style == 'even') {
$style = 'odd';
} else {
$style = 'even';
}
}
$html .= '</tbody>';
$html .= '</table>';
if ($tracking_active) {
$html .= PMA_getHtmlForDeactivateTracking($url_query, $last_version);
} else {
$html .= PMA_getHtmlForActivateTracking($url_query, $last_version);
}
return $html;
}
/**
* Tests for PMA_getHtmlForDeactivateTracking() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForDeactivateTracking()
{
$url_query = "url_query";
$last_version = "10";
$html = PMA_getHtmlForDeactivateTracking($url_query, $last_version);
$this->assertContains('<div id="div_deactivate_tracking">', $html);
$this->assertContains($url_query, $html);
$item = sprintf(__('Deactivate tracking for %s'), htmlspecialchars($GLOBALS['db'] . '.' . $GLOBALS['table']));
$this->assertContains($item, $html);
$this->assertContains($last_version, $html);
$this->assertContains(__('Deactivate now'), $html);
}
