group data from an array, making sum and add child node

Question

I am trying to summarize a JSON,I have tried several example from Stack Overflow How to get max of in array of objects How to make a foreach of an object in javascript? but none of the tries have been successful.

   Sale: [
  {
     saleID: "2",
     timeStamp: "2021-01-08T17:50:28+00:00",
     discountPercent: "0",
     completed: "true",
     archived: "false",
     voided: "false",
     enablePromotions: "true",
     isTaxInclusive: "true",
     createTime: "2021-01-08T17:49:53+00:00",
     updateTime: "2021-01-08T17:50:29+00:00",
     completeTime: "2021-01-08T17:50:28+00:00",
     referenceNumber: "",
     referenceNumberSource: "",
     tax1Rate: "0.2",
     tax2Rate: "0",
     change: "0",
     receiptPreference: "printed",
     displayableSubtotal: "500",
     ticketNumber: "220000000002",
     calcDiscount: "0",
     calcTotal: "500",
     calcSubtotal: "416.67",
     calcTaxable: "416.67",
     calcNonTaxable: "0",
     calcAvgCost: "0",
     calcFIFOCost: "0",
     calcTax1: "83.33",
     calcTax2: "0",
     calcPayments: "500",
     total: "500",
     totalDue: "500",
     displayableTotal: "500",
     balance: "0",
     customerID: "0",
     discountID: "0",
     employeeID: "1",
     quoteID: "0",
     registerID: "1",
     shipToID: "0",
     shopID: "1",
     taxCategoryID: "1",
     taxTotal: "83.33"
  },
  {
     saleID: "3",
     timeStamp: "2021-01-08T17:53:18+00:00",
     discountPercent: "0",
     completed: "false",
     archived: "false",
     voided: "false",
     enablePromotions: "true",
     isTaxInclusive: "true",
     createTime: "2021-01-08T17:53:18+00:00",
     updateTime: "2021-01-08T17:53:18+00:00",
     referenceNumber: "",
     referenceNumberSource: "",
     tax1Rate: "0.2",
     tax2Rate: "0",
     change: "0",
     receiptPreference: "printed",
     displayableSubtotal: "0",
     ticketNumber: "220000000003",
     calcDiscount: "0",
     calcTotal: "0",
     calcSubtotal: "0",
     calcTaxable: "0",
     calcNonTaxable: "0",
     calcAvgCost: "0",
     calcFIFOCost: "0",
     calcTax1: "0",
     calcTax2: "0",
     calcPayments: "0",
     total: "0",
     totalDue: "0",
     displayableTotal: "0",
     balance: "0",
     customerID: "0",
     discountID: "0",
     employeeID: "1",
     quoteID: "0",
     registerID: "1",
     shipToID: "0",
     shopID: "1",
     taxCategoryID: "1",
     taxTotal: "0"
  },
  {
     saleID: "5",
     timeStamp: "2021-01-08T17:54:43+00:00",
     discountPercent: "0",
     completed: "false",
     archived: "false",
     voided: "false",
     enablePromotions: "true",
     isTaxInclusive: "true",
     createTime: "2021-01-08T17:54:43+00:00",
     updateTime: "2021-01-08T17:54:43+00:00",
     referenceNumber: "",
     referenceNumberSource: "",
     tax1Rate: "0.2",
     tax2Rate: "0",
     change: "0",
     receiptPreference: "printed",
     displayableSubtotal: "0",
     ticketNumber: "220000000005",
     calcDiscount: "0",
     calcTotal: "0",
     calcSubtotal: "0",
     calcTaxable: "0",
     calcNonTaxable: "0",
     calcAvgCost: "0",
     calcFIFOCost: "0",
     calcTax1: "0",
     calcTax2: "0",
     calcPayments: "0",
     total: "0",
     totalDue: "0",
     displayableTotal: "0",
     balance: "0",
     customerID: "0",
     discountID: "0",
     employeeID: "1",
     quoteID: "0",
     registerID: "1",
     shipToID: "0",
     shopID: "1",
     taxCategoryID: "1",
     taxTotal: "0"
  },
  {
     saleID: "6",
     timeStamp: "2021-01-24T18:49:27+00:00",
     discountPercent: "0",
     completed: "true",
     archived: "false",
     voided: "false",
     enablePromotions: "true",
     isTaxInclusive: "true",
     createTime: "2021-01-24T18:48:30+00:00",
     updateTime: "2021-01-24T18:49:28+00:00",
     completeTime: "2021-01-24T18:49:27+00:00",
     referenceNumber: "",
     referenceNumberSource: "",
     tax1Rate: "0.2",
     tax2Rate: "0",
     change: "0",
     receiptPreference: "printed",
     displayableSubtotal: "316.69",
     ticketNumber: "220000000006",
     calcDiscount: "0",
     calcTotal: "316.69",
     calcSubtotal: "263.91",
     calcTaxable: "263.91",
     calcNonTaxable: "0",
     calcAvgCost: "0",
     calcFIFOCost: "0",
     calcTax1: "52.78",
     calcTax2: "0",
     calcPayments: "316.69",
     total: "316.69",
     totalDue: "316.69",
     displayableTotal: "316.69",
     balance: "0",
     customerID: "0",
     discountID: "0",
     employeeID: "1",
     quoteID: "0",
     registerID: "1",
     shipToID: "0",
     shopID: "1",
     taxCategoryID: "1",
     taxTotal: "52.78"
  }]

