@php $results_obj = json_decode($results); //echo "kabali"; //echo "
";
	//print_r($header);
	//print_r($results_obj);
	//print_r($headers);
	//print_r($fromMailAddress);
	
//echo "
"; try { $loggedinUser=Auth::user()->RefId; } catch(\Exception $e) { $loggedinUser=1; } //if($loggedinUser==1) //{ //echo "
";
	//print_r($results_obj);
	//print_r($tempFiles);
	//print_r($headers);
	//print_r($GetDropdownLists);
	//print_r($ListBoxNamesIDs);
//echo "
"; //} $InLineArray=array(); if($mode=='Auto') { $field_name=$header[0]; $sort_order="DESC"; } $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++; } } // added on 28th April '21 $userdetails = Auth::user(); try { $LoggedUser = $userdetails->name; $DateFormat = $userdetails->DateFormat; $TimeZone = $userdetails->TimeZone; $TimeFormat = $userdetails->TimeFormat; $GmtOffSet = $userdetails->GmtOffSet; } catch(\Exception $e) { $LoggedUser="Super Admin"; $DateFormat="d-m-Y"; $TimeZone="Asia/Kolkata"; $TimeFormat="H:i"; $GmtOffSet=""; } $total_count=count($header); $temp_count=$page_num; $columns = array(); $loopcount=0; // added on 20th Oct '21 $RoleAccess_c="1264d300-9915-11eb-948a-56b1773fd56f"; // None 8eca7f5f-9914-11eb-948a-56b1773fd56f $RoleAccess_l="1264d300-9915-11eb-948a-56b1773fd56f"; // All $RoleAccess_e="1264d300-9915-11eb-948a-56b1773fd56f"; // All $RoleAccess_d="1264d300-9915-11eb-948a-56b1773fd56f"; // All $RoleAccess_r="1264d300-9915-11eb-948a-56b1773fd56f"; // All $RoleAccess_m="1264d300-9915-11eb-948a-56b1773fd56f"; // All if(!empty($ModulesAccess)) { //print_r($ModulesAccess); foreach($ModulesAccess['Actions'] as $ActionName) { if($ActionName['ActionName']=="Create") $RoleAccess_c=$ActionName['RoleAccess']; if($ActionName['ActionName']=="List") $RoleAccess_l=$ActionName['RoleAccess']; if($ActionName['ActionName']=="Edit") $RoleAccess_e=$ActionName['RoleAccess']; if($ActionName['ActionName']=="Delete") $RoleAccess_r=$ActionName['RoleAccess']; if($ActionName['ActionName']=="Detail") $RoleAccess_d=$ActionName['RoleAccess']; if($ActionName['ActionName']=="Mass Update") $RoleAccess_m=$ActionName['RoleAccess']; } } //print_r($headers); @endphp
@php // added on 26th Aug '21 if(!empty($results_obj)) { @endphp @php echo ""; foreach($results_obj as $name => $values) { //print_r($values); $modulesIdValues=end($values); echo ""; //echo ""; if($mode=="RelatedSearch") { @endphp @php } $loopcount++; $row_count=0; //print_r($values); foreach ($values as $k => $v) { $InLineRowId=end($values); $columns[$k] = $k; if($row_count==$total_count) { if($mode!=="RelatedSearch" && $mode!=="RelatedReminderSearch") { $pass_array=array("ModuleId"=>$ModuleId,"RowId"=>"$v"); //print_r($pass_array); @endphp @if($RoleAccess_e!="8eca7f5f-9914-11eb-948a-56b1773fd56f") @endif @if($RoleAccess_d!="8eca7f5f-9914-11eb-948a-56b1773fd56f") @endif @if($RoleAccess_r!="8eca7f5f-9914-11eb-948a-56b1773fd56f") @endif @if($RoleAccess_m!="8eca7f5f-9914-11eb-948a-56b1773fd56f") @endif @php } else { if($mode=="RelatedReminderSearch") { @endphp @php } } } else { $display_value=$v; $display_type=""; $display_name=""; foreach($headers as $field_list) { $field_name=$field_list['FieldName']; $DropDownNameId=$field_list['DropDownNameId']; $DemographyConfigId=$field_list['DemographyConfigId']; $InLineEdit=$field_list['InLineEdit']; $InLineArray[$DemographyConfigId]=$InLineEdit; if($field_name==$k) { $ReferenceField=$field_list['ReferenceField']; $display_name=$field_list['DisplayName']; $display_type=$field_list['DisplayType']; $DemographyConfigIdN=$field_list['DemographyConfigId']; if($display_type==8) { $ParentModuleId=$field_list['ParentModuleId']; } if( ($display_type==2 || $display_type==26 && !empty($ListBoxNamesIDs)) && $DropDownNameId!='') { //$display_value=$GetDropdownLists[$v]; $ListBoxNamesIDVal=$DropDownNameId; //$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name]; $listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal]; //$display_value=$listBoxVal[$v]; foreach($listBoxVal as $listBoxKey=>$listBoxValue) { if($listBoxKey==$v) $display_value=$listBoxValue; // else // $display_value=""; } } if( ($display_type==5 && !empty($ListBoxNamesIDs)) && $DropDownNameId!='') { //$display_value=$GetDropdownLists[$v]; $ListBoxNamesIDVal=$DropDownNameId; //$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name]; $listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal]; //$display_value=$listBoxVal[$v]; foreach($listBoxVal as $listBoxKey=>$listBoxValue) { if($listBoxKey==$v) $display_value=$listBoxValue; // else // $display_value=""; } } if($display_type==3 && !empty($ListBoxNamesIDs) && $DropDownNameId!='') { $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==4 && $DateFormat!="" && $v!="") { if($v=="0000-00-00 00:00:00" || $v==0000-00-00 || $v=="0000-00-00") { // added on 16th Sept '21 $display_value=""; } else { // added on 28th April '21 $display_value = date("$DateFormat", strtotime($v)); } } elseif($display_type==4 && $v=="0000-00-00") { $display_value=""; } if($display_type==14 && $DateFormat!="" && $v!="") { // added on 29th April '21 //$display_value = date("$DateFormat $TimeFormat", strtotime($v)); if($v=="0000-00-00 00:00:00" || $v=="0000-00-00") { // added on 16th Sept '21 $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"); } } $NewRowId=$v; $newFieldName=$field_name; if($display_type==8 && $v!="" && !empty($RelateModules) && array_key_exists($v,$RelateModules)) { // for RelateTo $display_value=$RelateModules[$v]; $newFieldName=$field_name; $NewRowId=$v; } if($display_type==25 && !empty($selfRelatedList)) { // for SelefRelateTo foreach($selfRelatedList as $SelfRelate) { if($SelfRelate["key"]==$v) { $display_value=$SelfRelate["value"]; } } } if($display_type==23) { if(array_key_exists($v,$getChildDependentRelateToList)) { $display_value=$getChildDependentRelateToList[$v]; } else { $display_value=$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==16) && $display_value!="") { // for AssignedTo //$display_value=$display_value; $display_value1=""; @endphp @php $display_value=$display_value1; } /*if($ReferenceField==1) // && $mode=='Auto' { $MyRowId=$RowIds[$name]; $PassArray=array("ModuleId"=>$ModuleId,"RowId"=>$RowIds[$name]); //print_r($PassArray); $pass_me=json_encode($PassArray); if($mode=="RelatedReminderSearch") { $PassArray=array("ModuleId"=>$ModuleId,"RowId"=>$RowIds[$name],"DisplayName"=>$display_value); $pass_me=json_encode($PassArray); $display_value= "$display_value"; } elseif($mode=="RelatedSearch") { $PassArray=array("ModuleId"=>$ModuleId,"RowId"=>$RowIds[$name],"DisplayName"=>$display_value); $pass_me=json_encode($PassArray); $display_value="$display_value"; } else { $display_value="".$display_value.""; } }*/ 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="|*_*|"; } if($display_type==12) { $display_value=$display_value; if(!empty($EmailValuesArray)) { if(array_key_exists($display_value,$EmailValuesArray)) { //$display_value=implode(",",$EmailValuesArray[$display_value]); $Emails=''; //echo ""; $display_value=$Emails; } } } } } if($display_type==8) { @endphp @if($InLineArray[$DemographyConfigIdN]=='1') @else @endif @php } elseif($display_type==9) { if(array_key_exists($display_value,$tempFiles)) { @endphp @php } else { @endphp @php } } else { @endphp @php } } $row_count++; $temp_count++; } echo ""; } $row_count=0; echo ""; echo ""; echo ""; $RefLoop=0; foreach ($columns as $column) { $RefLoop++; //$column=$fieldList['FieldName']; //$DisplayName=$fieldList['DisplayName']; if($mode=="RelatedSearch" && $RefLoop=="1" ) { echo ""; } if($row_count==$total_count) { if($mode!=="RelatedSearch" && $mode!=="RelatedReminderSearch") { echo ""; if($RoleAccess_m!="8eca7f5f-9914-11eb-948a-56b1773fd56f") { echo ""; } } else { if($mode=="RelatedReminderSearch") { echo ""; } } } 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'; } // newly added on 22nd April '21 $DisplayName=$column; foreach($headers as $fieldList) { $FieldName=$fieldList['FieldName']; if($FieldName==$column) { $DisplayName=$fieldList['DisplayName']; $DisplayType=$fieldList['DisplayType']; } } @endphp @php } $row_count++; } echo ""; echo ""; $row_count=0; echo ""; echo ""; $massupdatecol=1; if($massupdatecol==1) { $massupdatecol="0"; } $fcount=0; foreach ($columns as $column) { $fcount++; if($fcount==1 && $mode=="RelatedSearch") { echo ""; } if($row_count==$total_count) { if($mode!=="RelatedSearch" && $mode!=="RelatedReminderSearch") { echo ""; } } else { // newly added on 22nd April '21 $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
    $name
    "; foreach($EmailValuesArray[$display_value] as $email) { $Emails.="
  • $email
  • "; @endphp @php } //echo "

    {{$display_value}}
    @if($InLineArray[$DemographyConfigIdN]=='1') @if($display_value=="")
    @else
    {{$display_value}}
    @endif
    @else {{$display_value}} @endif
    linkAction". '' ."Select{{$DisplayName}}
    LinkAction{{$DisplayName}}
    @php } // end of results_obj validation, added on 26th Aug '21 @endphp
    @if(empty($columns)) @php foreach($headers as $fieldList) { echo ""; } @endphp
    ".$DisplayName=$fieldList['DisplayName']."
    @endif
    Total {{$total_records}} records