public function changeGroupadminUsername($old_group_identifier, $group_identifier, $user_id) { $old_username = $old_group_identifier . '_group'; $data['user_name'] = $group_identifier . '_group'; parent::update($data, array('user_name = ?' => $old_username)); $userGroupModel = new User_Model_DbTable_UserGroup(); $userGroupModel->updateUsername($group_identifier, $user_id); }
public function listOrganisationAction() { $identity = Zend_Auth::getInstance()->getIdentity(); $userId = $identity->user_id; $userModel = new Model_User(); $groupModel = new User_Model_DbTable_Group(); $userGroupModel = new User_Model_DbTable_UserGroup(); $activityModel = new Model_ActivityCollection(); $group = $userGroupModel->getRowByUserId($userId); $orgs = $groupModel->getAllOrganisationsByGroupId($group['group_id']); $org_data = array(); foreach ($orgs as $organisation) { $users = $userModel->getUserCountByAccountId($organisation['account_id']); $organisation['users_count'] = $users[0]['users_count']; $activities = $activityModel->getActivitiesCountByAccount($organisation['account_id']); $organisation['activity_count'] = $activities[0]['activity_count']; $user = $userModel->getUserByAccountId($organisation['account_id'], array('role_id' => 1)); $organisation['user_id'] = $user['user_id']; $org_data[] = $organisation; } $this->view->groupRow = $group; $this->view->rowSet = $org_data; }
public function deleteGroupAction() { $groupId = $this->_getParam('group_id'); if (!isset($groupId)) { $this->_helper->FlashMessenger->addMessage(array('error' => "No Group Id Provided.")); $this->_redirect('/admin/group-organisations'); } $userModel = new Model_User(); $groupModel = new User_Model_DbTable_Group(); $userGroupModel = new User_Model_DbTable_UserGroup(); $row = $userGroupModel->getRowByGroupId($groupId); if (!$row) { $this->_helper->FlashMessenger->addMessage(array('message' => "Cannot Delete Group. Invalid Group Id.")); $this->_redirect('/admin/group-organisations'); } // Disable User $data['status'] = 0; $userModel->updateStatusByUser($row['user_id'], $data['status']); $groupModel->deleteGroup($groupId); $userGroupModel->deleteUserGroup($groupId); $this->_helper->FlashMessenger->addMessage(array('message' => "Group Deleted Successfully.")); $this->_redirect('/admin/group-organisations'); }