{% extends "finance_and_banking_base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load custom_filters %}


{% block title %}
<title>Old Order Wise Lending Report</title>
{% endblock title %}
{% block Style %}
<style>
  .search {
      width: 94%!important;
  }
  .cus-btn {
  background: #FC6736;
  }
  a.cus-btn.excel:hover {
  color: white;
  }
  thead tr, th, td {
  font-size: 13px !important;
  border:1px solid black !important;
  }
  tbody tr, th, td {
  font-size: 13px !important;
  border:1px solid black !important;
  }



  thead tr:first-child th {
  position: sticky;
  top: -16px;

  z-index: 3; 
  }
  .fixed thead tr:nth-child(2){
  position: sticky;
  top: 18px;
  z-index: 4;
  }
</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">
  <div class="table-area">
  <!-- table-title -->
  <div class="table-title">
    <div class="row">
      <div class="col-md-4">
        <div class="depertment-name">
          <h4>Old Order Wise Lending Report</h4>
        </div>
      </div>
    </div>
  </div>

  <form method="post" id="reportForm" data-cities-url="" novalidate>
    {% csrf_token %}
    <div class="table-header">
        <div class="row">
          <div class="col-md-4 fw-bold">
            {{form.parent_file|as_crispy_field }}
          </div>
          <div class="col-md-4 fw-bold">
            {{form.order_no|as_crispy_field }}
          </div>
          <div class="col-md-3 fw-bold">
            {{form.type|as_crispy_field }}
          </div>
          <div class="col-md-1" style="margin-top: 33px;">
            <button type="submit" class="cus-btn">Show</button>
          </div>
        </div>
    </div>
  </form>

</div>
  <!-- table-title -->
  {% comment %} {% if report_list and file and total_value and total_lc_value and total_consignment_value and total_request_value and total_acceptance_value and total_maturity_value and tatal_payment_value %} {% endcomment %}
  {% if file %}
  <div class="table-area">
    <div style="text-align: 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>
      {% comment %} <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> {% endcomment %}
      <button type="button" onclick="printDiv('printableArea')" 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 table-container" id="printableArea">
      <div>
        <h3 style = 'text-align: center'>{{file.beneficiary_company}}</h3>
        {% comment %} <h5 style = 'text-align: center'>File wise import position of {{file.beneficiary_company}}</h5> {% endcomment %}
        <h6 style = 'text-align: center'>{{file.beneficiary_company.branch.branch.address_details}}</h6>
      </div>
      <h5 class="fw-bold m-3 text-center"><u>Old Order Wise Lending-{{order_no}}</U></h5>
        <div class="row">
          <div class="col-md-12">



<table class="table table-hover table-bordered">
    <thead class="table-light">
        <tr>
            <th class="text-center">SL NO.</th>
            <th class="text-center">Goods Description</th>
            <th class="text-center">Costing Value</th>
            <th class="text-center">BTB Opened</th>
            <th class="text-center">Balance</th>
            <th class="text-center">PI Value</th>
            <th class="text-center">Supplier</th>
            <th class="text-center">Cash</th>
            <th class="text-center">BTB LC</th>
            <th class="text-center">Tenor</th>
            <th class="text-center">BTB Value</th>
            <th class="text-center">LC Date</th>
            <th class="text-center">BTB Value(PI)</th>
            <th class="text-center">Balance</th>
            <th class="text-center">Ammendments</th>
            <th class="text-center">Transfer History</th>
            <th class="text-center">Parent Order</th>
            <th class="text-center">Remarks</th>
        </tr>
    </thead>
    <tbody>
        <tr><td class="text-center fw-bold" colspan="18"><strong>To Other Odr (S.F)</strong></td></tr>
   
           
            {% for item in order_wise_btb_obj_for_same %}
                <tr>
                    <td class="text-center">{{ forloop.counter }}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.good_description}}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.costing_value }}</td>
                    <td class="text-center">{{ item.value }}</td>
                    <td class="text-center">{{ form_balance }}</td>
                    <td class="text-center">{{ item.old_request.pi_value }}</td>
                    <td class="text-center">{{ item.old_request.supplier }}</td>
                    <td class="text-center">{{ item.old_request.get_payment_type_display }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_no }}</td>
                    <td class="text-center">{{ item.btb_lc.tenor }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.opening_date }}</td>
                    <td class="text-center">{{ item.btb_lc.value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_amendments }}</td>
                    <td class="text-center">{{ item.pi_transfer_status }}</td>
                    <td class="text-center">{{ item.old_parent_budget }}</td>
                    <td class="text-center">{{ item.old_request.remarks }}</td>
                </tr>
            {% endfor %}
            <tr class="fw-bold">
                <td class="text-center" colspan="3"><strong>Subtotal:</strong></td>
               <td class="text-center"><strong>{{grand_total_order_wise_btb_obj_for_same}}</strong></td>
            </tr>
        <tr><td class="text-center fw-bold" colspan="18"><strong>From Other Odr (S.F)</strong></td></tr>
   
           
            {% for item in order_wise_btb_obj_from_same %}
                <tr>
                    <td class="text-center">{{ forloop.counter }}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.good_description}}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.costing_value }}</td>
                    <td class="text-center">{{ item.value }}</td>
                    <td class="text-center">{{ form_balance }}</td>
                    <td class="text-center">{{ item.old_request.pi_value }}</td>
                    <td class="text-center">{{ item.old_request.supplier }}</td>
                    <td class="text-center">{{ item.old_request.get_payment_type_display }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_no }}</td>
                    <td class="text-center">{{ item.btb_lc.tenor }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.opening_date }}</td>
                    <td class="text-center">{{ item.btb_lc.value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_amendments }}</td>
                    <td class="text-center">{{ item.pi_transfer_status }}</td>
                    <td class="text-center">{{ item.old_parent_budget }}</td>
                    <td class="text-center">{{ item.old_request.remarks }}</td>
                </tr>
            {% endfor %}
            <tr class="fw-bold">
                <td class="text-center" colspan="3"><strong>Subtotal:</strong></td>
               <td class="text-center"><strong>{{grand_total_order_wise_btb_obj_from_same}}</strong></td>
            </tr>
        <tr><td class="text-center fw-bold" colspan="18"><strong>To Other File</strong></td></tr>
   
           
            {% for item in order_wise_btb_other_file_obj_for %}
                <tr>
                    <td class="text-center">{{ forloop.counter }}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.good_description}}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.costing_value }}</td>
                    <td class="text-center">{{ item.value }}</td>
                    <td class="text-center">{{ form_balance }}</td>
                    <td class="text-center">{{ item.old_request.pi_value }}</td>
                    <td class="text-center">{{ item.old_request.supplier }}</td>
                    <td class="text-center">{{ item.old_request.get_payment_type_display }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_no }}</td>
                    <td class="text-center">{{ item.btb_lc.tenor }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.opening_date }}</td>
                    <td class="text-center">{{ item.btb_lc.value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_amendments }}</td>
                    <td class="text-center">{{ item.pi_transfer_status }}</td>
                    <td class="text-center">{{ item.old_parent_budget }}</td>
                    <td class="text-center">{{ item.old_request.remarks }}</td>
                </tr>
            {% endfor %}
            <tr class="fw-bold">
                <td class="text-center" colspan="3"><strong>Subtotal:</strong></td>
               <td class="text-center"><strong>{{grand_lend_to_other_file}}</strong></td>
            </tr>
        <tr><td class="text-center fw-bold" colspan="18"><strong>From other File</strong></td></tr>
   
           
            {% for item in order_wise_btb_other_file_obj_form %}
                <tr>
                    <td class="text-center">{{ forloop.counter }}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.good_description}}</td>
                    <td class="text-center">{{ item.old_request.backlog_budget_costing.costing_value }}</td>
                    <td class="text-center">{{ item.value }}</td>
                    <td class="text-center">{{ form_balance }}</td>
                    <td class="text-center">{{ item.old_request.pi_value }}</td>
                    <td class="text-center">{{ item.old_request.supplier }}</td>
                    <td class="text-center">{{ item.old_request.get_payment_type_display }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_no }}</td>
                    <td class="text-center">{{ item.btb_lc.tenor }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.opening_date }}</td>
                    <td class="text-center">{{ item.btb_lc.value|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                    <td class="text-center">{{ item.btb_lc.lc_value.total_amendments }}</td>
                    <td class="text-center">{{ item.pi_transfer_status }}</td>
                    <td class="text-center">{{ item.old_parent_budget }}</td>
                    <td class="text-center">{{ item.old_request.remarks }}</td>
                </tr>
            {% endfor %}
            <tr class="fw-bold">
                <td class="text-center" colspan="3"><strong>Subtotal:</strong></td>
               <td class="text-center"><strong>{{grand_lend_from_other_file}}</strong></td>
            </tr>
    
    </tbody>
</table>

</div>
</div>
</div>
{% endif %} 
  
  
  {% 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 type=text/javascript>

    var load_order_no_url = "{% url 'ajax_order_no_load_from_parent_file' %}"
    
    $(document).ready(function() {
      $("#id_parent_file").select2();
    });
    $(document).ready(function() {
      $("#id_type").select2();
    });
    $(document).ready(function() {
      $("#id_order_no").select2();
    });
  
    $("#id_parent_file").change(function () {
      var branchId = $(this).val();  
      $.ajax({                       
        url: load_order_no_url,
        
        data: {
          'parent_file_id': branchId   
        },
        success: function (data) { 
          $("#id_order_no").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('calculation_report');
      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 || ('Calculation report.' + (type || 'xlsx')));
    }

    function printDiv(divName) {
      var printContents = document.getElementById(divName).innerHTML;
      var originalContents = document.body.innerHTML;
    
      document.body.innerHTML = printContents;
      window.print();
      document.body.innerHTML = originalContents;
    }
  </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>
  
{% endblock JS%}