@extends('admin.layout.master')
@section('title','PURCHASE ORDER 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>PURCHASE 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">Quotation No</label>
                    <select id="quotation_search" class="form-control" name="quotation_search">
                    </select>
                </div>
                <div class="col-6 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="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">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">Vendor</label>
                            </div>
                            <div class="col-9 px-0">
                                <select name="vendor_id" id="vendor_id" class="form-control vendor" required>
                                    @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">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">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="">
                                
                            </div>
                        </div>
                    </div>
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th width="5%">#</th>
                                    <th width="40%">PRODUCT</th>
                                    {{-- <th width="45%">PRODUCT</th> --}}
                                    <th width="15%">NOTE</th>
                                    <th width="10%">Quotation Qty</th>
                                    <th width="10%">Purchase. QTY</th>
                                    <th width="10%">Unit Price</th>
                                    <th width="10%">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">
                                                {{$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="{{$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">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">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="{{$quotation?$quotation->discount:0}}"></td>
                                    <td class="text-right">Discount (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">Net 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=[];
    // $('.select2').select2();
    $('#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
                                }
                            })
                        };
                    }
                }                                                   
            });

    $('#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 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