Yii2模型搜索查询，可在周一和周五开店

Question

我想写Yii2模型搜索查询，让商店在周一和周五开张。

下面是表结构和查询

shop_name  openday 
------------------------
    shop-A      Monday  
    shop-A      Tuesday
    shop-A      Wednesday
    shop-A      Thursday
    shop-A      Friday
    shop-B      Monday 
    shop-B      Tuesday


SELECT shop_name
FROM availability   WHERE openday IN ('Monday', 'Friday')
GROUP BY shop_name HAVING COUNT(*) = 2;

我想实现这个查询yii2模型搜索，

$query->andWhere("(`parking_availability`.`day` IN('Monday', 'Friday'))")->groupBy('parking_availability.day')->having('COUNT(*) = 2');

以上查询不起作用，请帮帮我...

Answer 1

试试这个：

$query->andWhere(['in', 'day', ['Monday', 'Friday']])
    ->groupBy('openday')
    ->having('COUNT(shop_name) = 2');