/**
* Returns a user list which contains all users who likes it
*/
public function actionUserList()
{
$query = \humhub\modules\user\models\User::find();
$query->leftJoin('like', 'like.created_by=user.id');
$query->where(['like.object_id' => $this->contentId, 'like.object_model' => $this->contentModel]);
$query->orderBy('like.created_at DESC');
$title = Yii::t('LikeModule.controllers_LikeController', "<strong>Users</strong> who like this");
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
/**
* Returns an list of all friends of a user
*/
public function actionPopup()
{
$user = User::findOne(['id' => Yii::$app->request->get('userId')]);
if ($user === null) {
throw new \yii\web\HttpException(404, 'Could not find user!');
}
$query = Friendship::getFriendsQuery($user);
$title = '<strong>' . Yii::t('FriendshipModule.base', "Friends") . '</strong>';
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
public function actionUserList()
{
$calendarEntry = $this->getCalendarEntry(Yii::$app->request->get('id'));
if ($calendarEntry == null) {
throw new HttpException('404', Yii::t('CalendarModule.base', "Event not found!"));
}
$state = Yii::$app->request->get('state');
$query = User::find();
$query->leftJoin('calendar_entry_participant', 'user.id=calendar_entry_participant.user_id AND calendar_entry_participant.calendar_entry_id=:calendar_entry_id AND calendar_entry_participant.participation_state=:state', [':calendar_entry_id' => $calendarEntry->id, ':state' => $state]);
$query->where('calendar_entry_participant.id IS NOT NULL');
$title = "";
if ($state == CalendarEntryParticipant::PARTICIPATION_STATE_ACCEPTED) {
$title = Yii::t('CalendarModule.base', 'Attending users');
} elseif ($state == CalendarEntryParticipant::PARTICIPATION_STATE_DECLINED) {
$title = Yii::t('CalendarModule.base', 'Declining users');
} elseif ($state == CalendarEntryParticipant::PARTICIPATION_STATE_MAYBE) {
$title = Yii::t('CalendarModule.base', 'Maybe attending users');
}
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
/**
* Returns an user list which are space members
*/
public function actionMembersList()
{
$title = Yii::t('SpaceModule.controllers_MembershipController', "<strong>Members</strong>");
return $this->renderAjaxContent(UserListBox::widget(['query' => Membership::getSpaceMembersQuery($this->getSpace()), 'title' => $title]));
}
/**
* Returns an user list which are space members
*/
public function actionMembersList()
{
$query = User::find();
$query->join('LEFT JOIN', 'space_membership', 'space_membership.user_id=user.id');
$query->andWhere(['space_membership.status' => Membership::STATUS_MEMBER]);
$query->andWhere(['user.status' => User::STATUS_ENABLED]);
$query->andWhere(['space_id' => $this->getSpace()->id]);
$query->orderBy(['space_membership.group_id' => SORT_DESC]);
$title = Yii::t('SpaceModule.controllers_MembershipController', "<strong>Members</strong>");
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
public function actionFollowedUsersList()
{
$query = User::find();
$query->leftJoin('user_follow', 'user.id=user_follow.object_id and object_model=:userClass and user_follow.user_id=:userId', [':userClass' => User::className(), ':userId' => $this->getUser()->id]);
$query->orderBy(['user_follow.id' => SORT_DESC]);
$query->andWhere(['IS NOT', 'user_follow.id', new \yii\db\Expression('NULL')]);
$query->active();
$title = Yii::t('UserModule.widgets_views_userFollower', '<strong>Following</strong> user');
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
/**
* Returns a user list including the pagination which contains all results
* for an answer
*/
public function actionUserListResults()
{
$poll = $this->getPollByParameter();
$answerId = (int) Yii::$app->request->get('answerId', '');
$answer = PollAnswer::findOne(['id' => $answerId]);
if ($answer == null || $poll->id != $answer->poll_id) {
throw new HttpException(401, Yii::t('PollsModule.controllers_PollController', 'Invalid answer!'));
}
$query = User::find();
$query->leftJoin('poll_answer_user', 'poll_answer_user.created_by=user.id');
$query->andWhere('poll_answer_user.poll_id IS NOT NULL');
$query->andWhere('poll_answer_user.poll_answer_id = ' . $answerId);
$query->orderBy('poll_answer_user.created_at DESC');
$title = Yii::t('PollsModule.controllers_PollController', "Users voted for: <strong>{answer}</strong>", array('{answer}' => Html::encode($answer->answer)));
return $this->renderAjaxContent(UserListBox::widget(['query' => $query, 'title' => $title]));
}
