@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
    <!--breadcrumb-->
    <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
        <div class="breadcrumb-title pe-3">Vendor</div>
        <div class="ps-3">
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0 p-0">
                    <li class="breadcrumb-item"><a href="javascript:;"><i class="bx bx-home-alt"></i></a>
                    </li>
                    <li class="breadcrumb-item active" aria-current="page">Ledger</li>
                </ol>
            </nav>
        </div>

    </div>
    <!--end breadcrumb-->
    <hr />
        <div class="main-body">
            <div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-body">
                            <table class="table table-bordered mt-4">
                                    <thead class="thead-dark">
                                        <tr>
                                            <th>Date</th>
                                            <th>Ref Code</th>
                                            <th>Narration</th>
                                            <th class="text-end">Debit</th>
                                            <th class="text-end">Credit</th>
                                            <th class="text-end">Balance</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php $totalDebit = 0; $totalCredit = 0; @endphp
                                        @foreach($ledger as $row)
                                            @php
                                                $totalDebit += $row['debit'];
                                                $totalCredit += $row['credit'];
                                            @endphp
                                            <tr>
                                                <td>{{ $row['date'] }}</td>
                                                <td>{{ $row['ref_code'] }}</td>
                                                <td>{{ $row['narration'] }}</td>
                                                <td class="text-end">{{ number_format($row['debit'], 2) }}</td>
                                                <td class="text-end">{{ number_format($row['credit'], 2) }}</td>
                                                <td class="text-end">{{ number_format($row['balance'], 2) }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot class="fw-bold">
                                        <tr>
                                            <td colspan="3" class="text-end">Total</td>
                                            <td class="text-end">{{ number_format($totalDebit, 2) }}</td>
                                            <td class="text-end">{{ number_format($totalCredit, 2) }}</td>
                                            <td class="text-end">{{ number_format($totalCredit - $totalDebit, 2) }}</td>
                                        </tr>
                                    </tfoot>
                                </table>

                      
                        </div>
                    </div>

                </div>
            </div>
        </div>

</div>


@endsection