{% extends "finance_and_banking_base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% block title %}
<title>BTB LC Budget 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 %}
<div class="contents">

<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"> 
           BTB LC Budget Report
          </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|as_crispy_field}}
            </div> 
            
          </div>
          
        </div> 
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12" style="text-align: center;" >
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
</div>
</form>

{% if budget %}
<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'>{{ budget }}</h3>
            <h5 style = 'text-align: center'>{{ budget.finance_company }}</h5>
            <p style = 'text-align: center'><span>Mode of Price:&nbsp;{{budget.get_mode_of_price_display}}</span>&nbsp;&nbsp;&nbsp;&nbsp; <span> Team:&nbsp;{{budget.team}}</span></p>
          </div>
          <h3>BTB LC Budget 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 from_date %} <small style = 'font-size: 15px; float: right'>{{from_date}} &nbsp; to  &nbsp; {{to_date}}</small> {% endif %}</h3>
        <table class="table  table-striped table-hover" id="tbl_absent_export">
            <thead>
              <tr>
                <th class="text-center">SL No</th>
              
                <th>Supplier</th>
                <th>Tenor</th>
                <th>LC No</th>
                <th>LC Date</th>
                <th>LC Tenor</th>
                <th>Costing Value</th>
                {% comment %} <th>BTB Due</th> {% endcomment %}
                <th>BTB Value</th>
                <th>Amendment</th>
                <th>Total</th>
                <th>Total Paid Amount</th>
                <th>Due Balance</th>
              </tr>
            </thead>
            <tbody>
            <tr>
            <td colspan=14 class="text-center fw-bold">Fabrics</td>
            </tr>
            {% for item in fabric_lists %}
                <tr>
                  <td colspan=14>{{item.goods}}</td>
                </tr>

                {% for details in item.details %}
                 <tr>
                    <th class="text-center">{{forloop.counter}}</th>
                 
                    <td>{{details.supplier}}</td>
                    <td>{{details.pi.pi.tenor.terms_short_name}}</td>
                    <td>  {% if details.btb_lc %}
                            {{details.btb_lc}}
                          {% else %}
                            LC not opened
                    {% endif %}</td>
                    <td>{% if details.btb_lc %} {{details.btb_lc.opening_date}} {% else %} LC not opened {% endif %}  </td>
                      
                    <td>{% if details.btb_lc %} {{details.btb_lc.tenor.terms_short_name}} {% else %} LC not opened {% endif %}</td>
                    <td>${{details.pi.fabric_pi_value|floatformat:3}}</td>
                    {% comment %} <td>${{details.opening_due|floatformat:3}}</td> {% endcomment %}
                    <td>{% if details.btb_lc %} ${{details.btb_lc.value|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} {% for amendment in  details.lc_info.amendments %}
                      {{amendment.value}} +
                    {% endfor %} = {{details.lc_info.total_amendments}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.total_lc_value|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.paid_amount|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.balance|floatformat:3}} {% else %} LC not opened {% endif %}</td>

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

            <tr>
                <td colspan=14 class="text-center fw-bold">Accessories</td>
            </tr>
            {% for item in accessory_lists %}
                <tr>
                  <td colspan=14>{{item.goods}}</td>
                </tr>

                {% for details in item.details %}
                 <tr>
                    <th class="text-center">{{forloop.counter}}</th>
                 
                    <td>{{details.supplier}}</td>
                    <td>{{details.pi.pi.tenor.terms_short_name}}</td>
                    <td>  {% if details.btb_lc %}
                            {{details.btb_lc}}
                          {% else %}
                            LC not opened
                    {% endif %}</td>
                    <td>{% if details.btb_lc %} {{details.btb_lc.opening_date}} {% else %} LC not opened {% endif %}  </td>
                      
                    <td>{% if details.btb_lc %} {{details.btb_lc.tenor.terms_short_name}} {% else %} LC not opened {% endif %}</td>
                    <td>${{details.pi.accessory_pi_value|floatformat:3}}</td>
                    {% comment %} <td>${{details.opening_due|floatformat:3}}</td> {% endcomment %}
                    <td>{% if details.btb_lc %} ${{details.btb_lc.value|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} {% for amendment in  details.lc_info.amendments %}
                      {{amendment.value}} +
                    {% endfor %} = {{details.lc_info.total_amendments}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.total_lc_value|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.paid_amount|floatformat:3}} {% else %} LC not opened {% endif %}</td>
                    <td>{% if details.btb_lc %} ${{details.lc_info.balance|floatformat:3}} {% else %} LC not opened {% endif %}</td>

                 
                  
                </tr>
                
                {% endfor %}
         
        
               
            {% endfor %}
            </tbody>
        </table>
    </div>
  </div>
  {% endif %}
{% endblock MainContent %}
{% block meassage %}
{% include 'notifications/notifications.html' %}         
{% endblock meassage %}
{% block JS %}
<script type=text/javascript>
    var load_sister_organization_url = "{% url 'sister-organization-load' %}"
    var load_branch_organization_url = "{% url 'load-branch-organization' %}"
    var load_department_url = "{% url 'ajax-load-department' %}"
    var load_designation_url = "{% url 'ajax-load-designation' %}"  


    $(document).ready(function() {
      $("#id_budget").select2();
      $("#id_file").select2();
    });
</script>
<script>
  var ajax_budget_load_url = "{% url 'ajax_budget_main_load' %}"
$("#id_file").change(function () {
  var fileId = $(this).val();  
 console.log('fileId ',fileId )
  $.ajax({                       
    url: ajax_budget_load_url,
    
    data: {
      'fileID': fileId  
    },
    success: function (data) { 
      console.log(data);
      $("#id_budget").html(data);  
      }
  }); 
});
     
</script>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>

<!-- <script src="{% static 'js/payroll/intime_outtime_missing/create.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>
    $("#id_date").attr("type", "date");


    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 || ('btblc_budget_report.' + (type || 'xlsx')));
        }
</script>
{% endblock JS %}