{% extends "base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load widget_tweaks %}
{% block title %}
<title>Create SalarySheets</title>
{% endblock title %}
{% block 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"> 
          Salary Sheet Create
          </h5>
        </div>
        <div class="card-body">
            <div class="row">
              <div class="col-md-6">
                <div class="row">
                  <div class="col-md-4">
                    {{form.mother_organization.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.mother_organization}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.sister_organization.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.sister_organization}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.branch.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.branch}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.department.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.department}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.employee.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.employee}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.year.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.year}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.month.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.month}}
                  </div>
                </div>
              </div>

            
              <div class="col-md-6">
                <div class="row mt-2">
                  <div class="col-md-4 mt-2">
                    {{form.mercy_time.label}}
                  </div>
                  <div class="col-md-6 mt-2">
                      {{form.mercy_time|add_class:'form-control'}}
                  </div>
                  <div class="col-md-4 mt-2">
                    {{form.mercy_days.label}}
                  </div>
                  <div class="col-md-6 mt-2">
                      {{form.mercy_days|add_class:'form-control'}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4 mt-2">
                    {{form.on_which_penalty_permanent.label}}
                  </div>
                  <div class="col-md-6 mt-2">
                      {{form.on_which_penalty_permanent}}
                  </div>
                  <div class="col-md-4 mt-2">
                    {{form.on_which_penalty_provision.label}}
                  </div>
                  <div class="col-md-6 mt-2">
                      {{form.on_which_penalty_provision}}
                  </div>
                </div>
                <div class="row mt-2">
                  <div class="col-md-4">
                    {{form.stamp.label}}
                  </div>
                  <div class="col-md-6">
                      {{form.stamp|add_class:'form-control'}}
                  </div>
                  <div class="col-md-4 mt-2">
                    {{form.deduction_process.label}}
                  </div>
                  <div class="col-md-6 mt-2">
                      {{form.deduction_process|add_class:'form-control'}}
                  </div>
                </div>
              </div>
            </div>
        </div> 
      </div>
      <div class="row" style="margin-top: 10px;margin-bottom: 8px; ">
        <div class="col-md-12" style="text-align: right;">
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
  </form>
{% endif %}
</div>

{% if salary_sheet %}

<div class="table-header">
  
  
  <div class="row" style="margin-top: 10px;margin-bottom: 8px; ">
    <div class="col-md-12" style="text-align: right;">
      <a href="{% url 'salary-sheet-index' %}"></a>
        <button type="submit" class="cus-btn" >Save</button>
      </a>
    </div>
  </div>
  
  <div class="tables table-responsive" id="employee-attendance-general-report-table-pdf">
    <table class="table table-striped table-hover">
        <thead>
          <tr>
            <th class="text-center">Code <br> SL No</th>
            <th class="text-center">Name <br> Joining Date</th>
            <th class="text-center">Gra-de</th>
            <th class="text-center">Designation</th>
            <th class="text-center">TTL Day <br> Pr, Day</th>
            <th class="text-center">Weekend <br> GH</th>
            <th class="text-center">CL <br> ML <br> SL <br> EL <br> OL <br> UL </th>
            <th class="text-center">Basic</th>
            <th class="text-center">HR</th>
            <th class="text-center">Food</th>
            <th class="text-center">Conveyance</th>
            <th class="text-center">Medical</th>
            <th class="text-center">Gross Salary</th>
            <th class="text-center">Abs-ence-day</th>
            <th class="text-center">Absent-Penalty amount</th>
            <th class="text-center">Payable Tk</th>
            <th class="text-center">Hours</th>
            <th class="text-center">Rate</th>
            <th class="text-center">Total Salary</th>
            <th class="text-center">Stamp</th>
          </tr>
        </thead>
        <tbody>
          {% for salary_sheet in salary_sheet %}
          <tr>
            <td class="">{{salary_sheet.employee.code}}  <br> 1</td>
            <td class="">{{salary_sheet.employee.name_en}} <br> {{salary_sheet.employee.joining_date}}</td>
            <td class="">{{salary_sheet.employee.designation.grade}}</td>
            <td class="">{{salary_sheet.employee.designation.name_en}}</td>
            <td class="">{{salary_sheet.total_working_day}} <br> {{salary_sheet.total_present_day}}</td>
            <td class="">{{salary_sheet.weekly_holiday}} <br> {{salary_sheet.general_holiday}}</td>
            <td class="">{{salary_sheet.cl}} <br> {{salary_sheet.ml}} <br> {{salary_sheet.ol}} <br> {{salary_sheet.el}} <br> {{salary_sheet.sl}} <br> {{salary_sheet.ul}}</td>
            <td class="">{{salary_sheet.basic}}</td>
            <td class="">{{salary_sheet.house_rent}}</td>
            <td class="">{{salary_sheet.food}}</td>
            <td class="">{{salary_sheet.conveyance}}</td>
            <td class="">{{salary_sheet.medical}}</td>
            <td class="">{{salary_sheet.gross_salary}}</td>
            <td class="">{{salary_sheet.absent_day}} <br> {{salary_sheet.previous_absent}} <br> {{salary_sheet.joing_after_absent}}</td>
            <td class="">{{salary_sheet.absent_penalty_amount}}</td>
            <td class="">{{salary_sheet.over_time_payable_taka}}</td>
            <td class="">{{salary_sheet.over_time_hours}}</td>
            <td class="">{{salary_sheet.over_time_rate|floatformat:2}}</td>
            <td class="">{{total_salary |floatformat:2}}</td>
            <td class="">{{salary_sheet.stamp}}</td>
          </tr>
          {% endfor %}
        </tbody>
    </table>
  </div>
</div>

{% endif %}

{% endblock MainContent %}
{% block meassage %}
{% include 'notifications/notifications.html' %}           
{% endblock meassage %}

{% block JS %}
<script type=text/javascript>
    var load_branch_url = "{% url 'ajax_load_branchs' %}"
    var load_emp = "{% url 'salary-employee-load' %}"
    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' %}"
  </script>
<script src="{% static 'js/payroll/salary_sheet/create.js' %} "></script>
{% endblock JS %}