@extends('admin.layout.app')
@section('title','Minimum Stock Report')
@push('headerscript')
    <link href="{{asset('theme/plugins/bootstrap-sweetalert/sweet-alert.css')}}" rel="stylesheet" type="text/css">
    <link href="{{asset('theme/plugins/datatables/responsive.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/datatables/dataTables.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/css/custom.css')}}" rel="stylesheet" type="text/css"/>
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Minimum Stock Report</h4>
                        <div class="pull-right">
                            <a href="{{url()->previous()}}"
                               class="btn btn-custom btn-rounded waves-effect waves-light m-b-2 m-r-15"><i
                                    class=" mdi mdi-keyboard-backspace"></i> Back</a>
                            <button type="button" onclick="exportsExcel()"
                                    class="btn btn-success btn-sm pull-right"
                                    title="Export in Excel">
                                <i class="fa fa-file-excel-o"></i>
                            </button>
                            <button type="button" onclick="exportsPdf()"
                                    class="btn btn-danger btn-sm pull-right m-r-10"
                                    title="Export in Pdf">
                                <i class="fa fa-file-pdf-o"></i>
                            </button>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
            <div class="row">

                <div class="form-group col-sm-4 col-12">
                    <label for="spare_part_id">Spare Part</label>
                    <select name="spare_part_id" id="spare_part_id"
                            class="form-control select2" required="">
                        <option value="">Select Spare Part</option>@foreach($spare_parts as $raw)
                            <option
                                value="{{$raw->id}}">{{$raw->part_description .' - '. $raw->part_number}}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12 mr-auto ml-auto">
                    <div class="card-box">
                        <div class="row">
                            <div class="col-sm-12 col-12">
                                <div class="table-responsive">
                                    <table class="table table-bordered " id="datatables">
                                        <thead>
                                        <tr>
                                            <th>S.No.</th>
                                            <th>Part Number</th>
                                            <th>Part Description</th>
                                            <th>Cost Price</th>
                                            <th>Selling Price</th>
                                            <th>Current Stock</th>
                                            <th style="width: 10%">Minimum Stock</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('footerscript')
    <script src="{{asset('theme/plugins/bootstrap-sweetalert/sweet-alert.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/dataTables.bootstrap.js')}}"></script>
    {{--    <script src="{{asset('theme/plugins/datatables/responsive.bootstrap.min.js')}}"></script>--}}

    <script>
        $('#spare_part_id').on('change', function () {
            $('#datatables').DataTable().draw(false);
        });

        $(function () {
            $('#datatables').DataTable({
                processing: true,
                serverSide: true,
                stateSave: true,
                responsive: true,
                oLanguage: {"sSearch": "master search"},
                ajax: {
                    url: '{{route('minStockReport.getData') }}',
                    data: function (d) {
                        d.spare_part_id = $('#spare_part_id').val();
                    },
                },
                columns: [
                    {data: 'DT_RowIndex', name: 'DT_RowIndex', searchable: false},
                    {data: 'part_number', name: 'part_number'},
                    {data: 'part_description', name: 'part_description'},
                    {data: 'cost_price', name: 'cost_price'},
                    {data: 'selling_price', name: 'selling_price'},
                    {data: 'stock_in', name: 'stock_in'},
                    {data: 'minimum_stock_report', name: 'minimum_stock_report'},
                ]
            });
        });

        function exportsExcel() {
            var spare_part_id = $('#spare_part_id').val();
            window.location.href = "{{route('minStockReport.exportExcel')}}?spare_part_id=" + spare_part_id;
        }
        function exportsPdf() {
            var spare_part_id = $('#spare_part_id').val();
            window.location.href = "{{route('minStockReport.exportPdf')}}?spare_part_id=" + spare_part_id;
        }


    </script>
@endpush