Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> DESCRIBE tbl_lists;
- +--------------+----------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------+----------------------+------+-----+---------+----------------+
- | id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
- | name | varchar(100) | NO | | NULL | |
- | user_id | smallint(5) unsigned | NO | MUL | NULL | |
- +--------------+----------------------+------+-----+---------+----------------+
- mysql> DESCRIBE tbl_lists_fields;
- +---------+-----------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +---------+-----------------------+------+-----+---------+----------------+
- | id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | |
- | list_id | smallint(5) unsigned | NO | MUL | NULL | |
- +---------+-----------------------+------+-----+---------+----------------+
- mysql> DESCRIBE tbl_lists_substances_comments;
- +--------------+-----------------------+------+-----+-------------------+-----------------------------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------+-----------------------+------+-----+-------------------+-----------------------------+
- | id | bigint(11) unsigned | NO | PRI | NULL | auto_increment |
- | list_id | smallint(5) unsigned | NO | MUL | NULL | |
- | field_id | mediumint(8) unsigned | NO | MUL | NULL | |
- | substance_id | mediumint(8) unsigned | NO | MUL | NULL |
- | comment | varchar(3000) | NO | | NULL | | |
- +--------------+-----------------------+------+-----+-------------------+-----------------------------+
- $TblLists = TableRegistry::get('TblLists');
- $tbl_lists = $TblLists->find('all')->contain(['TblListsFields'])->where(['user_id' => '1234'])->toArray();
- debug($tbl_lists);
- ->contain(['TblListsFields', 'TblListsSubstancesComments'])->
- // TblListsTable.php
- $this->hasMany('TblListsSubstances', [
- 'foreignKey' => 'list_id'
- ]);
- $this->hasMany('TblListsFields', [
- 'foreignKey' => 'list_id'
- ]);
- // TblListsFieldsTable.php
- $this->belongsTo('TblLists', [
- 'foreignKey' => 'list_id',
- 'joinType' => 'INNER'
- ]);
- $this->belongsTo('TblListsSubstancesComments', [
- 'foreignKey' => 'field_id',
- 'joinType' => 'INNER'
- ]);
- // TblListsSubstancesCommentsTable.php
- $this->belongsTo('TblLists', [
- 'foreignKey' => 'list_id',
- 'joinType' => 'INNER'
- ]);
- $this->belongsTo('TblListsFields', [
- 'foreignKey' => 'field_id',
- 'joinType' => 'INNER'
- ]);
- $this->belongsTo('Substances', [
- 'foreignKey' => 'substance_id',
- 'joinType' => 'INNER'
- ]);
- $this->belongsTo('TblListsSubstancesComments', [
- 'foreignKey' => 'id',
- 'joinType' => 'INNER'
- ]);
Add Comment
Please, Sign In to add comment