@extends('admin.layout.master')
@section('title','REQUISITION 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>REQUISITION</h4>
    </div>
    <div class="card-body">

        <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />

            <form id="form" method="get" action="{{ route('prepurchase.requisition_create') }}" name="form" enctype="multipart/form-data">
                <div class="row justify-content-end">
                    {{-- <div class="input-group col-3">
                        <label for="product_id">Product</label>
                        <select class="product_live form-control" style="width: 100%" name="product_id[]" id="product_id">

                        </select>
                    </div>  --}}
                    <div class="input-group col-3">
                        <label for="category_id">Category</label>
                        <select class="form-control select_2" style="width: 100%" name="category_code" id="category_id">
                            <option value="" selected> -- Select Category -- </option>
                            @forelse ($categories as $cat)
                                <option value="{{$cat->code}}" > {{$cat->name_eng .' ('. $cat->code.')'}} </option>

                                @forelse ($cat->child as $sub_cat)
                                    <option value="{{$sub_cat->code}}">&nbsp;&nbsp; {{$sub_cat->name_eng}}</option>

                                    @forelse ($sub_cat->child as $sub_sub_cat)
                                        <option value="{{$sub_sub_cat->code}}">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {{$sub_sub_cat->name_eng}}</option>
                                    @empty

                                    @endforelse
                                @empty

                                @endforelse
                            @empty

                            @endforelse
                        </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="submit" style="height: 28px; margin-left: -2px" class="btn btn-pill btn-sm btn-hover btn-danger">
                                    <i class="fa fa-search"></i>
                                </button>
                            </div>
                        </div>
                    </div>

                </div>

            </form>
        <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">REQUISITION</legend>
            <form id="form" method="post" action="{{ route('prepurchase.requisition_store') }}" name="form" enctype="multipart/form-data">
                @csrf
                <div class="tab-content">
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>PRODUCT</th>
                                    <th>NOTE</th>
                                    <th>Available Qty</th>
                                    <th>Pre Purchase Date</th>
                                    <th>Pre Purchase Rate</th>
                                    <th>Req. QTY</th>
                                    <th>Approx Rate</th>
                                    <th>Total</th>
                                </tr>
                            </thead>
                            <tbody id="tbl_body">
                                @php
                                    $i=0;
                                @endphp
                                @forelse ($products as $item)


                                    <tr id="tr{{ $i }}">
                                        <td>{{ (++$i) }}</td>
                                        <td>
                                            <div class="d-flex">
                                                <div class="col-10">
                                                    {{$item->name_eng}}
                                                </div>
                                                <div class="col-10">
                                                    <span class="badge badge-secondary text-right">{{$item->primaryUnit?$item->primaryUnit->name:''}}</span>
                                                </div>
                                            <input type="hidden" name="product_id[{{$i}}]" value="{{$item->id}}">
                                            </div>
                                        </td>
                                        <td>
                                            <input type="text" name="desc[{{$i}}]" id="desc{{ $i }}" class="form-control">
                                        </td>
                                        <td class="text-right">
                                            {{-- @php
                                                $qty=0;
                                                if($item->transactions){
                                                    $qty= $item->transactions->where('dr_cr',1)->sum('quantity');
                                                    }

                                            @endphp
                                            {{$qty}} --}}
                                            {{ $item->availQty->avail ?? 0 }}

                                        </td>
                                        <td text-align="center">
                                            {{ count($item->getPreviousPurchaseHistory) > 0 ? date('d-m-Y', strtotime($item->getPreviousPurchaseHistory[0]->date)) : 'No Purchase Info Found'}}
                                        </td>
                                        <td text-align="center">
                                            {{ count($item->getPreviousPurchaseHistory) > 0 ? $item->getPreviousPurchaseHistory[0]->price : 'No Purchase Info Found'}}
                                        </td>
                                        <td>
                                            <input type="number" min="0"  name="quantity[{{$i}}]"
                                                id="quantity{{ $i }}" class="form-control">
                                        </td>
                                        <td class="text-right">
                                            <input type="text" onkeyup="setSubtotal({{ $i }})" name="approx_rate[{{ $i }}]" id="approx_rate{{ $i }}" class="form-control">
                                        </td>
                                        <td class="d-flex" nowrap>
                                            <input type="text" name="" id="total{{ $i }}" class="form-control" readonly>
                                        </td>
                                    </tr>
                                    @empty

                                @endforelse

                            </tbody>
                            <input type="hidden" name="" id="index_num" value="{{($i)}}">
                        </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:15%;right:0" onclick="addRow()" type="button"
                                name="add_Row" id="add_Row"><i class="fas fa-plus"></i></button>
                            <button class="btn btn-sm btn-primary btn-pill btn-sina-submit" type="submit" style="position: fixed;bottom:8%;right:0;">SUBMIT</i></button>
                        </div>
                    </div>
                </div>
            </form>
        </fieldset>
    </div>
</div>

{{-- @include('inventory.indent.previuos_recipe_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>
    // $('.select_2').select2();
    select2('select_2');

    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">
                                            <div class="input-group">
                                                <select class="form-control new_product" style="width: 85%" name="product_id[`+index+`]" onchange="getAvailQTY(this.value,` + index + `)">
                                                    <option value=" ">-- Select Product --</option>
                                                </select>
                                                <div class="input-group-append" style="width: 10%;height: 30px !important">
                                                    <span class="input-group-text" id="unit_name`+index+`"></span>
                                                </div>
                                            </div>
                                        </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-right"> <input type="number" min="0" step=".01" name="avail_quantity[]"
                                            id="avail_quantity`+index+`" class="form-control" readonly></td>
                                            <td class="text-right"> <input type="text" name=""
                                            id="pre_purchase_date`+index+`" class="form-control" readonly></td>
                                            <td class="text-right"> <input type="text" name=""
                                            id="pre_purchase_rate`+index+`" class="form-control" readonly></td>`;
                                    returnData+=`<td class="text-right">
                                                    <div class="input-group text-right flex-nowrap">
                                                        <input style="width:80px" type="number" min="0" onkeyup="setSubtotal('`+index+`')"  name="quantity[`+index+`]" id="quantity`+index+`" step=".01" class="form-control-sm" value="0">
                                                    </div>
                                                </td>`;

                                    returnData+=`<td class="text-right"> <input type="text" onkeyup="setSubtotal('`+index+`')" name="approx_rate[`+index+`]"
                                            id="approx_rate`+index+`" class="form-control"></td>
                                            <td class="d-flex" nowrap> <input type="text" name=""
                                            id="total`+index+`" class="form-control" readonly>
                                            <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>
                                            </td></tr>`;
                                                console.log(returnData);
                                                $('#index_num').val((index));
                                        $('#tbl_body').append(returnData);
                                        initSelect2();
    }

    function setSubtotal(index){
        req_qty = $(`#quantity${index}`).val();
        appr_rate = $(`#approx_rate${index}`).val();

        $(`#total${index}`).val(req_qty*appr_rate);
    }
    function getAvailQTY(pro_id, i) {
        var store_table_type=$('#store_table_type').val();
        $.each(pub_product, function(index, pro) {
            if (pro.id == pro_id) {
                $('#unit_name' + i).text(pro.primary_unit.name);
            }
        });
        $.ajax({
            url: '/purchase/invoice-transaction/avail-qty/'+pro_id+'/'+store_table_type,
            method: "get",
            dataType: 'JSON',
            data: {},
            success: function(data) {
                // console.log("rrr",data.data);
                var t = data;
                $('#avail_quantity' + i).val(data['qty']);
                $('#pre_purchase_date' + i).val((data.data.get_previous_purchase_history.length == 0 ? 'No Purchase Info Found' : getFormatedDateDMY(data.data.get_previous_purchase_history[0].date)));
                $('#pre_purchase_rate' + i).val((data.data.get_previous_purchase_history.length == 0 ? 'No Purchase Info Found' : data.data.get_previous_purchase_history[0].price));
                // console.log("indent", data);
            },
            error: function(data) {
                alert('Something Went Wrong.!');
                console.log(data);
            }
        });
        getSum(i);
        // pro_ids();
    }
    function getSum(i){
        console.log(i);
        var sum=0;
        var stock=parseFloat($('#avail_quantity'+i).val());
        var sum=parseFloat($('#quantity'+i).val());

        if(stock<sum){
            $('#save').attr('disabled',true);
        }else{
            $('#save').attr('disabled',false);
        }
    }
    function initSelect2(){
        productSearch('new_product');
    }
    function deleteRow (i){
        $('#tr-'+i).remove();
    }

    function getFormatedDateDMY(date){
        var todayTime = new Date(date);
        var month = todayTime.getMonth() + 1;
        var day = todayTime.getDate();
        var year = todayTime.getFullYear();
        return `${day}-${month}-${year}`;
    }
</script>
@stop