Question [cakephp, model, virtualfields, mysql]

Hi all. I have a cakephp application with 3 tables, purchase_items, sale_items, stocks.

the schemas of the 3 tables are something like this:

stocks: id. name

purchase_items: id, stock_id, quantity, price

sale_items: id, stock_id, quantity, price

I wanted to query the available stocks, categorized by the cost (purchase_items.price).

Please kindly refer to the image here. I'd like to generate a virtual field available/cost.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.