so I have this output:
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:
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.
