Trying to organize an array of elements (orders details).
https://i.stack.imgur.com/T2DQe.png
[{"id":"myid","base":{"brands":["KI", "SA"],"country":"BG","status":"new"}},{"id":"DEC-00500331","base":{"brands":["DEC"],"country":"UK","status":"new"},"psp":{"name":"adyen","status":"paid"}}]
An order can include items from different brands and is associated with a specific country website.
I am looking to group these orders by country and brand to create a consolidated list. Currently, I am able to group by country using the following code snippet:
let groupedDataByCountryAndBrand = _.groupBy(orders.value, 'base.country')
Object.keys(groupedDataByCountryAndBrand).forEach(key => {
table.push(
{
country : key,
new : groupedDataByCountryAndBrand[key].filter( order => (order.base.status === SFCC_STATUS.new
|| SFCC_STATUS.open
|| SFCC_STATUS.completed )).length
})
})
The desired outcome is to have a breakdown of newly created orders for each brand in a specific country. For example:
{
"country" : "FR",
"brand": "adidas",
"pending": 4,
"new" : 3,
"an other status": 5
}
If you have any suggestions on how I can achieve this, please let me know. I am using lodash with a vue component. Thank you.