Fix #4523 insert as new row submit type on multiple selected records does not set all AUTO_INCREMENTs to 0 value

Signed-off-by: Hugues Peccatte <hugues.peccatte@gmail.com>

1 files changed, 14 insertions, 6 deletions

diff --git a/js/tbl_change.js b/js/tbl_change.js
index b95efc48ef..bab668dbad 100644
--- a/js/tbl_change.js
+++ b/js/tbl_change.js
@@ -311,20 +311,28 @@ AJAX.registerOnload('tbl_change.js', function () {
      * available).
      */
     $('select[name="submit_type"]').bind('change', function (e) {
+        var $thisElemSubmitTypeField = $(this);
         var $table = $('table.insertRowTable');
-        var auto_increment_column = $table.find('input[name^="auto_increment"]').attr('name');
-        if (auto_increment_column) {
-            var prev_value_field = $table.find('input[name="' + auto_increment_column.replace('auto_increment', 'fields_prev') + '"]');
-            var value_field = $table.find('input[name="' + auto_increment_column.replace('auto_increment', 'fields') + '"]');
+        var auto_increment_column = $table.find('input[name^="auto_increment"]');
+        auto_increment_column.each(function () {
+            var $thisElemAIField = $(this);
+            var thisElemName = $thisElemAIField.attr('name');
+
+            var prev_value_field = $table.find('input[name="' + thisElemName.replace('auto_increment', 'fields_prev') + '"]');
+            var value_field = $table.find('input[name="' + thisElemName.replace('auto_increment', 'fields') + '"]');
             var previous_value = $(prev_value_field).val();
             if (previous_value !== undefined) {
-                if ($(this).val() == 'insert' || $(this).val() == 'insertignore' || $(this).val() == 'showinsert') {
+                if ($thisElemSubmitTypeField.val() == 'insert'
+                    || $thisElemSubmitTypeField.val() == 'insertignore'
+                    || $thisElemSubmitTypeField.val() == 'showinsert'
+                ) {
                     $(value_field).val(0);
                 } else {
                     $(value_field).val(previous_value);
                 }
             }
-        }
+        });
+
     });
 
     /**