@extends('layouts.admin')
@section('content')
@php
       $months=[
                        ''=>'None',
                        1=>'January',
                        2=>'February',
                        3=>'March',
                        4=>'April',
                        5=>'May',
                        6=>'Jun',
                        7=>'July',
                        8=>'August',
                        9=>'September',
                        10=>'October',
                        11=>'November',
                        12=>'December',
                ];
@endphp
<div class="container">
    <div class="card">
        <div class="card-header">
            Account statement of <strong>{{$ppp->name?$ppp->name:""}}</strong>
        </div>
        <div class="card-body">
            <table class="table table-striped table-hover table-sm">
                <thead>
                    <th>Date</th>
                    <th>Particulars</th>
                    <th>Incoming</th>
                    <th>Outgoing</th>
                    <th>Balance</th>
                </thead>
                <tbody>
                    @php
                        $balance=0;
                    @endphp
                    @foreach ($ledger as $l)
                        <tr>
                            <td>
                                {{$l->created_at->format('M d, Y')}}
                                <br>
                                {{$l->created_at->format('h:i:s A')}}
                            </td>
                            <td>{{$l->particulars}}</td>
                            <td>{{$l->in}}</td>
                            <td>{{$l->out}}</td>
                            <td>
                                @php
                                $balance=$balance+$l->in-$l->out;
                                @endphp
                                {{number_format($balance,2)}}
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div><!--.card-->
    
  

</div>
@endsection