/** * 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 * * @return {object} template data */ Export.getTemplateData = function () { var $form = $('form[name="dump"]'); var excludeList = ['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, excludeList) < 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 checkboxes (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(), 'templateName': name, 'templateData': JSON.stringify(templateData) }; Functions.ajaxShowMessage(); $.post('index.php?route=/export/template/create', 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(), 'templateId': id, }; Functions.ajaxShowMessage(); $.post('index.php?route=/export/template/load', 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(), 'templateId': id, 'templateData': JSON.stringify(templateData) }; Functions.ajaxShowMessage(); $.post('index.php?route=/export/template/update', 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(), 'templateId': id, }; Functions.ajaxShowMessage(); $.post('index.php?route=/export/template/delete', 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 () { $('#showsqlquery').on('click', function () { // Creating a dialog box similar to preview sql container to show sql query var modalOptions = {}; modalOptions[Messages.strClose] = function () { $(this).dialog('close'); }; $('#export_sql_modal_content').clone().dialog({ minWidth: 550, maxHeight: 400, modal: true, buttons: modalOptions, title: Messages.strQuery, close: function () { $(this).remove(); }, open: function () { // Pretty SQL printing. Functions.highlightSql($(this)); } }); }); /** * 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); } }); // update 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').on('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.checkTableSelectStructureOrData(); } }; /** * 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.checkTableSelectStructureOrData = 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.checkTableSelectStructureOrData(); }); $('input[name="table_structure[]"]').on('change', function () { Export.checkTableSelected($(this).closest('tr')); Export.checkTableSelectAll(); Export.handleAddProcCheckbox(); Export.checkTableSelectStructureOrData(); }); $('input[name="table_data[]"]').on('change', function () { Export.checkTableSelected($(this).closest('tr')); Export.checkTableSelectAll(); Export.handleAddProcCheckbox(); Export.checkTableSelectStructureOrData(); }); $('#table_structure_all').on('change', function () { Export.toggleTableSelectAllStr(); Export.checkSelectedTables(); Export.handleAddProcCheckbox(); Export.checkTableSelectStructureOrData(); }); $('#table_data_all').on('change', function () { Export.toggleTableSelectAllData(); Export.checkSelectedTables(); Export.handleAddProcCheckbox(); Export.checkTableSelectStructureOrData(); }); 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( $('') ) .after( $('') ); $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; clearTimeout(timeOut); timeOut = setTimeout(function () { $.get('index.php?route=/export/check-time-out', { 'ajax_request': true }, function (data) { if (data.message === 'timeout') { Functions.ajaxShowMessage( '