{% extends "finance_and_banking_base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load widget_tweaks %}
{% block title %}
<title>Report</title>
{% endblock title %}
{% block Style %}
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/sweetalert2@10.10.1/dist/sweetalert2.min.css'>
 <style>
 .right{
    text-align: right !important;
  }
  .rowhight{
    height:5px !important;
  }
</style>
{% endblock Style %}


{% block MainContent %}

{% if messages %}
  {% for message in messages %}
    <div class="alert alert-dismissible fade show {% if message.tags %}alert-{% if message.level == DEFAULT_MESSAGE_LEVELS.ERROR %}danger{% else %}{{ message.tags }}{% endif %}{% endif %}" role="alert">{{ message }}
      <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
  {% endfor %}
{% endif %}

<div class="contents">
  {% if request.user.is_superuser == True %}
<form action="" method="POST" enctype="multipart/form-data" autocomplete="off">
  {% csrf_token %}
  <div class="accordion-item">
      <div class="card">
        <div class="card-header">
          <h5 class="mb-0 fw-bold"> 
            Add New File BTB Lot
          </h5>
        </div>
        <div class="card-body">
            <div class="row">

                <div class="col-md-3">
                    {{form.mother_organization|as_crispy_field}}
                </div>
                <div class="col-md-3">
                    {{form.sister_organization|as_crispy_field}}
                </div>
                <div class="col-md-3">
                    {{form.branch|as_crispy_field}}
                </div>
                <div class="col-md-3">
                    {{form.lot_number|as_crispy_field}}
                </div> 
            </div>
            <div class="row">

                <div class="col-md-3">
                    {{form.booking|as_crispy_field}}
                </div> 
    
                <div class="col-md-3">
                    {{form.quantity|as_crispy_field}}
                </div> 
                <div class="col-md-3">
                    {{form.fabric_unit|as_crispy_field}}
                </div> 
                <div class="col-md-3">
                    {{form.item_type|as_crispy_field}}
                </div> 
            </div>
        </div>
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Save</button>
        </div>
    </div>
</div>
</form>
</div>
{% elif user_obj.user_type == 'branch_admin' %}
<form action="" method="POST" enctype="multipart/form-data" autocomplete="off">
  {% csrf_token %}
  <div class="accordion-item">
      <div class="card">
        <div class="card-header">
          <h5 class="mb-0 fw-bold"> 
            Fabric BTB Payment
          </h5>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-3">
                    {{form.file|as_crispy_field}}
                </div>
                <div class="col-md-3">
                  {{form.budget_name|as_crispy_field}}
              </div> 
              <div class="col-md-3">
                {{form.supplier|as_crispy_field}}
            </div> 
            </div>
        </div>
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Save</button>
        </div>
    </div>
</div>
</form>
</div>
{% endif %}

{% if fabric_btb_payment_list %}
<div class="contents">
<div class="table-area mt-2">
  <div class="right">
   <button onclick="ExportToExcel('xlsx')" class="cus-btn" style="width:70px; height:30px"><i class="fa fa-file-excel-o" aria-hidden="true"></i></button>
    <button type="button" id="employee-attendance-general-report-pdf-button" class="cus-btn" style="width:70px; height:30px"><i class="fa fa-print" style="font-size: 16px; color:#fff"></i></button>
  </div>
  <div class="tables table-responsive" id="employee-attendance-general-report-table-pdf">
      <div>
          <h3 style = 'text-align: center'>{{ company_info.name_en }}</h3>
          <h5 style = 'text-align: center'>{{ company_info.address_details }}</h5>
          <p style = 'text-align: right'><span>{{report_month}}</span> <span>{{report_year}}{{eid_bonus_list.created_date}}</span></p>
        </div>
        <h3>Fabric BTB Payment Report
          {% comment %} <small style = 'font-size: 15px; float: right'>{% if department %} {{department}} {% endif %} {% if designation %}  &nbsp - &nbsp {{designation}}{% endif %}</small> </h4> <small style = 'font-size: 15px; float: right; padding-right: 0px;'>{{year}} &nbsp-&nbsp {{month}}</small></h3> {% endcomment %}
        
          <small style = 'font-size: 15px; text-transform: capitalize;'>{% if department %}(<b> Department 
          </b> : {{department}})</small> {% endif %} {% if designation %} <small style = 'font-size: 15px; text-transform: capitalize;'>(<b>Designation</b> : {{designation}})</small> {% endif %}
          {% if date %} <small style = 'font-size: 15px; float: right'>{{date}}</small> {% endif %}</h3>
      <table class="table  table-hover" id="tbl_absent_export">
          <thead>
            <tr>
              <th class="text-center" colspan="6">BTB Position</th>
              <th class="text-center" colspan="6">Consignment & Payment Position</th>
            </tr>
            <tr>
              <th class="text-center">SL No</th>
              <th>Name of Supplier </th>
              <th>Lc Tenor</th>
              <th>Lc Number</th>
              <th>Lc Date</th>
              <th>BTB Lc value</th>
              <th>Recv QTY</th>
              <th>DOC Recv Date</th>
              <th>Goods Recv Date</th>
              <th>Value </th>
              <th>date</th>
            </tr>
          </thead>
          <tbody>
          {% for fabric_btb in fabric_btb_payment_list  %}
              <tr>
                <td class="text-center">{{forloop.counter}}</td>
                <td>{{ fabric_btb.0.supplier }}</td>
                <td>{{ fabric_btb.0.tenor }}</td>
                <td>{{ fabric_btb.0.lc_no }}</td>
                <td>{{ fabric_btb.0.lc_date}}</td>
                 <td>${{ fabric_btb.0.total_value}}</td>
                 <td>{{ fabric_btb.1.booking_rcv_lots.quantity }}</td>
                 <td>{{ fabric_btb.1.doc_rcv_date}}</td>
                 <td>{{ fabric_btb.1.goods_rcv_date}}</td>
                 {% if fabric_btb.1.paid_amount %}
                 <td>${{ fabric_btb.1.paid_amount}}</td>
                 {% else %}
                 <td>$ 0</td>
                 {% endif %}
                 
                 <td>{{ fabric_btb.1.maturity_date}}</td>
              </tr>
              {% endfor %}
                
              {% if dummu_fabric_btb_payment_list %}
              {% for fabric_btb in dummu_fabric_btb_payment_list  %}
              <tr style="background:#F3FF90" >
                <td class="text-center">{{forloop.counter}}</td>
                <td>{{ fabric_btb.supplier }}</td>
                <td>{{ fabric_btb.tenor }}</td>
                <td>{{ fabric_btb.lc_no }}</td>
                <td>{{ fabric_btb.lc_date}}</td>
                 <td>${{ fabric_btb.total_value}}</td>
                 <td>{{ fabric_btb.1.booking_rcv_lots.quantity }}</td>
                 <td>{{ fabric_btb.1.doc_rcv_date}}</td>
                 <td>{{ fabric_btb.1.goods_rcv_date}}</td>
                 <td>${{ fabric_btb.total_value}}</td>
                 <td>{{ fabric_btb.1.maturity_date}}</td>
              </tr>
              {% endfor %}
              {% endif %}
                
          </tbody>
      </table>
  </div>
</div>
{% endif %}
</div>
{% endblock MainContent %}
{% block meassage %}
{% include 'notifications/notifications.html' %}           
{% endblock meassage %}

{% block JS %}

  <script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>

  <script src="{% static 'js/report_app/global_dependency_search/global_dependency_search.js' %} "></script>
  <script src="{% static 'js/report_app/general_attendance_report/general_attendance_report.js' %} "></script>

<script>
    var load_sister_organization_url = "{% url 'ajax-sister-orgazitaion-load' %}"
    var load_branch_organization_url = "{% url 'ajax-branch-load' %}"



    $(document).ready(function() {
      $("#id_file").select2({
          
      });
    });
    
    
    $(document).ready(function() {
      $("#id_branch").select2({
          
      });
    });
    
    
    
    $(document).ready(function() {
      $("#id_budget").select2({
          
      });
    });
    



   
      $("#id_mother_organization").change(function () { 
        var mother_organizationId = $(this).val();  
        $.ajax({                       
        url: load_sister_organization_url,
        
        data: {
            'mother_organization': mother_organizationId   
        },
        success: function (data) { 
            console.log(data);
            $("#id_sister_organization").html(data);  
            }
        });
    });
    $("#id_sister_organization").change(function () {
        var sister_organizationId = $(this).val();  
        $.ajax({                       
          url: load_branch_organization_url,
          
          data: {
            'sister_organization': sister_organizationId   
          },
          success: function (data) { 
            console.log(data);
            $("#id_branch").html(data);  
            }
        }); 
    });
    
    function printDiv(divName) {
      var originalContents = document.body.innerHTML
      var printContents = document.getElementById(divName).innerHTML;
      document.body.innerHTML = printContents;
      window.print();
      document.body.innerHTML = originalContents;
    }


    
  function ExportToExcel(type, fn, dl) {
          var elt = document.getElementById('tbl_absent_export');
          var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1" });
          return dl ?
              XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) :
              XLSX.writeFile(wb, fn || ('Absent_report.' + (type || 'xlsx')));
      }   

</script>


{% endblock JS %}