Multiple relations in Yii 2.0 ActiveRecord Model

Question

I am trying to define relations in ActiveRecord Model Class, but the problem is our database is too large and has many relations. So is there a simpler way to declare relation in only one model so that Yii can understand the relation for every other model it is related to.

public function getBill_details()
{
    return $this->hasMany(bill_details::className(),['company_bill_id'=>'id']);
}

public function getCompany()
{
    return $this->hasOne(company::className(),['merchant_c_id'=>'id']);
}

I have created two functions for two relations. Similarily I have around 80 relations in one table only so is there an simpler way of doing it.

but how gii will help in defining relations. How it will now what relations are?? — Vikrant Dubey, Oct 21 '15 at 05:38
you must give relation of 'fk' in database tables then gii will generate relation for them. — Insane Skull, Oct 21 '15 at 05:51
Gii will create all relations automatically, assuming you have proper foreign keys defined. I bet you don't, though ;) — Beowulfenator, Oct 26 '15 at 20:10
80 relationships in a table suggests a bad DB design! Or an absolutely epic app... Can you autogenerate an entity relationship diagram of your DB? — Force Hero, Nov 05 '15 at 03:53

score 0 · Answer 1 · edited Feb 19 '16 at 11:47

0

If you could use innoDB and set the relations on the database before Gii generates the models, Gii would generate the models with the relations for all tables.

edited Feb 19 '16 at 11:47

antichris

2,015
1
17
17

answered Dec 02 '15 at 21:16

Álvaro Herrero

141
1
8

score 0 · Answer 2 · answered May 26 '16 at 10:01

0

You can use gii extension to generate the relations gii

answered May 26 '16 at 10:01

Iman Tumorang

121
2
7
25

Multiple relations in Yii 2.0 ActiveRecord Model

2 Answers2