/** * 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; }