@php
echo "
<pre>";
// Uncomment the following lines to debug:
// print_r($XAxisArray);
// print_r($YAxisArray);
// print_r($GetResult);
// print_r($FieldsDisplayType);
// print_r($AssignedToList);
echo "</pre>";
$uniqueId = uniqid('report_');

$tableId = "DownloadXYAxisReport_" . $uniqueId;
$buttonId = "ExportButton_" . $uniqueId;
$XAxisData = $GetResult['XAxisData'];
$YAxisData = $GetResult['YAxisData'];
$REsultData = $GetResult['REsultData'];
$XDemographyConfigId = $XAxisArray[0]['DemographyConfigId'];
$XAxisColumnName = $XAxisArray[0]['ColumnName'];
$XAxisAliasname = $XAxisArray[0]['Aliasname'];
$YDemographyConfigId = $YAxisArray[0]['DemographyConfigId'];
$YAxisColumnName = $YAxisArray[0]['ColumnName'];
$YAxisAliasname = $YAxisArray[0]['Aliasname'];
$TotalOverAllCount = array(); // Total for Y-axis
$TotalXCount = array(); // Total for X-axis
@endphp

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js"></script>

<div style="overflow-x: auto; white-space: nowrap !important;">
    <div class="row">
        <div class="col-sm-12 col-md-12" style="text-align: right">
            <button class="btn btn-primary" type="button" id="{{ $buttonId }}">Export Excel</button>
        </div>
    </div>
    <br>
    <table style="width:100%;margin: 18px;" class="table table-bordered mb-4" id="{{ $tableId }}">
        <tr>
            <td><b>{{$XAxisAliasname}} / {{$YAxisAliasname}}</b></td>
            @foreach($YAxisData as $EachYAxisData)
            @php
            $YColumnName = $EachYAxisData;
            $YDisplayName = $EachYAxisData;
            $YdisplayType = $FieldsDisplayType[$YDemographyConfigId]['DisplayType'];
            if(($YdisplayType == 5 || $YdisplayType == 2 || $YdisplayType == 3 || $YdisplayType == 6 || $YdisplayType == 26) && $YColumnName != '')
            {
            $YDropDownNameId = $FieldsDisplayType[$YDemographyConfigId]['DropDownNameId'];
            if($GetDropdownLists[$YDropDownNameId])
            {
            $ChildDropDown = $GetDropdownLists[$YDropDownNameId];
            if(array_key_exists($YColumnName, $ChildDropDown))
            {
            $YDisplayName = $ChildDropDown[$YColumnName];
            }
            }
            }
            if($YdisplayType == 15 || $YdisplayType == 31 || $YdisplayType == 32 || $YdisplayType == 33)
            {
            $AssignedUserNameTEmp = "";
            if(array_key_exists($YColumnName, $AssignedToList))
            {
            $AssignedUserNameTEmp = $AssignedToList[$YColumnName];
            $YDisplayName = $AssignedUserNameTEmp['name'];
            }
            }
            @endphp
            <td>
                @if($YDisplayName == '')
                (EMPTY)
                @else
                <b>{{$YDisplayName}}</b>
                @endif
            </td>
            @endforeach
            <td><b>Total</b></td> <!-- Adding Y-axis total column -->
        </tr>
        @foreach($XAxisData as $EachXAxisData)
        <tr>
            @php
            $XColumnName = $EachXAxisData;
            $XDisplayName = $EachXAxisData;
            $XdisplayType = $FieldsDisplayType[$XDemographyConfigId]['DisplayType'];
            if(($XdisplayType == 5 || $XdisplayType == 2 || $XdisplayType == 3 || $XdisplayType == 6 || $XdisplayType == 26) && $XColumnName != '')
            {
            $XDropDownNameId = $FieldsDisplayType[$XDemographyConfigId]['DropDownNameId'];
            if($GetDropdownLists[$XDropDownNameId])
            {
            $ChildDropDown = $GetDropdownLists[$XDropDownNameId];
            if(array_key_exists($XColumnName, $ChildDropDown))
            {
            $XDisplayName = $ChildDropDown[$XColumnName];
            }
            }
            }
            if($XdisplayType == 15 || $XdisplayType == 31 || $XdisplayType == 32 || $XdisplayType == 33)
            {
            $AssignedUserNameTEmp = "";
            if(array_key_exists($XColumnName, $AssignedToList))
            {
            $AssignedUserNameTEmp = $AssignedToList[$XColumnName];
            $XDisplayName = $AssignedUserNameTEmp['name'];
            }
            }
            $TotalForThisRow = 0; // Initialize total for this row (X-axis)
            @endphp
            <td>
                @if($XDisplayName == '')
                (EMPTY)
                @else
                {{$XDisplayName}}
                @endif
            </td>
            @foreach($YAxisData as $EachYAxisData)
            <td style="cursor:pointer">
                @php
                $YColumnName = $EachYAxisData;
                $XAxisResult = $REsultData[$XColumnName][$YColumnName];

                // Calculate the total for the Y-axis
                if(array_key_exists($YColumnName, $TotalOverAllCount))
                {
                $TotalOverAllCount[$YColumnName] += $XAxisResult;
                }
                else
                {
                $TotalOverAllCount[$YColumnName] = $XAxisResult;
                }

                // Calculate the total for the X-axis (row total)
                $TotalForThisRow += $XAxisResult;

                // Calculate the total for the X-axis
                if(array_key_exists($XColumnName, $TotalXCount))
                {
                $TotalXCount[$XColumnName] += $XAxisResult;
                }
                else
                {
                $TotalXCount[$XColumnName] = $XAxisResult;
                }
                @endphp
                <a onclick="AdhocDrillDown('{{$XDemographyConfigId}}','{{$XColumnName}}','{{$YDemographyConfigId}}','{{$YColumnName}}','{{$AdHocReportId}}','{{$ReportType}}','{{$PrimaryModuleId}}',1,'{{$mode}}')" data-bs-toggle="modal" data-bs-target="#XAxisModal">
                {{$XAxisResult}}
            </a>
            </td>
            @endforeach
            <td class="x-total" data-x="{{ $XColumnName }}" style="cursor:pointer">
                <b>{{$TotalForThisRow}}</b>
                </a>
        </td> <!-- Displaying the total for the current row -->
        </tr>
        @endforeach
        <tr>
            <td><b>Total</b></td>
            @foreach($YAxisData as $EachYAxisData)
            <td class="y-total" data-y="{{$EachYAxisData}}" style="cursor:pointer">
                    <b>{{$TotalOverAllCount[$EachYAxisData]}}</b>
                
            </td>
            @endforeach
            <td class="grand-total" style="cursor:pointer">
                    <b>{{ array_sum($TotalXCount) }}</b>
                </a>
            </td> <!-- Display the overall total for the X-axis (grand total) -->
        </tr>
    </table>
