@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; $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; } @endphp
select all