组织与组织类型有许多关系
Tabel组织
id | name | organType_id
1 | a | 1
2 | b | 1
3 | c | 2
4 | d | 3
表格组织类型
id | name
1 | aa
2 | bb
3 | cc
i在organiztinos模型中使用belongsTo=>'organType'
模型组织
class organizationsTable extends table
{
public function initialize(array $config)
{
$this->table('organizations');
$this->primaryKey('id');
$this->belongsTo('organType', [
'foreignKey' => 'organType_id',
]);
}
}
型号组织类型
class organTypeTable extends table
{
public function initialize(array $config)
{
$this->table('organType');
$this->primaryKey('id');
}
}
控制器
$organization=TableRegistry::get('organizations');
$organization=$organization->find('all')->offset(0)->limit(30) ;
debug($organization);
但在结果只返回组织表中,我希望组织内部加入organ_type
不良结果:
'sql' => 'SELECT organizations.id AS `organizations__id`, organizations.name AS `organizations__name`, organizations.organType_id AS `organizations__organType_id` FROM organizations organizations LIMIT 30 OFFSET 0',
我想要这个结果:
'sql' => 'SELECT organizations.id , organizations.name , organizations.organType_id FROM organizations inner join organType on organizations.organType_id=organType.id
book.cakephp.org
用于从cakehp3中的外国表中选择muse使用的contain(['organType'])
$organization=$organization->find('all')->contain(['organType'])->offset(0)->limit(30) ;