TP6.0 分类查询注意事项

最新推荐文章于 2024-05-09 11:17:16 发布

Doc_ACwhite

最新推荐文章于 2024-05-09 11:17:16 发布

阅读量292

点赞数

文章标签：分类 mariadb linq

本文链接：https://blog.csdn.net/doc_acwhite/article/details/122038368

版权

分类查询使用select 下拉框进行搜索

所以得注意其是否存在，根据其存在与否进行判断

进行empty判断其是否存在

/**
     * 展示
     * @param Request $request
     * @param Advertes $advertes
     * @return string
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function index(Request $request,Advertes $advertes){
        $kinds = Db::table('kindes')->select();
        $keywords = $request->param('keywords');
        $kind_key = $request->param('kind_key');
        if (empty($kind_key)){
            $res = $advertes->join('kindes','advertes.K_id = kindes.kind_id')
                ->where('advertName','like',"%$keywords%")
                ->order('advertOrd','asc')
                ->paginate([
                    'list_rows'=>5,
                    'query'=>[
                        'keywords'=>$keywords,
                    ]
                ]);
            //高亮
            foreach($res as $v){
                $v['advertName'] = str_replace($keywords,"<span style='color: red'>".$keywords."</span>",$v['advertName']);
            }
            return View::fetch('admin/goods_list',['data'=>$res,'kinds'=>$kinds,'keywords'=>$keywords,'kind_key'=>null]);
        }else{
            $res = $advertes->join('kindes','advertes.K_id = kindes.kind_id')
                ->where('advertName','like',"%$keywords%")
                ->where('K_id','=',$kind_key)
                ->order('advertOrd','asc')
                ->paginate([
                    'list_rows'=>5,
                    'query'=>[
                        'keywords'=>$keywords,
                        'kind_key'=>$kind_key
                    ]
                ]);
            $kindName = Db::table('kindes')->where('kind_id',$kind_key)->find()['kindName'];
//            dd($kindName);
            //高亮
            foreach($res as $v){
                $v['advertName'] = str_replace($keywords,"<span style='color: red'>".$keywords."</span>",$v['advertName']);
                $v['kindName'] = str_replace($kindName,"<span style='color: red'>".$kindName."</span>",$v['kindName']);
            }
            return View::fetch('admin/goods_list',['data'=>$res,'kinds'=>$kinds,'keywords'=>$keywords,'kind_key'=>$kind_key]);
        }
    }