@extends('layouts.app')

@section('title', 'Financial & Operational Reporting Suite - Pavitram Agroz')

@section('content')
<div class="d-flex flex-wrap justify-content-between align-items-center mb-4 gap-3">
    <div>
        <h3 class="fw-bold mb-1 text-dark">Enterprise Reporting & Financial Analytics</h3>
        <p class="text-muted mb-0 small">Cross-store retail sales velocity, tax liabilities, cashier settlements, and inventory balance.</p>
    </div>
    <div class="d-flex gap-2">
        <a href="{{ route('reports.export', ['type' => 'products', 'store_id' => $storeId, 'from_date' => $fromDate, 'to_date' => $toDate]) }}" class="btn btn-outline-success btn-sm shadow-sm">
            <i class="bi bi-file-earmark-spreadsheet me-1"></i> Export Product Sales CSV
        </a>
        <a href="{{ route('reports.export', ['type' => 'stores', 'from_date' => $fromDate, 'to_date' => $toDate]) }}" class="btn btn-outline-primary btn-sm shadow-sm">
            <i class="bi bi-download me-1"></i> Export Store Breakdown CSV
        </a>
    </div>
</div>

<!-- Date & Store Filter Bar -->
<div class="card shadow-sm border-0 mb-4">
    <div class="card-body p-3">
        <form method="GET" action="{{ route('reports.index') }}" class="row g-2 align-items-end">
            <input type="hidden" name="tab" value="{{ $activeTab }}">

            @if(auth()->user()->isSuperAdmin())
                <div class="col-md-3">
                    <label class="form-label small fw-semibold mb-1">Store Scope</label>
                    <select name="store_id" class="form-select form-select-sm">
                        <option value="">All Stores (Organization Wide)</option>
                        @foreach($stores as $st)
                            <option value="{{ $st->id }}" {{ $storeId == $st->id ? 'selected' : '' }}>{{ $st->name }}</option>
                        @endforeach
                    </select>
                </div>
            @endif

            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">From Date</label>
                <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $fromDate }}">
            </div>

            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">To Date</label>
                <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $toDate }}">
            </div>

            <div class="col-md-2 d-flex gap-2">
                <button type="submit" class="btn btn-agri btn-sm w-100 fw-bold">
                    <i class="bi bi-funnel me-1"></i> Apply Filter
                </button>
            </div>
        </form>
    </div>
</div>

<!-- Primary Financial Metrics Grid -->
<div class="row g-3 mb-4">
    <div class="col-sm-6 col-xl-3">
        <div class="card shadow-sm border-0 h-100">
            <div class="stat-card">
                <div class="stat-icon green">
                    <i class="bi bi-currency-rupee"></i>
                </div>
                <div>
                    <div class="text-muted small fw-semibold">Net Sales Revenue</div>
                    <div class="fs-4 fw-bold text-success font-monospace">₹{{ number_format($metrics['net_revenue'], 2) }}</div>
                    <div class="small text-muted">Gross: ₹{{ number_format($metrics['gross_revenue'], 2) }}</div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-sm-6 col-xl-3">
        <div class="card shadow-sm border-0 h-100">
            <div class="stat-card">
                <div class="stat-icon blue">
                    <i class="bi bi-receipt"></i>
                </div>
                <div>
                    <div class="text-muted small fw-semibold">Units Sold / Volume</div>
                    <div class="fs-4 fw-bold text-primary font-monospace">{{ number_format($metrics['total_units_sold']) }}</div>
                    <div class="small text-muted">{{ $metrics['total_invoices'] }} bills | AOV: ₹{{ number_format($metrics['avg_order_value'], 2) }}</div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-sm-6 col-xl-3">
        <div class="card shadow-sm border-0 h-100">
            <div class="stat-card">
                <div class="stat-icon amber">
                    <i class="bi bi-percent"></i>
                </div>
                <div>
                    <div class="text-muted small fw-semibold">Total GST Collected</div>
                    <div class="fs-4 fw-bold text-warning-emphasis font-monospace">₹{{ number_format($metrics['total_tax'], 2) }}</div>
                    <div class="small text-muted">Taxable Base: ₹{{ number_format($metrics['taxable_amount'], 2) }}</div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-sm-6 col-xl-3">
        <div class="card shadow-sm border-0 h-100">
            <div class="stat-card">
                <div class="stat-icon red">
                    <i class="bi bi-arrow-return-left"></i>
                </div>
                <div>
                    <div class="text-muted small fw-semibold">Customer Refunds</div>
                    <div class="fs-4 fw-bold text-danger font-monospace">₹{{ number_format($metrics['total_refunds'], 2) }}</div>
                    <div class="small text-muted">{{ $metrics['total_returns_count'] }} returns processed</div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Nav Tabs for Analytical Breakdown -->
