@extends('layouts.app')

@section('page-title', 'Product Sales This Month')

@section('content')
<div class="row">
    <div class="col-xl-12">
        <div class="card">
            <div class="card-header border-0 pb-0">
                <div class="d-flex align-items-center justify-content-between">
                    <div>
                        <h4 class="card-title mb-0">Product Sales This Month</h4>
                        <p class="text-muted mb-0">Products sold in {{ Carbon\Carbon::now()->format('F Y') }}</p>
                    </div>
                    <a href="{{ route('dashboard') }}" class="btn btn-secondary btn-sm">
                        <i class="fas fa-arrow-left"></i> Back to Dashboard
                    </a>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="display table table-borderless table-lg" id="salesTable">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Product</th>
                                <th>Quantity</th>
                                <th>Unit Price</th>
                                <th>Total Amount</th>
                                <th>Customer</th>
                                <th>Date</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($sales as $sale)
                            <tr>
                                <td>#{{ str_pad($sale->id, 6, '0', STR_PAD_LEFT) }}</td>
                                <td>{{ $sale->product->name ?? 'N/A' }}</td>
                                <td>{{ $sale->quantity }}</td>
                                <td>Rs {{ number_format($sale->unit_price, 2) }}</td>
                                <td class="text-primary font-w500">Rs {{ number_format($sale->total_amount, 2) }}</td>
                                <td>
                                    @if($sale->customer_name)
                                        {{ $sale->customer_name }}
                                        @if($sale->customer_phone)
                                            <br><small class="text-muted">{{ $sale->customer_phone }}</small>
                                        @endif
                                    @else
                                        <span class="text-muted">Walk-in</span>
                                    @endif
                                </td>
                                <td>{{ $sale->created_at->format('d/m/Y h:i A') }}</td>
                                <td>
                                    <a href="{{ route('product-sales.index') }}" class="btn btn-primary shadow btn-xs btn-square" title="View All Sales">
                                        <i class="fas fa-eye"></i>
                                    </a>
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="8" class="text-center">No product sales found this month.</td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script src="{{ asset('assets/vendor/datatables/js/jquery.dataTables.bundle.min.js') }}"></script>
<script>
    $(document).ready(function() {
        $('#salesTable').DataTable({
            responsive: true,
            order: [[0, 'desc']],
            pageLength: 25,
            searching: true,
            search: {
                caseInsensitive: true,
                smart: true
            },
            language: {
                search: "Search:",
                searchPlaceholder: "Search product sales..."
            },
            dom: '<"row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>rt<"row"<"col-sm-12 col-md-5"i><"col-sm-12 col-md-7"p>>'
        });
    });
</script>
@endpush