@extends('layouts.app')
@section('title', 'Account Reports')
@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">Account Reports & Analytics</h1>
        <div>
            <a href="{{ request()->fullUrlWithQuery(['export' => 'pdf']) }}" class="btn btn-danger shadow-sm">
                <i class="bi bi-file-pdf"></i> PDF
            </a>
            <a href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}" class="btn btn-success shadow-sm">
                <i class="bi bi-file-excel"></i> Excel
            </a>
            <a href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}" class="btn btn-info text-white shadow-sm">
                <i class="bi bi-filetype-csv"></i> CSV
            </a>
            <button class="btn btn-secondary shadow-sm" onclick="window.print()">
                <i class="bi bi-printer"></i> Print
            </button>
        </div>
    </div>

    <!-- Filter Form -->
    <div class="card shadow-sm mb-4 d-print-none">
        <div class="card-body">
            <form method="GET" action="{{ route('accounting.reports') }}" 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 form-select-sm">
                        <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">Date From</label>
                    <input type="date" name="date_from" class="form-control form-control-sm" 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 form-control-sm" value="{{ request('date_to') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Method</label>
                    <select name="payment_method" class="form-select form-select-sm">
                        <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</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Type</label>
                    <select name="source_type" class="form-select form-select-sm">
                        <option value="">All Types</option>
                        <option value="App\Models\AccountIncome" {{ request('source_type') == 'App\Models\AccountIncome' ? 'selected' : '' }}>Income</option>
                        <option value="App\Models\Payment" {{ request('source_type') == 'App\Models\Payment' ? 'selected' : '' }}>Collection</option>
                        <option value="App\Models\AccountExpense" {{ request('source_type') == 'App\Models\AccountExpense' ? 'selected' : '' }}>Expense</option>
                        <option value="App\Models\PurchasePayment" {{ request('source_type') == 'App\Models\PurchasePayment' ? 'selected' : '' }}>Supplier Pmt</option>
                        <option value="App\Models\ContractorPayment" {{ request('source_type') == 'App\Models\ContractorPayment' ? 'selected' : '' }}>Contractor Pmt</option>
                        <option value="App\Models\CommissionPayment" {{ request('source_type') == 'App\Models\CommissionPayment' ? 'selected' : '' }}>Commission Pmt</option>
                    </select>
                </div>
                <div class="col-md-1">
                    <label class="form-label">Group</label>
                    <select name="group_by" class="form-select form-select-sm">
                        <option value="daily" {{ request('group_by') == 'daily' ? 'selected' : '' }}>Daily</option>
                        <option value="monthly" {{ request('group_by') == 'monthly' ? 'selected' : '' }}>Monthly</option>
                    </select>
                </div>
                <div class="col-md-1">
                    <button type="submit" class="btn btn-primary btn-sm w-100">Filter</button>
                </div>
            </form>
        </div>
    </div>

    <!-- High Level Summary -->
    <div class="row mb-4">
        <!-- Income/Money In -->
        <div class="col-md-4">
            <div class="card border-left-success shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Total Money In</div>
                    <div class="h5 mb-2 font-weight-bold text-gray-800">Tk {{ number_format($sumMoneyIn, 2) }}</div>
                    <small class="text-muted">Customer Income / Collections</small>
                </div>
            </div>
        </div>
        <!-- Expenses/Money Out -->
        <div class="col-md-4">
            <div class="card border-left-danger shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">Total Money Out</div>
                    <div class="h5 mb-2 font-weight-bold text-gray-800">Tk {{ number_format($sumMoneyOut, 2) }}</div>
                    
                    <div class="row mt-2 text-xs">
                        <div class="col-6">Office Expense:</div>
                        <div class="col-6 text-end">Tk {{ number_format($sumExpense, 2) }}</div>
                        <div class="col-6">Supplier Pmt:</div>
                        <div class="col-6 text-end">Tk {{ number_format($sumSupplier, 2) }}</div>
                        <div class="col-6">Contractor Pmt:</div>
                        <div class="col-6 text-end">Tk {{ number_format($sumContractor, 2) }}</div>
                        <div class="col-6">Commission Pmt:</div>
                        <div class="col-6 text-end">Tk {{ number_format($sumCommission, 2) }}</div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Net Balance -->
        <div class="col-md-4">
            <div class="card border-left-primary shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Net Balance / Profit</div>
                    <div class="h5 mb-0 font-weight-bold {{ $netBalance >= 0 ? 'text-success' : 'text-danger' }}">
                        Tk {{ number_format($netBalance, 2) }}
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Due vs Paid Summary -->
    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card shadow-sm">
                <div class="card-header bg-white">
                    <h6 class="m-0 font-weight-bold">Due vs Paid Summary (Lifetime)</h6>
                </div>
                <div class="card-body p-0">
                    <table class="table table-hover mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Category</th>
                                <th class="text-end">Total Payable</th>
                                <th class="text-end text-success">Total Paid</th>
                                <th class="text-end text-danger">Total Due</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td>Suppliers</td>
                                <td class="text-end fw-bold">Tk {{ number_format($dueSummary->supplier_payable, 2) }}</td>
                                <td class="text-end text-success">Tk {{ number_format($dueSummary->supplier_paid, 2) }}</td>
                                <td class="text-end text-danger">Tk {{ number_format($dueSummary->supplier_due, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Contractors</td>
                                <td class="text-end fw-bold">Tk {{ number_format($dueSummary->contractor_payable, 2) }}</td>
                                <td class="text-end text-success">Tk {{ number_format($dueSummary->contractor_paid, 2) }}</td>
                                <td class="text-end text-danger">Tk {{ number_format($dueSummary->contractor_due, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Commissions</td>
                                <td class="text-end fw-bold">Tk {{ number_format($dueSummary->commission_payable, 2) }}</td>
                                <td class="text-end text-success">Tk {{ number_format($dueSummary->commission_paid, 2) }}</td>
                                <td class="text-end text-danger">Tk {{ number_format($dueSummary->commission_due, 2) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <!-- Project Wise and Methods -->
    <div class="row mb-4">
        <div class="col-md-8">
            <div class="card shadow-sm h-100">
                <div class="card-header bg-white">
                    <h6 class="m-0 font-weight-bold">Project-wise Profit / Loss</h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Project</th>
                                    <th class="text-end text-success">Income</th>
                                    <th class="text-end">Office Exp.</th>
                                    <th class="text-end">Supplier</th>
                                    <th class="text-end">Contractor</th>
                                    <th class="text-end">Commission</th>
                                    <th class="text-end text-danger">Total Outflow</th>
                                    <th class="text-end">Net Profit</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($projectWise as $pw)
                                <tr>
                                    <td>{{ $pw->name }}</td>
                                    <td class="text-end text-success">{{ number_format($pw->income, 2) }}</td>
                                    <td class="text-end">{{ number_format($pw->expense, 2) }}</td>
                                    <td class="text-end">{{ number_format($pw->supplier, 2) }}</td>
                                    <td class="text-end">{{ number_format($pw->contractor, 2) }}</td>
                                    <td class="text-end">{{ number_format($pw->commission, 2) }}</td>
                                    <td class="text-end text-danger">{{ number_format($pw->outflow, 2) }}</td>
                                    <td class="text-end fw-bold {{ $pw->profit >= 0 ? 'text-success' : 'text-danger' }}">Tk {{ number_format($pw->profit, 2) }}</td>
                                </tr>
                                @empty
                                <tr><td colspan="8" class="text-center py-3">No data available.</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-md-4">
            <div class="card shadow-sm h-100">
                <div class="card-header bg-white">
                    <h6 class="m-0 font-weight-bold">Payment Methods Summary</h6>
                </div>
                <div class="card-body p-0">
                    <table class="table table-hover mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Method</th>
                                <th class="text-end">In</th>
                                <th class="text-end">Out</th>
                                <th class="text-end">Balance</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($methodSummary as $ms)
                            <tr>
                                <td>{{ $ms->method }}</td>
                                <td class="text-end text-success">{{ number_format($ms->income, 2) }}</td>
                                <td class="text-end text-danger">{{ number_format($ms->expense, 2) }}</td>
                                <td class="text-end fw-bold {{ $ms->balance >= 0 ? 'text-primary' : 'text-danger' }}">{{ number_format($ms->balance, 2) }}</td>
                            </tr>
                            @empty
                            <tr><td colspan="4" class="text-center py-3">No data available.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <!-- Date Wise Summary -->
    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card shadow-sm">
                <div class="card-header bg-white">
                    <h6 class="m-0 font-weight-bold">{{ ucfirst($groupBy) }} Summary</h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Period ({{ ucfirst($groupBy) }})</th>
                                    <th class="text-end text-success">Total Money In</th>
                                    <th class="text-end text-danger">Total Money Out</th>
                                    <th class="text-end">Net Balance</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($dateSummary as $ds)
                                <tr>
                                    <td>{{ $ds->period }}</td>
                                    <td class="text-end text-success">Tk {{ number_format($ds->income, 2) }}</td>
                                    <td class="text-end text-danger">Tk {{ number_format($ds->expense, 2) }}</td>
                                    <td class="text-end fw-bold {{ $ds->balance >= 0 ? 'text-success' : 'text-danger' }}">Tk {{ number_format($ds->balance, 2) }}</td>
                                </tr>
                                @empty
                                <tr><td colspan="4" class="text-center py-3">No data available.</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Voucher Wise / Transactions Table -->
    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h6 class="m-0 font-weight-bold">Voucher-wise Transactions</h6>
                    <span class="badge bg-primary rounded-pill">Total: {{ $transactions->total() }}</span>
                </div>
                <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>Type</th>
                                    <th>Project</th>
                                    <th>Voucher No</th>
                                    <th>Party</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($transactions as $rec)
                                <tr>
                                    <td>{{ \Carbon\Carbon::parse($rec->transaction_date)->format('d M, Y') }}</td>
                                    <td>
                                        @php
                                            $typeName = 'Unknown';
                                            if(str_contains($rec->source_type, 'AccountIncome')) $typeName = 'Income Entry';
                                            elseif(str_contains($rec->source_type, 'AccountExpense')) $typeName = 'Office Expense';
                                            elseif(str_contains($rec->source_type, 'PurchasePayment')) $typeName = 'Supplier Pmt';
                                            elseif(str_contains($rec->source_type, 'ContractorPayment')) $typeName = 'Contractor Pmt';
                                            elseif(str_contains($rec->source_type, 'CommissionPayment')) $typeName = 'Commission Pmt';
                                            elseif(str_contains($rec->source_type, 'Payment')) $typeName = 'Customer Pmt';
                                        @endphp
                                        <span class="badge bg-secondary">{{ $typeName }}</span>
                                    </td>
                                    <td>{{ $rec->project->project_name ?? 'General' }}</td>
                                    <td>{{ $rec->voucher_no ?? '-' }}</td>
                                    <td>{{ $rec->party_name ?? '-' }}</td>
                                    <td>{{ $rec->payment_method }}</td>
                                    <td class="text-end fw-bold text-success">{{ $rec->debit_amount > 0 ? 'Tk ' . number_format($rec->debit_amount, 2) : '-' }}</td>
                                    <td class="text-end fw-bold 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 transactions found for these filters.</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="card-footer bg-white d-print-none">
                    {{ $transactions->links('pagination::bootstrap-5') }}
                </div>
            </div>
        </div>
    </div>

</div>

<!-- Print Styles -->
<style>
@media print {
    .d-print-none { display: none !important; }
    .card { border: none !important; box-shadow: none !important; }
    .table { width: 100% !important; margin-bottom: 1rem; color: #000; }
    .table-light th { background-color: #f8f9fa !important; }
    body { background-color: white; }
    @page { size: landscape; margin: 1cm; }
}
</style>
@endsection