Yii2: Relation through multiple via

Question

I have a relation through multiple intermediate tables. How can I define in Yii2?

So for I have tried following

public function getTbl1() { return $this->hasOne( Tbl1::className(), [ 'id' => 'tbl1_id' ] ); } public function getTbl2() { return $this->hasOne( Tbl2::className(), [ 'id' => 'tbl2_id' ] )->via( 'tbl1' ); } public function getTbl3() { return $this->hasOne( Tbl3::className(), [ 'id' => 'tbl3_id' ] )->via( 'tbl2' ); }

I get the relation tbl1 and tbl2, but not able to get the tbl3. How can I do it?

Thanks in advance.

Yupik · Accepted Answer · 2016-12-09 13:52:11Z

Just tried this:

/** * @return ActiveQuery */ public function getLastPosition() { return $this ->hasOne(Position::class, ['equipment_id' => 'id']) ->orderBy('date DESC'); } /** * @return ActiveQuery */ public function getTest1() { return $this->hasOne(CompanyCarpark::class, ['id' => 'company_carpark_id'])->via('lastPosition'); } /** * @return ActiveQuery */ public function getTest2() { return $this->hasOne(Company::class, ['id' => 'company_id'])->via('test1'); }

And it "worked like a charm". Check your keys in database, propably there's something wrong there.

Alexey Berezuev · Accepted Answer · 2016-12-09 12:43:49Z

2

You should do it with parent-child structure, like this:

$model->find() ->with('relationOne') //Model1::getRelationOne(Model2::table_name()...) ->with('relationOne.childRelation'); // Model2::getChildRelation....

answered Dec 9, 2016 at 12:43

Alexey Berezuev

7939 silver badges27 bronze badges

3 Comments

Sanky Over a year ago

I knew that I can do like this. But I want to know whether I can create direct relation or not.

Alexey Berezuev Over a year ago

@Sanky maybe you need this github.com/yiisoft/yii2/blob/master/docs/guide/… ?

Sanky Over a year ago

I already tried it and it is working for tbl2 but it is not working for tbl3

Collectives™ on Stack Overflow

Yii2: Relation through multiple via

2 Answers 2

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Related