@php
    $monthName = (isset($isInvoice)) ? 'tax_date_month_name' : (isset($is_payment_voucher) ? 'pv_date_month_name' :'date_month_name');
    $monthNo = (isset($isInvoice)) ? 'tax_date_month_no' : (isset($is_payment_voucher) ? 'pv_date_month_no' : 'date_month_no');
    $year =   (isset($isInvoice)) ? 'tax_date_year' : (isset($is_payment_voucher) ? 'pv_date_year' : 'date_year'); 
@endphp

<!-- monthly total row -->
<tr class="table-secondary">

    <!-- static tds -->
    <td colspan="3"><strong>{{ $order->$monthName }} {{ $order->$year }} Total</strong></td>

    <!-- description td -->
    <td></td>

    <!-- department tds -->
    @foreach($departments as $department)
        @php $printEmptyTd = true @endphp
        @if(isset($splitData[$order->$year][$order->$monthNo]))
            @foreach($splitData[$order->$year][$order->$monthNo] as $key => $val)
                @if($department->id == $key)
                    @foreach($splitData[$order->$year][$order->$monthNo][$key] as $key1 => $val1)
                        @if($key1 != 'dept') <!-- check records have sub splits -->
                            @foreach($department->subdepts as $sub_dept)
                                @if($sub_dept->id == $key1)
                                    @if($val1 != null) <!-- check sub department value not null -->
                                        @php $printEmptyTd = false @endphp
                                        @if(isset($val1[$franchiseCurrency]) && isset($val1['USD']))
                                            <td class="text-right allamt">
                                                <p>ST: {{ number_format($val1[$franchiseCurrency]['totalAmount'], 2) }}</p>
                                                @isset($val1[$franchiseCurrency]['taxAmount'])
                                                    @foreach($val1[$franchiseCurrency]['taxAmount'] as $key => $tax)
                                                        @if($tax != 0)
                                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                                        @endif
                                                    @endforeach
                                                @endisset
                                                <p><strong>GT: {{ number_format($val1[$franchiseCurrency]['subTotalAmount'], 2) }}</strong></p>
                                            </td>
                                            <td class="text-right allamt">
                                                <p>ST: {{ number_format($val1['USD']['totalAmount'], 2) }}</p>
                                                @isset($val1['USD']['taxAmount'])
                                                    @foreach($val1['USD']['taxAmount'] as $key => $tax)
                                                        @if($tax != 0)
                                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                                        @endif
                                                    @endforeach
                                                @endisset
                                                <p><strong>GT: {{ number_format($val1['USD']['subTotalAmount'], 2) }}</strong></p>
                                            </td>
                                        @elseif(isset($val1[$franchiseCurrency]) && !isset($val1['USD']))
                                            <td class="text-right allamt">
                                                <p>ST: {{ number_format($val1[$franchiseCurrency]['totalAmount'], 2) }}</p>
                                                @isset($val1[$franchiseCurrency]['taxAmount'])
                                                    @foreach($val1[$franchiseCurrency]['taxAmount'] as $key => $tax)
                                                        @if($tax != 0)
                                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                                        @endif
                                                    @endforeach
                                                @endisset
                                                <p><strong>GT: {{ number_format($val1[$franchiseCurrency]['subTotalAmount'], 2) }}</strong></p>
                                            </td>
                                            <td class="text-right allamt">
                                            </td>
                                        @elseif(!isset($val1[$franchiseCurrency]) && isset($val1['USD']))
                                            <td class="text-right allamt">
                                            </td>
                                            <td class="text-right allamt">
                                                <p>ST: {{ number_format($val1['USD']['totalAmount'], 2) }}</p>
                                                @isset($val1['USD']['taxAmount'])
                                                    @foreach($val1['USD']['taxAmount'] as $key => $tax)
                                                        @if($tax != 0)
                                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                                        @endif
                                                    @endforeach
                                                @endisset
                                                <p><strong>GT: {{ number_format($val1['USD']['subTotalAmount'], 2) }}</strong></p>
                                            </td>
                                        @endif
                                    @else <!-- print blank td for dept having subdept but cant have a record  -->
                                        @php $printEmptyTd = false @endphp
                                        <td></td>
                                        <td></td>
                                    @endif
                                @endif
                            @endforeach
                        @elseif($key1 == 'dept') <!-- check dept not having sub dept but have a value -->
                            @php $printEmptyTd = false @endphp
                            @if(isset($val1[$franchiseCurrency]) && isset($val1['USD']))
                                <td class="text-right allamt">
                                    <p>ST: {{ number_format($val1[$franchiseCurrency]['totalAmount'], 2) }}</p>
                                    @isset($val1[$franchiseCurrency]['taxAmount'])
                                        @foreach($val1[$franchiseCurrency]['taxAmount'] as $key => $tax)
                                            @if($tax != 0)
                                                <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                            @endif
                                        @endforeach
                                    @endisset
                                    <p><strong>GT: {{ number_format($val1[$franchiseCurrency]['subTotalAmount'], 2) }}</strong></p>
                                </td>
                                <td class="text-right allamt">
                                    <p>ST: {{ number_format($val1['USD']['totalAmount'], 2) }}</p>
                                    @isset($val1['USD']['taxAmount'])
                                        @foreach($val1['USD']['taxAmount'] as $key => $tax)
                                            @if($tax != 0)
                                                <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                            @endif
                                        @endforeach
                                    @endif
                                    <p><strong>GT: {{ number_format($val1['USD']['subTotalAmount'], 2) }}</strong></p>
                                </td>
                            @elseif(isset($val1[$franchiseCurrency]) && !isset($val1['USD']))
                                <td class="text-right allamt">
                                    <p>ST: {{ number_format($val1[$franchiseCurrency]['totalAmount'], 2) }}</p>
                                    @isset($val1[$franchiseCurrency]['taxAmount'])
                                        @foreach($val1[$franchiseCurrency]['taxAmount'] as $key => $tax)
                                            @if($tax != 0)
                                                <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                            @endif
                                        @endforeach
                                    @endisset
                                    <p><strong>GT: {{ number_format($val1[$franchiseCurrency]['subTotalAmount'], 2) }}</strong></p>
                                </td>
                                <td class="text-right allamt">
                                </td>
                            @elseif(!isset($val1[$franchiseCurrency]) && isset($val1['USD']))
                                <td class="text-right allamt">
                                </td>
                                <td class="text-right allamt">
                                    <p>ST: {{ number_format($val1['USD']['totalAmount'], 2) }}</p>
                                    @isset($val1['USD']['taxAmount'])
                                        @foreach($val1['USD']['taxAmount'] as $key => $tax)
                                            @if($tax != 0)
                                                <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                            @endif
                                        @endforeach
                                    @endisset
                                    <p><strong>GT: {{ number_format($val1['USD']['subTotalAmount'], 2) }}</strong></p>
                                </td>
                            @endif
                        @endif
                    @endforeach
                @endif
            @endforeach
        @endif
        @if($printEmptyTd)
            @if($department->subdepts->count() != 0) <!-- print blank td sub dept wise -->
                @foreach($department->subdepts as $sub_dept)
                    <td></td>
                    <td></td>
                @endforeach
            @else <!-- print blank td -->
                <td></td>
                <td></td>
            @endif
        @endif
    @endforeach

    <!-- total Amount tzs -->
    @if(isset($monthlyData[$order->$year][$order->$monthNo][$franchiseCurrency]))
    <td class="text-right allamt">
        <p>ST: {{ number_format($monthlyData[$order->$year][$order->$monthNo][$franchiseCurrency]['totalAmount'], 2) }}</p>
        @isset($monthlyData[$order->$year][$order->$monthNo][$franchiseCurrency]['taxAmount'])
            @foreach($monthlyData[$order->$year][$order->$monthNo][$franchiseCurrency]['taxAmount'] as $key => $tax)
                @if($tax != 0)
                    <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax, 2) }}</p>
                @endif
            @endforeach
        @endisset
        <p><strong>GT: {{ number_format($monthlyData[$order->$year][$order->$monthNo][$franchiseCurrency]['subTotalAmount'], 2) }}</strong></p>
    </td>
    @else
    <td></td>
    @endif

    <!-- total Amount usd -->
    @if(isset($monthlyData[$order->$year][$order->$monthNo]['USD']))
    <td class="text-right allamt">
        <p>ST: {{ number_format($monthlyData[$order->$year][$order->$monthNo]['USD']['totalAmount'], 2) }}</p>
        @isset($monthlyData[$order->$year][$order->$monthNo]['USD']['taxAmount'])
            @foreach($monthlyData[$order->$year][$order->$monthNo]['USD']['taxAmount'] as $key => $tax)
                @if($tax != 0)
                    <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax, 2) }}</p>
                @endif
            @endforeach
        @endisset
        <p><strong>GT: {{ number_format($monthlyData[$order->$year][$order->$monthNo]['USD']['subTotalAmount'], 2) }}</strong></p>
    </td>
    @else
    <td></td>
    @endif

    <!-- total Amount -->
    <td class="text-right allamt"></td>

    <!-- created by td -->
    <td></td>

    @if(!isset($isInvoice))
        <!-- status td -->
        <td></td>
    @endif

    <!-- action td -->
    <td></td>
