Fastadmin使用IN关联展示及搜索方法

He195501

已于 2024-06-12 21:30:10 修改

阅读量541

点赞数

分类专栏： thinkphp5.0 fastadmin 文章标签： php 后端

于 2023-06-14 22:26:28 首次发布

本文链接：https://blog.csdn.net/He195501/article/details/131217148

版权

thinkphp5.0 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

fastadmin

3 篇文章 0 订阅

订阅专栏

列表展示多数据

在这里插入图片描述
展示类似结构且可搜索

第一步查看表结构存储

在这里插入图片描述

因存表是附表id 展示效果是附表的name值

第二步处理查询

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();
            }
            $wheres = [];
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            //自定义需要参数
            $filter = $this->request->get("filter", '');
            $filter = (array)json_decode($filter, true);
            if(isset($filter['book_id'])){
                $whereLike = " name like '%" .$filter['book_id'] . "%'";
                $book_id =  implode(',', db('book')->where($whereLike)->column('id'));
                $rex = explode(',', $book_id);
                foreach ($rex as $v){
                    $wheres[] = ['exp',Db::raw("FIND_IN_SET('$v', book_id)")];
                }
            }
            //end
            $list = $this->model
                    ->with(['address','member', 'arealist'])
                    ->where($where)
                    ->whereOr($wheres)
                    ->order($sort, $order)
                    ->paginate($limit);

            foreach ($list as $row) {
                $row->visible(['id','user_id', 'book_id','address_id','address_info','contact','phone','start_end_time','order_sn','create_time','status','delivery_time','return_book_time','return_book_finsh_time','des']);
                $row->visible(['address']);
				$row->visible(['member']);
            }
            $total = $list->total();
            $lists = $list->toArray();
            foreach ($lists['data'] as &$value) {
            //自定义需要参数
				$value['bookids'] = $value['book_id'];
                if($value['book_id']){
                    $bookId = explode(',', $value['book_id']);
                    $value['book_id'] = implode(',', db('book')
                        ->whereIn('id', $bookId)
                        ->column('name'));
                }
                //end
            }
            $result = array("total" => $total, "rows" => $lists['data']);

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