Я хочу сделать этот урок http://miftyisbored.com/complete-tutorial-habtm-relationships-cakephp/ в тортPHP 3.0
У меня есть 3 таблицы: рецепты, ингредиенты и ингредиенты_ рецепты.
При составлении рецепта я хочу выбрать ингредиенты. Затем я хочу сохранить recipe_id и attribute_id в таблице ингридиенты_рецептов, но не могу этого сделать. Я думаю, что-то не так в моем RecipesController. Может ли кто-нибудь помочь мне или указать мне правильное направление?
Проблема:
$ingredients = $this->Recipes->Ingredients->find('list', ['limit' => 200]);
// => THIS GIVES ME THE MESSAGE "The recipe could not be saved. Please, try again."
$ingredients = $this->Ingredients->find('list', ['limit' => 200]);
// => THIS GIVES ME THE ERROR "Call to a member function find() on boolean"
Когда я делаю var dump (при использовании этого $ this-> Recipes-> Ingredients-> find) я получаю это:
array(3) {
["recipe_name"]=> string(4) "Test"["recipe_description"]=> string(4) "Test"["Recipe"]=> array(1) {
["Ingredient"]=> array(1) { [0]=> string(1) "1" }
}
}
Таблицы:
CREATE TABLE `recipes` (
`recipe_id` int(11) NOT NULL auto_increment,
`recipe_name` varchar(255) NOT NULL,
`recipe_description` text NOT NULL,
PRIMARY KEY (`recipe_id`)
);
CREATE TABLE `ingredients` (
`ingredient_id` int(11) NOT NULL auto_increment,
`ingredient_name` varchar(255) NOT NULL,
`ingredient_description` text NOT NULL,
PRIMARY KEY (`ingredient_id`)
);
CREATE TABLE `ingredients_recipes` (
`ingredient_id` int(11) NOT NULL,
`recipe_id` int(11) NOT NULL,
PRIMARY KEY (`ingredient_id`,`recipe_id`)
);
Вот мой код ниже:
Модель> Сущность:
Рецепт
class Recipe extends Entity
{
protected $_accessible = [
'recipe_id' => true,
'recipe_name' => true,
'recipe_description' => true,
];
}
Ингредиент
class Ingredient extends Entity
{
protected $_accessible = [
'ingredient_id' => true,
'ingredient_name' => true,
'ingredient_description' => true,
];
}
IngredientsRecipe
class IngredientsRecipe extends Entity
{
protected $_accessible = [
'ingredient' => true,
'recipe' => true,
];
}
Модель> Таблица:
RecipesTable
class RecipesTable extends Table
{
public function initialize(array $config)
{
$this->table('recipes');
$this->displayField('recipe_name');
$this->primaryKey('recipe_id');
$this->belongsTo('Recipes', [
'foreignKey' => 'recipe_id',
'joinType' => 'INNER'
]);
$this->belongsToMany('Ingredients', [
'className' => 'Ingredients',
'joinTable' => 'ingredients_recipes',
'foreignKey' => 'recipe_id',
'targetForeignKey' => 'ingredient_id'
]);
}
public function validationDefault(Validator $validator)
{
$validator
->requirePresence('recipe_name', 'create')
->notEmpty('recipe_name')
->requirePresence('recipe_description', 'create')
->notEmpty('recipe_description')
->requirePresence('Ingredients', 'create')
->notEmpty('Ingredients');
return $validator;
}
}
IngredientsTable
class IngredientsTable extends Table
{
public function initialize(array $config)
{
$this->table('ingredients');
$this->displayField('ingredient_name');
$this->primaryKey('ingredient_id');
$this->belongsTo('Ingredients', [
'foreignKey' => 'ingredient_id',
'joinType' => 'INNER'
]);
$this->belongsToMany('Recipies', [
'className' => 'Recipies',
'joinTable' => 'ingredients_recipes',
'foreignKey' => 'ingredient_id',
'targetForeignKey' => 'recipe_id'
]);
}
}
IngredientsRecipesTable
class IngredientsRecipesTable extends Table
{
public function initialize(array $config)
{
$this->table('ingredients_recipes');
$this->displayField('recipe_id');
$this->primaryKey(['recipe_id', 'ingredient_id']);
$this->belongsTo('Recipies', [
'foreignKey' => 'recipe_id',
'joinType' => 'INNER'
]);
$this->belongsTo('Ingredients', [
'foreignKey' => 'ingredient_id',
'joinType' => 'INNER'
]);
}
контроллер:
RecipesController
public function add()
{
$recipe = $this->Recipes->newEntity();
if ($this->request->is('post')) {
$recipe = $this->Recipes->patchEntity($recipe, $this->request->data);
// var_dump($this->request->data);
if ($this->Recipes->save($recipe)){
$this->Flash->success('The recipe has been saved.');
return $this->redirect(['action' => 'index']);
} else {
$this->Flash->error('The recipe could not be saved. Please, try again.');
}
}
$recipes = $this->Recipes->find('list', ['limit' => 200]);
$ingredients = $this->Recipes->Ingredients->find('list', ['limit' => 200]);
// => THIS GIVES ME THE MESSAGE "The recipe could not be saved. Please, try again."$ingredients = $this->Ingredients->find('list', ['limit' => 200]);
// => THIS GIVES ME THE ERROR "Call to a member function find() on boolean"
$this->set(compact('recipe', 'recipes', 'ingredients'));
$this->set('_serialize', ['recipe']);
}
Шаблон> Рецепты
add.ctp
<?= $this->Form->create($recipe); ?>
<fieldset>
<legend><?= __('Add Recipe') ?></legend>
<?php
echo $this->Form->input('recipe_name', array(
'label' => 'Name'
)
);
echo $this->Form->input('recipe_description', array(
'label' => 'Description'
)
);
echo $this->Form->input('Recipes.Ingredients', ['multiple'=>true]);
?>
</fieldset>
<?= $this->Form->button(__('Submit')) ?>
<?= $this->Form->end() ?>
Может быть, этот урок может помочь: http://book.cakephp.org/3.0/en/tutorials-and-examples/bookmarks/intro.html.
Он объясняет, как именно установить отношения HABTM, добавить теги в закладки и многое другое.
Удачи и счастливого кодирования 🙂
Других решений пока нет …