@extends('layouts.app')

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

@section('content')
<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> Transactions - {{ $bankAccountInfo->bank_name }} ({{ $bankAccountInfo->account_number }})
                    </h3>
                    <div>
                        <a href="{{ route('bank-information.create-transaction', $bankAccountInfo) }}" class="btn btn-success">
                            <i class="fas fa-plus"></i> Add Transaction
                        </a>
                        <a href="{{ route('bank-information.show', $bankAccountInfo) }}" class="btn btn-info">
                            <i class="fas fa-eye"></i> View Account
                        </a>
                        <a href="{{ route('bank-information.index') }}" class="btn btn-secondary">
                            <i class="fas fa-arrow-left"></i> Back to List
                        </a>
                    </div>
                </div>
                
                <div class="card-body">
                    <!-- Account Summary -->
                    <div class="row mb-4">
                        <div class="col-md-4">
                            <div class="card bg-primary text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">{{ $bankAccountInfo->accountHolder->name }}</h4>
                                    <p class="mb-0">Account Holder</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card bg-info text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">৳{{ number_format($bankAccountInfo->opening_balance, 2) }}</h4>
                                    <p class="mb-0">Opening Balance</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card bg-success text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">৳{{ number_format($bankAccountInfo->current_balance, 2) }}</h4>
                                    <p class="mb-0">Current Balance</p>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Filters -->
                    <div class="card mb-4">
                        <div class="card-header">
                            <h5 class="card-title mb-0">Filters</h5>
                        </div>
                        <div class="card-body">
                            <form method="GET" action="{{ route('bank-information.transactions', $bankAccountInfo) }}">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="transaction_type">Transaction Type</label>
                                            <select class="form-control" id="transaction_type" name="transaction_type">
                                                <option value="">All Types</option>
                                                <option value="deposit" {{ request('transaction_type') == 'deposit' ? 'selected' : '' }}>Deposit</option>
                                                <option value="withdrawal" {{ request('transaction_type') == 'withdrawal' ? 'selected' : '' }}>Withdrawal</option>
                                                <option value="transfer_in" {{ request('transaction_type') == 'transfer_in' ? 'selected' : '' }}>Transfer In</option>
                                                <option value="transfer_out" {{ request('transaction_type') == 'transfer_out' ? 'selected' : '' }}>Transfer Out</option>
                                                <option value="fee" {{ request('transaction_type') == 'fee' ? 'selected' : '' }}>Fee</option>
                                                <option value="interest" {{ request('transaction_type') == 'interest' ? 'selected' : '' }}>Interest</option>
                                                <option value="refund" {{ request('transaction_type') == 'refund' ? 'selected' : '' }}>Refund</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="status">Status</label>
                                            <select class="form-control" id="status" name="status">
                                                <option value="">All Status</option>
                                                <option value="completed" {{ request('status') == 'completed' ? 'selected' : '' }}>Completed</option>
                                                <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                                <option value="failed" {{ request('status') == 'failed' ? 'selected' : '' }}>Failed</option>
                                                <option value="cancelled" {{ request('status') == 'cancelled' ? 'selected' : '' }}>Cancelled</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <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-2">
                                        <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-2">
                                        <div class="form-group">
                                            <label>&nbsp;</label>
                                            <div class="d-flex gap-2">
                                                <button type="submit" class="btn btn-primary">
                                                    <i class="fas fa-search"></i> Filter
                                                </button>
                                                <a href="{{ route('bank-information.transactions', $bankAccountInfo) }}" class="btn btn-secondary">
                                                    <i class="fas fa-times"></i> Clear
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

                    @if($transactions->count() > 0)
                        @php
                            // Get all transactions in DESC order (newest first) for calculation
                            $allTransactions = $bankAccountInfo->bankTransactions()
                                ->orderBy('transaction_date', 'desc')
                                ->orderBy('id', 'desc')
                                ->get();
                            
                            // For running balance calculation, we need to reverse the order (oldest first)
                            $transactionsForCalculation = $allTransactions->sortBy(function($transaction) {
                                return $transaction->transaction_date->format('Y-m-d') . '-' . str_pad($transaction->id, 10, '0', STR_PAD_LEFT);
                            });
                            
                            $runningBalance = $bankAccountInfo->opening_balance ?? 0;
                            $totalDeposits = 0;
                            $totalWithdrawals = 0;
                            
                            // Pre-calculate running balances for display
                            $runningBalances = [];
                            foreach($transactionsForCalculation as $trans) {
                                // Always add deposit amount
                                $runningBalance += $trans->deposit_balance;
                                $totalDeposits += $trans->deposit_balance;
                                
                                // Always subtract withdrawal amount
                                $runningBalance -= $trans->withdraw_balance;
                                $totalWithdrawals += $trans->withdraw_balance;
                                
                                $runningBalances[$trans->id] = $runningBalance;
                            }
                        @endphp
                        
                        <!-- Summary Cards -->
                        <div class="row mb-4">
                            <div class="col-md-3">
                                <div class="card bg-info text-white">
                                    <div class="card-body text-center">
                                        <h5 class="mb-1">৳{{ number_format($bankAccountInfo->opening_balance ?? 0, 2) }}</h5>
                                        <small class="mb-0">Opening Balance</small>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card bg-success text-white">
                                    <div class="card-body text-center">
                                        <h5 class="mb-1">৳{{ number_format($totalDeposits, 2) }}</h5>
                                        <small class="mb-0">Total Deposits</small>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card bg-danger text-white">
                                    <div class="card-body text-center">
                                        <h5 class="mb-1">৳{{ number_format($totalWithdrawals, 2) }}</h5>
                                        <small class="mb-0">Total Withdrawals</small>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card bg-primary text-white">
                                    <div class="card-body text-center">
                                        <h5 class="mb-1">৳{{ number_format($runningBalance, 2) }}</h5>
                                        <small class="mb-0">Current Balance</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                        <!-- Calculation Table -->
                        <div class="card mb-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-calculator"></i> Transaction Calculation
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-striped">
                                        <thead class="thead-dark">
                                            <tr>
                                                <th rowspan="2" class="text-center align-middle">Date</th>
                                                <th rowspan="2" class="text-center align-middle">Transaction Type</th>
                                                <th rowspan="2" class="text-center align-middle">Description</th>
                                                <th colspan="2" class="text-center">Amount</th>
                                                <th rowspan="2" class="text-center align-middle">Running Balance</th>
                                                <th rowspan="2" class="text-center align-middle">Status</th>
                                            </tr>
                                            <tr>
                                                <th class="text-center text-success">Deposit</th>
                                                <th class="text-center text-danger">Withdraw</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            
                                            <!-- Opening Balance Row -->
                                            <tr class="table-info">
                                                <td colspan="3" class="text-center">
                                                    <strong>Opening Balance</strong>
                                                </td>
                                                <td class="text-center text-success">
                                                    <strong>৳{{ number_format(0, 2) }}</strong>
                                                </td>
                                                <td class="text-center text-danger">
                                                    <strong>৳{{ number_format(0, 2) }}</strong>
                                                </td>
                                                <td class="text-center">
                                                    <strong class="text-primary">৳{{ number_format($runningBalance, 2) }}</strong>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge badge-info">Opening</span>
                                                </td>
                                            </tr>
                                            
                                            @foreach($allTransactions as $transaction)
                                                <tr>
                                                    <td class="text-center">
                                                        {{ $transaction->transaction_date->format('M d, Y') }}
                                                    </td>
                                                    <td class="text-center">
                                                        <span class="badge badge-{{ $transaction->isDeposit() ? 'success' : 'warning' }}">
                                                            {{ ucfirst($transaction->transaction_type) }}
                                                        </span>
                                                    </td>
                                                    <td>
                                                        @if($transaction->salesInvoice)
                                                            <div class="small">
                                                                <strong class="text-primary">{{ $transaction->salesInvoice->invoice_no }}</strong>
                                                                <br><span class="text-muted">{{ $transaction->salesInvoice->customer_name ?? ($transaction->salesInvoice->customer ? $transaction->salesInvoice->customer->name : 'N/A') }}</span>
                                                            </div>
                                                        @else
                                                            {{ $transaction->description ?? 'N/A' }}
                                                        @endif
                                                    </td>
                                                    <td class="text-center text-success">
                                                        <strong>৳{{ number_format($transaction->deposit_balance, 2) }}</strong>
                                                    </td>
                                                    <td class="text-center text-danger">
                                                        <strong>৳{{ number_format($transaction->withdraw_balance, 2) }}</strong>
                                                    </td>
                                                    <td class="text-center">
                                                        <strong class="text-primary">৳{{ number_format($runningBalances[$transaction->id] ?? 0, 2) }}</strong>
                                                    </td>
                                                    <td class="text-center">
                                                        <span class="badge {{ $transaction->status_badge_class }}">
                                                            {{ ucfirst($transaction->status) }}
                                                        </span>
                                                    </td>
                                                </tr>
                                            @endforeach
                                            
                                            <!-- Summary Row -->
                                            <tr class="table-dark">
                                                <td colspan="3" class="text-center">
                                                    <strong>TOTAL</strong>
                                                </td>
                                                <td class="text-center text-success">
                                                    <strong>৳{{ number_format($totalDeposits, 2) }}</strong>
                                                </td>
                                                <td class="text-center text-danger">
                                                    <strong>৳{{ number_format($totalWithdrawals, 2) }}</strong>
                                                </td>
                                                <td class="text-center">
                                                    <strong class="text-primary">৳{{ number_format($runningBalance, 2) }}</strong>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge badge-dark">Final</span>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>

                        <div class="d-flex justify-content-center">
                            {{ $transactions->links() }}
                        </div>
                    @else
                        <div class="text-center py-5">
                            <i class="fas fa-exchange-alt fa-3x text-muted mb-3"></i>
                            <h4 class="text-muted">No Transactions Found</h4>
                            <p class="text-muted">No transactions match your current filters.</p>
                            <a href="{{ route('bank-information.create-transaction', $bankAccountInfo) }}" class="btn btn-success">
                                <i class="fas fa-plus"></i> Add Transaction
                            </a>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection