@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>
    <!-- start:: table head -->
        <thead>
            <tr>
                <!-- <th><b>Month</b></th>
                <th>{{ date('M-Y', strtotime($dates[0])) }} to {{ date('M-Y', strtotime($dates[1])) }}</th> -->

                <th><b>Start Date</b></th>
                <th>{{ $dates[0] }}</th>
                <th></th>
                <th><b>End Date</b></th>
                <th>{{ $dates[1] }}</th>

                @php $i = 0; @endphp
                @while ($i < 10)
                    <th></th>
                    @php $i++; @endphp
                @endwhile
                @foreach($departmentList as $department)
                    <th colspan="@if($department->subdepts->count() == 0) 3 @else {{ $department->subdepts->count() * 3 }} @endif"
                        style="border: 1px solid black; text-align:center; width: 18px; height: 20px; border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                        {{ $department->name }}
                    </th>
                @endforeach
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;" colspan="3">Total</th>
            </tr>
            <tr>
                @php $i = 0; @endphp
                @while ($i < 15)
                    <td></td>
                    @php $i++; @endphp
                @endwhile
                @foreach($departmentList as $department)
                    @if($department->subdepts->count() != 0)
                        @foreach($department->subdepts as $sub_dept)
                            <th style="border: 1px solid black; text-align: center; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif" colspan="3">{{ $sub_dept->name }}</th>
                        @endforeach
                    @else
                        <th style="border: 1px solid black; text-align: center; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif" colspan="3">-</th>
                    @endif
                @endforeach
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;">{{ $currencyCode }}</th>
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;">USD</th>
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;"></th>
                <th style="border: 1px solid black; text-align: center;">Staff Allocation</th>
            </tr>
            <tr>
                <th style="border: 1px solid black; text-align: center;">Inv Date</th>
                <th style="border: 1px solid black; text-align: center;">Payment Received Date</th>
                <th style="border: 1px solid black; text-align: center;">Payment Terms</th>
                <th style="border: 1px solid black; text-align: center;">Days to Payment</th>
                <th style="border: 1px solid black; text-align: center;">Inv No</th>
                <th style="border: 1px solid black; text-align: center;">Company</th>
                <th style="border: 1px solid black; text-align: center;">Project Title</th>
                <th style="border: 1px solid black; text-align: center;">Project Owner</th>
                <th style="border: 1px solid black; text-align: center;">Category</th>
                <th style="border: 1px solid black; text-align: center;">Industry</th>
                <th style="border: 1px solid black; text-align: center;">Short Description</th>
                @foreach($taxList as $tax)
                    <th style="border: 1px solid black; text-align: center;">{{ ($tax->tax_title == 'Withholding Tax') ? 'WHT' : $tax->tax_title }} (%)</th>
                    @if(($tax->tax_title == 'Withholding Tax'))
                    <th style="border: 1px solid black; text-align: center;">WHT Status</th>
                    @endif
                @endforeach
                <th style="border: 1px solid black; text-align: center;">Xrate</th>
                @foreach($departmentList as $department)
                    @if($department->subdepts->count() != 0)
                        @foreach($department->subdepts as $sub_dept)
                            <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif">{{ $sub_dept->name }} {{ $currencyCode }}</th>
                            <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif">{{ $sub_dept->name }} USD</th>
                            <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif">{{ $sub_dept->name }} TOTAL {{ $currencyCode }}</th>
                        @endforeach
                    @else
                        <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">{{ $department->name }} {{ $currencyCode }}</th>
                        <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">{{ $department->name }} USD</th>
                        <th style="border: 1px solid black; text-align: center; width:20px; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">{{ $department->name }} TOTAL {{ $currencyCode }}</th>
                    @endif
                @endforeach
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;">EMPOWER TZS</th>
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;">EMPOWER USD</th>
                <th style="border: 1px solid black; background-color: #b3b7bb; text-align: center;">EMPOWER TOTAL TZS</th>
                @foreach ($userList as $user)
                    <th style="border: 1px solid black; text-align: center;">{{ $user->full_name }}</th>
                @endforeach
                <th style="border: 1px solid black; text-align: center;">Total</th>
            </tr>
        </thead>
    <!-- end:: table head -->
    <!-- start:: table body -->
        <tbody>
            <!-- start department wise rows -->
                @php $bgclr = ''; @endphp 
                @foreach($invoiceList as $invoice)
                    @php
                        $deptTZS  = 0;
                        $deptUSD  = 0;
                        $deptTotal  = 0;
                        $totalInvoiceSplitAmount = 0;

                        $totalAmount = $invoice->total_amount;

                        $convertedTotalAmount = $invoice->currency == 'USD' ? $invoice->total_amount_converted : $invoice->total_amount;
                        $convertedSubTotalAmount = $invoice->currency == 'USD' ? $invoice->sub_total_amount_converted : $invoice->sub_total_amount;
                    @endphp

                                @if($invoice->taxes->where('tax_title', $taxList[0]->tax_title)->pluck('tax_value')->first())
                                    @if($invoice->certificate)
                                        @php $bgclr = '#c3e6cb'; @endphp 
                                    @else 
                                        @php $bgclr = '#ffeeba'; @endphp
                                    @endif
                                @else 
                                    @php $bgclr = '#c3e6cb'; @endphp
                                @endif
                    <tr>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->tax_invoice_date_formatted_full }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->date_collected_formatted ?? '-' }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->payment_days_term }}</td>
                        <td style="border: 1px solid black; text-align: left; background-color:{{ $bgclr}}">
                            @if($invoice->status == 'paid')
                                {{ Carbon\Carbon::parse($invoice->tax_invoice_date)->diffInDays($invoice->date_collected) }}
                            @else
                                -
                            @endif
                        </td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->ti_serial_number }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->company->name }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->project->name ?? '-' }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">
                            {{ ($invoice->project && $invoice->project->projectOwner && $invoice->project->projectOwner->first() && $invoice->project->projectOwner->first()->full_name) ?
                            $invoice->project->projectOwner->first()->full_name : '-' }}
                        </td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}"></td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->company->industries_formatted ?? '-' }}</td>
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">{{ $invoice->description }}</td>
                        @foreach($taxList as $tax)
                            <td style="border: 1px solid black; background-color:{{ $bgclr}}">
                                {{ $invoice->taxes->where('tax_title', $tax->tax_title)->pluck('tax_value')->first() ?? '-' }}
                            </td>
                            @if(($tax->tax_title == 'Withholding Tax'))
                            <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">
                                @if($invoice->taxes->where('tax_title', $tax->tax_title)->pluck('tax_value')->first())
                                    @if($invoice->certificate)
                                        {{ 'Paid' }}
                                    @else 
                                        {{ 'Not Paid' }}
                                    @endif
                                @else 
                                    {{ '-' }}
                                @endif
                            </td>
                            @endif
                        @endforeach
                        <td style="border: 1px solid black; text-align: center; background-color:{{ $bgclr}}">
                            @if($invoice->currency == 'USD')
                                {{ $invoice->conversion_rate ?? '-' }}
                            @else
                                -
                            @endif
                        </td>
                        <!-- department tds -->
                        @foreach($departmentList as $department)
                            @php $printEmptyTd = true; @endphp

                            @if($department->subdepts->count() != 0) <!-- order having records in sub_split  -->
                                @foreach($department->subdepts as $sub_dept) <!-- run subdepartment loop for match with sub splits ids -->
                                    @if($invoice->subsplits()->where('sub_department_id', $sub_dept->id)->count() != 0) <!-- make grouping in sub dept id of sub splits  -->
                                        @php $groupBySplits = $invoice->subSplits->groupBy('sub_department_id'); @endphp

                                        @foreach($groupBySplits as $key => $split)
                                            @if($key == $sub_dept->id)
                                                @php
                                                    $printEmptyTd = false;
                                                    $splitAmount = $invoice->subSplits->where('sub_department_id', $key)->sum('amount');

                                                    if($invoice->currency == 'USD') {
                                                        $deptUSD += $splitAmount;
                                                        $deptTotal  += $splitAmount * $invoice->conversion_rate;
                                                    }else {
                                                        $deptTZS += $splitAmount;
                                                        $deptTotal += $splitAmount;
                                                    }
                                                @endphp

                                                @if($invoice->currency == $franchiseCurrency)
                                                    <td class="text-right allamt" style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif">
                                                        {{ round($splitAmount,2) }}
                                                    </td>
                                                    <td style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif"></td>
                                                    <td style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif">
                                                        {{ round($splitAmount,2) }}
                                                    </td>
                                                @elseif($invoice->currency == 'USD')
                                                    <td style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif"></td>
                                                    <td style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif" class="text-right allamt">
                                                        {{ round($splitAmount,2) }}
                                                    </td>
                                                    <td style="border: 1px solid black; background-color:@if($loop->parent->parent->odd) #CCB2FF @elseif($loop->parent->parent->even) #FFE6AB @endif">
                                                        {{ round($splitAmount * $invoice->conversion_rate,2) }}
                                                    </td>
                                                @endif
                                            @endif
                                        @endforeach
                                    @else
                                        @php $printEmptyTd = false; @endphp
                                        <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                        <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                        <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                    @endif
                                @endforeach
                                @if($printEmptyTd) <!-- order having sub splits but cant have record -->
                                    <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                    <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                    <td style="border: 1px solid black; background-color:@if($loop->parent->odd) #CCB2FF @elseif($loop->parent->even) #FFE6AB @endif"></td>
                                @endif
                            @elseif($invoice->splits()->whereType('dept')->whereDepartmentId($department->id)->count() != 0) <!-- order having records not in sub_split but in split -->
                                @php
                                    $deptsplitAmount = $invoice->splits->where('department_id', $department->id)->sum('amount');

                                    if($invoice->currency == 'USD'){
                                        $deptUSD += $deptsplitAmount;
                                        $deptTotal  += $deptsplitAmount * $invoice->conversion_rate;
                                    } else {
                                        $deptTZS += $deptsplitAmount;
                                        $deptTotal  += $deptsplitAmount;
                                    }
                                @endphp
                                @if($invoice->currency == $franchiseCurrency)
                                    <td class="text-right allamt" style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                                        {{ round($deptsplitAmount,2) }}
                                    </td>
                                    <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif"></td>
                                    <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                                        {{ round($deptsplitAmount,2) }}
                                    </td>
                                @elseif($invoice->currency == 'USD')
                                    <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                                    <td class="text-right allamt" style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                                        {{ round($deptsplitAmount,2) }}
                                    </td>
                                    <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">
                                        {{ round($deptsplitAmount * $invoice->conversion_rate,2) }}
                                    </td>
                                @endif
                            @else <!-- print blank td when order not have value for dept  -->
                                <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif"></td>
                                <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif"></td>
                                <td style="border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif"></td>
                            @endif
                        @endforeach
                        @if($invoice->currency != 'USD')
                            <td style="border: 1px solid black; background-color: #b3b7bb;">{{ round($deptTZS, 2) }}</td>
                            <td style="border: 1px solid black; background-color: #b3b7bb;"></td>
                        @else
                        <td style="border: 1px solid black; background-color: #b3b7bb;"></td>
                        <td style="border: 1px solid black; background-color: #b3b7bb;">{{ round($deptUSD, 2) }}</td>
                        @endif
                        <td style="border: 1px solid black; background-color: #b3b7bb;">{{ round($deptTotal, 2) }}</td>
                        @foreach ($userList as $user)
                            @php
                                $memberSplitAmount = $invoice->splits->where('user_id', $user->id)->sum('amount');
                                if($invoice->currency == 'USD')
                                    $memberSplitAmount = $memberSplitAmount * $invoice->conversion_rate;

                                $totalInvoiceSplitAmount += $memberSplitAmount;
                            @endphp
                            <td style="border: 1px solid black; background-color: {{ $bgclr}}">{{ ($memberSplitAmount != 0) ? round($memberSplitAmount, 2) : '' }}</td>
                        @endforeach
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}">{{ round($totalInvoiceSplitAmount, 2) }}</td>
                    </tr>
                @endforeach
            <!-- end department wise rows -->
        </tbody>
    <!-- end:: table body -->
</table>