Xtykutl

I have a problem in getting the total sales every time I select specific range of date using a date picker. This is what my sales table look like and yet it display the wrong sum total.

function sales_result()

{

var start_date =  urlParams["start_date"]; 

var from = new Date(start_date); 

var start_mil = from.getTime(); 



var end_date =  urlParams["end_date"]; 

var end = new Date(end_date); 

var end_mil = end.getTime(); 

var user_id =  ""; //urlParams["user_id"]

$("#from-date").html(start_date);

$("#to-date").html(end_date);





dbRef.ref('tbl_orders').on('child_added', function(data) {

    var set_ongoing = "";

    if ( data.val().status == 'ordered' ) {

        var status = '<span class="label label-default">Ordered</span>';

        var set_ongoing = '<button confirmation_code="'+ 

data.val().confirmation_code+'" order_key="' + data.key + '" order_no="' + 

data.val().order_no + '" onclick="set_ongoing(this)"  title="Set As Ongoing" 

class="btn btn-green btn-fab btn-fab-sm"><i class="zmdi zmdi-check-all"></i> 

<div class="ripple-container"></div></button>';

    }else if ( data.val().status == 'ongoing' ) {

        var status = '<span class="label label-primary">Ongoing</span>';

    }else{

        var status = '<span class="label label-success">Delivered</span>';

    } 



    var from = data.val().order_date;

    var from = new Date(data.val().order_date); 

    var from_mil = from.getTime(); 

    if ( from_mil  >= start_mil && from_mil  <= end_mil ) {

        dbRef.ref('tbl_user').child(data.val().user_id).once("value", 

function(snap) {

          $("#type").append('<tr><input type="hidden"  name="total" 

value="' + data.val().total + '" > <td>' + data.val().order_date + '</td>  

<td>' + data.val().order_no + '</td>  <td>' + snap.val().fullname + '</td> 

<td>' + data.val().confirmation_code + '</td> <td>' + status + '</td> <td 

align="right"> ' + data.val().total + '</td></tr>');

         });

    }



});



dbRef.ref('tbl_orders').on("value", function(data,getReq) {

    data.forEach(keyReq => { console.log(keyReq.val()); 

         var total = keyReq.val().total; 

    var t = parseInt(total); 

    t1 += t;   



    }); 

    $("#total-price").html('₱'+t1.toFixed(2).replace(/d(?=(d{3})+.)/g, 

'$&,') );

});

This is my database:

Can anyone please help me for our thesis. Thank you so much.