{% extends "base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% block title %}
  <title>Highest OT Holder Report</title>
{% endblock title %}
{% load widget_tweaks %}
{% block Style %}
<style>
  .right{
    text-align: right !important;
  }
</style>

{% endblock Style %}

{% block MainContent %}

<div class="contents">
  <div class="table-area">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h3>Highest OT Holder Report</h3>
          </div>
        </div>
      </div>
    </div>
    {% if request.user.is_superuser == True %}
    <form method="post" id="personForm" data-cities-url="" novalidate>
        {% csrf_token %}
        <div class="table-header">
          <div>
            <div class="row">
              <div class="col-md-4 fw-bold">
                {{search_form.mother_organization|as_crispy_field }}
              </div> 
              <div class="col-md-4 fw-bold">
                {{search_form.sister_organization|as_crispy_field }}
              </div> 
              <div class="col-md-4 fw-bold">
                {{search_form.branch|as_crispy_field }}
              </div> 
            </div>
            <div class="row">
              <div class="col-md-2 fw-bold">
                {{search_form.department|as_crispy_field }}
              </div> 
              <div class="col-md-2 fw-bold">
                {{search_form.designation|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{search_form.work_place|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.from_date|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.to_date|as_crispy_field }}
              </div>
              <div class="col-md-1" style="margin-top: 31px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
            </div>
          </div>
        </div>
      </form>
    {% endif %}

    {% if request.user.user_type == 'Mother_Organization_admin' %}
    <form method="post" id="personForm" data-cities-url="" novalidate>
        {% csrf_token %}
        <div class="table-header">
          <div>
            <div class="row">
              <div class="col-md-3 fw-bold">
                {{search_form.sister_organization|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{search_form.branch|as_crispy_field }}
              </div> 
    
              <div class="col-md-3 fw-bold">
                {{search_form.department|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{search_form.designation|as_crispy_field }}
              </div> 
            </div>
            <div class="row">
              <div class="col-md-3 fw-bold">
                {{search_form.work_place|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.from_date|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.to_date|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 31px;">
              <button type="submit" class="cus-btn">Show</button>
            </div>
            </div>
            
          </div>
        </div>
      </form>
    {% endif %}

    {% if request.user.user_type == 'Sister_Organization_admin' %}
    <form method="post" id="personForm" data-cities-url="" novalidate>
        {% csrf_token %}
        <div class="table-header">
          <div>
            <div class="row">
              <div class="col-md-4 fw-bold">
                {{search_form.branch|as_crispy_field }}
              </div> 
    
              <div class="col-md-4 fw-bold">
                {{search_form.department|as_crispy_field }}
              </div> 
              <div class="col-md-4 fw-bold">
                {{search_form.designation|as_crispy_field }}
              </div> 
            </div>
    
            <div class="row">
              <div class="col-md-3 fw-bold">
                {{search_form.work_place|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.from_date|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.to_date|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 31px;">
              <button type="submit" class="cus-btn">Show</button>
            </div>
            </div>
          </div>
        </div>
      </form>
    {% endif %}

    {% if request.user.user_type == 'Branch' or request.user.user_type == 'Regular' %}
    <form method="post" id="personForm" data-cities-url="" novalidate>
        {% csrf_token %}
        <div class="table-header">
          <div>
            <div class="row">
              <div class="col-md-3 fw-bold">
                {{search_form.department|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{search_form.designation|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{search_form.work_place|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.from_date|as_crispy_field }}
              </div> 
              <div class="col-md-3 fw-bold">
                {{form.to_date|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 31px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
            </div>
          </div>
        </div>
      </form>
    {% endif %}
    
</div>
{% if employee %}

<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 table-responsive" id="employee-attendance-general-report-table-pdf">
    <div>
      <h3 style = 'text-align: center'>{{ sister_organization }}</h3>
      <h5 style = 'text-align: center'>{{ branch }}</h5>
      <h6 style = 'text-align: center'>{{ branch.address_details }}</h6>
    </div>
    <h3>Highest OT Holder Report
      <small style = 'font-size: 15px; text-transform: capitalize;'>{% if department %}(<b>Department 
      </b> : {{department}})</small> {% endif %} {% if designation %} <small style = 'font-size: 15px; text-transform: capitalize;'>(<b>Designation</b> : {{designation}})</small> {% endif %}
      {% if month %} <small style = 'font-size: 15px; float: right'>{{month}} &nbsp-&nbsp {{year}}</small> {% endif %}</h3>
    <table class="table table-striped table-hover" id="employee_report" style="color:black">
        <thead>
          <tr>
       
            <th>Card No</th>
            <th>Joining Date</th>
            <th>Employee Name</th>
            <th> Gross Salary</th>
            <th>Department</th>
            <th>Designation</th> 
        
            <th>Work Place</th>
            <th>OT</th>
          </tr>
        </thead>
        <tbody style="color:black">
     
          <tr>
            <td>{%if employee.employee_code %}{{employee.employee_code}} {% else %} {{employee.auto_employee_code}} {% endif %}</td>
            <td>{{employee.joining_date}}</td>
            <td>{{employee.name_en}}</td>
            <td>{{employee.gross_salary}}</td>
            <td>{{employee.department}}</td>
            <td>{{employee.designation}}</td>

            <td>{{employee.working_place.working_place}}</td>
            <td>{{high_ot}}</td>
          </tr>
      
        </tbody>
    </table>
  </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_work_place").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('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 || ('employee_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%}