{% extends 'pos_system/base.html' %}
{% load static %}

{% block content %}

<style>
@media print {
    @page {
    size: landscape;
  }
    body * {
    visibility: hidden;
    transform: scale(1);
  }
  #datefilter{
    display: none;
  }
  #print,
  #print * {
    visibility: visible;
  }
  .hide{
    visibility: visible;
  }
}
.hide{
    visibility: hidden;
}
</style>


<div class="main-content">

    <div class="page-content">
        <div class="container-fluid">
            
            <!-- start page title -->
            <div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0 font-size-18">Product Sale Report</h4>

                    </div>
                </div>
            </div>
            <!-- end page title -->

            <div class="row" id="datefilter">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">

                            <form method="POST">
                                {% csrf_token %}
                                <div class="row">
                                    <div class="col-sm-1 col-12">
                                        <h4 class="card-title mb-4">Filter</h4>
                                    </div>
                                    <div class="col-sm-6 col-12">
                                        <div class="input-group">
                                            <select class="form-control select2" name="product" id="customer">
                                                <option value="0">All</option>
                                                {% for product in products %}
                                                    <option value="{{product.id}}" {% if product.id == product_id %}selected{% endif %}>{{product.name}}</option>
                                                {% endfor %}
                                              </select>
                                            <input value="{{from}}" style="height: 30px;" type="date" class="form-control" name="from_date" placeholder="From Date" title="From Date" required>
                                            <input value="{{to}}" style="height: 30px;" type="date" class="form-control" title="To  Date" placeholder="To Date" name="to_date" required>
                                            <button type="submit" class="btn btn-primary w-md"><i class="fas fa-filter"></i></button>
                                        </div>
                                    </div>
                                    <div class="col-sm-5 col-12"></div>
                                </div>
                            </form>
                        </div>
                        <!-- end card body -->
                    </div>
                    <!-- end card -->
                </div>
            </div>


            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row mb-2">
                                <div class="col-sm-4">
                                </div>
                                <div class="col-sm-8">
                                    <div class="text-sm-end">                                         
                                    </div>
                                </div><!-- end col-->
                            </div>
                            
                        <a href="javascript:window.print()" type="button" class="btn btn-primary"><i class="fas fa-print"></i></a>
                        <div class="" id="print">
                                <h4 class="mb-sm-0 font-size-18 text-center hide mb-4">Product Sale Report</h4>
                                <table class="table table-sm align-middle" id="product-sale-report">
                                    <thead>
                                        <tr>
                                            <!-- <th>#</th> -->
                                            <th>Description</th>
                                            <th>Date</th>
                                            <th>Total</th>
                                            <th>Paid</th>
                                            <th>Invoice Id</th>
                                            <th>Entity Id</th>
                                            <th>Product</th>
                                            <th>Price</th>
                                            <th>Qty</th>
                                            <th>Product Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {% for invoices in data %}
                                        <tr>
                                            <th colspan="10">{{invoices.des}}</th>
                                        </tr>
                                            {% for details in invoices.detail %}
                                                {% for detail in details.list %}
                                                <tr>
                                                    <td></td>
                                                        <td class="text-nowrap">{{detail.invoice.created_at}}</td>
                                                        <td>{{detail.invoice.total}}</td>
                                                        <td>{{detail.invoice.paid}}</td>
                                                        <td>{{detail.invoice.id}}</td>
                                                        <td>{{detail.invoice.customer.id}}</td>
                                                        <td>{{detail.product.name}}</td>
                                                        <td>{{detail.amount}}</td>
                                                        <td>{{detail.qty}}</td>
                                                        <td>{{detail.total|floatformat:"2"}}</td>
                                                    </tr>
                                                {% endfor %}
                                                <tr>
                                                    <th colspan="7" class="text-end">Total for this product</th>
                                                    <th colspan="3">{{details.total}}</th>
                                                </tr>
                                            {% endfor %}
                                        {% endfor %}
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div> <!-- container-fluid -->
    </div>
    <!-- End Page-content -->
</div>










{% endblock %}