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

{% block title %}
<title>Consignment Report</title>
{% endblock title %}
{% block Style %}
<style>
  .search {
    width: 94%!important;
  }
  .cus-btn {
    background: #FC6736;
  }
  .contents {
    padding: 10px;
  }
  .right {
    text-align: right;
  }
  .table > :not(caption) > * > * {
    padding: 7px 10px;
    border: 1px solid #ddd;
    font-size: 14px;
    line-height: 1.5;
    color: #374767;
}
  thead tr, th, td {
  font-size: 10px !important;
  border:1px solid black !important;
  }
  tbody tr, th, td {
  font-size: 10px !important;
  border:1px solid black !important;
  }

.table {
  width: 100% !important;
}
@media print {
    #deptList2 table {
        width: 100% !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">
  <div class="table-area">
  <!-- table-title -->
  <div class="table-title">
    <div class="row">
      <div class="col-md-4">
        <div class="depertment-name">
          <h4>Consignment 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.file|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 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" id="employee-attendance-general-report-table-pdf">
      <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>Consignment Report - {{file}}</U></h5>
      <div class="row">
        <div class="col-lg-6">
            <table class="table table-striped table-hover" style="color: black;">
              <thead>
                <tr>
                  <th>File Number</th>
                  <td colspan="7">{{file}}</td>
                </tr>
                <tr>
                  <th>Buyer Name</th>
                  <td  colspan="7">{% for item in buyer_name_list %} {{item}},{% endfor %}</td>
                </tr>
                <tr>
                  <th>Contract/LC No.</th>
                  <td colspan="7">{% for item in contract_lc_no %}{{item}},{% endfor %}</td>
                 
                </tr>
                <tr>
                  <th>Order Qnty</th>
                  <td>{{total_qty}} pcs</td>
                </tr>
                <tr>
                  <th>LC/Count. Value</th>
                  <td colspan="7">${{lc_count_value}}</td>
                </tr>
                <tr>
                  <th>Bank COMM. 2%</th>
                  <td colspan="7">${{bank_com_2|floatformat:2}}</td>
                </tr>
                <tr>
                  <th>75 % of LC Value</th>
                  <td colspan="7">${{lc_value_75|floatformat:2}}</td>
                </tr>
                <tr>
                  <th>Balance of 75%</th>
                  <th colspan="7">${{balance_75|floatformat:2}}</th>
                </tr>
                <tr>
                  <th>Equipment DT.</th>
                  <td colspan="7">{{min_date}} to {{max_date}}</td>
                </tr>
                <tr>
                  <th>BTB Open Value</th>
                  <th colspan="7">${{total_lc_value |floatformat:2}}</th>
                </tr>
              </thead>
            </table>
        </div>
        <div class="col-lg-4">
          {% comment %} <caption>MDR: HASAN</caption> {% endcomment %}
          <table class="table table-striped table-hover mt-2" style="color: black;">
            <thead>
              <tr>
                <th>Contract Value</th>
                <th></th>
              </tr>
              <tr>
                <th>Replace Value</th>
                <th></th>
              </tr>
              <tr>
                <th>Shipped Value</th>
                <th></th>
              </tr>
              <tr>
                <th>Balance</th>
                <th></th>
              </tr>
              <tr>
                <th>Payment Received</th>
                <th></th>
              </tr>
              <tr>
                <th>Payment Due</th>
                <th></th>
              </tr>
              <tr>
                <th>Payment Term:</th>
                <td></td>
              </tr>
            </thead>
          </table>
        </div>
        <div class="col-lg-2">
          {% comment %} <h6>Date: March 11, 2024</h6> {% endcomment %}
          <h4 class="fw-bold">Current File</h4>
        </div>
      </div>
      <div class="tables table-responsive" style="width: 100% !important;" id="deptList2">
        <table class="table table-striped table-hover" style="width: 100% !important;">
            <thead>
                <tr>
                    <th colspan="8" class="text-center">BTB Position</th>
                    <th colspan="14" class="text-center">Consignment &amp; Payment Position</th>
                </tr>
                <tr>
                    <th rowspan="2" class="text-center">SL <br>NO.</th>
                    <th rowspan="2" class="text-center">Name of Supplier</th>
                    <th rowspan="2" class="text-center">LC Tenor</th>
                    <th colspan="2" class="text-center">BTB LC</th>
                    <th rowspan="2" class="text-center">Foreign/ <br>Local</th>
                    <th rowspan="2" class="text-center">BTB LC Value in $</th>
                    <th rowspan="2" class="text-center">BL Date</th>
                    <th rowspan="2" class="text-center">Rcvd Consi. Qty</th>
                    <th rowspan="2" class="text-center">Docs Rcvd Dt.</th>
                    <th rowspan="2" class="text-center">Goods Rcvd Dt.</th>
                    <th rowspan="2" class="text-center">Rcvd Consign. Value in $</th>
                    <th rowspan="2" class="text-center">Balance Cons. Value</th>
                    <th colspan="2" class="text-center">Acceptance</th>
                    <th colspan="2" class="text-center">Maturity</th>
                    <th colspan="1" class="text-center">Due</th>
                    <th colspan="2" class="text-center">Payment</th>
                    <th rowspan="2" class="text-center">Balance Payment</th>
                    <th rowspan="2" class="text-center">Remarks</th>
                </tr>
                <tr>
                    <th class="text-center">Number</th>
                    <th class="text-center">Date</th>
                    <th class="text-center">Value</th>
                    <th class="text-center">Date</th>
                    <th class="text-center">Value</th>
                    <th class="text-center">Date</th>
                    <th class="text-center">Date</th>
                    <th class="text-center">Value</th>
                    <th class="text-center">Date</th>
                </tr>

                <!-- Data Start -->
                {% for data in report_list %}
                <tr>
                    <td class="text-center">{{forloop.counter}}</td>
                    <td class="text-center">{{data.old_payment_pi.supplier}}</td>
                    <td class="text-center">{{data.btb_lc.tenor}}</td>
                    <td class="text-center">{{data.btb_lc.lc_no}}</td>
                    <td class="text-center">{{data.btb_lc.opening_date|default:"N/A"}}</td>
                    <td class="text-center">{{ data.btb_lc.get_lc_type_display }}</td>
                    <td class="text-center">${{ data.btb_lc.value|floatformat:2}}</td>
                    <td class="text-center">{{ data.bl_date|default:"N/A" }}</td>
                    <td class="text-center">{{data.rcv_con_qty}}</td>
                    <td class="text-center">{{data.doc_rcv_date|default:"N/A"}}</td>
                    <td class="text-center">{{data.good_rcv_date|default:"N/A"}}</td>
                    <td class="text-center">${{data.rcv_con_value}}</td>
                    <td class="text-center">${{data.balance|floatformat:2}}</td>
                    <td class="text-center">${{data.acceptance_value|floatformat:2|default:0}}</td>
                    <td class="text-center">{{data.acceptance_date|default:"N/A"}}</td>
                    <td class="text-center">${{data.maturity_value|floatformat:2|default:0}}</td>
                    <td class="text-center">{{data.maturity_date|default:"N/A"}}</td>
                    <td class="text-center">{{data.due_date|default:"N/A"}}</td>
                    <td class="text-center">${{data.payment_value|floatformat:2|default:0}}</td>
                    <td class="text-center">{{data.payment_date|default:"N/A"}}</td>
                    <td class="text-center">${{data.btb_lc.lc_value.balance|floatformat:2 | floatformat:2|default:0}}</td>
                    <td class="text-center">{{data.remarks|default:"N/A"}}</td>
                </tr>
                {% endfor %}
                <!-- Data End -->
                <tr>
                    <th></th>
                    <th></th>
                    <th colspan="3" class="text-center">Total BTB Value</th>
                    <th></th>
                    <th class="text-center">${{grand_total_lc_value| floatformat:2}}</th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th></th>
                    <th class="text-center">${{total_consignment_value| floatformat:2}}</th>
                    <th class="text-center">${{total_request_value| floatformat:2}}</th>
                    <th class="text-center">${{total_acceptance_value| floatformat:2}}</th>
                    <th></th>
                    <th class="text-center">${{total_maturity_value| floatformat:2}}</th>
                    <th></th>
                    <th></th>
                    <th class="text-center">${{tatal_payment_value| floatformat:2}}</th>
                    <th></th>
                    <th></th>
                    <th></th>
                </tr>
                <tr>
                    <th colspan="5" class="text-center">Total BTB Opened Value</th>
                    <th></th>
                    <th class="text-center">${{grand_total_lc_value|floatformat:2}}</th>
                    <th></th>
                    <th colspan="14" class="text-center">${{total_value| floatformat:2}}</th>
                </tr>
            </thead>
        </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_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' %}"
    var load_work_place_url = "{% url 'work-place-load' %}"
    
    $(document).ready(function() {
      $("#id_file").select2();
    });
  
    $("#id_branch").change(function () {
      var branchId = $(this).val();  
      $.ajax({                       
        url: load_work_place_url,
        
        data: {
          'branch': branchId   
        },
        success: function (data) { 
          $("#id_work_place").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('consignment_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 || ('Consignment_report.' + (type || 'xlsx')));
          }
  </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%}