public function up()
{
$spaces = Space::find()->all();
$users = User::find()->all();
$containers = array_merge($users == null ? [] : $users, $spaces == null ? [] : $spaces);
foreach ($containers as $container) {
$created_by = $container instanceof User ? $container->id : $container instanceof Space ? $container->created_by : 1;
$created_by = $created_by == null ? 1 : $created_by;
if ($container->isModuleEnabled('cfiles')) {
$this->insert('cfiles_folder', ['title' => Module::ROOT_TITLE, 'description' => Module::ROOT_DESCRIPTION, 'parent_folder_id' => 0, 'has_wall_entry' => false, 'type' => Folder::TYPE_FOLDER_ROOT]);
$root_id = Yii::$app->db->getLastInsertID();
$this->insert('content', ['guid' => \humhub\libs\UUID::v4(), 'object_model' => Folder::className(), 'object_id' => $root_id, 'visibility' => 0, 'sticked' => 0, 'archived' => 0, 'created_at' => new \yii\db\Expression('NOW()'), 'created_by' => $created_by, 'updated_at' => new \yii\db\Expression('NOW()'), 'updated_by' => $created_by, 'contentcontainer_id' => $container->contentcontainer_id]);
$this->insert('cfiles_folder', ['title' => Module::ALL_POSTED_FILES_TITLE, 'description' => Module::ALL_POSTED_FILES_DESCRIPTION, 'parent_folder_id' => $root_id, 'has_wall_entry' => false, 'type' => Folder::TYPE_FOLDER_POSTED]);
$allpostedfiles_id = Yii::$app->db->getLastInsertID();
$this->insert('content', ['guid' => \humhub\libs\UUID::v4(), 'object_model' => Folder::className(), 'object_id' => $allpostedfiles_id, 'visibility' => 0, 'sticked' => 0, 'archived' => 0, 'created_at' => new \yii\db\Expression('NOW()'), 'created_by' => $created_by, 'updated_at' => new \yii\db\Expression('NOW()'), 'updated_by' => $created_by, 'contentcontainer_id' => $container->contentcontainer_id]);
$posted_content_id = Yii::$app->db->getLastInsertID();
$filesQuery = File::find()->joinWith('baseFile')->contentContainer($container);
$foldersQuery = Folder::find()->contentContainer($container);
$filesQuery->andWhere(['cfiles_file.parent_folder_id' => 0]);
// user maintained folders
$foldersQuery->andWhere(['cfiles_folder.parent_folder_id' => 0]);
// do not return any folders here that are root or allpostedfiles
$foldersQuery->andWhere(['cfiles_folder.type' => null]);
$rootsubfiles = $filesQuery->all();
$rootsubfolders = $foldersQuery->all();
foreach ($rootsubfiles as $file) {
$this->update('cfiles_file', ['cfiles_file.parent_folder_id' => $root_id], ['id' => $file->id]);
}
foreach ($rootsubfolders as $folder) {
$this->update('cfiles_folder', ['parent_folder_id' => $root_id], ['id' => $folder->id]);
}
}
}
}
/**
* Callback to validate module database records.
*
* @param Event $event
*/
public static function onIntegrityCheck($event)
{
$integrityController = $event->sender;
$integrityController->showTestHeadline("Space Module - Spaces (" . Space::find()->count() . " entries)");
foreach (Space::find()->all() as $space) {
foreach ($space->applicants as $applicant) {
if ($applicant->user == null) {
if ($integrityController->showFix("Deleting applicant record id " . $applicant->id . " without existing user!")) {
$applicant->delete();
}
}
}
}
$integrityController->showTestHeadline("Space Module - Module (" . models\Module::find()->count() . " entries)");
foreach (models\Module::find()->joinWith('space')->all() as $module) {
if ($module->space == null) {
if ($integrityController->showFix("Deleting space module" . $module->id . " without existing space!")) {
$module->delete();
}
}
}
$integrityController->showTestHeadline("Space Module - Memberships (" . models\Membership::find()->count() . " entries)");
foreach (models\Membership::find()->joinWith('space')->all() as $membership) {
if ($membership->space == null) {
if ($integrityController->showFix("Deleting space membership" . $membership->space_id . " without existing space!")) {
$membership->delete();
}
}
if ($membership->user == null) {
if ($integrityController->showFix("Deleting space membership" . $membership->user_id . " without existing user!")) {
$membership->delete();
}
}
}
}
/**
* Executes the widgets
*/
public function run()
{
$statsCountSpaces = Space::find()->count();
$statsCountSpacesHidden = Space::find()->where(['visibility' => Space::VISIBILITY_NONE])->count();
$statsSpaceMostMembers = Space::find()->where('id = (SELECT space_id FROM space_membership GROUP BY space_id ORDER BY count(*) DESC LIMIT 1)')->one();
// Render widgets view
return $this->render('spaceStats', array('statsSpaceMostMembers' => $statsSpaceMostMembers, 'statsCountSpaces' => $statsCountSpaces, 'statsCountSpacesHidden' => $statsCountSpacesHidden));
}
/**
* Executes the widgets
*/
public function run()
{
$query = Space::find();
/**
* Show private spaces only if user is member
*/
$query->leftJoin('space_membership', 'space.id=space_membership.space_id AND space_membership.user_id=:userId', [':userId' => \Yii::$app->user->id]);
$query->andWhere(['!=', 'space.visibility', Space::VISIBILITY_NONE]);
$query->orWhere(['space_membership.status' => Membership::STATUS_MEMBER]);
$query->limit(10);
$query->orderBy('created_at DESC');
return $this->render('newSpaces', array('newSpaces' => $query->all(), 'showMoreButton' => $this->showMoreButton));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Space::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 50]]);
$dataProvider->setSort(['attributes' => ['id', 'name', 'visibility', 'join_policy']]);
$this->load($params);
if (!$this->validate()) {
$query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['join_policy' => $this->join_policy]);
$query->andFilterWhere(['visibility' => $this->visibility]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* @inheritdoc
*/
public function parseRequest($manager, $request)
{
$pathInfo = $request->getPathInfo();
if (substr($pathInfo, 0, 2) == "s/") {
$parts = explode('/', $pathInfo, 3);
if (isset($parts[1])) {
$space = Space::find()->where(['guid' => $parts[1]])->orWhere(['url' => $parts[1]])->one();
if ($space !== null) {
if (!isset($parts[2]) || $parts[2] == "") {
$parts[2] = $this->defaultRoute;
}
$params = $request->get();
$params['sguid'] = $space->guid;
return [$parts[2], $params];
}
}
}
return false;
}
/**
* Invite user
*/
public function actionInvite($space = null)
{
$space = $space == null ? Space::find()->where(['id' => Yii::$app->request->get('spaceId', "")])->one() : $space;
$model = new \humhub\modules\space\models\forms\InviteForm();
$model->space = $space;
$canInviteExternal = Yii::$app->getModule('user')->settings->get('auth.internalUsersCanInvite');
if ($model->load(Yii::$app->request->post()) && $model->validate()) {
// Invite existing members
foreach ($model->getInvites() as $user) {
$space->inviteMember($user->id, Yii::$app->user->id);
}
// Invite non existing members
if ($canInviteExternal) {
foreach ($model->getInvitesExternal() as $email) {
$space->inviteMemberByEMail($email, Yii::$app->user->id);
}
}
return $this->htmlRedirect($space->getUrl());
}
return $this->renderAjax('invite', ['canInviteExternal' => $canInviteExternal, 'model' => $model, 'space' => $space]);
}
/**
* Create installer sample data
*
* @param \yii\base\Event $event
*/
public static function onSampleDataInstall($event)
{
$space = Space::find()->where(['id' => 1])->one();
// activate module at space
if (!$space->isModuleEnabled("polls")) {
$space->enableModule("polls");
}
// Switch Identity
$user = User::find()->where(['id' => 1])->one();
Yii::$app->user->switchIdentity($user);
$poll = new Poll();
$poll->question = Yii::t('PollsModule.events', "Right now, we are in the planning stages for our next meetup and we would like to know from you, where you would like to go?");
$poll->answersText = Yii::t('PollsModule.events', "To Daniel\nClub A Steakhouse\nPisillo Italian Panini\n");
$poll->content->container = $space;
$poll->allow_multiple = Yii::$app->request->post('allowMultiple', 0);
$poll->save();
// load users
$user2 = User::find()->where(['id' => 2])->one();
$user3 = User::find()->where(['id' => 3])->one();
// Switch Identity
Yii::$app->user->switchIdentity($user2);
// vote
$poll->vote([2]);
$comment = new \humhub\modules\comment\models\Comment();
$comment->message = Yii::t('PollsModule.events', "Why don't we go to Bemelmans Bar?");
$comment->object_model = $poll->className();
$comment->object_id = $poll->getPrimaryKey();
$comment->save();
// Switch Identity
Yii::$app->user->switchIdentity($user3);
// vote
$poll->vote([3]);
$comment = new \humhub\modules\comment\models\Comment();
$comment->message = Yii::t('PollsModule.events', "Again? ;Weary;");
$comment->object_model = $poll->className();
$comment->object_id = $poll->getPrimaryKey();
$comment->save();
// Switch Identity
Yii::$app->user->switchIdentity($user);
}
/**
* Generate a unique space url
*
* @param string $name
* @return string a unique space url
*/
public static function autogenerateUniqueSpaceUrl($name)
{
$maxUrlLength = 45;
$url = URLify::filter($name, $maxUrlLength - 4);
// Get a list of all similar space urls
$existingSpaceUrls = [];
foreach (Space::find()->where(['LIKE', 'url', $url . '%', false])->all() as $space) {
$existingSpaceUrls[] = $space->url;
}
// Url is free
if (!in_array($url, $existingSpaceUrls)) {
return $url;
}
// Add number to taken url
for ($i = 0; $i <= count($existingSpaceUrls); $i++) {
$tryUrl = $url . ($i + 2);
if (!in_array($tryUrl, $existingSpaceUrls)) {
return $tryUrl;
}
}
// Shouldn't never happen - failed
return "";
}
protected function buildQuery($keyword, $options)
{
// Allow *Token*
\ZendSearch\Lucene\Search\Query\Wildcard::setMinPrefixLength(0);
$query = new \ZendSearch\Lucene\Search\Query\Boolean();
foreach (explode(" ", $keyword) as $k) {
// Require at least 3 non-wildcard characters
if (strlen($k) > 2) {
$term = new \ZendSearch\Lucene\Index\Term("*" . $k . "*");
$query->addSubquery(new \ZendSearch\Lucene\Search\Query\Wildcard($term), true);
}
}
// Add model filter
if (isset($options['model']) && $options['model'] != "") {
if (is_array($options['model'])) {
$boolQuery = new \ZendSearch\Lucene\Search\Query\MultiTerm();
foreach ($options['model'] as $model) {
$boolQuery->addTerm(new \ZendSearch\Lucene\Index\Term($model, 'model'));
}
$query->addSubquery($boolQuery, true);
} else {
$term = new \ZendSearch\Lucene\Index\Term($options['model'], 'model');
$query->addSubquery(new \ZendSearch\Lucene\Search\Query\Term($term), true);
}
}
// Add type filter
if (isset($options['type']) && $options['type'] != "") {
if (is_array($options['type'])) {
$boolQuery = new \ZendSearch\Lucene\Search\Query\MultiTerm();
foreach ($options['type'] as $model) {
$boolQuery->addTerm(new \ZendSearch\Lucene\Index\Term($type), 'type');
}
$query->addSubquery($boolQuery, true);
} else {
$term = new \ZendSearch\Lucene\Index\Term($options['type'], 'type');
$query->addSubquery(new \ZendSearch\Lucene\Search\Query\Term($term), true);
}
}
// Add custom filters
if (isset($options['filters']) && is_array($options['filters'])) {
foreach ($options['filters'] as $field => $value) {
$term = new \ZendSearch\Lucene\Index\Term($value, $field);
$query->addSubquery(new \ZendSearch\Lucene\Search\Query\Term($term), true);
}
}
if ($options['checkPermissions'] && !Yii::$app->request->isConsoleRequest) {
$permissionQuery = new \ZendSearch\Lucene\Search\Query\Boolean();
if (Yii::$app->user->isGuest) {
// Guest Content
$guestContentQuery = new \ZendSearch\Lucene\Search\Query\Boolean();
$guestContentQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_VISIBILITY_PUBLIC, 'visibility')), true);
$guestContentQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_TYPE_CONTENT, 'type')), true);
$guestContentQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(Space::className(), 'containerModel')), true);
$guestSpaceListQuery = new \ZendSearch\Lucene\Search\Query\MultiTerm();
foreach (Space::find()->where(['visibility' => Space::VISIBILITY_ALL])->all() as $space) {
$guestSpaceListQuery->addTerm(new \ZendSearch\Lucene\Index\Term($space->id, 'containerPk'));
}
$guestContentQuery->addSubquery($guestSpaceListQuery, true);
$permissionQuery->addSubquery($guestContentQuery);
// Guest Spaces
$guestSpacesQuery = new \ZendSearch\Lucene\Search\Query\Boolean();
$guestSpacesQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_TYPE_SPACE, 'type')), true);
$guestSpacesQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_VISIBILITY_PUBLIC, 'visibility')), true);
$permissionQuery->addSubquery($guestSpacesQuery);
$permissionQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_TYPE_USER, 'type')));
} else {
//--- Public Content
$permissionQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_VISIBILITY_PUBLIC, 'visibility')));
//--- Private Space Content
$privateSpaceContentQuery = new \ZendSearch\Lucene\Search\Query\Boolean();
$privateSpaceContentQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(self::DOCUMENT_VISIBILITY_PRIVATE, 'visibility')), true);
$privateSpaceContentQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(Space::className(), 'containerModel')), true);
$privateSpacesListQuery = new \ZendSearch\Lucene\Search\Query\MultiTerm();
foreach (\humhub\modules\space\models\Membership::GetUserSpaces() as $space) {
$privateSpacesListQuery->addTerm(new \ZendSearch\Lucene\Index\Term($space->id, 'containerPk'));
}
$privateSpaceContentQuery->addSubquery($privateSpacesListQuery, true);
$permissionQuery->addSubquery($privateSpaceContentQuery);
}
$query->addSubquery($permissionQuery, true);
}
if (count($options['limitSpaces']) > 0) {
$spaceBaseQuery = new \ZendSearch\Lucene\Search\Query\Boolean();
$spaceBaseQuery->addSubquery(new \ZendSearch\Lucene\Search\Query\Term(new \ZendSearch\Lucene\Index\Term(Space::className(), 'containerModel')), true);
$spaceIdQuery = new \ZendSearch\Lucene\Search\Query\MultiTerm();
foreach ($options['limitSpaces'] as $space) {
$spaceIdQuery->addTerm(new \ZendSearch\Lucene\Index\Term($space->id, 'containerPk'));
}
$spaceBaseQuery->addSubquery($spaceIdQuery, true);
$query->addSubquery($spaceBaseQuery, true);
}
return $query;
}
/**
* Cancel Space creation
*/
public function actionCancel()
{
$space = Space::find()->where(['id' => Yii::$app->request->get('spaceId', "")])->one();
$space->delete();
}
/**
* Updates or creates user by given ldap node
*
* @param Zend_Ldap_Node $node
* @return User User Object
*/
public function handleLdapUser($node)
{
$usernameAttribute = Setting::Get('usernameAttribute', 'authentication_ldap');
if ($usernameAttribute == '') {
$usernameAttribute = 'sAMAccountName';
}
$emailAttribute = Setting::Get('emailAttribute', 'authentication_ldap');
if ($emailAttribute == '') {
$emailAttribute = 'mail';
}
$username = $node->getAttribute($usernameAttribute, 0);
$email = $node->getAttribute($emailAttribute, 0);
$guid = $this->binToStrGuid($node->getAttribute('objectGUID', 0));
// Try to load User:
$userChanged = false;
$user = null;
if ($guid != "") {
$user = User::findOne(array('guid' => $guid, 'auth_mode' => User::AUTH_MODE_LDAP));
} else {
// Fallback use e-mail
$user = User::findOne(array('email' => $email, 'auth_mode' => User::AUTH_MODE_LDAP));
}
if ($user === null) {
$user = new User();
if ($guid != "") {
$user->guid = $guid;
}
$user->status = User::STATUS_ENABLED;
$user->auth_mode = User::AUTH_MODE_LDAP;
$user->group_id = 1;
Yii::info('Create ldap user ' . $username . '!');
}
// Update Group Mapping
foreach (Group::find()->andWhere(['!=', 'ldap_dn', ""])->all() as $group) {
if (in_array($group->ldap_dn, $node->getAttribute('memberOf'))) {
if ($user->group_id != $group->id) {
$userChanged = true;
$user->group_id = $group->id;
}
}
}
// Update Users Field
if ($user->username != $username) {
$userChanged = true;
$user->username = $username;
}
if ($user->email != $email) {
$userChanged = true;
$user->email = $email;
}
if ($user->validate()) {
// Only Save user when something is changed
if ($userChanged || $user->isNewRecord) {
$user->save();
}
// Update Profile Fields
foreach (ProfileField::find()->andWhere(['!=', 'ldap_attribute', ''])->all() as $profileField) {
$ldapAttribute = $profileField->ldap_attribute;
$profileFieldName = $profileField->internal_name;
$user->profile->{$profileFieldName} = $node->getAttribute($ldapAttribute, 0);
}
if ($user->profile->validate()) {
$user->profile->save();
// Update Space Mapping
foreach (Space::find()->andWhere(['!=', 'ldap_dn', ''])->all() as $space) {
if (in_array($space->ldap_dn, $node->getAttribute('memberOf')) || strpos($node->getDn(), $space->ldap_dn) !== false) {
$space->addMember($user->id);
}
}
} else {
Yii::error('Could not create or update ldap user profile! (' . print_r($user->profile->getErrors(), true) . ")");
}
} else {
Yii::error('Could not create or update ldap user! (' . print_r($user->getErrors(), true) . ")");
}
return $user;
}
/**
* Sample Data
*/
public function actionSampleData()
{
if (Yii::$app->getModule('installer')->settings->get('sampleData') == 1) {
// Sample Data already created
return $this->redirect(Yii::$app->getModule('installer')->getNextConfigStepUrl());
}
$form = new \humhub\modules\installer\forms\SampleDataForm();
$form->sampleData = 1;
if ($form->load(Yii::$app->request->post()) && $form->validate()) {
Yii::$app->getModule('installer')->settings->set('sampleData', $form->sampleData);
if (Yii::$app->getModule('installer')->settings->get('sampleData') == 1) {
// Add sample image to admin
$admin = User::find()->where(['id' => 1])->one();
$adminImage = new \humhub\libs\ProfileImage($admin->guid);
$adminImage->setNew(Yii::getAlias("@webroot/resources/installer/user_male_1.jpg"));
// Create second user
$userModel = new User();
$userModel->scenario = 'registration';
$profileModel = $userModel->profile;
$profileModel->scenario = 'registration';
$userModel->status = User::STATUS_ENABLED;
$userModel->username = "******";
$userModel->email = "*****@*****.**";
$userModel->language = '';
$userModel->tags = "Microsoft Office, Marketing, SEM, Digital Native";
$userModel->last_activity_email = new \yii\db\Expression('NOW()');
$userModel->save();
$profileImage = new \humhub\libs\ProfileImage($userModel->guid);
$profileImage->setNew(Yii::getAlias("@webroot/resources/installer/user_male_2.jpg"));
$profileModel->user_id = $userModel->id;
$profileModel->firstname = "David";
$profileModel->lastname = "Roberts";
$profileModel->title = "Late riser";
$profileModel->street = "2443 Queens Lane";
$profileModel->zip = "24574";
$profileModel->city = "Allwood";
$profileModel->country = "Virginia";
$profileModel->save();
// Create third user
$userModel2 = new User();
$userModel2->scenario = 'registration';
$profileModel2 = $userModel2->profile;
$profileModel2->scenario = 'registration';
$userModel2->status = User::STATUS_ENABLED;
$userModel2->username = "******";
$userModel2->email = "*****@*****.**";
$userModel2->language = '';
$userModel2->tags = "Yoga, Travel, English, German, French";
$userModel2->last_activity_email = new \yii\db\Expression('NOW()');
$userModel2->save();
$profileImage2 = new \humhub\libs\ProfileImage($userModel2->guid);
$profileImage2->setNew(Yii::getAlias("@webroot/resources/installer/user_female_1.jpg"));
$profileModel2->user_id = $userModel2->id;
$profileModel2->firstname = "Sara";
$profileModel2->lastname = "Schuster";
$profileModel2->title = "Do-gooder";
$profileModel2->street = "Schmarjestrasse 51";
$profileModel2->zip = "17095";
$profileModel2->city = "Friedland";
$profileModel2->country = "Niedersachsen";
$profileModel2->save();
// Switch Identity
$user = User::find()->where(['id' => 1])->one();
Yii::$app->user->switchIdentity($user);
$space = Space::find()->where(['id' => 1])->one();
// Create a sample post
$post = new \humhub\modules\post\models\Post();
$post->message = Yii::t("InstallerModule.controllers_ConfigController", "We're looking for great slogans of famous brands. Maybe you can come up with some samples?");
$post->content->container = $space;
$post->content->visibility = \humhub\modules\content\models\Content::VISIBILITY_PRIVATE;
$post->save();
// Switch Identity
Yii::$app->user->switchIdentity($userModel);
$comment = new \humhub\modules\comment\models\Comment();
$comment->message = Yii::t("InstallerModule.controllers_ConfigController", "Nike – Just buy it. ;Wink;");
$comment->object_model = $post->className();
$comment->object_id = $post->getPrimaryKey();
$comment->save();
// Switch Identity
Yii::$app->user->switchIdentity($userModel2);
$comment2 = new \humhub\modules\comment\models\Comment();
$comment2->message = Yii::t("InstallerModule.controllers_ConfigController", "Calvin Klein – Between love and madness lies obsession.");
$comment2->object_model = $post->className();
$comment2->object_id = $post->getPrimaryKey();
$comment2->save();
// Create Like Object
$like = new \humhub\modules\like\models\Like();
$like->object_model = $comment->className();
$like->object_id = $comment->getPrimaryKey();
$like->save();
$like = new \humhub\modules\like\models\Like();
$like->object_model = $post->className();
$like->object_id = $post->getPrimaryKey();
$like->save();
// trigger install sample data event
$this->trigger(self::EVENT_INSTALL_SAMPLE_DATA);
}
return $this->redirect(Yii::$app->getModule('installer')->getNextConfigStepUrl());
}
return $this->render('sample-data', array('model' => $form));
}
/**
* Returns Space for user space membership
*
* @since 1.0
* @param \humhub\modules\user\models\User $user
* @param boolean $memberOnly include only member status - no pending/invite states
* @return \yii\db\ActiveQuery for space model
*/
public static function getUserSpaceQuery($user, $memberOnly = true)
{
$query = Space::find();
$query->leftJoin('space_membership', 'space_membership.space_id=space.id and space_membership.user_id=:userId', [':userId' => $user->id]);
if ($memberOnly) {
$query->andWhere(['space_membership.status' => self::STATUS_MEMBER]);
}
$query->orderBy(['name' => SORT_ASC]);
return $query;
}
