@extends('layouts.master')

@section('page_title', 'Account Statement')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>Account Statement</h1>
        <div>
            <a href="{{ route('reports.chart-of-accounts') }}" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Back to Chart of Accounts
            </a>
            <a href="#" onclick="window.print()" class="btn btn-outline-secondary">
                <i class="fas fa-print"></i> Print
            </a>
            <a href="{{ route('reports.account-statement', array_merge(['account' => $account->id], request()->all(), ['format' => 'pdf'])) }}" class="btn btn-danger">
                <i class="fas fa-file-pdf"></i> PDF
            </a>
        </div>
    </div>

    <!-- Filter Options -->
    <div class="card mb-4 no-print">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.account-statement', $account) }}" class="row g-3">
                <div class="col-md-4">
                    <label for="start_date" class="form-label">Start Date</label>
                    <input type="date" class="form-control" id="start_date" name="start_date" 
                           value="{{ request('start_date', $startDate) }}">
                </div>
                <div class="col-md-4">
                    <label for="end_date" class="form-label">End Date</label>
                    <input type="date" class="form-control" id="end_date" name="end_date" 
                           value="{{ request('end_date', $endDate) }}">
                </div>
                <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Update Statement</button>
                </div>
            </form>
        </div>
    </div>

    <!-- Account Information -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Account Information</h5>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-6">
                    <table class="table table-borderless">
                        <tr>
                            <td class="fw-bold" style="width: 140px;">Account Code:</td>
                            <td><code class="text-primary">{{ $account->code ?? $account->account_code }}</code></td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Account Name:</td>
                            <td>{{ $account->name }}</td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Account Type:</td>
                            <td>
                                {{ $account->accountType->name ?? 'N/A' }}
                                @if($account->accountType)
                                    <span class="badge bg-secondary ms-2">{{ ucfirst($account->accountType->category) }}</span>
                                @endif
                            </td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Normal Balance:</td>
                            <td>
                                <span class="badge {{ $account->accountType->normal_balance === 'debit' ? 'bg-info' : 'bg-warning' }}">
                                    {{ ucfirst($account->accountType->normal_balance ?? 'N/A') }}
                                </span>
                            </td>
                        </tr>
                    </table>
                </div>
                <div class="col-md-6">
                    <table class="table table-borderless">
                        <tr>
                            <td class="fw-bold" style="width: 140px;">Statement Period:</td>
                            <td>{{ \Carbon\Carbon::parse($startDate)->format('M d, Y') }} to {{ \Carbon\Carbon::parse($endDate)->format('M d, Y') }}</td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Opening Balance:</td>
                            <td>
                                <span class="h6 {{ $openingBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($openingBalance, 2) }}
                                </span>
                            </td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Closing Balance:</td>
                            <td>
                                <span class="h6 {{ $closingBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($closingBalance, 2) }}
                                </span>
                            </td>
                        </tr>
                        <tr>
                            <td class="fw-bold">Status:</td>
                            <td>
                                @if($account->is_active)
                                    <span class="badge bg-success">Active</span>
                                @else
                                    <span class="badge bg-secondary">Inactive</span>
                                @endif
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            @if($account->description)
            <div class="row mt-3">
                <div class="col-12">
                    <div class="alert alert-light">
                        <strong>Description:</strong> {{ $account->description }}
                    </div>
                </div>
            </div>
            @endif
        </div>
    </div>

    <!-- Statement Transactions -->
    <div class="card">
        <div class="card-header d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Transaction History</h5>
            <span class="badge bg-primary">{{ $transactions->count() }} Transactions</span>
        </div>
        <div class="card-body">
            @if($transactions->count() > 0)
                <div class="table-responsive">
                    <table class="table table-striped table-hover">
                        <thead class="table-dark">
                            <tr>
                                <th style="width: 12%">Date</th>
                                <th style="width: 15%">Reference</th>
                                <th style="width: 30%">Description</th>
                                <th style="width: 12%" class="text-end">Debit</th>
                                <th style="width: 12%" class="text-end">Credit</th>
                                <th style="width: 12%" class="text-end">Balance</th>
                                <th style="width: 7%" class="text-center no-print">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <!-- Opening Balance Row -->
                            <tr class="table-info">
                                <td colspan="3">
                                    <strong>Opening Balance as of {{ \Carbon\Carbon::parse($startDate)->format('M d, Y') }}</strong>
                                </td>
                                <td class="text-end">-</td>
                                <td class="text-end">-</td>
                                <td class="text-end">
                                    <strong class="{{ $openingBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                        {{ number_format($openingBalance, 2) }}
                                    </strong>
                                </td>
                                <td class="text-center">-</td>
                            </tr>

                            @foreach($transactions as $transaction)
                            <tr>
                                <td>{{ $transaction->journalEntry->entry_date ? \Carbon\Carbon::parse($transaction->journalEntry->entry_date)->format('M d, Y') : 'N/A' }}</td>
                                <td>
                                    <a href="{{ route('journal-entries.show', $transaction->journalEntry) }}" class="text-decoration-none">
                                        {{ $transaction->journalEntry->entry_number ?? 'N/A' }}
                                    </a>
                                </td>
                                <td>
                                    <div>
                                        <strong>{{ $transaction->description ?: $transaction->journalEntry->description }}</strong>
                                    </div>
                                    @if($transaction->description && $transaction->journalEntry->description && $transaction->description !== $transaction->journalEntry->description)
                                        <small class="text-muted">Entry: {{ $transaction->journalEntry->description }}</small>
                                    @endif
                                </td>
                                <td class="text-end">
                                    @if($transaction->debit_amount > 0)
                                        <span class="text-info fw-bold">{{ number_format($transaction->debit_amount, 2) }}</span>
                                    @else
                                        <span class="text-muted">-</span>
                                    @endif
                                </td>
                                <td class="text-end">
                                    @if($transaction->credit_amount > 0)
                                        <span class="text-success fw-bold">{{ number_format($transaction->credit_amount, 2) }}</span>
                                    @else
                                        <span class="text-muted">-</span>
                                    @endif
                                </td>
                                <td class="text-end">
                                    <span class="fw-bold {{ $transaction->running_balance >= 0 ? 'text-success' : 'text-danger' }}">
                                        {{ number_format($transaction->running_balance, 2) }}
                                    </span>
                                </td>
                                <td class="text-center no-print">
                                    <a href="{{ route('journal-entries.show', $transaction->journalEntry) }}" 
                                       class="btn btn-sm btn-outline-primary" title="View Journal Entry">
                                        <i class="fas fa-eye"></i>
                                    </a>
                                </td>
                            </tr>
                            @endforeach

                            <!-- Closing Balance Row -->
                            <tr class="table-success">
                                <td colspan="3">
                                    <strong>Closing Balance as of {{ \Carbon\Carbon::parse($endDate)->format('M d, Y') }}</strong>
                                </td>
                                <td class="text-end">-</td>
                                <td class="text-end">-</td>
                                <td class="text-end">
                                    <strong class="{{ $closingBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                        {{ number_format($closingBalance, 2) }}
                                    </strong>
                                </td>
                                <td class="text-center">-</td>
                            </tr>
                        </tbody>
                    </table>
                </div>

                <!-- Summary Statistics -->
                <div class="row mt-4">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h6 class="mb-0">Period Summary</h6>
                            </div>
                            <div class="card-body">
                                <div class="row text-center">
                                    @php
                                        $totalDebits = $transactions->sum('debit_amount');
                                        $totalCredits = $transactions->sum('credit_amount');
                                        $netMovement = $closingBalance - $openingBalance;
                                        $transactionCount = $transactions->count();
                                        $averageTransaction = $transactionCount > 0 ? ($totalDebits + $totalCredits) / $transactionCount : 0;
                                    @endphp
                                    
                                    <div class="col-md-2">
                                        <h4 class="text-primary">{{ $transactionCount }}</h4>
                                        <p class="mb-0">Transactions</p>
                                    </div>
                                    <div class="col-md-2">
                                        <h4 class="text-info">{{ number_format($totalDebits, 2) }}</h4>
                                        <p class="mb-0">Total Debits</p>
                                    </div>
                                    <div class="col-md-2">
                                        <h4 class="text-success">{{ number_format($totalCredits, 2) }}</h4>
                                        <p class="mb-0">Total Credits</p>
                                    </div>
                                    <div class="col-md-2">
                                        <h4 class="{{ $netMovement >= 0 ? 'text-success' : 'text-danger' }}">
                                            {{ number_format($netMovement, 2) }}
                                        </h4>
                                        <p class="mb-0">Net Movement</p>
                                    </div>
                                    <div class="col-md-2">
                                        <h4 class="text-secondary">{{ number_format($averageTransaction, 2) }}</h4>
                                        <p class="mb-0">Avg Transaction</p>
                                    </div>
                                    <div class="col-md-2">
                                        <h4 class="{{ $closingBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                            {{ number_format($closingBalance, 2) }}
                                        </h4>
                                        <p class="mb-0">Final Balance</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @else
                <div class="alert alert-info text-center">
                    <i class="fas fa-info-circle fa-2x mb-3"></i>
                    <h5>No Transactions Found</h5>
                    <p class="mb-0">This account has no transactions for the selected period.</p>
                    <small class="text-muted">
                        Period: {{ \Carbon\Carbon::parse($startDate)->format('M d, Y') }} to {{ \Carbon\Carbon::parse($endDate)->format('M d, Y') }}
                    </small>
                </div>
            @endif
        </div>
    </div>

    <!-- Quick Actions -->
    <div class="card mt-4 no-print">
        <div class="card-body">
            <h6 class="card-title">Quick Actions</h6>
            <div class="d-flex gap-2 flex-wrap">
                <a href="{{ route('accounts.show', $account) }}" class="btn btn-outline-primary btn-sm">
                    <i class="fas fa-eye"></i> View Account Details
                </a>
                <a href="{{ route('accounts.edit', $account) }}" class="btn btn-outline-warning btn-sm">
                    <i class="fas fa-edit"></i> Edit Account
                </a>
                <a href="{{ route('journal-entries.create') }}?account_id={{ $account->id }}" class="btn btn-outline-success btn-sm">
                    <i class="fas fa-plus"></i> New Journal Entry
                </a>
                <a href="{{ route('reports.general-ledger') }}?account_id={{ $account->id }}" class="btn btn-outline-info btn-sm">
                    <i class="fas fa-book"></i> General Ledger
                </a>
            </div>
        </div>
    </div>
</div>

<style>
@media print {
    .btn, .no-print {
        display: none !important;
    }
    
    .card {
        border: none !important;
        box-shadow: none !important;
    }
    
    .card-header {
        background: none !important;
        border: none !important;
    }
    
    body {
        -webkit-print-color-adjust: exact;
    }
    
    .table-dark {
        background-color: #343a40 !important;
        color: white !important;
    }
    
    .table-info {
        background-color: #d1ecf1 !important;
    }
    
    .table-success {
        background-color: #d4edda !important;
    }
}

.table-borderless td {
    padding: 0.25rem 0.5rem;
}

.transaction-row:hover {
    background-color: #f8f9fa;
}
</style>
@endsection