fastadmin 栏目加入搜索

addons/cms/controller/channel.php 130

        //加入标题搜索
        $search=[];
        $q=$this->request->get('q', "");
        if($q!==""){
            $search["title"]=['like',"%$q%"];
        }

下面的查询加入条件

//缓存列表总数
        if (!$simple && ($config['cachelistcount'] ?? false)) {
            $simple = Archives::with(['channel', 'user'])->alias('a')
                ->where('a.status', 'normal')
                ->whereNull('a.deletetime')
                ->where($filterWhere)
                ->bind($filterBind)
                ->where($filterPagelist)
                ->where($filterChannel)
                ->where($search)
                ->where('model_id', $channel->model_id)
                ->join($model['table'] . ' n', 'a.id=n.id', 'LEFT')
                ->cache("cms-channel-list-" . $channel['id'] . '-' . md5(serialize($filter)), 3600) //总数缓存1小时
                ->count();
        }


        //加载列表数据
        $pageList = Archives::with(['channel', 'user'])->alias('a')
            ->where('a.status', 'normal')
            ->whereNull('a.deletetime')
            ->where($filterWhere)
            ->bind($filterBind)
            ->where($filterPagelist)
            ->where($filterChannel)
            ->where($search)
            ->where('model_id', $channel->model_id)
            ->join($model['table'] . ' n', 'a.id=n.id', 'LEFT')
            ->field('a.*')
            ->field('id,content', true, config('database.prefix') . $model['table'], 'n')
            ->order($orderby, $orderway)
            ->paginate($pagesize, $simple);