{% extends "base.html" %}

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

{% block content %}
<div class="d-flex justify-content-between align-items-center mb-4">
    <h1>Products</h1>
    <a href="{{ url_for('product_new') }}" class="btn btn-primary">+ New Product</a>
</div>

<form method="GET" action="{{ url_for('products') }}" class="mb-4">
    <div class="row g-2">
        <div class="col-md-4">
            <select name="category" class="form-select" onchange="this.form.submit()">
                <option value="">All Categories</option>
                {% for cat in categories %}
                <option value="{{ cat }}" {% if selected_category == cat %}selected{% endif %}>
                    {{ cat }}
                </option>
                {% endfor %}
            </select>
        </div>
    </div>
</form>

<div class="card">
    <div class="card-body p-0">
        {% if products %}
        <div class="table-responsive">
            <table class="table table-striped mb-0">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Product Name</th>
                        <th>Category</th>
                        <th>Supplier</th>
                        <th>Price</th>
                        <th>Stock</th>
                        <th>Status</th>
                        <th style="width: 180px;">Actions</th>
                    </tr>
                </thead>
                <tbody>
                    {% for product in products %}
                    <tr>
                        <td>{{ product['ProductID'] }}</td>
                        <td><strong>{{ product['ProductName'] }}</strong></td>
                        <td>{{ product['CategoryName'] }}</td>
                        <td>{{ product['SupplierID'] }}</td>
                        <td>${{ "%.2f"|format(product['UnitPrice']) }}</td>
                        <td>{{ product['UnitsInStock'] }}</td>
                        <td>
                            {% if product['Discontinued'] %}
                                <span class="badge bg-danger">Discontinued</span>
                            {% elif product['UnitsInStock'] < 10 %}
                                <span class="badge bg-warning text-dark">Low Stock</span>
                            {% else %}
                                <span class="badge bg-success">Available</span>
                            {% endif %}
                        </td>
                        <td>
                            <div class="btn-group btn-group-sm" role="group">
                                <a href="{{ url_for('product_edit', product_id=product['ProductID']) }}" 
                                   class="btn btn-outline-secondary">Edit</a>
                                <form method="POST" action="{{ url_for('product_delete', product_id=product['ProductID']) }}"
                                      style="display: inline;" onsubmit="return confirm('Delete this product?')">
                                    <button type="submit" class="btn btn-outline-danger">Delete</button>
                                </form>
                            </div>
                        </td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
        {% else %}
        <p class="text-center py-4 text-muted">
            {% if selected_category %}No products found in {{ selected_category }}{% else %}No products in database. 
            <a href="{{ url_for('product_new') }}">Create your first product</a>!{% endif %}
        </p>
        {% endif %}
    </div>
</div>

<div class="mt-3 text-muted">
    Showing {{ products|length }} product(s)
</div>
{% endblock %}