/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* @fileoverview JavaScript functions used on Database Search page
* @name Database Search
*
* @requires jQuery
* @requires js/functions.js
*/
/**
* AJAX script for the Database Search page.
*
* Actions ajaxified here:
* Retrieve result of SQL query
*/
/** Loads the database search results */
function loadResult(result_path , table_name , link , ajaxEnable)
{
$(document).ready(function() {
if(ajaxEnable)
{
/** Hides the results shown by the delete criteria */
PMA_ajaxShowMessage(PMA_messages['strBrowsing']);
$('#sqlqueryform').hide();
$('#togglequerybox').hide();
/** Load the browse results to the page */
$("#table-info").show();
$('#table-link').attr({"href" : 'sql.php?'+link }).text(table_name);
$('#browse-results').load(result_path + " '"+'#sqlqueryresults' + "'", null, function() {
// because under db_search, window.parent.table is not defined yet,
// we assign it manually from #table-link
window.parent.table = $('#table-link').text().trim();
$('#table_results').makegrid();
}).show();
}
else
{
event.preventDefault();
}
});
}
/** Delete the selected search results */
function deleteResult(result_path , msg , ajaxEnable)
{
$(document).ready(function() {
/** Hides the results shown by the browse criteria */
$("#table-info").hide();
$('#browse-results').hide();
$('#sqlqueryform').hide();
$('#togglequerybox').hide();
/** Conformation message for deletion */
if(confirm(msg))
{
if(ajaxEnable)
{
/** Load the deleted option to the page*/
$('#browse-results').load(result_path + " '"+'#result_query' + "'");
$('#sqlqueryform').load(result_path + " '"+'#sqlqueryform' + "'");
$('#togglequerybox').html(PMA_messages['strShowQueryBox']);
/** Refresh the search results after the deletion */
document.getElementById('buttonGo'). click();
PMA_ajaxShowMessage(PMA_messages['strDeleting']);
/** Show the results of the deletion option */
$('#browse-results').show();
$('#sqlqueryform').hide();
$('#togglequerybox').show();
}
else
{
event.preventDefault();
}
}
});
}
$(document).ready(function() {
/**
* Set a parameter for all Ajax queries made on this page. Don't let the
* web server serve cached pagesshow
*/
$.ajaxSetup({
cache: 'false'
});
/** Hide the table link in the initial search result */
$("#table-info").prepend('').hide();
/** Hide the browse and deleted results in the new search criteria */
$('#buttonGo').click(function(){
$("#table-info").hide();
$('#browse-results').hide();
$('#sqlqueryform').hide();
$('#togglequerybox').hide();
});
/**
*Prepare a div containing a link for toggle the search results
*/
$('