@extends('layouts.master')

@section('page_title', 'Accounts Payable Report')

@section('content')
<div class="container-fluid">
    <!-- Filter Section -->
    <div class="card mb-4 no-print">
        <div class="card-header">
            <h5 class="mb-0">Accounts Payable Filters</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('reports.accounts-payable') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="as_of_date" class="form-label">As of Date</label>
                    <input type="date" class="form-control" id="as_of_date" name="as_of_date" 
                           value="{{ $asOfDate }}" required>
                </div>
                <div class="col-md-3">
                    <label for="vendor_id" class="form-label">Vendor</label>
                    <select class="form-select" id="vendor_id" name="vendor_id">
                        <option value="">All Vendors</option>
                        @foreach($vendors as $vendor)
                            <option value="{{ $vendor->id }}" {{ $vendorId == $vendor->id ? 'selected' : '' }}>
                                {{ $vendor->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="aging_days" class="form-label">Aging Period (Days)</label>
                    <select class="form-select" id="aging_days" name="aging_days">
                        <option value="30" {{ $agingDays == 30 ? 'selected' : '' }}>30 Days</option>
                        <option value="60" {{ $agingDays == 60 ? 'selected' : '' }}>60 Days</option>
                        <option value="90" {{ $agingDays == 90 ? 'selected' : '' }}>90 Days</option>
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end gap-2">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search"></i> Generate Report
                    </button>
                    <button type="button" class="btn btn-success" onclick="window.print()">
                        <i class="fas fa-print"></i> Print
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2>Accounts Payable Report</h2>
            <p class="text-muted mb-0">As of: {{ Carbon\Carbon::parse($asOfDate)->format('M d, Y') }}</p>
        </div>
        <div class="text-end">
            <p class="mb-0"><strong>Generated:</strong> {{ Carbon\Carbon::now()->format('M d, Y g:i A') }}</p>
            <p class="mb-0"><strong>Outstanding Vouchers:</strong> {{ $payables->count() }}</p>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card bg-danger text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ \App\Helpers\Mk::formatCurrency($payables->sum('outstanding_amount')) }}</h3>
                            <p class="mb-0">Total Payable</p>
                        </div>
                        <div>
                            <i class="fas fa-exclamation-triangle fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-success text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ $agingSummary['Current']['count'] ?? 0 }}</h3>
                            <p class="mb-0">Current (0-30 days)</p>
                        </div>
                        <div>
                            <i class="fas fa-check-circle fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-warning text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ ($agingSummary['31-60 Days']['count'] ?? 0) + ($agingSummary['61-90 Days']['count'] ?? 0) }}</h3>
                            <p class="mb-0">31-90 Days</p>
                        </div>
                        <div>
                            <i class="fas fa-clock fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-dark text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ $agingSummary['Over 90 Days']['count'] ?? 0 }}</h3>
                            <p class="mb-0">Over 90 Days</p>
                        </div>
                        <div>
                            <i class="fas fa-times-circle fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Aging Summary -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Aging Summary</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Aging Category</th>
                            <th class="text-center">Number of Vouchers</th>
                            <th class="text-end">Outstanding Amount</th>
                            <th class="text-end">Percentage</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $totalOutstanding = $payables->sum('outstanding_amount'); @endphp
                        @foreach(['Current', '31-60 Days', '61-90 Days', 'Over 90 Days'] as $category)
                        @php 
                            $count = $agingSummary[$category]['count'] ?? 0;
                            $amount = $agingSummary[$category]['total'] ?? 0;
                            $percentage = $totalOutstanding > 0 ? ($amount / $totalOutstanding) * 100 : 0;
                        @endphp
                        <tr class="{{ $category == 'Over 90 Days' ? 'table-danger' : ($category == 'Current' ? 'table-success' : 'table-warning') }}">
                            <td><strong>{{ $category }}</strong></td>
                            <td class="text-center">{{ $count }}</td>
                            <td class="text-end">${{ number_format($amount, 2) }}</td>
                            <td class="text-end">{{ number_format($percentage, 1) }}%</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="table-primary">
                            <th>Total</th>
                            <th class="text-center">{{ $payables->count() }}</th>
                            <th class="text-end">${{ number_format($totalOutstanding, 2) }}</th>
                            <th class="text-end">100.0%</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>

    <!-- Vendor Summary -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Vendor Summary</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Vendor</th>
                            <th class="text-center">Outstanding Vouchers</th>
                            <th class="text-end">Total Outstanding</th>
                            <th class="text-end">Average Age (Days)</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($payables->groupBy('vendor_name') as $vendorName => $vendorPayables)
                        @php
                            $totalAmount = $vendorPayables->sum('outstanding_amount');
                            $avgAge = round($vendorPayables->avg('days_outstanding'));
                        @endphp
                        <tr>
                            <td><strong>{{ $vendorName }}</strong></td>
                            <td class="text-center">{{ $vendorPayables->count() }}</td>
                            <td class="text-end">${{ number_format($totalAmount, 2) }}</td>
                            <td class="text-center">
                                <span class="badge bg-{{ $avgAge > 90 ? 'danger' : ($avgAge > 30 ? 'warning' : 'success') }}">
                                    {{ $avgAge }}
                                </span>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Detailed Payables -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">Outstanding Payables Detail</h5>
        </div>
        <div class="card-body">
            @if($payables->count() > 0)
                <div class="table-responsive">
                    <table class="table table-striped table-hover" id="payablesTable">
                        <thead>
                            <tr>
                                <th>Voucher #</th>
                                <th>Vendor</th>
                                <th>Description</th>
                                <th class="text-end">Total Amount</th>
                                <th class="text-end">Payments</th>
                                <th class="text-end">Outstanding</th>
                                <th class="text-center">Days</th>
                                <th>Aging</th>
                                <th>Voucher Date</th>
                                <th>Due Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($payables->sortBy('aging_category') as $payable)
                            <tr class="{{ $payable->aging_category == 'Over 90 Days' ? 'table-danger' : ($payable->aging_category == 'Current' ? '' : 'table-warning') }}">
                                <td><code>{{ $payable->voucher_number }}</code></td>
                                <td>{{ $payable->vendor_name }}</td>
                                <td>{{ str($payable->description)->limit(50) }}</td>
                                <td class="text-end">${{ number_format($payable->amount, 2) }}</td>
                                <td class="text-end text-success">${{ number_format($payable->payments_made, 2) }}</td>
                                <td class="text-end">
                                    <strong class="text-danger">${{ number_format($payable->outstanding_amount, 2) }}</strong>
                                </td>
                                <td class="text-center">
                                    <span class="badge bg-{{ $payable->days_outstanding > 90 ? 'danger' : ($payable->days_outstanding > 30 ? 'warning' : 'success') }}">
                                        {{ $payable->days_outstanding }}
                                    </span>
                                </td>
                                <td>
                                    <span class="badge bg-{{ $payable->aging_category == 'Over 90 Days' ? 'danger' : ($payable->aging_category == 'Current' ? 'success' : 'warning') }}">
                                        {{ $payable->aging_category }}
                                    </span>
                                </td>
                                <td>{{ Carbon\Carbon::parse($payable->voucher_date)->format('M d, Y') }}</td>
                                <td>{{ Carbon\Carbon::parse($payable->due_date)->format('M d, Y') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr class="table-primary">
                                <th colspan="5">Grand Total</th>
                                <th class="text-end">${{ number_format($payables->sum('outstanding_amount'), 2) }}</th>
                                <th colspan="4"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @else
                <div class="alert alert-success">
                    <i class="fas fa-check-circle"></i>
                    <strong>Great News!</strong><br>
                    No outstanding payables found. All vendor invoices have been paid!
                </div>
            @endif
        </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;
    }
}
</style>
@endsection