@extends('admin.layout.master')
@section('title','QUOTATION MANAGEMENT')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 35px !important;
    }
    .table th, .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           background: #ab3535;
           padding: 5px !important;
           color: white !important;
        }

</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s">
        <h4>QUOTATION</h4>
    </div>
    <div class="card-body">
         
        <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />
        <div class="row justify-content-end">
            <div class="col-3 pl-0">
                <label for="requisition_search">Requisition No</label>
                <select id="requisition_search" class="form-control" name="requisition_search">          
                </select>
            </div>
            <div class="col-4 pl-0">
                <label>Date</label>
                <div class="input-group">
                    <div class="input-group input-group-append">
                        <input type="date" class="form-control bsdatepicker" id="start_date" name="start_date" value="{{Request()->start_date?date('Y-m-d',strtotime(Request()->start_date)):date('Y-m-d')}}">
                        <label class="input-group-text" style="height: 28px; margin-left: -2px; margin-right: -2px">To</label>
                        <input type="date" class="form-control bsdatepicker" id="end_date" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):date('Y-m-d')}}"> 
                
                        <button type="button" style="height: 28px; margin-left: -2px"  onclick="getRequisitionData()" class="btn btn-sm btn-pill btn-sm btn-hover btn-danger">
                            <i class="fa fa-search"></i>
                        </button>
                    </div>
                </div>
            </div>
          
        </div>
        {{-- <div class="row mb-1" style="border:dashed 1px green">
            <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                <div class="col-5 px-0">
                    <label for="pay_type">Requisition No</label>
                    
                </div>
                <div class="col-7 px-0">
                        <select id="requisition_search" class="form-control" name="requisition_search">
                            
                        </select>
                    </div>
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-3">
                    <div class="col-2 px-0">
                        <label for="cost_id">FROM</label>
                    </div>
                    <div class="col-10 px-0">
                        <input type="date" class="form-control" id="start_date">
                    </div>
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-3">
                    <div class="col-2 px-0">
                        <label for="cost_id">TO</label>
                    </div>
                    <div class="col-10 px-0">
                        <input type="date" class="form-control" id="end_date">
                    </div>
                </div>
                <div class="col-md-2 col-12 d-flex flex-wrap pr-0 mb-3">
                    <div class="col-12 px-0">
                        <div class="input-group">
                            <span class="input-group-text">Install</span>
                            <div class="input-group-append">
                                <button type="button" class="btn btn-danger" onclick="getRequisitionData()">
                                    <span class="fa fa-download"></span>
                                </button>
                            </div>
                            
                        </div>
                    </div>
                </div>
                
        </div> --}}
        <fieldset style="border: 1px groove #663399 !important;padding: 0 1.4em 1.4em 1.4em !important; margin: 0 0 2em 0 !important;-webkit-box-shadow:  0px 0px 0px 0px #000;box-shadow:  0px 0px 0px 0px #000;">
            <legend style="width:inherit;padding:0 10px;border-bottom:none;font-size: 18px">QUOTATION</legend>
        <form id="form1" method="post" action="{{ route('prepurchase.quotation_store') }}" enctype="multipart/form-data">
            @csrf
            <div>
                <div class="row mb-1">
                    <input type="hidden" name="requisition_id" id="requisition_id" value="{{Request()->requisition_id}}">
                    <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                        <div class="col-3 px-0">
                            <label for="note">Vendor</label>
                        </div>
                        <div class="col-9 px-0">
                            <select name="vendor_id" id="vendor_id" class="form-control vendor" required>
                                
                            </select>
                            
                        </div>
                    </div>
                    {{-- <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-3">
                        <div class="col-2 px-0">
                            <label for="note">Batch Qty</label>
                        </div>
                        <div class="col-10 px-0">
                            <input type="text" class="form-control" name="b_qty" min="1" id="b_qty" value="1" onkeyup="setQtyToRawProduct()">
                            <input type="hidden" class="form-control" name="s_qty" id="s_qty" value="0">
                        </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">
                            
                        </div>
                    </div>
                </div>
                <div class="table-responsive">
                    <table class="table table-bordered table-hover">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>PRODUCT</th>
                                <th>NOTE</th>
                                <th>Req. QTY</th>
                                <th>Quotation Qty</th>
                                <th>Unit Price</th>
                                <th>Subtotal</th>
                            </tr>
                        </thead>
                        <tbody id="tbl_body">
                            @php
                                $i=0;
                            @endphp
                            @if($requisition)
                            @forelse ($requisition->details as $p=>$item)
                                
                            
                                <tr id="tr{{ $i }}">
                                    <td>{{ ($i+1) }}</td>
                                    <td>
                                        <div class="d-flex text-center">
                                            {{$item->product->name_eng}}
                                            <input type="hidden" name="product_id[{{$i}}]" value="{{$item->product_id}}">
                                        
                                        </div>
                                    </td>
                                    <td>
                                        <input type="text" name="desc[{{$i}}]" id="desc{{ $i }}" class="form-control">
                                    </td>
                                    {{-- <td class="text-center">
                                        {{$item->quantity}} 
                                    </td> --}}
                                    <td class="text-center">
                                        <input type="number" min="0" step=".01"  name="req[{{$i}}]"
                                        id="req{{ $i }}" class="form-control-sm" value="{{$item->quantity}}" readonly>
                                        
                                    </td>
                                    <td>
                                        <input type="number" onkeyup="setSubtotal('{{$i}}')" min="0" step=".01" value="{{$item->quantity}}"  name="quantity[{{$i}}]"
                                            id="quantity{{$i}}" class="form-control-sm">
                                    </td>
                                    <td>
                                        <input type="number" onkeyup="setSubtotal('{{$i}}')" min="0" step=".01"  name="rate[{{$i}}]"
                                            id="rate{{$i}}" class="form-control-sm" value="0">
                                    </td>
                                    <td class="text-left">
                                        <input type="number" min="0" step=".01"  name="subtotal[{{$i}}]"
                                            id="subtotal{{$i}}" class="form-control-sm subtotal" readonly value="0">
                                    </td>
                                </tr>
                                @php
                                    $i++;
                                @endphp
                                @empty
                                
                            @endforelse
                            @endif
                        </tbody>
                        <input type="hidden" name="" id="index_num" value="{{($i)}}">
                        <tfoot>
                            <tr  style="padding-top:2px !important; border-top: black 2px solid !important;">
                                <td colspan="6" class="text-right">Total</td><td class="text-left"> <input type="number" min="0" step=".01"  name="total_amount"
                                                        id="total_amount" class="form-control-sm total_amount" readonly></td></tr>
                            <tr>
                                <td colspan="4" class="text-right">Discount (%)</td><td class="text-right"> <input type="number" max="100" step=".01"  name="discount"
                                id="discount" class="form-control-sm discount" onkeyup="setDiscount()" value="0"></td><td class="text-right">Discount (Amount)</td><td class="text-left"> <input type="number"  name="discount_amount"
                                id="discount_amount" class="form-control-sm discount_amount" readonly></td>
                            </tr>
                            <tr>
                                <td colspan="6" class="text-right">Net Amount</td><td class="text-left"> <input type="number"  name="net_amount"
                                id="net_amount" class="form-control-sm net_amount" readonly></td>
                            </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>
                <div class="row pb-0  modal-footer">
                    <input class="btn-sina-submit" type="submit" id="save" value="save">
                </div>
            </div>
        </form>
        </fieldset>
    </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=[];
    // $('.select2').select2();
    $('#requisition_search').select2({
                minimumInputLength: 3,
                // tags: [],
                ajax: {
                    url: "/quotation/create",
                    dataType: 'json',
                    type: "GET",
                    quietMillis: 0,
                    data: function (term) {
                        return {
                            type: 2,
                            name: term
                        };
                    },
                    processResults: function (data) {
                        return {
                            results: $.map(data, function (item) {
                                return {
                                    text: item.requisition_no,
                                    id: item.id
                                }
                            })
                        };
                    }
                }                                                   
            });
            partySearch('vendor',1);
    // $('#vendor_id').select2({
    //     minimumInputLength: 3,
    //     // tags: [],
    //     ajax: {
    //         url: "{{route('vendor.index')}}",
    //         dataType: 'json',
    //         type: "GET",
    //         quietMillis: 0,
    //         data: function (term) {
    //             return {
    //                 type: 2,
    //                 name: term
    //             };
    //         },
    //         processResults: function (data) {
    //             return {
    //                 results: $.map(data, function (item) {
    //                     return {
    //                         text: item.name_eng,
    //                         id: item.id
    //                     }
    //                 })
    //             };
    //         }
    //     }                                                   
    // });

function getRequisitionData(){
    $('#install_model_table').dataTable().fnDestroy();
    $('#install_model_tbody').empty();
    var returnData;
    var start=$('#start_date').val();
    var end=$('#end_date').val();
    $.ajaxSetup({
        headers: {
            "X-CSRF-TOKEN": $('meta[name="csrf-token"]').attr("content"),
        },
    });
    $.ajax({
        type: "GET",
        url: "/quotation/create",
        data: {
            start:start,
            end:end,
            type:3,
        },
        success: function (data) {
            console.log(data);
            if(data.length>0){
                for (let index = 0; index < data.length; index++) {
                    requsitionData[data[index].id]=data[index];
                    returnData+=`<tr onclick="setDataForQuotation(`+data[index].id+`)" role="row" class="odd">
                                    <td class="sorting_1">`+(index+1)+`</td>
                                    <td class="tr_td_group_code-205">`+data[index].requisition_no+`</td>
                                    <td class="tr_td_title-205"><b>`+getFormatedDate(data[index].created_at)+`</b></td>
                                </tr>`;
                }
            }
            
            $('#install_model_tbody').html(returnData);
            $("#install_model").modal("show");
            $('#install_model_table').DataTable({
                "destroy": true,
            });
        },
        error: function (response) {
            // $('#load_tbody_previous_recipe_model').empty();
        },
    });
}
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%" name="product_id[`+index+`]">
                                            <option value=" ">-- Select Product --</option>
                                        </select>
                                    </div>
                                </td>
                                <td>
                                    <input type="text" name="desc[`+index+`]" id="desc`+index+`" class="form-control">
                                </td>`;
                                // returnData+=` <td class="text-center">0</td>`;
                                returnData+=` <td class="text-center"> <input type="number" min="0"  name="req[`+index+`]"
                                    id="req`+index+`" step=".01" class="form-control-sm" value="0" 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="0">  

                                                </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-left">
                                                <div class="input-group text-left">  
                                                    <input type="number" min="0" step=".01"  name="subtotal[`+index+`]"
                                                        id="subtotal`+index+`" class="form-control-sm subtotal" readonly value="0">
                                                    <div class="input-group-append">
                                                        <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);
                                    initSelect2();
}

