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}));
    }
}