@extends('layouts.fixed')

@section('title','Manage Requisition - Purcahse Requisition')

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">

            </div>
        </div><!-- /.container-fluid -->
    </section>
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1>Pending Purchases</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">Manage Requisition</li>
                    </ol>
                </div>
            </div>
        </div><!-- /.container-fluid -->
    </section>


    <!-- Main content -->
    <section class="content">
        <div class="col-lg-12">

            <div class="card"><br>
                <div class="card-body">
                    <div class="row">
                        <div class="form-group col-md-3">
                            <input type="text" id="requistion_no" onkeyup="myTableSearch('requisitions')" class="form-control" name="style" placeholder="Enter Requisition No">
                        </div>
                        {{-- requisition  lists start --}}
                        <div class="col-lg-12 table-responsive">

                            <table id="searchTable" class="table-bordered table-striped table">
                                <thead>
                                    <tr class="bg-info">
                                        <th>#SL</th>
                                        <th>Requisition No</th>
                                        <th>Req. Invoice No</th>
                                        <th>Qty</th>
                                        <th>Total Quotation Taken Yet </th>
                                        <th>Note</th>
                                        <th>Requisition Making Date </th>
                                        <th>Action</th>
                                    </tr>
                                </thead>

                                <tbody>
                                @php $i=0; @endphp
                                @if($requisitions->count()>0)
                                    @foreach($requisitions as $key => $requisition)
                                        @if($requisition->new_requisition_products->count() > 0)
                                            @php $i++; @endphp
                                            <tr>
                                                {{-- <td>{{(($requisitions->currentPage() - 1) * $requisitions->perPage() + $key+1)}}</td> --}}
                                                <td>{{ $i }}</td>
                                                <td width="11%">{{ $requisition->requisition->requisition_id }}</td>
                                                <td>{{ $requisition->invoice_no }}</td>
                                                <td>{{ $requisition->qty }}</td>
                                                <td>
                                                @if($requisition->sent_for == 2 || $requisition->sent_for == 3)
                                                <a class="btn-block btn bg-info" style="border: 2px solid rgba(255,255,255,1);border-radius: 10px 0 10px;font-size: 1.2rem;margin: 0;">  Without Quotation </a>
                                                @else
                                                <a href="{{ route('quotations.list',$requisition->id) }}" class="btn-block btn btn-info" style="border: 2px solid rgba(255,255,255,1);border-radius: 10px 0 10px;font-size: 1.2rem;margin: 0;">  {{ $requisition->quotations->count() }} </a>
                                                @endif
                                                 {{--  <label class="btn-block btn btn-info" style="border: 2px solid rgba(255,255,255,1);border-radius: 10px 0 10px;font-size: 1.2rem;margin: 0;">  {{ \App\Quotation::where('requisition_id',$requisition->id)->count() }} </label>  --}}
                                                </td>
                                                <td>{{ $requisition->note or 'N/A' }}</td>
                                                <td>
                                                    {{ \Carbon\Carbon::parse($requisition->created_at)->format('D-d-M-Y')   }}  -- {{ $requisition->created_at->diffForHumans() }}
                                                </td>
                                                <td>
                                                    @if($requisition->sent_for == 1)
                                                    <a class=" btn btn-info" href="{{ route('inventory.quotation.add',$requisition->id) }}"> Quotation Generate</a>
                                                    @elseif($requisition->sent_for == 2)
                                                    <a class=" btn btn-warning" href="{{ route('inventory.po.add',$requisition->id) }}"> Make Purchase Order</a>
                                                    @elseif($requisition->sent_for == 3)
                                                    <button class=" btn btn-success"> Already Purchased</button>
                                                    @endif
                                                </td>
                                            </tr>
                                        @endif
                                    @endforeach
                                @else
                                    <tr> <td colspan="8" class="bg-danger text-center">No Pending Requisiton</td> </tr>
                                @endif
                                </tbody>
                            </table>
                            {{-- <span class="float-right">{{ $requisitions->links() }}</span> --}}
                        </div>
                        {{-- requisition  lists End --}}

                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- /.content -->



@stop

@section('style')
    <!-- DataTables -->
    <link rel="stylesheet" href="{{ asset('plugins/datatables/dataTables.bootstrap4.css') }}">
@stop

@section('plugin')
    <!-- DataTables -->
    <script src="{{ asset('plugins/datatables/jquery.dataTables.js') }}"></script>
    <script src="{{ asset('plugins/datatables/dataTables.bootstrap4.js') }}"></script>

    <!-- page script -->
    <script type="text/javascript">

        function myTableSearch(index) {
          // Declare variables 
          var input, filter, table, tr, i, j, column_length, count_td, null_tr = 0;
          column_length = document.getElementById('searchTable').rows[0].cells.length;
          input = document.getElementById("requistion_no");
          filter = input.value.toUpperCase();
          
          j = 1; //second column
          table = document.getElementById("searchTable");
          tr = table.getElementsByTagName("tr");
          for (i = 1; i < tr.length; i++) { // except first(heading) row
            count_td = 0;
            // for(j = 1; j < column_length-1; j++){ // except first column
                td = tr[i].getElementsByTagName("td")[j];
                /* ADD columns here that you want you to filter to be used on */
                if (td) {
                  if ( td.innerHTML.toUpperCase().indexOf(filter) > -1)  {            
                    count_td++;
                  }
                }
            // }
            console.log(count_td)
            if(count_td > 0){
                tr[i].style.display = "";
            } else {
                null_tr++;
                tr[i].style.display = "none";
            }
          }
        }
    </script>
@stop
