@php
// on 29th Nov '21, for ReportType==6, updated on 3rd & 4th Dec '21
// updated on 11th with Date
// updated on 13th with AssignedToList
$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;
}
if($_SERVER['REMOTE_ADDR']=='49.205.146.66')
{
//echo json_encode($results_obj);
echo "";
// print_r($results);
// print_r($results_obj);
// echo "
Header:
";
//print_r($header);
// echo "
Header:
";
// print_r($headers);
// echo "
x_axis:
";
//print_r($column_data);
//echo "
y_axis:
";
//print_r($header_data);
echo "
";
}
$ColumnName="";
$display_value="";
if(empty($results_obj))
{
@endphp
Not Available!
Try using different filter...
@php
}
else
{
foreach($column_data as $head)
{
foreach($head as $display_data=>$display_key)
{
@endphp
| {{$display_data}} |
@php
$column_header=array();
foreach($header_data as $heads)
{
foreach($heads as $display_datah=>$display_keyh)
{
$display_datahk=$display_datah;
foreach($display_keyh as $display_recordh)
{
$HeaderName=$display_recordh->ColumnName;
if($HeaderName!="")
{
if(multiKeyExists($GetDropdownLists, $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);
$column_header[$HeaderName]=$display_value;
$ColumnNameArray[$HeaderName]=$display_datah;
}
else
{
$display_value=$HeaderName;
//array_push($column_header,$display_value);
}
@endphp
{{$display_value}} |
@php
}
}
}
}
@endphp
Total |
@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"; // on 11th Dec '21
@endphp
| {{$display_values}} |
@php
$count=0;
$total_count=0;
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
// commented on 11th Dec
//$RowHeader=$results_obj[$ColumnName];
if(array_key_exists($ColumnName,$results_obj))
$RowHeader=$results_obj[$ColumnName];
else
$RowHeader[]=$display_values;
if(array_key_exists($HeaderName,$RowHeader))
{
if(is_numeric($RowHeader[$HeaderName]))
$count=$RowHeader[$HeaderName];
else
$count=0;
}
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']; // on 13th Dec '21
else
$display_value="$HeaderName"; // on 11th Dec '21
@endphp
{{$count}} |
@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;
//$row_count[$display_value][]=$total_count;
}
}
}
}
if(array_key_exists('Total',$TotalCount))
{
$TotalCount['Total']=$TotalCount['Total']+$total_count;
}
else
{
$TotalCount['Total']=$total_count;
}
@endphp
{{$total_count}} |
@php
}
}
@endphp
|
@php
$array_sum=0;
foreach($column_header as $chKey=>$ch)
{
$TempColumnName=$ColumnNameArray[$chKey];
@endphp
{{$column_count[$ch]}} |
@php
}
@endphp
{{$TotalCount['Total']}} |
@php
}
}
}
@endphp
@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