MultiGrouping Grid and Summary

[azesm]

Hi

My code MultiGrouping Grid and Summary ( ExtJs 4.0.7 or higher )

MultiGrouping
Снимок экрана 2012-09-15.jpg
MultiGroupingSummary
Снимок экрана 2012-09-15.jpg

mg.zip

Store:
...
groupers: ['field1', 'field2', 'field3', ...]

Grid:
features: [{ ftype: 'multigroupingsummarymy' }]
or
features: [{ ftype: 'multigrouping' }]

P.S. rebuild - http://www.sencha.com/forum/showthread.php?226739-MultiGrouping-and-MultiGroupingSummary
Thank you - ExTriqui

[scottmartin]

Thank you for the contribution.

Scott.

[icemanovich]

guidGenerator() is not defined in this code. Probably this function defined somewhere else.

Quick fix for this (insert in MultiGrouoping.js):

// Generate unique id for group
    guidGenerator: function(gname){
        var gid = 'x-' + gname + '-' + Ext.id();
        return gid;
    },

[azesm]

Hi


Code guidGenerator()

function guidGenerator() {
    var S4 = function() {
        return (((1 + Math.random()) * 0x10000) | 0).toString(16).substring(1);
    };
    return (S4() + S4() + "-" + S4() + "-" + S4() + "-" + S4() + "-" + S4() + S4() + S4());
}

Code trimFIO()

// Removes leading and ending whitespaces
function trimFIO( value ) {


    return LTrim(RTrim(value));
    
}

/// Removes leading whitespacesfunction LTrim( value ) {
    
    var re = /\s*((\S+\s*)*)/;
    return value.replace(re, "$1");
    
}


// Removes ending whitespaces
function RTrim( value ) {
    
    var re = /((\s*\S+)*)\s*/;
    return value.replace(re, "$1");
    
}

[icemanovich]

Thanks, azesm!
One more question. There is "group" parameter and it is group.id in MultiGrouping.js

group.id = guidGenerator();

How can I figure out parent of node on groupcontextmenu event?

 
groupcontextmenu: function(view, node, group, e, eOpts){
//group - text parens.id
}

Example:

mangle:
FORWARD
INPUT
OUTPUT

When i click to INPUT I need to know parent ("mangle").

[azesm]

Hi, icemanovich!

probably can not answer immediately, you need to experiment
group.id - I made in order to properly open subgroups, as in the original code, the map was not very nice

[icemanovich]

As quick solution I set group.id as composite field:

guidGenerator: function(group){
        var gid = '';
        if (group.records.length){

            if (group.records[0].data.table === group.name){
                gid = group.name;
            } else {
                gid = group.records[0].data.table + '/' + group.name;
            }
        }
        else {
            gid =  group.name;
        }
        return gid + '-' + Ext.id();
    },

P.S. azesm, thanks for adaptation for 4.07!

[azesm]

icemanovich,
Here's more to this grid would make the total amount of the line at the bottom. It would be cool at all.

[azesm]

Hi All!

Not much altered code and added the ability to include lines with the total amount

features: [
{
           ftype: 'multigroupingsummarymy',
           totalSummary: 'fixed',          // Can be: 'fixed', true, false. Default: false
           totalSummaryTopLine: true,      // Default: true
           totalSummaryColumnLines: false,        // Default: false          
           startCollapsed: true,
           forceFit: true,
           groupHeaderTpl: '{name} ({rows.length})'
}],

I have used code Mcaveti
"Grouping Summary with Total Row for Ext 4.0.7"
http://www.sencha.com/forum/showthre...478#post790478

[bbbbkai]

I don't know how to use multigroupingsummary, Who can give me a demo like this Снимок экрана 2012-09-15.jpg
Thanks
Email：bbbbkai@yahoo.com.cn