PDA

View Full Version : [CLOSED] set background color for each grouping throws error message



Fahd
Jun 29, 2012, 2:00 AM
Hi,
I am trying to set different background colors for each grouping in my grid. I got this code from
the following 2.0 example but it is not working for me. I keep getting the "Invalid Property Value " error message.
http://examples2.ext.net/#/GridPanel/Miscellaneous/Grouping/

I am running IE 8.0

4416

Thank you very much in advance for your help. Below is my code:



<%@ Page Language="C#" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.Store1.DataSource = new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
};

this.Store1.DataBind();
}
}
</script>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<title>FormPanel - Ext.NET Examples</title>

<script type="text/javascript">
// this "setGroupStyle" function is called when the GroupingView is refreshed.
var setGroupStyle = function (view) {
// get an instance of the Groups
var groups = view.el.query(App.Grouping1.eventSelector);

for (var i = 0; i < groups.length; i++) {
var groupId = Ext.fly(groups[i]).next().id.substr((view.id + '-gp-').length),
records = view.panel.store.getGroups(groupId).children,
color = "#" + records[0].data.ColorCode;

// Set the "background-color" of the original Group node.
Ext.get(groups[i]).select('.x-grid-cell-inner').setStyle("background-color", color);
}
};

</script>
</head>
<body>
<form id="Form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:FormPanel ID="FormPanel1" runat="server" Title="Company data" Width="800" BodyPadding="5"
Layout="ColumnLayout">
<FieldDefaults LabelAlign="Left" MsgTarget="Side" />
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" Title="Company Data" ColumnWidth="0.6"
Height="400">
<Store>
<ext:Store ID="Store1" runat="server" GroupField="rating" GroupDir="DESC">
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
<ext:ModelField Name="rating" Type="Int" >
<Convert Handler="var pct = record.get('pctChange'); if (pct < 0) return 2; if (pct < 1) return 1; return 0;" />
</ext:ModelField>
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ID="Column1" runat="server" Text="Company" DataIndex="company" Flex="1" />
<ext:Column ID="Column2" runat="server" Text="Price" Width="75" DataIndex="price" />
<ext:Column ID="Column3" runat="server" Text="Change" Width="75" DataIndex="change" />
<ext:Column ID="Column4" runat="server" Text="Change" Width="75" DataIndex="pctChange" />
<ext:DateColumn ID="DateColumn1" runat="server" Text="Last Updated" Width="85" DataIndex="lastChange" />
<ext:Column ID="Column5" runat="server" Text="Rating" Width="30" Sortable="true"
DataIndex="rating" />

</Columns>
</ColumnModel>
<View>
<ext:GridView ID="GridView1" runat="server">
<Listeners>
<Refresh Fn="setGroupStyle" />
</Listeners>
</ext:GridView>
</View>
<Features>
<ext:Grouping ID="Grouping1" runat="server" HideGroupedHeader="true" StartCollapsed="false"
GroupHeaderTplString='{text} ({[values.rows.length]} {[values.rows.length > 1 ? "Items" : "Item"]})' />
</Features>
</ext:GridPanel>

</Items>
</ext:FormPanel>
</form>
</body>
</html>

Daniil
Jun 29, 2012, 12:14 PM
Hi,

I think you should still use the GetRowClass feature as here:
http://forums.ext.net/showthread.php?19291&p=83132&viewfull=1#post83132

Example

<ext:GridPanel runat="server">
<Features>
<ext:Grouping runat="server" />
</Features>
<View>
<ext:GridView>
<GetRowClass Fn="getRowClass" />
</ext:GridView>
</View>
</ext:GridPanel>

Fahd
Jun 29, 2012, 3:04 PM
Hi,
It is very impressive that you still remember that I did the same thing back in Version 1.4.
Yes I did tried using the the GetRowClass feature but I got this error message - "Object doesn't support this property or method":
4418
I think it is not finding the "this.getGroupField()" I as I can't find it through the debugger.

