@extends('layouts.app')

        @section('styles')

        @endsection

            @section('content')
                             <!-- PAGE-HEADER -->
                            <div class="page-header">
                                <h1 class="page-title">Out of Stock Report</h1>
                                <div>
                                    <ol class="breadcrumb">
                                        <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                                         <li class="breadcrumb-item"><a href="javascript:void(0)">Reports</a></li>
                                        <li class="breadcrumb-item active" aria-current="page">Out of Stock Report</li>
                                    </ol>
                                </div>
                            </div>
                            <!-- PAGE-HEADER END -->

                               <!-- Row -->
                        
                            <input type="hidden" name="" id="order_id">
                             <div class="row">
                            <div class="col-12 col-sm-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title mb-0">View Out of Stock Report</h3>
                                    </div>
                                    <div class="card-body pt-4">
                                        <div class="grid-margin">
                                            <div class="">
                                                <div class="panel panel-primary">
                                                    <div class="tab-menu-heading border-0 p-0">
                                                        <div class="tabs-menu1">
         
                                                            <ul class=" nav panel-tabs product-sale">
                                                

                                                <li class="">
                                              <a target="_blank" title="Download Excel" class="btn custom-btn-success btn-sm" href="/admin/reports/out_of_stock_report_export"><span class="fa fa-file-excel-o text-white"> </span></a>
                                                
                                                
                                                <!--<button type="button" class="btn btn-icon  custom-btn-danger"><i class="fa fa-file-pdf-o"></i></button> -->

                                                </li>


                                  
                                            
                                            
                                            
                                               

                                                        
                                                         </ul>
                                                        </div>
                                                    </div>
                                                    <div class="panel-body tabs-menu-body border-0 pt-0">
                                                        <div class="tab-content">
                                                            <div class="tab-pane active" id="tab5">
                                                                <div class="table-responsive">
                                                                    <table class="table table-bordered text-nowrap border-bottom " style="width: 100% !important;"  id="table_datatable">
                                                                        <thead class="border-top text-center">
                                                                            <tr>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">#</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">SKU</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Product Name</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Category</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Reorder Point</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5" >Stock </th>

                                                                            </tr>
                                                                        </thead>
                                                                        <tbody></tbody>

                                                               
                                                                    </table>
                                                                </div>
                                                            </div>
                                                           
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                      
    

            @endsection
              @section('scripts')  
{{-- ################################Jquery Datatable########################### --}}
   <script src="{{asset('assets/jquery-datatable/jquery.min.js')}}"></script>
   <link rel="stylesheet" type="text/css" href="{{asset('assets/jquery-datatable/jquery.dataTables.css')}}">
   <script src="{{asset('assets/jquery-datatable/jquery.dataTables.js')}}"></script>
 {{-- ########################################################################## --}}
        <script>
    var token = $("meta[name=csrf-token]").attr("content");  
    var base_url='{{url('/')}}';
    var datatable_name="table_datatable";
$('#table_datatable').DataTable({
        "responsive": true,
       "serverSide": true,
       "ordering": false,
       "searching": true,
       "bLengthChange": false,
       "info":false,
       "bSort": true,
       "order": [
           [0, 'desc']
       ],
       "columnDefs": [{
               "targets": [0,4],
               "orderable": true
           },
           {"className": "text-center", "targets": [0,1,4,5]},
           {"className": "text-left", "targets": []},
           
       ],
       "displayLength":10,
       "ajax": {   
           "url":  "/admin/reports/out_of_stock_datable",
           "type": "post",
           "data": function (data) {
                data._token = token;
              
               return data;
  
           }
       }, "AutoWidth": true,
       "columns": [
                  {"data": "product_id", "name": "product_id"},
                  {"data": "product_sku", "name": "product_sku"},
                  {"data": "product_name_en", "name": "product_name_en"},
                  {"data": "category_name", "name": "category_name"},
                  {"data": "reorder_point", "name": "reorder_point"},
                  {"data": "product_stock", "name": "product_stock"}, 

                   ],
      
      "fnCreatedRow": function (nRow, aData, iDataIndex) {
          var info = this.dataTable().api().page.info();
          var page = info.page;
          var length = info.length;
          var index = (page * length + (iDataIndex + 1));

      
            
            if(aData.product_stock>=aData.reorder_point){
                
                var status="<span class='text-success fw-bold'>Instock</span>"
            }
            else if(aData.product_stock==0){
                var status="<span class='text-danger fw-bold'>Out Of Stock</span>"
            }
            
            else if(aData.product_stock<aData.reorder_point){
                var status="<span class='text-warning fw-bold'>Going To Out Of Stock</span>"
            }
            
                  $('td:eq(0)', nRow).html(index);
       
                  
                  

 },

 });


        </script>
    <script src="{{asset('assets/js/tooltip&popover.js')}}"></script>
    <!-- INTERNAL Bootstrap-Datepicker js-->
    <script src="{{asset('assets/plugins/bootstrap-daterangepicker/daterangepicker.js')}}"></script>
    <!-- INTERNAL Bootstrap-Datepicker js-->
    <script src="{{asset('assets/plugins/bootstrap-datepicker/bootstrap-datepicker.js')}}"></script>
    <!-- TIMEPICKER JS -->
    <script src="{{asset('assets/plugins/time-picker/jquery.timepicker.js')}}"></script>
    <script src="{{asset('assets/plugins/time-picker/toggles.min.js')}}"></script>
    <!-- INTERNAL jquery transfer js-->
    <script src="{{asset('assets/plugins/jQuerytransfer/jquery.transfer.js')}}"></script>
    <!-- DATEPICKER JS -->
    <script src="{{asset('assets/plugins/date-picker/date-picker.js')}}"></script>
    <script src="{{asset('assets/plugins/date-picker/jquery-ui.js')}}"></script>
    <script src="{{asset('assets/plugins/input-mask/jquery.maskedinput.js')}}"></script>
    <!-- FORMELEMENTS JS -->
    <script src="{{asset('assets/js/formelementadvnced.js')}}"></script>
    <script src="{{asset('assets/js/form-elements.js')}}"></script>
        @endsection