@extends('backEnd.layouts.master')
@section('title', 'Product Wise Report')

@push('styles')
@include('backEnd.reports.partials.report-styles')
@endpush

@section('content')
@php
    $exportParams = request()->only(['from_date','to_date','search','sales_basis','category_id','approved_by','payment_method','courier_type','district','order_source','sort']);
    $todayStr = now()->format('Y-m-d');
    $yesterdayStr = now()->copy()->subDay()->format('Y-m-d');
    $last7From = now()->copy()->subDays(6)->format('Y-m-d');
    $thisMonthFrom = now()->startOfMonth()->format('Y-m-d');
    $lastMonthFrom = now()->copy()->subMonth()->startOfMonth()->format('Y-m-d');
    $lastMonthTo = now()->copy()->subMonth()->endOfMonth()->format('Y-m-d');
    $last90From = now()->copy()->subDays(89)->format('Y-m-d');

    $activePreset = '';
    if ($from === $to && $from === $todayStr) $activePreset = 'today';
    elseif ($from === $to && $from === $yesterdayStr) $activePreset = 'yesterday';
    elseif ($from === $last7From && $to === $todayStr) $activePreset = 'last7';
    elseif ($from === $thisMonthFrom && $to === $todayStr) $activePreset = 'this_month';
    elseif ($from === $lastMonthFrom && $to === $lastMonthTo) $activePreset = 'last_month';
    elseif ($from === $last90From && $to === $todayStr) $activePreset = 'last90';
@endphp

