爱玺玺

爱玺玺的生活日记本。wx:lb87626

Thinkphp模型关联条件查询

public function demo5(){

        //使用hasWhere根据article的条件查询(注:comment与article有关联),同时使用with把article查询出来:

        $list = Comment::hasWhere('article',[["title","like","%美国%"]])->with("article")->select()->toArray();

             //或者,效果一样

        $list = Comment::with(['article'=>function($query){

            $query->where("title","like","%量子%");

        }])->select();

    }




 $enInRefundList = Bill::hasWhere('agent',[["id","like","%1%"]])->where('cname', 'like', '%' . Request::param('cname') . '%')->where('ctel', 'like', '%' . Request::param('tel') . '%')->where('iname', 'like', '%' . Request::param('iname') . '%')->where('project', 'like', '%' . Request::param('project') . '%')->where('del','eq','0')->order('id', 'desc')->paginate(50,false,

        [

            'type'     => 'Bootstrap',

            'var_page' => 'page',

            //第一种方法,使用数组方式传入参数

            //'query' => ['iname'=>Request::param('iname')],

            //第二种方法,使用函数助手传入参数

            'query' => request()->param(),

         ]

        );


发表评论:

Powered By Z-BlogPHP 1.4 Deeplue Build 150101

Copyright Your WebSite.Some Rights Reserved.

蜀ICP备11021721号-5