@extends('adminlte::page')


@section('content')

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

        <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">
                        @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 />
                            @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">
                    <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">
                            <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>
                                <option value="pilot" @if(isset($filters->fuel_provider) && $filters->fuel_provider=='pilot') selected @endif>Pilot</option>
                                <option value="loves" @if(isset($filters->fuel_provider) && $filters->fuel_provider=='loves') selected @endif>Loves</option>
                                <option value="road_rangers" @if(isset($filters->fuel_provider) && $filters->fuel_provider=='road_rangers') selected @endif>Road Rangers</option>
                                <option value="independent" @if(isset($filters->fuel_provider) && $filters->fuel_provider=='independent') selected @endif>Independent</option>
                                <option value="cps_checks" @if(isset($filters->fuel_provider) && $filters->fuel_provider=='cps_checks') selected @endif>Cps checks</option>
                            </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="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>

                            <b>Filter by date</b>

                            <label for="from_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"/>

                            <label for="to_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"/>

                            <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"/>

                            <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"/>


                            <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"/>

                            <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>
                            <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 />
                            <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')
        {{$filter}}: {{\App\Broker::find($value)->name}},
        @elseif($filter=='carrier')
        {{$filter}}: {{\App\Carrier::find($value)->name}}
        @else
        {{$filter}}: {{$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" value="20{{date('W')-1}}" />

                    <label for="carrier">Carrier</label>
                    <select name="carrier_id" id="carrier" class="form-control">
                        @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>
<!-- /.modal-dialog -->
</div>


@stop

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

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