drr47973 2019-05-31 11:07
浏览 84
已采纳

两个模型的雄辩查询

I need your help, please! I have two models customer and membership. Customer hasMany Memberships. I need to extract all customers with a membership active. I did this but it extracts only memberships, without customers data. How can I change it to solve the problem?

Membership::has("customer")
    ->forCompany($companyId)
    ->whereIn('state', ['ATTIVA', 'IN ATTESA DI ESITO', 'DA INVIARE'])
    ->where(function ($query) {
        $query
            ->where('end_date', '>=', Carbon::now()->toDateString())
            ->orWhereNull('end_date');
    })
  • 写回答

2条回答 默认 最新

  • douzhao5656 2019-05-31 11:16
    关注

    If you want the customers data with membership you must write the query from Customers model and not the Membership model. In case you want to eager load the membership with customers data, you must use with() method.

    So here is the query you want:

    $customers = Customer::whereHas("memberships",function($q) use ($companyId){
    
        return $q->forCompany($companyId)
                  ->whereIn('state', ['ATTIVA', 'IN ATTESA DI ESITO', 'DA INVIARE'])
                  ->where(function ($query) {
                       $query->where('end_date', '>=', Carbon::now()->toDateString())
                             ->orWhereNull('end_date');
                   });
    
    })->with('memberships')->get();
    

    So, you can access the memberships of each customer like so:

    foreach($customers as $customer)
        $memberships = $customer->memberships;
    

    Notice : don't forget to define the membersips() method in Customer model. Remember to eager load the memberships with customer data using ->with() method. and don't forget to use ->get() at the end of query.

    Here you can read about eager loading.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 有人懂怎么做大模型的客服系统吗?卡住了卡住了
  • ¥20 firefly-rk3399上启动卡住了
  • ¥15 如何删除这个虚拟音频
  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway
  • ¥20 基于MATLAB的绝热压缩空气储能系统代码咨询
  • ¥15 R语言建立随机森林模型出现的问题
  • ¥15 中级微观经济学,生产可能性边界问题
  • ¥15 TCP传输时不同网卡传输用时差异过大
  • ¥15 请各位看看我写的属于什么算法,或者有更正确的写法?