/** * @param $pageNumber int * @param $pageSize int * @param $filter ReservationFilter * @param $user UserSession * @return PageableData|ReservationItemView[] */ public function LoadFiltered($pageNumber, $pageSize, $filter, $user) { $groupIds = array(); $groups = $this->userRepository->LoadGroups($user->UserId, RoleLevel::RESOURCE_ADMIN); foreach ($groups as $group) { $groupIds[] = $group->GroupId; } $filter->_And(new SqlFilterIn(new SqlFilterColumn(TableNames::RESOURCES, ColumnNames::RESOURCE_ADMIN_GROUP_ID), $groupIds)); return $this->reservationViewRepository->GetList($pageNumber, $pageSize, null, null, $filter->GetFilter()); }
public function GetList($pageNumber, $pageSize, $sortField = null, $sortDirection = null, $filter = null) { if (!$this->user->IsAdmin) { $scheduleAdminGroupIds = array(); $resourceAdminGroupIds = array(); $groups = $this->repo->LoadGroups($this->user->UserId, array(RoleLevel::SCHEDULE_ADMIN, RoleLevel::RESOURCE_ADMIN)); foreach ($groups as $group) { if ($group->IsResourceAdmin) { $resourceAdminGroupIds[] = $group->GroupId; } if ($group->IsScheduleAdmin) { $scheduleAdminGroupIds[] = $group->GroupId; } } if ($filter == null) { $filter = new SqlFilterNull(); } $additionalFilter = new SqlFilterIn(new SqlFilterColumn(TableNames::SCHEDULES_ALIAS, ColumnNames::SCHEDULE_ADMIN_GROUP_ID), $scheduleAdminGroupIds); $filter->_And($additionalFilter->_Or(new SqlFilterIn(new SqlFilterColumn(TableNames::RESOURCES_ALIAS, ColumnNames::RESOURCE_ADMIN_GROUP_ID), $resourceAdminGroupIds))); } return parent::GetList($pageNumber, $pageSize, $sortField, $sortDirection, $filter); }
/** * @param int $pageNumber * @param int $pageSize * @param BlackoutFilter $filter * @param UserSession $user * @return BlackoutItemView[]|PageableData */ public function LoadFiltered($pageNumber, $pageSize, $filter, $user) { $blackoutFilter = $filter->GetFilter(); if (!$user->IsAdmin) { $groups = $this->userRepository->LoadGroups($user->UserId, array(RoleLevel::RESOURCE_ADMIN, RoleLevel::SCHEDULE_ADMIN)); $groupIds = array(); foreach ($groups as $group) { $groupIds[] = $group->GroupId; } $adminFilter = new SqlFilterIn(new SqlFilterColumn('r', ColumnNames::RESOURCE_ADMIN_GROUP_ID), $groupIds); $adminFilter->_Or(new SqlFilterIn(new SqlFilterColumn(TableNames::SCHEDULES, ColumnNames::SCHEDULE_ADMIN_GROUP_ID), $groupIds)); $blackoutFilter->_And($adminFilter); } return $this->reservationViewRepository->GetBlackoutList($pageNumber, $pageSize, null, null, $blackoutFilter); }