Javascript - Soma e Group By em Array

Question

I would like a tip/help.

I’m working with a number of files JSON, and applying filters to them as the user advances in the system.

So far so good, I managed to do it quietly using the .filter().

My problem is in the next step to this. I need to apply the filter to this file, and with the filter result, summarize the information based on a few columns only.

var as=$(ards).filter(function (i,n){
    return n.ARMARIO_ERB===marker.getTitle();
});

Okay, the filter is applied, comfort the marker I need, at this point print the filter information:

for (var i=0;i<as.length;i++){
    conteudo_info +=    "<tr>" +
                          "<td>" + as[i].UF + "</td>" +
                          "<td>" + as[i].DESC_CLUSTER + "</td>" +
                          "<td>" + as[i].DESC + "</td>" +
                          "<td>" + as[i].QNTD1+ "</td>" +
                          "<td>" + as[i].QNTD2+ "</td>" +
                        "</tr>" ;
}

I put five columns just to simplify, I have around 10.

What I need to do is, instead of presenting the 10 columns, I would like to present the result in a consolidated way.

Example(Original Base):

PR CTBA  A 1 1
PR CTBA  B 8 5
PR MGA   A 1 2
PR CTBA  C 2 0

Consolidated:

PR CTBA 11 6
PR MGA  1  2

Researching, I saw that can be done through the .reduce(), I found some examples, but I could not apply any, I am layman in the subject.

I found this link: sum-and-group-by-of-json-data, it applies on a column only, as I would for 4 for example, adding up my columns?

Example of the link:

var result = dataObject.reduce(function(res, obj) {
    if (!(obj.category in res))
        res.__array.push(res[obj.category] = obj);
    else {
        res[obj.category].hits += obj.hits;
        res[obj.category].bytes += obj.bytes;
    }
    return res;
}, {__array:[]}).__array
                .sort(function(a,b) { return b.bytes - a.bytes; });

Thank you.

Answer 1

I implemented a solution with 'Vanilla JS' (pure Javascript :p ).

Follows:

//Classe de agrupamento
function Foo(){
    // data source
    this.data = [];

    // retorna um array de objetos agrupados por propertyNames
    // propertyNames [array de string] - nomes das propriedades de agrupamento
    this.getGroupedData = function(propertyNames){
        if(!this.data.length || !propertyNames || !propertyNames.length) return [];

        var group = [], currentIndex, currentItem;

        for(var i in this.data){
            currentIndex = getGroupedItemIndex(group, propertyNames, this.data[i]);
            if(currentIndex >= 0){
                currentItem = group[currentIndex];
            }else{
                currentItem = {};
                for(var pi in propertyNames){
                    currentItem[propertyNames[pi]] = this.data[i][propertyNames[pi]];
                }
                currentItem.TOTAL_QNTD1 = 0;
                currentItem.TOTAL_QNTD2 = 0;
            }

            currentItem.TOTAL_QNTD1 += this.data[i].QNTD1;
            currentItem.TOTAL_QNTD2 += this.data[i].QNTD2;

            if(currentIndex >= 0){
                group[currentIndex] = currentItem;
            }else{
                group.push(currentItem);
            }
        }

        return group;
    }

    var getGroupedItemIndex = function(array, propertyNames, targetItem){
        var index = -1, found = true;

        for(var i in array){        
            for(var pi in propertyNames){
                found &= (array[i][propertyNames[pi]] === targetItem[propertyNames[pi]]);
            }
            if(found){
                index = i;
                break;
            }               

             // reset do valor para a próxima iteração
             found = true;
        }

        return index;
    }
}

Now only remains to instantiate, pass the data and get the grouped items.

var foo = new Foo();
foo.data = [{UF: 'PR', DESC_CLUSTER: 'CTBA', DESC: 'A', QNTD1: 1, QNTD2: 1}, {UF: 'PR', DESC_CLUSTER: 'CTBA', DESC: 'B', QNTD1: 8, QNTD2: 5}, {UF: 'PR', DESC_CLUSTER: 'MGA', DESC: 'A', QNTD1: 1, QNTD2: 2}, {UF: 'PR', DESC_CLUSTER: 'CTBA', DESC: 'C', QNTD1: 2, QNTD2: 0} ];

// obtém os dados agrupados por UF e DESC_CLUSTER
var groupedData = foo.getGroupedData(['UF', 'DESC_CLUSTER']);
//para melhor visualização no console: table(groupedData);