@extends('layouts.layout-horizontal')
@section('title', 'Sales Report - Customer Wise')

@section('content')
<div class="card">
    <form method="GET" class="report-filter">
        <div class="filter-group">
            <label>From</label>
            <input type="date" name="start_date" value="{{ $startDate }}">
        </div>
        <div class="filter-group">
            <label>To</label>
            <input type="date" name="end_date" value="{{ $endDate }}">
        </div>
        <button type="submit" class="btn btn-primary filter-btn">
            <i class="ph-duotone ph-funnel"></i> Filter
        </button>
    </form>
    <div class="card-body">
        <div data-st data-st-export="excel,print">
            <div class="table-responsive">
            <table class="table table-hover table-sm align-middle">
                <thead class="table-light">
                    <tr>
                        <th>Customer</th>
                        <th>Invoice Date</th>
                        <th>Bill No</th>
                        <th>Product Name</th>
                        <th class="text-end">Quantity</th>
                        <th class="text-end">Rate</th>
                        <th class="text-end">Tax</th>
                        <th class="text-end">Total</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($items as $item)
                    <tr>
                        <td>{{ $item->customer_name }}</td>
                        <td>{{ \Carbon\Carbon::parse($item->invoice_date)->format('d-M-Y') }}</td>
                        <td>{{ $item->bill_no }}</td>
                        <td>{{ $item->product_name }}</td>
                        <td class="text-end">{{ indian_number($item->qty, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->rate, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->tax, 2) }}</td>
                        <td class="text-end">{{ indian_number($item->total, 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light fw-bold">
                    <tr>
                        <td colspan="6" class="text-end">Totals:</td>
                        <td class="text-end">{{ indian_number($items->sum('tax'), 2) }}</td>
                        <td class="text-end">{{ indian_number($items->sum('total'), 2) }}</td>
                    </tr>
                </tfoot>
            </table>
            </div>
        </div>
    </div>
</div>
@endsection