@push('title')
    Sales Report
@endpush

<x-app-layout>
    <div class="card mb-4">
        <div class="card-header d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Sales Report</h5>
            <div class="dropdown">
                <button class="btn btn-secondary dropdown-toggle" type="button" id="exportDropdown" data-bs-toggle="dropdown" aria-expanded="false">
                    <i class="bx bx-export me-1"></i> Export
                </button>
                <ul class="dropdown-menu" aria-labelledby="exportDropdown">
                    <li><a class="dropdown-item" href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}"><i class="bx bx-file me-2"></i>Export as CSV</a></li>
                    <li><a class="dropdown-item" href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}"><i class="bx bx-spreadsheet me-2"></i>Export as Excel</a></li>
                </ul>
            </div>
        </div>
        <div class="card-body">
            <form action="{{ route('reports.sales') }}" method="GET" class="row g-3 mb-4">
                <div class="col-md-2">
                    <label class="form-label">Start Date</label>
                    <input type="date" name="start_date" class="form-control" value="{{ request('start_date') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">End Date</label>
                    <input type="date" name="end_date" class="form-control" value="{{ request('end_date') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Customer</label>
                    <select name="customer_id" class="form-select select2">
                        <option value="">All Customers</option>
                        @foreach($customers as $customer)
                            <option value="{{ $customer->id }}" {{ request('customer_id') == $customer->id && request('customer_id') != null ? 'selected' : '' }}>
                                {{ $customer->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Warehouse</label>
                    <select name="warehouse_id" class="form-select">
                        <option value="">All Warehouses</option>
                        @foreach($warehouses as $warehouse)
                            <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id && request('warehouse_id') != null ? 'selected' : '' }}>
                                {{ $warehouse->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Payment Status</label>
                    <select name="payment_status" class="form-select">
                        <option value="">All Statuses</option>
                        <option value="2" {{ request('payment_status') == '2' && request('payment_status') != null ? 'selected' : '' }}>Paid</option>
                        <option value="1" {{ request('payment_status') == '1' && request('payment_status') != null ? 'selected' : '' }}>Partial</option>
                        <option value="0" {{ request('payment_status') == '0' && request('payment_status') != null ? 'selected' : '' }}>Unpaid</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Sale Status</label>
                    <select name="sale_status" class="form-select">
                        <option value="">All Statuses</option>
                        <option value="2" {{ request('sale_status') == '2' ? 'selected' : '' }}>Completed</option>
                        <option value="4" {{ request('sale_status') == '4' ? 'selected' : '' }}>Returned</option>
                        <option value="3" {{ request('sale_status') == '3' ? 'selected' : '' }}>Partial Return</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Cashier</label>
                    <select name="user_id" class="form-select">
                        <option value="">All Cashiers</option>
                        @foreach($users as $user)
                            <option value="{{ $user->id }}" {{ request('user_id') == $user->id && request('user_id') != null ? 'selected' : '' }}>
                                {{ $user->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary w-100 me-2">Filter</button>
                    <a href="{{ route('reports.sales') }}" class="btn btn-label-secondary w-100">Reset</a>
                </div>
            </form>

            <div class="table-responsive text-nowrap">
                <table class="table table-striped table-borderless">
                <thead class="table-dark">
                        <tr>
                            <th>Date</th>
                            <th>Invoice No</th>
                            <th>Customer</th>
                            <th>Warehouse</th>
                            <th>Payment Status</th>
                            <th>Sale Status</th>
                            <th>Payment Type</th>
                            <th class="text-end">Total</th>
                            <th class="text-end">Paid</th>
                            <th class="text-end">Balance</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $totalAmount = 0;
                            $totalPaid = 0;
                            $totalDue = 0;
                        @endphp
                        @forelse($sales as $sale)
                            @php
                                $totalAmount += $sale->grand_total;
                                $totalPaid += $sale->paid_amount;
                                $totalDue += $sale->due_amount;
                            @endphp
                            <tr>
                                <td>{{ $sale->created_at->format('Y-m-d') }}</td>
                                <td>
                                    <span class="fw-medium">{{ $sale->invoice_no }}</span>
                                </td>
                                <td>{{ $sale->customer->name ?? 'Walk-in' }}</td>
                                <td>{{ $sale->warehouse->name ?? 'N/A' }}</td>
                                <td>
                                    @if($sale->payment_status == 2)
                                        <span class="badge bg-label-success">Paid</span>
                                    @elseif($sale->payment_status == 1)
                                        <span class="badge bg-label-warning">Partial</span>
                                    @else
                                        <span class="badge bg-label-danger">Unpaid</span>
                                    @endif
                                </td>
                                <td>
                                    @if($sale->sale_status == 2)
                                        <span class="badge bg-label-success">Completed</span>
                                    @elseif($sale->sale_status == 4)
                                        <span class="badge bg-label-danger">Returned</span>
                                    @elseif($sale->sale_status == 3)
                                        <span class="badge bg-label-warning">Partial Return</span>
                                    @else
                                        <span class="badge bg-label-secondary">Pending</span>
                                    @endif
                                </td>
                                <td>
                                    @if($sale->payment_type == \App\Models\Sale::CASH)
                                        <span><i class="bx bx-money me-1"></i> Cash</span>
                                    @else
                                        <span><i class="bx bx-credit-card me-1"></i> Credit</span>
                                    @endif
                                </td>
                                <td class="text-end">{{ number_format($sale->grand_total, 2) }}</td>
                                <td class="text-end">{{ number_format($sale->paid_amount, 2) }}</td>
                                <td class="text-end text-danger">{{ number_format($sale->due_amount, 2) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="10" class="text-center py-5 text-muted">No sales data found for the selected criteria.</td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if($sales->isNotEmpty())
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="7" class="text-end fw-bold">Page Total:</th>
                            <th class="text-end fw-bold">{{ number_format($totalAmount, 2) }}</th>
                            <th class="text-end fw-bold">{{ number_format($totalPaid, 2) }}</th>
                            <th class="text-end fw-bold text-danger">{{ number_format($totalDue, 2) }}</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
            
            <div class="mt-4">
                {{ $sales->withQueryString()->links() }}
            </div>
        </div>
    </div>
</x-app-layout>