@extends('admin.layout.master')
@section('title','WORK ORDER MANAGEMENT')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 35px !important;
        max-width: 75px;
    }
   
    .table th, .table td {
        padding: 0px 5px;
        color: black;
    }
    .table th {
        background: #ab3535;
        padding: 5px !important;
        color: white !important;
    }
    .table-bordered th, .table-bordered td {
        border: 1px solid #c1c1c1 !important;
    }

</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s">
        <h4>WORK ORDER</h4>
    </div>
    <div class="card-body">
         
        <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />
        <form id="form1" method="post" action="{{ route('pre_sells.wo_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">
                                <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                                    <div class="col-3 px-0">
                                        <label for="note">Supplier</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <select name="vendor_id" id="vendor_id" class="form-control vendor" required>
                                            {{-- <option value="{{$quotation->party_id}}">{{$quotation->party->name_eng}}</option> --}}
                                        </select>
                                       
                                    </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="note">DESCRIPTION</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        <textarea name="note" class="form-control-sm" id="note" cols="30" rows="10">{{$quotation->note}}</textarea>
                                        {{-- <input type="text" class="form-control" name="note" id="note" value="{{$quotation->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="reference">REFERENCE NO</label>
                                    </div>
                                    <div class="col-9 px-0">
                                        {{-- <textarea name="note" class="form-control-sm" id="note" cols="30" rows="10"></textarea> --}}
                                        <input type="text" class="form-control" name="reference" id="reference" value="{{$quotation->reference}}">
                                        
                                    </div>
                                </div>
                            </div>
                        </div>
                </div>
            </div> 
            {{-- end --}}
            <hr>
            <div class="table-responsive">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>PRODUCT</th>
                            <th>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>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>piece</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;
                        @endphp
                        @forelse ($quotation->details->where('ordered',0) as $k=>$item)
                        <tr id="tr-`+index+`">
                            <td>{{++$i}}</td>
                            <td class="text-left">
                                <div class="checkbox">
                                    <input  type="checkbox" class="{{strtolower($item->id)}}-select" name="assigned_products[{{$i}}]" value="{{$item->id}}">
                                    <label for="demo-form-checkbox">{{$item->product->name_eng}}</label>
                                </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>  
                                <input type="hidden" min="0" name="product_id[{{$i}}]" id="product_id{{$i}}" step=".01" class="form-control-sm" value="{{$item->product_id}}" 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="{{$item->unit_price}}" 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="{{$ctn_price=($item->unit_size*$item->unit_price)}}" 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="{{$item->other_cost}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="commission[{{$i}}]" id="commission{{$i}}" step=".01" class="form-control-sm" value="{{($item->commission_rate*100)}}" 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="{{$commission_total=($item->commission_rate*$ctn_price)}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="fob[{{$i}}]" id="fob{{$i}}" step=".01" class="form-control-sm" value="{{$fob=(($ctn_price+$item->other_cost)-$commission_total)}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="cbm[{{$i}}]" id="cbm{{$i}}" step=".01" class="form-control-sm" value="{{$item->cbm_unit}}" 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="{{$item->qty}}" onkeyup="setSubtotal('{{$i}}')" readonly>  
                                         </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="{{$tcbm=($item->cbm_unit*$item->qty)}}" readonly>  
                                         </td>
                            <td class="text-center">
                                            <input type="number" min="0" name="offer_fob[{{$i}}]" id="offer_fob{{$i}}" step=".01" class="form-control-sm" value="{{$item->offer_fob_unit}}" onkeyup="setSubtotal('{{$i}}')">  
                                         </td>
                            <td class="text-center">
                                            <input type="text" min="0" name="profit[{{$i}}]" id="profit{{$i}}" step=".01" class="form-control-sm" value="{{$profit_unit=($item->offer_fob_unit-$fob)}}" 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="{{$profit_total=($profit_unit*$item->qty)}}" 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="{{$total_fob_offer=($item->offer_fob_unit*$item->qty)}}" 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="{{($profit_total/$total_fob_offer)*100}}" 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
                            <tr><th colspan="5">No Product Available for Order</th></tr>
                        @endforelse
                    </tbody>
                    <input type="hidden" name="" id="index_num" value="{{($i)}}">
                    <tfoot>
                        <tr>
                            <th colspan="3" class="text-right">Total</th>
                            <th class="text-center">
                                <input type="number" min="0" step=".01"  name="total_qty" id="total_qty" value="{{$total_qty}}" 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="{{$total_tcbm}}" 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="{{$total_gprofit}}" 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="{{$total_fob_offer_g}}" class="form-control-sm" readonly>
                            </th>
                            <th class="text-right">
                                <input type="number" min="0" step=".01"  name="gross_gp" id="gross_gp" value="{{(($total_gprofit/$total_fob_offer_g)*100)}}" class="form-control-sm" readonly>
                            </th> --}}
                        </tr>
                        {{-- <tr>
                            <th colspan="15" class="text-right">Add, Other Charge</th>
                            <th class="text-right">
                                <input type="number" step=".01"  name="invoice_other_charge" id="invoice_other_charge" class="form-control-sm invoice_other_charge" onkeyup="setCharge()" value="{{$quotation->invoice_charge}}">
                            </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="{{$total_fob_offer_g+$quotation->invoice_charge}}" 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>
    let requsitionData=[];
    // let p_ids=[];
    partySearch('vendor',1);
    // 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="text" 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="text" 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="text" 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>`;
                                // 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+`" data-id="`+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 type="number" min="0" name="offer_fob[`+index+`]" id="offer_fob`+index+`" step=".01" class="form-control-sm" value="0" onkeyup="setSubtotal('`+index+`')">  
                                //              </td>`;
                                // returnData+=`<td class="text-center">
                                //                 <input type="text" 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="text" 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="text" 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>`;
                                returnData+=`</tr>`;
                                            // console.log(returnData);
                                            $('#index_num').val((index));
                                            $('#tbl_body').append(returnData);
                                            productSearch('new_product');
}
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) {
            console.log(data);
            if(data){
                var commission_rate=data['costing']?data['costing'].purchase_commission:0;
                var otc=data['costing']?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;

                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 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 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();
    getSum();
}
// function initSelect2(){
//     productSearch('new_product');
// }
</script>
@stop