public function getOrderItems() { /* @var $rel ActiveQuery */ $rel = $this->hasMany(Item::className(), ['id' => 'item_id']); return $rel->viaTable('order_item', ['order_id' => 'id'], function ($q) { /* @var $q ActiveQuery */ $q->viaTable('order', ['customer_id' => 'id']); })->orderBy('id'); }
public function getItem() { return $this->hasOne(Item::className(), ['id' => 'item_id']); }
public function getLimitedItems() { return $this->hasMany(Item::className(), ['category_id' => 'id'])->onCondition(['item.id' => [1, 2, 3]]); }
public function getBooks2() { return $this->hasMany(Item::className(), ['id' => 'item_id'])->onCondition(['category_id' => 1])->viaTable('order_item', ['order_id' => 'id']); }