{% extends "base.html" %}
{% load static %}
{% load crispy_forms_tags %}
{% load widget_tweaks %}
{% block title %}
<title>Report</title>
{% endblock title %}
{% block Style %}
<style>
.page {
    width: 210mm; /* A4 width */
    height: 297mm; /* A4 height */
    margin: 0 auto; /* Center the page horizontally */
    background-image: url('background-image.jpg');
    background-repeat: no-repeat;
    background-size: cover;
}

 .right{
    text-align: right !important;
  }
  .rowhight{
    height:5px !important;
  }

</style>
{% endblock Style %}


{% block MainContent %}
<div class="contents">
<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"> 
            Add New  Conveyence
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
              {{form.project|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.form|as_crispy_field}}
            </div> 
            <div class="col-md-3">
              {{form.destination|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.cost|as_crispy_field}}
            </div>
          </div>
          <div class="row">
            <div class="col-md-3">
              {{form.date|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.description|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.mother_organization|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.sister_organization|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.branch|as_crispy_field}}

            </div>
          </div>
        </div>
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
</div>
</form>


{% elif request.user.user_type == 'Mother_Organization_admin' %}
<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"> 
            Add New  Conveyence
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
              {{form.project|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.form|as_crispy_field}}
            </div> 
            <div class="col-md-3">
              {{form.destination|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.cost|as_crispy_field}}
            </div>
          </div>
          <div class="row">
            <div class="col-md-3">
              {{form.date|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.description|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.sister_organization|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.branch|as_crispy_field}}

            </div>
          </div>
        </div>
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
</div>
</form>
{% elif request.user.user_type == 'Sister_Organization_admin' %}
<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"> 
            Add New  Conveyence
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
              {{form.project|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.form|as_crispy_field}}
            </div> 
            <div class="col-md-3">
              {{form.destination|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.cost|as_crispy_field}}
            </div>
          </div>
          <div class="row">
            <div class="col-md-3">
              {{form.date|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.description|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.branch|as_crispy_field}}

            </div>
          </div>
        </div>
   
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
</div>
</form>
{% elif request.user.user_type == 'Branch' or request.user.user_type == 'Regular' %}
<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"> 
            Report
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-md-3">
              {{form.project|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.bill_submission_status|as_crispy_field}}
            </div>
            <div class="col-md-3">
              {{form.bill_receive_status|as_crispy_field}}
            </div>
        </div>
      </div>
  
      <div class="row" style="margin-top: 10px;margin-bottom: 8px;">
        <div class="col-md-12 text-center">
            <button type="submit" class="cus-btn" >Submit</button>
        </div>
    </div>
</div>
</form>
{% endif %}
 {% if project_list %}

<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 mt-3" id="tbl_absent_export">
            <thead>
              <tr>
                <th class="text-center">SL No</th>
                <th class="text-center">Product</th>
                <th class="text-center">Invoice</th>
                <th>Quantity</th>
                <th>Buying Date</th>
                <th>Buying Price</th>
                <th>Selling Price</th>
                <th>Net Profit </th>
                <th>Bill to Consumer</th>
                <th>Bill submission status</th>
                <th>Bill Receive Status</th>
              </tr>
            </thead>
            <tbody>
            {% for project in project_list  %}
                <tr>
                  <td class="text-center">{{forloop.counter}}</td>
                  <td style="font-size:12px">{{ project.product_name }}</td>
                  <td>{{ project.invoice.invoice_number }}/{{ project.invoice.supplier_invoice_number }}</td>
                  <td>{{ project.qty }}</td>
                  <td>{{ project.invoice.buying_date }}</td>
                  <td>{{ project.buying_price}}</td>
                  <td>{{ project.selling_price}}</td>
                  <td>{{ project.profit}}</td>
                  <td>{{ project.invoice.bill_to}}</td>
                  {% if project.invoice.bill_submission_satus == 'submitted' %}
                  <td class="text-center" style="background-color: #37a000 !important; color:white;">Submitted</td>
                  {% else %}
                  <td  style="background-color: #FFC107 !important; color:white;">Not Submitted</td>
                  {% endif %}
                  {% if project.invoice.bill_receive_satus == 'received' %}
                   <td class="text-center" style="background-color: #37a000 !important; color:white;">Received</td>

                    {% else %}
                    <td  style="background-color: #FF6347 !important; color:white;">Pending</td>
                  {% endif %}
                </tr>
                {% endfor %}
                <tr>
                <td colspan="4" class="text-center">Total</td>
                 <td>{{ total_buying_price }}</td>
                 <td>{{ total_selling_price }}</td>
                 <td>{{ total_profit }}</td>
                 <td colspan="3" class="text-center"></td>
                </tr>
            </tbody>
        </table>
        <div>

        </div>
    </div>
  </div>
{% endif %}
</div>

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

{% block JS %}
<script type=text/javascript>
  $(document).ready(function() {
  $("#id_project").select2({
      
  });
});

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

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

</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' %}"  

</script>
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>

<!-- <script src="{% static 'js/payroll/intime_outtime_missing/create.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 || ('report.' + (type || 'xlsx')));
        }
</script>

{% endblock JS %}