{% extends "base.html" %}
{% load static %}
{% load crispy_forms_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
    }


    table, td, th {
      border: 1px solid black;
    }

    table {
      width: 100%;
      border-collapse: collapse;
    }
    @page { size: landscape; }
  .select2-selection__rendered{
      line-height: 39px !important;
      margin-top: -4px !important;
      width:100% !important;
    }
    .select2-container {
      width:100% !important;
  }
    .select2-container .select2-selection--single {
      height: 35px !important;
    }
    .select2-selection__arrow {
      height: 34px !important;
      
    }
    .select2-selection__arrow b{
      border-color:#FFF transparent transparent transparent !important;
    }

  </style>
{% endblock Style %}

{% block MainContent %}
 <div class="contents">
   {% if request.user.is_superuser == True %}
  <div class="table-area">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h4>Eid Bonus Report</h4>
          </div>
        </div>
        <div class="col-md-8">
          
        </div>
      </div>
    </div>
    <!-- table-title -->
      <div class="table-header">
        <form method="post" id="personForm" novalidate>
          {% csrf_token %}
            <div class="row">
              <div class="col-md-4">
                {{search_form.mother_organization|as_crispy_field }}
              </div> 
              <div class="col-md-4">
                {{search_form.sister_organization|as_crispy_field }}
              </div> 
              <div class="col-md-4">
                {{search_form.branch|as_crispy_field }}
              </div> 
            </div>
              <div class="row">
              <div class="col-md-3">
                  {{form.eid_name|as_crispy_field }}
              </div> 
              <div class="col-md-3">
                  {{form.year|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.category|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 32px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
              </div>
          </div>
        </form>
    </div>
  {% endif %}
   {% if request.user.user_type == 'Mother_Organization_admin'%}
  <div class="table-area">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h4>Eid Bonus Report</h4>
          </div>
        </div>
        <div class="col-md-8">
          
        </div>
      </div>
    </div>
    <!-- table-title -->
      <div class="table-header">
        <form method="post" id="personForm" novalidate>
          {% csrf_token %}
            <div class="row">
              <div class="col-md-4">
                {{search_form.sister_organization|as_crispy_field }}
              </div> 
              <div class="col-md-4">
                {{search_form.branch|as_crispy_field }}
              </div> 
              <div class="col-md-3">
                {{form.eid_name|as_crispy_field }}
            </div> 
            </div>
              <div class="row">
              <div class="col-md-3">
                  {{form.year|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.category|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 32px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
              </div>
       
          </div>
        </form>
    </div>
  {% endif %}
       {% if request.user.user_type == 'Sister_Organization_admin'%}
  <div class="table-area">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h4>Eid Bonus Report</h4>
          </div>
        </div>
        <div class="col-md-8">
          
        </div>
      </div>
    </div>
    <!-- table-title -->
      <div class="table-header">
        <form method="post" id="personForm" novalidate>
          {% csrf_token %}
            <div class="row">
              <div class="col-md-4">
                {{search_form.branch|as_crispy_field }}
              </div> 
              <div class="col-md-3">
                {{form.eid_name|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.year|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.category|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 32px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
            </div>
          </div>
        </form>
    </div>
  {% endif %}
  {% if request.user.user_type == 'Branch'%}
  <div class="table-area">
    <div class="table-title">
      <div class="row">
        <div class="col-md-4">
          <div class="depertment-name">
            <h4>Eid Bonus Report</h4>
          </div>
        </div>
        <div class="col-md-8">
          
        </div>
      </div>
    </div>
    <!-- table-title -->
      <div class="table-header">
        <form method="post" id="personForm" novalidate>
          {% csrf_token %}
            <div class="row">
              <div class="col-md-3">
                {{form.eid_name|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.year|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.category|as_crispy_field }}
              </div> 
              <div class="col-md-3">
              {{form.work_place|as_crispy_field }}
              </div> 
              <div class="col-md-1" style="margin-top: 32px;">
                <button type="submit" class="cus-btn">Show</button>
              </div>
            </div>
          </div>
        </form>
    </div>
  {% endif %}

  {% if report %}
  <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>
        </div>
        <table class="table table-striped table-hover" id="eid_bonus_report">
          <thead>
            <tr>
              <th class="text-center" colspan = "25" > <h3 style = 'text-align: center'>{{company_info.name_en }}  &nbsp &nbsp <small style = 'font-size: 15px; float: right; '> {% if work_place %}{{work_place.working_place}}
              {% endif %}
                </small>  <br>  <p> {{ company_info.address_details }}</P></h3><br> <p style = 'font-size: 15px; text-align: center;margin-top:0px;'>Eid Bonus Report  &nbsp - &nbsp 
                {% if  eid_name == 'eid-al-fitr' %}
                Eid-Al-Fitr &nbsp -&nbsp {{report_year}}
                {% else %}
                Eid-Al-Adha &nbsp -&nbsp {{report_year}}
                {% endif %}
                </h3></p></th>
            </tr>
            <tr>
              <th style = 'text-align: center'> SL </th>
              <th style = 'text-align: center'>Card No </th>
              <th style = 'text-align: center'> Name </th>
              <th style = 'text-align: center'> Jonining Date</th>
              <th style = 'text-align: center'>Gr-ade</th>
              <th style = 'text-align: center'>Designation</th>
              <th style = 'text-align: center'>Basic</th> 
              <th style = 'text-align: center'>HR</th>
              <th style = 'text-align: center'>MA </th>
              <th style = 'text-align: center'> FA </th>
              <th style = 'text-align: center'> CA</th>
              <th style = 'text-align: center'>Gross Salary</th>
              <th style = 'text-align: center'>Net Payable Taka</th>
              <th style = 'text-align: center'>Signature</th> 
              
            </tr>
          </thead>
          <tbody>
          
        {% for temp in report %}
        <tr>
          <td style = 'text-align: center'>{{forloop.counter}}</td>
          <td style = 'text-align: center'>{{temp.1}}</td>
          <td style="text-align: center;">{{temp.0}} </td>
          <td style="text-align: center;">{{temp.3}}</td>
          <td style="text-align: center;">{{temp.2}}</td>
          <td style="text-align: center;">{{temp.4}}</td>
          <td style="text-align: center;">{{temp.6}}</td>
          <td style="text-align: center;">{{temp.7}}</td>
          <td style="text-align: center;">{{temp.9}}</td>
          <td style="text-align: center;">{{temp.8}}</td>
          <td style="text-align: center;">{{temp.10}}</td>
          <td style="text-align: center;">{{temp.5}}</td>
          <td style="text-align: center;">{{temp.11}}</td>
          <td style="text-align: center;"> </td>
          
        </tr>
      {% endfor %}
          </tbody>
          <tfoot id="page-break">
            <tr>
                {% if request.user.signature %}
                  <td colspan="2" class="mt-2" style="border:none; color:black; float:center;" >
                    <img src = "{{request.user.signature.url}}" style="height:40px;margin-left:40%; padding:0px;" />
                  </td>
                {% else %} 
                  <td  class="mt-1" style="border:none; color:black; float:center; margin-top:10px !important"> </td>
                {% endif %}
            </tr>
            <tr >
              {% if request.user.signature %}
              <td colspan="3" class="mt-2" style="border:none; color:black;" ><p class="fw-bold text-center" style="border-top:1px solid black;"> Prepared by</p></td>
              {% else %}
              <td colspan="2" class="mt-2" style="border:none; color:black;" ><p class="fw-bold text-center mt-3" style="border-top:1px solid black;"> Prepared by</p></td>
              {% endif %}
  
              <td colspan="2" 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="2" 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="2" 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="3" class="mt-2" style="border:none; color:black;"><p class="fw-bold text-center" style="border-top:1px solid black;"> Director</p></td>
              <td colspan="2" 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' %}"

  $(document).ready(function() {
    $("#id_eid_name").select2({
     
    });
  });
  $(document).ready(function() {
    $("#id_category").select2({
     
    });
  });

  $(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('eid_bonus_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 || ('eid_bonus_report.' + (type || 'xlsx')));
        }
</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>


{% endblock JS%}