@extends('layouts.master')

@section('content')
<div class="container">
    <h4>Bank Opening Report</h4>

    <div class="mb-2">
        <a href="{{ route('bankopening.report.pdf') }}" class="btn btn-danger">Export PDF</a>
        <a href="{{ route('bankopening.report.excel') }}" class="btn btn-success">Export Excel</a>
        <button onclick="window.print()" class="btn btn-secondary">Print</button>
    </div>

    <h5><strong>Bank: {{ $bank->Account_Title }}</strong></h5>
<p><strong>Opening Balance: {{ number_format(session('openingbalance'), 0) }}</strong></p>
    <table class="table table-bordered table-sm">
        <thead>
            <tr>
                <th>Date</th>
                <th>Narration</th>
                <th>Debit</th>
                <th>Credit</th>
                <th>Cl.Balane</th>
            </tr>
        </thead>
        <tbody>
@php
    $balance = $bank->openingbalance ?? 0;
@endphp

@php
    $balance = $openingbalance ?? 0; // ensure openingbalance is set properly
@endphp

@foreach($data as $entry)
    @php
        $debit = '';
        $credit = '';

        if ($entry->entryType == 'D') {
            $debit = $entry->Amount;
            $balance += $entry->Amount;
        } elseif ($entry->entryType == 'C') {
            $credit = $entry->Amount;
            $balance -= $entry->Amount;
        }
    @endphp

    <tr>
        <td>{{ $entry->VoucherDate }}</td>
        <td>{{ $entry->Entry_Narration }}</td>
        <td>{{ $debit ? number_format($debit, 0) : '' }}</td>
        <td>{{ $credit ? number_format($credit, 0) : '' }}</td>
        <td><strong>{{ number_format($balance, 0) }}</strong></td>
    </tr>
</tbody>
@endforeach
    </table>
</div>
@endsection