1时间戳用这种$where['order_time'] = ['between', strtotime($input['start_time']).",".strtotime($input['end_time'])];
日期格式用这种会报错SQLSTATE[42S22]: Column not found: 1054 Unknown column 'delivery_time' in 'where clause'意思是搜索的值是字符串但是没加单引号,但是加了单引号就不是变量了
2日期用这种->where('delivery_time','between time',[$input['delivery_time'],$input['delivery_time2']])
这种就不会说搜索的值是字符串了
if($input['start'] != '' && $input['end'] == ''){
$where['order_time'] = ['gt', strtotime($input['start'])];
}
if($input['start'] == '' && $input['end'] != ''){
$where['order_time'] = ['lt', strtotime($input['end'])];
}
if($input['start'] != '' && $input['end'] != ''){
$where['order_time'] = ['between', strtotime($input['start']).",".strtotime($input['end'])];
}