@extends('layouts.master')
@section('heading')
    <h1>{{__('All Audits')}}</h1>
@stop

@section('content')
<div class="table-responsive">
    <table class="table table-hover dataTable" id="audits-table">
        <thead>
        <tr>
            <th>Company</th>
            <th>Site</th>
            <th>Province</th>
            <th>Suburb</th>
            <th>Auditor</th>
            <th>Start Date</th>
            <th>Capturer</th>
            <th>Sales Rep</th>
            <th>Proposal Date</th>
            <th>Presentation Date</th>
            <th>Notes</th>
            <th>Action</th>
        </tr>
        </thead>
    </table>

</div>

@stop

@push('scripts')
<script>
    $(function () {
        $('#audits-table').DataTable({
            processing: true,
           
            ajax: '{!! route('audits.data') !!}',
            columns: [

                {data: 'company_namelink', name: 'company_name'},
                {data: 'site', name: 'site'},
                {data: 'province', name: 'province'},
                {data: 'suburb', name: 'suburb'},
                {data: 'first_name', name: 'first_name'},
                {data: 'start_date', name: 'start_date'},
                {data: 'capturer', name: 'capturer'},
                {data: 'user_assigned_id', name: 'user_assigned_id'},
                {data: 'proposal_date', name: 'proposal_date'},
                {data: 'presentation_date', name: 'presentation_date'},
                {data: 'notes', name: 'notes'},
                {data: 'action', name: 'action'}
            ],
            
            dom: 'Brtip',
            buttons: [
                {
                    extend: 'print',
                      title: 'Audits Report',
                    autoPrint: true,
                    exportOptions: {
                columns: [ 0, 1, 2,3,4,5,6,7,8,9,10 ]
            }
                },
                {
                extend: 'excel',
                title: 'Audits Report',
                    exportOptions: {
                        columns: [ 0, 1, 2,3,4,5,6,7,8,9,10]
            }
                }
                ,
                {
                extend: 'pdf',
                title: 'Audits Report',
                    exportOptions: {
                        columns: [ 0, 1, 2,3,4,5,6,7,8,9,10 ]
            }
                }
            ]
        });
    
    });
</script>
@endpush