Hi All!
I have a problem with a complicated find and I'm stumped...
-- I have a problem with a complicated find and I'm stumped...
My database tables are:
Products
- id
- name
...
Orders
- id
- status
...
OrderItems
- id
- order_id
- product_id
- quantity
- line_total
...
And Models are:
Orders hasMany OrderItems
OrderItems belongTo Products, Orders
And I am trying to query all Products to get total number of OrderItems and sum of line_totals where the Order status is completed...
So I can generate a table:
Product Name | Number of Sales | Sales Total
A Bag | 10 | £50.00
...
Can anyone help? I'm getting nowhere fast...
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/groups/opt_out.
No comments:
Post a Comment