diff options
Diffstat (limited to 'hugo/view_create.php')
| -rw-r--r-- | hugo/view_create.php | 235 |
1 files changed, 235 insertions, 0 deletions
diff --git a/hugo/view_create.php b/hugo/view_create.php new file mode 100644 index 0000000..cd2ec3b --- /dev/null +++ b/hugo/view_create.php @@ -0,0 +1,235 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * handles creation of VIEWs + * + * @todo js error when view name is empty (strFormEmpty) + * @todo (also validate if js is disabled, after form submission?) + * @package PhpMyAdmin + */ + +/** + * + */ +require_once './libraries/common.inc.php'; + +/** + * Runs common work + */ +require './libraries/db_common.inc.php'; +$url_params['goto'] = $cfg['DefaultTabDatabase']; +$url_params['back'] = 'view_create.php'; + +$view_algorithm_options = array( + 'UNDEFINED', + 'MERGE', + 'TEMPTABLE', +); + +$view_with_options = array( + 'CASCADED CHECK OPTION', + 'LOCAL CHECK OPTION' +); + +if (isset($_REQUEST['createview'])) { + /** + * Creates the view + */ + $sep = "\r\n"; + + $sql_query = 'CREATE'; + + if (isset($_REQUEST['view']['or_replace'])) { + $sql_query .= ' OR REPLACE'; + } + + if (PMA_isValid($_REQUEST['view']['algorithm'], $view_algorithm_options)) { + $sql_query .= $sep . ' ALGORITHM = ' . $_REQUEST['view']['algorithm']; + } + + $sql_query .= $sep . ' VIEW ' . PMA_Util::backquote($_REQUEST['view']['name']); + + if (! empty($_REQUEST['view']['column_names'])) { + $sql_query .= $sep . ' (' . $_REQUEST['view']['column_names'] . ')'; + } + + $sql_query .= $sep . ' AS ' . $_REQUEST['view']['as']; + + if (isset($_REQUEST['view']['with'])) { + $options = array_intersect($_REQUEST['view']['with'], $view_with_options); + if (count($options)) { + $sql_query .= $sep . ' WITH ' . implode(' ', $options); + } + } + + if (PMA_DBI_try_query($sql_query)) { + + include_once './libraries/tbl_views.lib.php'; + + // If different column names defined for VIEW + $view_columns = array(); + if (isset($_REQUEST['view']['column_names'])) { + $view_columns = explode(',', $_REQUEST['view']['column_names']); + } + + $column_map = PMA_getColumnMap($_REQUEST['view']['as'], $view_columns); + $pma_tranformation_data = PMA_getExistingTranformationData($GLOBALS['db']); + + if ($pma_tranformation_data !== false) { + + // SQL for store new transformation details of VIEW + $new_transformations_sql = PMA_getNewTransformationDataSql( + $pma_tranformation_data, $column_map, $_REQUEST['view']['name'], + $GLOBALS['db'] + ); + + // Store new transformations + if ($new_transformations_sql != '') { + PMA_DBI_try_query($new_transformations_sql); + } + + } + unset($pma_tranformation_data); + + if ($GLOBALS['is_ajax_request'] != true) { + $message = PMA_Message::success(); + include './' . $cfg['DefaultTabDatabase']; + } else { + $response = PMA_Response::getInstance(); + $response->addJSON( + 'message', + PMA_Util::getMessage( + PMA_Message::success(), $sql_query + ) + ); + } + + exit; + + } else { + if ($GLOBALS['is_ajax_request'] != true) { + $message = PMA_Message::rawError(PMA_DBI_getError()); + } else { + $response = PMA_Response::getInstance(); + $response->addJSON( + 'message', + PMA_Message::error( + "<i>" . htmlspecialchars($sql_query) . "</i><br /><br />" + . PMA_DBI_getError() + ) + ); + $response->isSuccess(false); + exit; + } + } +} + +// prefill values if not already filled from former submission +$view = array( + 'or_replace' => '', + 'algorithm' => '', + 'name' => '', + 'column_names' => '', + 'as' => $sql_query, + 'with' => array(), +); + +if (PMA_isValid($_REQUEST['view'], 'array')) { + $view = array_merge($view, $_REQUEST['view']); +} + +$url_params['db'] = $GLOBALS['db']; +$url_params['reload'] = 1; + +/** + * Displays the page + */ +$htmlString = '<!-- CREATE VIEW options -->' + . '<div id="div_view_options">' + . '<form method="post" action="view_create.php">' + . PMA_generate_common_hidden_inputs($url_params) + . '<fieldset>' + . '<legend>' . __('Create view') + . PMA_Util::showMySQLDocu('SQL-Syntax', 'CREATE_VIEW') . '</legend>' + . '<table class="rte_table">' + . '<tr><td><label for="or_replace">OR REPLACE</label></td>' + . '<td><input type="checkbox" name="view[or_replace]" id="or_replace"'; +if ($view['or_replace']) { + $htmlString .= ' checked="checked"'; +} +$htmlString .= ' value="1" />' + . '</td>' + . '</tr>' + . '<tr>' + . '<td><label for="algorithm">ALGORITHM</label></td>' + . '<td><select name="view[algorithm]" id="algorithm">'; + +foreach ($view_algorithm_options as $option) { + $htmlString .= '<option value="' . htmlspecialchars($option) . '"'; + if ($view['algorithm'] === $option) { + $htmlString .= ' selected="selected"'; + } + $htmlString .= '>' . htmlspecialchars($option) . '</option>'; +} + +$htmlString .= '</select>' + . '</td>' + . '</tr>' + . '<tr><td>' . __('VIEW name') . '</td>' + . '<td><input type="text" size="20" name="view[name]" onfocus="this.select()"' + . ' value="' . htmlspecialchars($view['name']) . '" />' + . '</td>' + . '</tr>' + . '<tr><td>' . __('Column names') . '</td>' + . '<td><input type="text" maxlength="100" size="50" name="view[column_names]"' + . ' onfocus="this.select()"' + . ' value="' . htmlspecialchars($view['column_names']) . '" />' + . '</td>' + . '</tr>' + . '<tr><td>AS</td>' + . '<td>' + . '<textarea name="view[as]" rows="' . $cfg['TextareaRows'] . '"' + . ' cols="' . $cfg['TextareaCols'] . '"' + . ' dir="' . $text_dir . '"'; + +if ($GLOBALS['cfg']['TextareaAutoSelect'] || true) { + $htmlString .= ' onclick="selectContent(this, sql_box_locked, true)"'; +} + +$htmlString .= '>' . htmlspecialchars($view['as']) . '</textarea>' + . '</td>' + . '</tr>' + . '<tr><td>WITH</td>' + . '<td>'; + +foreach ($view_with_options as $option) { + $htmlString .= '<input type="checkbox" name="view[with][]"'; + if (in_array($option, $view['with'])) { + $htmlString .= ' checked="checked"'; + } + $htmlString .= ' id="view_with_' + . str_replace(' ', '_', htmlspecialchars($option)) . '"' + . ' value="' . htmlspecialchars($option) . '" />' + . '<label for="view_with_' . str_replace(' ', '_', htmlspecialchars($option)) + . '"> ' + . htmlspecialchars($option) . '</label><br />'; +} + +$htmlString .= '</td>' + . '</tr>' + . '</table>' + . '</fieldset>'; + +if ($GLOBALS['is_ajax_request'] != true) { + $htmlString .= '<fieldset class="tblFooters">' + . '<input type="submit" name="createview" value="' . __('Go') . '" />' + . '</fieldset>'; +} else { + $htmlString .= '<input type="hidden" name="createview" value="1" />' + . '<input type="hidden" name="ajax_request" value="1" />'; +} + +$htmlString .= '</form>' + . '</div>'; + +echo $htmlString; |