@extends('layouts.app')
@section('title', 'Financial Transactions')
@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h3 mb-0 text-gray-800">Payment Records & Transactions</h1>
    </div>

    <!-- Filter Form -->
    <div class="card mb-4 shadow-sm">
        <div class="card-body">
            <form method="GET" action="{{ route('accounting.payments') }}" class="row g-3 align-items-end">
                <div class="col-md-2">
                    <label class="form-label">Project</label>
                    <select name="project_id" class="form-select">
                        <option value="">All Projects</option>
                        @foreach($projects as $id => $name)
                            <option value="{{ $id }}" {{ request('project_id') == $id ? 'selected' : '' }}>{{ $name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Type</label>
                    <select name="source_type" class="form-select">
                        <option value="">All Types</option>
                        <option value="App\Models\AccountIncome" {{ request('source_type') == 'App\Models\AccountIncome' ? 'selected' : '' }}>Income Entry</option>
                        <option value="App\Models\AccountExpense" {{ request('source_type') == 'App\Models\AccountExpense' ? 'selected' : '' }}>Expense Entry</option>
                        <option value="App\Models\Payment" {{ request('source_type') == 'App\Models\Payment' ? 'selected' : '' }}>Customer Collection</option>
                        <option value="App\Models\PurchasePayment" {{ request('source_type') == 'App\Models\PurchasePayment' ? 'selected' : '' }}>Supplier Payment</option>
                        <option value="App\Models\ContractorPayment" {{ request('source_type') == 'App\Models\ContractorPayment' ? 'selected' : '' }}>Contractor Payment</option>
                        <option value="App\Models\CommissionPayment" {{ request('source_type') == 'App\Models\CommissionPayment' ? 'selected' : '' }}>Commission Payment</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Method</label>
                    <select name="payment_method" class="form-select">
                        <option value="">All Methods</option>
                        <option value="Cash" {{ request('payment_method') == 'Cash' ? 'selected' : '' }}>Cash</option>
                        <option value="Bank" {{ request('payment_method') == 'Bank' ? 'selected' : '' }}>Bank</option>
                        <option value="Mobile Banking" {{ request('payment_method') == 'Mobile Banking' ? 'selected' : '' }}>Mobile Banking</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Date From</label>
                    <input type="date" name="date_from" class="form-control" value="{{ request('date_from') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Date To</label>
                    <input type="date" name="date_to" class="form-control" value="{{ request('date_to') }}">
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary w-100">Filter</button>
                </div>
            </form>
        </div>
    </div>

    <!-- Total Payments -->
    <div class="row mb-4">
        <div class="col-md-4">
            <div class="alert alert-success fw-bold mb-0">
                Total Money In: Tk {{ number_format($totalIn, 2) }}
            </div>
        </div>
        <div class="col-md-4">
            <div class="alert alert-danger fw-bold mb-0">
                Total Money Out: Tk {{ number_format($totalOut, 2) }}
            </div>
        </div>
        <div class="col-md-4">
            <div class="alert alert-info fw-bold mb-0">
                Net Balance: Tk {{ number_format($totalIn - $totalOut, 2) }}
            </div>
        </div>
    </div>

    <!-- Data Table -->
    <div class="card shadow-sm">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Payment Type</th>
                            <th>Project</th>
                            <th>Party Name</th>
                            <th>Voucher No</th>
                            <th>Method</th>
                            <th class="text-end text-success">Money In</th>
                            <th class="text-end text-danger">Money Out</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($records as $rec)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($rec->transaction_date)->format('d M, Y') }}</td>
                            <td>
                                @php
                                    $typeBadge = 'bg-secondary';
                                    $typeName = 'Unknown';
                                    if(str_contains($rec->source_type, 'AccountIncome')) { $typeName = 'Income Entry'; $typeBadge = 'bg-success'; }
                                    elseif(str_contains($rec->source_type, 'AccountExpense')) { $typeName = 'Expense Entry'; $typeBadge = 'bg-danger'; }
                                    elseif(str_contains($rec->source_type, 'PurchasePayment')) { $typeName = 'Supplier Payment'; $typeBadge = 'bg-warning text-dark'; }
                                    elseif(str_contains($rec->source_type, 'ContractorPayment')) { $typeName = 'Contractor Payment'; $typeBadge = 'bg-info text-dark'; }
                                    elseif(str_contains($rec->source_type, 'CommissionPayment')) { $typeName = 'Commission Payment'; $typeBadge = 'bg-dark'; }
                                    elseif(str_contains($rec->source_type, 'Payment')) { $typeName = 'Customer Collection'; $typeBadge = 'bg-primary'; }
                                @endphp
                                <span class="badge {{ $typeBadge }}">{{ $typeName }}</span>
                            </td>
                            <td>{{ $rec->project->project_name ?? 'General / None' }}</td>
                            <td>{{ $rec->party_name ?? '-' }}</td>
                            <td>{{ $rec->voucher_no ?? '-' }}</td>
                            <td>{{ $rec->payment_method }}</td>
                            <td class="fw-bold text-end text-success">{{ $rec->debit_amount > 0 ? 'Tk ' . number_format($rec->debit_amount, 2) : '-' }}</td>
                            <td class="fw-bold text-end text-danger">{{ $rec->credit_amount > 0 ? 'Tk ' . number_format($rec->credit_amount, 2) : '-' }}</td>
                        </tr>
                        @empty
                        <tr><td colspan="8" class="text-center py-3">No payment records found.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        <div class="card-footer">
            {{ $records->links('pagination::bootstrap-5') }}
        </div>
    </div>
</div>
@endsection