@php $TeamsDataArray = DB::table('TmTeams')->where('ActiveStatus', '=', '1')->get(['TmTeamID', 'TeamName']); $roles_array = DB::table('UserRoles')->where('ActiveStatus', '=', '1')->get(['RoleId', 'RoleName']); $Field=DB::table('DemographyConfig')->where('DemographyConfigId',$demographyconfigId)->get()->first(); $DisplayName=$Field->LabelValue; $ColumnName=$Field->ColumnName; $DropDownNameId=$Field->DropDownNameId; $DependentField=$Field->DependentField; $ModuleId=$Field->ModuleId; $UserConditionArray['1']='All user'; $UserConditionArray['2']='Role Based User'; $UserConditionArray['3']='Team Based User'; $UserConditionArray['4']='Role and Team Based User'; $checktext=""; $UserCondition=""; $UserDisplay="display:none;"; $TeamDisplay="display:none;"; $RoleDisplay="display:none;"; $UserSavedArray=array(); $TeamSavedArray=array(); $RoleSavedArray=array(); $temparray = array(); $TeamsArray = array(); foreach ($TeamsDataArray as $Team) { $TeamsArray[$Team->TmTeamID] = $Team->TeamName; } $RolesArray = array(); foreach ($roles_array as $role) { $RolesArray[$role->RoleId] = $role->RoleName; } if(array_key_exists($demographyconfigId,$valueforhold)) { $temparray=$valueforhold[$demographyconfigId]; } if(!empty($temparray)) { $UserCondition=$temparray->UserCondition; $UserSavedArray=json_decode($temparray->User); $TeamSavedArray=json_decode($temparray->Team); $RoleSavedArray=json_decode($temparray->Role); $checktext="checked"; if($UserCondition==1) { $UserDisplay="display:block;"; } elseif($UserCondition==2) { $RoleDisplay="display:block;"; } elseif($UserCondition==3) { $TeamDisplay="display:block;"; } elseif($UserCondition==4) { $TeamDisplay="display:block;"; $RoleDisplay="display:block;"; } } @endphp

select all