var Partidas = new Array();
var total = 0.0;
var claveadd_id = 0;
var db;
var request;

function sellsingle() {



    $('sendButton').text('Sending request');
    var prodId   = $('#prodtb').val();
    var clientid = $('#clienttb').val();

    var queryString =
        endpoint + '/sellsingle.ashx?prod=' + prodId + '&client=' + clientid + '&format=json';

    $.getJSON(queryString, function (results) {
        showSellSingleResults(results);
    }
    ).fail(function (jqXHR) {
        setStatLabel("danger", "Un error ocurrió")
    })

return false;

}

function showSellSingleResults(results) {
    var vta = results.VENTA;
    $("#statuslabel").removeAttr ("class");
    $('#statuslabel').text('Venta ' + vta + ' hecha');
}

function populateSearch(results) {

    var endpoint = localStorage.getItem("endpoint");
    var term = $('#searchProdText').val();

    if (term.length > 0) {
        var url =
        endpoint + '/search.ashx?q=contains&c=' + term;

        $('#prodSearch ul').empty();

        $.getJSON(url, function (results) {
            for (i = 0; i < results.length; i++) {
                addToProdList(results[i]);
            }
        }
        ).fail(function (jqXHR) {
            setStatLabel("danger", "Un error ocurrió")
        });

    }else{
        setStatLabel("warning", 'Escribe un articulo para buscar')
    }


}

function searchClient(){
    var endpoint = localStorage.getItem("endpoint");
    var term = $('#searchClientText').val();

    if (term.length > 0)
    {
        var url =
        endpoint + '/searchclient.ashx?c=' + term;

        $('#clientSearch ul').empty();

        $.getJSON(url, function (results) {
            for (i = 0; i < results.length; i++) {
            addToClientList(results[i]);
            }
        }
        ).fail(function (jqXHR) {
            setStatLabel("danger", 'Un error ocurrió');
        });
    }else{
       setStatLabel("warning", 'Escribe un cliente para buscar');
    }

}

function addToClientList(result){
    $('#clientSearch ul').append(
         '<li class="list-group-item" id="' +
          result.cliente +  '">' +
          result.nombre + '</li>');



     $(document).on('click', '#' + result.cliente,
     function(){
         $('#clienttb').val(result.cliente);
         $('#searchClientModal').modal('hide');
     } );
}

function addToProdList(item)
{


     $('#prodSearch ul').append(
         '<li class="list-group-item" id="' +
          item.ARTICULO +  '">' +
          item.DESCRIP + '</li>');


     $(document).on('click', '#' + item.ARTICULO,
     function(){

         //Deselecciona las lineas de abajo para agregar el articulo directamente
         //window.alert(item.PRECIO);
         //$('#prodtb').val(item.ARTICULO);
         //$('#pricetb').val(item.PRECIO);
         $('#searchProdModal').modal('hide');

         // Selecciona la linea de abajo para agregar el articulo directamente
         selectclaveadd2(item.ARTICULO);
     } );

}

function addProd(results) {
    var endpoint = localStorage.getItem("endpoint");

    var prodId = $('#prodtb').val();

    var queryString = endpoint +  '/prods.ashx?single=true&p=' + prodId;

    var prod = $.getJSON(queryString, function (results) {
        // edit here, result will be an array with multiple product presentations
        instanceProd(results);
    }).fail(function (jqXHR) {
        setStatLabel("danger", "algo fallo :()")
    });


}

function statCheck2(){
    //window.alert("intentando conexión")
    setStatLabel("info", "intentando conexion");


    var endpoint = localStorage.getItem("endpoint");

    var url = endpoint + '/dbstatus.ashx';

    var stat = $.getJSON(url, function(result){
        if (result.exists == true){

    $('#addButton'         ).unbind('click').click(addProd          );    // Add prod to prods to be sent
    $('#terminateButton'   ).unbind('click').click(terminateSell    );    // terminate sell on click
    $('#searchProdButton'  ).unbind('click').click(populateSearch   );    // On search prod click

            setStatLabel("success", "Sistema cargado y listo");
        }else{
            setStatLabel("danger", "No se pudo conectar a la base de datos");
        }
    }).error(function(jqXHR, textStatus, errorThrown){
        $('#addButton'         ).unbind('click').click(addProdOffline       );    // Add prod to prods to be sent
        $('#terminateButton'   ).unbind('click').click(insertPendingSell    );
        $('#searchProdButton'  ).unbind('click').click(searchProdOffline    );

        setStatLabel("danger", "No se pudo conectar al servidor: " + textStatus);
    });
}

function instanceProd2(results){
    var price = $('#pricetb').val();

    var newP = {
        Precio: price,
        Cantidad: 1,
        Impuesto: 0,
        Costo: results.ARTICULO.COSTO,
        Articulo: results.ARTICULO.ARTICULO}

        Partidas.push(newP);

        total = total + newP.Precio;

        $("#statuslabel").removeAttr ("class"                                                            );
        $('#statuslabel').addClass   ("alert alert alert-success"                                        );
        $('#statuslabel').text       ('Articulo agregado, total: ' + total                               );
        $('#prods ul'   ).append     ('<li class="list-group-item">' + results.ARTICULO.DESCRIP + '</li>' );
}

function instanceProd(results) {
    var price = $('#pricetb').val();
    if (results.clavesadd.length > 0)
    {
        selectclaveadd(results.clavesadd, results.ARTICULO);
    }else{
        var newP = {
        Precio: price,
        Cantidad: 1,
        Impuesto: 0,
        Costo: results.ARTICULO.COSTO,
        Articulo: results.ARTICULO.ARTICULO
    };
    Partidas.push(newP);

    total = total + newP.Precio;

    $("#statuslabel").removeAttr ("class"                                                            );
    $('#statuslabel').addClass   ("alert alert alert-success"                                        );
    $('#statuslabel').text       ('Articulo agregado, total: ' + total                               );
    $('#prods ul'   ).append     ('<li class="list-group-item">' + results.ARTICULO.DESCRIP + '</li>' );
    }
}

function selectclaveadd2(art){
    // url del articulo
        var endpoint = localStorage.getItem("endpoint");
        var url = endpoint +  '/prods.ashx?single=true&p=' + art;


        $.getJSON(url, function (results) {
            if (results.clavesadd.length > 0){
                selectclaveadd(results.clavesadd, results.ARTICULO)
            }else{
                instanceProd2(results)
            }

        }
        ).fail(function (jqXHR) {
            setStatLabel("danger", 'Un error ocurrió');
        });



}

function selectclaveadd(data, art){
    $('#presList ul').empty();
    $('#clavesaddModal').modal('show');
    //$('#presList ul').append('<li>' + data[0].Dato1 + '</li>')

    for (i = 0; i < data.length; i++) {

        var item = data[i];


        var displayText = item.Clave + '(' + item.Precio + ')';

        $('#presList ul').append(
            '<li class="list-group-item" id="' +
            item.Clave +  '">' +
            displayText+ '</li>');

        //$('#presList ul').append('<li class="list-group-item">' + item.Dato1 +'</li>');


        $("#presList ul").unbind('click').on('click', '#' + item.Clave,
            function(){
                var newP = {
                    Precio: item.Precio,
                    Cantidad: 1,
                    Impuesto: 0,
                    Costo: art.COSTO,
                    Articulo: art.ARTICULO
                };
                Partidas.push(newP);

                total = total + newP.Precio;

                $("#statuslabel"    ).removeAttr ("class"                                                    );
                $('#statuslabel'    ).addClass   ("alert alert alert-success"                                );
                $('#statuslabel'    ).text       ('Articulo agregado, total: ' + total                       );
                $('#prods ul'       ).append     ('<li class="list-group-item">' + art.DESCRIP + '</li>'     );
                $('#clavesaddModal' ).modal      ('hide'                                                     );
        } // function
        ); // on click

    } // for



} //selectclaveadd

function terminateSell() {
   var clientid = $('#clienttb').val();

   if (Partidas.length > 0 && clientid.length > 0){
       var endoint = localStorage.getItem("endpoint");


       var ob = { "ClientId": clientid, "Partidas": Partidas };

       var data = JSON.stringify(ob);

       var url = endoint + '//makesell.ashx';

       $.ajax({
            type: "POST",
            data: data,
            url: url,
            contentType: "application/json",
            dataType: 'json'
       }).done(function (res) {
            setStatLabel("success", "Venta hecha")
            console.log('res', res);
            // Do something with the result :)
       });

   $('#prods ul').empty();
   Partidas = [];
   total = 0;
   }

}