<div class="container-fluid py-3">
    <div class="d-flex justify-content-between align-items-center mb-3 flex-wrap gap-2">
        <div>
            <h4 class="rp-page-title mb-0">Product Wise Report</h4>
            <small class="text-muted">Product অনুযায়ী sold qty, revenue, cost ও profit · Cost = Product Edit → Price &amp; Stock → Purchase Cost</small>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('admin.reports.products', array_merge($exportParams, ['export' => 'excel'])) }}"
               class="btn btn-success btn-sm rp-export-btn">
                <i class="fas fa-file-excel me-1"></i> Excel
            </a>
            <a href="{{ route('admin.reports.products', array_merge($exportParams, ['export' => 'csv'])) }}"
               class="btn btn-success btn-sm rp-export-btn">
                <i class="fas fa-file-csv me-1"></i> CSV
            </a>
        </div>
    </div>

    <div class="rp-filter-card mb-3">
        <form method="GET" action="{{ route('admin.reports.products') }}" id="productReportFilterForm" class="row g-2 align-items-end">
            <div class="col-12">
                <div class="rp-date-presets">
                    <span class="rp-date-presets-label"><i class="fas fa-calendar-alt me-1"></i>Quick Date:</span>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'today' ? 'is-active' : '' }}" data-preset="today">Today</button>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'yesterday' ? 'is-active' : '' }}" data-preset="yesterday">Yesterday</button>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'last7' ? 'is-active' : '' }}" data-preset="last7">Last 7 Days</button>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'this_month' ? 'is-active' : '' }}" data-preset="this_month">This Month</button>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'last_month' ? 'is-active' : '' }}" data-preset="last_month">Last Month</button>
                    <button type="button" class="rp-preset-btn {{ $activePreset === 'last90' ? 'is-active' : '' }}" data-preset="last90">Last 90 Days</button>
                </div>
            </div>

            <div class="col-md-4">
                <label class="form-label small fw-semibold mb-1">Date Range</label>
                <div class="rp-date-range-wrap">
                    <div class="rp-date-field">
                        <input type="date" name="from_date" id="productFromDate" class="form-control form-control-sm" value="{{ $from }}">
                    </div>
                    <span class="text-muted small pb-1">to</span>
                    <div class="rp-date-field">
                        <input type="date" name="to_date" id="productToDate" class="form-control form-control-sm" value="{{ $to }}">
                    </div>
                </div>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">Sales Basis</label>
                <select name="sales_basis" class="form-select form-select-sm rp-auto-filter">
                    <option value="delivered" {{ ($filters['sales_basis'] ?? 'delivered') === 'delivered' ? 'selected' : '' }}>Delivered Sales</option>
                    <option value="placed" {{ ($filters['sales_basis'] ?? '') === 'placed' ? 'selected' : '' }}>Placed Orders</option>
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">Category</label>
                <select name="category_id" class="form-select form-select-sm rp-auto-filter">
                    <option value="">All Categories</option>
                    @foreach($filterOptions['categories'] as $cat)
                    <option value="{{ $cat->id }}" {{ (string) ($filters['category_id'] ?? '') === (string) $cat->id ? 'selected' : '' }}>{{ $cat->name }}</option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">Sort By</label>
                <select name="sort" class="form-select form-select-sm rp-auto-filter">
                    <option value="sold_qty" {{ ($filters['sort'] ?? 'sold_qty') === 'sold_qty' ? 'selected' : '' }}>Sold Qty</option>
                    <option value="revenue" {{ ($filters['sort'] ?? '') === 'revenue' ? 'selected' : '' }}>Revenue</option>
                    <option value="profit" {{ ($filters['sort'] ?? '') === 'profit' ? 'selected' : '' }}>Profit</option>
                    <option value="orders" {{ ($filters['sort'] ?? '') === 'orders' ? 'selected' : '' }}>Order Count</option>
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">Payment</label>
                <select name="payment_method" class="form-select form-select-sm rp-auto-filter">
                    <option value="">All Payment</option>
                    @foreach($filterOptions['payments'] as $payment)
                    <option value="{{ $payment }}" {{ ($filters['payment_method'] ?? '') === $payment ? 'selected' : '' }}>{{ strtoupper($payment) }}</option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">Courier</label>
                <select name="courier_type" class="form-select form-select-sm rp-auto-filter">
                    <option value="">All Courier</option>
                    @foreach($filterOptions['couriers'] as $courier)
                    <option value="{{ $courier }}" {{ ($filters['courier_type'] ?? '') === $courier ? 'selected' : '' }}>
                        {{ \App\Models\CourierApi::displayName($courier) }}
                    </option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-2">
                <label class="form-label small fw-semibold mb-1">District</label>
                <select name="district" class="form-select form-select-sm rp-auto-filter">
                    <option value="">All District</option>
                    @foreach($filterOptions['districts'] as $district)
                    <option value="{{ $district }}" {{ ($filters['district'] ?? '') === $district ? 'selected' : '' }}>{{ $district }}</option>
                    @endforeach
                </select>
            </div>

            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">Search Product</label>
                <input type="text" name="search" class="form-control form-control-sm" value="{{ $filters['search'] ?? '' }}" placeholder="Product name or SKU">
            </div>

            <div class="col-md-2">
                <button type="submit" class="btn btn-primary btn-sm w-100">
                    <i class="fas fa-filter me-1"></i> Apply
                </button>
            </div>
        </form>
    </div>

    <div class="row g-3 mb-3">
        <div class="col-md-2 col-6">
            <div class="rp-stat-card rp-stat-blue">
                <div class="label">Products</div>
                <div class="value">{{ number_format($summary['product_count']) }}</div>
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="rp-stat-card rp-stat-teal">
                <div class="label">Sold Qty</div>
                <div class="value">{{ number_format($summary['sold_qty']) }}</div>
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="rp-stat-card rp-stat-dark">
                <div class="label">Orders</div>
                <div class="value">{{ number_format($summary['order_count']) }}</div>
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="rp-stat-card rp-stat-green">
                <div class="label">Revenue</div>
                <div class="value">৳{{ number_format($summary['revenue']) }}</div>
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="rp-stat-card rp-stat-yellow">
                <div class="label">Cost</div>
                <div class="value">৳{{ number_format($summary['cost_price']) }}</div>
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="rp-stat-card {{ $summary['profit'] >= 0 ? 'rp-stat-green' : 'rp-stat-red' }}">
                <div class="label">Profit</div>
                <div class="value">৳{{ number_format($summary['profit']) }}</div>
            </div>
        </div>
    </div>

    <div class="rp-panel">
        <div class="table-responsive">
            <table class="rp-table">
                <thead>
                    <tr>
                        <th width="40">#</th>
                        <th>Product</th>
                        <th>Category</th>
                        <th class="text-center">Sold Qty</th>
                        <th class="text-center">Orders</th>
                        <th class="text-end">Revenue</th>
                        <th class="text-end">Cost</th>
                        <th class="text-end">Profit</th>
                        <th class="text-end">Margin</th>
                        <th class="text-end">Avg Price</th>
                        <th class="text-center">Stock</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($rows as $i => $row)
                    <tr>
                        <td class="text-center text-muted">{{ $i + 1 }}</td>
                        <td>
                            <div class="d-flex align-items-center gap-2">
                                @if($row['thumbnail'])
                                <img src="{{ asset($row['thumbnail']) }}" alt="" class="rounded" style="width:36px;height:36px;object-fit:cover">
                                @endif
                                <div>
                                    <div class="fw-semibold">{{ Str::limit($row['product_name'], 50) }}</div>
                                    @if($row['sku'])
                                    <small class="text-muted">{{ $row['sku'] }}</small>
                                    @endif
                                </div>
                            </div>
                        </td>
                        <td>{{ $row['category_name'] ?? '—' }}</td>
                        <td class="text-center fw-bold">{{ number_format($row['sold_qty']) }}</td>
                        <td class="text-center">{{ number_format($row['order_count']) }}</td>
                        <td class="text-end rp-text-sales">৳{{ number_format($row['revenue']) }}</td>
                        <td class="text-end rp-text-cost">৳{{ number_format($row['cost_price']) }}</td>
                        <td class="text-end {{ $row['profit'] >= 0 ? 'rp-text-profit' : 'rp-text-loss' }}">৳{{ number_format($row['profit']) }}</td>
                        <td class="text-end">{{ number_format($row['margin_pct'], 1) }}%</td>
                        <td class="text-end">৳{{ number_format($row['avg_unit_price']) }}</td>
                        <td class="text-center">
                            <span class="badge {{ $row['current_stock'] > 10 ? 'bg-success' : ($row['current_stock'] > 0 ? 'bg-warning text-dark' : 'bg-danger') }}">
                                {{ $row['current_stock'] }}
                            </span>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="11" class="text-center py-5 text-muted">Selected date range-এ কোনো product sale পাওয়া যায়নি।</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
(function () {
    var form = document.getElementById('productReportFilterForm');
    if (!form) return;

    var fromInput = document.getElementById('productFromDate');
    var toInput = document.getElementById('productToDate');
    var today = @json(now()->format('Y-m-d'));

    var presets = {
        today: [today, today],
        yesterday: (function () {
            var d = new Date();
            d.setDate(d.getDate() - 1);
            var s = d.toISOString().slice(0, 10);
            return [s, s];
        })(),
        last7: (function () {
            var d = new Date();
            d.setDate(d.getDate() - 6);
            return [d.toISOString().slice(0, 10), today];
        })(),
        this_month: (function () {
            var d = new Date();
            return [d.getFullYear() + '-' + String(d.getMonth() + 1).padStart(2, '0') + '-01', today];
        })(),
        last_month: (function () {
            var d = new Date();
            d.setDate(1);
            d.setMonth(d.getMonth() - 1);
            var start = d.toISOString().slice(0, 10);
            d.setMonth(d.getMonth() + 1);
            d.setDate(0);
            return [start, d.toISOString().slice(0, 10)];
        })(),
        last90: (function () {
            var d = new Date();
            d.setDate(d.getDate() - 89);
            return [d.toISOString().slice(0, 10), today];
        })()
    };

    document.querySelectorAll('.rp-preset-btn[data-preset]').forEach(function (btn) {
        btn.addEventListener('click', function () {
            var range = presets[this.dataset.preset];
            if (!range) return;
            fromInput.value = range[0];
            toInput.value = range[1];
            form.submit();
        });
    });

    form.querySelectorAll('.rp-auto-filter').forEach(function (el) {
        el.addEventListener('change', function () { form.submit(); });
    });
})();
</script>
@endpush