var xmlhttpa;
var xmlhttpb;
var xmlhttpc;
var xmlhttpd;
var xmlhttpe;

var xmlhttp;

var currentpageproduct=1;
var currentpagecategory=1;
var currentpagereview=1;
var currentpagecomment=1;
var currentpageuser=1;
var rowsperpage=10;
var count;
var pages;
var productsearchtxt="";
var categorysearchtxt="";
var usersearchtxt="";
var reviewsearchtxt="";
var commentsearchtxt="";

function GetXmlHttpObject()
{
    if (window.XMLHttpRequest)
    {
        // code for IE7+, Firefox, Chrome, Opera, Safari
        return new XMLHttpRequest();
    }
    if (window.ActiveXObject)
    {
        // code for IE6, IE5
        return new ActiveXObject("Microsoft.XMLHTTP");
    }
    return null;
}
function navigateProduct(field){
    currentpageproduct = field.innerHTML;
    getProduct();
}
function navigateCategory(field){
    currentpagecategory = field.innerHTML;
    getCategory();
}
function navigateReview(field){
    currentpagereview = field.innerHTML;
    getReview();
}
function navigateComment(field){
    currentpagecomment = field.innerHTML;
    getComment();
}
function navigateUser(field){
    currentpageuser = field.innerHTML;
    getUser();
}



function searchProduct()
{
    productsearchtxt=document.getElementById("txtProductSearch").value;
    getProduct();
}
function searchCategory()
{
    categorysearchtxt=document.getElementById("txtCategorySearch").value;
    getCategory();
}
function searchUser()
{
    usersearchtxt=document.getElementById("txtUserSearch").value;
    getUser();
}
function searchReview()
{
    reviewsearchtxt=document.getElementById("txtReviewSearch").value;
    getReview();
}
function searchComment()
{
    commentsearchtxt=document.getElementById("txtCommentSearch").value;
    getComment();
}

function enterprosearch(event)
{
    if(event.keyCode==13)
    {
        searchProduct();
    }
}

function entercatsearch(event)
{
    if(event.keyCode==13)
    {
        searchCategory();
    }
}

function enterusersearch(event)
{
    if(event.keyCode==13)
    {
        searchUser();
    }
}

function enterrevsearch(event)
{
    if(event.keyCode==13)
    {
        searchReview();
    }
}

function entercommsearch(event)
{
    if(event.keyCode==13)
    {
        searchComment();
    }
}

function resetSearchProduct()
{
    document.getElementById("txtProductSearch").value="";
    productsearchtxt="";
    getProduct();
}
function resetSearchCategory()
{
    document.getElementById("txtCategorySearch").value="";
    categorysearchtxt="";
    getCategory();
}
function resetSearchUser()
{
    document.getElementById("txtUserSearch").value="";
    usersearchtxt="";
    getUser();
}
function resetSearchReview()
{
    document.getElementById("txtReviewSearch").value="";
    reviewsearchtxt="";
    getReview();
}
function resetSearchComment()
{
    document.getElementById("txtCommentSearch").value="";
    commentsearchtxt="";
    getComment();
}


