/** * Deletes all new user invitations corresponding to a community. * * @param CommunityDao $community * @throws Zend_Exception */ public function deleteByCommunity($community) { if (!$community instanceof CommunityDao) { throw new Zend_Exception('Must pass a community dao'); } Zend_Registry::get('dbAdapter')->delete($this->_name, 'community_id = ' . $community->getKey()); }
/** * Check whether the given policy is valid for the given community and user. * * @param CommunityDao $communityDao community DAO * @param null|UserDao $userDao user DAO * @param int $policy policy * @return bool true if the given policy is valid for the given community and user * @throws Zend_Exception */ public function policyCheck($communityDao, $userDao = null, $policy = MIDAS_POLICY_READ) { if (!$communityDao instanceof CommunityDao || !is_numeric($policy)) { throw new Zend_Exception('Error in param: communityDao should be a CommunityDao and policy should be numeric.'); } if ($userDao == null) { $userId = -1; } elseif (!$userDao instanceof UserDao) { throw new Zend_Exception('Should be an user.'); } else { $userId = $userDao->getUserId(); if ($userDao->isAdmin()) { return true; } } $privacy = $communityDao->getPrivacy(); switch ($policy) { case MIDAS_POLICY_READ: if ($privacy != MIDAS_COMMUNITY_PRIVATE) { return true; } elseif ($userId == -1) { return false; } else { $user_groups = $userDao->getGroups(); $member_group = $communityDao->getMemberGroup(); foreach ($user_groups as $group) { if ($group->getKey() == $member_group->getKey()) { return true; } } $invitations = $userDao->getInvitations(); foreach ($invitations as $invitation) { if ($invitation->getCommunityId() == $communityDao->getKey()) { return true; } } return false; } break; case MIDAS_POLICY_WRITE: if ($userId == -1) { return false; } else { $user_groups = $userDao->getGroups(); $moderator_group = $communityDao->getModeratorGroup(); $admin_group = $communityDao->getAdminGroup(); foreach ($user_groups as $group) { if ($group->getKey() == $moderator_group->getKey() || $group->getKey() == $admin_group->getKey()) { return true; } } return false; } break; case MIDAS_POLICY_ADMIN: if ($userId == -1) { return false; } else { $user_groups = $userDao->getGroups(); $admin_group = $communityDao->getAdminGroup(); foreach ($user_groups as $group) { if ($group->getKey() == $admin_group->getKey()) { return true; } } return false; } break; default: return false; } }
/** * Remove invitation. * * @param CommunityDao $communityDao * @param UserDao $userDao * @return bool * @throws Zend_Exception */ public function removeInvitation($communityDao, $userDao) { if ($userDao == null) { return false; } $invitations = $userDao->getInvitations(); foreach ($invitations as $invitation) { if ($invitation->getCommunityId() == $communityDao->getKey()) { /** @var FeedModel $feedModel */ $feedModel = MidasLoader::loadModel('Feed'); $feeds = $feedModel->getFeedByResourceAndType(array(MIDAS_FEED_COMMUNITY_INVITATION), $invitation); foreach ($feeds as $feed) { $feedModel->delete($feed); } $this->delete($invitation); return true; } } return false; }
/** * Get feeds. * * @param UserDao $loggedUserDao * @param null|UserDao $userDao * @param null|CommunityDao $communityDao * @param int $policy * @param int $limit * @return array * @throws Zend_Exception */ protected function getFeeds($loggedUserDao, $userDao = null, $communityDao = null, $policy = 0, $limit = 20) { $isAdmin = false; if ($loggedUserDao == null) { $userId = -1; } elseif (!$loggedUserDao instanceof UserDao) { throw new Zend_Exception('Should be an user.'); } else { $userId = $loggedUserDao->getUserId(); if ($loggedUserDao->isAdmin()) { $isAdmin = true; } } if ($userDao != null && !$userDao instanceof UserDao) { throw new Zend_Exception('Should be an user.'); } if ($communityDao != null && !$communityDao instanceof CommunityDao) { throw new Zend_Exception('Should be a community.'); } $sql = $this->database->select()->setIntegrityCheck(false)->from(array('f' => 'feed'))->limit($limit); if (!$isAdmin) { $sql->joinLeft(array('fpu' => 'feedpolicyuser'), ' f.feed_id = fpu.feed_id AND ' . $this->database->getDB()->quoteInto('fpu.policy >= ?', $policy) . ' AND ' . $this->database->getDB()->quoteInto('fpu.user_id = ? ', $userId) . ' ', array('userpolicy' => 'fpu.policy'))->joinLeft(array('fpg' => 'feedpolicygroup'), ' f.feed_id = fpg.feed_id AND ' . $this->database->getDB()->quoteInto('fpg.policy >= ?', $policy) . ' AND ( ' . $this->database->getDB()->quoteInto('fpg.group_id = ? ', MIDAS_GROUP_ANONYMOUS_KEY) . ' OR fpg.group_id IN (' . new Zend_Db_Expr($this->database->select()->setIntegrityCheck(false)->from(array('u2g' => 'user2group'), array('group_id'))->where('u2g.user_id = ?', $userId)) . '))', array('grouppolicy' => 'fpg.policy'))->where('( fpu.feed_id is not null or fpg.feed_id is not null)'); } if ($userDao != null) { $sql->where('f.user_id = ? ', $userDao->getKey()); } if ($communityDao != null) { $sql->join(array('f2c' => 'feed2community'), $this->database->getDB()->quoteInto('f2c.community_id = ? ', $communityDao->getKey()) . ' AND f.feed_id = f2c.feed_id', array()); } $sql->order(array('f.date DESC')); $rowset = $this->database->fetchAll($sql); $rowsetAnalysed = array(); foreach ($rowset as $row) { if (isset($row['userpolicy']) && $row['userpolicy'] == null) { $row['userpolicy'] = 0; } if (isset($row['grouppolicy']) && $row['grouppolicy'] == null) { $row['grouppolicy'] = 0; } if (!isset($rowsetAnalysed[$row['feed_id']]) || $rowsetAnalysed[$row['feed_id']]->policy < $row['userpolicy'] && $rowsetAnalysed[$row['feed_id']]->policy < $row['grouppolicy']) { $tmpDao = $this->initDao('Feed', $row); if (isset($row['userpolicy']) && isset($row['grouppolicy']) && $row['userpolicy'] >= $row['grouppolicy']) { $tmpDao->policy = $row['userpolicy']; } elseif ($isAdmin) { $tmpDao->policy = MIDAS_POLICY_ADMIN; } else { $tmpDao->policy = $row['grouppolicy']; } $rowsetAnalysed[$row['feed_id']] = $tmpDao; unset($tmpDao); } } $this->Component->Sortdao->field = 'date'; $this->Component->Sortdao->order = 'asc'; usort($rowsetAnalysed, array($this->Component->Sortdao, 'sortByDate')); return $rowsetAnalysed; }
/** * Create or find an item with the given name in the given community. * * @param string $itemName item name * @param CommunityDao $community community DAO * @return ItemDao item DAO * @throws Exception */ private function _createOrFindByName($itemName, $community) { /** @var ItemModel $itemModel */ $itemModel = MidasLoader::loadModel('Item'); $items = $itemModel->getByName($itemName); if (count($items) === 0) { $folders = $community->getFolder()->getFolders(); $privateFolder = null; /** @var FolderDao $folder */ foreach ($folders as $folder) { if ($folder->getName() === 'Private' && $folder->getPrivacyStatus() === MIDAS_PRIVACY_PRIVATE) { $privateFolder = $folder; break; } } if (is_null($privateFolder)) { throw new Exception('No private folder in the given community in which to create an item', -1); } return $itemModel->createItem($itemName, '', $privateFolder); } return $items[0]; }
/** * Get items shared to the given community. * * @param CommunityDao $communityDao * @param int $limit * @return array * @throws Zend_Exception */ public function getSharedToCommunity($communityDao, $limit = 20) { $groupId = $communityDao->getMemberGroup()->getKey(); if (!is_numeric($groupId)) { throw new Zend_Exception('Error in parameter groupId when getting items shared to community.'); } $sql = $this->database->select()->setIntegrityCheck(false)->from(array('i' => 'item'))->join(array('p' => 'itempolicygroup'), 'i.item_id = p.item_id', array('p.policy', 'policy_date' => 'p.date'))->where('group_id = ? ', $groupId)->order(array('p.date DESC'))->limit($limit); $rowset = $this->database->fetchAll($sql); $results = array(); foreach ($rowset as $row) { $tmp = $this->initDao('Item', $row); $tmp->policy = $row['policy']; $tmp->policy_date = $row['policy_date']; $results[] = $tmp; } return $results; }