@extends('layouts.app')
@section('title', 'Dashboard')
@section('content')
<h4 class="mb-4">Dashboard</h4>
<div class="row g-3 mb-4">
    <div class="col-md-2">
        <div class="card stat-card" style="border-left-color: #3498db;">
            <div class="card-body">
                <div class="text-muted small">Products</div>
                <div class="fs-4 fw-bold">{{ $totalProducts }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="card stat-card" style="border-left-color: #2ecc71;">
            <div class="card-body">
                <div class="text-muted small">Today's Orders</div>
                <div class="fs-4 fw-bold">{{ $todayOrders }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card stat-card" style="border-left-color: #e67e22;">
            <div class="card-body">
                <div class="text-muted small">Today's Sales</div>
                <div class="fs-4 fw-bold">Rs. {{ number_format($todaySales, 2) }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card stat-card" style="border-left-color: #e74c3c;">
            <div class="card-body">
                <div class="text-muted small">Supplier Due</div>
                <div class="fs-4 fw-bold">Rs. {{ number_format($totalSupplierBalance, 2) }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="card stat-card" style="border-left-color: #9b59b6;">
            <div class="card-body">
                <div class="text-muted small">Customer Receivable</div>
                <div class="fs-4 fw-bold">Rs. {{ number_format($totalCustomerBalance, 2) }}</div>
            </div>
        </div>
    </div>
</div>

<div class="row g-3">
    <div class="col-md-7">
        <div class="card">
            <div class="card-header">Recent Orders</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    <thead><tr><th>#</th><th>Customer</th><th>Total</th><th>Paid</th><th>Date</th></tr></thead>
                    <tbody>
                    @forelse($recentOrders as $order)
                        <tr>
                            <td>{{ $order->id }}</td>
                            <td>{{ $order->customer ? $order->customer->name : ($order->customer_name ?: 'Walk-in') }}</td>
                            <td>Rs. {{ number_format($order->total, 2) }}</td>
                            <td>
                                @if($order->total - $order->paid > 0)
                                    <span class="text-danger">Rs. {{ number_format($order->paid, 2) }}</span>
                                @else
                                    <span class="text-success">Full</span>
                                @endif
                            </td>
                            <td>{{ $order->date->format('d M Y') }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="5" class="text-center text-muted">No orders yet</td></tr>
                    @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="col-md-5">
        <div class="card">
            <div class="card-header">Low Stock Products</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    <thead><tr><th>Product</th><th>Stock</th></tr></thead>
                    <tbody>
                    @forelse($lowStockProducts as $product)
                        <tr>
                            <td>{{ $product->category->name ?? '' }} - {{ $product->weight->label ?? '' }}</td>
                            <td><span class="badge bg-danger">{{ $product->stock }} bags</span></td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="text-center text-muted">All stocked up</td></tr>
                    @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection