@extends('layouts.app')

@section('content')
<h3>Inventory Valuation Report</h3>

<table class="table table-bordered">
<thead>
<tr>
    <th>Item</th>
    <th>Category</th>
    <th>Qty</th>
    <th>Unit Cost</th>
    <th>Total Value</th>
</tr>
</thead>

<tbody>
@foreach($items as $i)
<tr>
    <td>{{ $i->name }}</td>
    <td>{{ $i->category }}</td>
    <td>{{ $i->qty }}</td>
    <td>{{ number_format($i->unit_cost,2) }}</td>
    <td>{{ number_format($i->total_value,2) }}</td>
</tr>
@endforeach
</tbody>

<tfoot class="table-secondary">
<tr>
    <th colspan="4">Grand Total</th>
    <th>{{ number_format($grandTotal,2) }}</th>
</tr>
</tfoot>
</table>
@endsection