/** * @return \yii\db\ActiveQuery */ public function getDiagnoses() { return $this->hasMany(Diagnos::className(), ['id' => 'diagnos_id'])->viaTable('tbl_product_type_has_diagnos', ['product_type_id' => 'id']); }
/** * Извлекаем список заболеваний для типов продуктов */ public function getDiagnos() { $query = $this->hasMany(Diagnos::className(), ['id' => 'diagnos_id'])->viaTable('tbl_product_type_has_diagnos', ['product_type_id' => 'type_id']); if (is_numeric(Yii::$app->request->get('diagnos'))) { $query->where(['tbl_diagnos.id' => (int) Yii::$app->request->get('diagnos')]); } return $query; }
/** * @return \yii\db\ActiveQuery */ public function getDiagnos() { return $this->hasOne(Diagnos::className(), ['id' => 'diagnos_id']); }