@extends('layouts.layout-horizontal')
@section('title', 'Field Report')

@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" data-st-filename="field-entries-{{ $startDate }}-to-{{ $endDate }}">
            <div class="table-responsive">
                <table class="table table-hover table-sm align-middle">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Dealer</th>
                            <th>Product</th>
                            <th>Exhibition</th>
                            <th>Location</th>
                            <th class="text-end">CTN Qty</th>
                            <th class="text-end">Pcs/CTN</th>
                            <th class="text-end">Rate (Yen)</th>
                            <th class="text-end">Conv. Rate</th>
                            <th class="text-end">INR Rate</th>
                            <th class="text-end">Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($items as $item)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($item->exhibition_date)->format('d-M-Y') }}</td>
                            <td>{{ $item->exhibitor_name ?: '-' }}</td>
                            <td>{{ $item->product_description }}</td>
                            <td>{{ $item->exhibition_name }}</td>
                            <td>{{ $item->location ?: '-' }}</td>
                            <td class="text-end">{{ indian_number($item->ctn_qty, 2) }}</td>
                            <td class="text-end">{{ indian_number($item->pieces_per_ctn, 0) }}</td>
                            <td class="text-end">{{ indian_number($item->rate_in_yen, 4) }}</td>
                            <td class="text-end">{{ indian_number($item->conversion_rate, 6) }}</td>
                            <td class="text-end">{{ indian_number($item->inr_rate, 2) }}</td>
                            <td class="text-end">{{ indian_number($item->total, 2) }}</td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="11" class="text-center text-muted py-4">No field entries found for this date range.</td>
                        </tr>
                        @endforelse
                    </tbody>
                    <tfoot class="table-light fw-bold">
                        <tr>
                            <td colspan="5" class="text-end">Totals:</td>
                            <td class="text-end">{{ indian_number($items->sum('ctn_qty'), 2) }}</td>
                            <td class="text-end">{{ indian_number($items->sum('pieces_per_ctn'), 0) }}</td>
                            <td colspan="3"></td>
                            <td class="text-end">{{ indian_number($items->sum('total'), 2) }}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection