@extends('layouts.inspinia')

@section('title', 'Expense Register')

@section('content_header', 'Expense Register')

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item active"><strong>Expense Register</strong></li>
@endsection

@section('content')

<div class="alert alert-secondary border-left border-secondary py-2 mb-3">
    <i class="fas fa-info-circle mr-1"></i>
    <strong>Read-only report.</strong>
    Shows posted expenses only.
</div>

{{-- Filter Form --}}
<div class="card card-outline card-secondary">
    <div class="card-header"><h5 class="card-title mb-0"><i class="fas fa-filter mr-1"></i>Filters</h5></div>
    <div class="card-body py-2">
        <form method="GET" action="{{ route('accounting-reports.expense-register') }}">
            <div class="row">
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">From Date</label>
                        <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $from }}">
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">To Date</label>
                        <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $to }}">
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Category</label>
                        <select name="category_id" class="form-control form-control-sm">
                            <option value="">All Categories</option>
                            @foreach($categories as $cat)
                                <option value="{{ $cat->id }}" {{ request('category_id') == $cat->id ? 'selected' : '' }}>{{ $cat->name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Payment Method</label>
                        <select name="payment_method" class="form-control form-control-sm">
                            <option value="">All Methods</option>
                            @foreach($paymentMethods as $pm)
                                <option value="{{ $pm }}" {{ request('payment_method') === $pm ? 'selected' : '' }}>{{ ucfirst(str_replace('_', ' ', $pm)) }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Search</label>
                        <input type="text" name="search" class="form-control form-control-sm"
                               placeholder="Expense # / payee / description" value="{{ request('search') }}">
                    </div>
                </div>
            </div>
            <button type="submit" class="btn btn-sm btn-secondary"><i class="fas fa-search mr-1"></i>Apply</button>
            <a href="{{ route('accounting-reports.expense-register') }}" class="btn btn-sm btn-outline-secondary ml-1"><i class="fas fa-times mr-1"></i>Reset</a>
        </form>
    </div>
</div>

{{-- Summary Cards --}}
<div class="row">
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box bg-secondary">
            <div class="inner"><h4>{{ number_format($totalAmount, 2) }}</h4><p>Total Expenses</p></div>
            <div class="icon"><i class="fas fa-receipt"></i></div>
        </div>
    </div>
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box bg-warning">
            <div class="inner"><h4>{{ number_format($totalTax, 2) }}</h4><p>Total Tax</p></div>
            <div class="icon"><i class="fas fa-percentage"></i></div>
        </div>
    </div>
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box bg-info">
            <div class="inner"><h4>{{ $expenseCount }}</h4><p>Expense Count</p></div>
            <div class="icon"><i class="fas fa-hashtag"></i></div>
        </div>
    </div>
</div>

<div class="row">
    {{-- By Category --}}
    @if($byCategory->isNotEmpty())
    <div class="col-md-6 mb-3">
        <div class="card card-outline card-secondary">
            <div class="card-header py-2"><h6 class="card-title mb-0">By Category</h6></div>
            <div class="card-body p-0">
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light">
                        <tr><th>Category</th><th class="text-right">Total</th><th class="text-right">Count</th></tr>
                    </thead>
                    <tbody>
                        @foreach($byCategory as $row)
                        <tr>
                            <td>{{ $row->category_name }}</td>
                            <td class="text-right">{{ number_format($row->total, 2) }}</td>
                            <td class="text-right">{{ $row->cnt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif

    {{-- By Method --}}
    @if($byMethod->isNotEmpty())
    <div class="col-md-6 mb-3">
        <div class="card card-outline card-warning">
            <div class="card-header py-2"><h6 class="card-title mb-0">By Payment Method</h6></div>
            <div class="card-body p-0">
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light">
                        <tr><th>Method</th><th class="text-right">Total</th><th class="text-right">Count</th></tr>
                    </thead>
                    <tbody>
                        @foreach($byMethod as $row)
                        <tr>
                            <td>{{ ucfirst(str_replace('_', ' ', $row->payment_method ?? 'N/A')) }}</td>
                            <td class="text-right">{{ number_format($row->total, 2) }}</td>
                            <td class="text-right">{{ $row->cnt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
</div>

{{-- Expenses Table --}}
<div class="card">
    <div class="card-header py-2">
        <h5 class="card-title mb-0">
            Expense List — {{ $from }} to {{ $to }}
            <span class="badge badge-info ml-2">{{ $expenses->total() }} records</span>
        </h5>
    </div>
    <div class="card-body p-0">
        @if($expenses->isEmpty())
            <div class="p-4 text-center text-muted"><i class="fas fa-inbox fa-2x mb-2 d-block"></i>No expenses found for the selected filters.</div>
        @else
        <div class="table-responsive">
            <table class="table table-sm table-bordered table-hover mb-0">
                <thead class="thead-light">
                    <tr>
                        <th>Expense #</th>
                        <th>Date</th>
                        <th>Category</th>
                        <th>Payee</th>
                        <th>Description</th>
                        <th>Method</th>
                        <th class="text-right">Subtotal</th>
                        <th class="text-right">Tax</th>
                        <th class="text-right">Total</th>
                        <th>Posted By</th>
                        <th>Posted At</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($expenses as $e)
                    <tr>
                        <td>{{ $e->expense_number }}</td>
                        <td>{{ $e->expense_date?->format('d/m/Y') }}</td>
                        <td>{{ $e->category?->name ?? '—' }}</td>
                        <td>{{ $e->payee_name ?? '—' }}</td>
                        <td>{{ \Illuminate\Support\Str::limit($e->description, 40) }}</td>
                        <td>{{ ucfirst(str_replace('_', ' ', $e->payment_method ?? 'N/A')) }}</td>
                        <td class="text-right">{{ number_format($e->subtotal, 2) }}</td>
                        <td class="text-right">{{ number_format($e->tax_amount, 2) }}</td>
                        <td class="text-right font-weight-bold">{{ number_format($e->total_amount, 2) }}</td>
                        <td>{{ $e->postedBy?->name ?? '—' }}</td>
                        <td>{{ $e->posted_at?->format('d/m/Y H:i') ?? '—' }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="thead-light font-weight-bold">
                    <tr>
                        <td colspan="6" class="text-right">Page Totals:</td>
                        <td class="text-right">{{ number_format($expenses->sum('subtotal'), 2) }}</td>
                        <td class="text-right">{{ number_format($expenses->sum('tax_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($expenses->sum('total_amount'), 2) }}</td>
                        <td colspan="2"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="p-2">{{ $expenses->links() }}</div>
        @endif
    </div>
</div>

@endsection