Well,
You can't sum price directly in your query since you are showing each
record individually as well, so I guess you'll need a combination.
a) in your controller: find('all', array('order' => 'Contractor.name,
Table.dt'))
b) in your view: sum up price while iterating. Whenever you get a new
contractor: display sum and reset
Alternatively, you could create a function in your Contractor model,
retrieving all contractors with contained items and have that function
calculate the sum into the contractor results.
On 11 feb, 13:56, "[email protected]" <[email protected]>
wrote:
> I have a table
> id
> buyer_id
> item_code
> contractor_id
> price
> dt
> item_name
>
> Now I want display dt(date) wise billing but contactor also will be in
> sequence like this:
>
> Contractor buyer_id item_code price
> item_name
> A 12 2112
> S jgj
> A
> 14 ..............................................
> ----------------------------------------------------------------------------------------------
> sum(price)
>
> B
> ......................................................................................
> B
> ......................................................................................
> B
> ......................................................................................
> ----------------------------------------------------------------------------------------------
> sum(price)
> C
> ......................................................................................
> C
> ......................................................................................
> C
> ......................................................................................
> ----------------------------------------------------------------------------------------------
> sum(price)
>
> how to write the query.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
