Ah thanks for your help, I managed to sort it out.

Got it working quite nicely with ajax menu on the sidenav.

/countries/view/204 is the main screen showing the provinces for the
country (only one country now, so countries arent really used)
/provinces/view/xxx views the regions belonging to the province

the ajax menu calls /(currentaction)/ajaxmenu/(currentvalue) so even
if a user goes directly to a region/suburb etc then the ajax menu will
start where it should.

Thanks for your help though, managed to get it sorted after a stroke
of genius!

On Aug 30, 6:53 am, Sam <[email protected]> wrote:
> I think I know what you want but I'm not sure... let me know if I'm
> close.
>
> I'd do it one of two ways
>
> 1) User selects a province, page refreshes and now there are two
> dropdown boxes, first one has province selected, in the second user
> chooses region(and so forth)
> 2) User selects a province, select box appears with regions in that
> province(and so on and so forth)
>
> For method 1 I'd have the javascript submit the page each time a
> dropdown is changed- then the controller can figure out which menu
> items to load for the next select box. If several select boxes have
> been chosen, such as province, region and suburb, and province is
> changed, then the form would basically reset to only show the province
> and region select boxes.
>
> For method 2 I'd either use ajax to query the database based on the
> change in any of the select boxes, and reload the values in the select
> boxes. When the last select is chosen it loads the proper view.
>
> As for the menu knowing where the user is, simply set the relevant
> fields(province_id, region_id, suburb_id and establishment_id) based
> on the data that is loaded... if you load a suburb it should be
> relatively easy to get the region_id and province_id for that suburb.
>
> On Aug 29, 10:59 am, Bryan Paddock <[email protected]> wrote:
>
>
>
> > Hey all,
>
> > I've looked through pretty much every menu tutorial out there for cakephp
> > and have sat for ages to try and think up how I can achieve this but to no
> > avail.
>
> > I have a semi-complex database structure of establishments (restaurants,
> > hotels etc).
>
> > Province -> Region -> Suburb -> Establishment
>
> > as well as
>
> > Category -> Subcategory -> Establishment
>
> > Now the user needs to be able to select the province from the list, have it
> > show the regions under that province, then the suburbs, then a list of
> > subcategories under that province that contain establishments. I can handle
> > the fetching the data (eg how to pull out the list using containable etc)
> > but it's the starting foundation I'm having problems figuring out. IT will
> > be done in ajax but the actual ajax part I could probably do myself.
>
> > I would like to have the menu also build itself from the page that the user
> > is on (eg the user can browse around the menu in itself but if he also goes
> > to the a related page (eg suburbs/view/cape-town) then the menu should know
> > where the user is)
>
> > I honestly can't think of even where I should start here. Building a menu is
> > simple in plain php with simple relationships but it's getting pretty tricky
> > with all the extra levels.
>
> > Does anyone have any advice on a starting point which I could work with...
> > I'm trying to make it extendable in the sense that I don't want to hard code
> > anything.
>
> > I'm starting to think it may be better off to handle the menu separately in
> > a menu model and update the menu on each of the related models afterSave(),
> > etc callback but that seems a bit unnecessary as it would just be duplicated
> > data.
>
> > Thanks in advance!
>
> > Bryan

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Reply via email to