普通网友 2017-11-13 18:40
浏览 161
已采纳

在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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?