php - 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');