public function init()
{
parent::init();
// Get Content Container by Param
if ($this->contentContainer->wall_id != "") {
$this->activeQuery->andWhere("wall_entry.wall_id = " . $this->contentContainer->wall_id);
} else {
Yii::warning("No wall id for content container " . get_class($this->contentContainer) . " - " . $this->contentContainer->getPrimaryKey() . " set - stopped stream action!");
// Block further execution
$this->activeQuery->andWhere("1=2");
}
/**
* Limit to public posts when no member
*/
if (!$this->contentContainer->canAccessPrivateContent($this->user)) {
if (!Yii::$app->user->isGuest) {
$this->activeQuery->andWhere("content.visibility=" . Content::VISIBILITY_PUBLIC . " OR content.created_by = :userId", [':userId' => $this->user->id]);
} else {
$this->activeQuery->andWhere("content.visibility=" . Content::VISIBILITY_PUBLIC);
}
}
/**
* Handle sticked posts only in content containers
*/
if ($this->limit != 1) {
if ($this->from == '') {
$oldOrder = $this->activeQuery->orderBy;
$this->activeQuery->orderBy("");
$this->activeQuery->addOrderBy('content.sticked DESC');
$this->activeQuery->addOrderBy($oldOrder);
} else {
$this->activeQuery->andWhere("(content.sticked != 1 OR content.sticked is NULL)");
}
}
}
/**
* @inheritdoc
*/
public function init()
{
parent::init();
$friendshipEnabled = Yii::$app->getModule('friendship')->getIsEnabled();
if ($this->user == null) {
/**
* For guests collect all wall_ids of "guest" public spaces / user profiles.
* Generally show only public content
*/
$publicSpacesSql = (new \yii\db\Query())->select(["si.wall_id"])->from('space si')->where('si.visibility=' . \humhub\modules\space\models\Space::VISIBILITY_ALL);
$union = Yii::$app->db->getQueryBuilder()->build($publicSpacesSql)[0];
$publicProfilesSql = (new \yii\db\Query())->select("pi.wall_id")->from('user pi')->where('pi.status=1 AND pi.visibility = ' . \humhub\modules\user\models\User::VISIBILITY_ALL);
$union .= " UNION " . Yii::$app->db->getQueryBuilder()->build($publicProfilesSql)[0];
$this->activeQuery->andWhere('wall_entry.wall_id IN (' . $union . ')');
$this->activeQuery->andWhere(['content.visibility' => \humhub\modules\content\models\Content::VISIBILITY_PUBLIC]);
} else {
/**
* Collect all wall_ids we need to include into dashboard stream
*/
// User to user follows
$userFollow = (new \yii\db\Query())->select(["uf.wall_id"])->from('user_follow')->leftJoin('user uf', 'uf.id=user_follow.object_id AND user_follow.object_model=:userClass')->where('user_follow.user_id=' . $this->user->id . ' AND uf.wall_id IS NOT NULL');
$union = Yii::$app->db->getQueryBuilder()->build($userFollow)[0];
// User to space follows
$spaceFollow = (new \yii\db\Query())->select("sf.wall_id")->from('user_follow')->leftJoin('space sf', 'sf.id=user_follow.object_id AND user_follow.object_model=:spaceClass')->where('user_follow.user_id=' . $this->user->id . ' AND sf.wall_id IS NOT NULL');
$union .= " UNION " . Yii::$app->db->getQueryBuilder()->build($spaceFollow)[0];
// User to space memberships
$spaceMemberships = (new \yii\db\Query())->select("sm.wall_id")->from('space_membership')->leftJoin('space sm', 'sm.id=space_membership.space_id')->where('space_membership.user_id=' . $this->user->id . ' AND sm.wall_id IS NOT NULL AND space_membership.show_at_dashboard = 1');
$union .= " UNION " . Yii::$app->db->getQueryBuilder()->build($spaceMemberships)[0];
if ($friendshipEnabled) {
// User to user follows
$usersFriends = (new \yii\db\Query())->select(["ufr.wall_id"])->from('user ufr')->leftJoin('user_friendship recv', 'ufr.id=recv.friend_user_id AND recv.user_id=' . (int) $this->user->id)->leftJoin('user_friendship snd', 'ufr.id=snd.user_id AND snd.friend_user_id=' . (int) $this->user->id)->where('recv.id IS NOT NULL AND snd.id IS NOT NULL AND ufr.wall_id IS NOT NULL');
$union .= " UNION " . Yii::$app->db->getQueryBuilder()->build($usersFriends)[0];
}
// Glue together also with current users wall
$wallIdsSql = (new \yii\db\Query())->select('wall_id')->from('user uw')->where('uw.id=' . $this->user->id);
$union .= " UNION " . Yii::$app->db->getQueryBuilder()->build($wallIdsSql)[0];
// Manual Union (https://github.com/yiisoft/yii2/issues/7992)
// Double union query - to avoid MySQL performance problems
$this->activeQuery->andWhere('wall_entry.wall_id IN (select subselect.wall_id from (' . $union . ') subselect)', [':spaceClass' => \humhub\modules\space\models\Space::className(), ':userClass' => \humhub\modules\user\models\User::className()]);
/**
* Begin visibility checks regarding the content container
*/
$this->activeQuery->leftJoin('wall', 'wall_entry.wall_id=wall.id');
$this->activeQuery->leftJoin('space_membership', 'wall.object_id=space_membership.space_id AND space_membership.user_id=:userId AND space_membership.status=:status', ['userId' => $this->user->id, ':status' => \humhub\modules\space\models\Membership::STATUS_MEMBER]);
if ($friendshipEnabled) {
$this->activeQuery->leftJoin('user_friendship', 'wall.object_id=user_friendship.user_id AND user_friendship.friend_user_id=:userId', ['userId' => $this->user->id]);
}
$condition = ' (wall.object_model=:userModel AND content.visibility=0 AND content.created_by = :userId) OR ';
if ($friendshipEnabled) {
// In case of friendship we can also display private content
$condition .= ' (wall.object_model=:userModel AND content.visibility=0 AND user_friendship.id IS NOT NULL) OR ';
}
// In case of an space entry, we need to join the space membership to verify the user can see private space content
$condition .= ' (wall.object_model=:spaceModel AND content.visibility = 0 AND space_membership.status = ' . \humhub\modules\space\models\Membership::STATUS_MEMBER . ') OR ';
$condition .= ' (content.visibility = 1 OR content.visibility IS NULL) ';
$this->activeQuery->andWhere($condition, [':userId' => $this->user->id, ':spaceModel' => \humhub\modules\space\models\Space::className(), ':userModel' => \humhub\modules\user\models\User::className()]);
}
}
public function init()
{
parent::init();
$this->activeQuery->andWhere(['content.visibility' => \humhub\modules\content\models\Content::VISIBILITY_PUBLIC]);
$wallIdsQuery = (new \yii\db\Query())->select('wall_id')->from('user uw');
if (Yii::$app->user->isGuest) {
$wallIdsQuery->andWhere('visibility=' . User::VISIBILITY_ALL);
}
$wallIdsSql = Yii::$app->db->getQueryBuilder()->build($wallIdsQuery)[0];
$this->activeQuery->andWhere('wall_entry.wall_id IN (' . $wallIdsSql . ')');
}
public function testLimit()
{
$baseStreamAction = new Stream('stream', Yii::$app->controller);
$baseStreamAction->limit = 2;
$baseStreamAction->init();
$wallEntries = $baseStreamAction->getWallEntries();
$wallEntryIds = array_map(create_function('$entry', 'return $entry->id;'), $wallEntries);
$this->assertEquals(array_slice($this->postWallEntryIds, 0, 2), $wallEntryIds);
}
