@extends('layouts.app')
@section('pagetitle')
@stop
@section('title')
<h1>รายงานสินค้าใกล้หมด </h1>
 
 

@stop
@section('content')




<style>
.table{ margin-bottom:0}
 
</style>
<div class="main-container " >

<div class="panel panel-default">
  <div class="panel-body"><span class="pull-left">
 <form class="form-inline">
   
       <div class="form-group">
    <label for="branches_id">สาขา</label>
    <select  class="form-control" id="branches_id" name="branches_id" placeholder="สาขา" >
    @if(auth()->user()->permission=='ADMIN')
    <option value=""  disabled   selected>กรุณาเลือกสาขา</option>
    @endif 
    @foreach($branches as $branch)
    	<option value="{{$branch->id }}" {{isset($_REQUEST['branches_id']) && $_REQUEST['branches_id'] == $branch->id ? 'selected' : '' }}>{{$branch->name }}</option>
    @endforeach
    </select>
  </div>
  <button type="submit" class="btn btn-default">ค้นหาข้อมูลสินค้าใกล้หมด</button>
</form>
</span>
 
  </div>
</div>



<div class="table-responsive">
  <table width="100%" border="1" class="table table-bordered datatable">
    <thead>
      <tr class="btn-info">
        <td align="center">รหัสสินค้า</td>
        <td align="center">สินค้า</td>
        <td align="center">ประเภท</td>
        <td align="center">สาขา</td>
        <td align="center">ยี่ห้อ</td>
        <td align="center">จำนวนต่ำสุด</td>
        <td align="center">คงเหลือ</td>
      </tr>
    </thead>
    <tbody>
    
    @foreach($products as $product)
    <tr>
      <td>{{$product->barcode}}</td>
      <td>{{$product->name}}</td>
      <td>{{$product->tname}}</td>
      <td align="center">{{$product->brname}}</td>
      <td>{{$product->bname}}</td>
      <td align="center">{{$product->minimum}}</td>
      <td align="center">{{$product->balance}}</td>
    </tr>
    @endforeach
      </tbody>
    
  
  </table>
</div></div>
@stop
@section('style')
 
<link href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet" />
@stop
@section('script')
  
<script src="{{asset('https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js')}}">
</script>
<script src="{{asset('https://cdn.datatables.net/1.10.20/js/dataTables.bootstrap.min.js')}}"> </script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script> 
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script> 
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.colVis.min.js"></script> 
<script>
 
            $(function () {
                otable = $('.datatable').dataTable({
                    "lengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "ทั้งหมด"]],
                    "order": [[0, "desc"]],
                  dom: 'lBfrtip',
                buttons: [
                    { extend: 'copyHtml5', footer: true, title: 'รายงานสินค้าใกล้หมด {{date('d m Y')}}' ,text :'คัดลอก'},
                    { extend: 'excelHtml5', footer: true, title: 'รายงานสินค้าใกล้หมด {{date('d m Y')}}' , text :'ส่งออกเป็น Excel'},
                    { extend: 'pdfHtml5', footer: true, title: 'รายงานสินค้าใกล้หมด {{date('d m Y')}}' , text :'ส่งออกเป็น PDF' },
                    { extend: 'print', footer: true, title: 'รายงานสินค้าใกล้หมด {{date('d m Y')}}' , text :'พิมพ์'  },
                ], initComplete: function () {
                    $('.buttons-copy').addClass('btn btn-sm btn-info');
                    $('.buttons-copy').removeClass('dt-button');
                    $('.buttons-excel').addClass('btn btn-sm btn-success');
                    $('.buttons-excel').removeClass('dt-button');
                    $('.buttons-pdf').addClass('btn btn-sm btn-danger');
                    $('.buttons-pdf').removeClass('dt-button');
                    $('.buttons-print').addClass('btn btn-sm btn-primary');
                    $('.buttons-print').removeClass('dt-button');
                },
					"language":{
					"decimal":        "",
					"emptyTable":     "ไม่พบข้อมูลเลยค่ะ",
					"info":           "แสดง _START_ ถึง _END_ จาก _TOTAL_ รายการ",
					"infoEmpty":      "ไม่มีรายการที่จะแสดง",
					"infoFiltered":   "(กรองจาก _MAX_ รายการ)",
					"infoPostFix":    "",
					"thousands":      ",",
					"lengthMenu":     "แสดง _MENU_ รายการ &nbsp;",
					"loadingRecords": "กำลังโหลดข้อมูล...",
					"processing":     "กำลังค้นข้อมูล...",
					"search":         "ค้นหา:",
					"zeroRecords":    "ไม่พบข้อมูลค่ะ",
					"paginate": {
					"first":      "หน้าแรก",
					"last":       "หน้าสุดท้าย",
					"next":       "หน้าถัดไป",
					"previous":   "ก่อนหน้า"
					},
					"aria": {
					"sortAscending":  ": activate to sort column ascending",
					"sortDescending": ": activate to sort column descending"
					}
					}
                    
                });
            })

 
</script>
@stop