').parent().html(); var tools = $resultQuery.find('.tools').wrap('
').parent().html(); // sqlOuter and tools will not be present if 'Show SQL queries' configuration is off
if (typeof sqlOuter !== 'undefined' && typeof tools !== 'undefined') {
$(g.o).find('.result_query').not($(g.o).find('.result_query').last()).remove();
var $existingQuery = $(g.o).find('.result_query'); // If two query box exists update query in second else add a second box
if ($existingQuery.find('div.sqlOuter').length > 1) {
$existingQuery.children().eq(3).remove();
$existingQuery.children().eq(3).remove();
$existingQuery.append(sqlOuter + tools);
} else {
$existingQuery.append(sqlOuter + tools);
}
Functions.highlightSql($existingQuery);
}
} // hide and/or update the successfully saved cells
g.hideEditCell(true, data); // remove the "Save edited cells" button
$(g.o).find('div.save_edited').hide(); // update saved fields
$(g.t).find('.to_be_saved').removeClass('to_be_saved').data('value', null).data('original_data', null);
g.isCellEdited = false;
} else {
Functions.ajaxShowMessage(data.error, false);
if (!g.saveCellsAtOnce) {
$(g.t).find('.to_be_saved').removeClass('to_be_saved');
}
}
}
}).done(function () {
if (options !== undefined && options.move) {
g.showEditCell(options.cell);
}
}); // end $.ajax()
},
/**
* Save edited cell, so it can be posted later.
*/
saveEditedCell: function saveEditedCell() {
/**
* @var $this_field Object referring to the td that is being edited
*/
var $thisField = $(g.currentEditCell);
var $testElement = ''; // to test the presence of a element
var needToPost = false;
/**
* @var field_name String containing the name of this field.
* @see Sql.getFieldName()
*/
var fieldName = Sql.getFieldName($(g.t), $thisField);
/**
* @var this_field_params Array temporary storage for the name/value of current field
*/
var thisFieldParams = {};
/**
* @var is_null String capturing whether 'checkbox_null_ to which the grid_edit should move
*/
saveOrPostEditedCell: function saveOrPostEditedCell(options) {
var saved = g.saveEditedCell(); // Check if $cfg['SaveCellsAtOnce'] is false
if (!g.saveCellsAtOnce) {
// Check if need_to_post is true
if (saved) {
// Check if this function called from 'move' functions
if (options !== undefined && options.move) {
g.postEditedCell(options);
} else {
g.postEditedCell();
} // need_to_post is false
} else {
// Check if this function called from 'move' functions
if (options !== undefined && options.move) {
g.hideEditCell(true);
g.showEditCell(options.cell); // NOT called from 'move' functions
} else {
g.hideEditCell(true);
}
} // $cfg['SaveCellsAtOnce'] is true
} else {
// If need_to_post
if (saved) {
// If this function called from 'move' functions
if (options !== undefined && options.move) {
g.hideEditCell(true, true, false, options);
g.showEditCell(options.cell); // NOT called from 'move' functions
} else {
g.hideEditCell(true, true);
}
} else {
// If this function called from 'move' functions
if (options !== undefined && options.move) {
g.hideEditCell(true, false, false, options);
g.showEditCell(options.cell); // NOT called from 'move' functions
} else {
g.hideEditCell(true);
}
}
}
},
/**
* Initialize column resize feature.
*/
initColResize: function initColResize() {
// create column resizer div
g.cRsz = document.createElement('div');
g.cRsz.className = 'cRsz'; // get data columns in the first row of the table
var $firstRowCols = $(g.t).find('tr').first().find('th.draggable'); // create column borders
$firstRowCols.each(function () {
var cb = document.createElement('div'); // column border
$(cb).addClass('colborder').on('mousedown', function (e) {
g.dragStartRsz(e, this);
});
$(g.cRsz).append(cb);
});
g.reposRsz(); // attach to global div
$(g.gDiv).prepend(g.cRsz);
},
/**
* Initialize column reordering feature.
*/
initColReorder: function initColReorder() {
g.cCpy = document.createElement('div'); // column copy, to store copy of dragged column header
g.cPointer = document.createElement('div'); // column pointer, used when reordering column
// adjust g.cCpy
g.cCpy.className = 'cCpy';
$(g.cCpy).hide(); // adjust g.cPointer
g.cPointer.className = 'cPointer';
$(g.cPointer).css('visibility', 'hidden'); // set visibility to hidden instead of calling hide() to force browsers to cache the image in cPointer class
// assign column reordering hint
g.reorderHint = Messages.strColOrderHint; // get data columns in the first row of the table
var $firstRowCols = $(g.t).find('tr').first().find('th.draggable'); // initialize column order
var $colOrder = $(g.o).find('.col_order'); // check if column order is passed from PHP
var i;
if ($colOrder.length > 0) {
g.colOrder = $colOrder.val().split(',');
for (i = 0; i < g.colOrder.length; i++) {
g.colOrder[i] = parseInt(g.colOrder[i], 10);
}
} else {
g.colOrder = [];
for (i = 0; i < $firstRowCols.length; i++) {
g.colOrder.push(i);
}
} // register events
$(g.t).find('th.draggable').on('mousedown', function (e) {
$(g.o).addClass('turnOffSelect');
if (g.visibleHeadersCount > 1) {
g.dragStartReorder(e, this);
}
}).on('mouseenter', function () {
if (g.visibleHeadersCount > 1) {
$(this).css('cursor', 'move');
} else {
$(this).css('cursor', 'inherit');
}
}).on('mouseleave', function () {
g.showReorderHint = false;
$(this).tooltip('option', {
content: g.updateHint()
});
}).on('dblclick', function (e) {
e.preventDefault();
$('').prop('title', Messages.strColNameCopyTitle).addClass('modal-copy').text(Messages.strColNameCopyText).append($('').prop('readonly', true).val($(this).data('column'))).dialog({
resizable: false,
modal: true
}).find('input').trigger('focus').trigger('select');
});
$(g.t).find('th.draggable a').on('dblclick', function (e) {
e.stopPropagation();
}); // restore column order when the restore button is clicked
$(g.o).find('div.restore_column').on('click', function () {
g.restoreColOrder();
}); // attach to global div
$(g.gDiv).append(g.cPointer);
$(g.gDiv).append(g.cCpy); // prevent default "dragstart" event when dragging a link
$(g.t).find('th a').on('dragstart', function () {
return false;
}); // refresh the restore column button state
g.refreshRestoreButton();
},
/**
* Initialize column visibility feature.
*/
initColVisib: function initColVisib() {
g.cDrop = document.createElement('div'); // column drop-down arrows
g.cList = document.createElement('div'); // column visibility list
// adjust g.cDrop
g.cDrop.className = 'cDrop'; // adjust g.cList
g.cList.className = 'cList';
$(g.cList).hide(); // assign column visibility related hints
g.showAllColText = Messages.strShowAllCol; // get data columns in the first row of the table
var $firstRowCols = $(g.t).find('tr').first().find('th.draggable');
var i; // initialize column visibility
var $colVisib = $(g.o).find('.col_visib'); // check if column visibility is passed from PHP
if ($colVisib.length > 0) {
g.colVisib = $colVisib.val().split(',');
for (i = 0; i < g.colVisib.length; i++) {
g.colVisib[i] = parseInt(g.colVisib[i], 10);
}
} else {
g.colVisib = [];
for (i = 0; i < $firstRowCols.length; i++) {
g.colVisib.push(1);
}
} // make sure we have more than one column
if ($firstRowCols.length > 1) {
var $colVisibTh = $(g.t).find('th:not(.draggable)');
Functions.tooltip($colVisibTh, 'th', Messages.strColVisibHint); // create column visibility drop-down arrow(s)
$colVisibTh.each(function () {
var cd = document.createElement('div'); // column drop-down arrow
$(cd).addClass('coldrop').on('click', function () {
if (g.cList.style.display === 'none') {
g.showColList(this);
} else {
g.hideColList();
}
});
$(g.cDrop).append(cd);
}); // add column visibility control
g.cList.innerHTML = '';
var $listDiv = $(g.cList).find('div');
var tempClick = function tempClick() {
if (g.toggleCol($(this).index())) {
g.afterToggleCol();
}
};
for (i = 0; i < $firstRowCols.length; i++) {
var currHeader = $firstRowCols[i];
var listElmt = document.createElement('div');
$(listElmt).text($(currHeader).text()).prepend('');
$listDiv.append(listElmt); // add event on click
$(listElmt).on('click', tempClick);
} // add "show all column" button
var showAll = document.createElement('div');
$(showAll).addClass('showAllColBtn').text(g.showAllColText);
$(g.cList).append(showAll);
$(showAll).on('click', function () {
g.showAllColumns();
}); // prepend "show all column" button at top if the list is too long
if ($firstRowCols.length > 10) {
var clone = showAll.cloneNode(true);
$(g.cList).prepend(clone);
$(clone).on('click', function () {
g.showAllColumns();
});
}
} // hide column visibility list if we move outside the list
$(g.t).find('td, th.draggable').on('mouseenter', function () {
g.hideColList();
}); // attach to first row first col of the grid
var thFirst = $(g.t).find('th.print_ignore');
$(thFirst).append(g.cDrop);
$(thFirst).append(g.cList); // some adjustment
g.reposDrop();
},
/**
* Move currently Editing Cell to Up
*/
moveUp: function moveUp(e) {
e.preventDefault();
var $thisField = $(g.currentEditCell);
var fieldName = Sql.getFieldName($(g.t), $thisField);
var whereClause = $thisField.parents('tr').first().find('.where_clause').val();
if (typeof whereClause === 'undefined') {
whereClause = '';
}
var found = false;
var $prevRow;
$thisField.parents('tr').first().parents('tbody').children().each(function () {
if ($(this).find('.where_clause').val() === whereClause) {
found = true;
}
if (!found) {
$prevRow = $(this);
}
});
var newCell;
if (found && $prevRow) {
$prevRow.children('td').each(function () {
if (Sql.getFieldName($(g.t), $(this)) === fieldName) {
newCell = this;
}
});
}
if (newCell) {
g.hideEditCell(false, false, false, {
move: true,
cell: newCell
});
}
},
/**
* Move currently Editing Cell to Down
*/
moveDown: function moveDown(e) {
e.preventDefault();
var $thisField = $(g.currentEditCell);
var fieldName = Sql.getFieldName($(g.t), $thisField);
var whereClause = $thisField.parents('tr').first().find('.where_clause').val();
if (typeof whereClause === 'undefined') {
whereClause = '';
}
var found = false;
var $nextRow;
var j = 0;
var nextRowFound = false;
$thisField.parents('tr').first().parents('tbody').children().each(function () {
if ($(this).find('.where_clause').val() === whereClause) {
found = true;
}
if (found) {
if (j >= 1 && !nextRowFound) {
$nextRow = $(this);
nextRowFound = true;
} else {
j++;
}
}
});
var newCell;
if (found && $nextRow) {
$nextRow.children('td').each(function () {
if (Sql.getFieldName($(g.t), $(this)) === fieldName) {
newCell = this;
}
});
}
if (newCell) {
g.hideEditCell(false, false, false, {
move: true,
cell: newCell
});
}
},
/**
* Move currently Editing Cell to Left
*/
moveLeft: function moveLeft(e) {
e.preventDefault();
var $thisField = $(g.currentEditCell);
var fieldName = Sql.getFieldName($(g.t), $thisField);
var whereClause = $thisField.parents('tr').first().find('.where_clause').val();
if (typeof whereClause === 'undefined') {
whereClause = '';
}
var found = false;
var $foundRow;
$thisField.parents('tr').first().parents('tbody').children().each(function () {
if ($(this).find('.where_clause').val() === whereClause) {
found = true;
$foundRow = $(this);
}
});
var leftCell;
var cellFound = false;
if (found) {
$foundRow.children('td.grid_edit').each(function () {
if (Sql.getFieldName($(g.t), $(this)) === fieldName) {
cellFound = true;
}
if (!cellFound) {
leftCell = this;
}
});
}
if (leftCell) {
g.hideEditCell(false, false, false, {
move: true,
cell: leftCell
});
}
},
/**
* Move currently Editing Cell to Right
*/
moveRight: function moveRight(e) {
e.preventDefault();
var $thisField = $(g.currentEditCell);
var fieldName = Sql.getFieldName($(g.t), $thisField);
var whereClause = $thisField.parents('tr').first().find('.where_clause').val();
if (typeof whereClause === 'undefined') {
whereClause = '';
}
var found = false;
var $foundRow;
var j = 0;
$thisField.parents('tr').first().parents('tbody').children().each(function () {
if ($(this).find('.where_clause').val() === whereClause) {
found = true;
$foundRow = $(this);
}
});
var rightCell;
var cellFound = false;
var nextCellFound = false;
if (found) {
$foundRow.children('td.grid_edit').each(function () {
if (Sql.getFieldName($(g.t), $(this)) === fieldName) {
cellFound = true;
}
if (cellFound) {
if (j >= 1 && !nextCellFound) {
rightCell = this;
nextCellFound = true;
} else {
j++;
}
}
});
}
if (rightCell) {
g.hideEditCell(false, false, false, {
move: true,
cell: rightCell
});
}
},
/**
* Initialize grid editing feature.
*/
initGridEdit: function initGridEdit() {
function startGridEditing(e, cell) {
if (g.isCellEditActive) {
g.saveOrPostEditedCell();
} else {
g.showEditCell(cell);
}
e.stopPropagation();
}
function handleCtrlNavigation(e) {
if (e.ctrlKey && e.which === 38 || e.altKey && e.which === 38) {
g.moveUp(e);
} else if (e.ctrlKey && e.which === 40 || e.altKey && e.which === 40) {
g.moveDown(e);
} else if (e.ctrlKey && e.which === 37 || e.altKey && e.which === 37) {
g.moveLeft(e);
} else if (e.ctrlKey && e.which === 39 || e.altKey && e.which === 39) {
g.moveRight(e);
}
} // create cell edit wrapper element
g.cEditStd = document.createElement('div');
g.cEdit = g.cEditStd;
g.cEditTextarea = document.createElement('div'); // adjust g.cEditStd
g.cEditStd.className = 'cEdit';
$(g.cEditStd).html('');
$(g.cEditStd).hide(); // adjust g.cEdit
g.cEditTextarea.className = 'cEdit';
$(g.cEditTextarea).html('');
$(g.cEditTextarea).hide(); // assign cell editing hint
g.cellEditHint = Messages.strCellEditHint;
g.saveCellWarning = Messages.strSaveCellWarning;
g.alertNonUnique = Messages.strAlertNonUnique;
g.gotoLinkText = Messages.strGoToLink; // initialize cell editing configuration
g.saveCellsAtOnce = $(g.o).find('.save_cells_at_once').val();
g.maxTruncatedLen = CommonParams.get('LimitChars'); // register events
$(g.t).find('td.data.click1').on('click', function (e) {
startGridEditing(e, this); // prevent default action when clicking on "link" in a table
if ($(e.target).is('.grid_edit a')) {
e.preventDefault();
}
});
$(g.t).find('td.data.click2').on('click', function (e) {
var $cell = $(this); // In the case of relational link, We want single click on the link
// to goto the link and double click to start grid-editing.
var $link = $(e.target);
if ($link.is('.grid_edit.relation a')) {
e.preventDefault(); // get the click count and increase
var clicks = $cell.data('clicks');
clicks = typeof clicks === 'undefined' ? 1 : clicks + 1;
if (clicks === 1) {
// if there are no previous clicks,
// start the single click timer
var timer = setTimeout(function () {
// temporarily remove ajax class so the page loader will not handle it,
// submit and then add it back
$link.removeClass('ajax');
AJAX.requestHandler.call($link[0]);
$link.addClass('ajax');
$cell.data('clicks', 0);
}, 700);
$cell.data('clicks', clicks);
$cell.data('timer', timer);
} else {
// When double clicking a link, switch to edit mode
// this is a double click, cancel the single click timer
// and make the click count 0
clearTimeout($cell.data('timer'));
$cell.data('clicks', 0); // start grid-editing
startGridEditing(e, this);
}
}
}).on('dblclick', function (e) {
if ($(e.target).is('.grid_edit a')) {
e.preventDefault();
} else {
startGridEditing(e, this);
}
});
$(g.cEditStd).on('keydown', 'input.edit_box, select', handleCtrlNavigation);
$(g.cEditStd).find('.edit_box').on('focus', function () {
g.showEditArea();
});
$(g.cEditStd).on('keydown', '.edit_box, select', function (e) {
if (e.which === 13) {
// post on pressing "Enter"
e.preventDefault();
g.saveOrPostEditedCell();
}
});
$(g.cEditStd).on('keydown', function (e) {
if (!g.isEditCellTextEditable) {
// prevent text editing
e.preventDefault();
}
});
$(g.cEditTextarea).on('keydown', 'textarea.edit_box, select', handleCtrlNavigation);
$(g.cEditTextarea).find('.edit_box').on('focus', function () {
g.showEditArea();
});
$(g.cEditTextarea).on('keydown', '.edit_box, select', function (e) {
if (e.which === 13 && !e.shiftKey) {
// post on pressing "Enter"
e.preventDefault();
g.saveOrPostEditedCell();
}
});
$(g.cEditTextarea).on('keydown', function (e) {
if (!g.isEditCellTextEditable) {
// prevent text editing
e.preventDefault();
}
});
$('html').on('click', function (e) {
// hide edit cell if the click is not fromDat edit area
if ($(e.target).parents().index($(g.cEdit)) === -1 && !$(e.target).parents('.ui-datepicker-header').length && !$('.browse_foreign_modal.ui-dialog:visible').length && !$(e.target).closest('.dismissable').length) {
g.hideEditCell();
}
}).on('keydown', function (e) {
if (e.which === 27 && g.isCellEditActive) {
// cancel on pressing "Esc"
g.hideEditCell(true);
}
});
$(g.o).find('div.save_edited').on('click', function () {
g.hideEditCell();
g.postEditedCell();
});
$(window).on('beforeunload', function () {
if (g.isCellEdited) {
return g.saveCellWarning;
}
}); // attach to global div
$(g.gDiv).append(g.cEditStd);
$(g.gDiv).append(g.cEditTextarea); // add hint for grid editing feature when hovering "Edit" link in each table row
if (Messages.strGridEditFeatureHint !== undefined) {
Functions.tooltip($(g.t).find('.edit_row_anchor a'), 'a', Messages.strGridEditFeatureHint);
}
}
};
/** ****************
* Initialize grid
******************/
// wrap all truncated data cells with span indicating the original length
// todo update the original length after a grid edit
$(t).find('td.data.truncated:not(:has(span))').wrapInner(function () {
return '';
}); // wrap remaining cells, except actions cell, with span
$(t).find('th, td:not(:has(span))').wrapInner(''); // create grid elements
g.gDiv = document.createElement('div'); // create global div
// initialize the table variable
g.t = t; // enclosing .sqlqueryresults div
g.o = $(t).parents('.sqlqueryresults'); // get data columns in the first row of the table
var $firstRowCols = $(t).find('tr').first().find('th.draggable'); // initialize visible headers count
g.visibleHeadersCount = $firstRowCols.filter(':visible').length; // assign first column (actions) span
if (!$(t).find('tr').first().find('th').first().hasClass('draggable')) {
// action header exist
g.actionSpan = $(t).find('tr').first().find('th').first().prop('colspan');
} else {
g.actionSpan = 0;
} // assign table create time
// table_create_time will only available if we are in "Browse" tab
g.tableCreateTime = $(g.o).find('.table_create_time').val(); // assign the hints
g.sortHint = Messages.strSortHint;
g.strMultiSortHint = Messages.strMultiSortHint;
g.markHint = Messages.strColMarkHint;
g.copyHint = Messages.strColNameCopyHint; // assign common hidden inputs
var $commonHiddenInputs = $(g.o).find('div.common_hidden_inputs');
g.server = $commonHiddenInputs.find('input[name=server]').val();
g.db = $commonHiddenInputs.find('input[name=db]').val();
g.table = $commonHiddenInputs.find('input[name=table]').val(); // add table class
$(t).addClass('pma_table'); // add relative position to global div so that resize handlers are correctly positioned
$(g.gDiv).css('position', 'relative'); // link the global div
$(t).before(g.gDiv);
$(g.gDiv).append(t); // FEATURES
if (isResizeEnabled) {
g.initColResize();
} // disable reordering for result from EXPLAIN or SHOW syntax, which do not have a table navigation panel
if (isReorderEnabled && $(g.o).find('table.navigation').length > 0) {
g.initColReorder();
}
if (isVisibEnabled) {
g.initColVisib();
} // make sure we have the ajax class
if (isGridEditEnabled && $(t).is('.ajax')) {
g.initGridEdit();
} // create tooltip for each with draggable class
Functions.tooltip($(t).find('th.draggable'), 'th', g.updateHint()); // register events for hint tooltip (anchors inside draggable th)
$(t).find('th.draggable a').on('mouseenter', function () {
g.showSortHint = true;
g.showMultiSortHint = true;
$(t).find('th.draggable').tooltip('option', {
content: g.updateHint()
});
}).on('mouseleave', function () {
g.showSortHint = false;
g.showMultiSortHint = false;
$(t).find('th.draggable').tooltip('option', {
content: g.updateHint()
});
}); // register events for dragging-related feature
if (isResizeEnabled || isReorderEnabled) {
$(document).on('mousemove', function (e) {
g.dragMove(e);
});
$(document).on('mouseup', function (e) {
$(g.o).removeClass('turnOffSelect');
g.dragEnd(e);
});
} // some adjustment
$(t).removeClass('data');
$(g.gDiv).addClass('data');
};
/**
* jQuery plugin to cancel selection in HTML code.
*/
(function ($) {
$.fn.noSelect = function (p) {
// no select plugin by Paulo P.Marinas
var prevent = p === null ? true : p;
/* eslint-disable compat/compat */
var isMsie = navigator.userAgent.indexOf('MSIE') > -1 || !!window.navigator.userAgent.match(/Trident.*rv:11\./);
var isFirefox = navigator.userAgent.indexOf('Firefox') > -1;
var isSafari = navigator.userAgent.indexOf('Safari') > -1;
var isOpera = navigator.userAgent.indexOf('Presto') > -1;
/* eslint-enable compat/compat */
if (prevent) {
return this.each(function () {
if (isMsie || isSafari) {
$(this).on('selectstart', false);
} else if (isFirefox) {
$(this).css('MozUserSelect', 'none');
$('body').trigger('focus');
} else if (isOpera) {
$(this).on('mousedown', false);
} else {
$(this).attr('unselectable', 'on');
}
});
} else {
return this.each(function () {
if (isMsie || isSafari) {
$(this).off('selectstart');
} else if (isFirefox) {
$(this).css('MozUserSelect', 'inherit');
} else if (isOpera) {
$(this).off('mousedown');
} else {
$(this).removeAttr('unselectable');
}
});
}
}; // end noSelect
})(jQuery);