</tr>

<!-- monthly total row (all currency) -->
<tr class="table-secondary">

    <!-- static tds -->
    <td colspan="3" rowspan="2"><strong>{{ $order->$monthName }} {{ $order->$year }} Total in {{ $franchiseCurrency }} (USD + {{ $franchiseCurrency }})</strong></td>

    <!-- description td -->
    <td></td>

    <!-- department tds -->
    @foreach($departments as $department)
        @php $printEmptyTd = true @endphp
        @if(isset($splitData[$order->$year][$order->$monthNo]))
            @foreach($splitData[$order->$year][$order->$monthNo] as $key => $val)
                @if($department->id == $key)
                    @foreach($splitData[$order->$year][$order->$monthNo][$key] as $key1 => $val1)
                        @if($key1 != 'dept') <!-- check records have sub splits -->
                            @foreach($department->subdepts as $sub_dept)
                                @if($sub_dept->id == $key1)
                                    @if($val1 != null) <!-- check sub department value not null -->
                                        @php $printEmptyTd = false @endphp
                                        <td class="text-right allamt" colspan="2">
                                            <p>ST: {{ number_format($val1['allCurrency']['totalAmount'], 2) }}</p>
                                            @isset($val1['allCurrency']['taxAmount'])
                                                @foreach($val1['allCurrency']['taxAmount'] as $key => $tax)
                                                    @if($tax != 0)
                                                        <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax, 2) }}</p>
                                                    @endif
                                                @endforeach
                                            @endisset
                                            <p><strong>GT: {{ number_format($val1['allCurrency']['subTotalAmount'], 2) }}</strong></p>
                                        </td>
                                    @else <!-- print blank td for dept having subdept but cant have a record  -->
                                        @php $printEmptyTd = false @endphp
                                        <td colspan="2"></td>
                                    @endif
                                @endif
                            @endforeach
                        @elseif($key1 == 'dept') <!-- check dept not having sub dept but have a value -->
                            @php $printEmptyTd = false @endphp
                            <td class="text-right allamt" colspan="2">
                                <p>ST: {{ number_format($val1['allCurrency']['totalAmount'], 2) }}</p>
                                @isset($val1['allCurrency']['taxAmount'])
                                    @foreach($val1['allCurrency']['taxAmount'] as $key => $tax)
                                        @if($tax != 0)
                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax, 2) }}</p>
                                        @endif
                                    @endforeach
                                @endisset
                                <p><strong>GT: {{ number_format($val1['allCurrency']['subTotalAmount'], 2) }}</strong></p>
                            </td>
                        @endif
                    @endforeach
                @endif
            @endforeach
        @endif
        @if($printEmptyTd)
            @if($department->subdepts->count() != 0) <!-- print blank td sub dept wise -->
                @foreach($department->subdepts as $sub_dept)
                    <td colspan="2"></td>
                @endforeach
            @else <!-- print blank td -->
                <td colspan="2"></td>
            @endif
        @endif
    @endforeach

    <!-- total Amount tzs -->
    <td class="text-right allamt"></td>

    <!-- total Amount usd -->
    <td class="text-right allamt"></td>

    <!-- total Amount -->
    <td class="text-right allamt"></td>

    <td><!-- created by td --></td>

    @if(!isset($isInvoice))
        <!-- status td -->
        <td></td>
    @endif

    <td><!-- action td --></td>

