@extends('adminlte::page')


@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title"><b>Savings by broker </b> </h3>

            <form action="/revenue-broker" method="post">
                @csrf
                <div class="form-group form-inline fa-pull-right">

                    <label for="broker">Broker</label>
                    <select name="broker_id" id="broker" class="form-control">
                        <option value="">All</option>
                    @foreach($brokers as $broker)
                            <option value="{{$broker->id}}" @if($selected_broker!=null && $selected_broker==$broker->id) selected @endif>{{$broker->name}}</option>
                    @endforeach
                    </select>

                    <label for="fuel_provider" style="margin-left:5px">Fuel provider</label>
                    <select name="fuel_provider" id="fuel_provider" class="form-control">
                        <option value="">All</option>
                        <option value="pilot" @if($selected_fuel_provider=='pilot') selected @endif>Pilot statement</option>
                        <option value="loves" @if($selected_fuel_provider=='loves') selected @endif>Loves</option>
                    </select>
                    {{--<input type="date" name="month" class="form-control" @if($month!=null) value="{{$month}}" @endif placeholder="Month"/>--}}
                    <input type="submit" class="btn btn-sm btn-success" value="Filter">
                </div>
            </form>
        </div>

    </div>
            <table class="table table-bordered table-striped table-hover" style="margin-top:20px">
                <tr >
                    <thead style="text-align: center">
                    <th></th>
                    <th colspan="2">Radu</th>
                    <th colspan="2">Vasi</th>
                    <th colspan="2">Pete</th>
                    <th colspan="2">Gelly</th>
                    <th colspan="2">Arslan</th>
                    <th colspan="2">Marcel</th>
                    <th colspan="2">Daniel</th>
                    <th colspan="2">Total</th>

                    </thead>
                </tr>
                <tbody style="text-align: center">
                <tr>
                    <td></td>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                    <th >US</th>
                    <th >CAN</th>
                </tr>
                <tr></tr><th>Total</th>
                    <td>{{number_format($totals->pru,2)}}</td>
                    <td>{{number_format($totals->prc,2)}}</td>
                    <td>{{number_format($totals->pvu,2)}}</td>
                    <td>{{number_format($totals->pvc,2)}}</td>
                    <td>{{number_format($totals->ppu,2)}}</td>
                    <td>{{number_format($totals->ppc,2)}}</td>
                    <td>{{number_format($totals->pgu,2)}}</td>
                    <td>{{number_format($totals->pgc,2)}}</td>
                    <td>{{number_format($totals->pau,2)}}</td>
                    <td>{{number_format($totals->pac,2)}}</td>
                    <td>{{number_format($totals->pmu,2)}}</td>
                    <td>{{number_format($totals->pmc,2)}}</td>
                    <td>{{number_format($totals->pdu,2)}}</td>
                    <td>{{number_format($totals->pdc,2)}}</td>
                    <td> {{number_format(($totals->pru+$totals->pvu+$totals->ppu+$totals->pgu+$totals->pau+$totals->pmu+$totals->pdu),2)}} </td>
                    <td> {{number_format(($totals->prc+$totals->pvc+$totals->ppc+$totals->pgc+$totals->pac+$totals->pmc+$totals->pdc),2)}} </td>
                </tr>
                @foreach ($report as $r)
                    <tr>
                        <td>{{$r->week_id}}</td>
                    <td>{{$r->pru}}</td>
                    <td>{{$r->prc}}</td>
                    <td>{{$r->pvu}}</td>
                    <td>{{$r->pvc}}</td>
                    <td>{{$r->ppu}}</td>
                    <td>{{$r->ppc}}</td>
                    <td>{{$r->pgu}}</td>
                    <td>{{$r->pgc}}</td>
                    <td>{{$r->pau}}</td>
                    <td>{{$r->pac}}</td>
                    <td>{{$r->pmu}}</td>
                    <td>{{$r->pmc}}</td>
                    <td>{{$r->pdu}}</td>
                    <td>{{$r->pdc}}</td>
                    <td> {{number_format(($r->pru+$r->pvu+$r->ppu+$r->ppu+$r->pgu+$r->pau+$r->pmu+$r->pdu),2)}}</td>
                    <td> {{number_format(($r->prc+$r->pvc+$r->ppc+$r->ppc+$r->pgc+$r->pac+$r->pmc+$r->pdc),2)}}</td>
                    </tr>
                @endforeach

                </tbody>
            </table>







      
@stop

@section('css')

@stop

@section('js')

@stop