获取多个外键值并在视图中输出它们

Question

我正在做一个预订系统，这是我目前使用的表。我无法获取客户端支付的外键值。我已经把关系放在模型里了。

预订

    <?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class booking extends Model
{
   protected $fillable = ['clientID', 'checkInDate', 'checkOutDate', 'roomsCount', 'roomTypeID', 'adultsCount', 'childrenCount', 'amenityID', 'paymentID'];


    public function client()
    {
        return $this->belongsTo('App\Client','clientID');
    }
    public function payment()
    {
        return $this->hasOne('App\Payment');
    }
    public function amenities()
    {
        return $this->hasOne('App\Amenities');
    }

客户端

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class client extends Model
{
   protected $fillable = ['fullNmae', 'firstName', 'lastName', 'phoneNumber', 'emailAddress'];
  public function booking()
  {
      return $this->hasMany('App\Booking');
  }
}

付款

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class payment extends Model
{
   protected $fillable = ['clientID', 'paymentMethod', 'invoiceNum', 'accountName', 'amountPaid', 'datePaid', 'payment_image', 'comments'];
  public function booking()
  {
      return $this->belongsTo('App\Booking');
  }
}

我现在用这个来访问外键

$bookingDetail = booking::with('client', 'payment')->get();
        return view('detail')
        ->with('bookingDetail', $bookingDetail);

查看

{{ $bookingDetail->payment->paymentMethod }}

我犯了一个错误

SQLSTATE[42S22]：未找到列：“where子句”中的1054未知列“clients.id”（SQL:select*fromclientswhereclientsidin（3,4,5,6,7,8,9,10,11,12,13,14,15,16,17））

这样做对吗？还是我遗漏了什么。我是拉威尔的新手，所以我不知道这样做是否正确

Answer 1

当定义关系时，laravel能够使用“方法名称”“_id”结构检测外键。

但是如果你的外键与这个模式不匹配，那么你必须手动指定键。

public function booking()
{
  return $this->belongsTo('App\Booking',$foreignKey,$ownerKey);
}

public function payment()
{
    return $this->hasOne('App\Payment',$foreignKey, $ownerKey);
}