function showTerminateSellResults(data, status) {
    $('#statuslabel').text(status);
}

function saveUser(){
    var user = $('#usertb').val();
    var password = $('#passwordtb').val();

    var endpoint = localStorage.getItem("endpoint");

    var url = endpoint + '/login.ashx?user=' + user + '&password=' + password;

     $.getJSON(url, function (results) {
        if (results.success = true){
            localStorage.setItem("user", user);

            var message = 'Iniciaste sesión como ' + user
            setStatLabel("success", message);
            $('#configModal').modal('hide');
        }else{
            setStatLabel("warning", 'Usuario o contraseñas incorrectos');
            $('#configModal').modal('hide');
        }
    }
    ).fail(function (jqXHR) {
        setStatLabel("danger", "Ocurrió un error al iniciar sesión :()")
    });

}

function setStatLabel(style, value){
    $("#statuslabel").removeAttr ("class");

    switch (style){

        case "info":
        $("#statuslabel").addClass("alert alert-info");
        break;

        case "success":
        $("#statuslabel").addClass("alert alert-success");
        break;

        case "danger":
        $("#statuslabel").addClass("alert alert-danger");
        break;

        case "warning":
        $("#statuslabel").addClass("alert alert-warning");
        break;

        default:
        $("#statuslabel").addClass("alert alert-info");
        break;
    }

    $("#statuslabel").text(value);
}

function generateClaveAddId(){
    claveadd_id += 1;

}

function opendb(){
    window.indexedDB = window.indexedDB || window.mozIndexedDB || window.webkitIndexedDB || window.msIndexedDB;


    window.IDBTransaction = window.IDBTransaction || window.webkitIDBTransaction || window.msIDBTransaction;

    window.IDBKeyRange = window.IDBKeyRange || window.webkitIDBKeyRange || window.msIDBKeyRange;

    if (!window.indexedDB) {
        window.alert("Your browser doesn't support a stable version of IndexedDB.");
    }else{
        //window.alert("Listo para conectarse");
    }


    var request = window.indexedDB.open("mbptest5", 1);

    request.onerror = function(event) {
        console.log("error: ");
    };

    request.onsuccess = function(event) {
        db = request.result;
        console.log("success: "+ db);
    };

    request.onupgradeneeded = function(event) {
        db = event.target.result;
        var prodStore = db.createObjectStore("prods", {keyPath: "ARTICULO"});
        var sellStore = db.createObjectStore("ventas", {keyPath: "id", autoIncrement: true});



    }
}

function syncdb(){

    setStatLabel("info", "Sincronizando bases de datos");
    var endpoint = localStorage.getItem("endpoint");

    var url = endpoint + "/prods.ashx?take=5000"


    $.getJSON(url, function (results) {
        var count = 0;

        for (count = 0; count < results.length; count++){
            var item = results[count];

            var request = db.transaction('prods', "readwrite")
                .objectStore("prods")
                .add(item);

            request.onsuccess = function(event) {
                console.log(item.DESCRIP + " agregado");
                setStatLabel("info", item.DESCRIP + " agregado");
            };

            request.onerror = function(event) {

                var request = db.transaction('prods', "readwrite")
                .objectStore("prods")
                .put(item);

                console.log(item.DESCRIP + " actualizado");
                setStatLabel("info", item.DESCRIP + " actualizado");

            }

        } // for

        //setStatLabel("success", "Bases de datos sincronizadas con exito");

    }// function
    ).fail(function (jqXHR) {
        window.alert("Error al descargar información del servidor :()")
    }).done(function(){
        setStatLabel("success", "Bases de datos sincronizadas con exito");
    }).complete(function(){
        setStatLabel("success", "Bases de datos sincronizadas con exito");
    });

} //syncdb

//offline functions

function searchProdOffline()
{
    var key = $('#searchProdText').val();
    var data = read(key);
    if (data){
        $('#prodtb').val(data.DESCRIP);
    }
}

function addProdOffline(){
    var transaction = db.transaction(["prods"]);
   var objectStore = transaction.objectStore("prods");
   var key = $('#prodtb').val();
   var request = objectStore.get(key);

   request.onerror = function(event) {
      setStatLabel("danger", "no se pudo extraer información de la base de datos");
   };

   request.onsuccess = function(event) {
      if(request.result) {

         instanceProdOffline(request.result);

      }

      else {
         setStatLabel("danger", "no se pudo extraer información de la base de datos");
      }
   };
}

