I have three table that names is 'agency' , 'property' and 'property_agency_map'
agency table :
--------------------------
| id => primary key ... |
| name => string ... |
| and som more fields |
--------------------------
property table :
--------------------------
| id => primary key ... |
| state => string ... |
| adress => string ... |
| and som more fields |
--------------------------
property_agency_map table :
------------------------------
| id => primary key ... |
| agency_id => string ... |
| property_id => string ... |
| status => intiger ... |
| favorite => intiger ... |
------------------------------
the property_agency_map table connect agency table to property table.
agency model :
public function getProperties(){
return $this->hasMany(Property::className(),['id'=>'property_id'])
->viaTable('"{{%property_agency_map}}"',['agency_id'=>'id']);
}
Now My question is How to access 'favorite' and 'status' field in property_agency_map ??