diff options
Diffstat (limited to 'srcs/phpmyadmin/js/export.js')
| -rw-r--r-- | srcs/phpmyadmin/js/export.js | 1014 |
1 files changed, 1014 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/js/export.js b/srcs/phpmyadmin/js/export.js new file mode 100644 index 0000000..db625e7 --- /dev/null +++ b/srcs/phpmyadmin/js/export.js @@ -0,0 +1,1014 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Functions used in the export tab + * + */ + +var Export = {}; + +/** + * Disables the "Dump some row(s)" sub-options + */ +Export.disableDumpSomeRowsSubOptions = function () { + $('label[for=\'limit_to\']').fadeTo('fast', 0.4); + $('label[for=\'limit_from\']').fadeTo('fast', 0.4); + $('input[type=\'text\'][name=\'limit_to\']').prop('disabled', 'disabled'); + $('input[type=\'text\'][name=\'limit_from\']').prop('disabled', 'disabled'); +}; + +/** + * Enables the "Dump some row(s)" sub-options + */ +Export.enableDumpSomeRowsSubOptions = function () { + $('label[for=\'limit_to\']').fadeTo('fast', 1); + $('label[for=\'limit_from\']').fadeTo('fast', 1); + $('input[type=\'text\'][name=\'limit_to\']').prop('disabled', ''); + $('input[type=\'text\'][name=\'limit_from\']').prop('disabled', ''); +}; + +/** + * Return template data as a json object + * + * @returns template data + */ +Export.getTemplateData = function () { + var $form = $('form[name="dump"]'); + var blacklist = ['token', 'server', 'db', 'table', 'single_table', + 'export_type', 'export_method', 'sql_query', 'template_id']; + var obj = {}; + var arr = $form.serializeArray(); + $.each(arr, function () { + if ($.inArray(this.name, blacklist) < 0) { + if (obj[this.name] !== undefined) { + if (! obj[this.name].push) { + obj[this.name] = [obj[this.name]]; + } + obj[this.name].push(this.value || ''); + } else { + obj[this.name] = this.value || ''; + } + } + }); + // include unchecked checboxes (which are ignored by serializeArray()) with null + // to uncheck them when loading the template + $form.find('input[type="checkbox"]:not(:checked)').each(function () { + if (obj[this.name] === undefined) { + obj[this.name] = null; + } + }); + // include empty multiselects + $form.find('select').each(function () { + if ($(this).find('option:selected').length === 0) { + obj[this.name] = []; + } + }); + return obj; +}; + +/** + * Create a template with selected options + * + * @param name name of the template + */ +Export.createTemplate = function (name) { + var templateData = Export.getTemplateData(); + + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': CommonParams.get('db'), + 'table': CommonParams.get('table'), + 'exportType': $('input[name="export_type"]').val(), + 'templateAction': 'create', + 'templateName': name, + 'templateData': JSON.stringify(templateData) + }; + + Functions.ajaxShowMessage(); + $.post('tbl_export.php', params, function (response) { + if (response.success === true) { + $('#templateName').val(''); + $('#template').html(response.data); + $('#template').find('option').each(function () { + if ($(this).text() === name) { + $(this).prop('selected', true); + } + }); + Functions.ajaxShowMessage(Messages.strTemplateCreated); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); +}; + +/** + * Loads a template + * + * @param id ID of the template to load + */ +Export.loadTemplate = function (id) { + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': CommonParams.get('db'), + 'table': CommonParams.get('table'), + 'exportType': $('input[name="export_type"]').val(), + 'templateAction': 'load', + 'templateId': id, + }; + + Functions.ajaxShowMessage(); + $.post('tbl_export.php', params, function (response) { + if (response.success === true) { + var $form = $('form[name="dump"]'); + var options = JSON.parse(response.data); + $.each(options, function (key, value) { + var localValue = value; + var $element = $form.find('[name="' + key + '"]'); + if ($element.length) { + if (($element.is('input') && $element.attr('type') === 'checkbox') && localValue === null) { + $element.prop('checked', false); + } else { + if (($element.is('input') && $element.attr('type') === 'checkbox') || + ($element.is('input') && $element.attr('type') === 'radio') || + ($element.is('select') && $element.attr('multiple') === 'multiple')) { + if (! localValue.push) { + localValue = [localValue]; + } + } + $element.val(localValue); + } + $element.trigger('change'); + } + }); + $('input[name="template_id"]').val(id); + Functions.ajaxShowMessage(Messages.strTemplateLoaded); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); +}; + +/** + * Updates an existing template with current options + * + * @param id ID of the template to update + */ +Export.updateTemplate = function (id) { + var templateData = Export.getTemplateData(); + + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': CommonParams.get('db'), + 'table': CommonParams.get('table'), + 'exportType': $('input[name="export_type"]').val(), + 'templateAction': 'update', + 'templateId': id, + 'templateData': JSON.stringify(templateData) + }; + + Functions.ajaxShowMessage(); + $.post('tbl_export.php', params, function (response) { + if (response.success === true) { + Functions.ajaxShowMessage(Messages.strTemplateUpdated); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); +}; + +/** + * Delete a template + * + * @param id ID of the template to delete + */ +Export.deleteTemplate = function (id) { + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': CommonParams.get('db'), + 'table': CommonParams.get('table'), + 'exportType': $('input[name="export_type"]').val(), + 'templateAction': 'delete', + 'templateId': id, + }; + + Functions.ajaxShowMessage(); + $.post('tbl_export.php', params, function (response) { + if (response.success === true) { + $('#template').find('option[value="' + id + '"]').remove(); + Functions.ajaxShowMessage(Messages.strTemplateDeleted); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); +}; + +/** + * Unbind all event handlers before tearing down a page + */ +AJAX.registerTeardown('export.js', function () { + $('#plugins').off('change'); + $('input[type=\'radio\'][name=\'sql_structure_or_data\']').off('change'); + $('input[type=\'radio\'][name$=\'_structure_or_data\']').off('change'); + $('input[type=\'radio\'][name=\'output_format\']').off('change'); + $('#checkbox_sql_include_comments').off('change'); + $('input[type=\'radio\'][name=\'quick_or_custom\']').off('change'); + $('input[type=\'radio\'][name=\'allrows\']').off('change'); + $('#btn_alias_config').off('click'); + $('.alias_remove').off('click'); + $('#db_alias_button').off('click'); + $('#table_alias_button').off('click'); + $('#column_alias_button').off('click'); + $('input[name="table_select[]"]').off('change'); + $('input[name="table_structure[]"]').off('change'); + $('input[name="table_data[]"]').off('change'); + $('#table_structure_all').off('change'); + $('#table_data_all').off('change'); + $('input[name="createTemplate"]').off('click'); + $('select[name="template"]').off('change'); + $('input[name="updateTemplate"]').off('click'); + $('input[name="deleteTemplate"]').off('click'); +}); + +AJAX.registerOnload('export.js', function () { + /** + * Export template handling code + */ + // create a new template + $('input[name="createTemplate"]').on('click', function (e) { + e.preventDefault(); + var name = $('input[name="templateName"]').val(); + if (name.length) { + Export.createTemplate(name); + } + }); + + // load an existing template + $('select[name="template"]').on('change', function (e) { + e.preventDefault(); + var id = $(this).val(); + if (id.length) { + Export.loadTemplate(id); + } + }); + + // udpate an existing template with new criteria + $('input[name="updateTemplate"]').on('click', function (e) { + e.preventDefault(); + var id = $('select[name="template"]').val(); + if (id.length) { + Export.updateTemplate(id); + } + }); + + // delete an existing template + $('input[name="deleteTemplate"]').on('click', function (e) { + e.preventDefault(); + var id = $('select[name="template"]').val(); + if (id.length) { + Export.deleteTemplate(id); + } + }); + + /** + * Toggles the hiding and showing of each plugin's options + * according to the currently selected plugin from the dropdown list + */ + $('#plugins').on('change', function () { + $('#format_specific_opts').find('div.format_specific_options').hide(); + var selectedPluginName = $('#plugins').find('option:selected').val(); + $('#' + selectedPluginName + '_options').show(); + }); + + /** + * Toggles the enabling and disabling of the SQL plugin's comment options that apply only when exporting structure + */ + $('input[type=\'radio\'][name=\'sql_structure_or_data\']').on('change', function () { + var commentsArePresent = $('#checkbox_sql_include_comments').prop('checked'); + var show = $('input[type=\'radio\'][name=\'sql_structure_or_data\']:checked').val(); + if (show === 'data') { + // disable the SQL comment options + if (commentsArePresent) { + $('#checkbox_sql_dates').prop('disabled', true).parent().fadeTo('fast', 0.4); + } + $('#checkbox_sql_relation').prop('disabled', true).parent().fadeTo('fast', 0.4); + $('#checkbox_sql_mime').prop('disabled', true).parent().fadeTo('fast', 0.4); + } else { + // enable the SQL comment options + if (commentsArePresent) { + $('#checkbox_sql_dates').prop('disabled', false).parent().fadeTo('fast', 1); + } + $('#checkbox_sql_relation').prop('disabled', false).parent().fadeTo('fast', 1); + $('#checkbox_sql_mime').prop('disabled', false).parent().fadeTo('fast', 1); + } + + if (show === 'structure') { + $('#checkbox_sql_auto_increment').prop('disabled', true).parent().fadeTo('fast', 0.4); + } else { + $('#checkbox_sql_auto_increment').prop('disabled', false).parent().fadeTo('fast', 1); + } + }); + + // When MS Excel is selected as the Format automatically Switch to Character Set as windows-1252 + $('#plugins').change(function () { + var selectedPluginName = $('#plugins').find('option:selected').val(); + if (selectedPluginName === 'excel') { + $('#select_charset').val('windows-1252'); + } else { + $('#select_charset').val('utf-8'); + } + }); + + // For separate-file exports only ZIP compression is allowed + $('input[type="checkbox"][name="as_separate_files"]').on('change', function () { + if ($(this).is(':checked')) { + $('#compression').val('zip'); + } + }); + + $('#compression').on('change', function () { + if ($('option:selected').val() !== 'zip') { + $('input[type="checkbox"][name="as_separate_files"]').prop('checked', false); + } + }); +}); + +Export.setupTableStructureOrData = function () { + if ($('input[name=\'export_type\']').val() !== 'database') { + return; + } + var pluginName = $('#plugins').find('option:selected').val(); + var formElemName = pluginName + '_structure_or_data'; + var forceStructureOrData = !($('input[name=\'' + formElemName + '_default\']').length); + + if (forceStructureOrData === true) { + $('input[name="structure_or_data_forced"]').val(1); + $('.export_structure input[type="checkbox"], .export_data input[type="checkbox"]') + .prop('disabled', true); + $('.export_structure, .export_data').fadeTo('fast', 0.4); + } else { + $('input[name="structure_or_data_forced"]').val(0); + $('.export_structure input[type="checkbox"], .export_data input[type="checkbox"]') + .prop('disabled', false); + $('.export_structure, .export_data').fadeTo('fast', 1); + + var structureOrData = $('input[name="' + formElemName + '_default"]').val(); + + if (structureOrData === 'structure') { + $('.export_data input[type="checkbox"]') + .prop('checked', false); + } else if (structureOrData === 'data') { + $('.export_structure input[type="checkbox"]') + .prop('checked', false); + } + if (structureOrData === 'structure' || structureOrData === 'structure_and_data') { + if (!$('.export_structure input[type="checkbox"]:checked').length) { + $('input[name="table_select[]"]:checked') + .closest('tr') + .find('.export_structure input[type="checkbox"]') + .prop('checked', true); + } + } + if (structureOrData === 'data' || structureOrData === 'structure_and_data') { + if (!$('.export_data input[type="checkbox"]:checked').length) { + $('input[name="table_select[]"]:checked') + .closest('tr') + .find('.export_data input[type="checkbox"]') + .prop('checked', true); + } + } + + Export.checkSelectedTables(); + Export.checkTableSelectAll(); + Export.checkTableSelectStrutureOrData(); + } +}; + +/** + * Toggles the hiding and showing of plugin structure-specific and data-specific + * options + */ +Export.toggleStructureDataOpts = function () { + var pluginName = $('select#plugins').val(); + var radioFormName = pluginName + '_structure_or_data'; + var dataDiv = '#' + pluginName + '_data'; + var structureDiv = '#' + pluginName + '_structure'; + var show = $('input[type=\'radio\'][name=\'' + radioFormName + '\']:checked').val(); + // Show the #rows if 'show' is not structure + $('#rows').toggle(show !== 'structure'); + if (show === 'data') { + $(dataDiv).slideDown('slow'); + $(structureDiv).slideUp('slow'); + } else { + $(structureDiv).slideDown('slow'); + if (show === 'structure') { + $(dataDiv).slideUp('slow'); + } else { + $(dataDiv).slideDown('slow'); + } + } +}; + +/** + * Toggles the disabling of the "save to file" options + */ +Export.toggleSaveToFile = function () { + var $ulSaveAsfile = $('#ul_save_asfile'); + if (!$('#radio_dump_asfile').prop('checked')) { + $ulSaveAsfile.find('> li').fadeTo('fast', 0.4); + $ulSaveAsfile.find('> li > input').prop('disabled', true); + $ulSaveAsfile.find('> li > select').prop('disabled', true); + } else { + $ulSaveAsfile.find('> li').fadeTo('fast', 1); + $ulSaveAsfile.find('> li > input').prop('disabled', false); + $ulSaveAsfile.find('> li > select').prop('disabled', false); + } +}; + +AJAX.registerOnload('export.js', function () { + Export.toggleSaveToFile(); + $('input[type=\'radio\'][name=\'output_format\']').on('change', Export.toggleSaveToFile); +}); + +/** + * For SQL plugin, toggles the disabling of the "display comments" options + */ +Export.toggleSqlIncludeComments = function () { + $('#checkbox_sql_include_comments').on('change', function () { + var $ulIncludeComments = $('#ul_include_comments'); + if (!$('#checkbox_sql_include_comments').prop('checked')) { + $ulIncludeComments.find('> li').fadeTo('fast', 0.4); + $ulIncludeComments.find('> li > input').prop('disabled', true); + } else { + // If structure is not being exported, the comment options for structure should not be enabled + if ($('#radio_sql_structure_or_data_data').prop('checked')) { + $('#text_sql_header_comment').prop('disabled', false).parent('li').fadeTo('fast', 1); + } else { + $ulIncludeComments.find('> li').fadeTo('fast', 1); + $ulIncludeComments.find('> li > input').prop('disabled', false); + } + } + }); +}; + +Export.checkTableSelectAll = function () { + var total = $('input[name="table_select[]"]').length; + var strChecked = $('input[name="table_structure[]"]:checked').length; + var dataChecked = $('input[name="table_data[]"]:checked').length; + var strAll = $('#table_structure_all'); + var dataAll = $('#table_data_all'); + + if (strChecked === total) { + strAll + .prop('indeterminate', false) + .prop('checked', true); + } else if (strChecked === 0) { + strAll + .prop('indeterminate', false) + .prop('checked', false); + } else { + strAll + .prop('indeterminate', true) + .prop('checked', false); + } + + if (dataChecked === total) { + dataAll + .prop('indeterminate', false) + .prop('checked', true); + } else if (dataChecked === 0) { + dataAll + .prop('indeterminate', false) + .prop('checked', false); + } else { + dataAll + .prop('indeterminate', true) + .prop('checked', false); + } +}; + +Export.checkTableSelectStrutureOrData = function () { + var strChecked = $('input[name="table_structure[]"]:checked').length; + var dataChecked = $('input[name="table_data[]"]:checked').length; + var autoIncrement = $('#checkbox_sql_auto_increment'); + + var pluginName = $('select#plugins').val(); + var dataDiv = '#' + pluginName + '_data'; + var structureDiv = '#' + pluginName + '_structure'; + + if (strChecked === 0) { + $(structureDiv).slideUp('slow'); + } else { + $(structureDiv).slideDown('slow'); + } + + if (dataChecked === 0) { + $(dataDiv).slideUp('slow'); + autoIncrement.prop('disabled', true).parent().fadeTo('fast', 0.4); + } else { + $(dataDiv).slideDown('slow'); + autoIncrement.prop('disabled', false).parent().fadeTo('fast', 1); + } +}; + +Export.toggleTableSelectAllStr = function () { + var strAll = $('#table_structure_all').is(':checked'); + if (strAll) { + $('input[name="table_structure[]"]').prop('checked', true); + } else { + $('input[name="table_structure[]"]').prop('checked', false); + } +}; + +Export.toggleTableSelectAllData = function () { + var dataAll = $('#table_data_all').is(':checked'); + if (dataAll) { + $('input[name="table_data[]"]').prop('checked', true); + } else { + $('input[name="table_data[]"]').prop('checked', false); + } +}; + +Export.checkSelectedTables = function () { + $('.export_table_select tbody tr').each(function () { + Export.checkTableSelected(this); + }); +}; + +Export.checkTableSelected = function (row) { + var $row = $(row); + var tableSelect = $row.find('input[name="table_select[]"]'); + var strCheck = $row.find('input[name="table_structure[]"]'); + var dataCheck = $row.find('input[name="table_data[]"]'); + + var data = dataCheck.is(':checked:not(:disabled)'); + var structure = strCheck.is(':checked:not(:disabled)'); + + if (data && structure) { + tableSelect.prop({ checked: true, indeterminate: false }); + $row.addClass('marked'); + } else if (data || structure) { + tableSelect.prop({ checked: true, indeterminate: true }); + $row.removeClass('marked'); + } else { + tableSelect.prop({ checked: false, indeterminate: false }); + $row.removeClass('marked'); + } +}; + +Export.toggleTableSelect = function (row) { + var $row = $(row); + var tableSelected = $row.find('input[name="table_select[]"]').is(':checked'); + + if (tableSelected) { + $row.find('input[type="checkbox"]:not(:disabled)').prop('checked', true); + $row.addClass('marked'); + } else { + $row.find('input[type="checkbox"]:not(:disabled)').prop('checked', false); + $row.removeClass('marked'); + } +}; + +Export.handleAddProcCheckbox = function () { + if ($('#table_structure_all').is(':checked') === true + && $('#table_data_all').is(':checked') === true + ) { + $('#checkbox_sql_procedure_function').prop('checked', true); + } else { + $('#checkbox_sql_procedure_function').prop('checked', false); + } +}; + +AJAX.registerOnload('export.js', function () { + /** + * For SQL plugin, if "CREATE TABLE options" is checked/unchecked, check/uncheck each of its sub-options + */ + var $create = $('#checkbox_sql_create_table_statements'); + var $createOptions = $('#ul_create_table_statements').find('input'); + $create.on('change', function () { + $createOptions.prop('checked', $(this).prop('checked')); + }); + $createOptions.on('change', function () { + if ($createOptions.is(':checked')) { + $create.prop('checked', true); + } + }); + + /** + * Disables the view output as text option if the output must be saved as a file + */ + $('#plugins').on('change', function () { + var activePlugin = $('#plugins').find('option:selected').val(); + var forceFile = $('#force_file_' + activePlugin).val(); + if (forceFile === 'true') { + if ($('#radio_dump_asfile').prop('checked') !== true) { + $('#radio_dump_asfile').prop('checked', true); + Export.toggleSaveToFile(); + } + $('#radio_view_as_text').prop('disabled', true).parent().fadeTo('fast', 0.4); + } else { + $('#radio_view_as_text').prop('disabled', false).parent().fadeTo('fast', 1); + } + }); + + $('input[type=\'radio\'][name$=\'_structure_or_data\']').on('change', function () { + Export.toggleStructureDataOpts(); + }); + + $('input[name="table_select[]"]').on('change', function () { + Export.toggleTableSelect($(this).closest('tr')); + Export.checkTableSelectAll(); + Export.handleAddProcCheckbox(); + Export.checkTableSelectStrutureOrData(); + }); + + $('input[name="table_structure[]"]').on('change', function () { + Export.checkTableSelected($(this).closest('tr')); + Export.checkTableSelectAll(); + Export.handleAddProcCheckbox(); + Export.checkTableSelectStrutureOrData(); + }); + + $('input[name="table_data[]"]').on('change', function () { + Export.checkTableSelected($(this).closest('tr')); + Export.checkTableSelectAll(); + Export.handleAddProcCheckbox(); + Export.checkTableSelectStrutureOrData(); + }); + + $('#table_structure_all').on('change', function () { + Export.toggleTableSelectAllStr(); + Export.checkSelectedTables(); + Export.handleAddProcCheckbox(); + Export.checkTableSelectStrutureOrData(); + }); + + $('#table_data_all').on('change', function () { + Export.toggleTableSelectAllData(); + Export.checkSelectedTables(); + Export.handleAddProcCheckbox(); + Export.checkTableSelectStrutureOrData(); + }); + + if ($('input[name=\'export_type\']').val() === 'database') { + // Hide structure or data radio buttons + $('input[type=\'radio\'][name$=\'_structure_or_data\']').each(function () { + var $this = $(this); + var name = $this.prop('name'); + var val = $('input[name="' + name + '"]:checked').val(); + var nameDefault = name + '_default'; + if (!$('input[name="' + nameDefault + '"]').length) { + $this + .after( + $('<input type="hidden" name="' + nameDefault + '" value="' + val + '" disabled>') + ) + .after( + $('<input type="hidden" name="' + name + '" value="structure_and_data">') + ); + $this.parent().find('label').remove(); + } else { + $this.parent().remove(); + } + }); + $('input[type=\'radio\'][name$=\'_structure_or_data\']').remove(); + + // Disable CREATE table checkbox for sql + var createTableCheckbox = $('#checkbox_sql_create_table'); + createTableCheckbox.prop('checked', true); + var dummyCreateTable = $('#checkbox_sql_create_table') + .clone() + .removeAttr('id') + .attr('type', 'hidden'); + createTableCheckbox + .prop('disabled', true) + .after(dummyCreateTable) + .parent() + .fadeTo('fast', 0.4); + + Export.setupTableStructureOrData(); + } + + /** + * Handle force structure_or_data + */ + $('#plugins').on('change', Export.setupTableStructureOrData); +}); + +/** + * Toggles display of options when quick and custom export are selected + */ +Export.toggleQuickOrCustom = function () { + if ($('input[name=\'quick_or_custom\']').length === 0 // custom_no_form option + || $('#radio_custom_export').prop('checked') // custom + ) { + $('#databases_and_tables').show(); + $('#rows').show(); + $('#output').show(); + $('#format_specific_opts').show(); + $('#output_quick_export').hide(); + var selectedPluginName = $('#plugins').find('option:selected').val(); + $('#' + selectedPluginName + '_options').show(); + } else { // quick + $('#databases_and_tables').hide(); + $('#rows').hide(); + $('#output').hide(); + $('#format_specific_opts').hide(); + $('#output_quick_export').show(); + } +}; + +var timeOut; + +Export.checkTimeOut = function (timeLimit) { + var limit = timeLimit; + if (typeof limit === 'undefined' || limit === 0) { + return true; + } + // margin of one second to avoid race condition to set/access session variable + limit = limit + 1; + var href = 'export.php'; + var params = { + 'ajax_request' : true, + 'check_time_out' : true + }; + clearTimeout(timeOut); + timeOut = setTimeout(function () { + $.get(href, params, function (data) { + if (data.message === 'timeout') { + Functions.ajaxShowMessage( + '<div class="error">' + + Messages.strTimeOutError + + '</div>', + false + ); + } + }); + }, limit * 1000); +}; + +/** + * Handler for Database/table alias select + * + * @param event object the event object + * + * @return void + */ +Export.aliasSelectHandler = function (event) { + var sel = event.data.sel; + var type = event.data.type; + var inputId = $(this).val(); + var $label = $(this).next('label'); + $('input#' + $label.attr('for')).addClass('hide'); + $('input#' + inputId).removeClass('hide'); + $label.attr('for', inputId); + $('#alias_modal ' + sel + '[id$=' + type + ']:visible').addClass('hide'); + var $inputWrapper = $('#alias_modal ' + sel + '#' + inputId + type); + $inputWrapper.removeClass('hide'); + if (type === '_cols' && $inputWrapper.length > 0) { + var outer = $inputWrapper[0].outerHTML; + // Replace opening tags + var regex = /<dummy_inp/gi; + if (outer.match(regex)) { + var newTag = outer.replace(regex, '<input'); + // Replace closing tags + regex = /<\/dummy_inp/gi; + newTag = newTag.replace(regex, '</input'); + // Assign replacement + $inputWrapper.replaceWith(newTag); + } + } else if (type === '_tables') { + $('.table_alias_select:visible').trigger('change'); + } + $('#alias_modal').dialog('option', 'position', 'center'); +}; + +/** + * Handler for Alias dialog box + * + * @param event object the event object + * + * @return void + */ +Export.createAliasModal = function (event) { + event.preventDefault(); + var dlgButtons = {}; + dlgButtons[Messages.strSaveAndClose] = function () { + $(this).dialog('close'); + $('#alias_modal').parent().appendTo($('form[name="dump"]')); + }; + $('#alias_modal').dialog({ + width: Math.min($(window).width() - 100, 700), + maxHeight: $(window).height(), + modal: true, + dialogClass: 'alias-dialog', + buttons: dlgButtons, + create: function () { + $(this).closest('.ui-dialog').find('.ui-button').addClass('btn btn-secondary'); + $(this).css('maxHeight', $(window).height() - 150); + var db = CommonParams.get('db'); + if (db) { + var option = $('<option></option>'); + option.text(db); + option.attr('value', db); + $('#db_alias_select').append(option).val(db).trigger('change'); + } else { + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'type': 'list-databases' + }; + $.post('ajax.php', params, function (response) { + if (response.success === true) { + $.each(response.databases, function (idx, value) { + var option = $('<option></option>'); + option.text(value); + option.attr('value', value); + $('#db_alias_select').append(option); + }); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); + } + }, + close: function () { + var isEmpty = true; + $(this).find('input[type="text"]').each(function () { + // trim empty input fields on close + if ($(this).val()) { + isEmpty = false; + } else { + $(this).parents('tr').remove(); + } + }); + // Toggle checkbox based on aliases + $('input#btn_alias_config').prop('checked', !isEmpty); + }, + position: { my: 'center top', at: 'center top', of: window } + }); +}; + +Export.aliasToggleRow = function (elm) { + var inputs = elm.parents('tr').find('input,button'); + if (elm.val()) { + inputs.attr('disabled', false); + } else { + inputs.attr('disabled', true); + } +}; + +Export.addAlias = function (type, name, field, value) { + if (value === '') { + return; + } + + var row = $('#alias_data tfoot tr').clone(); + row.find('th').text(type); + row.find('td:first').text(name); + row.find('input').attr('name', field); + row.find('input').val(value); + row.find('.alias_remove').on('click', function () { + $(this).parents('tr').remove(); + }); + + var matching = $('#alias_data [name="' + $.escapeSelector(field) + '"]'); + if (matching.length > 0) { + matching.parents('tr').remove(); + } + + $('#alias_data tbody').append(row); +}; + +AJAX.registerOnload('export.js', function () { + $('input[type=\'radio\'][name=\'quick_or_custom\']').on('change', Export.toggleQuickOrCustom); + + $('#scroll_to_options_msg').hide(); + $('#format_specific_opts').find('div.format_specific_options') + .hide() + .css({ + 'border': 0, + 'margin': 0, + 'padding': 0 + }) + .find('h3') + .remove(); + Export.toggleQuickOrCustom(); + Export.toggleStructureDataOpts(); + Export.toggleSqlIncludeComments(); + Export.checkTableSelectAll(); + Export.handleAddProcCheckbox(); + + /** + * Initially disables the "Dump some row(s)" sub-options + */ + Export.disableDumpSomeRowsSubOptions(); + + /** + * Disables the "Dump some row(s)" sub-options when it is not selected + */ + $('input[type=\'radio\'][name=\'allrows\']').on('change', function () { + if ($('input[type=\'radio\'][name=\'allrows\']').prop('checked')) { + Export.enableDumpSomeRowsSubOptions(); + } else { + Export.disableDumpSomeRowsSubOptions(); + } + }); + + // Open Alias Modal Dialog on click + $('#btn_alias_config').on('click', Export.createAliasModal); + $('.alias_remove').on('click', function () { + $(this).parents('tr').remove(); + }); + $('#db_alias_select').on('change', function () { + Export.aliasToggleRow($(this)); + var table = CommonParams.get('table'); + if (table) { + var option = $('<option></option>'); + option.text(table); + option.attr('value', table); + $('#table_alias_select').append(option).val(table).trigger('change'); + } else { + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': $(this).val(), + 'type': 'list-tables' + }; + $.post('ajax.php', params, function (response) { + if (response.success === true) { + $.each(response.tables, function (idx, value) { + var option = $('<option></option>'); + option.text(value); + option.attr('value', value); + $('#table_alias_select').append(option); + }); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); + } + }); + $('#table_alias_select').on('change', function () { + Export.aliasToggleRow($(this)); + var params = { + 'ajax_request': true, + 'server': CommonParams.get('server'), + 'db': $('#db_alias_select').val(), + 'table': $(this).val(), + 'type': 'list-columns' + }; + $.post('ajax.php', params, function (response) { + if (response.success === true) { + $.each(response.columns, function (idx, value) { + var option = $('<option></option>'); + option.text(value); + option.attr('value', value); + $('#column_alias_select').append(option); + }); + } else { + Functions.ajaxShowMessage(response.error, false); + } + }); + }); + $('#column_alias_select').on('change', function () { + Export.aliasToggleRow($(this)); + }); + $('#db_alias_button').on('click', function (e) { + e.preventDefault(); + var db = $('#db_alias_select').val(); + Export.addAlias( + Messages.strAliasDatabase, + db, + 'aliases[' + db + '][alias]', + $('#db_alias_name').val() + ); + $('#db_alias_name').val(''); + }); + $('#table_alias_button').on('click', function (e) { + e.preventDefault(); + var db = $('#db_alias_select').val(); + var table = $('#table_alias_select').val(); + Export.addAlias( + Messages.strAliasTable, + db + '.' + table, + 'aliases[' + db + '][tables][' + table + '][alias]', + $('#table_alias_name').val() + ); + $('#table_alias_name').val(''); + }); + $('#column_alias_button').on('click', function (e) { + e.preventDefault(); + var db = $('#db_alias_select').val(); + var table = $('#table_alias_select').val(); + var column = $('#column_alias_select').val(); + Export.addAlias( + Messages.strAliasColumn, + db + '.' + table + '.' + column, + 'aliases[' + db + '][tables][' + table + '][colums][' + column + ']', + $('#column_alias_name').val() + ); + $('#column_alias_name').val(''); + }); +}); |