Grid Summary Plugin With Fixed Summary Row

[vnug]

Thanks, Mystix for the response. Follow-up questions - was anyone successful in porting this to 1.1? Or, any similar plug-in available for 1.1? Any and all information is appreciated.

best regards,

[rtconner]

For those of you trying to get this (Mystix version) to work with group summary...

I don't know how fast or efficient this is, but it works. This easy 3 step proccess with get you there

1. Replace this..

this.view.afterMethod('syncScroll', this.syncSummaryScroll, this);
this.view.afterMethod('onColumnWidthUpdated', this.doWidth, this);
this.view.afterMethod('onAllColumnWidthsUpdated', this.doAllWidths, this);
this.view.afterMethod('onColumnHiddenUpdated', this.doHidden, this);

with..

v.on('layout', this.setupUpdates, this);

2. then add fireEvent to onLayout...

  onLayout : function(vw, vh) {
    this.fireEvent('layout');
    // note: this method is scoped to the GridView
    if (!this.grid.getGridEl().hasClass('x-grid-hide-gridsummary')) {
      // readjust gridview's height only if grid summary row is visible
      this.scroller.setHeight(vh - this.summary.getHeight());
    }
  },

3. then add this method in to finish things up.

  setupUpdates : function() {
    this.refreshSummary();
    this.view.afterMethod('syncScroll', this.syncSummaryScroll, this);
    this.view.afterMethod('onColumnWidthUpdated', this.doWidth, this);
    this.view.afterMethod('onAllColumnWidthsUpdated', this.doAllWidths, this);
    this.view.afterMethod('onColumnHiddenUpdated', this.doHidden, this);
  },

[rtconner]

Oh and I was having a problem where I was getting NaN if there were no records. Just changed the calculate method to what is below to fix it.

  calculate : function(rs, cs) {
    var data = {}, r, c, cfg = this.cm.config, cf;
    for (var i = 0, len = cs.length; i < len; i++) {
      c = cs[i];
      cf = cfg[i];
      data[c.name] = 0;
      for (var j = 0, jlen = rs.length; j < jlen; j++) {
        r = rs[j];
        if (cf && cf.summaryType) {
          data[c.name] = Ext.grid.GridSummary.Calculations[cf.summaryType](data[c.name] || 0, r, c.name, data);
        }
      }
    }

    return data;
  },

[Richie1985]

i use the sum row in a editor grid. the problem is, when i type something in a cell and then i go to the next cell with tab, or enter key, then the cell has no focus, without this plugin dos it function. how can fix it? but this os only in internet explorer, not in firefox

[mystix]

i use the sum row in a editor grid. the problem is, when i type something in a cell and then i go to the next cell with tab, or enter key, then the cell has no focus, without this plugin dos it function. how can fix it? but this os only in internet explorer, not in firefox

huh???

[Richie1985]

sorry, i come from germany and my english is very baaaaaaaaaaaadl.

i try to describe it better:

i use this Grid Summary Plugin in a Editor Grid.
Normaly i can click in a cell and write mit value. then i press the "enter" key and the cursur jump to the next cell. this runs without the plugin in alle browser (ie7, ie6, and firefox).

but with the plugin, in ie6 the grid lost the focus when i leave the cell.

did you understand me?

thanks

[mystix]

@Richie1985, no worries. i don't speak a word of german

post your grid code, or a screencast (use Jing or something similar) and me / someone will take a look at it.
unfortunately, i don't have IE6 on hand, only IE7, so i'll have to start by inspecting your grid code.

[edit]
get the latest GridSummary update from my initial post.
i've updated the code to include fixes posted by various users.

[crpatrick]

Please disreguard the below. I created only one instance of the summary plugin, and used on both grids. Wouldn't you know I saw that the minute I posted.

Thanks again for the plugin!

___________________________________________ Disreguard below this line....

Hi there-

First...great plugin!

I am seeing something a little weird with multiple grids on a page. I have a border layout, and the first grid with summary row renders in the center region. Once rendered, the user can resize/scroll, and the summary row resizes/scrolls as expected. When the user clicks on a row item, a second grid is built within the southern region, with another summary panel. The thing I am seeing though is that if a user resizes/scrolls the columns of the first grid, it resizes/scrolls the summary row columns of the second. Is there something that anyone can think of that may be tying the summary row of the second grid to the first/second displayed grids?

Thanks for any help.
Chris

[mystix]

@crpatrick, you do know there's a strikethrough tag right?

doing

[s]cows are cute[/s]

would give you

cows are cute

enjoy

[nuser]

as @SaJoshua has mentioned, you may manipulate the 'sum' value (or 'count' / 'max' / 'min' / 'average' values) via a custom summaryRenderer.

add the following function to the included example

function squareIt(v, params, data) {
  return v? (Math.pow(v * 1000, 2) / Math.pow(1000, 2)) : '';
}

and add the following summaryRenderer to the column with the sum

{header: "Price", width: 75, sortable: true, renderer: 'usMoney', dataIndex: 'price', summaryType: 'sum', editor: new Ext.form.NumberField({allowDecimals: true}), summaryRenderer: squareIt},

the summaryRenderer method is always passed 3 params:

• v - the value computed by the column's respective summaryType function
• params - the cell params css, id, style and value
• data - computed data for all cells in the summary row

I need the sum value of two columns to derive the average value for a third column e.g. average price = sum cost / sum qty.

I've been trying to figure out how to use the summaryRenderer to achieve this without success. Appreciate if someone could shed some light on how this could be done.

Tks & Best Rgds