Re: Threaded count
I know that, product_count is the counter_cache, but only for the subcategories the ones that have a parent_id from the categories, is a threaded model, and when i select the main categories i want to know the count of the products in all the subcategories :). That's my dilemma. Thx. On Thu, 2009-05-14 at 13:47 -0700, majna wrote: there is counter cache counter_cache property. check manual. On May 14, 4:41 pm, Bogdan I. Bursuc bogdanbursu...@gmail.com wrote: I have the following model: categories: - id, - parent_id, - name, - product_count So, the model is threaded: exists main categories and subcategories that's it, but only subcategories contain products so only for subcategories product_count will be incremented. My question: Is there a way in cake so that when i do a find on the main categories to obtain the number of products in all it's subcategories. Thx. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Threaded count
Yes is related to cake, well all I want to know is if there is a
solution to this in cake.
I have Categories like
Array(
[0] = Array(
[Category] = Array(
[id] = 1,
[parent_id] = null,
[name] = 'Parent category 1',
[product_count] = 0
),
[children] = Array(
[0] = Array(
[Category] = Array(
[id] = 2,
[parent_id] = 1,
[name] = 'Subcategory 1',
[product_count] = 5
)
)
)
)
)
Thing is: i can only have products in a subcategory, I want to know if
it's a possibility in cake to obtain in the parent category the number
of products associated to it's subcategories.
What i have is
On Fri, 2009-05-15 at 01:58 -0700, majna wrote:
Try with find('all') with joins , group by, count.. to attach
product counts.
see Model::_findThreaded()if it can helps to SUM counts.
Do you think this problem is related to cakephp?
On May 15, 8:49 am, Bogdan I. Bursuc bogdanbursu...@gmail.com
wrote:
I know that, product_count is the counter_cache, but only for the
subcategories the ones that have a parent_id from the categories, is a
threaded model, and when i select the main categories i want to know the
count of the products in all the subcategories :). That's my dilemma.
Thx.
On Thu, 2009-05-14 at 13:47 -0700, majna wrote:
there is counter cache counter_cache property. check manual.
On May 14, 4:41 pm, Bogdan I. Bursuc bogdanbursu...@gmail.com
wrote:
I have the following model:
categories:
- id,
- parent_id,
- name,
- product_count
So, the model is threaded: exists main categories and subcategories
that's it, but only subcategories contain products so only for
subcategories product_count will be incremented.
My question:
Is there a way in cake so that when i do a find on the main
categories
to obtain the number of products in all it's subcategories.
Thx.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Threaded count
I have the following model: categories: - id, - parent_id, - name, - product_count So, the model is threaded: exists main categories and subcategories that's it, but only subcategories contain products so only for subcategories product_count will be incremented. My question: Is there a way in cake so that when i do a find on the main categories to obtain the number of products in all it's subcategories. Thx. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Threaded count
there is counter cache counter_cache property. check manual. On May 14, 4:41 pm, Bogdan I. Bursuc bogdanbursu...@gmail.com wrote: I have the following model: categories: - id, - parent_id, - name, - product_count So, the model is threaded: exists main categories and subcategories that's it, but only subcategories contain products so only for subcategories product_count will be incremented. My question: Is there a way in cake so that when i do a find on the main categories to obtain the number of products in all it's subcategories. Thx. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
