@php use App\Models\Demography; $results_obj = json_decode($results); $ReferenceField = NULL; // Added by sharath on 4 th May 2022 echo "
";
	//print_r($header);
	//print_r($results_obj);
	//print_r($headers);
	//print_r($fromMailAddress);
	//print_r($DropDownColors);
	//print_r($RelatedModules);
	//print_r($AssignedByCreatedByResults);
	//print_r($GetDropdownLists);
	//print_r($RelateModules);
	//print_r($ModulesAccess);
	//print_r($userRoles);
echo "
"; try { $loggedinUser=Auth::user()->RefId; $IsAdmin=Auth::user()->IsAdmin; $UserPhoneNo=Auth::user()->PhoneNo; } catch(\Exception $e) { $loggedinUser=1; $UserPhoneNo=""; } $userPrimaryRole=""; foreach($userRoles as $URole) { if($URole['PrimaryRole']=="1") { $userPrimaryRole=$URole['RoleID']; } } //if($loggedinUser==1) //{ echo "
";
		// print_r($results_obj);
		// print_r($header);
		//print_r($tempFiles);
		//print_r($headers);
		//print_r($GetDropdownLists);
		//print_r($ListBoxNamesIDs);
	echo "
"; //} $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; $condition1=""; $conditionValue1=""; $condition2=""; $conditionValue2=""; if($mode==6) { $condition1=$DrillDownCondition[0]->name; $conditionValue1=$DrillDownCondition[0]->value; $condition2=$DrillDownCondition[1]->name; $conditionValue2=$DrillDownCondition[1]->value; } // 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']; } } $start_from = ($page_num-1)*$limit; $sno=$start_from+1; //print_r($headers); $siteurl=$_SERVER['HTTP_HOST']; $url=explode(".",$siteurl); $InstanceName=$url[0]; @endphp
@php if(!empty($results_obj)) { @endphp @php echo ""; foreach($results_obj as $name => $values) { //print_r($values); $modulesIdValues=end($values); $FetchRowId=''; if(array_key_exists($loopcount,$RowIds)) { $FetchRowId=$RowIds[$loopcount]; } @endphp @php if($serialno=="1") { echo ""; } //echo ""; if($mode=="RelatedSearch" || $mode=="RelatedSearchinSearch") { @endphp @php } $loopcount++; $row_count=0; foreach ($values as $k => $v) { $InLineRowId=end($values); $columns[$k] = $k; if($row_count==$total_count) { if($mode!=="RelatedSearch" && $mode!=="RelatedReminderSearch" && $mode!=="4") { $pass_array=array("ModuleId"=>$ModuleId,"RowId"=>"$v"); $pass_arrayBigDaddy=array("RowId"=>"$v"); @endphp @if($RoleAccess_m!="8eca7f5f-9914-11eb-948a-56b1773fd56f") @endif @php } else { if($mode=="RelatedReminderSearch") { @endphp @php } } } else { $display_value=$v; $display_type=""; $display_name=""; if(array_key_exists($display_value,$DropDownColors)) { $displayColor=$DropDownColors[$display_value]; } else { $displayColor="#888ea8"; } //echo "display value=".$display_value."
"; 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 || $display_type==26) { $display_value=Demography::GetDisplayValue($ModuleId,$field_name,$v); } 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==6 && !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($OtherModuleFieldValues) && array_key_exists($v,$OtherModuleFieldValues)) { // for RelateTo //$display_value=$RelateModules[$v];//instead of PAssing the Id kabali is Passing the Name of the Relate Module field //$newFieldName=$field_name; //$NewRowId=$v; $display_value=$OtherModuleFieldValues[$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_type==32 || $display_type==33) && $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(($display_type==37) && $display_value!="") { if($display_value) { $ExplodedValue=explode(':',$display_value); if($ExplodedValue[0]) { $aa=$ExplodedValue[0]; } if($ExplodedValue[1]) { $bb=$ExplodedValue[1]; } $display_value=$aa." hours ".$bb." Min"; } } if(($display_type==38) && $display_value!="") { $display_value=date('h:i A',strtotime($display_value)); } /*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 @php } elseif($display_type==9) { if(array_key_exists($display_value,$tempFiles)) { @endphp @php } else { echo ""; } } elseif($display_type==20) { $click_to_call=base64_encode($display_value); $FetchRowIdTemp=""; if(array_key_exists($name,$RowIds)) { $FetchRowIdTemp=$RowIds[$name]; } @endphp @php } elseif($display_type==29) { @endphp @php } elseif($display_type==30) { @endphp @php } elseif($display_type==35) { @endphp @if($_SERVER['HTTP_HOST']=="trainingt.bpm360.net" || $_SERVER['HTTP_HOST']=="training.bpm360.net") @else @endif @php } else { if($ReferenceField==0) { echo ""; } else { $pass_array=array("ModuleId"=>$ModuleId,"RowId"=>"$InLineRowId"); //$pass_array=$ModuleId."/".$InLineRowId; //$pass_array=url_encode($pass_array); $displayColor="blue"; @endphp @php } } } $row_count++; $temp_count++; } echo ""; $sno++; } $row_count=0; echo ""; echo ""; echo ""; $RefLoop=0; if($serialno=="1") { echo ""; } 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") { @endphp @php } } 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; if($serialno=="1") { echo ""; } 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
    $sno$name
    "; foreach($EmailValuesArray[$display_value] as $email) { $rowidLoopCount=$loopcount-1; $Emails.="
  • $email
  • "; @endphp @php } //echo "
    {{$display_value}} $display_value {{$display_value}}
    {{$display_value}} @php $mcubeApiKey="f155247a2c1d343e0d3edeecfe4108bf";//for crm @endphp {{$display_value}} $display_value {{$display_value}}
    S.NolinkAction Select @php echo $DisplayName @endphp
    S.NoLinkAction
    @php } // end of results_obj validation, added on 26th Aug '21 @endphp
    @php $MassupdateRole=array(); $ReAssignRole=array(); if(array_key_exists('Roles',$GetMassupdateButtonAccess)) { $MassupdateRole=$GetMassupdateButtonAccess['Roles']; $ReAssignRole=$GetMassupdateButtonAccess['ReAssignRole']; } if($MassupdateRole==NULL) { $MassupdateRole=array(); $ReAssignRole=array(); } $MassUpdateAccessForRoles=["2fe5483f-00de-4741-a419-82763560e80b","bbc3b105-8219-4839-a956-1a72ee035ba0","b61c54fb-0ea6-47e2-b2f3-0f65dba41e98","bada407f-3a53-4c18-b7d6-d47065fc5297","2fe5483f-00de-4741-a419-82763560e80b","de9fb832-3a80-42b0-9446-53a291084b1e","fde6d535-4efb-496c-98ec-27b0e5ecec7a","3b618f7b-21ee-4f36-8692-302aa7116972","87002040-180b-4bfb-85d4-1d770262bace"]; @endphp
    @if(empty($columns)) @php foreach($headers as $fieldList) { echo ""; } @endphp
    ".$DisplayName=$fieldList['DisplayName']."
    @endif
    Total {{$total_records}} records

    @if($mode!=6 && $mode!='RelatedSearchinSearch') @if($mode!='RelatedSearchinSearch' )
    @endif @elseif($mode==6)
    @endif @if($mode=='RelatedSearchinSearch')
    @endif