Tabel coding
id | level1 | level2 | title _____________________________________ 1 | 100 | 1 | numberOne 2 | 100 | 2 | NumberTwo 3 | 101 | 1 | Compay 4 | 101 | 2 | association
Table Organizations
id | name | type | level ____________________________ 1 | intel | 3 | 1 2 | IBM | 4 | 2
Model Organizations
class organizationsTable extends table
{
public function initialize(array $config)
{
$this->table('organizations');
$this->primaryKey('id');
$this->belongsTo('coding', [
'foreignKey' => 'type',
'joinType' => 'INNER',
],
'coding', [
'foreignKey' => 'level',
'joinType' => 'INNER']);
}
}
this code$organization->find('all')->contain(['coding'])
only set level
to foreignKey but i want set level
and type
to foreignKey for table organizations
i sql query like this
select * from organizations
inner join coding
on organizations.type=coding.id
inner join coding ccc
on organizations.level=ccc.id
how create join like this?
EDIT
i write this but say error :organizations is not associated with coding
$this->belongsTo('yyyy', [
'foreignKey' => 'type',
'className' => 'coding'
],
'xxxx', [
'foreignKey' => 'level',
'className' => 'coding'
]);