Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/phpmyadmin/phpmyadmin.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarc Delisle <marc@infomarc.info>2014-02-26 21:47:22 +0400
committerMarc Delisle <marc@infomarc.info>2014-02-26 21:47:22 +0400
commit9a18b579c3d2942eef09f5417699181bf25f9a0d (patch)
treed0ef18af66204fa2dc50124043fe04b94c5a2f61 /db_qbe.php
parentd30b1d314d12192041edbcd9b0ab2b71a0b769fd (diff)
parent5cf8424a7f36f9e3f7603146f2e258ac6180e1dc (diff)
Fix merge conflict
Signed-off-by: Marc Delisle <marc@infomarc.info>
Diffstat (limited to 'db_qbe.php')
-rw-r--r--db_qbe.php56
1 files changed, 55 insertions, 1 deletions
diff --git a/db_qbe.php b/db_qbe.php
index e1ed199d1f..4df2fa7870 100644
--- a/db_qbe.php
+++ b/db_qbe.php
@@ -19,6 +19,50 @@ $response = PMA_Response::getInstance();
// Gets the relation settings
$cfgRelation = PMA_getRelationsParam();
+$savedSearchList = array();
+$currentSearchId = null;
+$displayUpdateSearchHint = false;
+if ($cfgRelation['savedsearcheswork']) {
+ include 'libraries/SavedSearches.php';
+ $header = $response->getHeader();
+ $scripts = $header->getScripts();
+ $scripts->addFile('db_qbe.js');
+
+ //Get saved search list.
+ $savedSearch = new PMA_SavedSearches($GLOBALS);
+ $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
+ ->setDbname($_REQUEST['db']);
+
+ //Criterias field is filled only when clicking on "Save search".
+ if (!empty($_REQUEST['action'])) {
+ $savedSearch->setId($_REQUEST['searchId'])
+ ->setSearchName($_REQUEST['searchName']);
+ if ('save' === $_REQUEST['action']) {
+ $saveResult = $savedSearch->setCriterias($_REQUEST)
+ ->save();
+ $displayUpdateSearchHint = true;
+ /*if (!$saveResult) {
+ $response->addHTML('raté');
+ exit();
+ }*/
+ } elseif ('delete' === $_REQUEST['action']) {
+ $deleteResult = $savedSearch->delete();
+ //After deletion, reset search.
+ $savedSearch = new PMA_SavedSearches($GLOBALS);
+ $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
+ ->setDbname($_REQUEST['db']);
+ $_REQUEST = array();
+ } elseif ('load' === $_REQUEST['action']) {
+ $loadResult = $savedSearch->load();
+ $displayUpdateSearchHint = true;
+ }
+ //Else, it's an "update query"
+ }
+
+ $savedSearchList = $savedSearch->getList();
+ $currentSearchId = $savedSearch->getId();
+}
+
/**
* A query has been submitted -> (maybe) execute it
*/
@@ -52,7 +96,7 @@ if ($message_to_display) {
unset($message_to_display);
// create new qbe search instance
-$db_qbe = new PMA_DBQbe($GLOBALS['db']);
+$db_qbe = new PMA_DBQbe($GLOBALS['db'], $savedSearchList, $savedSearch);
/**
* Displays the Query by example form
@@ -74,5 +118,15 @@ if ($cfgRelation['designerwork']) {
)
);
}
+if ($displayUpdateSearchHint) {
+ $response->addHTML(
+ PMA_Message::notice(
+ __(
+ 'After saving or loading a search, you can rename it and save the '
+ . 'new criterias.'
+ )
+ )
+ );
+}
$response->addHTML($db_qbe->getSelectionForm($cfgRelation));
?>