{% extends "base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load custom_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;
  }
  .rowhight{
    height:5px !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"> 
           Monthly Absent Summary Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
                {{form.mother_organization|as_crispy_field}}
            </div>
              <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">
              {{form.department|as_crispy_field}}
            </div>
            
          </div>
          <div class="row">
            <div class="col-md-3">
              {{form.designation|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.work_place|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 == '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"> 
            Monthly Absent Summary 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">
              {{form.department|as_crispy_field}}
            </div>
              <div class="col-md-3">
              {{form.designation|as_crispy_field}}
            </div>
          </div>
          <div class="row">
            <div class="col-md-3">
              {{form.work_place|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"> 
            Monthly Absent Summary Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
                {{form.branch|as_crispy_field}}
            </div>

            <div class="col-md-3">
              {{form.department|as_crispy_field}}
            </div>
              <div class="col-md-3">
              {{form.designation|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.work_place|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 == '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"> 
            Monthly Absent Summary Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
              {{form.department|as_crispy_field}}
            </div>
              <div class="col-md-3">
              {{form.designation|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.work_place|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 department_temp  %}
<div class="table-area mt-2">
  <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'>{{ company_info.name_en }}</h3>
          <h5 style = 'text-align: center'>{{ company_info.address_details }}</h5>
          <p style = 'text-align: right'><span>{{report_month}}</span> <span>{{report_year}}{{eid_bonus_list.created_date}}</span></p>
        </div>
        <h3> Monthly Absent Summary 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="tbl_absent_export">
          <thead>
            <tr>
              <th>ID</th>
              <th>Employee Name</th>
              <th>join Date </th>
              <th>Designation</th>
              <th>Status</th>
              <th>Shift</th>
              <th>T.Absent</th>
              <th>Remarks</th>
            </tr>
          </thead>
          <tbody>

          {% for department_list in department_temp  %}
            {% if department_list.0.0  %}
            <td colspan="2" style = 'text-align: center'>{{department_list.0.0}}</td>
            <td colspan="2" style = 'text-align: center'> {% if department_list.0.1 %} Line:{{department_list.0.1.working_place}} {% else %} Line: {% endif %}</td>
            {% endif %}
          {% for employee in department_list  %}

                 
            

              {% if forloop.last %}
              {% if employee != 0 %}
              <tr>
                
                  <td></td>
                  <td colspan="6"> <span class="fw-bold">Total Employee: &nbsp;{{department_list.0.9}} </span>&nbsp; &nbsp;<span class="fw-bold">Total Present: &nbsp;{{forloop.counter|subtract:total_present}}</span></td>
                  
                  <td colspan="2" class="fw-bold">sub Total: {{employee}}</td>
               </tr>
               {% endif %}
               {% else %}

               <tr>
                <td>{{ employee.2 }}</td>
                <td>{{ employee.3 }}</td>
                <td>{{ employee.4}}</td>
                 <td>{{ employee.5}}</td>
                
                <td style="text-transform:capitalize;">{{ employee.6}}</td>
                
                
                <td>{{ employee.7}}</td>
                <td>{{ employee.8}}</td>
                <td></td>

              </tr>
              {% endif %} 
              {% endfor %}

              {% endfor %}

          </tbody>
      </table>
  </div>
</div>
{% endif %}

{% endblock MainContent %}
{% block meassage %}
{% include 'notifications/notifications.html' %}         
{% endblock meassage %}
{% block JS %}
<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' %}"
  
  $("#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);  
        }
    }); 
  });
</script>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></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");

      $(document).ready(function() {
    $("#id_work_place").select2({
     
    });
  });
    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('tbl_absent_export');
            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 || ('Today_Absent_report.' + (type || 'xlsx')));
        }
</script>
{% endblock JS %}