@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 ""; //echo ""; $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 ""; } $row_count++; } echo ""; } $row_count=0; echo ""; echo ""; echo ""; echo ""; 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
    $loopcount$name$display_value
    Sl.No
    @php } // end of results_obj validation @endphp @if(empty($columns)) @php foreach($headers as $fieldList) { echo ""; } @endphp
    ".$DisplayName=$fieldList['DisplayName']."
    @endif