public function listOrganisationAction() { $model = new Model_Wep(); $userModel = new Model_User(); $activity_model = new Model_ActivityCollection(); $orgs = $model->listOrganisation('account'); $org_data = array(); foreach ($orgs as $organisation) { $users = $userModel->getUserCountByAccountId($organisation['id']); $organisation['users_count'] = $users[0]['users_count']; $activities = $activity_model->getActivitiesCountByAccount($organisation['id']); $organisation['activity_count'] = $activities[0]['activity_count']; $user = $userModel->getUserByAccountId($organisation['id'], array('role_id' => 1)); $organisation['user_id'] = $user['user_id']; $organisation['email'] = $user['email']; $org_data[] = $organisation; } $this->view->rowSet = $org_data; }
/** * Ported from Admin Controller::listActivityStatesAction() * @param None * @return Array containing activity states and activity registry published count for all organisations. */ public function allOrganisationsActivityStates() { $model = new Model_Wep(); $activityCollModel = new Model_ActivityCollection(); // $activityModel = new Model_Activity(); $orgs = $model->listOrganisation('account'); $orgData = array(); foreach ($orgs as $organisation) { $activities = $activityCollModel->getActivitiesByAccount($organisation['id']); $states = $this->getCountByState($activities); $organisation['states'] = $states; $regPublishModel = new Model_RegistryPublishedData(); $publishedFiles = $regPublishModel->getPublishedInfoByOrg($organisation['id']); $publishedActivityCount = $regPublishModel->getActivityCount($publishedFiles); $organisation['registry_published_count'] = $publishedActivityCount; $orgData[] = $organisation; } return $orgData; }