109 lines
3.2 KiB
JavaScript
109 lines
3.2 KiB
JavaScript
|
var table_tmpl;
|
||
|
|
var column_sc_tmpl;
|
||
|
|
|
||
|
|
jQuery(document).ready(function () {
|
||
|
|
|
||
|
|
|
||
|
|
table_tmpl = document.getElementById('table-tmpl').innerHTML;
|
||
|
|
Mustache.parse(table_tmpl);
|
||
|
|
|
||
|
|
column_sc_tmpl = document.getElementById('column-selection-tmpl').innerHTML;
|
||
|
|
Mustache.parse(column_sc_tmpl);
|
||
|
|
|
||
|
|
single_column_sc_tmpl = document.getElementById('single-column-selection-tmpl').innerHTML;
|
||
|
|
Mustache.parse(single_column_sc_tmpl);
|
||
|
|
|
||
|
|
jQuery('#save-options').change(function () {
|
||
|
|
var s = jQuery(this).val();
|
||
|
|
jQuery("[id^=w12_]").hide();
|
||
|
|
jQuery('#w12_' + s).show();
|
||
|
|
jQuery('#connection_id_' + s).val('');
|
||
|
|
openMappingBox(s);
|
||
|
|
});
|
||
|
|
|
||
|
|
jQuery('#create_table_1, #create_table_2').click(function () {
|
||
|
|
|
||
|
|
var settingsData = jQuery('#w0').serialize();
|
||
|
|
|
||
|
|
ajaxRequest('developer/formbuilder/form/create/table', 'post' ,'json', settingsData, function (html) {
|
||
|
|
if (html['status'] == 200) {
|
||
|
|
|
||
|
|
} else {
|
||
|
|
|
||
|
|
}
|
||
|
|
jQuery('#db_notify').html(html.msg);
|
||
|
|
})
|
||
|
|
});
|
||
|
|
|
||
|
|
jQuery('#connection_id_3').change(function () {
|
||
|
|
var value = jQuery(this).val();
|
||
|
|
//Metronic.startPageLoading();
|
||
|
|
ajaxRequest('db/just/table/' + value + '/true', 'get', 'json', {}, function (data) {
|
||
|
|
|
||
|
|
if (data['status'] == 200) {
|
||
|
|
|
||
|
|
jQuery('#table_name_3').html('');
|
||
|
|
jQuery('#table_name_3').append(Mustache.render(table_tmpl, data));
|
||
|
|
|
||
|
|
|
||
|
|
} else {
|
||
|
|
alert(data['error']);
|
||
|
|
}
|
||
|
|
//Metronic.stopPageLoading();
|
||
|
|
})
|
||
|
|
})
|
||
|
|
|
||
|
|
jQuery('#table_name_3').change(function () {
|
||
|
|
var value = jQuery(this).val();
|
||
|
|
var connection_id = jQuery('#connection_id_3').val();
|
||
|
|
|
||
|
|
var postdata = {
|
||
|
|
tables: value,
|
||
|
|
"data-source": connection_id
|
||
|
|
}
|
||
|
|
//Metronic.startPageLoading();
|
||
|
|
ajaxRequest('db/table/column', 'get', 'json', postdata, function (data) {
|
||
|
|
|
||
|
|
if (data['status'] == 200) {
|
||
|
|
jQuery('#column-sc').html(Mustache.render(column_sc_tmpl, {columns: data['columns'], fields: fields}));
|
||
|
|
|
||
|
|
if (save == 3) {
|
||
|
|
|
||
|
|
jQuery.each(mapping, function (key, data) {
|
||
|
|
jQuery('#col_' + key).val(data.COLUMN_NAME);
|
||
|
|
});
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
alert(data['error']);
|
||
|
|
}
|
||
|
|
|
||
|
|
//Metronic.stopPageLoading();
|
||
|
|
})
|
||
|
|
})
|
||
|
|
|
||
|
|
var s = jQuery('#save-options').val();
|
||
|
|
if ( s == 3) {
|
||
|
|
jQuery('#table_name_3').trigger("change");
|
||
|
|
}else if (s == 1 || s == 2){
|
||
|
|
openMappingBox(s);
|
||
|
|
}
|
||
|
|
|
||
|
|
jQuery('#create_table_3').click(function () {
|
||
|
|
|
||
|
|
var settingsData = jQuery('#w0').serialize();
|
||
|
|
ajaxRequest('developer/formbuilder/form/existing/table','post' ,'json', settingsData, function (html) {
|
||
|
|
console.log(html);
|
||
|
|
if (html['status'] == 200) {
|
||
|
|
} else {
|
||
|
|
}
|
||
|
|
jQuery('#db_notify').html(html.msg);
|
||
|
|
});
|
||
|
|
})
|
||
|
|
|
||
|
|
});
|
||
|
|
|
||
|
|
function openMappingBox(s) {
|
||
|
|
if (s == 1 || s == 2) {
|
||
|
|
jQuery('#w_12_' + s + '_column-sc').html(Mustache.render(single_column_sc_tmpl, {fields: fields, mapping: mapping}));
|
||
|
|
}
|
||
|
|
}
|