/* vim: set expandtab sw=4 ts=4 sts=4: */ $(function () { checkNumberOfFields(); }); /** * Holds common parameters such as server, db, table, etc * * The content for this is normally loaded from Header.class.php or * Response.class.php and executed by ajax.js */ var PMA_commonParams = (function () { /** * @var hash params An associative array of key value pairs * @access private */ var params = {}; // The returned object is the public part of the module return { /** * Saves all the key value pair that * are provided in the input array * * @param obj hash The input array * * @return void */ setAll: function (obj) { var reload = false; var updateNavigation = false; for (var i in obj) { if (params[i] !== undefined && params[i] !== obj[i]) { if (i == 'db' || i == 'table') { updateNavigation = true; } reload = true; } params[i] = obj[i]; } if (updateNavigation && $('#pma_navigation_tree').hasClass('synced') ) { PMA_showCurrentNavigation(); } }, /** * Retrieves a value given its key * Returns empty string for undefined values * * @param name string The key * * @return string */ get: function (name) { return params[name] || ''; }, /** * Saves a single key value pair * * @param name string The key * @param value string The value * * @return self For chainability */ set: function (name, value) { var updateNavigation = false; if (name == 'db' || name == 'table' && params[name] !== value ) { updateNavigation = true; } params[name] = value; if (updateNavigation && $('#pma_navigation_tree').hasClass('synced') ) { PMA_showCurrentNavigation(); } return this; }, /** * Returns the url query string using the saved parameters * * @return string */ getUrlQuery: function () { return PMA_sprintf( '%s&server=%s&db=%s&table=%s', this.get('common_query'), encodeURIComponent(this.get('server')), encodeURIComponent(this.get('db')), encodeURIComponent(this.get('table')) ); } }; })(); /** * Holds common parameters such as server, db, table, etc * * The content for this is normally loaded from Header.class.php or * Response.class.php and executed by ajax.js */ var PMA_commonActions = { /** * Saves the database name when it's changed * and reloads the query window, if necessary * * @param new_db string new_db The name of the new database * * @return void */ setDb: function (new_db) { if (new_db != PMA_commonParams.get('db')) { PMA_commonParams.setAll({'db': new_db, 'table': ''}); } }, /** * Opens a database in the main part of the page * * @param new_db string The name of the new database * * @return void */ openDb: function (new_db) { PMA_commonParams .set('db', new_db) .set('table', ''); this.refreshMain( PMA_commonParams.get('opendb_url') ); }, /** * Refreshes the main frame * * @param mixed url Undefined to refresh to the same page * String to go to a different page, e.g: 'index.php' * * @return void */ refreshMain: function (url, callback) { if (! url) { url = $('#selflink').find('a').attr('href'); url = url.substring(0, url.indexOf('?')); } url += PMA_commonParams.getUrlQuery(); $('', {href: url}) .appendTo('body') .click() .remove(); AJAX._callback = callback; } }; /** * Class to handle PMA Drag and Drop Import * feature */ PMA_DROP_IMPORT = { /** * @var int, count of total uploads in this view */ uploadCount: 0, /** * @var int, count of live uploads */ liveUploadCount: 0, /** * @var string array, allowed extensions */ allowedExtensions: ['sql', 'xml', 'ldi', 'mediawiki', 'shp'], /** * @var string array, allowed extensions for compressed files */ allowedCompressedExtensions: ['gz', 'bz2', 'zip'], /** * @var obj array to store message returned by import_status.php */ importStatus: [], /** * Checks if any dropped file has valid extension or not * * @param file filename * * @return string, extension for valid extension, '' otherwise */ _getExtension: function(file) { var arr = file.split('.'); ext = arr[arr.length - 1]; //check if compressed if (jQuery.inArray(ext.toLowerCase(), PMA_DROP_IMPORT.allowedCompressedExtensions) !== -1) { ext = arr[arr.length - 2]; } //Now check for extension if (jQuery.inArray(ext.toLowerCase(), PMA_DROP_IMPORT.allowedExtensions) !== -1) { return ext; } return ''; }, /** * Shows upload progress for different sql uploads * * @param: hash (string), hash for specific file upload * @param: percent (float), file upload percentage * * @return void */ _setProgress: function(hash, percent) { $('.pma_sql_import_status div li[data-hash="' +hash +'"]') .children('progress').val(percent); }, /** * Function to upload the file asynchronously * * @param formData FormData object for a specific file * @param hash hash of the current file upload * * @return void */ _sendFileToServer: function(formData, hash) { var uploadURL ="./import.php"; //Upload URL var extraData ={}; var jqXHR = $.ajax({ xhr: function() { var xhrobj = $.ajaxSettings.xhr(); if (xhrobj.upload) { xhrobj.upload.addEventListener('progress', function(event) { var percent = 0; var position = event.loaded || event.position; var total = event.total; if (event.lengthComputable) { percent = Math.ceil(position / total * 100); } //Set progress PMA_DROP_IMPORT._setProgress(hash, percent); }, false); } return xhrobj; }, url: uploadURL, type: "POST", contentType:false, processData: false, cache: false, data: formData, success: function(data){ PMA_DROP_IMPORT._importFinished(hash, false, data.success); if (!data.success) { PMA_DROP_IMPORT.importStatus[PMA_DROP_IMPORT.importStatus.length] = { hash: hash, message: data.error }; } } }); // -- provide link to cancel the upload $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize').html('' + PMA_messages.dropImportMessageCancel + ''); // -- add event listener to this link to abort upload operation $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize span.pma_drop_file_status') .on('click', function() { if ($(this).attr('task') === 'cancel') { jqXHR.abort(); $(this).html('' +PMA_messages.dropImportMessageAborted +''); PMA_DROP_IMPORT._importFinished(hash, true, false); } else if ($(this).children("span").html() === PMA_messages.dropImportMessageFailed) { // -- view information var $this = $(this); $.each( PMA_DROP_IMPORT.importStatus, function( key, value ) { if (value.hash === hash) { $(".pma_drop_result:visible").remove(); var filename = $this.parent('span').attr('data-filename'); $("body").append('