{% extends "base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% block title %}
  <title>SalarySheets Report</title>
{% endblock title %}
{% load widget_tweaks %}
{% block Style %}

{{form.media}}
<style>
  .right{
    text-align: right !important;
  }
</style>
{% endblock Style %}

{% block MainContent %}


<div class="contents">
  <div class="table-header bg-white">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h3> Salary Summary Report</h3>
          </div>
        </div>
      </div>
    </div>
    {% comment %} {% if request.user.is_superuser == True %}
    {% include 'report_app/payroll_report/super_admin_forms.html' %}
    {% endif %}


{% endcomment %}
    {% 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-3 fw-bold">
                  {{search_form.branch|as_crispy_field }}
                </div> 
                
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.month|as_crispy_field }}
                </div> 
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.year|as_crispy_field }}
                </div> 
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.status|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'  %}
    {% include 'report_app/salary_summary_report/branch_admin_form.html' %}
    {% 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> 

              {% comment %} <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>   {% endcomment %}
             
                
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.month|as_crispy_field }}
                </div> 
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.year|as_crispy_field }}
                </div> 
                <div class="col-md-2 fw-bold">
                  {{year_month_wise_form.status|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>
</div>




<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>
{% if item_list %}

  <div class="tables table-responsive" >
    <div id="employee-payroll-salary-report-table-pdf">
      <div>
        <h3 style = 'text-align: center'>{{ branch.sister_organization }}</h3>
        <h5 style = 'text-align: center'>{{ branch }}</h5>
        <h6 style = 'text-align: center'>{{ branch.address_details }}</h6>
      </div>
      <h3>Salary Summary 
         <small style = 'font-size: 15px; float: right'>{% if department %} {{department}} {% endif %} {% if designation %}  &nbsp - &nbsp {{designation}}{% endif %}</small> </h4> <small style = 'font-size: 15px; float: right; padding-right: 0px;'>{{year}} &nbsp-&nbsp {{month}}</small></h3> 
    
      <table class="table  table-hover" id="salary_summary">
        <thead>
          <tr>
            <th class="text-center">SL No</th>
            <th class="">Department</th>
            <th class="">Manpower</th>
            <th class="">Gross</th>
            <th class="">Deduction</th>
            <th class="">Att. Bonus</th>
            <th class="">Payable Salary</th>
            <th class="">OT Hour</th>
            <th class="text-center">OT Amount</th>
            <th class="text-center">EL Amount</th>
            <th class="text-center">Night</th>
            <th class="text-center">Tiffin</th>
            <th class="text-center">Tax</th>
            <th class="text-center">Lunch</th>
            <th class="text-center">Payable Total Tk</th>

           
            
          </tr>
        </thead>
        <tbody>
         {% for item in item_list %}
        
        <tr>
            <td class="text-center">{{ forloop.counter }}</td>
            <td class="">{{item.Department}}</td>
            <td class="">{{item.manpower}}</td>
            <td class="">{{item.dept_gross}}</td>
            <td class="">{{item.dept_deduct}}</td>
            <td class="">{{item.Attendance_Bonus}}</td>
            <td class="">{{item.total_payable_taka_attendance_bonus}}</td>
            <td class="">{{item.OT_Hour|floatformat:2}}</td>
            <td class="">{{item.Overtime_Payable_Taka}}</td>
            <td class="">{{item.el_amount}}</td>
            <td class="">{{item.night_bonus}} </td>
            <td class=""> {{item.tiffin_bill}}</td>
            <td class=""> {{item.tax}}</td>
            <td class="">{{item.lunch}}</td>
            <td class="">{{item.total_payable_taka}}</td>
          </tr>
          {% endfor %} 
          
          <tr>
            <td class="fw-bold"  colspan = "2" > Total</td>
            <td class="fw-bold">{{grand_manpower}}</td>
            <td class="fw-bold">{{grand_gross}}</td>
            <td class="fw-bold">{{grand_deduct}}</td>
            <td class="fw-bold">{{grand_attendance_bonus}}</td>
            <td class="fw-bold">{{grand_total_payable_taka_attendance_bonus}}</td>
            <td class="fw-bold">{{grand_ot_hour|floatformat:2}}</td>
            <td class="fw-bold">{{grand_ot_taka}}</td>
            <td class="fw-bold">{{grand_total_el}}</td>
            <td class="fw-bold">{{grand_night}} </td>
            <td class="fw-bold"> {{grand_tiffin}}</td>
            <td class="fw-bold"> {{grand_tax}}</td>
            <td class="fw-bold">{{grand_lunch}}</td>
            <td class="fw-bold">{{grand_payable_taka}}</td>
           
            
          </tr>
          <tr>
            <td class="fw-bold"  colspan = "2" > Total Manpower</td>
            <td class="fw-bold">{{grand_total_employee}}</td>
            <td class="fw-bold" colspan = "2">Running Employee</td>
            <td class="fw-bold">{{grand_total_running_employee}}</td>
            <td class="fw-bold" colspan = "2">New Employee</td>
            <td class="fw-bold">{{grand_total_new_employee}}</td>
            <td class="fw-bold" colspan = "2">Leftee Employee</td>

            <td class="fw-bold">{{grand_total_leftee_employee}}</td>
            <td class="fw-bold" colspan = "2">Resing Employee</td>
            <td class="fw-bold">{{grand_total_resing_employee}} </td>
          </tr>
        
          


        </tbody>
      </table>
    </div>
  </div>
</div>

{% endif %}



{% endblock MainContent %}
{% block meassage %}
                 
{% 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>
  $( document ).ready(function() {    
    $('select').select2();
});
  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' %}"

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

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

{% endblock JS%}