@extends('admin.layout.master')
@section('title','QUOTATION MANAGEMENT')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 35px !important;
        max-width: 75px;
    }
    input:read-only {
        background-color: #BEC6CC;
    }
    .table thead th,.table tbody td,.table tfoot th 
    {
        border: 1px solid black !important;
        /* max-width: 30px; */
        text-align: center;
        vertical-align: middle;
    }
    .table tbody td
    {
        padding:1px 2px;
    }
    .table thead th
    {
        padding:2px 3px;
    }

</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <div class="col-md-6 col-12 pl-0">
            <h4 >Quotation Edit</h4>
        </div>
        <div class="pl-0 pl-md-4 mt-md-0 mt-2 col-md-4 col-12 d-flex justify-content-md-end justify-content-start text-white pr-0">
            <label for="report_type">Currency</label>
        </div>
        <div  class="pl-0 pl-md-3 col-md-2 col-12 d-flex">
            <select class="form-control select_2" onchange="currencyChange(-1)" style="width: 100%" name="currency" id="currency">
                @forelse ($currency as $item)
                    <option value="{{$item->id}}" {{$item->id == $quotation->currency_id ? 'selected' : ''}} roe="{{$item->roe}}">{{$item->name}}</option>
                @empty
                    
                @endforelse
            </select>
        </div>
    </div>
    <div class="card-body">
         
        <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />
        <form id="form1" method="post" action="{{ route('pre_sells.quotation_store') }}" enctype="multipart/form-data">
            @csrf
            <input type="hidden" name="quotation_id" id="" value="{{$quotation->id}}">
        <div class="">
                <div class="tab-content">
                
                        
                        <div class="tab-pane active" id="tabs-1" role="tabpanel">
                            <div class="row mb-1">
                            {{-- <input type="hidden" name="requisition_id" id="requisition_id" value="{{Request()->quotation_id}}"> --}}
                                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">Customer</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <select name="customer_id" id="customer_id" class="form-control customer" required>
                                            <option value="{{$quotation->party_id}}">{{$quotation->party->name_eng}}</option>
                                        </select>
                                       
                                    </div>
                                </div>
                                <div class="col-md-5 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">DESCRIPTION</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <textarea name="note" id="note" class="form-control" cols="30" rows="1">{{$quotation->note}}</textarea>
                                        {{-- <input type="text"  name="note" id="note"> --}}
                                        
                                    </div>
                                </div>
                                <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="name">ROE</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <input class="form-control" step=".000000000000000001" onchange="currencyChange(this.value)" style="min-width: 90% !important" type="number" id="roe" name="roe" value="{{$quotation->roe}}" required>
                                        <input class="form-control" step=".000000000000000001" style="min-width: 90% !important" type="hidden" id="currency_id" name="currency_id" value="{{$quotation->currency_id}}" required>
                                    </div>
                                </div> 
                                {{-- <div class="col-md-6 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">DESCRIPTION</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <input type="text" class="form-control" name="note" id="note" value="{{$quotation->note}}">
                                        
                                    </div>
                                </div> --}}
                            </div>
                        </div>
                </div>
            </div> 
            {{-- end --}}
            <hr>
            <div class="table-responsive">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th rowspan="2">#</th>
                            <th rowspan="2">PRODUCT</th>
                            <th rowspan="2">Packing Size</th>
                            <th colspan="2">F. Rate</th>
                            <th colspan="2">Costing</th>
                            <th rowspan="2">Comm<br>(CTN)</th>
                            <th rowspan="2">FOB</th>
                            <th rowspan="2">CBM</th>
                            <th rowspan="2">QTY</th>
                            <th rowspan="2">T.CBM</th>
                            <th rowspan="2">OFFER</th>
                            <th colspan="2">Profit</th>
                            <th rowspan="2">T.FOB</th>
                            <th rowspan="2">GP</th>
                        </tr>
                        <tr>
                            {{-- size --}}
                            {{-- <th>carton</th>
                            <th>piece</th> --}}
                            {{-- rate --}}
                            <th>PCS</th>
                            <th>Carton</th>
                            {{-- costing --}}
                            <th>O. Cost</th>
                            <th>Comm.(%)</th>
                            {{-- Profit --}}
                            <th>Carton</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody id="tbl_body">
                        @php
                            $total_qty=0;
                            $total_tcbm=0;
                            $total_gprofit=0;
                            $total_fob_offer_g=0;
                            $i=0;
                            $roe=$quotation->roe;
                        @endphp
                        @forelse ($quotation->details as $k=>$item)
                        <tr id="tr-`+index+`">
                            <td>{{++$i}}</td>
                           @php
                                $unit_price=($item->unit_price);
                                $ctn_price=($item->unit_size*$unit_price);
                                $other_cost=($item->other_cost);
                                $commission_total=($item->commission_rate*$ctn_price);
                                $fob=((($ctn_price+$other_cost)-$commission_total)/$roe);
                                $tcbm=($item->cbm_unit*$item->qty);
                                $offer_fob_unit=($item->offer_fob_unit);
                                $profit_unit=($offer_fob_unit-$fob);
                                $profit_total=($profit_unit*$item->qty);
                                $total_fob_offer=($offer_fob_unit*$item->qty);
                            @endphp
                            <td>
                                <div class="d-flex text-center">
                                    <input type="hidden" name="details_id[{{$i}}]" id="" value="{{$item->id}}">
                                    <select class="form-control new_product" style="width: 100%" id="product_id{{$i}}"  name="product_id[{{$i}}]" onchange="getPriviousCosting('{{$i}}',this.value)">
                                        <option value="{{$item->product_id}}">{{$item->product->name_eng}}</option>
                                    </select>
                                </div>
                            </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="unit_quantity[{{$i}}]" id="unit_quantity{{$i}}" step=".01" class="form-control-sm" value="{{$item->unit_size}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="unit_price[{{$i}}]" id="unit_price{{$i}}" step=".01" class="form-control-sm" value="{{number_format($unit_price,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="ctn_price[{{$i}}]" id="ctn_price{{$i}}" step=".01" class="form-control-sm" value="{{number_format($ctn_price,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="other_cost[{{$i}}]" id="other_cost{{$i}}" step=".01" class="form-control-sm" value="{{number_format($other_cost,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="commission[{{$i}}]" id="commission{{$i}}" step=".01" class="form-control-sm" value="{{number_format(($item->commission_rate*100),2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="commission_total[{{$i}}]" id="commission_total{{$i}}" step=".01" class="form-control-sm" value="{{number_format($commission_total,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="fob[{{$i}}]" id="fob{{$i}}" step=".01" class="form-control-sm" value="{{number_format($fob,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="cbm[{{$i}}]" id="cbm{{$i}}" step=".01" class="form-control-sm" value="{{number_format($item->cbm_unit,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="qty[{{$i}}]" id="qty{{$i}}" step=".01" class="form-control-sm qty" value="{{number_format($item->qty,2,'.','')}}" onkeyup="setSubtotal('{{$i}}')">  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="total_cbm[{{$i}}]" id="total_cbm{{$i}}" step=".01" class="form-control-sm cbm" value="{{number_format($tcbm,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center {{$item->fob_type==1?'bg-dark':''}}">
                                            <input data-toggle="tooltip" title="{{$item->fob_type==1?'Product Party Price Has Yet Not Set':''}}" type="number" min="0" name="offer_fob[{{$i}}]" id="offer_fob{{$i}}" step=".01" class="form-control-sm" value="{{number_format($offer_fob_unit,2,'.','')}}" onkeyup="setSubtotal('{{$i}}')">
                                            <input type="hidden" name="offer_fob_type[{{$i}}]" id="offer_fob_type{{$i}}" value="{{$item->fob_type}}">  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="profit[{{$i}}]" id="profit{{$i}}" step=".01" class="form-control-sm" value="{{number_format($profit_unit,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="total_profit[{{$i}}]" id="total_profit{{$i}}" step=".01" class="form-control-sm total_profit" value="{{number_format($profit_total,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="total_fob[{{$i}}]" id="total_fob{{$i}}" step=".01" class="form-control-sm total_fob" value="{{number_format($total_fob_offer,2,'.','')}}" readonly>  
                                         </td>
                            <td class="text-right">
                                            <div class="input-group text-right">  
                                                <input type="number" min="0" step=".01"  name="gp[{{$i}}]"
                                                    id="gp{{$i}}" class="form-control-sm gp" readonly value="{{number_format((($profit_total/$total_fob_offer)*100),2,'.','')}}" style="width:92%">
                                                <div class="input-group-append" style="width:8%">
                                                    <button type="button" onclick="deleteRow({{$i}})" class="btn btn-danger btn-sm">
                                                        <span class="fa fa-minus"></span><span class="btn_text-{{$i}}"></span>
                                                    </button>
                                                </div>
                                            </div>
                                        </td>
                                        </tr>
                                        @php
                                            $total_qty+=$item->qty;
                                            $total_tcbm+=$tcbm;
                                            $total_gprofit+=$profit_total;
                                            $total_fob_offer_g+=$total_fob_offer;
                                        @endphp
                        @empty
                            
                        @endforelse
                    </tbody>
                    <input type="hidden" name="" id="index_num" value="{{($i)}}">
                    <tfoot>
                        <tr>
                            <th colspan="10" class="text-right">Total</th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01" name="total_qty" id="total_qty" value="{{number_format($total_qty,2,'.','')}}" class="form-control-sm total_qty" readonly>
                            </th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01" name="total_cbm" id="total_cbm" value="{{number_format($total_tcbm,2,'.','')}}" class="form-control-sm total_cbm" readonly>
                            </th>
                            <th colspan="2"></th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01" name="gross_total_profit" value="{{number_format($total_gprofit,2,'.','')}}" id="gross_total_profit" class="form-control-sm" readonly>
                            </th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01" name="gross_total_fob" id="gross_total_fob" value="{{number_format($total_fob_offer_g,2,'.','')}}" class="form-control-sm" readonly>
                            </th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01"  name="gross_gp" id="gross_gp" value="{{number_format((($total_gprofit/$total_fob_offer_g)*100),2,'.','')}}" class="form-control-sm" readonly>
                            </th>
                        </tr>
                        <tr>
                            <th colspan="15" class="text-right">Add, Other Charge</th>
                            <th class="text-right">
                                @php
                                    $invoice_charge=($quotation->invoice_charge/$roe);
                                @endphp
                                <input type="number" step=".01"  name="invoice_other_charge" id="invoice_other_charge" class="form-control-sm invoice_other_charge" onkeyup="setCharge()" value="{{number_format($invoice_charge,2,'.','')}}">
                            </th>
                            <th></th>
                        </tr>
                        <tr>
                            <th colspan="15" class="text-right">Net Amount</th><th class="text-right">
                                <input type="number" name="net_amount" id="net_amount" class="form-control-sm net_amount" value="{{number_format(($total_fob_offer_g+$invoice_charge),2,'.','')}}" readonly></th>
                                <th></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
            <div class="row">
                <div class="col-12 text-right mt-2 mt-md-0">
                    <button class="btn btn-sm btn-primary btn-pill btn-sina-submit" style="position: fixed;bottom:10%;right:0" onclick="addRow()" type="button"
                        name="add_Row" id="add_Row"><i class="fas fa-plus"></i></button>
                </div>
            </div>
            <hr>
            
            <div class="row pb-0  modal-footer">
                <input class="btn-sina-submit" type="submit" id="save" value="save">
            </div>
        </form>
    </div>
</div>

@include('inventory.prepurchase.quotation.install_modal')
@endsection
@section('script')
<script>
    const store_setting = @json(store_info());
</script>
<script type="text/javascript" src="{{ asset('inventory/blade_js/common.js') }}"></script>
<script>
    var prev_curr_val=parseFloat("{{$quotation->roe}}");
    var price=[];
    let actual_price=[];
    // let p_ids=[];
    partySearch('customer',2,'.','');
    productSearch('new_product');
    pro_ids('new_product');

function getFormatedDate(dateToBeFormated){
    var now = new Date(dateToBeFormated);
    var day = ("0" + now.getDate()).slice(-2);
    var month = ("0" + (now.getMonth() + 1)).slice(-2);
    var return_date = now.getFullYear()+"-"+(month)+"-"+(day) ;
    return return_date;
}

function addRow(){
    var index=parseInt($('#index_num').val())+1;
    var returnData='';
    returnData+=`<tr id="tr-`+index+`">
                                <td>`+(index)+`</td>
                                <td>
                                    <div class="d-flex text-center">
                                        <select class="form-control new_product" style="width: 100%" id="product_id`+index+`"  name="product_id[`+index+`]" onchange="getPriviousCosting('`+index+`',this.value)">
                                            <option value=" ">-- Select Product --</option>
                                        </select>
                                    </div>
                                </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="unit_quantity[`+index+`]" id="unit_quantity`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="unit_price[`+index+`]" id="unit_price`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="ctn_price[`+index+`]" id="ctn_price`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="other_cost[`+index+`]" id="other_cost`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                            //  currency_conversion
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="commission[`+index+`]" id="commission`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="commission_total[`+index+`]" id="commission_total`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="fob[`+index+`]" id="fob`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="cbm[`+index+`]" id="cbm`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="qty[`+index+`]" id="qty`+index+`" step=".01" class="form-control-sm qty" value="0" onkeyup="setSubtotal('`+index+`')">  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="total_cbm[`+index+`]" id="total_cbm`+index+`" step=".01" class="form-control-sm cbm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input data-toggle="tooltip" title="" type="number" min="0" name="offer_fob[`+index+`]" id="offer_fob`+index+`" step=".01" class="form-control-sm" value="0" onkeyup="setSubtotal('`+index+`')">
                                                <input type="hidden" name="offer_fob_type[`+index+`]" id="offer_fob_type`+index+`" value="0">  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="profit[`+index+`]" id="profit`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="total_profit[`+index+`]" id="total_profit`+index+`" step=".01" class="form-control-sm total_profit" value="0" readonly>  
                                             </td>`;
                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" name="total_fob[`+index+`]" id="total_fob`+index+`" step=".01" class="form-control-sm total_fob" value="0" readonly>  
                                             </td>`;
                                // returnData+=`<td class="text-center">
                                //                 <input type="text" min="0" name="gp[`+index+`]" id="gp`+index+`" step=".01" class="form-control-sm" value="0" readonly>  
                                //              </td>`;
                                returnData+=`<td class="text-right">
                                                <div class="input-group text-right">  
                                                    <input type="number" min="0" step=".01"  name="gp[`+index+`]"
                                                        id="gp`+index+`" class="form-control-sm gp" readonly value="0" style="width:92%">
                                                    <div class="input-group-append" style="width:8%">
                                                        <button type="button" onclick="deleteRow(`+index+`)" class="btn btn-danger btn-sm">
                                                            <span class="fa fa-minus"></span><span class="btn_text-`+index+`"></span>
                                                        </button>
                                                    </div>
                                                </div>
                                            </td>
                                            </tr>`;
                                            // console.log(returnData);
                                            $('#index_num').val((index));
                                            $('#tbl_body').append(returnData);
                                            productSearch('new_product');
}
function getPriviousCosting(row_id,product_id){
    var party_id=$('#customer_id').val();
    if(party_id){
        $.ajaxSetup({
            headers: {
                "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
            },
        });
        $.ajax({
            type: "GET",
            url: "{{route('pre_sells.costing_search')}}",
            data: {
                // effect_date:effect_date,
                product_id:product_id,
                type:2,
                party_id:party_id,
            },
            success: function (data) {
                if(data){
                // if(data && data['party_price']){
                //    console.log(data);
                    var roe=parseFloat($('#roe').val());
                    // var roe= (prev_curr_val/current_roe);
                    var commission_rate=data['costing']?data['costing'].purchase_commission:0;
                    var otc=data['costing']?(parseFloat(data['costing'].other_cost)):0;
                    var crt_qty=parseFloat(data['product'].unit_quantity);
                    var cbm=parseFloat(data['product'].cbm);
                    var product_unit_price=(parseFloat(data['product'].buy_price));
                    //var qty=0;
                    actual_price[row_id]=product_unit_price;
                    var ctn_price=parseFloat(crt_qty*product_unit_price);
                    var commission_total=parseFloat(ctn_price*commission_rate);
                    var fob=(ctn_price+otc)-commission_total;
                // var cbm_total=parseFloat(qty*cbm);
                    $('#other_cost'+row_id).val(otc);
                    $('#commission'+row_id).val(parseFloat(commission_rate)*100);
                    $('#unit_quantity'+row_id).val(crt_qty);
                    $('#unit_price'+row_id).val(product_unit_price);
                    $('#ctn_price'+row_id).val(ctn_price);
                    $('#commission_total'+row_id).val(commission_total);
                    $('#fob'+row_id).val(parseFloat(fob/roe).toFixed(2));
                    $('#cbm'+row_id).val(cbm);
                    $('#offer_fob'+row_id).attr('title','');
                    if(data['party_price']){
                        $('#offer_fob_type'+row_id).val(0);
                        $('#offer_fob'+row_id).val(parseFloat(data['party_price'].price).toFixed(2));
                    }else{
                        $('#offer_fob_type'+row_id).val(1);
                        $('#offer_fob'+row_id).val(parseFloat(data['product'].sell_price).toFixed(2));
                        $('#offer_fob'+row_id).attr('title','Product Party Price Has Yet Not Set');
                        $('#offer_fob'+row_id).tooltip('show')
                    }
                    // var offer_price=(parseFloat(data['party_price'].price));
                    // var offer_price=(parseFloat(data['party_price'].price)*crt_qty);
                    // $('#offer_fob'+row_id).val(parseFloat(offer_price).toFixed(2));
                    // $('#qty'+row_id).val(0);
                    // $('#total_cbm'+row_id).val(cbm_total);$("#customers_select").val('').trigger('change')
                    getTotalQty();
                    
                }else{
                    alert('Product Not Fount In Party Price !!!');
                    //$('#product_id'+row_id).val('').trigger('change');
                }
                pro_ids('new_product');
                // var party_id=$('#customer_id').val();
                // if(party_id){
                //     getPartyPrice(2,party_id);
                // }
            },
            error: function (response) {
            },
        });
    }else{
        alert('Set Party First!!')
    }
}
// function getPriviousCosting(row_id,product_id){
//     var returnData;
//     // var effect_date=$('#effect_date').val();
//     // var product_id=$('#product_id'+row_id).val();
//     // var end=$('#end_date').val();
//     pro_ids('new_product');
//     $.ajaxSetup({
//         headers: {
//             "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
//         },
//     });
//     $.ajax({
//         type: "GET",
//         url: "{{route('pre_sells.costing_search')}}",
//         data: {
//             // effect_date:effect_date,
//             product_id:product_id,
//             type:2,
//         },
//         success: function (data) {
//             if(data){
               
//                var roe=parseFloat($('#roe').val());
//                // var roe= (prev_curr_val/current_roe);
//                var commission_rate=data['costing']?data['costing'].purchase_commission:0;
//                var otc=data['costing']?(parseFloat(data['costing'].other_cost)/roe):0;
//                var crt_qty=parseFloat(data['product'].unit_quantity);
//                var cbm=parseFloat(data['product'].cbm);
//                var product_unit_price=(parseFloat(data['product'].buy_price)/roe);
//                //var qty=0;

//                var ctn_price=parseFloat(crt_qty*product_unit_price);
//                var commission_total=parseFloat(ctn_price*commission_rate);
//                var fob=(ctn_price+otc)-commission_total;
//               // var cbm_total=parseFloat(qty*cbm);
//                $('#other_cost'+row_id).val(otc);
//                $('#commission'+row_id).val(parseFloat(commission_rate)*100);
//                $('#unit_quantity'+row_id).val(crt_qty);
//                $('#unit_price'+row_id).val(product_unit_price);
//                $('#ctn_price'+row_id).val(ctn_price);
//                $('#commission_total'+row_id).val(commission_total);
//                $('#fob'+row_id).val(fob);
//                $('#cbm'+row_id).val(cbm);
//                // $('#qty'+row_id).val(0);
//                // $('#total_cbm'+row_id).val(cbm_total);
//                getTotalQty();
//            }
              
//         },
//         error: function (response) {
//         },
//     });
// }
function setDataForQuotation(i){
    $('#requisition_id').val(i);
    returnData='';
    requisition=requsitionData[i];
    data=requisition.details;
    if(data.length>0){
                for (let index = 0; index < data.length; index++) {
                    returnData+=`<tr id="tr-`+index+`">
                                <td>`+(index+1)+`</td>
                                <td>
                                    <div class="d-flex text-center">
                                       `+data[index].product.name_eng+`
                                       <input type="hidden" name="product_id[`+index+`]" id="product_id`+index+`" class="form-control" value="`+data[index].product_id+`">
                                    </div>
                                </td>
                                <td>
                                    <input type="text" name="desc[`+index+`]" id="desc`+index+`" class="form-control">
                                </td>`;
                               // returnData+=` <td>`+data[index].quantity+`</td>`;

                                returnData+=`<td class="text-center">
                                    <input type="number" min="0"  name="req[`+index+`]"
                                    id="req`+index+`" step=".01" class="form-control-sm" value="`+data[index].quantity+`" readonly>  
                                </td>`;

                                returnData+=`<td class="text-center">
                                                <input type="number" min="0" onkeyup="setSubtotal('`+index+`')"  name="quantity[`+index+`]" id="quantity`+index+`" step=".01" class="form-control-sm" value="`+data[index].quantity+`">  

                                                </td>
                                            <td>
                                                <input type="number" onkeyup="setSubtotal('`+index+`')" min="0" step=".01"  name="rate[`+index+`]"
                                                    id="rate`+index+`" class="form-control-sm" value="0">
                                            </td>
                                            <td class="text-right">
                                                <input type="number" min="0" step=".01"  name="subtotal[`+index+`]"
                                                    id="subtotal`+index+`" class="form-control-sm subtotal" readonly value="0">
                                            </td>
                                            </tr>`;
                $('#index_num').val('');
                $('#index_num').val(parseInt(index)+1);
                }
            }
            $('#tbl_body').html(returnData);
            getSum();
            $("#install_model").modal("hide");
}
function getTotalQty(){
        var sum=0;
        $('.qty').each(function(){
            sum += parseFloat(this.value);
        });
        $('#total_qty').val(sum);
        getTotalCbm();
        getTotalProfit();
        setCharge();
}
function getTotalCbm(){
        var sum=0;
        $('.cbm').each(function(){
            sum += parseFloat(this.value);
        });
        $('#total_cbm').val(sum);
}
function getTotalProfit(){
        var total_profit=0;
        var total_fob=0;
        $('.total_profit').each(function(){
            total_profit += parseFloat(this.value);
        });
        $('#gross_total_profit').val(total_profit);

        $('.total_fob').each(function(){
            total_fob += parseFloat(this.value);
        });
        $('#gross_total_fob').val(total_fob);
        $('#gross_gp').val((total_profit/total_fob)*100);

}

function setSubtotal(row_id){
    var roe=parseFloat($('#roe').val());//new
    var commission_rate=(parseFloat($('#commission'+row_id).val())/100);
    var otc=parseFloat($('#other_cost'+row_id).val());
    var crt_qty=parseFloat($('#unit_quantity'+row_id).val());
    var cbm=parseFloat($('#cbm'+row_id).val());
    var product_unit_price=parseFloat($('#unit_price'+row_id).val());
    var qty=parseFloat($('#qty'+row_id).val());
    var offer_fob=parseFloat($('#offer_fob'+row_id).val());

    var ctn_price=parseFloat(crt_qty*product_unit_price);
    var commission_total=parseFloat(ctn_price*commission_rate);
     // var fob=(ctn_price+otc)-commission_total;
     var fob=((ctn_price+otc)-commission_total)/roe;//new
    var cbm_total=parseFloat(qty*cbm);


    var profit=(offer_fob-fob);
    var total_profit=profit*qty;
    var total_fob=offer_fob*qty;
    var gp=((total_profit/total_fob)*100);

    $('#other_cost'+row_id).val(otc);
    $('#commission'+row_id).val(parseFloat(commission_rate)*100);
    $('#unit_quantity'+row_id).val(crt_qty);
    $('#unit_price'+row_id).val(product_unit_price);
    $('#ctn_price'+row_id).val(ctn_price);
    $('#commission_total'+row_id).val(commission_total);
    $('#fob'+row_id).val(fob);
    $('#cbm'+row_id).val(cbm);
    
    $('#qty'+row_id).val(qty);
    $('#total_cbm'+row_id).val(cbm_total);
    $('#offer_fob'+row_id).val(offer_fob);
    $('#profit'+row_id).val(profit);
    $('#total_profit'+row_id).val(total_profit);
    $('#total_fob'+row_id).val(total_fob);
    $('#gp'+row_id).val(gp);
    getTotalQty();
}
function setCharge(){
        var total=parseFloat($('#gross_total_fob').val());
        var discount_amount=(parseFloat($('#invoice_other_charge').val()));
        $('#net_amount').val(total+discount_amount);
}
function deleteRow(row_id){
    $('#tr-'+row_id).remove();
    getTotalQty();
}
// function initSelect2(){
//     productSearch('new_product');
// }

function currencyChange(current_roe) { 
    if (current_roe == -1) {
        current_roe = $('#currency option:selected').attr('roe');
        currency_id = $('#currency').val();
        $('#currency_id').val(parseFloat(currency_id));
    }
    $('#roe').val(parseFloat(current_roe));
    // alert(current_roe);
    // $('.currency_conversion').each(function(i) { 
    //     price[i] = parseFloat((this.value*prev_curr_val)/current_roe);
    //     this.value=price[i];
    // });
    var row=parseInt($('#index_num').val());
    for (let p = 0; p < row; p++) {
        setSubtotal((p+1));
    } 
        prev_curr_val = current_roe; 
}
</script>
@stop