@php
if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code)
$currencyCode = Auth::user()->franchise->countries->currency_code;
else
$currencyCode = 'TZS';
@endphp

<table>
    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="10" style="font-weight:bold;">
            Date Range: {{ \Carbon\Carbon::parse($data['date_from'])->format('d-m-Y') }} to {{ \Carbon\Carbon::parse($data['date_to'])->format('d-m-Y') }}
        </td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>

    <tr>
        <td colspan="{{ !empty($data['regionalSales']['companies']) ? count($data['regionalSales']['companies'])+3 : 3}}" style="font-weight:bold; background:#8064A2; color:#ffffff; text-align:center;">
            Regional Sales Report
        </td>
    </tr>
    <tr>
        <th style="border: 1px solid black; font-weight:bold;">#</th>
        <th style="border: 1px solid black; font-weight:bold;">Region</th>
        @foreach($data['regionalSales']['companies'] as $company)
        <th style="border: 1px solid black; font-weight:bold;">{{ $company->name}}</th>
        @endforeach
        <th style="border: 1px solid black; font-weight:bold;">Total</th>
    </tr>
        @foreach($regionalSales as $key => $regional_data)
    <tr>
        <td style="border: 1px solid black;">{{ ($key + 1)}}</td>
        <td style="border: 1px solid black;">{{ $regional_data['region'] }}</td>
        @foreach($data['regionalSales']['companies'] as $r_company)
        <td style="border: 1px solid black;">
            {{ ($regional_data['cols'] && $regional_data['cols'][$r_company->id]) ? $regional_data['cols'][$r_company->id] : 0 }}
        </td>
        @endforeach
        <td style="border: 1px solid black;"><strong>{{ $regional_data['total'] }}</strong></td>
    </tr>
    @endforeach
    <tr>
        <td style="border: 1px solid black;"></td>
        <td style="border: 1px solid black;">Total</td>
        @foreach($data['regionalSales']['companies'] as $leadData)
        <td style="border: 1px solid black;">
            {{ $data['regionalSales']['regionTotals'] ? $data['regionalSales']['regionTotals'][$leadData->id] : 0 }}
        </td>
        @endforeach
        <td style="border: 1px solid black;">{{ $data['regionalSales']['regionTotals']['__grand__'] ?? 0 }}</td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>

    <tr>
        <td colspan="5" style="font-weight:bold; background:#8064A2; color:#ffffff; text-align:center;">
            Unit Sales Report
        </td>
    </tr>

    @foreach($data['unitSales']['unitSales'] as $unitSales)
    <tr>
        <th style="border: 1px solid black; font-weight:bold;">{{ $unitSales['company']['name'] }}</th>
        <th style="border: 1px solid black; font-weight:bold;">SOLD UNITS</th>
    </tr>
    @if($unitSales['rows'])
    @foreach($unitSales['rows'] as $rowsData)
    <tr>
        <td style="border: 1px solid black;">{{ $rowsData['product_name'] }}</td>
        <td style="border: 1px solid black;">{{ $rowsData['units'] }}</td>
    </tr>
    @endforeach
    <tr>
        <td style="border: 1px solid black;">TOTAL</td>
        <td style="border: 1px solid black;">{{ $unitSales['total'] }}</td>
    </tr>
    @else
    <tr>
        <td colspan="2" style="border: 1px solid black;">No data found</td>
    </tr>
    <tr>
        <td style="border: 1px solid black;">TOTAL</td>
        <td style="border: 1px solid black;">0</td>
    </tr>
    @endif
    <tr>
        <td colspan="10"></td>
    </tr>
    @endforeach


    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="5" style="font-weight:bold; background:#8064A2; color:#ffffff; text-align:center;">
            Revenue Report
        </td>
    </tr>
    <tr>
        <th style="border: 1px solid black; font-weight:bold;">#</th>
        <th style="border: 1px solid black; font-weight:bold;">TOTAL SALES</th>
        <th style="border: 1px solid black; font-weight:bold;">AMOUNTS</th>
        <th style="border: 1px solid black; font-weight:bold;">EXPECTED COMMISION</th>
        <th style="border: 1px solid black; font-weight:bold;">INCENTIVE AMOUNTS</th>
    </tr>
    @foreach($data['revenue']['rows'] as $key => $revenue)
    <tr>
        <td style="border: 1px solid black;">{{ $key+1 }}</td>
        <td style="border: 1px solid black;">{{ $revenue['company'] }}</td>
        <td style="border: 1px solid black;">TZS {{ $revenue['amounts']}}</td>
        <td style="border: 1px solid black;">TZS {{ $revenue['expected_commission']}}</td>
        <td style="border: 1px solid black;">TZS {{ $revenue['incentive']}}</td>
    </tr>
    @endforeach
    <tr>
        <td style="border: 1px solid black;"></td>
        <td style="border: 1px solid black;">Total</td>
        <td style="border: 1px solid black;">TZS {{ $data['revenue']['totals']['amounts'] }}</td>
        <td style="border: 1px solid black;">TZS {{ $data['revenue']['totals']['expected_commission'] }}</td>
        <td style="border: 1px solid black;">TZS {{ $data['revenue']['totals']['incentive'] }}</td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>

    <tr>
        <td colspan="{{ !empty($data['activeAgent']['companies']) ? count($data['activeAgent']['companies'])+3 : 3}}" style="font-weight:bold; background:#8064A2; color:#ffffff; text-align:center;">
            Growth Agents Report
        </td>
    </tr>
    <tr>
        <th style="border: 1px solid black; font-weight:bold;">#</th>
        <th style="border: 1px solid black; font-weight:bold;">AGENTS</th>
        @foreach($data['activeAgent']['companies'] as $company)
        <th style="border: 1px solid black; font-weight:bold;">{{ $company->name}}</th>
        @endforeach
        <th style="border: 1px solid black; font-weight:bold;">Total</th>
    </tr>
    @foreach($data['activeAgent']['leadRows'] as $key => $agentData)
    <tr>
        <td style="border: 1px solid black;">{{ $key + 1}}</td>
        <td style="border: 1px solid black;">{{ $agentData['agent']}}</td>
        @foreach($data['activeAgent']['companies'] as $r_company)
        <td style="border: 1px solid black;">
            {{ ($agentData['cols'] && $agentData['cols'][$r_company->id]) ? $agentData['cols'][$r_company->id]['sold'] : 0 }}
        </td>
        @endforeach
        <td style="border: 1px solid black;">{{ $agentData['total']['sold'] }}</td>
    </tr>
    @endforeach
    <tr>
        <td style="border: 1px solid black;"></td>
        <td style="border: 1px solid black;">Total</td>
        @foreach($data['activeAgent']['companies'] as $r_company)
        <td style="border: 1px solid black;">{{ $data['activeAgent']['leadTotals'][$r_company->id]['sold']}}</td>
        @endforeach
        <td style="border: 1px solid black;">{{ $data['activeAgent']['leadTotals']['__grand__']['sold']}}</td>
    </tr>

    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="10"></td>
    </tr>
    <tr>
        <td colspan="{{ !empty($data['leadData']['companies']) ? count($data['leadData']['companies'])+4 : 4}}" style="font-weight:bold; background:#8064A2; color:#ffffff; text-align:center;">
            Lead Generated
        </td>
    </tr>

    <tr>
        <th style="border: 1px solid black; font-weight:bold;">#</th>
        <th style="border: 1px solid black; font-weight:bold;">AGENTS</th>
        @foreach($data['leadData']['companies'] as $company)
        <th style="border: 1px solid black; font-weight:bold;">{{ $company->name}}</th>
        @endforeach
        <th style="border: 1px solid black; font-weight:bold;">Generic</th>
        <th style="border: 1px solid black; font-weight:bold;">Total</th>
    </tr>
    @foreach($data['leadData']['leadRows'] as $key => $leadData)
    <tr>
        <td style="border: 1px solid black;">{{ $key + 1}}</td>
        <td style="border: 1px solid black;">{{ $leadData['agent']}}</td>
        @foreach($data['leadData']['companies'] as $r_company)
        <td style="border: 1px solid black;">
            {{ ($leadData['cols'] && $leadData['cols'][$r_company->id]) ? $leadData['cols'][$r_company->id] : 0 }}
        </td>
        @endforeach
        <td style="border: 1px solid black;">{{ $leadData['generic'] }}</td>
        <td style="border: 1px solid black;">{{ $leadData['total'] }}</td>
    </tr>
    @endforeach
    <tr>
        <td style="border: 1px solid black;"></td>
        <td style="border: 1px solid black;">Total</td>
        @foreach($data['leadData']['companies'] as $r_company)
        <td style="border: 1px solid black;">{{ $data['leadData']['leadTotals'][$r_company->id]}}</td>
        @endforeach
        <td style="border: 1px solid black;">{{ $data['leadData']['leadTotals']['__generic__']}}</td>
        <td style="border: 1px solid black;">{{ $data['leadData']['leadTotals']['__grand__']}}</td>
    </tr>
</table>