@php
    // on 9th Dec '21, for ReportType==7

$userdetails = Auth::user();
$LoggedUser = $userdetails->name;
$DateFormat = $userdetails->DateFormat;
$TimeZone = $userdetails->TimeZone;
$TimeFormat = $userdetails->TimeFormat;
$GmtOffSet = $userdetails->GmtOffSet;

$total_count=count($header);
$columns = array();
$loopcount=0;

$column_data=array();
$header_data=array();
$results_obj=array();
foreach($results as $obj => $key)
{
    if($obj=="x_axis")
        $column_data=$key;

    if($obj=="y_axis")
        $header_data=$key;

    if($obj=="results")
        $results_obj=$key;
	
}
    //echo json_encode($results_obj);

//echo "<pre>";
    //print_r($results_obj);
    //echo "<br>Header:<br>";
    //print_r($header);
    //echo "<br>Header:<br>";
    //print_r($headers);
    //echo "<br>x_axis:<br>";
    //print_r($column_data);
    //echo "<br>y_axis:<br>";
    //print_r($header_data);
//echo "</pre>";
//die();
$ColumnName="";
$display_value="";
if(empty($results_obj))
{
@endphp
<div class="alert alert-arrow-right alert-icon-right alert-light-success mb-4" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><svg xmlns="http://www.w3.org/2000/svg" data-dismiss="alert" 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 close"><line x1="18" y1="6" x2="6" y2="18"></line><line x1="6" y1="6" x2="18" y2="18"></line></svg></button>
<svg 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-alert-circle"><circle cx="12" cy="12" r="10"></circle><line x1="12" y1="8" x2="12" y2="12"></line><line x1="12" y1="16" x2="12" y2="16"></line></svg>
<!-- <strong>Not Available!</strong> -->
You may try different filters!
</div>
@php
}
//else
{
foreach($column_data as $head)
{
    foreach($head as $display_data=>$display_key)
    {
        //echo "$display_data";
        @endphp

        <div class="widget-content widget-content-area">
            <!-- <div class="toggle-list"> -->
                @php
                /*
                    foreach($header_data as $heads)
                    {
                        foreach($heads as $display_datah=>$display_keyh)
                        {
                            $i=0;
                            foreach($display_keyh as $display_recordh)
                            {
                                $HeaderName=$display_recordh->ColumnName;
                                if($HeaderName!="")
                                {
                                    $results_dd = multiKeyExists($GetDropdownLists, $HeaderName);
                                    if(is_array($results_dd) && array_key_exists($HeaderName,$results_dd[0]))
                                        $display_value=$results_dd[0][$HeaderName];
                                    else
                                        $display_value="";
                                    @endphp
                                    <!-- <a class="btn toggle-vis mb-4 ml-2" data-column="{{$i}}">{{$display_value}}</a> -->
                                    @php
                                    $i++;
                                }
                            } 
                        }
                    }
                */
                @endphp
            <!-- </div> -->

        <div class="table-responsive">
        <table class="table table-bordered table-hover table-striped mb-4" role="grid">
        <thead>
            <tr>
                <th>{{$display_data}}</th>

                    @php
					$display_datah="";
                    $column_header=array();
					if(count($header_data) != 0)
					{
						 foreach($header_data as $heads)
						{
							foreach($heads as $display_datah=>$display_keyh)
							{
								foreach($display_keyh as $display_recordh)
								{
									$HeaderName=$display_recordh->ColumnName;

									if($HeaderName!="")
									{
										$results_dd = multiKeyExists($GetDropdownLists, $HeaderName);

								

										if(is_array($results_dd) && array_key_exists($HeaderName,$results_dd[0]))
											$display_value=$results_dd[0][$HeaderName];
										else if(array_key_exists($HeaderName,$AssignedToList))
												$display_value=$AssignedToList[$HeaderName]['name'];
										else
											$display_value="$HeaderName";

										array_push($column_header,$display_value);
										@endphp
										<th title="{{$HeaderName}}">{{$display_value}}</th>
										@php
									}
								} 
							}
						}
					}
                   
                    @endphp

                <th title="Total {{$display_datah}}">Total</th>
            </tr>
        </thead>
        <tbody>
        @php

        $row_count=array();
		$column_count=array();
        $TotalCount=array();
        foreach($display_key as $display_record)
        {
            $ColumnName=$display_record->ColumnName;
            if($ColumnName!="")
            {
                $results_dd = multiKeyExists($GetDropdownLists, $ColumnName);

                if(is_array($results_dd) && array_key_exists($ColumnName,$results_dd[0]))
                    $display_values=$results_dd[0][$ColumnName];
                else if(array_key_exists($ColumnName,$AssignedToList))
                        $display_values=$AssignedToList[$ColumnName]['name'];
                else
                    $display_values="$ColumnName";

                @endphp
                <tr>
                <th title="{{$ColumnName}}" class="text-primary">{{$display_values}}</th>

                    @php
                    $count=0;
                    $total_count=0;
                    $RowHeader=array();
                    foreach($header_data as $heads)
                    {
                        foreach($heads as $display_datah=>$display_keyh)
                        {
                            foreach($display_keyh as $display_recordh)
                            {
                                $HeaderName=$display_recordh->ColumnName;
                                    // get data from results_obj

                                        // on 11th Dec
                                //$RowHeader=$results_obj[$ColumnName];

                                if(array_key_exists($ColumnName,$results_obj))
                                    $RowHeader=$results_obj[$ColumnName];
                                else
                                    $RowHeader[]=$display_values; // 11th Dec 

                                if(array_key_exists($HeaderName,$RowHeader))
                                {
                                    if(is_numeric($RowHeader[$HeaderName]))
                                        $count=$RowHeader[$HeaderName];
                                    else
                                        $count=0;   // on 14th Dec '21
                                }
                                else
                                {
                                    $count=0;
                                }

                                if($HeaderName!="")
                                {
                                    $results_dd = multiKeyExists($GetDropdownLists, $HeaderName);
                                    if(is_array($results_dd) && array_key_exists($HeaderName,$results_dd[0]))
                                        $display_value=$results_dd[0][$HeaderName];
                                    else if(array_key_exists($HeaderName,$AssignedToList))
                                            $display_value=$AssignedToList[$HeaderName]['name'];
                                    else
                                        $display_value="$HeaderName";

                                    @endphp
                                    <th title="{{$display_values}} - {{$display_value}} | {{$HeaderName}} / {{$count}}">{{$count}}</th>
                                    @php
									if(array_key_exists($display_value,$column_count))
									{
										$column_count[$display_value]=$column_count[$display_value]+$count;
									}
									else
									{
										$column_count[$display_value]=$count;
									}
                                    $total_count=$total_count+$count;
                                }

                                if(in_array($display_value,$column_header))
                                {
                                    $row_count[$display_value][]=$count;
                                }
                            }
                        }
                    }
                    @endphp

                <th title="{{$ColumnName}}" class="text-primary">{{$total_count}}</th>
                </tr>
                @php
            }
        }
        @endphp
            <tr>
                <th></th>
                @php
                    $array_sum=0;
                    foreach($column_header as $ch)
                    {
                        @endphp
                        <th title="Total: {{$ch}}"  class="text-primary">{{$column_count[$ch]}}</th>
                        @php
                    }
                @endphp
            </tr>   
        </tbody>
        </table>
        </div>
        @php
    }
}
}
@endphp
<!--     <div class="widget-content widget-content-area text-center">
        <span class="badge outline-badge-info"></span>
    </div> -->
@php
function multiKeyExists(array $arr, $key) {
        
        // is in base array?
    if (array_key_exists($key, $arr)) {
        $results[] = $arr;
        return $results;
    }

    // check arrays contained in this array
    foreach ($arr as $element) {
        if (is_array($element)) {
            if (multiKeyExists($element, $key)) {
                //return true;
                $results[] = $element;
                return $results;
            }
        }
        
    }

    return false;
}

@endphp
<!-- Modal -->
<div class="modal fade" id="exampleModal" 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>
            <div class="modal-footer">
                <button class="btn" data-dismiss="modal"><i class="flaticon-cancel-12"></i> Discard</button>
                <!-- <button type="button" class="btn btn-primary">Save</button> -->
            </div>
        </div>
    </div>
</div>