{% extends "factory_base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% block title %}
  <title> Single Employee Attendance Report</title>
{% endblock title %}
{% load widget_tweaks %}
{% block Style %}
<style>
  .right{
    text-align: right !important;
  }
  .table1 td {
    line-height: 0.5 !important;
    font-size: 12px !important;
  }
  .table1 th {
    line-height: 0.5 !important;
    font-size: 12px !important;
  }
  .job_card{
    font-size: 12px !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>Single Employee Monthly Attendance Report</h3>
          </div>
        </div>
      </div>
    </div>
    {% if request.user.is_superuser == True %}
    {% include 'buyer_app/report_app/single_employee_monthly_report/super_admin_forms.html' %}
    {% endif %}

    {% if request.user.user_type == 'Mother_Organization_admin' %}
    {% include 'buyer_app/report_app/single_employee_monthly_report/mother_admin_forms.html' %}
    {% endif %}

    {% if request.user.user_type == 'Sister_Organization_admin' %}
    {% include 'buyer_app/report_app/single_employee_monthly_report/sister_admin_forms.html' %}
    {% endif %}

    {% if request.user.user_type == 'Branch' or request.user.user_type == 'Regular' %}
    {% include 'buyer_app/report_app/single_employee_monthly_report/branch_admin_forms.html' %}
    {% endif %}
</div>

{% if report_dict %}
<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>
<div class="table-area">
  <div class="tables table-responsive m-0 p-0" id="employee-attendance-general-report-table-pdf">
    <div>
      <h4 class="m-0 p-0" style = 'text-align: center'>{{ branch }}</h4>
      <h6 class="m-0 p-0"  style = 'text-align: center'>{{ branch.address_details }}</h6>
    </div>
    <div class="m-auto" style="width: 95%;">
        {% comment %} <div class="table-title"> {% endcomment %}
         <div class="row">
             <div class="col-md-12">
                <h5 class="job_card"><span class="fw-bold me-2">Name:  </span>{{employee.name_en}} &nbsp;<span class="fw-bold me-2">ID:</span>{{employee.employee_code}}&nbsp; <span class="fw-bold me-2">Line:</span>{{employee.work_place}}&nbsp; <span class="fw-bold me-2">Designation:</span>{{employee.designation}} &nbsp; <span class="fw-bold me-2">Department:</span>{{employee.department}}</h5>
                {% comment %} <h5><span class="fw-bold me-2">Employee Code:</span>{{employee.employee_code}}</h5>
                <h5><span class="fw-bold me-2">Designation:</span>{{employee.designation}}</h5> {% endcomment %}
             </div>
        {% comment %} </div> {% endcomment %}
    </div>

    <div>
      <h6 class="job_card">Single Employee Monthly Attendance Report {%if department %} <small style = 'font-size: 15px; text-transform: capitalize;'>(<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 %}</h6>
    </div>
    <table class="table table1 table-striped table-hover" id="single_employee_attendance_report">
        <thead>
          <tr>
            <th>Date</th>
            <th style = 'text-align: center'>Status</th>
            <th class="text-center">In Time</th>
            <th class="text-center">Out Time</th>
            <th class="text-center">Over Time</th>
            <th class="text-center">Working Hour</th>
            {% if request.user.is_superuser == True %}
            <th class="text-center">created_by </th>
            <th class="text-center">updated_by</th>
            <th class="text-center">input_method</th>
            {% endif %}
          </tr>
        </thead>
        <tbody>
        {% for report in report_dict %}
        
          <tr>
            <td  style="line-height:10px !important; " >{{report.1.date}}</td>
            <td class="text-center">{{report.1.status}}</td>
            <td class="text-center">{{report.1.in_time |time:'h:i a'}}</td>
            <td class="text-center">{{report.1.out_time |time:'h:i a'}}</td>
            {% if employee.over_time == 'Eligible' %} 
            <td class="text-center">{{report.1.over_time}}</td>
            {% else %}
             <td class="text-center"></td>
            {% endif %}
            <td class="text-center">{{report.1.Working_time}}</td>
            {% if request.user.is_superuser == True %}
            <td class="text-center">{{report.1.created_by}}</td>
            <td class="text-center">{{report.1.updated_by}}</td>
            <td class="text-center">{{report.1.input_method}}</td>
            {% endif %}
          </tr>
        {% endfor %}
        
        <tr>
            
            <td colspan="5" class="fw-bold text-center"><b> Present : {{present}} <b> &nbsp;  &nbsp; <b> Leave : {{total_leave}} <b> &nbsp;  &nbsp; Holiday:  {{total_holiday}}<b> &nbsp;  &nbsp;<b> Absent:  {{total_absent}}<b> &nbsp;  &nbsp; <b><b>Total Present:  {{total_present}}<b></td>
            <td  class="text-center fw-bold">Total Over Time: 
                  {% if employee.over_time == 'Eligible' %} 
                  {{total_OT}}
                  {% else %}
                  0.0
                  {% endif %}

             </td>
            {% if request.user.is_superuser == True %}
            <td colspan="3"> </td>
            {% endif %}
        </tr>

        <tr>
            {% if request.user.is_superuser == True %}
            <td colspan="4" class="text-bold">CL : {% for date in leave_type_date.CL %} {{date}}, {% endfor %}</td>
            <td colspan="5" class="text-bold"> SL : {% for date in leave_type_date.SL %} {{date}}, {% endfor %}</td>
            {% else %}
            <td colspan="3" class="text-bold">CL : {% for date in leave_type_date.CL %} {{date}}, {% endfor %}</td>
            <td colspan="3" class="text-bold"> SL : {% for date in leave_type_date.SL %} {{date}}, {% endfor %}</td>
            {% endif %}
        </tr>
        <tr>
            {% if request.user.is_superuser == True %}
            <td colspan="4" class="text-bold">ML : {% for date in leave_type_date.ML %} {{date}}, {% endfor %}</td>
            <td colspan="5" class="text-bold"> OL : {% for date in leave_type_date.OL %} {{date}}, {% endfor %} </td>
            {% else %}
            <td colspan="3" class="text-bold">ML : {% for date in leave_type_date.ML %} {{date}}, {% endfor %}</td>
            <td colspan="3" class="text-bold"> OL : {% for date in leave_type_date.OL %} {{date}}, {% endfor %} </td>
            {% endif %}
        </tr>
        <tr>
            {% if request.user.is_superuser == True %}
            <td colspan="4" class="text-bold">Unpaid Leave : {% for date in leave_type_date.UL %} {{date}}, {% endfor %}</td>
            <td colspan="5" class="text-bold"> EL : {% for date in leave_type_date.EL %} {{date}}, {% endfor %} </td>
             {% else %}
            <td colspan="3" class="text-bold">Unpaid Leave : {% for date in leave_type_date.UL %} {{date}}, {% endfor %}</td>
            <td colspan="3" class="text-bold"> EL : {% for date in leave_type_date.EL %} {{date}}, {% endfor %} </td>
            {% endif %}
        </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_employee_url = "{% url 'designation-wise-employee-load' %}"
  var load_emp = "{% url 'employee-load' %}"
  

  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('single_employee_attendance_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 || ('Daily_Attendance_report.' + (type || 'xlsx')));
        }
</script>

<script src="{% static 'js/report_app/global_dependency_search/include_employee.js' %} "></script>
<script src="{% static 'js/report_app/general_attendance_report/general_attendance_report.js' %} "></script>

{% endblock JS%}