@extends('layouts.admin')


@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }
    </style>
@endpush


@section('content')

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid pt-2">

            <div class="col-md-12">
                <!-- general form elements -->
                <div class="card card-info">

                    <!-- form start -->
                    <form method="GET" action="{{ route('report.purestimate') }}">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="product_id">From Date</label>

                                     <div class="input-group date" id="reservationdate2" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input" data-target="#reservationdate2" name="fromdate" id="fromdate" value="{{$fromdate}}" placeholder="Form Date" required/>
                                        <div class="input-group-append" data-target="#reservationdate2" data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>


                                    </div>
                                </div>
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="reservationdate3">To Date</label>

                                     <div class="input-group date" id="reservationdate3" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input" data-target="#reservationdate3" name="todate" id="todate" value="{{$todate}}" placeholder="To date" required/>
                                        <div class="input-group-append" data-target="#reservationdate3" data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>


                                    </div>
                                </div>

                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="req_id">Request No</label>

                                        <select id="req_id" name="req_id" class="form-control form-control-sm select2" style="width: 100%;">
                                          <option value="">Select Request No</option>

                                          @if(isset($reqinvoice) && (count($reqinvoice) > 0))

                                          @foreach($reqinvoice as $v)
                                          <option value="{{$v->id}}" {{ ($req_id == $v->id) ? "selected" : "" }} >{{$v->req_invoice}}</option>
                                          @endforeach

                                          @endif

                                        </select>


                                    </div>
                                </div>

                                <div class="col-sm-3">
                                    <button type="submit" style="margin-top: 30px;" class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('report.purestimate') }}" style="margin-top: 30px;"
                                    class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                                </div>

                            </div>
                    </form>
                </div>
            </div>

            <!-- /.card -->

            <div class="row">
                <!-- left column -->
                <div class="col-md-12">

                    <div class="card card-info">
                        <div class="card-header">
                            <h3 class="card-title">Purchase Estimate</h3>
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="example1" class="table table-bordered table-sm table-striped">
                                <thead>
                       
                                    <tr>
                                        <th>SL</th>
                                        <th>Product Name</th>
                                        <th>Unit</th>
                                        <th>Store. Stock</th>
                                        <th>Dept. Stock</th>
                                        <th>Store & Dept Stock</th>
                                        <th>Usage Qty</th>
                                        <th>Total Needs</th>
                                    </tr>
                                </thead>
                                <tbody>

                                    @php

                                        $sl = 1;

                                    @endphp

                                    @foreach($purEst as $v)

                                    @php
                                        $sl++;
                                        $ttneed = ($v['prodStock']+$v['storeQty']) - $v['usageQty'];

                                        if($ttneed >= 0){
                                            $ttneed = 0;
                                        }else{
                                            $ttneed = (-1) * $ttneed;
                                        }


                                    @endphp
                         
                                    <tr>
                                        <td>{{$sl}}</td>
                                        <td>{{$v['product_name']}}</td>
                                        <td>{{$v['unit_name']}}</td>
                                        <td>{{$v['storeQty']}}</td>
                                        <td>{{$v['prodStock']}}</td>
                                        <td>{{($v['prodStock']+$v['storeQty'])}}</td>
                                        <td>{{$v['usageQty']}}</td>
                                        <td>{{$ttneed}}</td>
                                    </tr>

                                    @endforeach

                                </tbody>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!--/.col (left) -->
                <!-- right column -->
                <div class="col-md-6">

                </div>
                <!--/.col (right) -->
            </div>
            <!-- /.row -->
        </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->

@endsection

@push('scripts')
<script src="{{asset('plugins/datatables/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js')}}"></script>
<script src="{{asset('plugins/datatables-responsive/js/dataTables.responsive.min.js')}}"></script>

<script src="{{asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js')}}"></script>
<script src="{{asset('plugins/datatables-buttons/js/dataTables.buttons.min.js')}}"></script>
<script src="{{asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js')}}"></script>
<script src="{{asset('plugins/jszip/jszip.min.js')}}"></script>
<script src="{{asset('plugins/pdfmake/pdfmake.min.js')}}"></script>
<script src="{{asset('plugins/pdfmake/vfs_fonts.js')}}"></script>
<script src="{{asset('plugins/datatables-buttons/js/buttons.html5.min.js')}}"></script>
<script src="{{asset('plugins/datatables-buttons/js/buttons.print.min.js')}}"></script>

<script src="{{asset('plugins/datatables-buttons/js/buttons.colVis.min.js')}}"></script>


<script src="{{asset('plugins/select2/js/select2.full.min.js')}}"></script>

<script>
  $(function () {


    $('#reservationdate2').datetimepicker({
        format: 'DD-MM-YYYY'
    });

    $('#reservationdate3').datetimepicker({
        format: 'DD-MM-YYYY'
    });


    $('.select2').select2()

    $('.select2bs4').select2({
      theme: 'bootstrap4'
    })


    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false,
      "searching": false,
      "paging": false,
              buttons: [
            {
                extend: 'excel',
               title: 'Purchase Estimate  \n {{$fromdate}} TO {{$todate}}'
            },
            {
                extend: 'pdf',
                title: 'Purchase Estimate  \n {{$fromdate}} TO {{$todate}}'
            },
            {
                extend: 'print',
               title: 'Purchase Estimate  \n {{$fromdate}} TO {{$todate}}'
            },
            'colvis'
        ]

    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });

  });




</script>
@endpush