CakePHP saveAll/saveAssociated issue


CakePHP saveAll/saveAssociated issue

我对下面的CakePHP结果有点困惑。我包含了两个Model和一个Controller的代码(去掉了不必要的东西)。

问题:所有东西都能正确保存。唯一的问题是store_users表的user_id字段没有保存

你能看出我做错了什么吗?我尝试了saveAssociated和saveAll。

Model/Store.php

<?php
App::uses('AppModel', 'Model');
class Store extends AppModel {
    public $belongsTo = array(
        'User'
    );
    public $hasMany = array(
        'StoreUser'
    );
}

模型/StoreUser.php

<?php
App::uses('AppModel', 'Model');
class StoreUser extends AppModel {
    public $belongsTo = array(
        'User',
        'Store'
    );
}

控制器/StoresController.php

<?php
App::uses('AppController', 'Controller');
class StoresController extends AppController {
    public $uses = array('Store');
    public function create() {
        $this->Store->create();
        $storeData = array(
            'Store' => array(
                'title' => 'New Store',
                'user_id' => $this->Auth->user('id')
             ),
             'StoreUser' => array(
                 'user_id' => $this->Auth->user('id')
              )
        );
        if($this->Store->saveAll($storeData) !== false) {
            // Success
        } else {
            // Error
        }
    }
}

数据库中的结果

stores table:
    id: 1
    title: New Store
    user_id: 1
    ...
store_users table:
    id: 1
    store_id: 1
    user_id: 0
    ...

找到了!因为Store hasMany StoreUser而不是StorehasOne StoreUser,所以我必须将user_id封装在数组中提供的数据中。

控制器/StoresController.php

<?php
App::uses('AppController', 'Controller');
class StoresController extends AppController {
    public $uses = array('Store');
    public function create() {
        $this->Store->create();
        $storeData = array(
            'Store' => array(
                'title' => 'New Store',
                'user_id' => $this->Auth->user('id')
             ),
             'StoreUser' => array(
                 array(
                     'user_id' => $this->Auth->user('id')
                 )
              )
        );
        if($this->Store->saveAll($storeData) !== false) {
            // Success
        } else {
            // Error
        }
    }
}