I have this json array response from my mysql multi query
[
[
{
"block": "Saraiyahat",
"pending": 1
},
{
"block": "Jama",
"pending": 3
},
{
"block": "Dumka",
"pending": 1
}
],
[
{
"block": "Dumka",
"processing": 2
}
],
[
{
"block": "Saraiyahat",
"disposed": 1
},
{
"block": "Jama",
"disposed": 1
},
{
"block": "Dumka",
"disposed": 1
}
]
]
And i want it to be shorted/merged like this group by "block" name using JQuery/Javascript
[
{
"block": "Saraiyahat",
"pending": 1,
"processing": 0,
"disposed": 1
},
{
"block": "Jama",
"pending": 3,
"processing": 0,
"disposed": 1
},
{
"block": "Dumka",
"pending": 1,
"processing": 2,
"disposed": 1
}
]
Please help me doing this...
Regards
What I have tried:
I have tried jquery unique, short, merge but not achieved
var block, pending = 0, processing = 0, disposed = 0;
for (let i = 0; i < res.length; i++) {
if (res[i].status == 'Pending') {
pending = pending + 1;
}
if (res[i].status == 'Processing') {
processing = processing + 1;
}
if (res[i].status == 'Disposed') {
disposed = disposed + 1;
}
block = res[i].block;
}
console.log({ block: block, pending: pending, processing: processing, disposed: disposed })