douyao1878
2017-11-13 18:40
浏览 151
已采纳

在JOIN表中的Eloquent where子句 - Laravel 5.5

I have two models which are connected each other.

class Company extends Model {
   public function addresses() {
      return $this->belongsToMany('\App\Address', 'address_mapping', 'uid_company', 'uid_address');
   }
}

class Address extends Model {
}

In my JOIN table I have a column named active. How can I fetch all active addresses from the company? Or how can I implement a where-clause in the JOIN table?

Thank you!

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douqiaotong8682 2017-11-13 18:54
    已采纳

    The table that you call a "JOIN table", usually called a pivot table. You can fetch all active records by using wherePivot method:

     $company = Company::first();   
     $activeAdresses = $company->addresses()->wherePivot('active', 1);
    

    Or you can directly define the relationship in your model:

    class Company extends Model {
       public function activeAddresses() {
          return $this->belongsToMany('\App\Address', 'address_mapping', 'uid_company', 'uid_address')
                      ->wherePivot('active', 1);
       }
    }
    

    See section Filtering Relationships Via Intermediate Table Columns in Eloquent documentation

    打赏 评论

相关推荐 更多相似问题