dwh/js/sql_exec.js

var ajax = new sack();
var IE = document.all?true:false;
var curr_page;


function paramChanged() {
    document.getElementById("parameterlist").innerHTML = ajax.response;
    ajax.reset();
}

function showDetailForm(windowTitle) {
    DETAILDATAFORM.style.display = "block";
    DETAILDATAFORM.style.position = "absolute";
    document.getElementById("lov_title").innerHTML = windowTitle;
    if (IE) {
        leftPos = (screen.width/2) - (DETAILDATAFORM.offsetWidth/2);
        topPos = 120;
        DETAILDATAFORM.style.left =leftPos+"px";
        DETAILDATAFORM.style.top = topPos+"px";
    } else {
        DETAILDATAFORM.style.left = window.event.pageX+"px";
        DETAILDATAFORM.style.top = window.event.pageY+"px";
    }
}


function execute_report() {
    validate = validateForm(rep_param);
    if (validate == 1 ) {
        document.getElementById("message").style.display = 'block';
        document.getElementById("ACTION").value = 'rep';
        param = build_param(rep_param);
        curr_page = 1;
        var data="action=rep";
        data=data+"&param="+param;
        data=data+"&sid="+Math.random();
		alert(data);
        ajax.requestFile = 'sql_exec_ajax.php?'+data;
        ajax.onCompletion = repChanged;
        ajax.runAJAX();
    }
}

function repChanged(){
    document.getElementById("parameterlist").style.display ='none';
    document.getElementById("message").style.display ='none';
    document.getElementById("report_out").style.display ='block';
    document.getElementById("report_button").style.display ='block';
    document.getElementById("report_out").innerHTML = ajax.response;
    document.getElementById("CURR_PAGE").value = curr_page;
    ajax.reset();
}

function cancel_report() {
    document.getElementById("parameterlist").style.display = 'block';
    document.getElementById("report_out").style.display = 'none';
    document.getElementById("report_button").style.display ='none';
    if (document.getElementById("ACTION").value == 'rep') {
        location.reload(true);
    }
}

function print_report() {
    url = "./rep_print.php"
    childWindow=showModalDialog(url,window,"dialogHeight: 470px; dialogWidth: 670px; dialogTop: px; dialogLeft: px; edge: Raised; center: Yes; resizable: no; status: no")
}

function goFirst(rep_id) {
    var param = build_param(rep_param);
    curr_page = 1;
    curr_page = parseInt(curr_page);
    var total = document.getElementById("JUM_PAGE").value;
    var rows_page = document.getElementById("ROWS_PAGE").value;
    var data="action=get";
    data=data+"&rep_id="+rep_id;
    data=data+"&param="+param;
    data=data+"&page="+curr_page;
    data=data+"&rows_page="+rows_page;
    data=data+"&total="+total;
    data=data+"&sid="+Math.random();
    ajax.requestFile = 'sql_exec_ajax.php?'+data;
    ajax.onCompletion = repChanged;
    ajax.runAJAX();
}

function goPrev(rep_id) {
    var param = build_param(rep_param);
    curr_page = document.getElementById("CURR_PAGE").value;
    curr_page = parseInt(curr_page)-1;
    var total = document.getElementById("JUM_PAGE").value;
    var rows_page = document.getElementById("ROWS_PAGE").value;
    var data="action=get";
    data=data+"&rep_id="+rep_id;
    data=data+"&param="+param;
    data=data+"&page="+curr_page;
    data=data+"&rows_page="+rows_page;
    data=data+"&total="+total;
    data=data+"&sid="+Math.random();
    ajax.requestFile = 'sql_exec_ajax.php?'+data;
    ajax.onCompletion = repChanged;
    ajax.runAJAX();
}

function goNext(rep_id) {
    var param = build_param(rep_param);
    curr_page = document.getElementById("CURR_PAGE").value;
    curr_page = parseInt(curr_page)+1;
    var total = document.getElementById("JUM_PAGE").value;
    var rows_page = document.getElementById("ROWS_PAGE").value;
    var data="action=get";
    data=data+"&rep_id="+rep_id;
    data=data+"&param="+param;
    data=data+"&page="+curr_page;
    data=data+"&rows_page="+rows_page;
    data=data+"&total="+total;
    data=data+"&sid="+Math.random();
    ajax.requestFile = 'sql_exec_ajax.php?'+data;
    ajax.onCompletion = repChanged;
    ajax.runAJAX();
}

function goLast(rep_id) {
    var param = build_param(rep_param);
    curr_page = document.getElementById("JUM_PAGE").value;
    curr_page = parseInt(curr_page);
    var rows_page = document.getElementById("ROWS_PAGE").value;
    var data="action=get";
    data=data+"&rep_id="+rep_id;
    data=data+"&param="+param;
    data=data+"&page="+curr_page;
    data=data+"&rows_page="+rows_page;
    data=data+"&total="+curr_page;
    data=data+"&sid="+Math.random();
    ajax.requestFile = 'sql_exec_ajax.php?'+data;
    ajax.onCompletion = repChanged;
    ajax.runAJAX();
}