{% 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;
  }
  th.salary_th{
    width:20px !important;
    font-size: 12px !important;
    padding:8px !important;
    line-height: 13px !important;
    color:black !important;
  }
  td.salaty_td{
     width:20px !important;
    font-size: 12px !important;
    padding:8px !important;
    line-height: 13px !important;
    color:black !important;
  }
  th.salary_th1{
    font-size: 8px !important;
    padding:0px !important;
    line-height: 5px !important;
    color:black !important;
  }

  @media print {
    footer {
      position: absolute;
      vertical-align: text-bottom;
    }
      .page-break {
    display: block;
    page-break-before: always;
  }
  }
  tr {page-break-inside: avoid;}
</style>
{% endblock Style %}

{% block MainContent %}


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

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

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

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

{% if salary_sheets %}
<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>
        <h3 style = 'text-align: center'>{{ sister_organization }}</h3>
        {% comment %} <h5 style = 'text-align: center'>{{ branch }}</h5>
        <h6 style = 'text-align: center'>{{ branch.address_details }}</h6> {% endcomment %}
        <p style = 'font-size: 15px; text-align: center;'>Salary Sheet Report <small style = 'font-size: 15px; float: right; padding-right: 0px;'>{{year}} &nbsp-&nbsp {{month}}</small></h3></p>
      </div>
      {% comment %} <h3> <small style = 'font-size: 15px; text-align: center;'>Salary Sheet Report</small>
      <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>  {% endcomment %}
      
      <table class="table table-striped table-hover" id="salary_sheet_report">
        <thead>
          <tr>  
            <th class="text-center" colspan = "8" ></th>
            <th class="text-center" colspan = "10" >S &nbsp &nbsp A &nbsp &nbsp L &nbsp &nbsp A &nbsp &nbsp R &nbsp &nbsp Y</th>
            <th class="text-center" colspan = "3">Over Time</th>
            <th class="text-center" colspan = "3"></th>
          </tr>
          <tr>
            <th class="text-center salary_th">Code <br><br> SL No</th>
            <th class="text-center salary_th">Name <br><br> Joining Date</th>
            <th class="text-center salary_th">Gra- <br>de</th>
            <th class="text-center salary_th">Designation</th>
            <th class="text-center salary_th">TTL Day <br> Pr,Day</th>
            <th class="text-center salary_th">FR <br><br> GH</th>
            <th class="text-center salary_th">CL <br> ML <br> SL</th>
            <th class="text-center salary_th">EL <br> OL <br> UL</th>
            <th class="text-center salary_th">Basic</th>
            <th class="text-center salary_th">HR</th>
            <th class="text-center salary_th">Food</th>
            <th class="text-center salary_th">Conve - <br>yance</th>
            <th class="text-center salary_th">Medical</th>
            <th class="text-center salary_th">Gross Salary</th>
            <th class="text-center salary_th">Inc.Amt <br> Arrear</th>
            <th class="text-center salary_th">Abs-ence-day</th>
            <th class="text-center salary_th">Absent-Penalty amount</th>
            <th class="text-center salary_th">Payable Tk <br> Att.Bonus</th>
            <th class="text-center salary_th">Hours</th>
            <th class="text-center salary_th">Rate</th>
            <th class="text-center salary_th">Payable Tk</th>
            {% comment %} <th class="text-center salary_th"></th> {% endcomment %}
            <th class="text-center salary_th"> Total Salary </th>
            <th class="text-center salary_th1">Stamp</th>
            <th class="text-center salary_th">Signature</th>
          </tr>
        </thead>
        <tbody>
          {% for salary_sheet in salary_sheets%}
            <tr>
                <td class="salaty_td">{%if salary_sheet.salary_sheet.employee.employee_code != None %}{{salary_sheet.salary_sheet.employee.employee_code}} {% else %} {{salary_sheet.salary_sheet.employee.auto_employee_code}} {% endif %}<br><br> {{ forloop.counter }}</td>
                <td class="salaty_td">{{salary_sheet.salary_sheet.employee.name_en}} <br><br> {{salary_sheet.salary_sheet.employee.joining_date}}</td>
                <td class="salaty_td">{{salary_sheet.salary_sheet.employee.grade}}</td>
                <td class="salaty_td">{{salary_sheet.salary_sheet.employee.designation.name_en}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.total_working_day}} <br><br> {{salary_sheet.salary_sheet.total_present_day}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.weekly_holiday}} <br><br> {{salary_sheet.salary_sheet.general_holiday}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.cl}} <br> {{salary_sheet.salary_sheet.ml}}  <br> {{salary_sheet.salary_sheet.sl}}</td>
                <td class="text-center salaty_td"> {{salary_sheet.salary_sheet.el}}<br>{{salary_sheet.salary_sheet.ol}} <br>{{salary_sheet.salary_sheet.ul}} </td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.basic}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.house_rent}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.food}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.conveyance}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.medical}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.gross_salary}}</td>
                <td class="text-center salaty_td">{{salary_sheet.increments_amount}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.absent_day|floatformat:0}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.absent_penalty_amount}}</td>
                <td class="text-center salaty_td">{{salary_sheet.payable_taka}} <br> {% if salary_sheet.salary_sheet.attendance_bonus_amount %}
                {{salary_sheet.salary_sheet.attendance_bonus_amount}}
                {% else %}     
                0   
                {% endif %} </td>
              
                {% if salary_sheet.salary_sheet.employee.over_time == 'Eligible' %} 
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.over_time_hours}}</td>
                {% else %}
                <td class="text-center salaty_td">0</td>
                 {% endif %}
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.over_time_rate|floatformat:2}}</td>
                <td class="text-center salaty_td">{{salary_sheet.over_time_payable_taka |floatformat:2}}</td>
                {% comment %} <td class="text-center"> 
                </td> {% endcomment %}
                <td class="text-center salaty_td">{{salary_sheet.total_salary |floatformat:2}}</td>
                <td class="text-center salaty_td">{{salary_sheet.salary_sheet.stamp}}</td>
                <td class="text-center salaty_td"></td>
            </tr>
          {% endfor %}
          <tr>
            <td  colspan = "22"></td>
          </tr>
          <tr>
            <td class="text-center fw-bold salaty_td" colspan = "8" > Total</td>
            <td class="text-center fw-bold salaty_td">{{total_basic}}</td>
            <td class="text-center fw-bold salaty_td">{{total_hr}}</td>
            <td class="text-center fw-bold salaty_td">{{total_food}}</td>
            <td class="text-center fw-bold salaty_td">{{total_conveyance}}</td>
            <td class="text-center fw-bold salaty_td">{{total_medical}}</td>
            <td class="text-center fw-bold salaty_td">{{total_gross}}</td>
            <td class="text-center fw-bold salaty_td">-</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
            <td class="text-center fw-bold salaty_td">{{total_payable|floatformat:2}}</td>
            <td class="text-center">-</td>
            <td class="text-center">-</td>
          </tr>
        </tbody>
           <tfoot id="page-break">
            <tr >
              <td colspan="3" class="mt-2" style="border:none; color:black;" ><p class="fw-bold text-center mt-5" style="border-top:1px solid black;"> Prepared by</p></td>
              <td colspan="4" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Checked by</p></td>
              <td colspan="4" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Accounts  Dept</p></td>
              <td colspan="4" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> GM(Admin & HR)</p></td>
              <td colspan="4" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> GM(Operation)</p></td>
              <td colspan="4" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Approved by</p></td>
            </tr>
          </tfoot>
      </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' %}"
  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('salary_sheet_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 || ('salary_sheet_report.' + (type || 'xlsx')));
        }
</script>

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

{% endblock JS%}