查询之间的Yii2模型搜索

Question

我想在yii2模型搜索()中实现下面的mysql查询

SELECT * FROM `parking_availability` WHERE  ('09:00' BETWEEN `time_start` AND `time_end` ) AND 
 ( '11:00' BETWEEN `time_start` AND `time_end` )  

我像这样申请过

 $query->andFilterWhere([$this->arrivaltime,'between','time_star', 'time_end'])
->andFilterWhere([$this->departuretime,'between','time_star', 'time_end']);

但是它的显示错误操作符'09:00‘需要两个操作数.

请帮帮我，谢谢

Answer 1

你的尝试方向是正确的，但是你得到的参数顺序是错误的。第一个必须是'between'操作符：

$query->andFilterWhere(['between', $this->arrivaltime, 'time_start', 'time_end'])
->andFilterWhere(['between', $this->departuretime, 'time_start', 'time_end']);