I have tried several ways, the latest one:

      const debitSummary = sales.reduce((acc, inv, i) => {
   // console.log("inside reduce");
    if (i) {
      //  if (parseFloat(inv.calcTotal>0)){ // invoice
      acc = {
        //...acc,
        ticketNumber: acc.ticketNumber + ',' + inv.ticketNumber,
        registerID: inv.registerID > acc.registerID ? inv.registerID : acc.registerID,
        calcTotal: parseFloat(acc.calcTotal) + parseFloat(inv.calcTotal),
        timeStamp: formatDate(inv.timeStamp) > formatDate(acc.timeStamp) ? formatDate(inv.timeStamp) : formatDate(acc.timeStamp),
      }
      // }
    }
    return acc;
  },sales[0] );

But impossible to achieve the goal:

sum of calcTotal,
sum of total,
array of saleID,
array of ticketNumber,
with a break by registerID and day of timeStamp:

[{
    calcTotal: "500",
    registerID: "1",
    saleID: {
      "2",
      "3",
      "5"
    },
    ticketNumber: {
      "220000000002",
      "220000000003",
      "220000000005"
    },
    timeStamp: "2021-01-08",
    total: "500"
  },
  {
    calcTotal: "316.69",
    registerID: "1",
    saleID: "6",
    ticketNumber: {
      "220000000006"
    },
    timeStamp: "2021-01-24",
    total: "316.69"
  }
]

Welcome to SO! You can make your question more answerable by removing some of the irrelevant fields and simplifying the data. It's not obvious to me what you're grouping on to create this final array. Is it both register id and timestamp? If so, can you show the expected output when there are multiple register ids? What aspect of the timestamp is relevant to forming a different bucket in the grouping logic? Week? Day? Thanks. — ggorlen
– ggorlen, Commented Jan 24, 2021 at 21:00
Your desired output is invalid; saleID and ticketNumber must be arrays (indicated using square brackets [ ... ]), not objects (indicated using curly brackets { ... }). — Heretic Monkey
– Heretic Monkey, Commented Jan 24, 2021 at 21:06
@HereticMonkey, you are right, I was not clear, both solutions are fine. — Montana
– Montana, Commented Jan 25, 2021 at 8:06

Nina Scholz · Accepted Answer · 2021-01-25 09:43:45Z

You could take an object with date part of the timestamp as key and get the values from the object as result.

