Laravel 5雄辩地从第二个连接表的外键中包含另一个表的行

1 回答

• 0

  class Customer extends Model {
  
      $table = 'customers';
  
      function addresses(){
          return $this->hasMany(Address::class, 'customer_id');
      }
  
      function orders(){
          return $this->hasMany(Order::class, 'customer_id');
      }
  
  }
  
  class Order extends Model {
  
      $table = 'orders';
  
      function address(){
          return $this->belongsTo(Address::class, 'address_id');
      }
  
      function customer() {
          return $this->belongsTo(Customer::class, 'customer_id');
      }
  }
  
  class Address extends Model{
  
      $table = 'customer_addresses';
  
      function customer(){
          return $this->belongsTo(Customer::class, 'customer_id');
      }
  
  }
  
  
  TABLES : 
  1 customers
  
          id
  
  2 orders
  
          id
  
          customer_id
  
          address_id
  
  3 customer_addresses
  
          id
  
          customer_id
  
          street
  
          country
  

  回复于 2024-05-12T15:59:30+08:00