@extends('layouts.inspinia')

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

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

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item active"><strong>Sales 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 tax invoices by default. Multi-currency invoices are converted to base (TZS) using each invoice's exchange-rate snapshot.
</div>

{{-- Filter Form --}}
<div class="card card-outline card-primary">
    <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.sales-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">Status</label>
                        <select name="status" class="form-control form-control-sm">
                            <option value="posted" {{ $statusFilter === 'posted' ? 'selected' : '' }}>Posted Only</option>
                            <option value="all" {{ $statusFilter === 'all' ? 'selected' : '' }}>All Statuses</option>
                            <option value="approved" {{ $statusFilter === 'approved' ? 'selected' : '' }}>Approved</option>
                            <option value="cancelled" {{ $statusFilter === 'cancelled' ? 'selected' : '' }}>Cancelled</option>
                        </select>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Customer</label>
                        <select name="customer_id" class="form-control form-control-sm">
                            <option value="">All Customers</option>
                            @foreach($customers as $c)
                                <option value="{{ $c->id }}" {{ request('customer_id') == $c->id ? 'selected' : '' }}>{{ $c->name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Currency</label>
                        <select name="currency_code" class="form-control form-control-sm">
                            <option value="">All Currencies</option>
                            @foreach($currencyCodes as $cc)
                                <option value="{{ $cc }}" {{ request('currency_code') == $cc ? 'selected' : '' }}>{{ $cc }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-2">
                    <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="Invoice # or customer" value="{{ request('search') }}">
                    </div>
                </div>
            </div>
            <button type="submit" class="btn btn-sm btn-primary"><i class="fas fa-search mr-1"></i>Apply</button>
            <a href="{{ route('accounting-reports.sales-register') }}" class="btn btn-sm btn-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-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-success">
            <div class="inner"><h4>{{ number_format($baseTotal, 2) }}</h4><p>Base Total (TZS)</p></div>
            <div class="icon"><i class="fas fa-file-invoice"></i></div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-info">
            <div class="inner"><h4>{{ number_format($paidTotal, 2) }}</h4><p>Amount Paid</p></div>
            <div class="icon"><i class="fas fa-check-circle"></i></div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-danger">
            <div class="inner"><h4>{{ number_format($balTotal, 2) }}</h4><p>Balance Due</p></div>
            <div class="icon"><i class="fas fa-exclamation-circle"></i></div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-warning">
            <div class="inner"><h4>{{ number_format($taxTotal, 2) }}</h4><p>Tax Amount</p></div>
            <div class="icon"><i class="fas fa-percentage"></i></div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-secondary">
            <div class="inner"><h4>{{ number_format($cnTotal, 2) }}</h4><p>Credit Notes</p></div>
            <div class="icon"><i class="fas fa-undo"></i></div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4 col-6 mb-3">
        <div class="small-box bg-primary">
            <div class="inner"><h4>{{ $invoiceCount }}</h4><p>Invoice Count</p></div>
            <div class="icon"><i class="fas fa-hashtag"></i></div>
        </div>
    </div>
</div>

{{-- By Currency --}}
@if($byCurrency->isNotEmpty())
<div class="card card-outline card-info mb-3">
    <div class="card-header py-2"><h6 class="card-title mb-0">Totals by Currency (Document Currency)</h6></div>
    <div class="card-body p-0">
        <table class="table table-sm table-bordered mb-0">
            <thead class="thead-light">
                <tr><th>Currency</th><th class="text-right">Document Total</th><th class="text-right">Invoices</th></tr>
            </thead>
            <tbody>
                @foreach($byCurrency as $row)
                <tr>
                    <td>{{ $row->currency }}</td>
                    <td class="text-right">{{ number_format($row->total, 2) }}</td>
                    <td class="text-right">{{ $row->cnt }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif

{{-- Invoices Table --}}
<div class="card">
    <div class="card-header py-2">
        <h5 class="card-title mb-0">
            Invoice List — {{ $from }} to {{ $to }}
            <span class="badge badge-info ml-2">{{ $invoices->total() }} records</span>
        </h5>
    </div>
    <div class="card-body p-0">
        @if($invoices->isEmpty())
            <div class="p-4 text-center text-muted"><i class="fas fa-inbox fa-2x mb-2 d-block"></i>No invoices 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>Invoice #</th>
                        <th>Date</th>
                        <th>Customer</th>
                        <th>Currency</th>
                        <th class="text-right">Rate</th>
                        <th class="text-right">Doc Total</th>
                        <th class="text-right">Tax</th>
                        <th class="text-right">Discount</th>
                        <th class="text-right">Base Total (TZS)</th>
                        <th class="text-right">Paid</th>
                        <th class="text-right">CN Amt</th>
                        <th class="text-right">Balance</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($invoices as $inv)
                    <tr>
                        <td><a href="{{ route('tax-invoices.show', $inv->id) }}">{{ $inv->tax_invoice_number }}</a></td>
                        <td>{{ $inv->invoice_date?->format('d/m/Y') }}</td>
                        <td>{{ $inv->customer_name ?? $inv->customer?->name }}</td>
                        <td>{{ $inv->currency_code ?? 'TZS' }}</td>
                        <td class="text-right">{{ number_format((float)$inv->exchange_rate, 4) }}</td>
                        <td class="text-right">{{ number_format($inv->total_amount, 2) }}</td>
                        <td class="text-right">{{ number_format($inv->tax_amount, 2) }}</td>
                        <td class="text-right">{{ number_format($inv->discount_amount, 2) }}</td>
                        <td class="text-right font-weight-bold">{{ number_format($inv->baseTotal(), 2) }}</td>
                        <td class="text-right text-success">{{ number_format($inv->amount_paid, 2) }}</td>
                        <td class="text-right text-warning">{{ number_format($inv->credit_note_amount, 2) }}</td>
                        <td class="text-right {{ $inv->balance_due > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($inv->balance_due, 2) }}</td>
                        <td>
                            <span class="badge badge-{{ $inv->status === 'posted' ? 'success' : ($inv->status === 'cancelled' ? 'danger' : 'secondary') }}">
                                {{ ucfirst($inv->status) }}
                            </span>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="thead-light font-weight-bold">
                    <tr>
                        <td colspan="5" class="text-right">Page Totals:</td>
                        <td class="text-right">{{ number_format($invoices->sum('total_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum('tax_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum('discount_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum(fn($i) => $i->baseTotal()), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum('amount_paid'), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum('credit_note_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($invoices->sum('balance_due'), 2) }}</td>
                        <td></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="p-2">{{ $invoices->links() }}</div>
        @endif
    </div>
</div>

@endsection