function setDataForQuotation(i){
    $('#requisition_id').val(i);
    returnData='';
    // var requisition=requsitionData[i];
    data=requsitionData[i].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-left">
                                                <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);
                }
            }
            // returnData+=`<tr>
            //                 <th colspan="6" class="text-right">Total</th><th> <input type="number" min="0" step=".01"  name="total_amount"
            //                                         id="total_amount" class="form-control-sm total_amount" readonly></th></tr>
            //             <tr>
            //                 <th colspan="6" class="text-right">Discount (%)</th><th> <input type="number" max="100" step=".01"  name="discount"
            //                 id="discount" class="form-control-sm discount"></th><th> <input type="number"  name="discount_amount"
            //                 id="discount_amount" class="form-control-sm discount_amount" readonly></th>
            //             </tr>
            //             <tr>
            //                 <th colspan="6" class="text-right">Net Amount</th><th> <input type="number"  name="net_amount"
            //                 id="net_amount" class="form-control-sm net_amount" readonly></th>
            //             </tr>`;
            $('#tbl_body').html(returnData);
            getSum();
            $("#install_model").modal("hide");
}
function getSum(){
        var sum=0;
        $('.subtotal').each(function(){
            sum += parseFloat(this.value);
        });
        $('#total_amount').val(sum);
        setDiscount();
}
function setSubtotal(i){
        var subtotal=0;
        var qty=parseFloat($('#quantity'+i).val());
        var rate=parseFloat($('#rate'+i).val());
        $('#subtotal'+i).val((qty*rate));
        getSum();
        setDiscount();
}
function setDiscount(){
        var total=0;
        var discount_amount=0;
        var discount_rate=(parseFloat($('#discount').val())/100);
        total=$('#total_amount').val();
        discount_amount=(discount_rate*total)
        $('#discount_amount').val(discount_amount);
        $('#net_amount').val(total-discount_amount);
        // getSum();
}
function deleteRow(row_id){
    $('#tr-'+row_id).remove();
    getSum();
}
function initSelect2(){
    productSearch('new_product');
}
</script>
@stop