Guriddo » Topic: Grouping Data questions

Grouping Data questions

Guriddo
Grouping Data questions

This topic has 5 replies, 3 voices, and was last updated 5 years, 10 months ago by tony.

Creator

Topic
November 2, 2018 at 1:59 am #126990
krisreddy
Participant
Hello,

We are using v5.3.0 and using grouping with subgrid and celledit, grouping works great but having some trouble with summary
1. Tried to specify summaryType:’sum’ on a column that has formatter:’currency’ – seems to error out because I have cellattr on a another column. Can cellattr be used with grouping
2. How do change the style of the grouping row? background color?
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

November 2, 2018 at 2:01 pm #126991

guriddo.support

Participant

Hello,

About 1. Can you please post the grid setup and some simple data or send a demo link or demo files to the support?

About 2. It depend how you want to process.

a) In case if you want to add the same color of all first level grouping you can:


<style>
.jqGridghead_0 td {
	background-color: background;
}
</style>

<style>

.jqGridghead_0 td {

background-color: background;

}

</style>

where jqGrid word in the classname is the id of the grid.

for the second level the generated class is jqGridghead_1 and etc.

b) If you want to do this dynamically depending a value one possible solution is to get the grouping names and add the appropriate classes in loadComplete by example.

loadComplete: function () {
    var i, group, myClass, Pref = this.id + "ghead_",
        groups = $(this).jqGrid("getGridParam", "groupingView").groups,
        l = groups.length;
    for (i = 0; i < l; i++) {
        group = groups<em class="d4pbbc-italic"></em>;
        switch (group.value) {
        case "ALFKI":
            myClass = "class1";
            break;
        case "ANATR":
            myClass = "class2";
            break;
        default:
            myClass = "";
            break;
        }
        if (cssClass !== "") {
            $("#" + Pref + group.idx + "_" + i).addClass(cssClass);
        }
    }
}

loadComplete: function () {

var i, group, myClass, Pref = this.id + "ghead_",

groups = $(this).jqGrid("getGridParam", "groupingView").groups,

l = groups.length;

for (i = 0; i < l; i++) {

group = groups<em class="d4pbbc-italic"></em>;

switch (group.value) {

case "ALFKI":

myClass = "class1";

break;

case "ANATR":

myClass = "class2";

break;

default:

myClass = "";

break;

}

if (cssClass !== "") {

$("#" + Pref + group.idx + "_" + i).addClass(cssClass);

}

and then define a style like:


<style>
.class1 td {
background-color: background;
}
.class2 td {
background-color: green;
}
</style>

<style>

.class1 td {

background-color: background;

}

.class2 td {

background-color: green;

}

</style>

Kind Regards,
Will

Guriddo Support Team

November 2, 2018 at 11:33 pm #126993

krisreddy

Participant

Thank you for solution regarding background color.

Here’ s a link

http://50.53.70.243:90/jqgrid/gridGroupingData.php

you will see in code that columns – dblOrdered and curSalePrice – have cellattr function – if I remove the cellattr – then grouping summary renders correctly.

I believe the problem is rdata parameter is undefined for the grouping rows – this is what might be causing the issue.

Thanks,

Kris

November 6, 2018 at 11:05 am #126995

guriddo.support

Participant

Hello,

cellattr should not be a problem. We have prepared similar example and it works. See here

The problem is maybe in another part of the code. Try to use no grouping, but with cellattr function.

Kind Regards,

Will

Guriddo Support Team

November 6, 2018 at 5:10 pm #126997

krisreddy

Participant

Hello Will,

The code works fine when grouping is set to false

yes, I understand cellattr is not a problem, I believe the problem – is with rdata parameter. When cellattr is being processed for every row – grouping header/row does not have rdata object.

I had to specifically add a check and now it works.

,cellattr : function(rowId, cellValue, rawObject, cm, rdata) {
if(rdata !== 'undefined' && Array.isArray(rdata)){
if(rdata.ysnSub == '1'){
return " class='eg-ct-badge-blue'";
}
}
}