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

{% block title %}
<title>Old Budget Costing And PI</title>
{% endblock title %}

{% block Style %}
<style>
  .search {
    width: 94%!important;
  }
  .cus-btn {
    background: #FC6736;
    color: white;
    padding: 4px 8px;
    border-radius: 4px;
    text-decoration: none;
    display: inline-block;
  }
  .cus-btn:hover {
    background: #e95a2e;
    color: white;
  }
  thead th, thead td, tbody th, tbody td {
    font-size: 13px !important;
    border: 1px solid black !important;
  }
  thead tr:first-child th {
    position: sticky;
    top: 0;
    background: #f8f9fa;
    z-index: 3;
  }
  thead tr:nth-child(2) th {
    position: sticky;
    top: 38px;
    background: #f8f9fa;
    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>Budget Costing And PI Information</h4>
          </div>
        </div>
      </div>
    </div>

    <div class="tables table-responsive" id="deptList">
      <div>
        <h3 class="text-center">{{ file.beneficiary_company }}</h3>
        <h6 class="text-center">{{ file.beneficiary_company.branch.branch.address_details }}</h6>
      </div>
      <h5 class="fw-bold m-3 text-center"><u> {{ order_no }}</u></h5>
      {% if order_no.budget == None %}
      <div class="mb-3 text-end">
    <a href="{% url 'old-budget-costing-create' file.id order_no.id %}" class="cus-btn">+ Add New Costing</a> 
      </div>
    {% endif %}
      {% for material_type, items in grouped_data.items %}
        

        <table class="table  table-hover">
          <thead class="table-light">
            <tr>
              <th colspan=8 style="background-color:black; color:white; text-align: center">{{ material_type|title }}</th>
            </tr>
            <tr>
              <th rowspan="2">Good Description</th>
              <th rowspan="2">Supplier</th>
              <th rowspan="2">Costing Value</th>
              <th rowspan="2">PI Total</th>
              <th rowspan="2">Balance</th>
              <th colspan="2" class="text-center">Corresponding PIs</th>
              <th rowspan="2">Action</th>
            </tr>
            <tr>
              <th>PI No</th>
              <th>PI Value</th>
            </tr>
          </thead>
          <tbody>
            {% for item in items %}
              {% if item.pi_qs %}
                {% for pi in item.pi_qs %}
                  <tr>
                    {% if forloop.first %}
                      <td rowspan="{{ item.pi_qs|length }}">{{ item.costing.good_description }}</td>
                      <td rowspan="{{ item.pi_qs|length }}">{{ item.costing.supplier }}</td>
                      <td rowspan="{{ item.pi_qs|length }}">
                        ${{ item.costing.costing_value|floatformat:"4" }}
                        {% if order_no.budget == None  %}
                        <br><br>
                          <ul class="action">
                                    <li>
                                        <a type="button" href="{% url 'old-budget-costing-update' item.costing.id %}" class="edit-click">
                                            <i class="fa fa-pencil" aria-hidden="true"></i>
                                        </a>
                                    </li>
                                    <li>
                                        <a onclick="SweetDelete(event, this.href)" href="{% url 'fnb_backlog_budget_costing_delete' item.costing.id file.id order_no.id %}">
                                            <i class="fa fa-trash" aria-hidden="true"></i>
                                        </a>
                                    </li>
                                     <a href="{% url 'old-pi-create' file.id order_no.id %}" class="cus-btn btn-sm btn-success">
                              <i class="fa fa-plus"></i>PI 
                          </a>
                          </ul>
                        
                         
                         {% endif %} 
                      </td>
                      <td rowspan="{{ item.pi_qs|length }}">${{ item.pi_value|floatformat:"4" }}</td>
                      <td rowspan="{{ item.pi_qs|length }}">${{ item.balance|floatformat:"4" }}</td>
                    {% endif %}
                    <td>{{ pi }}</td>
                    <td>${{ pi.pi_value|floatformat:"4" }}</td>
                    <td>
                      {% if order_no.budget == None  %}
                       <ul class="action">
                                    <li>
                                        <a type="button" href="{% url 'old-pi_upload-update' pi.id %}" class="edit-click">
                                            <i class="fa fa-pencil" aria-hidden="true"></i>
                                        </a>
                                    </li>
                                    <li>
                                        <a onclick="SweetDelete(event, this.href)" href="{% url 'fnb_new_backlog_pi_delete' pi.id file.id order_no.id %}">
                                            <i class="fa fa-trash" aria-hidden="true"></i>
                                        </a>
                                    </li>
                          </ul>
                          {% endif %}
                
                    </td>
                  </tr>
                {% endfor %}
              {% else %}
                <tr>
                  <td>{{ item.costing.good_description }}</td>
                  <td>{{ item.costing.supplier }}</td>
                  <td>
                    ${{ item.costing.costing_value|floatformat:"4" }}
                     {% if order_no.budget == None  %}
                    <br><br>
                    
                     <ul class="action">
                                    <li>
                                        <a type="button" href="{% url 'old-budget-costing-update' item.costing.id %}" class="edit-click">
                                            <i class="fa fa-pencil" aria-hidden="true"></i>
                                        </a>
                                    </li>
                                    <li>
                                        <a onclick="SweetDelete(event, this.href)" href="{% url 'fnb_backlog_budget_costing_delete' item.costing.id file.id order_no.id %}">
                                            <i class="fa fa-trash" aria-hidden="true"></i>
                                        </a>
                                    </li>
                                     <a href="{% url 'old-pi-create' file.id order_no.id %}" class="cus-btn btn-sm btn-success">
                              <i class="fa fa-plus"></i>PI 
                          </a>
                          </ul>
                        {% endif %}
                  </td>
                  <td>${{ item.pi_value|floatformat:"4" }}</td>
                  <td>${{ item.balance|floatformat:"4" }}</td>
                  <td colspan="2" class="text-center">No PIs found</td>
                  <td>

                  </td>
                </tr>
              {% endif %}
            {% endfor %}
          </tbody>
        </table>
      {% endfor %}
    </div>
  </div>
</div>

{% endblock MainContent %}

{% block meassage %}
  {% include 'notifications/notifications.html' %}
{% endblock meassage %}

{% block JS %}
<script>
  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
    
      }
    })
  }
</script>
{% endblock JS %}