`; }
function generateWorkbooksModalHtml() { return workbooksEnabled ? `
` : ``; }
function generateJQueryEventHandlersForModals() { return `$('#localLoadModal').on('shown.bs.modal', function (e) { fetchAndDisplayLocalLibraryFiles(); }); $('#remoteLoadModal').on('shown.bs.modal', function (e) { fetchAndDisplayRemoteLibraryIndex(); }); $('#recentQueriesModal').on('shown.bs.modal', function (e) { displayRecentQueriesFromLocalStorage(); }); $('#saveModal').on('shown.bs.modal', function (e) { $('#saveQueryMessage, #saveQueryForm').hide(); if (editor.getValue() == '') { $('#saveQueryMessage').html('
Please enter a query.
').show(); } else { $('#saveQueryForm').show(); $('#saveQueryFormFileName').val(activeSQLFile.fileName || '').focus(); $('#saveQueryFormDescription').val(activeSQLFile.description || ''); } }); $('#workbooksModal').on('shown.bs.modal', function (e) { fetchAndDisplayWorkbooksList(); });`; }
function generateJsForSettingDefaultQuery() { return `function setDefaultQueryInEditor() { editor.setValue('SELECT\\n\\tID,\\n\\tLastName,\\n\\tFirstName,\\n\\tPhone,\\n\\tEmail\\nFROM\\n\\tEmployee'); }`; }
function generateJsForTogglingPaginationOptions() { return `function togglePaginationOptionsVisibility() { const isChecked = $('#enablePagination').is(':checked'); $('#pagination-options').toggle(isChecked); }`; }
function generateJsForRefreshingFileInfoDisplay() { return `function refreshUnsavedFileStatusIndicator() { var content = ''; if (activeSQLFile.source == undefined) { if (editor.getValue() != '') { content = '
Unsaved '; } } else { var status = (editor.getValue() != activeSQLFile.sql) ? 'Changed' : 'Unchanged'; var tooltip = 'Source: ' + activeSQLFile.source + '\\nStatus: ' + status; content = '
' + activeSQLFile.fileName + ' '; if (status === 'Changed') { content = '
' + content + ' '; } } $('#fileInfo').html(content); }`; }
function generateJsForSubmittingQuery() { return `function submitQueryForExecution() { var queryText = editor.getValue(); if (!queryText) { alert('Please enter a query.'); return; } var selectedText = editor.getSelection(); var theQuery = selectedText || queryText; var rowBegin = 1, rowEnd = 999999; if ($('#enablePagination').is(':checked') && !$('#returnAll').is(':checked')) { rowBegin = parseInt($('#rowBegin').val()) || 1; rowEnd = parseInt($('#rowEnd').val()) || ${rowsReturnedDefault}; } $('#resultsDiv').show(); $('#resultsDiv').html('
Running query... '); var requestPayload = { 'function': 'queryExecute', 'query': theQuery, 'rowBegin': rowBegin, 'rowEnd': rowEnd, 'paginationEnabled': $('#enablePagination').is(':checked'), 'viewsEnabled': false, 'returnTotals': $('#returnTotals').is(':checked') }; $.post({ url: '${scriptURL}', data: JSON.stringify(requestPayload), contentType: 'application/json' }).done(function(response) { queryResponsePayload = response; if (queryResponsePayload.error) { $('#resultsDiv').html('
Error ' + queryResponsePayload.error.message + ' '); } else { saveQueryToRecentQueries(theQuery); generateResponseOutputBasedOnFormat(); } }).fail(function(xhr) { $('#resultsDiv').html('
Error XHR Error: ' + xhr.status + ' ' + xhr.statusText + ' '); }); }`; }
function generateJsForResizingQueryTextArea() { return `function resizeQueryTextArea() { /* Auto-resize handled by flexbox and CodeMirror */ }`; }
function generateJsForGettingRadioFieldValue() { return `function getCheckedRadioValue(name) { return $('input[name="' + name + '"]:checked').val(); }`; }
function generateJsForFetchingRemoteLibraryIndex() { return `function fetchAndDisplayRemoteLibraryIndex() { $('#remoteSQLFilesList').html('
Loading... '); $.getJSON('https://suiteql.s3.us-east-1.amazonaws.com/queries/index.json?nonce=' + new Date().getTime()).done(function(payload) { let content = '
Name Description '; payload.forEach(r => { content += '' + r.name + ' ' + r.description + ' Load
'; $('#remoteSQLFilesList').html(content); if (datatablesEnabled) { $('#remoteFilesTable').DataTable({"pageLength": 10}); } }).fail(function(xhr) { $('#remoteSQLFilesList').html('
' + xhr.status + '
'); }); }`; }
function generateJsForLoadingRemoteSqlFile() { return `function loadSqlFileFromRemoteLibrary(filename) { $.get('https://suiteql.s3.us-east-1.amazonaws.com/queries/' + filename + '?nonce=' + new Date().getTime()).done(function(response) { editor.setValue(response); activeSQLFile = { source: 'Remote', fileName: filename, sql: response }; refreshUnsavedFileStatusIndicator(); $('#remoteLoadModal').modal('hide'); $('#resultsDiv').hide(); }).fail(function(xhr) { alert('Error: ' + xhr.status); }); }`; }
function generateJsForCopyingResponseData() { return `function copyResponseDataToClipboard() { $('#responseData').select(); document.execCommand('copy'); }`; }
function generateJsForGeneratingResponseOutput() { return `function generateResponseOutputBasedOnFormat() { switch (getCheckedRadioValue('resultsFormat')) { case 'csv': generateCsvFromResponseData(); break; case 'json': generateJsonFromResponseData(); break; default: generateHtmlTableFromResponseData(); } }`; }
function generateJsForGeneratingCsvResponse() { return `function generateCsvFromResponseData() { if (!queryResponsePayload || !queryResponsePayload.records || queryResponsePayload.records.length === 0) { $('#resultsDiv').html('
No records to display. '); return; } const columnNames = Object.keys(queryResponsePayload.records[0]); let csv = '"' + columnNames.join('","') + '"\\r\\n'; queryResponsePayload.records.forEach(record => { let values = columnNames.map(col => { let val = record[col] === null ? '' : String(record[col]); return '"' + val.replace(/"/g, '""') + '"'; }); csv += values.join(',') + '\\r\\n'; }); let header = ''; $('#resultsDiv').html(header + '
'); }`; }
function generateJsForGeneratingJsonResponse() { return `function generateJsonFromResponseData() { let header = ''; let jsonString = JSON.stringify(queryResponsePayload.records, null, 2); $('#resultsDiv').html(header + '
'); }`; }
function generateJsForGeneratingHtmlTableResponse() { return `function generateHtmlTableFromResponseData() { if (!queryResponsePayload || !queryResponsePayload.records || queryResponsePayload.records.length === 0) { $('#resultsDiv').html('
No records found. '); return; } const records = queryResponsePayload.records; const columnNames = Object.keys(records[0]); let header = ''; let table = '
'; columnNames.forEach(col => { table += '' + col + ' '; }); table += ' '; const nullFormat = getCheckedRadioValue('nullFormat'); records.forEach(rec => { table += ''; columnNames.forEach(col => { let val = rec[col]; if (val === null) { if (nullFormat === 'blank') val = ''; else if (nullFormat === 'dimmed') val = 'null '; else val = 'null'; } table += '' + val + ' '; }); table += ' '; }); table += '
'; $('#resultsDiv').html(header + table); if (datatablesEnabled) { $('#resultsTable').DataTable({"pageLength": 10, "scrollX": true}); } }`; }
function generateJsForTogglingReturnAllRowsOption() { return `function toggleReturnAllRowsOption() { $('#rowBegin, #rowEnd').prop('disabled', $('#returnAll').is(':checked')); }`; }
function generateJsForOpeningTablesReference() { return `function openTablesReferenceWindow() { window.open('${scriptURL}&function=tablesReference', '_tablesRef'); }`; }
function generateJsForGettingRecentQueries() { return `function displayRecentQueriesFromLocalStorage() { let recentQueries = JSON.parse(localStorage.getItem('suiteql_recentQueries') || '[]'); let content = ''; if (recentQueries.length === 0) { content = '
No recent queries found.
'; } else { content = '
Query '; recentQueries.forEach((query, index) => { let displayQuery = query.replace(/\\n|\\t/g, ' ').trim(); content += '' + displayQuery + 'Load
'; } $('#recentQueriesList').html(content); }`; }
function generateJsForLoadingRecentQuery() { return `function loadQueryFromRecentQueries(index) { let recentQueries = JSON.parse(localStorage.getItem('suiteql_recentQueries') || '[]'); if (recentQueries[index]) { editor.setValue(recentQueries[index]); $('#recentQueriesModal').modal('hide'); $('#resultsDiv').hide(); activeSQLFile = {}; refreshUnsavedFileStatusIndicator(); } }`; }
function generateJsForSavingRecentQuery() { return `function saveQueryToRecentQueries(queryToSave) { const MAX_RECENT_QUERIES = 20; let recentQueries = JSON.parse(localStorage.getItem('suiteql_recentQueries') || '[]'); const existingIndex = recentQueries.indexOf(queryToSave); if (existingIndex > -1) { recentQueries.splice(existingIndex, 1); } recentQueries.unshift(queryToSave); if (recentQueries.length > MAX_RECENT_QUERIES) { recentQueries = recentQueries.slice(0, MAX_RECENT_QUERIES); } localStorage.setItem('suiteql_recentQueries', JSON.stringify(recentQueries)); }`; }
function generateJsForGettingTableDetails() { return `function fetchAndDisplayTableDetails(tableName) { $('#tableInfoColumn').html('
Loading ' + tableName + '... '); var url = '/app/recordscatalog/rcendpoint.nl?action=getRecordTypeDetail&data=' + encodeURI(JSON.stringify({ scriptId: tableName, detailType: 'SS_ANAL' })); $.getJSON(url).done(function(response) { let recordDetail = response.data; let content = '
' + recordDetail.label + ' ("' + tableName + '") '; content += '
Columns Label Name Type '; recordDetail.fields.forEach(f => { if (f.isColumn) { content += '' + f.label + ' ' + f.id + ' ' + f.dataType + '
'; $('#tableInfoColumn').html(content); if (datatablesEnabled) { $('#tableColumnsTable').DataTable({"pageLength": 10}); } }); }`; }
function generateJsForGettingTableNames() { return `function fetchAndDisplayAllTableNames() { var url = '/app/recordscatalog/rcendpoint.nl?action=getRecordTypes&data=' + encodeURI(JSON.stringify({ structureType: 'FLAT' })); $.getJSON(url).done(function(response) { let recordTypes = response.data; let content = '
Table Name '; recordTypes.forEach(rt => { content += '' + rt.label + ' ' + rt.id + '
'; $('#tablesColumn').html(content); if (datatablesEnabled) { $('#tableNamesTable').DataTable({"pageLength": 10}); } }); }`; }
function generateJsForCopyingTableQuery() { return `function copyTableQueryToClipboard() { $('#tableQuery').select(); document.execCommand('copy'); }`; }
function generateJsForGettingLocalLibraryFiles() {
return `function fetchAndDisplayLocalLibraryFiles() {
$('#localSQLFilesList').html('
Loading... ');
$.post({
url: '${scriptURL}',
data: JSON.stringify({ 'function': 'localLibraryFilesGet' }),
contentType: 'application/json'
}).done(function(payload) {
if (payload.error) {
$('#localSQLFilesList').html('
' + payload.error + '
');
return;
}
let content = '
Name Description ';
payload.records.forEach(r => {
content += '' + (r.name || '') + ' ' + (r.description || '') + ' Load
';
$('#localSQLFilesList').html(content);
if (datatablesEnabled) { $('#localFilesTable').DataTable({"pageLength": 10}); }
}).fail(function(xhr) {
$('#localSQLFilesList').html('
Error: ' + xhr.status + '
');
});
}`;
}
function generateJsForLoadingLocalSqlFile() {
return `function loadSqlFileFromLocalLibraryById(fileID) {
$.post({
url: '${scriptURL}',
data: JSON.stringify({ 'function': 'sqlFileLoad', 'fileID': fileID }),
contentType: 'application/json'
}).done(function(payload) {
if (payload.error) { alert('Error: ' + payload.error); return; }
editor.setValue(payload.sql);
activeSQLFile = { source: 'Local', fileName: payload.file.name, description: payload.file.description, fileID: payload.file.id, sql: payload.sql };
refreshUnsavedFileStatusIndicator();
$('#localLoadModal').modal('hide');
$('#resultsDiv').hide();
}).fail(function(xhr) {
alert('Error: ' + xhr.status);
});
}`;
}
function generateJsForSavingLocalSqlFile() {
return `function saveSqlFileToLocalLibraryWithPrompt() {
var filename = $('#saveQueryFormFileName').val();
if (!filename) { alert('Please enter a file name.'); return; }
$.post({
url: '${scriptURL}',
data: JSON.stringify({ 'function': 'sqlFileExists', 'filename': filename }),
contentType: 'application/json'
}).done(function(fileExistsPayload) {
if (fileExistsPayload.exists && !confirm("A file named '" + filename + "' already exists. Overwrite?")) {
return;
}
var savePayload = {
'function': 'sqlFileSave',
'filename': filename,
'contents': editor.getValue(),
'description': $('#saveQueryFormDescription').val()
};
$.post({
url: '${scriptURL}',
data: JSON.stringify(savePayload),
contentType: 'application/json'
}).done(function(fileSavePayload) {
if (fileSavePayload.error) { alert('Error: ' + fileSavePayload.error); return; }
activeSQLFile = { source: 'Local', fileName: filename, description: savePayload.description, fileID: fileSavePayload.fileID, sql: savePayload.contents };
refreshUnsavedFileStatusIndicator();
alert('File saved.');
$('#saveModal').modal('hide');
}).fail(function(xhr) {
alert('Save Error: ' + xhr.status);
});
}).fail(function(xhr) {
alert('File Check Error: ' + xhr.status);
});
}`;
}
function generateJsForLoadingWorkbook() {
return `function loadQueryFromWorkbookById(scriptID) {
$.post({
url: '${scriptURL}',
data: JSON.stringify({ 'function': 'workbookLoad', 'scriptID': scriptID }),
contentType: 'application/json'
}).done(function(payload) {
if (payload.error) { alert('Error: ' + payload.error); return; }
editor.setValue(payload.sql);
$('#workbooksModal').modal('hide');
$('#resultsDiv').hide();
activeSQLFile = { source: 'Workbook ' + scriptID, fileName: '', description: '', fileID: '', sql: payload.sql };
refreshUnsavedFileStatusIndicator();
}).fail(function(xhr) {
alert('Error: ' + xhr.status);
});
}`;
}
function generateJsForGettingWorkbooksList() {
return `function fetchAndDisplayWorkbooksList() {
$('#workbooksList').html('
Loading... ');
$.post({
url: '${scriptURL}',
data: JSON.stringify({ 'function': 'workbooksGet' }),
contentType: 'application/json'
}).done(function(payload) {
if (payload.error) {
$('#workbooksList').html('
' + payload.error + '
');
return;
}
let content = '
Name Description Owner ';
payload.records.forEach(r => {
content += '' + (r.name || '') + ' ' + (r.description || '') + ' ' + (r.owner || '') + ' Load
';
$('#workbooksList').html(content);
if (datatablesEnabled) { $('#workbooksTable').DataTable({"pageLength": 10}); }
}).fail(function(xhr) {
$('#workbooksList').html('
Error loading workbooks: ' + xhr.statusText + '
');
});
}`;
}