</div>

<div class="modal fade" id="XAxisModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-xl" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="exampleModalLabel">BPM360</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <svg aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-x">
                        <line x1="18" y1="6" x2="6" y2="18"></line>
                        <line x1="6" y1="6" x2="18" y2="18"></line>
                    </svg>
                </button>
            </div>
            <div class="modal-body" id="response_div">
                <p class="modal-text"></p>
                <div id="DrillDropDetails"></div>
            </div>
            <div class="modal-footer">
                <button class="btn" data-dismiss="modal"><i class="flaticon-cancel-12"></i> Discard</button>
            </div>
        </div>
    </div>
</div>

<script>

function AdhocDrillDownTotal(Condition1, Value1, Condition2, Value2, AdhocReportId, AdhocReportType, PrimaryModuleId, page_num, mode) {
    console.log("Loading Total Results...");
    var searchForm = '';
    if (mode == 'Report') {
        searchForm = '';
    } else if (mode == 'Manual') {
        searchForm = JSON.stringify($('#SearchForm').serializeArray());
    }
    var formData = {
        source: mode,
        ModuleId: PrimaryModuleId,
        ReportId: AdhocReportId,
        ReportType: 5,
        mode: mode,
        page_num: page_num,
        Condition1: Condition1,
        Value1: Value1,
        Condition2: Condition2,
        Value2: Value2,
        searchForm: searchForm,
        isTotal: true  // Add this flag to indicate it's a total drilldown
    };
    console.log("Total FormData:", formData);

    var ajax_url = "{{ url('ShowAdhocGeneratedResults') }}";
    $.ajax({
        url: ajax_url,
        type: 'POST',
        data: formData,
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        beforeSend: function() {
            $('#DrillDropDetails').html('<center> <div class="spinner-border text-primary align-self-center loader-lg">Loading Total...</div></center>');
        },
        success: function(result) {
            console.log("Total Success...");
            console.log("Total Backend Result:", result);
            $('#DrillDropDetails').html(result);
            $('#XAxisModal').modal('show'); 
        },
        error: function (data) {
            console.error("Total Error:", data);
            $('#DrillDropDetails').html("");
            $('#XAxisModal').modal('show'); 
        }
    });
}


// Update onclick events in the table
$(document).ready(function() {
    // For row totals (X-axis totals)
    $('.x-total').on('click', function() {
        var x = $(this).data('x');
        AdhocDrillDownTotal('{{$XDemographyConfigId}}', x, '', '', '{{$AdHocReportId}}', '{{$ReportType}}', '{{$PrimaryModuleId}}', 1, '{{$mode}}');
    });

    // For column totals (Y-axis totals)
    $('.y-total').on('click', function() {
        var y = $(this).data('y');
        AdhocDrillDownTotal('', '', '{{$YDemographyConfigId}}', y, '{{$AdHocReportId}}', '{{$ReportType}}', '{{$PrimaryModuleId}}', 1, '{{$mode}}');
    });

    // For grand total
    $('.grand-total').on('click', function() {
        AdhocDrillDownTotal('', '', '', '', '{{$AdHocReportId}}', '{{$ReportType}}', '{{$PrimaryModuleId}}', 1, '{{$mode}}');
    });
});

(function() {
    var tableId = '{{ $tableId }}';
    var buttonId = '{{ $buttonId }}';
    var fileName = '{{ $XAxisAliasname }}_{{ $YAxisAliasname }}_Report.xlsx';

    function exportToExcel() {
        var table = document.getElementById(tableId);
        if (!table) {
            console.error('Table not found:', tableId);
            return;
        }

        if (typeof XLSX === 'undefined') {
            console.error('XLSX library not loaded');
            return;
        }

        try {
            var wb = XLSX.utils.table_to_book(table, { sheet: "Sheet JS" });
            var wbout = XLSX.write(wb, { bookType: 'xlsx', type: 'array' });
            var blob = new Blob([wbout], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
            var url = URL.createObjectURL(blob);
            var a = document.createElement('a');
            a.href = url;
            a.download = fileName;
            document.body.appendChild(a);
            a.click();
            setTimeout(function() {
                document.body.removeChild(a);
                window.URL.revokeObjectURL(url);
            }, 0);
        } catch (error) {
            console.error('Error exporting Excel:', error);
        }
    }

    var button = document.getElementById(buttonId);
    if (button) {
        button.addEventListener('click', exportToExcel);
    } else {
        console.error('Export button not found:', buttonId);
    }
})();


</script>