THINKPHP_(2)_TP模型的多表关联查询和多表字段的关键字搜索。

    public function search($srcfrom)
    {
        // 整理变量
        $src = [
            ‘category‘ => ‘‘
            ,‘searchval‘ => ‘‘
            ,‘status‘ => ‘‘
            ,‘bfdate‘ => ‘‘
            ,‘enddate‘ => ‘‘
        ];
        $src = array_cover($srcfrom, $src) ;
        if(isset($srcfrom[‘bfdate‘]) && strlen($srcfrom[‘bfdate‘]) > 0)
        {
            $src[‘bfdate‘] = $srcfrom[‘bfdate‘];
        }else{
            $src[‘bfdate‘] = date("Y-m-d", strtotime("-6 year"));
        }
        if(isset($srcfrom[‘enddate‘]) && strlen($srcfrom[‘enddate‘]) > 0)
        {
            $src[‘enddate‘] = $srcfrom[‘enddate‘];
        }else{
            $src[‘enddate‘] = date("Y-m-d", strtotime(‘4 year‘));
        }

        // 查询数据
        $data = $this
            ->whereTime(‘bfdate|enddate‘, ‘between‘, [$src[‘bfdate‘], $src[‘enddate‘]])
//            ->alias("c")
            ->withJoin(
//                "glCategory"
                [
                    ‘glCategory‘=>function($query){
                        $query->field(‘id, title‘);
                    },
                ]
            )
            ->when(strlen($src[‘searchval‘]) > 0, function($query) use($src){
                $query->where("xueqi.title|glCategory.title|xuenian", ‘like‘, ‘%‘ . $src[‘searchval‘] . ‘%‘);
                })
            ->when(strlen($src[‘category‘]) > 0, function($query) use($src){
                    $query->where(‘category‘, $src[‘category‘]);
                })
            ->when(strlen($src[‘status‘]) > 0, function($query) use($src){
                    $query->where(‘status‘, $src[‘status‘]);
                })
//            ->with(
//                [
//                    ‘glCategory‘=>function($query){
//                        $query->field(‘id, title‘);
//                    },
//                ]
//            )
            ->select();

        file_put_contents(‘D:\log.txt‘,$this->getLastSql());

        return $data;
    }