Skip to content

Instantly share code, notes, and snippets.

@fabriciomurta

fabriciomurta/60744-groupingListFilter.aspx

Created March 18, 2016 16:18
Show Gist options
  • Save fabriciomurta/52f19d2c0d1769f82f6a to your computer and use it in GitHub Desktop.
Save fabriciomurta/52f19d2c0d1769f82f6a to your computer and use it in GitHub Desktop.
Download ZIP
60744 - Problem when using listfilter
Raw
60744-groupingListFilter.aspx
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Collections.Generic" %>
<!DOCTYPE html>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
this.Store1.DataSource = new List<Project>
{
new Project(100, 'a', "Ext Forms: Field Anchoring", 112, "Integrate 2.0 Forms with 2.0 Layouts", 6, 150, 0, new DateTime(2007, 06, 24)),
new Project(100, 'a', "Ext Forms: Field Anchoring", 113, "Implement AnchorLayout", 4, 150, 0, new DateTime(2007, 06, 25)),
new Project(100, 'a', "Ext Forms: Field Anchoring", 114, "Add support for multiple types of anchors", 4, 150, 0, new DateTime(2007, 06, 27)),
new Project(100, 'b', "Ext Forms: Field Anchoring", 115, "Testing and debugging", 8, 0, 0, new DateTime(2007, 06, 29)),
new Project(101, 'a', "Ext Grid: Single-level Grouping", 101, "Add required rendering \"hooks\" to GridView", 6, 100, 0, new DateTime(2007, 07, 01)),
new Project(101, 'b', "Ext Grid: Single-level Grouping", 102, "Extend GridView and override rendering functions", 6, 100, 0, new DateTime(2007, 07, 03)),
new Project(101, 'b', "Ext Grid: Single-level Grouping", 103, "Extend Store with grouping functionality", 4, 100, 0, new DateTime(2007, 07, 04)),
new Project(101, 'b', "Ext Grid: Single-level Grouping", 121, "Default CSS Styling", 2, 100, 0, new DateTime(2007, 07, 05)),
new Project(101, 'a', "Ext Grid: Single-level Grouping", 104, "Testing and debugging", 6, 100, 0, new DateTime(2007, 07, 06)),
new Project(102, 'c', "Ext Grid: Summary Rows", 105, "Ext Grid plugin integration", 4, 125, 0, new DateTime(2007, 07, 01)),
new Project(102, 'a', "Ext Grid: Summary Rows", 106, "Summary creation during rendering phase", 4, 125, 0, new DateTime(2007, 07, 02)),
new Project(102, 'c', "Ext Grid: Summary Rows", 107, "Dynamic summary updates in editor grids", 6, 125, 0, new DateTime(2007, 07, 05)),
new Project(102, 'b', "Ext Grid: Summary Rows", 108, "Remote summary integration", 4, 125, 0, new DateTime(2007, 07, 05)),
new Project(102, 'a', "Ext Grid: Summary Rows", 109, "Summary renderers and calculators", 4, 125, 0, new DateTime(2007, 07, 06)),
new Project(102, 'c', "Ext Grid: Summary Rows", 110, "Integrate summaries with GroupingView", 10, 125, 0, new DateTime(2007, 07, 11)),
new Project(102, 'b', "Ext Grid: Summary Rows", 111, "Testing and debugging", 8, 125, 0, new DateTime(2007, 07, 15))
};
this.Store1.DataBind();
}
public class Project
{
public Project(int projectId, char grade, string name, int taskId, string description, int estimate, double rate, double cost, DateTime due)
{
this.ProjectID = projectId;
this.Grade = grade;
this.Name = name;
this.TaskID = taskId;
this.Description = description;
this.Estimate = estimate;
this.Rate = rate;
this.Due = due;
}
public int ProjectID { get; set; }
public char Grade { get; set; }
public string Name { get;set; }
public int TaskID { get; set; }
public string Description { get;set; }
public int Estimate { get;set; }
public double Rate { get; set; }
public double Cost { get; set; }
public DateTime Due { get; set; }
}
</script>
<html>
<head runat="server">
<title>GroupingSummary Plugin - Ext.NET Examples</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
<style>
.x-grid-body .x-grid-cell-Cost {
background-color : #f1f2f4;
}
.x-grid-row-summary .x-grid-cell-Cost .x-grid-cell-inner{
background-color : #e1e2e4;
}
.task .x-grid-cell-inner {
padding-left: 15px;
}
.x-grid-row-summary .x-grid-cell-inner {
font-weight: bold;
font-size: 11px;
background-color : #f1f2f4;
}
</style>
<script>
var totalCost = function (records) {
var i = 0,
length = records.length,
total = 0,
record;
for (; i < length; ++i) {
record = records[i];
total += record.get('Estimate') * record.get('Rate');
}
return total;
};
</script>
</head>
<body>
<form runat="server">
<h1>Group Summary Plugin</h1>
<p>Advanced grouping grid that allows cell editing and includes custom dynamic summary calculations.</p>
<ext:ResourceManager runat="server"/>
<ext:Store ID="Store1" runat="server" GroupField="Name">
<Sorters>
<ext:DataSorter Property="Due" Direction="ASC" />
</Sorters>
<Model>
<ext:Model runat="server" IDProperty="TaskID">
<Fields>
<ext:ModelField Name="ProjectID" />
<ext:ModelField Name="Grade" />
<ext:ModelField Name="Name" />
<ext:ModelField Name="TaskID" />
<ext:ModelField Name="Description" />
<ext:ModelField Name="Estimate" Type="Int" />
<ext:ModelField Name="Rate" Type="Float" />
<ext:ModelField Name="Cost" Type="Float" />
<ext:ModelField Name="Due" Type="Date" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
<ext:GridPanel
ID="GridPanel1"
runat="server"
Frame="true"
StoreID="Store1"
Title="Sponsored Projects"
Collapsible="true"
AnimCollapse="false"
Icon="ApplicationViewColumns"
Width="800"
Height="450">
<Plugins>
<ext:CellEditing runat="server" ClicksToEdit="1" />
<ext:GridFilters runat="server" />
</Plugins>
<ColumnModel runat="server">
<Columns>
<ext:Column
runat="server"
TdCls="task"
Text="Task"
Sortable="true"
DataIndex="Description"
Hideable="false"
SummaryType="Count"
Flex="1">
<SummaryRenderer Handler="return ((value === 0 || value > 1) ? '(' + value +' Tasks)' : '(1 Task)');" />
</ext:Column>
<ext:Column runat="server" Text="Grade" DataIndex="Grade" Width="58" Align="Center">
<Filter>
<ext:ListFilter />
</Filter>
</ext:Column>
<ext:Column runat="server" Text="Project" DataIndex="Name" Width="20" />
<ext:DateColumn
runat="server"
Text="Due Date"
Sortable="true"
DataIndex="Due"
SummaryType="Max"
Format="MM/dd/yyyy">
<Editor>
<ext:DateField runat="server" Format="MM/dd/yyyy" />
</Editor>
<%-- Remove after fixing #563 --%>
<SummaryRenderer Format="Date" FormatArgs="'m/d/Y'" />
</ext:DateColumn>
<ext:Column
runat="server"
Width="75"
Text="Estimate"
Sortable="true"
DataIndex="Estimate"
SummaryType="Sum">
<Renderer Handler="return value +' hours';" />
<%-- Remove after fixing #563 --%>
<SummaryRenderer Handler="return value + ' hours';" />
<Editor>
<ext:NumberField
runat="server"
AllowBlank="false"
MinValue="0"
StyleSpec="text-align:left" />
</Editor>
</ext:Column>
<ext:Column
runat="server"
Width="75"
Text="Rate"
Sortable="true"
DataIndex="Rate"
SummaryType="Average">
<Renderer Format="UsMoney" />
<%-- Remove after fixing #563 --%>
<SummaryRenderer Format="UsMoney" />
<Editor>
<ext:NumberField
runat="server"
AllowBlank="false"
MinValue="0"
StyleSpec="text-align:left" />
</Editor>
</ext:Column>
<ext:Column
runat="server"
Width="75"
ID="Cost"
Text="Cost"
Sortable="false"
Groupable="false"
DataIndex="Cost"
CustomSummaryType="totalCost">
<Renderer Handler="return Ext.util.Format.usMoney(record.data.Estimate * record.data.Rate);" />
<SummaryRenderer Format="UsMoney" />
</ext:Column>
</Columns>
</ColumnModel>
<View>
<ext:GridView runat="server" StripeRows="true" MarkDirty="false" />
</View>
<Features>
<ext:GroupingSummary
ID="GroupingSummary1"
runat="server"
GroupHeaderTplString="{name}"
HideGroupedHeader="true"
EnableGroupingMenu="false" />
</Features>
<TopBar>
<ext:Toolbar runat="server">
<Items>
<ext:Button
runat="server"
Text="Toggle"
ToolTip="Toggle the visibility of summary row"
EnableToggle="true"
Pressed="true"
Handler="#{GroupingSummary1}.toggleSummaryRow(!#{GroupingSummary1}.showSummaryRow);
#{GroupingSummary1}.view.refresh();" />
</Items>
</ext:Toolbar>
</TopBar>
</ext:GridPanel>
</form>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment