diff options
author | Maurício Meneghini Fauth <mauricio@fauth.dev> | 2022-06-19 22:26:19 +0300 |
---|---|---|
committer | Maurício Meneghini Fauth <mauricio@fauth.dev> | 2022-06-19 22:48:11 +0300 |
commit | 196dad277706f483e7e32cc0133a094efc6cc7db (patch) | |
tree | 0b9d62496ee02fca8b89c97eb29e85dd750f5312 | |
parent | 8cee1399cc111a47433fa146c68c349068156154 (diff) |
Extract some sql.js functions from functions.js file
Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>
-rw-r--r-- | js/src/functions.js | 185 | ||||
-rw-r--r-- | js/src/sql.js | 198 |
2 files changed, 192 insertions, 191 deletions
diff --git a/js/src/functions.js b/js/src/functions.js index 347f996969..58753cc567 100644 --- a/js/src/functions.js +++ b/js/src/functions.js @@ -15,16 +15,6 @@ var Functions = {}; /** - * @type {boolean} lock for the sqlbox textarea in the querybox - */ -let sqlBoxLocked = false; - -/** - * @type {boolean[]} holds elements which content should only selected once - */ -const onlyOnceElements = []; - -/** * @var {number} ajaxMessageCount Number of AJAX messages shown since page load */ var ajaxMessageCount = 0; @@ -629,25 +619,6 @@ Functions.displayPasswordGenerateButton = function () { }; /** - * selects the content of a given object, f.e. a textarea - * - * @param {HTMLTextAreaElement} element Element of which the content will be selected - */ -Functions.selectContent = function (element) { - if (onlyOnceElements[element.name]) { - return; - } - - onlyOnceElements[element.name] = true; - - if (sqlBoxLocked) { - return; - } - - element.select(); -}; - -/** * Displays a confirmation box before submitting a "DROP/DELETE/ALTER" query. * This function is called while clicking links * @@ -1114,162 +1085,6 @@ Functions.setSelectOptions = function (theForm, theSelect, doCheck) { }; /** - * Sets current value for query box. - * @param {string} query - * @return {void} - */ -Functions.setQuery = function (query) { - if (codeMirrorEditor) { - codeMirrorEditor.setValue(query); - codeMirrorEditor.focus(); - } else if (document.sqlform) { - document.sqlform.sql_query.value = query; - document.sqlform.sql_query.focus(); - } -}; - -/** - * Create quick sql statements. - * - * @param {'clear'|'format'|'saved'|'selectall'|'select'|'insert'|'update'|'delete'} queryType - * - */ -Functions.insertQuery = function (queryType) { - var table; - if (queryType === 'clear') { - Functions.setQuery(''); - return; - } else if (queryType === 'format') { - if (codeMirrorEditor) { - $('#querymessage').html(Messages.strFormatting + - ' <img class="ajaxIcon" src="' + - themeImagePath + 'ajax_clock_small.gif" alt="">'); - var params = { - 'ajax_request': true, - 'sql': codeMirrorEditor.getValue(), - 'server': CommonParams.get('server') - }; - $.ajax({ - type: 'POST', - url: 'index.php?route=/database/sql/format', - data: params, - success: function (data) { - if (data.success) { - codeMirrorEditor.setValue(data.sql); - } - $('#querymessage').html(''); - }, - error: function () { - $('#querymessage').html(''); - } - }); - } - return; - } else if (queryType === 'saved') { - var db = $('input[name="db"]').val(); - table = $('input[name="table"]').val(); - var key = db; - if (table !== undefined) { - key += '.' + table; - } - key = 'autoSavedSql_' + key; - if (isStorageSupported('localStorage') && - typeof window.localStorage.getItem(key) === 'string') { - Functions.setQuery(window.localStorage.getItem(key)); - } else if (Cookies.get(key, { path: CommonParams.get('rootPath') })) { - Functions.setQuery(Cookies.get(key, { path: CommonParams.get('rootPath') })); - } else { - Functions.ajaxShowMessage(Messages.strNoAutoSavedQuery); - } - return; - } - - var query = ''; - var myListBox = document.sqlform.dummy; - table = document.sqlform.table.value; - - if (myListBox.options.length > 0) { - sqlBoxLocked = true; - var columnsList = ''; - var valDis = ''; - var editDis = ''; - var NbSelect = 0; - for (var i = 0; i < myListBox.options.length; i++) { - NbSelect++; - if (NbSelect > 1) { - columnsList += ', '; - valDis += ','; - editDis += ','; - } - columnsList += myListBox.options[i].value; - valDis += '\'[value-' + NbSelect + ']\''; - editDis += myListBox.options[i].value + '=\'[value-' + NbSelect + ']\''; - } - if (queryType === 'selectall') { - query = 'SELECT * FROM `' + table + '` WHERE 1'; - } else if (queryType === 'select') { - query = 'SELECT ' + columnsList + ' FROM `' + table + '` WHERE 1'; - } else if (queryType === 'insert') { - query = 'INSERT INTO `' + table + '`(' + columnsList + ') VALUES (' + valDis + ')'; - } else if (queryType === 'update') { - query = 'UPDATE `' + table + '` SET ' + editDis + ' WHERE 1'; - } else if (queryType === 'delete') { - query = 'DELETE FROM `' + table + '` WHERE 0'; - } - Functions.setQuery(query); - sqlBoxLocked = false; - } -}; - -/** - * Inserts multiple fields. - * - */ -Functions.insertValueQuery = function () { - var myQuery = document.sqlform.sql_query; - var myListBox = document.sqlform.dummy; - - if (myListBox.options.length > 0) { - sqlBoxLocked = true; - var columnsList = ''; - var NbSelect = 0; - for (var i = 0; i < myListBox.options.length; i++) { - if (myListBox.options[i].selected) { - NbSelect++; - if (NbSelect > 1) { - columnsList += ', '; - } - columnsList += myListBox.options[i].value; - } - } - - /* CodeMirror support */ - if (codeMirrorEditor) { - codeMirrorEditor.replaceSelection(columnsList); - codeMirrorEditor.focus(); - // IE support - } else if (document.selection) { - myQuery.focus(); - var sel = document.selection.createRange(); - sel.text = columnsList; - // MOZILLA/NETSCAPE support - } else if (document.sqlform.sql_query.selectionStart || document.sqlform.sql_query.selectionStart === '0') { - var startPos = document.sqlform.sql_query.selectionStart; - var endPos = document.sqlform.sql_query.selectionEnd; - var SqlString = document.sqlform.sql_query.value; - - myQuery.value = SqlString.substring(0, startPos) + columnsList + SqlString.substring(endPos, SqlString.length); - myQuery.focus(); - } else { - myQuery.value += columnsList; - } - - // eslint-disable-next-line no-unused-vars - sqlBoxLocked = false; - } -}; - -/** * Updates the input fields for the parameters based on the query */ Functions.updateQueryParameters = function () { diff --git a/js/src/sql.js b/js/src/sql.js index 4185321c29..bcd70ee9e9 100644 --- a/js/src/sql.js +++ b/js/src/sql.js @@ -10,6 +10,7 @@ /* global isStorageSupported */ // js/config.js /* global codeMirrorEditor */ // js/functions.js /* global makeGrid */ // js/makegrid.js +/* global themeImagePath */ // templates/javascript/variables.twig var Sql = {}; @@ -182,6 +183,16 @@ Sql.getFieldName = function ($tableResults, $thisField) { }; /** + * @type {boolean} lock for the sqlbox textarea in the querybox + */ +let sqlBoxLocked = false; + +/** + * @type {boolean[]} holds elements which content should only selected once + */ +const onlyOnceElements = []; + +/** * Handles 'Simulate query' button on SQL query box. * * @return {void} @@ -213,6 +224,181 @@ const handleSimulateQueryButton = function () { }; /** + * selects the content of a given object, f.e. a textarea + * + * @param {HTMLTextAreaElement} element Element of which the content will be selected + */ +const selectContent = function (element) { + if (onlyOnceElements[element.name]) { + return; + } + + onlyOnceElements[element.name] = true; + + if (sqlBoxLocked) { + return; + } + + element.select(); +}; + +/** + * Sets current value for query box. + * @param {string} query + * @return {void} + */ +const setQuery = function (query) { + if (codeMirrorEditor) { + codeMirrorEditor.setValue(query); + codeMirrorEditor.focus(); + } else if (document.sqlform) { + document.sqlform.sql_query.value = query; + document.sqlform.sql_query.focus(); + } +}; + +/** + * Create quick sql statements. + * + * @param {'clear'|'format'|'saved'|'selectall'|'select'|'insert'|'update'|'delete'} queryType + * + */ +const insertQuery = function (queryType) { + var table; + if (queryType === 'clear') { + setQuery(''); + return; + } else if (queryType === 'format') { + if (codeMirrorEditor) { + $('#querymessage').html(Messages.strFormatting + + ' <img class="ajaxIcon" src="' + + themeImagePath + 'ajax_clock_small.gif" alt="">'); + var params = { + 'ajax_request': true, + 'sql': codeMirrorEditor.getValue(), + 'server': CommonParams.get('server') + }; + $.ajax({ + type: 'POST', + url: 'index.php?route=/database/sql/format', + data: params, + success: function (data) { + if (data.success) { + codeMirrorEditor.setValue(data.sql); + } + $('#querymessage').html(''); + }, + error: function () { + $('#querymessage').html(''); + } + }); + } + return; + } else if (queryType === 'saved') { + var db = $('input[name="db"]').val(); + table = $('input[name="table"]').val(); + var key = db; + if (table !== undefined) { + key += '.' + table; + } + key = 'autoSavedSql_' + key; + if (isStorageSupported('localStorage') && + typeof window.localStorage.getItem(key) === 'string') { + setQuery(window.localStorage.getItem(key)); + } else if (Cookies.get(key, { path: CommonParams.get('rootPath') })) { + setQuery(Cookies.get(key, { path: CommonParams.get('rootPath') })); + } else { + Functions.ajaxShowMessage(Messages.strNoAutoSavedQuery); + } + return; + } + + var query = ''; + var myListBox = document.sqlform.dummy; + table = document.sqlform.table.value; + + if (myListBox.options.length > 0) { + sqlBoxLocked = true; + var columnsList = ''; + var valDis = ''; + var editDis = ''; + var NbSelect = 0; + for (var i = 0; i < myListBox.options.length; i++) { + NbSelect++; + if (NbSelect > 1) { + columnsList += ', '; + valDis += ','; + editDis += ','; + } + columnsList += myListBox.options[i].value; + valDis += '\'[value-' + NbSelect + ']\''; + editDis += myListBox.options[i].value + '=\'[value-' + NbSelect + ']\''; + } + if (queryType === 'selectall') { + query = 'SELECT * FROM `' + table + '` WHERE 1'; + } else if (queryType === 'select') { + query = 'SELECT ' + columnsList + ' FROM `' + table + '` WHERE 1'; + } else if (queryType === 'insert') { + query = 'INSERT INTO `' + table + '`(' + columnsList + ') VALUES (' + valDis + ')'; + } else if (queryType === 'update') { + query = 'UPDATE `' + table + '` SET ' + editDis + ' WHERE 1'; + } else if (queryType === 'delete') { + query = 'DELETE FROM `' + table + '` WHERE 0'; + } + setQuery(query); + sqlBoxLocked = false; + } +}; + +/** + * Inserts multiple fields. + * + */ +const insertValueQuery = function () { + var myQuery = document.sqlform.sql_query; + var myListBox = document.sqlform.dummy; + + if (myListBox.options.length > 0) { + sqlBoxLocked = true; + var columnsList = ''; + var NbSelect = 0; + for (var i = 0; i < myListBox.options.length; i++) { + if (myListBox.options[i].selected) { + NbSelect++; + if (NbSelect > 1) { + columnsList += ', '; + } + columnsList += myListBox.options[i].value; + } + } + + /* CodeMirror support */ + if (codeMirrorEditor) { + codeMirrorEditor.replaceSelection(columnsList); + codeMirrorEditor.focus(); + // IE support + } else if (document.selection) { + myQuery.focus(); + var sel = document.selection.createRange(); + sel.text = columnsList; + // MOZILLA/NETSCAPE support + } else if (document.sqlform.sql_query.selectionStart || document.sqlform.sql_query.selectionStart === '0') { + var startPos = document.sqlform.sql_query.selectionStart; + var endPos = document.sqlform.sql_query.selectionEnd; + var SqlString = document.sqlform.sql_query.value; + + myQuery.value = SqlString.substring(0, startPos) + columnsList + SqlString.substring(endPos, SqlString.length); + myQuery.focus(); + } else { + myQuery.value += columnsList; + } + + // eslint-disable-next-line no-unused-vars + sqlBoxLocked = false; + } +}; + +/** * Unbind all event handlers before tearing down a page */ AJAX.registerTeardown('sql.js', function () { @@ -596,7 +782,7 @@ AJAX.registerOnload('sql.js', function () { if ('1' === data.action_bookmark) { $('#sqlquery').text(data.sql_query); // send to codemirror if possible - Functions.setQuery(data.sql_query); + setQuery(data.sql_query); } // delete if ('2' === data.action_bookmark) { @@ -872,27 +1058,27 @@ AJAX.registerOnload('sql.js', function () { }); $('#insertBtn').on('click', function () { - Functions.insertValueQuery(); + insertValueQuery(); }); $('#view_as').on('click', function () { - Functions.selectContent(this); + selectContent(this); }); $('#sqlquery').on('click', function () { if ($(this).data('textarea-auto-select') === true) { - Functions.selectContent(this); + selectContent(this); } }); $(document).on('click', 'input.sqlbutton', function (evt) { - Functions.insertQuery(evt.target.id); + insertQuery(evt.target.id); handleSimulateQueryButton(); return false; }); $('#fieldsSelect').on('dblclick', () => { - Functions.insertValueQuery(); + insertValueQuery(); }); }); |