@extends('admin_dashboard')
@section('admin')

<div class="content">
    <div class="container-fluid">
        <style>
            @media print {
                .dataTables_length,
                .dataTables_filter,
                .dataTables_info,
                .dataTables_paginate,
                .btn-print {
                    display: none !important;
                }
            }
        </style>
        <div class="page-title-box">
            <h4 class="page-title">Other Projects Member Statement</h4>
            <button class="btn btn-primary btn-print" onclick="window.print()">Print</button>
        </div>

        <div class="card shadow-sm mb-3">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-6">
                        <p><strong>Account Type:</strong> {{ $account->account_type }}</p>
                        <p><strong>Account No:</strong> {{ $account->account_number }}</p>
                        <p><strong>GSS No:</strong> {{ $account->gss_number }}</p>
                    </div>
                    <div class="col-md-6">
                        <p><strong>From:</strong> {{ $startDate->format('d-m-Y') }}</p>
                        <p><strong>To:</strong> {{ $endDate->format('d-m-Y') }}</p>
                        <p><strong>Opening Balance:</strong> {{ number_format($openingBalance, 2) }}</p>
                    </div>
                </div>
            </div>
        </div>

        <div class="card shadow-sm">
            <div class="card-body">
                <table id="basic-datatable" class="table table-bordered align-middle w-100">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Invoice</th>
                            <th>Description</th>
                            <th>Debit</th>
                            <th>Credit</th>
                            <th>Balance</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $running = $openingBalance; @endphp
                        @foreach($transactions as $t)
                            <tr>
                                <td>{{ \Carbon\Carbon::parse($t->date)->format('d-m-Y') }}</td>
                                <td>{{ $t->invoice_no }}</td>
                                <td>{{ $t->description }}</td>
                                <td>{{ number_format($t->dr_amount ?? 0, 2) }}</td>
                                <td>{{ number_format($t->cr_amount ?? 0, 2) }}</td>
                                @php $running += ($t->cr_amount ?? 0) - ($t->dr_amount ?? 0); @endphp
                                <td>{{ number_format($running, 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

@endsection