/**
* Function to get html for Internal relations form
*
* @param array $columns columns
* @param string $tbl_storage_engine table storage engine
* @param array $existrel db, table, column
* @param string $db current database
*
* @return string
*/
function PMA_getHtmlForInternalRelationForm($columns, $tbl_storage_engine, $existrel, $db)
{
$save_row = array_values($columns);
$saved_row_cnt = count($save_row);
$html_output = '<fieldset>' . '<legend>' . __('Internal relations') . '</legend>' . '<table id="internal_relations" class="relationalTable">';
$html_output .= '<tr><th>' . __('Column') . '</th>';
$html_output .= '<th>' . __('Internal relation');
if (PMA_Util::isForeignKeySupported($tbl_storage_engine)) {
$html_output .= PMA_Util::showHint(__('An internal relation is not necessary when a corresponding' . ' FOREIGN KEY relation exists.'));
}
$html_output .= '</th>';
$odd_row = true;
for ($i = 0; $i < $saved_row_cnt; $i++) {
$html_output .= PMA_getHtmlForInternalRelationRow($save_row, $i, $odd_row, $existrel, $db);
$odd_row = !$odd_row;
}
$html_output .= '</table>';
$html_output .= '</fieldset>';
return $html_output;
}
/**
* Tests for PMA_getHtmlForCommonForm() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForCommonForm()
{
$db = "pma_db";
$table = "pma_table";
$columns = array(array("Field" => "Field1"));
$cfgRelation = array('displaywork' => true, 'relwork' => true, 'displaywork' => true);
$tbl_storage_engine = "InnoDB";
$existrel = array();
$existrel_foreign = array();
$options_array = array();
$save_row = array();
foreach ($columns as $row) {
$save_row[] = $row;
}
$html = PMA_getHtmlForCommonForm($db, $table, $columns, $cfgRelation, $tbl_storage_engine, $existrel, $existrel_foreign, $options_array);
//case 1: PMA_getHtmlForInternalRelationForm
$this->assertContains(PMA_getHtmlForInternalRelationForm($columns, $tbl_storage_engine, $existrel, $db), $html);
//case 2: PMA_getHtmlForForeignKeyForm
$this->assertContains(PMA_getHtmlForForeignKeyForm($columns, $existrel_foreign, $db, $tbl_storage_engine, $options_array), $html);
$this->assertContains(PMA_URL_getHiddenInputs($db, $table), $html);
$this->assertContains(__('Relations'), $html);
$this->assertContains(__('Column'), $html);
$this->assertContains(__('Internal relation'), $html);
$this->assertContains(__('Choose column to display:'), $html);
//case 3: PMA_getHtmlForInternalRelationRow
$row = PMA_getHtmlForInternalRelationRow($save_row, 0, true, $existrel, $db);
$this->assertContains($row, $html);
//case 4: PMA_getHtmlForForeignKeyRow
$row = PMA_getHtmlForForeignKeyRow(array(), true, $columns, 0, $options_array, $tbl_storage_engine, $db);
$this->assertContains($row, $html);
//case 5: PMA_getHtmlForDisplayFieldInfos
$this->assertContains(PMA_getHtmlForDisplayFieldInfos($db, $table, $save_row), $html);
//case 6: PMA_getHtmlForCommonFormFooter
$this->assertContains(PMA_getHtmlForCommonFormFooter(), $html);
}
