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

{% block content %}

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

<div class="main-content" id="page-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">Balance Due Report</h4>

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

            <div class="row" id="datefilter">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <!-- <h4 class="card-title mb-4">Date Filter</h4> -->

                            <form method="POST">
                                {% csrf_token %}
                                <div class="row">
                                    <div class="col-sm-1 col-12"><h4>Filters</h4></div>
                                    
                                    <div class="col-sm-7 col-12">
                                        <div class="input-group">
                                            <select class="form-control select2" name="customer" id="customer" style="width: 40%;">
                                              <option value="0">All</option>
                                              {% for customer in customers %}
                                                  <option value="{{customer.id}}" {% if customer.id == customer_id %}selected{% endif %}>{{customer.first_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" style="height: 30px;" class="btn btn-primary w-md"><i class="fas fa-filter"></i></button>
                                        </div>
                                    </div>
                                    <div class="col-sm-4 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">                                         
                                        <!-- <button type="button" data-bs-toggle="modal" data-bs-target="#addCustomerModal" class="btn btn-success btn-rounded waves-effect waves-light mb-2 me-2"><i class="mdi mdi-plus me-1"></i> New Customers</button> -->
                                    </div>
                                </div><!-- end col-->
                            </div>
                            {% if messages %}
                            {% for message in messages %}
                            <div class="alert alert-success alert-dismissible fade show" role="alert">
                                {{ message }}
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>        
                            </div>
                            {% endfor %}
                        {% endif %}
                        <div class="float-end">
                            <a href="javascript:window.print()" type="button" class="btn btn-primary"><i class="fas fa-print"></i></a>
                        </div>
                            <div class="" id="print">
                                <h4 class="mb-sm-0 font-size-18 text-center hide mb-4">Balance Due Report</h4>

                                <table class="table align-middle table-hover" id="balance-due-report-table">
                                    <thead>
                                        <tr>
                                            <!-- <th>#</th> -->
                                            <th>Invoice Id</th>
                                            <th>Description</th>
                                            <th>Total</th>
                                            <th>Balance</th>
                                            <th>Date</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {% for i in customer_data %}
                                        <tr>
                                            <td colspan="5">
                                                <a style="font-weight: bolder;" title="View Invoice"  target="_blank">{{ i.customer.first_name }} {{ i.customer.last_name }}</a>
                                            </td>
                                        </tr>
                                            {% for invoice in i.invoices %}
                                            <tr title="View Invoice" onclick="reportViewInvoice('{{invoice.id}}')">
                                                <td>
                                                    {{invoice.id}}
                                                </td>
                                                <td>
                                                    {{invoice.description}}
                                                </td>
                                                <td>
                                                    ${{invoice.total}}
                                                </td>
                                                
                                                <td>${{ invoice.balance }}</td>
                                                <td>
                                                    {{invoice.created_at}}
                                                </td>
                                            </tr>
                                            {% endfor %}
                                            <tr class="border-dark">
                                                <td class="fw-bolder text-end" colspan="2">Customer Total:</td>
                                                <td class="fw-bolder">${{i.total}}</td>
                                                <td class="fw-bolder" colspan="2">${{i.balance}}</td>
                                            </tr>
                                        {% endfor %}
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


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





{% endblock %}