Calculating different percentages from a reduced map containing JSON data

Question

Calculating different percentages from a reduced map containing JSON data

Forgive me in advance if there's a similar question out there, but after a day of searching, I couldn't find what I need.

I'm calling an API that responds with data, and I've extracted the necessary details to create a JSON file with the following example:

{
    "total": 563,
    "shipping_fee": 58,
    "e_charges": ???,
    "order_items": [
      {
        "item_id": 6291020872,
        "quantity": 1,
        "price": 88,
        "total": 88
      },
      {
        "item_id": 7755274567,
        "quantity": 1,
        "price": 150,
        "total": 150
      },
      {
        "item_id": 7980571205,
        "quantity": 1,
        "price": 45,
        "total": 45
      },
      {
        "item_id": 12612977930,
        "quantity": 1,
        "price": 280,
        "total": 280
      }
    ]
  }, ... {} {} {}....

My issue is calculating the total sum of all total values in order_items [], then adding the shipping_fee and calculating two separate percentages.

10%
8%

It's important to note that I'm receiving these values in real-time.

const resDetails = await request.post(baseURL, {
        data: viewData
    });

info = await JSON.parse(JSON.stringify(await resDetails.json()));

Here is how the JSON file structure was derived:

orders = await info.data.orders.map((x) => ({total: x.order_items.map(y =>  Number(y.order_price) * y.amount).reduce((total, y) => y+total),
        shipping_fee : Number(x.shipping_fee), 
        e_charges: Number(Number((x.order_items.map(y=>  Number(y.order_price) * y.amount).reduce((total, y) => Number(y+total)) + Number(x.shipping_fee)) * 0.1).toFixed()),
        order_items: x.order_items.map((y) => ({
             item_id : y.item_id, 
             quantity: y.amount, 
             price: Number(y.order_price),
             total: Number(y.order_price) * y.amount}))})

I managed to calculate the 10%, but I'm struggling to add the additional 8% without repeating the mapping, reducing, and adding the shipping_fee again.

Number(Number((x.order_items.map(y=>  Number(y.order_price) * y.amount).reduce((total, y) => Number(y+total)) + Number(x.shipping_fee)) * 0.1).toFixed())

I'm new to the world of JavaScript/TypeScript and I'm hoping for a more efficient way to achieve my goal. Thank you for any assistance.

EDIT: Here's the actual code: https://i.sstatic.net/bcHHI.png

javascript json typescript javascript-objects

Answer 1

Answer №1

Feel free to review the code snippet below. Personally, I prefer not to cram all the calculations into one line using the map, reduce, and other functions as it can make the code less readable. Instead, I have broken down the calculations into separate methods.

One important point to note is that the total order amount is computed only once, and the percentage charges for e_charges are saved in two different keys - e_charges_8 and e_charges_10. This structure allows for easy customization according to specific requirements.

let orders = [
  {
    "shipping_fee": 58,
    "order_items": [
      {
        "item_id": 6291020872,
        "quantity": 1,
        "price": 88
      },
      {
        "item_id": 7755274567,
        "quantity": 1,
        "price": 150
      },
      {
        "item_id": 7980571205,
        "quantity": 1,
        "price": 45
      },
      {
        "item_id": 12612977930,
        "quantity": 1,
        "price": 280
      }
    ]
  }, 
  {
    "shipping_fee": 58,
    "order_items": [
      {
        "item_id": 6291020872,
        "quantity": 1,
        "price": 88
      },
      {
        "item_id": 7755274567,
        "quantity": 1,
        "price": 150
      },
      {
        "item_id": 7980571205,
        "quantity": 1,
        "price": 45
      },
      {
        "item_id": 12612977930,
        "quantity": 1,
        "price": 280
      }
    ]
  }
]


const getOrderItemTotal = (orderItem) => {
  return orderItem.quantity * orderItem.price
}

const getPercentage = (shippingFee, total, percentage) => {
  return ((total + shippingFee) * percentage).toFixed()
}

const getOrderItemsTotal = (orderItems) => {
  return orderItems.reduce((total, orderItem) => (total + orderItem.total), 0)
}

orders = orders.map(order => {
  order.order_items.map(orderItem => {
    orderItem.total = getOrderItemTotal(orderItem)
    return orderItem
  })
  
  order.total = getOrderItemsTotal(order.order_items)
  
  order.e_charges_8 = getPercentage(order.shipping_fee, order.total, 0.1)
  order.e_charges_10 = getPercentage(order.shipping_fee, order.total, 0.08)
    
  return order
})


console.log(orders)

Answer 2

Feel free to review the code snippet below. Personally, I prefer not to cram all the calculations into one line using the map, reduce, and other functions as it can make the code less readable. Instead, I have broken down the calculations into separate methods.

One important point to note is that the total order amount is computed only once, and the percentage charges for e_charges are saved in two different keys - e_charges_8 and e_charges_10. This structure allows for easy customization according to specific requirements.

let orders = [
  {
    "shipping_fee": 58,
    "order_items": [
      {
        "item_id": 6291020872,
        "quantity": 1,
        "price": 88
      },
      {
        "item_id": 7755274567,
        "quantity": 1,
        "price": 150
      },
      {
        "item_id": 7980571205,
        "quantity": 1,
        "price": 45
      },
      {
        "item_id": 12612977930,
        "quantity": 1,
        "price": 280
      }
    ]
  }, 
  {
    "shipping_fee": 58,
    "order_items": [
      {
        "item_id": 6291020872,
        "quantity": 1,
        "price": 88
      },
      {
        "item_id": 7755274567,
        "quantity": 1,
        "price": 150
      },
      {
        "item_id": 7980571205,
        "quantity": 1,
        "price": 45
      },
      {
        "item_id": 12612977930,
        "quantity": 1,
        "price": 280
      }
    ]
  }
]


const getOrderItemTotal = (orderItem) => {
  return orderItem.quantity * orderItem.price
}

const getPercentage = (shippingFee, total, percentage) => {
  return ((total + shippingFee) * percentage).toFixed()
}

const getOrderItemsTotal = (orderItems) => {
  return orderItems.reduce((total, orderItem) => (total + orderItem.total), 0)
}

orders = orders.map(order => {
  order.order_items.map(orderItem => {
    orderItem.total = getOrderItemTotal(orderItem)
    return orderItem
  })
  
  order.total = getOrderItemsTotal(order.order_items)
  
  order.e_charges_8 = getPercentage(order.shipping_fee, order.total, 0.1)
  order.e_charges_10 = getPercentage(order.shipping_fee, order.total, 0.08)
    
  return order
})


console.log(orders)

Calculating different percentages from a reduced map containing JSON data

Answer №1

Similar questions

Use JavaScript to upload a JSON file containing arrays into separate tabs

How can a parameter be added to a query string only when there is a value present in a textbox using JavaScript?

Limiting the size of images within a specific section using CSS

I'm not sure how I can retrieve the pollId from a ReactJS poll

Steps for injecting strings directly into Angular2 EventBindingWould you like to learn how

Setting a default value in react-select

Using Web SQL always seems to throw me for a loop

"I'm looking for a way to set a cookie and JSON in the server response and then redirect to the client URL using PassportJS in

Effortlessly switch between multiple divs with jQuery

Unknown identifier in the onClick function

Transmit information from the primary HTML page's controller to a directive's controller

Items seem to vanish into thin air and become immovable when attempting to relocate them

Once this code is executed, Javascript ceases to function

The event.pageY position consistently reflects the laptop screen size rather than the exact position where the click occurred

What is the method for retrieving the active element with Waypoint?

Enhance the design of MDX in Next.js with a personalized layout

Is there an improved method for designing a schema?

Can you provide guidance on how to access my account using the code that I have?

Is it possible for JavaScript to be cached when it is located within the body tag of an HTML document?

Using Vue.js 3 to fetch data from a REST API using the Axios