<div class="card shadow-sm border-0">
    <div class="card-header bg-white border-bottom-0 pb-0">
        <ul class="nav nav-tabs card-header-tabs" role="tablist">
            @if(auth()->user()->isSuperAdmin())
                <li class="nav-item">
                    <button class="nav-link active fw-bold" data-bs-toggle="tab" data-bs-target="#tabStores">
                        <i class="bi bi-buildings me-1"></i> Store-Wise Sales
                    </button>
                </li>
            @endif
            <li class="nav-item">
                <button class="nav-link {{ !auth()->user()->isSuperAdmin() ? 'active' : '' }} fw-bold" data-bs-toggle="tab" data-bs-target="#tabProducts">
                    <i class="bi bi-box-seam me-1"></i> Product Performance
                </button>
            </li>
            <li class="nav-item">
                <button class="nav-link fw-bold" data-bs-toggle="tab" data-bs-target="#tabBatches">
                    <i class="bi bi-tags me-1"></i> Batch Velocity
                </button>
            </li>
            <li class="nav-item">
                <button class="nav-link fw-bold" data-bs-toggle="tab" data-bs-target="#tabCashiers">
                    <i class="bi bi-people me-1"></i> Cashier Stats
                </button>
            </li>
            <li class="nav-item">
                <button class="nav-link fw-bold" data-bs-toggle="tab" data-bs-target="#tabPayments">
                    <i class="bi bi-credit-card me-1"></i> Payment Methods
                </button>
            </li>
            <li class="nav-item">
                <button class="nav-link fw-bold" data-bs-toggle="tab" data-bs-target="#tabExpiry">
                    <i class="bi bi-hourglass-split me-1 text-warning"></i> Expiring Stock (90d)
                </button>
            </li>
            <li class="nav-item">
                <button class="nav-link fw-bold" data-bs-toggle="tab" data-bs-target="#tabDamaged">
                    <i class="bi bi-shield-x me-1 text-danger"></i> Damaged / Quarantine
                </button>
            </li>
        </ul>
    </div>

    <div class="card-body p-0">
        <div class="tab-content">
            <!-- 1. Store-Wise Sales Tab -->
            @if(auth()->user()->isSuperAdmin())
                <div class="tab-pane fade show active" id="tabStores">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Store Name</th>
                                    <th>Code</th>
                                    <th class="text-end">Invoices</th>
                                    <th class="text-end">Units Sold</th>
                                    <th class="text-end">Taxable Amount (₹)</th>
                                    <th class="text-end">GST Collected (₹)</th>
                                    <th class="text-end">Total Revenue (₹)</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($storeSales as $stSale)
                                    <tr>
                                        <td class="fw-bold text-dark">{{ $stSale->store_name }}</td>
                                        <td><span class="badge bg-light text-dark border font-monospace">{{ $stSale->store_code }}</span></td>
                                        <td class="text-end font-monospace">{{ number_format($stSale->invoice_count) }}</td>
                                        <td class="text-end font-monospace">{{ number_format($stSale->units_sold) }}</td>
                                        <td class="text-end font-monospace">₹{{ number_format($stSale->taxable_amount, 2) }}</td>
                                        <td class="text-end font-monospace text-primary">₹{{ number_format($stSale->total_tax, 2) }}</td>
                                        <td class="text-end font-monospace fw-bold text-success fs-6">₹{{ number_format($stSale->grand_total, 2) }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="7" class="text-center py-4 text-muted">No store sales recorded in selected timeframe.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            @endif

            <!-- 2. Product-Wise Sales Tab -->
            <div class="tab-pane fade {{ !auth()->user()->isSuperAdmin() ? 'show active' : '' }}" id="tabProducts">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Product Name</th>
                                <th>SKU / Code</th>
                                <th class="text-end">Units Sold</th>
                                <th class="text-end">Base Revenue (₹)</th>
                                <th class="text-end">GST Collected (₹)</th>
                                <th class="text-end">Gross Revenue (₹)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($productSales as $pSale)
                                <tr>
                                    <td class="fw-bold text-dark">{{ $pSale->product_name }}</td>
                                    <td>
                                        <span class="badge bg-light text-dark border font-monospace">{{ $pSale->product_sku }}</span>
                                        <small class="text-muted">{{ $pSale->product_code }}</small>
                                    </td>
                                    <td class="text-end font-monospace fw-bold text-primary">{{ number_format($pSale->units_sold) }}</td>
                                    <td class="text-end font-monospace">₹{{ number_format($pSale->base_revenue, 2) }}</td>
                                    <td class="text-end font-monospace text-muted">₹{{ number_format($pSale->tax_collected, 2) }}</td>
                                    <td class="text-end font-monospace fw-bold text-success">₹{{ number_format($pSale->total_revenue, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="6" class="text-center py-4 text-muted">No product units sold in selected timeframe.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 3. Batch Velocity Tab -->
            <div class="tab-pane fade" id="tabBatches">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Batch Number</th>
                                <th>Product</th>
                                <th>Expiry Date</th>
                                <th class="text-end">Units Sold</th>
                                <th class="text-end">Total Revenue (₹)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($batchSales as $bSale)
                                <tr>
                                    <td class="font-monospace fw-bold text-dark">{{ $bSale->batch_number }}</td>
                                    <td>{{ $bSale->product_name }}</td>
                                    <td class="small">{{ \Carbon\Carbon::parse($bSale->expiry_date)->format('d M Y') }}</td>
                                    <td class="text-end font-monospace fw-bold">{{ number_format($bSale->units_sold) }}</td>
                                    <td class="text-end font-monospace fw-bold text-success">₹{{ number_format($bSale->revenue, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="5" class="text-center py-4 text-muted">No batch sales recorded.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 4. Cashier Performance Tab -->
            <div class="tab-pane fade" id="tabCashiers">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Cashier Name</th>
                                <th>Store</th>
                                <th class="text-end">Bills Handled</th>
                                <th class="text-end">Items Sold</th>
                                <th class="text-end">Total Collected (₹)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($cashierStats as $cStat)
                                <tr>
                                    <td>
                                        <div class="fw-bold text-dark">{{ $cStat->cashier_name }}</div>
                                        <small class="text-muted">{{ $cStat->cashier_email }}</small>
                                    </td>
                                    <td>{{ $cStat->store_name }}</td>
                                    <td class="text-end font-monospace">{{ number_format($cStat->bills_processed) }}</td>
                                    <td class="text-end font-monospace">{{ number_format($cStat->items_sold) }}</td>
                                    <td class="text-end font-monospace fw-bold text-success fs-6">₹{{ number_format($cStat->total_collected, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="5" class="text-center py-4 text-muted">No cashier activity recorded.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 5. Payment Methods Tab -->
            <div class="tab-pane fade" id="tabPayments">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Payment Method</th>
                                <th class="text-end">Transactions Count</th>
                                <th class="text-end">Total Amount (₹)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($paymentBreakdown as $pmt)
                                <tr>
                                    <td>
                                        <span class="badge bg-light text-dark border px-3 py-2 fs-6">
                                            <i class="bi bi-wallet2 me-1"></i> {{ $pmt->payment_method }}
                                        </span>
                                    </td>
                                    <td class="text-end font-monospace fs-6">{{ number_format($pmt->transaction_count) }}</td>
                                    <td class="text-end font-monospace fw-bold text-success fs-6">₹{{ number_format($pmt->total_amount, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="3" class="text-center py-4 text-muted">No payment settlements found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 6. Expiring Stock (90 Days) Tab -->
            <div class="tab-pane fade" id="tabExpiry">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Serial # / QR</th>
                                <th>Product</th>
                                <th>Batch</th>
                                <th>Location</th>
                                <th>Expiry Date</th>
                                <th>Days Remaining</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($expiringProducts as $expUnit)
                                @php
                                    $daysRemaining = round(now()->diffInDays($expUnit->expiry_date, false));
                                @endphp
                                <tr>
                                    <td><span class="badge bg-light text-dark border font-monospace">{{ $expUnit->serial_number }}</span></td>
                                    <td class="fw-bold">{{ $expUnit->product->name }}</td>
                                    <td class="font-monospace small">{{ $expUnit->batch->batch_number }}</td>
                                    <td>{{ $expUnit->current_location_display }}</td>
                                    <td class="small">{{ $expUnit->expiry_date->format('d M Y') }}</td>
                                    <td>
                                        @if($daysRemaining <= 0)
                                            <span class="badge bg-danger">EXPIRED</span>
                                        @elseif($daysRemaining <= 30)
                                            <span class="badge bg-danger-subtle text-danger">{{ $daysRemaining }} days</span>
                                        @else
                                            <span class="badge bg-warning-subtle text-warning-emphasis">{{ $daysRemaining }} days</span>
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="6" class="text-center py-4 text-muted">No units expiring within the next 90 days.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 7. Damaged & Quarantine Stock Tab -->
            <div class="tab-pane fade" id="tabDamaged">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Serial #</th>
                                <th>Product</th>
                                <th>Batch</th>
                                <th>Status</th>
                                <th>Current Holding Location</th>
                                <th>Last Updated</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($damagedProducts as $dmgUnit)
                                <tr>
                                    <td><span class="badge bg-light text-dark border font-monospace">{{ $dmgUnit->serial_number }}</span></td>
                                    <td class="fw-bold">{{ $dmgUnit->product->name }}</td>
                                    <td class="font-monospace small">{{ $dmgUnit->batch->batch_number }}</td>
                                    <td><span class="badge bg-danger-subtle text-danger">{{ $dmgUnit->status }}</span></td>
                                    <td>{{ $dmgUnit->current_location_display }}</td>
                                    <td class="small text-muted">{{ $dmgUnit->updated_at->format('d M Y H:i') }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="6" class="text-center py-4 text-muted">No damaged or quarantined units recorded.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection