/**
* Список всех значений фич, которые задействованы в данной категории маркетов
* @param type $category_id
* @param type $feature_ids
* @return type
*/
public static function getPossibleMarketsValues($category_id, $feature_ids)
{
$feature_ids = array_map('intval', $feature_ids);
$feature_ids_imploded = implode(',', $feature_ids);
$sql = 'SELECT fv.id, fv.feature_value ' . ' FROM ' . self::tableName() . ' fv ' . ' JOIN ' . FeaturesValuesRelations::tableName() . ' fvr ' . ' ON fv.id = fvr.feature_value_id ' . ' JOIN ' . MarketsFeatures::tableName() . ' mf ' . ' ON fv.id = mf.feature_value_id ' . ' JOIN ' . MarketsCategories::tableName() . ' mc ' . ' ON mc.markets_id = mf.markets_id ' . ' WHERE fvr.feature_id IN (' . $feature_ids_imploded . ') ' . ' AND mc.categories_id = :category_id';
return self::findBySql($sql, [':category_id' => $category_id])->asArray()->all();
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMarketsFeatures()
{
return $this->hasMany(MarketsFeatures::className(), ['markets_id' => 'id']);
}
