product-balance.html

{% extends 'base.html' %}

{% block title %}
<title>Inventory Managment App</title>
{% endblock %}


{% block content %}
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/list.js/2.3.1/list.min.js"></script>



<main>
    <div class="container-fluid">
        <h1 class="mt-4">Dashboard</h1>
        <ol class="breadcrumb mb-4">
            <li class="breadcrumb-item"><a href="/">Dashboard</a></li>
            <li class="breadcrumb-item active">Product Balance</li>
        </ol>
        <div class="card mb-4">
            <div class="card-header">Product Balance</div>
            <div class="card-body">
                <div class="card mb-4">
                <div class="card-header">
                    <i class="fas fa-table mr-1"></i>
                    Product Balance Report
                </div>
                <div class="card-body">
                    <div class="table-responsive">

                        {% if movements|length < 1 %}
                        <h4>There are no Movements, add one above</h4>
                        {% else %}
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
    <thead>
        <tr>
            <th>Product Name</th>
            {% for wkey in movements.values()|last %}
                <th>{{ wkey }}</th>
            {% endfor %}

        </tr>
    </thead>
    <tfoot>

    </tfoot>
    <tbody>
        {% for pkey, values in movements.items() %}
            <tr>
                <td>{{ pkey }}</td>
                {% for wkey in movements.values()|last %}
                    {% set quantity = values[wkey].quantity if wkey in values else 0 %}
                    <td>{{ quantity }}</td>

                {% endfor %}
            </tr>
        {% endfor %}
    </tbody>
</table>




                        {% endif %}
                </div>
            </div>
                </div>
            </div>
        </div>
    </div>
</main>
{% endblock %}