Smarty

[clj83]

Hi,

Not sure if this is possible but what I am trying to do is add some amounts within a foreach loop and create some subtotals. The problem is that I need to create a number of subtotals from within the foreach loop.

The foreach loop looks like this,

{foreach from=$lines item=entry}
{$entry->id}
{$entry->amount}
{/foreach}

And an example of the output would be this,

Job ID Amount
482 €30.00
482 €60.00
482 €90.00
489 €30.00
489 €60.00
490 €30.00

What I need is it to look like this,

Job ID Amount
482 €180.00
489 €90.00
490 €30.00

So you can see where the Job ID's are the same I want to add the amounts to create a sub-total.

I can get a running total using this math,

{math assign="amount" equation="x + y" x=$amount|default:0 y=$entry->amount|default:0}

But that doesnt provide the sub total I am after.

Can anyone advise if they think this is even possible within a foreach loop.

Thanks

Chris

[rodneyrehm]

In Smarty3 you can achieve your goal quite easily:

[clj83]

Hi,

Thanks for the reply. Unfortunately I am using CMSMS which currently only uses Smarty2.

I found this plugin, http://smarty.incutio.com/?page=foreachgroup, called foreachgroup which I thought could be useful. However, I cannot get it to work.

Is there anyway to achieve the same result in Smarty2?

Thanks

Chris