@extends('layouts.app')

@section('title', 'ERP Dashboard')
@section('page_title', 'ERP Executive Dashboard')

@section('content')
<div class="container-fluid p-0">

    <!-- KPI Metric Cards Row -->
    <div class="row g-3 mb-4">
        <!-- Card 1: Sales -->
        <div class="col-xl-3 col-md-6">
            <div class="card h-100 border-0 shadow-sm border-start border-primary border-4">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span class="text-muted fw-semibold small text-uppercase">Total Sales Revenue</span>
                        <span class="badge bg-primary-subtle text-primary p-2 rounded-circle"><i class="bi bi-graph-up fs-5"></i></span>
                    </div>
                    <h3 class="fw-bold mb-1">₹{{ number_format($totalSales, 2) }}</h3>
                    <div class="small text-muted mt-2 d-flex justify-content-between">
                        <span>This Month: <strong class="text-dark">₹{{ number_format($monthSales, 2) }}</strong></span>
                        <span>Today: <strong class="text-primary">₹{{ number_format($todaySales, 2) }}</strong></span>
                    </div>
                </div>
            </div>
        </div>

        <!-- Card 2: Stock Valuation -->
        <div class="col-xl-3 col-md-6">
            <div class="card h-100 border-0 shadow-sm border-start border-success border-4">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span class="text-muted fw-semibold small text-uppercase">Stock Valuation (Cost)</span>
                        <span class="badge bg-success-subtle text-success p-2 rounded-circle"><i class="bi bi-box-seam fs-5"></i></span>
                    </div>
                    <h3 class="fw-bold mb-1">₹{{ number_format($stockValuation, 2) }}</h3>
                    <div class="small text-muted mt-2 d-flex justify-content-between">
                        <span>Total Items: <strong class="text-dark">{{ $totalProducts }}</strong></span>
                        <span>Retail Value: <strong class="text-success">₹{{ number_format($stockRetailValuation, 2) }}</strong></span>
                    </div>
                </div>
            </div>
        </div>

        <!-- Card 3: Receivables (Dues from Customers) -->
        <div class="col-xl-3 col-md-6">
            <div class="card h-100 border-0 shadow-sm border-start border-warning border-4">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span class="text-muted fw-semibold small text-uppercase">Receivables (Customer Dues)</span>
                        <span class="badge bg-warning-subtle text-warning p-2 rounded-circle"><i class="bi bi-arrow-down-left-circle fs-5"></i></span>
                    </div>
                    <h3 class="fw-bold mb-1 text-danger">₹{{ number_format($receivables, 2) }}</h3>
                    <div class="small text-muted mt-2">
                        <span>Outstanding amount due on pending invoices</span>
                    </div>
                </div>
            </div>
        </div>

        <!-- Card 4: Payables (Dues to Suppliers) -->
        <div class="col-xl-3 col-md-6">
            <div class="card h-100 border-0 shadow-sm border-start border-info border-4">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span class="text-muted fw-semibold small text-uppercase">Payables (Supplier Dues)</span>
                        <span class="badge bg-info-subtle text-info p-2 rounded-circle"><i class="bi bi-arrow-up-right-circle fs-5"></i></span>
                    </div>
                    <h3 class="fw-bold mb-1 text-dark">₹{{ number_format($payables, 2) }}</h3>
                    <div class="small text-muted mt-2">
                        <span>Total Purchases: <strong class="text-dark">₹{{ number_format($totalPurchases, 2) }}</strong></span>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- GST Tax Summary Widget & Sales Trend -->
    <div class="row g-3 mb-4">
        <!-- GST Tax Summary -->
        <div class="col-lg-5">
            <div class="card h-100 border-0 shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h6 class="mb-0 fw-bold"><i class="bi bi-shield-check text-primary me-2"></i> GST Position & Tax Summary</h6>
                    <a href="{{ route('reports.gst-summary') }}" class="btn btn-sm btn-outline-primary">View GSTR-1</a>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm align-middle mb-0">
                            <thead>
                                <tr class="table-light">
                                    <th>Tax Head</th>
                                    <th class="text-end">Output Tax (Sales)</th>
                                    <th class="text-end">Input Tax (Purchases)</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td class="fw-semibold">CGST</td>
                                    <td class="text-end text-danger fw-semibold">₹{{ number_format($outputCgst, 2) }}</td>
                                    <td class="text-end text-success fw-semibold">₹{{ number_format($inputCgst, 2) }}</td>
                                </tr>
                                <tr>
                                    <td class="fw-semibold">SGST</td>
                                    <td class="text-end text-danger fw-semibold">₹{{ number_format($outputSgst, 2) }}</td>
                                    <td class="text-end text-success fw-semibold">₹{{ number_format($inputSgst, 2) }}</td>
                                </tr>
                                <tr>
                                    <td class="fw-semibold">IGST (Inter-State)</td>
                                    <td class="text-end text-danger fw-semibold">₹{{ number_format($outputIgst, 2) }}</td>
                                    <td class="text-end text-success fw-semibold">₹{{ number_format($inputIgst, 2) }}</td>
                                </tr>
                                <tr class="table-light fw-bold">
                                    <td>Total Tax</td>
                                    <td class="text-end text-danger">₹{{ number_format($totalOutputTax, 2) }}</td>
                                    <td class="text-end text-success">₹{{ number_format($totalInputTax, 2) }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>

                    <div class="alert alert-primary bg-primary-subtle border-0 mt-3 mb-0 d-flex justify-content-between align-items-center p-3">
                        <div>
                            <div class="small text-uppercase fw-bold text-primary">Estimated Net GST Liability</div>
                            <div class="fs-4 fw-bold text-dark">₹{{ number_format($netGstLiability, 2) }}</div>
                        </div>
                        <span class="badge bg-primary px-3 py-2 fs-6">Payable</span>
                    </div>
                </div>
            </div>
        </div>

        <!-- 6-Month Sales & Purchase Performance Chart -->
        <div class="col-lg-7">
            <div class="card h-100 border-0 shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h6 class="mb-0 fw-bold"><i class="bi bi-bar-chart-line text-success me-2"></i> Sales vs Purchases (Last 6 Months)</h6>
                    <span class="text-muted small">Financial Trend</span>
                </div>
                <div class="card-body">
                    <canvas id="monthlyTrendChart" height="150"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Low Stock Alerts & Recent Invoices -->
    <div class="row g-3 mb-4">
        <!-- Low Stock Alerts Table -->
        <div class="col-lg-6">
            <div class="card h-100 border-0 shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <div class="d-flex align-items-center gap-2">
                        <span class="badge bg-danger rounded-pill">{{ $lowStockCount }}</span>
                        <h6 class="mb-0 fw-bold text-danger"><i class="bi bi-exclamation-octagon me-1"></i> Low Stock Reorder Alerts</h6>
                    </div>
                    <a href="{{ route('purchases.create') }}" class="btn btn-sm btn-outline-danger">Create Purchase Bill</a>
                </div>
                <div class="card-body p-0">
                    @if($lowStockProducts->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-hover align-middle mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Product / SKU</th>
                                        <th class="text-center">Current Stock</th>
                                        <th class="text-center">Reorder Level</th>
                                        <th class="text-end">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($lowStockProducts as $prod)
                                        <tr>
                                            <td>
                                                <div class="fw-semibold">{{ $prod->name }}</div>
                                                <small class="text-muted">SKU: {{ $prod->sku }} | HSN: {{ $prod->hsn_code }}</small>
                                            </td>
                                            <td class="text-center">
                                                <span class="badge bg-danger fs-6">{{ number_format($prod->current_stock, 0) }} {{ $prod->unit ? $prod->unit->short_code : '' }}</span>
                                            </td>
                                            <td class="text-center text-muted fw-semibold">
                                                {{ number_format($prod->reorder_level, 0) }} {{ $prod->unit ? $prod->unit->short_code : '' }}
                                            </td>
                                            <td class="text-end">
                                                <a href="{{ route('purchases.create') }}" class="btn btn-sm btn-outline-primary" title="Reorder via Purchase Bill">
                                                    <i class="bi bi-cart-plus"></i> Reorder
                                                </a>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div class="text-center py-4 text-muted">
                            <i class="bi bi-check-circle-fill text-success fs-1 d-block mb-2"></i>
                            All inventory items are well above reorder levels!
                        </div>
                    @endif
                </div>
            </div>
        </div>

        <!-- Recent Sales Invoices -->
        <div class="col-lg-6">
            <div class="card h-100 border-0 shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h6 class="mb-0 fw-bold"><i class="bi bi-receipt text-primary me-2"></i> Recent Sales Invoices</h6>
                    <a href="{{ route('invoices.index') }}" class="btn btn-sm btn-outline-primary">View All</a>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Invoice #</th>
                                    <th>Customer / Place of Supply</th>
                                    <th class="text-end">Amount</th>
                                    <th class="text-center">Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($recentInvoices as $inv)
                                    <tr>
                                        <td>
                                            <a href="{{ route('invoices.show', $inv) }}" class="fw-bold text-decoration-none">
                                                {{ $inv->invoice_number }}
                                            </a>
                                            <div class="small text-muted">{{ $inv->invoice_date->format('d M Y') }}</div>
                                        </td>
                                        <td>
                                            <div class="fw-semibold text-truncate" style="max-width: 180px;">{{ $inv->party_name }}</div>
                                            <small class="badge bg-light text-secondary border">
                                                {{ $inv->place_of_supply_state }} ({{ $inv->is_inter_state ? 'IGST' : 'CGST+SGST' }})
                                            </small>
                                        </td>
                                        <td class="text-end fw-bold">
                                            ₹{{ number_format($inv->grand_total, 2) }}
                                        </td>
                                        <td class="text-center">
                                            <span class="badge {{ $inv->payment_badge_class }}">
                                                {{ ucfirst(str_replace('_', ' ', $inv->payment_status)) }}
                                            </span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="4" class="text-center py-3 text-muted">No sales invoices yet.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Stock Movements Audit Trail Row -->
    <div class="row g-3">
        <div class="col-12">
            <div class="card border-0 shadow-sm">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h6 class="mb-0 fw-bold"><i class="bi bi-clock-history text-secondary me-2"></i> Recent Stock Audit Trail Movements</h6>
                    <a href="{{ route('stock-movements.index') }}" class="btn btn-sm btn-outline-secondary">Complete Audit Log</a>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Timestamp</th>
                                    <th>Product</th>
                                    <th>Movement Type</th>
                                    <th class="text-center">Quantity</th>
                                    <th class="text-center">Stock Before</th>
                                    <th class="text-center">Stock After</th>
                                    <th>Reference / Notes</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($recentMovements as $move)
                                    <tr>
                                        <td class="small text-muted">{{ $move->created_at->format('d M Y, h:i A') }}</td>
                                        <td class="fw-semibold">{{ $move->product ? $move->product->name : 'N/A' }}</td>
                                        <td>
                                            <span class="badge {{ $move->badge_class }}">
                                                {{ $move->formatted_type }}
                                            </span>
                                        </td>
                                        <td class="text-center fw-bold">
                                            {{ in_array($move->movement_type, ['purchase', 'adjustment_add', 'sale_return']) ? '+' : '-' }}{{ number_format($move->quantity, 0) }}
                                        </td>
                                        <td class="text-center text-muted">{{ number_format($move->stock_before, 0) }}</td>
                                        <td class="text-center fw-semibold text-primary">{{ number_format($move->stock_after, 0) }}</td>
                                        <td class="small text-muted">{{ $move->notes ?? ($move->reference_type ? "Ref: {$move->reference_type} #{$move->reference_id}" : '-') }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="7" class="text-center py-3 text-muted">No stock movements recorded yet.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

</div>
@endsection

@push('scripts')
<!-- Chart.js -->
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
    document.addEventListener("DOMContentLoaded", function () {
        const trendData = @json($monthlyTrends);
        const labels = trendData.map(item => item.month);
        const salesData = trendData.map(item => item.sales);
        const purchaseData = trendData.map(item => item.purchases);

        const ctx = document.getElementById('monthlyTrendChart').getContext('2d');
        new Chart(ctx, {
            type: 'bar',
            data: {
                labels: labels,
                datasets: [
                    {
                        label: 'Sales Revenue (₹)',
                        data: salesData,
                        backgroundColor: 'rgba(37, 99, 235, 0.85)',
                        borderColor: '#2563eb',
                        borderWidth: 1,
                        borderRadius: 4
                    },
                    {
                        label: 'Purchases (₹)',
                        data: purchaseData,
                        backgroundColor: 'rgba(16, 185, 129, 0.85)',
                        borderColor: '#10b981',
                        borderWidth: 1,
                        borderRadius: 4
                    }
                ]
            },
            options: {
                responsive: true,
                maintainAspectRatio: false,
                scales: {
                    y: {
                        beginAtZero: true,
                        ticks: {
                            callback: function(value) {
                                return '₹' + value.toLocaleString('en-IN');
                            }
                        }
                    }
                },
                plugins: {
                    tooltip: {
                        callbacks: {
                            label: function(context) {
                                return context.dataset.label + ': ₹' + context.raw.toLocaleString('en-IN', {minimumFractionDigits: 2});
                            }
                        }
                    }
                }
            }
        });
    });
</script>
@endpush