Grid Summary Plugin With Fixed Summary Row

[mystix]

mystix I download the zip and changed summaryRenderer and now with 0 record the count don't appear, this is ok but yet in the column summaryType: 'sum' appear $NaN.00,

that $NaN.00 issue is caused by the built-in Ext.util.Format.usMoney() method, which always assumes valid numbers are passed in.

use this override to fix that issue

Ext.util.Format.usMoney = function(v) { // override Ext.util.usMoney
  v = Ext.num(v, 0); // ensure v is a valid numeric value, otherwise use 0 as a base (fixes $NaN.00 appearing in summaryRow when no records exist)
  v = (Math.round((v - 0) * 100)) / 100;
  v = (v == Math.floor(v)) ? v + ".00" : ((v * 10 == Math.floor(v * 10)) ? v + "0" : v);
  v = String(v);
  var ps = v.split('.');
  var whole = ps[0];
  var sub = ps[1] ? '.'+ ps[1] : '.00';
  var r = /(\d+)(\d{3})/;
  while (r.test(whole)) {
      whole = whole.replace(r, '$1' + ',' + '$2');
  }
  v = whole + sub;
  if (v.charAt(0) == '-') {
    return '-$' + v.substr(1);
  }
  return "$" +  v;
}

should be hide like other

this is easily achieved via a custom summaryRenderer (like the one i used to display the total no. of companies).

a little detail is when you have several column in the grid with the summary if the grid have horizontal scroll you can watching a column for instance email column and in the summary appear $700.00 so maybe will be good to set in the summary something like Total: $700.00 a field label, what do you thing?

this is also easily achieved via a custom summaryRenderer. i've updated the example above with an example for the "Change" column.

thanks for the feedback

[edit]
fixed minor problem with toggleSummary

[franklt69]

sorry mystix I am wrong about horizontal scrolling, it is working ok

regards
Frank

[dado.cubo]

Ehm, sorry for my bad English, and also because it's the first time that I post with you.
I'm a beginner user of ExtJs and JavaScript.
Could you tell me if it's possible to use the Footer-Summary with a grid of examples\grid\totals.html?
How do I use it?
Thanks

[juljupy]

Hi, i've saw the screenshots and this is what i need for my project but i don't get it work, i got this error in firebug console: Ext.ns is not a function and Ext.ux.grid.GridSummary is not a constructor. when i run this file Ext.ux.grid.GridSummary.html, i've already add the ext link for js files but i'm still getting those errors, what's happening with this?

[juljupy]

Hi all,

I've already made it work, it's great!!
Thanks to you!!

[mystix]

Hi all,

I've already made it work, it's great!!
Thanks to you!!

yay.

[mystix]

Ehm, sorry for my bad English, and also because it's the first time that I post with you.
I'm a beginner user of ExtJs and JavaScript.
Could you tell me if it's possible to use the Footer-Summary with a grid of examples\grid\totals.html?
How do I use it?
Thanks

i've already included an example on how to use the GridSummary plugin in Ext.ux.GridSummary.html.
(the totals.html example is an example on how to use the GroupSummary plugin with an EditorGridPanel -- i've not tested if these 2 plugins work well together, but i strongly doubt so owing to the purpose of either plugin.)

if you're new to ExtJS i'd suggest starting with a simple grid example (e.g. array-grid.html) before trying out the plugin examples. there are a couple of concepts you need to be familiar with (like the Store, DataProxy, DataReader, ColumnModel etc) before you dive into the grid examples.

you might also want to check out the Learn section of the site to get up to speed with Ext 2.0 before diving into more complex components like the GridPanel / EditorGridPanel.

[saJoshua]

So cool! Nice going tinker & mystix

I have used the plugin in a paging grid and it works beautifully.

At the moment, I'm parsing to the server and fetching 30 records at a time. I'm considering using the PagingMemoryProxy to save the round trip.

I would really like to know if there is any chance that the summary could be on the entire datastore, not just the portion being rendered? Also, would it be possible to only aggregate on the store being loaded?

Thanks for this.
Joshua

[juljupy]

hi, thanks for that again, i got a question, how do i get the summary value to make another calculations with that value?

[saJoshua]

first guess would be to use the custom summaryRenderer.

What exactly are you trying to do?