fastadmin把列表页查询条件where拿出来定义示例
代码:\think\Log::record($this->request->param());
$params = $this->request->param();
// 凡是带createtime参数查询则定义查询条件
$filter = json_decode($params['filter'], true);
if (isset($filter['createtime'])) {
$timerange = explode(' - ', $filter['createtime']);
\think\Log::record($timerange);
$starttime = explode(' ', $timerange);
$endtime = explode(' ', $timerange);
$start = $starttime;
$end = $endtime;
// 分页限制
$limit = $params['limit'];
$sort = $params['sort'];
$order = $params['order'];
$where = [
'name' => []
];
if (isset($filter['id'])) {
$where['id'] = $filter['id'];
}
if (isset($filter['name'])) {
$where['name'] = ['like', "%" . $filter['name'] . "%"];
} else {
unset($where['name']);
}
if (isset($filter['status'])) {
$where['status'] = $filter['status'];
}
} else {
[$where, $sort, $order, $offset, $limit] = $this->buildparams();
}
// 门店列表
$list = $this->model
->where($where)
->order($sort, $order)
->paginate($limit);
$result = ['total' => $list->total(), 'rows' => $list->items()];
return json($result);
页:
[1]