@extends('admin.layouts.app')

@section('title', 'Customer Wise Sales Report')
@section('page_title', 'Customer Wise Sales Report')

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Customer Wise Sales Report</h5>
    </div>
    <div class="card-body">
        <form action="{{ route('customer-wise-sales') }}" method="GET" class="mb-4">
            <div class="row">
                <div class="col-md-3">
                    <label class="form-label">From Date</label>
                    <input type="date" name="from_date" class="form-control" value="{{ $from_date }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">To Date</label>
                    <input type="date" name="to_date" class="form-control" value="{{ $to_date }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Customer</label>
                    <select name="customer_id" class="form-select">
                        <option value="">All Customers</option>
                        @foreach(App\Models\Customer::where('status', 1)->get() as $customer)
                            <option value="{{ $customer->id }}" {{ request('customer_id') == $customer->id ? 'selected' : '' }}>{{ $customer->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Branch</label>
                    <select name="branch_id" class="form-select">
                        <option value="">All Branches</option>
                        @foreach(App\Models\CustomerBranch::where('status', 1)->get() as $branch)
                            <option value="{{ $branch->id }}" {{ request('branch_id') == $branch->id ? 'selected' : '' }}>{{ $branch->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Filter</button>
                </div>
            </div>
        </form>



        <div class="table-responsive">
            <table class="table table-bordered table-striped" style="font-size: 13px;">
                <thead class="table-dark">
                    <tr>
                        <th>Sl No</th>
                        <th>Date</th>
                        <th>Shipment Number</th>
                        <th>Invoice No</th>
                        <th>Customer Name</th>
                        <th>Branch</th>
                        <th class="text-end">Amount</th>
                    </tr>
                </thead>
                <tbody>
                    @php $sl = 1; @endphp
                    @forelse($sales as $sale)
                        <tr>
                            <td>{{ $sl++ }}</td>
                            <td>{{ date('d-m-Y', strtotime($sale->date)) }}</td>
                            <td>{{ $sale->items->pluck('shipment_number')->filter()->unique()->implode(', ') ?: '-' }}</td>
                            <td>{{ $sale->invoice_no }}</td>
                            <td>{{ $sale->customer->name ?? 'N/A' }}</td>
                            <td>{{ $sale->branch->name ?? '-' }}</td>
                            <td class="text-end">{{ number_format($sale->total, 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center">No sales found for selected date range</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <th colspan="6" class="text-end">Total:</th>
                        <th class="text-end">{{ number_format($totalAmount, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection