central columns management page basic

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

central columns management page edit/delete

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

added column length to central columns table

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

fix edit issu

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

remove logging and alert statement

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

delete an entry fixed

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

col_length default to 0 + filter rows

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

fix menu tab test case

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

fix col_length datatype plus menu tst case fix

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

added cancel button

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

sprite regenerate for adding cntral columns icon

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

removing default value from col_length of type text

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

message format

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

search fix plus uitablfilter plugin modify to take elements to limit search to

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

refactoring db_cntral_columns.php plus file description in db_cntral_columns.js

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

added table sorting

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

fix js error for empty central columns

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

refactoring of code plus adding option to add a column to central list

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

removing trailing white spaces

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

handle condition if central list is empty

Signed-off-by: Smita Kumari <kumarismita62@gmail.com>

1 files changed, 142 insertions, 0 deletions

diff --git a/js/db_central_columns.js b/js/db_central_columns.js
new file mode 100644
index 0000000000..287a184ca3
--- /dev/null
+++ b/js/db_central_columns.js
@@ -0,0 +1,142 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * @fileoverview   events handling from central columns page
+ * @name            Central columns
+ *
+ * @requires    jQuery
+ */
+
+/**
+ * AJAX scripts for db_central_columns.php
+ *
+ * Actions ajaxified here:
+ * Inline Edit and save of a result row
+ * Delete a row
+ *
+ */
+
+AJAX.registerTeardown('db_central_columns.js', function () {
+    $(".edit").unbind('click');
+    $(".edit_save_form").unbind('click');
+    $('.edit_cancel_form').unbind('click');
+    $(".del_row").unbind('click');
+    $(".filter_rows").die("keyup");
+    $('.edit_cancel_form').unbind('click');
+    $('.column_heading').unbind('hover');
+    $('#table-select').unbind('change');
+    $('#column-select').unbind('change');
+});
+
+AJAX.registerOnload('db_central_columns.js', function () {
+    $('#tableslistcontainer input,#tableslistcontainer select').hide();
+    if ($('#table_columns tbody tr').length > 0) {
+        $("#table_columns").tablesorter();
+    }
+    $('.column_heading').hover(function(){
+        $(this).css("cursor","move");
+        PMA_tooltip(
+            $(this),
+            'th',
+            PMA_messages.strSortHint
+        );
+    });
+    $(".filter_rows").live("keyup", function () {
+        var cols = ["Name", "Type", "Length/Values", "Collation", "Null", "Extra", "Default"];
+        $.uiTableFilter($("#table_columns"), $(this).val(), cols, null, "td span");
+    });
+    $('.edit').click(function() {
+        rownum = $(this).parent().data('rownum');
+        $('#save_'+rownum).show();
+        $(this).hide();
+        $('#f_'+rownum+' td span').hide();
+        $('#f_'+rownum +' input, #f_'+rownum+' select').show();
+    });
+    $(".del_row").click(function() {
+        //alert('del')
+        rownum = $(this).data('rownum');
+        //alert($('#f_'+rownum +' input[name=col_name]').val());
+        $("#del_col_name").val($('#f_'+rownum +' input[name=col_name]').val());
+        $("#del_form").submit();
+    });
+    $('.edit_cancel_form').click(function(event) {
+        event.preventDefault();
+        event.stopPropagation();
+        rownum = $(this).data('rownum');
+        $('#save_'+rownum).hide();
+        $('#edit_'+rownum).show();
+        $('#f_'+rownum+' td span').show();
+        $('#f_'+rownum +' input, #f_'+rownum+' select').hide();
+    });
+    $('.edit_save_form').click(function(event) {
+        //alert(1);
+        event.preventDefault();
+        event.stopPropagation();
+        rownum = $(this).data('rownum');
+       // alert(rownum);
+        var datastring = $('#f_'+rownum+' :input').serialize();
+        //console.log(datastring);
+        $.ajax({
+            type: "POST",
+            url: "db_central_columns.php",
+            data: datastring+'&ajax_request=true',
+            dataType: "json",
+            success: function(data) {
+                if (data.message !== '1') {
+                    PMA_ajaxShowMessage(
+                        '<div class="error">' +
+                        data.message +
+                        '</div>',
+                        false
+                    );
+                } else {
+                    $('#f_'+rownum +' td[name=col_name] span').html($('#f_'+rownum +' input[name=col_name]').val());
+                    $('#f_'+rownum +' td[name=col_type] span').html($('#f_'+rownum +' select[name=col_type]').val());
+                    $('#f_'+rownum +' td[name=col_length] span').html($('#f_'+rownum +' input[name=col_length]').val());
+                    $('#f_'+rownum +' td[name=collation] span').html($('#f_'+rownum +' select[name=collation]').val());
+                    $('#f_'+rownum +' td[name=col_isNull] span').html($('#f_'+rownum +' input[name=col_isNull]').val());
+                    $('#f_'+rownum +' td[name=col_extra] span').html($('#f_'+rownum +' input[name=col_extra]').val());
+                    $('#f_'+rownum +' td[name=col_default] span').html($('#f_'+rownum +' input[name=col_default]').val());
+                }
+
+                $('#save_'+rownum).hide();
+                $('#edit_'+rownum).show();
+                $('#f_'+rownum+' td span').show();
+                $('#f_'+rownum +' input, #f_'+rownum+' select').hide();
+            },
+            error: function() {
+                    PMA_ajaxShowMessage(
+                        '<div class="error">' +
+                        PMA_messages.strErrorProcessingRequest +
+                        '</div>',
+                        false
+                    );
+                }
+        });
+    });
+    $('#table-select').change(function(e) {
+        var selectvalue = $(this).val();
+        var default_column_select = '<option value="" selected>Select a column</option>';
+        var href = "db_central_columns.php";
+        var params = {
+            'ajax_request' : true,
+            'token' : PMA_commonParams.get('token'),
+            'db' : PMA_commonParams.get('db'),
+            'selectedTable' : selectvalue,
+            'pupluateColumn' : true
+        };
+        $('#column-select').html('<option value="">Loading...</option>');
+
+        if (selectvalue !== "") {
+            $.post(href, params, function (data) {
+                $('#column-select').html(default_column_select);
+                $('#column-select').append(data.message);
+            });
+        }
+    });
+    $('#column-select').change(function(e) {
+        var selectvalue = $(this).val();
+        if (selectvalue !== "") {
+            $("#add_column").submit();
+        }
+    });
+});