@extends('layouts.master')

@section('title', 'Account Ledger | ')
@section('content')
    @include('partials.header')
   <!-- @include('partials.sidebar')-->

   <style>
        @media print {
            @page {
                size: A4 portrait;
                margin: 1cm;
            }
            body {
                font-size: 8px;
            }
            .ledger-header {
                text-align: center;
                font-size: 10px;
                font-weight: bold;
                margin-bottom: 10px;
            }
            .underline {
                border-bottom: 2px solid black;
                font-weight: bold;
                display: inline-block;
                padding-bottom: 2px;
            }
            table {
                font-size: 8px;
                width: 100%;
            }
            thead { display: table-header-group; }
            tfoot { display: table-row-group; }
            .hide-on-print {
                display: none !important;
            }
        }
    </style>

    <main class="app-content">
        <div class="app-title text-center">
            <h1><i class="fa fa-file-text-o"></i> Account Ledger</h1>
            <p>A Printable Ledger Account Format</p>
        </div>



        <div class="hide-on-print">
            <form action="{{ url('detailaccount/' . $payment->Account_ID) }}" method="GET">
                <div class="row">
                    <div class="col-md-4">
                        <label>From Date:</label>
                        <input type="date" name="from_date" class="form-control" value="{{ request('from_date') ?? date('Y-m-01') }}" required>
                    </div>
                    <div class="col-md-4">
                        <label>To Date:</label>
                        <input type="date" name="to_date" class="form-control" value="{{ request('to_date') ?? date('Y-m-d') }}" required>
                    </div>
                    <div class="col-md-4" style="margin-top:30px;">
                        <button type="submit" class="btn btn-primary">Show</button>
                    </div>
                </div>
            </form>
        </div>
        <br>

        <div class="tile">
            <section class="invoice">
                <div class="ledger-header">
                    <h2>Account Ledger</h2>
                    <p><b>Account Name: {{ $payment->Account_Title }}</b></p>
                    <p class="underline">From: {{ request('from_date') }} To: {{ request('to_date') }}</p>
                </div>

                <div class="table-responsive">
                    <table class="table table-striped">
                        <thead>
                            <tr>
                                <th>Voucher#</th>
                                <th>Date</th>
                                <th>Entry Narration</th>
                                <th>Debit</th>
                                <th>Credit</th>
                                <th>Closing Balance</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $runningBalance = 0; @endphp
                            @foreach($details as $detail)
                                @php
                                    $debit = $detail->entryType == 'D' ? $detail->Amount : 0;
                                    $credit = $detail->entryType == 'C' ? $detail->Amount : 0;
                                    $runningBalance += ($debit + $credit);
                                @endphp
                                <tr>
                                    <td>{{ $detail->Id }}-{{ $detail->VoucherType }}</td>
                                    <td>{{ $detail->VoucherDate }}</td>
                                    <td>{{ $detail->Entry_Narration }}</td>
                                    <td>{{ number_format($debit, 2) }}</td>
                                    <td>{{ number_format($credit, 2) }}</td>
                                    <td>{{ number_format($runningBalance, 2) }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td colspan="3"><b>Total</b></td>
                                <td><b>{{ number_format($details->where('entryType', 'D')->sum('Amount'), 2) }}</b></td>
                                <td><b>{{ number_format($details->where('entryType', 'C')->sum('Amount'), 2) }}</b></td>
                                <td><b>{{ number_format($runningBalance, 2) }}</b></td>
                            </tr>
                        </tfoot>
                    </table>
                </div>

                <div class="row d-print-none mt-2">
                    <div class="col-12 text-right">
                        <a class="btn btn-primary" href="javascript:void(0);" onclick="window.print();">
                            <i class="fa fa-print"></i> Print
                        </a>
                    </div>
                </div>
            </section>
        </div>
    </main>
@endsection