查询sql为:
SELECT
*
FROM
rht_medicine_order
WHERE
buy_time
BETWEEN 1588262400
AND 1589212800
前端代码:使用的是layui时间控件
<div class="layui-form-item layui-inline">
<label class="layui-form-label">成交时间:</label>
<div class="layui-input-inline">
<input data-date-range name="buy_time" value="{$Think.get.buy_time|default=''}" placeholder="请选择时间区间" class="layui-input">
</div>
</div>
控制器代码
//成交时间 2020-05-19 - 2020-05-23
$buy_time = $this->request->param('buy_time') ?? '';
//成交时间
$whereTime = [];
if ($buy_time){
list($begin,$after) = explode(' - ', $buy_time);
$whereTime[] = ['buy_time','between',[strtotime($begin),strtotime($after)]];
}
$data = Db::table($this->table)
->where($whereTime)
->select();
显示结果页面