Can you please take a look why is throwing the error? Thanks for your help.
Below is my new code using the GetRowClass function:


<%@ Page Language="C#" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.Store1.DataSource = new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
};

this.Store1.DataBind();
}
}
</script>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<title>FormPanel - Ext.NET Examples</title>
<script type="text/javascript">
var getRowClass = function (record, index, rowParams, store) {
var cls = record.get(this.getGroupField());
var d = new Date(cls);
var aDay = d.getDay();

switch (aDay) {
case 0:
cls = "clsSunday";
break;
case 1:
cls = "clsMonday";
break;
case 2:
cls = "clsTuesday";
break;
case 3:
cls = "clsWednesday";
break;
case 4:
cls = "clsThursday";
break;
case 5:
cls = "clsFriday";
break;
case 6:
cls = "clsSaturday";
break;
}

return cls;
};
</script>
</head>
<body>
<form id="Form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:FormPanel ID="FormPanel1" runat="server" Title="Company data" Width="800" BodyPadding="5"
Layout="ColumnLayout">
<FieldDefaults LabelAlign="Left" MsgTarget="Side" />
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" Title="Company Data" ColumnWidth="0.6"
Height="400">
<Store>
<ext:Store ID="Store1" runat="server" GroupField="rating" GroupDir="DESC">
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
<ext:ModelField Name="rating" Type="Int">
<Convert Handler="var pct = record.get('pctChange'); if (pct < 0) return 2; if (pct < 1) return 1; return 0;" />
</ext:ModelField>
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ID="Column1" runat="server" Text="Company" DataIndex="company" Flex="1" />
<ext:Column ID="Column2" runat="server" Text="Price" Width="75" DataIndex="price" />
<ext:Column ID="Column3" runat="server" Text="Change" Width="75" DataIndex="change" />
<ext:Column ID="Column4" runat="server" Text="Change" Width="75" DataIndex="pctChange" />
<ext:DateColumn ID="DateColumn1" runat="server" Text="Last Updated" Width="85" DataIndex="lastChange" />
<ext:Column ID="Column5" runat="server" Text="Rating" Width="30" Sortable="true"
DataIndex="rating" />
</Columns>
</ColumnModel>
<Features>
<ext:Grouping ID="Grouping1" runat="server" HideGroupedHeader="true" StartCollapsed="false"
GroupHeaderTplString='{text} ({[values.rows.length]} {[values.rows.length > 1 ? "Items" : "Item"]})' />
</Features>
<View>
<ext:GridView ID="GridView1" runat="server">
<GetRowClass Fn="getRowClass" />
</ext:GridView>
</View>
</ext:GridPanel>
</Items>
</ext:FormPanel>
</form>
</body>
</html>





Hi,

I think you should still use the GetRowClass feature as here:
http://forums.ext.net/showthread.php?19291&p=83132&viewfull=1#post83132

Example

<ext:GridPanel runat="server">
<Features>
<ext:Grouping runat="server" />
</Features>
<View>
<ext:GridView>
<GetRowClass Fn="getRowClass" />
</ext:GridView>
</View>
</ext:GridPanel>

Daniil
Jun 29, 2012, 4:05 PM
I think it is not finding the "this.getGroupField()" I as I can't find it through the debugger.


This method has been moved to the Grouping feature.

Please use:

var grouping = this.featuresMC.findBy(function (f) {
return f.ftype === "grouping";
}),
groupField = grouping.getGroupField();

Fahd
Jun 29, 2012, 5:46 PM
Hi,
Thanks for the update.
I just tried your code. grouping.getGroupField() does return me the correct group field. However, the
<GetRowClass Fn="getRowClass" /> does not seem to be able to apply the "Cls" to the groups. I do not see any background color set for the three groups.

Please advice.
Below is my code:


<%@ Page Language="C#" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.Store1.DataSource = new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
};