const
    sale = [{ saleID: "2", timeStamp: "2021-01-08T17:50:28+00:00", discountPercent: "0", completed: "true", archived: "false", voided: "false", enablePromotions: "true", isTaxInclusive: "true", createTime: "2021-01-08T17:49:53+00:00", updateTime: "2021-01-08T17:50:29+00:00", completeTime: "2021-01-08T17:50:28+00:00", referenceNumber: "", referenceNumberSource: "", tax1Rate: "0.2", tax2Rate: "0", change: "0", receiptPreference: "printed", displayableSubtotal: "500", ticketNumber: "220000000002", calcDiscount: "0", calcTotal: "500", calcSubtotal: "416.67", calcTaxable: "416.67", calcNonTaxable: "0", calcAvgCost: "0", calcFIFOCost: "0", calcTax1: "83.33", calcTax2: "0", calcPayments: "500", total: "500", totalDue: "500", displayableTotal: "500", balance: "0", customerID: "0", discountID: "0", employeeID: "1", quoteID: "0", registerID: "1", shipToID: "0", shopID: "1", taxCategoryID: "1", taxTotal: "83.33" }, { saleID: "3", timeStamp: "2021-01-08T17:53:18+00:00", discountPercent: "0", completed: "false", archived: "false", voided: "false", enablePromotions: "true", isTaxInclusive: "true", createTime: "2021-01-08T17:53:18+00:00", updateTime: "2021-01-08T17:53:18+00:00", referenceNumber: "", referenceNumberSource: "", tax1Rate: "0.2", tax2Rate: "0", change: "0", receiptPreference: "printed", displayableSubtotal: "0", ticketNumber: "220000000003", calcDiscount: "0", calcTotal: "0", calcSubtotal: "0", calcTaxable: "0", calcNonTaxable: "0", calcAvgCost: "0", calcFIFOCost: "0", calcTax1: "0", calcTax2: "0", calcPayments: "0", total: "0", totalDue: "0", displayableTotal: "0", balance: "0", customerID: "0", discountID: "0", employeeID: "1", quoteID: "0", registerID: "1", shipToID: "0", shopID: "1", taxCategoryID: "1", taxTotal: "0" }, { saleID: "5", timeStamp: "2021-01-08T17:54:43+00:00", discountPercent: "0", completed: "false", archived: "false", voided: "false", enablePromotions: "true", isTaxInclusive: "true", createTime: "2021-01-08T17:54:43+00:00", updateTime: "2021-01-08T17:54:43+00:00", referenceNumber: "", referenceNumberSource: "", tax1Rate: "0.2", tax2Rate: "0", change: "0", receiptPreference: "printed", displayableSubtotal: "0", ticketNumber: "220000000005", calcDiscount: "0", calcTotal: "0", calcSubtotal: "0", calcTaxable: "0", calcNonTaxable: "0", calcAvgCost: "0", calcFIFOCost: "0", calcTax1: "0", calcTax2: "0", calcPayments: "0", total: "0", totalDue: "0", displayableTotal: "0", balance: "0", customerID: "0", discountID: "0", employeeID: "1", quoteID: "0", registerID: "1", shipToID: "0", shopID: "1", taxCategoryID: "1", taxTotal: "0" }, { saleID: "6", timeStamp: "2021-01-24T18:49:27+00:00", discountPercent: "0", completed: "true", archived: "false", voided: "false", enablePromotions: "true", isTaxInclusive: "true", createTime: "2021-01-24T18:48:30+00:00", updateTime: "2021-01-24T18:49:28+00:00", completeTime: "2021-01-24T18:49:27+00:00", referenceNumber: "", referenceNumberSource: "", tax1Rate: "0.2", tax2Rate: "0", change: "0", receiptPreference: "printed", displayableSubtotal: "316.69", ticketNumber: "220000000006", calcDiscount: "0", calcTotal: "316.69", calcSubtotal: "263.91", calcTaxable: "263.91", calcNonTaxable: "0", calcAvgCost: "0", calcFIFOCost: "0", calcTax1: "52.78", calcTax2: "0", calcPayments: "316.69", total: "316.69", totalDue: "316.69", displayableTotal: "316.69", balance: "0", customerID: "0", discountID: "0", employeeID: "1", quoteID: "0", registerID: "1", shipToID: "0", shopID: "1", taxCategoryID: "1", taxTotal: "52.78" }],
    result = Object.values(sale.reduce((r, o) => {
        const timeStamp = o.timeStamp.slice(0, 10);
        r[timeStamp] ??= { timeStamp, registerID: o.registerID, ticketNumber: [], saleID: [], calcTotal: 0, total: 0 };
        ['calcTotal', 'total'].forEach(k => r[timeStamp][k] += +o[k]);
        ['saleID', 'ticketNumber'].forEach(k => r[timeStamp][k].push(o[k]));
        return r;
    }, {}));

console.log(result);

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

@NinaSholtz, it works, thanks, can you explain the following code: r[timeStamp] ??= { timeStamp, registerID: o.registerID, ticketNumber: [], saleID: [], calcTotal: 0, total: 0 }; specifically ** ??= **
Thank you, I have adapted it to work in my environment: acc[timeStamp] = acc[timeStamp] ? acc[timeStamp]:{ timeStamp, registerID: curr.registerID, ticketNumber: [], saleID: [], calcTotal: 0, total: 0 };
you could shrink it to acc[timeStamp] = acc[timeStamp] || { timeStamp, registerID: curr.registerID, ticketNumber: [], saleID: [], calcTotal: 0, total: 0 };

Mohammad Mirsafaei · Accepted Answer · 2021-01-24 21:34:29Z

j = [
    {
       saleID: "2",
       timeStamp: "2021-01-08T17:50:28+00:00",
       discountPercent: "0",
       completed: "true",
       archived: "false",
       voided: "false",
       enablePromotions: "true",
       isTaxInclusive: "true",
       createTime: "2021-01-08T17:49:53+00:00",
       updateTime: "2021-01-08T17:50:29+00:00",
       completeTime: "2021-01-08T17:50:28+00:00",
       referenceNumber: "",
       referenceNumberSource: "",
       tax1Rate: "0.2",
       tax2Rate: "0",
       change: "0",
       receiptPreference: "printed",
       displayableSubtotal: "500",
       ticketNumber: "220000000002",
       calcDiscount: "0",
       calcTotal: "500",
       calcSubtotal: "416.67",
       calcTaxable: "416.67",
       calcNonTaxable: "0",
       calcAvgCost: "0",
       calcFIFOCost: "0",
       calcTax1: "83.33",
       calcTax2: "0",
       calcPayments: "500",
       total: "500",
       totalDue: "500",
       displayableTotal: "500",
       balance: "0",
       customerID: "0",
       discountID: "0",
       employeeID: "1",
       quoteID: "0",
       registerID: "1",
       shipToID: "0",
       shopID: "1",
       taxCategoryID: "1",
       taxTotal: "83.33"
    },
    {
       saleID: "3",
       timeStamp: "2021-01-08T17:53:18+00:00",
       discountPercent: "0",
       completed: "false",
       archived: "false",
       voided: "false",
       enablePromotions: "true",
       isTaxInclusive: "true",
       createTime: "2021-01-08T17:53:18+00:00",
       updateTime: "2021-01-08T17:53:18+00:00",
       referenceNumber: "",
       referenceNumberSource: "",
       tax1Rate: "0.2",
       tax2Rate: "0",
       change: "0",
       receiptPreference: "printed",
       displayableSubtotal: "0",
       ticketNumber: "220000000003",
       calcDiscount: "0",
       calcTotal: "0",
       calcSubtotal: "0",
       calcTaxable: "0",
       calcNonTaxable: "0",
       calcAvgCost: "0",
       calcFIFOCost: "0",
       calcTax1: "0",
       calcTax2: "0",
       calcPayments: "0",
       total: "0",
       totalDue: "0",
       displayableTotal: "0",
       balance: "0",
       customerID: "0",
       discountID: "0",
       employeeID: "1",
       quoteID: "0",
       registerID: "1",
       shipToID: "0",
       shopID: "1",
       taxCategoryID: "1",
       taxTotal: "0"
    },
    {
       saleID: "5",
       timeStamp: "2021-01-08T17:54:43+00:00",
       discountPercent: "0",
       completed: "false",
       archived: "false",
       voided: "false",
       enablePromotions: "true",
       isTaxInclusive: "true",
       createTime: "2021-01-08T17:54:43+00:00",
       updateTime: "2021-01-08T17:54:43+00:00",
       referenceNumber: "",
       referenceNumberSource: "",
       tax1Rate: "0.2",
       tax2Rate: "0",
       change: "0",
       receiptPreference: "printed",
       displayableSubtotal: "0",
       ticketNumber: "220000000005",
       calcDiscount: "0",
       calcTotal: "0",
       calcSubtotal: "0",
       calcTaxable: "0",
       calcNonTaxable: "0",
       calcAvgCost: "0",
       calcFIFOCost: "0",
       calcTax1: "0",
       calcTax2: "0",
       calcPayments: "0",
       total: "0",
       totalDue: "0",
       displayableTotal: "0",
       balance: "0",
       customerID: "0",
       discountID: "0",
       employeeID: "1",
       quoteID: "0",
       registerID: "1",
       shipToID: "0",
       shopID: "1",
       taxCategoryID: "1",
       taxTotal: "0"
    },
    {
       saleID: "6",
       timeStamp: "2021-01-24T18:49:27+00:00",
       discountPercent: "0",
       completed: "true",
       archived: "false",
       voided: "false",
       enablePromotions: "true",
       isTaxInclusive: "true",
       createTime: "2021-01-24T18:48:30+00:00",
       updateTime: "2021-01-24T18:49:28+00:00",
       completeTime: "2021-01-24T18:49:27+00:00",
       referenceNumber: "",
       referenceNumberSource: "",
       tax1Rate: "0.2",
       tax2Rate: "0",
       change: "0",
       receiptPreference: "printed",
       displayableSubtotal: "316.69",
       ticketNumber: "220000000006",
       calcDiscount: "0",
       calcTotal: "316.69",
       calcSubtotal: "263.91",
       calcTaxable: "263.91",
       calcNonTaxable: "0",
       calcAvgCost: "0",
       calcFIFOCost: "0",
       calcTax1: "52.78",
       calcTax2: "0",
       calcPayments: "316.69",
       total: "316.69",
       totalDue: "316.69",
       displayableTotal: "316.69",
       balance: "0",
       customerID: "0",
       discountID: "0",
       employeeID: "1",
       quoteID: "0",
       registerID: "1",
       shipToID: "0",
       shopID: "1",
       taxCategoryID: "1",
       taxTotal: "52.78"
    }];
    result = j.reduce((r, { registerID,timeStamp, ...object }) => {
        var temp = r.find(o => o.registerID === registerID && (new Date(o.timeStamp)).toLocaleDateString() === (new Date(timeStamp)).toLocaleDateString());
        if (!temp) r.push(temp = { calcTotal: "0", registerID,timeStamp: (new Date(timeStamp)).toLocaleDateString(), saleID: [], ticketNumber: [], total: "0" });
        temp.saleID.push(object.saleID);
        temp.ticketNumber.push(object.ticketNumber);
        temp.calcTotal = (parseInt(temp.calcTotal) + parseInt(object.calcTotal)).toString();
        temp.total = (parseInt(temp.total) + parseInt(object.total)).toString();

        return r;
    }, []);
    
console.log(result);

but this is output I get : [{"calcTotal":"500","registerID":"1","timeStamp":"1/8/2021","saleID":["2","3","5"],"ticketNumber":["220000000002","220000000003","220000000005"],"total":"500"},{"calcTotal":"316","registerID":"1","timeStamp":"1/24/2021","saleID":["6"],"ticketNumber":["220000000006"],"total":"316"}]
this is what I got: [{ calcTotal: "500", registerID: "1", saleID: ["2"], ticketNumber: ["220000000002"], timeStamp: "08/01/2021", total: "500" }, { calcTotal: "0", registerID: "1", saleID: ["3"], ticketNumber: ["220000000003"], timeStamp: "08/01/2021", total: "0" }, { calcTotal: "0", registerID: "1", saleID: ["5"], ticketNumber: ["220000000005"], timeStamp: "08/01/2021", total: "0" }, { calcTotal: "316", registerID: "1", saleID: ["6"], ticketNumber: ["220000000006"], timeStamp: "24/01/2021", total: "316" }]

Collectives™ on Stack Overflow

group data from an array, making sum and add child node

2 Answers 2

4 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related