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


{% 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;
  }
</style>

{% endblock Style %}

{% block MainContent %}
<div class="contents">
{% if request.user.is_superuser == True %}
<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"> 
          EL Payment  Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-4">
                {{form.mother_organization|as_crispy_field}}
            </div>
              <div class="col-md-4">
                {{form.sister_organization|as_crispy_field}}
            </div> 
            <div class="col-md-4">
                {{form.branch|as_crispy_field}}
            </div>
          </div>
          <div class="row">
            <div class="col-md-4">
              {{month_form.month|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>
{% endif %}
{% if request.user.user_type == 'Mother_Organization_admin' %}
<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"> 
          EL Payment  Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
              <div class="col-md-3">
                {{form.sister_organization|as_crispy_field}}
            </div> 
            <div class="col-md-3">
                {{form.branch|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{month_form.month|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{month_form.year|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>
{% endif %}
{% if request.user.user_type == 'Sister_Organization_admin' %}
<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"> 
          EL Payment  Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-4">
            {{form.branch|as_crispy_field}}
            </div>
            <div class="col-md-4">
              {{month_form.year|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>
{% endif %}
{% if request.user.user_type == 'Branch' %}
<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"> 
          EL Payment  Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-4">
              {{month_form.month|as_crispy_field}}
            </div> 
            <div class="col-md-4">
              {{month_form.year|as_crispy_field}}
            </div> 
            <div class="col-md-4">
              {{form.working_place|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>
{% endif %}
{% if department_temp %}
<div class="contents">
<div class="table-header">
  <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-payroll-salary-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" >
    <div id="employee-payroll-salary-report-table-pdf" id="page" >
      <div>
      </div>
      <table class="table table-striped table-hover" id="salary_sheet_report">
        <thead>
          <tr>
            <th class="text-center" colspan = "25" > <h3 style = 'text-align: center'>{{ company_info.name_en }} &nbsp &nbsp <small style = 'font-size: 15px;'> {% if line %}{{line.working_place}}
            {% endif %}</small></h3><br> <p style = 'font-size: 15px; text-align: center;margin-top:0px;'> EL Payment  Report <small style = 'font-size: 15px; float: right; padding-right: 0px;'>{{year}} &nbsp-&nbsp {{month}}</small></h3></p></th>
          </tr>
          <tr>
            <th>Employee Code</th>
            <th>Employee</th>
            <th>Joining Date</th>
            <th>Designation</th>
            <th>Basic</th>
            <th>HR</th>
            <th>Other</th>
            <th>Total Salary</th>
            <th>1-Day Salary</th>
            <th>Att</th>
            <th>Use of EL</th>
            <th>TTL Cur Yr EL</th>
            <th>TTL Cur Yr Amt</th>
            <th>Pre Yr EL</th>
            <th>Pre Yr Amt</th>
            <th>Toatl EL Amt</th>
            <th>Payable EL Amt</th>
            <th>TTL EL</th>
            <th>Balance EL</th>
            <th>Signature</th>
          </tr>
        </thead>
        <tbody>
          {% for department_list in department_temp  %}
              
          {% if department_list.0.0  %}
          <td colspan="2">{{department_list.0.0}}</td>
          {% endif %}
          {% if department_list.0.1  %}
                    
          {% for item in department_list.0 %}
          {% if forloop.counter == 1 %}
          {%else%}
            <tr>
            {% comment %} <td class="text-center">{{forloop.counter}}</td> {% endcomment %}
            <td>{{ item.1 }}</td>
            <td>{{ item.0 }}</td>
          
            <td>{{ item.2}}</td>
            <td>{{ item.3}}</td>
            <td>{{ item.4 | floatformat:2}}</td>
            <td>{{ item.5 | floatformat:2}}</td>
            <td>{{ item.6 | floatformat:0}}</td>
            <td>{{ item.7 | floatformat:0}}</td>
            <td>{{ item.8 | floatformat:2}}</td>
            <td>{{ item.9 | floatformat:2}}</td>
            <td>{{ item.10 | floatformat:2}}</td>
            <td>{{ item.11 | floatformat:2}}</td>
            <td>{{ item.12 | floatformat:2}}</td>
            <td>{{ item.13 | floatformat:2}}</td>
            <td>{{ item.14 | floatformat:2}}</td>
            <td>{{ item.15 | floatformat:2}}</td>
            <td>{{ item.16 | floatformat:2}}</td>
            <td>{{ item.17 | floatformat:2}}</td>
            <td>{{ item.18 | floatformat:2}}</td>
            <td> </td>
          </tr>
          {% if forloop.last %}
          
          <tr>
          
              <td colspan="12" class="text-center fw-bold">sub Total</td>
              {% comment %} <td></td>
              <td></td>
              <td></td>
              <td></td> {% endcomment %}
              
              <td class="text-center fw-bold"> {{department_list.1|floatformat:2}}</td>
              <td></td>
              <td class="text-center fw-bold">{{department_list.2 |floatformat:2}}</td>
              <td class="text-center fw-bold">{{department_list.3 |floatformat:2}}</td>
              <td class="text-center fw-bold">{{department_list.4 |floatformat:2}}</td>
              <td></td>
              <td></td>
              <td></td>
            
           </tr>
          {% endif %}
          {% endif %}

          {% endfor %}

          {% endif %}
          {% endfor %}
            <tr>
              
              <td colspan="12" class="text-center fw-bold">Grand Total</td>
              {% comment %} <td></td>
              <td></td>
              <td></td>
              <td></td> {% endcomment %}
              
              <td class="text-center fw-bold">{{grand_present_gross |floatformat:2}}</td>
              <td></td>
              <td class="text-center fw-bold">{{grand_increment_total |floatformat:2}}</td>
              <td class="text-center fw-bold">{{grand_increment_gross_total |floatformat:2}}</td>
              <td class="text-center fw-bold">{{grand_payable_total |floatformat:2}}</td>
              <td></td>
              <td></td>
              <td></td>
            
           </tr>
        </tbody>
      </table>
    </div>
  </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' %}"  

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