@extends('layouts.master')

@section('page_title', 'Download Excel Sheet Table')
@section('title', 'Download Excel Sheet Table')
@section('main_item', 'Orders')
@section('sub_item', 'Download Excel Sheet Table')

@section('content')

<div class="col-12">
    <div class="card">
        <div class="card-body">
            <h4 class="header-title mt-0">Sale Excel Download Details</h4>
            <div class="table-responsive dash-social">
                <table id="laravel_datatable_excel" class="table table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>User Name</th>
                            <th>E-Mail Address</th>
                            <th>Download Sale Excel</th>
                            <th>Date & Time</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

@endsection
@section('scripts')
<script>
    $(document).ready(function() {
        var table = $('#laravel_datatable_excel').DataTable({
            dom: 'Blfrtip',
            buttons: [{
                    extend: 'copy',
                    exportOptions: {
                        columns: [0, 1, 2, 3 ]
                    }
                },
                {
                    extend: 'excel',
                    exportOptions: {
                        columns: [0, 1, 2, 3]
                    }
                },
                {
                    extend: 'pdf',
                    exportOptions: {
                        columns: [0, 1, 2, 3]
                    }
                },
                {
                    extend: 'print',
                    exportOptions: {
                        columns: [0, 1, 2, 3]
                    }
                },
            ],
            lengthMenu: [
                [25, 50, 100, -1],
                ['25 ', '50 ', '100', 'All']
            ],
            processing: false,
            serverSide: true,
            ajax: {
                url: "{{ url('/orders/sale/excel/download/table') }}",
                data: function(d) {
                    d.location_id = $('#location_id').val();
                    d.range = $('#reportrange').val();
                }
            },
            columnDefs: [{
                "targets": [],
                "orderable": false,
                "searchable": false,
                "visible": false,
            }],

            columns: [
                {
                    data: 'user_name',
                    name: 'user_name'
                },

                {
                    data: 'email_address',
                    name: 'email_address'
                },
                {
                    data: 'path',
                    name: 'path'
                },
                {
                    data: 'created_at',
                    name: 'created_at'
                },
            ]
        });
    });
</script>

@endsection