').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.
*
* @return {bool}
*/
saveEditedCell: function () {
/**
* @var $thisField 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 fieldName String containing the name of this field.
* @see Sql.getFieldName()
*/
var fieldName = Sql.getFieldName($(g.t), $thisField);
/**
* @var thisFieldParams Array temporary storage for the name/value of current field
*/
var thisFieldParams = {};
/**
* @var isNull String capturing whether 'checkbox_null_ to which the grid_edit should move
*/
saveOrPostEditedCell: function (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 () {
// 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 () {
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 = window.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).uiTooltip('option', {
content: g.updateHint()
});
})
.on('dblclick', function (e) {
e.preventDefault();
var res = Functions.copyToClipboard($(this).data('column'));
if (res) {
Functions.ajaxShowMessage(window.Messages.strCopyColumnSuccess, false, 'success');
} else {
Functions.ajaxShowMessage(window.Messages.strCopyColumnFailure, false, 'error');
}
});
$(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 () {
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 = window.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)').slice(0, 1);
Functions.tooltip(
$colVisibTh,
'th',
window.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 () {
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.d-print-none');
$(thFirst).append(g.cDrop);
$(thFirst).append(g.cList);
// some adjustment
g.reposDrop();
},
/**
* Move currently Editing Cell to Up
*
* @param e
*
*/
moveUp: function (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
*
* @param e
*
*/
moveDown: function (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
*
* @param e
*
*/
moveLeft: function (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
*
* @param e
*
*/
moveRight: function (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 () {
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 = window.Messages.strCellEditHint;
g.saveCellWarning = window.Messages.strSaveCellWarning;
g.alertNonUnique = window.Messages.strAlertNonUnique;
g.gotoLinkText = window.Messages.strGoToLink;
// initialize cell editing configuration
g.saveCellsAtOnce = $(g.o).find('.save_cells_at_once').val();
g.maxTruncatedLen = window.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');
window.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
const editRowAnchor = $(g.t).find('.edit_row_anchor');
if (editRowAnchor.attr('data-grid-edit-config') !== 'disabled') {
editRowAnchor.find('a').tooltip();
}
}
};
/** ****************
* 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 = window.Messages.strSortHint;
g.strMultiSortHint = window.Messages.strMultiSortHint;
g.markHint = window.Messages.strColMarkHint;
g.copyHint = window.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').uiTooltip('option', {
content: g.updateHint()
});
})
.on('mouseleave', function () {
g.showSortHint = false;
g.showMultiSortHint = false;
$(t).find('th.draggable').uiTooltip('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
}($));