</tr>

<!-- monthly total row (department wise) -->
<tr class="table-secondary">

    <!-- description td -->
    <td></td>

    <!-- department tds -->
    @foreach($departments as $department)
        @php $printEmptyTd = true @endphp
            @if(isset($deptSplitData[$order->$year][$order->$monthNo]))
                @foreach($deptSplitData[$order->$year][$order->$monthNo]['allSubDept'] as $key => $val)
                        @if($department->id == $key)
                            @php $printEmptyTd = false @endphp
                            <td class="text-right allamt" colspan="{{ ($department->subdepts->count() != 0) ? $department->subdepts->count() * 2 : 2 }}">
                                <p>ST: {{ number_format($val['totalAmount'],2) }}</p>
                                @isset($val['taxAmount'])
                                    @foreach($val['taxAmount'] as $key => $tax)
                                        @if($tax != 0)
                                            <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                                        @endif
                                    @endforeach
                                @endisset
                                <p><strong>GT: {{ number_format($val['subTotalAmount'],2) }}</strong></p>
                            </td>
                        @endif
                @endforeach
            @endif
        @if($printEmptyTd)
            @if($department->subdepts->count() != 0) <!-- print blank td sub dept wise -->
                <td colspan="{{ ($department->subdepts->count() != 0) ? $department->subdepts->count() * 2 : 2 }}"></td>
            @else <!-- print blank td -->
                <td colspan="2"></td>
            @endif
        @endif
    @endforeach

    <!-- total Amount tzs -->
    <td class="text-right allamt"></td>

    <!-- total Amount usd -->
    <td class="text-right allamt"></td>

    <!-- total Amount -->
    <td class="text-right allamt">
        <p>ST: {{ number_format($monthlyData[$order->$year][$order->$monthNo]['allCurrency']['totalAmount'],2) }}</p>
        @isset($monthlyData[$order->$year][$order->$monthNo]['allCurrency']['taxAmount'])
            @foreach($monthlyData[$order->$year][$order->$monthNo]['allCurrency']['taxAmount'] as $key => $tax)
                @if($tax != 0)
                    <p class="font-italic tax-font-sm">{{ $key }}: {{ number_format($tax,2) }}</p>
                @endif
            @endforeach
        @endisset
        <p><strong>GT: {{ number_format($monthlyData[$order->$year][$order->$monthNo]['allCurrency']['subTotalAmount'],2) }}</strong></p>
    </td>

    <td><!-- created by td --></td>

    @if(!isset($isInvoice))
        <!-- status td -->
        <td></td>
    @endif

    <td><!-- action td --></td>

</tr>