public function PageLoad() { if ($this->page->GetGroupId() != null) { $groupList = $this->groupRepository->GetList(1, 1, null, null, new SqlFilterEquals(new SqlFilterColumn(TableNames::GROUPS_ALIAS, ColumnNames::GROUP_ID), $this->page->GetGroupId())); } else { $groupList = $this->groupRepository->GetList($this->page->GetPageNumber(), $this->page->GetPageSize()); } $this->page->BindGroups($groupList->Results()); $this->page->BindPageInfo($groupList->PageInfo()); $this->page->BindResources($this->resourceRepository->GetResourceList()); $this->page->BindRoles(array(new RoleDto(1, 'Group Admin', RoleLevel::GROUP_ADMIN), new RoleDto(2, 'Application Admin', RoleLevel::APPLICATION_ADMIN), new RoleDto(3, 'Resource Admin', RoleLevel::RESOURCE_ADMIN), new RoleDto(4, 'Schedule Admin', RoleLevel::SCHEDULE_ADMIN))); $this->page->BindAdminGroups($this->groupRepository->GetGroupsByRole(RoleLevel::GROUP_ADMIN)); }
public function testCanGetPageableListOfGroups() { $filter = new SqlFilterEquals("", ""); $pageNum = 10; $pageSize = 100; $count = 1000; $countRow = array(ColumnNames::TOTAL => $count); $itemRows = new GroupItemRow(); $itemRows->With(1, 'g1')->With(2, 'g2'); $rows = $itemRows->Rows(); $this->db->SetRow(0, array($countRow)); $this->db->SetRow(1, $rows); $baseCommand = new GetAllGroupsCommand(); $expected = new FilterCommand($baseCommand, $filter); $list = $this->repository->GetList($pageNum, $pageSize, null, null, $filter); $results = $list->Results(); $this->assertEquals(GroupItemView::Create($rows[0]), $results[0]); $this->assertEquals(GroupItemView::Create($rows[1]), $results[1]); $this->assertTrue($this->db->ContainsCommand($expected), "missing select group command"); $pageInfo = $list->PageInfo(); $this->assertEquals($count, $pageInfo->Total); $this->assertEquals($pageNum, $pageInfo->CurrentPage); }
public function GetList($pageNumber = null, $pageSize = null, $sortField = null, $sortDirection = null, $filter = null) { $user = $this->userRepository->LoadById($this->userSession->UserId); $groupIds = array(); $groups = $user->GetAdminGroups(); foreach ($groups as $group) { $groupIds[] = $group->GroupId; } $and = new SqlFilterIn(new SqlFilterColumn(TableNames::GROUPS_ALIAS, ColumnNames::GROUP_ID), $groupIds); if ($filter == null) { $filter = $and; } else { $filter->_And($and); } return parent::GetList($pageNumber, $pageSize, $sortField, $sortDirection, $filter); }
private function GetGroups($term) { $filter = new SqlFilterLike(new SqlFilterColumn(TableNames::GROUPS_ALIAS, ColumnNames::GROUP_NAME), $term); $r = new GroupRepository(); return $r->GetList(1, PageInfo::All, null, null, $filter)->Results(); }