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

{% block title %}
<title>Summarized Budget</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">


  {% include 'merchant_app/budget/cmptw/menubar.html' with active_tab="reports" %}

<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">
        <div>
            <h3 style = 'text-align: center'>O'Dell Group</h3>
            <h5 style = 'text-align: center'>House 1161, Road 10, Avenue 12, Mirpur DOHS</h5>
            <p style = 'text-align: right'><span>{{report_month}}</span> <span>{{report_year}}{{eid_bonus_list.created_date}}</span></p>
          </div>
          <h4 class="my-3">CMPTW/CM Summarized 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> <br>
           
           <small style = 'font-size: 15px; text-transform: capitalize; color:white; background-color: #3983d1; margin-top: 5px !important;' class=" p-2">
           Beneficiary Company : {{budget.finance_company}} </small>
           
           </h4>
        <table  class="table my-custom-font table-hover mt-3" id="summarized_budget" >
          

       
  
  
  
      <thead  >
           <tr>
            <td colspan='13' class="fw-bold text-center"> Style Wise Details </td>

            </tr>
          <tr style="background-color: #fdf9ec; font-size: 12px !important;">
              <th class="col-md-1 text-center">SL No</th>
              <th class="text-center  "> Style </th>
              <th class="text-center "> Order QTY </th>
              <th class="text-center "> Quoted {{budget.get_mode_of_price_display}}/pc </th>
              <th class="text-center " >Total Quoted {{budget.mode_of_price}}</th>
              <th class="text-center col-md-2 ">Total CM</th>
              <th class="text-center ">Ag. Com.</th>
              <th class="text-center ">Profit</th>
              <th class="text-center "> Others </th>
              <th class="text-center "> Commercial </th>
              <th class="text-center" >Price/pc</th>
              <th class="text-center">Mode</th>
              <th class="text-center col-md-2">Total Price</th>
             
             
              
            
              
          </tr>
          {% for item in style_details_list  %}
          
              <tr>

                <td class="col-md-1 text-center">{{forloop.counter}}</td>
                <td class="text-center"> {{item.style}} </td>
                <td class="text-center">{{item.gmt_qty}} pcs</td>
                <td class="text-center"> $ {{item.price_obj.per_pc_quoted_price|floatformat:4}} </td>

                <td class="text-center"> ${{item.price_obj.total_quoted_price}}</td>
                <td class="text-center">$ {{item.cm}}</td>
                <td class="text-center">$ {{item.price_obj.agent_commission}}</td> 
                <td class="text-center"> $ {{item.price_obj.profit_margin}}</td> 
                <td class="text-center">$ {{item.price_obj.other}} </td> 
                <td class="text-center">$ {{item.price_obj.commercial}} </td> 


                <td class="text-center">${{ item.price_obj.per_pc_total_price|floatformat:4 }}</td>
                <td class="text-center">{{ item.price_obj.get_price_mode_display }}</td> 
                <td class="text-center">${{ item.price_obj.total_price}} </td> 
                

              </tr>
            {% endfor %}
            <tr style="background-color:#FFFF01">
            
            <td class="fw-bold" colspan=2>Grand Total</td>
            <td class="text-center fw-bold"> {{total_budgeted_prices.gmt_qty}} pcs </td>
            <td class="text-center fw-bold">  </td>
            <td class="text-center fw-bold"> $ {{total_budgeted_prices.quoted_price|floatformat:2}} </td>
            <td class="text-center fw-bold"> $ {{total_budgeted_prices.total_cm|floatformat:2}} <br>Avg CM:  $ {{total_budgeted_prices.avg_cm|floatformat:2}}/pc</td>
            <td class="text-center fw-bold"> ${{total_budgeted_prices.agent}} </td>
            <td class="text-center fw-bold"> ${{total_budgeted_prices.profit}} </td>
            <td class="text-center fw-bold"> $ {{total_budgeted_prices.other}} </td>
            <td class="text-center fw-bold"> $ {{total_budgeted_prices.commercial}} </td>
            <td class="text-center fw-bold"> </td>
            <td class="text-center fw-bold">  </td>
            <td class="text-center fw-bold"> $ {{total_budgeted_prices.total_price}} </td>
            </tr>





          <tr>
          <td colspan=13 class="text-center fw-bold">Material Details</td>
          </tr>


          <tr style="background-color: #fdf9ec;">
              <th class="col-md-1 text-center">SL No</th>
              <th class="text-center "> Type </th>
              <th class="text-center "> Description </th>
              <th class="text-center "> GMT </th>
              <th class="text-center ">Consumption/gmt</th>
              <th class="text-center ">Actual Qty</th>
              <th class="text-center">Wastage(%)</th>
             
              <th class="text-center ">Required</th>
              <th class="text-center ">Unit Price</th>
              <th class="text-center ">Total PX</th>
              <th class="text-center ">Supplier</th>
              <th class="text-center " colspan=2>T&C</th>
              
            
              
          </tr>
      </thead>
      <tbody>
            <tr>
            <td colspan='13' class="fw-bold">Fabric Description </td>

            </tr>

            {% for fabric in fabric_budget %}
             
              <tr>
              <td class="col-md-1 text-center">{{forloop.counter}}</td>
              <td class="text-center"> {{fabric.get_type_display}} </td>
             <td class="text-center">{{fabric.description}} </td>
              <td class="text-center">{{fabric.gmt_qty}} pcs</td>

              <td class="text-center">{{fabric.consumption_per_gmt}} {{fabric.unit}}  </td>
              <td class="text-center">{{ fabric.gmt_qty |multiply:fabric.consumption_per_gmt }} {{fabric.unit}}</td>
              <td class="text-center">{{fabric.wastage}}%</td>
              <td class="text-center">{{fabric.total_required}} {{fabric.unit}}</td> 
              <td class="text-center">{{fabric.cost_per_unit|floatformat:3}} </td> 
              <td class="text-center">$ {{fabric.price}} </td> 
              <td class="text-center">{{ fabric.supplier }}</td>
              <td class="text-center" colspan=2>{{ fabric.get_supplier_type_display }}<br>{{ fabric.payment_term }}</td>

             
            </tr>

         
            
            {% endfor %}
            <tr>
              <td colspan='9' class="text-center fw-bold">  Total </td>
              <td colspan='' class="fw-bold">  $ {{total_fabric_cost}} </td>

            </tr>

             <tr>
                  <td colspan='13' class="fw-bold">  Material Description </td>

            </tr>

           
            
            {% for item in materials_budget  %}

            <tr>
              <td class="col-md-1 text-center">{{forloop.counter}}</td>
              <td class="text-center"> {{item.get_type_display}} </td>
              <td class="text-center">{{item.description}} </td>
              <td class="text-center">{{item.gmt_qty}} pcs</td>

              <td class="text-center">{{item.consumption_per_gmt}} {{item.unit}}  </td>
              <td class="text-center">{{ item.gmt_qty |multiply:item.consumption_per_gmt }} {{item.unit}}</td>
              <td class="text-center">{{item.wastage}}%</td>
              <td class="text-center">{{item.total_required}} </td> 
              <td class="text-center">{{item.cost_per_unit|floatformat:3}} </td> 
              <td class="text-center">{{item.price}} </td> 
              <td class="text-center">{{ item.supplier }}</td>
              <td class="text-center" colspan=2>{{ item.get_supplier_type_display }}<br>{{ item.payment_term }}</td>

             
            </tr>
             
            {% endfor %}
            <tr>
              <td colspan='9' class="text-center fw-bold">  Total </td>
              <td colspan='' class="fw-bold">  $ {{budget_summary.total_material_cost}} </td>

            </tr>


            <tr>
            <td colspan='13' class="fw-bold"> Wash Cost </td>

            </tr>

            {% for wash in wash_budget%}
             
              <tr>
              <td class="col-md-1 text-center">{{forloop.counter}}</td>
              <td class="text-center"> {{wash.get_type_display}} </td>
             <td class="text-center">{{wash.description}} </td>
              <td class="text-center">{{wash.gmt_qty}} pcs</td>

              <td></td>
              <td class="text-center"></td>
              <td class="text-center"></td>
              <td class="text-center"></td> 
              <td class="text-center"> </td> 
              <td class="text-center">$ {{wash.price}} </td> 
              <td class="text-center">{{ wash.supplier }}</td>
              <td class="text-center" colspan=2>{{ wash.get_supplier_type_display }}<br>{{ wash.payment_term }}</td>

             
            </tr>
            {% endfor %}









            <tr>
            <td colspan=13 class='fw-bold'>CM</td>
            
            </tr>



            <tr>
                <td class="text-center fw-bold">SL No</td>
                <td class="text-center fw-bold" colspan=3> Style </td>
                <td class="text-center fw-bold" colspan=3> GMT Qty </td>
                <td class="text-center fw-bold" colspan=3>Price/pc</td>
                <td class="text-center fw-bold" colspan=3>Total PX</td>     
                
            </tr>
            
            {% for item in cm_list  %}
            <tr>
                 <th class="text-center">{{forloop.counter}}</th>
                <th class="text-center" colspan=3> {{item.0.style}} </th>
                <td class="text-center" colspan=3>
                {% if item.1 %}
                
                {{item.1}}pcs
                {% else %}
                 <p style="color:red;"> PO Don't Have Gmt Qty </p>

                {% endif %}
                
                </td>
                <td class="text-center" colspan=3>${{item.0.price}}</td>
                {% if item.1 %}
                  <td class="text-center" colspan=3>${{ item.1|multiply:item.0.price }}</td>

                {% else %}
                  <td class="text-center" colspan=3><p style="color:red;"> PO Don't Have Gmt Qty </p></td>

                {% endif %}

            </tr>
            {% endfor %}

        <tr>
        <td colspan=13 class="fw-bold text-center" style="background-color:#FFFF01">Budget Summary</td>    
        </tr>
        <tr>
        <td class="fw-bold">Total Gmt</td>
        <td>{{budget_summary.total_gmt}} pcs</td>
        <td class="fw-bold">FOB</td>
        <td>$ {{budget_summary.total_fob}}</td>
        <td class="fw-bold">FOB/pc</td>
        <td>$ {{budget_summary.fob_pc |floatformat:3}}</td>
        <td class="fw-bold">75% of FOB</td>
        <td>$ {{budget_summary.total_fob_75percent |floatformat:3}}</td>
        <td class="fw-bold">25% of FOB</td>
        <td>$ {{budget_summary.total_fob_25percent |floatformat:3}}</td>
        <td class="fw-bold">Commercial</td>
        <td colspan=2>$ {{budget_summary.commercial |floatformat:3}}</td>
        


        </tr>
        <tr>
        <td class="fw-bold">Commercial in Percent</td>
        <td >{{budget_summary.commercial_percent |floatformat:3}}%</td>
        <td class="fw-bold">Agent Com.</td>
        <td>$ {{budget_summary.agent_comm |floatformat:3}}</td>
        <td class="fw-bold">Agent Com. in Percent</td>
        <td>{{budget_summary.agent_comm_percent |floatformat:3}}%</td>
        <td class="fw-bold">Fab Cost</td>
        <td>${{budget_summary.fab_cost |floatformat:3}}</td>
        <td class="fw-bold">Fab Cost in percent</td>
        <td>{{budget_summary.fab_cost_percent |floatformat:3}}%</td>

        <td class="fw-bold">Acc. Cost</td>

        <td colspan=2>${{budget_summary.total_material_cost |floatformat:3}}</td>







        </tr>
        <tr>
            <td class="fw-bold">Acc. Cost in percent</td>
            <td colspan=>{{budget_summary.total_material_cost_percent |floatformat:3}}%</td>
            <td class="fw-bold">Wash Cost</td>
            <td colspan= >${{total_wash_cost |floatformat:3}}</td>
            <td class="fw-bold">CM Cost</td>
            <td colspan= 10>${{total_budgeted_prices.total_cm |floatformat:3}}</td>
            

            </tr>
            <tr>
            <td class="fw-bold">Total BTB</td>
            <td colspan=2>${{budget_summary.total_btb |floatformat:3}}</td>
            <td class="fw-bold">BTB (Buyer Nominated)</td>
            <td colspan=2>$ {{budget_summary.total_btb_buyer_nominated |floatformat:3}}</td>
            <td class="fw-bold">BTB Own Source</td>
            <td colspan=2>$ {{budget_summary.total_btb_own_source |floatformat:3}}</td>
            <td class="fw-bold">Cash Payment</td>
            <td colspan=5>$ {{budget_summary.total_cash |floatformat:3}} </td>
        </tr>


            
          
 
            



























            


          
          
           
      
      

      </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('summarized_budget');
            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 || ('summarized_budget.' + (type || 'xlsx')));
        }
</script>
{% endblock JS %}