diff options
author | Marc Delisle <marc@infomarc.info> | 2014-02-26 21:47:22 +0400 |
---|---|---|
committer | Marc Delisle <marc@infomarc.info> | 2014-02-26 21:47:22 +0400 |
commit | 9a18b579c3d2942eef09f5417699181bf25f9a0d (patch) | |
tree | d0ef18af66204fa2dc50124043fe04b94c5a2f61 /db_qbe.php | |
parent | d30b1d314d12192041edbcd9b0ab2b71a0b769fd (diff) | |
parent | 5cf8424a7f36f9e3f7603146f2e258ac6180e1dc (diff) |
Fix merge conflict
Signed-off-by: Marc Delisle <marc@infomarc.info>
Diffstat (limited to 'db_qbe.php')
-rw-r--r-- | db_qbe.php | 56 |
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)); ?> |