@extends('adminlte::page')


@section('content')

    @if ($message = Session::get('success'))
        <div class="alert alert-success">
            <p>{{ $message }} transactions imported</p>
        </div>
    @endif

    @if ($message = Session::get('warning'))
        <div class="alert alert-warning" style="text-align:center">
            <p>{{ $message }} </p>
        </div>
    @endif

    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Reports </h3>

            <div class="card-tools">
                <form action="/reports/search" method="post">
                    @csrf
                    <div class="input-group input-group-sm" style="width: 150px;">

                        <input type="text" name="auth_no" class="form-control float-right"
                            value="{{ Request()->auth_no }}" placeholder="Search by auth#">

                        <div class="input-group-append">
                            <button type="submit" class="btn btn-default"><i class="fas fa-search"></i></button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
        <!-- /.card-header -->
        <div class="card-body">


            <button type="button" class="btn btn-default" data-toggle="modal" data-target="#filters">
                <i class="fa fa-filter"></i>
                <span class="info-box-text">Filters</span>

            </button>

            <button type="button" class="btn btn-default" data-toggle="modal" data-target="#select_columns">
                <i class="fa fa-filter"></i>
                <span class="info-box-text">Select columns</span>

            </button>

            <button type="button" class="btn btn-sm btn-success" data-toggle="modal" data-target="#compass-reports"
                style="margin-left: 5px;float:right">
                <i class="fa fa-download"></i> Import CPS Report
            </button>


            <button type="button" class="btn btn-sm btn-success" data-toggle="modal" data-target="#add-transaction"
                style="margin-left: 5px;float:right">
                <i class="fa fa-plus"></i> Add transaction
            </button>

            <a href="/reports?export" class="btn btn-success btn-sm" style="float: right"><i class="fa fa-upload"></i>
                Export</a>

            <div class="modal fade" id="select_columns">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <form action="/reports/set-header" method="post" id="select_columns">
                            @csrf
                            <div class="modal-header">
                                <h4 class="modal-title">Select columns</h4>

                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">×</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <b>Select table header:</b> <br><br />
                                <label for="results_per_page">Results per page</label>
                                <input type="text" name="results_per_page" class="form-control"
                                    style="width: 100px" /><br />
                                <input type="checkbox" id="check_all"
                                    onclick="$('input:checkbox').not(this).prop('checked', this.checked);">
                                <label for="check_all">Check all</label> <br />
                                <input type="checkbox" id="discount_verification">
                                <label for="discount_verification">Discount Verification</label> <br />
                                <input type="checkbox" id="profit_verification_us">
                                <label for="profit_verification_us">Profit Verification US</label> <br />
                                <input type="checkbox" id="profit_verification_can">
                                <label for="profit_verification_can">Profit Verification CAN</label> <br />
                                <hr />
                                @foreach ($all_table_header as $column => $name)
                                    <input type="checkbox" name="columns[]" @if (isset($table_header[$column])) checked @endif
                                        id="{{ $column }}" value="{{ $column }}"> <label
                                        for="{{ $column }}">{{ $name }}</label> <br />
                                @endforeach


                                <input type="submit" class="btn btn-success" value="Filter" />
                            </div>
                        </form>

                    </div>
                </div>
                <!-- /.modal-content -->
            </div>

            <div class="modal fade" id="filters">
                <div class="modal-dialog">
                    <div class="modal-content" style="width:800px">
                        <form action="/reports/set-filter" method="post">
                            @csrf
                            <div class="modal-header">
                                <h4 class="modal-title">Filters</h4>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">×</span>
                                </button>
                            </div>
                            <div class="modal-body" id="form-filters">


                                <div class="form-inline">
                                    <label for="filter_by_fuel_provider">Fuel provider</label>
                                    <select name="filters[fuel_provider]" id="filter_by_fuel_provider" class="form-control">
                                        <option value="">All</option>
                                        @foreach ($fuel_providers as $fuel_provider)
                                            <option value="{{ $fuel_provider->value }}" @if (isset($filters->fuel_provider) && $filters->fuel_provider == 'pilot') selected @endif>{{ $fuel_provider->name }}</option>
                                        @endforeach
                                    </select><br />

                                    <label for="pilot_independent">Pilot independent</label>
                                    <select name="filters[pilot_independent]" id="pilot_independent" class="form-control">
                                        <option value="">All</option>
                                        <option value="Y" @if (isset($filters->pilot_independent) && $filters->pilot_independent == 'Y') selected @endif>Y</option>
                                        <option value="N" @if (isset($filters->pilot_independent) && $filters->pilot_independent == 'N') selected @endif>N</option>
                                    </select><br />



                                    <label for="direct_billing">Direct billing</label>
                                    <select name="filters[direct_billing]" id="direct_billing">
                                        <option value="">All</option>
                                        <option value="Y" @if (isset($filters->direct_billing) && $filters->direct_billing == 'Y') checked @endif>Yes</option>
                                        <option value="N" @if (isset($filters->direct_billing) && $filters->direct_billing == 'N') checked @endif>No</option>
                                    </select>

                                    <label for="linked">Linked</label>
                                    <select name="filters[linked]" id="linked">
                                        <option value="">All</option>
                                        <option value="Y" @if (isset($filters->linked) && $filters->linked == 'Y') checked @endif>Yes</option>
                                        <option value="N" @if (isset($filters->linked) && $filters->linked == 'N') checked @endif>No</option>
                                    </select>
                                    <br />

                                </div>

                                <hr />
                                <div class="form-inline">
                                    <label for="filter_by_broker">Broker</label>
                                    <select name="filters[broker]" id="filter_by_broker" class="form-control">
                                        <option value="">All</option>
                                        @foreach ($brokers as $broker)
                                            <option value="{{ $broker->id }}" @if (isset($filters->broker) && $filters->broker == $broker->id) selected @endif>{{ $broker->name }}</option>
                                        @endforeach
                                    </select><br />

                                    <label for="filter_by_carrier">Carrier</label>
                                    <select name="filters[carrier]" id="filter_carrier" class="form-control">
                                        <option value="">All</option>
                                        @foreach ($carriers as $carrier)
                                            <option value="{{ $carrier->id }}" @if (isset($filters->carrier) && $filters->carrier == $carrier->id) selected @endif>{{ $carrier->name }}</option>
                                        @endforeach
                                    </select> <br />

                                    <label for="filter_by_carrier_group">Carrier group</label>
                                    <select name="filters[group_id]" id="filter_carrier_group" class="form-control">
                                        <option value="">All</option>
                                        @foreach ($carrier_groups as $group)
                                            <option value="{{ $group->id }}" @if (isset($filters->group_id) && $filters->group_id == $group->id) selected @endif>{{ $group->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <hr />
                                <div class="form-inline">
                                    <label for="from_date">Date From</label>
                                    <input type="date" id="from_date" name="filters[from_date]" @if (isset($filters->from_date) && $filters->from_date != '') value="{{ $filters->from_date }}" @endif
                                        class="form-control" style="margin-right:5px" />

                                    <label for="to_date">Date To</label>
                                    <input type="date" id="to_date" name="filters[to_date]" @if (isset($filters->to_date) && $filters->to_date != '') value="{{ $filters->to_date }}" @endif
                                        class="form-control" />
</div> <hr/>
                                                               <div class="form-inline">

                                    <label for="wek_id">Week ID from</label>
                                    <input type="text" id="week_id" name="filters[week_id]" @if (isset($filters->week_id) && $filters->week_id != '') value="{{ $filters->week_id }}" @endif
                                        class="form-control" style="margin-right:15px"/>

                                    <label for="wek_id">Week ID to</label>
                                    <input type="text" id="week_id_to" name="filters[week_id_to]" @if (isset($filters->week_id_to) && $filters->week_id_to != '') value="{{ $filters->week_id_to }}" @endif
                                        class="form-control" />

                                </div>
                                <hr/>
                                                                <div class="form-inline">
                                <label for="country">Country</label>
                                <select name="filters[country]" id="country" class="form-control">
                                    <option value="">All</option>
                                    <option value="us" @if (isset($filters->country) && $filters->country == 'us') selected @endif>US</option>
                                    <option value="can" @if (isset($filters->country) && $filters->country == 'can') selected @endif>Canada</option>
                                </select>

                                <label for="unit_no">Unit #</label>
                                <input type="text" id="unit_no" name="filters[unit_no]" @if (isset($filters->unit_no) && $filters->unit_no != '') value="{{ $filters->unit_no }}" @endif
                                    class="form-control" style="margin-right:5px"/>

                                <br />

                                <label for="empty_auth_code">Empty auth code</label>
                                <input type="checkbox" name="filters[empty_auth_code]" @if (isset($filters->empty_auth_code) && $filters->empty_auth_code == 'on') checked @endif> <br />
                                </div>
                                <hr/>
                                <input type="submit" class="btn btn-success" value="Filter" />
                            </div>
                        </form>

                    </div>
                </div>
                <!-- /.modal-content -->
            </div>

            <br>
            <br>

            @if (!empty($filters))
                <b> Active filters:</b>
                @foreach ($filters as $filter => $value)

                    @if ($value != '')
                        @if ($filter == 'broker')
                            {{ ucfirst(str_replace('_', ' ', $filter)) }}: {{ \App\Broker::find($value)->name }},
                        @elseif($filter=='carrier')
                            {{ ucfirst(str_replace('_', ' ', $filter)) }}: {{ \App\Carrier::find($value)->name }}
                        @else
                            {{ ucfirst(str_replace('_', ' ', $filter)) }}: {{ ucfirst(str_replace('_', ' ', $value)) }},
                        @endif
                    @endif
                    @endforeach <a href="/reports/clear-filters">Clear all</a><br /> <br />
                @endif Results per page : {{ $results_per_page }}

                @if (!empty($table))
                    <table class="table table-bordered table-hover table-striped">
                        <thead>
                            <th>View</th>
                            @foreach ($table_header as $column => $name)
                                <th style="white-space:nowrap;">{{ $name }}</th>
                            @endforeach

                        </thead>
                        <tbody>
                            <tr style="font-size:12px">
                                <th>Total</th>
                                @if (isset($table_header['broker']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['carrier']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['fuel_provider']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['report_id']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['driver']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['unit']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['merchant']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['merchant_id']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['invoice']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['auth_code']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['date']))
                                    <td></td>
                                @endif
                                @if (isset($table_header['volume']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['total_volume'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['total_volume'] }}
                                            {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                                @if (isset($table_header['price']) && isset($totals_columns[0]['price']))
                                    <th>{{ number_format($totals_columns[0]['avg_price'], 3) }}
                                        {{ $totals_columns[0]['us_can'] }} @if (isset($totals_columns[1]))/
                                            {{ number_format($totals_columns[1]['avg_price'], 3) }}
                                            {{ $totals_columns[1]['us_can'] }} @endif
                                    </th>
                                @endif
                                @if (isset($table_header['reefer_ppg']) && isset($totals_columns[0]))
                                    <th>{{ number_format($totals_columns[0]['avg_reefer_ppg'], 3) }}
                                        {{ $totals_columns[0]['us_can'] }} @if (isset($totals_columns[1]))/
                                            {{ number_format($totals_columns[1]['avg_reefer_ppg'], 3) }}
                                            {{ $totals_columns[1]['us_can'] }} @endif
                                    </th>
                                @endif
                                @if (isset($table_header['reefer_quantity']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['total_volume_reefer'] }}
                                        {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['total_volume_reefer'] }}
                                            {{ $totals_columns[1]['us_can'] }} @endif
                                    </th>
                                @endif
                                @if (isset($table_header['reefer_amount']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['total_reefer_amount'] }}
                                        {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/ @if (isset($totals_columns[1]))
                                                {{ $totals_columns[1]['total_reefer_amount'] }}
                                                {{ $totals_columns[1]['us_can'] }} @endif
                                        @endif
                                    </th>
                                @endif
                                @if (isset($table_header['discount']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['total_discount'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['total_discount'] }}
                                            {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                                @if (isset($table_header['discount2']))
                                    <th></th>
                                @endif
                                @if (isset($table_header['def']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['def_total'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['def_total'] }} {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                                @if (isset($table_header['def2']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['def_total2'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['def_total2'] }} {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                @if (isset($table_header['total']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['total_sum'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['total_sum'] }} {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                                @if (isset($table_header['total_pay']) && isset($totals_columns[0]))
                                    <th>{{ $totals_columns[0]['ttp_total'] }} {{ $totals_columns[0]['us_can'] }}
                                        @if (isset($totals_columns[1]))/
                                            {{ $totals_columns[1]['ttp_total'] }} {{ $totals_columns[1]['us_can'] }}
                                        @endif
                                    </th>
                                @endif
                            </tr>
                            @foreach ($table as $index => $td)
                                <tr>
                                    <td><a href="/reports/{{ $td['id'] }}" class="btn btn-default"> <i
                                                class="fa fa-eye"></i> View</a></td>
                                    @foreach ($table_header as $column => $name)

                                        @if (isset($td[$column]))
                                            <td @if ($column == 'fp_check_1')  @if ($td[$column] < 0.01
                                                && $td[$column] > -0.01) style="background-color:
                                                greenyellow"
                                            @else style="background-color:red" @endif

                                            @elseif($column=='pl_check_3')
                                                @if ($td[$column] < 0.01 && $td[$column] > -0.01)
                                                    style="background-color: greenyellow"
                                                @else style="background-color:red"
                                                @endif

                                        @endif



                                        >{{ $td[$column] }}</td>
                                    @elseif(isset($td['all'][$column]))
                                        <td>{{ $td['all'][$column] }}</td>
                                    @else <td></td>
                                    @endif
                            @endforeach
                            </tr>
                @endforeach

                </tbody>

                </table>


                {{ $cps_rep->links() }}
            @else
                <p class="callout callout-info">There are no reports matching your current filters!</p>
            @endif

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


    <div class="modal fade" id="compass-reports">
        <div class="modal-dialog">
            <div class="modal-content">
                <form action="/import" method="post" enctype="multipart/form-data">
                    @csrf
                    <div class="modal-header">
                        <h4 class="modal-title">Compass reports</h4>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <input type="hidden" name="report_type" value="compass_report">
                        <label for="week_id">Week ID</label>
                        <input type="text" name="week_id" id="week_id" class="form-control" @if (date('W') - 1 != 0) value="{{ date('y') }}{{ date('W') - 1 }}" @else value="{{ date('y') - 1 }}53" @endif />


                        <label for="provider">Provider</label>
                        <select name="provider" id="provider" class="form-control">
                            <option value="cps" selected>CPS</option>
                            <option value="quickq">QuickQ</option>
                            <option value="petro-canada">Petro Canada</option>
                        </select><br />
                        <label for="carrier">Carrier</label>
                        <select name="carrier_id" id="carrier" class="form-control">
                            <option value="0">* Automated Search *</option>
                            @foreach ($carriers as $carrier)
                                <option value="{{ $carrier->id }}">{{ $carrier->name }}</option>
                            @endforeach
                        </select><br />

                        <label for="report">Report</label>
                        <input type="file" id="report" name="report" class="form-control" /> <br />
                        <input type="submit" class="btn btn-success" value="Import" />
                    </div>
                </form>

            </div>
        </div>
        <!-- /.modal-content -->
    </div>

    <div class="modal fade" id="add-transaction">
        <div class="modal-dialog">
            <div class="modal-content">
                <form action="/cps/add" method="post">
                    @csrf
                    <div class="modal-header">
                        <h4 class="modal-title">Add CPS transaction</h4>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <label for="week_id">Week ID</label>
                        <input type="text" name="week_id" id="week_id" class="form-control" @if (date('W') - 1 != 0) value="{{ date('y') }}{{ date('W') - 1 }}" @else value="{{ date('y') - 1 }}53" @endif />

                        <label for="filter_by_fuel_provider">Fuel provider</label>
                        <select name="fuel_provider" id="filter_by_fuel_provider" class="form-control">
                            <option value="">All</option>
                            @foreach ($fuel_providers as $fuel_provider)
                                <option value="{{ $fuel_provider->value }}">{{ $fuel_provider->name }}</option>
                            @endforeach
                        </select><br />

                        <label for="merchant">Merchant</label>
                        <input type="text" name="merchant" id="merchant" class="form-control" />

                        <label for="total">Total</label>
                        <input type="text" name="total" id="total" class="form-control" />

                        <label for="ttp">TTP</label>
                        <input type="text" name="ttp" id="ttp" class="form-control" />

                        <label for="date">Date</label>
                        <input type="date" name="date" id="date" class="form-control" />

                        {{-- <label for="fuel_provider">Fuel provider</label>
                        <select name="fuel_provider" id="fuel_provider" class="form-control">
                            <option value="cps" selected></option>
                            <option value="quickq">QuickQ</option>
                            <option value="petro-canada">Petro Canada</option>
                        </select><br /> --}}

                        <label for="country">Country</label>
                        <select name="country" id="country" class="form-control">
                            <option value="us" selected>US</option>
                            <option value="can">CAN</option>
                        </select><br />

                        <label for="carrier">Carrier</label>
                        <select name="carrier_id" id="carrier" class="form-control">
                            <option value="0">* Automated Search *</option>
                            @foreach ($carriers as $carrier)
                                <option value="{{ $carrier->id }}">{{ $carrier->name }}</option>
                            @endforeach
                        </select><br />


                        <input type="submit" class="btn btn-success" value="Save" />
                    </div>
                </form>

            </div>
        </div>
        <!-- /.modal-content -->
    </div>
    <!-- /.modal-dialog -->
    </div>


@stop

@section('css')
    <style>
        .card-body {
            overflow-x: scroll;
        }

        #form-filters select {
            margin-right: 15px;
        }

        #form-filters label {
            margin-right: 5px;
        }

    </style>
@stop

@section('js')
    <script>
        $(function() {
            $(".datatables").DataTable();

            var discount_verification_checkboxes = ['carrier', 'fuel_provider', 'pilot_independent', 'merchant',
                'merchant_id', 'auth_code',
                'date', 'volume', 'reefer_quantity', 'total_discount', 'fee', 'ca_fee', 'total', 'ttp2',
                'us_can', 'fp_retail_total', 'fp_savings', 'pl_savings_q', 'pl_savings', 'week_id'
            ];
            var profit_verification_us = ['broker', 'carrier', 'fuel_provider', 'merchant', 'date',
                'total_discount',
                'fee', 'ca_fee', 'ttp2', 'us_can', 'fp_invoice_total', 'fp_retail_total', 'fp_savings',
                'profit_2_usd',
                'pr_Radu_u', 'pr_Vasi_u', 'pr_Pete_u', 'pr_Gelly_u', 'pr_Arslan_u', 'pr_Arslan_u',
                'pr_Marcel_u', 'pr_Daniel_u', 'pr_Johnny_u', 'pr_Mike_u',
                'week_id'
            ];

            var profit_verification_can = ['broker', 'carrier', 'fuel_provider', 'merchant', 'date',
                'total_discount',
                'fee', 'ca_fee', 'ttp2', 'us_can', 'fp_invoice_total', 'fp_retail_total', 'fp_savings',
                'profit_2_cad',
                'pr_Radu_c', 'pr_Vasi_c', 'pr_Pete_c', 'pr_Gelly_c', 'pr_Arslan_c', 'pr_Arslan_c',
                'pr_Marcel_c', 'pr_Daniel_c', 'pr_Johnny_c', 'pr_Mike_c',
                'week_id'
            ];

            $("#discount_verification").change(function() {
                $('#select_columns input:checkbox').prop('checked', false);
                jQuery.each(discount_verification_checkboxes, function(index, value) {
                    $('#' + value).prop('checked', true);
                });
                $("#discount_verification").prop('checked', true);
            });

            $("#profit_verification_us").change(function() {
                $('#select_columns input:checkbox').prop('checked', false);
                jQuery.each(profit_verification_us, function(index, value) {
                    $('#' + value).prop('checked', true);
                });
                $("#profit_verification_us").prop('checked', true);
            });

            $("#profit_verification_can").change(function() {
                $('#select_columns input:checkbox').prop('checked', false);
                jQuery.each(profit_verification_can, function(index, value) {
                    $('#' + value).prop('checked', true);
                });
                $("#profit_verification_can").prop('checked', true);
            });

        });

    </script>
@stop