Calculate the total of all the arrays of objects nested within the main array of objects

Question

Calculate the total of all the arrays of objects nested within the main array of objects

I have an array of objects with nested arrays, and I need to calculate the sum of certain values based on the same picker_id. Specifically, I want to sum up the current_capacity, process_time_in_minutes, and picked_qty inside the products array. Here is the data:

var arr = [
  {
    current_capacity: 6000,
    picker_id: "icQrHPuE2fMZslceSG6liwuRar92",
    process_time_in_minutes: 10,
    products: [
      {
        product_id: 1,
        picked_qty: 2
      },
      {
        product_id: 2,
        picked_qty: 3
      }
    ]
  },

  {
    current_capacity: 2500,
    picker_id: "icQrHPuE2fMZslceSG6liwuRar92",
    process_time_in_minutes: 20,
    products: [
      {
        product_id: 1,
        picked_qty: 10
      }
    ]
  },

  {
    current_capacity: 36000,
    picker_id: "WIRzfIZALeftRk3DRGvh4nBdxQV2",
    process_time_in_minutes: 15,
    products: [
      {
        product_id: 1,
        picked_qty: 2
      },
      {
        product_id: 2,
        picked_qty: 3
      }
    ]
  }
];

Below is the code I'm using:

  var res = arr.reduce((acc, obj) => {
  var existObj = acc.find((item) => item.picker_id === obj.picker_id);
  if (existObj) {
    let total_picked = obj.products.reduce((acc2, curr) => acc2 + curr);

    // console.log("total_picked", total_picked);
    existObj.current_capacity =
      existObj.current_capacity + obj.current_capacity;
    existObj.process_time_in_minutes =
      existObj.process_time_in_minutes + obj.process_time_in_minutes;

    existObj.total = existObj.total ? existObj.total : 0 + total_picked;
    return acc;
  }
  acc.push(obj);
  return acc;
}, []);

const formatted = res.map((el) => {
  return {
    picker_id: el.picker_id,
    total_volume: el.current_capacity,
    total_time: el.process_time_in_minutes,
    total_products: el.total
  };
});

The resulting output is shown below:

[
 {
   picker_id: "icQrHPuE2fMZslceSG6liwuRar92"
   total_volume: 8500
   total_time: 30
   total_products: "0[object Object]"
 },
 {
   picker_id: "WIRzfIZALeftRk3DRGvh4nBdxQV2"
   total_volume: 36000
   total_time: 15
   total_products: undefined
  }
]

The expected output should be as follows:

[
 {
   picker_id: "icQrHPuE2fMZslceSG6liwuRar92"
   total_volume: 8500
   total_time: 30
   total_products: 15
 },
 {
   picker_id: "WIRzfIZALeftRk3DRGvh4nBdxQV2"
   total_volume: 36000
   total_time: 15
   total_products: 5
  }
]

javascript arrays algorithm object hashtable

Answer 1

Answer №1

By utilizing parameter destructuring, it is possible to enhance the code for better readability and efficiency. Here is an improved version based on the suggestions provided:

const extractData = (data) => Object .values (data .reduce (
  (acc, {capacity, id, time, products}) => {
    const currentPicker = acc [id] || (acc [id] = {
      id, totalVolume: 0, totalTime: 0, totalProducts: 0
    })
    currentPicker .totalVolume += capacity
    currentPicker .totalTime += time
    currentPicker .totalProducts += products .reduce ((acc, product) => acc + product .quantityPicked, 0)
    return acc
  },
  {}
))

const dataList = [{capacity: 6000, id: "icQrHPuE2fMZslceSG6liwuRar92", time: 10, products: [{productId: 1, quantityPicked: 2}, {productId: 2, quantityPicked: 3}]}, {capacity: 2500, id: "icQrHPuE2fMZslceSG6liwuRar92", time: 20, products: [{productId: 1, quantityPicked: 10}]}, {capacity: 36000, id: "WIRzfIZALeftRk3DRGvh4nBdxQV2", time: 15, products: [{productId: 1, quantityPicked: 2}, {productId: 2, quantityPicked: 3}]}]

console .log (extractData (dataList))

.as-console-wrapper {max-height: 100% !important; top: 0}

Answer 2

By utilizing parameter destructuring, it is possible to enhance the code for better readability and efficiency. Here is an improved version based on the suggestions provided:

const extractData = (data) => Object .values (data .reduce (
  (acc, {capacity, id, time, products}) => {
    const currentPicker = acc [id] || (acc [id] = {
      id, totalVolume: 0, totalTime: 0, totalProducts: 0
    })
    currentPicker .totalVolume += capacity
    currentPicker .totalTime += time
    currentPicker .totalProducts += products .reduce ((acc, product) => acc + product .quantityPicked, 0)
    return acc
  },
  {}
))

const dataList = [{capacity: 6000, id: "icQrHPuE2fMZslceSG6liwuRar92", time: 10, products: [{productId: 1, quantityPicked: 2}, {productId: 2, quantityPicked: 3}]}, {capacity: 2500, id: "icQrHPuE2fMZslceSG6liwuRar92", time: 20, products: [{productId: 1, quantityPicked: 10}]}, {capacity: 36000, id: "WIRzfIZALeftRk3DRGvh4nBdxQV2", time: 15, products: [{productId: 1, quantityPicked: 2}, {productId: 2, quantityPicked: 3}]}]

console .log (extractData (dataList))

.as-console-wrapper {max-height: 100% !important; top: 0}

Answer 3

Answer №2

