diff options
Diffstat (limited to 'srcs/phpmyadmin/js/table/change.js')
| -rw-r--r-- | srcs/phpmyadmin/js/table/change.js | 724 |
1 files changed, 724 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/js/table/change.js b/srcs/phpmyadmin/js/table/change.js new file mode 100644 index 0000000..bd7d4ba --- /dev/null +++ b/srcs/phpmyadmin/js/table/change.js @@ -0,0 +1,724 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * @fileoverview function used in table data manipulation pages + * + * @requires jQuery + * @requires jQueryUI + * @requires js/functions.js + * + */ + +/* global extendingValidatorMessages */ // js/messages.php +/* global openGISEditor, gisEditorLoaded, loadJSAndGISEditor, loadGISEditor */ // js/gis_data_editor.js + +/** + * Modify form controls when the "NULL" checkbox is checked + * + * @param theType string the MySQL field type + * @param urlField string the urlencoded field name - OBSOLETE + * @param md5Field string the md5 hashed field name + * @param multiEdit string the multi_edit row sequence number + * + * @return boolean always true + */ +function nullify (theType, urlField, md5Field, multiEdit) { + var rowForm = document.forms.insertForm; + + if (typeof(rowForm.elements['funcs' + multiEdit + '[' + md5Field + ']']) !== 'undefined') { + rowForm.elements['funcs' + multiEdit + '[' + md5Field + ']'].selectedIndex = -1; + } + + // "ENUM" field with more than 20 characters + if (Number(theType) === 1) { + rowForm.elements['fields' + multiEdit + '[' + md5Field + ']'][1].selectedIndex = -1; + // Other "ENUM" field + } else if (Number(theType) === 2) { + var elts = rowForm.elements['fields' + multiEdit + '[' + md5Field + ']']; + // when there is just one option in ENUM: + if (elts.checked) { + elts.checked = false; + } else { + var eltsCnt = elts.length; + for (var i = 0; i < eltsCnt; i++) { + elts[i].checked = false; + } // end for + } // end if + // "SET" field + } else if (Number(theType) === 3) { + rowForm.elements['fields' + multiEdit + '[' + md5Field + '][]'].selectedIndex = -1; + // Foreign key field (drop-down) + } else if (Number(theType) === 4) { + rowForm.elements['fields' + multiEdit + '[' + md5Field + ']'].selectedIndex = -1; + // foreign key field (with browsing icon for foreign values) + } else if (Number(theType) === 6) { + rowForm.elements['fields' + multiEdit + '[' + md5Field + ']'].value = ''; + // Other field types + } else /* if (theType === 5)*/ { + rowForm.elements['fields' + multiEdit + '[' + md5Field + ']'].value = ''; + } // end if... else if... else + + return true; +} // end of the 'nullify()' function + + +/** + * javascript DateTime format validation. + * its used to prevent adding default (0000-00-00 00:00:00) to database when user enter wrong values + * Start of validation part + */ +// function checks the number of days in febuary +function daysInFebruary (year) { + return (((year % 4 === 0) && (((year % 100 !== 0)) || (year % 400 === 0))) ? 29 : 28); +} +// function to convert single digit to double digit +function fractionReplace (number) { + var num = parseInt(number, 10); + return num >= 1 && num <= 9 ? '0' + num : '00'; +} + +/* function to check the validity of date +* The following patterns are accepted in this validation (accepted in mysql as well) +* 1) 2001-12-23 +* 2) 2001-1-2 +* 3) 02-12-23 +* 4) And instead of using '-' the following punctuations can be used (+,.,*,^,@,/) All these are accepted by mysql as well. Therefore no issues +*/ +function isDate (val, tmstmp) { + var value = val.replace(/[.|*|^|+|//|@]/g, '-'); + var arrayVal = value.split('-'); + for (var a = 0; a < arrayVal.length; a++) { + if (arrayVal[a].length === 1) { + arrayVal[a] = fractionReplace(arrayVal[a]); + } + } + value = arrayVal.join('-'); + var pos = 2; + var dtexp = new RegExp(/^([0-9]{4})-(((01|03|05|07|08|10|12)-((0[0-9])|([1-2][0-9])|(3[0-1])))|((02|04|06|09|11)-((0[0-9])|([1-2][0-9])|30))|((00)-(00)))$/); + if (value.length === 8) { + pos = 0; + } + if (dtexp.test(value)) { + var month = parseInt(value.substring(pos + 3, pos + 5), 10); + var day = parseInt(value.substring(pos + 6, pos + 8), 10); + var year = parseInt(value.substring(0, pos + 2), 10); + if (month === 2 && day > daysInFebruary(year)) { + return false; + } + if (value.substring(0, pos + 2).length === 2) { + year = parseInt('20' + value.substring(0, pos + 2), 10); + } + if (tmstmp === true) { + if (year < 1978) { + return false; + } + if (year > 2038 || (year > 2037 && day > 19 && month >= 1) || (year > 2037 && month > 1)) { + return false; + } + } + } else { + return false; + } + return true; +} + +/* function to check the validity of time +* The following patterns are accepted in this validation (accepted in mysql as well) +* 1) 2:3:4 +* 2) 2:23:43 +* 3) 2:23:43.123456 +*/ +function isTime (val) { + var arrayVal = val.split(':'); + for (var a = 0, l = arrayVal.length; a < l; a++) { + if (arrayVal[a].length === 1) { + arrayVal[a] = fractionReplace(arrayVal[a]); + } + } + var newVal = arrayVal.join(':'); + var tmexp = new RegExp(/^(-)?(([0-7]?[0-9][0-9])|(8[0-2][0-9])|(83[0-8])):((0[0-9])|([1-5][0-9])):((0[0-9])|([1-5][0-9]))(\.[0-9]{1,6}){0,1}$/); + return tmexp.test(newVal); +} + +/** + * To check whether insert section is ignored or not + */ +function checkForCheckbox (multiEdit) { + if ($('#insert_ignore_' + multiEdit).length) { + return $('#insert_ignore_' + multiEdit).is(':unchecked'); + } + return true; +} + +function verificationsAfterFieldChange (urlField, multiEdit, theType) { + var evt = window.event || arguments.callee.caller.arguments[0]; + var target = evt.target || evt.srcElement; + var $thisInput = $(':input[name^=\'fields[multi_edit][' + multiEdit + '][' + + urlField + ']\']'); + // the function drop-down that corresponds to this input field + var $thisFunction = $('select[name=\'funcs[multi_edit][' + multiEdit + '][' + + urlField + ']\']'); + var functionSelected = false; + if (typeof $thisFunction.val() !== 'undefined' && + $thisFunction.val() !== null && + $thisFunction.val().length > 0 + ) { + functionSelected = true; + } + + // To generate the textbox that can take the salt + var newSaltBox = '<br><input type=text name=salt[multi_edit][' + multiEdit + '][' + urlField + ']' + + ' id=salt_' + target.id + ' placeholder=\'' + Messages.strEncryptionKey + '\'>'; + + // If encrypting or decrypting functions that take salt as input is selected append the new textbox for salt + if (target.value === 'AES_ENCRYPT' || + target.value === 'AES_DECRYPT' || + target.value === 'DES_ENCRYPT' || + target.value === 'DES_DECRYPT' || + target.value === 'ENCRYPT') { + if (!($('#salt_' + target.id).length)) { + $thisInput.after(newSaltBox); + } + } else { + // Remove the textbox for salt + $('#salt_' + target.id).prev('br').remove(); + $('#salt_' + target.id).remove(); + } + + if (target.value === 'AES_DECRYPT' + || target.value === 'AES_ENCRYPT' + || target.value === 'MD5') { + $('#' + target.id).rules('add', { + validationFunctionForFuns: { + param: $thisInput, + depends: function () { + return checkForCheckbox(multiEdit); + } + } + }); + } + + // Unchecks the corresponding "NULL" control + $('input[name=\'fields_null[multi_edit][' + multiEdit + '][' + urlField + ']\']').prop('checked', false); + + // Unchecks the Ignore checkbox for the current row + $('input[name=\'insert_ignore_' + multiEdit + '\']').prop('checked', false); + + var charExceptionHandling; + if (theType.substring(0,4) === 'char') { + charExceptionHandling = theType.substring(5,6); + } else if (theType.substring(0,7) === 'varchar') { + charExceptionHandling = theType.substring(8,9); + } + if (functionSelected) { + $thisInput.removeAttr('min'); + $thisInput.removeAttr('max'); + // @todo: put back attributes if corresponding function is deselected + } + + if ($thisInput.data('rulesadded') === null && ! functionSelected) { + // call validate before adding rules + $($thisInput[0].form).validate(); + // validate for date time + if (theType === 'datetime' || theType === 'time' || theType === 'date' || theType === 'timestamp') { + $thisInput.rules('add', { + validationFunctionForDateTime: { + param: theType, + depends: function () { + return checkForCheckbox(multiEdit); + } + } + }); + } + // validation for integer type + if ($thisInput.data('type') === 'INT') { + var mini = parseInt($thisInput.attr('min')); + var maxi = parseInt($thisInput.attr('max')); + $thisInput.rules('add', { + number: { + param : true, + depends: function () { + return checkForCheckbox(multiEdit); + } + }, + min: { + param: mini, + depends: function () { + if (isNaN($thisInput.val())) { + return false; + } else { + return checkForCheckbox(multiEdit); + } + } + }, + max: { + param: maxi, + depends: function () { + if (isNaN($thisInput.val())) { + return false; + } else { + return checkForCheckbox(multiEdit); + } + } + } + }); + // validation for CHAR types + } else if ($thisInput.data('type') === 'CHAR') { + var maxlen = $thisInput.data('maxlength'); + if (typeof maxlen !== 'undefined') { + if (maxlen <= 4) { + maxlen = charExceptionHandling; + } + $thisInput.rules('add', { + maxlength: { + param: maxlen, + depends: function () { + return checkForCheckbox(multiEdit); + } + } + }); + } + // validate binary & blob types + } else if ($thisInput.data('type') === 'HEX') { + $thisInput.rules('add', { + validationFunctionForHex: { + param: true, + depends: function () { + return checkForCheckbox(multiEdit); + } + } + }); + } + $thisInput.data('rulesadded', true); + } else if ($thisInput.data('rulesadded') === true && functionSelected) { + // remove any rules added + $thisInput.rules('remove'); + // remove any error messages + $thisInput + .removeClass('error') + .removeAttr('aria-invalid') + .siblings('.error') + .remove(); + $thisInput.data('rulesadded', null); + } +} +/* End of fields validation*/ + +/** + * Unbind all event handlers before tearing down a page + */ +AJAX.registerTeardown('table/change.js', function () { + $(document).off('click', 'span.open_gis_editor'); + $(document).off('click', 'input[name^=\'insert_ignore_\']'); + $(document).off('click', 'input[name=\'gis_data[save]\']'); + $(document).off('click', 'input.checkbox_null'); + $('select[name="submit_type"]').off('change'); + $(document).off('change', '#insert_rows'); +}); + +/** + * Ajax handlers for Change Table page + * + * Actions Ajaxified here: + * Submit Data to be inserted into the table. + * Restart insertion with 'N' rows. + */ +AJAX.registerOnload('table/change.js', function () { + if ($('#insertForm').length) { + // validate the comment form when it is submitted + $('#insertForm').validate(); + jQuery.validator.addMethod('validationFunctionForHex', function (value) { + return value.match(/^[a-f0-9]*$/i) !== null; + }); + + jQuery.validator.addMethod('validationFunctionForFuns', function (value, element, options) { + if (value.substring(0, 3) === 'AES' && options.data('type') !== 'HEX') { + return false; + } + + return !(value.substring(0, 3) === 'MD5' && + typeof options.data('maxlength') !== 'undefined' && + options.data('maxlength') < 32); + }); + + jQuery.validator.addMethod('validationFunctionForDateTime', function (value, element, options) { + var dtValue = value; + var theType = options; + if (theType === 'date') { + return isDate(dtValue); + } else if (theType === 'time') { + return isTime(dtValue); + } else if (theType === 'datetime' || theType === 'timestamp') { + var tmstmp = false; + dtValue = dtValue.trim(); + if (dtValue === 'CURRENT_TIMESTAMP' || dtValue === 'current_timestamp()') { + return true; + } + if (theType === 'timestamp') { + tmstmp = true; + } + if (dtValue === '0000-00-00 00:00:00') { + return true; + } + var dv = dtValue.indexOf(' '); + if (dv === -1) { // Only the date component, which is valid + return isDate(dtValue, tmstmp); + } + + return isDate(dtValue.substring(0, dv), tmstmp) && + isTime(dtValue.substring(dv + 1)); + } + }); + /* + * message extending script must be run + * after initiation of functions + */ + extendingValidatorMessages(); + } + + $.datepicker.initialized = false; + + $(document).on('click', 'span.open_gis_editor', function (event) { + event.preventDefault(); + + var $span = $(this); + // Current value + var value = $span.parent('td').children('input[type=\'text\']').val(); + // Field name + var field = $span.parents('tr').children('td:first').find('input[type=\'hidden\']').val(); + // Column type + var type = $span.parents('tr').find('span.column_type').text(); + // Names of input field and null checkbox + var inputName = $span.parent('td').children('input[type=\'text\']').attr('name'); + + openGISEditor(); + if (!gisEditorLoaded) { + loadJSAndGISEditor(value, field, type, inputName); + } else { + loadGISEditor(value, field, type, inputName); + } + }); + + /** + * Forced validation check of fields + */ + $(document).on('click','input[name^=\'insert_ignore_\']', function () { + $('#insertForm').valid(); + }); + + /** + * Uncheck the null checkbox as geometry data is placed on the input field + */ + $(document).on('click', 'input[name=\'gis_data[save]\']', function () { + var inputName = $('form#gis_data_editor_form').find('input[name=\'input_name\']').val(); + var $nullCheckbox = $('input[name=\'' + inputName + '\']').parents('tr').find('.checkbox_null'); + $nullCheckbox.prop('checked', false); + }); + + /** + * Handles all current checkboxes for Null; this only takes care of the + * checkboxes on currently displayed rows as the rows generated by + * "Continue insertion" are handled in the "Continue insertion" code + * + */ + $(document).on('click', 'input.checkbox_null', function () { + nullify( + // use hidden fields populated by tbl_change.php + $(this).siblings('.nullify_code').val(), + $(this).closest('tr').find('input:hidden').first().val(), + $(this).siblings('.hashed_field').val(), + $(this).siblings('.multi_edit').val() + ); + }); + + /** + * Reset the auto_increment column to 0 when selecting any of the + * insert options in submit_type-dropdown. Only perform the reset + * when we are in edit-mode, and not in insert-mode(no previous value + * available). + */ + $('select[name="submit_type"]').on('change', function () { + var thisElemSubmitTypeVal = $(this).val(); + var $table = $('table.insertRowTable'); + var autoIncrementColumn = $table.find('input[name^="auto_increment"]'); + autoIncrementColumn.each(function () { + var $thisElemAIField = $(this); + var thisElemName = $thisElemAIField.attr('name'); + + var prevValueField = $table.find('input[name="' + thisElemName.replace('auto_increment', 'fields_prev') + '"]'); + var valueField = $table.find('input[name="' + thisElemName.replace('auto_increment', 'fields') + '"]'); + var previousValue = $(prevValueField).val(); + if (previousValue !== undefined) { + if (thisElemSubmitTypeVal === 'insert' + || thisElemSubmitTypeVal === 'insertignore' + || thisElemSubmitTypeVal === 'showinsert' + ) { + $(valueField).val(0); + } else { + $(valueField).val(previousValue); + } + } + }); + }); + + /** + * Handle ENTER key when press on Continue insert with field + */ + $('#insert_rows').on('keypress', function (e) { + var key = e.which; + if (key === 13) { + addNewContinueInsertionFiels(e); + } + }); + + /** + * Continue Insertion form + */ + $(document).on('change', '#insert_rows', addNewContinueInsertionFiels); +}); + +function addNewContinueInsertionFiels (event) { + event.preventDefault(); + /** + * @var columnCount Number of number of columns table has. + */ + var columnCount = $('table.insertRowTable:first').find('tr').has('input[name*=\'fields_name\']').length; + /** + * @var curr_rows Number of current insert rows already on page + */ + var currRows = $('table.insertRowTable').length; + /** + * @var target_rows Number of rows the user wants + */ + var targetRows = $('#insert_rows').val(); + + // remove all datepickers + $('input.datefield, input.datetimefield').each(function () { + $(this).datepicker('destroy'); + }); + + if (currRows < targetRows) { + var tempIncrementIndex = function () { + var $thisElement = $(this); + /** + * Extract the index from the name attribute for all input/select fields and increment it + * name is of format funcs[multi_edit][10][<long random string of alphanum chars>] + */ + + /** + * @var this_name String containing name of the input/select elements + */ + var thisName = $thisElement.attr('name'); + /** split {@link thisName} at [10], so we have the parts that can be concatenated later */ + var nameParts = thisName.split(/\[\d+\]/); + /** extract the [10] from {@link nameParts} */ + var oldRowIndexString = thisName.match(/\[\d+\]/)[0]; + /** extract 10 - had to split into two steps to accomodate double digits */ + var oldRowIndex = parseInt(oldRowIndexString.match(/\d+/)[0], 10); + + /** calculate next index i.e. 11 */ + newRowIndex = oldRowIndex + 1; + /** generate the new name i.e. funcs[multi_edit][11][foobarbaz] */ + var newName = nameParts[0] + '[' + newRowIndex + ']' + nameParts[1]; + + var hashedField = nameParts[1].match(/\[(.+)\]/)[1]; + $thisElement.attr('name', newName); + + /** If element is select[name*='funcs'], update id */ + if ($thisElement.is('select[name*=\'funcs\']')) { + var thisId = $thisElement.attr('id'); + var idParts = thisId.split(/_/); + var oldIdIndex = idParts[1]; + var prevSelectedValue = $('#field_' + oldIdIndex + '_1').val(); + var newIdIndex = parseInt(oldIdIndex) + columnCount; + var newId = 'field_' + newIdIndex + '_1'; + $thisElement.attr('id', newId); + $thisElement.find('option').filter(function () { + return $(this).text() === prevSelectedValue; + }).attr('selected','selected'); + + // If salt field is there then update its id. + var nextSaltInput = $thisElement.parent().next('td').next('td').find('input[name*=\'salt\']'); + if (nextSaltInput.length !== 0) { + nextSaltInput.attr('id', 'salt_' + newId); + } + } + + // handle input text fields and textareas + if ($thisElement.is('.textfield') || $thisElement.is('.char') || $thisElement.is('textarea')) { + // do not remove the 'value' attribute for ENUM columns + // special handling for radio fields after updating ids to unique - see below + if ($thisElement.closest('tr').find('span.column_type').html() !== 'enum') { + $thisElement.val($thisElement.closest('tr').find('span.default_value').html()); + } + $thisElement + .off('change') + // Remove onchange attribute that was placed + // by tbl_change.php; it refers to the wrong row index + .attr('onchange', null) + // Keep these values to be used when the element + // will change + .data('hashed_field', hashedField) + .data('new_row_index', newRowIndex) + .on('change', function () { + var $changedElement = $(this); + verificationsAfterFieldChange( + $changedElement.data('hashed_field'), + $changedElement.data('new_row_index'), + $changedElement.closest('tr').find('span.column_type').html() + ); + }); + } + + if ($thisElement.is('.checkbox_null')) { + $thisElement + // this event was bound earlier by jQuery but + // to the original row, not the cloned one, so unbind() + .off('click') + // Keep these values to be used when the element + // will be clicked + .data('hashed_field', hashedField) + .data('new_row_index', newRowIndex) + .on('click', function () { + var $changedElement = $(this); + nullify( + $changedElement.siblings('.nullify_code').val(), + $thisElement.closest('tr').find('input:hidden').first().val(), + $changedElement.data('hashed_field'), + '[multi_edit][' + $changedElement.data('new_row_index') + ']' + ); + }); + } + }; + + var tempReplaceAnchor = function () { + var $anchor = $(this); + var newValue = 'rownumber=' + newRowIndex; + // needs improvement in case something else inside + // the href contains this pattern + var newHref = $anchor.attr('href').replace(/rownumber=\d+/, newValue); + $anchor.attr('href', newHref); + }; + + while (currRows < targetRows) { + /** + * @var $last_row Object referring to the last row + */ + var $lastRow = $('#insertForm').find('.insertRowTable:last'); + + // need to access this at more than one level + // (also needs improvement because it should be calculated + // just once per cloned row, not once per column) + var newRowIndex = 0; + + // Clone the insert tables + $lastRow + .clone(true, true) + .insertBefore('#actions_panel') + .find('input[name*=multi_edit],select[name*=multi_edit],textarea[name*=multi_edit]') + .each(tempIncrementIndex) + .end() + .find('.foreign_values_anchor') + .each(tempReplaceAnchor); + + // Insert/Clone the ignore checkboxes + if (currRows === 1) { + $('<input id="insert_ignore_1" type="checkbox" name="insert_ignore_1" checked="checked">') + .insertBefore('table.insertRowTable:last') + .after('<label for="insert_ignore_1">' + Messages.strIgnore + '</label>'); + } else { + /** + * @var $last_checkbox Object reference to the last checkbox in #insertForm + */ + var $lastCheckbox = $('#insertForm').children('input:checkbox:last'); + + /** name of {@link $lastCheckbox} */ + var lastCheckboxName = $lastCheckbox.attr('name'); + /** index of {@link $lastCheckbox} */ + var lastCheckboxIndex = parseInt(lastCheckboxName.match(/\d+/), 10); + /** name of new {@link $lastCheckbox} */ + var newName = lastCheckboxName.replace(/\d+/, lastCheckboxIndex + 1); + + $('<br><div class="clearfloat"></div>') + .insertBefore('table.insertRowTable:last'); + + $lastCheckbox + .clone() + .attr({ 'id': newName, 'name': newName }) + .prop('checked', true) + .insertBefore('table.insertRowTable:last'); + + $('label[for^=insert_ignore]:last') + .clone() + .attr('for', newName) + .insertBefore('table.insertRowTable:last'); + + $('<br>') + .insertBefore('table.insertRowTable:last'); + } + currRows++; + } + // recompute tabindex for text fields and other controls at footer; + // IMO it's not really important to handle the tabindex for + // function and Null + var tabIndex = 0; + $('.textfield, .char, textarea') + .each(function () { + tabIndex++; + $(this).attr('tabindex', tabIndex); + // update the IDs of textfields to ensure that they are unique + $(this).attr('id', 'field_' + tabIndex + '_3'); + + // special handling for radio fields after updating ids to unique + if ($(this).closest('tr').find('span.column_type').html() === 'enum') { + if ($(this).val() === $(this).closest('tr').find('span.default_value').html()) { + $(this).prop('checked', true); + } else { + $(this).prop('checked', false); + } + } + }); + $('.control_at_footer') + .each(function () { + tabIndex++; + $(this).attr('tabindex', tabIndex); + }); + } else if (currRows > targetRows) { + /** + * Displays alert if data loss possible on decrease + * of rows. + */ + var checkLock = jQuery.isEmptyObject(AJAX.lockedTargets); + if (checkLock || confirm(Messages.strConfirmRowChange) === true) { + while (currRows > targetRows) { + $('input[id^=insert_ignore]:last') + .nextUntil('fieldset') + .addBack() + .remove(); + currRows--; + } + } else { + document.getElementById('insert_rows').value = currRows; + } + } + // Add all the required datepickers back + Functions.addDateTimePicker(); +} + +// eslint-disable-next-line no-unused-vars +function changeValueFieldType (elem, searchIndex) { + var fieldsValue = $('select#fieldID_' + searchIndex); + if (0 === fieldsValue.size()) { + return; + } + + var type = $(elem).val(); + if ('IN (...)' === type || + 'NOT IN (...)' === type || + 'BETWEEN' === type || + 'NOT BETWEEN' === type + ) { + $('#fieldID_' + searchIndex).attr('multiple', ''); + } else { + $('#fieldID_' + searchIndex).removeAttr('multiple'); + } +} |