From 6fcbbb72d78d16196cd834fdfd407394d0e41bf7 Mon Sep 17 00:00:00 2001
From: Atul Pratap Singh <atulpratapsingh05@gmail.com>
Date: Fri, 20 Jul 2012 16:28:58 +0000
Subject: Use PMA_DBQbe in db_qbe.php

---
 db_qbe.php | 143 +++----------------------------------------------------------
 1 file changed, 7 insertions(+), 136 deletions(-)

(limited to 'db_qbe.php')

diff --git a/db_qbe.php b/db_qbe.php
index b84f3676b7..62ff739094 100644
--- a/db_qbe.php
+++ b/db_qbe.php
@@ -10,7 +10,10 @@
  * requirements
  */
 require_once 'libraries/common.inc.php';
-require_once 'libraries/db_qbe.lib.php';
+require_once 'libraries/DbQbe.class.php';
+$response = PMA_Response::getInstance();
+$header   = $response->getHeader();
+$scripts  = $header->getScripts();
 
 /**
  * Sets globals from $_POST patterns, for Or* variables 
@@ -27,138 +30,9 @@ foreach (array_keys($_POST) as $post_key) {
         }
     }
 }
-/**
- * Initialize some more global variables
- */
-$GLOBALS['curField'] = array();
-$GLOBALS['curSort'] = array();
-$GLOBALS['curShow'] = array();
-$GLOBALS['curCriteria'] = array();
-$GLOBALS['curAndOrRow'] = array();
-$GLOBALS['curAndOrCol'] = array();
-
-/**
- * Gets the relation settings
- */
-$cfgRelation = PMA_getRelationsParam();
 
-$common_functions = PMA_CommonFunctions::getInstance();
-
-/**
- * A query has been submitted -> (maybe) execute it
- */
-$message_to_display = false;
-if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) {
-    if (! preg_match('@^SELECT@i', $sql_query)) {
-        $message_to_display = true;
-    } else {
-        $goto      = 'db_sql.php';
-        include 'sql.php';
-        exit;
-    }
-}
-
-$sub_part  = '_qbe';
-require 'libraries/db_common.inc.php';
-$url_query .= '&amp;goto=db_qbe.php';
-$url_params['goto'] = 'db_qbe.php';
-require 'libraries/db_info.inc.php';
-
-if ($message_to_display) {
-    PMA_Message::error(__('You have to choose at least one column to display'))->display();
-}
-unset($message_to_display);
-
-/**
- * Initialize some variables
- */
-$criteriaColumnCount = PMA_ifSetOr($_REQUEST['criteriaColumnCount'], 3, 'numeric');
-$criteriaColumnAdd = PMA_ifSetOr($_REQUEST['criteriaColumnAdd'], 0, 'numeric');
-$criteriaRowAdd = PMA_ifSetOr($_REQUEST['criteriaRowAdd'], 0, 'numeric');
-
-$rows    = PMA_ifSetOr($_REQUEST['rows'],    0, 'numeric');
-$criteriaColumnInsert = PMA_ifSetOr($_REQUEST['criteriaColumnInsert'], null, 'array');
-$criteriaColumnDelete = PMA_ifSetOr($_REQUEST['criteriaColumnDelete'], null, 'array');
-
-$prev_criteria = isset($_REQUEST['prev_criteria'])
-    ? $_REQUEST['prev_criteria']
-    : array();
-$criteria = isset($_REQUEST['criteria'])
-    ? $_REQUEST['criteria']
-    : array_fill(0, $criteriaColumnCount, '');
-
-$criteriaRowInsert = isset($_REQUEST['criteriaRowInsert'])
-    ? $_REQUEST['criteriaRowInsert']
-    : array_fill(0, $criteriaColumnCount, '');
-$criteriaRowDelete = isset($_REQUEST['criteriaRowDelete'])
-    ? $_REQUEST['criteriaRowDelete']
-    : array_fill(0, $criteriaColumnCount, '');
-$criteriaAndOrRow = isset($_REQUEST['criteriaAndOrRow'])
-    ? $_REQUEST['criteriaAndOrRow']
-    : array_fill(0, $criteriaColumnCount, '');
-$criteriaAndOrColumn = isset($_REQUEST['criteriaAndOrColumn'])
-    ? $_REQUEST['criteriaAndOrColumn']
-    : array_fill(0, $criteriaColumnCount, '');
-
-// minimum width
-$form_column_width = 12;
-$criteria_column_count = max($criteriaColumnCount + $criteriaColumnAdd, 0);
-$criteria_row_count = max($rows + $criteriaRowAdd, 0);
-
-
-// The tables list sent by a previously submitted form
-if (PMA_isValid($_REQUEST['TableList'], 'array')) {
-    foreach ($_REQUEST['TableList'] as $each_table) {
-        $criteriaTables[$each_table] = ' selected="selected"';
-    }
-} // end if
-
-
-// this was a work in progress, deactivated for now
-//$columns = PMA_DBI_get_columns_full($GLOBALS['db']);
-//$tables  = PMA_DBI_get_columns_full($GLOBALS['db']);
-
-
-/**
- * Prepares the form
- */
-$all_tables = PMA_DBI_query(
-    'SHOW TABLES FROM ' . $common_functions->backquote($db) . ';',
-    null, PMA_DBI_QUERY_STORE
-);
-$all_tables_count = PMA_DBI_num_rows($all_tables);
-if (0 == $all_tables_count) {
-    PMA_Message::error(__('No tables found in database.'))->display();
-    exit;
-}
-
-// The tables list gets from MySQL
-while (list($table) = PMA_DBI_fetch_row($all_tables)) {
-    $columns = PMA_DBI_get_columns($db, $table);
-
-    if (empty($criteriaTables[$table]) && ! empty($_REQUEST['TableList'])) {
-        $criteriaTables[$table] = '';
-    } else {
-        $criteriaTables[$table] = ' selected="selected"';
-    } //  end if
-
-    // The fields list per selected tables
-    if ($criteriaTables[$table] == ' selected="selected"') {
-        $each_table = $common_functions->backquote($table);
-        $columnNames[]  = $each_table . '.*';
-        foreach ($columns as $each_column) {
-            $each_column = $each_table . '.' . $common_functions->backquote($each_column['Field']);
-            $columnNames[] = $each_column;
-
-            // increase the width if necessary
-            $form_column_width = max(strlen($each_column), $form_column_width);
-        } // end foreach
-    } // end if
-} // end while
-PMA_DBI_free_result($all_tables);
-
-// largest width found
-$realwidth = $form_column_width . 'ex';
+// create new qbe search instance
+$db_qbe = new PMA_DBQbe($GLOBALS['db']);
 
 /**
  * Displays the Query by example form
@@ -179,8 +53,5 @@ if ($cfgRelation['designerwork']) {
         )
     )->display();
 }
-echo PMA_dbQbeGetSelectionForm($db, $criteriaTables, $columnNames, $criteria_column_count, $criteria_row_count,
-    $criteriaColumnInsert, $criteriaColumnDelete, $realwidth, $criteria, $prev_criteria,
-    $criteriaAndOrRow, $criteriaAndOrColumn, $cfgRelation
-);
+$response->addHTML($db_qbe->getSelectionForm($cfgRelation));
 ?>
-- 
cgit v1.2.3