/**
* Tests for PMA_getHtmlForSelect() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForSelect()
{
$column = "labelColumn";
$columnCandidates = array("option1", "option2", "option3");
$visualizationSettings = array("labelColumn" => "option3", "height" => "10");
$html = PMA_getHtmlForSelect($column, $columnCandidates, $visualizationSettings);
$this->assertContains('<label for="' . $column . '">', $html);
$this->assertContains(__("Label column"), $html);
$output = PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
$this->assertContains($output, $html);
}
/**
* Tests for PMA_getHtmlForColumn() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForColumn()
{
$column = 0;
$columnCandidates = array("option1", "option2");
$visualizationSettings = array("option2", "option3");
$html = PMA_getHtmlForColumn($column, $columnCandidates, $visualizationSettings);
$this->assertContains('<tr><td><label for="labelColumn">', $html);
$this->assertContains(__("Label column"), $html);
$output = PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
$this->assertContains($output, $html);
}
/**
* Get the HTML for the set column dropdown
* During grid edit, if we have a set field, returns the html for the
* dropdown
*
* @param string $db current database
* @param string $table current table
* @param string $column current column
* @param string $curr_value currently selected value
*
* @return string $dropdown html for the set column
*/
function PMA_getHtmlForSetColumn($db, $table, $column, $curr_value)
{
$values = PMA_getValuesForColumn($db, $table, $column);
$dropdown = '';
//converts characters of $curr_value to HTML entities
$converted_curr_value = htmlentities($curr_value, ENT_COMPAT, "UTF-8");
$selected_values = explode(',', $converted_curr_value);
$dropdown .= PMA_getHtmlForOptionsList($values, $selected_values);
$select_size = sizeof($values) > 10 ? 10 : sizeof($values);
$dropdown = '<select multiple="multiple" size="' . $select_size . '">' . $dropdown . '</select>';
return $dropdown;
}
/**
* Get the HTML for the set column dropdown
* During grid edit, if we have a set field, returns the html for the
* dropdown
*
* @param string $db current database
* @param string $table current table
* @param string $column current column
* @param string $curr_value currently selected value
*
* @return string $dropdown html for the set column
*/
function PMA_getHtmlForSetColumn($db, $table, $column, $curr_value)
{
$values = PMA_getValuesForColumn($db, $table, $column);
$dropdown = '';
$full_values = isset($_REQUEST['get_full_values']) ? $_REQUEST['get_full_values'] : false;
$where_clause = isset($_REQUEST['where_clause']) ? $_REQUEST['where_clause'] : null;
// If the $curr_value was truncated, we should
// fetch the correct full values from the table
if ($full_values && !empty($where_clause)) {
$curr_value = PMA_getFullValuesForSetColumn($db, $table, $column, $where_clause);
}
//converts characters of $curr_value to HTML entities
$converted_curr_value = htmlentities($curr_value, ENT_COMPAT, "UTF-8");
$selected_values = explode(',', $converted_curr_value);
$dropdown .= PMA_getHtmlForOptionsList($values, $selected_values);
$select_size = sizeof($values) > 10 ? 10 : sizeof($values);
$dropdown = '<select multiple="multiple" size="' . $select_size . '">' . $dropdown . '</select>';
return $dropdown;
}
/**
* Function to get html for the lebel column and spatial column
*
* @param string $column the column type. i.e either "labelColumn"
* or "spatialColumn"
* @param array $columnCandidates the list of select options
* @param array $visualizationSettings visualization settings
*
* @return string $html
*/
function PMA_getHtmlForColumn($column, $columnCandidates, $visualizationSettings)
{
$html = '<tr><td><label for="labelColumn">';
$html .= $column == "labelColumn" ? __("Label column") : __("Spatial column");
$html .= '</label></td>';
$html .= '<td><select name="visualizationSettings[' . $column . ']" id="' . $column . '">';
if ($column == "labelColumn") {
$html .= '<option value="">' . __("-- None --") . '</option>';
}
$html .= PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
$html .= '</select></td>';
$html .= '</tr>';
return $html;
}