@extends('adminlte::page')


@section('content')
<div class="card">
    <div class="card-header">
        <h3 class="card-title"><b>Savings statistics </b> </h3>
        <form action="/savings-statistics" method="get" style="float:right">
            <label for="fuel_provider">Fuel provider</label>
            <select name="fuel_provider" id="fuel_provider">
                <option value="">All</option>
                <option value="pilot" @if(Request()->fuel_provider=='pilot') selected @endif>Pilot</option>
                <option value="loves" @if(Request()->fuel_provider=='loves') selected @endif>Loves</option>
            </select>
            <label for="country">Country</label>
            <select name="country" id="country">
                <option value="">All</option>
                <option value="us" @if(Request()->country=='us') selected @endif>US</option>
                <option value="can" @if(Request()->country=='can') selected @endif>CAN</option>
            </select>
            <input type="submit" value="Filter" class="btn btn-sm btn-success" />
        </form>
    </div>
    <!-- /.card-header -->
    <div class="card-body">

        <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>
                    <th>Fuel provider</th>
                </thead>
            </tr>
            @foreach ($report as $date=>$r)
            <tr>
                <td>{{$date}}</td>
                <td>{{number_format($r['avg_price'],3)}}</td>
                <td>{{number_format($r['avg_savings'],3)}}</td>
                <td>{{$r['country']}}</td>
                <td>{{$r['fuel_provider']}}</td>
            </tr>
            @endforeach
        </table>


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

@section('css')

@stop

@section('js')
<script src="https://cdn.jsdelivr.net/npm/chart.js@2.9.3/dist/Chart.min.js"></script>
<script>

</script>
@stop