FastAdmin 个人记录 - 修改table传递的参数

Aug 19, 2022#FastAdmin #教程294

AI-generated summary

This article explains how to modify the parameters passed to a table in FastAdmin. It provides code examples for retrieving and manipulating request parameters in the controller, as well as modifying search conditions in the frontend table using JavaScript.

后台 php 修改#

#一般我们可以直接在控制器中使用以下代码获取请求的参数：
$filter = json_decode($this->request->get("filter", ''), true);
$op = json_decode($this->request->get("op", '','trim'), true);

#通过isset()函数判断是否存在某个参数，然后利用unset()去除你不需要的参数；再通过

$filter[''] = '';
$op[''] = '';

#设置你的自定义参数和查询条件;
#然后进行重新赋值：

$this->request->get(['filter' => json_encode($filter, true)]);
$this->request->get(['op' => json_encode($op, true)]);

list($where, $sort, $order, $offset, $limit) = $this->buildparams();

前台 table js 修改#

table.bootstrapTable({
    url: $.fn.bootstrapTable.defaults.extend.index_url,
    pk: 'id',
    sortName: 'id',
    searchFormVisible: true,
    toolbar: '#toolbar',
    queryParams:function(params){
        let filter = JSON.parse(params.filter);
        let op = JSON.parse(params.op);
        
        //重构搜索条件 根据个人需求修改
        if (filter['status'] == undefined){
            filter['status'] = 0;
            op['status'] = '>';

            params.filter = JSON.stringify(filter);
            params.op = JSON.stringify(op);
            //console.log(params);
        }
        return params;
    },
    columns: [
        col
    ]
});