How to filter data by intermediate link table (hasMany/hasOne with via/viaTable) in Yii2 model?

Question

Yii

there is a link according to the scheme Buyer - Sales - Supplier, i.e. The Buyer is connected to suppliers through Sales
for the getter in the Buyer model, we have

return $this->hasMany(ПОСТАВЩИКИ::className(), ['ПОСТАВЩИК_ID' => 'ПРОДАЖИ_ID_ПОСТАВЩИКА'])
->viaTable('ПРОДАЖИ', ['ПРОДАЖИ_ID_ПОКУПАТЕЛЯ' => 'ПОКУПАТЕЛЬ_ID'])

Some sales have been canceled or have not taken place yet. in the sales table, records are marked as inactive.
Adding where/andWhere to fields in the Sales table does not work.
It is possible to join the Sales table and then filter, but it looks like a crutch.
How to filter data by intermediate link table (hasMany/hasOne with via/viaTable) in Yii2 model?

Answer 1

return $this->hasMany(ПОСТАВЩИКИ::className(), ['ПОСТАВЩИК_ID' => 'ПРОДАЖИ_ID_ПОСТАВЩИКА'])
         ->viaTable(
              'ПРОДАЖИ', 
              ['ПРОДАЖИ_ID_ПОКУПАТЕЛЯ' => 'ПОКУПАТЕЛЬ_ID'], 
              function ($query) {
                    $query->andWhere(['СТАТУС_ПРОДАЖИ' => 'АКТИВНА']);
              });

Answer 2

return $this->hasMany(ПОСТАВЩИКИ::className(), ['ПОСТАВЩИК_ID' => 'ПРОДАЖИ_ID_ПОСТАВЩИКА'])
->viaTable('ПРОДАЖИ', ['ПРОДАЖИ_ID_ПОКУПАТЕЛЯ' => 'ПОКУПАТЕЛЬ_ID'])->where(['table_name.columns'  => value])

Answer 3

The most flexible option is to perform all JOINs on your own and filter by any fields of intermediate tables.