``Consolidate array elements to calculate total sums over a specified time duration

Question

``Consolidate array elements to calculate total sums over a specified time duration

I need help with modifying the code below to only calculate the total payments that occurred within the last 24 hours (86400 seconds).

var addr = 't1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU',
  data = [{
    "name": "zelcash",
    "pending": {
      "blocks": [
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e:b7887996c1267949ffcd80773a6512e7df9cce392ba1f76c89f3b5fa974a0c91:99856:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Lana:1529254887651",
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2:7e679e73247e724e707c485dc9111f981e2bf7f19814abadfa7cecfbb897b146:99735:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Del:1529240255922"
      ],
      "confirms": {
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2": "130",
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e": "9"
      }
    },
    "payments": [{

       // Payment data omitted for brevity

    }]
  }]

var totalAmount =
  data[0].payments.
map(payment => payment.amounts). //get all amount object
map(amounts => amounts[addr]). //get amount from addr
filter(price => price). //filter undefined amount
reduce((first, second) => { //sum amount
  return first + second;
});
totalAmount = totalAmount.toFixed(5);
console.log(totalAmount)

javascript json ajax

Answer 1

Answer №1

You have the ability to implement a filter based on time, specifically targeting the current time minus one day. Take a look at this example:

var addr = 't1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU',
  data = [{...data object here...}];

var oneDayAgoInSeconds = new Date(Date.now()-1).getTime();

var totalAmount =
  data[0].payments.filter(payment => payment.time >= oneDayAgoInSeconds).
map(payment => payment.amounts). // accessing all amounts
map(amounts => amounts[addr]). // extracting amount by address
filter(price => price). 
reduce((first, second) => { 
  return first + second;
}, 0);
totalAmount = totalAmount.toFixed(5);
console.log(totalAmount)

Additional note: I also included a '0' after the return statement in your reduce function to handle potential errors related to empty arrays.

Answer 2

You have the ability to implement a filter based on time, specifically targeting the current time minus one day. Take a look at this example:

var addr = 't1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU',
  data = [{...data object here...}];

var oneDayAgoInSeconds = new Date(Date.now()-1).getTime();

var totalAmount =
  data[0].payments.filter(payment => payment.time >= oneDayAgoInSeconds).
map(payment => payment.amounts). // accessing all amounts
map(amounts => amounts[addr]). // extracting amount by address
filter(price => price). 
reduce((first, second) => { 
  return first + second;
}, 0);
totalAmount = totalAmount.toFixed(5);
console.log(totalAmount)

Additional note: I also included a '0' after the return statement in your reduce function to handle potential errors related to empty arrays.

Answer 3

Answer №2

Make sure to apply a filter for payments made in the last 24 hours before initiating the process:

.filter(payment => payment.time > Date.now() - 24*60*60*1000)

The expression Date.now() - 24*60*60*1000 provides the unixtime value from 24 hours ago.

var addr = 't1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU',
  data = [{
    "name": "zelcash",
    "pending": {
      "blocks": [
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e:b7887996c1267949ffcd80773a6512e7df9cce392ba1f76c89f3b5fa974a0c91:99856:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Lana:1529254887651",
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2:7e679e73247e724e707c485dc9111f981e2bf7f19814abadfa7cecfbb897b146:99735:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Del:1529240255922"
      ],
      "confirms": {
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2": "130",
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e": "9"
      }
    },
    "payments": [...
      
    ]
  }]

var totalAmount =
  data[0].payments.
filter(payment => payment.time > Date.now() - 24*60*60*1000).
map(payment => payment.amounts). //access all amount objects
map(amounts => amounts[addr]). //retrieve amount based on address
filter(price => price). //apply filter if amount is defined
reduce((first, second) => { //sum of amounts
  return first + second;
});
totalAmount = totalAmount.toFixed(5);
console.log(totalAmount)

Answer 4

Make sure to apply a filter for payments made in the last 24 hours before initiating the process:

.filter(payment => payment.time > Date.now() - 24*60*60*1000)

The expression Date.now() - 24*60*60*1000 provides the unixtime value from 24 hours ago.

var addr = 't1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU',
  data = [{
    "name": "zelcash",
    "pending": {
      "blocks": [
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e:b7887996c1267949ffcd80773a6512e7df9cce392ba1f76c89f3b5fa974a0c91:99856:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Lana:1529254887651",
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2:7e679e73247e724e707c485dc9111f981e2bf7f19814abadfa7cecfbb897b146:99735:t1QATR1DnhnrKEsv3tUvWzcjFHKEV4GPBZU.Del:1529240255922"
      ],
      "confirms": {
        "00000005a9bf4d9b58d031c4868b14645e93a29fa057f3a02547c8cc70ad46e2": "130",
        "0000000cc8cb614f91c1f2cb97cce10c6fcbcc16a10ed9e209e03b3debafe56e": "9"
      }
    },
    "payments": [...
      
    ]
  }]

var totalAmount =
  data[0].payments.
filter(payment => payment.time > Date.now() - 24*60*60*1000).
map(payment => payment.amounts). //access all amount objects
map(amounts => amounts[addr]). //retrieve amount based on address
filter(price => price). //apply filter if amount is defined
reduce((first, second) => { //sum of amounts
  return first + second;
});
totalAmount = totalAmount.toFixed(5);
console.log(totalAmount)

``Consolidate array elements to calculate total sums over a specified time duration

Answer №1

Answer №2

Similar questions

Several attributes in the JSON object being sent to the MVC controller are missing or have a null

Steps to deactivate the select element in backbone.js

"Converting an array within a single object into an object: step-by-step

The NextJs error message states: "`nextCallback` is not defined as a function

Building an Image/Grid system using CSS and Javascript

Display the input text value when the button is clicked

Access the file from the resources directory in the Glassfish Java application

How to utilize AJAX in jQuery to retrieve data from an external URL

A guide on locating and comparing values of specific elements within a JSON object

I'm curious why my background generator is only altering a portion of the background instead of the entire thing

Retrieve the session variable established in Script 1 within Script 2 using PHP

What is the best way to save inputted names as properties of an object and assign the corresponding input values as the values of those properties?

What steps do I need to take in order to create functions that are

How can I ensure that I am correctly choosing specific fields in a Mongoose query?

Java - Converting JSON format

Troubleshooting: Groovy Script with JSON Parameter Configuration is malfunctioning

"Is there a way to effectively showcase an error message for AJAX requests in a Rails

When a new element is introduced, onmouseenter feature assigns a unique dynamic function variable

The mongoose library is not throwing any errors, indicating that the database connection has been established successfully

Guide to ensuring that a form's textarea contains a minimum of 12 characters using Bootstrap