/**
* 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;
}
}
/**
* Return a list of communities corresponding to the search.
*
* @param string $search
* @param UserDao $userDao
* @param int $limit
* @param bool $group
* @param string $order
* @return array
* @throws Zend_Exception
*/
public function getCommunitiesFromSearch($search, $userDao, $limit = 14, $group = true, $order = 'view')
{
if (Zend_Registry::get('configDatabase')->database->adapter == 'PDO_PGSQL') {
$group = false;
// PostgreSQL does not like the SQL request with group by
}
$communities = array();
if ($userDao == null) {
$userId = -1;
} elseif (!$userDao instanceof UserDao) {
throw new Zend_Exception('Should be an user.');
} else {
$userId = $userDao->getUserId();
$userGroups = $userDao->getGroups();
foreach ($userGroups as $userGroup) {
$communities[] = $userGroup->getCommunityId();
}
}
$sql = $this->database->select();
if ($group) {
$sql->from(array('c' => 'community'), array('community_id', 'name', 'count(*)'));
} else {
$sql->from(array('c' => 'community'));
}
if ($userId != -1 && $userDao->isAdmin()) {
$sql->where('c.name LIKE ?', '%' . $search . '%');
} elseif (!empty($communities)) {
$sql->where('c.name LIKE ?', '%' . $search . '%');
$sql->where('(c.privacy < ' . MIDAS_COMMUNITY_PRIVATE . ' OR ' . $this->database->getDB()->quoteInto('c.community_id IN (?)', $communities) . ')');
} else {
$sql->where('c.name LIKE ?', '%' . $search . '%');
$sql->where('(c.privacy < ' . MIDAS_COMMUNITY_PRIVATE . ')');
}
$sql->limit($limit);
if ($group) {
$sql->group('c.name');
}
switch ($order) {
case 'name':
$sql->order(array('c.name ASC'));
break;
case 'date':
$sql->order(array('c.creation ASC'));
break;
case 'view':
default:
$sql->order(array('c.view DESC'));
break;
}
$rowset = $this->database->fetchAll($sql);
$return = array();
foreach ($rowset as $row) {
$tmpDao = $this->initDao('Community', $row);
if (isset($row['count(*)'])) {
$tmpDao->count = $row['count(*)'];
}
$return[] = $tmpDao;
unset($tmpDao);
}
return $return;
}