This method can also produce the desired result:


    function calculateTotal(arr){
      let sum = 0;
      arr.forEach(item => {
        sum += item.quantity
      })
      return sum;
    }
    
    const finalResult = data.reduce((accumulator,element) => {
       if(!accumulator.hasOwnProperty(element.id)){
          accumulator[element.id] = {
            id: element.id,
            total_amount: element.amount,
            total_time: element.time_in_minutes
          }    
             
          accumulator[element.id].total_items = calculateTotal(element.items);
      }else{
         accumulator[element.id].total_amount = accumulator[element.id].total_amount + element.amount;
         accumulator[element.id].total_time = accumulator[element.id].total_time + element.time_in_minutes;
         accumulator[element.id].total_items = accumulator[element.id].total_items + calculateTotal(element.items);
      }
          
         return accumulator;
       },{});
        
console.log(Object.values(finalResult),'final result');

Answer 4

This method can also produce the desired result:


    function calculateTotal(arr){
      let sum = 0;
      arr.forEach(item => {
        sum += item.quantity
      })
      return sum;
    }
    
    const finalResult = data.reduce((accumulator,element) => {
       if(!accumulator.hasOwnProperty(element.id)){
          accumulator[element.id] = {
            id: element.id,
            total_amount: element.amount,
            total_time: element.time_in_minutes
          }    
             
          accumulator[element.id].total_items = calculateTotal(element.items);
      }else{
         accumulator[element.id].total_amount = accumulator[element.id].total_amount + element.amount;
         accumulator[element.id].total_time = accumulator[element.id].total_time + element.time_in_minutes;
         accumulator[element.id].total_items = accumulator[element.id].total_items + calculateTotal(element.items);
      }
          
         return accumulator;
       },{});
        
console.log(Object.values(finalResult),'final result');

Answer 5

Answer №3

There was an issue in your implementation where if the existObj is not present in your acc, you were directly pushing the obj. Instead, you should process the total first from the inner array of products.

I have enhanced your code to make it more organized and maintainable.

Here is the approach:

Create a dictionary for each unique picker_id that contains the computed data
Convert the dictionary into a list

var result = arr.reduce((acc, obj) => {
  if (!acc[obj.picker_id]) {
    acc[obj.picker_id] = {
      total_volume: 0,
      total_time: 0,
      total_products: 0
    };
  }

  const selectedPicker = acc[obj.picker_id];
  const total_picked = obj.products.reduce((acc2, item) => acc2 + item.picked_qty, 0);

  selectedPicker.total_volume = selectedPicker.total_volume + obj.current_capacity;
  selectedPicker.total_time =
    selectedPicker.total_time + obj.process_time_in_minutes;
  selectedPicker.total_products = selectedPicker.total_products + total_picked;
  
  return acc;
}, {});


const formatted = Object.keys(result).reduce((acc, picker_id) => {
    acc.push({
    picker_id,
    ...result[picker_id]
  })
    return acc;
}, [])

console.log("formatted", formatted);

Answer 6

There was an issue in your implementation where if the existObj is not present in your acc, you were directly pushing the obj. Instead, you should process the total first from the inner array of products.

I have enhanced your code to make it more organized and maintainable.

Here is the approach:

Create a dictionary for each unique picker_id that contains the computed data
Convert the dictionary into a list

var result = arr.reduce((acc, obj) => {
  if (!acc[obj.picker_id]) {
    acc[obj.picker_id] = {
      total_volume: 0,
      total_time: 0,
      total_products: 0
    };
  }

  const selectedPicker = acc[obj.picker_id];
  const total_picked = obj.products.reduce((acc2, item) => acc2 + item.picked_qty, 0);

  selectedPicker.total_volume = selectedPicker.total_volume + obj.current_capacity;
  selectedPicker.total_time =
    selectedPicker.total_time + obj.process_time_in_minutes;
  selectedPicker.total_products = selectedPicker.total_products + total_picked;
  
  return acc;
}, {});


const formatted = Object.keys(result).reduce((acc, picker_id) => {
    acc.push({
    picker_id,
    ...result[picker_id]
  })
    return acc;
}, [])

console.log("formatted", formatted);

Calculate the total of all the arrays of objects nested within the main array of objects

Answer №1

Answer №2

Answer №3

Similar questions

Activate jQuery datetimepicker on dynamic elements

Is it possible to load a JavaScript file from a different domain using a bookmarklet?

Checking phone number on a React.js form

JavaScript can extract a portion of an array

Tips for displaying indentations on Tube Geometry using THREE.js

Send data from an AJAX request to a Laravel controller

After a brief period of running, my AJAX request begins to malfunction

Leveraging JQuery to extract the numerical value located between the slashes within a hyperlink

What is the best way to populate empty dates within an array of objects using TypeScript or JavaScript?

Issues have been encountered with activating checkboxes on Internet Explorer while utilizing ASP.NET CheckBox controls

Using axios to modify and enhance the HTML content of a webpage

Measuring the number of distinct words within a given set of strings

Developing a website with multiple pages using Vue.js CLI allows for

What could be causing the error in sending JSON data from JavaScript to Flask?

Visualization with D3 - Putting an image at the heart of a circular chart made with SVG

Utilizing a font URL imported through a script

Automating Image Downloads with Puppeteer by Adding Authentication Query String to Image URL

Updating class on elements in arrays

What is the most efficient way to perform an array join in Node.js, akin to the speed of MongoDB's $

Guide to refreshing extensive dataset using MySQL migration scripts