Grid Summary Plugin With Fixed Summary Row

[lychorojostone]

i would think it would make more sense to show the subtotal for any given page (if used in a paging grid) as opposed to showing the total, until the last page is reached and the total for the entire paging grid is then displayed. (this, unfortunately, isn't supported atm.)

thoughts?

First of all... thanks for the answer!
You are rigth... maybe showing both: subtotals ( what the user is looking at ) and totals would make more sense...
Imagine a grid that shows losses and earnings ( with a lot of pages ). The end-user should see the total balance

thoughts?

Lisandro

[mystix]

yep, that's exactly what i had in mind.

i have no need for that functionality atm, though it sounds like a fun side-project

let us know if you decide to try your hand at it, and perhaps some of the folk here could chip in along the way.

[edit]
this should be somewhat simpler now, since i've recently refactored the code and added a rowIdx param to the calculation methods.

[mcouillard]

Lovely extension, thank you. Question: how to get the value of a summary cell? I've looked all through the summary object using Firebug - no luck. I also checked the Store - seems the Summary data isn't there.

Background: Summary in use on an EditorGrid. Most cells are editable, numeric. The summary values thus change on edit of main content cells. To "save and exit" the EditorGrid, I must check the right-most column's summary cell value and take action based on it's value.

Any ideas?

[mystix]

@mcouillard: get a reference to the gridsummaryplugin, call gridsummaryplugin.getSummaryNode() and inspect the appropriate cell for the value you need.

[httpdotcom]

exactly...First I assigned

var summary = new Ext.ux.grid.GridSummary() ;

and then, in my grid, I used

...plugins:          [summary],...

so, I could reference summary.getSummaryNode().
mcouillard, try that and please post results.

[mystix]

exactly...First I assigned

var summary = new Ext.ux.grid.GridSummary() ;

and then, in my grid, I used

...plugins:          [summary],...

so, I could reference summary.getSummaryNode().
mcouillard, try that and please post results.

although it might be a good idea to somehow make the summary row data (or node for the matter) available to the grid...

i'll chew on this over the weekend.

[mcouillard]

@mcouillard: get a reference to the gridsummaryplugin, call gridsummaryplugin.getSummaryNode() and inspect the appropriate cell for the value you need.

Solved. Thank you both, Mystix and httpdotcom!

...
var summary = new Ext.ux.grid.GridSummary();
...
  plugins: [summary],
...
//get the DOM of the summary element, wrap in Ext Element, query the last TD, get the first array element and get the underlying text - no matter how nested
var rightMostSummaryCell= Ext.get(summary.getSummaryNode().dom).query('td:last')[0].getText();

Took me a bit longer than I thought to piece together the right methods, but that's mostly due to my inexperience with Ext JS in general. Though, and you may agree even more Mystix, it'd be nice to have the summary data stored in a more approachable place!

[mondomon]

@eliezerreis, found 2 funky bugs in the demo:

1. gridsummary row's columns don't get resized when their respective column headers are resized (i hope this wasn't part of my gridsummary implementation.. ). if the gridsummary row is toggled, the gridsummary row's columns are resized correctly.

[edit]
i should've mentioned i tested this in FF2.0.0.14

I want first thank those that help contribute to this plugin. I am using this with a group summary grid and wondering if is there a fix for this bug?

What function can I look into to get this to work.

[mystix]

check the rest of the thread. someone else has already posted tips on successfully using both gridsummary and groupsummary plugins together.

[mondomon]

check the rest of the thread. someone else has already posted tips on successfully using both gridsummary and groupsummary plugins together.

I have fixed the issue with the gridsummary row and groupsummary row not being resized correctly.

Just replace doWidth with this

doWidth : function(col, w, tw) {
        var s = this.view.summary.dom, gs = this.view.getGroups(), r;
        s.firstChild.style.width = tw;
        s.firstChild.rows[0].childNodes[col].style.width = w;
        for (var i = 0, len = gs.length; i < len; i++) {
            r = gs[i].childNodes[2];
            r.style.width = tw;
            r.firstChild.style.width = tw;
            r.firstChild.rows[0].childNodes[col].style.width = w;
        }
    },

and replace doAllWidths with this

doAllWidths : function(ws, tw) {
        var s = this.view.summary.dom, gs = this.view.getGroups(), r, cells, cellsgs, wlen = ws.length;
        s.firstChild.style.width = tw;
        cells = s.firstChild.rows[0].childNodes;
        for (var i = 0, len = gs.length; i < len; i++) {
            r = gs[i].childNodes[2];
            r.style.width = tw;
            r.firstChild.style.width = tw;
            cellsgs = r.firstChild.rows[0].childNodes;
        
            for (var j = 0; j < wlen; j++) {
                cells[j].style.width = ws[j];
                cellsgs[j].style.width = ws[j];
            }
        }
    },