function instanceProdOffline(prod){
    var price = parseInt($('#pricetb').val());
    //if (results.clavesadd.length > 0)
    //{
        //selectclaveadd(results.clavesadd, results.ARTICULO);
    //}else{
        var newP = {
        Precio: price,
        Cantidad: 1,
        Impuesto: 0,
        Costo: 0,
        Articulo: prod.ARTICULO
    };
    Partidas.push(newP);

    total = total + newP.Precio;

    $("#statuslabel").removeAttr ("class"                                                            );
    $('#statuslabel').addClass   ("alert alert alert-success"                                        );
    $('#statuslabel').text       ('Articulo agregado, total: ' + total                               );
    $('#prods ul'   ).append     ('<li class="list-group-item">' + prod.DESCRIP + '</li>'            );
    //}
}

function read(key) {
   var transaction = db.transaction(["prods"]);
   var objectStore = transaction.objectStore("prods");
   var request = objectStore.get(key);

   request.onerror = function(event) {
      setStatLabel("danger", "no se pudo extraer información de la base de datos");
   };

   request.onsuccess = function(event) {
      if(request.result) {
         //window.alert(request.result);
         $('#prodtb').val(request.result.ARTICULO);
      }

      else {
         setStatLabel("danger", "no se pudo extraer información de la base de datos");
      }
   };
}

function insertPendingSell(){

    var d = new Date();
    var fecha = d.toLocaleDateString();
    var CANTIDAD = $('#qtytb').val();
    var cliente = $('#clienttb').val();
    var qty = $('#qtytb').val()

    var newvta = {PRECIO: total, CLIENTE: cliente, USUFECHA: fecha, cantidad: qty, PARTIDAS: Partidas};



    var request = db.transaction('ventas', "readwrite")
        .objectStore("ventas")
        .add(newvta);

    request.onsuccess = function(event) {
        console.log("Venta agregada a pendientes");
        setStatLabel("sucess", "Venta agregada a pendientes");
    };


}

function getPendingSales(callback){
    var trans = db.transaction("ventas", "readwrite");
    var store = trans.objectStore("ventas");
    var items = [];

    trans.oncomplete = function(evt) {
        callback(items);
    };

    var cursorRequest = store.openCursor();

    cursorRequest.onerror = function(error) {
        console.log(error);
    };

    cursorRequest.onsuccess = function(evt) {
        var cursor = evt.target.result;
        if (cursor) {
            items.push(cursor.value);
            cursor.continue();
        }
    };
}

function renderPendingSales(){
    getPendingSales(function(items){
        var c = 0;
        var l = items.length;

        for (c = 0; c < l; c++){
            var item = items[c];
            var div = $('<div class="list-group-item"></div>')
            var span = '<span>' + "venta: " + item.id + ", importe: " + item.PRECIO + '<span>';
            var button = $('<button>Enviar a MyBusiness</button>').click(
                function(){
                    //window.alert(item.id);
                    terminateSell2(item);
                }
            )

            div.append(span);
            div.append(button);

            $('#pendingSalesList ul').append(div);

        }

    })
}

function terminateSell2(item) {

   var clientid = $('#clienttb').val();

   if (clientid.length > 0){
       var endpoint = localStorage.getItem("endpoint");


       var ob = { "ClientId": item.CLIENTE, "Partidas": item.PARTIDAS };

       var data = JSON.stringify(ob);

       var url = endpoint + '//makesell.ashx';

       $.ajax({
            type: "POST",
            data: data,
            url: url,
            contentType: "application/json",
            dataType: 'json'
       }).done(function (res) {
           console.log("i'm going to remove entry")
            removePendingSale(item.id)

            setStatLabel("success", "Venta hecha")
            console.log('res', res);
            // Do something with the result :)
       });

   $('#prods ul').empty();
   Partidas = [];
   total = 0;
   }

}

function removePendingSale(id){
    var transaction = db.transaction(["ventas"], "readwrite");

    transaction.oncomplete = function(event) {

    };

    transaction.onerror = function(event) {

    };

    // create an object store on the transaction
    var objectStore = transaction.objectStore("ventas");

    // Delete the specified record out of the object store
    var objectStoreRequest = objectStore.delete(id);

    objectStoreRequest.onsuccess = function(event) {
    // report the success of our delete operation

    };
}