function NameIsValid(name) { sName = new String(name); if (sName.match(/^[A-Za-z][A-Za-z0-9_]*$/)) return true; return false; } function DoGoBack(iStep) { $('input[name=operation]').val('step'+iStep); $(':button').attr('disabled', 'disabled'); $('#theForm').submit(); // Submit the form return true; } function DoSubmit(sMsg, iStep) { var bResult = true; switch(iStep) { case 0: // Select either install or upgrade or nothing to select... if ( ($("input:radio").length > 0) && ($("input:radio:checked").length < 1)) { alert('Please select either install or upgrade'); bResult = false; } break; case 1: // Licence agreement if ($('#licence_ok:checked').length < 1) { alert('Please accept the licence agreement before continuing.'); bResult = false; } break; case 2: // Database server selection if ($('#db_server').val() == '') { alert('Please specify a database server. Use "localhost" for a local DB server.'); bResult = false; } else if ($('#db_user').val() == '') { alert('Please specify a user name to connect to the database.'); bResult = false; } break; case 3: // Database instance selection if ($("input[@type=radio]:checked").length < 1) { alert('Please specify a database name'); bResult = false; } else if( ($("#new_db:checked").length == 1)) { if ($('#new_db_name').val() == '') { alert('Please specify the name of the database to create'); bResult = false; } else if (!NameIsValid($('#new_db_name').val())) { alert($('#new_db_name').val()+' is not a valid database name. Please limit yourself to letters, numbers and the underscore character.'); bResult = false; } } else if ($("#current_db:checked").length == 1) { // Special case (DB enumeration failed, user must enter DB name) if ($("#current_db_name").val() == '') { alert('Please specify the name of the database.'); bResult = false; } else { // Copy the typed value as the value of the radio $("#current_db").val($("#current_db_name").val()); } } if( ($('#db_prefix').val() != '') && (!NameIsValid($('#db_prefix').val())) ) { alert($('#db_prefix').val()+' is not a valid table name. Please limit yourself to letters, numbers and the underscore character.'); bResult = false; } break; case 4: // Choice of iTop modules break; case 5: // Administrator account if ($('#auth_user').val() == '') { alert('Please specify a login name for the administrator account'); bResult = false; } else if ($('#auth_pwd').val() != $('#auth_pwd2').val()) { alert('Retyped password does not match! Please verify the password.'); bResult = false; } break; case 6: // Sample data selection break; case 7: // Display Summary: launch DoUpdateDBSchema to start the asynchronous update bResult = DoUpdateDBSchema(); break; // Email test page case 10: if ($('#to').val() == '') { alert('Please specify a destination address'); bResult = false; } } if (bResult) { $(':button').attr('disabled', 'disabled'); if ((sMsg != '')) { $('#setup').block({message: ' '+sMsg}); } } return bResult; } function DoUpdateDBSchema() { try { // Call the asynchronous page that performs the creation/update of the DB Schema $('#log').html(''); $('#setup').block({message: '

Updating DB schema...

0%

'}); $('#progress').progression( {Current:5, Maximum: 100, aBackgroundImg: 'orange-progress.gif', aTextColor: '#000000'} ); $('#log').load( 'ajax.dataloader.php', { 'operation': 'update_db_schema', 'selected_modules': GetSelectedModules(), 'mode': $(':input[name=mode]').val() }, DoUpdateProfiles, 'html'); } catch(err) { alert('An exception occured: '+err); } return false; // Do NOT submit the form yet } function DoUpdateProfiles(response, status, xhr) { if (status == 'error') { $('#setup').unblock(); return; // An error occurred ! } try { // Call the asynchronous page that performs the creation/update of the DB Schema $('#log').html(''); $('#setup_msg').text('Updating Profiles...'); $('#progress').progression( {Current:40, Maximum: 100, aBackgroundImg: 'orange-progress.gif', aTextColor: '#000000'} ); $('#log').load( 'ajax.dataloader.php', { 'operation': 'after_db_create', 'selected_modules': GetSelectedModules(), 'mode': $(':input[name=mode]').val(), 'auth_user': $(':input[name=auth_user]').val(), 'auth_pwd': $(':input[name=auth_pwd]').val(), 'language': $(':input[name=language]').val() }, DoLoadDataAsynchronous, 'html'); // $('#log').ajaxError( // function(e, xhr, settings, exception) // { // bStopAysncProcess = true; // alert('Fatal error detected: '+ xhr.responseText); // $('#log').append(xhr.responseText); // $('#setup').unblock(); // } ); } catch(err) { alert('An exception occured: '+err); } return true; // Continue loading the data } var aFilesToLoad = new Array(); var iCounter = 0; function DoLoadDataAsynchronous(response, status, xhr) { if (status == 'error') { $('#setup').unblock(); return; // An error occurred ! } try { // The array aFilesToLoad is populated by this function dynamically written on the server PopulateDataFilesList(); iCurrent = 60; if (aFilesToLoad.length == 0) { $('#progress').progression( {Current: 100} ); } else { $('#log').html(''); $('#setup_msg').text('Loading data...'); $('#progress').progression( {Current: 60, Maximum: 100, aBackgroundImg: 'orange-progress.gif', aTextColor: '#000000'} ); // $('#log').ajaxError( // function(e, xhr, settings, exception) // { // bStopAysncProcess = true; // alert('Fatal error detected: '+ xhr.responseText); // $('#log').append(xhr.responseText); // $('#setup').unblock(); // } ); } LoadNextDataFile('', '', ''); } catch(err) { alert('An exception occured: '+err); } return true; // Continue } function LoadNextDataFile(response, status, xhr) { if (status == 'error') { $('#setup').unblock(); return; // Stop here } try { if (iCounter < aFilesToLoad.length) { if (iCounter == (aFilesToLoad.length - 1)) { // Last file in the list (or only 1 file), this completes the session sSessionStatus = 'end'; } else if (iCounter == 0) { // First file in the list, start the session sSessionStatus = 'start'; } else { sSessionStatus = 'continue'; } iPercent = 60+Math.round((40.0 * (1+iCounter)) / aFilesToLoad.length); sFileName = aFilesToLoad[iCounter]; //alert('Loading file '+sFileName+' ('+iPercent+' %) - '+sSessionStatus); $("#progress").progression({ Current: iPercent, Maximum: 100, aBackgroundImg: 'orange-progress.gif', aTextColor: '#000000' }); iCounter++; $('#log').load( 'ajax.dataloader.php', { 'operation': 'load_data', 'file': sFileName, 'percent': iPercent, 'session_status': sSessionStatus }, LoadNextDataFile, 'html'); } else { // We're done $("#progress").progression({ Current: 100, Maximum: 100, aBackgroundImg: 'orange-progress.gif', aTextColor: '#000000' }); $('#setup').unblock(); $('#GoToNextStep').submit(); // Use the hidden form to navigate to the next step } } catch(err) { alert('An exception occurred: '+err); } } function GetSelectedModules() { var aModules = new Array(); $(':input[name^=module]').each(function() { aModules.push($(this).val()); } ); return aModules.join(','); }