@extends('student.student_dashboard')

@section('admin')
<div class="content-body">
<div class="container-fluid">
   <div class="container">
    <h3 class="mb-4">Billing History</h3>

    <!-- Summary Card -->
    <div class="card mb-4">
        <div class="card-body">
            <h5>Account Summary</h5>
            <div class="row">
                <div class="col-md-2"><strong>Total Fee:</strong> {{ number_format($totalFee) }} ৳</div>
                <div class="col-md-2"><strong>Total Paid:</strong> {{ number_format($totalPaid) }} ৳</div>
                <div class="col-md-2"><strong>Balance:</strong> {{ number_format($balance) }} ৳</div>
            </div>
        </div>
    </div>

    <!-- Installment Card -->
    <div class="card mb-4">
        <div class="card-body">
            <h5>Installment Information</h5>
            <div class="table-responsive">
                <table class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>SL</th>
                            <th>Installment No</th>
                            <th>Due Date</th>
                            <th>Installment Amount</th>
                            <th>Payable</th>
                            <th>Late Fee</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($installments as $key => $inst)
                            @php
                                $paidAmount = $inst->studentPayments
                                    ->where('student_id', Auth::user()->id)
                                    ->sum('amount');
                                $isPaid = $paidAmount >= $inst->payable;
                            @endphp
                            <tr>
                                <td>{{ $key + 1 }}</td>
                                <td>{{ $inst->installment_number }}</td>
                                <td>{{ \Carbon\Carbon::parse($inst->due_date)->format('Y-m-d') }}</td>
                                <td>{{ number_format($inst->amount) }} ৳</td>
                                <td>{{ number_format($inst->payable ?? $inst->amount) }} ৳</td>
                                <td>{{ number_format($inst->late_fee ?? 0) }} ৳</td>
                                <td>
                                    @if($isPaid)
                                        <span class="badge bg-success">Paid</span>
                                    @else
                                        <span class="badge bg-danger">Unpaid</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="7" class="text-center text-muted">No installment data found</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Billing Ledger -->
    <div class="card">
        <div class="card-body">
            <h5>Account Ledger</h5>
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>SL</th>
                        <th>Date</th>
                        <th>Type</th>
                        <th>Details</th>
                        <th>Debit (Charge)</th>
                        <th>Credit (Payment)</th>
                        <th>Remark</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($billingHistory as $key => $item)
                        <tr>
                            <td>{{ $key + 1 }}</td>
                            <td>{{ $item['date'] }}</td>
                            <td>{{ $item['type'] }}</td>
                            <td>{{ $item['details'] }}</td>
                            <td class="text-danger">{{ $item['debit'] > 0 ? number_format($item['debit']) : '-' }}</td>
                            <td class="text-success">{{ $item['credit'] > 0 ? number_format($item['credit']) : '-' }}</td>
                            <td>{{ $item['remark'] }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center text-muted">No billing history found.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
</div>
</div>
@endsection