@extends('layouts.app')

@section('content')
<h3>Inventory Movement (Stock Ledger)</h3>

<table class="table table-bordered">
<thead>
<tr>
    <th>Date</th>
    <th>Ref</th>
    <th>Description</th>
    <th>Debit (IN)</th>
    <th>Credit (OUT)</th>
    <th>Qty Balance</th>
    <th>Value Balance</th>
</tr>
</thead>

<tbody>
@foreach($rows as $row)
<tr>
    <td>{{ $row['date'] }}</td>
    <td>{{ $row['ref'] }}</td>
    <td>{{ $row['desc'] }}</td>
    <td>{{ number_format($row['debit'],2) }}</td>
    <td>{{ number_format($row['credit'],2) }}</td>
    <td>{{ $row['qty_balance'] }}</td>
    <td>{{ number_format($row['value_balance'],2) }}</td>
</tr>
@endforeach
</tbody>
</table>

@endsection