@php
$results_obj = json_decode($results);
if($mode=='Auto')
{
$field_name=$header[0];
$sort_order="DESC";
}
echo "
";
//print_r($headers);
//print_r($AssignedToList);
echo "
";
//echo "
";
//print_r($results_obj);
//print_r($GetDropdownLists);
//print_r($selfRelatedList);
$total_counts=count($header);
$RowIds=array();
foreach($results_obj as $name => $values) {
$row_count=0;
foreach ($values as $k => $v) {
if($row_count==$total_counts)
{
$RowIds[]=$v;
}
$row_count++;
}
}
$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;
@endphp
@php
if(!empty($results_obj))
{
@endphp
@php
echo "";
foreach($results_obj as $name => $values) {
$modulesIdValues=end($values);
echo "";
@endphp
@php
$loopcount++;
echo "| $loopcount | ";
//echo "$name | ";
$row_count=0;
foreach ($values as $k => $v) {
$columns[$k] = $k;
if($row_count==$total_count)
{
if($mode!=="RelatedSearch")
{
$pass_array=array("ModuleId"=>$ModuleId,"RowId"=>"$v");
@endphp
@php
}
}
else
{
$display_value=$v;
$display_name="";
foreach($headers as $field_list)
{
$field_name=$field_list['FieldName'];
$DropDownNameId=$field_list['DropDownNameId'];
if($field_name==$k)
{
$ReferenceField=$field_list['ReferenceField'];
$display_name=$field_list['DisplayName'];
$display_type=$field_list['DisplayType'];
if($display_type==2 && !empty($ListBoxNamesIDs))
{
//$display_value=$GetDropdownLists[$v];
$ListBoxNamesIDVal=$DropDownNameId;
$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];
if(array_key_exists($ListBoxNamesIDVal,$GetDropdownLists))
{
$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];
if(array_key_exists($display_value,$listBoxVal))
$display_value=$listBoxVal[$display_value];
}
}
if($display_type==3 && !empty($ListBoxNamesIDs))
{
$display_value="";
if($v!="")
{
$ListBoxNamesIDVal=$DropDownNameId;
//$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name];
$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];
$listArray=explode(",",$v);
foreach($listArray as $listVal)
{
if(!array_key_exists($listVal,$listBoxVal))
{
$display_value=$listVal;
}
else
{
$display_value.="".$listBoxVal[$listVal]."";
}
}
}
}
if( ($display_type==5 && !empty($ListBoxNamesIDs)) && $DropDownNameId!='')
{
$ListBoxNamesIDVal=$DropDownNameId;
$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];
foreach($listBoxVal as $listBoxKey=>$listBoxValue)
{
if($listBoxKey==$v)
$display_value=$listBoxValue;
}
}
if($display_type==25)
{
if(!array_key_exists($display_value,$selfRelatedList))
{
foreach($selfRelatedList as $selfRelated)
{
if($display_value==$selfRelated['key'])
{
$display_value=$selfRelated['value'];
}
}
}
}
if($display_type==4 && $DateFormat!="" && $v!="")
{
if($v=="0000-00-00")
{
$display_value="";
}
else
{
$display_value = date("$DateFormat", strtotime($v));
}
}
if($display_type==14 && $DateFormat!="" && $v!="")
{
if($v=="0000-00-00 00:00:00")
{
$display_value="";
}
else
{
$datetime = new DateTime($v);
$datetime->format("$DateFormat $TimeFormat");
$la_time = new DateTimeZone($TimeZone);
$datetime->setTimezone($la_time);
$display_value = $datetime->format("$DateFormat $TimeFormat");
}
}
if($display_type==8 && $v!="" && !empty($RelateModules) && array_key_exists($v,$RelateModules))
{
// for RelateTo
$display_value=$RelateModules[$v];
}
if($display_type==23 && $v!="" && !empty($RelateModules) && array_key_exists($v,$RelateModules))
{
// for Dependent_RelateTo
$display_value=$RelateModules[$v];
}
if($display_type==15 && $display_value!="")
{
// for AssignedTo
if(array_key_exists($v,$AssignedToList))
{
$display_value=$AssignedToList[$v]['name'];
}
else
{
$display_value=$v;
}
}
if(($display_type==9||$display_type==9) && $display_value!="")
{
// for AssignedTo
$display_value1="";
@endphp
@php
$display_value=$display_value1;
}
if($display_type==12)
{
$display_value=$display_value;
if(!empty($EmailValuesArray))
{
if(array_key_exists($display_value,$EmailValuesArray))
{
$Emails='';
foreach($EmailValuesArray[$display_value] as $email)
{
$Emails.=" $email";
}
$display_value=$Emails;
}
}
}
if($display_type==21)
{
// for Click2Call_Masking
$display_name.=" is masked";
//$display_value="XXXX-XXX-XXX";
$display_value="xxxx-xxx-xxx";
}
if($display_type==22)
{
// for Masked, on 24th Aug '21
$display_name.=" is masked";
$display_value="|*_*|";
}
}
}
echo "$display_value | ";
}
$row_count++;
}
echo "
";
}
$row_count=0;
echo "";
echo "";
echo "";
echo "| Sl.No | ";
foreach ($columns as $column) {
if($row_count==$total_count)
{
// Action
}
else
{
$sorting_css='';
$title='ascending';
if($column==$field_name && $sort_order=="DESC")
{
$sorting_css='sorting_asc';
$title='descending';
}
else
{
$sorting_css='sorting_desc';
//$title='ascending';
}
$DisplayName=$column;
foreach($headers as $fieldList)
{
$FieldName=$fieldList['FieldName'];
if($FieldName==$column)
{
$DisplayName=$fieldList['DisplayName'];
$DisplayType=$fieldList['DisplayType'];
}
}
@endphp
|
@php
}
$row_count++;
}
echo "
";
echo "";
@endphp
@php
} // end of results_obj validation
@endphp
@if(empty($columns))
@php
foreach($headers as $fieldList)
{
echo "| ".$DisplayName=$fieldList['DisplayName']." | ";
}
@endphp
Not Available!
@endif