{% extends "base.html" %}

{% block title %}Dashboard - Northwind Traders{% endblock %}

{% block content %}
<h1 class="mb-4">Dashboard</h1>

<div class="row g-3 mb-4">
    <div class="col-md-3">
        <a href="{{ url_for('customers') }}" class="text-decoration-none">
            <div class="card card-stat bg-primary text-white">
                <div class="card-body">
                    <h5 class="card-title">Customers</h5>
                    <p class="card-text display-6">{{ stats.total_customers }}</p>
                    <span class="btn btn-light btn-sm">View All</span>
                </div>
            </div>
        </a>
    </div>
    <div class="col-md-3">
        <a href="{{ url_for('products') }}" class="text-decoration-none">
            <div class="card card-stat bg-success text-white">
                <div class="card-body">
                    <h5 class="card-title">Products</h5>
                    <p class="card-text display-6">{{ stats.total_products }}</p>
                    <span class="btn btn-light btn-sm">View All</span>
                </div>
            </div>
        </a>
    </div>
    <div class="col-md-3">
        <a href="{{ url_for('orders') }}" class="text-decoration-none">
            <div class="card card-stat bg-info text-white">
                <div class="card-body">
                    <h5 class="card-title">Orders</h5>
                    <p class="card-text display-6">{{ stats.total_orders }}</p>
                    <span class="btn btn-light btn-sm">View All</span>
                </div>
            </div>
        </a>
    </div>
    <div class="col-md-3">
        <div class="card card-stat bg-warning text-dark">
            <div class="card-body">
                <h5 class="card-title">Employees</h5>
                <p class="card-text display-6">{{ stats.total_employees }}</p>
            </div>
        </div>
    </div>
</div>

<div class="row mb-4">
    <div class="col-md-4">
        <a href="{{ url_for('customer_new') }}" class="btn btn-lg btn-primary w-100">+ New Customer</a>
    </div>
    <div class="col-md-4">
        <a href="{{ url_for('product_new') }}" class="btn btn-lg btn-success w-100">+ New Product</a>
    </div>
    <div class="col-md-4">
        <a href="{{ url_for('order_new') }}" class="btn btn-lg btn-info w-100">+ New Order</a>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h5>Recent Orders</h5>
                <a href="{{ url_for('orders') }}" class="btn btn-primary btn-sm">View All Orders</a>
            </div>
            <div class="card-body p-0">
                {% if recent_orders %}
                <div class="table-responsive">
                    <table class="table table-striped mb-0">
                        <thead>
                            <tr>
                                <th>Order ID</th>
                                <th>Customer</th>
                                <th>Employee</th>
                                <th>Date</th>
                                <th>Ship To</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>
                            {% for order in recent_orders %}
                            <tr>
                                <td><a href="{{ url_for('order_detail', order_id=order['OrderID']) }}">#{{ order['OrderID'] }}</a></td>
                                <td>{{ order['CustomerName'] }}</td>
                                <td>{{ order['EmployeeName'] }}</td>
                                <td>{{ order['OrderDate'] }}</td>
                                <td>{{ order['ShipCountry'] }}</td>
                                <td>
                                    <div class="btn-group btn-group-sm">
                                        <a href="{{ url_for('order_detail', order_id=order['OrderID']) }}" 
                                           class="btn btn-outline-primary">View</a>
                                        <a href="{{ url_for('order_edit', order_id=order['OrderID']) }}" 
                                           class="btn btn-outline-secondary">Edit</a>
                                    </div>
                                </td>
                            </tr>
                            {% endfor %}
                        </tbody>
                    </table>
                </div>
                {% else %}
                <p class="text-center py-4 text-muted">No orders found. 
                    <a href="{{ url_for('order_new') }}">Create your first order</a>!</p>
                {% endif %}
            </div>
        </div>
    </div>
</div>
{% endblock %}