Hi,
You need to build and implement closure table,
look at this excellent presentation
http://www.slideshare.net/billkarwin/models-for-hierarchical-data (page 40),
I have recently implemented similar to www.farm.ba , where I now have the
ability to create unlimited number of levels.
Save
Create the following db tables:
table nodes, where you will have a minimum of the following fields:
id, title, path, parent_id, lft, rght, type
In the field: path, save the full path on which you will find your posts.
Field: type, is reserved for storing content types, eg '1 '. categories, '2
Thanks,
I will explore it and see how it turns out.
Dave
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of Salines
Sent: Saturday, March 30, 2013 11:13 AM
To: cake-php@googlegroups.com
Subject: Re: Product / Category Tree Help
Create the following db
: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of Salines
Sent: Saturday, March 30, 2013 11:13 AM
To: cake-php@googlegroups.com
Subject: Re: Product / Category Tree Help
Create the following db tables:
table nodes, where you will have a minimum of the following fields
I am building a shopping plugin and at the point where I am stuck with
routing the correct/ custom path and breadcrumbs.
The Category model actsAs Tree so that houses all the categories / sub
categories and the product belongs to the specific category so all that is
fine.
The end goal is