function getProduct()
{
    $("#loadingpanel").show();
    var limit=(currentpageproduct-1)*10;

    xmlhttpa=GetXmlHttpObject();
    if (xmlhttpa==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/table_product.php";
    parameters="field="+
    "&limit="+limit.toString()+
    "&order="+
    "&searchstring="+productsearchtxt;
    xmlhttpa.open("POST",url,true);
    xmlhttpa.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttpa.setRequestHeader("Content-length", parameters.length);
    xmlhttpa.setRequestHeader("Connection", "close");
    xmlhttpa.onreadystatechange=fillProduct;
    xmlhttpa.send(parameters);
}
function fillProduct()
{
    if (xmlhttpa.readyState==4)
    {
        $("#loadingpanel").hide();
        var div=document.getElementById("ProductTable");
        div.innerHTML=xmlhttpa.responseText;
    }
}
function getCategory()
{
    $("#loadingpanel").show();
    var limit=(currentpagecategory-1)*10;

    xmlhttpb=GetXmlHttpObject();
    if (xmlhttpb==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/table_category.php";
    parameters="field="+
    "&limit="+limit.toString()+
    "&order="+
    "&searchstring="+categorysearchtxt;
    xmlhttpb.open("POST",url,true);
    xmlhttpb.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttpb.setRequestHeader("Content-length", parameters.length);
    xmlhttpb.setRequestHeader("Connection", "close");
    xmlhttpb.onreadystatechange=fillCategory;
    xmlhttpb.send(parameters);
}
function fillCategory()
{
    if (xmlhttpb.readyState==4)
    {
        $("#loadingpanel").hide();
        var div=document.getElementById("CategoryTable");
        div.innerHTML=xmlhttpb.responseText;
    }
}
function getUser()
{
    $("#loadingpanel").show();
    var limit=(currentpageuser-1)*10;

    xmlhttpc=GetXmlHttpObject();
    if (xmlhttpc==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/table_user.php";
    parameters="field="+
    "&limit="+limit.toString()+
    "&order="+
    "&searchstring="+usersearchtxt;
    xmlhttpc.open("POST",url,true);
    xmlhttpc.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttpc.setRequestHeader("Content-length", parameters.length);
    xmlhttpc.setRequestHeader("Connection", "close");
    xmlhttpc.onreadystatechange=fillUser;
    xmlhttpc.send(parameters);
}
function fillUser()
{
    if (xmlhttpc.readyState==4)
    {
        $("#loadingpanel").hide();
        var div=document.getElementById("UserTable");
        div.innerHTML=xmlhttpc.responseText;
    }
}
function getReview()
{
    $("#loadingpanel").show();
    var limit=(currentpagereview-1)*10;

    xmlhttpd=GetXmlHttpObject();
    if (xmlhttpd==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/table_review.php";
    parameters="field="+
    "&limit="+limit.toString()+
    "&order="+
    "&searchstring="+reviewsearchtxt;
    xmlhttpd.open("POST",url,true);
    xmlhttpd.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttpd.setRequestHeader("Content-length", parameters.length);
    xmlhttpd.setRequestHeader("Connection", "close");
    xmlhttpd.onreadystatechange=fillReview;
    xmlhttpd.send(parameters);
}
function fillReview()
{
    if (xmlhttpd.readyState==4)
    {
        $("#loadingpanel").hide();
        var div=document.getElementById("ReviewTable");
        div.innerHTML=xmlhttpd.responseText;
    }
}
function getComment()
{
    $("#loadingpanel").show();
    var limit=(currentpagecomment-1)*10;

    xmlhttpe=GetXmlHttpObject();
    if (xmlhttpe==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/table_comment.php";
    parameters="field="+
    "&limit="+limit.toString()+
    "&order="+
    "&searchstring="+commentsearchtxt;
    xmlhttpe.open("POST",url,true);
    xmlhttpe.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttpe.setRequestHeader("Content-length", parameters.length);
    xmlhttpe.setRequestHeader("Connection", "close");
    xmlhttpe.onreadystatechange=fillComment;
    xmlhttpe.send(parameters);
}
function fillComment()
{
    if (xmlhttpe.readyState==4)
    {
        $("#loadingpanel").hide();
        var div=document.getElementById("CommentTable");
        div.innerHTML=xmlhttpe.responseText;
    }
}
function highlightPanelHeading(panel)
{
    var list=panel.parentNode;

    var listitems=list.getElementsByTagName("li");
    for(var i=0;i<listitems.length;i++)
    {
        listitems[i].style.cssText="background-color:white";
    }
    panel.style.cssText="background-color:#FFCCCC";
}
function showPanel(panel)
{
    var panelname=panel.innerHTML;
    panelname = panelname.replace(/^\s+|\s+$/g, '');
    //panel.style.cssText="background-color:";
    highlightPanelHeading(panel);
    $("#welcomepanel").hide();
    $("#productpanel").hide();
    $("#categorypanel").hide();
    $("#userpanel").hide();
    $("#reviewpanel").hide();
    $("#commentpanel").hide();
    switch(panelname)
    {
        case "Product":$("#productpanel").fadeIn(500);
            getProduct();
            break;
        case "Category":$("#categorypanel").fadeIn(500);
            getCategory();
            break;
        case "User":$("#userpanel").fadeIn(500);
            getUser();
            break;
        case "Review":$("#reviewpanel").fadeIn(500);
            getReview();
            break;
        case "Comment":$("#commentpanel").fadeIn(500);
            getComment();
            break;
    }
}
$(document).ready(function() {
    var width = $(this).width();
    var height = $(this).height();

    $("#panelbackground").css({
        top: 0,
        left: 0,
        height: height,
        width: width
    })
    $("#productedit").css({
        top: ((height / 2) - 200),
        left: ((width / 2) - 200)
    })
    $("#categoryedit").css({
        top: ((height / 2) - 200),
        left: ((width / 2) - 200)
    })
    $("#useredit").css({
        top: ((height / 2) - 200),
        left: ((width / 2) - 200)
    })
    $("#reviewedit").css({
        top: ((height / 2) - 200),
        left: ((width / 2) - 200)
    })
    $("#commentedit").css({
        top: ((height / 2) - 200),
        left: ((width / 2) - 200)
    })
    $("#loadingpanel").css({
        top: 10,
        left: ((width / 2) - 50)
    })

});
function showEditProduct(toggle)
{
    $("#panelbackground").fadeIn(500);
    $("#productedit").fadeIn(500);
    if(toggle=="edit")
    {
        getEditProduct();
    }
}
function hideEditProduct()
{
    $("#panelbackground").fadeOut(100);
    $("#productedit").fadeOut(100);
}
function showEditCategory(toggle)
{
    $("#panelbackground").fadeIn(500);
    $("#categoryedit").fadeIn(500);
    if(toggle=="edit")
    {
        getEditCategory();
    }
}
function hideEditCategory()
{
    $("#panelbackground").fadeOut(100);
    $("#categoryedit").fadeOut(100);
}
function showEditUser(toggle)
{
    $("#panelbackground").fadeIn(500);
    $("#useredit").fadeIn(500);
//    if(toggle=="edit")
//    {
//        getEditUser();
//    }
}
function hideEditUser()
{
    $("#panelbackground").fadeOut(100);
    $("#useredit").fadeOut(100);
}
function showEditReview(toggle)
{
    $("#panelbackground").fadeIn(500);
    $("#reviewedit").fadeIn(500);
    if(toggle=="edit")
    {
        getEditReview();
    }
}
function hideEditReview()
{
    $("#panelbackground").fadeOut(100);
    $("#reviewedit").fadeOut(100);
}
function showEditComment(toggle)
{
    $("#panelbackground").fadeIn(500);
    $("#commentedit").fadeIn(500);
    if(toggle=="edit")
    {
        getEditComment();
    }
}
function hideEditComment()
{
    $("#panelbackground").fadeOut(100);
    $("#commentedit").fadeOut(100);
}

function checkAll(field,toggle)
{
    if(toggle){
        for (i = 0; i < field.length; i++)
            field[i].checked = true ;
    }
    else{
        for (i = 0; i < field.length; i++)
            field[i].checked = false ;
    }
}

function uncheckAll(field)
{
    for (i = 0; i < field.length; i++)
        field[i].checked = false ;
}

function get_valueProduct(){

    var checkbox = document.getElementsByName("checkproduct");
    var j = 0;
    var temp = "";

    for(i = 0; i<checkbox.length; i++){
        if(checkbox[i].checked==true){
            temp = temp+checkbox[i].value+"_";
            j++;
        }
    }
    return temp;

}

function get_valueCategory(){

    var checkbox = document.getElementsByName("checkcategory");
    var j = 0;
    var temp = "";

    for(i = 0; i<checkbox.length; i++){
        if(checkbox[i].checked==true){
            temp = temp+checkbox[i].value+"_";
            j++;
        }
    }
    return temp;

}

function get_valueUser(){

    var checkbox = document.getElementsByName("checkuser");
    var j = 0;
    var temp = "";

    for(i = 0; i<checkbox.length; i++){
        if(checkbox[i].checked==true){
            temp = temp+checkbox[i].value+"_";
            j++;
        }
    }
    return temp;

}

function get_valueReview(){

    var checkbox = document.getElementsByName("checkreview");
    var j = 0;
    var temp = "";

    for(i = 0; i<checkbox.length; i++){
        if(checkbox[i].checked==true){
            temp = temp+checkbox[i].value+"_";
            j++;
        }
    }
    return temp;

}

function get_valueComment(){

    var checkbox = document.getElementsByName("checkcomment");
    var j = 0;
    var temp = "";

    for(i = 0; i<checkbox.length; i++){
        if(checkbox[i].checked==true){
            temp = temp+checkbox[i].value+"_";
            j++;
        }
    }
    return temp;

}

function getEditProduct(){
    var value = get_valueProduct();
    var id = value.split("_");
    if(id.length == 2){
        xmlhttp=GetXmlHttpObject();
        $("#loadingpanel").show();
        if (xmlhttp==null)
        {
            alert ("Your browser does not support XMLHTTP!");
            return;
        }
        var url="/admin/edit_product.php";
        url=url+"?q="+id[0];
        url=url+"&sid="+Math.random();
        xmlhttp.onreadystatechange=fillEditProduct;
        xmlhttp.open("GET",url,true);
        xmlhttp.send(null);
    }
    else{
        alert('Select One User For Editing');
        $("#panelbackground").hide();
        $("#productedit").hide();
    }
}
function fillEditProduct()
{
    if (xmlhttp.readyState==4)
    {
        $("#loadingpanel").hide();
        document.getElementById("producteditform").innerHTML=xmlhttp.responseText;
    }
}
function getEditCategory(){

    var value = get_valueCategory();
    var id = value.split("_");
    if(id.length == 2){
        xmlhttp=GetXmlHttpObject();
        $("#loadingpanel").show();
        if (xmlhttp==null)
        {
            alert ("Your browser does not support XMLHTTP!");
            return;
        }
        var url="/admin/edit_category.php";
        url=url+"?q="+id[0];
        url=url+"&sid="+Math.random();
        xmlhttp.onreadystatechange=fillEditCategory;
        xmlhttp.open("GET",url,true);
        xmlhttp.send(null);
    }
    else{
        alert('Select One User For Editing');
        $("#panelbackground").hide();
        $("#categoryedit").hide();
    }
}
function fillEditCategory()
{
    if (xmlhttp.readyState==4)
    {
        $("#loadingpanel").hide();
        document.getElementById("categoryeditform").innerHTML=xmlhttp.responseText;
    }
}
function getEditReview(){

    var value = get_valueReview();
    var id = value.split("_");
    if(id.length == 2){
        xmlhttp=GetXmlHttpObject();
        $("#loadingpanel").show();
        if (xmlhttp==null)
        {
            alert ("Your browser does not support XMLHTTP!");
            return;
        }
        var url="/admin/edit_review.php";
        url=url+"?q="+id[0];
        url=url+"&sid="+Math.random();
        xmlhttp.onreadystatechange=fillEditReview;
        xmlhttp.open("GET",url,true);
        xmlhttp.send(null);
    }
    else{
        alert('Select One User For Editing');
        $("#panelbackground").hide();
        $("#reviewedit").hide();
    }

}
function fillEditReview()
{
    if (xmlhttp.readyState==4)
    {
        $("#loadingpanel").hide();
        document.getElementById("revieweditform").innerHTML=xmlhttp.responseText;
    }
}
function getEditComment(){

    var value = get_valueComment();
    var id = value.split("_");
    if(id.length == 2){
        xmlhttp=GetXmlHttpObject();
        $("#loadingpanel").show();
        if (xmlhttp==null)
        {
            alert ("Your browser does not support XMLHTTP!");
            return;
        }
        var url="/admin/edit_comment.php";
        url=url+"?q="+id[0];
        url=url+"&sid="+Math.random();
        xmlhttp.onreadystatechange=fillEditComment;
        xmlhttp.open("GET",url,true);
        xmlhttp.send(null);
    }
    else{
        alert('Select One User For Editing');
        $("#panelbackground").hide();
        $("#commentedit").hide();
    }
}
function fillEditComment()
{
    if (xmlhttp.readyState==4)
    {
        $("#loadingpanel").hide();
        document.getElementById("commenteditform").innerHTML=xmlhttp.responseText;
    }
}
function delproduct(){

    var value = get_valueProduct();
    var id = value.split("_");
    if(id.length >= 2){
        var num =id.length-1;
        var answer = confirm("Do you really want to DELETE "+num+" Record(s)?")
        if(answer){
            xmlhttp = GetXmlHttpObject();
            if (xmlhttp==null)
            {
                alert ("Your browser does not support XMLHTTP!");
                return;
            }
            xmlhttp.onreadystatechange=function()
            {

                if (xmlhttp.readyState==4)
                {
                    var num = xmlhttp.responseText;
                    alert("Deleted "+num+" Record(s)");
                }
            }
            var url = "delete_product.php?id="+value;
            url=url+"&sid="+Math.random();
            xmlhttp.open("GET",url,true);
            xmlhttp.send(null);
        }
    }
    else{
        alert('Select Atleast One User For Deleting');
    }
    getProduct();
}
function delcategory(){

    var value = get_valueCategory();
    var id = value.split("_");
    if(id.length >= 2){
        var num =id.length-1;
        var answer = confirm("Do you really want to DELETE "+num+" Record(s)?")
        if(answer){
            xmlhttp = GetXmlHttpObject();
            if (xmlhttp==null)
            {
                alert ("Your browser does not support XMLHTTP!");
                return;
            }
            xmlhttp.onreadystatechange=function()
            {

                if (xmlhttp.readyState==4)
                {
                    var num = xmlhttp.responseText;
                    if(num ==""){
                        alert("Deleted");
                    }else{
                        alert("Can not delete parent categories : "+num);
                    }
                   
                }
            }
            var url = "delete_category.php?id="+value;
            url=url+"&sid="+Math.random();
            xmlhttp.open("GET",url,true);
            xmlhttp.send(null);
        }
    }
    else{
        alert('Select Atleast One User For Deleting');
    }
    getCategory();
}

function deluser(){

    var value = get_valueUser();
    var id = value.split("_");
    if(id.length >= 2){
        var num =id.length-1;
        var answer = confirm("Do you really want to DELETE "+num+" Record(s)?")
        if(answer){
            xmlhttp = GetXmlHttpObject();
            if (xmlhttp==null)
            {
                alert ("Your browser does not support XMLHTTP!");
                return;
            }
            xmlhttp.onreadystatechange=function()
            {

                if (xmlhttp.readyState==4)
                {
                    var num = xmlhttp.responseText;
                    alert("Deleted "+num+" Record(s)");
                }
            }
            var url = "delete_user.php?id="+value;
            url=url+"&sid="+Math.random();
            xmlhttp.open("GET",url,true);
            xmlhttp.send(null);
        }
    }
    else{
        alert('Select Atleast One User For Deleting');
    }
    getUser();
}

function delreview(){

    var value = get_valueReview();
    var id = value.split("_");
    if(id.length >= 2){
        var num =id.length-1;
        var answer = confirm("Do you really want to DELETE "+num+" Record(s)?")
        if(answer){
            xmlhttp = GetXmlHttpObject();
            if (xmlhttp==null)
            {
                alert ("Your browser does not support XMLHTTP!");
                return;
            }
            xmlhttp.onreadystatechange=function()
            {

                if (xmlhttp.readyState==4)
                {
                    var num = xmlhttp.responseText;
                    alert("Deleted "+num+" Records");
                }
            }
            var url = "delete_review.php?id="+value;
            url=url+"&sid="+Math.random();
            xmlhttp.open("GET",url,true);
            xmlhttp.send(null);
        }
    }
    else{
        alert('Select Atleast One User For Deleting');
    }
    getReview();
}

function delcomment(){

    var value = get_valueComment();
    var id = value.split("_");
    if(id.length >= 2){
        var num =id.length-1;
        var answer = confirm("Do you really want to DELETE "+num+" Record(s)?")
        if(answer){
            xmlhttp = GetXmlHttpObject();
            if (xmlhttp==null)
            {
                alert ("Your browser does not support XMLHTTP!");
                return;
            }
            xmlhttp.onreadystatechange=function()
            {

                if (xmlhttp.readyState==4)
                {
                    var num = xmlhttp.responseText;
                    alert("Deleted "+num+" Records");
                }
            }
            var url = "delete_comment.php?id="+value;
            url=url+"&sid="+Math.random();
            xmlhttp.open("GET",url,true);
            xmlhttp.send(null);
        }
    }
    else{
        alert('Select Atleast One User For Deleting');
    }
    getComment();
}

function approveComment(comment)
{
    var id = comment.id.split("_");
    var commentid=id[1];
    xmlhttp = GetXmlHttpObject();
    if (xmlhttp==null)
    {
        alert ("Your browser does not support XMLHTTP!");
        return;
    }
    xmlhttp.onreadystatechange=function()
    {

        if (xmlhttp.readyState==4)
        {
            var status = xmlhttp.responseText;
            alert(status);
        }
    }
    var url = "approve_comment.php?id="+commentid;
    url=url+"&sid="+Math.random();
    xmlhttp.open("GET",url,true);
    xmlhttp.send(null);
    getComment();
}
/*function addProduct()
{
    var name=document.getElementById("txtProductName").value;
    var categoryid=document.getElementById("sltProductCategory").options[document.getElementById("sltProductCategory").selectedIndex].value;
    var image=document.getElementById("fileProductImage").value;
    var description=document.getElementById("txtProductDescription").value;
    xmlhttp=GetXmlHttpObject();
    if (xmlhttp==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/addproduct.php";
    parameters="productname="+name+
    "&categoryid="+categoryid+
    "&description="+description+
    "&image="+image;
    xmlhttp.open("POST",url,true);
    xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttp.setRequestHeader("Content-length", parameters.length);
    xmlhttp.setRequestHeader("Connection", "close");
    xmlhttp.onreadystatechange=function()
    {
        if (xmlhttp.readyState==4)
        {
            var status = xmlhttp.responseText;
            alert(status);
        }
    };
    xmlhttp.send(parameters);
}*/

function addCategory()
{
    var name=document.getElementById("txtCategoryName").value;
    var categoryid=document.getElementById("sltparentCategory").options[document.getElementById("sltparentCategory").selectedIndex].value;
    var description=document.getElementById("txtCategoryDescription").value;
    xmlhttp=GetXmlHttpObject();
    if (xmlhttp==null)
    {
        alert ("Your browser does not support xmlhttp!");
        return;
    }
    var url="/admin/addcategory.php";
    parameters="categoryname="+name+
    "&parentcategoryid="+categoryid+
    "&description="+description;
    
    xmlhttp.open("POST",url,true);
    xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    xmlhttp.setRequestHeader("Content-length", parameters.length);
    xmlhttp.setRequestHeader("Connection", "close");
    xmlhttp.onreadystatechange=function()
    {
        if (xmlhttp.readyState==4)
        {
            var status = xmlhttp.responseText;
            alert(status);
        }
    };
    xmlhttp.send(parameters);
    getCategory();
}