{% 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>Actual 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>


{% comment %} {% if salary_sheets %}

<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">
      <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>Salary Sheet Report 
         <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-striped table-hover" id="actual_salary_sheet_report">
        <thead>
          <tr>
            <th class="text-center">SL No</th>
            <th class="">Name </th>
            <th class="">Department</th>
            <th class="">Designation</th>
            <th class="">Work Place</th>
            <th class="">Code</th>
            <th class="">Grade</th>
            <th class=""> Bank AC</th>
            <th class="text-center">Gross Salary</th>
            <th class="text-center">Basic</th>
            <th class="text-center">Late Penalty</th>
            <th class="text-center">Absent Penalty</th>
            <th class="text-center">Over Time</th>
            <th class="text-center">Attendance Bonus</th>
            <th class="text-center">Lunch Bill</th>
            <th class="text-center">Tax</th>
            <th class="text-center">Stamp</th>
            <th class="text-center">Advance</th>
            <th class="text-center">Payable Tk</th>
            
          </tr>
        </thead>
        <tbody>
          {% for salary_sheet in salary_sheets %}
          <tr>
            <td class="text-center">{{ forloop.counter }}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.name_en}}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.department}}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.designation.name_en}}</td>
            <td class="">{{salary_sheet.work_place}}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.employee_code}}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.grade}}</td>
            <td class="">{{salary_sheet.salary_sheet.employee.bank_ac}}</td>
            <td class="text-center">{{salary_sheet.salary_sheet.gross_salary}}</td>
            <td class="text-center">{{salary_sheet.salary_sheet.basic}}</td>
            <td class="text-center">{{salary_sheet.late_penalty_amount|floatformat:2}}</td>
            <td class="text-center">{{salary_sheet.absent_penalty_amount|floatformat:2}}</td>
            <td class="text-center">{{salary_sheet.salary_sheet.over_time_payable_taka}}</td>
            <td class="text-center">{{salary_sheet.attendance_bonus}}</td>
            <td class="text-center">{{salary_sheet.salary_sheet.lunch_bill}}</td>
            <td class="text-center">{{salary_sheet.salary_sheet.tax}}</td>
            <td class="text-center">{{salary_sheet.stamp}}</td>
            <td class="text-center">{{salary_sheet.advance}}</td>
            <td class="text-center">{{salary_sheet.total_salary |floatformat:2}}</td>
          </tr>
          {% endfor %}
        </tbody>
      </table>
    </div>
  </div>
</div> {% endcomment %}

