fastadmin列表添加统计行

ETO_冬

已于 2023-09-01 18:08:42 修改

阅读量431

点赞数

文章标签： php 服务器 javascript

于 2023-09-01 18:05:59 首次发布

本文链接：https://blog.csdn.net/qq_40088333/article/details/132628858

版权

    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();

            $list = $this->model
                    ->with(['kehu','fenzu','guwen','hehuoren'])
                    ->where($where)
                    ->order($sort, $order)
                    ->paginate($limit);

            foreach ($list as $row) {
                
                $row->getRelation('kehu')->visible(['name']);
                $row->getRelation('fenzu')->visible(['name']);
                $row->getRelation('guwen')->visible(['name']);
                $row->getRelation('hehuoren')->visible(['name']);
            }
            $t['id'] = '合计';
            $t['order_num'] = '—';
            $t['kehu']['name'] = '—';
            $t['project'] = '—';
            $t['fenzu']['name'] = '—';
            $t['guwen']['name'] = '—';
            $t['hehuoren']['name'] = '—';
            //总价
            $t['zongjia'] = $this->model->with(['kehu','fenzu','guwen','hehuoren'])->where($where)->sum('zongjia');
            //分佣金额
            $t['fenyongjine'] = $this->model->with(['kehu','fenzu','guwen','hehuoren'])->where($where)->sum('fenyongjine');
            //分组分佣金额
            $t['group_fenyong_jine'] = $this->model->with(['kehu','fenzu','guwen','hehuoren'])->where($where)->sum('group_fenyong_jine');
            //顾问分佣金额
            $t['guwen_jine'] = $this->model->with(['kehu','fenzu','guwen','hehuoren'])->where($where)->sum('guwen_jine');
            //合伙人分佣金额
            $t['sell_user_jine'] = $this->model->with(['kehu','fenzu','guwen','hehuoren'])->where($where)->sum('sell_user_jine');
            $array = $list->items();
            $array[] = $t;
            $result = array("total" => $list->total(), "rows" => $array);

            return json($result);
        }
        return $this->view->fetch();
    }

                        {
                            field: 'operate',
                            title: __('Operate'),
                            table: table,
                            events: Table.api.events.operate,
                            formatter: Table.api.formatter.operate,
                            buttons: [
                                {
                                    name: 'edit',
                                    text: '详情',
                                    icon: 'fa fa-eye',
                                    title: __('详情'),
                                    extend: 'data-toggle="tooltip"',
                                    classname: 'btn btn-xs btn-success btn-editone',
                                    visible: function (row) {
                                        // 删除按钮 动态是否显示
                                        if (row.id == '合计') {
                                            return false;
                                        }
                                        return true;
                                    }
                                },
                            ],
                        }

在列表数据中增加一列统计。js中添加判断在合计列不展示按钮。最终效果如下。