Very respectful. Well done. I suspect he does know the answer. Jeremy Burns Class Outfit
[email protected] http://www.classoutfit.com On 12 Feb 2011, at 04:24, sanjib dhar wrote: > "HOW TO DO THIS" is not an appropriate title for your thread! > by the way > ........................this means u don't know the answer right. > On Sat, Feb 12, 2011 at 5:10 AM, euromark <[email protected]> wrote: > "HOW TO DO THIS" is not an appropriate title for your thread! > by the way > > On 11 Feb., 18:27, sanjib dhar <[email protected]> wrote: > > What will be the function like?Can you please send me.I am new in cakephp. > > > > > > > > > > > > > > > > On Fri, Feb 11, 2011 at 6:55 PM, Mattijs <[email protected]> wrote: > > > 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 sitehttp://ask.cakephp.organd help > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > [email protected] For more options, visit this group > > > athttp://groups.google.com/group/cake-php > > -- > 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 > > > -- > 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 -- 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
