@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">Product</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>Type</th>
                                        <th class="text-end">Qty In</th>
                                        <th class="text-end">Qty Out</th>
                                        <th class="text-end">Rate</th>
                                        <th class="text-end">Value</th>
                                        <th class="text-end">Stock Balance</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $totalIn = 0; $totalOut = 0; $totalValue = 0; @endphp
                                    @foreach($ledger as $row)
                                        @php
                                            $totalIn += $row['qty_in'];
                                            $totalOut += $row['qty_out'];
                                            $totalValue += $row['value'];
                                        @endphp
                                        <tr>
                                            <td>{{ $row['date'] }}</td>
                                            <td>{{ ucfirst($row['type']) }}</td>
                                            <td class="text-end">{{ $row['qty_in'] }}</td>
                                            <td class="text-end">{{ $row['qty_out'] }}</td>
                                            <td class="text-end">{{ number_format($row['rate'], 2) }}</td>
                                            <td class="text-end">{{ number_format($row['value'], 2) }}</td>
                                            <td class="text-end">{{ $row['stock_balance'] }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                               <tfoot class="text-end">
                                    <tr>
                                        <th colspan="2">Total</th>
                                        <th>{{ $totalIn }}</th>
                                        <th>{{ $totalOut }}</th>
                                        <th></th>
                                        <th>{{ number_format($totalValue, 2) }}</th>
                                        <th>{{ $stockBalance }}</th>
                                    </tr>
                                </tfoot>
                            </table>

                      
                        </div>
                    </div>

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

</div>


@endsection