{% extends "finance_and_banking_base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load widget_tweaks %}
{% block title %}
<title>Export Upcoming Bill Collection</title>
{% endblock title %}
{% block Style %}
<style>
  .disabled-link {
    pointer-events: none;
    opacity: 0.5;
    cursor: not-allowed;
  }
    .search {
    width: 94%!important;
  }
  .cus-btn {
    background: #FC6736;
  }
  a.cus-btn.excel:hover {
    color: white;
  }
  thead tr, th, td {
    font-size: 13px !important;
  }
  tbody tr, th, td {
    font-size: 13px !important;
  }
  div#upcoming-exports-table_length {
      margin-bottom: 37px;
  }
  div#upcoming-exports-table_filter {
      margin-bottom: 37px;
  }

  .table-container{
    position: relative;
    overflow-x: auto;
    overflow-y: auto;
    height: 100vh;
  }
  thead tr, td, th {
    font-size: 13px !important;
  }
  table.table.table-hover.fixed tr th {
    color: black;
  }

  thead tr:first-child th {
    position: sticky;
    top: -16px;
    background-color: #fff;
    z-index: 3; 
  }
  .fixed thead tr:nth-child(2){
    position: sticky;
    top: 17px;
    z-index: 4;
  }

  thead tr:nth-child(2) th:nth-child(-n+6) {
    position: sticky;
    left: 0;
    background-color: #fff;
    z-index: 1;
  }
  .table > :not(caption) > * > * {
    padding: 7px 10px;
    border: 1px solid dimgray;
    font-size: 13px;
    line-height: 1.5;
    }

  tbody td:nth-child(-n+6) {
    position: sticky;
    left: 0;
    background-color: #fff;
    z-index: 1;
  }
  thead tr:nth-child(2) th:nth-child(1),
  tbody td:nth-child(1) {
    left: 0%;
  }
  thead tr:nth-child(2) th:nth-child(2),
  tbody td:nth-child(2) {
    left: 2.5%;
  }
  thead tr:nth-child(2) th:nth-child(3),
  tbody td:nth-child(3) {
    left: 7.5%;
  }
  thead tr:nth-child(2) th:nth-child(4),
  tbody td:nth-child(4) {
    left: 13.42%;
  }
  thead tr:nth-child(2) th:nth-child(5),
  tbody td:nth-child(5) {
    left: 18.4%;
  }
  thead tr:nth-child(2) th:nth-child(6),
  tbody td:nth-child(6) {
    left: 23.8%;
  }

</style>

{% endblock Style %}

{% block MainContent %}
<meta name="csrf-token" content="{{ csrf_token }}">
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap4.min.css" />
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css" />
{% 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 Header -->
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h4 class='fw-bold' style='font-size: 17px; color: #1f7622;'>Export Upcoming Bill Collection Index &nbsp;&nbsp; {{ upcoming_export_request_obj|length }}</h4>
          </div>
        </div>
      </div>
    </div>
    <!-- Your Grouped Table -->
 
            <!-- Your Grouped Table -->
            <div class="tables table-responsive" id="deptList">
            <table id="upcoming-exports-table"  class="table table-hover mt-4">
            <thead>
              <tr>
                <th class="text-center">SL No</th>
                <th>File</th>
                <th>Budget</th>
                <th>Order Qty</th>
                <th>Value</th>
                <th>Shipped Qty</th>
                <th>Value</th>
                <th>Commercial</th>
                <th>FnB</th>
                <th>Action</th>
              </tr>
            </thead>
            <tbody>
            {% for export in upcoming_export_request_obj  %}
                <tr>
                  <td class="text-center">{{forloop.counter}}</td>
                  <td>{{ export.budget.file_name }}</td>
                  <td>{{ export.budget }}</td>
                  <td>{{ export.total_qty_value.total_gmt_qty }} pcs</td>
                  <td>${{ export.budget.total_qty_value.grand_total_value|floatformat:3 }}</td>

                  <td>{{export.shipped_qty}} pcs</td>
                  <td>$ {{export.shipped_value}}</td>
                  <td></td>
                  <td></td>
                  <td>
                    <ul class="action">
                        <li>
                          <a href="{% url 'export_bill_upcoming_details' export.id %}"> 
                   
                                <i aria-hidden="true" class="fa fa-eye"></i>
                          </a>
                        </li>
                    </ul>
                  </td>
                </tr>
            {% endfor %}
        </tbody>
      </table>
    </div>
    
  </div>
</div>


{% endblock MainContent %}
{% block meassage %}

{% include 'notifications/notifications.html' %}

{% endblock meassage %}

{% block JS %}
<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script type=text/javascript>
  var ajax_search_url = "{% url 'backlog_pi_search' %}"
  var redirect_url = "{% url 'backlog_pi_index' %}"
  $('select').select2();

  function SweetDelete(e,href){
    e.preventDefault()
    var self = $(this)
    Swal.fire({
      title: 'Are you sure?',
      text: "You won't be able to revert this!",
      icon: 'warning',
      showCancelButton: true,
      confirmButtonColor: '#3085d6',
      cancelButtonColor: '#d33',
      confirmButtonText: 'Yes, delete it!'
    }).then((result) => {
      if (result.isConfirmed) {
        Swal.fire(
          'Deleted!',
          'Your file has been deleted.',
          'success',
          
        )
        location.href = href
    
      }
    })
  }
  
  $("#searchFileSales").keypress(function (e) { 
    console.log('worked')
    if (e.keyCode == 13){
    $("#search-btn").click();
    }
  });
  $("#search-btn").click(function () { 
    console.log('worked')
    console.log($("#searchFileSales").val())
    if($("#searchFileSales").val())
      $.ajax({                       
      url: ajax_search_url,                   
      data: {
        'file_name': $("#searchFileSales").val()     
      },
      success: function (data) {   
        $("#piList").html(data);  
      }
    });
    else
    location.href = redirect_url
  });
</script>

{% if upcoming_export_request_obj %}
<script>
  $(document).ready(function() {
    $('#upcoming-exports-table').DataTable({
      "paging": false,
      "searching": true,
      "ordering": true,
      "info": false,
      "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ],
      "order": []
    });
  });
</script>
{% endif %}
{% endblock JS %}