@extends('admin.layout.master')
@section('title','PURCHASE ORDER MANAGEMENT')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 24px !important;
    }
    .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           background: var(--cl-primary);
           padding: 5px !important;
           color: white !important;
        }

</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s">
        <h4>{{__('obs.purchase')}} {{__('obs.order')}}</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="quotation_search">{{__('obs.quotation')}} {{__('obs.no')}}</label>
                    <select id="quotation_search" class="form-control" name="quotation_search">
                    </select>
                </div>
                <div class="col-6 pl-0">
                    <label>{{__('obs.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: 24px; margin-left: -2px; margin-right: -2px">{{__('obs.date_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: 24px; margin-left: -2px"  onclick="getQuotationData()" class="btn btn-sm btn-pill btn-sm btn-hover btn-danger">
                                <i class="fa fa-search"></i>
                            </button>
                        </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">{{__('obs.po')}}</legend>
            <form id="form1" method="post" action="{{ route('prepurchase.po_store') }}" enctype="multipart/form-data">
                @csrf
                <div>
                    <div class="row mb-1">
                        <input type="hidden" name="quotation_id" id="quotation_id" value="{{Request()->quotation_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">{{__('obs.vendor')}}</label>
                            </div>
                            <div class="col-9 px-0">
                                <select name="vendor_id" id="vendor_id" class="form-control vendor" required onchange="/*getProducts();*/">
                                    @if($quotation)
                                        <option value="{{$quotation->supplier_id}}">{{$quotation->supplier->name_eng}}</option>
                                    @endif
                                </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">{{__('obs.description')}}</label>
                            </div>
                            <div class="col-9 px-0">
                                <input type="text" class="form-control" 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="reference">{{__('obs.reference')}} {{__('obs.no')}}</label>
                            </div>
                            <div class="col-9 px-0"> 
                                <input type="text" class="form-control" name="reference" id="reference" value="">
                                
                            </div>
                        </div>
                    </div>
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th width="5%">#</th>
                                    <th width="40%">{{__('obs.product')}}</th> 
                                    <th width="15%">{{__('obs.note')}}</th>
                                    <th width="10%">{{__('obs.quotation')}} {{__('obs.qty')}}</th>
                                    <th width="10%">{{__('obs.purchase.')}} {{__('obs.qty')}}</th>
                                    <th width="10%">{{__('obs.unit')}} {{__('obs.price')}}</th>
                                    <th width="10%">{{__('obs.subtotal')}}</th>
                                </tr>
                            </thead>
                            <tbody id="tbl_body">
                                @php
                                    $i=0;
                                    $grandtotal=0;
                                @endphp
                                @if($quotation)
                                    @forelse ($quotation->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">
                                                <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="{{$item->rate}}">
                                                    <input type="hidden" name="quotation_rate[{{$i}}]" value="{{$item->rate}}">
                                            </td>
                                            <td class="text-right">
                                                @php
                                                    $grandtotal+=$subTotal=($item->quantity*$item->rate);
                                                @endphp
                                                <input type="number" min="0" step=".01"  name="subtotal[{{$i}}]" id="subtotal{{$i}}" class="form-control-sm subtotal" readonly value="{{$subTotal}}">
                                            </td>
                                        </tr>
                                        @php
                                            $i++;
                                        @endphp
                                        @empty
                                        
                                    @endforelse
                                @endif
                            </tbody>
                            <input type="hidden" name="" id="index_num" value="{{($i)}}">
                            <tfoot>
                                <tr>
                                    <td colspan="6" class="text-right">{{__('obs.total')}}</td>
                                    <td class="text-right"> <input type="number" min="0" step=".01"  name="total_amount" id="total_amount" class="form-control-sm total_amount" value="{{$grandtotal}}" readonly></td>
                                </tr>
                                <tr>
                                    <td colspan="4" class="text-right">{{__('obs.discount')}} {{__('obs.(%)')}}</td>
                                    <td class="text-right"> <input type="number" max="100" step=".01"  name="discount" id="discount" class="form-control-sm discount" onkeyup="setDiscount()" value="{{$quotation?$quotation->discount:0}}"></td>
                                    <td class="text-right">{{__('obs.discount')}} ({{__('obs.amount')}})</td>
                                    @php
                                        $discountAmount=$quotation?(($quotation->discount/100)*$grandtotal):0
                                    @endphp
                                    <td class="text-right"> <input type="number"  name="discount_amount" id="discount_amount" class="form-control-sm discount_amount" readonly value="{{$discountAmount}}"></td>
                                </tr>
                                <tr>
                                    <td colspan="6" class="text-right">{{__('obs.net')}} {{__('obs.amount')}}</td><td class="text-right"> <input type="number"  name="net_amount" id="net_amount" class="form-control-sm net_amount" value="{{($grandtotal-$discountAmount)}}" 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.po.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 quotationData=[];
        let rowForCallMethod=[]; 
        $('#quotation_search').select2({
            minimumInputLength: 3,
            // tags: [],
            ajax: {
                url: "/po/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.quotation_no,
                                id: item.id
                            }
                        })
                    };
                }
            }                                                   
        });
        partySearch('vendor', 1);
        // $('#vendor_id').select2({
        //     minimumInputLength: 3, 
        //     ajax: {
        //         url: "{{route('vendor.index')}}",
        //         dataType: 'json',
        //         type: "GET",
        //         quietMillis: 0,
        //         data: function (term) {
        //             return {
        //                 type: 1,
        //                 name: term
        //             };
        //         },
        //         processResults: function (data) {
        //             return {
        //                 results: $.map(data, function (item) {
        //                     return {
        //                         text: item.name_eng,
        //                         id: item.id
        //                     }
        //                 })
        //             };
        //         }
        //     }                                                   
        // });

        function getQuotationData(){
            $('#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: "/po/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++) {
                            quotationData[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].quotation_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">
                                                            <input type="hidden" name="quotation_rate[`+index+`]" id="quotation_rate`+index+`" class="form-control" value="0">
                                                    </td>
                                                    <td class="text-right">
                                                        <div class="input-group text-right">  
                                                            <input type="number" min="0" step=".01"  name="subtotal[`+index+`]"
                                                                id="subtotal`+index+`" style="width:90%" class="form-control-sm subtotal" readonly value="0">
                                                            <div class="input-group-append" style="width:10%">
                                                                <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>`;
                                                    $('#index_num').val((index));
                                            $('#tbl_body').append(returnData);
                                            initSelect2();
        }

        function setDataForQuotation(i){
            $('#quotation_id').val(i);
            returnData='';
            var quotation=quotationData[i];
            $('#vendor_id').html(`<option value="`+quotation.supplier_id+`">`+quotation.supplier.name_eng+`</option>`);
            $('#discount').val(quotation.discount);
            data=quotation.details;
            if(data.length>0){
                        for (let index = 0; index < data.length; index++) {
                            rowForCallMethod[index]=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+`">  
                                                        <input type="hidden" name="quotation_rate[`+index+`]" id="quotation_rate`+index+`" class="form-control" value="`+data[index].rate+`">
                                                        </td>
                                                    <td>
                                                        <input type="number" onkeyup="setSubtotal('`+index+`')" min="0" step=".01"  name="rate[`+index+`]"
                                                            id="rate`+index+`" class="form-control-sm" value="`+data[index].rate+`">
                                                    </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);
                        }
                        
                    }
                    // 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);
                    if(rowForCallMethod.length>0){
                        for (let p = 0; p < rowForCallMethod.length; p++) {
                            setSubtotal(p);
                        }
                    }
                    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');
            // $('.new_product').select2({
            //             minimumInputLength: 3,
            //             // tags: [],
            //             ajax: {
            //                 url: "/product-live-search",
            //                 dataType: 'json',
            //                 type: "POST",
            //                 quietMillis: 50,
            //                 data: function (term) {
            //                     return {
            //                         _token: "{{ csrf_token() }}",
            //                         type: 2,
            //                         p_ids: [],
            //                         name: term
            //                     };
            //                 },
            //                 processResults: function (data) {
            //                     return {
            //                         results: $.map(data, function (item) {
            //                             return {
            //                                 text: item.name_eng + ' -- ' + item.barcode,
            //                                 id: item.id
            //                             }
            //                         })
            //                     };
            //                 }
            //             }                                                   
            //         });
        }
        
    </script>
@stop