@extends('pdf.reports.layouts.pdf')
@section('style')
    <style>
        table thead tr th,
        table tbody tr td {
            padding: 5px;
        }

        table thead tr{
            background: #cccccc;
        }

        table thead tr th:not(:last-child) {
            border-right: 1px solid #fff;
        }
    </style>
@endsection
@section('content')
    <table>
        <thead>
            <tr>
                <th>Salesperson</th>
                <th>{{$year}}</th>
                @foreach($months as $month)
                <th>{{$month}}</th>
                @endforeach
                <th>Total</th>
                <th>Ratio</th>
            </tr>
        </thead>
        <tbody>
        @foreach($sales as $name => $user)
            @if($name == 'totals')
                @continue
            @endif
            <tr style="page-break-after:avoid">
                @php
                    $row = $user['leads'];
                @endphp
                <td scope="row">{{$name}}</td>
                <td># Leads</td>
                @foreach($months as $k => $month)
                    <td>{{(isset($row[$k]))?$row[$k]:0}}</td>
                @endforeach
                <td>{{array_sum($row)}}</td>
                <td></td>
            </tr>

            <tr style="page-break-after:avoid">
                @php
                    $row = $user['sales'];
                @endphp
                <td scope="row"></td>
                <td># Sales</td>
                @foreach($months as $k => $month)
                    <td>{{(isset($row[$k]))?$row[$k]:0}}</td>
                @endforeach
                <td>{{array_sum($row)}}</td>
                <td>{{((array_sum($user['leads'])!=0))?round(array_sum($user['sales'])/array_sum($user['leads'])*100,2).'%':'0%'}}</td>
            </tr>
            <tr style="page-break-after:avoid">
                @php
                    $row = $user['salesAmount'];
                @endphp
                <td scope="row"></td>
                <td>$ Sales</td>
                @foreach($months as $k => $month)
                    <td>{{(isset($row[$k]))?\AppHelper::formatPricePdf($row[$k]):0}}</td>
                @endforeach
                <td>{{\AppHelper::formatPricePdf(array_sum($row))}}</td>
                <td>{{((array_sum($user['sales'])!=0))?'$'.\AppHelper::formatPricePdf(array_sum($user['salesAmount'])/array_sum($user['sales'])):'$0'}}</td>
            </tr>
            <tr style="page-break-after:avoid">
                @php
                    $row = $user['digs'];
                @endphp
                <td scope="row"></td>
                <td># Digs</td>
                @foreach($months as $k => $month)
                    <td>{{(isset($row[$k]))?$row[$k]:0}}</td>
                @endforeach
                <td>{{array_sum($row)}}</td>
                <td>{{((array_sum($user['sales'])!=0))?round(array_sum($user['digs'])/array_sum($user['sales'])*100,2).'%':'0%'}}</td>
            </tr>
            <tr style="page-break-after:avoid">
                @php
                    $row = $user['digsPayment'];
                @endphp
                <td scope="row"></td>
                <td>$ Digs</td>
                @foreach($months as $k => $month)
                    <td>{{(isset($row[$k]))?\AppHelper::formatPricePdf($row[$k]):0}}</td>
                @endforeach
                <td>{{\AppHelper::formatPricePdf(array_sum($row))}}</td>
                <td>{{((array_sum($user['digs'])!=0))?'$'.\AppHelper::formatPricePdf(array_sum($user['digsPayment'])/array_sum($user['digs'])):'$0'}}</td>
            </tr>
            <tr>
                <td colspan="16"></td>
            </tr>
        @endforeach
        @php
            $k = 1;
        @endphp
        @foreach($sales['totals'] as $key => $row)
            <tr style="page-break-after:avoid">
                @if ($k ==1)
                    <td scope="row" data-row="{{$k++}}">Office totals</td>
                @else
                    <td scope="row" data-row="{{$k++}}"></td>
                @endif
                <td>{{$labels[$key]}}</td>
                    @if ($key == 'salesAmount' || $key == 'digsPayment')
                        @foreach($months as $k => $month)
                            <td>{{(isset($row[$k]))?\AppHelper::formatPricePdf($row[$k]):0}}</td>
                        @endforeach
                        <td>{{\AppHelper::formatPricePdf(array_sum($row))}}</td>
                    @else
                        @foreach($months as $k => $month)
                            <td>{{(isset($row[$k]))?$row[$k]:0}}</td>
                        @endforeach
                        <td>{{array_sum($row)}}</td>
                    @endif
                <td>
                    @if ($key == 'leads')
                        <span></span>
                    @endif
                    @if ($key == 'digs')
                        @php
                            $sale = array_sum($sales['totals']['digs']);
                            $lead = array_sum($sales['totals']['sales']);
                            $sum = 0;
                            if ($lead != 0){
                                $sum = $sale/$lead;
                            }
                            $percent = $sum*100;
                            $percent = round($percent,2);
                        @endphp
                        <span>{{$percent}}%</span>
                    @endif
                    @if ($key == 'salesAmount')
                        @php
                            $sale = array_sum($sales['totals']['salesAmount']);
                            $lead = array_sum($sales['totals']['sales']);
                            $sum = 0;
                            if ($lead != 0){
                                $sum = $sale/$lead;
                            }
                            $percent = $sum;
                            $percent = \AppHelper::formatPricePdf($percent);
                        @endphp
                        <span>${{$percent}}</span>
                    @endif
                    @if ($key == 'sales')
                        @php
                            $sale = array_sum($sales['totals']['sales']);
                            $lead = array_sum($sales['totals']['leads']);
                            $sum = 0;
                            if ($lead != 0){
                                $sum = $sale/$lead;
                            }
                            $percent = $sum*100;
                            $percent = round($percent,2);
                        @endphp
                        <span>{{$percent}}%</span>
                    @endif
                    @if ($key == 'digsPayment')
                        @php
                            $digsSumm = array_sum($sales['totals']['digs']);
                            if ($digsSumm == 0){
                                $digratio = 0;
                            } else {
                                $digratio = array_sum($sales['totals']['digsPayment'])/$digsSumm;
                                $digratio = \AppHelper::formatPricePdf($digratio);
                            }
                        @endphp
                        <span>${{$digratio}}</span>
                    @endif
                </td>
            </tr>
        @endforeach
        </tbody>
    </table>
@endsection