this.Store1.DataBind();
}
}
</script>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<title>FormPanel - Ext.NET Examples</title>
<style type="text/css">
/* Runs Backgroud Color */
.clsSunday
{
background-color: #afeeee; /*blue*/
}
.clsMonday
{
background-color: #FAEBD7; /*AntiqueWhite*/
}
.clsTuesday
{
background-color: #00FFFF; /*Aqua*/
}
.clsWednesday
{
background-color: #ADFF2F; /*GreenYellow*/
}
.clsThursday
{
background-color: #D8BFD8; /*Thistle*/
}
.clsFriday
{
background-color: #F0E68C; /*Khaki*/
}
.clsSaturday
{
background-color: #ffdab9; /*pink*/
}
</style>
<script type="text/javascript">
var getRowClass = function (record, index, rowParams, store) {

var grouping = this.featuresMC.findBy(function (f) { return f.ftype === "grouping"; }), groupField = grouping.getGroupField();
var cls = record.get(groupField);

switch (cls) {
case 0:
cls = "clsSunday";
break;
case 1:
cls = "clsMonday";
break;
case 2:
cls = "clsTuesday";
break;
case 3:
cls = "clsWednesday";
break;
case 4:
cls = "clsThursday";
break;
case 5:
cls = "clsFriday";
break;
case 6:
cls = "clsSaturday";
break;
}

return cls;
};


</script>
</head>
<body>
<form id="Form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:FormPanel ID="FormPanel1" runat="server" Title="Company data" Width="800" BodyPadding="5"
Layout="ColumnLayout">
<FieldDefaults LabelAlign="Left" MsgTarget="Side" />
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" Title="Company Data" ColumnWidth="0.6"
Height="400">
<Store>
<ext:Store ID="Store1" runat="server" GroupField="rating" GroupDir="DESC">
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
<ext:ModelField Name="rating" Type="Int">
<Convert Handler="var pct = record.get('pctChange'); if (pct < 0) return 2; if (pct < 1) return 1; return 0;" />
</ext:ModelField>
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ID="Column1" runat="server" Text="Company" DataIndex="company" Flex="1" />
<ext:Column ID="Column2" runat="server" Text="Price" Width="75" DataIndex="price" />
<ext:Column ID="Column3" runat="server" Text="Change" Width="75" DataIndex="change" />
<ext:Column ID="Column4" runat="server" Text="Change" Width="75" DataIndex="pctChange" />
<ext:DateColumn ID="DateColumn1" runat="server" Text="Last Updated" Width="85" DataIndex="lastChange" />
<ext:Column ID="Column5" runat="server" Text="Rating" Width="30" Sortable="true"
DataIndex="rating" />
</Columns>
</ColumnModel>
<Features>
<ext:Grouping ID="Grouping1" runat="server" HideGroupedHeader="true" StartCollapsed="false"
GroupHeaderTplString='{text} ({[values.rows.length]} {[values.rows.length > 1 ? "Items" : "Item"]})' />
</Features>
<View>
<ext:GridView ID="GridView1" runat="server">
<GetRowClass Fn="getRowClass" />
</ext:GridView>
</View>
</ext:GridPanel>
</Items>
</ext:FormPanel>
</form>
</body>
</html>


Thanks!


This method has been moved to the Grouping feature.

Please use:

var grouping = this.featuresMC.findBy(function (f) {
return f.ftype === "grouping";
}),
groupField = grouping.getGroupField();

Daniil
Jul 02, 2012, 10:59 AM
The markup and CSS styles of the grid rows have been changed in Ext.NET v2.

I think you should also correct the CSS rules adding the ".x-grid-cell" selector like this:

.clsSunday .x-grid-cell
{
background-color: #afeeee; /*blue*/
}

Fahd
Jul 02, 2012, 1:17 PM
Thank you very much. It worked!


The markup and CSS styles of the grid rows have been changed in Ext.NET v2.

I think you should also correct the CSS rules adding the ".x-grid-cell" selector like this:

.clsSunday .x-grid-cell
{
background-color: #afeeee; /*blue*/
}