cakephp chain select in form with special conditions

Question

hi

My form application calls for 2 chained select boxes with special conditions, and I'm using cakephp 1.3 to build this application.

The hierarchy and order of choices for the sections is this:

1 - hotel

2 - roomtype

the hotel has limits of how many visitors can be in each room

The relationships are:

customer hasOne hotel->roomtype for x weekdays AND / OR weekenddays

hotels have many roomtypes

roomtypes has limits to amount of visitors and different prices on weekdays/weekends

The user selects dates "arrival" and "departure" to the hotel and thus the list is populated with hotels that have rooms availiable and then the list with rooms. im showing the calculated price on the next "confirm" page.

anyone have any good ideas? im real stuck here.

many thx

Answer 1

I would change your relationships and models. They don't make a ton of semantic sense -- why should a customer have one hotel roomtype? That doesn't make sense.

Instead, I'd recommend:

Room hasOne RoomType
Customer HABTM Reservation
Reservation hasOne RoomType

Is there a reason you don't want to make RoomType just a column in the Room model? Because then you could just have room, customer, reservation models that would collect all the information you need.