You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@wicket.apache.org by steve222 <st...@gmail.com> on 2008/10/11 00:27:15 UTC
Easiest way to add column totals to a table?
What is the easiest way to get the final row in a table to show the column
totals for numeric values? No need for paging or sorting - just a simple
table with column totals in the final row.
--
View this message in context: http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p19927092.html
Sent from the Wicket - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Easiest way to add column totals to a table?
Posted by steve222 <st...@gmail.com>.
Thanks. Will try this.
Steve
jwcarman wrote:
>
> Sorry, I mean addBottomToolbar()
>
> On Tue, Oct 14, 2008 at 1:25 PM, James Carman
> <ja...@carmanconsulting.com> wrote:
>> Have you tried creating a "toolbar"? You could call
>> setBottomToolbar() on your DataTable.
>>
>> On Tue, Oct 14, 2008 at 1:21 PM, steve222 <st...@gmail.com>
>> wrote:
>>>
>>> Maybe I did not phrase my original the question well enough to get an
>>> answer.
>>>
>>> I have a simple DataTable containing - let call it sales records. So,
>>> some
>>> columns have numbers (eg, sales prices, sales commission, etc). At the
>>> bottom of the table, I need a row showing the of sales prices for all
>>> items
>>> in the table.
>>>
>>> I've done something like this in my Panel (this code has been chopped
>>> about,
>>> so may not be correct - but you get the idea):
>>>
>>> public class SalesPanel extends PanelBase {
>>>
>>> private double totalSales = 0.0d;
>>> private Label totalSalesLabel = new Label("totalSalesLabel", "");
>>> private WebMarkupContainer listContainer = new
>>> WebMarkupContainer("listContainer");
>>>
>>> public SalesPanel (String id) {
>>> super(id);
>>>
>>> listContainer.add(new DataView("sales", dataProvider) {
>>>
>>> int i = 0;
>>>
>>> protected void populateItem(final Item item) {
>>>
>>> SalesItem salesitem = (SalesItem)
>>> item.getModelObject();
>>>
>>> item.add(new Label("salesref",
>>> String.valueOf(salesitem
>>> .getRef())));
>>>
>>> // add all the other columns here...
>>>
>>> // increment the total
>>> totalSales += salesitem .getSalesPrice();
>>> totalSalesLabel.setModel(new Model(totalSales));
>>>
>>> i++;
>>> // if we are on the last row, reset the total to
>>> zero so
>>> // total does not keep growing when panel is
>>> redisplayed
>>> // it's on a cached tab
>>> if(i == dataProvider.size()){
>>> i = 0;
>>> totalSales = 0;
>>> }
>>> }
>>> });
>>>
>>> addLabels();
>>> add(listContainer);
>>> }
>>> }
>>>
>>>
>>> But maybe there is a better way.
>>>
>>> And maybe a way to do this in an AjaxFallbackDefaultDataTable?
>>>
>>> Steve
>>>
>>>
>>>
>>>
>>>
>>> steve222 wrote:
>>>>
>>>> What is the easiest way to get the final row in a table to show the
>>>> column
>>>> totals for numeric values? No need for paging or sorting - just a
>>>> simple
>>>> table with column totals in the final row.
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p19978198.html
>>> Sent from the Wicket - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>>> For additional commands, e-mail: users-help@wicket.apache.org
>>>
>>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p20016024.html
Sent from the Wicket - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Easiest way to add column totals to a table?
Posted by James Carman <ja...@carmanconsulting.com>.
Sorry, I mean addBottomToolbar()
On Tue, Oct 14, 2008 at 1:25 PM, James Carman
<ja...@carmanconsulting.com> wrote:
> Have you tried creating a "toolbar"? You could call
> setBottomToolbar() on your DataTable.
>
> On Tue, Oct 14, 2008 at 1:21 PM, steve222 <st...@gmail.com> wrote:
>>
>> Maybe I did not phrase my original the question well enough to get an answer.
>>
>> I have a simple DataTable containing - let call it sales records. So, some
>> columns have numbers (eg, sales prices, sales commission, etc). At the
>> bottom of the table, I need a row showing the of sales prices for all items
>> in the table.
>>
>> I've done something like this in my Panel (this code has been chopped about,
>> so may not be correct - but you get the idea):
>>
>> public class SalesPanel extends PanelBase {
>>
>> private double totalSales = 0.0d;
>> private Label totalSalesLabel = new Label("totalSalesLabel", "");
>> private WebMarkupContainer listContainer = new
>> WebMarkupContainer("listContainer");
>>
>> public SalesPanel (String id) {
>> super(id);
>>
>> listContainer.add(new DataView("sales", dataProvider) {
>>
>> int i = 0;
>>
>> protected void populateItem(final Item item) {
>>
>> SalesItem salesitem = (SalesItem) item.getModelObject();
>>
>> item.add(new Label("salesref", String.valueOf(salesitem
>> .getRef())));
>>
>> // add all the other columns here...
>>
>> // increment the total
>> totalSales += salesitem .getSalesPrice();
>> totalSalesLabel.setModel(new Model(totalSales));
>>
>> i++;
>> // if we are on the last row, reset the total to
>> zero so
>> // total does not keep growing when panel is
>> redisplayed
>> // it's on a cached tab
>> if(i == dataProvider.size()){
>> i = 0;
>> totalSales = 0;
>> }
>> }
>> });
>>
>> addLabels();
>> add(listContainer);
>> }
>> }
>>
>>
>> But maybe there is a better way.
>>
>> And maybe a way to do this in an AjaxFallbackDefaultDataTable?
>>
>> Steve
>>
>>
>>
>>
>>
>> steve222 wrote:
>>>
>>> What is the easiest way to get the final row in a table to show the column
>>> totals for numeric values? No need for paging or sorting - just a simple
>>> table with column totals in the final row.
>>>
>>
>> --
>> View this message in context: http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p19978198.html
>> Sent from the Wicket - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>> For additional commands, e-mail: users-help@wicket.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Easiest way to add column totals to a table?
Posted by James Carman <ja...@carmanconsulting.com>.
Have you tried creating a "toolbar"? You could call
setBottomToolbar() on your DataTable.
On Tue, Oct 14, 2008 at 1:21 PM, steve222 <st...@gmail.com> wrote:
>
> Maybe I did not phrase my original the question well enough to get an answer.
>
> I have a simple DataTable containing - let call it sales records. So, some
> columns have numbers (eg, sales prices, sales commission, etc). At the
> bottom of the table, I need a row showing the of sales prices for all items
> in the table.
>
> I've done something like this in my Panel (this code has been chopped about,
> so may not be correct - but you get the idea):
>
> public class SalesPanel extends PanelBase {
>
> private double totalSales = 0.0d;
> private Label totalSalesLabel = new Label("totalSalesLabel", "");
> private WebMarkupContainer listContainer = new
> WebMarkupContainer("listContainer");
>
> public SalesPanel (String id) {
> super(id);
>
> listContainer.add(new DataView("sales", dataProvider) {
>
> int i = 0;
>
> protected void populateItem(final Item item) {
>
> SalesItem salesitem = (SalesItem) item.getModelObject();
>
> item.add(new Label("salesref", String.valueOf(salesitem
> .getRef())));
>
> // add all the other columns here...
>
> // increment the total
> totalSales += salesitem .getSalesPrice();
> totalSalesLabel.setModel(new Model(totalSales));
>
> i++;
> // if we are on the last row, reset the total to
> zero so
> // total does not keep growing when panel is
> redisplayed
> // it's on a cached tab
> if(i == dataProvider.size()){
> i = 0;
> totalSales = 0;
> }
> }
> });
>
> addLabels();
> add(listContainer);
> }
> }
>
>
> But maybe there is a better way.
>
> And maybe a way to do this in an AjaxFallbackDefaultDataTable?
>
> Steve
>
>
>
>
>
> steve222 wrote:
>>
>> What is the easiest way to get the final row in a table to show the column
>> totals for numeric values? No need for paging or sorting - just a simple
>> table with column totals in the final row.
>>
>
> --
> View this message in context: http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p19978198.html
> Sent from the Wicket - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Easiest way to add column totals to a table?
Posted by steve222 <st...@gmail.com>.
Maybe I did not phrase my original the question well enough to get an answer.
I have a simple DataTable containing - let call it sales records. So, some
columns have numbers (eg, sales prices, sales commission, etc). At the
bottom of the table, I need a row showing the of sales prices for all items
in the table.
I've done something like this in my Panel (this code has been chopped about,
so may not be correct - but you get the idea):
public class SalesPanel extends PanelBase {
private double totalSales = 0.0d;
private Label totalSalesLabel = new Label("totalSalesLabel", "");
private WebMarkupContainer listContainer = new
WebMarkupContainer("listContainer");
public SalesPanel (String id) {
super(id);
listContainer.add(new DataView("sales", dataProvider) {
int i = 0;
protected void populateItem(final Item item) {
SalesItem salesitem = (SalesItem) item.getModelObject();
item.add(new Label("salesref", String.valueOf(salesitem
.getRef())));
// add all the other columns here...
// increment the total
totalSales += salesitem .getSalesPrice();
totalSalesLabel.setModel(new Model(totalSales));
i++;
// if we are on the last row, reset the total to
zero so
// total does not keep growing when panel is
redisplayed
// it's on a cached tab
if(i == dataProvider.size()){
i = 0;
totalSales = 0;
}
}
});
addLabels();
add(listContainer);
}
}
But maybe there is a better way.
And maybe a way to do this in an AjaxFallbackDefaultDataTable?
Steve
steve222 wrote:
>
> What is the easiest way to get the final row in a table to show the column
> totals for numeric values? No need for paging or sorting - just a simple
> table with column totals in the final row.
>
--
View this message in context: http://www.nabble.com/Easiest-way-to-add-column-totals-to-a-table--tp19927092p19978198.html
Sent from the Wicket - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org