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

{% block title %}
<title>Calculation 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: 10px !important;
  border:1px solid black !important;
  }
  tbody tr, th, td {
  font-size: 10px !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>Calculation 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 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>
        <h5 style = 'text-align: center'>File wise import position of {{file.beneficiary_company}}</h5>
        <h6 style = 'text-align: center'>{{file.beneficiary_company.branch.branch.address_details}}</h6>
      </div>
      <h5 class="fw-bold m-3 text-center"><u>Calculation Report - {{file}}</U></h5>

        <div class="row">

        <div class="col-md-10">
        <table class="table table-hover ">
              
              <thead>
                <tr>
                  <th colspan=2 style="text-align:center; background:#FFF1D5;">File Summary</th>
                </tr>
                <tr>
                  <th class="text-center">Particulars</th>
                  <th class="text-center">Value (USD)</th>
                </tr>
              </thead>
              <tbody>
                {% for item in summary_data %}
                  {% if forloop.first %}
                    <tr>
                      <td class="fw-bold">Lien Contract Value</td>
                      <td class="value">${{ file_value|floatformat:2 }}</td>
                    </tr>
              
                    <tr>
                      <td class="fw-bold">2% Commission</td>
                      <td class="value">${{ commission_2_percent|floatformat:2 }}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">Ac. File Value</td>
                      <td class="value">${{ actual_file_value|floatformat:2 }}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">{{file.allowed_btb_lc_percent}}% Value</td>
                      <td class="value">${{ item.file_btb_lc_allowed_value|floatformat:2 }}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">Replaced Value/Total Budget Value</td>
                      <td class="value">{{file.replacement_details.total_replaced}} / ${{ file.total_budget_in_file.total_budget|floatformat:2 }}</td>
                    </tr>
                    
                    <tr>
                      <td class="fw-bold">Fabric 70% Value</td>
                      <td class="value"> ${{ item.fabric_lc_value|floatformat:2 }}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">Accessories 30% Value</td>
                      <td class="value">${{ item.acc_lc_value|floatformat:2 }}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">Fabric BTB Open</td>
                      <td class="value" style="color: {% if item.fabric_lc_value > grand_order_wise_btb_financed_fabric %}green{% else %}red{% endif %};">${{ grand_order_wise_btb_financed_fabric|floatformat:2 }}</td>
                    </tr>
 
                    <tr>
                      <td class="fw-bold">Accessories BTB Open</td>
                      <td class="value" style="color: {% if item.acc_lc_value > grand_order_wise_btb_financed_acc %}green{% else %}red{% endif %};">${{ grand_order_wise_btb_financed_acc|floatformat:2 }}</td>
                    </tr>
                    {% comment %} <tr>
                      <td class="fw-bold">Percent</td>
                      <td class="value percent">{{ per|floatformat:2 }}%</td>
                    </tr> {% endcomment %}
                    <tr>
                      <td class="fw-bold">Local</td>
                      <td class="value">${{item.total_lc_value_local_sum|floatformat:2}}</td>
                    </tr>
                    <tr>
                      <td class="fw-bold">Cash</td>
                      <td class="value">${{grand_total_cash_payment|floatformat:2}}</td>
                    </tr>

                    <tr class="total">
                      <td class="fw-bold">Total BTB</td>
                      <td class="value">${{ item.total_btb_opened|floatformat:2 }}&nbsp; &nbsp;&nbsp; &nbsp;  ({{ per|floatformat:2 }}%)</td>
                    </tr>
                    <tr class="total">
                      <td class="fw-bold">Total Expense  (Total BTB + Cash)</td>
                      <td class="value">${{ item.total_expense|floatformat:2 }}&nbsp; &nbsp;&nbsp; &nbsp;  ({{ per_2|floatformat:2 }}%)</td>
                    </tr>
                    <tr class="total">
                      <td class="fw-bold">Balance   ({{file.allowed_btb_lc_percent}}% Value - Total Expense)</td>
                      <td class="value">${{ item.btb_balance|floatformat:2 }}</td>
                    </tr>
                    <tr class="total">
                      <td class="fw-bold">Available Balance( {{file.allowed_btb_lc_percent}}% Value - Total Expense - Balance of Costing) </td>
                      <td class="value" style="background-color: {% if avl_bal_allowed_btb_total_expense_costing_balance > 1  %} #aee8ae {% else %} #ffa8a8 {% endif %}">${{ avl_bal_allowed_btb_total_expense_costing_balance|floatformat:2 }} ( {{ item.btb_balance|floatformat:2 }} - {{order_wise_grand_total_balance|floatformat:2}} )</td>
                    </tr>
                    {% if request.user.is_superuser == True %}
                    <tr class="total">
                      <td class="fw-bold">Cal. Total BTB</td>
                      <td class="value">${{grand_total_order_wise_btb_open_this_file|floatformat:2}}</td>
                    </tr>
                    {% endif %}
                  {% endif %}
                {% endfor %}
              </tbody>
            </table>
        </div>
        <div class="col-md-4">
        </div>
        </div>
        <div class="row">


          <div class="col-md-10">

            <table class="table table-hover " >
              <thead>
                  <tr style="background:#bfc9ca" class="text-center">  
                    <th colspan="4" style="background:#FFF1D5">Order Info</th>
                    <th colspan="10" style="background:#FFF1D5">Costing</th>
                    <th colspan="3" style="background:#BDDDE4"> Financed BTB</th>
                    <th colspan="4" style="background:#9EC6F3"> Lending </th>
                    <th colspan="2" rowspan="1"></th> 
                  </tr>
                  <tr>
                      <th style="background:#FFF1D5">Order No</th>
                      
                      <th style="background:#FFF1D5">Buyer</th>
                      <th style="background:#FFF1D5">MDR</th>

                      <th style="background:#FFF1D5">Budget Value</th>
                      <th style="background:#FFF1D5">CM</th>
                      <th style="background:#FFF1D5">Commercial & Others</th>
                      <th style="background:#FFF1D5">Material Budget</th>
                      <th style="background:#FFF1D5">Fabrics</th>
                       <th style="background:#FFF1D5">Accessories</th>
                      <th style="background:#FFF1D5"> Fabric BTB  </th>
                      <th style="background:#FFF1D5"> Accessories BTB</th>
                      <th style="background:#FFF1D5"> Total BTB</th>
                      <th style="background:#FFF1D5">Balance</th>
                      <th style="background:#FFF1D5">Self BTB Finance</th>
                      <th style="background:#BDDDE4">Fabric </th>
                      <th style="background:#BDDDE4">Accessories</th>
                      <th style="background:#BDDDE4">Total</th>
                      <th style="background:#9EC6F3">To Other Odr
                        (S.F)</th>
                      <th style="background:#9EC6F3">From Other Odr
                        (S.F)</th>
                      <th style="background:#9EC6F3">To Other File</th>
                      <th style="background:#9EC6F3">From other File</th>
                      <th >Cash Payment</th> 
                      <th >Balance</th> 
                     

                  
                  </tr>
              </thead>
              <tbody>
                  {% for item in summary_data %}
                      <tr>
                          <td style="background:#FFF1D5">{{ item.order_no.order_no }}</td>
                          <td style="background:#FFF1D5">{{ item.order_no.buyer_display.buyer|default:"N/A" }}/Agent : {{ item.order_no.buyer_display.agent|default:"N/A" }}</td>
                          <td style="background:#FFF1D5">{{item.order_no.mdr_display.mdr|default:"N/A"}}/ {{item.order_no.mdr_display.team|default:"N/A"}}</td>
                          <td style="background:#FFF1D5">{{ item.order_no.order_summary.total_sc_value|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.order_no.order_summary.total_cm|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.order_no.order_summary.total_commercial_other_cost|floatformat:2 }}</td>

                          <td style="background:#FFF1D5">{{ item.costing_value|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.fabrics_value|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.accessories_value|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.fabrics_btb_value|floatformat:2 }}</td>
                         
                          <td style="background:#FFF1D5">{{ item.accessories_btb_value|floatformat:2 }}</td>
                          <td style="background:#FFF1D5">{{ item.order_wise_total_btb_opened|floatformat:2 }}</td> 
                          <td style="background:#FFF1D5">{{ item.order_wise_balance|floatformat:2 }}</td> 
                          <td style="background:#FFF1D5">{{item.order_wise_self_costing_value|floatformat:2}}</td> 
                          <td style="background:#BDDDE4">{{item.order_wise_btb_financed_fabric|floatformat:2}}</td> 
                          <td style="background:#BDDDE4">{{item.order_wise_btb_financed_acc|floatformat:2}}</td> 
                          <td style="background:#BDDDE4">{{item.order_wise_btb_financed|floatformat:2}}</td> 
                          <td style="background:#9EC6F3">{{ item.order_wise_lend|floatformat:2 }}</td> 
                          <td style="background:#9EC6F3">{{ item.order_wise_lend_from|floatformat:2 }}</td> 
                          <td style="background:#9EC6F3">{{ item.order_wise_value_other_file|floatformat:2 }}</td> 
                          <td style="background:#9EC6F3">{{ item.order_wise_value_other_file_form|floatformat:2 }}</td> 
                          <td>{{item.order_wise_total_payment|floatformat:2}}</td> 
                          <td>{{item.balance|floatformat:2}}</td> 
                          {% comment %} {% if forloop.first %} {% endcomment %}
                          {% comment %} <td colspan="3" rowspan="{{ summary_data|length }}" class="align-middle">
                             <ul style="list-style-type: disc; padding-left: 20px; line-height: 1.6; margin: 0;">
                              <li><span class="fw-bold">File Value: </span> ${{ file_value|floatformat:2 }}</li>
                              <li><span class="fw-bold">2% Commission : </span> ${{ commission_2_percent|floatformat:2 }}</li>
                              <li><span class="fw-bold">Ac.File Value: </span> ${{ actual_file_value|floatformat:2 }}</li>
                              <li><strong class="fw-bold">75% Value: </strong> ${{ item.file_btb_lc_allowed_value|floatformat:2 }}</li>
                              <li><strong class="fw-bold">Fabric 70% Value:</strong> ${{ item.fabric_lc_value|floatformat:2 }}</li>
                              <li style="color: {% if item.fabric_lc_value > grand_order_wise_btb_financed_fabric %}green{% else %}red{% endif %};"><strong class="fw-bold">Fabric BTB Open:</strong> ${{ grand_order_wise_btb_financed_fabric|floatformat:2 }}</li>
                              <li><strong class="fw-bold">Accessories 30% Value:</strong> ${{ item.acc_lc_value|floatformat:2 }}</li>

                              <li style="color: {% if item.acc_lc_value > grand_order_wise_btb_financed_acc %}green{% else %}red{% endif %};"><strong>Accessories BTB Open:</strong> ${{ grand_order_wise_btb_financed_acc|floatformat:2 }}</li>

                              <li><span class="fw-bold">Percent: </span> {{ per|floatformat:2 }}%</li>
                              <li><span class="fw-bold">Local: </span> ${{item.total_lc_value_local_sum|floatformat:2}}</li>
                              <li><span class="fw-bold">Total BTB : </span> ${{ item.total_btb_opened|floatformat:2 }}</li>
                              <li><span class="fw-bold"> Cal. Total BTB : </span> ${{grand_total_order_wise_btb_open_this_file|floatformat:2}}</li>
                            </ul>
                          </td>
                        
                        {% endif %} {% endcomment %}
                      </tr>
                  {% endfor %}
                  <tr class="fw-bold">
                    <td style="background:#FFF1D5">Grand Total </td>
                    <td style="background:#FFF1D5"></td>
                    <td style="background:#FFF1D5"></td>
                    <td style="background:#FFF1D5">${{ file.total_budget_in_file.total_budget|floatformat:2 }}</td>
                    <td style="background:#FFF1D5">${{ file.total_budget_in_file.total_cm|floatformat:2 }}</td>
                    <td style="background:#FFF1D5"></td>
                    <td style="background:#FFF1D5">${{total_costing|floatformat:2}}</td>
                    <td style="background:#FFF1D5">${{fabric_total_costing|floatformat:2}}</td>
                    <td style="background:#FFF1D5">${{accessories_total_costing|floatformat:2}}</td>
                    <td style="background:#FFF1D5">${{total_fabric_btb_opened_value|floatformat:2}}</td>
                   
                    <td style="background:#FFF1D5">${{total_accessories_btb_opened_value|floatformat:2}}</td>
                    <td style="background:#FFF1D5">${{grand_total_btb_opend|floatformat:2}}</td>
                    <td style="background:#FFF1D5">${{grand_order_wise_balance|floatformat:2}}</td>
                    <td style="background:#FFF1D5">{{grand_order_wise_self_costing_value|floatformat:2}}</td>
                    <td style="background:#BDDDE4">{{grand_order_wise_btb_financed_fabric|floatformat:2}}</td>
                    <td style="background:#BDDDE4">{{grand_order_wise_btb_financed_acc|floatformat:2}}</td>
                    <td style="background:#BDDDE4">{{grand_order_wise_btb_financed|floatformat:2}}</td>
                    <td style="background:#9EC6F3">{{grand_lend_to_other_order_same|floatformat:2}}</td>
                    <td style="background:#9EC6F3">{{grand_lend_to_from_order_same |floatformat:2}}</td>
                    <td style="background:#9EC6F3">{{grand_lend_to_other_file |floatformat:2}}</td>
                    <td style="background:#9EC6F3">{{grand_lend_from_other_file |floatformat:2}}</td>
                    <td>{{grand_total_cash_payment|floatformat:2}}</td>
                    <td>{{order_wise_grand_total_balance|floatformat:2}}</td>

                    {% comment %} <td colspan=""></td> {% endcomment %}
           
                    {% comment %} <td></td>
                    <td></td>
                    <td></td> {% endcomment %}
                  </tr>
              </tbody>
          </table>
        </div>
      
        </div>
        <table class="table table-hover fixed" id="calculation_report">
          <thead>
            <tr style="background:#E8F9FF" >
              <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">Remarks</th>
            </tr>
          </thead>
          <tbody>
            {# First render all Fabric grouped by order #}

            {% if fabric_group %}
            {% for order, items in fabric_group %}
              {% if items %}
                <tr><td colspan="17"  class='fw-bold'><strong>Order No: {{ order.order_no }} — Fabric  &ensp;&ensp;&ensp;  Buyer: {{ order.buyer_display.buyer|default:"N/A" }}/Agent : {{ order.buyer_display.agent|default:"N/A" }} &ensp;&ensp;&ensp; MDR : {{order.budget.created_by_employee|default:"N/A"}} / {{order.budget.team.responsible_person|default:"N/A"}} </strong></td></tr>
                
                {% regroup items by costing as costing_groups %}

                {% for group in costing_groups %}
                  {% with group.list|length as group_len %}
                    {% for item in group.list %}
                      <tr>
                        <td class="text-center">{{ order.order_no }}.{{ forloop.parentloop.counter }}.{{ forloop.counter }}</td>
                
                        {% if forloop.first %}
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.good_description }}</td>
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.costing_value }}</td>
                        {% endif %}
                        <td class="text-center" style="background-color: {% if item.btb_status %}#fff3cd{% endif %};">
                          {% if item.btb_lc %}
                              {{ item.btb_lc.btb_lc.lc_value.total_lc_value}}
                          {% else %}
                              N/A
                          {% endif %}
                       </td>
                        {% if forloop.first %}
                        <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.balance|floatformat:"2" }}</td>
              
                      {% endif %}
                        <td class="text-center">{{ item.backlog_pi.pi_value }}</td>
                        <td class="text-center">{{ item.backlog_pi.supplier }}</td>
                        <td class="text-center">{{ item.backlog_pi.get_payment_type_display }}</td>
                
                        {% if item.btb_lc %}
                          {% comment %} <td class="text-center">{{ item.btb_lc.btb_lc.lc_no }}</td> {% endcomment %}

                          <td class="text-center" style="background-color: {% if item.other_btb_status %}#fff3cd{% endif %};">
                            {% if item.btb_lc %}
                            {{ item.btb_lc.btb_lc.lc_no }}
                            {% else %}
                                N/A
                            {% endif %}
                         </td>


                          <td class="text-center">{{ item.btb_lc.btb_lc.tenor }}</td>
                          <td class="text-center">{{ item.btb_lc.value }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.opening_date }}</td>
                          <td class="text-center">{{ item.btb_lc.old_request.pi_value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.pi_btb_balance|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_amendments }}</td>
                          <td class="text-center">{{ item.btb_lc.pi_transfer_status }}</td>
                        {% elif item.cash_payment %}
                        <td class="text-center" colspan="8">{{item.cash_payment.cash_payment.get_payment_mode_display}} &nbsp;&nbsp;&nbsp; {{item.cash_payment.cash_payment.value_tk|floatformat:"2"}} &nbsp;&nbsp;&nbsp; Rate:({{item.cash_payment.cash_payment.conversion_rate}})</td>
                        <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% else %}
                          <td class="text-center" colspan="8">N/A</td>
                          <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% endif %}
                      </tr>
                    {% endfor %}
                  {% endwith %}
                {% endfor %}
              {% endif %}
            {% endfor %}
            
            {% comment %} <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_fabric_costing|floatformat:"4" }}</strong></td>
              <td class="fw-bold"><strong>{{total_fabric_btb_opened|floatformat:"4"}}</strong></td>
              <td class="fw-bold"><strong>{{total_fabric_btb_balance|floatformat:"4"}}</strong></td> 
              <td class="fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_fabric_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_fabric_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr> {% endcomment %}
          {% endif %}
          {% if accessories_group %}
            {% for order, items in accessories_group %}
              {% if items %}
                <tr><td colspan="17"  class='fw-bold'><strong>Order No: {{ order.order_no }} — Accessories &ensp;&ensp;&ensp; Buyer: {{ order.buyer_display.buyer|default:"N/A" }}/Agent : {{ order.buyer_display.agent|default:"N/A" }} &ensp;&ensp;&ensp; MDR : {{order.budget.created_by_employee|default:"N/A"}} / {{order.budget.team.responsible_person|default:"N/A"}} </strong></td></tr>
                
    
                {% regroup items by costing as costing_groups %}

                {% for group in costing_groups %}
                  {% with group.list|length as group_len %}
                    {% for item in group.list %}
                      <tr>
                        <td class="text-center">{{ order.order_no }}.{{ forloop.parentloop.counter }}.{{ forloop.counter }}</td>
                
                        {% if forloop.first %}
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.good_description }}</td>
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.costing_value }}</td>
                        {% endif %}
                
                        <td class="text-center" style="background-color: {% if item.btb_status %}#fff3cd{% endif %};">
                          {% if item.btb_lc %}
                              {% comment %} {{ item.btb_lc.value }} {% endcomment %}
                              {{ item.btb_lc.btb_lc.lc_value.total_lc_value}}
                          {% else %}
                              N/A
                          {% endif %}
                       </td>
                    
                        {% if forloop.first %}
                        <td class="text-center" rowspan="{{ group_len }}">{{ item.balance|floatformat:"2" }}</td>
              
                      {% endif %}
                        <td class="text-center">{{ item.backlog_pi.pi_value }}</td>
                        <td class="text-center">{{ item.backlog_pi.supplier }}</td>
                        <td class="text-center">{{ item.backlog_pi.get_payment_type_display }}</td>
                
                        {% if item.btb_lc %}
                          {% comment %} <td class="text-center">{{ item.btb_lc.btb_lc.lc_no }}</td> {% endcomment %}
                          <td class="text-center" style="background-color: {% if item.other_btb_status %}#fff3cd{% endif %};">
                            {% if item.btb_lc %}
                            {{ item.btb_lc.btb_lc.lc_no }}
                            {% else %}
                                N/A
                            {% endif %}
                         </td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.tenor }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.opening_date }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_amendments }}</td>
                          <td class="text-center">{{ item.btb_lc.pi_transfer_status }}</td>
                        {% elif item.cash_payment %}
                        <td class="text-center" colspan="8">{{item.cash_payment.cash_payment.get_payment_mode_display}} &nbsp;&nbsp;&nbsp; {{item.cash_payment.cash_payment.value_tk|floatformat:"2"}}  &nbsp;&nbsp;&nbsp; Rate:({{item.cash_payment.cash_payment.conversion_rate}})</td>
                        <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% else %}
                          <td class="text-center" colspan="8">N/A</td>
                          <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% endif %}
                
                        
                      </tr>
                    {% endfor %}
                  {% endwith %}
                {% endfor %}
              {% endif %}
            {% endfor %}
            
            {% comment %} <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_accessories_costing|floatformat:"4" }}</strong></td>
              <td class="fw-bold"><strong>{{total_accessories_btb_opened|floatformat:"4"}}</strong></td> {% endcomment %}
              {% comment %} <td class="fw-bold"><strong>{{total_accessories_btb_balance|floatformat:"4"}}</strong></td> {% endcomment %}
              {% comment %} <td class="fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_accessories_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_accessories_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr> {% endcomment %}
          {% endif %}
          {% if wash_group %}
            {% for order, items in wash_group %}
              {% if items %}
                <tr><td colspan="17" class='fw-bold'><strong>Order No: {{ order.order_no }} — Wash</strong></td></tr>
                
                 
                {% regroup items by costing as costing_groups %}

                {% for group in costing_groups %}
                  {% with group.list|length as group_len %}
                    {% for item in group.list %}
                      <tr>
                        <td class="text-center">{{ order.order_no }}.{{ forloop.parentloop.counter }}.{{ forloop.counter }}</td>
                
                        {% if forloop.first %}
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.good_description }}</td>
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.costing_value }}</td>
                        {% endif %}
                
                        <td class="text-center" style="background-color: {% if item.btb_status %}#fff3cd{% endif %};">
                          {% if item.btb_lc %}
                          {{ item.btb_lc.btb_lc.lc_value.total_lc_value}}
                          {% else %}
                              N/A
                          {% endif %}
                       </td>
                    
                        {% if forloop.first %}
                        <td class="text-center" rowspan="{{ group_len }}">{{ item.balance|floatformat:"2" }}</td>
              
                      {% endif %}
                        <td class="text-center">{{ item.backlog_pi.pi_value }}</td>
                        <td class="text-center">{{ item.backlog_pi.supplier }}</td>
                        <td class="text-center">{{ item.backlog_pi.get_payment_type_display }}</td>
                
                        {% if item.btb_lc %}
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_no }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.tenor }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.opening_date }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_amendments }}</td>
                          <td class="text-center">{{ item.btb_lc.pi_transfer_status }}</td>
                        {% elif item.cash_payment %}
                        <td class="text-center" colspan="8">{{item.cash_payment.cash_payment.get_payment_mode_display}} &nbsp;&nbsp;&nbsp; {{item.cash_payment.cash_payment.value_tk|floatformat:"2"}}  &nbsp;&nbsp;&nbsp; Rate:({{item.cash_payment.cash_payment.conversion_rate}})</td>
                        <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% else %}
                          <td class="text-center" colspan="8">N/A</td>
                          <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% endif %}
                      </tr>
                    {% endfor %}
                  {% endwith %}
                {% endfor %}
              {% endif %}
            {% endfor %}
            
            <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_wash_costing|floatformat:"4" }}</strong></td>
              <td class="fw-bold"><strong>{{total_wash_btb_opened|floatformat:"4"}}</strong></td>
              {% comment %} <td class="fw-bold"><strong>{{total_wash_btb_balance|floatformat:"4"}}</strong></td> {% endcomment %}
              <td class="fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_wash_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_wash_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr>
          {% endif %}
          {% if embroidery_group %}
            {% for order, items in embroidery_group %}
              {% if items %}
                <tr><td colspan="17"  class='fw-bold'><strong>Order No: {{ order.order_no }} — Embroidery</strong></td></tr>
                
              
                {% regroup items by costing as costing_groups %}

                {% for group in costing_groups %}
                  {% with group.list|length as group_len %}
                    {% for item in group.list %}
                      <tr>
                        <td class="text-center">{{ order.order_no }}.{{ forloop.parentloop.counter }}.{{ forloop.counter }}</td>
                
                        {% if forloop.first %}
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.good_description }}</td>
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.costing_value }}</td>
                        {% endif %}
                
                        <td class="text-center" style="background-color: {% if item.btb_status %}#fff3cd{% endif %};">
                          {% if item.btb_lc %}
                          {{ item.btb_lc.btb_lc.lc_value.total_lc_value}}
                          {% else %}
                              N/A
                          {% endif %}
                       </td>
                    
                        {% if forloop.first %}
                        <td class="text-center" rowspan="{{ group_len }}">{{ item.balance|floatformat:"2" }}</td>
              
                      {% endif %}
                        <td class="text-center">{{ item.backlog_pi.pi_value }}</td>
                        <td class="text-center">{{ item.backlog_pi.supplier }}</td>
                        <td class="text-center">{{ item.backlog_pi.get_payment_type_display }}</td>
                
                        {% if item.btb_lc %}
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_no }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.tenor }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.opening_date }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_amendments }}</td>
                          <td class="text-center">{{ item.btb_lc.pi_transfer_status }}</td>
                        {% elif item.cash_payment %}
                        <td class="text-center" colspan="8">{{item.cash_payment.cash_payment.get_payment_mode_display}} &nbsp;&nbsp;&nbsp; {{item.cash_payment.cash_payment.value_tk|floatformat:"2"}}  &nbsp;&nbsp;&nbsp; Rate:({{item.cash_payment.cash_payment.conversion_rate}})</td>
                        <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% else %}
                          <td class="text-center" colspan="8">N/A</td>
                          <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% endif %}
                      </tr>
                    {% endfor %}
                  {% endwith %}
                {% endfor %}
              {% endif %}
            {% endfor %}
            
            <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_embroidery_costing|floatformat:"4" }}</strong></td>
              <td class="fw-bold"><strong>{{total_embroidery_btb_opened|floatformat:"4"}}</strong></td>
              {% comment %} <td class="fw-bold"><strong>{{total_embroidery_btb_balance|floatformat:"4"}}</strong></td> {% endcomment %}
              <td class="fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_embroidery_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_embroidery_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr>
          {% endif %}
          {% if print_group %}
            {% for order, items in print_group %}
              {% if items %}
                <tr><td colspan="17"  class='fw-bold'><strong>Order No: {{ order.order_no }} — Print</strong></td></tr>
                
                 
                {% regroup items by costing as costing_groups %}

                {% for group in costing_groups %}
                  {% with group.list|length as group_len %}
                    {% for item in group.list %}
                      <tr>
                        <td class="text-center">{{ order.order_no }}.{{ forloop.parentloop.counter }}.{{ forloop.counter }}</td>
                
                        {% if forloop.first %}
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.good_description }}</td>
                          <td class="text-center" rowspan="{{ group_len }}">{{ item.costing.costing_value }}</td>
                        {% endif %}
                
                        <td class="text-center" style="background-color: {% if item.btb_status %}#fff3cd{% endif %};">
                          {% if item.btb_lc %}
                          {{ item.btb_lc.btb_lc.lc_value.total_lc_value}}
                          {% else %}
                              N/A
                          {% endif %}
                       </td>
                        {% if forloop.first %}
                        <td class="text-center" rowspan="{{ group_len }}">{{ item.balance|floatformat:"2" }}</td>
              
                      {% endif %}
                        <td class="text-center">{{ item.backlog_pi.pi_value }}</td>
                        <td class="text-center">{{ item.backlog_pi.supplier }}</td>
                        <td class="text-center">{{ item.backlog_pi.get_payment_type_display }}</td>
                
                        {% if item.btb_lc %}
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_no }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.tenor }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_lc_value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.opening_date }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.value|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.balance|floatformat:"4" }}</td>
                          <td class="text-center">{{ item.btb_lc.btb_lc.lc_value.total_amendments }}</td>
                          <td class="text-center">{{ item.btb_lc.pi_transfer_status }}</td>
                        {% elif item.cash_payment %}
                        <td class="text-center" colspan="8">{{item.cash_payment.cash_payment.get_payment_mode_display}} &nbsp;&nbsp;&nbsp; {{item.cash_payment.cash_payment.value_tk|floatformat:"2"}}  &nbsp;&nbsp;&nbsp; Rate:({{item.cash_payment.cash_payment.conversion_rate}})</td>
                        <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% else %}
                          <td class="text-center" colspan="8">N/A</td>
                          <td class="text-center">{{ item.backlog_pi.remarks }}</td>
                        {% endif %}
                      </tr>
                    {% endfor %}
                  {% endwith %}
                {% endfor %}
              {% endif %}
            {% endfor %}
            
            <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_print_costing|floatformat:"4" }}</strong></td>
              <td class="fw-bold"><strong>{{total_print_btb_opened|floatformat:"4"}}</strong></td>
              {% comment %} <td class="fw-bold"><strong>{{total_print_btb_balance|floatformat:"4"}}</strong></td> {% endcomment %}
              <td class="fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_print_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_print_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr>

          {% endif %}

          </tbody>
 
            <thead>
            <tr style="background:#E8F9FF">
            <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">Remarks</th>
            </tr>
            </thead>
            <tbody>
            {% if form_object %}
            {% for item in form_object %}
            <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 }} <br>{{item.old_parent_budget}}</td>
            <td class="text-center">{{ item.old_request.remarks }}</td>
            </tr>
            {% endfor %}
            {% comment %} <tr>
              <td colspan="2" class="fw-bold"><strong>Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ total_form_costing_value|floatformat:"4" }}</strong></td>
              <td class="fw-bold text-center"><strong>{{ total_form_btb_opened }}</strong></td> {% endcomment %}
              {% comment %} <td class="text-center fw-bold"><strong>{{ total_form_balance|floatformat:"4" }}</strong></td> {% endcomment %}
              {% comment %} <td class="text-center fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ total_form_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ total_form_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr> {% endcomment %}
            {% endif %}
            {% comment %} <tr>
              <td colspan="2" class="fw-bold"><strong>Grand Total:</strong></td>
              <td class="text-center fw-bold"><strong>{{ grand_total_costing_value|floatformat:"4" }}</strong></td>
              <td class="fw-bold text-center"><strong>{{ grand_total_btb_opened|floatformat:"4" }}</strong></td> {% endcomment %}
              {% comment %} <td class="text-center fw-bold"><strong>{{ grand_total_balance|floatformat:"4" }}</strong></td> {% endcomment %}
              {% comment %} <td class="text-center fw-bold"><strong></strong></td>
              <td class="text-center fw-bold"><strong>{{ grand_total_pi_value|floatformat:"4" }}</strong></td>
              <td colspan="6"></td>
              <td class="text-center fw-bold"><strong>{{ grand_total_btb_value|floatformat:"4" }}</strong></td>
              <td colspan="4"></td>
            </tr> {% endcomment %}

            </tbody>
            </table>

            {% for obj in wrong_pis_obj %}
            
              {{obj.btb_lc.parent_file}},{{obj.btb_lc}},{{obj.old_request}}<br>
              
            {% endfor %}
    </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('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%}