@extends('adminlte::page')
@section('content')
<div class="col-12  col-lg-12">
    <div class="card">
        <div class="card-header">
            <h3 class="card-title"><b>Savings statistics </b> </h3>
        </div>
    </div>


    <div class="card card-default card-tabs">
        <div class="card-header p-2 pt-1">
            <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
                <li class="nav-item">
                    <a class="nav-link @if(!isset(Request()->week_id)) active @endif" id="by-week-tab" data-toggle="pill" href="#by-week-tab-wrapper" role="tab" aria-controls="by-week-tab-wrapper" aria-selected="false">By Week</a>
                </li>

                <li class="nav-item">
                    <a class="nav-link @if(isset(Request()->week_id)) active @endif" id="by-state-tab" data-toggle="pill" href="#by-state-tab-wrapper" role="tab" aria-controls="by-state-tab-wrapper" aria-selected="false">By State</a>
                </li>
            </ul>
        </div>

        <div class="card-body">
            <div class="tab-content" id="custom-tabs-one-tabContent">
                <div class="tab-pane fade @if(!isset(Request()->week_id)) active show @endif" id="by-week-tab-wrapper" role="tabpanel" aria-labelledby="by-week-tab">

                    <!-- BY WEEK second row of tabs -->
                    <div class="card card-default card-tabs">
                        <div class="card-header p-2 pt-1">
                            <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
                                <li class="nav-item">
                                    <a class="nav-link active" id="week-discounts-tab" data-toggle="pill" href="#week-discounts-tab-wrapper" role="tab" aria-controls="week-discounts-tab-wrapper" aria-selected="false">All Discounts</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="week-prices-tab" data-toggle="pill" href="#week-prices-tab-wrapper" role="tab" aria-controls="week-prices-tab-wrapper" aria-selected="false">All Prices</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="pilot-tab" data-toggle="pill" href="#pilot-tab-wrapper" role="tab" aria-controls="pilot-tab-wrapper" aria-selected="false">Pilot US</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="pilot-independent-tab" data-toggle="pill" href="#pilot-independent-tab-wrapper" role="tab" aria-controls="pilot-independent-tab-wrapper" aria-selected="false">Pilot Independent</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="pilot-can-tab" data-toggle="pill" href="#pilot-can-tab-wrapper" role="tab" aria-controls="pilot-can-tab-wrapper" aria-selected="false">Pilot CAN</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="loves-tab" data-toggle="pill" href="#loves-tab-wrapper" role="tab" aria-controls="loves-tab-wrapper" aria-selected="false">Loves</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="road-rangers-tab" data-toggle="pill" href="#road-rangers-tab-wrapper" role="tab" aria-controls="road-rangers-tab-wrapper" aria-selected="false">Road Rangers</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="ta-petro-tab" data-toggle="pill" href="#ta-petro-tab-wrapper" role="tab" aria-controls="ta-petro-tab-wrapper" aria-selected="false">TA Petro</a>
                                </li>
                            </ul>
                        </div>
                        <div class="card-body">
                            <div class="tab-content" id="custom-tabs-one-tabContent">
                                <div class="tab-pane fade active show" id="week-discounts-tab-wrapper" role="tabpanel" aria-labelledby="week-discounts-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>Pilot</th>
                                                <th>Loves</th>
                                                <th>Road Rangers</th>
                                                <th>Pilot Independent</th>
                                                <th>Pilot CAN</th>
                                                <th>TA Petro</th>
                                                <th>Petro Canada</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['week']))
                                            @foreach ($report['week'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{(isset($r['pilot']['avg_savings']) && strlen($r['pilot']['avg_savings']))? number_format($r['pilot']['avg_savings'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($r['loves']['avg_savings']) && strlen($r['loves']['avg_savings']))? number_format($r['loves']['avg_savings'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($r['road_rangers']['avg_savings']) && strlen($r['road_rangers']['avg_savings']))? number_format($r['road_rangers']['avg_savings'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($report['week-pilot-ind'][$date]['pilot']['avg_savings']) && strlen($report['week-pilot-ind'][$date]['pilot']['avg_savings']))? number_format($report['week-pilot-ind'][$date]['pilot']['avg_savings'],2):'0.00' }}</td>
                                                <td class="text-center">{{(isset($report['week-pilot-can'][$date]['pilot']['avg_savings']) && strlen($report['week-pilot-can'][$date]['pilot']['avg_savings']))? number_format($report['week-pilot-can'][$date]['pilot']['avg_savings'],2):'0.00' }}</td>
                                                <td class="text-center">{{(isset($report['taPetro']['avg_savings']) && strlen($report['taPetro']['avg_savings']))? number_format($report['taPetro']['avg_savings'],2):'0.00' }}</td>
                                                <td class="text-center">{{(isset($report['petroCanada']['avg_savings']) && strlen($report['petroCanada']['avg_savings']))? number_format($report['petroCanada']['avg_savings'],2):'0.00' }}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="week-prices-tab-wrapper" role="tabpanel" aria-labelledby="week-prices-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>Pilot</th>
                                                <th>Loves</th>
                                                <th>Road Rangers</th>
                                                <th>Pilot Independent</th>
                                                <th>Pilot CAN</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['week']))
                                            @foreach ($report['week'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{(isset($r['pilot']['avg_price']) && strlen($r['pilot']['avg_price']))? number_format($r['pilot']['avg_price'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($r['loves']['avg_price']) && strlen($r['loves']['avg_price']))? number_format($r['loves']['avg_price'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($r['road_rangers']['avg_price']) && strlen($r['road_rangers']['avg_price']))? number_format($r['road_rangers']['avg_price'],2):'0.00'}}</td>
                                                <td class="text-center">{{(isset($report['week-pilot-can'][$date]['pilot']['avg_price']) && strlen($report['week-pilot-can'][$date]['pilot']['avg_price']))? number_format($report['week-pilot-can'][$date]['pilot']['avg_price'],2):'0.00' }}</td></td>
                                                <td class="text-center">{{(isset($report['week-pilot-ind'][$date]['pilot']['avg_price']) && strlen($report['week-pilot-ind'][$date]['pilot']['avg_price']))? number_format($report['week-pilot-ind'][$date]['pilot']['avg_price'],2):'0.00' }}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="pilot-tab-wrapper" role="tabpanel" aria-labelledby="pilot-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['pilot']))
                                            @foreach ($report['pilot'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="pilot-independent-tab-wrapper" role="tabpanel" aria-labelledby="pilot-independent-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['pilotIndependent']))
                                            @foreach ($report['pilotIndependent'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="pilot-can-tab-wrapper" role="tabpanel" aria-labelledby="pilot-can-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['pilotCanada']))
                                            @foreach ($report['pilotCanada'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="loves-tab-wrapper" role="tabpanel" aria-labelledby="loves-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['loves']))
                                            @foreach ($report['loves'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="road-rangers-tab-wrapper" role="tabpanel" aria-labelledby="road-rangers-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['roadRangers']))
                                            @foreach ($report['roadRangers'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>

                                <div class="tab-pane fade" id="ta-petro-tab-wrapper" role="tabpanel" aria-labelledby="ta-petro-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>Week ID</th>
                                                <th>AVG price</th>
                                                <th>AVG Savings/Q</th>
                                                <th>Country</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['taPetro']))
                                            @foreach ($report['taPetro'] as $date => $r)
                                            <tr>
                                                <td class="text-center">{{$date}}</td>
                                                <td class="text-center">{{number_format($r['avg_price'],2)}}</td>
                                                <td class="text-center">{{$r['avg_savings']}}</td>
                                                <td class="text-center">{{$r['country']}}</td>
                                            </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>

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


                </div>
                <div class="tab-pane fade @if(isset(Request()->week_id)) active show @endif" id="by-state-tab-wrapper" role="tabpanel" aria-labelledby="by-state-tab">
                    <!-- BY STATE second row of tabs -->
                    <div class="card card-default card-tabs">
                        <div class="card-header p-2 pt-1">
                            <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
                                <li class="nav-item">
                                    <a class="nav-link active" id="state-discounts-tab" data-toggle="pill" href="#state-discounts-tab-wrapper" role="tab" aria-controls="state-discounts-tab-wrapper" aria-selected="false">All Discounts</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" id="state-prices-tab" data-toggle="pill" href="#state-prices-tab-wrapper" role="tab" aria-controls="state-prices-tab-wrapper" aria-selected="false">All Prices</a>
                                </li>
                            </ul>
                        </div>
                        <div class="card-body">
                            <form action="/savings-statistics" method="get" class="form-inline" style="float:right;">
                                <label for="week_id">Week ID</label> &nbsp;&nbsp;
                                <select name="week_id" id="week_id" style="width:200px">
                                    @foreach($week_ids as $nr => $week)
                                        <option value="{{$nr}}" @if(isset(Request()->week_id) && Request()->week_id == $nr) selected @endif >{{$week['week_start']}} - {{$week['week_end']}}</option>
                                    @endforeach
                                </select>
                                <input type="submit" value="Search" class="btn btn-success" style="margin:10px" />
                            </form>
                            <div class="tab-content" id="custom-tabs-one-tabContent">
                                <div class="tab-pane fade active show" id="state-discounts-tab-wrapper" role="tabpanel" aria-labelledby="state-discounts-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>State</th>
                                                <th>Pilot</th>

                                                <th>Loves</th>
                                                <th>Road Rangers</th>
                                                <th>TA Petro</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['daily-prices']))
                                            @foreach ($report['daily-prices'] as $state => $r)
                                                @if(!empty($state) && ctype_alpha($state))
                                                    <tr>
                                                        <td class="text-center">{{$state}}</td>
                                                        <td class="text-center">{{(isset($r['pilot']['avg_savings']) && strlen($r['pilot']['avg_savings']))? number_format($r['pilot']['avg_savings'],2):'0.00'}}</td>

                                                        <td class="text-center">{{(isset($r['loves']['avg_savings']) && strlen($r['loves']['avg_savings']))? number_format($r['loves']['avg_savings'],2):'0.00'}}</td>
                                                        <td class="text-center">{{(isset($r['road_rangers']['avg_savings']) && strlen($r['road_rangers']['avg_savings']))? number_format($r['road_rangers']['avg_savings'],2):'0.00'}}</td>
                                                        <td class="text-center">{{(isset($r['ta_petro']['avg_savings']) && strlen($r['ta_petro']['avg_savings']))? number_format($r['ta_petro']['avg_savings'],2):'0.00'}}</td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                                <div class="tab-pane fade" id="state-prices-tab-wrapper" role="tabpanel" aria-labelledby="state-prices-tab">
                                    <table class="table table-striped table-bordered">
                                        <tr>
                                            <thead style="text-align: center">
                                                <th>State</th>
                                                <th>Pilot</th>

                                                <th>Loves</th>
                                                <th>Road Rangers</th>
                                                <th>TA Petro</th>
                                            </thead>
                                        </tr>
                                        @if(isset($report['daily-prices']))
                                            @foreach ($report['daily-prices'] as $state => $r)
                                                @if(!empty($state) && ctype_alpha($state))
                                                    <tr>
                                                        <td class="text-center">{{$state}}</td>
                                                        <td class="text-center">{{(isset($r['pilot']['avg_price']) && strlen($r['pilot']['avg_price']))? number_format($r['pilot']['avg_price'],2):'0.00'}}</td>

                                                        <td class="text-center">{{(isset($r['loves']['avg_price']) && strlen($r['loves']['avg_price']))? number_format($r['loves']['avg_price'],2):'0.00'}}</td>
                                                        <td class="text-center">{{(isset($r['road_rangers']['avg_price']) && strlen($r['road_rangers']['avg_price']))? number_format($r['road_rangers']['avg_price'],2):'0.00'}}</td>
                                                        <td class="text-center">{{(isset($r['ta_petro']['avg_price']) && strlen($r['ta_petro']['avg_price']))? number_format($r['ta_petro']['avg_price'],2):'0.00'}}</td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </div>


</div>


@stop

@section('css')

@stop

@section('js')
<script src="https://unpkg.com/multiple-select@1.5.2/dist/multiple-select.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chart.js@2.9.3/dist/Chart.min.js"></script>
<script>
    $(function () {
        //$('#week_id').multipleSelect();
    });
</script>
@stop