function SQL_autocomplete(obj) {
    var table = $(obj).attr('data-table');
    var key = $(obj).attr('data-key');
    var label = $(obj).attr('data-label');
    var search = $(obj).attr('data-search');
    var status = $(obj).attr('data-status');
    var keyword = $(obj).val();
    
    $(obj).parent('div').children('.sql-autocomplete-id').val('');
            
    $.post('/sqlinputs/ajax/all/',{
        table: table, 
        key: key, 
        label: label, 
        search: search, 
        status: status, 
        keyword: keyword
        },
        function(resp) {
            $(obj).parent('div').children('.sql-autocomplete-placeholder').html(resp);
            $(obj).parent('div').children('.sql-autocomplete-placeholder').show();
        }
    );
}


function SQL_autocomplete_hide(obj,sub) {
    var delay = setInterval(function() {
        if (sub==='code') {
            if ($('#product_code').val()==='') {
                $('#product_code').val($('#product_code_label').val());
            }
            else {
                get_product_data($('#product_code').val());
            }
        }
        
        $(obj).parent('div').children('.sql-autocomplete-placeholder').hide();
        clearInterval(delay);
    },200);
}


function SQL_autocomplete_update(obj) {
    var table = $(obj).attr('data-table');
    var key = $(obj).attr('data-key');
    var label = $(obj).attr('data-label');
    var search = $(obj).attr('data-search');
    var status = $(obj).attr('data-status');
    var keyword = $(obj).val();
    
    $(obj).parent('div').children('.sql-autocomplete-id').val('');
            
    $.post('/sqlinputs/ajax/search/',{
        table: table, 
        key: key, 
        label: label, 
        search: search, 
        status: status, 
        keyword: keyword
        },
        function(resp) {
            $(obj).parent('div').children('.sql-autocomplete-placeholder').html(resp);
            $(obj).parent('div').children('.sql-autocomplete-placeholder').show();
        }
    );
}


function SQL_autocomplete_select(obj) {
    var id = $(obj).attr('data-id');
    var label = $(obj).html();
    var action = $(obj).parent('ul').parent('div').parent('div').attr('data-change');
    var inp = $(obj).parent('ul').parent('div').parent('div').children('.sql-autocomplete');
    
    $(obj).parent('ul').parent('div').parent('div').children('.sql-autocomplete-id').val(id);
    $(obj).parent('ul').parent('div').parent('div').children('.sql-autocomplete').val(label);
    
    
    if ($(inp).attr('id')==='product_alapanyag_label') {
        if ($(inp).val()==='kovácsdarab' && $('#product_gyartas_mod').val()==='3') {
            $('#product_elokeszitesi_meret').attr('disabled','true');
        }
        else if ($('#product_gyartas_mod').val()==='3' || $(inp).val()==='kovácsdarab') {
            $('#product_elokeszitesi_meret').attr('disabled','true');
        }
        else if ($(inp).val()!=='kovácsdarab' && $('#product_gyartas_mod').val()!=='3') {
            $('#product_elokeszitesi_meret').removeAttr('disabled');
        }
    }

    if ($(inp).attr('id')==='product_gyartas_mod') {
        if ($(inp).val()==='kovácsdarab') {
            $('#product_elokeszitesi_meret').attr('disabled','true');
        }
        else {
            $('#product_elokeszitesi_meret').removeAttr('disabled');
        }
    }

    if (action==='set_size_options') {
        set_size_options(id);
    }
}