{% extends "shopyo_base/module_base.html" %}
{% set active_page = 'inventory' %}
{% block pagehead %}<title>Inventory Reports</title>{% endblock %}
{% block sidebar %}{% include 'inventory/blocks/sidebar.html' %}{% endblock %}
{% block module_content %}
<br>
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
 <div><div class="card bg-info text-white p-3"><h5>Valuation (Cost)</h5><h3>${{ '%.2f'|format(total_cost) }}</h3></div></div>
 <div><div class="card bg-success text-white p-3"><h5>Valuation (Retail)</h5><h3>${{ '%.2f'|format(total_retail) }}</h3></div></div>
 <div><div class="card bg-warning text-white p-3"><h5>Potential Margin</h5><h3>${{ '%.2f'|format(total_retail - total_cost) }}</h3></div></div>
</div>
<div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6">
 <div>
 <div class="card"><div class="card-body">
 <h5>Low Stock Alerts ({{ low_stock|length }})</h5>
 <ul>{% for p in low_stock %}<li>{{ p.name }} — {{ p.in_stock }} left (min: {{ p.min_stock }})</li>{% else %}<li class="text-slate-400">None</li>{% endfor %}</ul>
 </div></div>
 </div>
 <div>
 <div class="card"><div class="card-body">
 <h5>Out of Stock ({{ out_of_stock|length }})</h5>
 <ul>{% for p in out_of_stock %}<li>{{ p.name }}</li>{% else %}<li class="text-slate-400">None</li>{% endfor %}</ul>
 </div></div>
 </div>
</div>
<div class="card mt-3"><div class="card-body">
 <h5>All Products</h5>
 <table class="table ">
 <thead><tr><th>Name</th><th>Stock</th><th>Cost</th><th>Retail</th><th>Margin</th><th>Value (Cost)</th></tr></thead>
 <tbody>{% for p in products %}
 <tr>
 <td>{{ p.name }}</td>
 <td>{{ p.in_stock or 0 }}</td>
 <td>${{ '%.2f'|format(p.cost_price|float) }}</td>
 <td>${{ '%.2f'|format(p.selling_price|float) }}</td>
 <td>${{ '%.2f'|format((p.selling_price|float) - (p.cost_price|float)) }}</td>
 <td>${{ '%.2f'|format((p.cost_price|float) * (p.in_stock or 0)) }}</td>
 </tr>
 {% else %}<tr><td colspan="6" class="text-slate-400">No products</td></tr>{% endfor %}
 </tbody>
 </table>
</div></div>
{% endblock %}