sum array and return object javascript

Question

i have an array of objects as follows i want to return a data object which contains a data object and a total returns an array of objects from data and displays the data sum "jumlah"

const data = [
      {
        _id: "618ce59f6d45171be8f7986c",
        persediaanName: "beras_putih",
        funcL: "pembelian",
        namaP: "jeje",
        kuantitas: 3500,
        harga: 20000,
        tanggal: "2021-11-12T09:42:51.000Z",
        tahun: "2021",
        jumlah: 60000000,
        __v: 0,
      },
      {
        _id: "618ce6f36d45171be8f7989a",
        persediaanName: "beras_merah",
        funcL: "penjualan",
        namaP: "bibi",
        kuantitas: 200,
        harga: 20000,
        tanggal: "2021-11-12T09:48:31.000Z",
        tahun: "2021",
        jumlah: 4000000,
        __v: 0,
      },
      {
        _id: "618ce70e6d45171be8f798a2",
        persediaanName: "beras_putih",
        funcL: "penjualan",
        namaP: "gege",
        kuantitas: 200,
        harga: 100000,
        tanggal: "2021-11-12T09:49:00.000Z",
        tahun: "2021",
        jumlah: 2000000,
        __v: 0,
      },
      {
        _id: "618e0bf4804ae02c5c24d83e",
        persediaanName: "beras_merah",
        funcL: "piutang",
        namaP: "ayu",
        kuantitas: 5,
        harga: 1000,
        tanggal: "2021-11-13T06:38:40.000Z",
        tahun: "2021",
        jumlah: 5000,
        __v: 0,
      },
     
      
      {
        _id: "61b1fa6cfe099b0624f04cac",
        kategori: "beras",
        persediaanName: "beras_putih",
        funcL: "piutang",
        namaP: "cahya",
        kuantitas: 100,
        satuan: "kg",
        harga: 1221,
        tanggal: "2021-12-10T12:45:30.000Z",
        tahun: "2021",
        jumlah: 122100,
        __v: 0,
      },
    ];

return object data and total like this. jumlah: sum penjualan from beras_merah and piutang beras_merah. total : sum from data jumlah beras_merah and beras_putih.

const returnArr =  {
  data: [{
    persediaanName: "beras_merah",
    jumlah: // sum  penjualan beras_merah + piutang beras_merah
  },{
    persediaanName: "beras_putih",
    jumlah: // sum penjualan beras_putih + piutang beras_putih
  }]
  total: // sum jumlah "beras_merah" + "beras_puith"
}

Could you show us what you have tried so far. Rather than someone just writing the code, you will find that you learn more by trying, and then people showing were it's maybe gone wrong. As a starter, often problems like this `Array.reduce` seem to fit well. https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/Reduce — Keith, Dec 10 '21 at 13:37

score 0 · Accepted Answer · answered Dec 10 '21 at 15:50

This is one crude way of doing things: You can define the output model and assign initial values (in this case 0's) and iterate through your array and make necessary manipulations.

If you have many values for persediaanName, then you can consider maintaining an array of those values and then do the crude way.

const data = [{
    _id: "618ce59f6d45171be8f7986c",
    persediaanName: "beras_putih",
    funcL: "pembelian",
    namaP: "jeje",
    kuantitas: 3500,
    harga: 20000,
    tanggal: "2021-11-12T09:42:51.000Z",
    tahun: "2021",
    jumlah: 60000000,
    __v: 0,
  },
  {
    _id: "618ce6f36d45171be8f7989a",
    persediaanName: "beras_merah",
    funcL: "penjualan",
    namaP: "bibi",
    kuantitas: 200,
    harga: 20000,
    tanggal: "2021-11-12T09:48:31.000Z",
    tahun: "2021",
    jumlah: 4000000,
    __v: 0,
  },
  {
    _id: "618ce70e6d45171be8f798a2",
    persediaanName: "beras_putih",
    funcL: "penjualan",
    namaP: "gege",
    kuantitas: 200,
    harga: 100000,
    tanggal: "2021-11-12T09:49:00.000Z",
    tahun: "2021",
    jumlah: 2000000,
    __v: 0,
  },
  {
    _id: "618e0bf4804ae02c5c24d83e",
    persediaanName: "beras_merah",
    funcL: "piutang",
    namaP: "ayu",
    kuantitas: 5,
    harga: 1000,
    tanggal: "2021-11-13T06:38:40.000Z",
    tahun: "2021",
    jumlah: 5000,
    __v: 0,
  },
  {
    _id: "61b1fa6cfe099b0624f04cac",
    kategori: "beras",
    persediaanName: "beras_putih",
    funcL: "piutang",
    namaP: "cahya",
    kuantitas: 100,
    satuan: "kg",
    harga: 1221,
    tanggal: "2021-12-10T12:45:30.000Z",
    tahun: "2021",
    jumlah: 122100,
    __v: 0,
  }
];


let newObj = {
  data: [{
    persediaanName: "beras_merah",
    jumlah: 0
  },{
    persediaanName: "beras_putih",
    jumlah: 0
  }],
  total: 0
};

data.map(eachObj => {
  if (eachObj.persediaanName === 'beras_putih') {
    newObj.data[1].jumlah += eachObj.jumlah;
  } else {
    newObj.data[0].jumlah += eachObj.jumlah;
  }
});

newObj.total += newObj.data[0].jumlah + newObj.data[1].jumlah;

console.log('New Obj ==>', newObj);

sum array and return object javascript

1 Answers1