Initial commit of intern.ccwn.org contentsHEADmaster

1 files changed, 170 insertions, 0 deletions

diff --git a/hugo/tbl_zoom_select.php b/hugo/tbl_zoom_select.php
new file mode 100644
index 0000000..2c6a123
--- /dev/null
+++ b/hugo/tbl_zoom_select.php
@@ -0,0 +1,170 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Handles table zoom search tab
+ *
+ * display table zoom search form, create SQL queries from form data
+ *
+ * @package PhpMyAdmin
+ */
+
+/**
+ * Gets some core libraries
+ */
+require_once './libraries/common.inc.php';
+require_once './libraries/mysql_charsets.lib.php';
+require_once './libraries/TableSearch.class.php';
+require_once './libraries/tbl_info.inc.php';
+
+$response = PMA_Response::getInstance();
+$header   = $response->getHeader();
+$scripts  = $header->getScripts();
+$scripts->addFile('makegrid.js');
+$scripts->addFile('sql.js');
+/* < IE 9 doesn't support canvas natively */
+if (PMA_USR_BROWSER_AGENT == 'IE' && PMA_USR_BROWSER_VER < 9) {
+    $scripts->addFile('canvg/flashcanvas.js');
+}
+$scripts->addFile('jqplot/jquery.jqplot.js');
+$scripts->addFile('jqplot/plugins/jqplot.canvasTextRenderer.js');
+$scripts->addFile('jqplot/plugins/jqplot.canvasAxisLabelRenderer.js');
+$scripts->addFile('jqplot/plugins/jqplot.dateAxisRenderer.js');
+$scripts->addFile('jqplot/plugins/jqplot.highlighter.js');
+$scripts->addFile('jqplot/plugins/jqplot.cursor.js');
+$scripts->addFile('canvg/canvg.js');
+$scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
+$scripts->addFile('tbl_zoom_plot_jqplot.js');
+
+/**
+ * Sets globals from $_POST
+ */
+$post_params = array(
+    'dataLabel',
+    'maxPlotLimit',
+    'zoom_submit'
+);
+foreach ($post_params as $one_post_param) {
+    if (isset($_POST[$one_post_param])) {
+        $GLOBALS[$one_post_param] = $_POST[$one_post_param];
+    }
+}
+
+$table_search = new PMA_TableSearch($db, $table, "zoom");
+
+/**
+ * Handle AJAX request for data row on point select
+ * @var post_params Object containing parameters for the POST request
+ */
+
+if (isset($_REQUEST['get_data_row']) && $_REQUEST['get_data_row'] == true) {
+    $extra_data = array();
+    $row_info_query = 'SELECT * FROM `' . $_REQUEST['db'] . '`.`'
+        . $_REQUEST['table'] . '` WHERE ' .  $_REQUEST['where_clause'];
+    $result = PMA_DBI_query($row_info_query . ";", null, PMA_DBI_QUERY_STORE);
+    $fields_meta = PMA_DBI_get_fields_meta($result);
+    while ($row = PMA_DBI_fetch_assoc($result)) {
+        // for bit fields we need to convert them to printable form
+        $i = 0;
+        foreach ($row as $col => $val) {
+            if ($fields_meta[$i]->type == 'bit') {
+                $row[$col] = PMA_Util::printableBitValue($val, $fields_meta[$i]->length);
+            }
+            $i++;
+        }
+        $extra_data['row_info'] = $row;
+    }
+    PMA_Response::getInstance()->addJSON($extra_data);
+    exit;
+}
+
+/**
+ * Handle AJAX request for changing field information
+ * (value,collation,operators,field values) in input form
+ * @var post_params Object containing parameters for the POST request
+ */
+
+if (isset($_REQUEST['change_tbl_info']) && $_REQUEST['change_tbl_info'] == true) {
+    $response = PMA_Response::getInstance();
+    $field = $_REQUEST['field'];
+    if ($field == 'pma_null') {
+        $response->addJSON('field_type', '');
+        $response->addJSON('field_collation', '');
+        $response->addJSON('field_operators', '');
+        $response->addJSON('field_value', '');
+        exit;
+    }
+    $key = array_search($field, $table_search->getColumnNames());
+    $properties = $table_search->getColumnProperties($_REQUEST['it'], $key);
+    $response->addJSON('field_type', $properties['type']);
+    $response->addJSON('field_collation', $properties['collation']);
+    $response->addJSON('field_operators', $properties['func']);
+    $response->addJSON('field_value', $properties['value']);
+    exit;
+}
+
+// Gets some core libraries
+require_once './libraries/tbl_common.inc.php';
+$url_query .= '&amp;goto=tbl_select.php&amp;back=tbl_select.php';
+
+// Gets tables informations
+require_once './libraries/tbl_info.inc.php';
+
+if (! isset($goto)) {
+    $goto = $GLOBALS['cfg']['DefaultTabTable'];
+}
+// Defines the url to return to in case of error in the next sql statement
+$err_url   = $goto . '?' . PMA_generate_common_url($db, $table);
+
+//Set default datalabel if not selected
+if ( !isset($_POST['zoom_submit']) || $_POST['dataLabel'] == '') {
+    $dataLabel = PMA_getDisplayField($db, $table);
+}
+
+// Displays the zoom search form
+$response->addHTML($table_search->getSelectionForm($goto, $dataLabel));
+
+/*
+ * Handle the input criteria and generate the query result
+ * Form for displaying query results
+ */
+if (isset($zoom_submit)
+    && $_POST['criteriaColumnNames'][0] != 'pma_null'
+    && $_POST['criteriaColumnNames'][1] != 'pma_null'
+    && $_POST['criteriaColumnNames'][0] != $_POST['criteriaColumnNames'][1]
+) {
+    //Query generation part
+    $sql_query = $table_search->buildSqlQuery();
+    $sql_query .= ' LIMIT ' . $maxPlotLimit;
+
+    //Query execution part
+    $result = PMA_DBI_query($sql_query . ";", null, PMA_DBI_QUERY_STORE);
+    $fields_meta = PMA_DBI_get_fields_meta($result);
+    while ($row = PMA_DBI_fetch_assoc($result)) {
+        //Need a row with indexes as 0,1,2 for the getUniqueCondition
+        // hence using a temporary array
+        $tmpRow = array();
+        foreach ($row as $val) {
+            $tmpRow[] = $val;
+        }
+        //Get unique conditon on each row (will be needed for row update)
+        $uniqueCondition = PMA_Util::getUniqueCondition(
+            $result, count($table_search->getColumnNames()), $fields_meta, $tmpRow,
+            true
+        );
+        //Append it to row array as where_clause
+        $row['where_clause'] = $uniqueCondition[0];
+
+        $tmpData = array(
+            $_POST['criteriaColumnNames'][0] => $row[$_POST['criteriaColumnNames'][0]],
+            $_POST['criteriaColumnNames'][1] => $row[$_POST['criteriaColumnNames'][1]],
+            'where_clause' => $uniqueCondition[0]
+        );
+        $tmpData[$dataLabel] = ($dataLabel) ? $row[$dataLabel] : '';
+        $data[] = $tmpData;
+    }
+    unset($tmpData);
+
+    //Displays form for point data and scatter plot
+    $response->addHTML($table_search->getZoomResultsForm($goto, $data));
+}
+?>