Summary Rows in UniDBTreeGrid

[jrp]

Hello,

I'm looking at the UniDBTreeGrid example \FMSoft\Framework\uniGUI\Demos\Desktop\Grid - DBTreeGrid

How to display some summary in the rows below?

Thank you

[jrp]

Hello,

Somebody could help?

The summary could be the sum of the field (if the type of the field is numerical) or maybe anything else.

Thank you

[Sherzod]

1 hour ago, jrp said:

Somebody could help?

The summary could be the sum of the field (if the type of the field is numerical) or maybe anything else.

Hello,

Can you make a testcase for your case, I will try to analyze?

[jrp]

Hi Sherzod,

I will create a testcase in a day or two, but for now maybe you could have a look at the example above (\FMSoft\Framework\uniGUI\Demos\Desktop\Grid - DBTreeGrid) and use the company column to display the count of entries in each city (for example: Bahamas=4, Belize=1, Bermuda=2, etc).

Thank you

[Sherzod]

2 hours ago, jrp said:

but for now maybe you could have a look at the example above (\FMSoft\Framework\uniGUI\Demos\Desktop\Grid - DBTreeGrid) and use the company column to display the count of entries in each city (for example: Bahamas=4, Belize=1, Bermuda=2, etc).

Something like this?

[jrp]

3 hours ago, Sherzod said:

Something like this?

Yes Sherzod, that's it  How do you do that?

[Sherzod]

I will post.

[Sherzod]

6 hours ago, jrp said:

Yes Sherzod, that's it  How do you do that?

One possible solution:

function store.nodeexpand(sender, eOpts) 
{
    var store = this;
    var colIndx = 1; /* Second column */

    sender.childNodes.forEach(function(node) {
        var leafCount = 0;
        store.getNodeById(node.data.id).cascadeBy(function(_node) {
            if (_node.isLeaf()) leafCount++;

        });
        if (!node.isLeaf()) node.data[colIndx] = leafCount;
    });

    store.grid.getView().refresh();
}

 

[Sherzod]

You can simply adapt this solution for other operations, such as sum...

[jrp]

Hi Sherzod,

Thank you for the solution. But.. uhm... sorry... where to put the JavaScript function and how to use it? 😅

3 hours ago, Sherzod said:

One possible solution:

function store.nodeexpand(sender, eOpts) 
{
    var store = this;
    var colIndx = 1; /* Second column */

    sender.childNodes.forEach(function(node) {
        var leafCount = 0;
        store.getNodeById(node.data.id).cascadeBy(function(_node) {
            if (_node.isLeaf()) leafCount++;

        });
        if (!node.isLeaf()) node.data[colIndx] = leafCount;
    });

    store.grid.getView().refresh();
}

 

 

[Sherzod]

1 hour ago, jrp said:

where to put the JavaScript function and how to use it? 😅

UniDBTreeGrid.ClientEvents.ExtEvents [store]

[Sherzod]

[jrp]

Thank you very much Sherzod! I have tried it in the example, it worked