我有tbl_batch哪個(gè)idtitlestart_datestart_timeend_timevenue_idcreated_by在數(shù)據(jù)庫中 start_time 和 end_time 被保存為time()排：-id 1title teststart_time 10:10end_time 11:30venue_id 1start_date 2020-03-01 (Y-m-d)created_by 1所以我想檢查時(shí)間是否在給定start_time的.end_timestart_date我試過的查詢：-$model = Batch::find()->where(['start_date' => '2020-03-01','venue_id' => 1])->andWhere(['AND',[ '>=', 'start_time', '10:20'],[ '<=', 'end_time', '19:20']]);if($model->exists()){ echo 'Already exists in DB';}else{ echo 'Does not Exist';}這沒有返回正確的輸出。
1 回答
達(dá)令說
TA貢獻(xiàn)1821條經(jīng)驗(yàn) 獲得超6個(gè)贊
我終于想通了：）
$time_between = Batch::find()->where([
'start_date' => '2020-03-01',
'venue_id' => 1
])->andWhere([
'OR',
[
'OR',
[
'between',
'end_time',
$model->start_time,
$model->end_time
],
[
'between',
'start_time',
$model->start_time,
$model->end_time
]
],
[
'AND',
[
'<=',
'start_time',
$model->start_time
],
[
'>=',
'end_time',
$model->start_time
]
]
]);
- 1 回答
- 0 關(guān)注
- 123 瀏覽
添加回答
舉報(bào)
0/150
提交
取消