doufu5521
2015-10-27 04:45
浏览 81
已采纳

Laravel Eloquent另一个表中的列的总和

so I have this output:

enter image description here

Here is the code in my controller:

public function showToday()
    {
        $now = new DateTime('today');
        $today = $now->format('Y-m-d');
        $reservations = Reservation::with('room') ->where('reservation_from', $now)
                                                            ->orderBy('created_at')
                                                            ->get();

        return \View::make('pages.admin.report.today') -> with('reservations', $reservations)
                                                       -> with('now', $today);
    }

Schema:

enter image description here

View (blade)

  <div class="box-body table-responsive no-padding">
    <table class="table table-bordered">
      <thead>
        <tr>
          <th>Room #</th>
          <th>Reservation From</th>
          <th>Reservation To</th>
          <th>Booked At</th>
          <th>Amount</th>
      </thead>
      </tr>
      <tbody>
        @foreach($reservations as $res)
        <tr>
          <td>{{ $res -> room -> room_number }}</td>
          <td>{{ date('F d, Y', strtotime($res -> reservation_from)) }}</td>
          <td>{{ date('F d, Y', strtotime($res -> reservation_to)) }}</td>
          <td>{{ $res -> created_at }}</td>
          <td>{{ $res -> room -> price }}</td>
        </tr>
        @endforeach
        <tr>
          <td colspan="2"><strong>Total:</strong></td>
          <td></td>
          <td></td>
          <td></td>
          <td><!-- Display price total here --></td>
        </tr>
      </tbody>
    </table>
  </div>

Reservation Model

class Reservation extends Model
{
    use SoftDeletes;
    protected $table = 'reservations';

    protected $fillable = ['roomNumber', 'clientId', 'reservation_from', 'reservation_to'];

    public function room() {
        return $this->belongsTo('App\Room');
    }

}

Room model

class Room extends Model
{
    use SoftDeletes;
    protected $table = 'rooms';

    protected $fillable = ['id', 'roomNumber', 'type', 'price', 'description'];

    public function reservations() {
        return $this->hasMany('App\Reservation', 'id', 'room_number');
    }
}

When I try to add this in my controller,

$sum = $reservations['room']->sum( 'price' );
dd($sum);

I get an Undefined index: room

What I wanted to is to display the total amount(sum) by adding the prices from the rooms table. How can I do that with Laravel and Eloquent? Thank you in advance.

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

1条回答 默认 最新

  • douwei2966 2015-10-27 08:56
    已采纳

    $reservations->sum('room.price')

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题