@extends('adminlte::page')
@section('content')

    @if ($message = Session::get('success'))
        <div class="alert alert-success">
            <p>Successfully imported {{ $message['imported'] }} skipped {{ count($message['skipped_values']) }} entries
                :
                {{ implode(',', $message['skipped_values']) }} </p>
        </div>
    @endif

    <div class="card" style="margin-top:10px">
        <div class="card-header">
            <h3 class="card-title">Import History</h3>
            <form action="/import" method="get" class="form-inline" style="float:right;margin-bottom:20px">
               Filter:  <input type="date" name="date" class="form-control" style="width:170px" value="{{ request()->date }}">
                <select name="type" class="form-control">
                    <option value=""> Report type </option>
                    @foreach ($report_types as $report)
                        @if ($report->report_type != '')
                            <option value="{{ $report->report_type }}" @if ($report->report_type == Request()->type) selected @endif>
                                {{ $report->report_type }}</option>
                        @endif
                    @endforeach

                </select>
                <input type="submit" class="btn btn-success" value="Filter">
            </form>
        </div>
        <!-- /.card-header -->
        <div class="card-body">


            <div class="card card-primary card-outline card-tabs">
                <div class="card-header p-0 pt-1 border-bottom-0">
                    <ul class="nav nav-tabs" id="custom-tabs-two-tab" role="tablist">
                        <li class="nav-item">
                            <a class="nav-link active" id="reports-tab" data-toggle="pill" href="#reports" role="tab"
                                aria-controls="reports" aria-selected="true">Reports</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="statements-tab" data-toggle="pill" href="#statements" role="tab"
                                aria-controls="statements" aria-selected="false">Statements</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="daily-prices-tab" data-toggle="pill" href="#daily-prices" role="tab"
                                aria-controls="daily-prices" aria-selected="false">Daily prices</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="qb-carriers-tab" data-toggle="pill" href="#qb-carriers" role="tab"
                                aria-controls="qb-carriers" aria-selected="false">QB Carriers</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="qb-drivers-tab" data-toggle="pill" href="#qb-drivers" role="tab"
                                aria-controls="qb-drivers" aria-selected="false">QB Drivers</a>
                        </li>
                    </ul>
                </div>
                <div class="card-body">
                    <div class="tab-content" id="custom-tabs-two-tabContent">
                        <div class="tab-pane fade show active" id="reports" role="tabpanel" aria-labelledby="reports-tab">
                            @if ($import_history->count() > 0)
                                <table class="table table-bordered table-hover table-striped datatables" style="width:100%">
                                    <thead>
                                        <th>Filename</th>
                                        <th>Report type</th>
                                        <th>Import success</th>
                                        <th>Failed</th>
                                        <th>Errors</th>
                                        <th>Date</th>
                                        <th>Total</th>
                                        <th>Total pay</th>
                                        <th>Delete</th>
                                    </thead>

                                    <tbody>
                                        @foreach (\App\ImportHistory::where('report_type', 'compass_report')
            ->latest()
            ->paginate(40)
        as $import)
                                            <tr>
                                                <td><a href="/import/{{ $import->id }}">{{ $import->filename }}</a></td>
                                                <td>{{ $import->report_type }}</td>
                                                <td>{{ $import->imported_rows }}</td>
                                                <td>{{ $import->failed_rows }}</td>
                                                <td></td>
                                                <td>{{ $import->created_at->format('d/m/Y') }}</td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total') }}@endif
                                                </td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total_pay') }}@endif
                                                </td>
                                                <td><a href="/import/delete-report/{{ $import->id }}"
                                                        onclick="return confirm('Are you sure?')"
                                                        style="text-align: right"><i class="fa fa-trash"
                                                            style="color:red"></i></a></td>
                                            </tr>
                                        @endforeach

                                    </tbody>


                                </table>

                                {{ \App\ImportHistory::whereIn('report_type', ['compass_report'])->paginate(40)->links() }}
                            @else
                                <div class="callout callout-info">No reports has been imported yet!</div>
                            @endif
                        </div>
                        <div class="tab-pane fade" id="statements" role="tabpanel" aria-labelledby="statements-tab">
                            @if ($import_history->count() > 0)
                                <table class="table table-bordered table-hover table-striped datatables" style="width:100%">
                                    <thead>
                                        <th>Filename</th>
                                        <th>Report type</th>
                                        <th>Import success</th>
                                        <th>Failed</th>
                                        <th>Errors</th>
                                        <th>Date</th>
                                        <th>Total</th>
                                        <th>Total pay</th>
                                        <th>Delete</th>
                                    </thead>

                                    <tbody>
                                        @foreach (\App\ImportHistory::whereIn('report_type',['love_statements', 'pilot_statements', 'road-rangers', 'ta-petro-statement'])
            ->latest()
            ->paginate(40)
        as $import)
                                            <tr>
                                                <td><a href="/import/{{ $import->id }}">{{ $import->filename }}</a>
                                                </td>
                                                <td>{{ $import->report_type }}</td>
                                                <td>{{ $import->imported_rows }}</td>
                                                <td>{{ $import->failed_rows }}</td>
                                                <td></td>
                                                <td>{{ $import->created_at->format('d/m/Y') }}</td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total') }}@endif
                                                </td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total_pay') }}@endif
                                                </td>
                                                <td><a href="/import/delete-report/{{ $import->id }}"
                                                        onclick="return confirm('Are you sure?')"
                                                        style="text-align: right"><i class="fa fa-trash"
                                                            style="color:red"></i></a></td>
                                            </tr>
                                        @endforeach

                                    </tbody>


                                </table>

                                {{ \App\ImportHistory::whereIn('report_type', ['love_statements', 'pilot_statements', 'road_rangers','ta_petro_statement'])->latest()->paginate(40)->links() }}
                            @else
                                <div class="callout callout-info">No reports has been imported yet!</div>
                            @endif
                        </div>
                        <div class="tab-pane fade" id="daily-prices" role="tabpanel" aria-labelledby="daily-prices-tab">
                              @if ($import_history->count() > 0)
                                <table class="table table-bordered table-hover table-striped datatables" style="width:100%">
                                    <thead>
                                        <th>Filename</th>
                                        <th>Report type</th>
                                        <th>Import success</th>
                                        <th>Failed</th>
                                        <th>Errors</th>
                                        <th>Date</th>
                                        <th>Total</th>
                                        <th>Total pay</th>
                                        <th>Delete</th>
                                    </thead>

                                    <tbody>
                                        @foreach (\App\ImportHistory::whereIn('report_type',['pilot-price-lists', 'road-rangers-price-lists', 'ta-petro-daily-prices', 'loves-daily-prices'])
            ->latest()
            ->paginate(40)
        as $import)
                                            <tr>
                                                <td><a href="/import/{{ $import->id }}">{{ $import->filename }}</a>
                                                </td>
                                                <td>{{ $import->report_type }}</td>
                                                <td>{{ $import->imported_rows }}</td>
                                                <td>{{ $import->failed_rows }}</td>
                                                <td></td>
                                                <td>{{ $import->created_at->format('d/m/Y') }}</td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total') }}@endif
                                                </td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total_pay') }}@endif
                                                </td>
                                                <td><a href="/import/delete-report/{{ $import->id }}"
                                                        onclick="return confirm('Are you sure?')"
                                                        style="text-align: right"><i class="fa fa-trash"
                                                            style="color:red"></i></a></td>
                                            </tr>
                                        @endforeach

                                    </tbody>


                                </table>

                                {{ \App\ImportHistory::whereIn('report_type', ['pilot-price-lists', 'road-rangers-price-lists', 'ta-petro-daily-prices', 'loves-daily-prices'])->latest()->paginate(40)->links() }}
                            @else
                                <div class="callout callout-info">No reports has been imported yet!</div>
                            @endif
                        </div>
                        <div class="tab-pane fade" id="qb-carriers" role="tabpanel" aria-labelledby="qb-carriers-tab">
                             @if ($import_history->count() > 0)
                                <table class="table table-bordered table-hover table-striped datatables" style="width:100%">
                                    <thead>
                                        <th>Filename</th>
                                        <th>Report type</th>
                                        <th>Import success</th>
                                        <th>Failed</th>
                                        <th>Errors</th>
                                        <th>Date</th>
                                        <th>Total</th>
                                        <th>Total pay</th>
                                        <th>Delete</th>
                                    </thead>

                                    <tbody>
                                        @foreach (\App\ImportHistory::where('report_type','quickbooks-verification-carriers')->latest()->paginate()
        as $import)
                                            <tr>
                                                <td><a href="/import/{{ $import->id }}">{{ $import->filename }}</a>
                                                </td>
                                                <td>{{ $import->report_type }}</td>
                                                <td>{{ $import->imported_rows }}</td>
                                                <td>{{ $import->failed_rows }}</td>
                                                <td></td>
                                                <td>{{ $import->created_at->format('d/m/Y') }}</td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total') }}@endif
                                                </td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total_pay') }}@endif
                                                </td>
                                                <td><a href="/import/delete-report/{{ $import->id }}"
                                                        onclick="return confirm('Are you sure?')"
                                                        style="text-align: right"><i class="fa fa-trash"
                                                            style="color:red"></i></a></td>
                                            </tr>
                                        @endforeach

                                    </tbody>


                                </table>

                                {{ \App\ImportHistory::where('report_type','quickbooks-verification-carriers')->latest()->paginate()->links() }}
                            @else
                                <div class="callout callout-info">No reports has been imported yet!</div>
                            @endif
                        </div>
                        <div class="tab-pane fade" id="qb-drivers" role="tabpanel" aria-labelledby="qb-drivers-tab">
                          @if ($import_history->count() > 0)
                                <table class="table table-bordered table-hover table-striped datatables" style="width:100%">
                                    <thead>
                                        <th>Filename</th>
                                        <th>Report type</th>
                                        <th>Import success</th>
                                        <th>Failed</th>
                                        <th>Errors</th>
                                        <th>Date</th>
                                        <th>Total</th>
                                        <th>Failed</th>
                                        <th>Delete</th>
                                    </thead>

                                    <tbody>
                                        @foreach (\App\ImportHistory::where('report_type','qb-verification-drivers')->latest()->paginate()
        as $import)
                                            <tr>
                                                <td><a href="/import/{{ $import->id }}">{{ $import->filename }}</a>
                                                </td>
                                                <td>{{ $import->report_type }}</td>
                                                <td>{{ $import->imported_rows }}</td>
                                                <td>{{ $import->failed_rows }}</td>
                                                <td></td>
                                                <td>{{ $import->created_at->format('d/m/Y') }}</td>
                                                <td>
                                                    @if ($import->report_type == 'compass_report')
                                                        {{ $import->transactions->sum('total') }}@endif
                                                </td>
                                                <td>
                                                        {{ $import->errors }}
                                                </td>
                                                <td><a href="/import/delete-report/{{ $import->id }}"
                                                        onclick="return confirm('Are you sure?')"
                                                        style="text-align: right"><i class="fa fa-trash"
                                                            style="color:red"></i></a></td>
                                            </tr>
                                        @endforeach

                                    </tbody>


                                </table>

                                {{ \App\ImportHistory::where('report_type','qb-verification-drivers')->latest()->paginate()->links() }}
                            @else
                                <div class="callout callout-info">No reports has been imported yet!</div>
                            @endif
                        </div>
                    </div>
                </div>
                <!-- /.card -->
            </div>


        </div>
        <!-- /.card-body -->
    </div>


@stop

@section('css')
    {{-- <link rel="stylesheet" href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css"> --}}

@stop
@section('js')
    <script>
    $(function () {
       
         // get back to the right tab
        var url = new URL(window.location.href);
        var tabId = url.searchParams.get("tab");

        if(typeof tabId === 'string' && tabId.length > 0) {
            $('#'+tabId).trigger('click');
        }
        $('.nav-tabs .nav-link').click(function() {
            history.pushState({}, null, window.location.pathname+'?tab='+$(this).attr('id'));
        });

    });

</script>
@stop