Just started with Cake for one simle app - online daily menu editor.
Briefly. One menu has many menu items. One menu item = one dish. one
dish = one dish type. There are 9 dish types (it's an indian
restaurant, so it's rice, naan, curry, veg. curry etc). Here is the db
structure
CREATE TABLE `dish_types`
(
`id` int(11) NOT NULL
auto_increment,
`name` varchar(100) collate utf8_czech_ci NOT
NULL,
PRIMARY KEY
(`id`)
)
CREATE TABLE `dishes`
(
`id` int(11) NOT NULL
auto_increment,
`name_en` text collate utf8_czech_ci NOT
NULL,
`name_cs` text collate utf8_czech_ci NOT
NULL,
`dish_type_id` int(11) NOT
NULL,
PRIMARY KEY
(`id`),
KEY `NewIndex1`
(`dish_type_id`),
CONSTRAINT `FK_dishes` FOREIGN KEY (`dish_type_id`)
REFERENCES `dish_types` (`id`) ON DELETE CASCADE
)
CREATE TABLE `menu_items`
(
`id` int(11) NOT NULL
auto_increment,
`menu_id` int(11) NOT
NULL,
`dish_id` int(11) NOT
NULL,
PRIMARY KEY
(`id`),
KEY `NewIndex1`
(`menu_id`),
KEY `NewIndex2`
(`dish_id`),
CONSTRAINT `FK_menu_items` FOREIGN KEY (`dish_id`)
REFERENCES `dishes` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_menu_items1` FOREIGN KEY (`menu_id`)
REFERENCES `menus` (`id`) ON DELETE CASCADE
)
CREATE TABLE `menus` (
`id` int(11) NOT NULL auto_increment,
`created` timestamp NOT NULL default CURRENT_TIMESTAMP,
`forday` date NOT NULL,
PRIMARY KEY (`id`)
)
Here is how I define model associations
class Menu extends AppModel {
var $hasMany = array(
'MenuItem' => array(
'className' => 'MenuItem',
'order' => 'Dish.dish_type_id asc'
)
);
}
class Dish extends AppModel {
var $belongsTo = 'DishType';
}
class MenuItem extends AppModel {
var $hasOne = 'Dish';
}
Now my trouble begin. I have a controller MenusController and an
action create. In the view create.ctp I want to see one date field
(that works) and 9 select fields to choose the 9 dishes for the day.
Now the question.
How do I automagically create the 9 select fields. I understand the
mechanism for 1 attribute, ie. if I do in controller $this->set
('dishes', $this->Dish->find('list'));
and in the view echo $form->input('Dish'); the select is there and
filled as expected.
But how to show 9 of them, each having only a subset of dishes. first
only rice, second naan etc)?
I already tried to do it manually. Meaning load the dishes in the
controller and then in the view call the method $form->select(...) 9
times to create 9 selects. But somehow I feel it goes against the
framework...or not?
Anyone have an idea?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
