201 lines
8.5 KiB
JavaScript
201 lines
8.5 KiB
JavaScript
/* 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');
|
|
$(document).off("keyup", ".filter_rows");
|
|
$('.edit_cancel_form').unbind('click');
|
|
$('#table-select').unbind('change');
|
|
$('#column-select').unbind('change');
|
|
$("#add_col_div>a").unbind('click');
|
|
$('#add_new').unbind('submit');
|
|
$("select.default_type").unbind('change');
|
|
});
|
|
|
|
AJAX.registerOnload('db_central_columns.js', function () {
|
|
$('#tableslistcontainer input,#tableslistcontainer select,.default_value,.open_enum_editor').hide();
|
|
if ($('#table_columns tbody tr').length > 0) {
|
|
$("#table_columns").tablesorter({
|
|
headers: {
|
|
0: {sorter: false},
|
|
1: {sorter: false}, // hidden column
|
|
4: {sorter: "integer"}
|
|
}
|
|
});
|
|
}
|
|
$('#add_new td').each(function(){
|
|
if ($(this).attr('name') !== 'undefined') {
|
|
$(this).find('input,select:first').attr('name', $(this).attr('name'));
|
|
}
|
|
});
|
|
$("#add_new #field_0_0").attr('required','required');
|
|
$('#add_new input[type="text"], #add_new input[type="number"], #add_new select')
|
|
.css({
|
|
'width' : '10em',
|
|
'-moz-box-sizing' : 'border-box'
|
|
});
|
|
window.scrollTo(0, 0);
|
|
$(document).on("keyup", ".filter_rows", function () {
|
|
// get the column names
|
|
var cols = $('th.column_heading').map(function () {
|
|
return $.trim($(this).text());
|
|
}).get();
|
|
$.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, #f_' + rownum + ' .open_enum_editor').show();
|
|
var extra_val = $('#f_' + rownum + ' td[name=col_extra] span').html();
|
|
var attribute_val = $('#f_' + rownum + ' td[name=col_attribute] span').html();
|
|
$('#f_' + rownum + ' select[name=field_attribute\\['+ rownum +'\\] ] option[value="' + attribute_val + '"]').attr("selected","selected");
|
|
$('#f_' + rownum + ' select[name=col_extra] option[value="' + extra_val + '"]').attr("selected","selected");
|
|
if($('#f_' + rownum + ' .default_type').val() === 'USER_DEFINED') {
|
|
$('#f_' + rownum + ' .default_type').siblings('.default_value').show();
|
|
} else {
|
|
$('#f_' + rownum + ' .default_type').siblings('.default_value').hide();
|
|
}
|
|
});
|
|
$(".del_row").click(function (event) {
|
|
event.preventDefault();
|
|
event.stopPropagation();
|
|
$td = $(this);
|
|
var question = PMA_messages.strDeleteCentralColumnWarning;
|
|
$td.PMA_confirm(question, null, function (url) {
|
|
rownum = $td.data('rownum');
|
|
$("#del_col_name").val($('#f_' + rownum + ' td[name=col_name] span').html());
|
|
$("#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,#f_'+rownum+' .default_value, #f_' + rownum + ' .open_enum_editor').hide();
|
|
});
|
|
$('.edit_save_form').click(function(event) {
|
|
//alert(1);
|
|
event.preventDefault();
|
|
event.stopPropagation();
|
|
rownum = $(this).data('rownum');
|
|
$('#f_' + rownum + ' td').each(function() {
|
|
if ($(this).attr('name') !== 'undefined') {
|
|
$(this).find(':input[type!="hidden"],select:first')
|
|
.attr('name', $(this).attr('name'));
|
|
}
|
|
});
|
|
if($('#f_' + rownum + ' .default_type').val() === 'USER_DEFINED') {
|
|
$('#f_' + rownum + ' .default_type').attr('name','col_default_sel');
|
|
} else {
|
|
$('#f_' + rownum + ' .default_value').attr('name','col_default_val');
|
|
}
|
|
// 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').text($('#f_' + rownum + ' input[name=col_name]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_type] span').text($('#f_' + rownum + ' select[name=col_type]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_length] span').text($('#f_' + rownum + ' input[name=col_length]').val()).html();
|
|
$('#f_' + rownum + ' td[name=collation] span').text($('#f_' + rownum + ' select[name=collation]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_attribute] span').text($('#f_' + rownum + ' select[name=col_attribute]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_isNull] span').text($('#f_' + rownum + ' input[name=col_isNull]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_extra] span').text($('#f_' + rownum + ' select[name=col_extra]').val()).html();
|
|
$('#f_' + rownum + ' td[name=col_default] span').text($('#f_' + rownum + ' :input[name=col_default]').val()).html();
|
|
}
|
|
$('#save_' + rownum).hide();
|
|
$('#edit_' + rownum).show();
|
|
$('#f_' + rownum + ' td span').show();
|
|
$('#f_' + rownum + ' input, #f_' + rownum + ' select,#f_' + rownum + ' .default_value, #f_' + rownum + ' .open_enum_editor').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 = $('#column-select option:first');
|
|
var href = "db_central_columns.php";
|
|
var params = {
|
|
'ajax_request' : true,
|
|
'token' : PMA_commonParams.get('token'),
|
|
'server' : PMA_commonParams.get('server'),
|
|
'db' : PMA_commonParams.get('db'),
|
|
'selectedTable' : selectvalue,
|
|
'populateColumns' : true
|
|
};
|
|
$('#column-select').html('<option value="">' + PMA_messages.strLoading + '</option>');
|
|
if (selectvalue !== "") {
|
|
$.post(href, params, function (data) {
|
|
$('#column-select').empty().append(default_column_select);
|
|
$('#column-select').append(data.message);
|
|
});
|
|
}
|
|
});
|
|
$('#column-select').change(function(e) {
|
|
var selectvalue = $(this).val();
|
|
if (selectvalue !== "") {
|
|
$("#add_column").submit();
|
|
}
|
|
});
|
|
$("#add_col_div>a").click(function(event){
|
|
$('#add_new').slideToggle("slow");
|
|
if($("#add_col_div>a span").html() === '+') {
|
|
$("#add_col_div>a span").html('-');
|
|
} else {
|
|
$("#add_col_div>a span").html('+');
|
|
}
|
|
});
|
|
$('#add_new').submit(function(event){
|
|
$('#add_new').toggle();
|
|
});
|
|
$("select.default_type").change(function () {
|
|
if ($(this).val() === 'USER_DEFINED') {
|
|
$(this).siblings('.default_value').attr('name','col_default');
|
|
$(this).attr('name','col_default_sel');
|
|
} else {
|
|
$(this).attr('name','col_default');
|
|
$(this).siblings('.default_value').attr('name','col_default_val');
|
|
}
|
|
});
|
|
});
|