@extends('layouts.app')

@section('title', 'All Bank Transactions')

@section('content')
<style>
    /* Reduced line height for filters section */
    .filters-section .form-group {
        margin-bottom: 0.5rem;
    }
    .filters-section .form-group label {
        margin-bottom: 0.25rem;
        line-height: 1.2;
        font-size: 0.875rem;
    }
    .filters-section .form-control {
        line-height: 1.2;
        padding: 0.375rem 0.5rem;
        font-size: 0.875rem;
    }
    .filters-section .btn {
        line-height: 1.2;
        padding: 0.375rem 0.5rem;
    }
    .filters-section .row {
        margin-bottom: 0.5rem;
    }
</style>
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="card-title">
                        <i class="fas fa-exchange-alt"></i> All Bank Transactions
                    </h3>
                    <div>
                        <a href="{{ route('bank-transactions.day-wise-summary') }}" class="btn btn-info mr-2">
                            <i class="fas fa-calendar-alt"></i> Day-wise Summary
                        </a>
                    <a href="{{ route('bank-information.index') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left"></i> Back to Bank Information
                    </a>
                    </div>
                </div>
                
                <div class="card-body">
                    @if(session('success'))
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            {{ session('success') }}
                            <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                    @endif

                    <!-- Statistics Cards -->
                    <div class="row mb-4">
                        <div class="col-md-2">
                            <div class="card bg-primary text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">{{ $stats['total_transactions'] }}</h5>
                                    <small>Total Transactions ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-success text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['total_deposits'], 2) }}</h5>
                                    <small>Total Deposits ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-danger text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['total_withdrawals'], 2) }}</h5>
                                    <small>Total Withdrawals ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-warning text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">{{ $stats['pending_transactions'] }}</h5>
                                    <small>Pending ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-info text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">{{ $stats['completed_transactions'] }}</h5>
                                    <small>Completed ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card bg-secondary text-white w-100">
                                <div class="card-body text-center py-2">
                                    <h5 class="mb-1">৳{{ number_format($stats['total_deposits'] - $stats['total_withdrawals'], 2) }}</h5>
                                    <small>Net Balance ({{ now()->format('M Y') }})</small>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Filters -->
                    <div class="card mb-4 filters-section">
                        <div class="card-header">
                            <h5 class="mb-0">Filters</h5>
                        </div>
                        <div class="card-body">
                            <form method="GET" action="{{ route('bank-transactions.index') }}">
                                <div class="row">
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="search">Search</label>
                                            <input type="text" class="form-control" id="search" name="search" 
                                                   value="{{ request('search') }}" placeholder="Search transactions...">
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="bank_name">Bank Name</label>
                                            <select class="form-control" id="bank_name" name="bank_name">
                                                <option value="">All Banks</option>
                                                @foreach(\App\Models\BankAccountInfo::distinct()->pluck('bank_name') as $bankName)
                                                    <option value="{{ $bankName }}" {{ request('bank_name') == $bankName ? 'selected' : '' }}>
                                                        {{ $bankName }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label for="account_name">Account Name</label>
                                            <select class="form-control" id="account_name" name="account_name">
                                                <option value="">All Accounts</option>
                                                @foreach(\App\Models\BankAccountInfo::select('account_name', 'account_number', 'bank_name')->get() as $account)
                                                    <option value="{{ $account->account_name }}" data-bank-name="{{ $account->bank_name }}">
                                                        {{ $account->account_name }} - {{ $account->account_number }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label for="transaction_type">Type</label>
                                            <select class="form-control" id="transaction_type" name="transaction_type">
                                                <option value="">All</option>
                                                <option value="deposit" {{ request('transaction_type') == 'deposit' ? 'selected' : '' }}>Deposit</option>
                                                <option value="withdrawal" {{ request('transaction_type') == 'withdrawal' ? 'selected' : '' }}>Withdrawal</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label for="status">Status</label>
                                            <select class="form-control" id="status" name="status">
                                                <option value="">All</option>
                                                <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                                <option value="completed" {{ request('status') == 'completed' ? 'selected' : '' }}>Completed</option>
                                                <option value="failed" {{ request('status') == 'failed' ? 'selected' : '' }}>Failed</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label for="date_from">Date From</label>
                                            <input type="date" class="form-control" id="date_from" name="date_from" 
                                                   value="{{ request('date_from') }}">
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label for="date_to">Date To</label>
                                            <input type="date" class="form-control" id="date_to" name="date_to" 
                                                   value="{{ request('date_to') }}">
                                        </div>
                                    </div>
                                    <div class="col-md-1">
                                        <div class="form-group">
                                            <label>&nbsp;</label>
                                            <button type="submit" class="btn btn-primary btn-sm btn-block">Filter</button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

                    <!-- Filter Summary -->
                    @php
                        $hasFilters = request()->hasAny(['search', 'transaction_type', 'status', 'date_from', 'date_to']);
                    @endphp
                    
                    @if($hasFilters)
                        <div class="alert alert-info">
                            <div class="row align-items-center">
                                <div class="col-md-8">
                                    <h6 class="mb-1"><i class="fas fa-filter"></i> Filtered Results Summary</h6>
                                    <div class="small">
                                        @php
                                            $filteredStats = [
                                                'count' => $transactions->total(),
                                                'total_deposit_balance' => $transactions->sum('deposit_balance'),
                                                'total_fee' => $transactions->sum('fee'),
                                                'total_withdraw_balance' => $transactions->sum('withdraw_balance'),
                                                'deposits' => $transactions->where('transaction_type', 'deposit')->sum('deposit_balance'),
                                                'withdrawals' => $transactions->where('transaction_type', 'withdrawal')->sum('withdraw_balance'),
                                            ];
                                            $netAmount = $filteredStats['deposits'] - $filteredStats['withdrawals'];
                                        @endphp
                                        <span class="badge badge-primary mr-1">{{ $filteredStats['count'] }} transactions</span>
                                        <span class="badge badge-success mr-1">Deposits: +৳{{ number_format($filteredStats['deposits'], 2) }}</span>
                                        <span class="badge badge-danger mr-1">Withdrawals: -৳{{ number_format($filteredStats['withdrawals'], 2) }}</span>
                                        <span class="badge badge-info mr-1">Net: ৳{{ number_format($netAmount, 2) }}</span>
                                        <span class="badge badge-secondary mr-1">Total Deposits: ৳{{ number_format($filteredStats['total_deposit_balance'], 2) }}</span>
                                        <span class="badge badge-info mr-1">Total Withdrawals: ৳{{ number_format($filteredStats['total_withdraw_balance'], 2) }}</span>
                                        <span class="badge badge-warning mr-1">Total Fee: ৳{{ number_format($filteredStats['total_fee'], 2) }}</span>
                                    </div>
                                </div>
                                <div class="col-md-4 text-right">
                                    <a href="{{ route('bank-transactions.index') }}" class="btn btn-sm btn-outline-danger">
                                        <i class="fas fa-times"></i> Clear All
                                    </a>
                                </div>
                            </div>
                        </div>
                    @endif
                    <div class="table-responsive">
                        @php
                            // Pre-calculate running balances per transaction (Balance after Deposit)
                            $runningBalances = [];
                            $accountIds = $transactions->pluck('bank_account_info_id')->unique()->filter()->values();
                            foreach ($accountIds as $accountId) {
                                $account = \App\Models\BankAccountInfo::find($accountId);
                                $opening = $account->opening_balance ?? 0;
                                $allTx = \App\Models\BankTransaction::where('bank_account_info_id', $accountId)
                                    ->orderBy('transaction_date', 'asc')
                                    ->orderBy('id', 'asc')
                                    ->get();
                                $balance = $opening;
                                foreach ($allTx as $tx) {
                                    $balance += $tx->deposit_balance;
                                    $balance -= $tx->withdraw_balance;
                                    $runningBalances[$tx->id] = $balance;
                                }
                            }
                        @endphp
                        <table class="table table-bordered table-striped">
                            <thead class="thead-dark">
                                <tr>
                                    <th>SL</th>
                                    <th>Date</th>
                                    <th>Bank Account</th>
                                    <th>Account Holder</th>
                                    <th>Type</th>
                                    <th>Description</th>
                                    <th>Amount</th>
                                    <th>Fee</th>
                                    <th>Withdrawal</th>
                                    <th>Deposit</th>
                                    <th>Balance</th>
                                    <th>Status</th>
                                    <th>Initiated & Created by</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($transactions as $index => $transaction)
                                    <tr>
                                        <td>{{ $transactions->firstItem() + $index }}</td>
                                        <td>{{ $transaction->transaction_date->format('M d, Y H:i') }}</td>
                                        <td>
                                            <strong>{{ $transaction->bankAccountInfo->bank_name }}</strong><br>
                                            <small class="text-muted">{{ $transaction->bankAccountInfo->account_number }}</small>
                                        </td>
                                        <td>{{ $transaction->bankAccountInfo->accountHolder->name }}</td>
                                        <td>
                                            <span class="badge badge-{{ $transaction->isDeposit() ? 'success' : 'warning' }}">
                                                {{ ucfirst($transaction->transaction_type) }}
                                            </span>
                                        </td>
                                        <td>{{ $transaction->description ?? 'N/A' }}</td>
                                        <td>
                                            <span class="{{ $transaction->isDeposit() ? 'text-success' : 'text-danger' }}">
                                                {{ $transaction->signed_amount }}
                                            </span>
                                        </td>
                                        <td>
                                            @if($transaction->fee > 0)
                                                <span class="text-warning">৳{{ number_format($transaction->fee, 2) }}</span>
                                            @else
                                                <span class="text-muted">-</span>
                                            @endif
                                        </td>
                                        <td>৳{{ number_format($transaction->withdraw_balance, 2) }}</td>
                                        <td>৳{{ number_format($transaction->deposit_balance, 2) }}</td>
                                        <td>
                                            <strong class="text-primary">৳{{ number_format($runningBalances[$transaction->id] ?? 0, 2) }}</strong>
                                        </td>
                                        <td>
                                            @php
                                                $isApproved = !is_null($transaction->approved_by) && !is_null($transaction->approved_at);
                                            @endphp
                                            <div>
                                                @if($transaction->status != 'completed')
                                                    <span class="badge badge-{{ $transaction->status == 'pending' ? 'warning' : 'danger' }}">
                                                {{ ucfirst($transaction->status) }}
                                            </span>
                                                    <br>
                                                @endif
                                                @if($isApproved)
                                                    <span class="badge badge-success {{ $transaction->status == 'completed' ? '' : 'mt-1' }}" title="Approved by {{ $transaction->approvedBy->name ?? 'N/A' }} on {{ $transaction->approved_at->format('d M Y, h:i A') }}">
                                                        <i class="fas fa-check-circle"></i>
                                                    </span>
                                                @else
                                                    <span class="badge badge-warning {{ $transaction->status == 'completed' ? '' : 'mt-1' }}" title="Not approved yet">
                                                        <i class="fas fa-times-circle"></i>
                                                    </span>
                                                @endif
                                            </div>
                                        </td>
                                        <td>
                                            @if($transaction->initiated_by || $transaction->created_by)
                                                <div class="small">
                                                    @if($transaction->initiated_by)
                                                        <div><strong>Initiated:</strong> {{ $transaction->initiatedBy->name ?? 'N/A' }}</div>
                                                    @endif
                                                    @if($transaction->created_by)
                                                        <div><strong>Created:</strong> {{ $transaction->createdBy->name ?? 'N/A' }}</div>
                                                    @endif
                                                </div>
                                            @else
                                                <span class="text-muted">-</span>
                                            @endif
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="12" class="text-center">No transactions found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>

                    <!-- Pagination -->
                    @if($transactions->hasPages())
                        <div class="d-flex justify-content-between align-items-center py-3 border-top border-bottom bg-white">
                            <div class="text-muted">
                                Showing <strong>{{ $transactions->firstItem() }}</strong> to <strong>{{ $transactions->lastItem() }}</strong> of <strong>{{ $transactions->total() }}</strong> transactions
                            </div>
                            <div>
                                <nav aria-label="Page navigation">
                                    {{ $transactions->appends(request()->query())->links('pagination::bootstrap-4') }}
                                </nav>
                            </div>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

<script>
document.addEventListener('DOMContentLoaded', function() {
    const bankNameSelect = document.getElementById('bank_name');
    const accountNameSelect = document.getElementById('account_name');
    
    // Store all account options
    const allAccountOptions = Array.from(accountNameSelect.options);
    
    bankNameSelect.addEventListener('change', function() {
        const selectedBankName = this.value;
        
        // Clear current options
        accountNameSelect.innerHTML = '<option value="">All Accounts</option>';
        
        if (selectedBankName) {
            // Filter and add matching account options
            allAccountOptions.forEach(option => {
                if (option.value && option.dataset.bankName === selectedBankName) {
                    accountNameSelect.appendChild(option.cloneNode(true));
                }
            });
        } else {
            // Show all accounts
            allAccountOptions.forEach(option => {
                accountNameSelect.appendChild(option.cloneNode(true));
            });
        }
    });
});
</script>