<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">

        <table class="table  table-striped table-hover" id="tbl_absent_export">
            <thead>

         <tr>
            <th class="text-center" colspan = "24" > <h3 style = 'text-align: center'>{{ sister_organization }} &nbsp &nbsp <small style = 'font-size: 15px;'> {% if workplace %}{{workplace.working_place}}
            {% endif %}</small></h3><br> <p style = 'font-size: 15px; text-align: center;margin-top:0px;'>Salary Sheet Report <small style = 'font-size: 15px; float: right; padding-right: 0px;'>{{year}} &nbsp-&nbsp {{month}}</small></h3></p></th>
          </tr>
          <tr>  
            <th class="text-center" colspan = "6" ></th>
            <th class="text-center" colspan = "6" >Gross Salary</th>
            <th class="text-center" colspan = "5">Deduction</th>
            <th class="text-center" style ="margin-top:25px !important;" rowspan="2">Payable</th>
            <th class="text-center" colspan = "4">Others Deduction</th>
            <th class="text-center" style ="margin-top:25px !important;" rowspan="2">Net Payable</th>
            <th class="text-center" style ="margin-top:25px !important;" rowspan="2">Signature</th>
          </tr>
          <tr>
            <th class="text-center salary_th">SL No</th>
            <th class="text-center salary_th">Name of the Employee</th>
            <th class="text-center salary_th">Designation</th>
            <th class="text-center salary_th">Bank AC No</th>
            <th class="text-center salary_th">Present Days</th>
            <th class="text-center salary_th">Absent Days</th>
            <th class="text-center salary_th">Basic</th>
            <th class="text-center salary_th">HR</th>
            <th class="text-center salary_th">M.Allow</th>
            <th class="text-center salary_th">Conv.</th>
            <th class="text-center salary_th">Food</th>
            <th class="text-center salary_th">Total</th>
            <th class="text-center salary_th">TAX</th>
            <th class="text-center salary_th">Stamp</th>
            <th class="text-center salary_th"> Absent <br> Late</th>
            <th class="text-center salary_th">S. Adv.</th>
            <th class="text-center salary_th">Total</th>
            {% comment %} <th class="text-center salary_th" rowspan="2"></th> {% endcomment %}
            <th class="text-center salary_th">Lunch Bill</th>
            <th class="text-center salary_th">Personal Loan</th>
            <th class="text-center salary_th">By Cash Voucher</th>
            <th class="text-center salary_th">Total</th>
            {% comment %} <th class="text-center salary_th"> Net Payable</th> {% endcomment %}
            {% comment %} <th class="text-center salary_th">Signature</th> {% endcomment %}
          </tr>

            </thead>
            <tbody>

            {% for department_list in department_temp  %}
              {% if department_list.0.0  %}
              <td colspan="4" class="fw-bold mt-2">{{department_list.0.0}}</td>
              
              {% endif %}
            {% for employee in department_list  %}

                   
              

                {% if forloop.last %}
                
                <tr>
                    <td></td>

                    <td colspan="21">Sub Total</td>

                    {% comment %} <td></td>
                    <td></td>
                    <td></td>
                    <td></td> {% endcomment %}
                    
                    <td class="fw-bold"> {{employee}}</td>
                    <td></td>
                 </tr>
                 {% else %}

                 <tr>
                  
                  <td class="text-center">{{forloop.counter}}</td>
                  <td>{{ employee.3 }}</td>
                  <td>{{ employee.8}}</td> 
                  <td>{{ employee.9}}</td>
                  <td>{{ employee.10}}</td>
                  <td>{{ employee.11}}</td>
                  <td>{{ employee.12}}</td>
                  <td>{{ employee.13}}</td>
                  <td>{{ employee.14}}</td>
                  <td>{{ employee.15}}</td> 
                   <td>{{ employee.16}}</td>
                  <td>{{ employee.17}}</td> 
                  <td>{{ employee.18}} </td>
                  <td>{{ employee.19}}</td>
                 
                  <td>{{ employee.20}} <br> {{ employee.21}}</td>
                   <td>{{ employee.22}}</td>
                  <td>{{ employee.23}}</td> 
                  <td>{{ employee.24}}</td> 
                  <td>{{ employee.25}}</td> 
                  <td>{{ employee.26}}</td> 
                  <td>0</td> 
                  <td>{{ employee.27}}</td> 
                  <td>{{ employee.28}}</td> 
                  <td></td>
                </tr>
                {% endif %} 
                {% endfor %}
                {% comment %} {% if department_list.0.0  %}
                <td>{{department_list.0.1}}</td>
                {% endif %} {% endcomment %}
                {% endfor %}
                <td></td>

                <td colspan="5" class="text-center fw-bold">Grand Total</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>

                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>

                <td class="fw-bold">{{grant_total}}</td>

                <td></td>
            </tbody>
            <tfoot id="page-break">
              <tr >

                <td colspan="3" class="mt-5" 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-5" 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-5" 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-5" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> AGM- Finance & Accounts</p></td>
                <td colspan="4" class="mt-5" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Admin & HR</p></td>
                {% comment %} <td colspan="5" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> GM(Operation)</p></td> {% endcomment %}
                <td colspan="5" class="mt-5" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Chairman & MD</p></td>

              </tr>
            </tfoot>
        </table>
    </div>
  </div>


{% comment %} {% endif %}  {% endcomment %}

{% 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>
  
  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);  
        }
    }); 
  });


        $(document).ready(function() {
    $("#id_work_place").select2({
     
    });
  });
  </script>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.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");


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

{% endblock JS%}