@extends('adminlte::page')


@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title"><b>Savings by broker </b> </h3>
            <a href="/revenue-broker-old" class="btn btn-info btn-sm" style="float:right">Old version</a>
        </div>

    </div>

    <div class="card card-primary card-outline card-tabs">
        <div class="card-header p-0 pt-1 border-bottom-0">
            <ul class="nav nav-tabs" id="custom-tabs-three-tab" role="tablist">
                <li class="nav-item">
                    <a class="nav-link active" id="custom-tabs-three-home-tab" data-toggle="pill"
                        href="#custom-tabs-three-home" role="tab" aria-controls="custom-tabs-three-home"
                        aria-selected="true">Primary Brokers</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" id="custom-tabs-three-profile-tab" data-toggle="pill"
                        href="#custom-tabs-three-profile" role="tab" aria-controls="custom-tabs-three-profile"
                        aria-selected="false">Secondary Brokers</a>
                </li>
                {{-- <li class="nav-item">
                    <a class="nav-link" id="custom-tabs-three-messages-tab" data-toggle="pill" href="#custom-tabs-three-messages" role="tab" aria-controls="custom-tabs-three-messages" aria-selected="false">Messages</a>
                  </li> --}}
            </ul>
        </div>
        <div class="card-body">
            <div class="tab-content" id="custom-tabs-three-tabContent">
                <div class="tab-pane fade show active" id="custom-tabs-three-home" role="tabpanel"
                    aria-labelledby="custom-tabs-three-home-tab">
                    <table class="table table-bordered table-striped table-hover" style="margin-top:20px">
                        <tr>
                            <thead style="text-align: center">
                                <th></th>
                                @foreach ($primary_brokers as $pb)
                                    <th colspan="2">{{ $pb->name }}</th>

                                @endforeach
                                <th colspan="2">Total</th>
                            </thead>
                        </tr>
                        <tbody style="text-align: center">
                            <tr>
                                <td></td>
                                @foreach ($primary_brokers as $pb)
                                    <th>US</th>
                                    <th>CAN</th>
                                @endforeach
                                <th>US</th>
                                <th>CAN</th>
                            </tr>
                            <tr>
                                <th>Total</th>
                                @foreach ($primary_brokers as $pb)
                                    <th style="text-align:right">
                                        {{ number_format($total_primary_brokers[$pb->id]['profit_us'], 2) }}</th>
                                    <th style="text-align:right">
                                        {{ number_format($total_primary_brokers[$pb->id]['profit_cad'], 2) }}</th>
                                @endforeach
                                <th>{{ number_format($total->savings_usd, 2) }}</th>
                                <th>{{ number_format($total->savings_cad, 2) }}</th>

                            </tr>
                            @foreach ($primary_brokers_data as $week_id => $brokers_data)
                                <tr>
                                    <td>{{ $week_id }}</td>
                                    @foreach ($primary_brokers as $pb)
                                        @foreach ($brokers_data as $broker)

                                            <td> {{ number_format($broker[$pb->id]['profit_us'], 2) }}</td>
                                            <td> {{ number_format($broker[$pb->id]['profit_cad'], 2) }}</td>

                                        @endforeach
                                    @endforeach
                                    <td>{{number_format($total_by_week_id[$week_id]['profit_us'],2)}} </td>
                                    <td>{{number_format($total_by_week_id[$week_id]['profit_cad'],2)}} </td>

                                </tr>
                            @endforeach





                        </tbody>
                    </table>



                </div>
                <div class="tab-pane fade" id="custom-tabs-three-profile" role="tabpanel"
                    aria-labelledby="custom-tabs-three-profile-tab">

                    <table class="table table-bordered table-striped table-hover" style="margin-top:20px">
                        <tr>
                            <thead style="text-align: center">
                                <th></th>
                                @foreach ($secondary_brokers as $pb)
                                    <th colspan="2">{{ $pb->name }}</th>

                                @endforeach
                                <th colspan="2">Total</th>
                            </thead>
                        </tr>
                        <tbody style="text-align: center">
                            <tr>
                                <td></td>
                                @foreach ($secondary_brokers as $pb)
                                    <th>US</th>
                                    <th>CAN</th>
                                @endforeach
                                <th>US</th>
                                <th>CAN</th>

                            </tr>
                            <tr>
                                <th>Total</th>
                                @foreach ($secondary_brokers as $pb)
                                    <th style="text-align:right">
                                        {{ number_format($total_secondary_brokers[$pb->id]['profit_us'], 2) }}</th>
                                    <th style="text-align:right">
                                        {{ number_format($total_secondary_brokers[$pb->id]['profit_cad'], 2) }}</th>
                                @endforeach
                                 <th>{{ number_format($total->savings_usd, 2) }}</th>
                                <th>{{ number_format($total->savings_cad, 2) }}</th>

                            </tr>
                            @foreach ($secondary_brokers_data as $week_id => $brokers_data)
                                <tr>
                                    <td>{{ $week_id }}</td>
                                    @foreach ($secondary_brokers as $pb)
                                        @foreach ($brokers_data as $broker)

                                            <td> {{ number_format($broker[$pb->id]['profit_us'], 2) }}</td>
                                            <td> {{ number_format($broker[$pb->id]['profit_cad'], 2) }}</td>

                                        @endforeach
                                    @endforeach
                                     <td>{{number_format($total_by_week_id_secondary[$week_id]['profit_us'],2)}} </td>
                                    <td>{{number_format($total_by_week_id_secondary[$week_id]['profit_cad'],2)}} </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>


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

@stop

@section('css')
    <style>
        table td {
            text-align: right;
        }

    </style>
@stop

@section('js')

@stop