@include('partials.reportHead.index')

<table class="table table-bordered table-condensed table-striped table-bordered text-primary">
    <thead>
        <tr>
            <th style="text-align:center; width: 5%; font-size: 10px;" rowspan="3">Designation</th>
            <th style="text-align:center; width: 5%; font-size: 10px;" colspan="3" rowspan="2">Opening Employee</th>
            <th style="text-align:center; font-size: 10px;" colspan="12">Addition</th>
            <th style="text-align:center; font-size: 10px;" colspan="12">Less</th>
            <th style="text-align:center; width: 5%; font-size: 10px;" colspan="3" rowspan="2">Closing</th>
        </tr>

        <tr>
            <th style="text-align:center; width: 2px; font-size: 10px;" rowspan="1" colspan="3">Joining</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Promotion</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Demotion</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Transfer</th>

            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Promotion</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Demotion</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Transfer</th>
            <th style="text-align:center; font-size: 10px;" rowspan="1" colspan="3">Resign</th>
        </tr>

        <tr>
            @for($i = 1; $i <= 10; $i++)
                <th style="text-align:center; width: 1.8%; font-size: 10px;">Male</th>
                <th style="text-align:center; width: 2.1%; font-size: 10px;">FeMale</th>
                <th style="text-align:center; width: 1.5%; font-size: 10px;">Total</th>
            @endfor
        </tr>
    </thead>

    <tbody>
        
        <!-- Head Office Data -->
        @if(count($data['headOfficeRecord']['positionsArray']) > 0)

            @if(count($data['headOfficeRecord']['positionsArray']) > 0 && count($data['branchOfficeRecord']['positionsArray']) > 0)
                <tr>
                    <td style="text-align:left; background: #F4F0E0;" colspan="31"><b>Head Office</b></td>
                </tr>
            @endif

            @php
                    
                $total_opening_Male_emp = $total_opening_Female_emp = $total_opening_emp = 0;
                $total_joining_Male_emp = $total_joining_Female_emp = $total_joining_emp = 0;
                $total_promotion_add_Male_emp = $total_promotion_add_Female_emp = $total_promotion_add_emp = 0;
                $total_promotion_less_Male_emp = $total_promotion_less_Female_emp = $total_promotion_less_emp = 0;
                $total_demotion_add_Male_emp = $total_demotion_add_Female_emp = $total_demotion_add_emp = 0;
                $total_demotion_less_Male_emp = $total_demotion_less_Female_emp = $total_demotion_less_emp = 0;
                $total_transfer_add_Male_emp = $total_transfer_add_Female_emp = $total_transfer_add_emp = 0;
                $total_transfer_less_Male_emp = $total_transfer_less_Female_emp = $total_transfer_less_emp = 0;
                $total_resign_Male_emp = $total_resign_Female_emp = $total_resign_emp = 0;
                $total_closing_Male_emp = $total_closing_Female_emp = $total_closing_emp = 0;

                $total_opening_acting_Male = $total_opening_acting_Female = $total_opening_acting = 0;
                $total_promotion_add_acting_Male = $total_promotion_add_acting_Female = $total_promotion_add_acting = 0;
                $total_promotion_less_acting_Male = $total_promotion_less_acting_Female = $total_promotion_less_acting = 0;
                $total_closing_acting_Male = $total_closing_acting_Female = $total_closing_acting = 0;

                $dataType = 'headOfficeRecord';
                $officeType = 'hq';

            @endphp

            @foreach($data['headOfficeRecord']['positionsArray'] as $position)

                @php

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['Male']))
                        $tempVal1 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['Male'];
                    else $tempVal1 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['Female']))
                        $tempVal2 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['Female'];
                    else $tempVal2 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['total']))
                        $tempVal3 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['total'];
                    else $tempVal3 = 0;

                    $total_opening_Male_emp = $total_opening_Male_emp + $tempVal1;
                    $total_opening_Female_emp = $total_opening_Female_emp + $tempVal2;
                    $total_opening_emp = $total_opening_emp + $tempVal3;
                                            
                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['Male']))
                        $tempVal4 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['Male'];
                    else $tempVal4 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['Female']))
                        $tempVal5 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['Female'];
                    else $tempVal5 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['total']))
                        $tempVal6 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['total'];
                    else $tempVal6 = 0;

                    $total_joining_Male_emp = $total_joining_Male_emp + $tempVal4;
                    $total_joining_Female_emp = $total_joining_Female_emp + $tempVal5;
                    $total_joining_emp = $total_joining_emp + $tempVal6;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Male']))
                        $tempVal7 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Male'];
                    else $tempVal7 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Female']))
                        $tempVal8 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Female'];
                    else $tempVal8 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['total']))
                        $tempVal9 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['total'];
                    else $tempVal9 = 0;

                    $total_promotion_add_Male_emp = $total_promotion_add_Male_emp + $tempVal7;
                    $total_promotion_add_Female_emp = $total_promotion_add_Female_emp + $tempVal8;
                    $total_promotion_add_emp = $total_promotion_add_emp + $tempVal9;
                    
                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Male']))
                        $tempVal10 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Male'];
                    else $tempVal10 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Female']))
                        $tempVal11 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Female'];
                    else $tempVal11 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['total']))
                        $tempVal12 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['total'];
                    else $tempVal12 = 0;
                    
                    $total_demotion_add_Male_emp = $total_demotion_add_Male_emp + $tempVal10;
                    $total_demotion_add_Female_emp = $total_demotion_add_Female_emp + $tempVal11;
                    $total_demotion_add_emp = $total_demotion_add_emp +  $tempVal12;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Male']))
                        $tempVal13 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Male'];
                    else $tempVal13 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Female']))
                        $tempVal14 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Female'];
                    else $tempVal14 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['total']))
                        $tempVal15 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['total'];
                    else $tempVal15 = 0;

                    $total_transfer_add_Male_emp = $total_transfer_add_Male_emp + $tempVal13;
                    $total_transfer_add_Female_emp = $total_transfer_add_Female_emp + $tempVal14;
                    $total_transfer_add_emp = $total_transfer_add_emp + $tempVal15;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Male']))
                        $tempVal16 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Male'];
                    else $tempVal16 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Female']))
                        $tempVal17 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Female'];
                    else $tempVal17 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['total']))
                        $tempVal18 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['total'];
                    else $tempVal18 = 0;

                    $total_promotion_less_Male_emp = $total_promotion_less_Male_emp + $tempVal16;
                    $total_promotion_less_Female_emp = $total_promotion_less_Female_emp + $tempVal17;
                    $total_promotion_less_emp = $total_promotion_less_emp + $tempVal18;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Male']))
                        $tempVal19 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Male'];
                    else $tempVal19 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Female']))
                        $tempVal20 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Female'];
                    else $tempVal20 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['total']))
                        $tempVal21 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['total'];
                    else $tempVal21 = 0;

                    $total_demotion_less_Male_emp = $total_demotion_less_Male_emp + $tempVal19;
                    $total_demotion_less_Female_emp = $total_demotion_less_Female_emp + $tempVal20;
                    $total_demotion_less_emp = $total_demotion_less_emp + $tempVal21;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Male']))
                        $tempVal22 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Male'];
                    else $tempVal22 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Female']))
                        $tempVal23 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Female'];
                    else $tempVal23 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['total']))
                        $tempVal24 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['total'];
                    else $tempVal24 = 0;

                    $total_transfer_less_Male_emp = $total_transfer_less_Male_emp + $tempVal22;
                    $total_transfer_less_Female_emp = $total_transfer_less_Female_emp + $tempVal23;
                    $total_transfer_less_emp = $total_transfer_less_emp + $tempVal24;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['Male']))
                        $tempVal25 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['Male'];
                    else $tempVal25 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['Female']))
                        $tempVal26 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['Female'];
                    else $tempVal26 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['total']))
                        $tempVal27 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['total'];
                    else $tempVal27 = 0;

                    $total_resign_Male_emp = $total_resign_Male_emp + $tempVal25;
                    $total_resign_Female_emp = $total_resign_Female_emp + $tempVal26;
                    $total_resign_emp = $total_resign_emp + $tempVal27;

                    $tempVal28 = ($tempVal1 + $tempVal4 + $tempVal7 + $tempVal10 + $tempVal13) - ($tempVal16 + $tempVal19 + $tempVal22 + $tempVal25);
                    $tempVal29 = ($tempVal2 + $tempVal5 + $tempVal8 + $tempVal11 + $tempVal14) - ($tempVal17 + $tempVal20 + $tempVal23 + $tempVal26);
                    $tempVal30 = ($tempVal3 + $tempVal6 + $tempVal9 + $tempVal12 + $tempVal15) - ($tempVal18 + $tempVal21 + $tempVal24 + $tempVal27);

                    $total_closing_Male_emp = ($total_opening_Male_emp + $total_joining_Male_emp + $total_promotion_add_Male_emp + $total_demotion_add_Male_emp + $total_transfer_add_Male_emp) - 
                                              ($total_promotion_less_Male_emp + $total_demotion_less_Male_emp + $total_transfer_less_Male_emp + $total_resign_Male_emp);

                    $total_closing_Female_emp = ($total_opening_Female_emp + $total_joining_Female_emp + $total_promotion_add_Female_emp + $total_demotion_add_Female_emp + $total_transfer_add_Female_emp) - 
                                              ($total_promotion_less_Female_emp + $total_demotion_less_Female_emp + $total_transfer_less_Female_emp + $total_resign_Female_emp);


                    $total_closing_emp = ($total_closing_Male_emp + $total_closing_Female_emp);

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Male']))
                        $tempVal31 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Male'];
                    else $tempVal31 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Female']))
                        $tempVal32 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Female'];
                    else $tempVal32 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['total']))
                        $tempVal33 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['total'];
                    else $tempVal33 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Male']))
                        $tempVal34 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Male'];
                    else $tempVal34 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Female']))
                        $tempVal35 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Female'];
                    else $tempVal35 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['total']))
                        $tempVal36 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['total'];
                    else $tempVal36 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Male']))
                        $tempVal37 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Male'];
                    else $tempVal37 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Female']))
                        $tempVal38 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Female'];
                    else $tempVal38 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['total']))
                        $tempVal39 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['total'];
                    else $tempVal39 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Male']))
                        $promotion_add_acting_start_Male = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Male'];
                    else $promotion_add_acting_start_Male = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Male']))
                        $promotion_less_acting_end_Male = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Male'];
                    else $promotion_less_acting_end_Male = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Female']))
                        $promotion_add_acting_start_Female = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Female'];
                    else $promotion_add_acting_start_Female = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Female']))
                        $promotion_less_acting_end_Female = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Female'];
                    else $promotion_less_acting_end_Female = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['total']))
                        $promotion_add_acting_start_total = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['total'];
                    else $promotion_add_acting_start_total = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['total']))
                        $promotion_less_acting_end_total = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['total'];
                    else $promotion_less_acting_end_total = 0;

                    $tempVal40 = ( $tempVal31 + $promotion_add_acting_start_Male ) - $promotion_less_acting_end_Male;
                    $tempVal41 = ( $tempVal32 + $promotion_add_acting_start_Female ) - $promotion_less_acting_end_Female;
                    $tempVal42 = ( $tempVal33 + $promotion_add_acting_start_total ) - $promotion_less_acting_end_total;

                    $total_opening_acting_Male = $total_opening_acting_Male + $tempVal31;
                    $total_opening_acting_Female = $total_opening_acting_Female + $tempVal32;
                    $total_opening_acting = $total_opening_acting + $tempVal33;

                    $total_promotion_add_acting_Male = $total_promotion_add_acting_Male + $tempVal34;
                    $total_promotion_add_acting_Female = $total_promotion_add_acting_Female + $tempVal35;
                    $total_promotion_add_acting = $total_promotion_add_acting + $tempVal36;

                    $total_promotion_less_acting_Male = $total_promotion_less_acting_Male + $tempVal37;
                    $total_promotion_less_acting_Female = $total_promotion_less_acting_Female + $tempVal38;
                    $total_promotion_less_acting = $total_promotion_less_acting + $tempVal39;

                    $total_closing_acting_Male = $total_closing_acting_Male + $tempVal40;
                    $total_closing_acting_Female = $total_closing_acting_Female + $tempVal41;
                    $total_closing_acting = $total_closing_acting + $tempVal42;
    
                @endphp
                
                @if(($data['positionTypeFilter'] == "Active" && $tempVal30 != 0) || ($data['positionTypeFilter'] == "All"))
                <tr>
                    <td style="text-align:center; text-align:left;">{{ $position->name }}</td>

                    <td style="text-align:center;">{{ ($tempVal1 != 0) ? $tempVal1 : '-' }} {{ ($tempVal1 != 0 && $tempVal31 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal31.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal2 != 0) ? $tempVal2 : '-' }} {{ ($tempVal2 != 0 && $tempVal32 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal32.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal3 != 0) ? $tempVal3 : '-' }} {{ ($tempVal3 != 0 && $tempVal33 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal33.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal4 != 0) ? $tempVal4 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal5 != 0) ? $tempVal5 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal6 != 0) ? $tempVal6 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal7 != 0) ? $tempVal7 : '-' }} {{ ($tempVal7 != 0 && $tempVal34 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal34.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal8 != 0) ? $tempVal8 : '-' }} {{ ($tempVal8 != 0 && $tempVal35 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal35.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal9 != 0) ? $tempVal9 : '-' }} {{ ($tempVal9 != 0 && $tempVal36 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal36.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal10 != 0) ? $tempVal10 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal11 != 0) ? $tempVal11 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal12 != 0) ? $tempVal12 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal13 != 0) ? $tempVal13 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal14 != 0) ? $tempVal14 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal15 != 0) ? $tempVal15 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal16 != 0) ? $tempVal16 : '-' }} {{ ($tempVal16 != 0 && $tempVal37 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal37.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal17 != 0) ? $tempVal17 : '-' }} {{ ($tempVal17 != 0 && $tempVal38 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal38.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal18 != 0) ? $tempVal18 : '-' }} {{ ($tempVal18 != 0 && $tempVal39 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal39.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal19 != 0) ? $tempVal19 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal20 != 0) ? $tempVal20 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal21 != 0) ? $tempVal21 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal22 != 0) ? $tempVal22 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal23 != 0) ? $tempVal23 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal24 != 0) ? $tempVal24 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal25 != 0) ? $tempVal25 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal26 != 0) ? $tempVal26 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal27 != 0) ? $tempVal27 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal28 != 0) ? $tempVal28 : '-' }} {{ ($tempVal28 != 0 && $tempVal40 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal40.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal29 != 0) ? $tempVal29 : '-' }} {{ ($tempVal29 != 0 && $tempVal41 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal41.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal30 != 0) ? $tempVal30 : '-' }} {{ ($tempVal30 != 0 && $tempVal42 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal42.')' : '' }}</td>

                </tr>
                @endif

            @endforeach

            @php

                $final_hq_no_1 = $total_opening_Male_emp;
                $final_hq_no_2 = $total_opening_Female_emp;
                $final_hq_no_3 = $total_opening_emp;

                $final_hq_no_4 = $total_joining_Male_emp;
                $final_hq_no_5 = $total_joining_Female_emp;
                $final_hq_no_6 = $total_joining_emp;

                $final_hq_no_7 = $total_promotion_add_Male_emp;
                $final_hq_no_8 = $total_promotion_add_Female_emp;
                $final_hq_no_9 = $total_promotion_add_emp;

                $final_hq_no_10 = $total_demotion_add_Male_emp;
                $final_hq_no_11 = $total_demotion_add_Female_emp;
                $final_hq_no_12 = $total_demotion_add_emp;

                $final_hq_no_13 = $total_transfer_add_Male_emp;
                $final_hq_no_14 = $total_transfer_add_Female_emp;
                $final_hq_no_15 = $total_transfer_add_emp;

                $final_hq_no_16 = $total_promotion_less_Male_emp;
                $final_hq_no_17 = $total_promotion_less_Female_emp;
                $final_hq_no_18 = $total_promotion_less_emp;
                
                $final_hq_no_19 = $total_demotion_less_Male_emp;
                $final_hq_no_20 = $total_demotion_less_Female_emp;
                $final_hq_no_21 = $total_demotion_less_emp;

                $final_hq_no_22 = $total_transfer_less_Male_emp;
                $final_hq_no_23 = $total_transfer_less_Female_emp;
                $final_hq_no_24 = $total_transfer_less_emp;

                $final_hq_no_25 = $total_resign_Male_emp;
                $final_hq_no_26 = $total_resign_Female_emp;
                $final_hq_no_27 = $total_resign_emp;

                $final_hq_no_28 = $total_closing_Male_emp;
                $final_hq_no_29 = $total_closing_Female_emp;
                $final_hq_no_30 = $total_closing_emp;

                $final_hq_no_31 = $total_opening_acting_Male;
                $final_hq_no_32 = $total_opening_acting_Female;
                $final_hq_no_33 = $total_opening_acting;

                $final_hq_no_34 = $total_promotion_add_acting_Male;
                $final_hq_no_35 = $total_promotion_add_acting_Female;
                $final_hq_no_36 = $total_promotion_add_acting;

                $final_hq_no_37 = $total_promotion_less_acting_Male;
                $final_hq_no_38 = $total_promotion_less_acting_Female;
                $final_hq_no_39 = $total_promotion_less_acting;

                $final_hq_no_40 = $total_closing_acting_Male;
                $final_hq_no_41 = $total_closing_acting_Female;
                $final_hq_no_42 = $total_closing_acting;


            @endphp

            <tr>
                <td style="text-align:center;"><b>Total</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_1 != 0) ? $final_hq_no_1 : '-' }} {{ ($final_hq_no_1 != 0 && $final_hq_no_31 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_31.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_2 != 0) ? $final_hq_no_2 : '-' }} {{ ($final_hq_no_2 != 0 && $final_hq_no_32 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_32.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_3 != 0) ?  $final_hq_no_3 : '-' }} {{ ($final_hq_no_3 != 0 && $final_hq_no_33 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_33.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_4 != 0) ? $final_hq_no_4 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_5 != 0) ? $final_hq_no_5 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_6 != 0) ? $final_hq_no_6 : '-' }}</b></td>
                
                <td style="text-align:center;"><b>{{ ($final_hq_no_7 != 0) ? $final_hq_no_7 : '-' }} {{ ($final_hq_no_7 != 0 && $final_hq_no_34 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_34.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_8 != 0) ? $final_hq_no_8 : '-' }} {{ ($final_hq_no_8 != 0 && $final_hq_no_35 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_35.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_9 != 0) ? $final_hq_no_9 : '-' }} {{ ($final_hq_no_9 != 0 && $final_hq_no_36 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_36.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_10 != 0) ? $final_hq_no_10 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_11 != 0) ? $final_hq_no_11 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_12 != 0) ? $final_hq_no_12 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_13 != 0) ? $final_hq_no_13 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_14 != 0) ? $final_hq_no_14 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_15 != 0) ? $final_hq_no_15 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_16 != 0) ? $final_hq_no_16 : '-' }} {{ ($final_hq_no_16 != 0 && $final_hq_no_37 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_37.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_17 != 0) ? $final_hq_no_17 : '-' }} {{ ($final_hq_no_17 != 0 && $final_hq_no_38 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_38.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_18 != 0) ? $final_hq_no_18 : '-' }} {{ ($final_hq_no_18 != 0 && $final_hq_no_39 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_39.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_19 != 0) ? $final_hq_no_19 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_20 != 0) ? $final_hq_no_20 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_21 != 0) ? $final_hq_no_21 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_22 != 0) ? $final_hq_no_22 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_23 != 0) ? $final_hq_no_23 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_24 != 0) ? $final_hq_no_24 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_25 != 0) ? $final_hq_no_25 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_26 != 0) ? $final_hq_no_26 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_27 != 0) ? $final_hq_no_27 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_hq_no_28 != 0) ? $final_hq_no_28 : '-' }} {{ ($final_hq_no_28 != 0 && $final_hq_no_40 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_40.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_29 != 0) ? $final_hq_no_29 : '-' }} {{ ($final_hq_no_29 != 0 && $final_hq_no_41 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_41.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_hq_no_30 != 0) ? $final_hq_no_30 : '-' }} {{ ($final_hq_no_30 != 0 && $final_hq_no_42 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_hq_no_42.')' : '' }}</b></td>
            </tr>

        @endif

        <!-- Branch Office Data -->
        @if(count($data['branchOfficeRecord']['positionsArray']) > 0)

            @if(count($data['headOfficeRecord']['positionsArray']) > 0 && count($data['branchOfficeRecord']['positionsArray']) > 0)
                <tr>
                    <td style="text-align:left; background: #F4F0E0;" colspan="31"><b>Branch</b></td>
                </tr>
            @endif

            @php
                    
                $total_opening_Male_emp = $total_opening_Female_emp = $total_opening_emp = 0;
                $total_joining_Male_emp = $total_joining_Female_emp = $total_joining_emp = 0;
                $total_promotion_add_Male_emp = $total_promotion_add_Female_emp = $total_promotion_add_emp = 0;
                $total_promotion_less_Male_emp = $total_promotion_less_Female_emp = $total_promotion_less_emp = 0;
                $total_demotion_add_Male_emp = $total_demotion_add_Female_emp = $total_demotion_add_emp = 0;
                $total_demotion_less_Male_emp = $total_demotion_less_Female_emp = $total_demotion_less_emp = 0;
                $total_transfer_add_Male_emp = $total_transfer_add_Female_emp = $total_transfer_add_emp = 0;
                $total_transfer_less_Male_emp = $total_transfer_less_Female_emp = $total_transfer_less_emp = 0;
                $total_resign_Male_emp = $total_resign_Female_emp = $total_resign_emp = 0;
                $total_closing_Male_emp = $total_closing_Female_emp = $total_closing_emp = 0;

                $total_opening_acting_Male = $total_opening_acting_Female = $total_opening_acting = 0;
                $total_promotion_add_acting_Male = $total_promotion_add_acting_Female = $total_promotion_add_acting = 0;
                $total_promotion_less_acting_Male = $total_promotion_less_acting_Female = $total_promotion_less_acting = 0;
                $total_closing_acting_Male = $total_closing_acting_Female = $total_closing_acting = 0;

                $dataType = 'branchOfficeRecord';
                $officeType = 'branch';

            @endphp

            @foreach($data['branchOfficeRecord']['positionsArray'] as $position)

                @php
                    
                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['Male']))
                        $tempVal1 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['Male'];
                    else $tempVal1 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['Female']))
                        $tempVal2 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['Female'];
                    else $tempVal2 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening']['total']))
                        $tempVal3 = $data[$dataType]['reportData'][$position->id][$officeType]['opening']['total'];
                    else $tempVal3 = 0;

                    $total_opening_Male_emp = $total_opening_Male_emp + $tempVal1;
                    $total_opening_Female_emp = $total_opening_Female_emp + $tempVal2;
                    $total_opening_emp = $total_opening_emp + $tempVal3;
                                            
                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['Male']))
                        $tempVal4 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['Male'];
                    else $tempVal4 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['Female']))
                        $tempVal5 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['Female'];
                    else $tempVal5 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['joining']['total']))
                        $tempVal6 = $data[$dataType]['reportData'][$position->id][$officeType]['joining']['total'];
                    else $tempVal6 = 0;

                    $total_joining_Male_emp = $total_joining_Male_emp + $tempVal4;
                    $total_joining_Female_emp = $total_joining_Female_emp + $tempVal5;
                    $total_joining_emp = $total_joining_emp + $tempVal6;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Male']))
                        $tempVal7 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Male'];
                    else $tempVal7 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Female']))
                        $tempVal8 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['Female'];
                    else $tempVal8 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['total']))
                        $tempVal9 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add']['total'];
                    else $tempVal9 = 0;

                    $total_promotion_add_Male_emp = $total_promotion_add_Male_emp + $tempVal7;
                    $total_promotion_add_Female_emp = $total_promotion_add_Female_emp + $tempVal8;
                    $total_promotion_add_emp = $total_promotion_add_emp + $tempVal9;
                    
                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Male']))
                        $tempVal10 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Male'];
                    else $tempVal10 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Female']))
                        $tempVal11 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['Female'];
                    else $tempVal11 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['total']))
                        $tempVal12 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_add']['total'];
                    else $tempVal12 = 0;
                    
                    $total_demotion_add_Male_emp = $total_demotion_add_Male_emp + $tempVal10;
                    $total_demotion_add_Female_emp = $total_demotion_add_Female_emp + $tempVal11;
                    $total_demotion_add_emp = $total_demotion_add_emp +  $tempVal12;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Male']))
                        $tempVal13 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Male'];
                    else $tempVal13 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Female']))
                        $tempVal14 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['Female'];
                    else $tempVal14 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['total']))
                        $tempVal15 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_add']['total'];
                    else $tempVal15 = 0;

                    $total_transfer_add_Male_emp = $total_transfer_add_Male_emp + $tempVal13;
                    $total_transfer_add_Female_emp = $total_transfer_add_Female_emp + $tempVal14;
                    $total_transfer_add_emp = $total_transfer_add_emp + $tempVal15;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Male']))
                        $tempVal16 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Male'];
                    else $tempVal16 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Female']))
                        $tempVal17 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['Female'];
                    else $tempVal17 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['total']))
                        $tempVal18 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less']['total'];
                    else $tempVal18 = 0;

                    $total_promotion_less_Male_emp = $total_promotion_less_Male_emp + $tempVal16;
                    $total_promotion_less_Female_emp = $total_promotion_less_Female_emp + $tempVal17;
                    $total_promotion_less_emp = $total_promotion_less_emp + $tempVal18;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Male']))
                        $tempVal19 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Male'];
                    else $tempVal19 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Female']))
                        $tempVal20 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['Female'];
                    else $tempVal20 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['total']))
                        $tempVal21 = $data[$dataType]['reportData'][$position->id][$officeType]['demotion_less']['total'];
                    else $tempVal21 = 0;

                    $total_demotion_less_Male_emp = $total_demotion_less_Male_emp + $tempVal19;
                    $total_demotion_less_Female_emp = $total_demotion_less_Female_emp + $tempVal20;
                    $total_demotion_less_emp = $total_demotion_less_emp + $tempVal21;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Male']))
                        $tempVal22 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Male'];
                    else $tempVal22 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Female']))
                        $tempVal23 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['Female'];
                    else $tempVal23 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['total']))
                        $tempVal24 = $data[$dataType]['reportData'][$position->id][$officeType]['transfer_less']['total'];
                    else $tempVal24 = 0;

                    $total_transfer_less_Male_emp = $total_transfer_less_Male_emp + $tempVal22;
                    $total_transfer_less_Female_emp = $total_transfer_less_Female_emp + $tempVal23;
                    $total_transfer_less_emp = $total_transfer_less_emp + $tempVal24;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['Male']))
                        $tempVal25 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['Male'];
                    else $tempVal25 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['Female']))
                        $tempVal26 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['Female'];
                    else $tempVal26 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['resign']['total']))
                        $tempVal27 = $data[$dataType]['reportData'][$position->id][$officeType]['resign']['total'];
                    else $tempVal27 = 0;

                    $total_resign_Male_emp = $total_resign_Male_emp + $tempVal25;
                    $total_resign_Female_emp = $total_resign_Female_emp + $tempVal26;
                    $total_resign_emp = $total_resign_emp + $tempVal27;

                    $tempVal28 = ($tempVal1 + $tempVal4 + $tempVal7 + $tempVal10 + $tempVal13) - ($tempVal16 + $tempVal19 + $tempVal22 + $tempVal25);
                    $tempVal29 = ($tempVal2 + $tempVal5 + $tempVal8 + $tempVal11 + $tempVal14) - ($tempVal17 + $tempVal20 + $tempVal23 + $tempVal26);
                    $tempVal30 = ($tempVal3 + $tempVal6 + $tempVal9 + $tempVal12 + $tempVal15) - ($tempVal18 + $tempVal21 + $tempVal24 + $tempVal27);

                    $total_closing_Male_emp = ($total_opening_Male_emp + $total_joining_Male_emp + $total_promotion_add_Male_emp + $total_demotion_add_Male_emp + $total_transfer_add_Male_emp) - 
                                            ($total_promotion_less_Male_emp + $total_demotion_less_Male_emp + $total_transfer_less_Male_emp + $total_resign_Male_emp);

                    $total_closing_Female_emp = ($total_opening_Female_emp + $total_joining_Female_emp + $total_promotion_add_Female_emp + $total_demotion_add_Female_emp + $total_transfer_add_Female_emp) - 
                                            ($total_promotion_less_Female_emp + $total_demotion_less_Female_emp + $total_transfer_less_Female_emp + $total_resign_Female_emp);


                    $total_closing_emp = ($total_closing_Male_emp + $total_closing_Female_emp);

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Male']))
                        $tempVal31 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Male'];
                    else $tempVal31 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Female']))
                        $tempVal32 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['Female'];
                    else $tempVal32 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['total']))
                        $tempVal33 = $data[$dataType]['reportData'][$position->id][$officeType]['opening_acting']['total'];
                    else $tempVal33 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Male']))
                        $tempVal34 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Male'];
                    else $tempVal34 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Female']))
                        $tempVal35 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['Female'];
                    else $tempVal35 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['total']))
                        $tempVal36 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting']['total'];
                    else $tempVal36 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Male']))
                        $tempVal37 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Male'];
                    else $tempVal37 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Female']))
                        $tempVal38 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['Female'];
                    else $tempVal38 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['total']))
                        $tempVal39 = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting']['total'];
                    else $tempVal39 = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Male']))
                        $promotion_add_acting_start_Male = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Male'];
                    else $promotion_add_acting_start_Male = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Male']))
                        $promotion_less_acting_end_Male = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Male'];
                    else $promotion_less_acting_end_Male = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Female']))
                        $promotion_add_acting_start_Female = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['Female'];
                    else $promotion_add_acting_start_Female = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Female']))
                        $promotion_less_acting_end_Female = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['Female'];
                    else $promotion_less_acting_end_Female = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['total']))
                        $promotion_add_acting_start_total = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_add_acting_start']['total'];
                    else $promotion_add_acting_start_total = 0;

                    if(isset($data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['total']))
                        $promotion_less_acting_end_total = $data[$dataType]['reportData'][$position->id][$officeType]['promotion_less_acting_end']['total'];
                    else $promotion_less_acting_end_total = 0;

                    $tempVal40 = ( $tempVal31 + $promotion_add_acting_start_Male ) - $promotion_less_acting_end_Male;
                    $tempVal41 = ( $tempVal32 + $promotion_add_acting_start_Female ) - $promotion_less_acting_end_Female;
                    $tempVal42 = ( $tempVal33 + $promotion_add_acting_start_total ) - $promotion_less_acting_end_total;

                    $total_opening_acting_Male = $total_opening_acting_Male + $tempVal31;
                    $total_opening_acting_Female = $total_opening_acting_Female + $tempVal32;
                    $total_opening_acting = $total_opening_acting + $tempVal33;

                    $total_promotion_add_acting_Male = $total_promotion_add_acting_Male + $tempVal34;
                    $total_promotion_add_acting_Female = $total_promotion_add_acting_Female + $tempVal35;
                    $total_promotion_add_acting = $total_promotion_add_acting + $tempVal36;

                    $total_promotion_less_acting_Male = $total_promotion_less_acting_Male + $tempVal37;
                    $total_promotion_less_acting_Female = $total_promotion_less_acting_Female + $tempVal38;
                    $total_promotion_less_acting = $total_promotion_less_acting + $tempVal39;

                    $total_closing_acting_Male = $total_closing_acting_Male + $tempVal40;
                    $total_closing_acting_Female = $total_closing_acting_Female + $tempVal41;
                    $total_closing_acting = $total_closing_acting + $tempVal42;

                @endphp
                 
                @if(($data['positionTypeFilter'] == "Active" && $tempVal30 != 0) || ($data['positionTypeFilter'] == "All"))
                <tr>
                    <td style="text-align:center; text-align:left;">{{ $position->name }}</td>

                    <td style="text-align:center;">{{ ($tempVal1 != 0) ? $tempVal1 : '-' }} {{ ($tempVal1 != 0 && $tempVal31 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal31.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal2 != 0) ? $tempVal2 : '-' }} {{ ($tempVal2 != 0 && $tempVal32 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal32.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal3 != 0) ? $tempVal3 : '-' }} {{ ($tempVal3 != 0 && $tempVal33 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal33.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal4 != 0) ? $tempVal4 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal5 != 0) ? $tempVal5 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal6 != 0) ? $tempVal6 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal7 != 0) ? $tempVal7 : '-' }} {{ ($tempVal7 != 0 && $tempVal34 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal34.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal8 != 0) ? $tempVal8 : '-' }} {{ ($tempVal8 != 0 && $tempVal35 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal35.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal9 != 0) ? $tempVal9 : '-' }} {{ ($tempVal9 != 0 && $tempVal36 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal36.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal10 != 0) ? $tempVal10 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal11 != 0) ? $tempVal11 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal12 != 0) ? $tempVal12 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal13 != 0) ? $tempVal13 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal14 != 0) ? $tempVal14 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal15 != 0) ? $tempVal15 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal16 != 0) ? $tempVal16 : '-' }} {{ ($tempVal16 != 0 && $tempVal37 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal37.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal17 != 0) ? $tempVal17 : '-' }} {{ ($tempVal17 != 0 && $tempVal38 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal38.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal18 != 0) ? $tempVal18 : '-' }} {{ ($tempVal18 != 0 && $tempVal39 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal39.')' : '' }}</td>

                    <td style="text-align:center;">{{ ($tempVal19 != 0) ? $tempVal19 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal20 != 0) ? $tempVal20 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal21 != 0) ? $tempVal21 : '-' }}</td>
                    
                    <td style="text-align:center;">{{ ($tempVal22 != 0) ? $tempVal22 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal23 != 0) ? $tempVal23 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal24 != 0) ? $tempVal24 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal25 != 0) ? $tempVal25 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal26 != 0) ? $tempVal26 : '-' }}</td>
                    <td style="text-align:center;">{{ ($tempVal27 != 0) ? $tempVal27 : '-' }}</td>

                    <td style="text-align:center;">{{ ($tempVal28 != 0) ? $tempVal28 : '-' }} {{ ($tempVal28 != 0 && $tempVal40 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal40.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal29 != 0) ? $tempVal29 : '-' }} {{ ($tempVal29 != 0 && $tempVal41 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal41.')' : '' }}</td>
                    <td style="text-align:center;">{{ ($tempVal30 != 0) ? $tempVal30 : '-' }} {{ ($tempVal30 != 0 && $tempVal42 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$tempVal42.')' : '' }}</td>

                </tr>
                @endif

            @endforeach

            @php

                $final_br_no_1 = $total_opening_Male_emp;
                $final_br_no_2 = $total_opening_Female_emp;
                $final_br_no_3 = $total_opening_emp;

                $final_br_no_4 = $total_joining_Male_emp;
                $final_br_no_5 = $total_joining_Female_emp;
                $final_br_no_6 = $total_joining_emp;

                $final_br_no_7 = $total_promotion_add_Male_emp;
                $final_br_no_8 = $total_promotion_add_Female_emp;
                $final_br_no_9 = $total_promotion_add_emp;

                $final_br_no_10 = $total_demotion_add_Male_emp;
                $final_br_no_11 = $total_demotion_add_Female_emp;
                $final_br_no_12 = $total_demotion_add_emp;

                $final_br_no_13 = $total_transfer_add_Male_emp;
                $final_br_no_14 = $total_transfer_add_Female_emp;
                $final_br_no_15 = $total_transfer_add_emp;

                $final_br_no_16 = $total_promotion_less_Male_emp;
                $final_br_no_17 = $total_promotion_less_Female_emp;
                $final_br_no_18 = $total_promotion_less_emp;
                
                $final_br_no_19 = $total_demotion_less_Male_emp;
                $final_br_no_20 = $total_demotion_less_Female_emp;
                $final_br_no_21 = $total_demotion_less_emp;

                $final_br_no_22 = $total_transfer_less_Male_emp;
                $final_br_no_23 = $total_transfer_less_Female_emp;
                $final_br_no_24 = $total_transfer_less_emp;

                $final_br_no_25 = $total_resign_Male_emp;
                $final_br_no_26 = $total_resign_Female_emp;
                $final_br_no_27 = $total_resign_emp;

                $final_br_no_28 = $total_closing_Male_emp;
                $final_br_no_29 = $total_closing_Female_emp;
                $final_br_no_30 = $total_closing_emp;

                $final_br_no_31 = $total_opening_acting_Male;
                $final_br_no_32 = $total_opening_acting_Female;
                $final_br_no_33 = $total_opening_acting;

                $final_br_no_34 = $total_promotion_add_acting_Male;
                $final_br_no_35 = $total_promotion_add_acting_Female;
                $final_br_no_36 = $total_promotion_add_acting;

                $final_br_no_37 = $total_promotion_less_acting_Male;
                $final_br_no_38 = $total_promotion_less_acting_Female;
                $final_br_no_39 = $total_promotion_less_acting;

                $final_br_no_40 = $total_closing_acting_Male;
                $final_br_no_41 = $total_closing_acting_Female;
                $final_br_no_42 = $total_closing_acting;

            @endphp

            <tr>
                <td style="text-align:center;"><b>Total</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_1 != 0) ? $final_br_no_1 : '-' }} {{ ($final_br_no_1 != 0 && $final_br_no_31 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_31.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_2 != 0) ? $final_br_no_2 : '-' }} {{ ($final_br_no_2 != 0 && $final_br_no_32 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_32.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_3 != 0) ?  $final_br_no_3 : '-' }} {{ ($final_br_no_3 != 0 && $final_br_no_33 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_33.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_4 != 0) ? $final_br_no_4 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_5 != 0) ? $final_br_no_5 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_6 != 0) ? $final_br_no_6 : '-' }}</b></td>
                
                <td style="text-align:center;"><b>{{ ($final_br_no_7 != 0) ? $final_br_no_7 : '-' }} {{ ($final_br_no_7 != 0 && $final_br_no_34 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_34.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_8 != 0) ? $final_br_no_8 : '-' }} {{ ($final_br_no_8 != 0 && $final_br_no_35 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_35.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_9 != 0) ? $final_br_no_9 : '-' }} {{ ($final_br_no_9 != 0 && $final_br_no_36 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_36.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_10 != 0) ? $final_br_no_10 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_11 != 0) ? $final_br_no_11 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_12 != 0) ? $final_br_no_12 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_13 != 0) ? $final_br_no_13 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_14 != 0) ? $final_br_no_14 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_15 != 0) ? $final_br_no_15 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_16 != 0) ? $final_br_no_16 : '-' }} {{ ($final_br_no_16 != 0 && $final_br_no_37 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_37.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_17 != 0) ? $final_br_no_17 : '-' }} {{ ($final_br_no_17 != 0 && $final_br_no_38 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_38.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_18 != 0) ? $final_br_no_18 : '-' }} {{ ($final_br_no_18 != 0 && $final_br_no_39 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_39.')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_19 != 0) ? $final_br_no_19 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_20 != 0) ? $final_br_no_20 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_21 != 0) ? $final_br_no_21 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_22 != 0) ? $final_br_no_22 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_23 != 0) ? $final_br_no_23 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_24 != 0) ? $final_br_no_24 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_25 != 0) ? $final_br_no_25 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_26 != 0) ? $final_br_no_26 : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_27 != 0) ? $final_br_no_27 : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ($final_br_no_28 != 0) ? $final_br_no_28 : '-' }} {{ ($final_br_no_28 != 0 && $final_br_no_40 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_40.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_29 != 0) ? $final_br_no_29 : '-' }} {{ ($final_br_no_29 != 0 && $final_br_no_41 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_41.')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ($final_br_no_30 != 0) ? $final_br_no_30 : '-' }} {{ ($final_br_no_30 != 0 && $final_br_no_42 != 0 && $data['positionTypeFilter'] == "All") ? ' ('.$final_br_no_42.')' : '' }}</b></td>
            </tr>

        @endif

        <!-- Grand Total -->
        @if(count($data['headOfficeRecord']['positionsArray']) > 0 && count($data['branchOfficeRecord']['positionsArray']) > 0)
            <tr>
                <td style="text-align:center;"><b>Grand Total</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_1 + $final_br_no_1) != 0) ? ($final_hq_no_1 + $final_br_no_1) : '-' }} {{ ( ($final_hq_no_1 + $final_br_no_1) != 0 && ($final_hq_no_31 + $final_br_no_31) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_31 + $final_br_no_31).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_2 + $final_br_no_2) != 0) ? ($final_hq_no_2 + $final_br_no_2) : '-' }} {{ ( ($final_hq_no_2 + $final_br_no_2) != 0 && ($final_hq_no_32 + $final_br_no_32) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_32 + $final_br_no_32).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_3 + $final_br_no_3) != 0) ? ($final_hq_no_3 + $final_br_no_3) : '-' }} {{ ( ($final_hq_no_3 + $final_br_no_3) != 0 && ($final_hq_no_33 + $final_br_no_33) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_33 + $final_br_no_33).')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_4 + $final_br_no_4) != 0) ? ($final_hq_no_4 + $final_br_no_4) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_5 + $final_br_no_5) != 0) ? ($final_hq_no_5 + $final_br_no_5) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_6 + $final_br_no_6) != 0) ? ($final_hq_no_6 + $final_br_no_6) : '-' }}</b></td>
                
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_7 + $final_br_no_7) != 0) ? ($final_hq_no_7 + $final_br_no_7) : '-' }} {{ ( ($final_hq_no_7 + $final_br_no_7) != 0 && ($final_hq_no_34 + $final_br_no_34) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_34 + $final_br_no_34).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_8 + $final_br_no_8) != 0) ? ($final_hq_no_8 + $final_br_no_8) : '-' }} {{ ( ($final_hq_no_8 + $final_br_no_8) != 0 && ($final_hq_no_35 + $final_br_no_35) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_35 + $final_br_no_35).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_9 + $final_br_no_9) != 0) ? ($final_hq_no_9 + $final_br_no_9) : '-' }} {{ ( ($final_hq_no_9 + $final_br_no_9) != 0 && ($final_hq_no_36 + $final_br_no_36) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_36 + $final_br_no_36).')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_10 + $final_br_no_10) != 0) ? ($final_hq_no_10 + $final_br_no_10) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_11 + $final_br_no_11) != 0) ? ($final_hq_no_11 + $final_br_no_11) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_12 + $final_br_no_12) != 0) ? ($final_hq_no_12 + $final_br_no_12) : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_13 + $final_br_no_13) != 0) ? ($final_hq_no_13 + $final_br_no_13) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_14 + $final_br_no_14) != 0) ? ($final_hq_no_14 + $final_br_no_14) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_15 + $final_br_no_15) != 0) ? ($final_hq_no_15 + $final_br_no_15) : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_16 + $final_br_no_16) != 0) ? ($final_hq_no_16 + $final_br_no_16) : '-' }} {{ ( ($final_hq_no_16 + $final_br_no_16) != 0 && ($final_hq_no_37 + $final_br_no_37) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_37 + $final_br_no_37).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_17 + $final_br_no_17) != 0) ? ($final_hq_no_17 + $final_br_no_17) : '-' }} {{ ( ($final_hq_no_17 + $final_br_no_17) != 0 && ($final_hq_no_38 + $final_br_no_38) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_38 + $final_br_no_38).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_18 + $final_br_no_18) != 0) ? ($final_hq_no_18 + $final_br_no_18) : '-' }} {{ ( ($final_hq_no_18 + $final_br_no_18) != 0 && ($final_hq_no_39 + $final_br_no_39) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_39 + $final_br_no_39).')' : '' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_19 + $final_br_no_19) != 0) ? ($final_hq_no_19 + $final_br_no_19) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_20 + $final_br_no_20) != 0) ? ($final_hq_no_20 + $final_br_no_20) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_21 + $final_br_no_21) != 0) ? ($final_hq_no_21 + $final_br_no_21) : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_22 + $final_br_no_22) != 0) ? ($final_hq_no_22 + $final_br_no_22) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_23 + $final_br_no_23) != 0) ? ($final_hq_no_23 + $final_br_no_23) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_24 + $final_br_no_24) != 0) ? ($final_hq_no_24 + $final_br_no_24) : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_25 + $final_br_no_25) != 0) ? ($final_hq_no_25 + $final_br_no_25) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_26 + $final_br_no_26) != 0) ? ($final_hq_no_26 + $final_br_no_26) : '-' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_27 + $final_br_no_27) != 0) ? ($final_hq_no_27 + $final_br_no_27) : '-' }}</b></td>

                <td style="text-align:center;"><b>{{ ( ($final_hq_no_28 + $final_br_no_28) != 0) ? ($final_hq_no_28 + $final_br_no_28) : '-' }} {{ ( ($final_hq_no_28 + $final_br_no_28) != 0 && ($final_hq_no_40 + $final_br_no_40) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_40 + $final_br_no_40).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_29 + $final_br_no_29) != 0) ? ($final_hq_no_29 + $final_br_no_29) : '-' }} {{ ( ($final_hq_no_29 + $final_br_no_29) != 0 && ($final_hq_no_41 + $final_br_no_41) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_41 + $final_br_no_41).')' : '' }}</b></td>
                <td style="text-align:center;"><b>{{ ( ($final_hq_no_30 + $final_br_no_30) != 0) ? ($final_hq_no_30 + $final_br_no_30) : '-' }} {{ ( ($final_hq_no_30 + $final_br_no_30) != 0 && ($final_hq_no_42 + $final_br_no_42) != 0 && $data['positionTypeFilter'] == "All") ? ' ('.($final_hq_no_42 + $final_br_no_42).')' : '' }}</b></td>
            </tr>
        @endif
       
    </tbody>

</table>