{% extends "merchant_base.html" %}
{% load widget_tweaks %}
{% load static %}
{% load crispy_forms_tags %}
{% load custom_filters %}

{% block title %}
<title>Open Quotation</title>
{% endblock title %}
{% block Style %}
<!-- <link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/sweetalert2@10.10.1/dist/sweetalert2.min.css'> -->


 <style>
 .right{
    text-align: right !important;
  }
  .rowhight{
    height:5px !important;
  }
</style>

{% endblock Style %}

{% block MainContent %}
<div class="contents">





<div class="table-are 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">
        <div>
            <h3 style = 'text-align: center'>O'Dell Group</h3>
            <h5 style = 'text-align: center'>House 1161, Road 10, Avenue 12, Mirpur DOHS</h5>
           
          </div>
          <h4 class="my-3">Initial Costing Report
            {% comment %} <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 %}
          
            <small style = 'font-size: 15px; text-transform: capitalize;'>
           {{budget.name}} </small> </h4>


        <table class="table table-hover" id="open_quotation">
          

       
  
  
  
      <thead >
          {% comment %} <tr>
              <th class="col-md-1 text-center">SL No</th>
              <th class="text-center "> Style </th>
              <th class="text-center "> Description </th>
              <th class="text-center "> Delivery Date </th>
              <th class="text-center ">Mode of Price</th>
              <th class="text-center ">Price</th>
           
              
            
              
          </tr> {% endcomment %}
      </thead>
      <tbody>
        

        
        <tr>
              <th class="col-md-1 fw-bold">SL No</th>
              <th class="text-center fw-bold"> Style </th>
              <th class="text-center fw-bold " colspan=2> Description </th>
              <th class="text-center fw-bold"> Delivery Date </th>
              <th class="text-center fw-bold" colspan=2>  Quantity </th>

              <th class="text-center fw-bold">Mode of Price</th>
              <th class="text-center fw-bold" colspan=2>Price</th>
              
            
           
  
            
              
          </tr>
          <tr>
              <th class="col-md-1 text-center">1</th>
              <th class="text-center "> {{style_information.style}} </th>
              <th class="text-center " colspan=2 > {{style_information.style.style_description}} </th>
              <th class="text-center "> {{style_information.style.ex_factory}} </th>
              <th class="text-center " colspan=2>
              {% if style_information.style.approx_quantity %}
              {{style_information.style.approx_quantity}} pcs <br> Approx
              
              {% elif style_information.style.moq  %}
              {{style_information.style.moq}} pcs <br> MOQ

              {% endif %}
              </th>
              <th class="text-center "> {{style_information.style.mode_of_price}} </th>

              <th class="text-center " colspan=2>
              {% if style_information.style.mode_of_price == "FOB" or style_information.style.mode_of_price == "CM"  or style_information.style.mode_of_price == "CMPTW" or style_information.style.mode_of_price == "FOC" %}
                  ${{style_information.summary.fob|floatformat:3}}
              
              {% endif %}
              {% if style_information.style.mode_of_price == "CIF" %}
                  ${{style_information.summary.cif|floatformat:3}}
              
              {% endif %}
               {% if style_information.style.mode_of_price == "CNF" %}
                  ${{style_information.summary.cnf|floatformat:3}}
              
              {% endif %}
              
              </th>
           
              
            
              
          </tr>
          {% if style_information.fabrics %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Fabrics</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold">Item</td>
            <td class="fw-bold">Cosumption</td>
            <td class="fw-bold">Wastage</td>
            <td class="fw-bold" colspan=2>Required</td>
            <td class="fw-bold" colspan=2>Cost/unit</td>
            <td class="fw-bold" colspan=2>Total PX</td>
          
          </tr>

          {% for fabric in style_information.fabrics  %}
            <tr>
              <td >{{forloop.counter}}</td>
              <td class='col-2' ><span class="fw-bold">{{fabric.fabric_application}} </span> {{fabric.fabric}}</td>
              <td >{{fabric.fabric.consumption}} {{fabric.fabric.unit}}</td>
              <td >{{fabric.fabric.wastage}}%</td>
              <td colspan=2>{{fabric.fabric.total_uses |floatformat:3}} {{fabric.fabric.unit}}</td>
              <td colspan=2>$ {{fabric.cost_per_unit |floatformat:3}}</td>
              <td colspan=2>$ {{fabric.total_cost |floatformat:3}}</td>
            
            </tr>
          
          {% endfor %}
          <tr>
              <td ></td>

              <td colspan=7 class="fw-bold">Grand Total</td>
              <td class="fw-bold" colspan=2> $ {{style_information.summary.total_fabric_cost |floatformat:3}}</td>
          </tr>
          
          
          {% endif %}
          {% comment %} accessories {% endcomment %}
          {% if style_information.accessories %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Accessories</td>
          </tr>
          <tr>
            <th class="fw-bold" >SL</th>
            <th class="fw-bold">Item</th>
            <th class="fw-bold">Cosumption</th>
            <th class="fw-bold">Wastage</th>
            <th class="fw-bold" colspan=2 >Required</th>
            <th class="fw-bold" colspan=2 >Cost/unit</th>
            <th class="fw-bold" colspan=2 >Total PX</th>
          
          </tr>

          {% for accessory in style_information.accessories  %}
            <tr>
              <td >{{forloop.counter}}</td>
              <td ><span class="fw-bold">{{accessory}} </span> {% if accessory.accessory.material_description %}
              {{accessory.accessory.material_description}}
             
              {% endif %}</td>
              <td >{{accessory.accessory.consumption}} {{accessory.accessory.unit}}</td>
              <td >{{accessory.accessory.wastage}}%</td>
              <td colspan=2 >{{accessory.accessory.total_uses |floatformat:3}} {{accessory.accessory.unit}}</td>
              <td colspan=2 >$ {{accessory.cost_per_unit |floatformat:3}}</td>
              <td colspan=2 >$ {{accessory.total_cost |floatformat:3}}</td>
            
            </tr>
          
          {% endfor %}
          <tr>
              <td ></td>

              <td colspan=7 class="fw-bold">Grand Total</td>
              <td class="fw-bold " colspan=2> $ {{style_information.summary.total_accessory_cost |floatformat:3}}</td>
          </tr>
          
          
          {% endif %}


          {% comment %} wash {% endcomment %}
           {% if style_information.wash %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Wash</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold" colspan=7 >Process Details</td>
            <td class="fw-bold" colspan=2>Cost/gmt</td>
           
          
          </tr>

         
            <tr>
              <td >1</td>
              <td colspan=7><span >{{style_information.wash.washing.process_details}}</td>
              <td  colspan=2 class="fw-bold">$ {{style_information.wash.total_cost}}</td>
              
            
            </tr>
          
         
          
          {% endif %}

             {% comment %} Embroidery {% endcomment %}
           {% if style_information.embroidery %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Embroidery</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold" colspan=7 >Process Details</td>
            <td class="fw-bold" colspan=2>Cost/gmt</td>
           
          
          </tr>

         
            <tr>
              <td >1</td>
              <td colspan=7><span >{{style_information.embroidery.embroidery.process_details}}</td>
              <td colspan=2 class="fw-bold">$ {{style_information.embroidery.embroidery_cost}}</td>
              
            
            </tr>
          
         
          
          {% endif %}

           {% comment %} Print {% endcomment %}
           {% if style_information.print_obj %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Print</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold" colspan=7 >Process Details</td>
            <td class="fw-bold" colspan=2 >Cost/gmt</td>
           
          
          </tr>

         
            <tr>
              <td >1</td>
              <td colspan=7><span >{{style_information.print_obj.print_object.process_details}}</td>
              <td colspan=2 class="fw-bold">$ {{style_information.print_obj.print_cost}}</td>
              
            
            </tr>
          
         
          
          {% endif %}




{% if style_information.test_cost %}
           {% comment %} Print {% endcomment %}
          
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Test Cost</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold">Fabric</td>
            <td class="fw-bold" >Accessories</td>
            <td class="fw-bold" >Thread</td>
            <td class="fw-bold" >Wash</td>
            <td class="fw-bold" >Embroidery</td>
            <td class="fw-bold" colspan=2>Print</td>
            <td class="fw-bold" colspan=2 >Total PX</td>
            
           
          
          </tr>

         
            <tr>
              <td  >SL</td>
              <td >{{style_information.test_cost.fabric_test_description}} <br> $ {{style_information.test_cost.fabric_test_cost}}</td>
              <td >{{style_information.test_cost.trim_test_description}} <br> $ {{style_information.test_cost.trim_test_cost}}</td>
              <td >{{style_information.test_cost.thread_test_description}} <br> $ {{style_information.test_cost.thread_test_cost}}</td>
              <td >{{style_information.test_cost.wash_test_description}} <br> $ {{style_information.test_cost.wash_test_cost}}</td>
              <td >{{style_information.test_cost.embroidery_test_description}} <br> $ {{style_information.test_cost.embroidery_test_cost}}</td>
              <td colspan=2 >{{style_information.test_cost.print_test_description}} <br> $ {{style_information.test_cost.print_test_cost}}</td>
              
              <td  colspan=2 class="fw-bold"> $ {{style_information.test_cost.total_cost_per_gmts}}</td>
                
            
            </tr>
          
         
           
          {% endif %}
         










           {% if style_information.cm %}
          <tr>
              
              <td colspan=10 style="background-color:#e1e9cd;"  class="fw-bold text-center">CM</td>
     
          </tr>
          <tr >
              <td  >1</td>
              <td colspan=7 >CM</td>
              <td  class="fw-bold" colspan=2> $ {{style_information.cm.total_cost_per_gmts }}</td>
     
          </tr>
          
         
          
          {% endif %}






           {% if style_information.commercial_other %}
          <tr>
          <td colspan=10 style="background-color:#e1e9cd;" class="text-center fw-bold">Commercial and Others</td>
          </tr>
          <tr>
            <td class="fw-bold" >SL</td>
            <td class="fw-bold" >Commercial</td>
            <td class="fw-bold" >Agent Commission 1</td>
            <td class="fw-bold" >Agent Commission 2</td>
            <td class="fw-bold"  >Duty</td>
            <td class="fw-bold" >Landed Cost</td>
            <td class="fw-bold"  >Insurance</td>
            <td class="fw-bold" >Freight</td>
            <td class="fw-bold" >Others</td>
            <td class="fw-bold"  >Courier Cost</td>
     
       
           
          
          </tr>

         
            <tr>
              <td >1</td>
              <td >$ {{style_information.summary.commercial_cost|floatformat:3}}</td>
              <td >$ {{style_information.summary.agent_commission1|floatformat:3}}</td>
              <td >$ {{style_information.summary.agent_commission2|floatformat:3}}</td>
              <td >$ {{style_information.summary.duty|floatformat:3}}</td>
              <td >$ {{style_information.summary.landed_cost|floatformat:3}}</td>
              <td >$ {{style_information.summary.insurance|floatformat:3}}</td>
              <td >$ {{style_information.summary.freight|floatformat:3}}</td>
              <td >$ {{style_information.summary.others}}</td>

              <td > {% if style_information.summary.courier_cost %}
               $ {{style_information.summary.courier_cost|floatformat:3}}
              {% else %}
               $ 0.00
              {% endif %}  </td>
         
              
              
            
            </tr>
          
          
          {% endif %}
          




          
        

          

            
          
 
            


          
          
           
      
      

      </tbody>
  </table>
    </div>
  </div>

{% endblock MainContent %}

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

//     jQuery(document).ready(function(){
//     $('#employee-attendance-general-report-pdf-button').click(function() {
//         console.log('Clicked pdf');
//         $('#employee-attendance-general-report-table-pdf').print();
        
//         return false;
//     });
// });








    function printDiv(divName) {
        var originalContents = document.body.innerHTML
        var printContents = document.getElementById(divName).innerHTML;
        console.log("DIV NAME", divName)
        document.body.innerHTML = printContents;
        window.print();
        document.body.innerHTML = originalContents;
      }


     
      
    function ExportToExcel(type, fn, dl) {
            var elt = document.getElementById('open_quotation');
            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 || ('Open_Quotation.' + (type || 'xlsx')));
        }
</script>
{% endblock JS %}