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();
}
