@extends('layout.mainlayout')
@section('content')
<div class="page-wrapper">
    <div class="content">
        <div class="page-header">
            <div class="page-title">
                <h4>Product Report</h4>
                <h6>Analyze product data</h6>
            </div>
        </div>

        <!-- Filter Section -->
        <div class="card">
            <div class="card-body">
                <form action="{{ route('admin.report.product') }}" method="GET" class="row g-3 align-items-end">
                    
                    <div class="col-md-3">
                        <label class="form-label">Category</label>
                        <select name="category_id" class="form-select select">
                            <option value="">All Categories</option>
                            @foreach($categories as $cat)
                                <option value="{{ $cat->id }}" {{ request('category_id') == $cat->id ? 'selected' : '' }}>
                                    {{ $cat->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">Status</label>
                        <select name="status" class="form-select select">
                            <option value="">All Statuses</option>
                            <option value="available" {{ request('status') == 'available' ? 'selected' : '' }}>Available</option>
                            <option value="unavailable" {{ request('status') == 'unavailable' ? 'selected' : '' }}>Unavailable</option>
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">From Date</label>
                        <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">To Date</label>
                        <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
                    </div>

                    <div class="col-md-3">
                        <button type="submit" class="btn btn-primary me-2">
                            <i data-feather="filter"></i> Filter
                        </button>
                        <a href="{{ route('admin.report.product') }}" class="btn btn-secondary">Clear</a>
                    </div>
                </form>

                <hr class="my-4">

                <!-- Export Buttons -->
                <div class="d-flex justify-content-end mb-3 gap-2">
                    <form action="{{ route('admin.report.product.export') }}" method="POST" target="_blank">
                        @csrf
                        <input type="hidden" name="category_id" value="{{ request('category_id') }}">
                        <input type="hidden" name="status" value="{{ request('status') }}">
                        <input type="hidden" name="from_date" value="{{ request('from_date') }}">
                        <input type="hidden" name="to_date" value="{{ request('to_date') }}">
                        
                        <input type="hidden" name="export_type" value="pdf">
                        <button type="submit" class="btn btn-danger btn-sm">
                            <i data-feather="file-text"></i> Export PDF
                        </button>
                    </form>

                    <form action="{{ route('admin.report.product.export') }}" method="POST">
                        @csrf
                        <input type="hidden" name="category_id" value="{{ request('category_id') }}">
                        <input type="hidden" name="status" value="{{ request('status') }}">
                        <input type="hidden" name="from_date" value="{{ request('from_date') }}">
                        <input type="hidden" name="to_date" value="{{ request('to_date') }}">
                        
                        <input type="hidden" name="export_type" value="excel">
                        <button type="submit" class="btn btn-success btn-sm">
                            <i data-feather="grid"></i> Export Excel
                        </button>
                    </form>
                </div>

            </div>
        </div>

        <!-- Data Table -->
        <div class="card">
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table datatable">
                        <thead>
                            <tr>
                                <th>Item</th>
                                <th>Category</th>
                                <th>Price</th>
                                <th>Status</th>
                                <th>Added On</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($products as $p)
                            <tr>
                                <td>
                                    <div class="d-flex align-items-center">
                                        @if($p->image)
                                            <img src="{{ asset('storage/'.$p->image) }}" class="me-2" style="width:40px;height:40px;border-radius:4px;object-fit:cover;">
                                        @else
                                            <div class="me-2" style="width:40px;height:40px;background:#f3f4f6;border-radius:4px;display:flex;align-items:center;justify-content:center;">
                                                <i data-feather="image" style="width:16px;color:#9ca3af;"></i>
                                            </div>
                                        @endif
                                        <span>{{ $p->name }}</span>
                                    </div>
                                </td>
                                <td>{{ $p->category_name ?? 'N/A' }}</td>
                                <td>Tsh {{ number_format($p->price, 2) }}</td>
                                <td>
                                    @if($p->status === 'available')
                                        <span class="badges bg-lightgreen">Available</span>
                                    @else
                                        <span class="badges bg-lightred">Unavailable</span>
                                    @endif
                                </td>
                                <td>{{ \Carbon\Carbon::parse($p->created_at)->format('d M Y, H:i') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

    </div>
</div>
@endsection